summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-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