summaryrefslogtreecommitdiff
path: root/sql-ledger/sql/Pg-upgrade-1.8.0-1.8.4.sql
diff options
context:
space:
mode:
authorivan <ivan>2007-12-04 21:30:08 +0000
committerivan <ivan>2007-12-04 21:30:08 +0000
commit9d36437025f070a586ece174a4dba48f6de94fa9 (patch)
treeb970ca9a38a23f85023990949395ad63f5074e4d /sql-ledger/sql/Pg-upgrade-1.8.0-1.8.4.sql
parent6dca1774038ec543b206ed4f5340d9e83e7026d0 (diff)
there's no reason this should still be hanging aroudn the tree
Diffstat (limited to 'sql-ledger/sql/Pg-upgrade-1.8.0-1.8.4.sql')
-rw-r--r--sql-ledger/sql/Pg-upgrade-1.8.0-1.8.4.sql21
1 files changed, 0 insertions, 21 deletions
diff --git a/sql-ledger/sql/Pg-upgrade-1.8.0-1.8.4.sql b/sql-ledger/sql/Pg-upgrade-1.8.0-1.8.4.sql
deleted file mode 100644
index 57b24f1f3..000000000
--- a/sql-ledger/sql/Pg-upgrade-1.8.0-1.8.4.sql
+++ /dev/null
@@ -1,21 +0,0 @@
---
-alter table chart add column gifi_accno text;
---
-create table gifi (accno text, description text);
-create unique index gifi_accno_key on gifi (accno);
---
-create table mtemp (parts_id int, name text);
-insert into mtemp select parts_id, name from makemodel;
-drop table makemodel;
-alter table mtemp rename to makemodel;
---
-alter table defaults add column closedto date;
-alter table defaults add column revtrans bool;
---
-alter table ap add column notes text;
---
-alter table customer add column businessnumber text;
-alter table vendor add column businessnumber text;
---
-update defaults set version = '1.8.4', revtrans = 'f';
---