path: root/sql/Pg-upgrade-2.3.7-2.3.8.sql

--
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';