diff options
Diffstat (limited to 'frontends/php/create')
-rw-r--r-- | frontends/php/create/mysql.sql | 1058 |
1 files changed, 490 insertions, 568 deletions
diff --git a/frontends/php/create/mysql.sql b/frontends/php/create/mysql.sql index 0413a05b..a537c362 100644 --- a/frontends/php/create/mysql.sql +++ b/frontends/php/create/mysql.sql @@ -1,704 +1,626 @@ --- --- ZABBIX --- Copyright (C) 2000-2005 SIA Zabbix --- --- This program is free software; you can redistribute it and/or modify --- it under the terms of the GNU General Public License as published by --- the Free Software Foundation; either version 2 of the License, or --- (at your option) any later version. --- --- This program is distributed in the hope that it will be useful, --- but WITHOUT ANY WARRANTY; without even the implied warranty of --- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the --- GNU General Public License for more details. --- --- You should have received a copy of the GNU General Public License --- along with this program; if not, write to the Free Software --- Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA. --- - --- --- Table structure for table 'nodes' --- - CREATE TABLE nodes ( - nodeid {integer} DEFAULT '0' NOT NULL, - name {varchar}(64) DEFAULT '' NOT NULL, - timezone {integer} DEFAULT '0' NOT NULL, - ip {varchar}(15) DEFAULT '' NOT NULL, - port {integer} DEFAULT '0' NOT NULL, - slave_history {integer} DEFAULT '0' NOT NULL, - slave_trends {integer} DEFAULT '0' NOT NULL, - event_lastid {bigint} DEFAULT '0' NOT NULL, - history_lastid {bigint} DEFAULT '0' NOT NULL, - nodetype {integer} DEFAULT '0' NOT NULL, - masterid {bigint} DEFAULT '0' NOT NULL, + nodeid bigint unsigned DEFAULT '0' NOT NULL, + name varchar(64) DEFAULT '0' NOT NULL, + timezone integer DEFAULT '0' NOT NULL, + ip varchar(15) DEFAULT '' NOT NULL, + port integer DEFAULT '10051' NOT NULL, + slave_history integer DEFAULT '30' NOT NULL, + slave_trends integer DEFAULT '365' NOT NULL, + event_lastid bigint unsigned DEFAULT '0' NOT NULL, + event_maxid bigint unsigned DEFAULT '0' NOT NULL, + history_lastid bigint unsigned DEFAULT '0' NOT NULL, + history_str_lastid bigint unsigned DEFAULT '0' NOT NULL, + history_uint_lastid bigint unsigned DEFAULT '0' NOT NULL, + nodetype integer DEFAULT '0' NOT NULL, + masterid bigint unsigned DEFAULT '0' NOT NULL, PRIMARY KEY (nodeid) -) {create_table_opt}; - +); CREATE TABLE node_cksum ( - cksumid {bigint} DEFAULT '0' NOT NULL, - nodeid {bigint} DEFAULT '0' NOT NULL, - tablename {varchar}(64) DEFAULT '' NOT NULL, - fieldname {varchar}(64) DEFAULT '' NOT NULL, - recordid {bigint} DEFAULT '0' NOT NULL, - cksumtype {integer} DEFAULT '0' NOT NULL, - cksum {char}(32) DEFAULT '' NOT NULL, + cksumid bigint unsigned DEFAULT '0' NOT NULL, + nodeid bigint unsigned DEFAULT '0' NOT NULL, + tablename varchar(64) DEFAULT '' NOT NULL, + fieldname varchar(64) DEFAULT '' NOT NULL, + recordid bigint unsigned DEFAULT '0' NOT NULL, + cksumtype integer DEFAULT '0' NOT NULL, + cksum char(32) DEFAULT '' NOT NULL, PRIMARY KEY (cksumid) -) {create_table_opt}; - -CREATE INDEX node_cksum_1 ON node_cksum (nodeid,tablename,fieldname,recordid,cksumtype); +); +CREATE INDEX node_cksum_cksum_1 on node_cksum (nodeid,tablename,fieldname,recordid,cksumtype); CREATE TABLE node_configlog ( - conflogid {bigint} DEFAULT '0' NOT NULL, - nodeid {bigint} DEFAULT '0' NOT NULL, - tablename {varchar}(64) DEFAULT '' NOT NULL, - recordid {bigint} DEFAULT '0' NOT NULL, - operation {integer} DEFAULT '0' NOT NULL, - sync_master {integer} DEFAULT '0' NOT NULL, - sync_slave {integer} DEFAULT '0' NOT NULL, + conflogid bigint unsigned DEFAULT '0' NOT NULL, + nodeid bigint unsigned DEFAULT '0' NOT NULL, + tablename varchar(64) DEFAULT '' NOT NULL, + recordid bigint unsigned DEFAULT '0' NOT NULL, + operation integer DEFAULT '0' NOT NULL, + sync_master integer DEFAULT '0' NOT NULL, + sync_slave integer DEFAULT '0' NOT NULL, PRIMARY KEY (nodeid,conflogid) -) {create_table_opt}; - -CREATE INDEX node_configlog_1 ON node_configlog (conflogid); -CREATE INDEX node_configlog_2 ON node_configlog (nodeid,tablename); +); +CREATE INDEX node_configlog_configlog_1 on node_configlog (conflogid); +CREATE INDEX node_configlog_configlog_2 on node_configlog (nodeid,tablename); CREATE TABLE services ( - serviceid {bigint} DEFAULT '0' NOT NULL, - name {varchar}(128) DEFAULT '' NOT NULL, - status {integer} DEFAULT '0' NOT NULL, - algorithm {integer} DEFAULT '0' NOT NULL, - triggerid {bigint}, - showsla {integer} DEFAULT '0' NOT NULL, - goodsla {double}(5,2) DEFAULT '99.9' NOT NULL, - sortorder {integer} DEFAULT '0' NOT NULL, + serviceid bigint unsigned DEFAULT '0' NOT NULL, + name varchar(128) DEFAULT '' NOT NULL, + status integer DEFAULT '0' NOT NULL, + algorithm integer DEFAULT '0' NOT NULL, + triggerid bigint unsigned , + showsla integer DEFAULT '0' NOT NULL, + goodsla double(5,2) DEFAULT '99.9' NOT NULL, + sortorder integer DEFAULT '0' NOT NULL, PRIMARY KEY (serviceid) -) {create_table_opt}; - +); CREATE TABLE services_times ( - timeid {bigint} DEFAULT '0' NOT NULL, - serviceid {bigint} DEFAULT '0' NOT NULL, - type {integer} DEFAULT '0' NOT NULL, - ts_from {integer} DEFAULT '0' NOT NULL, - ts_to {integer} DEFAULT '0' NOT NULL, - note {varchar}(255) DEFAULT '' NOT NULL, + timeid bigint unsigned DEFAULT '0' NOT NULL, + serviceid bigint unsigned DEFAULT '0' NOT NULL, + type integer DEFAULT '0' NOT NULL, + ts_from integer DEFAULT '0' NOT NULL, + ts_to integer DEFAULT '0' NOT NULL, + note varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (timeid) -) {create_table_opt}; - -CREATE INDEX services_times_1 ON services_times (serviceid,type,ts_from,ts_to); +); +CREATE INDEX services_times_times_1 on services_times (serviceid,type,ts_from,ts_to); CREATE TABLE services_links ( - linkid {bigint} DEFAULT '0' NOT NULL, - serviceupid {bigint} DEFAULT '0' NOT NULL, - servicedownid {bigint} DEFAULT '0' NOT NULL, - soft {integer} DEFAULT '0' NOT NULL, + linkid bigint unsigned DEFAULT '0' NOT NULL, + serviceupid bigint unsigned DEFAULT '0' NOT NULL, + servicedownid bigint unsigned DEFAULT '0' NOT NULL, + soft integer DEFAULT '0' NOT NULL, PRIMARY KEY (linkid) -) {create_table_opt}; - -CREATE INDEX services_links_1 ON services_links (servicedownid); -CREATE INDEX services_links_2 ON services_links (serviceupid,servicedownid); +); +CREATE INDEX services_links_links_1 on services_links (servicedownid); +CREATE INDEX services_links_links_2 on services_links (serviceupid,servicedownid); CREATE TABLE graphs_items ( - gitemid {bigint} DEFAULT '0' NOT NULL, - graphid {bigint} DEFAULT '0' NOT NULL, - itemid {bigint} DEFAULT '0' NOT NULL, - drawtype {integer} DEFAULT '0' NOT NULL, - sortorder {integer} DEFAULT '0' NOT NULL, - color {varchar}(32) DEFAULT 'Dark Green' NOT NULL, - yaxisside {integer} DEFAULT '1' NOT NULL, - calc_fnc {integer} DEFAULT '2' NOT NULL, - type {integer} DEFAULT '0' NOT NULL, - periods_cnt {integer} DEFAULT '5' NOT NULL, + gitemid bigint unsigned DEFAULT '0' NOT NULL, + graphid bigint unsigned DEFAULT '0' NOT NULL, + itemid bigint unsigned DEFAULT '0' NOT NULL, + drawtype integer DEFAULT '0' NOT NULL, + sortorder integer DEFAULT '0' NOT NULL, + color varchar(32) DEFAULT 'Dark Green' NOT NULL, + yaxisside integer DEFAULT '1' NOT NULL, + calc_fnc integer DEFAULT '2' NOT NULL, + type integer DEFAULT '0' NOT NULL, + periods_cnt integer DEFAULT '5' NOT NULL, PRIMARY KEY (gitemid) -) {create_table_opt}; - +); CREATE TABLE graphs ( - graphid {bigint} DEFAULT '0' NOT NULL, - name {varchar}(128) DEFAULT '' NOT NULL, - width {integer} DEFAULT '0' NOT NULL, - height {integer} DEFAULT '0' NOT NULL, - yaxistype {integer} DEFAULT '0' NOT NULL, - yaxismin {double}(16,4) DEFAULT '0' NOT NULL, - yaxismax {double}(16,4) DEFAULT '0' NOT NULL, - templateid {bigint} DEFAULT '0' NOT NULL, - show_work_period {integer} DEFAULT '1' NOT NULL, - show_triggers {integer} DEFAULT '1' NOT NULL, - graphtype {integer} DEFAULT '0' NOT NULL, + graphid bigint unsigned DEFAULT '0' NOT NULL, + name varchar(128) DEFAULT '' NOT NULL, + width integer DEFAULT '0' NOT NULL, + height integer DEFAULT '0' NOT NULL, + yaxistype integer DEFAULT '0' NOT NULL, + yaxismin double(16,4) DEFAULT '0' NOT NULL, + yaxismax double(16,4) DEFAULT '0' NOT NULL, + templateid bigint unsigned DEFAULT '0' NOT NULL, + show_work_period integer DEFAULT '1' NOT NULL, + show_triggers integer DEFAULT '1' NOT NULL, + graphtype integer DEFAULT '0' NOT NULL, PRIMARY KEY (graphid) -) {create_table_opt}; - -CREATE INDEX graphs_1 ON graphs (name); +); +CREATE INDEX graphs_graphs_1 on graphs (name); CREATE TABLE sysmaps_links ( - linkid {bigint} DEFAULT '0' NOT NULL, - sysmapid {bigint} DEFAULT '0' NOT NULL, - selementid1 {bigint} DEFAULT '0' NOT NULL, - selementid2 {bigint} DEFAULT '0' NOT NULL, - triggerid {bigint}, - drawtype_off {integer} DEFAULT '0' NOT NULL, - color_off {varchar}(32) DEFAULT 'Black' NOT NULL, - drawtype_on {integer} DEFAULT '0' NOT NULL, - color_on {varchar}(32) DEFAULT 'Red' NOT NULL, + linkid bigint unsigned DEFAULT '0' NOT NULL, + sysmapid bigint unsigned DEFAULT '0' NOT NULL, + selementid1 bigint unsigned DEFAULT '0' NOT NULL, + selementid2 bigint unsigned DEFAULT '0' NOT NULL, + triggerid bigint unsigned , + drawtype_off integer DEFAULT '0' NOT NULL, + color_off varchar(32) DEFAULT 'Black' NOT NULL, + drawtype_on integer DEFAULT '0' NOT NULL, + color_on varchar(32) DEFAULT 'Red' NOT NULL, PRIMARY KEY (linkid) -) {create_table_opt}; - +); CREATE TABLE sysmaps_elements ( - selementid {bigint} DEFAULT '0' NOT NULL, - sysmapid {bigint} DEFAULT '0' NOT NULL, - elementid {bigint} DEFAULT '0' NOT NULL, - elementtype {integer} DEFAULT '0' NOT NULL, - iconid_off {bigint} DEFAULT '0' NOT NULL, - iconid_on {bigint} DEFAULT '0' NOT NULL, - label {varchar}(128) DEFAULT '' NOT NULL, - label_location {integer} DEFAULT NULL, - x {integer} DEFAULT '0' NOT NULL, - y {integer} DEFAULT '0' NOT NULL, - url {varchar}(255) DEFAULT '' NOT NULL, + selementid bigint unsigned DEFAULT '0' NOT NULL, + sysmapid bigint unsigned DEFAULT '0' NOT NULL, + elementid bigint unsigned DEFAULT '0' NOT NULL, + elementtype integer DEFAULT '0' NOT NULL, + iconid_off bigint unsigned DEFAULT '0' NOT NULL, + iconid_on bigint unsigned DEFAULT '0' NOT NULL, + label varchar(128) DEFAULT '' NOT NULL, + label_location integer NULL, + x integer DEFAULT '0' NOT NULL, + y integer DEFAULT '0' NOT NULL, + url varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (selementid) -) {create_table_opt}; - +); CREATE TABLE sysmaps ( - sysmapid {bigint} DEFAULT '0' NOT NULL, - name {varchar}(128) DEFAULT '' NOT NULL, - width {integer} DEFAULT '0' NOT NULL, - height {integer} DEFAULT '0' NOT NULL, - backgroundid {bigint} DEFAULT '0' NOT NULL, - label_type {integer} DEFAULT '0' NOT NULL, - label_location {integer} DEFAULT '0' NOT NULL, + sysmapid bigint unsigned DEFAULT '0' NOT NULL, + name varchar(128) DEFAULT '' NOT NULL, + width integer DEFAULT '0' NOT NULL, + height integer DEFAULT '0' NOT NULL, + backgroundid bigint unsigned DEFAULT '0' NOT NULL, + label_type integer DEFAULT '0' NOT NULL, + label_location integer DEFAULT '0' NOT NULL, PRIMARY KEY (sysmapid) -) {create_table_opt}; - -CREATE INDEX sysmaps_1 ON sysmaps (name); +); +CREATE INDEX sysmaps_1 on sysmaps (name); CREATE TABLE config ( - configid {bigint} DEFAULT '0' NOT NULL, - alert_history {integer} DEFAULT '0' NOT NULL, - event_history {integer} DEFAULT '0' NOT NULL, - refresh_unsupported {integer} DEFAULT '0' NOT NULL, - work_period {varchar}(100) DEFAULT '1-5,00:00-24:00' NOT NULL, + configid bigint unsigned DEFAULT '0' NOT NULL, + alert_history integer DEFAULT '0' NOT NULL, + event_history integer DEFAULT '0' NOT NULL, + refresh_unsupported integer DEFAULT '0' NOT NULL, + work_period varchar(100) DEFAULT '1-5,00:00-24:00' NOT NULL, PRIMARY KEY (configid) -) {create_table_opt}; - +); CREATE TABLE groups ( - groupid {bigint} DEFAULT '0' NOT NULL, - name {varchar}(64) DEFAULT '' NOT NULL, + groupid bigint unsigned DEFAULT '0' NOT NULL, + name varchar(64) DEFAULT '' NOT NULL, PRIMARY KEY (groupid) -) {create_table_opt}; - -CREATE INDEX groups_1 ON groups (name); +); +CREATE INDEX groups_1 on groups (name); CREATE TABLE hosts_groups ( - hostgroupid {bigint} DEFAULT '0' NOT NULL, - hostid {bigint} DEFAULT '0' NOT NULL, - groupid {bigint} DEFAULT '0' NOT NULL, + hostgroupid bigint unsigned DEFAULT '0' NOT NULL, + hostid bigint unsigned DEFAULT '0' NOT NULL, + groupid bigint unsigned DEFAULT '0' NOT NULL, PRIMARY KEY (hostgroupid) -) {create_table_opt}; - -CREATE INDEX hosts_groups_1 ON hosts_groups (hostid,groupid); +); +CREATE INDEX hosts_groups_groups_1 on hosts_groups (hostid,groupid); CREATE TABLE alerts ( - alertid {bigint} DEFAULT '0' NOT NULL, - actionid {bigint} DEFAULT '0' NOT NULL, - triggerid {bigint} DEFAULT '0' NOT NULL, - userid {bigint} DEFAULT '0' NOT NULL, - clock {integer} DEFAULT '0' NOT NULL, - mediatypeid {bigint} DEFAULT '0' NOT NULL, - sendto {varchar}(100) DEFAULT '' NOT NULL, - subject {varchar}(255) DEFAULT '' NOT NULL, - message {blob} DEFAULT '' NOT NULL, - status {integer} DEFAULT '0' NOT NULL, - retries {integer} DEFAULT '0' NOT NULL, - error {varchar}(128) DEFAULT '' NOT NULL, - repeats {integer} DEFAULT '0' NOT NULL, - maxrepeats {integer} DEFAULT '0' NOT NULL, - nextcheck {integer} DEFAULT '0' NOT NULL, - delay {integer} DEFAULT '0' NOT NULL, - + alertid bigint unsigned DEFAULT '0' NOT NULL, + actionid bigint unsigned DEFAULT '0' NOT NULL, + triggerid bigint unsigned DEFAULT '0' NOT NULL, + userid bigint unsigned DEFAULT '0' NOT NULL, + clock integer DEFAULT '0' NOT NULL, + mediatypeid bigint unsigned DEFAULT '0' NOT NULL, + sendto varchar(100) DEFAULT '' NOT NULL, + subject varchar(255) DEFAULT '' NOT NULL, + message blob DEFAULT '' NOT NULL, + status integer DEFAULT '0' NOT NULL, + retries integer DEFAULT '0' NOT NULL, + error varchar(128) DEFAULT '' NOT NULL, + repeats integer DEFAULT '0' NOT NULL, + maxrepeats integer DEFAULT '0' NOT NULL, + nextcheck integer DEFAULT '0' NOT NULL, + delay integer DEFAULT '0' NOT NULL, PRIMARY KEY (alertid) -) {create_table_opt}; - -CREATE INDEX alerts_1 ON alerts (actionid); -CREATE INDEX alerts_2 ON alerts (clock); -CREATE INDEX alerts_3 ON alerts (triggerid); -CREATE INDEX alerts_4 ON alerts (status, retries); -CREATE INDEX alerts_5 ON alerts (mediatypeid); -CREATE INDEX alerts_6 ON alerts (userid); +); +CREATE INDEX alerts_1 on alerts (actionid); +CREATE INDEX alerts_2 on alerts (clock); +CREATE INDEX alerts_3 on alerts (triggerid); +CREATE INDEX alerts_4 on alerts (status,retries); +CREATE INDEX alerts_5 on alerts (mediatypeid); +CREATE INDEX alerts_6 on alerts (userid); CREATE TABLE actions ( - actionid {bigint} DEFAULT '0' NOT NULL, - userid {bigint} DEFAULT '0' NOT NULL, - subject {varchar}(255) DEFAULT '' NOT NULL, - message {blob} DEFAULT '' NOT NULL, - recipient {integer} DEFAULT '0' NOT NULL, - maxrepeats {integer} DEFAULT '0' NOT NULL, - repeatdelay {integer} DEFAULT '600' NOT NULL, - source {integer} DEFAULT '0' NOT NULL, - actiontype {integer} DEFAULT '0' NOT NULL, - status {integer} DEFAULT '0' NOT NULL, - scripts {blob} DEFAULT '' NOT NULL, + actionid bigint unsigned DEFAULT '0' NOT NULL, + userid bigint unsigned DEFAULT '0' NOT NULL, + subject varchar(255) DEFAULT '' NOT NULL, + message blob DEFAULT '' NOT NULL, + recipient integer DEFAULT '0' NOT NULL, + maxrepeats integer DEFAULT '0' NOT NULL, + repeatdelay integer DEFAULT '600' NOT NULL, + source integer DEFAULT '0' NOT NULL, + actiontype integer DEFAULT '0' NOT NULL, + status integer DEFAULT '0' NOT NULL, + scripts blob DEFAULT '' NOT NULL, PRIMARY KEY (actionid) -) {create_table_opt}; - +); CREATE TABLE conditions ( - conditionid {bigint} DEFAULT '0' NOT NULL, - actionid {bigint} DEFAULT '0' NOT NULL, - conditiontype {integer} DEFAULT '0' NOT NULL, - operator {integer} DEFAULT '0' NOT NULL, - value {varchar}(255) DEFAULT '' NOT NULL, + conditionid bigint unsigned DEFAULT '0' NOT NULL, + actionid bigint unsigned DEFAULT '0' NOT NULL, + conditiontype integer DEFAULT '0' NOT NULL, + operator integer DEFAULT '0' NOT NULL, + value varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (conditionid) -) {create_table_opt}; - -CREATE INDEX conditions_1 ON conditions (actionid); +); +CREATE INDEX conditions_1 on conditions (actionid); CREATE TABLE events ( - eventid {bigint} DEFAULT '0' NOT NULL, - triggerid {bigint} DEFAULT '0' NOT NULL, - clock {integer} DEFAULT '0' NOT NULL, - value {integer} DEFAULT '0' NOT NULL, - acknowledged {integer} DEFAULT '0' NOT NULL, + eventid bigint unsigned DEFAULT '0' NOT NULL, + triggerid bigint unsigned DEFAULT '0' NOT NULL, + clock integer DEFAULT '0' NOT NULL, + value integer DEFAULT '0' NOT NULL, + acknowledged integer DEFAULT '0' NOT NULL, PRIMARY KEY (eventid) -) {create_table_opt}; - -CREATE INDEX events_1 ON events (triggerid,clock); -CREATE INDEX events_2 ON events (clock); +); +CREATE INDEX events_1 on events (triggerid,clock); +CREATE INDEX events_2 on events (clock); CREATE TABLE functions ( - functionid {bigint} DEFAULT '0' NOT NULL, - itemid {bigint} DEFAULT '0' NOT NULL, - triggerid {bigint} DEFAULT '0' NOT NULL, - lastvalue {varchar}(255), - function {varchar}(12) DEFAULT '' NOT NULL, - parameter {varchar}(255) DEFAULT '0' NOT NULL, + functionid bigint unsigned DEFAULT '0' NOT NULL, + itemid bigint unsigned DEFAULT '0' NOT NULL, + triggerid bigint unsigned DEFAULT '0' NOT NULL, + lastvalue varchar(255) , + function varchar(12) DEFAULT '' NOT NULL, + parameter varchar(255) DEFAULT '0' NOT NULL, PRIMARY KEY (functionid) -) {create_table_opt}; - -CREATE INDEX functions_1 ON functions (triggerid); -CREATE INDEX functions_2 ON functions (itemid,function,parameter); +); +CREATE INDEX functions_1 on functions (triggerid); +CREATE INDEX functions_2 on functions (itemid,function,parameter); CREATE TABLE history ( - itemid {bigint} DEFAULT '0' NOT NULL, - clock {integer} DEFAULT '0' NOT NULL, - value {double}(16,4) DEFAULT '0.0000' NOT NULL -) {create_table_opt}; - -CREATE INDEX history_1 ON history (itemid, clock); + itemid bigint unsigned DEFAULT '0' NOT NULL, + clock integer DEFAULT '0' NOT NULL, + value double(16,4) DEFAULT '0.0000' NOT NULL +); +CREATE INDEX history_1 on history (itemid,clock); CREATE TABLE history_sync ( - id {serial}, - nodeid {bigint} DEFAULT '0' NOT NULL, - itemid {bigint} DEFAULT '0' NOT NULL, - clock {integer} DEFAULT '0' NOT NULL, - value {double}(16,4) DEFAULT '0.0000' NOT NULL, + id serial , + nodeid bigint unsigned DEFAULT '0' NOT NULL, + itemid bigint unsigned DEFAULT '0' NOT NULL, + clock integer DEFAULT '0' NOT NULL, + value double(16,4) DEFAULT '0.0000' NOT NULL, PRIMARY KEY (id) -) {create_table_opt}; - -CREATE INDEX history_sync_1 ON history_sync (nodeid, id); +); +CREATE INDEX history_sync_1 on history_sync (nodeid,id); CREATE TABLE history_uint ( - itemid {bigint} DEFAULT '0' NOT NULL, - clock {integer} DEFAULT '0' NOT NULL, - value {bigint} DEFAULT '0' NOT NULL -) {create_table_opt}; - -CREATE INDEX history_uint_1 ON history_uint (itemid, clock); + itemid bigint unsigned DEFAULT '0' NOT NULL, + clock integer DEFAULT '0' NOT NULL, + value bigint unsigned DEFAULT '0' NOT NULL +); +CREATE INDEX history_uint_1 on history_uint (itemid,clock); CREATE TABLE history_uint_sync ( - id {serial}, - nodeid {integer} DEFAULT '0' NOT NULL, - itemid {bigint} DEFAULT '0' NOT NULL, - clock {integer} DEFAULT '0' NOT NULL, - value {bigint} DEFAULT '0' NOT NULL, + id serial , + nodeid bigint unsigned DEFAULT '0' NOT NULL, + itemid bigint unsigned DEFAULT '0' NOT NULL, + clock integer DEFAULT '0' NOT NULL, + value bigint unsigned DEFAULT '0' NOT NULL, PRIMARY KEY (id) -) {create_table_opt}; - -CREATE INDEX history_uint_sync_1 ON history_uint_sync (nodeid, id); +); +CREATE INDEX history_uint_sync_1 on history_uint_sync (nodeid,id); CREATE TABLE history_str ( - itemid {bigint} DEFAULT '0' NOT NULL, - clock {integer} DEFAULT '0' NOT NULL, - value {varchar}(255) DEFAULT '' NOT NULL -) {create_table_opt}; - -CREATE INDEX history_str_1 ON history_str (itemid, clock); + itemid bigint unsigned DEFAULT '0' NOT NULL, + clock integer DEFAULT '0' NOT NULL, + value varchar(255) DEFAULT '' NOT NULL +); +CREATE INDEX history_str_1 on history_str (itemid,clock); CREATE TABLE history_str_sync ( - id {serial}, - nodeid {integer} DEFAULT '0' NOT NULL, - itemid {bigint} DEFAULT '0' NOT NULL, - clock {integer} DEFAULT '0' NOT NULL, - value {varchar}(255) DEFAULT '' NOT NULL, + id serial , + nodeid bigint unsigned DEFAULT '0' NOT NULL, + itemid bigint unsigned DEFAULT '0' NOT NULL, + clock integer DEFAULT '0' NOT NULL, + value varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (id) -) {create_table_opt}; - -CREATE INDEX history_str_sync_1 ON history_str_sync (nodeid, id); +); +CREATE INDEX history_str_sync_1 on history_str_sync (nodeid,id); CREATE TABLE hosts ( - hostid {bigint} DEFAULT '0' NOT NULL, - host {varchar}(64) DEFAULT '' NOT NULL, - useip {integer} DEFAULT '1' NOT NULL, - ip {varchar}(15) DEFAULT '127.0.0.1' NOT NULL, - port {integer} DEFAULT '0' NOT NULL, - status {integer} DEFAULT '0' NOT NULL, - disable_until {integer} DEFAULT '0' NOT NULL, - error {varchar}(128) DEFAULT '' NOT NULL, - available {integer} DEFAULT '0' NOT NULL, - errors_from {integer} DEFAULT '0' NOT NULL, - PRIMARY KEY (hostid) -) {create_table_opt}; - -CREATE INDEX hosts_1 ON hosts (host); -CREATE INDEX hosts_2 ON hosts (status); + hostid bigint unsigned DEFAULT '0' NOT NULL, + host varchar(64) DEFAULT '' NOT NULL, + useip integer DEFAULT '1' NOT NULL, + ip varchar(15) DEFAULT '127.0.0.1' NOT NULL, + port integer DEFAULT '0' NOT NULL, + status integer DEFAULT '0' NOT NULL, + disable_until integer DEFAULT '0' NOT NULL, + error varchar(128) DEFAULT '' NOT NULL, + available integer DEFAULT '0' NOT NULL, + errors_from integer DEFAULT '0' NOT NULL, + PRIMARY KEY (hostid) +); +CREATE INDEX hosts_1 on hosts (host); +CREATE INDEX hosts_2 on hosts (status); CREATE TABLE items ( - itemid {bigint} DEFAULT '0' NOT NULL, - type {integer} DEFAULT '0' NOT NULL, - snmp_community {varchar}(64) DEFAULT '' NOT NULL, - snmp_oid {varchar}(255) DEFAULT '' NOT NULL, - snmp_port {integer} DEFAULT '161' NOT NULL, - hostid {bigint} DEFAULT '0' NOT NULL, - description {varchar}(255) DEFAULT '' NOT NULL, - key_ {varchar}(64) DEFAULT '' NOT NULL, - delay {integer} DEFAULT '0' NOT NULL, - history {integer} DEFAULT '90' NOT NULL, - trends {integer} DEFAULT '365' NOT NULL, - nextcheck {integer} DEFAULT '0' NOT NULL, - lastvalue {varchar}(255) DEFAULT NULL, - lastclock {integer} DEFAULT NULL, - prevvalue {varchar}(255) DEFAULT NULL, - status {integer} DEFAULT '0' NOT NULL, - value_type {integer} DEFAULT '0' NOT NULL, - trapper_hosts {varchar}(255) DEFAULT '' NOT NULL, - units {varchar}(10) DEFAULT '' NOT NULL, - multiplier {integer} DEFAULT '0' NOT NULL, - delta {integer} DEFAULT '0' NOT NULL, - prevorgvalue {double}(16,4) DEFAULT NULL, - snmpv3_securityname {varchar}(64) DEFAULT '' NOT NULL, - snmpv3_securitylevel {integer} DEFAULT '0' NOT NULL, - snmpv3_authpassphrase {varchar}(64) DEFAULT '' NOT NULL, - snmpv3_privpassphrase {varchar}(64) DEFAULT '' NOT NULL, - - formula {varchar}(255) DEFAULT '0' NOT NULL, - error {varchar}(128) DEFAULT '' NOT NULL, - - lastlogsize {integer} DEFAULT '0' NOT NULL, - logtimefmt {varchar}(64) DEFAULT '' NOT NULL, - templateid {bigint} DEFAULT '0' NOT NULL, - valuemapid {bigint} DEFAULT '0' NOT NULL, - delay_flex {varchar}(255) DEFAULT '' NOT NULL, - - PRIMARY KEY (itemid) -) {create_table_opt}; - -CREATE INDEX items_1 ON items (hostid,key_); -CREATE INDEX items_2 ON items (nextcheck); -CREATE INDEX items_3 ON items (status); + itemid bigint unsigned DEFAULT '0' NOT NULL, + type integer DEFAULT '0' NOT NULL, + snmp_community varchar(64) DEFAULT '' NOT NULL, + snmp_oid varchar(255) DEFAULT '' NOT NULL, + snmp_port integer DEFAULT '161' NOT NULL, + hostid bigint unsigned DEFAULT '0' NOT NULL, + description varchar(255) DEFAULT '' NOT NULL, + key_ varchar(64) DEFAULT '' NOT NULL, + delay integer DEFAULT '0' NOT NULL, + history integer DEFAULT '90' NOT NULL, + trends integer DEFAULT '365' NOT NULL, + nextcheck integer DEFAULT '0' NOT NULL, + lastvalue varchar(255) NULL, + lastclock integer NULL, + prevvalue varchar(255) NULL, + status integer DEFAULT '0' NOT NULL, + value_type integer DEFAULT '0' NOT NULL, + trapper_hosts varchar(255) DEFAULT '' NOT NULL, + units varchar(10) DEFAULT '' NOT NULL, + multiplier integer DEFAULT '0' NOT NULL, + delta integer DEFAULT '0' NOT NULL, + prevorgvalue double(16,4) NULL, + snmpv3_securityname varchar(64) DEFAULT '' NOT NULL, + snmpv3_securitylevel integer DEFAULT '0' NOT NULL, + snmpv3_authpassphrase varchar(64) DEFAULT '' NOT NULL, + snmpv3_privpassphrase varchar(64) DEFAULT '' NOT NULL, + formula varchar(255) DEFAULT '0' NOT NULL, + error varchar(128) DEFAULT '' NOT NULL, + lastlogsize integer DEFAULT '0' NOT NULL, + logtimefmt varchar(64) DEFAULT '' NOT NULL, + templateid bigint unsigned DEFAULT '0' NOT NULL, + valuemapid bigint unsigned DEFAULT '0' NOT NULL, + delay_flex varchar(255) DEFAULT '' NOT NULL, + PRIMARY KEY (itemid) +); +CREATE INDEX items_1 on items (hostid,key_); +CREATE INDEX items_2 on items (nextcheck); +CREATE INDEX items_3 on items (status); CREATE TABLE media ( - mediaid {bigint} DEFAULT '0' NOT NULL, - userid {bigint} DEFAULT '0' NOT NULL, - mediatypeid {bigint} DEFAULT '0' NOT NULL, - sendto {varchar}(100) DEFAULT '' NOT NULL, - active {integer} DEFAULT '0' NOT NULL, - severity {integer} DEFAULT '63' NOT NULL, - period {varchar}(100) DEFAULT '1-7,00:00-23:59' NOT NULL, - PRIMARY KEY (mediaid) -) {create_table_opt}; - -CREATE INDEX media_1 ON media (userid); -CREATE INDEX media_2 ON media (mediatypeid); + mediaid bigint unsigned DEFAULT '0' NOT NULL, + userid bigint unsigned DEFAULT '0' NOT NULL, + mediatypeid bigint unsigned DEFAULT '0' NOT NULL, + sendto varchar(100) DEFAULT '' NOT NULL, + active integer DEFAULT '0' NOT NULL, + severity integer DEFAULT '63' NOT NULL, + period varchar(100) DEFAULT '1-7,00:00-23:59' NOT NULL, + PRIMARY KEY (mediaid) +); +CREATE INDEX media_1 on media (userid); +CREATE INDEX media_2 on media (mediatypeid); CREATE TABLE media_type ( - mediatypeid {bigint} DEFAULT '0' NOT NULL, - type {integer} DEFAULT '0' NOT NULL, - description {varchar}(100) DEFAULT '' NOT NULL, - smtp_server {varchar}(255) DEFAULT '' NOT NULL, - smtp_helo {varchar}(255) DEFAULT '' NOT NULL, - smtp_email {varchar}(255) DEFAULT '' NOT NULL, - exec_path {varchar}(255) DEFAULT '' NOT NULL, - gsm_modem {varchar}(255) DEFAULT '' NOT NULL, - PRIMARY KEY (mediatypeid) -) {create_table_opt}; - + mediatypeid bigint unsigned DEFAULT '0' NOT NULL, + type integer DEFAULT '0' NOT NULL, + description varchar(100) DEFAULT '' NOT NULL, + smtp_server varchar(255) DEFAULT '' NOT NULL, + smtp_helo varchar(255) DEFAULT '' NOT NULL, + smtp_email varchar(255) DEFAULT '' NOT NULL, + exec_path varchar(255) DEFAULT '' NOT NULL, + gsm_modem varchar(255) DEFAULT '' NOT NULL, + PRIMARY KEY (mediatypeid) +); CREATE TABLE triggers ( - triggerid {bigint} DEFAULT '0' NOT NULL, - expression {varchar}(255) DEFAULT '' NOT NULL, - description {varchar}(255) DEFAULT '' NOT NULL, - url {varchar}(255) DEFAULT '' NOT NULL, - status {integer} DEFAULT '0' NOT NULL, - value {integer} DEFAULT '0' NOT NULL, - priority {integer} DEFAULT '0' NOT NULL, - lastchange {integer} DEFAULT '0' NOT NULL, - dep_level {integer} DEFAULT '0' NOT NULL, - comments {blob}, - error {varchar}(128) DEFAULT '' NOT NULL, - templateid {bigint} DEFAULT '0' NOT NULL, - PRIMARY KEY (triggerid) -) {create_table_opt}; - -CREATE INDEX triggers_1 ON triggers (status); -CREATE INDEX triggers_2 ON triggers (value); + triggerid bigint unsigned DEFAULT '0' NOT NULL, + expression varchar(255) DEFAULT '' NOT NULL, + description varchar(255) DEFAULT '' NOT NULL, + url varchar(255) DEFAULT '' NOT NULL, + status integer DEFAULT '0' NOT NULL, + value integer DEFAULT '0' NOT NULL, + priority integer DEFAULT '0' NOT NULL, + lastchange integer DEFAULT '0' NOT NULL, + dep_level integer DEFAULT '0' NOT NULL, + comments blob , + error varchar(128) DEFAULT '' NOT NULL, + templateid bigint unsigned DEFAULT '0' NOT NULL, + PRIMARY KEY (triggerid) +); +CREATE INDEX triggers_1 on triggers (status); +CREATE INDEX triggers_2 on triggers (value); CREATE TABLE trigger_depends ( - triggerdepid {bigint} DEFAULT '0' NOT NULL, - triggerid_down {bigint} DEFAULT '0' NOT NULL, - triggerid_up {bigint} DEFAULT '0' NOT NULL, - PRIMARY KEY (triggerdepid) -) {create_table_opt}; - -CREATE INDEX trigger_depends_1 ON trigger_depends (triggerid_down, triggerid_up); -CREATE INDEX trigger_depends_2 ON trigger_depends (triggerid_up); + triggerdepid bigint unsigned DEFAULT '0' NOT NULL, + triggerid_down bigint unsigned DEFAULT '0' NOT NULL, + triggerid_up bigint unsigned DEFAULT '0' NOT NULL, + PRIMARY KEY (triggerdepid) +); +CREATE INDEX trigger_depends_1 on trigger_depends (triggerid_down,triggerid_up); +CREATE INDEX trigger_depends_2 on trigger_depends (triggerid_up); CREATE TABLE users ( - userid {bigint} DEFAULT '0' NOT NULL, - alias {varchar}(100) DEFAULT '' NOT NULL, - name {varchar}(100) DEFAULT '' NOT NULL, - surname {varchar}(100) DEFAULT '' NOT NULL, - passwd {char}(32) DEFAULT '' NOT NULL, - url {varchar}(255) DEFAULT '' NOT NULL, - autologout {integer} DEFAULT '900' NOT NULL, - lang {varchar}(5) DEFAULT 'en_gb' NOT NULL, - refresh {integer} DEFAULT '30' NOT NULL, - type {integer} DEFAULT '0' NOT NULL, + userid bigint unsigned DEFAULT '0' NOT NULL, + alias varchar(100) DEFAULT '' NOT NULL, + name varchar(100) DEFAULT '' NOT NULL, + surname varchar(100) DEFAULT '' NOT NULL, + passwd char(32) DEFAULT '' NOT NULL, + url varchar(255) DEFAULT '' NOT NULL, + autologout integer DEFAULT '900' NOT NULL, + lang varchar(5) DEFAULT 'en_gb' NOT NULL, + refresh integer DEFAULT '30' NOT NULL, + type integer DEFAULT '0' NOT NULL, PRIMARY KEY (userid) -) {create_table_opt}; - -CREATE INDEX users_1 ON users (alias); +); +CREATE INDEX users_1 on users (alias); CREATE TABLE auditlog ( - auditid {bigint} DEFAULT '0' NOT NULL, - userid {bigint} DEFAULT '0' NOT NULL, - clock {integer} DEFAULT '0' NOT NULL, - action {integer} DEFAULT '0' NOT NULL, - resourcetype {integer} DEFAULT '0' NOT NULL, - details {varchar}(128) DEFAULT '0' NOT NULL, + auditid bigint unsigned DEFAULT '0' NOT NULL, + userid bigint unsigned DEFAULT '0' NOT NULL, + clock integer DEFAULT '0' NOT NULL, + action integer DEFAULT '0' NOT NULL, + resourcetype integer DEFAULT '0' NOT NULL, + details varchar(128) DEFAULT '0' NOT NULL, PRIMARY KEY (auditid) -) {create_table_opt}; - -CREATE INDEX auditlog_1 ON auditlog (userid,clock); -CREATE INDEX auditlog_2 ON auditlog (clock); +); +CREATE INDEX auditlog_1 on auditlog (userid,clock); +CREATE INDEX auditlog_2 on auditlog (clock); CREATE TABLE sessions ( - sessionid {varchar}(32) NOT NULL DEFAULT '', - userid {bigint} NOT NULL DEFAULT '0', - lastaccess {integer} NOT NULL DEFAULT '0', + sessionid varchar(32) DEFAULT '' NOT NULL, + userid bigint unsigned DEFAULT '0' NOT NULL, + lastaccess integer DEFAULT '0' NOT NULL, PRIMARY KEY (sessionid) -) {create_table_opt}; - +); CREATE TABLE rights ( - rightid {bigint} DEFAULT '0' NOT NULL, - groupid {bigint} DEFAULT '0' NOT NULL, - type {integer} DEFAULT '0' NOT NULL, - permission {integer} DEFAULT '0' NOT NULL, - id {bigint}, + rightid bigint unsigned DEFAULT '0' NOT NULL, + groupid bigint unsigned DEFAULT '0' NOT NULL, + type integer DEFAULT '0' NOT NULL, + permission integer DEFAULT '0' NOT NULL, + id bigint unsigned , PRIMARY KEY (rightid) -) {create_table_opt}; - -CREATE INDEX rights_1 ON rights (groupid); +); +CREATE INDEX rights_1 on rights (groupid); CREATE TABLE service_alarms ( - servicealarmid {bigint} DEFAULT '0' NOT NULL, - serviceid {bigint} DEFAULT '0' NOT NULL, - clock {integer} DEFAULT '0' NOT NULL, - value {integer} DEFAULT '0' NOT NULL, + servicealarmid bigint unsigned DEFAULT '0' NOT NULL, + serviceid bigint unsigned DEFAULT '0' NOT NULL, + clock integer DEFAULT '0' NOT NULL, + value integer DEFAULT '0' NOT NULL, PRIMARY KEY (servicealarmid) -) {create_table_opt}; - -CREATE INDEX service_alarms_1 ON service_alarms (serviceid,clock); -CREATE INDEX service_alarms_2 ON service_alarms (clock); +); +CREATE INDEX service_alarms_1 on service_alarms (serviceid,clock); +CREATE INDEX service_alarms_2 on service_alarms (clock); CREATE TABLE profiles ( - profileid {bigint} DEFAULT '0' NOT NULL, - userid {bigint} DEFAULT '0' NOT NULL, - idx {varchar}(64) DEFAULT '' NOT NULL, - value {varchar}(255) DEFAULT '' NOT NULL, - valuetype {integer} DEFAULT 0 NOT NULL, + profileid bigint unsigned DEFAULT '0' NOT NULL, + userid bigint unsigned DEFAULT '0' NOT NULL, + idx varchar(64) DEFAULT '' NOT NULL, + value varchar(255) DEFAULT '' NOT NULL, + valuetype integer DEFAULT 0 NOT NULL, PRIMARY KEY (profileid) -) {create_table_opt}; - -CREATE INDEX profiles_1 ON profiles (userid,idx); +); +CREATE INDEX profiles_1 on profiles (userid,idx); CREATE TABLE screens ( - screenid {bigint} DEFAULT '0' NOT NULL, - name {varchar}(255) DEFAULT 'Screen' NOT NULL, - hsize {integer} DEFAULT '1' NOT NULL, - vsize {integer} DEFAULT '1' NOT NULL, - PRIMARY KEY (screenid) -) {create_table_opt}; - + screenid bigint unsigned DEFAULT '0' NOT NULL, + name varchar(255) DEFAULT 'Screen' NOT NULL, + hsize integer DEFAULT '1' NOT NULL, + vsize integer DEFAULT '1' NOT NULL, + PRIMARY KEY (screenid) +); CREATE TABLE screens_items ( - screenitemid {bigint} DEFAULT '0' NOT NULL, - screenid {bigint} DEFAULT '0' NOT NULL, - resourcetype {integer} DEFAULT '0' NOT NULL, - resourceid {bigint} DEFAULT '0' NOT NULL, - width {integer} DEFAULT '320' NOT NULL, - height {integer} DEFAULT '200' NOT NULL, - x {integer} DEFAULT '0' NOT NULL, - y {integer} DEFAULT '0' NOT NULL, - colspan {integer} DEFAULT '0' NOT NULL, - rowspan {integer} DEFAULT '0' NOT NULL, - elements {integer} DEFAULT '25' NOT NULL, - valign {integer} DEFAULT '0' NOT NULL, - halign {integer} DEFAULT '0' NOT NULL, - style {integer} DEFAULT '0' NOT NULL, - url {varchar}(255) DEFAULT '' NOT NULL, - PRIMARY KEY (screenitemid) -) {create_table_opt}; - + screenitemid bigint unsigned DEFAULT '0' NOT NULL, + screenid bigint unsigned DEFAULT '0' NOT NULL, + resourcetype integer DEFAULT '0' NOT NULL, + resourceid bigint unsigned DEFAULT '0' NOT NULL, + width integer DEFAULT '320' NOT NULL, + height integer DEFAULT '200' NOT NULL, + x integer DEFAULT '0' NOT NULL, + y integer DEFAULT '0' NOT NULL, + colspan integer DEFAULT '0' NOT NULL, + rowspan integer DEFAULT '0' NOT NULL, + elements integer DEFAULT '25' NOT NULL, + valign integer DEFAULT '0' NOT NULL, + halign integer DEFAULT '0' NOT NULL, + style integer DEFAULT '0' NOT NULL, + url varchar(255) DEFAULT '' NOT NULL, + PRIMARY KEY (screenitemid) +); CREATE TABLE usrgrp ( - usrgrpid {bigint} DEFAULT '0' NOT NULL, - name {varchar}(64) DEFAULT '' NOT NULL, + usrgrpid bigint unsigned DEFAULT '0' NOT NULL, + name varchar(64) DEFAULT '' NOT NULL, PRIMARY KEY (usrgrpid) -) {create_table_opt}; - -CREATE INDEX usrgrp_1 ON usrgrp (name); +); +CREATE INDEX usrgrp_1 on usrgrp (name); CREATE TABLE users_groups ( - id {bigint} DEFAULT '0' NOT NULL, - usrgrpid {bigint} DEFAULT '0' NOT NULL, - userid {bigint} DEFAULT '0' NOT NULL, + id bigint unsigned DEFAULT '0' NOT NULL, + usrgrpid bigint unsigned DEFAULT '0' NOT NULL, + userid bigint unsigned DEFAULT '0' NOT NULL, PRIMARY KEY (id) -) {create_table_opt}; - -CREATE INDEX users_groups_1 ON users_groups (usrgrpid,userid); +); +CREATE INDEX users_groups_1 on users_groups (usrgrpid,userid); CREATE TABLE trends ( - itemid {bigint} DEFAULT '0' NOT NULL, - clock {integer} DEFAULT '0' NOT NULL, - num {integer} DEFAULT '0' NOT NULL, - value_min {double}(16,4) DEFAULT '0.0000' NOT NULL, - value_avg {double}(16,4) DEFAULT '0.0000' NOT NULL, - value_max {double}(16,4) DEFAULT '0.0000' NOT NULL, + itemid bigint unsigned DEFAULT '0' NOT NULL, + clock integer DEFAULT '0' NOT NULL, + num integer DEFAULT '0' NOT NULL, + value_min double(16,4) DEFAULT '0.0000' NOT NULL, + value_avg double(16,4) DEFAULT '0.0000' NOT NULL, + value_max double(16,4) DEFAULT '0.0000' NOT NULL, PRIMARY KEY (itemid,clock) -) {create_table_opt}; - +); CREATE TABLE images ( - imageid {bigint} DEFAULT '0' NOT NULL, - imagetype {integer} DEFAULT '0' NOT NULL, - name {varchar}(64) DEFAULT '0' NOT NULL, - image {image_type} DEFAULT '' NOT NULL, + imageid bigint unsigned DEFAULT '0' NOT NULL, + imagetype integer DEFAULT '0' NOT NULL, + name varchar(64) DEFAULT '0' NOT NULL, + image longblob DEFAULT '' NOT NULL, PRIMARY KEY (imageid) -) {create_table_opt}; - -CREATE INDEX images_1 ON images (imagetype, name); +); +CREATE INDEX images_1 on images (imagetype,name); CREATE TABLE hosts_templates ( - hosttemplateid {bigint} DEFAULT '0' NOT NULL, - hostid {bigint} DEFAULT '0' NOT NULL, - templateid {bigint} DEFAULT '0' NOT NULL, + hosttemplateid bigint unsigned DEFAULT '0' NOT NULL, + hostid bigint unsigned DEFAULT '0' NOT NULL, + templateid bigint unsigned DEFAULT '0' NOT NULL, PRIMARY KEY (hosttemplateid) -) {create_table_opt}; - -CREATE INDEX hosts_templates_1 ON hosts_templates (hostid, templateid); +); +CREATE INDEX hosts_templates_1 on hosts_templates (hostid,templateid); CREATE TABLE history_log ( - id {bigint} DEFAULT '0' NOT NULL, - itemid {bigint} DEFAULT '0' NOT NULL, - clock {integer} DEFAULT '0' NOT NULL, - timestamp {integer} DEFAULT '0' NOT NULL, - source {varchar}(64) DEFAULT '' NOT NULL, - severity {integer} DEFAULT '0' NOT NULL, - value {history_log_type} DEFAULT '' NOT NULL, + id bigint unsigned DEFAULT '0' NOT NULL, + itemid bigint unsigned DEFAULT '0' NOT NULL, + clock integer DEFAULT '0' NOT NULL, + timestamp integer DEFAULT '0' NOT NULL, + source varchar(64) DEFAULT '' NOT NULL, + severity integer DEFAULT '0' NOT NULL, + value text DEFAULT '' NOT NULL, PRIMARY KEY (id) -) {create_table_opt}; - -CREATE INDEX history_log_1 ON history_log (itemid, clock); +); +CREATE INDEX history_log_1 on history_log (itemid,clock); CREATE TABLE history_text ( - id {bigint} DEFAULT '0' NOT NULL, - itemid {bigint} DEFAULT '0' NOT NULL, - clock {integer} DEFAULT '0' NOT NULL, - value {history_text_type} DEFAULT '' NOT NULL, + id bigint unsigned DEFAULT '0' NOT NULL, + itemid bigint unsigned DEFAULT '0' NOT NULL, + clock integer DEFAULT '0' NOT NULL, + value text DEFAULT '' NOT NULL, PRIMARY KEY (id) -) {create_table_opt}; - -CREATE INDEX history_text_1 ON history_text (itemid, clock); +); +CREATE INDEX history_text_1 on history_text (itemid,clock); CREATE TABLE hosts_profiles ( - hostid {bigint} DEFAULT '0' NOT NULL, - devicetype {varchar}(64) DEFAULT '' NOT NULL, - name {varchar}(64) DEFAULT '' NOT NULL, - os {varchar}(64) DEFAULT '' NOT NULL, - serialno {varchar}(64) DEFAULT '' NOT NULL, - tag {varchar}(64) DEFAULT '' NOT NULL, - macaddress {varchar}(64) DEFAULT '' NOT NULL, - hardware {blob} DEFAULT '' NOT NULL, - software {blob} DEFAULT '' NOT NULL, - contact {blob} DEFAULT '' NOT NULL, - location {blob} DEFAULT '' NOT NULL, - notes {blob} DEFAULT '' NOT NULL, + hostid bigint unsigned DEFAULT '0' NOT NULL, + devicetype varchar(64) DEFAULT '' NOT NULL, + name varchar(64) DEFAULT '' NOT NULL, + os varchar(64) DEFAULT '' NOT NULL, + serialno varchar(64) DEFAULT '' NOT NULL, + tag varchar(64) DEFAULT '' NOT NULL, + macaddress varchar(64) DEFAULT '' NOT NULL, + hardware blob DEFAULT '' NOT NULL, + software blob DEFAULT '' NOT NULL, + contact blob DEFAULT '' NOT NULL, + location blob DEFAULT '' NOT NULL, + notes blob DEFAULT '' NOT NULL, PRIMARY KEY (hostid) -) {create_table_opt}; - +); CREATE TABLE autoreg ( - id {bigint} DEFAULT '0' NOT NULL, - priority {integer} DEFAULT '0' NOT NULL, - pattern {varchar}(255) DEFAULT '' NOT NULL, - hostid {bigint} DEFAULT '0' NOT NULL, + id bigint unsigned DEFAULT '0' NOT NULL, + priority integer DEFAULT '0' NOT NULL, + pattern varchar(255) DEFAULT '' NOT NULL, + hostid bigint unsigned DEFAULT '0' NOT NULL, PRIMARY KEY (id) -) {create_table_opt}; - +); CREATE TABLE valuemaps ( - valuemapid {bigint} DEFAULT '0' NOT NULL, - name {varchar}(64) DEFAULT '' NOT NULL, + valuemapid bigint unsigned DEFAULT '0' NOT NULL, + name varchar(64) DEFAULT '' NOT NULL, PRIMARY KEY (valuemapid) -) {create_table_opt}; - -CREATE INDEX valuemaps_1 ON valuemaps (name); +); +CREATE INDEX valuemaps_1 on valuemaps (name); CREATE TABLE mappings ( - mappingid {bigint} DEFAULT '0' NOT NULL, - valuemapid {bigint} DEFAULT '0' NOT NULL, - value {varchar}(64) DEFAULT '' NOT NULL, - newvalue {varchar}(64) DEFAULT '' NOT NULL, + mappingid bigint unsigned DEFAULT '0' NOT NULL, + valuemapid bigint unsigned DEFAULT '0' NOT NULL, + value varchar(64) DEFAULT '' NOT NULL, + newvalue varchar(64) DEFAULT '' NOT NULL, PRIMARY KEY (mappingid) -) {create_table_opt}; - -CREATE INDEX mappings_1 ON mappings (valuemapid); +); +CREATE INDEX mappings_1 on mappings (valuemapid); CREATE TABLE housekeeper ( - housekeeperid {bigint} DEFAULT '0' NOT NULL, - tablename {varchar}(64) DEFAULT '' NOT NULL, - field {varchar}(64) DEFAULT '' NOT NULL, - value {integer} DEFAULT '0' NOT NULL, + housekeeperid bigint unsigned DEFAULT '0' NOT NULL, + tablename varchar(64) DEFAULT '' NOT NULL, + field varchar(64) DEFAULT '' NOT NULL, + value integer DEFAULT '0' NOT NULL, PRIMARY KEY (housekeeperid) -) {create_table_opt}; - +); CREATE TABLE acknowledges ( - acknowledgeid {bigint} DEFAULT '0' NOT NULL, - userid {bigint} DEFAULT '0' NOT NULL, - eventid {bigint} DEFAULT '0' NOT NULL, - clock {integer} DEFAULT '0' NOT NULL, - message {varchar}(255) DEFAULT '' NOT NULL, + acknowledgeid bigint unsigned DEFAULT '0' NOT NULL, + userid bigint unsigned DEFAULT '0' NOT NULL, + eventid bigint unsigned DEFAULT '0' NOT NULL, + clock integer DEFAULT '0' NOT NULL, + message varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (acknowledgeid) -) {create_table_opt}; - -CREATE INDEX acknowledges_1 ON acknowledges (userid); -CREATE INDEX acknowledges_2 ON acknowledges (eventid); -CREATE INDEX acknowledges_3 ON acknowledges (clock); +); +CREATE INDEX acknowledges_1 on acknowledges (userid); +CREATE INDEX acknowledges_2 on acknowledges (eventid); +CREATE INDEX acknowledges_3 on acknowledges (clock); CREATE TABLE applications ( - applicationid {bigint} DEFAULT '0' NOT NULL, - hostid {bigint} DEFAULT '0' NOT NULL, - name {varchar}(255) DEFAULT '' NOT NULL, - templateid {bigint} DEFAULT '0' NOT NULL, - PRIMARY KEY (applicationid) -) {create_table_opt}; - -CREATE INDEX applications_1 ON applications (templateid); -CREATE INDEX applications_2 ON applications (hostid,name); + applicationid bigint unsigned DEFAULT '0' NOT NULL, + hostid bigint unsigned DEFAULT '0' NOT NULL, + name varchar(255) DEFAULT '' NOT NULL, + templateid bigint unsigned DEFAULT '0' NOT NULL, + PRIMARY KEY (applicationid) +); +CREATE INDEX applications_1 on applications (templateid); +CREATE INDEX applications_2 on applications (hostid,name); CREATE TABLE items_applications ( - itemappid {bigint} DEFAULT '0' NOT NULL, - applicationid {bigint} DEFAULT '0' NOT NULL, - itemid {bigint} DEFAULT '0' NOT NULL, + itemappid bigint unsigned DEFAULT '0' NOT NULL, + applicationid bigint unsigned DEFAULT '0' NOT NULL, + itemid bigint unsigned DEFAULT '0' NOT NULL, PRIMARY KEY (itemappid) -) {create_table_opt}; - -CREATE INDEX items_applications_1 ON items_applications (applicationid,itemid); +); +CREATE INDEX items_applications_1 on items_applications (applicationid,itemid); CREATE TABLE help_items ( - itemtype {integer} DEFAULT '0' NOT NULL, - key_ {varchar}(64) DEFAULT '' NOT NULL, - description {varchar}(255) DEFAULT '' NOT NULL, - PRIMARY KEY (itemtype, key_) -) {create_table_opt}; + itemtype integer DEFAULT '0' NOT NULL, + key_ varchar(64) DEFAULT '' NOT NULL, + description varchar(255) DEFAULT '' NOT NULL, + PRIMARY KEY (itemtype,key_) +); |