From 35b6f56b689d87f2a7d55185ae1c3475e0c747a5 Mon Sep 17 00:00:00 2001 From: sasha Date: Fri, 29 Feb 2008 09:19:28 +0000 Subject: - [DEV-105] added table "proxy_dhistory" git-svn-id: svn://svn.zabbix.com/trunk@5416 97f52cf1-0a1b-0410-bd0e-c28be96e8082 --- create/schema/schema.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) (limited to 'create') 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 -- cgit