diff options
Diffstat (limited to 'create/src/schema.tmpl')
-rw-r--r-- | create/src/schema.tmpl | 30 |
1 files changed, 21 insertions, 9 deletions
diff --git a/create/src/schema.tmpl b/create/src/schema.tmpl index 11ea9812b48..a8323202cb7 100644 --- a/create/src/schema.tmpl +++ b/create/src/schema.tmpl @@ -35,7 +35,7 @@ UNIQUE |2 |name TABLE|hosts|hostid|ZBX_DATA FIELD |hostid |t_id | |NOT NULL |0 FIELD |proxy_hostid |t_id | |NULL |0 |1|hosts |hostid |RESTRICT -FIELD |host |t_varchar(64) |'' |NOT NULL |ZBX_PROXY +FIELD |host |t_varchar(128) |'' |NOT NULL |ZBX_PROXY FIELD |status |t_integer |'0' |NOT NULL |ZBX_PROXY FIELD |disable_until |t_integer |'0' |NOT NULL |ZBX_NODATA FIELD |error |t_varchar(128) |'' |NOT NULL |ZBX_NODATA @@ -62,7 +62,7 @@ FIELD |jmx_disable_until|t_integer |'0' |NOT NULL |ZBX_NODATA FIELD |jmx_available |t_integer |'0' |NOT NULL |ZBX_NODATA FIELD |jmx_errors_from|t_integer |'0' |NOT NULL |ZBX_NODATA FIELD |jmx_error |t_varchar(128) |'' |NOT NULL |ZBX_NODATA -FIELD |name |t_varchar(64) |'' |NOT NULL |ZBX_PROXY +FIELD |name |t_varchar(128) |'' |NOT NULL |ZBX_PROXY FIELD |flags |t_integer |'0' |NOT NULL |0 FIELD |templateid |t_id | |NULL |0 |3|hosts |hostid FIELD |description |t_shorttext |'' |NOT NULL |0 @@ -111,8 +111,8 @@ FIELD |width |t_integer |'320' |NOT NULL |0 FIELD |height |t_integer |'200' |NOT NULL |0 FIELD |x |t_integer |'0' |NOT NULL |0 FIELD |y |t_integer |'0' |NOT NULL |0 -FIELD |colspan |t_integer |'0' |NOT NULL |0 -FIELD |rowspan |t_integer |'0' |NOT NULL |0 +FIELD |colspan |t_integer |'1' |NOT NULL |0 +FIELD |rowspan |t_integer |'1' |NOT NULL |0 FIELD |elements |t_integer |'25' |NOT NULL |0 FIELD |valign |t_integer |'0' |NOT NULL |0 FIELD |halign |t_integer |'0' |NOT NULL |0 @@ -121,6 +121,7 @@ FIELD |url |t_varchar(255) |'' |NOT NULL |0 FIELD |dynamic |t_integer |'0' |NOT NULL |0 FIELD |sort_triggers |t_integer |'0' |NOT NULL |0 FIELD |application |t_varchar(255) |'' |NOT NULL |0 +FIELD |max_columns |t_integer |'3' |NOT NULL |0 INDEX |1 |screenid TABLE|slideshows|slideshowid|ZBX_DATA @@ -141,7 +142,7 @@ INDEX |2 |screenid TABLE|drules|druleid|ZBX_DATA FIELD |druleid |t_id | |NOT NULL |0 FIELD |proxy_hostid |t_id | |NULL |0 |1|hosts |hostid |RESTRICT -FIELD |name |t_varchar(255) |'' |NOT NULL |0 +FIELD |name |t_varchar(255) |'' |NOT NULL |ZBX_PROXY FIELD |iprange |t_varchar(255) |'' |NOT NULL |ZBX_PROXY FIELD |delay |t_integer |'3600' |NOT NULL |ZBX_PROXY FIELD |nextcheck |t_integer |'0' |NOT NULL |ZBX_NODATA @@ -188,6 +189,12 @@ FIELD |hostid |t_id | |NOT NULL |ZBX_PROXY |2|hosts FIELD |templateid |t_id | |NULL |0 |3|httptest |httptestid FIELD |http_proxy |t_varchar(255) |'' |NOT NULL |ZBX_PROXY,ZBX_NODATA FIELD |retries |t_integer |'1' |NOT NULL |ZBX_PROXY,ZBX_NODATA +FIELD |ssl_cert_file |t_varchar(255) |'' |NOT NULL |ZBX_PROXY,ZBX_NODATA +FIELD |ssl_key_file |t_varchar(255) |'' |NOT NULL |ZBX_PROXY,ZBX_NODATA +FIELD |ssl_key_password|t_varchar(64) |'' |NOT NULL |ZBX_PROXY,ZBX_NODATA +FIELD |verify_peer |t_integer |'0' |NOT NULL |ZBX_PROXY +FIELD |verify_host |t_integer |'0' |NOT NULL |ZBX_PROXY +FIELD |headers |t_shorttext |'' |NOT NULL |ZBX_PROXY INDEX |1 |applicationid UNIQUE |2 |hostid,name INDEX |3 |status @@ -198,12 +205,15 @@ FIELD |httpstepid |t_id | |NOT NULL |0 FIELD |httptestid |t_id | |NOT NULL |ZBX_PROXY |1|httptest FIELD |name |t_varchar(64) |'' |NOT NULL |ZBX_PROXY FIELD |no |t_integer |'0' |NOT NULL |ZBX_PROXY -FIELD |url |t_varchar(255) |'' |NOT NULL |ZBX_PROXY -FIELD |timeout |t_integer |'30' |NOT NULL |ZBX_PROXY +FIELD |url |t_varchar(2048)|'' |NOT NULL |ZBX_PROXY +FIELD |timeout |t_integer |'15' |NOT NULL |ZBX_PROXY FIELD |posts |t_shorttext |'' |NOT NULL |ZBX_PROXY FIELD |required |t_varchar(255) |'' |NOT NULL |ZBX_PROXY FIELD |status_codes |t_varchar(255) |'' |NOT NULL |ZBX_PROXY FIELD |variables |t_shorttext |'' |NOT NULL |ZBX_PROXY +FIELD |follow_redirects|t_integer |'1' |NOT NULL |ZBX_PROXY +FIELD |retrieve_mode |t_integer |'0' |NOT NULL |ZBX_PROXY +FIELD |headers |t_shorttext |'' |NOT NULL |ZBX_PROXY INDEX |1 |httptestid TABLE|interface|interfaceid|ZBX_DATA @@ -215,6 +225,7 @@ FIELD |useip |t_integer |'1' |NOT NULL |ZBX_PROXY FIELD |ip |t_varchar(64) |'127.0.0.1'|NOT NULL |ZBX_PROXY FIELD |dns |t_varchar(64) |'' |NOT NULL |ZBX_PROXY FIELD |port |t_varchar(64) |'10050'|NOT NULL |ZBX_PROXY +FIELD |bulk |t_integer |'1' |NOT NULL |ZBX_PROXY INDEX |1 |hostid,type INDEX |2 |ip,dns @@ -245,7 +256,7 @@ FIELD |snmpv3_securitylevel|t_integer |'0' |NOT NULL |ZBX_PROXY FIELD |snmpv3_authpassphrase|t_varchar(64)|'' |NOT NULL |ZBX_PROXY FIELD |snmpv3_privpassphrase|t_varchar(64)|'' |NOT NULL |ZBX_PROXY FIELD |formula |t_varchar(255) |'' |NOT NULL |0 -FIELD |error |t_varchar(128) |'' |NOT NULL |ZBX_NODATA +FIELD |error |t_varchar(2048)|'' |NOT NULL |ZBX_NODATA FIELD |lastlogsize |t_bigint |'0' |NOT NULL |ZBX_NODATA FIELD |logtimefmt |t_varchar(64) |'' |NOT NULL |ZBX_PROXY FIELD |templateid |t_id | |NULL |0 |2|items |itemid @@ -368,6 +379,7 @@ FIELD |def_longdata |t_shorttext |'' |NOT NULL |0 FIELD |recovery_msg |t_integer |'0' |NOT NULL |0 FIELD |r_shortdata |t_varchar(255) |'' |NOT NULL |0 FIELD |r_longdata |t_shorttext |'' |NOT NULL |0 +FIELD |formula |t_varchar(255) |'' |NOT NULL |0 INDEX |1 |eventsource,status UNIQUE |2 |name @@ -1267,4 +1279,4 @@ INDEX |1 |itemid TABLE|dbversion|| FIELD |mandatory |t_integer |'0' |NOT NULL | FIELD |optional |t_integer |'0' |NOT NULL | -ROW |2030091 |2030091 +ROW |2030118 |2030118 |