1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
CREATE TABLE actions_tmp (
actionid bigint DEFAULT '0' NOT NULL,
userid bigint DEFAULT '0' NOT NULL,
subject varchar(255) DEFAULT '' NOT NULL,
message text DEFAULT '' NOT NULL,
recipient integer DEFAULT '0' NOT NULL,
source integer DEFAULT '0' NOT NULL,
actiontype integer DEFAULT '0' NOT NULL,
evaltype integer DEFAULT '0' NOT NULL,
status integer DEFAULT '0' NOT NULL,
scripts text DEFAULT '' NOT NULL,
PRIMARY KEY (actionid)
);
insert into actions_tmp select actionid,userid,subject,message,recipient,source,actiontype,0,status,scripts from actions;
drop table actions;
alter table actions_tmp rename to actions;
|
