diff options
| author | sasha <sasha@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2008-05-27 08:24:17 +0000 |
|---|---|---|
| committer | sasha <sasha@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2008-05-27 08:24:17 +0000 |
| commit | c0bfb062b8ac422278fbd5b299ecbef51203011b (patch) | |
| tree | 0d21b48a18b42a9fafeb19236cff97f50436bc3a /create/schema | |
| parent | 1528814bf6b442cc01211b9f0b3f2adaadf970f4 (diff) | |
| download | zabbix-c0bfb062b8ac422278fbd5b299ecbef51203011b.tar.gz zabbix-c0bfb062b8ac422278fbd5b299ecbef51203011b.tar.xz zabbix-c0bfb062b8ac422278fbd5b299ecbef51203011b.zip | |
- [DEV-173] added support of notification escalations on server side
git-svn-id: svn://svn.zabbix.com/trunk@5725 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create/schema')
| -rw-r--r-- | create/schema/schema.sql | 32 |
1 files changed, 31 insertions, 1 deletions
diff --git a/create/schema/schema.sql b/create/schema/schema.sql index 16397a8a..88227b62 100644 --- a/create/schema/schema.sql +++ b/create/schema/schema.sql @@ -165,6 +165,8 @@ FIELD |status |t_integer |'0' |NOT NULL |0 FIELD |retries |t_integer |'0' |NOT NULL |0 FIELD |error |t_varchar(128) |'' |NOT NULL |0 FIELD |nextcheck |t_integer |'0' |NOT NULL |0 +FIELD |esc_step |t_integer |'0' |NOT NULL |0 +FIELD |alerttype |t_integer |'0' |NOT NULL |0 INDEX |1 |actionid INDEX |2 |clock INDEX |3 |eventid @@ -318,6 +320,12 @@ FIELD |name |t_varchar(255) |'' |NOT NULL |ZBX_SYNC FIELD |eventsource |t_integer |'0' |NOT NULL |ZBX_SYNC FIELD |evaltype |t_integer |'0' |NOT NULL |ZBX_SYNC FIELD |status |t_integer |'0' |NOT NULL |ZBX_SYNC +FIELD |esc_period |t_integer |'0' |NOT NULL |ZBX_SYNC +FIELD |shortdata |t_varchar(255) |'' |NOT NULL |ZBX_SYNC +FIELD |longdata |t_blob |'' |NOT NULL |ZBX_SYNC +FIELD |recovery_msg |t_integer |'0' |NOT NULL |ZBX_SYNC +FIELD |r_shortdata |t_varchar(255) |'' |NOT NULL |ZBX_SYNC +FIELD |r_longdata |t_blob |'' |NOT NULL |ZBX_SYNC TABLE|operations|operationid|ZBX_SYNC FIELD |operationid |t_id |'0' |NOT NULL |0 @@ -327,8 +335,31 @@ FIELD |object |t_integer |'0' |NOT NULL |ZBX_SYNC FIELD |objectid |t_id |'0' |NOT NULL |ZBX_SYNC FIELD |shortdata |t_varchar(255) |'' |NOT NULL |ZBX_SYNC FIELD |longdata |t_blob |'' |NOT NULL |ZBX_SYNC +FIELD |esc_period |t_integer |'0' |NOT NULL |ZBX_SYNC +FIELD |esc_step_from |t_integer |'0' |NOT NULL |ZBX_SYNC +FIELD |esc_step_to |t_integer |'0' |NOT NULL |ZBX_SYNC +FIELD |default_msg |t_integer |'0' |NOT NULL |ZBX_SYNC +FIELD |evaltype |t_integer |'0' |NOT NULL |ZBX_SYNC INDEX |1 |actionid +TABLE|opconditions|opconditionid|ZBX_SYNC +FIELD |opconditionid |t_id |'0' |NOT NULL |0 +FIELD |operationid |t_id |'0' |NOT NULL |ZBX_SYNC +FIELD |conditiontype |t_integer |'0' |NOT NULL |ZBX_SYNC +FIELD |operator |t_integer |'0' |NOT NULL |ZBX_SYNC +FIELD |value |t_varchar(255) |'' |NOT NULL |ZBX_SYNC +INDEX |1 |operationid + +TABLE|escalations|escalationid|0 +FIELD |escalationid |t_id |'0' |NOT NULL |0 +FIELD |actionid |t_id |'0' |NOT NULL |0 +FIELD |triggerid |t_id |'0' |NOT NULL |0 +FIELD |eventid |t_id |'0' |NOT NULL |0 +FIELD |nextcheck |t_time |'0' |NOT NULL |0 +FIELD |esc_step |t_integer |'0' |NOT NULL |0 +FIELD |status |t_integer |'0' |NOT NULL |0 +INDEX |1 |actionid,triggerid + TABLE|applications|applicationid|ZBX_SYNC FIELD |applicationid |t_id |'0' |NOT NULL |0 FIELD |hostid |t_id |'0' |NOT NULL |ZBX_SYNC @@ -364,7 +395,6 @@ FIELD |ldap_bind_dn |t_varchar(255) |'' |NOT NULL |ZBX_SYNC FIELD |ldap_bind_password|t_varchar(128)|'' |NOT NULL |ZBX_SYNC FIELD |ldap_search_attribute|t_varchar(128)|''|NOT NULL |ZBX_SYNC - TABLE|functions|functionid|ZBX_SYNC FIELD |functionid |t_id |'0' |NOT NULL |0 FIELD |itemid |t_id |'0' |NOT NULL |ZBX_SYNC |