1 files changed, 30 insertions, 0 deletions
diff --git a/upgrades/dbpatches/1.4/postgresql/patch/actions.sql b/upgrades/dbpatches/1.4/postgresql/patch/actions.sql
new file mode 100644
index 00000000..9f45bd08
--- /dev/null
+++ b/upgrades/dbpatches/1.4/postgresql/patch/actions.sql
@@ -0,0 +1,30 @@
+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;