summaryrefslogtreecommitdiffstats
path: root/create/postgresql/schema.sql
diff options
context:
space:
mode:
authorhugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2005-12-27 10:59:17 +0000
committerhugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2005-12-27 10:59:17 +0000
commite6d3bc1a6eae3d6847198856e7e7f57eb8a0c98b (patch)
tree9e491d48382cf57960b1bfb949df512a9047f821 /create/postgresql/schema.sql
parentb4942b68162cb3606056b71e46ae91d630e10523 (diff)
downloadzabbix-e6d3bc1a6eae3d6847198856e7e7f57eb8a0c98b.tar.gz
zabbix-e6d3bc1a6eae3d6847198856e7e7f57eb8a0c98b.tar.xz
zabbix-e6d3bc1a6eae3d6847198856e7e7f57eb8a0c98b.zip
Minor changes.
git-svn-id: svn://svn.zabbix.com/trunk@2430 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create/postgresql/schema.sql')
-rw-r--r--create/postgresql/schema.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql
index 75b05b68..f713f1d7 100644
--- a/create/postgresql/schema.sql
+++ b/create/postgresql/schema.sql
@@ -203,7 +203,6 @@ CREATE INDEX audit_clock on audit (clock);
CREATE TABLE actions (
actionid serial,
userid int4 DEFAULT '0' NOT NULL,
- severity int4 DEFAULT '0' NOT NULL,
good int4 DEFAULT '0' NOT NULL,
delay int4 DEFAULT '0' NOT NULL,
subject varchar(255) DEFAULT '' NOT NULL,
@@ -218,6 +217,7 @@ CREATE TABLE actions (
filter_hostid int4 DEFAULT '0' NOT NULL,
filter_groupid int4 DEFAULT '0' NOT NULL,
filter_trigger_name varchar(255) DEFAULT '' NOT NULL,
+ filter_trigger_severity int4 DEFAULT '0' NOT NULL,
PRIMARY KEY (actionid)
-- depends on scope. Could be hostid or 0.
-- FOREIGN KEY (triggerid) REFERENCES triggers