From de88880aed22e1fc120f9ca0912bc5e5ec1460da Mon Sep 17 00:00:00 2001 From: hugetoad Date: Sat, 31 Dec 2005 10:17:17 +0000 Subject: Upgrade script for actions; git-svn-id: svn://svn.zabbix.com/trunk@2461 97f52cf1-0a1b-0410-bd0e-c28be96e8082 --- create/postgresql/schema.sql | 15 +++++++++++++++ 1 file changed, 15 insertions(+) (limited to 'create/postgresql/schema.sql') 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 @@ -219,6 +219,21 @@ CREATE TABLE actions ( -- FOREIGN KEY (userid) REFERENCES users ); +-- +-- 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' -- -- cgit