1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
|
CREATE TABLE actions_tmp (
actionid bigint unsigned DEFAULT '0' NOT NULL,
name varchar(255) DEFAULT '' NOT NULL,
eventsource integer DEFAULT '0' NOT NULL,
evaltype integer DEFAULT '0' NOT NULL,
status integer DEFAULT '0' NOT NULL,
PRIMARY KEY (actionid)
) ENGINE=InnoDB;
CREATE TABLE operations (
operationid bigint unsigned DEFAULT '0' NOT NULL,
actionid bigint unsigned DEFAULT '0' NOT NULL,
operationtype integer DEFAULT '0' NOT NULL,
object integer DEFAULT '0' NOT NULL,
objectid bigint unsigned DEFAULT '0' NOT NULL,
shortdata varchar(255) DEFAULT '' NOT NULL,
longdata blob DEFAULT '' NOT NULL,
scripts_tmp blob DEFAULT '' NOT NULL,
PRIMARY KEY (operationid)
) ENGINE=InnoDB;
CREATE INDEX operations_1 on operations (actionid);
insert into actions_tmp select actionid,actionid,source,0,status from actions;
insert into operations select actionid,actionid,actiontype,recipient,userid,subject,message,scripts from actions;
update operations set longdata=scripts_tmp where operationtype=1;
alter table operations drop scripts_tmp;
drop table actions;
alter table actions_tmp rename actions;
|
