summaryrefslogtreecommitdiff
path: root/sql/legacy/Pg-upgrade-2.3.7-2.3.8.sql
blob: 56979bee2e2ee858f504b38153451d78c1737f3b (plain)
  1. --
  2. create table audittrail (
  3. trans_id int,
  4. tablename text,
  5. reference text,
  6. formname text,
  7. action text,
  8. transdate timestamp default current_timestamp,
  9. employee_id int
  10. );
  11. create index audittrail_trans_id_key on audittrail (trans_id);
  12. --
  13. alter table defaults add audittrail bool;
  14. alter table defaults alter audittrail set default '0';
  15. --
  16. update defaults set version = '2.3.8', audittrail = '0';