diff options
Diffstat (limited to 'upgrades/dbpatches/1.3/postgresql/patch/auditlog.sql')
-rw-r--r-- | upgrades/dbpatches/1.3/postgresql/patch/auditlog.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/upgrades/dbpatches/1.3/postgresql/patch/auditlog.sql b/upgrades/dbpatches/1.3/postgresql/patch/auditlog.sql new file mode 100644 index 00000000..6db8afbf --- /dev/null +++ b/upgrades/dbpatches/1.3/postgresql/patch/auditlog.sql @@ -0,0 +1,15 @@ +CREATE TABLE auditlog_tmp ( + auditid bigint unsigned DEFAULT '0' NOT NULL, + userid bigint unsigned DEFAULT '0' NOT NULL, + clock integer DEFAULT '0' NOT NULL, + action integer DEFAULT '0' NOT NULL, + resourcetype integer DEFAULT '0' NOT NULL, + details varchar(128) DEFAULT '0' NOT NULL, + PRIMARY KEY (auditid) +) ENGINE=InnoDB; +CREATE INDEX auditlog_1 on auditlog_tmp (userid,clock); +CREATE INDEX auditlog_2 on auditlog_tmp (clock); + +insert into auditlog_tmp select * from auditlog; +drop table auditlog; +alter table auditlog_tmp rename auditlog; |