blob: 7846291f67a543f52f578177e032be54d950e18c (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
CREATE TABLE acknowledges_tmp (
acknowledgeid bigint DEFAULT '0' NOT NULL,
userid bigint DEFAULT '0' NOT NULL,
eventid bigint DEFAULT '0' NOT NULL,
clock integer DEFAULT '0' NOT NULL,
message varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (acknowledgeid)
);
CREATE INDEX acknowledges_1 on acknowledges_tmp (userid);
CREATE INDEX acknowledges_2 on acknowledges_tmp (eventid);
CREATE INDEX acknowledges_3 on acknowledges_tmp (clock);
insert into acknowledges_tmp select * from acknowledges;
drop table acknowledges;
alter table acknowledges_tmp rename to acknowledges;
|
