diff options
| author | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2005-08-10 08:28:50 +0000 |
|---|---|---|
| committer | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2005-08-10 08:28:50 +0000 |
| commit | aa8feb98f29a60e23b2d11e93d3e186d72dd2426 (patch) | |
| tree | 1b03f86d1a1ad4cc1d353c58516762aee3470779 /create/postgresql/schema.sql | |
| parent | 831ae6761f98382b21ae96177bfa542dbcc20ca4 (diff) | |
| download | zabbix-aa8feb98f29a60e23b2d11e93d3e186d72dd2426.tar.gz zabbix-aa8feb98f29a60e23b2d11e93d3e186d72dd2426.tar.xz zabbix-aa8feb98f29a60e23b2d11e93d3e186d72dd2426.zip | |
Minor changes.
git-svn-id: svn://svn.zabbix.com/trunk@1955 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create/postgresql/schema.sql')
| -rw-r--r-- | create/postgresql/schema.sql | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql index 80d2489b..10063400 100644 --- a/create/postgresql/schema.sql +++ b/create/postgresql/schema.sql @@ -634,6 +634,26 @@ CREATE TABLE escalations ( CREATE UNIQUE INDEX escalations_name on escalations (name); -- +-- Table structure for table 'escalation_log' +-- + +CREATE TABLE escalation_log ( + escalationlogid serial, + triggerid int4 DEFAULT '0' NOT NULL, + alarmid int4 DEFAULT '0' NOT NULL, + escalationid int4 DEFAULT '0' NOT NULL, + actiontype int4 DEFAULT '0' NOT NULL, + level int4 DEFAULT '0' NOT NULL, + adminlevel int4 DEFAULT '0' NOT NULL, + nextcheck int4 DEFAULT '0' NOT NULL, + status int4 DEFAULT '0' NOT NULL, + PRIMARY KEY (escalationlogid) +); + +CREATE INDEX escalations_log_alarmid_escalationid on escalations_log (alarmid,escalationid); +CREATE INDEX escalations_log_triggerid on escalations_log (triggerid); + +-- -- Table structure for table 'escalation_rules' -- |