diff options
Diffstat (limited to 'sql-ledger/sql/Pg-upgrade-2.3.7-2.3.8.sql')
-rw-r--r-- | sql-ledger/sql/Pg-upgrade-2.3.7-2.3.8.sql | 16 |
1 files changed, 0 insertions, 16 deletions
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'; |