diff options
author | linuxpoet <linuxpoet@4979c152-3d1c-0410-bac9-87ea11338e46> | 2006-09-09 17:20:12 +0000 |
---|---|---|
committer | linuxpoet <linuxpoet@4979c152-3d1c-0410-bac9-87ea11338e46> | 2006-09-09 17:20:12 +0000 |
commit | ea383fecc03ff242fe7e0b6b64e2ace82aa8f5d8 (patch) | |
tree | 276730ab4803f3f9b6bc6695f42d74898b1a78e9 /sql/Oracle-upgrade-1.8.0-1.8.4.sql | |
parent | 6599a872c186b3be1b4e9c14200bf623f9f2c4a3 (diff) |
Remove all non Pg Ports, they were unsupported and LedgerSMB is a Pg only project now.
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@47 4979c152-3d1c-0410-bac9-87ea11338e46
Diffstat (limited to 'sql/Oracle-upgrade-1.8.0-1.8.4.sql')
-rwxr-xr-x | sql/Oracle-upgrade-1.8.0-1.8.4.sql | 28 |
1 files changed, 0 insertions, 28 deletions
diff --git a/sql/Oracle-upgrade-1.8.0-1.8.4.sql b/sql/Oracle-upgrade-1.8.0-1.8.4.sql deleted file mode 100755 index a3293a64..00000000 --- a/sql/Oracle-upgrade-1.8.0-1.8.4.sql +++ /dev/null @@ -1,28 +0,0 @@ --- -ALTER TABLE chart ADD gifi_accno VARCHAR2(20); --- -CREATE TABLE gifi ( - accno VARCHAR2(20), - description VARCHAR2(100) -); --- -CREATE UNIQUE INDEX chart_accno_key ON chart (accno); --- -CREATE TABLE mtemp ( - parts_id INTEGER, - name VARCHAR2(100) -); -INSERT INTO mtemp SELECT parts_id, name FROM makemodel; -DROP TABLE makemodel; -ALTER TABLE mtemp RENAME TO makemodel; --- -ALTER TABLE defaults ADD closedto DATE; -ALTER TABLE defaults ADD revtrans CHAR(1); --- -ALTER TABLE ap ADD notes VARCHAR2(4000); --- -ALTER TABLE customer ADD businessnumber VARCHAR2(40); -ALTER TABLE vendor ADD businessnumber VARCHAR2(40); --- -UPDATE defaults SET version = '1.8.4', revtrans = '0'; --- |