summaryrefslogtreecommitdiffstats
path: root/create/postgresql/schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'create/postgresql/schema.sql')
-rw-r--r--create/postgresql/schema.sql15
1 files changed, 15 insertions, 0 deletions
diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql
index 34fc17aa..95afe961 100644
--- a/create/postgresql/schema.sql
+++ b/create/postgresql/schema.sql
@@ -220,6 +220,21 @@ CREATE TABLE actions (
);
--
+-- Table structure for table 'conditions'
+--
+
+CREATE TABLE conditions (
+ conditionid serial,
+ actionid int4 DEFAULT '0' NOT NULL,
+ conditiontype int4 DEFAULT '0' NOT NULL,
+ operator int1 DEFAULT '0' NOT NULL,
+ value varchar(255) DEFAULT '' NOT NULL,
+ PRIMARY KEY (conditionid),
+ FOREIGN KEY (actionid) REFERENCES actions
+);
+
+
+--
-- Table structure for table 'media_type'
--