summaryrefslogtreecommitdiffstats
path: root/create/postgresql/schema.sql
diff options
context:
space:
mode:
authorhugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2003-05-11 07:59:43 +0000
committerhugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2003-05-11 07:59:43 +0000
commita0b5fa62e195872b6bdd740f30afd53dd6e83170 (patch)
tree69b7bb01985964e584d0eedfd16f26c31f54560e /create/postgresql/schema.sql
parent3af34e029204d721a4eac3c7a9a2727d9e9c6845 (diff)
downloadzabbix-a0b5fa62e195872b6bdd740f30afd53dd6e83170.tar.gz
zabbix-a0b5fa62e195872b6bdd740f30afd53dd6e83170.tar.xz
zabbix-a0b5fa62e195872b6bdd740f30afd53dd6e83170.zip
- added columns actions.scope and actions.severity (Alexei)
git-svn-id: svn://svn.zabbix.com/trunk@765 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create/postgresql/schema.sql')
-rw-r--r--create/postgresql/schema.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql
index acaa4dc4..5ad70042 100644
--- a/create/postgresql/schema.sql
+++ b/create/postgresql/schema.sql
@@ -164,6 +164,8 @@ CREATE TABLE actions (
actionid serial,
triggerid int4 DEFAULT '0' NOT NULL,
userid int4 DEFAULT '0' NOT NULL,
+ scope 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,