blob: 7581dd2cf3b3d1769000928242e9c76b01b2fd03 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
CREATE TABLE actions_tmp (
actionid bigint unsigned DEFAULT '0' NOT NULL,
userid bigint unsigned DEFAULT '0' NOT NULL,
subject varchar(255) DEFAULT '' NOT NULL,
message blob DEFAULT '' NOT NULL,
recipient integer DEFAULT '0' NOT NULL,
maxrepeats integer DEFAULT '0' NOT NULL,
repeatdelay integer DEFAULT '600' NOT NULL,
source integer DEFAULT '0' NOT NULL,
actiontype integer DEFAULT '0' NOT NULL,
status integer DEFAULT '0' NOT NULL,
scripts blob DEFAULT '' NOT NULL,
PRIMARY KEY (actionid)
) ENGINE=InnoDB ;
insert into actions_tmp select * from actions;
drop table actions;
alter table actions_tmp rename actions;
|