diff options
| author | alex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2006-10-10 13:34:58 +0000 |
|---|---|---|
| committer | alex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2006-10-10 13:34:58 +0000 |
| commit | 495799b2aa61aab23d74d7faa110a0cd09d59bf0 (patch) | |
| tree | f25c991e9a2c9db854dab7919700c70d9ee99ea8 /create/schema/schema.sql | |
| parent | abafe94bd653f8510dba94760607869ff31b248d (diff) | |
| download | zabbix-495799b2aa61aab23d74d7faa110a0cd09d59bf0.tar.gz zabbix-495799b2aa61aab23d74d7faa110a0cd09d59bf0.tar.xz zabbix-495799b2aa61aab23d74d7faa110a0cd09d59bf0.zip | |
More changes for distributed monitoring.
git-svn-id: svn://svn.zabbix.com/trunk@3335 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create/schema/schema.sql')
| -rw-r--r-- | create/schema/schema.sql | 24 |
1 files changed, 23 insertions, 1 deletions
diff --git a/create/schema/schema.sql b/create/schema/schema.sql index 650cfa37..49abce50 100644 --- a/create/schema/schema.sql +++ b/create/schema/schema.sql @@ -22,7 +22,7 @@ -- CREATE TABLE nodes ( - nodeid {bigint} DEFAULT '0' NOT NULL, + nodeid {integer} DEFAULT '0' NOT NULL, name {varchar}(64) DEFAULT '' NOT NULL, timezone {integer} DEFAULT '0' NOT NULL, ip {varchar}(15) DEFAULT '' NOT NULL, @@ -302,6 +302,17 @@ CREATE TABLE history_uint ( CREATE INDEX history_uint_1 ON history_uint (itemid, clock); +CREATE TABLE history_uint_sync ( + id {serial}, + nodeid {integer} DEFAULT '0' NOT NULL, + itemid {bigint} DEFAULT '0' NOT NULL, + clock {integer} DEFAULT '0' NOT NULL, + value {bigint} DEFAULT '0' NOT NULL, + PRIMARY KEY (id) +) {create_table_opt}; + +CREATE INDEX history_uint_sync_1 ON history_uint_sync (nodeid, id); + CREATE TABLE history_str ( itemid {bigint} DEFAULT '0' NOT NULL, clock {integer} DEFAULT '0' NOT NULL, @@ -310,6 +321,17 @@ CREATE TABLE history_str ( CREATE INDEX history_str_1 ON history_str (itemid, clock); +CREATE TABLE history_str_sync ( + id {serial}, + nodeid {integer} DEFAULT '0' NOT NULL, + itemid {bigint} DEFAULT '0' NOT NULL, + clock {integer} DEFAULT '0' NOT NULL, + value {varchar}(255) DEFAULT '' NOT NULL, + PRIMARY KEY (id) +) {create_table_opt}; + +CREATE INDEX history_str_sync_1 ON history_str_sync (nodeid, id); + CREATE TABLE hosts ( hostid {bigint} DEFAULT '0' NOT NULL, host {varchar}(64) DEFAULT '' NOT NULL, |