diff options
author | sasha <sasha@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2008-01-19 22:35:44 +0000 |
---|---|---|
committer | sasha <sasha@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2008-01-19 22:35:44 +0000 |
commit | 3e8c5c43f93bdc2cea90a021eedee58327d83641 (patch) | |
tree | 0d2c28283e56cde4d37a7a1f2023452d1213612b /create/schema | |
parent | b29b61d9956aa526b42083f1b79bb07e4949e621 (diff) | |
download | zabbix-3e8c5c43f93bdc2cea90a021eedee58327d83641.tar.gz zabbix-3e8c5c43f93bdc2cea90a021eedee58327d83641.tar.xz zabbix-3e8c5c43f93bdc2cea90a021eedee58327d83641.zip |
- [DEV-105] Database changes
git-svn-id: svn://svn.zabbix.com/trunk@5267 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create/schema')
-rw-r--r-- | create/schema/schema.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/create/schema/schema.sql b/create/schema/schema.sql index 7fe4a1b2..c9a78602 100644 --- a/create/schema/schema.sql +++ b/create/schema/schema.sql @@ -378,8 +378,15 @@ FIELD |itemtype |t_integer |'0' |NOT NULL |ZBX_SYNC FIELD |key_ |t_varchar(255) |'' |NOT NULL |ZBX_SYNC FIELD |description |t_varchar(255) |'' |NOT NULL |ZBX_SYNC +TABLE|proxies|proxyid|ZBX_SYNC +FIELD |proxyid |t_id |'0' |NOT NULL |0 +FIELD |name |t_varchar(64) |'' |NOT NULL |ZBX_SYNC +FIELD |lastaccess |t_integer |'0' |NOT NULL |ZBX_SYNC +INDEX |1 |name + TABLE|hosts|hostid|ZBX_SYNC FIELD |hostid |t_id |'0' |NOT NULL |0 +FIELD |proxyid |t_id |'0' |NOT NULL |ZBX_SYNC FIELD |host |t_varchar(64) |'' |NOT NULL |ZBX_SYNC FIELD |dns |t_varchar(64) |'' |NOT NULL |ZBX_SYNC FIELD |useip |t_integer |'1' |NOT NULL |ZBX_SYNC @@ -392,6 +399,7 @@ FIELD |available |t_integer |'0' |NOT NULL |ZBX_SYNC FIELD |errors_from |t_integer |'0' |NOT NULL |0 INDEX |1 |host INDEX |2 |status +INDEX |3 |proxyid TABLE|hosts_groups|hostgroupid|ZBX_SYNC FIELD |hostgroupid |t_id |'0' |NOT NULL |0 |