blob: 56979bee2e2ee858f504b38153451d78c1737f3b (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
--
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';
|
