diff options
author | sasha <sasha@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2008-04-10 13:35:38 +0000 |
---|---|---|
committer | sasha <sasha@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2008-04-10 13:35:38 +0000 |
commit | 5324c016a35d893a4e76951d1a45546b5a5ddaf3 (patch) | |
tree | 04a33db618b977b74da66cf902db86a8c04e6774 /create/schema | |
parent | 895237a817c3c2f173e342a8fa1594a308f68485 (diff) | |
download | zabbix-5324c016a35d893a4e76951d1a45546b5a5ddaf3.tar.gz zabbix-5324c016a35d893a4e76951d1a45546b5a5ddaf3.tar.xz zabbix-5324c016a35d893a4e76951d1a45546b5a5ddaf3.zip |
- [DEV-105] Database changes
- [DEV-141] improved performance of ZABBIX Proxy module
git-svn-id: svn://svn.zabbix.com/trunk@5608 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create/schema')
-rw-r--r-- | create/schema/schema.sql | 16 |
1 files changed, 11 insertions, 5 deletions
diff --git a/create/schema/schema.sql b/create/schema/schema.sql index b310fbae..abf16482 100644 --- a/create/schema/schema.sql +++ b/create/schema/schema.sql @@ -185,7 +185,6 @@ FIELD |itemid |t_id |'0' |NOT NULL |ZBX_HISTORY_SYNC FIELD |clock |t_time |'0' |NOT NULL |ZBX_HISTORY_SYNC FIELD |value |t_double |'0.0000'|NOT NULL |ZBX_HISTORY_SYNC INDEX |1 |nodeid,id -INDEX |2 |clock TABLE|history_uint||0 FIELD |itemid |t_id |'0' |NOT NULL |0 @@ -200,7 +199,6 @@ FIELD |itemid |t_id |'0' |NOT NULL |ZBX_HISTORY_SYNC FIELD |clock |t_time |'0' |NOT NULL |ZBX_HISTORY_SYNC FIELD |value |t_bigint |'0' |NOT NULL |ZBX_HISTORY_SYNC INDEX |1 |nodeid,id -INDEX |2 |clock TABLE|history_str||0 FIELD |itemid |t_id |'0' |NOT NULL |0 @@ -215,7 +213,6 @@ FIELD |itemid |t_id |'0' |NOT NULL |ZBX_HISTORY_SYNC FIELD |clock |t_time |'0' |NOT NULL |ZBX_HISTORY_SYNC FIELD |value |t_varchar(255) |'' |NOT NULL |ZBX_HISTORY_SYNC INDEX |1 |nodeid,id -INDEX |2 |clock TABLE|history_log|id|ZBX_HISTORY FIELD |id |t_id |'0' |NOT NULL |0 @@ -226,7 +223,6 @@ FIELD |source |t_varchar(64) |'' |NOT NULL |0 FIELD |severity |t_integer |'0' |NOT NULL |0 FIELD |value |t_history_log |'' |NOT NULL |0 INDEX |1 |itemid,clock -INDEX |2 |clock TABLE|history_text|id|ZBX_HISTORY FIELD |id |t_id |'0' |NOT NULL |0 @@ -234,7 +230,17 @@ FIELD |itemid |t_id |'0' |NOT NULL |0 FIELD |clock |t_time |'0' |NOT NULL |0 FIELD |value |t_history_text |'' |NOT NULL |0 INDEX |1 |itemid,clock -INDEX |2 |clock + +TABLE|proxy_history|id|0 +FIELD |id |t_serial | |NOT NULL |0 +FIELD |host |t_varchar(64) |'' |NOT NULL |0 +FIELD |key_ |t_varchar(255) |'' |NOT NULL |0 +FIELD |clock |t_time |'0' |NOT NULL |0 +FIELD |timestamp |t_time |'0' |NOT NULL |0 +FIELD |source |t_varchar(64) |'' |NOT NULL |0 +FIELD |severity |t_integer |'0' |NOT NULL |0 +FIELD |value |t_history_log |'' |NOT NULL |0 +INDEX |1 |clock TABLE|proxy_dhistory|id|0 FIELD |id |t_serial | |NOT NULL |0 |