diff options
Diffstat (limited to 'create/postgresql/schema.sql')
| -rw-r--r-- | create/postgresql/schema.sql | 15 |
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' -- |
