X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=sql-ledger%2Fsql%2FPg-upgrade-1.8.0-1.8.4.sql;fp=sql-ledger%2Fsql%2FPg-upgrade-1.8.0-1.8.4.sql;h=0000000000000000000000000000000000000000;hp=57b24f1f35df649e874814b693810032f1727cd1;hb=86b1b489a4ed2f9bc0cba6cafeab0d6eca5584dc;hpb=948b8acdd4b9b3864342062d0c397a11f57c5700 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'; ---