X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=sql-ledger%2Fsql%2FPg-upgrade-2.3.7-2.3.8.sql;fp=sql-ledger%2Fsql%2FPg-upgrade-2.3.7-2.3.8.sql;h=0000000000000000000000000000000000000000;hp=56979bee2e2ee858f504b38153451d78c1737f3b;hb=86b1b489a4ed2f9bc0cba6cafeab0d6eca5584dc;hpb=948b8acdd4b9b3864342062d0c397a11f57c5700 diff --git a/sql-ledger/sql/Pg-upgrade-2.3.7-2.3.8.sql b/sql-ledger/sql/Pg-upgrade-2.3.7-2.3.8.sql deleted file mode 100644 index 56979bee2..000000000 --- a/sql-ledger/sql/Pg-upgrade-2.3.7-2.3.8.sql +++ /dev/null @@ -1,16 +0,0 @@ --- -create table audittrail ( - trans_id int, - tablename text, - reference text, - formname text, - action text, - transdate timestamp default current_timestamp, - employee_id int -); -create index audittrail_trans_id_key on audittrail (trans_id); --- -alter table defaults add audittrail bool; -alter table defaults alter audittrail set default '0'; --- -update defaults set version = '2.3.8', audittrail = '0';