1 /* 2 ** Zabbix 3 ** Copyright (C) 2001-2021 Zabbix SIA 4 ** 5 ** This program is free software; you can redistribute it and/or modify 6 ** it under the terms of the GNU General Public License as published by 7 ** the Free Software Foundation; either version 2 of the License, or 8 ** (at your option) any later version. 9 ** 10 ** This program is distributed in the hope that it will be useful, 11 ** but WITHOUT ANY WARRANTY; without even the implied warranty of 12 ** MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 13 ** GNU General Public License for more details. 14 ** 15 ** You should have received a copy of the GNU General Public License 16 ** along with this program; if not, write to the Free Software 17 ** Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA. 18 **/ 19 20 #include "common.h" 21 #include "dbschema.h" 22 23 const ZBX_TABLE tables[] = { 24 25 #if defined(HAVE_IBM_DB2) || defined(HAVE_ORACLE) 26 # define ZBX_TYPE_SHORTTEXT_LEN 2048 27 #else 28 # define ZBX_TYPE_SHORTTEXT_LEN 65535 29 #endif 30 31 #if defined(HAVE_IBM_DB2) 32 # define ZBX_TYPE_LONGTEXT_LEN 2048 33 # define ZBX_TYPE_TEXT_LEN 2048 34 #else 35 # define ZBX_TYPE_LONGTEXT_LEN 0 36 # define ZBX_TYPE_TEXT_LEN 65535 37 #endif 38 39 {"users", "userid", 0, 40 { 41 {"userid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 42 {"alias", "", NULL, NULL, 100, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 43 {"name", "", NULL, NULL, 100, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 44 {"surname", "", NULL, NULL, 100, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 45 {"passwd", "", NULL, NULL, 32, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 46 {"url", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 47 {"autologin", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 48 {"autologout", "900", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 49 {"lang", "en_GB", NULL, NULL, 5, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 50 {"refresh", "30", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 51 {"type", "1", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 52 {"theme", "default", NULL, NULL, 128, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 53 {"attempt_failed", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 54 {"attempt_ip", "", NULL, NULL, 39, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 55 {"attempt_clock", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 56 {"rows_per_page", "50", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 57 {0} 58 }, 59 "alias" 60 }, 61 {"maintenances", "maintenanceid", 0, 62 { 63 {"maintenanceid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 64 {"name", "", NULL, NULL, 128, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 65 {"maintenance_type", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 66 {"description", "", NULL, NULL, ZBX_TYPE_SHORTTEXT_LEN, ZBX_TYPE_SHORTTEXT, ZBX_NOTNULL, 0}, 67 {"active_since", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 68 {"active_till", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 69 {0} 70 }, 71 "name" 72 }, 73 {"hosts", "hostid", 0, 74 { 75 {"hostid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 76 {"proxy_hostid", NULL, "hosts", "hostid", 0, ZBX_TYPE_ID, 0, 0}, 77 {"host", "", NULL, NULL, 128, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 78 {"status", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL | ZBX_PROXY, 0}, 79 {"disable_until", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 80 {"error", "", NULL, NULL, 2048, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 81 {"available", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 82 {"errors_from", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 83 {"lastaccess", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 84 {"ipmi_authtype", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL | ZBX_PROXY, 0}, 85 {"ipmi_privilege", "2", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL | ZBX_PROXY, 0}, 86 {"ipmi_username", "", NULL, NULL, 16, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 87 {"ipmi_password", "", NULL, NULL, 20, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 88 {"ipmi_disable_until", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 89 {"ipmi_available", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 90 {"snmp_disable_until", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 91 {"snmp_available", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 92 {"maintenanceid", NULL, "maintenances", "maintenanceid", 0, ZBX_TYPE_ID, 0, 0}, 93 {"maintenance_status", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 94 {"maintenance_type", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 95 {"maintenance_from", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 96 {"ipmi_errors_from", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 97 {"snmp_errors_from", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 98 {"ipmi_error", "", NULL, NULL, 2048, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 99 {"snmp_error", "", NULL, NULL, 2048, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 100 {"jmx_disable_until", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 101 {"jmx_available", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 102 {"jmx_errors_from", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 103 {"jmx_error", "", NULL, NULL, 2048, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 104 {"name", "", NULL, NULL, 128, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 105 {"flags", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 106 {"templateid", NULL, "hosts", "hostid", 0, ZBX_TYPE_ID, 0, ZBX_FK_CASCADE_DELETE}, 107 {"description", "", NULL, NULL, ZBX_TYPE_SHORTTEXT_LEN, ZBX_TYPE_SHORTTEXT, ZBX_NOTNULL, 0}, 108 {"tls_connect", "1", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL | ZBX_PROXY, 0}, 109 {"tls_accept", "1", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL | ZBX_PROXY, 0}, 110 {"tls_issuer", "", NULL, NULL, 1024, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 111 {"tls_subject", "", NULL, NULL, 1024, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 112 {"tls_psk_identity", "", NULL, NULL, 128, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 113 {"tls_psk", "", NULL, NULL, 512, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 114 {0} 115 }, 116 NULL 117 }, 118 {"groups", "groupid", 0, 119 { 120 {"groupid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 121 {"name", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 122 {"internal", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 123 {"flags", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 124 {0} 125 }, 126 NULL 127 }, 128 {"group_prototype", "group_prototypeid", 0, 129 { 130 {"group_prototypeid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 131 {"hostid", NULL, "hosts", "hostid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 132 {"name", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 133 {"groupid", NULL, "groups", "groupid", 0, ZBX_TYPE_ID, 0, 0}, 134 {"templateid", NULL, "group_prototype", "group_prototypeid", 0, ZBX_TYPE_ID, 0, ZBX_FK_CASCADE_DELETE}, 135 {0} 136 }, 137 NULL 138 }, 139 {"group_discovery", "groupid", 0, 140 { 141 {"groupid", NULL, "groups", "groupid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 142 {"parent_group_prototypeid", NULL, "group_prototype", "group_prototypeid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 143 {"name", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 144 {"lastcheck", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 145 {"ts_delete", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 146 {0} 147 }, 148 NULL 149 }, 150 {"screens", "screenid", 0, 151 { 152 {"screenid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 153 {"name", NULL, NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 154 {"hsize", "1", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 155 {"vsize", "1", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 156 {"templateid", NULL, "hosts", "hostid", 0, ZBX_TYPE_ID, 0, ZBX_FK_CASCADE_DELETE}, 157 {"userid", NULL, "users", "userid", 0, ZBX_TYPE_ID, 0, 0}, 158 {"private", "1", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 159 {0} 160 }, 161 NULL 162 }, 163 {"screens_items", "screenitemid", 0, 164 { 165 {"screenitemid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 166 {"screenid", NULL, "screens", "screenid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 167 {"resourcetype", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 168 {"resourceid", "0", NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 169 {"width", "320", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 170 {"height", "200", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 171 {"x", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 172 {"y", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 173 {"colspan", "1", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 174 {"rowspan", "1", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 175 {"elements", "25", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 176 {"valign", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 177 {"halign", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 178 {"style", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 179 {"url", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 180 {"dynamic", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 181 {"sort_triggers", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 182 {"application", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 183 {"max_columns", "3", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 184 {0} 185 }, 186 NULL 187 }, 188 {"screen_user", "screenuserid", 0, 189 { 190 {"screenuserid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 191 {"screenid", NULL, "screens", "screenid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 192 {"userid", NULL, "users", "userid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 193 {"permission", "2", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 194 {0} 195 }, 196 "screenid,userid" 197 }, 198 {"screen_usrgrp", "screenusrgrpid", 0, 199 { 200 {"screenusrgrpid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 201 {"screenid", NULL, "screens", "screenid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 202 {"usrgrpid", NULL, "usrgrp", "usrgrpid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 203 {"permission", "2", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 204 {0} 205 }, 206 "screenid,usrgrpid" 207 }, 208 {"slideshows", "slideshowid", 0, 209 { 210 {"slideshowid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 211 {"name", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 212 {"delay", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 213 {"userid", NULL, "users", "userid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 214 {"private", "1", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 215 {0} 216 }, 217 "name" 218 }, 219 {"slideshow_user", "slideshowuserid", 0, 220 { 221 {"slideshowuserid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 222 {"slideshowid", NULL, "slideshows", "slideshowid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 223 {"userid", NULL, "users", "userid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 224 {"permission", "2", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 225 {0} 226 }, 227 "slideshowid,userid" 228 }, 229 {"slideshow_usrgrp", "slideshowusrgrpid", 0, 230 { 231 {"slideshowusrgrpid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 232 {"slideshowid", NULL, "slideshows", "slideshowid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 233 {"usrgrpid", NULL, "usrgrp", "usrgrpid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 234 {"permission", "2", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 235 {0} 236 }, 237 "slideshowid,usrgrpid" 238 }, 239 {"slides", "slideid", 0, 240 { 241 {"slideid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 242 {"slideshowid", NULL, "slideshows", "slideshowid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 243 {"screenid", NULL, "screens", "screenid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 244 {"step", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 245 {"delay", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 246 {0} 247 }, 248 NULL 249 }, 250 {"drules", "druleid", 0, 251 { 252 {"druleid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 253 {"proxy_hostid", NULL, "hosts", "hostid", 0, ZBX_TYPE_ID, 0, 0}, 254 {"name", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 255 {"iprange", "", NULL, NULL, 2048, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 256 {"delay", "3600", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL | ZBX_PROXY, 0}, 257 {"nextcheck", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 258 {"status", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 259 {0} 260 }, 261 "name" 262 }, 263 {"dchecks", "dcheckid", 0, 264 { 265 {"dcheckid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 266 {"druleid", NULL, "drules", "druleid", 0, ZBX_TYPE_ID, ZBX_NOTNULL | ZBX_PROXY, ZBX_FK_CASCADE_DELETE}, 267 {"type", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL | ZBX_PROXY, 0}, 268 {"key_", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 269 {"snmp_community", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 270 {"ports", "0", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 271 {"snmpv3_securityname", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 272 {"snmpv3_securitylevel", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL | ZBX_PROXY, 0}, 273 {"snmpv3_authpassphrase", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 274 {"snmpv3_privpassphrase", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 275 {"uniq", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL | ZBX_PROXY, 0}, 276 {"snmpv3_authprotocol", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL | ZBX_PROXY, 0}, 277 {"snmpv3_privprotocol", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL | ZBX_PROXY, 0}, 278 {"snmpv3_contextname", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 279 {0} 280 }, 281 NULL 282 }, 283 {"applications", "applicationid", 0, 284 { 285 {"applicationid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 286 {"hostid", NULL, "hosts", "hostid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 287 {"name", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 288 {"flags", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 289 {0} 290 }, 291 "hostid,name" 292 }, 293 {"httptest", "httptestid", 0, 294 { 295 {"httptestid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 296 {"name", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 297 {"applicationid", NULL, "applications", "applicationid", 0, ZBX_TYPE_ID, 0, 0}, 298 {"nextcheck", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 299 {"delay", "60", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL | ZBX_PROXY, 0}, 300 {"status", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 301 {"variables", "", NULL, NULL, ZBX_TYPE_SHORTTEXT_LEN, ZBX_TYPE_SHORTTEXT, ZBX_NOTNULL | ZBX_PROXY, 0}, 302 {"agent", "Zabbix", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 303 {"authentication", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL | ZBX_PROXY, 0}, 304 {"http_user", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 305 {"http_password", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 306 {"hostid", NULL, "hosts", "hostid", 0, ZBX_TYPE_ID, ZBX_NOTNULL | ZBX_PROXY, ZBX_FK_CASCADE_DELETE}, 307 {"templateid", NULL, "httptest", "httptestid", 0, ZBX_TYPE_ID, 0, ZBX_FK_CASCADE_DELETE}, 308 {"http_proxy", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 309 {"retries", "1", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL | ZBX_PROXY, 0}, 310 {"ssl_cert_file", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 311 {"ssl_key_file", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 312 {"ssl_key_password", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 313 {"verify_peer", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL | ZBX_PROXY, 0}, 314 {"verify_host", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL | ZBX_PROXY, 0}, 315 {"headers", "", NULL, NULL, ZBX_TYPE_SHORTTEXT_LEN, ZBX_TYPE_SHORTTEXT, ZBX_NOTNULL | ZBX_PROXY, 0}, 316 {0} 317 }, 318 "hostid,name" 319 }, 320 {"httpstep", "httpstepid", 0, 321 { 322 {"httpstepid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 323 {"httptestid", NULL, "httptest", "httptestid", 0, ZBX_TYPE_ID, ZBX_NOTNULL | ZBX_PROXY, ZBX_FK_CASCADE_DELETE}, 324 {"name", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 325 {"no", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL | ZBX_PROXY, 0}, 326 {"url", "", NULL, NULL, 2048, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 327 {"timeout", "15", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL | ZBX_PROXY, 0}, 328 {"posts", "", NULL, NULL, ZBX_TYPE_SHORTTEXT_LEN, ZBX_TYPE_SHORTTEXT, ZBX_NOTNULL | ZBX_PROXY, 0}, 329 {"required", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 330 {"status_codes", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 331 {"variables", "", NULL, NULL, ZBX_TYPE_SHORTTEXT_LEN, ZBX_TYPE_SHORTTEXT, ZBX_NOTNULL | ZBX_PROXY, 0}, 332 {"follow_redirects", "1", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL | ZBX_PROXY, 0}, 333 {"retrieve_mode", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL | ZBX_PROXY, 0}, 334 {"headers", "", NULL, NULL, ZBX_TYPE_SHORTTEXT_LEN, ZBX_TYPE_SHORTTEXT, ZBX_NOTNULL | ZBX_PROXY, 0}, 335 {0} 336 }, 337 NULL 338 }, 339 {"interface", "interfaceid", 0, 340 { 341 {"interfaceid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 342 {"hostid", NULL, "hosts", "hostid", 0, ZBX_TYPE_ID, ZBX_NOTNULL | ZBX_PROXY, ZBX_FK_CASCADE_DELETE}, 343 {"main", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL | ZBX_PROXY, 0}, 344 {"type", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL | ZBX_PROXY, 0}, 345 {"useip", "1", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL | ZBX_PROXY, 0}, 346 {"ip", "127.0.0.1", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 347 {"dns", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 348 {"port", "10050", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 349 {"bulk", "1", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL | ZBX_PROXY, 0}, 350 {0} 351 }, 352 NULL 353 }, 354 {"valuemaps", "valuemapid", 0, 355 { 356 {"valuemapid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 357 {"name", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 358 {0} 359 }, 360 "name" 361 }, 362 {"items", "itemid", 0, 363 { 364 {"itemid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 365 {"type", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL | ZBX_PROXY, 0}, 366 {"snmp_community", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 367 {"snmp_oid", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 368 {"hostid", NULL, "hosts", "hostid", 0, ZBX_TYPE_ID, ZBX_NOTNULL | ZBX_PROXY, ZBX_FK_CASCADE_DELETE}, 369 {"name", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 370 {"key_", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 371 {"delay", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL | ZBX_PROXY, 0}, 372 {"history", "90", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 373 {"trends", "365", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 374 {"status", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL | ZBX_PROXY, 0}, 375 {"value_type", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL | ZBX_PROXY, 0}, 376 {"trapper_hosts", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 377 {"units", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 378 {"multiplier", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 379 {"delta", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 380 {"snmpv3_securityname", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 381 {"snmpv3_securitylevel", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL | ZBX_PROXY, 0}, 382 {"snmpv3_authpassphrase", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 383 {"snmpv3_privpassphrase", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 384 {"formula", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 385 {"error", "", NULL, NULL, 2048, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 386 {"lastlogsize", "0", NULL, NULL, 0, ZBX_TYPE_UINT, ZBX_NOTNULL | ZBX_PROXY, 0}, 387 {"logtimefmt", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 388 {"templateid", NULL, "items", "itemid", 0, ZBX_TYPE_ID, 0, ZBX_FK_CASCADE_DELETE}, 389 {"valuemapid", NULL, "valuemaps", "valuemapid", 0, ZBX_TYPE_ID, 0, 0}, 390 {"delay_flex", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 391 {"params", "", NULL, NULL, ZBX_TYPE_SHORTTEXT_LEN, ZBX_TYPE_SHORTTEXT, ZBX_NOTNULL | ZBX_PROXY, 0}, 392 {"ipmi_sensor", "", NULL, NULL, 128, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 393 {"data_type", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL | ZBX_PROXY, 0}, 394 {"authtype", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL | ZBX_PROXY, 0}, 395 {"username", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 396 {"password", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 397 {"publickey", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 398 {"privatekey", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 399 {"mtime", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL | ZBX_PROXY, 0}, 400 {"flags", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL | ZBX_PROXY, 0}, 401 {"interfaceid", NULL, "interface", "interfaceid", 0, ZBX_TYPE_ID, ZBX_PROXY, 0}, 402 {"port", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 403 {"description", "", NULL, NULL, ZBX_TYPE_SHORTTEXT_LEN, ZBX_TYPE_SHORTTEXT, ZBX_NOTNULL, 0}, 404 {"inventory_link", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 405 {"lifetime", "30", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 406 {"snmpv3_authprotocol", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL | ZBX_PROXY, 0}, 407 {"snmpv3_privprotocol", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL | ZBX_PROXY, 0}, 408 {"state", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 409 {"snmpv3_contextname", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 410 {"evaltype", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 411 {0} 412 }, 413 "hostid,key_" 414 }, 415 {"httpstepitem", "httpstepitemid", 0, 416 { 417 {"httpstepitemid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 418 {"httpstepid", NULL, "httpstep", "httpstepid", 0, ZBX_TYPE_ID, ZBX_NOTNULL | ZBX_PROXY, ZBX_FK_CASCADE_DELETE}, 419 {"itemid", NULL, "items", "itemid", 0, ZBX_TYPE_ID, ZBX_NOTNULL | ZBX_PROXY, ZBX_FK_CASCADE_DELETE}, 420 {"type", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL | ZBX_PROXY, 0}, 421 {0} 422 }, 423 "httpstepid,itemid" 424 }, 425 {"httptestitem", "httptestitemid", 0, 426 { 427 {"httptestitemid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 428 {"httptestid", NULL, "httptest", "httptestid", 0, ZBX_TYPE_ID, ZBX_NOTNULL | ZBX_PROXY, ZBX_FK_CASCADE_DELETE}, 429 {"itemid", NULL, "items", "itemid", 0, ZBX_TYPE_ID, ZBX_NOTNULL | ZBX_PROXY, ZBX_FK_CASCADE_DELETE}, 430 {"type", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL | ZBX_PROXY, 0}, 431 {0} 432 }, 433 "httptestid,itemid" 434 }, 435 {"media_type", "mediatypeid", 0, 436 { 437 {"mediatypeid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 438 {"type", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 439 {"description", "", NULL, NULL, 100, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 440 {"smtp_server", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 441 {"smtp_helo", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 442 {"smtp_email", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 443 {"exec_path", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 444 {"gsm_modem", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 445 {"username", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 446 {"passwd", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 447 {"status", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 448 {"smtp_port", "25", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 449 {"smtp_security", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 450 {"smtp_verify_peer", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 451 {"smtp_verify_host", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 452 {"smtp_authentication", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 453 {"exec_params", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 454 {0} 455 }, 456 "description" 457 }, 458 {"usrgrp", "usrgrpid", 0, 459 { 460 {"usrgrpid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 461 {"name", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 462 {"gui_access", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 463 {"users_status", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 464 {"debug_mode", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 465 {0} 466 }, 467 "name" 468 }, 469 {"users_groups", "id", 0, 470 { 471 {"id", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 472 {"usrgrpid", NULL, "usrgrp", "usrgrpid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 473 {"userid", NULL, "users", "userid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 474 {0} 475 }, 476 "usrgrpid,userid" 477 }, 478 {"scripts", "scriptid", 0, 479 { 480 {"scriptid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 481 {"name", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 482 {"command", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 483 {"host_access", "2", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 484 {"usrgrpid", NULL, "usrgrp", "usrgrpid", 0, ZBX_TYPE_ID, 0, 0}, 485 {"groupid", NULL, "groups", "groupid", 0, ZBX_TYPE_ID, 0, 0}, 486 {"description", "", NULL, NULL, ZBX_TYPE_SHORTTEXT_LEN, ZBX_TYPE_SHORTTEXT, ZBX_NOTNULL, 0}, 487 {"confirmation", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 488 {"type", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 489 {"execute_on", "1", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 490 {0} 491 }, 492 "name" 493 }, 494 {"actions", "actionid", 0, 495 { 496 {"actionid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 497 {"name", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 498 {"eventsource", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 499 {"evaltype", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 500 {"status", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 501 {"esc_period", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 502 {"def_shortdata", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 503 {"def_longdata", "", NULL, NULL, ZBX_TYPE_SHORTTEXT_LEN, ZBX_TYPE_SHORTTEXT, ZBX_NOTNULL, 0}, 504 {"recovery_msg", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 505 {"r_shortdata", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 506 {"r_longdata", "", NULL, NULL, ZBX_TYPE_SHORTTEXT_LEN, ZBX_TYPE_SHORTTEXT, ZBX_NOTNULL, 0}, 507 {"formula", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 508 {0} 509 }, 510 "name" 511 }, 512 {"operations", "operationid", 0, 513 { 514 {"operationid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 515 {"actionid", NULL, "actions", "actionid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 516 {"operationtype", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 517 {"esc_period", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 518 {"esc_step_from", "1", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 519 {"esc_step_to", "1", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 520 {"evaltype", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 521 {0} 522 }, 523 NULL 524 }, 525 {"opmessage", "operationid", 0, 526 { 527 {"operationid", NULL, "operations", "operationid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 528 {"default_msg", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 529 {"subject", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 530 {"message", "", NULL, NULL, ZBX_TYPE_SHORTTEXT_LEN, ZBX_TYPE_SHORTTEXT, ZBX_NOTNULL, 0}, 531 {"mediatypeid", NULL, "media_type", "mediatypeid", 0, ZBX_TYPE_ID, 0, 0}, 532 {0} 533 }, 534 NULL 535 }, 536 {"opmessage_grp", "opmessage_grpid", 0, 537 { 538 {"opmessage_grpid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 539 {"operationid", NULL, "operations", "operationid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 540 {"usrgrpid", NULL, "usrgrp", "usrgrpid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 541 {0} 542 }, 543 "operationid,usrgrpid" 544 }, 545 {"opmessage_usr", "opmessage_usrid", 0, 546 { 547 {"opmessage_usrid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 548 {"operationid", NULL, "operations", "operationid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 549 {"userid", NULL, "users", "userid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 550 {0} 551 }, 552 "operationid,userid" 553 }, 554 {"opcommand", "operationid", 0, 555 { 556 {"operationid", NULL, "operations", "operationid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 557 {"type", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 558 {"scriptid", NULL, "scripts", "scriptid", 0, ZBX_TYPE_ID, 0, 0}, 559 {"execute_on", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 560 {"port", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 561 {"authtype", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 562 {"username", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 563 {"password", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 564 {"publickey", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 565 {"privatekey", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 566 {"command", "", NULL, NULL, ZBX_TYPE_SHORTTEXT_LEN, ZBX_TYPE_SHORTTEXT, ZBX_NOTNULL, 0}, 567 {0} 568 }, 569 NULL 570 }, 571 {"opcommand_hst", "opcommand_hstid", 0, 572 { 573 {"opcommand_hstid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 574 {"operationid", NULL, "operations", "operationid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 575 {"hostid", NULL, "hosts", "hostid", 0, ZBX_TYPE_ID, 0, 0}, 576 {0} 577 }, 578 NULL 579 }, 580 {"opcommand_grp", "opcommand_grpid", 0, 581 { 582 {"opcommand_grpid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 583 {"operationid", NULL, "operations", "operationid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 584 {"groupid", NULL, "groups", "groupid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 585 {0} 586 }, 587 NULL 588 }, 589 {"opgroup", "opgroupid", 0, 590 { 591 {"opgroupid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 592 {"operationid", NULL, "operations", "operationid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 593 {"groupid", NULL, "groups", "groupid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 594 {0} 595 }, 596 "operationid,groupid" 597 }, 598 {"optemplate", "optemplateid", 0, 599 { 600 {"optemplateid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 601 {"operationid", NULL, "operations", "operationid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 602 {"templateid", NULL, "hosts", "hostid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 603 {0} 604 }, 605 "operationid,templateid" 606 }, 607 {"opconditions", "opconditionid", 0, 608 { 609 {"opconditionid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 610 {"operationid", NULL, "operations", "operationid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 611 {"conditiontype", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 612 {"operator", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 613 {"value", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 614 {0} 615 }, 616 NULL 617 }, 618 {"conditions", "conditionid", 0, 619 { 620 {"conditionid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 621 {"actionid", NULL, "actions", "actionid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 622 {"conditiontype", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 623 {"operator", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 624 {"value", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 625 {0} 626 }, 627 NULL 628 }, 629 {"config", "configid", 0, 630 { 631 {"configid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 632 {"refresh_unsupported", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL | ZBX_PROXY, 0}, 633 {"work_period", "1-5,00:00-24:00", NULL, NULL, 100, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 634 {"alert_usrgrpid", NULL, "usrgrp", "usrgrpid", 0, ZBX_TYPE_ID, 0, 0}, 635 {"event_ack_enable", "1", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 636 {"event_expire", "7", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 637 {"event_show_max", "100", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 638 {"default_theme", "blue-theme", NULL, NULL, 128, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 639 {"authentication_type", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 640 {"ldap_host", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 641 {"ldap_port", "389", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 642 {"ldap_base_dn", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 643 {"ldap_bind_dn", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 644 {"ldap_bind_password", "", NULL, NULL, 128, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 645 {"ldap_search_attribute", "", NULL, NULL, 128, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 646 {"dropdown_first_entry", "1", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 647 {"dropdown_first_remember", "1", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 648 {"discovery_groupid", NULL, "groups", "groupid", 0, ZBX_TYPE_ID, ZBX_NOTNULL | ZBX_PROXY, 0}, 649 {"max_in_table", "50", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 650 {"search_limit", "1000", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 651 {"severity_color_0", "97AAB3", NULL, NULL, 6, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 652 {"severity_color_1", "7499FF", NULL, NULL, 6, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 653 {"severity_color_2", "FFC859", NULL, NULL, 6, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 654 {"severity_color_3", "FFA059", NULL, NULL, 6, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 655 {"severity_color_4", "E97659", NULL, NULL, 6, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 656 {"severity_color_5", "E45959", NULL, NULL, 6, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 657 {"severity_name_0", "Not classified", NULL, NULL, 32, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 658 {"severity_name_1", "Information", NULL, NULL, 32, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 659 {"severity_name_2", "Warning", NULL, NULL, 32, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 660 {"severity_name_3", "Average", NULL, NULL, 32, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 661 {"severity_name_4", "High", NULL, NULL, 32, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 662 {"severity_name_5", "Disaster", NULL, NULL, 32, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 663 {"ok_period", "1800", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 664 {"blink_period", "1800", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 665 {"problem_unack_color", "DC0000", NULL, NULL, 6, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 666 {"problem_ack_color", "DC0000", NULL, NULL, 6, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 667 {"ok_unack_color", "00AA00", NULL, NULL, 6, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 668 {"ok_ack_color", "00AA00", NULL, NULL, 6, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 669 {"problem_unack_style", "1", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 670 {"problem_ack_style", "1", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 671 {"ok_unack_style", "1", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 672 {"ok_ack_style", "1", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 673 {"snmptrap_logging", "1", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL | ZBX_PROXY, 0}, 674 {"server_check_interval", "10", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 675 {"hk_events_mode", "1", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 676 {"hk_events_trigger", "365", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 677 {"hk_events_internal", "365", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 678 {"hk_events_discovery", "365", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 679 {"hk_events_autoreg", "365", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 680 {"hk_services_mode", "1", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 681 {"hk_services", "365", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 682 {"hk_audit_mode", "1", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 683 {"hk_audit", "365", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 684 {"hk_sessions_mode", "1", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 685 {"hk_sessions", "365", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 686 {"hk_history_mode", "1", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 687 {"hk_history_global", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 688 {"hk_history", "90", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 689 {"hk_trends_mode", "1", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 690 {"hk_trends_global", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 691 {"hk_trends", "365", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 692 {"default_inventory_mode", "-1", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 693 {0} 694 }, 695 NULL 696 }, 697 {"triggers", "triggerid", 0, 698 { 699 {"triggerid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 700 {"expression", "", NULL, NULL, 2048, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 701 {"description", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 702 {"url", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 703 {"status", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 704 {"value", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 705 {"priority", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 706 {"lastchange", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 707 {"comments", "", NULL, NULL, ZBX_TYPE_SHORTTEXT_LEN, ZBX_TYPE_SHORTTEXT, ZBX_NOTNULL, 0}, 708 {"error", "", NULL, NULL, 128, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 709 {"templateid", NULL, "triggers", "triggerid", 0, ZBX_TYPE_ID, 0, ZBX_FK_CASCADE_DELETE}, 710 {"type", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 711 {"state", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 712 {"flags", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 713 {0} 714 }, 715 NULL 716 }, 717 {"trigger_depends", "triggerdepid", 0, 718 { 719 {"triggerdepid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 720 {"triggerid_down", NULL, "triggers", "triggerid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 721 {"triggerid_up", NULL, "triggers", "triggerid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 722 {0} 723 }, 724 "triggerid_down,triggerid_up" 725 }, 726 {"functions", "functionid", 0, 727 { 728 {"functionid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 729 {"itemid", NULL, "items", "itemid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 730 {"triggerid", NULL, "triggers", "triggerid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 731 {"function", "", NULL, NULL, 12, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 732 {"parameter", "0", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 733 {0} 734 }, 735 NULL 736 }, 737 {"graphs", "graphid", 0, 738 { 739 {"graphid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 740 {"name", "", NULL, NULL, 128, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 741 {"width", "900", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 742 {"height", "200", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 743 {"yaxismin", "0", NULL, NULL, 0, ZBX_TYPE_FLOAT, ZBX_NOTNULL, 0}, 744 {"yaxismax", "100", NULL, NULL, 0, ZBX_TYPE_FLOAT, ZBX_NOTNULL, 0}, 745 {"templateid", NULL, "graphs", "graphid", 0, ZBX_TYPE_ID, 0, ZBX_FK_CASCADE_DELETE}, 746 {"show_work_period", "1", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 747 {"show_triggers", "1", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 748 {"graphtype", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 749 {"show_legend", "1", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 750 {"show_3d", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 751 {"percent_left", "0", NULL, NULL, 0, ZBX_TYPE_FLOAT, ZBX_NOTNULL, 0}, 752 {"percent_right", "0", NULL, NULL, 0, ZBX_TYPE_FLOAT, ZBX_NOTNULL, 0}, 753 {"ymin_type", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 754 {"ymax_type", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 755 {"ymin_itemid", NULL, "items", "itemid", 0, ZBX_TYPE_ID, 0, 0}, 756 {"ymax_itemid", NULL, "items", "itemid", 0, ZBX_TYPE_ID, 0, 0}, 757 {"flags", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 758 {0} 759 }, 760 NULL 761 }, 762 {"graphs_items", "gitemid", 0, 763 { 764 {"gitemid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 765 {"graphid", NULL, "graphs", "graphid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 766 {"itemid", NULL, "items", "itemid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 767 {"drawtype", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 768 {"sortorder", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 769 {"color", "009600", NULL, NULL, 6, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 770 {"yaxisside", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 771 {"calc_fnc", "2", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 772 {"type", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 773 {0} 774 }, 775 NULL 776 }, 777 {"graph_theme", "graphthemeid", 0, 778 { 779 {"graphthemeid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 780 {"theme", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 781 {"backgroundcolor", "", NULL, NULL, 6, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 782 {"graphcolor", "", NULL, NULL, 6, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 783 {"gridcolor", "", NULL, NULL, 6, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 784 {"maingridcolor", "", NULL, NULL, 6, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 785 {"gridbordercolor", "", NULL, NULL, 6, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 786 {"textcolor", "", NULL, NULL, 6, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 787 {"highlightcolor", "", NULL, NULL, 6, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 788 {"leftpercentilecolor", "", NULL, NULL, 6, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 789 {"rightpercentilecolor", "", NULL, NULL, 6, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 790 {"nonworktimecolor", "", NULL, NULL, 6, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 791 {0} 792 }, 793 "theme" 794 }, 795 {"globalmacro", "globalmacroid", 0, 796 { 797 {"globalmacroid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 798 {"macro", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 799 {"value", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 800 {0} 801 }, 802 "macro" 803 }, 804 {"hostmacro", "hostmacroid", 0, 805 { 806 {"hostmacroid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 807 {"hostid", NULL, "hosts", "hostid", 0, ZBX_TYPE_ID, ZBX_NOTNULL | ZBX_PROXY, ZBX_FK_CASCADE_DELETE}, 808 {"macro", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 809 {"value", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 810 {0} 811 }, 812 "hostid,macro" 813 }, 814 {"hosts_groups", "hostgroupid", 0, 815 { 816 {"hostgroupid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 817 {"hostid", NULL, "hosts", "hostid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 818 {"groupid", NULL, "groups", "groupid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 819 {0} 820 }, 821 "hostid,groupid" 822 }, 823 {"hosts_templates", "hosttemplateid", 0, 824 { 825 {"hosttemplateid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 826 {"hostid", NULL, "hosts", "hostid", 0, ZBX_TYPE_ID, ZBX_NOTNULL | ZBX_PROXY, ZBX_FK_CASCADE_DELETE}, 827 {"templateid", NULL, "hosts", "hostid", 0, ZBX_TYPE_ID, ZBX_NOTNULL | ZBX_PROXY, ZBX_FK_CASCADE_DELETE}, 828 {0} 829 }, 830 "hostid,templateid" 831 }, 832 {"items_applications", "itemappid", 0, 833 { 834 {"itemappid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 835 {"applicationid", NULL, "applications", "applicationid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 836 {"itemid", NULL, "items", "itemid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 837 {0} 838 }, 839 "applicationid,itemid" 840 }, 841 {"mappings", "mappingid", 0, 842 { 843 {"mappingid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 844 {"valuemapid", NULL, "valuemaps", "valuemapid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 845 {"value", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 846 {"newvalue", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 847 {0} 848 }, 849 NULL 850 }, 851 {"media", "mediaid", 0, 852 { 853 {"mediaid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 854 {"userid", NULL, "users", "userid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 855 {"mediatypeid", NULL, "media_type", "mediatypeid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 856 {"sendto", "", NULL, NULL, 100, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 857 {"active", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 858 {"severity", "63", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 859 {"period", "1-7,00:00-24:00", NULL, NULL, 100, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 860 {0} 861 }, 862 NULL 863 }, 864 {"rights", "rightid", 0, 865 { 866 {"rightid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 867 {"groupid", NULL, "usrgrp", "usrgrpid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 868 {"permission", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 869 {"id", NULL, "groups", "groupid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 870 {0} 871 }, 872 NULL 873 }, 874 {"services", "serviceid", 0, 875 { 876 {"serviceid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 877 {"name", "", NULL, NULL, 128, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 878 {"status", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 879 {"algorithm", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 880 {"triggerid", NULL, "triggers", "triggerid", 0, ZBX_TYPE_ID, 0, ZBX_FK_CASCADE_DELETE}, 881 {"showsla", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 882 {"goodsla", "99.9", NULL, NULL, 0, ZBX_TYPE_FLOAT, ZBX_NOTNULL, 0}, 883 {"sortorder", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 884 {0} 885 }, 886 NULL 887 }, 888 {"services_links", "linkid", 0, 889 { 890 {"linkid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 891 {"serviceupid", NULL, "services", "serviceid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 892 {"servicedownid", NULL, "services", "serviceid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 893 {"soft", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 894 {0} 895 }, 896 "serviceupid,servicedownid" 897 }, 898 {"services_times", "timeid", 0, 899 { 900 {"timeid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 901 {"serviceid", NULL, "services", "serviceid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 902 {"type", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 903 {"ts_from", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 904 {"ts_to", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 905 {"note", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 906 {0} 907 }, 908 NULL 909 }, 910 {"icon_map", "iconmapid", 0, 911 { 912 {"iconmapid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 913 {"name", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 914 {"default_iconid", NULL, "images", "imageid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 915 {0} 916 }, 917 "name" 918 }, 919 {"icon_mapping", "iconmappingid", 0, 920 { 921 {"iconmappingid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 922 {"iconmapid", NULL, "icon_map", "iconmapid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 923 {"iconid", NULL, "images", "imageid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 924 {"inventory_link", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 925 {"expression", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 926 {"sortorder", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 927 {0} 928 }, 929 NULL 930 }, 931 {"sysmaps", "sysmapid", 0, 932 { 933 {"sysmapid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 934 {"name", "", NULL, NULL, 128, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 935 {"width", "600", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 936 {"height", "400", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 937 {"backgroundid", NULL, "images", "imageid", 0, ZBX_TYPE_ID, 0, 0}, 938 {"label_type", "2", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 939 {"label_location", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 940 {"highlight", "1", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 941 {"expandproblem", "1", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 942 {"markelements", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 943 {"show_unack", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 944 {"grid_size", "50", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 945 {"grid_show", "1", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 946 {"grid_align", "1", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 947 {"label_format", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 948 {"label_type_host", "2", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 949 {"label_type_hostgroup", "2", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 950 {"label_type_trigger", "2", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 951 {"label_type_map", "2", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 952 {"label_type_image", "2", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 953 {"label_string_host", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 954 {"label_string_hostgroup", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 955 {"label_string_trigger", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 956 {"label_string_map", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 957 {"label_string_image", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 958 {"iconmapid", NULL, "icon_map", "iconmapid", 0, ZBX_TYPE_ID, 0, 0}, 959 {"expand_macros", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 960 {"severity_min", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 961 {"userid", NULL, "users", "userid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 962 {"private", "1", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 963 {0} 964 }, 965 "name" 966 }, 967 {"sysmaps_elements", "selementid", 0, 968 { 969 {"selementid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 970 {"sysmapid", NULL, "sysmaps", "sysmapid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 971 {"elementid", "0", NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 972 {"elementtype", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 973 {"iconid_off", NULL, "images", "imageid", 0, ZBX_TYPE_ID, 0, 0}, 974 {"iconid_on", NULL, "images", "imageid", 0, ZBX_TYPE_ID, 0, 0}, 975 {"label", "", NULL, NULL, 2048, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 976 {"label_location", "-1", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 977 {"x", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 978 {"y", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 979 {"iconid_disabled", NULL, "images", "imageid", 0, ZBX_TYPE_ID, 0, 0}, 980 {"iconid_maintenance", NULL, "images", "imageid", 0, ZBX_TYPE_ID, 0, 0}, 981 {"elementsubtype", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 982 {"areatype", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 983 {"width", "200", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 984 {"height", "200", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 985 {"viewtype", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 986 {"use_iconmap", "1", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 987 {"application", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 988 {0} 989 }, 990 NULL 991 }, 992 {"sysmaps_links", "linkid", 0, 993 { 994 {"linkid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 995 {"sysmapid", NULL, "sysmaps", "sysmapid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 996 {"selementid1", NULL, "sysmaps_elements", "selementid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 997 {"selementid2", NULL, "sysmaps_elements", "selementid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 998 {"drawtype", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 999 {"color", "000000", NULL, NULL, 6, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1000 {"label", "", NULL, NULL, 2048, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1001 {0} 1002 }, 1003 NULL 1004 }, 1005 {"sysmaps_link_triggers", "linktriggerid", 0, 1006 { 1007 {"linktriggerid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 1008 {"linkid", NULL, "sysmaps_links", "linkid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1009 {"triggerid", NULL, "triggers", "triggerid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1010 {"drawtype", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1011 {"color", "000000", NULL, NULL, 6, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1012 {0} 1013 }, 1014 "linkid,triggerid" 1015 }, 1016 {"sysmap_element_url", "sysmapelementurlid", 0, 1017 { 1018 {"sysmapelementurlid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 1019 {"selementid", NULL, "sysmaps_elements", "selementid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1020 {"name", NULL, NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1021 {"url", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1022 {0} 1023 }, 1024 "selementid,name" 1025 }, 1026 {"sysmap_url", "sysmapurlid", 0, 1027 { 1028 {"sysmapurlid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 1029 {"sysmapid", NULL, "sysmaps", "sysmapid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1030 {"name", NULL, NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1031 {"url", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1032 {"elementtype", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1033 {0} 1034 }, 1035 "sysmapid,name" 1036 }, 1037 {"sysmap_user", "sysmapuserid", 0, 1038 { 1039 {"sysmapuserid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 1040 {"sysmapid", NULL, "sysmaps", "sysmapid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1041 {"userid", NULL, "users", "userid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1042 {"permission", "2", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1043 {0} 1044 }, 1045 "sysmapid,userid" 1046 }, 1047 {"sysmap_usrgrp", "sysmapusrgrpid", 0, 1048 { 1049 {"sysmapusrgrpid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 1050 {"sysmapid", NULL, "sysmaps", "sysmapid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1051 {"usrgrpid", NULL, "usrgrp", "usrgrpid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1052 {"permission", "2", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1053 {0} 1054 }, 1055 "sysmapid,usrgrpid" 1056 }, 1057 {"maintenances_hosts", "maintenance_hostid", 0, 1058 { 1059 {"maintenance_hostid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 1060 {"maintenanceid", NULL, "maintenances", "maintenanceid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1061 {"hostid", NULL, "hosts", "hostid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1062 {0} 1063 }, 1064 "maintenanceid,hostid" 1065 }, 1066 {"maintenances_groups", "maintenance_groupid", 0, 1067 { 1068 {"maintenance_groupid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 1069 {"maintenanceid", NULL, "maintenances", "maintenanceid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1070 {"groupid", NULL, "groups", "groupid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1071 {0} 1072 }, 1073 "maintenanceid,groupid" 1074 }, 1075 {"timeperiods", "timeperiodid", 0, 1076 { 1077 {"timeperiodid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 1078 {"timeperiod_type", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1079 {"every", "1", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1080 {"month", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1081 {"dayofweek", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1082 {"day", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1083 {"start_time", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1084 {"period", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1085 {"start_date", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1086 {0} 1087 }, 1088 NULL 1089 }, 1090 {"maintenances_windows", "maintenance_timeperiodid", 0, 1091 { 1092 {"maintenance_timeperiodid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 1093 {"maintenanceid", NULL, "maintenances", "maintenanceid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1094 {"timeperiodid", NULL, "timeperiods", "timeperiodid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1095 {0} 1096 }, 1097 "maintenanceid,timeperiodid" 1098 }, 1099 {"regexps", "regexpid", 0, 1100 { 1101 {"regexpid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 1102 {"name", "", NULL, NULL, 128, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 1103 {"test_string", "", NULL, NULL, ZBX_TYPE_SHORTTEXT_LEN, ZBX_TYPE_SHORTTEXT, ZBX_NOTNULL, 0}, 1104 {0} 1105 }, 1106 "name" 1107 }, 1108 {"expressions", "expressionid", 0, 1109 { 1110 {"expressionid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 1111 {"regexpid", NULL, "regexps", "regexpid", 0, ZBX_TYPE_ID, ZBX_NOTNULL | ZBX_PROXY, ZBX_FK_CASCADE_DELETE}, 1112 {"expression", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 1113 {"expression_type", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL | ZBX_PROXY, 0}, 1114 {"exp_delimiter", "", NULL, NULL, 1, ZBX_TYPE_CHAR, ZBX_NOTNULL | ZBX_PROXY, 0}, 1115 {"case_sensitive", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL | ZBX_PROXY, 0}, 1116 {0} 1117 }, 1118 NULL 1119 }, 1120 {"ids", "table_name,field_name", 0, 1121 { 1122 {"table_name", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1123 {"field_name", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1124 {"nextid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 1125 {0} 1126 }, 1127 NULL 1128 }, 1129 {"alerts", "alertid", 0, 1130 { 1131 {"alertid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 1132 {"actionid", NULL, "actions", "actionid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1133 {"eventid", NULL, "events", "eventid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1134 {"userid", NULL, "users", "userid", 0, ZBX_TYPE_ID, 0, ZBX_FK_CASCADE_DELETE}, 1135 {"clock", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1136 {"mediatypeid", NULL, "media_type", "mediatypeid", 0, ZBX_TYPE_ID, 0, ZBX_FK_CASCADE_DELETE}, 1137 {"sendto", "", NULL, NULL, 100, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1138 {"subject", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1139 {"message", "", NULL, NULL, ZBX_TYPE_TEXT_LEN, ZBX_TYPE_TEXT, ZBX_NOTNULL, 0}, 1140 {"status", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1141 {"retries", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1142 {"error", "", NULL, NULL, 128, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1143 {"esc_step", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1144 {"alerttype", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1145 {0} 1146 }, 1147 NULL 1148 }, 1149 {"history", "", 0, 1150 { 1151 {"itemid", NULL, "items", "itemid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1152 {"clock", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1153 {"value", "0.0000", NULL, NULL, 0, ZBX_TYPE_FLOAT, ZBX_NOTNULL, 0}, 1154 {"ns", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1155 {0} 1156 }, 1157 NULL 1158 }, 1159 {"history_uint", "", 0, 1160 { 1161 {"itemid", NULL, "items", "itemid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1162 {"clock", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1163 {"value", "0", NULL, NULL, 0, ZBX_TYPE_UINT, ZBX_NOTNULL, 0}, 1164 {"ns", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1165 {0} 1166 }, 1167 NULL 1168 }, 1169 {"history_str", "", 0, 1170 { 1171 {"itemid", NULL, "items", "itemid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1172 {"clock", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1173 {"value", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1174 {"ns", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1175 {0} 1176 }, 1177 NULL 1178 }, 1179 {"history_log", "id", 0, 1180 { 1181 {"id", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 1182 {"itemid", NULL, "items", "itemid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1183 {"clock", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1184 {"timestamp", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1185 {"source", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1186 {"severity", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1187 {"value", "", NULL, NULL, ZBX_TYPE_TEXT_LEN, ZBX_TYPE_TEXT, ZBX_NOTNULL, 0}, 1188 {"logeventid", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1189 {"ns", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1190 {0} 1191 }, 1192 "itemid,id" 1193 }, 1194 {"history_text", "id", 0, 1195 { 1196 {"id", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 1197 {"itemid", NULL, "items", "itemid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1198 {"clock", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1199 {"value", "", NULL, NULL, ZBX_TYPE_TEXT_LEN, ZBX_TYPE_TEXT, ZBX_NOTNULL, 0}, 1200 {"ns", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1201 {0} 1202 }, 1203 "itemid,id" 1204 }, 1205 {"proxy_history", "id", 0, 1206 { 1207 {"id", NULL, NULL, NULL, 0, ZBX_TYPE_UINT, ZBX_NOTNULL, 0}, 1208 {"itemid", NULL, "items", "itemid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1209 {"clock", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1210 {"timestamp", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1211 {"source", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1212 {"severity", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1213 {"value", "", NULL, NULL, ZBX_TYPE_LONGTEXT_LEN, ZBX_TYPE_LONGTEXT, ZBX_NOTNULL, 0}, 1214 {"logeventid", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1215 {"ns", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1216 {"state", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1217 {"lastlogsize", "0", NULL, NULL, 0, ZBX_TYPE_UINT, ZBX_NOTNULL, 0}, 1218 {"mtime", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1219 {"flags", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1220 {0} 1221 }, 1222 NULL 1223 }, 1224 {"proxy_dhistory", "id", 0, 1225 { 1226 {"id", NULL, NULL, NULL, 0, ZBX_TYPE_UINT, ZBX_NOTNULL, 0}, 1227 {"clock", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1228 {"druleid", NULL, "drules", "druleid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1229 {"type", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1230 {"ip", "", NULL, NULL, 39, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1231 {"port", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1232 {"key_", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1233 {"value", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1234 {"status", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1235 {"dcheckid", NULL, "dchecks", "dcheckid", 0, ZBX_TYPE_ID, 0, ZBX_FK_CASCADE_DELETE}, 1236 {"dns", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1237 {0} 1238 }, 1239 NULL 1240 }, 1241 {"events", "eventid", 0, 1242 { 1243 {"eventid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 1244 {"source", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1245 {"object", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1246 {"objectid", "0", NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 1247 {"clock", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1248 {"value", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1249 {"acknowledged", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1250 {"ns", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1251 {0} 1252 }, 1253 NULL 1254 }, 1255 {"trends", "itemid,clock", 0, 1256 { 1257 {"itemid", NULL, "items", "itemid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1258 {"clock", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1259 {"num", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1260 {"value_min", "0.0000", NULL, NULL, 0, ZBX_TYPE_FLOAT, ZBX_NOTNULL, 0}, 1261 {"value_avg", "0.0000", NULL, NULL, 0, ZBX_TYPE_FLOAT, ZBX_NOTNULL, 0}, 1262 {"value_max", "0.0000", NULL, NULL, 0, ZBX_TYPE_FLOAT, ZBX_NOTNULL, 0}, 1263 {0} 1264 }, 1265 NULL 1266 }, 1267 {"trends_uint", "itemid,clock", 0, 1268 { 1269 {"itemid", NULL, "items", "itemid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1270 {"clock", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1271 {"num", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1272 {"value_min", "0", NULL, NULL, 0, ZBX_TYPE_UINT, ZBX_NOTNULL, 0}, 1273 {"value_avg", "0", NULL, NULL, 0, ZBX_TYPE_UINT, ZBX_NOTNULL, 0}, 1274 {"value_max", "0", NULL, NULL, 0, ZBX_TYPE_UINT, ZBX_NOTNULL, 0}, 1275 {0} 1276 }, 1277 NULL 1278 }, 1279 {"acknowledges", "acknowledgeid", 0, 1280 { 1281 {"acknowledgeid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 1282 {"userid", NULL, "users", "userid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1283 {"eventid", NULL, "events", "eventid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1284 {"clock", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1285 {"message", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1286 {0} 1287 }, 1288 NULL 1289 }, 1290 {"auditlog", "auditid", 0, 1291 { 1292 {"auditid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 1293 {"userid", NULL, "users", "userid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1294 {"clock", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1295 {"action", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1296 {"resourcetype", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1297 {"details", "0", NULL, NULL, 128 , ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1298 {"ip", "", NULL, NULL, 39, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1299 {"resourceid", "0", NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 1300 {"resourcename", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1301 {0} 1302 }, 1303 NULL 1304 }, 1305 {"auditlog_details", "auditdetailid", 0, 1306 { 1307 {"auditdetailid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 1308 {"auditid", NULL, "auditlog", "auditid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1309 {"table_name", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1310 {"field_name", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1311 {"oldvalue", "", NULL, NULL, ZBX_TYPE_SHORTTEXT_LEN, ZBX_TYPE_SHORTTEXT, ZBX_NOTNULL, 0}, 1312 {"newvalue", "", NULL, NULL, ZBX_TYPE_SHORTTEXT_LEN, ZBX_TYPE_SHORTTEXT, ZBX_NOTNULL, 0}, 1313 {0} 1314 }, 1315 NULL 1316 }, 1317 {"service_alarms", "servicealarmid", 0, 1318 { 1319 {"servicealarmid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 1320 {"serviceid", NULL, "services", "serviceid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1321 {"clock", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1322 {"value", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1323 {0} 1324 }, 1325 NULL 1326 }, 1327 {"autoreg_host", "autoreg_hostid", 0, 1328 { 1329 {"autoreg_hostid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 1330 {"proxy_hostid", NULL, "hosts", "hostid", 0, ZBX_TYPE_ID, 0, ZBX_FK_CASCADE_DELETE}, 1331 {"host", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1332 {"listen_ip", "", NULL, NULL, 39, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1333 {"listen_port", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1334 {"listen_dns", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1335 {"host_metadata", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1336 {0} 1337 }, 1338 NULL 1339 }, 1340 {"proxy_autoreg_host", "id", 0, 1341 { 1342 {"id", NULL, NULL, NULL, 0, ZBX_TYPE_UINT, ZBX_NOTNULL, 0}, 1343 {"clock", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1344 {"host", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1345 {"listen_ip", "", NULL, NULL, 39, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1346 {"listen_port", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1347 {"listen_dns", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1348 {"host_metadata", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1349 {0} 1350 }, 1351 NULL 1352 }, 1353 {"dhosts", "dhostid", 0, 1354 { 1355 {"dhostid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 1356 {"druleid", NULL, "drules", "druleid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1357 {"status", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1358 {"lastup", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1359 {"lastdown", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1360 {0} 1361 }, 1362 NULL 1363 }, 1364 {"dservices", "dserviceid", 0, 1365 { 1366 {"dserviceid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 1367 {"dhostid", NULL, "dhosts", "dhostid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1368 {"type", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1369 {"key_", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1370 {"value", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1371 {"port", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1372 {"status", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1373 {"lastup", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1374 {"lastdown", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1375 {"dcheckid", NULL, "dchecks", "dcheckid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1376 {"ip", "", NULL, NULL, 39, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1377 {"dns", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1378 {0} 1379 }, 1380 "dcheckid,type,key_,ip,port" 1381 }, 1382 {"escalations", "escalationid", 0, 1383 { 1384 {"escalationid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 1385 {"actionid", NULL, "actions", "actionid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1386 {"triggerid", NULL, "triggers", "triggerid", 0, ZBX_TYPE_ID, 0, ZBX_FK_CASCADE_DELETE}, 1387 {"eventid", NULL, "events", "eventid", 0, ZBX_TYPE_ID, 0, ZBX_FK_CASCADE_DELETE}, 1388 {"r_eventid", NULL, "events", "eventid", 0, ZBX_TYPE_ID, 0, ZBX_FK_CASCADE_DELETE}, 1389 {"nextcheck", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1390 {"esc_step", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1391 {"status", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1392 {"itemid", NULL, "items", "itemid", 0, ZBX_TYPE_ID, 0, ZBX_FK_CASCADE_DELETE}, 1393 {0} 1394 }, 1395 "actionid,triggerid,itemid,escalationid" 1396 }, 1397 {"globalvars", "globalvarid", 0, 1398 { 1399 {"globalvarid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 1400 {"snmp_lastsize", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1401 {0} 1402 }, 1403 NULL 1404 }, 1405 {"graph_discovery", "graphid", 0, 1406 { 1407 {"graphid", NULL, "graphs", "graphid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1408 {"parent_graphid", NULL, "graphs", "graphid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 1409 {0} 1410 }, 1411 NULL 1412 }, 1413 {"host_inventory", "hostid", 0, 1414 { 1415 {"hostid", NULL, "hosts", "hostid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1416 {"inventory_mode", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1417 {"type", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1418 {"type_full", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1419 {"name", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1420 {"alias", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1421 {"os", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1422 {"os_full", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1423 {"os_short", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1424 {"serialno_a", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1425 {"serialno_b", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1426 {"tag", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1427 {"asset_tag", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1428 {"macaddress_a", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1429 {"macaddress_b", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1430 {"hardware", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1431 {"hardware_full", "", NULL, NULL, ZBX_TYPE_SHORTTEXT_LEN, ZBX_TYPE_SHORTTEXT, ZBX_NOTNULL, 0}, 1432 {"software", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1433 {"software_full", "", NULL, NULL, ZBX_TYPE_SHORTTEXT_LEN, ZBX_TYPE_SHORTTEXT, ZBX_NOTNULL, 0}, 1434 {"software_app_a", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1435 {"software_app_b", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1436 {"software_app_c", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1437 {"software_app_d", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1438 {"software_app_e", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1439 {"contact", "", NULL, NULL, ZBX_TYPE_SHORTTEXT_LEN, ZBX_TYPE_SHORTTEXT, ZBX_NOTNULL, 0}, 1440 {"location", "", NULL, NULL, ZBX_TYPE_SHORTTEXT_LEN, ZBX_TYPE_SHORTTEXT, ZBX_NOTNULL, 0}, 1441 {"location_lat", "", NULL, NULL, 16, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1442 {"location_lon", "", NULL, NULL, 16, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1443 {"notes", "", NULL, NULL, ZBX_TYPE_SHORTTEXT_LEN, ZBX_TYPE_SHORTTEXT, ZBX_NOTNULL, 0}, 1444 {"chassis", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1445 {"model", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1446 {"hw_arch", "", NULL, NULL, 32, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1447 {"vendor", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1448 {"contract_number", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1449 {"installer_name", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1450 {"deployment_status", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1451 {"url_a", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1452 {"url_b", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1453 {"url_c", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1454 {"host_networks", "", NULL, NULL, ZBX_TYPE_SHORTTEXT_LEN, ZBX_TYPE_SHORTTEXT, ZBX_NOTNULL, 0}, 1455 {"host_netmask", "", NULL, NULL, 39, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1456 {"host_router", "", NULL, NULL, 39, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1457 {"oob_ip", "", NULL, NULL, 39, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1458 {"oob_netmask", "", NULL, NULL, 39, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1459 {"oob_router", "", NULL, NULL, 39, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1460 {"date_hw_purchase", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1461 {"date_hw_install", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1462 {"date_hw_expiry", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1463 {"date_hw_decomm", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1464 {"site_address_a", "", NULL, NULL, 128, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1465 {"site_address_b", "", NULL, NULL, 128, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1466 {"site_address_c", "", NULL, NULL, 128, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1467 {"site_city", "", NULL, NULL, 128, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1468 {"site_state", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1469 {"site_country", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1470 {"site_zip", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1471 {"site_rack", "", NULL, NULL, 128, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1472 {"site_notes", "", NULL, NULL, ZBX_TYPE_SHORTTEXT_LEN, ZBX_TYPE_SHORTTEXT, ZBX_NOTNULL, 0}, 1473 {"poc_1_name", "", NULL, NULL, 128, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1474 {"poc_1_email", "", NULL, NULL, 128, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1475 {"poc_1_phone_a", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1476 {"poc_1_phone_b", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1477 {"poc_1_cell", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1478 {"poc_1_screen", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1479 {"poc_1_notes", "", NULL, NULL, ZBX_TYPE_SHORTTEXT_LEN, ZBX_TYPE_SHORTTEXT, ZBX_NOTNULL, 0}, 1480 {"poc_2_name", "", NULL, NULL, 128, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1481 {"poc_2_email", "", NULL, NULL, 128, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1482 {"poc_2_phone_a", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1483 {"poc_2_phone_b", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1484 {"poc_2_cell", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1485 {"poc_2_screen", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1486 {"poc_2_notes", "", NULL, NULL, ZBX_TYPE_SHORTTEXT_LEN, ZBX_TYPE_SHORTTEXT, ZBX_NOTNULL, 0}, 1487 {0} 1488 }, 1489 NULL 1490 }, 1491 {"housekeeper", "housekeeperid", 0, 1492 { 1493 {"housekeeperid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 1494 {"tablename", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1495 {"field", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1496 {"value", NULL, "items", "value", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1497 {0} 1498 }, 1499 NULL 1500 }, 1501 {"images", "imageid", 0, 1502 { 1503 {"imageid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 1504 {"imagetype", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1505 {"name", "0", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1506 {"image", "", NULL, NULL, 0, ZBX_TYPE_BLOB, ZBX_NOTNULL, 0}, 1507 {0} 1508 }, 1509 "name" 1510 }, 1511 {"item_discovery", "itemdiscoveryid", 0, 1512 { 1513 {"itemdiscoveryid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 1514 {"itemid", NULL, "items", "itemid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1515 {"parent_itemid", NULL, "items", "itemid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1516 {"key_", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1517 {"lastcheck", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1518 {"ts_delete", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1519 {0} 1520 }, 1521 "itemid,parent_itemid" 1522 }, 1523 {"host_discovery", "hostid", 0, 1524 { 1525 {"hostid", NULL, "hosts", "hostid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1526 {"parent_hostid", NULL, "hosts", "hostid", 0, ZBX_TYPE_ID, 0, 0}, 1527 {"parent_itemid", NULL, "items", "itemid", 0, ZBX_TYPE_ID, 0, 0}, 1528 {"host", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1529 {"lastcheck", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1530 {"ts_delete", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1531 {0} 1532 }, 1533 NULL 1534 }, 1535 {"interface_discovery", "interfaceid", 0, 1536 { 1537 {"interfaceid", NULL, "interface", "interfaceid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1538 {"parent_interfaceid", NULL, "interface", "interfaceid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1539 {0} 1540 }, 1541 NULL 1542 }, 1543 {"profiles", "profileid", 0, 1544 { 1545 {"profileid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 1546 {"userid", NULL, "users", "userid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1547 {"idx", "", NULL, NULL, 96, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1548 {"idx2", "0", NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 1549 {"value_id", "0", NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 1550 {"value_int", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1551 {"value_str", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1552 {"source", "", NULL, NULL, 96, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1553 {"type", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1554 {0} 1555 }, 1556 NULL 1557 }, 1558 {"sessions", "sessionid", 0, 1559 { 1560 {"sessionid", "", NULL, NULL, 32, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1561 {"userid", NULL, "users", "userid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1562 {"lastaccess", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1563 {"status", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1564 {0} 1565 }, 1566 NULL 1567 }, 1568 {"trigger_discovery", "triggerid", 0, 1569 { 1570 {"triggerid", NULL, "triggers", "triggerid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1571 {"parent_triggerid", NULL, "triggers", "triggerid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 1572 {0} 1573 }, 1574 NULL 1575 }, 1576 {"application_template", "application_templateid", 0, 1577 { 1578 {"application_templateid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 1579 {"applicationid", NULL, "applications", "applicationid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1580 {"templateid", NULL, "applications", "applicationid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1581 {0} 1582 }, 1583 "applicationid,templateid" 1584 }, 1585 {"item_condition", "item_conditionid", 0, 1586 { 1587 {"item_conditionid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 1588 {"itemid", NULL, "items", "itemid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1589 {"operator", "8", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1590 {"macro", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1591 {"value", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1592 {0} 1593 }, 1594 NULL 1595 }, 1596 {"application_prototype", "application_prototypeid", 0, 1597 { 1598 {"application_prototypeid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 1599 {"itemid", NULL, "items", "itemid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1600 {"templateid", NULL, "application_prototype", "application_prototypeid", 0, ZBX_TYPE_ID, 0, ZBX_FK_CASCADE_DELETE}, 1601 {"name", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1602 {0} 1603 }, 1604 NULL 1605 }, 1606 {"item_application_prototype", "item_application_prototypeid", 0, 1607 { 1608 {"item_application_prototypeid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 1609 {"application_prototypeid", NULL, "application_prototype", "application_prototypeid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1610 {"itemid", NULL, "items", "itemid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1611 {0} 1612 }, 1613 "application_prototypeid,itemid" 1614 }, 1615 {"application_discovery", "application_discoveryid", 0, 1616 { 1617 {"application_discoveryid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, 1618 {"applicationid", NULL, "applications", "applicationid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1619 {"application_prototypeid", NULL, "application_prototype", "application_prototypeid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1620 {"name", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0}, 1621 {"lastcheck", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1622 {"ts_delete", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1623 {0} 1624 }, 1625 NULL 1626 }, 1627 {"opinventory", "operationid", 0, 1628 { 1629 {"operationid", NULL, "operations", "operationid", 0, ZBX_TYPE_ID, ZBX_NOTNULL, ZBX_FK_CASCADE_DELETE}, 1630 {"inventory_mode", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1631 {0} 1632 }, 1633 NULL 1634 }, 1635 {"dbversion", "", 0, 1636 { 1637 {"mandatory", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1638 {"optional", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, 1639 {0} 1640 }, 1641 NULL 1642 }, 1643 {0} 1644 1645 #undef ZBX_TYPE_LONGTEXT_LEN 1646 #undef ZBX_TYPE_SHORTTEXT_LEN 1647 1648 }; 1649 #if defined(HAVE_SQLITE3) 1650 const char *const db_schema = "\ 1651 CREATE TABLE users (\n\ 1652 userid bigint NOT NULL,\n\ 1653 alias varchar(100) DEFAULT '' NOT NULL,\n\ 1654 name varchar(100) DEFAULT '' NOT NULL,\n\ 1655 surname varchar(100) DEFAULT '' NOT NULL,\n\ 1656 passwd char(32) DEFAULT '' NOT NULL,\n\ 1657 url varchar(255) DEFAULT '' NOT NULL,\n\ 1658 autologin integer DEFAULT '0' NOT NULL,\n\ 1659 autologout integer DEFAULT '900' NOT NULL,\n\ 1660 lang varchar(5) DEFAULT 'en_GB' NOT NULL,\n\ 1661 refresh integer DEFAULT '30' NOT NULL,\n\ 1662 type integer DEFAULT '1' NOT NULL,\n\ 1663 theme varchar(128) DEFAULT 'default' NOT NULL,\n\ 1664 attempt_failed integer DEFAULT 0 NOT NULL,\n\ 1665 attempt_ip varchar(39) DEFAULT '' NOT NULL,\n\ 1666 attempt_clock integer DEFAULT 0 NOT NULL,\n\ 1667 rows_per_page integer DEFAULT 50 NOT NULL,\n\ 1668 PRIMARY KEY (userid)\n\ 1669 );\n\ 1670 CREATE UNIQUE INDEX users_1 ON users (alias);\n\ 1671 CREATE TABLE maintenances (\n\ 1672 maintenanceid bigint NOT NULL,\n\ 1673 name varchar(128) DEFAULT '' NOT NULL,\n\ 1674 maintenance_type integer DEFAULT '0' NOT NULL,\n\ 1675 description text DEFAULT '' NOT NULL,\n\ 1676 active_since integer DEFAULT '0' NOT NULL,\n\ 1677 active_till integer DEFAULT '0' NOT NULL,\n\ 1678 PRIMARY KEY (maintenanceid)\n\ 1679 );\n\ 1680 CREATE INDEX maintenances_1 ON maintenances (active_since,active_till);\n\ 1681 CREATE UNIQUE INDEX maintenances_2 ON maintenances (name);\n\ 1682 CREATE TABLE hosts (\n\ 1683 hostid bigint NOT NULL,\n\ 1684 proxy_hostid bigint NULL REFERENCES hosts (hostid),\n\ 1685 host varchar(128) DEFAULT '' NOT NULL,\n\ 1686 status integer DEFAULT '0' NOT NULL,\n\ 1687 disable_until integer DEFAULT '0' NOT NULL,\n\ 1688 error varchar(2048) DEFAULT '' NOT NULL,\n\ 1689 available integer DEFAULT '0' NOT NULL,\n\ 1690 errors_from integer DEFAULT '0' NOT NULL,\n\ 1691 lastaccess integer DEFAULT '0' NOT NULL,\n\ 1692 ipmi_authtype integer DEFAULT '0' NOT NULL,\n\ 1693 ipmi_privilege integer DEFAULT '2' NOT NULL,\n\ 1694 ipmi_username varchar(16) DEFAULT '' NOT NULL,\n\ 1695 ipmi_password varchar(20) DEFAULT '' NOT NULL,\n\ 1696 ipmi_disable_until integer DEFAULT '0' NOT NULL,\n\ 1697 ipmi_available integer DEFAULT '0' NOT NULL,\n\ 1698 snmp_disable_until integer DEFAULT '0' NOT NULL,\n\ 1699 snmp_available integer DEFAULT '0' NOT NULL,\n\ 1700 maintenanceid bigint NULL REFERENCES maintenances (maintenanceid),\n\ 1701 maintenance_status integer DEFAULT '0' NOT NULL,\n\ 1702 maintenance_type integer DEFAULT '0' NOT NULL,\n\ 1703 maintenance_from integer DEFAULT '0' NOT NULL,\n\ 1704 ipmi_errors_from integer DEFAULT '0' NOT NULL,\n\ 1705 snmp_errors_from integer DEFAULT '0' NOT NULL,\n\ 1706 ipmi_error varchar(2048) DEFAULT '' NOT NULL,\n\ 1707 snmp_error varchar(2048) DEFAULT '' NOT NULL,\n\ 1708 jmx_disable_until integer DEFAULT '0' NOT NULL,\n\ 1709 jmx_available integer DEFAULT '0' NOT NULL,\n\ 1710 jmx_errors_from integer DEFAULT '0' NOT NULL,\n\ 1711 jmx_error varchar(2048) DEFAULT '' NOT NULL,\n\ 1712 name varchar(128) DEFAULT '' NOT NULL,\n\ 1713 flags integer DEFAULT '0' NOT NULL,\n\ 1714 templateid bigint NULL REFERENCES hosts (hostid) ON DELETE CASCADE,\n\ 1715 description text DEFAULT '' NOT NULL,\n\ 1716 tls_connect integer DEFAULT '1' NOT NULL,\n\ 1717 tls_accept integer DEFAULT '1' NOT NULL,\n\ 1718 tls_issuer varchar(1024) DEFAULT '' NOT NULL,\n\ 1719 tls_subject varchar(1024) DEFAULT '' NOT NULL,\n\ 1720 tls_psk_identity varchar(128) DEFAULT '' NOT NULL,\n\ 1721 tls_psk varchar(512) DEFAULT '' NOT NULL,\n\ 1722 PRIMARY KEY (hostid)\n\ 1723 );\n\ 1724 CREATE INDEX hosts_1 ON hosts (host);\n\ 1725 CREATE INDEX hosts_2 ON hosts (status);\n\ 1726 CREATE INDEX hosts_3 ON hosts (proxy_hostid);\n\ 1727 CREATE INDEX hosts_4 ON hosts (name);\n\ 1728 CREATE INDEX hosts_5 ON hosts (maintenanceid);\n\ 1729 CREATE TABLE groups (\n\ 1730 groupid bigint NOT NULL,\n\ 1731 name varchar(64) DEFAULT '' NOT NULL,\n\ 1732 internal integer DEFAULT '0' NOT NULL,\n\ 1733 flags integer DEFAULT '0' NOT NULL,\n\ 1734 PRIMARY KEY (groupid)\n\ 1735 );\n\ 1736 CREATE INDEX groups_1 ON groups (name);\n\ 1737 CREATE TABLE group_prototype (\n\ 1738 group_prototypeid bigint NOT NULL,\n\ 1739 hostid bigint NOT NULL REFERENCES hosts (hostid) ON DELETE CASCADE,\n\ 1740 name varchar(64) DEFAULT '' NOT NULL,\n\ 1741 groupid bigint NULL REFERENCES groups (groupid),\n\ 1742 templateid bigint NULL REFERENCES group_prototype (group_prototypeid) ON DELETE CASCADE,\n\ 1743 PRIMARY KEY (group_prototypeid)\n\ 1744 );\n\ 1745 CREATE INDEX group_prototype_1 ON group_prototype (hostid);\n\ 1746 CREATE TABLE group_discovery (\n\ 1747 groupid bigint NOT NULL REFERENCES groups (groupid) ON DELETE CASCADE,\n\ 1748 parent_group_prototypeid bigint NOT NULL REFERENCES group_prototype (group_prototypeid),\n\ 1749 name varchar(64) DEFAULT '' NOT NULL,\n\ 1750 lastcheck integer DEFAULT '0' NOT NULL,\n\ 1751 ts_delete integer DEFAULT '0' NOT NULL,\n\ 1752 PRIMARY KEY (groupid)\n\ 1753 );\n\ 1754 CREATE TABLE screens (\n\ 1755 screenid bigint NOT NULL,\n\ 1756 name varchar(255) NOT NULL,\n\ 1757 hsize integer DEFAULT '1' NOT NULL,\n\ 1758 vsize integer DEFAULT '1' NOT NULL,\n\ 1759 templateid bigint NULL REFERENCES hosts (hostid) ON DELETE CASCADE,\n\ 1760 userid bigint NULL REFERENCES users (userid),\n\ 1761 private integer DEFAULT '1' NOT NULL,\n\ 1762 PRIMARY KEY (screenid)\n\ 1763 );\n\ 1764 CREATE INDEX screens_1 ON screens (templateid);\n\ 1765 CREATE TABLE screens_items (\n\ 1766 screenitemid bigint NOT NULL,\n\ 1767 screenid bigint NOT NULL REFERENCES screens (screenid) ON DELETE CASCADE,\n\ 1768 resourcetype integer DEFAULT '0' NOT NULL,\n\ 1769 resourceid bigint DEFAULT '0' NOT NULL,\n\ 1770 width integer DEFAULT '320' NOT NULL,\n\ 1771 height integer DEFAULT '200' NOT NULL,\n\ 1772 x integer DEFAULT '0' NOT NULL,\n\ 1773 y integer DEFAULT '0' NOT NULL,\n\ 1774 colspan integer DEFAULT '1' NOT NULL,\n\ 1775 rowspan integer DEFAULT '1' NOT NULL,\n\ 1776 elements integer DEFAULT '25' NOT NULL,\n\ 1777 valign integer DEFAULT '0' NOT NULL,\n\ 1778 halign integer DEFAULT '0' NOT NULL,\n\ 1779 style integer DEFAULT '0' NOT NULL,\n\ 1780 url varchar(255) DEFAULT '' NOT NULL,\n\ 1781 dynamic integer DEFAULT '0' NOT NULL,\n\ 1782 sort_triggers integer DEFAULT '0' NOT NULL,\n\ 1783 application varchar(255) DEFAULT '' NOT NULL,\n\ 1784 max_columns integer DEFAULT '3' NOT NULL,\n\ 1785 PRIMARY KEY (screenitemid)\n\ 1786 );\n\ 1787 CREATE INDEX screens_items_1 ON screens_items (screenid);\n\ 1788 CREATE TABLE screen_user (\n\ 1789 screenuserid bigint NOT NULL,\n\ 1790 screenid bigint NOT NULL REFERENCES screens (screenid) ON DELETE CASCADE,\n\ 1791 userid bigint NOT NULL REFERENCES users (userid) ON DELETE CASCADE,\n\ 1792 permission integer DEFAULT '2' NOT NULL,\n\ 1793 PRIMARY KEY (screenuserid)\n\ 1794 );\n\ 1795 CREATE UNIQUE INDEX screen_user_1 ON screen_user (screenid,userid);\n\ 1796 CREATE TABLE screen_usrgrp (\n\ 1797 screenusrgrpid bigint NOT NULL,\n\ 1798 screenid bigint NOT NULL REFERENCES screens (screenid) ON DELETE CASCADE,\n\ 1799 usrgrpid bigint NOT NULL REFERENCES usrgrp (usrgrpid) ON DELETE CASCADE,\n\ 1800 permission integer DEFAULT '2' NOT NULL,\n\ 1801 PRIMARY KEY (screenusrgrpid)\n\ 1802 );\n\ 1803 CREATE UNIQUE INDEX screen_usrgrp_1 ON screen_usrgrp (screenid,usrgrpid);\n\ 1804 CREATE TABLE slideshows (\n\ 1805 slideshowid bigint NOT NULL,\n\ 1806 name varchar(255) DEFAULT '' NOT NULL,\n\ 1807 delay integer DEFAULT '0' NOT NULL,\n\ 1808 userid bigint NOT NULL REFERENCES users (userid),\n\ 1809 private integer DEFAULT '1' NOT NULL,\n\ 1810 PRIMARY KEY (slideshowid)\n\ 1811 );\n\ 1812 CREATE UNIQUE INDEX slideshows_1 ON slideshows (name);\n\ 1813 CREATE TABLE slideshow_user (\n\ 1814 slideshowuserid bigint NOT NULL,\n\ 1815 slideshowid bigint NOT NULL REFERENCES slideshows (slideshowid) ON DELETE CASCADE,\n\ 1816 userid bigint NOT NULL REFERENCES users (userid) ON DELETE CASCADE,\n\ 1817 permission integer DEFAULT '2' NOT NULL,\n\ 1818 PRIMARY KEY (slideshowuserid)\n\ 1819 );\n\ 1820 CREATE UNIQUE INDEX slideshow_user_1 ON slideshow_user (slideshowid,userid);\n\ 1821 CREATE TABLE slideshow_usrgrp (\n\ 1822 slideshowusrgrpid bigint NOT NULL,\n\ 1823 slideshowid bigint NOT NULL REFERENCES slideshows (slideshowid) ON DELETE CASCADE,\n\ 1824 usrgrpid bigint NOT NULL REFERENCES usrgrp (usrgrpid) ON DELETE CASCADE,\n\ 1825 permission integer DEFAULT '2' NOT NULL,\n\ 1826 PRIMARY KEY (slideshowusrgrpid)\n\ 1827 );\n\ 1828 CREATE UNIQUE INDEX slideshow_usrgrp_1 ON slideshow_usrgrp (slideshowid,usrgrpid);\n\ 1829 CREATE TABLE slides (\n\ 1830 slideid bigint NOT NULL,\n\ 1831 slideshowid bigint NOT NULL REFERENCES slideshows (slideshowid) ON DELETE CASCADE,\n\ 1832 screenid bigint NOT NULL REFERENCES screens (screenid) ON DELETE CASCADE,\n\ 1833 step integer DEFAULT '0' NOT NULL,\n\ 1834 delay integer DEFAULT '0' NOT NULL,\n\ 1835 PRIMARY KEY (slideid)\n\ 1836 );\n\ 1837 CREATE INDEX slides_1 ON slides (slideshowid);\n\ 1838 CREATE INDEX slides_2 ON slides (screenid);\n\ 1839 CREATE TABLE drules (\n\ 1840 druleid bigint NOT NULL,\n\ 1841 proxy_hostid bigint NULL REFERENCES hosts (hostid),\n\ 1842 name varchar(255) DEFAULT '' NOT NULL,\n\ 1843 iprange varchar(2048) DEFAULT '' NOT NULL,\n\ 1844 delay integer DEFAULT '3600' NOT NULL,\n\ 1845 nextcheck integer DEFAULT '0' NOT NULL,\n\ 1846 status integer DEFAULT '0' NOT NULL,\n\ 1847 PRIMARY KEY (druleid)\n\ 1848 );\n\ 1849 CREATE INDEX drules_1 ON drules (proxy_hostid);\n\ 1850 CREATE UNIQUE INDEX drules_2 ON drules (name);\n\ 1851 CREATE TABLE dchecks (\n\ 1852 dcheckid bigint NOT NULL,\n\ 1853 druleid bigint NOT NULL REFERENCES drules (druleid) ON DELETE CASCADE,\n\ 1854 type integer DEFAULT '0' NOT NULL,\n\ 1855 key_ varchar(255) DEFAULT '' NOT NULL,\n\ 1856 snmp_community varchar(255) DEFAULT '' NOT NULL,\n\ 1857 ports varchar(255) DEFAULT '0' NOT NULL,\n\ 1858 snmpv3_securityname varchar(64) DEFAULT '' NOT NULL,\n\ 1859 snmpv3_securitylevel integer DEFAULT '0' NOT NULL,\n\ 1860 snmpv3_authpassphrase varchar(64) DEFAULT '' NOT NULL,\n\ 1861 snmpv3_privpassphrase varchar(64) DEFAULT '' NOT NULL,\n\ 1862 uniq integer DEFAULT '0' NOT NULL,\n\ 1863 snmpv3_authprotocol integer DEFAULT '0' NOT NULL,\n\ 1864 snmpv3_privprotocol integer DEFAULT '0' NOT NULL,\n\ 1865 snmpv3_contextname varchar(255) DEFAULT '' NOT NULL,\n\ 1866 PRIMARY KEY (dcheckid)\n\ 1867 );\n\ 1868 CREATE INDEX dchecks_1 ON dchecks (druleid);\n\ 1869 CREATE TABLE applications (\n\ 1870 applicationid bigint NOT NULL,\n\ 1871 hostid bigint NOT NULL REFERENCES hosts (hostid) ON DELETE CASCADE,\n\ 1872 name varchar(255) DEFAULT '' NOT NULL,\n\ 1873 flags integer DEFAULT '0' NOT NULL,\n\ 1874 PRIMARY KEY (applicationid)\n\ 1875 );\n\ 1876 CREATE UNIQUE INDEX applications_2 ON applications (hostid,name);\n\ 1877 CREATE TABLE httptest (\n\ 1878 httptestid bigint NOT NULL,\n\ 1879 name varchar(64) DEFAULT '' NOT NULL,\n\ 1880 applicationid bigint NULL REFERENCES applications (applicationid),\n\ 1881 nextcheck integer DEFAULT '0' NOT NULL,\n\ 1882 delay integer DEFAULT '60' NOT NULL,\n\ 1883 status integer DEFAULT '0' NOT NULL,\n\ 1884 variables text DEFAULT '' NOT NULL,\n\ 1885 agent varchar(255) DEFAULT 'Zabbix' NOT NULL,\n\ 1886 authentication integer DEFAULT '0' NOT NULL,\n\ 1887 http_user varchar(64) DEFAULT '' NOT NULL,\n\ 1888 http_password varchar(64) DEFAULT '' NOT NULL,\n\ 1889 hostid bigint NOT NULL REFERENCES hosts (hostid) ON DELETE CASCADE,\n\ 1890 templateid bigint NULL REFERENCES httptest (httptestid) ON DELETE CASCADE,\n\ 1891 http_proxy varchar(255) DEFAULT '' NOT NULL,\n\ 1892 retries integer DEFAULT '1' NOT NULL,\n\ 1893 ssl_cert_file varchar(255) DEFAULT '' NOT NULL,\n\ 1894 ssl_key_file varchar(255) DEFAULT '' NOT NULL,\n\ 1895 ssl_key_password varchar(64) DEFAULT '' NOT NULL,\n\ 1896 verify_peer integer DEFAULT '0' NOT NULL,\n\ 1897 verify_host integer DEFAULT '0' NOT NULL,\n\ 1898 headers text DEFAULT '' NOT NULL,\n\ 1899 PRIMARY KEY (httptestid)\n\ 1900 );\n\ 1901 CREATE INDEX httptest_1 ON httptest (applicationid);\n\ 1902 CREATE UNIQUE INDEX httptest_2 ON httptest (hostid,name);\n\ 1903 CREATE INDEX httptest_3 ON httptest (status);\n\ 1904 CREATE INDEX httptest_4 ON httptest (templateid);\n\ 1905 CREATE TABLE httpstep (\n\ 1906 httpstepid bigint NOT NULL,\n\ 1907 httptestid bigint NOT NULL REFERENCES httptest (httptestid) ON DELETE CASCADE,\n\ 1908 name varchar(64) DEFAULT '' NOT NULL,\n\ 1909 no integer DEFAULT '0' NOT NULL,\n\ 1910 url varchar(2048) DEFAULT '' NOT NULL,\n\ 1911 timeout integer DEFAULT '15' NOT NULL,\n\ 1912 posts text DEFAULT '' NOT NULL,\n\ 1913 required varchar(255) DEFAULT '' NOT NULL,\n\ 1914 status_codes varchar(255) DEFAULT '' NOT NULL,\n\ 1915 variables text DEFAULT '' NOT NULL,\n\ 1916 follow_redirects integer DEFAULT '1' NOT NULL,\n\ 1917 retrieve_mode integer DEFAULT '0' NOT NULL,\n\ 1918 headers text DEFAULT '' NOT NULL,\n\ 1919 PRIMARY KEY (httpstepid)\n\ 1920 );\n\ 1921 CREATE INDEX httpstep_1 ON httpstep (httptestid);\n\ 1922 CREATE TABLE interface (\n\ 1923 interfaceid bigint NOT NULL,\n\ 1924 hostid bigint NOT NULL REFERENCES hosts (hostid) ON DELETE CASCADE,\n\ 1925 main integer DEFAULT '0' NOT NULL,\n\ 1926 type integer DEFAULT '0' NOT NULL,\n\ 1927 useip integer DEFAULT '1' NOT NULL,\n\ 1928 ip varchar(64) DEFAULT '127.0.0.1' NOT NULL,\n\ 1929 dns varchar(64) DEFAULT '' NOT NULL,\n\ 1930 port varchar(64) DEFAULT '10050' NOT NULL,\n\ 1931 bulk integer DEFAULT '1' NOT NULL,\n\ 1932 PRIMARY KEY (interfaceid)\n\ 1933 );\n\ 1934 CREATE INDEX interface_1 ON interface (hostid,type);\n\ 1935 CREATE INDEX interface_2 ON interface (ip,dns);\n\ 1936 CREATE TABLE valuemaps (\n\ 1937 valuemapid bigint NOT NULL,\n\ 1938 name varchar(64) DEFAULT '' NOT NULL,\n\ 1939 PRIMARY KEY (valuemapid)\n\ 1940 );\n\ 1941 CREATE UNIQUE INDEX valuemaps_1 ON valuemaps (name);\n\ 1942 CREATE TABLE items (\n\ 1943 itemid bigint NOT NULL,\n\ 1944 type integer DEFAULT '0' NOT NULL,\n\ 1945 snmp_community varchar(64) DEFAULT '' NOT NULL,\n\ 1946 snmp_oid varchar(255) DEFAULT '' NOT NULL,\n\ 1947 hostid bigint NOT NULL REFERENCES hosts (hostid) ON DELETE CASCADE,\n\ 1948 name varchar(255) DEFAULT '' NOT NULL,\n\ 1949 key_ varchar(255) DEFAULT '' NOT NULL,\n\ 1950 delay integer DEFAULT '0' NOT NULL,\n\ 1951 history integer DEFAULT '90' NOT NULL,\n\ 1952 trends integer DEFAULT '365' NOT NULL,\n\ 1953 status integer DEFAULT '0' NOT NULL,\n\ 1954 value_type integer DEFAULT '0' NOT NULL,\n\ 1955 trapper_hosts varchar(255) DEFAULT '' NOT NULL,\n\ 1956 units varchar(255) DEFAULT '' NOT NULL,\n\ 1957 multiplier integer DEFAULT '0' NOT NULL,\n\ 1958 delta integer DEFAULT '0' NOT NULL,\n\ 1959 snmpv3_securityname varchar(64) DEFAULT '' NOT NULL,\n\ 1960 snmpv3_securitylevel integer DEFAULT '0' NOT NULL,\n\ 1961 snmpv3_authpassphrase varchar(64) DEFAULT '' NOT NULL,\n\ 1962 snmpv3_privpassphrase varchar(64) DEFAULT '' NOT NULL,\n\ 1963 formula varchar(255) DEFAULT '' NOT NULL,\n\ 1964 error varchar(2048) DEFAULT '' NOT NULL,\n\ 1965 lastlogsize bigint DEFAULT '0' NOT NULL,\n\ 1966 logtimefmt varchar(64) DEFAULT '' NOT NULL,\n\ 1967 templateid bigint NULL REFERENCES items (itemid) ON DELETE CASCADE,\n\ 1968 valuemapid bigint NULL REFERENCES valuemaps (valuemapid),\n\ 1969 delay_flex varchar(255) DEFAULT '' NOT NULL,\n\ 1970 params text DEFAULT '' NOT NULL,\n\ 1971 ipmi_sensor varchar(128) DEFAULT '' NOT NULL,\n\ 1972 data_type integer DEFAULT '0' NOT NULL,\n\ 1973 authtype integer DEFAULT '0' NOT NULL,\n\ 1974 username varchar(64) DEFAULT '' NOT NULL,\n\ 1975 password varchar(64) DEFAULT '' NOT NULL,\n\ 1976 publickey varchar(64) DEFAULT '' NOT NULL,\n\ 1977 privatekey varchar(64) DEFAULT '' NOT NULL,\n\ 1978 mtime integer DEFAULT '0' NOT NULL,\n\ 1979 flags integer DEFAULT '0' NOT NULL,\n\ 1980 interfaceid bigint NULL REFERENCES interface (interfaceid),\n\ 1981 port varchar(64) DEFAULT '' NOT NULL,\n\ 1982 description text DEFAULT '' NOT NULL,\n\ 1983 inventory_link integer DEFAULT '0' NOT NULL,\n\ 1984 lifetime varchar(64) DEFAULT '30' NOT NULL,\n\ 1985 snmpv3_authprotocol integer DEFAULT '0' NOT NULL,\n\ 1986 snmpv3_privprotocol integer DEFAULT '0' NOT NULL,\n\ 1987 state integer DEFAULT '0' NOT NULL,\n\ 1988 snmpv3_contextname varchar(255) DEFAULT '' NOT NULL,\n\ 1989 evaltype integer DEFAULT '0' NOT NULL,\n\ 1990 PRIMARY KEY (itemid)\n\ 1991 );\n\ 1992 CREATE UNIQUE INDEX items_1 ON items (hostid,key_);\n\ 1993 CREATE INDEX items_3 ON items (status);\n\ 1994 CREATE INDEX items_4 ON items (templateid);\n\ 1995 CREATE INDEX items_5 ON items (valuemapid);\n\ 1996 CREATE INDEX items_6 ON items (interfaceid);\n\ 1997 CREATE TABLE httpstepitem (\n\ 1998 httpstepitemid bigint NOT NULL,\n\ 1999 httpstepid bigint NOT NULL REFERENCES httpstep (httpstepid) ON DELETE CASCADE,\n\ 2000 itemid bigint NOT NULL REFERENCES items (itemid) ON DELETE CASCADE,\n\ 2001 type integer DEFAULT '0' NOT NULL,\n\ 2002 PRIMARY KEY (httpstepitemid)\n\ 2003 );\n\ 2004 CREATE UNIQUE INDEX httpstepitem_1 ON httpstepitem (httpstepid,itemid);\n\ 2005 CREATE INDEX httpstepitem_2 ON httpstepitem (itemid);\n\ 2006 CREATE TABLE httptestitem (\n\ 2007 httptestitemid bigint NOT NULL,\n\ 2008 httptestid bigint NOT NULL REFERENCES httptest (httptestid) ON DELETE CASCADE,\n\ 2009 itemid bigint NOT NULL REFERENCES items (itemid) ON DELETE CASCADE,\n\ 2010 type integer DEFAULT '0' NOT NULL,\n\ 2011 PRIMARY KEY (httptestitemid)\n\ 2012 );\n\ 2013 CREATE UNIQUE INDEX httptestitem_1 ON httptestitem (httptestid,itemid);\n\ 2014 CREATE INDEX httptestitem_2 ON httptestitem (itemid);\n\ 2015 CREATE TABLE media_type (\n\ 2016 mediatypeid bigint NOT NULL,\n\ 2017 type integer DEFAULT '0' NOT NULL,\n\ 2018 description varchar(100) DEFAULT '' NOT NULL,\n\ 2019 smtp_server varchar(255) DEFAULT '' NOT NULL,\n\ 2020 smtp_helo varchar(255) DEFAULT '' NOT NULL,\n\ 2021 smtp_email varchar(255) DEFAULT '' NOT NULL,\n\ 2022 exec_path varchar(255) DEFAULT '' NOT NULL,\n\ 2023 gsm_modem varchar(255) DEFAULT '' NOT NULL,\n\ 2024 username varchar(255) DEFAULT '' NOT NULL,\n\ 2025 passwd varchar(255) DEFAULT '' NOT NULL,\n\ 2026 status integer DEFAULT '0' NOT NULL,\n\ 2027 smtp_port integer DEFAULT '25' NOT NULL,\n\ 2028 smtp_security integer DEFAULT '0' NOT NULL,\n\ 2029 smtp_verify_peer integer DEFAULT '0' NOT NULL,\n\ 2030 smtp_verify_host integer DEFAULT '0' NOT NULL,\n\ 2031 smtp_authentication integer DEFAULT '0' NOT NULL,\n\ 2032 exec_params varchar(255) DEFAULT '' NOT NULL,\n\ 2033 PRIMARY KEY (mediatypeid)\n\ 2034 );\n\ 2035 CREATE UNIQUE INDEX media_type_1 ON media_type (description);\n\ 2036 CREATE TABLE usrgrp (\n\ 2037 usrgrpid bigint NOT NULL,\n\ 2038 name varchar(64) DEFAULT '' NOT NULL,\n\ 2039 gui_access integer DEFAULT '0' NOT NULL,\n\ 2040 users_status integer DEFAULT '0' NOT NULL,\n\ 2041 debug_mode integer DEFAULT '0' NOT NULL,\n\ 2042 PRIMARY KEY (usrgrpid)\n\ 2043 );\n\ 2044 CREATE UNIQUE INDEX usrgrp_1 ON usrgrp (name);\n\ 2045 CREATE TABLE users_groups (\n\ 2046 id bigint NOT NULL,\n\ 2047 usrgrpid bigint NOT NULL REFERENCES usrgrp (usrgrpid) ON DELETE CASCADE,\n\ 2048 userid bigint NOT NULL REFERENCES users (userid) ON DELETE CASCADE,\n\ 2049 PRIMARY KEY (id)\n\ 2050 );\n\ 2051 CREATE UNIQUE INDEX users_groups_1 ON users_groups (usrgrpid,userid);\n\ 2052 CREATE INDEX users_groups_2 ON users_groups (userid);\n\ 2053 CREATE TABLE scripts (\n\ 2054 scriptid bigint NOT NULL,\n\ 2055 name varchar(255) DEFAULT '' NOT NULL,\n\ 2056 command varchar(255) DEFAULT '' NOT NULL,\n\ 2057 host_access integer DEFAULT '2' NOT NULL,\n\ 2058 usrgrpid bigint NULL REFERENCES usrgrp (usrgrpid),\n\ 2059 groupid bigint NULL REFERENCES groups (groupid),\n\ 2060 description text DEFAULT '' NOT NULL,\n\ 2061 confirmation varchar(255) DEFAULT '' NOT NULL,\n\ 2062 type integer DEFAULT '0' NOT NULL,\n\ 2063 execute_on integer DEFAULT '1' NOT NULL,\n\ 2064 PRIMARY KEY (scriptid)\n\ 2065 );\n\ 2066 CREATE INDEX scripts_1 ON scripts (usrgrpid);\n\ 2067 CREATE INDEX scripts_2 ON scripts (groupid);\n\ 2068 CREATE UNIQUE INDEX scripts_3 ON scripts (name);\n\ 2069 CREATE TABLE actions (\n\ 2070 actionid bigint NOT NULL,\n\ 2071 name varchar(255) DEFAULT '' NOT NULL,\n\ 2072 eventsource integer DEFAULT '0' NOT NULL,\n\ 2073 evaltype integer DEFAULT '0' NOT NULL,\n\ 2074 status integer DEFAULT '0' NOT NULL,\n\ 2075 esc_period integer DEFAULT '0' NOT NULL,\n\ 2076 def_shortdata varchar(255) DEFAULT '' NOT NULL,\n\ 2077 def_longdata text DEFAULT '' NOT NULL,\n\ 2078 recovery_msg integer DEFAULT '0' NOT NULL,\n\ 2079 r_shortdata varchar(255) DEFAULT '' NOT NULL,\n\ 2080 r_longdata text DEFAULT '' NOT NULL,\n\ 2081 formula varchar(255) DEFAULT '' NOT NULL,\n\ 2082 PRIMARY KEY (actionid)\n\ 2083 );\n\ 2084 CREATE INDEX actions_1 ON actions (eventsource,status);\n\ 2085 CREATE UNIQUE INDEX actions_2 ON actions (name);\n\ 2086 CREATE TABLE operations (\n\ 2087 operationid bigint NOT NULL,\n\ 2088 actionid bigint NOT NULL REFERENCES actions (actionid) ON DELETE CASCADE,\n\ 2089 operationtype integer DEFAULT '0' NOT NULL,\n\ 2090 esc_period integer DEFAULT '0' NOT NULL,\n\ 2091 esc_step_from integer DEFAULT '1' NOT NULL,\n\ 2092 esc_step_to integer DEFAULT '1' NOT NULL,\n\ 2093 evaltype integer DEFAULT '0' NOT NULL,\n\ 2094 PRIMARY KEY (operationid)\n\ 2095 );\n\ 2096 CREATE INDEX operations_1 ON operations (actionid);\n\ 2097 CREATE TABLE opmessage (\n\ 2098 operationid bigint NOT NULL REFERENCES operations (operationid) ON DELETE CASCADE,\n\ 2099 default_msg integer DEFAULT '0' NOT NULL,\n\ 2100 subject varchar(255) DEFAULT '' NOT NULL,\n\ 2101 message text DEFAULT '' NOT NULL,\n\ 2102 mediatypeid bigint NULL REFERENCES media_type (mediatypeid),\n\ 2103 PRIMARY KEY (operationid)\n\ 2104 );\n\ 2105 CREATE INDEX opmessage_1 ON opmessage (mediatypeid);\n\ 2106 CREATE TABLE opmessage_grp (\n\ 2107 opmessage_grpid bigint NOT NULL,\n\ 2108 operationid bigint NOT NULL REFERENCES operations (operationid) ON DELETE CASCADE,\n\ 2109 usrgrpid bigint NOT NULL REFERENCES usrgrp (usrgrpid),\n\ 2110 PRIMARY KEY (opmessage_grpid)\n\ 2111 );\n\ 2112 CREATE UNIQUE INDEX opmessage_grp_1 ON opmessage_grp (operationid,usrgrpid);\n\ 2113 CREATE INDEX opmessage_grp_2 ON opmessage_grp (usrgrpid);\n\ 2114 CREATE TABLE opmessage_usr (\n\ 2115 opmessage_usrid bigint NOT NULL,\n\ 2116 operationid bigint NOT NULL REFERENCES operations (operationid) ON DELETE CASCADE,\n\ 2117 userid bigint NOT NULL REFERENCES users (userid),\n\ 2118 PRIMARY KEY (opmessage_usrid)\n\ 2119 );\n\ 2120 CREATE UNIQUE INDEX opmessage_usr_1 ON opmessage_usr (operationid,userid);\n\ 2121 CREATE INDEX opmessage_usr_2 ON opmessage_usr (userid);\n\ 2122 CREATE TABLE opcommand (\n\ 2123 operationid bigint NOT NULL REFERENCES operations (operationid) ON DELETE CASCADE,\n\ 2124 type integer DEFAULT '0' NOT NULL,\n\ 2125 scriptid bigint NULL REFERENCES scripts (scriptid),\n\ 2126 execute_on integer DEFAULT '0' NOT NULL,\n\ 2127 port varchar(64) DEFAULT '' NOT NULL,\n\ 2128 authtype integer DEFAULT '0' NOT NULL,\n\ 2129 username varchar(64) DEFAULT '' NOT NULL,\n\ 2130 password varchar(64) DEFAULT '' NOT NULL,\n\ 2131 publickey varchar(64) DEFAULT '' NOT NULL,\n\ 2132 privatekey varchar(64) DEFAULT '' NOT NULL,\n\ 2133 command text DEFAULT '' NOT NULL,\n\ 2134 PRIMARY KEY (operationid)\n\ 2135 );\n\ 2136 CREATE INDEX opcommand_1 ON opcommand (scriptid);\n\ 2137 CREATE TABLE opcommand_hst (\n\ 2138 opcommand_hstid bigint NOT NULL,\n\ 2139 operationid bigint NOT NULL REFERENCES operations (operationid) ON DELETE CASCADE,\n\ 2140 hostid bigint NULL REFERENCES hosts (hostid),\n\ 2141 PRIMARY KEY (opcommand_hstid)\n\ 2142 );\n\ 2143 CREATE INDEX opcommand_hst_1 ON opcommand_hst (operationid);\n\ 2144 CREATE INDEX opcommand_hst_2 ON opcommand_hst (hostid);\n\ 2145 CREATE TABLE opcommand_grp (\n\ 2146 opcommand_grpid bigint NOT NULL,\n\ 2147 operationid bigint NOT NULL REFERENCES operations (operationid) ON DELETE CASCADE,\n\ 2148 groupid bigint NOT NULL REFERENCES groups (groupid),\n\ 2149 PRIMARY KEY (opcommand_grpid)\n\ 2150 );\n\ 2151 CREATE INDEX opcommand_grp_1 ON opcommand_grp (operationid);\n\ 2152 CREATE INDEX opcommand_grp_2 ON opcommand_grp (groupid);\n\ 2153 CREATE TABLE opgroup (\n\ 2154 opgroupid bigint NOT NULL,\n\ 2155 operationid bigint NOT NULL REFERENCES operations (operationid) ON DELETE CASCADE,\n\ 2156 groupid bigint NOT NULL REFERENCES groups (groupid),\n\ 2157 PRIMARY KEY (opgroupid)\n\ 2158 );\n\ 2159 CREATE UNIQUE INDEX opgroup_1 ON opgroup (operationid,groupid);\n\ 2160 CREATE INDEX opgroup_2 ON opgroup (groupid);\n\ 2161 CREATE TABLE optemplate (\n\ 2162 optemplateid bigint NOT NULL,\n\ 2163 operationid bigint NOT NULL REFERENCES operations (operationid) ON DELETE CASCADE,\n\ 2164 templateid bigint NOT NULL REFERENCES hosts (hostid),\n\ 2165 PRIMARY KEY (optemplateid)\n\ 2166 );\n\ 2167 CREATE UNIQUE INDEX optemplate_1 ON optemplate (operationid,templateid);\n\ 2168 CREATE INDEX optemplate_2 ON optemplate (templateid);\n\ 2169 CREATE TABLE opconditions (\n\ 2170 opconditionid bigint NOT NULL,\n\ 2171 operationid bigint NOT NULL REFERENCES operations (operationid) ON DELETE CASCADE,\n\ 2172 conditiontype integer DEFAULT '0' NOT NULL,\n\ 2173 operator integer DEFAULT '0' NOT NULL,\n\ 2174 value varchar(255) DEFAULT '' NOT NULL,\n\ 2175 PRIMARY KEY (opconditionid)\n\ 2176 );\n\ 2177 CREATE INDEX opconditions_1 ON opconditions (operationid);\n\ 2178 CREATE TABLE conditions (\n\ 2179 conditionid bigint NOT NULL,\n\ 2180 actionid bigint NOT NULL REFERENCES actions (actionid) ON DELETE CASCADE,\n\ 2181 conditiontype integer DEFAULT '0' NOT NULL,\n\ 2182 operator integer DEFAULT '0' NOT NULL,\n\ 2183 value varchar(255) DEFAULT '' NOT NULL,\n\ 2184 PRIMARY KEY (conditionid)\n\ 2185 );\n\ 2186 CREATE INDEX conditions_1 ON conditions (actionid);\n\ 2187 CREATE TABLE config (\n\ 2188 configid bigint NOT NULL,\n\ 2189 refresh_unsupported integer DEFAULT '0' NOT NULL,\n\ 2190 work_period varchar(100) DEFAULT '1-5,00:00-24:00' NOT NULL,\n\ 2191 alert_usrgrpid bigint NULL REFERENCES usrgrp (usrgrpid),\n\ 2192 event_ack_enable integer DEFAULT '1' NOT NULL,\n\ 2193 event_expire integer DEFAULT '7' NOT NULL,\n\ 2194 event_show_max integer DEFAULT '100' NOT NULL,\n\ 2195 default_theme varchar(128) DEFAULT 'blue-theme' NOT NULL,\n\ 2196 authentication_type integer DEFAULT '0' NOT NULL,\n\ 2197 ldap_host varchar(255) DEFAULT '' NOT NULL,\n\ 2198 ldap_port integer DEFAULT 389 NOT NULL,\n\ 2199 ldap_base_dn varchar(255) DEFAULT '' NOT NULL,\n\ 2200 ldap_bind_dn varchar(255) DEFAULT '' NOT NULL,\n\ 2201 ldap_bind_password varchar(128) DEFAULT '' NOT NULL,\n\ 2202 ldap_search_attribute varchar(128) DEFAULT '' NOT NULL,\n\ 2203 dropdown_first_entry integer DEFAULT '1' NOT NULL,\n\ 2204 dropdown_first_remember integer DEFAULT '1' NOT NULL,\n\ 2205 discovery_groupid bigint NOT NULL REFERENCES groups (groupid),\n\ 2206 max_in_table integer DEFAULT '50' NOT NULL,\n\ 2207 search_limit integer DEFAULT '1000' NOT NULL,\n\ 2208 severity_color_0 varchar(6) DEFAULT '97AAB3' NOT NULL,\n\ 2209 severity_color_1 varchar(6) DEFAULT '7499FF' NOT NULL,\n\ 2210 severity_color_2 varchar(6) DEFAULT 'FFC859' NOT NULL,\n\ 2211 severity_color_3 varchar(6) DEFAULT 'FFA059' NOT NULL,\n\ 2212 severity_color_4 varchar(6) DEFAULT 'E97659' NOT NULL,\n\ 2213 severity_color_5 varchar(6) DEFAULT 'E45959' NOT NULL,\n\ 2214 severity_name_0 varchar(32) DEFAULT 'Not classified' NOT NULL,\n\ 2215 severity_name_1 varchar(32) DEFAULT 'Information' NOT NULL,\n\ 2216 severity_name_2 varchar(32) DEFAULT 'Warning' NOT NULL,\n\ 2217 severity_name_3 varchar(32) DEFAULT 'Average' NOT NULL,\n\ 2218 severity_name_4 varchar(32) DEFAULT 'High' NOT NULL,\n\ 2219 severity_name_5 varchar(32) DEFAULT 'Disaster' NOT NULL,\n\ 2220 ok_period integer DEFAULT '1800' NOT NULL,\n\ 2221 blink_period integer DEFAULT '1800' NOT NULL,\n\ 2222 problem_unack_color varchar(6) DEFAULT 'DC0000' NOT NULL,\n\ 2223 problem_ack_color varchar(6) DEFAULT 'DC0000' NOT NULL,\n\ 2224 ok_unack_color varchar(6) DEFAULT '00AA00' NOT NULL,\n\ 2225 ok_ack_color varchar(6) DEFAULT '00AA00' NOT NULL,\n\ 2226 problem_unack_style integer DEFAULT '1' NOT NULL,\n\ 2227 problem_ack_style integer DEFAULT '1' NOT NULL,\n\ 2228 ok_unack_style integer DEFAULT '1' NOT NULL,\n\ 2229 ok_ack_style integer DEFAULT '1' NOT NULL,\n\ 2230 snmptrap_logging integer DEFAULT '1' NOT NULL,\n\ 2231 server_check_interval integer DEFAULT '10' NOT NULL,\n\ 2232 hk_events_mode integer DEFAULT '1' NOT NULL,\n\ 2233 hk_events_trigger integer DEFAULT '365' NOT NULL,\n\ 2234 hk_events_internal integer DEFAULT '365' NOT NULL,\n\ 2235 hk_events_discovery integer DEFAULT '365' NOT NULL,\n\ 2236 hk_events_autoreg integer DEFAULT '365' NOT NULL,\n\ 2237 hk_services_mode integer DEFAULT '1' NOT NULL,\n\ 2238 hk_services integer DEFAULT '365' NOT NULL,\n\ 2239 hk_audit_mode integer DEFAULT '1' NOT NULL,\n\ 2240 hk_audit integer DEFAULT '365' NOT NULL,\n\ 2241 hk_sessions_mode integer DEFAULT '1' NOT NULL,\n\ 2242 hk_sessions integer DEFAULT '365' NOT NULL,\n\ 2243 hk_history_mode integer DEFAULT '1' NOT NULL,\n\ 2244 hk_history_global integer DEFAULT '0' NOT NULL,\n\ 2245 hk_history integer DEFAULT '90' NOT NULL,\n\ 2246 hk_trends_mode integer DEFAULT '1' NOT NULL,\n\ 2247 hk_trends_global integer DEFAULT '0' NOT NULL,\n\ 2248 hk_trends integer DEFAULT '365' NOT NULL,\n\ 2249 default_inventory_mode integer DEFAULT '-1' NOT NULL,\n\ 2250 PRIMARY KEY (configid)\n\ 2251 );\n\ 2252 CREATE INDEX config_1 ON config (alert_usrgrpid);\n\ 2253 CREATE INDEX config_2 ON config (discovery_groupid);\n\ 2254 CREATE TABLE triggers (\n\ 2255 triggerid bigint NOT NULL,\n\ 2256 expression varchar(2048) DEFAULT '' NOT NULL,\n\ 2257 description varchar(255) DEFAULT '' NOT NULL,\n\ 2258 url varchar(255) DEFAULT '' NOT NULL,\n\ 2259 status integer DEFAULT '0' NOT NULL,\n\ 2260 value integer DEFAULT '0' NOT NULL,\n\ 2261 priority integer DEFAULT '0' NOT NULL,\n\ 2262 lastchange integer DEFAULT '0' NOT NULL,\n\ 2263 comments text DEFAULT '' NOT NULL,\n\ 2264 error varchar(128) DEFAULT '' NOT NULL,\n\ 2265 templateid bigint NULL REFERENCES triggers (triggerid) ON DELETE CASCADE,\n\ 2266 type integer DEFAULT '0' NOT NULL,\n\ 2267 state integer DEFAULT '0' NOT NULL,\n\ 2268 flags integer DEFAULT '0' NOT NULL,\n\ 2269 PRIMARY KEY (triggerid)\n\ 2270 );\n\ 2271 CREATE INDEX triggers_1 ON triggers (status);\n\ 2272 CREATE INDEX triggers_2 ON triggers (value,lastchange);\n\ 2273 CREATE INDEX triggers_3 ON triggers (templateid);\n\ 2274 CREATE TABLE trigger_depends (\n\ 2275 triggerdepid bigint NOT NULL,\n\ 2276 triggerid_down bigint NOT NULL REFERENCES triggers (triggerid) ON DELETE CASCADE,\n\ 2277 triggerid_up bigint NOT NULL REFERENCES triggers (triggerid) ON DELETE CASCADE,\n\ 2278 PRIMARY KEY (triggerdepid)\n\ 2279 );\n\ 2280 CREATE UNIQUE INDEX trigger_depends_1 ON trigger_depends (triggerid_down,triggerid_up);\n\ 2281 CREATE INDEX trigger_depends_2 ON trigger_depends (triggerid_up);\n\ 2282 CREATE TABLE functions (\n\ 2283 functionid bigint NOT NULL,\n\ 2284 itemid bigint NOT NULL REFERENCES items (itemid) ON DELETE CASCADE,\n\ 2285 triggerid bigint NOT NULL REFERENCES triggers (triggerid) ON DELETE CASCADE,\n\ 2286 function varchar(12) DEFAULT '' NOT NULL,\n\ 2287 parameter varchar(255) DEFAULT '0' NOT NULL,\n\ 2288 PRIMARY KEY (functionid)\n\ 2289 );\n\ 2290 CREATE INDEX functions_1 ON functions (triggerid);\n\ 2291 CREATE INDEX functions_2 ON functions (itemid,function,parameter);\n\ 2292 CREATE TABLE graphs (\n\ 2293 graphid bigint NOT NULL,\n\ 2294 name varchar(128) DEFAULT '' NOT NULL,\n\ 2295 width integer DEFAULT '900' NOT NULL,\n\ 2296 height integer DEFAULT '200' NOT NULL,\n\ 2297 yaxismin double(16,4) DEFAULT '0' NOT NULL,\n\ 2298 yaxismax double(16,4) DEFAULT '100' NOT NULL,\n\ 2299 templateid bigint NULL REFERENCES graphs (graphid) ON DELETE CASCADE,\n\ 2300 show_work_period integer DEFAULT '1' NOT NULL,\n\ 2301 show_triggers integer DEFAULT '1' NOT NULL,\n\ 2302 graphtype integer DEFAULT '0' NOT NULL,\n\ 2303 show_legend integer DEFAULT '1' NOT NULL,\n\ 2304 show_3d integer DEFAULT '0' NOT NULL,\n\ 2305 percent_left double(16,4) DEFAULT '0' NOT NULL,\n\ 2306 percent_right double(16,4) DEFAULT '0' NOT NULL,\n\ 2307 ymin_type integer DEFAULT '0' NOT NULL,\n\ 2308 ymax_type integer DEFAULT '0' NOT NULL,\n\ 2309 ymin_itemid bigint NULL REFERENCES items (itemid),\n\ 2310 ymax_itemid bigint NULL REFERENCES items (itemid),\n\ 2311 flags integer DEFAULT '0' NOT NULL,\n\ 2312 PRIMARY KEY (graphid)\n\ 2313 );\n\ 2314 CREATE INDEX graphs_1 ON graphs (name);\n\ 2315 CREATE INDEX graphs_2 ON graphs (templateid);\n\ 2316 CREATE INDEX graphs_3 ON graphs (ymin_itemid);\n\ 2317 CREATE INDEX graphs_4 ON graphs (ymax_itemid);\n\ 2318 CREATE TABLE graphs_items (\n\ 2319 gitemid bigint NOT NULL,\n\ 2320 graphid bigint NOT NULL REFERENCES graphs (graphid) ON DELETE CASCADE,\n\ 2321 itemid bigint NOT NULL REFERENCES items (itemid) ON DELETE CASCADE,\n\ 2322 drawtype integer DEFAULT '0' NOT NULL,\n\ 2323 sortorder integer DEFAULT '0' NOT NULL,\n\ 2324 color varchar(6) DEFAULT '009600' NOT NULL,\n\ 2325 yaxisside integer DEFAULT '0' NOT NULL,\n\ 2326 calc_fnc integer DEFAULT '2' NOT NULL,\n\ 2327 type integer DEFAULT '0' NOT NULL,\n\ 2328 PRIMARY KEY (gitemid)\n\ 2329 );\n\ 2330 CREATE INDEX graphs_items_1 ON graphs_items (itemid);\n\ 2331 CREATE INDEX graphs_items_2 ON graphs_items (graphid);\n\ 2332 CREATE TABLE graph_theme (\n\ 2333 graphthemeid bigint NOT NULL,\n\ 2334 theme varchar(64) DEFAULT '' NOT NULL,\n\ 2335 backgroundcolor varchar(6) DEFAULT '' NOT NULL,\n\ 2336 graphcolor varchar(6) DEFAULT '' NOT NULL,\n\ 2337 gridcolor varchar(6) DEFAULT '' NOT NULL,\n\ 2338 maingridcolor varchar(6) DEFAULT '' NOT NULL,\n\ 2339 gridbordercolor varchar(6) DEFAULT '' NOT NULL,\n\ 2340 textcolor varchar(6) DEFAULT '' NOT NULL,\n\ 2341 highlightcolor varchar(6) DEFAULT '' NOT NULL,\n\ 2342 leftpercentilecolor varchar(6) DEFAULT '' NOT NULL,\n\ 2343 rightpercentilecolor varchar(6) DEFAULT '' NOT NULL,\n\ 2344 nonworktimecolor varchar(6) DEFAULT '' NOT NULL,\n\ 2345 PRIMARY KEY (graphthemeid)\n\ 2346 );\n\ 2347 CREATE UNIQUE INDEX graph_theme_1 ON graph_theme (theme);\n\ 2348 CREATE TABLE globalmacro (\n\ 2349 globalmacroid bigint NOT NULL,\n\ 2350 macro varchar(255) DEFAULT '' NOT NULL,\n\ 2351 value varchar(255) DEFAULT '' NOT NULL,\n\ 2352 PRIMARY KEY (globalmacroid)\n\ 2353 );\n\ 2354 CREATE UNIQUE INDEX globalmacro_1 ON globalmacro (macro);\n\ 2355 CREATE TABLE hostmacro (\n\ 2356 hostmacroid bigint NOT NULL,\n\ 2357 hostid bigint NOT NULL REFERENCES hosts (hostid) ON DELETE CASCADE,\n\ 2358 macro varchar(255) DEFAULT '' NOT NULL,\n\ 2359 value varchar(255) DEFAULT '' NOT NULL,\n\ 2360 PRIMARY KEY (hostmacroid)\n\ 2361 );\n\ 2362 CREATE UNIQUE INDEX hostmacro_1 ON hostmacro (hostid,macro);\n\ 2363 CREATE TABLE hosts_groups (\n\ 2364 hostgroupid bigint NOT NULL,\n\ 2365 hostid bigint NOT NULL REFERENCES hosts (hostid) ON DELETE CASCADE,\n\ 2366 groupid bigint NOT NULL REFERENCES groups (groupid) ON DELETE CASCADE,\n\ 2367 PRIMARY KEY (hostgroupid)\n\ 2368 );\n\ 2369 CREATE UNIQUE INDEX hosts_groups_1 ON hosts_groups (hostid,groupid);\n\ 2370 CREATE INDEX hosts_groups_2 ON hosts_groups (groupid);\n\ 2371 CREATE TABLE hosts_templates (\n\ 2372 hosttemplateid bigint NOT NULL,\n\ 2373 hostid bigint NOT NULL REFERENCES hosts (hostid) ON DELETE CASCADE,\n\ 2374 templateid bigint NOT NULL REFERENCES hosts (hostid) ON DELETE CASCADE,\n\ 2375 PRIMARY KEY (hosttemplateid)\n\ 2376 );\n\ 2377 CREATE UNIQUE INDEX hosts_templates_1 ON hosts_templates (hostid,templateid);\n\ 2378 CREATE INDEX hosts_templates_2 ON hosts_templates (templateid);\n\ 2379 CREATE TABLE items_applications (\n\ 2380 itemappid bigint NOT NULL,\n\ 2381 applicationid bigint NOT NULL REFERENCES applications (applicationid) ON DELETE CASCADE,\n\ 2382 itemid bigint NOT NULL REFERENCES items (itemid) ON DELETE CASCADE,\n\ 2383 PRIMARY KEY (itemappid)\n\ 2384 );\n\ 2385 CREATE UNIQUE INDEX items_applications_1 ON items_applications (applicationid,itemid);\n\ 2386 CREATE INDEX items_applications_2 ON items_applications (itemid);\n\ 2387 CREATE TABLE mappings (\n\ 2388 mappingid bigint NOT NULL,\n\ 2389 valuemapid bigint NOT NULL REFERENCES valuemaps (valuemapid) ON DELETE CASCADE,\n\ 2390 value varchar(64) DEFAULT '' NOT NULL,\n\ 2391 newvalue varchar(64) DEFAULT '' NOT NULL,\n\ 2392 PRIMARY KEY (mappingid)\n\ 2393 );\n\ 2394 CREATE INDEX mappings_1 ON mappings (valuemapid);\n\ 2395 CREATE TABLE media (\n\ 2396 mediaid bigint NOT NULL,\n\ 2397 userid bigint NOT NULL REFERENCES users (userid) ON DELETE CASCADE,\n\ 2398 mediatypeid bigint NOT NULL REFERENCES media_type (mediatypeid) ON DELETE CASCADE,\n\ 2399 sendto varchar(100) DEFAULT '' NOT NULL,\n\ 2400 active integer DEFAULT '0' NOT NULL,\n\ 2401 severity integer DEFAULT '63' NOT NULL,\n\ 2402 period varchar(100) DEFAULT '1-7,00:00-24:00' NOT NULL,\n\ 2403 PRIMARY KEY (mediaid)\n\ 2404 );\n\ 2405 CREATE INDEX media_1 ON media (userid);\n\ 2406 CREATE INDEX media_2 ON media (mediatypeid);\n\ 2407 CREATE TABLE rights (\n\ 2408 rightid bigint NOT NULL,\n\ 2409 groupid bigint NOT NULL REFERENCES usrgrp (usrgrpid) ON DELETE CASCADE,\n\ 2410 permission integer DEFAULT '0' NOT NULL,\n\ 2411 id bigint NOT NULL REFERENCES groups (groupid) ON DELETE CASCADE,\n\ 2412 PRIMARY KEY (rightid)\n\ 2413 );\n\ 2414 CREATE INDEX rights_1 ON rights (groupid);\n\ 2415 CREATE INDEX rights_2 ON rights (id);\n\ 2416 CREATE TABLE services (\n\ 2417 serviceid bigint NOT NULL,\n\ 2418 name varchar(128) DEFAULT '' NOT NULL,\n\ 2419 status integer DEFAULT '0' NOT NULL,\n\ 2420 algorithm integer DEFAULT '0' NOT NULL,\n\ 2421 triggerid bigint NULL REFERENCES triggers (triggerid) ON DELETE CASCADE,\n\ 2422 showsla integer DEFAULT '0' NOT NULL,\n\ 2423 goodsla double(16,4) DEFAULT '99.9' NOT NULL,\n\ 2424 sortorder integer DEFAULT '0' NOT NULL,\n\ 2425 PRIMARY KEY (serviceid)\n\ 2426 );\n\ 2427 CREATE INDEX services_1 ON services (triggerid);\n\ 2428 CREATE TABLE services_links (\n\ 2429 linkid bigint NOT NULL,\n\ 2430 serviceupid bigint NOT NULL REFERENCES services (serviceid) ON DELETE CASCADE,\n\ 2431 servicedownid bigint NOT NULL REFERENCES services (serviceid) ON DELETE CASCADE,\n\ 2432 soft integer DEFAULT '0' NOT NULL,\n\ 2433 PRIMARY KEY (linkid)\n\ 2434 );\n\ 2435 CREATE INDEX services_links_1 ON services_links (servicedownid);\n\ 2436 CREATE UNIQUE INDEX services_links_2 ON services_links (serviceupid,servicedownid);\n\ 2437 CREATE TABLE services_times (\n\ 2438 timeid bigint NOT NULL,\n\ 2439 serviceid bigint NOT NULL REFERENCES services (serviceid) ON DELETE CASCADE,\n\ 2440 type integer DEFAULT '0' NOT NULL,\n\ 2441 ts_from integer DEFAULT '0' NOT NULL,\n\ 2442 ts_to integer DEFAULT '0' NOT NULL,\n\ 2443 note varchar(255) DEFAULT '' NOT NULL,\n\ 2444 PRIMARY KEY (timeid)\n\ 2445 );\n\ 2446 CREATE INDEX services_times_1 ON services_times (serviceid,type,ts_from,ts_to);\n\ 2447 CREATE TABLE icon_map (\n\ 2448 iconmapid bigint NOT NULL,\n\ 2449 name varchar(64) DEFAULT '' NOT NULL,\n\ 2450 default_iconid bigint NOT NULL REFERENCES images (imageid),\n\ 2451 PRIMARY KEY (iconmapid)\n\ 2452 );\n\ 2453 CREATE UNIQUE INDEX icon_map_1 ON icon_map (name);\n\ 2454 CREATE INDEX icon_map_2 ON icon_map (default_iconid);\n\ 2455 CREATE TABLE icon_mapping (\n\ 2456 iconmappingid bigint NOT NULL,\n\ 2457 iconmapid bigint NOT NULL REFERENCES icon_map (iconmapid) ON DELETE CASCADE,\n\ 2458 iconid bigint NOT NULL REFERENCES images (imageid),\n\ 2459 inventory_link integer DEFAULT '0' NOT NULL,\n\ 2460 expression varchar(64) DEFAULT '' NOT NULL,\n\ 2461 sortorder integer DEFAULT '0' NOT NULL,\n\ 2462 PRIMARY KEY (iconmappingid)\n\ 2463 );\n\ 2464 CREATE INDEX icon_mapping_1 ON icon_mapping (iconmapid);\n\ 2465 CREATE INDEX icon_mapping_2 ON icon_mapping (iconid);\n\ 2466 CREATE TABLE sysmaps (\n\ 2467 sysmapid bigint NOT NULL,\n\ 2468 name varchar(128) DEFAULT '' NOT NULL,\n\ 2469 width integer DEFAULT '600' NOT NULL,\n\ 2470 height integer DEFAULT '400' NOT NULL,\n\ 2471 backgroundid bigint NULL REFERENCES images (imageid),\n\ 2472 label_type integer DEFAULT '2' NOT NULL,\n\ 2473 label_location integer DEFAULT '0' NOT NULL,\n\ 2474 highlight integer DEFAULT '1' NOT NULL,\n\ 2475 expandproblem integer DEFAULT '1' NOT NULL,\n\ 2476 markelements integer DEFAULT '0' NOT NULL,\n\ 2477 show_unack integer DEFAULT '0' NOT NULL,\n\ 2478 grid_size integer DEFAULT '50' NOT NULL,\n\ 2479 grid_show integer DEFAULT '1' NOT NULL,\n\ 2480 grid_align integer DEFAULT '1' NOT NULL,\n\ 2481 label_format integer DEFAULT '0' NOT NULL,\n\ 2482 label_type_host integer DEFAULT '2' NOT NULL,\n\ 2483 label_type_hostgroup integer DEFAULT '2' NOT NULL,\n\ 2484 label_type_trigger integer DEFAULT '2' NOT NULL,\n\ 2485 label_type_map integer DEFAULT '2' NOT NULL,\n\ 2486 label_type_image integer DEFAULT '2' NOT NULL,\n\ 2487 label_string_host varchar(255) DEFAULT '' NOT NULL,\n\ 2488 label_string_hostgroup varchar(255) DEFAULT '' NOT NULL,\n\ 2489 label_string_trigger varchar(255) DEFAULT '' NOT NULL,\n\ 2490 label_string_map varchar(255) DEFAULT '' NOT NULL,\n\ 2491 label_string_image varchar(255) DEFAULT '' NOT NULL,\n\ 2492 iconmapid bigint NULL REFERENCES icon_map (iconmapid),\n\ 2493 expand_macros integer DEFAULT '0' NOT NULL,\n\ 2494 severity_min integer DEFAULT '0' NOT NULL,\n\ 2495 userid bigint NOT NULL REFERENCES users (userid),\n\ 2496 private integer DEFAULT '1' NOT NULL,\n\ 2497 PRIMARY KEY (sysmapid)\n\ 2498 );\n\ 2499 CREATE UNIQUE INDEX sysmaps_1 ON sysmaps (name);\n\ 2500 CREATE INDEX sysmaps_2 ON sysmaps (backgroundid);\n\ 2501 CREATE INDEX sysmaps_3 ON sysmaps (iconmapid);\n\ 2502 CREATE TABLE sysmaps_elements (\n\ 2503 selementid bigint NOT NULL,\n\ 2504 sysmapid bigint NOT NULL REFERENCES sysmaps (sysmapid) ON DELETE CASCADE,\n\ 2505 elementid bigint DEFAULT '0' NOT NULL,\n\ 2506 elementtype integer DEFAULT '0' NOT NULL,\n\ 2507 iconid_off bigint NULL REFERENCES images (imageid),\n\ 2508 iconid_on bigint NULL REFERENCES images (imageid),\n\ 2509 label varchar(2048) DEFAULT '' NOT NULL,\n\ 2510 label_location integer DEFAULT '-1' NOT NULL,\n\ 2511 x integer DEFAULT '0' NOT NULL,\n\ 2512 y integer DEFAULT '0' NOT NULL,\n\ 2513 iconid_disabled bigint NULL REFERENCES images (imageid),\n\ 2514 iconid_maintenance bigint NULL REFERENCES images (imageid),\n\ 2515 elementsubtype integer DEFAULT '0' NOT NULL,\n\ 2516 areatype integer DEFAULT '0' NOT NULL,\n\ 2517 width integer DEFAULT '200' NOT NULL,\n\ 2518 height integer DEFAULT '200' NOT NULL,\n\ 2519 viewtype integer DEFAULT '0' NOT NULL,\n\ 2520 use_iconmap integer DEFAULT '1' NOT NULL,\n\ 2521 application varchar(255) DEFAULT '' NOT NULL,\n\ 2522 PRIMARY KEY (selementid)\n\ 2523 );\n\ 2524 CREATE INDEX sysmaps_elements_1 ON sysmaps_elements (sysmapid);\n\ 2525 CREATE INDEX sysmaps_elements_2 ON sysmaps_elements (iconid_off);\n\ 2526 CREATE INDEX sysmaps_elements_3 ON sysmaps_elements (iconid_on);\n\ 2527 CREATE INDEX sysmaps_elements_4 ON sysmaps_elements (iconid_disabled);\n\ 2528 CREATE INDEX sysmaps_elements_5 ON sysmaps_elements (iconid_maintenance);\n\ 2529 CREATE TABLE sysmaps_links (\n\ 2530 linkid bigint NOT NULL,\n\ 2531 sysmapid bigint NOT NULL REFERENCES sysmaps (sysmapid) ON DELETE CASCADE,\n\ 2532 selementid1 bigint NOT NULL REFERENCES sysmaps_elements (selementid) ON DELETE CASCADE,\n\ 2533 selementid2 bigint NOT NULL REFERENCES sysmaps_elements (selementid) ON DELETE CASCADE,\n\ 2534 drawtype integer DEFAULT '0' NOT NULL,\n\ 2535 color varchar(6) DEFAULT '000000' NOT NULL,\n\ 2536 label varchar(2048) DEFAULT '' NOT NULL,\n\ 2537 PRIMARY KEY (linkid)\n\ 2538 );\n\ 2539 CREATE INDEX sysmaps_links_1 ON sysmaps_links (sysmapid);\n\ 2540 CREATE INDEX sysmaps_links_2 ON sysmaps_links (selementid1);\n\ 2541 CREATE INDEX sysmaps_links_3 ON sysmaps_links (selementid2);\n\ 2542 CREATE TABLE sysmaps_link_triggers (\n\ 2543 linktriggerid bigint NOT NULL,\n\ 2544 linkid bigint NOT NULL REFERENCES sysmaps_links (linkid) ON DELETE CASCADE,\n\ 2545 triggerid bigint NOT NULL REFERENCES triggers (triggerid) ON DELETE CASCADE,\n\ 2546 drawtype integer DEFAULT '0' NOT NULL,\n\ 2547 color varchar(6) DEFAULT '000000' NOT NULL,\n\ 2548 PRIMARY KEY (linktriggerid)\n\ 2549 );\n\ 2550 CREATE UNIQUE INDEX sysmaps_link_triggers_1 ON sysmaps_link_triggers (linkid,triggerid);\n\ 2551 CREATE INDEX sysmaps_link_triggers_2 ON sysmaps_link_triggers (triggerid);\n\ 2552 CREATE TABLE sysmap_element_url (\n\ 2553 sysmapelementurlid bigint NOT NULL,\n\ 2554 selementid bigint NOT NULL REFERENCES sysmaps_elements (selementid) ON DELETE CASCADE,\n\ 2555 name varchar(255) NOT NULL,\n\ 2556 url varchar(255) DEFAULT '' NOT NULL,\n\ 2557 PRIMARY KEY (sysmapelementurlid)\n\ 2558 );\n\ 2559 CREATE UNIQUE INDEX sysmap_element_url_1 ON sysmap_element_url (selementid,name);\n\ 2560 CREATE TABLE sysmap_url (\n\ 2561 sysmapurlid bigint NOT NULL,\n\ 2562 sysmapid bigint NOT NULL REFERENCES sysmaps (sysmapid) ON DELETE CASCADE,\n\ 2563 name varchar(255) NOT NULL,\n\ 2564 url varchar(255) DEFAULT '' NOT NULL,\n\ 2565 elementtype integer DEFAULT '0' NOT NULL,\n\ 2566 PRIMARY KEY (sysmapurlid)\n\ 2567 );\n\ 2568 CREATE UNIQUE INDEX sysmap_url_1 ON sysmap_url (sysmapid,name);\n\ 2569 CREATE TABLE sysmap_user (\n\ 2570 sysmapuserid bigint NOT NULL,\n\ 2571 sysmapid bigint NOT NULL REFERENCES sysmaps (sysmapid) ON DELETE CASCADE,\n\ 2572 userid bigint NOT NULL REFERENCES users (userid) ON DELETE CASCADE,\n\ 2573 permission integer DEFAULT '2' NOT NULL,\n\ 2574 PRIMARY KEY (sysmapuserid)\n\ 2575 );\n\ 2576 CREATE UNIQUE INDEX sysmap_user_1 ON sysmap_user (sysmapid,userid);\n\ 2577 CREATE TABLE sysmap_usrgrp (\n\ 2578 sysmapusrgrpid bigint NOT NULL,\n\ 2579 sysmapid bigint NOT NULL REFERENCES sysmaps (sysmapid) ON DELETE CASCADE,\n\ 2580 usrgrpid bigint NOT NULL REFERENCES usrgrp (usrgrpid) ON DELETE CASCADE,\n\ 2581 permission integer DEFAULT '2' NOT NULL,\n\ 2582 PRIMARY KEY (sysmapusrgrpid)\n\ 2583 );\n\ 2584 CREATE UNIQUE INDEX sysmap_usrgrp_1 ON sysmap_usrgrp (sysmapid,usrgrpid);\n\ 2585 CREATE TABLE maintenances_hosts (\n\ 2586 maintenance_hostid bigint NOT NULL,\n\ 2587 maintenanceid bigint NOT NULL REFERENCES maintenances (maintenanceid) ON DELETE CASCADE,\n\ 2588 hostid bigint NOT NULL REFERENCES hosts (hostid) ON DELETE CASCADE,\n\ 2589 PRIMARY KEY (maintenance_hostid)\n\ 2590 );\n\ 2591 CREATE UNIQUE INDEX maintenances_hosts_1 ON maintenances_hosts (maintenanceid,hostid);\n\ 2592 CREATE INDEX maintenances_hosts_2 ON maintenances_hosts (hostid);\n\ 2593 CREATE TABLE maintenances_groups (\n\ 2594 maintenance_groupid bigint NOT NULL,\n\ 2595 maintenanceid bigint NOT NULL REFERENCES maintenances (maintenanceid) ON DELETE CASCADE,\n\ 2596 groupid bigint NOT NULL REFERENCES groups (groupid) ON DELETE CASCADE,\n\ 2597 PRIMARY KEY (maintenance_groupid)\n\ 2598 );\n\ 2599 CREATE UNIQUE INDEX maintenances_groups_1 ON maintenances_groups (maintenanceid,groupid);\n\ 2600 CREATE INDEX maintenances_groups_2 ON maintenances_groups (groupid);\n\ 2601 CREATE TABLE timeperiods (\n\ 2602 timeperiodid bigint NOT NULL,\n\ 2603 timeperiod_type integer DEFAULT '0' NOT NULL,\n\ 2604 every integer DEFAULT '1' NOT NULL,\n\ 2605 month integer DEFAULT '0' NOT NULL,\n\ 2606 dayofweek integer DEFAULT '0' NOT NULL,\n\ 2607 day integer DEFAULT '0' NOT NULL,\n\ 2608 start_time integer DEFAULT '0' NOT NULL,\n\ 2609 period integer DEFAULT '0' NOT NULL,\n\ 2610 start_date integer DEFAULT '0' NOT NULL,\n\ 2611 PRIMARY KEY (timeperiodid)\n\ 2612 );\n\ 2613 CREATE TABLE maintenances_windows (\n\ 2614 maintenance_timeperiodid bigint NOT NULL,\n\ 2615 maintenanceid bigint NOT NULL REFERENCES maintenances (maintenanceid) ON DELETE CASCADE,\n\ 2616 timeperiodid bigint NOT NULL REFERENCES timeperiods (timeperiodid) ON DELETE CASCADE,\n\ 2617 PRIMARY KEY (maintenance_timeperiodid)\n\ 2618 );\n\ 2619 CREATE UNIQUE INDEX maintenances_windows_1 ON maintenances_windows (maintenanceid,timeperiodid);\n\ 2620 CREATE INDEX maintenances_windows_2 ON maintenances_windows (timeperiodid);\n\ 2621 CREATE TABLE regexps (\n\ 2622 regexpid bigint NOT NULL,\n\ 2623 name varchar(128) DEFAULT '' NOT NULL,\n\ 2624 test_string text DEFAULT '' NOT NULL,\n\ 2625 PRIMARY KEY (regexpid)\n\ 2626 );\n\ 2627 CREATE UNIQUE INDEX regexps_1 ON regexps (name);\n\ 2628 CREATE TABLE expressions (\n\ 2629 expressionid bigint NOT NULL,\n\ 2630 regexpid bigint NOT NULL REFERENCES regexps (regexpid) ON DELETE CASCADE,\n\ 2631 expression varchar(255) DEFAULT '' NOT NULL,\n\ 2632 expression_type integer DEFAULT '0' NOT NULL,\n\ 2633 exp_delimiter varchar(1) DEFAULT '' NOT NULL,\n\ 2634 case_sensitive integer DEFAULT '0' NOT NULL,\n\ 2635 PRIMARY KEY (expressionid)\n\ 2636 );\n\ 2637 CREATE INDEX expressions_1 ON expressions (regexpid);\n\ 2638 CREATE TABLE ids (\n\ 2639 table_name varchar(64) DEFAULT '' NOT NULL,\n\ 2640 field_name varchar(64) DEFAULT '' NOT NULL,\n\ 2641 nextid bigint NOT NULL,\n\ 2642 PRIMARY KEY (table_name,field_name)\n\ 2643 );\n\ 2644 CREATE TABLE alerts (\n\ 2645 alertid bigint NOT NULL,\n\ 2646 actionid bigint NOT NULL REFERENCES actions (actionid) ON DELETE CASCADE,\n\ 2647 eventid bigint NOT NULL REFERENCES events (eventid) ON DELETE CASCADE,\n\ 2648 userid bigint NULL REFERENCES users (userid) ON DELETE CASCADE,\n\ 2649 clock integer DEFAULT '0' NOT NULL,\n\ 2650 mediatypeid bigint NULL REFERENCES media_type (mediatypeid) ON DELETE CASCADE,\n\ 2651 sendto varchar(100) DEFAULT '' NOT NULL,\n\ 2652 subject varchar(255) DEFAULT '' NOT NULL,\n\ 2653 message text DEFAULT '' NOT NULL,\n\ 2654 status integer DEFAULT '0' NOT NULL,\n\ 2655 retries integer DEFAULT '0' NOT NULL,\n\ 2656 error varchar(128) DEFAULT '' NOT NULL,\n\ 2657 esc_step integer DEFAULT '0' NOT NULL,\n\ 2658 alerttype integer DEFAULT '0' NOT NULL,\n\ 2659 PRIMARY KEY (alertid)\n\ 2660 );\n\ 2661 CREATE INDEX alerts_1 ON alerts (actionid);\n\ 2662 CREATE INDEX alerts_2 ON alerts (clock);\n\ 2663 CREATE INDEX alerts_3 ON alerts (eventid);\n\ 2664 CREATE INDEX alerts_4 ON alerts (status,retries);\n\ 2665 CREATE INDEX alerts_5 ON alerts (mediatypeid);\n\ 2666 CREATE INDEX alerts_6 ON alerts (userid);\n\ 2667 CREATE TABLE history (\n\ 2668 itemid bigint NOT NULL,\n\ 2669 clock integer DEFAULT '0' NOT NULL,\n\ 2670 value double(16,4) DEFAULT '0.0000' NOT NULL,\n\ 2671 ns integer DEFAULT '0' NOT NULL\n\ 2672 );\n\ 2673 CREATE INDEX history_1 ON history (itemid,clock);\n\ 2674 CREATE TABLE history_uint (\n\ 2675 itemid bigint NOT NULL,\n\ 2676 clock integer DEFAULT '0' NOT NULL,\n\ 2677 value bigint DEFAULT '0' NOT NULL,\n\ 2678 ns integer DEFAULT '0' NOT NULL\n\ 2679 );\n\ 2680 CREATE INDEX history_uint_1 ON history_uint (itemid,clock);\n\ 2681 CREATE TABLE history_str (\n\ 2682 itemid bigint NOT NULL,\n\ 2683 clock integer DEFAULT '0' NOT NULL,\n\ 2684 value varchar(255) DEFAULT '' NOT NULL,\n\ 2685 ns integer DEFAULT '0' NOT NULL\n\ 2686 );\n\ 2687 CREATE INDEX history_str_1 ON history_str (itemid,clock);\n\ 2688 CREATE TABLE history_log (\n\ 2689 id bigint NOT NULL,\n\ 2690 itemid bigint NOT NULL,\n\ 2691 clock integer DEFAULT '0' NOT NULL,\n\ 2692 timestamp integer DEFAULT '0' NOT NULL,\n\ 2693 source varchar(64) DEFAULT '' NOT NULL,\n\ 2694 severity integer DEFAULT '0' NOT NULL,\n\ 2695 value text DEFAULT '' NOT NULL,\n\ 2696 logeventid integer DEFAULT '0' NOT NULL,\n\ 2697 ns integer DEFAULT '0' NOT NULL,\n\ 2698 PRIMARY KEY (id)\n\ 2699 );\n\ 2700 CREATE INDEX history_log_1 ON history_log (itemid,clock);\n\ 2701 CREATE UNIQUE INDEX history_log_2 ON history_log (itemid,id);\n\ 2702 CREATE TABLE history_text (\n\ 2703 id bigint NOT NULL,\n\ 2704 itemid bigint NOT NULL,\n\ 2705 clock integer DEFAULT '0' NOT NULL,\n\ 2706 value text DEFAULT '' NOT NULL,\n\ 2707 ns integer DEFAULT '0' NOT NULL,\n\ 2708 PRIMARY KEY (id)\n\ 2709 );\n\ 2710 CREATE INDEX history_text_1 ON history_text (itemid,clock);\n\ 2711 CREATE UNIQUE INDEX history_text_2 ON history_text (itemid,id);\n\ 2712 CREATE TABLE proxy_history (\n\ 2713 id integer NOT NULL PRIMARY KEY AUTOINCREMENT,\n\ 2714 itemid bigint NOT NULL,\n\ 2715 clock integer DEFAULT '0' NOT NULL,\n\ 2716 timestamp integer DEFAULT '0' NOT NULL,\n\ 2717 source varchar(64) DEFAULT '' NOT NULL,\n\ 2718 severity integer DEFAULT '0' NOT NULL,\n\ 2719 value text DEFAULT '' NOT NULL,\n\ 2720 logeventid integer DEFAULT '0' NOT NULL,\n\ 2721 ns integer DEFAULT '0' NOT NULL,\n\ 2722 state integer DEFAULT '0' NOT NULL,\n\ 2723 lastlogsize bigint DEFAULT '0' NOT NULL,\n\ 2724 mtime integer DEFAULT '0' NOT NULL,\n\ 2725 flags integer DEFAULT '0' NOT NULL\n\ 2726 );\n\ 2727 CREATE INDEX proxy_history_1 ON proxy_history (clock);\n\ 2728 CREATE TABLE proxy_dhistory (\n\ 2729 id integer NOT NULL PRIMARY KEY AUTOINCREMENT,\n\ 2730 clock integer DEFAULT '0' NOT NULL,\n\ 2731 druleid bigint NOT NULL,\n\ 2732 type integer DEFAULT '0' NOT NULL,\n\ 2733 ip varchar(39) DEFAULT '' NOT NULL,\n\ 2734 port integer DEFAULT '0' NOT NULL,\n\ 2735 key_ varchar(255) DEFAULT '' NOT NULL,\n\ 2736 value varchar(255) DEFAULT '' NOT NULL,\n\ 2737 status integer DEFAULT '0' NOT NULL,\n\ 2738 dcheckid bigint NULL,\n\ 2739 dns varchar(64) DEFAULT '' NOT NULL\n\ 2740 );\n\ 2741 CREATE INDEX proxy_dhistory_1 ON proxy_dhistory (clock);\n\ 2742 CREATE TABLE events (\n\ 2743 eventid bigint NOT NULL,\n\ 2744 source integer DEFAULT '0' NOT NULL,\n\ 2745 object integer DEFAULT '0' NOT NULL,\n\ 2746 objectid bigint DEFAULT '0' NOT NULL,\n\ 2747 clock integer DEFAULT '0' NOT NULL,\n\ 2748 value integer DEFAULT '0' NOT NULL,\n\ 2749 acknowledged integer DEFAULT '0' NOT NULL,\n\ 2750 ns integer DEFAULT '0' NOT NULL,\n\ 2751 PRIMARY KEY (eventid)\n\ 2752 );\n\ 2753 CREATE INDEX events_1 ON events (source,object,objectid,clock);\n\ 2754 CREATE INDEX events_2 ON events (source,object,clock);\n\ 2755 CREATE TABLE trends (\n\ 2756 itemid bigint NOT NULL,\n\ 2757 clock integer DEFAULT '0' NOT NULL,\n\ 2758 num integer DEFAULT '0' NOT NULL,\n\ 2759 value_min double(16,4) DEFAULT '0.0000' NOT NULL,\n\ 2760 value_avg double(16,4) DEFAULT '0.0000' NOT NULL,\n\ 2761 value_max double(16,4) DEFAULT '0.0000' NOT NULL,\n\ 2762 PRIMARY KEY (itemid,clock)\n\ 2763 );\n\ 2764 CREATE TABLE trends_uint (\n\ 2765 itemid bigint NOT NULL,\n\ 2766 clock integer DEFAULT '0' NOT NULL,\n\ 2767 num integer DEFAULT '0' NOT NULL,\n\ 2768 value_min bigint DEFAULT '0' NOT NULL,\n\ 2769 value_avg bigint DEFAULT '0' NOT NULL,\n\ 2770 value_max bigint DEFAULT '0' NOT NULL,\n\ 2771 PRIMARY KEY (itemid,clock)\n\ 2772 );\n\ 2773 CREATE TABLE acknowledges (\n\ 2774 acknowledgeid bigint NOT NULL,\n\ 2775 userid bigint NOT NULL REFERENCES users (userid) ON DELETE CASCADE,\n\ 2776 eventid bigint NOT NULL REFERENCES events (eventid) ON DELETE CASCADE,\n\ 2777 clock integer DEFAULT '0' NOT NULL,\n\ 2778 message varchar(255) DEFAULT '' NOT NULL,\n\ 2779 PRIMARY KEY (acknowledgeid)\n\ 2780 );\n\ 2781 CREATE INDEX acknowledges_1 ON acknowledges (userid);\n\ 2782 CREATE INDEX acknowledges_2 ON acknowledges (eventid);\n\ 2783 CREATE INDEX acknowledges_3 ON acknowledges (clock);\n\ 2784 CREATE TABLE auditlog (\n\ 2785 auditid bigint NOT NULL,\n\ 2786 userid bigint NOT NULL REFERENCES users (userid) ON DELETE CASCADE,\n\ 2787 clock integer DEFAULT '0' NOT NULL,\n\ 2788 action integer DEFAULT '0' NOT NULL,\n\ 2789 resourcetype integer DEFAULT '0' NOT NULL,\n\ 2790 details varchar(128) DEFAULT '0' NOT NULL,\n\ 2791 ip varchar(39) DEFAULT '' NOT NULL,\n\ 2792 resourceid bigint DEFAULT '0' NOT NULL,\n\ 2793 resourcename varchar(255) DEFAULT '' NOT NULL,\n\ 2794 PRIMARY KEY (auditid)\n\ 2795 );\n\ 2796 CREATE INDEX auditlog_1 ON auditlog (userid,clock);\n\ 2797 CREATE INDEX auditlog_2 ON auditlog (clock);\n\ 2798 CREATE TABLE auditlog_details (\n\ 2799 auditdetailid bigint NOT NULL,\n\ 2800 auditid bigint NOT NULL REFERENCES auditlog (auditid) ON DELETE CASCADE,\n\ 2801 table_name varchar(64) DEFAULT '' NOT NULL,\n\ 2802 field_name varchar(64) DEFAULT '' NOT NULL,\n\ 2803 oldvalue text DEFAULT '' NOT NULL,\n\ 2804 newvalue text DEFAULT '' NOT NULL,\n\ 2805 PRIMARY KEY (auditdetailid)\n\ 2806 );\n\ 2807 CREATE INDEX auditlog_details_1 ON auditlog_details (auditid);\n\ 2808 CREATE TABLE service_alarms (\n\ 2809 servicealarmid bigint NOT NULL,\n\ 2810 serviceid bigint NOT NULL REFERENCES services (serviceid) ON DELETE CASCADE,\n\ 2811 clock integer DEFAULT '0' NOT NULL,\n\ 2812 value integer DEFAULT '0' NOT NULL,\n\ 2813 PRIMARY KEY (servicealarmid)\n\ 2814 );\n\ 2815 CREATE INDEX service_alarms_1 ON service_alarms (serviceid,clock);\n\ 2816 CREATE INDEX service_alarms_2 ON service_alarms (clock);\n\ 2817 CREATE TABLE autoreg_host (\n\ 2818 autoreg_hostid bigint NOT NULL,\n\ 2819 proxy_hostid bigint NULL REFERENCES hosts (hostid) ON DELETE CASCADE,\n\ 2820 host varchar(64) DEFAULT '' NOT NULL,\n\ 2821 listen_ip varchar(39) DEFAULT '' NOT NULL,\n\ 2822 listen_port integer DEFAULT '0' NOT NULL,\n\ 2823 listen_dns varchar(64) DEFAULT '' NOT NULL,\n\ 2824 host_metadata varchar(255) DEFAULT '' NOT NULL,\n\ 2825 PRIMARY KEY (autoreg_hostid)\n\ 2826 );\n\ 2827 CREATE INDEX autoreg_host_1 ON autoreg_host (proxy_hostid,host);\n\ 2828 CREATE TABLE proxy_autoreg_host (\n\ 2829 id integer NOT NULL PRIMARY KEY AUTOINCREMENT,\n\ 2830 clock integer DEFAULT '0' NOT NULL,\n\ 2831 host varchar(64) DEFAULT '' NOT NULL,\n\ 2832 listen_ip varchar(39) DEFAULT '' NOT NULL,\n\ 2833 listen_port integer DEFAULT '0' NOT NULL,\n\ 2834 listen_dns varchar(64) DEFAULT '' NOT NULL,\n\ 2835 host_metadata varchar(255) DEFAULT '' NOT NULL\n\ 2836 );\n\ 2837 CREATE INDEX proxy_autoreg_host_1 ON proxy_autoreg_host (clock);\n\ 2838 CREATE TABLE dhosts (\n\ 2839 dhostid bigint NOT NULL,\n\ 2840 druleid bigint NOT NULL REFERENCES drules (druleid) ON DELETE CASCADE,\n\ 2841 status integer DEFAULT '0' NOT NULL,\n\ 2842 lastup integer DEFAULT '0' NOT NULL,\n\ 2843 lastdown integer DEFAULT '0' NOT NULL,\n\ 2844 PRIMARY KEY (dhostid)\n\ 2845 );\n\ 2846 CREATE INDEX dhosts_1 ON dhosts (druleid);\n\ 2847 CREATE TABLE dservices (\n\ 2848 dserviceid bigint NOT NULL,\n\ 2849 dhostid bigint NOT NULL REFERENCES dhosts (dhostid) ON DELETE CASCADE,\n\ 2850 type integer DEFAULT '0' NOT NULL,\n\ 2851 key_ varchar(255) DEFAULT '' NOT NULL,\n\ 2852 value varchar(255) DEFAULT '' NOT NULL,\n\ 2853 port integer DEFAULT '0' NOT NULL,\n\ 2854 status integer DEFAULT '0' NOT NULL,\n\ 2855 lastup integer DEFAULT '0' NOT NULL,\n\ 2856 lastdown integer DEFAULT '0' NOT NULL,\n\ 2857 dcheckid bigint NOT NULL REFERENCES dchecks (dcheckid) ON DELETE CASCADE,\n\ 2858 ip varchar(39) DEFAULT '' NOT NULL,\n\ 2859 dns varchar(64) DEFAULT '' NOT NULL,\n\ 2860 PRIMARY KEY (dserviceid)\n\ 2861 );\n\ 2862 CREATE UNIQUE INDEX dservices_1 ON dservices (dcheckid,type,key_,ip,port);\n\ 2863 CREATE INDEX dservices_2 ON dservices (dhostid);\n\ 2864 CREATE TABLE escalations (\n\ 2865 escalationid bigint NOT NULL,\n\ 2866 actionid bigint NOT NULL,\n\ 2867 triggerid bigint NULL,\n\ 2868 eventid bigint NULL,\n\ 2869 r_eventid bigint NULL,\n\ 2870 nextcheck integer DEFAULT '0' NOT NULL,\n\ 2871 esc_step integer DEFAULT '0' NOT NULL,\n\ 2872 status integer DEFAULT '0' NOT NULL,\n\ 2873 itemid bigint NULL,\n\ 2874 PRIMARY KEY (escalationid)\n\ 2875 );\n\ 2876 CREATE UNIQUE INDEX escalations_1 ON escalations (actionid,triggerid,itemid,escalationid);\n\ 2877 CREATE TABLE globalvars (\n\ 2878 globalvarid bigint NOT NULL,\n\ 2879 snmp_lastsize integer DEFAULT '0' NOT NULL,\n\ 2880 PRIMARY KEY (globalvarid)\n\ 2881 );\n\ 2882 CREATE TABLE graph_discovery (\n\ 2883 graphid bigint NOT NULL REFERENCES graphs (graphid) ON DELETE CASCADE,\n\ 2884 parent_graphid bigint NOT NULL REFERENCES graphs (graphid),\n\ 2885 PRIMARY KEY (graphid)\n\ 2886 );\n\ 2887 CREATE INDEX graph_discovery_1 ON graph_discovery (parent_graphid);\n\ 2888 CREATE TABLE host_inventory (\n\ 2889 hostid bigint NOT NULL REFERENCES hosts (hostid) ON DELETE CASCADE,\n\ 2890 inventory_mode integer DEFAULT '0' NOT NULL,\n\ 2891 type varchar(64) DEFAULT '' NOT NULL,\n\ 2892 type_full varchar(64) DEFAULT '' NOT NULL,\n\ 2893 name varchar(64) DEFAULT '' NOT NULL,\n\ 2894 alias varchar(64) DEFAULT '' NOT NULL,\n\ 2895 os varchar(64) DEFAULT '' NOT NULL,\n\ 2896 os_full varchar(255) DEFAULT '' NOT NULL,\n\ 2897 os_short varchar(64) DEFAULT '' NOT NULL,\n\ 2898 serialno_a varchar(64) DEFAULT '' NOT NULL,\n\ 2899 serialno_b varchar(64) DEFAULT '' NOT NULL,\n\ 2900 tag varchar(64) DEFAULT '' NOT NULL,\n\ 2901 asset_tag varchar(64) DEFAULT '' NOT NULL,\n\ 2902 macaddress_a varchar(64) DEFAULT '' NOT NULL,\n\ 2903 macaddress_b varchar(64) DEFAULT '' NOT NULL,\n\ 2904 hardware varchar(255) DEFAULT '' NOT NULL,\n\ 2905 hardware_full text DEFAULT '' NOT NULL,\n\ 2906 software varchar(255) DEFAULT '' NOT NULL,\n\ 2907 software_full text DEFAULT '' NOT NULL,\n\ 2908 software_app_a varchar(64) DEFAULT '' NOT NULL,\n\ 2909 software_app_b varchar(64) DEFAULT '' NOT NULL,\n\ 2910 software_app_c varchar(64) DEFAULT '' NOT NULL,\n\ 2911 software_app_d varchar(64) DEFAULT '' NOT NULL,\n\ 2912 software_app_e varchar(64) DEFAULT '' NOT NULL,\n\ 2913 contact text DEFAULT '' NOT NULL,\n\ 2914 location text DEFAULT '' NOT NULL,\n\ 2915 location_lat varchar(16) DEFAULT '' NOT NULL,\n\ 2916 location_lon varchar(16) DEFAULT '' NOT NULL,\n\ 2917 notes text DEFAULT '' NOT NULL,\n\ 2918 chassis varchar(64) DEFAULT '' NOT NULL,\n\ 2919 model varchar(64) DEFAULT '' NOT NULL,\n\ 2920 hw_arch varchar(32) DEFAULT '' NOT NULL,\n\ 2921 vendor varchar(64) DEFAULT '' NOT NULL,\n\ 2922 contract_number varchar(64) DEFAULT '' NOT NULL,\n\ 2923 installer_name varchar(64) DEFAULT '' NOT NULL,\n\ 2924 deployment_status varchar(64) DEFAULT '' NOT NULL,\n\ 2925 url_a varchar(255) DEFAULT '' NOT NULL,\n\ 2926 url_b varchar(255) DEFAULT '' NOT NULL,\n\ 2927 url_c varchar(255) DEFAULT '' NOT NULL,\n\ 2928 host_networks text DEFAULT '' NOT NULL,\n\ 2929 host_netmask varchar(39) DEFAULT '' NOT NULL,\n\ 2930 host_router varchar(39) DEFAULT '' NOT NULL,\n\ 2931 oob_ip varchar(39) DEFAULT '' NOT NULL,\n\ 2932 oob_netmask varchar(39) DEFAULT '' NOT NULL,\n\ 2933 oob_router varchar(39) DEFAULT '' NOT NULL,\n\ 2934 date_hw_purchase varchar(64) DEFAULT '' NOT NULL,\n\ 2935 date_hw_install varchar(64) DEFAULT '' NOT NULL,\n\ 2936 date_hw_expiry varchar(64) DEFAULT '' NOT NULL,\n\ 2937 date_hw_decomm varchar(64) DEFAULT '' NOT NULL,\n\ 2938 site_address_a varchar(128) DEFAULT '' NOT NULL,\n\ 2939 site_address_b varchar(128) DEFAULT '' NOT NULL,\n\ 2940 site_address_c varchar(128) DEFAULT '' NOT NULL,\n\ 2941 site_city varchar(128) DEFAULT '' NOT NULL,\n\ 2942 site_state varchar(64) DEFAULT '' NOT NULL,\n\ 2943 site_country varchar(64) DEFAULT '' NOT NULL,\n\ 2944 site_zip varchar(64) DEFAULT '' NOT NULL,\n\ 2945 site_rack varchar(128) DEFAULT '' NOT NULL,\n\ 2946 site_notes text DEFAULT '' NOT NULL,\n\ 2947 poc_1_name varchar(128) DEFAULT '' NOT NULL,\n\ 2948 poc_1_email varchar(128) DEFAULT '' NOT NULL,\n\ 2949 poc_1_phone_a varchar(64) DEFAULT '' NOT NULL,\n\ 2950 poc_1_phone_b varchar(64) DEFAULT '' NOT NULL,\n\ 2951 poc_1_cell varchar(64) DEFAULT '' NOT NULL,\n\ 2952 poc_1_screen varchar(64) DEFAULT '' NOT NULL,\n\ 2953 poc_1_notes text DEFAULT '' NOT NULL,\n\ 2954 poc_2_name varchar(128) DEFAULT '' NOT NULL,\n\ 2955 poc_2_email varchar(128) DEFAULT '' NOT NULL,\n\ 2956 poc_2_phone_a varchar(64) DEFAULT '' NOT NULL,\n\ 2957 poc_2_phone_b varchar(64) DEFAULT '' NOT NULL,\n\ 2958 poc_2_cell varchar(64) DEFAULT '' NOT NULL,\n\ 2959 poc_2_screen varchar(64) DEFAULT '' NOT NULL,\n\ 2960 poc_2_notes text DEFAULT '' NOT NULL,\n\ 2961 PRIMARY KEY (hostid)\n\ 2962 );\n\ 2963 CREATE TABLE housekeeper (\n\ 2964 housekeeperid bigint NOT NULL,\n\ 2965 tablename varchar(64) DEFAULT '' NOT NULL,\n\ 2966 field varchar(64) DEFAULT '' NOT NULL,\n\ 2967 value bigint NOT NULL,\n\ 2968 PRIMARY KEY (housekeeperid)\n\ 2969 );\n\ 2970 CREATE TABLE images (\n\ 2971 imageid bigint NOT NULL,\n\ 2972 imagetype integer DEFAULT '0' NOT NULL,\n\ 2973 name varchar(64) DEFAULT '0' NOT NULL,\n\ 2974 image longblob DEFAULT '' NOT NULL,\n\ 2975 PRIMARY KEY (imageid)\n\ 2976 );\n\ 2977 CREATE UNIQUE INDEX images_1 ON images (name);\n\ 2978 CREATE TABLE item_discovery (\n\ 2979 itemdiscoveryid bigint NOT NULL,\n\ 2980 itemid bigint NOT NULL REFERENCES items (itemid) ON DELETE CASCADE,\n\ 2981 parent_itemid bigint NOT NULL REFERENCES items (itemid) ON DELETE CASCADE,\n\ 2982 key_ varchar(255) DEFAULT '' NOT NULL,\n\ 2983 lastcheck integer DEFAULT '0' NOT NULL,\n\ 2984 ts_delete integer DEFAULT '0' NOT NULL,\n\ 2985 PRIMARY KEY (itemdiscoveryid)\n\ 2986 );\n\ 2987 CREATE UNIQUE INDEX item_discovery_1 ON item_discovery (itemid,parent_itemid);\n\ 2988 CREATE INDEX item_discovery_2 ON item_discovery (parent_itemid);\n\ 2989 CREATE TABLE host_discovery (\n\ 2990 hostid bigint NOT NULL REFERENCES hosts (hostid) ON DELETE CASCADE,\n\ 2991 parent_hostid bigint NULL REFERENCES hosts (hostid),\n\ 2992 parent_itemid bigint NULL REFERENCES items (itemid),\n\ 2993 host varchar(64) DEFAULT '' NOT NULL,\n\ 2994 lastcheck integer DEFAULT '0' NOT NULL,\n\ 2995 ts_delete integer DEFAULT '0' NOT NULL,\n\ 2996 PRIMARY KEY (hostid)\n\ 2997 );\n\ 2998 CREATE TABLE interface_discovery (\n\ 2999 interfaceid bigint NOT NULL REFERENCES interface (interfaceid) ON DELETE CASCADE,\n\ 3000 parent_interfaceid bigint NOT NULL REFERENCES interface (interfaceid) ON DELETE CASCADE,\n\ 3001 PRIMARY KEY (interfaceid)\n\ 3002 );\n\ 3003 CREATE TABLE profiles (\n\ 3004 profileid bigint NOT NULL,\n\ 3005 userid bigint NOT NULL REFERENCES users (userid) ON DELETE CASCADE,\n\ 3006 idx varchar(96) DEFAULT '' NOT NULL,\n\ 3007 idx2 bigint DEFAULT '0' NOT NULL,\n\ 3008 value_id bigint DEFAULT '0' NOT NULL,\n\ 3009 value_int integer DEFAULT '0' NOT NULL,\n\ 3010 value_str varchar(255) DEFAULT '' NOT NULL,\n\ 3011 source varchar(96) DEFAULT '' NOT NULL,\n\ 3012 type integer DEFAULT '0' NOT NULL,\n\ 3013 PRIMARY KEY (profileid)\n\ 3014 );\n\ 3015 CREATE INDEX profiles_1 ON profiles (userid,idx,idx2);\n\ 3016 CREATE INDEX profiles_2 ON profiles (userid,profileid);\n\ 3017 CREATE TABLE sessions (\n\ 3018 sessionid varchar(32) DEFAULT '' NOT NULL,\n\ 3019 userid bigint NOT NULL REFERENCES users (userid) ON DELETE CASCADE,\n\ 3020 lastaccess integer DEFAULT '0' NOT NULL,\n\ 3021 status integer DEFAULT '0' NOT NULL,\n\ 3022 PRIMARY KEY (sessionid)\n\ 3023 );\n\ 3024 CREATE INDEX sessions_1 ON sessions (userid,status);\n\ 3025 CREATE TABLE trigger_discovery (\n\ 3026 triggerid bigint NOT NULL REFERENCES triggers (triggerid) ON DELETE CASCADE,\n\ 3027 parent_triggerid bigint NOT NULL REFERENCES triggers (triggerid),\n\ 3028 PRIMARY KEY (triggerid)\n\ 3029 );\n\ 3030 CREATE INDEX trigger_discovery_1 ON trigger_discovery (parent_triggerid);\n\ 3031 CREATE TABLE application_template (\n\ 3032 application_templateid bigint NOT NULL,\n\ 3033 applicationid bigint NOT NULL REFERENCES applications (applicationid) ON DELETE CASCADE,\n\ 3034 templateid bigint NOT NULL REFERENCES applications (applicationid) ON DELETE CASCADE,\n\ 3035 PRIMARY KEY (application_templateid)\n\ 3036 );\n\ 3037 CREATE UNIQUE INDEX application_template_1 ON application_template (applicationid,templateid);\n\ 3038 CREATE INDEX application_template_2 ON application_template (templateid);\n\ 3039 CREATE TABLE item_condition (\n\ 3040 item_conditionid bigint NOT NULL,\n\ 3041 itemid bigint NOT NULL REFERENCES items (itemid) ON DELETE CASCADE,\n\ 3042 operator integer DEFAULT '8' NOT NULL,\n\ 3043 macro varchar(64) DEFAULT '' NOT NULL,\n\ 3044 value varchar(255) DEFAULT '' NOT NULL,\n\ 3045 PRIMARY KEY (item_conditionid)\n\ 3046 );\n\ 3047 CREATE INDEX item_condition_1 ON item_condition (itemid);\n\ 3048 CREATE TABLE application_prototype (\n\ 3049 application_prototypeid bigint NOT NULL,\n\ 3050 itemid bigint NOT NULL REFERENCES items (itemid) ON DELETE CASCADE,\n\ 3051 templateid bigint NULL REFERENCES application_prototype (application_prototypeid) ON DELETE CASCADE,\n\ 3052 name varchar(255) DEFAULT '' NOT NULL,\n\ 3053 PRIMARY KEY (application_prototypeid)\n\ 3054 );\n\ 3055 CREATE INDEX application_prototype_1 ON application_prototype (itemid);\n\ 3056 CREATE INDEX application_prototype_2 ON application_prototype (templateid);\n\ 3057 CREATE TABLE item_application_prototype (\n\ 3058 item_application_prototypeid bigint NOT NULL,\n\ 3059 application_prototypeid bigint NOT NULL REFERENCES application_prototype (application_prototypeid) ON DELETE CASCADE,\n\ 3060 itemid bigint NOT NULL REFERENCES items (itemid) ON DELETE CASCADE,\n\ 3061 PRIMARY KEY (item_application_prototypeid)\n\ 3062 );\n\ 3063 CREATE UNIQUE INDEX item_application_prototype_1 ON item_application_prototype (application_prototypeid,itemid);\n\ 3064 CREATE INDEX item_application_prototype_2 ON item_application_prototype (itemid);\n\ 3065 CREATE TABLE application_discovery (\n\ 3066 application_discoveryid bigint NOT NULL,\n\ 3067 applicationid bigint NOT NULL REFERENCES applications (applicationid) ON DELETE CASCADE,\n\ 3068 application_prototypeid bigint NOT NULL REFERENCES application_prototype (application_prototypeid) ON DELETE CASCADE,\n\ 3069 name varchar(255) DEFAULT '' NOT NULL,\n\ 3070 lastcheck integer DEFAULT '0' NOT NULL,\n\ 3071 ts_delete integer DEFAULT '0' NOT NULL,\n\ 3072 PRIMARY KEY (application_discoveryid)\n\ 3073 );\n\ 3074 CREATE INDEX application_discovery_1 ON application_discovery (applicationid);\n\ 3075 CREATE INDEX application_discovery_2 ON application_discovery (application_prototypeid);\n\ 3076 CREATE TABLE opinventory (\n\ 3077 operationid bigint NOT NULL REFERENCES operations (operationid) ON DELETE CASCADE,\n\ 3078 inventory_mode integer DEFAULT '0' NOT NULL,\n\ 3079 PRIMARY KEY (operationid)\n\ 3080 );\n\ 3081 CREATE TABLE dbversion (\n\ 3082 mandatory integer DEFAULT '0' NOT NULL,\n\ 3083 optional integer DEFAULT '0' NOT NULL\n\ 3084 );\n\ 3085 INSERT INTO dbversion VALUES ('3000000','3000000');\n\ 3086 "; 3087 const char *const db_schema_fkeys[] = { 3088 NULL 3089 }; 3090 #else /* HAVE_SQLITE3 */ 3091 const char *const db_schema = NULL; 3092 #endif /* not HAVE_SQLITE3 */ 3093