upgrade.sql 532 Bytes
Newer Older
1
2
3
4
5
6
7
-- 2021-03-12
ALTER TABLE gms_group ADD COLUMN creation_time timestamp DEFAULT NOW();
ALTER TABLE gms_group ADD COLUMN created_by varchar;
ALTER TABLE gms_membership ADD COLUMN creation_time timestamp DEFAULT NOW();
ALTER TABLE gms_membership ADD COLUMN created_by varchar;
ALTER TABLE gms_permission ADD COLUMN update_time timestamp DEFAULT NOW();
ALTER TABLE gms_permission ADD COLUMN set_by varchar;
Sonia Zorba's avatar
Sonia Zorba committed
8
9
10
11

--- 2021-03-19
ALTER TABLE audit_log ADD COLUMN action_type varchar;
ALTER TABLE audit_log RENAME COLUMN action TO description;