diff options
Diffstat (limited to 'upgrades/dbpatches/1.3/postgresql/patch/actions.sql')
| -rw-r--r-- | upgrades/dbpatches/1.3/postgresql/patch/actions.sql | 38 |
1 files changed, 25 insertions, 13 deletions
diff --git a/upgrades/dbpatches/1.3/postgresql/patch/actions.sql b/upgrades/dbpatches/1.3/postgresql/patch/actions.sql index ecec38df..daefedc4 100644 --- a/upgrades/dbpatches/1.3/postgresql/patch/actions.sql +++ b/upgrades/dbpatches/1.3/postgresql/patch/actions.sql @@ -1,17 +1,29 @@ 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) + actionid bigintd DEFAULT '0' NOT NULL, + eventsource integer DEFAULT '0' NOT NULL, + evaltype integer DEFAULT '0' NOT NULL, + status integer DEFAULT '0' NOT NULL, + PRIMARY KEY (actionid) ); -insert into actions_tmp select actionid,userid,subject,message,recipient,source,actiontype,0,status,scripts from actions; +CREATE TABLE operations ( + operationid bigint DEFAULT '0' NOT NULL, + actionid bigint DEFAULT '0' NOT NULL, + operationtype integer DEFAULT '0' NOT NULL, + object integer DEFAULT '0' NOT NULL, + objectid bigint DEFAULT '0' NOT NULL, + shortdata varchar(255) DEFAULT '' NOT NULL, + longdata text DEFAULT '' NOT NULL, + scripts_tmp text DEFAULT '' NOT NULL, + PRIMARY KEY (operationid) +); +CREATE INDEX operations_1 on operations (actionid); + +insert into actions_tmp select 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 to actions; +alter table actions_tmp rename actions; |