blob: 561bec1d55684895c208dec7874355dd6d52518b (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
CREATE TABLE auditlog_tmp (
auditid bigint DEFAULT '0' NOT NULL,
userid bigint 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)
) with OIDS;
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 to auditlog;
|
