blob: 56979bee2e2ee858f504b38153451d78c1737f3b (
plain)
- --
- 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';
|
