diff options
| author | alex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2006-09-20 06:58:59 +0000 |
|---|---|---|
| committer | alex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2006-09-20 06:58:59 +0000 |
| commit | b3ca9173d1a1135522cb9c6eb002a5e1d0849eda (patch) | |
| tree | 8b875b9905b4985bd9cbfb877a121c623e65e30b /create/schema/schema.sql | |
| parent | 60ac638462e1f5b72ba9010cd61b734631f2dc32 (diff) | |
| download | zabbix-b3ca9173d1a1135522cb9c6eb002a5e1d0849eda.tar.gz zabbix-b3ca9173d1a1135522cb9c6eb002a5e1d0849eda.tar.xz zabbix-b3ca9173d1a1135522cb9c6eb002a5e1d0849eda.zip | |
- table ALARMS renamed to EVENTS (Alexei)
- more development of distributed monitoring
git-svn-id: svn://svn.zabbix.com/trunk@3317 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create/schema/schema.sql')
| -rw-r--r-- | create/schema/schema.sql | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/create/schema/schema.sql b/create/schema/schema.sql index 0b1861ee..76c51aea 100644 --- a/create/schema/schema.sql +++ b/create/schema/schema.sql @@ -171,7 +171,7 @@ CREATE INDEX sysmaps_1 ON sysmaps (name); CREATE TABLE config ( configid {bigint} DEFAULT '0' NOT NULL, alert_history {integer} DEFAULT '0' NOT NULL, - alarm_history {integer} DEFAULT '0' NOT NULL, + event_history {integer} DEFAULT '0' NOT NULL, refresh_unsupported {integer} DEFAULT '0' NOT NULL, work_period {varchar}(100) DEFAULT '1-5,00:00-24:00' NOT NULL, PRIMARY KEY (configid) @@ -248,17 +248,17 @@ CREATE TABLE conditions ( CREATE INDEX conditions_1 ON conditions (actionid); -CREATE TABLE alarms ( - alarmid {bigint} DEFAULT '0' NOT NULL, +CREATE TABLE events ( + eventid {bigint} DEFAULT '0' NOT NULL, triggerid {bigint} DEFAULT '0' NOT NULL, clock {integer} DEFAULT '0' NOT NULL, value {integer} DEFAULT '0' NOT NULL, acknowledged {integer} DEFAULT '0' NOT NULL, - PRIMARY KEY (alarmid) + PRIMARY KEY (eventid) ) {create_table_opt}; -CREATE INDEX alarms_1 ON alarms (triggerid,clock); -CREATE INDEX alarms_2 ON alarms (clock); +CREATE INDEX events_1 ON events (triggerid,clock); +CREATE INDEX events_2 ON events (clock); CREATE TABLE functions ( functionid {bigint} DEFAULT '0' NOT NULL, @@ -634,14 +634,14 @@ CREATE TABLE housekeeper ( CREATE TABLE acknowledges ( acknowledgeid {bigint} DEFAULT '0' NOT NULL, userid {bigint} DEFAULT '0' NOT NULL, - alarmid {bigint} DEFAULT '0' NOT NULL, + eventid {bigint} DEFAULT '0' NOT NULL, clock {integer} DEFAULT '0' NOT NULL, message {varchar}(255) DEFAULT '' NOT NULL, PRIMARY KEY (acknowledgeid) ) {create_table_opt}; CREATE INDEX acknowledges_1 ON acknowledges (userid); -CREATE INDEX acknowledges_2 ON acknowledges (alarmid); +CREATE INDEX acknowledges_2 ON acknowledges (eventid); CREATE INDEX acknowledges_3 ON acknowledges (clock); CREATE TABLE applications ( |