summaryrefslogtreecommitdiffstats
path: root/upgrades/dbpatches/1.6/mysql/patch/opconditions.sql
diff options
context:
space:
mode:
Diffstat (limited to 'upgrades/dbpatches/1.6/mysql/patch/opconditions.sql')
-rw-r--r--upgrades/dbpatches/1.6/mysql/patch/opconditions.sql9
1 files changed, 9 insertions, 0 deletions
diff --git a/upgrades/dbpatches/1.6/mysql/patch/opconditions.sql b/upgrades/dbpatches/1.6/mysql/patch/opconditions.sql
new file mode 100644
index 00000000..0028cf5d
--- /dev/null
+++ b/upgrades/dbpatches/1.6/mysql/patch/opconditions.sql
@@ -0,0 +1,9 @@
+CREATE TABLE opconditions (
+ opconditionid bigint unsigned DEFAULT '0' NOT NULL,
+ operationid bigint unsigned DEFAULT '0' NOT NULL,
+ conditiontype integer DEFAULT '0' NOT NULL,
+ operator integer DEFAULT '0' NOT NULL,
+ value varchar(255) DEFAULT '' NOT NULL,
+ PRIMARY KEY (opconditionid)
+) type=InnoDB;
+CREATE INDEX opconditions_1 on opconditions (operationid);