summaryrefslogtreecommitdiffstats
path: root/upgrades/dbpatches/1.3/postgresql/patch/triggers.sql
diff options
context:
space:
mode:
Diffstat (limited to 'upgrades/dbpatches/1.3/postgresql/patch/triggers.sql')
-rw-r--r--upgrades/dbpatches/1.3/postgresql/patch/triggers.sql21
1 files changed, 21 insertions, 0 deletions
diff --git a/upgrades/dbpatches/1.3/postgresql/patch/triggers.sql b/upgrades/dbpatches/1.3/postgresql/patch/triggers.sql
new file mode 100644
index 00000000..1d03e406
--- /dev/null
+++ b/upgrades/dbpatches/1.3/postgresql/patch/triggers.sql
@@ -0,0 +1,21 @@
+CREATE TABLE triggers_tmp (
+ triggerid bigint unsigned DEFAULT '0' NOT NULL,
+ expression varchar(255) DEFAULT '' NOT NULL,
+ description varchar(255) DEFAULT '' NOT NULL,
+ url varchar(255) DEFAULT '' NOT NULL,
+ status integer DEFAULT '0' NOT NULL,
+ value integer DEFAULT '0' NOT NULL,
+ priority integer DEFAULT '0' NOT NULL,
+ lastchange integer DEFAULT '0' NOT NULL,
+ dep_level integer DEFAULT '0' NOT NULL,
+ comments blob ,
+ error varchar(128) DEFAULT '' NOT NULL,
+ templateid bigint unsigned DEFAULT '0' NOT NULL,
+ PRIMARY KEY (triggerid)
+) ENGINE=InnoDB;
+CREATE INDEX triggers_1 on triggers_tmp (status);
+CREATE INDEX triggers_2 on triggers_tmp (value);
+
+insert into triggers_tmp select * from triggers;
+drop table triggers;
+alter table triggers_tmp rename triggers;