diff options
Diffstat (limited to 'upgrades/dbpatches/1.3/postgresql/patch/actions.sql')
-rw-r--r-- | upgrades/dbpatches/1.3/postgresql/patch/actions.sql | 30 |
1 files changed, 0 insertions, 30 deletions
diff --git a/upgrades/dbpatches/1.3/postgresql/patch/actions.sql b/upgrades/dbpatches/1.3/postgresql/patch/actions.sql deleted file mode 100644 index 9f45bd08..00000000 --- a/upgrades/dbpatches/1.3/postgresql/patch/actions.sql +++ /dev/null @@ -1,30 +0,0 @@ -CREATE TABLE actions_tmp ( - actionid bigintd 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) -); - -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,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; |