summaryrefslogtreecommitdiffstats
path: root/create
diff options
context:
space:
mode:
authorsasha <sasha@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2008-02-29 09:19:28 +0000
committersasha <sasha@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2008-02-29 09:19:28 +0000
commit35b6f56b689d87f2a7d55185ae1c3475e0c747a5 (patch)
treeac592f0b15488c6a73e88184f3d8184371d4819d /create
parentf928f6768df82762c119f9d1c1bae3a92a1c6451 (diff)
downloadzabbix-35b6f56b689d87f2a7d55185ae1c3475e0c747a5.tar.gz
zabbix-35b6f56b689d87f2a7d55185ae1c3475e0c747a5.tar.xz
zabbix-35b6f56b689d87f2a7d55185ae1c3475e0c747a5.zip
- [DEV-105] added table "proxy_dhistory"
git-svn-id: svn://svn.zabbix.com/trunk@5416 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create')
-rw-r--r--create/schema/schema.sql12
1 files changed, 12 insertions, 0 deletions
diff --git a/create/schema/schema.sql b/create/schema/schema.sql
index 9ae2989f..a0eaeaaa 100644
--- a/create/schema/schema.sql
+++ b/create/schema/schema.sql
@@ -231,6 +231,18 @@ FIELD |clock |t_time |'0' |NOT NULL |0
FIELD |value |t_history_text |'' |NOT NULL |0
INDEX |1 |itemid,clock
+TABLE|proxy_dhistory|id|0
+FIELD |id |t_serial | |NOT NULL |0
+FIELD |clock |t_time |'0' |NOT NULL |0
+FIELD |druleid |t_id |'0' |NOT NULL |0
+FIELD |type |t_integer |'0' |NOT NULL |0
+FIELD |ip |t_varchar(39) |'' |NOT NULL |0
+FIELD |port |t_integer |'0' |NOT NULL |0
+FIELD |key_ |t_varchar(255) |'0' |NOT NULL |0
+FIELD |value |t_varchar(255) |'0' |NOT NULL |0
+FIELD |status |t_integer |'0' |NOT NULL |0
+INDEX |1 |clock
+
TABLE|events|eventid|ZBX_HISTORY
FIELD |eventid |t_id |'0' |NOT NULL |0
FIELD |source |t_integer |'0' |NOT NULL |0