diff options
| author | alex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2007-02-28 14:49:08 +0000 |
|---|---|---|
| committer | alex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2007-02-28 14:49:08 +0000 |
| commit | 09ad0726ce2decd534f7cd4410f049fca9433839 (patch) | |
| tree | 080e2a5cd63ade7b3220c575cf24fe6e0762ce28 /upgrades/dbpatches | |
| parent | 37bd95902dd4725301c18a98e35f84030a2ab910 (diff) | |
| download | zabbix-09ad0726ce2decd534f7cd4410f049fca9433839.tar.gz zabbix-09ad0726ce2decd534f7cd4410f049fca9433839.tar.xz zabbix-09ad0726ce2decd534f7cd4410f049fca9433839.zip | |
Removed unneeded files from MySQL patches.
git-svn-id: svn://svn.zabbix.com/trunk@3854 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'upgrades/dbpatches')
112 files changed, 0 insertions, 2235 deletions
diff --git a/upgrades/dbpatches/1.3/mysql/1.1/acknowledges.sql b/upgrades/dbpatches/1.3/mysql/1.1/acknowledges.sql deleted file mode 100644 index cab807f0..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.1/acknowledges.sql +++ /dev/null @@ -1,11 +0,0 @@ -CREATE TABLE acknowledges ( - acknowledgeid int(4) NOT NULL auto_increment, - userid int(4) DEFAULT '0' NOT NULL, - alarmid int(4) DEFAULT '0' NOT NULL, - clock int(4) DEFAULT '0' NOT NULL, - message varchar(255) DEFAULT '' NOT NULL, - PRIMARY KEY (acknowledgeid), - KEY userid (userid), - KEY alarmid (alarmid), - KEY clock (clock) -) type=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/1.1/actions.sql b/upgrades/dbpatches/1.3/mysql/1.1/actions.sql deleted file mode 100644 index fa4cecfb..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.1/actions.sql +++ /dev/null @@ -1,16 +0,0 @@ -CREATE TABLE actions ( - actionid int(4) NOT NULL auto_increment, - userid int(4) DEFAULT '0' NOT NULL, ---delay int(4) DEFAULT '0' NOT NULL, - subject varchar(255) DEFAULT '' NOT NULL, - message blob DEFAULT '' NOT NULL, ---nextcheck int(4) DEFAULT '0' NOT NULL, - recipient int(1) DEFAULT '0' NOT NULL, - maxrepeats int(4) DEFAULT '0' NOT NULL, - repeatdelay int(4) DEFAULT '600' NOT NULL, - source int(1) DEFAULT '0' NOT NULL, - actiontype int(1) DEFAULT '0' NOT NULL, - status int(1) DEFAULT '0' NOT NULL, - scripts blob DEFAULT '' NOT NULL, - PRIMARY KEY (actionid) -) type=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/1.1/alarms.sql b/upgrades/dbpatches/1.3/mysql/1.1/alarms.sql deleted file mode 100644 index fa221683..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.1/alarms.sql +++ /dev/null @@ -1,10 +0,0 @@ -CREATE TABLE alarms ( - alarmid int(4) NOT NULL auto_increment, - triggerid int(4) DEFAULT '0' NOT NULL, - clock int(4) DEFAULT '0' NOT NULL, - value int(4) DEFAULT '0' NOT NULL, - acknowledged int(1) DEFAULT '0' NOT NULL, - PRIMARY KEY (alarmid), - KEY (triggerid,clock), - KEY (clock) -) type=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/1.1/alerts.sql b/upgrades/dbpatches/1.3/mysql/1.1/alerts.sql deleted file mode 100644 index 9908f446..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.1/alerts.sql +++ /dev/null @@ -1,27 +0,0 @@ -CREATE TABLE alerts ( - alertid int(4) NOT NULL auto_increment, - actionid int(4) DEFAULT '0' NOT NULL, - triggerid int(4) DEFAULT '0' NOT NULL, - userid int(4) DEFAULT '0' NOT NULL, - clock int(4) DEFAULT '0' NOT NULL, --- type varchar(10) DEFAULT '' NOT NULL, - mediatypeid int(4) DEFAULT '0' NOT NULL, - sendto varchar(100) DEFAULT '' NOT NULL, - subject varchar(255) DEFAULT '' NOT NULL, - message blob DEFAULT '' NOT NULL, - status int(4) DEFAULT '0' NOT NULL, - retries int(4) DEFAULT '0' NOT NULL, - error varchar(128) DEFAULT '' NOT NULL, - repeats int(4) DEFAULT '0' NOT NULL, - maxrepeats int(4) DEFAULT '0' NOT NULL, - nextcheck int(4) DEFAULT '0' NOT NULL, - delay int(4) DEFAULT '0' NOT NULL, - - PRIMARY KEY (alertid), - INDEX (actionid), - KEY clock (clock), - KEY triggerid (triggerid), - KEY status_retries (status, retries), - KEY mediatypeid (mediatypeid), - KEY userid (userid) -) type=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/1.1/applications.sql b/upgrades/dbpatches/1.3/mysql/1.1/applications.sql deleted file mode 100644 index 71d21452..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.1/applications.sql +++ /dev/null @@ -1,9 +0,0 @@ -CREATE TABLE applications ( - applicationid int(4) NOT NULL auto_increment, - hostid int(4) DEFAULT '0' NOT NULL, - name varchar(255) DEFAULT '' NOT NULL, - templateid int(4) DEFAULT '0' NOT NULL, - PRIMARY KEY (applicationid), - KEY templateid (templateid), - UNIQUE appname (hostid,name) -) type=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/1.1/auditlog.sql b/upgrades/dbpatches/1.3/mysql/1.1/auditlog.sql deleted file mode 100644 index ee44c575..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.1/auditlog.sql +++ /dev/null @@ -1,11 +0,0 @@ -CREATE TABLE auditlog ( - auditid int(4) NOT NULL auto_increment, - userid int(4) DEFAULT '0' NOT NULL, - clock int(4) DEFAULT '0' NOT NULL, - action int(4) DEFAULT '0' NOT NULL, - resourcetype int(4) DEFAULT '0' NOT NULL, - details varchar(128) DEFAULT '0' NOT NULL, - PRIMARY KEY (auditid), - KEY (userid,clock), - KEY (clock) -) type=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/1.1/autoreg.sql b/upgrades/dbpatches/1.3/mysql/1.1/autoreg.sql deleted file mode 100644 index d5e2a2fc..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.1/autoreg.sql +++ /dev/null @@ -1,7 +0,0 @@ -CREATE TABLE autoreg ( - id int(4) NOT NULL auto_increment, - priority int(4) DEFAULT '0' NOT NULL, - pattern varchar(255) DEFAULT '' NOT NULL, - hostid int(4) DEFAULT '0' NOT NULL, - PRIMARY KEY (id) -) type=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/1.1/conditions.sql b/upgrades/dbpatches/1.3/mysql/1.1/conditions.sql deleted file mode 100644 index 04f74815..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.1/conditions.sql +++ /dev/null @@ -1,9 +0,0 @@ -CREATE TABLE conditions ( - conditionid int(4) NOT NULL auto_increment, - actionid int(4) DEFAULT '0' NOT NULL, - conditiontype int(4) DEFAULT '0' NOT NULL, - operator int(1) DEFAULT '0' NOT NULL, - value varchar(255) DEFAULT '' NOT NULL, - PRIMARY KEY (conditionid), - KEY (actionid) -) type=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/1.1/config.sql b/upgrades/dbpatches/1.3/mysql/1.1/config.sql deleted file mode 100644 index 61a8d3e7..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.1/config.sql +++ /dev/null @@ -1,10 +0,0 @@ -CREATE TABLE config ( --- smtp_server varchar(255) DEFAULT '' NOT NULL, --- smtp_helo varchar(255) DEFAULT '' NOT NULL, --- smtp_email varchar(255) DEFAULT '' NOT NULL, --- password_required int(1) DEFAULT '0' NOT NULL, - alert_history int(4) DEFAULT '0' NOT NULL, - alarm_history int(4) DEFAULT '0' NOT NULL, - refresh_unsupported int(4) DEFAULT '0' NOT NULL, - work_period varchar(100) DEFAULT '1-5,00:00-24:00' NOT NULL -) type=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/1.1/functions.sql b/upgrades/dbpatches/1.3/mysql/1.1/functions.sql deleted file mode 100644 index f61712e8..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.1/functions.sql +++ /dev/null @@ -1,11 +0,0 @@ -CREATE TABLE functions ( - functionid int(4) NOT NULL auto_increment, - itemid int(4) DEFAULT '0' NOT NULL, - triggerid int(4) DEFAULT '0' NOT NULL, - lastvalue varchar(255), - function varchar(12) DEFAULT '' NOT NULL, - parameter varchar(255) DEFAULT '0' NOT NULL, - PRIMARY KEY (functionid), - KEY triggerid (triggerid), - KEY itemidfunctionparameter (itemid,function,parameter) -) type=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/1.1/graphs.sql b/upgrades/dbpatches/1.3/mysql/1.1/graphs.sql deleted file mode 100644 index cf733eda..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.1/graphs.sql +++ /dev/null @@ -1,14 +0,0 @@ -CREATE TABLE graphs ( - graphid int(4) NOT NULL auto_increment, - name varchar(128) DEFAULT '' NOT NULL, - width int(4) DEFAULT '0' NOT NULL, - height int(4) DEFAULT '0' NOT NULL, - yaxistype int(1) DEFAULT '0' NOT NULL, - yaxismin double(16,4) DEFAULT '0' NOT NULL, - yaxismax double(16,4) DEFAULT '0' NOT NULL, - templateid int(4) DEFAULT '0' NOT NULL, - show_work_period int(1) DEFAULT '1' NOT NULL, - show_triggers int(1) DEFAULT '1' NOT NULL, - PRIMARY KEY (graphid), - KEY (name) -) type=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/1.1/graphs_items.sql b/upgrades/dbpatches/1.3/mysql/1.1/graphs_items.sql deleted file mode 100644 index 7b46d3f6..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.1/graphs_items.sql +++ /dev/null @@ -1,13 +0,0 @@ -CREATE TABLE graphs_items ( - gitemid int(4) NOT NULL auto_increment, - graphid int(4) DEFAULT '0' NOT NULL, - itemid int(4) DEFAULT '0' NOT NULL, - drawtype int(4) DEFAULT '0' NOT NULL, - sortorder int(4) DEFAULT '0' NOT NULL, - color varchar(32) DEFAULT 'Dark Green' NOT NULL, - yaxisside int(1) DEFAULT '1' NOT NULL, - calc_fnc int(1) DEFAULT '2' NOT NULL, - type int(1) DEFAULT '0' NOT NULL, - periods_cnt int(4) DEFAULT '5' NOT NULL, - PRIMARY KEY (gitemid) -) type=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/1.1/groups.sql b/upgrades/dbpatches/1.3/mysql/1.1/groups.sql deleted file mode 100644 index d932908a..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.1/groups.sql +++ /dev/null @@ -1,6 +0,0 @@ -CREATE TABLE groups ( - groupid int(4) NOT NULL auto_increment, - name varchar(64) DEFAULT '' NOT NULL, - PRIMARY KEY (groupid), - UNIQUE (name) -) type=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/1.1/help_items.sql b/upgrades/dbpatches/1.3/mysql/1.1/help_items.sql deleted file mode 100644 index 4057b63e..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.1/help_items.sql +++ /dev/null @@ -1,7 +0,0 @@ -CREATE TABLE help_items ( - itemtype int(4) DEFAULT '0' NOT NULL, - key_ varchar(64) DEFAULT '' NOT NULL, - description varchar(255) DEFAULT '' NOT NULL, - PRIMARY KEY (itemtype, key_) -) type=InnoDB; - diff --git a/upgrades/dbpatches/1.3/mysql/1.1/history.sql b/upgrades/dbpatches/1.3/mysql/1.1/history.sql deleted file mode 100644 index 74616774..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.1/history.sql +++ /dev/null @@ -1,7 +0,0 @@ -CREATE TABLE history ( - itemid int(4) DEFAULT '0' NOT NULL, - clock int(4) DEFAULT '0' NOT NULL, - value double(16,4) DEFAULT '0.0000' NOT NULL, --- PRIMARY KEY (itemid,clock) - KEY itemidclock (itemid, clock) -) type=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/1.1/history_log.sql b/upgrades/dbpatches/1.3/mysql/1.1/history_log.sql deleted file mode 100644 index a313fc3a..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.1/history_log.sql +++ /dev/null @@ -1,11 +0,0 @@ -CREATE TABLE history_log ( - id int(4) NOT NULL auto_increment, - itemid int(4) DEFAULT '0' NOT NULL, - clock int(4) DEFAULT '0' NOT NULL, - timestamp int(4) DEFAULT '0' NOT NULL, - source varchar(64) DEFAULT '' NOT NULL, - severity int(4) DEFAULT '0' NOT NULL, - value text DEFAULT '' NOT NULL, - PRIMARY KEY (id), - KEY itemidclock (itemid, clock) -) type=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/1.1/history_str.sql b/upgrades/dbpatches/1.3/mysql/1.1/history_str.sql deleted file mode 100644 index 95cc3ef3..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.1/history_str.sql +++ /dev/null @@ -1,7 +0,0 @@ -CREATE TABLE history_str ( - itemid int(4) DEFAULT '0' NOT NULL, - clock int(4) DEFAULT '0' NOT NULL, - value varchar(255) DEFAULT '' NOT NULL, --- PRIMARY KEY (itemid,clock) - KEY itemidclock (itemid, clock) -) type=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/1.1/history_text.sql b/upgrades/dbpatches/1.3/mysql/1.1/history_text.sql deleted file mode 100644 index 9b33c088..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.1/history_text.sql +++ /dev/null @@ -1,8 +0,0 @@ -CREATE TABLE history_text ( - id int(4) NOT NULL auto_increment, - itemid int(4) DEFAULT '0' NOT NULL, - clock int(4) DEFAULT '0' NOT NULL, - value text DEFAULT '' NOT NULL, - PRIMARY KEY (id), - KEY itemidclock (itemid, clock) -) type=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/1.1/history_uint.sql b/upgrades/dbpatches/1.3/mysql/1.1/history_uint.sql deleted file mode 100644 index 96fa75f2..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.1/history_uint.sql +++ /dev/null @@ -1,7 +0,0 @@ -CREATE TABLE history_uint ( - itemid int(4) DEFAULT '0' NOT NULL, - clock int(4) DEFAULT '0' NOT NULL, - value bigint unsigned DEFAULT '0' NOT NULL, --- PRIMARY KEY (itemid,clock) - KEY itemidclock (itemid, clock) -) type=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/1.1/hosts.sql b/upgrades/dbpatches/1.3/mysql/1.1/hosts.sql deleted file mode 100644 index b3d96a7d..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.1/hosts.sql +++ /dev/null @@ -1,17 +0,0 @@ -CREATE TABLE hosts ( - hostid int(4) NOT NULL auto_increment, - host varchar(64) DEFAULT '' NOT NULL, - useip int(1) DEFAULT '1' NOT NULL, - ip varchar(15) DEFAULT '127.0.0.1' NOT NULL, - port int(4) DEFAULT '0' NOT NULL, - status int(4) DEFAULT '0' NOT NULL, --- If status=UNREACHABLE, host will not be checked until this time - disable_until int(4) DEFAULT '0' NOT NULL, - error varchar(128) DEFAULT '' NOT NULL, - available int(4) DEFAULT '0' NOT NULL, - errors_from int(4) DEFAULT '0' NOT NULL, - templateid int(4) DEFAULT '0' NOT NULL, - PRIMARY KEY (hostid), - UNIQUE (host), - KEY (status) -) type=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/1.1/hosts_groups.sql b/upgrades/dbpatches/1.3/mysql/1.1/hosts_groups.sql deleted file mode 100644 index 2ee65f3c..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.1/hosts_groups.sql +++ /dev/null @@ -1,5 +0,0 @@ -CREATE TABLE hosts_groups ( - hostid int(4) DEFAULT '0' NOT NULL, - groupid int(4) DEFAULT '0' NOT NULL, - PRIMARY KEY (hostid,groupid) -) type=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/1.1/hosts_profiles.sql b/upgrades/dbpatches/1.3/mysql/1.1/hosts_profiles.sql deleted file mode 100644 index 31bfb1a1..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.1/hosts_profiles.sql +++ /dev/null @@ -1,15 +0,0 @@ -CREATE TABLE hosts_profiles ( - hostid int(4) 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) -) type=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/1.1/hosts_templates.sql b/upgrades/dbpatches/1.3/mysql/1.1/hosts_templates.sql deleted file mode 100644 index 49229629..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.1/hosts_templates.sql +++ /dev/null @@ -1,10 +0,0 @@ -CREATE TABLE hosts_templates ( - hosttemplateid int(4) NOT NULL auto_increment, - hostid int(4) DEFAULT '0' NOT NULL, - templateid int(4) DEFAULT '0' NOT NULL, - items int(1) DEFAULT '0' NOT NULL, - triggers int(1) DEFAULT '0' NOT NULL, - graphs int(1) DEFAULT '0' NOT NULL, - PRIMARY KEY (hosttemplateid), - UNIQUE (hostid, templateid) -) type=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/1.1/housekeeper.sql b/upgrades/dbpatches/1.3/mysql/1.1/housekeeper.sql deleted file mode 100644 index 63cd7f1c..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.1/housekeeper.sql +++ /dev/null @@ -1,7 +0,0 @@ -CREATE TABLE housekeeper ( - housekeeperid int(4) NOT NULL auto_increment, - tablename varchar(64) DEFAULT '' NOT NULL, - field varchar(64) DEFAULT '' NOT NULL, - value int(4) DEFAULT '0' NOT NULL, - PRIMARY KEY (housekeeperid) -) type=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/1.1/images.sql b/upgrades/dbpatches/1.3/mysql/1.1/images.sql deleted file mode 100644 index 72f43710..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.1/images.sql +++ /dev/null @@ -1,8 +0,0 @@ -CREATE TABLE images ( - imageid int(4) NOT NULL auto_increment, - imagetype int(4) DEFAULT '0' NOT NULL, - name varchar(64) DEFAULT '0' NOT NULL, - image longblob DEFAULT '' NOT NULL, - PRIMARY KEY (imageid), - UNIQUE (imagetype, name) -) type=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/1.1/items.sql b/upgrades/dbpatches/1.3/mysql/1.1/items.sql deleted file mode 100644 index a07dfef6..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.1/items.sql +++ /dev/null @@ -1,44 +0,0 @@ -CREATE TABLE items ( - itemid int(4) NOT NULL auto_increment, - type int(4) DEFAULT '0' NOT NULL, - snmp_community varchar(64) DEFAULT '' NOT NULL, - snmp_oid varchar(255) DEFAULT '' NOT NULL, - snmp_port int(4) DEFAULT '161' NOT NULL, - hostid int(4) NOT NULL, - description varchar(255) DEFAULT '' NOT NULL, - key_ varchar(64) DEFAULT '' NOT NULL, - delay int(4) DEFAULT '0' NOT NULL, - history int(4) DEFAULT '90' NOT NULL, - trends int(4) DEFAULT '365' NOT NULL, --- lastdelete is not longer required --- lastdelete int(4) DEFAULT '0' NOT NULL, - nextcheck int(4) DEFAULT '0' NOT NULL, - lastvalue varchar(255) DEFAULT NULL, - lastclock int(4) DEFAULT NULL, - prevvalue varchar(255) DEFAULT NULL, - status int(4) DEFAULT '0' NOT NULL, - value_type int(4) DEFAULT '0' NOT NULL, - trapper_hosts varchar(255) DEFAULT '' NOT NULL, - units varchar(10) DEFAULT '' NOT NULL, - multiplier int(4) DEFAULT '0' NOT NULL, - delta int(1) DEFAULT '0' NOT NULL, - prevorgvalue double(16,4) DEFAULT NULL, - snmpv3_securityname varchar(64) DEFAULT '' NOT NULL, - snmpv3_securitylevel int(1) 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 int(4) DEFAULT '0' NOT NULL, - logtimefmt varchar(64) DEFAULT '' NOT NULL, - templateid int(4) DEFAULT '0' NOT NULL, - valuemapid int(4) DEFAULT '0' NOT NULL, - - PRIMARY KEY (itemid), - UNIQUE shortname (hostid,key_), --- KEY (hostid), - KEY (nextcheck), - KEY (status) -) type=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/1.1/items_applications.sql b/upgrades/dbpatches/1.3/mysql/1.1/items_applications.sql deleted file mode 100644 index 0fcd00f4..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.1/items_applications.sql +++ /dev/null @@ -1,5 +0,0 @@ -CREATE TABLE items_applications ( - applicationid int(4) DEFAULT '0' NOT NULL, - itemid int(4) DEFAULT '0' NOT NULL, - PRIMARY KEY (applicationid,itemid) -) type=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/1.1/mappings.sql b/upgrades/dbpatches/1.3/mysql/1.1/mappings.sql deleted file mode 100644 index 98f140a7..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.1/mappings.sql +++ /dev/null @@ -1,8 +0,0 @@ -CREATE TABLE mappings ( - mappingid int(4) NOT NULL auto_increment, - valuemapid int(4) DEFAULT '0' NOT NULL, - value varchar(64) DEFAULT '' NOT NULL, - newvalue varchar(64) DEFAULT '' NOT NULL, - PRIMARY KEY (mappingid), - KEY valuemapid (valuemapid) -) type=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/1.1/media.sql b/upgrades/dbpatches/1.3/mysql/1.1/media.sql deleted file mode 100644 index d800ad65..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.1/media.sql +++ /dev/null @@ -1,13 +0,0 @@ -CREATE TABLE media ( - mediaid int(4) NOT NULL auto_increment, - userid int(4) DEFAULT '0' NOT NULL, --- type varchar(10) DEFAULT '' NOT NULL, - mediatypeid int(4) DEFAULT '0' NOT NULL, - sendto varchar(100) DEFAULT '' NOT NULL, - active int(4) DEFAULT '0' NOT NULL, - severity int(4) DEFAULT '63' NOT NULL, - period varchar(100) DEFAULT '1-7,00:00-23:59' NOT NULL, - PRIMARY KEY (mediaid), - KEY (userid), - KEY (mediatypeid) -) type=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/1.1/media_type.sql b/upgrades/dbpatches/1.3/mysql/1.1/media_type.sql deleted file mode 100644 index fddb2ed7..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.1/media_type.sql +++ /dev/null @@ -1,11 +0,0 @@ -CREATE TABLE media_type ( - mediatypeid int(4) NOT NULL auto_increment, - type int(4) 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) -) type=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/1.1/profiles.sql b/upgrades/dbpatches/1.3/mysql/1.1/profiles.sql deleted file mode 100644 index f72ba7d1..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.1/profiles.sql +++ /dev/null @@ -1,10 +0,0 @@ -CREATE TABLE profiles ( - profileid int(4) NOT NULL auto_increment, - userid int(4) DEFAULT '0' NOT NULL, - idx varchar(64) DEFAULT '' NOT NULL, - value varchar(255) DEFAULT '' NOT NULL, - valuetype int(4) DEFAULT 0 NOT NULL, - PRIMARY KEY (profileid), --- KEY (userid), - UNIQUE (userid,idx) -) type=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/1.1/rights.sql b/upgrades/dbpatches/1.3/mysql/1.1/rights.sql deleted file mode 100644 index 34795fac..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.1/rights.sql +++ /dev/null @@ -1,9 +0,0 @@ -CREATE TABLE rights ( - rightid int(4) NOT NULL auto_increment, - userid int(4) DEFAULT '0' NOT NULL, - name char(255) DEFAULT '' NOT NULL, - permission char(1) DEFAULT '' NOT NULL, - id int(4), - PRIMARY KEY (rightid), - KEY (userid) -) type=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/1.1/screens.sql b/upgrades/dbpatches/1.3/mysql/1.1/screens.sql deleted file mode 100644 index d49bff30..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.1/screens.sql +++ /dev/null @@ -1,7 +0,0 @@ -CREATE TABLE screens ( - screenid int(4) NOT NULL auto_increment, - name varchar(255) DEFAULT 'Screen' NOT NULL, - hsize int(4) DEFAULT '1' NOT NULL, - vsize int(4) DEFAULT '1' NOT NULL, - PRIMARY KEY (screenid) -) TYPE=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/1.1/screens_items.sql b/upgrades/dbpatches/1.3/mysql/1.1/screens_items.sql deleted file mode 100644 index 469f58c1..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.1/screens_items.sql +++ /dev/null @@ -1,18 +0,0 @@ -CREATE TABLE screens_items ( - screenitemid int(4) NOT NULL auto_increment, - screenid int(4) DEFAULT '0' NOT NULL, - resourcetype int(4) DEFAULT '0' NOT NULL, - resourceid int(4) DEFAULT '0' NOT NULL, - width int(4) DEFAULT '320' NOT NULL, - height int(4) DEFAULT '200' NOT NULL, - x int(4) DEFAULT '0' NOT NULL, - y int(4) DEFAULT '0' NOT NULL, - colspan int(4) DEFAULT '0' NOT NULL, - rowspan int(4) DEFAULT '0' NOT NULL, - elements int(4) DEFAULT '25' NOT NULL, - valign int(2) DEFAULT '0' NOT NULL, - halign int(2) DEFAULT '0' NOT NULL, - style int(4) DEFAULT '0' NOT NULL, - url varchar(255) DEFAULT '' NOT NULL, - PRIMARY KEY (screenitemid) -) TYPE=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/1.1/service_alarms.sql b/upgrades/dbpatches/1.3/mysql/1.1/service_alarms.sql deleted file mode 100644 index e66e0c20..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.1/service_alarms.sql +++ /dev/null @@ -1,9 +0,0 @@ -CREATE TABLE service_alarms ( - servicealarmid int(4) NOT NULL auto_increment, - serviceid int(4) DEFAULT '0' NOT NULL, - clock int(4) DEFAULT '0' NOT NULL, - value int(4) DEFAULT '0' NOT NULL, - PRIMARY KEY (servicealarmid), - KEY (serviceid,clock), - KEY (clock) -) type=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/1.1/services.sql b/upgrades/dbpatches/1.3/mysql/1.1/services.sql deleted file mode 100644 index e7630f75..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.1/services.sql +++ /dev/null @@ -1,11 +0,0 @@ -CREATE TABLE services ( - serviceid int(4) NOT NULL auto_increment, - name varchar(128) DEFAULT '' NOT NULL, - status int(1) DEFAULT '0' NOT NULL, - algorithm int(1) DEFAULT '0' NOT NULL, - triggerid int(4), - showsla int(1) DEFAULT '0' NOT NULL, - goodsla double(5,2) DEFAULT '99.9' NOT NULL, - sortorder int(4) DEFAULT '0' NOT NULL, - PRIMARY KEY (serviceid) -) type=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/1.1/services_links.sql b/upgrades/dbpatches/1.3/mysql/1.1/services_links.sql deleted file mode 100644 index eff1625a..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.1/services_links.sql +++ /dev/null @@ -1,10 +0,0 @@ -CREATE TABLE services_links ( - linkid int(4) NOT NULL auto_increment, - serviceupid int(4) DEFAULT '0' NOT NULL, - servicedownid int(4) DEFAULT '0' NOT NULL, - soft int(1) DEFAULT '0' NOT NULL, - PRIMARY KEY (linkid), --- KEY (serviceupid), - KEY (servicedownid), - UNIQUE (serviceupid,servicedownid) -) type=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/1.1/sessions b/upgrades/dbpatches/1.3/mysql/1.1/sessions deleted file mode 100644 index 980c53a1..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.1/sessions +++ /dev/null @@ -1,6 +0,0 @@ -CREATE TABLE sessions ( - sessionid varchar(32) NOT NULL DEFAULT '', - userid int(4) NOT NULL DEFAULT '0', - lastaccess int(4) NOT NULL DEFAULT '0', - PRIMARY KEY (sessionid) -) type=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/1.1/sessions.sql b/upgrades/dbpatches/1.3/mysql/1.1/sessions.sql deleted file mode 100644 index 980c53a1..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.1/sessions.sql +++ /dev/null @@ -1,6 +0,0 @@ -CREATE TABLE sessions ( - sessionid varchar(32) NOT NULL DEFAULT '', - userid int(4) NOT NULL DEFAULT '0', - lastaccess int(4) NOT NULL DEFAULT '0', - PRIMARY KEY (sessionid) -) type=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/1.1/sysmaps.sql b/upgrades/dbpatches/1.3/mysql/1.1/sysmaps.sql deleted file mode 100644 index 17f7c258..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.1/sysmaps.sql +++ /dev/null @@ -1,11 +0,0 @@ -CREATE TABLE sysmaps ( - sysmapid int(4) NOT NULL auto_increment, - name varchar(128) DEFAULT '' NOT NULL, - width int(4) DEFAULT '0' NOT NULL, - height int(4) DEFAULT '0' NOT NULL, - background varchar(64) DEFAULT '' NOT NULL, - label_type int(4) DEFAULT '0' NOT NULL, - label_location int(1) DEFAULT '0' NOT NULL, - PRIMARY KEY (sysmapid), - UNIQUE (name) -) type=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/1.1/sysmaps_elements.sql b/upgrades/dbpatches/1.3/mysql/1.1/sysmaps_elements.sql deleted file mode 100644 index fbdda7d3..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.1/sysmaps_elements.sql +++ /dev/null @@ -1,14 +0,0 @@ -CREATE TABLE sysmaps_elements ( - selementid int(4) NOT NULL auto_increment, - sysmapid int(4) DEFAULT '0' NOT NULL, - elementid int(4) DEFAULT '0' NOT NULL, - elementtype int(4) DEFAULT '0' NOT NULL, - icon varchar(32) DEFAULT 'Server' NOT NULL, - icon_on varchar(32) DEFAULT 'Server' NOT NULL, - label varchar(128) DEFAULT '' NOT NULL, - label_location int(1) DEFAULT NULL, - x int(4) DEFAULT '0' NOT NULL, - y int(4) DEFAULT '0' NOT NULL, - url varchar(255) DEFAULT '' NOT NULL, - PRIMARY KEY (selementid) -) type=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/1.1/sysmaps_links.sql b/upgrades/dbpatches/1.3/mysql/1.1/sysmaps_links.sql deleted file mode 100644 index df9c1513..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.1/sysmaps_links.sql +++ /dev/null @@ -1,13 +0,0 @@ -CREATE TABLE sysmaps_links ( - linkid int(4) NOT NULL auto_increment, - sysmapid int(4) DEFAULT '0' NOT NULL, - selementid1 int(4) DEFAULT '0' NOT NULL, - selementid2 int(4) DEFAULT '0' NOT NULL, - -- may be NULL - triggerid int(4), - drawtype_off int(4) DEFAULT '0' NOT NULL, - color_off varchar(32) DEFAULT 'Black' NOT NULL, - drawtype_on int(4) DEFAULT '0' NOT NULL, - color_on varchar(32) DEFAULT 'Red' NOT NULL, - PRIMARY KEY (linkid) -) type=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/1.1/trends.sql b/upgrades/dbpatches/1.3/mysql/1.1/trends.sql deleted file mode 100644 index b235e9a7..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.1/trends.sql +++ /dev/null @@ -1,9 +0,0 @@ -CREATE TABLE trends ( - itemid int(4) DEFAULT '0' NOT NULL, - clock int(4) DEFAULT '0' NOT NULL, - num int(2) 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) -) type=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/1.1/trigger_depends.sql b/upgrades/dbpatches/1.3/mysql/1.1/trigger_depends.sql deleted file mode 100644 index 9e43590c..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.1/trigger_depends.sql +++ /dev/null @@ -1,7 +0,0 @@ -CREATE TABLE trigger_depends ( - triggerid_down int(4) DEFAULT '0' NOT NULL, - triggerid_up int(4) DEFAULT '0' NOT NULL, - PRIMARY KEY (triggerid_down, triggerid_up), --- KEY (triggerid_down), - KEY (triggerid_up) -) type=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/1.1/triggers.sql b/upgrades/dbpatches/1.3/mysql/1.1/triggers.sql deleted file mode 100644 index 887b4caf..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.1/triggers.sql +++ /dev/null @@ -1,17 +0,0 @@ -CREATE TABLE triggers ( - triggerid int(4) NOT NULL auto_increment, - expression varchar(255) DEFAULT '' NOT NULL, - description varchar(255) DEFAULT '' NOT NULL, - url varchar(255) DEFAULT '' NOT NULL, - status int(4) DEFAULT '0' NOT NULL, - value int(4) DEFAULT '0' NOT NULL, - priority int(2) DEFAULT '0' NOT NULL, - lastchange int(4) DEFAULT '0' NOT NULL, - dep_level int(2) DEFAULT '0' NOT NULL, - comments blob, - error varchar(128) DEFAULT '' NOT NULL, - templateid int(4) DEFAULT '0' NOT NULL, - PRIMARY KEY (triggerid), - KEY (status), - KEY (value) -) type=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/1.1/users.sql b/upgrades/dbpatches/1.3/mysql/1.1/users.sql deleted file mode 100644 index 18eb9f21..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.1/users.sql +++ /dev/null @@ -1,13 +0,0 @@ -CREATE TABLE users ( - userid int(4) NOT NULL auto_increment, - 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 int(4) DEFAULT '900' NOT NULL, - lang varchar(5) DEFAULT 'en_gb' NOT NULL, - refresh int(4) DEFAULT '30' NOT NULL, - PRIMARY KEY (userid), - UNIQUE (alias) -) type=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/1.1/users_groups.sql b/upgrades/dbpatches/1.3/mysql/1.1/users_groups.sql deleted file mode 100644 index ebbc8893..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.1/users_groups.sql +++ /dev/null @@ -1,5 +0,0 @@ -CREATE TABLE users_groups ( - usrgrpid int(4) DEFAULT '0' NOT NULL, - userid int(4) DEFAULT '0' NOT NULL, - PRIMARY KEY (usrgrpid,userid) -) type=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/1.1/usrgrp.sql b/upgrades/dbpatches/1.3/mysql/1.1/usrgrp.sql deleted file mode 100644 index 9701b6c9..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.1/usrgrp.sql +++ /dev/null @@ -1,6 +0,0 @@ -CREATE TABLE usrgrp ( - usrgrpid int(4) NOT NULL auto_increment, - name varchar(64) DEFAULT '' NOT NULL, - PRIMARY KEY (usrgrpid), - UNIQUE (name) -) type=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/1.1/valuemaps.sql b/upgrades/dbpatches/1.3/mysql/1.1/valuemaps.sql deleted file mode 100644 index 394f3aa2..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.1/valuemaps.sql +++ /dev/null @@ -1,6 +0,0 @@ -CREATE TABLE valuemaps ( - valuemapid int(4) NOT NULL auto_increment, - name varchar(64) DEFAULT '' NOT NULL, - PRIMARY KEY (valuemapid), - UNIQUE (name) -) type=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/1.3/acknowledges.sql b/upgrades/dbpatches/1.3/mysql/1.3/acknowledges.sql deleted file mode 100644 index 603c88c5..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/acknowledges.sql +++ /dev/null @@ -1,11 +0,0 @@ -CREATE TABLE acknowledges ( - 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 INDEX acknowledges_1 on acknowledges (userid); -CREATE INDEX acknowledges_2 on acknowledges (eventid); -CREATE INDEX acknowledges_3 on acknowledges (clock); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/actions.sql b/upgrades/dbpatches/1.3/mysql/1.3/actions.sql deleted file mode 100644 index ff277579..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/actions.sql +++ /dev/null @@ -1,14 +0,0 @@ -CREATE TABLE actions ( - 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) -); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/alerts.sql b/upgrades/dbpatches/1.3/mysql/1.3/alerts.sql deleted file mode 100644 index 0ac338bd..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/alerts.sql +++ /dev/null @@ -1,25 +0,0 @@ -CREATE TABLE alerts ( - 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 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); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/applications.sql b/upgrades/dbpatches/1.3/mysql/1.3/applications.sql deleted file mode 100644 index 58e95976..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/applications.sql +++ /dev/null @@ -1,9 +0,0 @@ -CREATE TABLE applications ( - 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 UNIQUE INDEX applications_2 on applications (hostid,name); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/auditlog.sql b/upgrades/dbpatches/1.3/mysql/1.3/auditlog.sql deleted file mode 100644 index 9056b1df..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/auditlog.sql +++ /dev/null @@ -1,11 +0,0 @@ -CREATE TABLE auditlog ( - 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 INDEX auditlog_1 on auditlog (userid,clock); -CREATE INDEX auditlog_2 on auditlog (clock); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/autoreg.sql b/upgrades/dbpatches/1.3/mysql/1.3/autoreg.sql deleted file mode 100644 index 61bb92f9..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/autoreg.sql +++ /dev/null @@ -1,7 +0,0 @@ -CREATE TABLE autoreg ( - 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) -); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/conditions.sql b/upgrades/dbpatches/1.3/mysql/1.3/conditions.sql deleted file mode 100644 index e961111f..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/conditions.sql +++ /dev/null @@ -1,9 +0,0 @@ -CREATE TABLE conditions ( - 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 INDEX conditions_1 on conditions (actionid); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/config.sql b/upgrades/dbpatches/1.3/mysql/1.3/config.sql deleted file mode 100644 index 664e57de..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/config.sql +++ /dev/null @@ -1,8 +0,0 @@ -CREATE TABLE config ( - 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) -); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/events.sql b/upgrades/dbpatches/1.3/mysql/1.3/events.sql deleted file mode 100644 index 597181a4..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/events.sql +++ /dev/null @@ -1,10 +0,0 @@ -CREATE TABLE events ( - 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 INDEX events_1 on events (triggerid,clock); -CREATE INDEX events_2 on events (clock); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/functions.sql b/upgrades/dbpatches/1.3/mysql/1.3/functions.sql deleted file mode 100644 index 76a48f1d..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/functions.sql +++ /dev/null @@ -1,11 +0,0 @@ -CREATE TABLE functions ( - 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 INDEX functions_1 on functions (triggerid); -CREATE INDEX functions_2 on functions (itemid,function,parameter); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/graphs.sql b/upgrades/dbpatches/1.3/mysql/1.3/graphs.sql deleted file mode 100644 index fead04c1..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/graphs.sql +++ /dev/null @@ -1,15 +0,0 @@ -CREATE TABLE graphs ( - 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 INDEX graphs_graphs_1 on graphs (name); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/graphs_items.sql b/upgrades/dbpatches/1.3/mysql/1.3/graphs_items.sql deleted file mode 100644 index f4151dde..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/graphs_items.sql +++ /dev/null @@ -1,13 +0,0 @@ -CREATE TABLE graphs_items ( - 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) -); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/groups.sql b/upgrades/dbpatches/1.3/mysql/1.3/groups.sql deleted file mode 100644 index 7a971b8d..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/groups.sql +++ /dev/null @@ -1,6 +0,0 @@ -CREATE TABLE groups ( - groupid bigint unsigned DEFAULT '0' NOT NULL, - name varchar(64) DEFAULT '' NOT NULL, - PRIMARY KEY (groupid) -); -CREATE INDEX groups_1 on groups (name); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/help_items.sql b/upgrades/dbpatches/1.3/mysql/1.3/help_items.sql deleted file mode 100644 index 6ff34132..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/help_items.sql +++ /dev/null @@ -1,6 +0,0 @@ -CREATE TABLE help_items ( - itemtype integer DEFAULT '0' NOT NULL, - key_ varchar(255) DEFAULT '' NOT NULL, - description varchar(255) DEFAULT '' NOT NULL, - PRIMARY KEY (itemtype,key_) -); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/history.sql b/upgrades/dbpatches/1.3/mysql/1.3/history.sql deleted file mode 100644 index 9e89cc6b..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/history.sql +++ /dev/null @@ -1,6 +0,0 @@ -CREATE TABLE history ( - 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); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/history_log.sql b/upgrades/dbpatches/1.3/mysql/1.3/history_log.sql deleted file mode 100644 index d9cff635..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/history_log.sql +++ /dev/null @@ -1,11 +0,0 @@ -CREATE TABLE history_log ( - 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 INDEX history_log_1 on history_log (itemid,clock); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/history_str.sql b/upgrades/dbpatches/1.3/mysql/1.3/history_str.sql deleted file mode 100644 index 4cbb2196..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/history_str.sql +++ /dev/null @@ -1,6 +0,0 @@ -CREATE TABLE history_str ( - 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); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/history_str_sync.sql b/upgrades/dbpatches/1.3/mysql/1.3/history_str_sync.sql deleted file mode 100644 index a1170393..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/history_str_sync.sql +++ /dev/null @@ -1,9 +0,0 @@ -CREATE TABLE history_str_sync ( - 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 INDEX history_str_sync_1 on history_str_sync (nodeid,id); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/history_sync.sql b/upgrades/dbpatches/1.3/mysql/1.3/history_sync.sql deleted file mode 100644 index 9c9feedf..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/history_sync.sql +++ /dev/null @@ -1,9 +0,0 @@ -CREATE TABLE history_sync ( - 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 INDEX history_sync_1 on history_sync (nodeid,id); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/history_text.sql b/upgrades/dbpatches/1.3/mysql/1.3/history_text.sql deleted file mode 100644 index 18f1642e..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/history_text.sql +++ /dev/null @@ -1,8 +0,0 @@ -CREATE TABLE history_text ( - 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 INDEX history_text_1 on history_text (itemid,clock); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/history_uint.sql b/upgrades/dbpatches/1.3/mysql/1.3/history_uint.sql deleted file mode 100644 index 8d8b7d8d..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/history_uint.sql +++ /dev/null @@ -1,6 +0,0 @@ -CREATE TABLE history_uint ( - 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); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/history_uint_sync.sql b/upgrades/dbpatches/1.3/mysql/1.3/history_uint_sync.sql deleted file mode 100644 index 19f2ef4c..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/history_uint_sync.sql +++ /dev/null @@ -1,9 +0,0 @@ -CREATE TABLE history_uint_sync ( - 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 INDEX history_uint_sync_1 on history_uint_sync (nodeid,id); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/hosts.sql b/upgrades/dbpatches/1.3/mysql/1.3/hosts.sql deleted file mode 100644 index 48c108d2..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/hosts.sql +++ /dev/null @@ -1,15 +0,0 @@ -CREATE TABLE hosts ( - 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); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/hosts_groups.sql b/upgrades/dbpatches/1.3/mysql/1.3/hosts_groups.sql deleted file mode 100644 index a31410af..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/hosts_groups.sql +++ /dev/null @@ -1,7 +0,0 @@ -CREATE TABLE hosts_groups ( - 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 INDEX hosts_groups_groups_1 on hosts_groups (hostid,groupid); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/hosts_profiles.sql b/upgrades/dbpatches/1.3/mysql/1.3/hosts_profiles.sql deleted file mode 100644 index 1cb419e5..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/hosts_profiles.sql +++ /dev/null @@ -1,15 +0,0 @@ -CREATE TABLE hosts_profiles ( - 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) -); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/hosts_templates.sql b/upgrades/dbpatches/1.3/mysql/1.3/hosts_templates.sql deleted file mode 100644 index 93872a12..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/hosts_templates.sql +++ /dev/null @@ -1,7 +0,0 @@ -CREATE TABLE hosts_templates ( - 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 UNIQUE INDEX hosts_templates_1 on hosts_templates (hostid,templateid); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/housekeeper.sql b/upgrades/dbpatches/1.3/mysql/1.3/housekeeper.sql deleted file mode 100644 index a00ab476..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/housekeeper.sql +++ /dev/null @@ -1,7 +0,0 @@ -CREATE TABLE housekeeper ( - 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) -); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/httpstep.sql b/upgrades/dbpatches/1.3/mysql/1.3/httpstep.sql deleted file mode 100644 index 958c0211..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/httpstep.sql +++ /dev/null @@ -1,12 +0,0 @@ -CREATE TABLE httpstep ( - httpstepid bigint unsigned DEFAULT '0' NOT NULL, - httptestid bigint unsigned DEFAULT '0' NOT NULL, - name varchar(64) DEFAULT '' NOT NULL, - no integer DEFAULT '0' NOT NULL, - url varchar(128) DEFAULT '' NOT NULL, - timeout integer DEFAULT '30' NOT NULL, - posts blob DEFAULT '' NOT NULL, - required varchar(255) DEFAULT '' NOT NULL, - PRIMARY KEY (httpstepid) -); -CREATE INDEX httpstep_httpstep_1 on httpstep (httptestid); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/httpstepitem.sql b/upgrades/dbpatches/1.3/mysql/1.3/httpstepitem.sql deleted file mode 100644 index 3a0fa50d..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/httpstepitem.sql +++ /dev/null @@ -1,8 +0,0 @@ -CREATE TABLE httpstepitem ( - httpstepitemid bigint unsigned DEFAULT '0' NOT NULL, - httpstepid bigint unsigned DEFAULT '0' NOT NULL, - itemid bigint unsigned DEFAULT '0' NOT NULL, - type integer DEFAULT '0' NOT NULL, - PRIMARY KEY (httpstepitemid) -); -CREATE UNIQUE INDEX httpstepitem_httpstepitem_1 on httpstepitem (httpstepid,itemid); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/httptest.sql b/upgrades/dbpatches/1.3/mysql/1.3/httptest.sql deleted file mode 100644 index 4197f377..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/httptest.sql +++ /dev/null @@ -1,17 +0,0 @@ -CREATE TABLE httptest ( - httptestid bigint unsigned DEFAULT '0' NOT NULL, - name varchar(64) DEFAULT '' NOT NULL, - applicationid bigint unsigned DEFAULT '0' NOT NULL, - lastcheck integer DEFAULT '0' NOT NULL, - nextcheck integer DEFAULT '0' NOT NULL, - curstate integer DEFAULT '0' NOT NULL, - curstep integer DEFAULT '0' NOT NULL, - lastfailedstep bigint unsigned DEFAULT '0' NOT NULL, - delay integer DEFAULT '60' NOT NULL, - status integer DEFAULT '0' NOT NULL, - macros blob DEFAULT '' NOT NULL, - agent varchar(255) DEFAULT '' NOT NULL, - time double(16,4) DEFAULT '0' NOT NULL, - PRIMARY KEY (httptestid) -); -CREATE INDEX httptest_httptest_1 on httptest (httptestid); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/httptestitem.sql b/upgrades/dbpatches/1.3/mysql/1.3/httptestitem.sql deleted file mode 100644 index a8fa36d9..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/httptestitem.sql +++ /dev/null @@ -1,8 +0,0 @@ -CREATE TABLE httptestitem ( - httptestitemid bigint unsigned DEFAULT '0' NOT NULL, - httptestid bigint unsigned DEFAULT '0' NOT NULL, - itemid bigint unsigned DEFAULT '0' NOT NULL, - type integer DEFAULT '0' NOT NULL, - PRIMARY KEY (httptestitemid) -); -CREATE UNIQUE INDEX httptestitem_httptestitem_1 on httptestitem (httptestid,itemid); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/images.sql b/upgrades/dbpatches/1.3/mysql/1.3/images.sql deleted file mode 100644 index 2b7b7024..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/images.sql +++ /dev/null @@ -1,8 +0,0 @@ -CREATE TABLE images ( - 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 INDEX images_1 on images (imagetype,name); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/items.sql b/upgrades/dbpatches/1.3/mysql/1.3/items.sql deleted file mode 100644 index a898583d..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/items.sql +++ /dev/null @@ -1,39 +0,0 @@ -CREATE TABLE items ( - 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(255) 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 varchar(255) 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 UNIQUE INDEX items_1 on items (hostid,key_); -CREATE INDEX items_2 on items (nextcheck); -CREATE INDEX items_3 on items (status); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/items_applications.sql b/upgrades/dbpatches/1.3/mysql/1.3/items_applications.sql deleted file mode 100644 index a57fc150..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/items_applications.sql +++ /dev/null @@ -1,7 +0,0 @@ -CREATE TABLE items_applications ( - 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 INDEX items_applications_1 on items_applications (applicationid,itemid); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/mappings.sql b/upgrades/dbpatches/1.3/mysql/1.3/mappings.sql deleted file mode 100644 index 216b7192..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/mappings.sql +++ /dev/null @@ -1,8 +0,0 @@ -CREATE TABLE mappings ( - 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 INDEX mappings_1 on mappings (valuemapid); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/media.sql b/upgrades/dbpatches/1.3/mysql/1.3/media.sql deleted file mode 100644 index 1211847c..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/media.sql +++ /dev/null @@ -1,12 +0,0 @@ -CREATE TABLE media ( - 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); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/media_type.sql b/upgrades/dbpatches/1.3/mysql/1.3/media_type.sql deleted file mode 100644 index 7db92f49..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/media_type.sql +++ /dev/null @@ -1,11 +0,0 @@ -CREATE TABLE media_type ( - 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) -); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/node_cksum.sql b/upgrades/dbpatches/1.3/mysql/1.3/node_cksum.sql deleted file mode 100644 index cd675a76..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/node_cksum.sql +++ /dev/null @@ -1,11 +0,0 @@ -CREATE TABLE node_cksum ( - 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 INDEX node_cksum_cksum_1 on node_cksum (nodeid,tablename,fieldname,recordid,cksumtype); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/node_configlog.sql b/upgrades/dbpatches/1.3/mysql/1.3/node_configlog.sql deleted file mode 100644 index f80f9b25..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/node_configlog.sql +++ /dev/null @@ -1,12 +0,0 @@ -CREATE TABLE node_configlog ( - 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 INDEX node_configlog_configlog_1 on node_configlog (conflogid); -CREATE INDEX node_configlog_configlog_2 on node_configlog (nodeid,tablename); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/nodes.sql b/upgrades/dbpatches/1.3/mysql/1.3/nodes.sql deleted file mode 100644 index 88acf5ed..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/nodes.sql +++ /dev/null @@ -1,18 +0,0 @@ -CREATE TABLE nodes ( - nodeid integer 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, - events_eventid bigint unsigned DEFAULT '0' NOT NULL, - alerts_alertid 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 integer DEFAULT '0' NOT NULL, - PRIMARY KEY (nodeid) -); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/profiles.sql b/upgrades/dbpatches/1.3/mysql/1.3/profiles.sql deleted file mode 100644 index e01b892a..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/profiles.sql +++ /dev/null @@ -1,9 +0,0 @@ -CREATE TABLE profiles ( - 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 UNIQUE INDEX profiles_1 on profiles (userid,idx); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/rights.sql b/upgrades/dbpatches/1.3/mysql/1.3/rights.sql deleted file mode 100644 index 9a1fdc23..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/rights.sql +++ /dev/null @@ -1,9 +0,0 @@ -CREATE TABLE rights ( - 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 INDEX rights_1 on rights (groupid); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/screens.sql b/upgrades/dbpatches/1.3/mysql/1.3/screens.sql deleted file mode 100644 index 982aec52..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/screens.sql +++ /dev/null @@ -1,7 +0,0 @@ -CREATE TABLE screens ( - 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) -); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/screens_items.sql b/upgrades/dbpatches/1.3/mysql/1.3/screens_items.sql deleted file mode 100644 index 458e212f..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/screens_items.sql +++ /dev/null @@ -1,18 +0,0 @@ -CREATE TABLE screens_items ( - 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) -); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/service_alarms.sql b/upgrades/dbpatches/1.3/mysql/1.3/service_alarms.sql deleted file mode 100644 index 6d01e21d..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/service_alarms.sql +++ /dev/null @@ -1,9 +0,0 @@ -CREATE TABLE service_alarms ( - 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 INDEX service_alarms_1 on service_alarms (serviceid,clock); -CREATE INDEX service_alarms_2 on service_alarms (clock); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/services.sql b/upgrades/dbpatches/1.3/mysql/1.3/services.sql deleted file mode 100644 index c431febc..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/services.sql +++ /dev/null @@ -1,11 +0,0 @@ -CREATE TABLE services ( - 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) -); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/services_links.sql b/upgrades/dbpatches/1.3/mysql/1.3/services_links.sql deleted file mode 100644 index 3dea6f85..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/services_links.sql +++ /dev/null @@ -1,9 +0,0 @@ -CREATE TABLE services_links ( - 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 INDEX services_links_links_1 on services_links (servicedownid); -CREATE UNIQUE INDEX services_links_links_2 on services_links (serviceupid,servicedownid); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/services_times.sql b/upgrades/dbpatches/1.3/mysql/1.3/services_times.sql deleted file mode 100644 index 444a26d1..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/services_times.sql +++ /dev/null @@ -1,10 +0,0 @@ -CREATE TABLE services_times ( - 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 INDEX services_times_times_1 on services_times (serviceid,type,ts_from,ts_to); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/sessions.sql b/upgrades/dbpatches/1.3/mysql/1.3/sessions.sql deleted file mode 100644 index b56c38c6..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/sessions.sql +++ /dev/null @@ -1,6 +0,0 @@ -CREATE TABLE sessions ( - sessionid varchar(32) DEFAULT '' NOT NULL, - userid bigint unsigned DEFAULT '0' NOT NULL, - lastaccess integer DEFAULT '0' NOT NULL, - PRIMARY KEY (sessionid) -); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/sysmaps.sql b/upgrades/dbpatches/1.3/mysql/1.3/sysmaps.sql deleted file mode 100644 index e6fecb34..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/sysmaps.sql +++ /dev/null @@ -1,11 +0,0 @@ -CREATE TABLE sysmaps ( - 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 INDEX sysmaps_1 on sysmaps (name); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/sysmaps_elements.sql b/upgrades/dbpatches/1.3/mysql/1.3/sysmaps_elements.sql deleted file mode 100644 index 4d751633..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/sysmaps_elements.sql +++ /dev/null @@ -1,14 +0,0 @@ -CREATE TABLE sysmaps_elements ( - 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) -); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/sysmaps_links.sql b/upgrades/dbpatches/1.3/mysql/1.3/sysmaps_links.sql deleted file mode 100644 index c088eb2c..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/sysmaps_links.sql +++ /dev/null @@ -1,12 +0,0 @@ -CREATE TABLE sysmaps_links ( - 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) -); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/trends.sql b/upgrades/dbpatches/1.3/mysql/1.3/trends.sql deleted file mode 100644 index 03488daf..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/trends.sql +++ /dev/null @@ -1,9 +0,0 @@ -CREATE TABLE trends ( - 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) -); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/trigger_depends.sql b/upgrades/dbpatches/1.3/mysql/1.3/trigger_depends.sql deleted file mode 100644 index 07bfd694..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/trigger_depends.sql +++ /dev/null @@ -1,8 +0,0 @@ -CREATE TABLE trigger_depends ( - 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); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/triggers.sql b/upgrades/dbpatches/1.3/mysql/1.3/triggers.sql deleted file mode 100644 index b25254f5..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/triggers.sql +++ /dev/null @@ -1,17 +0,0 @@ -CREATE TABLE triggers ( - 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); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/users.sql b/upgrades/dbpatches/1.3/mysql/1.3/users.sql deleted file mode 100644 index d695ab26..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/users.sql +++ /dev/null @@ -1,14 +0,0 @@ -CREATE TABLE users ( - 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 INDEX users_1 on users (alias); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/users_groups.sql b/upgrades/dbpatches/1.3/mysql/1.3/users_groups.sql deleted file mode 100644 index 26cedcd5..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/users_groups.sql +++ /dev/null @@ -1,7 +0,0 @@ -CREATE TABLE users_groups ( - 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 INDEX users_groups_1 on users_groups (usrgrpid,userid); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/usrgrp.sql b/upgrades/dbpatches/1.3/mysql/1.3/usrgrp.sql deleted file mode 100644 index b811fc98..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/usrgrp.sql +++ /dev/null @@ -1,6 +0,0 @@ -CREATE TABLE usrgrp ( - usrgrpid bigint unsigned DEFAULT '0' NOT NULL, - name varchar(64) DEFAULT '' NOT NULL, - PRIMARY KEY (usrgrpid) -); -CREATE INDEX usrgrp_1 on usrgrp (name); diff --git a/upgrades/dbpatches/1.3/mysql/1.3/valuemaps.sql b/upgrades/dbpatches/1.3/mysql/1.3/valuemaps.sql deleted file mode 100644 index 5eaa6983..00000000 --- a/upgrades/dbpatches/1.3/mysql/1.3/valuemaps.sql +++ /dev/null @@ -1,6 +0,0 @@ -CREATE TABLE valuemaps ( - valuemapid bigint unsigned DEFAULT '0' NOT NULL, - name varchar(64) DEFAULT '' NOT NULL, - PRIMARY KEY (valuemapid) -); -CREATE INDEX valuemaps_1 on valuemaps (name); diff --git a/upgrades/dbpatches/1.3/mysql/changed_tables.sql b/upgrades/dbpatches/1.3/mysql/changed_tables.sql deleted file mode 100644 index d2070f34..00000000 --- a/upgrades/dbpatches/1.3/mysql/changed_tables.sql +++ /dev/null @@ -1,628 +0,0 @@ -CREATE TABLE acknowledges_tmp ( - 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 INDEX acknowledges_1 on acknowledges_tmp (userid); -CREATE INDEX acknowledges_2 on acknowledges_tmp (eventid); -CREATE INDEX acknowledges_3 on acknowledges_tmp (clock); - -insert into acknowledges_tmp select * from acknowledges; -drop table acknowledges; -alter table acknowledges_tmp rename acknowledges; - -CREATE TABLE actions_tmp ( - 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) -); - -insert into actions_tmp select * from actions; -drop table actions; -alter table actions_tmp rename actions; - -CREATE TABLE applications_tmp ( - 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_tmp (templateid); -CREATE UNIQUE INDEX applications_2 on applications_tmp (hostid,name); - -insert into applications_tmp select * from applications; -drop table applications; -alter table applications_tmp rename applications; - -CREATE TABLE auditlog_tmp ( - 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 INDEX auditlog_1 on auditlog_tmp (userid,clock); -CREATE INDEX auditlog_2 on auditlog_tmp (clock); - -insert into auditlog_tmp select * from auditlog; -drop table auditlog; -alter table auditlog_tmp rename auditlog; - -CREATE TABLE autoreg_tmp ( - 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) -); - -insert into autoreg_tmp select * from autoreg; -drop table autoreg; -alter table autoreg_tmp rename autoreg; - -CREATE TABLE conditions_tmp ( - 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 INDEX conditions_1 on conditions_tmp (actionid); - -insert into conditions_tmp select * from conditions; -drop table conditions; -alter table conditions_tmp rename conditions; - -CREATE TABLE config_tmp ( - 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) -); - -insert into config_tmp select * from config; -drop table config; -alter table config_tmp rename config; - -CREATE TABLE functions_tmp ( - 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 INDEX functions_1 on functions_tmp (triggerid); -CREATE INDEX functions_2 on functions_tmp (itemid,function,parameter); - -insert into functions_tmp select * from functions; -drop table functions; -alter table functions_tmp rename functions; - -CREATE TABLE graphs_tmp ( - 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 INDEX graphs_graphs_1 on graphs_tmp (name); - -insert into graphs_tmp select * from graphs; -drop table graphs; -alter table graphs_tmp rename graphs; - -CREATE TABLE graphs_items_tmp ( - 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) -); - -insert into graphs_items_tmp select * from graphs_items; -drop table graphs_items; -alter table graphs_items_tmp rename graphs_items; - -CREATE TABLE groups_tmp ( - groupid bigint unsigned DEFAULT '0' NOT NULL, - name varchar(64) DEFAULT '' NOT NULL, - PRIMARY KEY (groupid) -); -CREATE INDEX groups_1 on groups_tmp (name); - -insert into groups_tmp select * from groups; -drop table groups; -alter table groups_tmp rename groups; - -CREATE TABLE help_items_tmp ( - itemtype integer DEFAULT '0' NOT NULL, - key_ varchar(255) DEFAULT '' NOT NULL, - description varchar(255) DEFAULT '' NOT NULL, - PRIMARY KEY (itemtype,key_) -); - -insert into help_items_tmp select * from help_items; -drop table help_items; -alter table help_items_tmp rename help_items; - -CREATE TABLE hosts_tmp ( - 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_tmp (host); -CREATE INDEX hosts_2 on hosts_tmp (status); - -insert into hosts_tmp select * from hosts; -drop table hosts; -alter table hosts_tmp rename hosts; - -CREATE TABLE hosts_groups_tmp ( - 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 INDEX hosts_groups_groups_1 on hosts_groups_tmp (hostid,groupid); - -insert into hosts_groups_tmp select * from hosts_groups; -drop table hosts_groups; -alter table hosts_groups_tmp rename hosts_groups; - -CREATE TABLE hosts_profiles_tmp ( - 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) -); - -insert into hosts_profiles_tmp select * from hosts_profiles; -drop table hosts_profiles; -alter table hosts_profiles_tmp rename hosts_profiles; - -CREATE TABLE hosts_templates_tmp ( - 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 UNIQUE INDEX hosts_templates_1 on hosts_templates_tmp (hostid,templateid); - -insert into hosts_templates_tmp select * from hosts_templates; -drop table hosts_templates; -alter table hosts_templates_tmp rename hosts_templates; - -CREATE TABLE housekeeper_tmp ( - 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) -); - -insert into housekeeper_tmp select * from housekeeper; -drop table housekeeper; -alter table housekeeper_tmp rename housekeeper; - -CREATE TABLE image_tmp ( - 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 INDEX images_1 on images_tmp (imagetype,name); - -insert into image_tmp select * from image; -drop table image; -alter table image_tmp rename image; - -CREATE TABLE items_tmp ( - 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(255) 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 varchar(255) 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 UNIQUE INDEX items_1 on items_tmp (hostid,key_); -CREATE INDEX items_2 on items_tmp (nextcheck); -CREATE INDEX items_3 on items_tmp (status); - -insert into items_tmp select * from items; -drop table items; -alter table image_tmp rename items; - -CREATE TABLE items_applications_tmp ( - 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 INDEX items_applications_1 on items_applications_tmp (applicationid,itemid); - -insert into items_applications_tmp select * from items_applications; -drop table items_applications; -alter table items_applications_tmp rename items_applications; - -CREATE TABLE mappings_tmp ( - 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 INDEX mappings_1 on mappings_tmp (valuemapid); - -insert into mappings_tmp select * from mappings; -drop table mappings; -alter table mappings_tmp rename mappings; - -CREATE TABLE media_tmp ( - 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_tmp (userid); -CREATE INDEX media_2 on media_tmp (mediatypeid); - -insert into media_tmp select * from media; -drop table media_tmp; -alter table media_tmp rename media_tmp; - -CREATE TABLE media_type_tmp ( - 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) -); - -insert into media_type_tmp select * from media_type; -drop table media_type; -alter table media_type_tmp rename media_type; - -CREATE TABLE profiles_tmp ( - 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 UNIQUE INDEX profiles_1 on profiles_tmp (userid,idx); - -insert into profiles_tmp select * from profiles; -drop table profiles_tmp; -alter table profiles_tmp rename profiles_tmp; - -CREATE TABLE rights_tmp ( - 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 INDEX rights_1 on rights_tmp (groupid); - -insert into rights_tmp select * from rights; -drop table rights; -alter table rights_tmp rename rights; - -CREATE TABLE screens_tmp ( - 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) -); - -insert into screens_tmp select * from screens; -drop table screens; -alter table screens_tmp rename screens; - -CREATE TABLE screens_items_tmp ( - 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) -); - -insert into screens_items_tmp select * from screens_items; -drop table screens_items_tmp; -alter table screens_items_tmp rename screens_items_tmp; - -CREATE TABLE services_tmp ( - 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) -); - -insert into services_tmp select * from services; -drop table services_tmp; -alter table services_tmp rename services_tmp; - -CREATE TABLE service_alarms_tmp ( - 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 INDEX service_alarms_1 on service_alarms_tmp (serviceid,clock); -CREATE INDEX service_alarms_2 on service_alarms_tmp (clock); - -insert into service_alarms_tmp select * from service_alarms; -drop table service_alarms; -alter table service_alarms_tmp rename service_alarms; - -CREATE TABLE services_links_tmp ( - 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 INDEX services_links_links_1 on services_links_tmp (servicedownid); -CREATE UNIQUE INDEX services_links_links_2 on services_links_tmp (serviceupid,servicedownid); - -insert into services_links_tmp select * from services_links; -drop table services_links; -alter table services_links_tmp rename services_links; - -CREATE TABLE sessions_tmp ( - sessionid varchar(32) DEFAULT '' NOT NULL, - userid bigint unsigned DEFAULT '0' NOT NULL, - lastaccess integer DEFAULT '0' NOT NULL, - PRIMARY KEY (sessionid) -); - -insert into sessions_tmp select * from sessions; -drop table sessions_tmp; -alter table sessions_tmp rename sessions_tmp; - -CREATE TABLE sysmaps_links_tmp ( - 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) -); - -insert into sysmaps_links_tmp select * from sysmaps_links; -drop table sysmaps_links; -alter table sysmaps_links_tmp rename sysmaps_links; - -CREATE TABLE sysmaps_elements_tmp ( - 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) -); - -insert into sysmaps_elements_tmp select * from sysmaps_elements; -drop table sysmaps_elements; -alter table sysmaps_elements_tmp rename sysmaps_elements; - -CREATE TABLE sysmaps_tmp ( - 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 INDEX sysmaps_1 on sysmaps_tmp (name); - -insert into sysmaps_tmp select * from sysmaps; -drop table sysmaps; -alter table sysmaps_tmp rename sysmaps; - -CREATE TABLE triggers_tmp ( - 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_tmp (status); -CREATE INDEX triggers_2 on triggers_tmp (value); - -insert into triggers_tmp select * from triggers; -drop table triggers_tmp; -alter table triggers_tmp rename triggers_tmp; - -CREATE TABLE trigger_depends_tmp ( - 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_tmp (triggerid_down,triggerid_up); -CREATE INDEX trigger_depends_2 on trigger_depends_tmp (triggerid_up); - -insert into trigger_depends_tmp select * from trigger_depends; -drop table trigger_depends; -alter table trigger_depends_tmp rename trigger_depends; - -CREATE TABLE users_tmp ( - 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 INDEX users_1 on users_tmp (alias); - -insert into users_tmp select * from users; -drop table users; -alter table users_tmp rename users; - -CREATE TABLE usrgrp_tmp ( - usrgrpid bigint unsigned DEFAULT '0' NOT NULL, - name varchar(64) DEFAULT '' NOT NULL, - PRIMARY KEY (usrgrpid) -); -CREATE INDEX usrgrp_1 on usrgrp_tmp (name); - -insert into usrgrp_tmp select * from usrgrp; -drop table usrgrp; -alter table usrgrp_tmp rename usrgrp; - -CREATE TABLE users_groups_tmp ( - 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 INDEX users_groups_1 on users_groups_tmp (usrgrpid,userid); - -insert into users_groups_tmp select * from users_groups; -drop table users_groups; -alter table users_groups_tmp rename users_groups; - -CREATE TABLE valuemaps_tmp ( - valuemapid bigint unsigned DEFAULT '0' NOT NULL, - name varchar(64) DEFAULT '' NOT NULL, - PRIMARY KEY (valuemapid) -); -CREATE INDEX valuemaps_1 on valuemaps_tmp (name); - -insert into valuemaps_tmp select * from valuemaps; -drop table valuemaps; -alter table valuemaps_tmp rename valuemaps; diff --git a/upgrades/dbpatches/1.3/mysql/history_tables.sql b/upgrades/dbpatches/1.3/mysql/history_tables.sql deleted file mode 100644 index bc23a79c..00000000 --- a/upgrades/dbpatches/1.3/mysql/history_tables.sql +++ /dev/null @@ -1,119 +0,0 @@ -CREATE TABLE alerts_tmp ( - 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 INDEX alerts_1 on alerts_tmp (actionid); -CREATE INDEX alerts_2 on alerts_tmp (clock); -CREATE INDEX alerts_3 on alerts_tmp (triggerid); -CREATE INDEX alerts_4 on alerts_tmp (status,retries); -CREATE INDEX alerts_5 on alerts_tmp (mediatypeid); -CREATE INDEX alerts_6 on alerts_tmp (userid); - -insert into alerts_tmp select * from alerts; -drop table alerts; -alter table alerts_tmp rename alerts; - -CREATE TABLE events ( - 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 INDEX events_1 on events (triggerid,clock); -CREATE INDEX events_2 on events (clock); - -insert into events select * from alarms; -drop table alarms; - -CREATE TABLE history_tmp ( - 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_tmp (itemid,clock); - -insert into history_tmp select * from history; -drop table history; -alter table history_tmp rename history; - -CREATE TABLE history_uint_tmp ( - 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_tmp (itemid,clock); - -insert into history_uint_tmp select * from history_uint; -drop table history_uint; -alter table history_uint_tmp rename history_uint; - -CREATE TABLE history_str_tmp ( - 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_tmp (itemid,clock); - -insert into history_str_tmp select * from history_str; -drop table history_str; -alter table history_str_tmp rename history_str; - -CREATE TABLE history_log_tmp ( - 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 INDEX history_log_1 on history_log_tmp (itemid,clock); - -insert into history_log_tmp select * from history_log; -drop table history_log; -alter table history_log_tmp rename history_log; - -CREATE TABLE history_text_tmp ( - 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 INDEX history_text_1 on history_text_tmp (itemid,clock); - -insert into history_text_tmp select * from history_text; -drop table history_text; -alter table history_text_tmp rename history_text; - -CREATE TABLE trends_tmp ( - 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) -); - -insert into trends_tmp select * from trends; -drop table trends; -alter table trends_tmp rename trends; diff --git a/upgrades/dbpatches/1.3/mysql/new_tables.sql b/upgrades/dbpatches/1.3/mysql/new_tables.sql deleted file mode 100644 index 8153baa3..00000000 --- a/upgrades/dbpatches/1.3/mysql/new_tables.sql +++ /dev/null @@ -1,127 +0,0 @@ -CREATE TABLE httptest ( - httptestid bigint unsigned DEFAULT '0' NOT NULL, - name varchar(64) DEFAULT '' NOT NULL, - applicationid bigint unsigned DEFAULT '0' NOT NULL, - nextcheck integer DEFAULT '0' NOT NULL, - delay integer DEFAULT '60' NOT NULL, - status integer DEFAULT '0' NOT NULL, - PRIMARY KEY (httptestid) -); -CREATE INDEX httptest_httptest_1 on httptest (httptestid); - -CREATE TABLE httpstep ( - httpstepid bigint unsigned DEFAULT '0' NOT NULL, - httptestid bigint unsigned DEFAULT '0' NOT NULL, - name varchar(64) DEFAULT '' NOT NULL, - no integer DEFAULT '0' NOT NULL, - url varchar(128) DEFAULT '' NOT NULL, - timeout integer DEFAULT '30' NOT NULL, - posts blob DEFAULT '' NOT NULL, - required varchar(255) DEFAULT '' NOT NULL, - PRIMARY KEY (httpstepid) -); -CREATE INDEX httpstep_httpstep_1 on httpstep (httptestid); - -CREATE TABLE httpstepitem ( - httpstepitemid bigint unsigned DEFAULT '0' NOT NULL, - httpstepid bigint unsigned DEFAULT '0' NOT NULL, - itemid bigint unsigned DEFAULT '0' NOT NULL, - type integer DEFAULT '0' NOT NULL, - PRIMARY KEY (httpstepitemid) -); -CREATE UNIQUE INDEX httpstepitem_httpstepitem_1 on httpstepitem (httpstepid,itemid); - -CREATE TABLE httpmacro ( - httpmacroid bigint unsigned DEFAULT '0' NOT NULL, - httptestid bigint unsigned DEFAULT '0' NOT NULL, - name varchar(64) DEFAULT '0' NOT NULL, - macro varchar(64) DEFAULT '0' NOT NULL, - value varchar(255) DEFAULT '0' NOT NULL, - note blob DEFAULT '' NOT NULL, - PRIMARY KEY (httpmacroid) -); -CREATE UNIQUE INDEX httpmacro_httpmacro_1 on httpmacro (httptestid,name); - -CREATE TABLE nodes ( - nodeid integer 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, - events_eventid bigint unsigned DEFAULT '0' NOT NULL, - alerts_alertid 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 integer DEFAULT '0' NOT NULL, - PRIMARY KEY (nodeid) -); -CREATE TABLE node_cksum ( - 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 INDEX node_cksum_cksum_1 on node_cksum (nodeid,tablename,fieldname,recordid,cksumtype); - -CREATE TABLE node_configlog ( - 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 INDEX node_configlog_configlog_1 on node_configlog (conflogid); -CREATE INDEX node_configlog_configlog_2 on node_configlog (nodeid,tablename); - -CREATE TABLE history_str_sync ( - 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 INDEX history_str_sync_1 on history_str_sync (nodeid,id); - -CREATE TABLE history_sync ( - 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 INDEX history_sync_1 on history_sync (nodeid,id); - -CREATE TABLE history_uint_sync ( - 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 INDEX history_uint_sync_1 on history_uint_sync (nodeid,id); - -CREATE TABLE services_times ( - 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 INDEX services_times_times_1 on services_times (serviceid,type,ts_from,ts_to); diff --git a/upgrades/dbpatches/1.3/mysql/patch.sql b/upgrades/dbpatches/1.3/mysql/patch.sql deleted file mode 100644 index fcf9bec9..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch.sql +++ /dev/null @@ -1,197 +0,0 @@ --- --- Table structure for table 'nodes' --- - -CREATE TABLE nodes ( - nodeid int(4) NOT NULL auto_increment, - name varchar(64) DEFAULT '' NOT NULL, - timezone int(4) DEFAULT '0' NOT NULL, - ip varchar(15) DEFAULT '' NOT NULL, - port int(4) DEFAULT '0' NOT NULL, - slave_history int(4) DEFAULT '0' NOT NULL, - slave_trends int(4) DEFAULT '0' NOT NULL, - nodetype int(4) DEFAULT '0' NOT NULL, - masterid int(4) DEFAULT '0' NOT NULL, - PRIMARY KEY (nodeid) -) type=InnoDB; - --- --- Table structure for table 'node_cksum' --- - -CREATE TABLE node_cksum ( - cksumid int(4) NOT NULL auto_increment, - nodeid int(4) DEFAULT '0' NOT NULL, - tablename varchar(64) DEFAULT '' NOT NULL, - fieldname varchar(64) DEFAULT '' NOT NULL, - recordid int(4) DEFAULT '0' NOT NULL, - cksumtype int(4) DEFAULT '0' NOT NULL, - cksum char(32) DEFAULT '' NOT NULL, - PRIMARY KEY (cksumid), - KEY (nodeid,tablename,fieldname,recordid,cksumtype) -) type=InnoDB; - --- --- Table structure for table 'node_configlog' --- - -CREATE TABLE node_configlog ( - conflogid int(4) NOT NULL auto_increment, - nodeid int(4) DEFAULT '0' NOT NULL, - tablename varchar(64) DEFAULT '' NOT NULL, - recordid int(4) DEFAULT '0' NOT NULL, - operation int(4) DEFAULT '0' NOT NULL, - sync_master int(4) DEFAULT '0' NOT NULL, - sync_slave int(4) DEFAULT '0' NOT NULL, - PRIMARY KEY (conflogid), - KEY (nodeid,tablename) -) type=InnoDB; - ---- Add configid to table config -CREATE TABLE config_tmp ( - configid int(4) NOT NULL auto_increment, - alert_history int(4) DEFAULT '0' NOT NULL, - alarm_history int(4) DEFAULT '0' NOT NULL, - refresh_unsupported int(4) DEFAULT '0' NOT NULL, - work_period varchar(100) DEFAULT '1-5,00:00-24:00' NOT NULL, - PRIMARY KEY (configid) -) type=InnoDB; - -insert into config_tmp (select null,alert_history,alarm_history,refresh_unsupported,work_period from config); -drop table config; -alter table config_tmp rename config; - --- Fix indexes of table groups -CREATE TABLE groups_tmp ( - groupid int(4) NOT NULL auto_increment, - name varchar(64) DEFAULT '' NOT NULL, - PRIMARY KEY (groupid), - KEY (name) -) type=InnoDB; - -insert into groups_tmp (select * from groups); -drop table groups; -alter table groups_tmp rename groups; - - -- Fix indexes of table hosts -CREATE TABLE hosts_tmp ( - hostid int(4) NOT NULL auto_increment, - host varchar(64) DEFAULT '' NOT NULL, - useip int(1) DEFAULT '1' NOT NULL, - ip varchar(15) DEFAULT '127.0.0.1' NOT NULL, - port int(4) DEFAULT '0' NOT NULL, - status int(4) DEFAULT '0' NOT NULL, --- If status=UNREACHABLE, host will not be checked until this time - disable_until int(4) DEFAULT '0' NOT NULL, - error varchar(128) DEFAULT '' NOT NULL, - available int(4) DEFAULT '0' NOT NULL, - errors_from int(4) DEFAULT '0' NOT NULL, - templateid int(4) DEFAULT '0' NOT NULL, - PRIMARY KEY (hostid), --- UNIQUE (host), - KEY (host), - KEY (status) -) type=InnoDB; - -insert into hosts_tmp (select * from hosts); -drop table hosts; -alter table hosts_tmp rename hosts; - --- Add hostgroupid to table hosts_groups - -CREATE TABLE hosts_groups_tmp ( - hostgroupid int(4) NOT NULL auto_increment, - hostid int(4) DEFAULT '0' NOT NULL, - groupid int(4) DEFAULT '0' NOT NULL, - PRIMARY KEY (hostgroupid), - KEY (hostid,groupid) -) type=InnoDB; - -insert into hosts_groups_tmp (select null,hostid,groupid from hosts_groups); -drop table hosts_groups; -alter table hosts_groups_tmp rename hosts_groups; - - --- Add itemappid to table items_applications -CREATE TABLE items_applications_tmp ( - itemappid int(4) NOT NULL auto_increment, - applicationid int(4) DEFAULT '0' NOT NULL, - itemid int(4) DEFAULT '0' NOT NULL, - PRIMARY KEY (itemappid), - KEY (applicationid,itemid) -) type=InnoDB; - -insert into items_applications_tmp (select null,applicationid,itemid from items_applications); -drop table items_applications; -alter table items_applications_tmp rename items_applications; - --- Add triggerdepid to table trigger_depends - -CREATE TABLE trigger_depends_tmp ( - triggerdepid int(4) NOT NULL auto_increment, - triggerid_down int(4) DEFAULT '0' NOT NULL, - triggerid_up int(4) DEFAULT '0' NOT NULL, - PRIMARY KEY (triggerdepid), - KEY (triggerid_down, triggerid_up), - KEY (triggerid_up) -) type=InnoDB; - -insert into trigger_depends_tmp (select null,triggerid_down,triggerid_up from trigger_depends); -drop table trigger_depends; -alter table trigger_depends_tmp rename trigger_depends; - --- Fixed indexes of users -CREATE TABLE users_tmp ( - userid int(4) NOT NULL auto_increment, - 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 int(4) DEFAULT '900' NOT NULL, - lang varchar(5) DEFAULT 'en_gb' NOT NULL, - refresh int(4) DEFAULT '30' NOT NULL, - PRIMARY KEY (userid), --- UNIQUE (alias) - KEY (alias) -) type=InnoDB; - -insert into users_tmp (select * from users); -drop table users; -alter table users_tmp rename users; - --- Add id to table users_groups - -CREATE TABLE users_groups_tmp ( - id int(4) NOT NULL auto_increment, - usrgrpid int(4) DEFAULT '0' NOT NULL, - userid int(4) DEFAULT '0' NOT NULL, - PRIMARY KEY (id), - KEY (usrgrpid,userid) -) type=InnoDB; - -insert into users_groups_tmp (select null,usrgrpid,userid from users_groups); -drop table users_groups; -alter table users_groups_tmp rename users_groups; - --- Ger rid of NULLs -alter table sysmaps_elements modify label_location int(1) DEFAULT '0' NOT NULL; - -alter table graphs add graphtype int(2) DEFAULT '0' NOT NULL; -alter table items add delay_flex varchar(255) DEFAULT '' NOT NULL; - --- --- Table structure for table 'services_times' --- - -CREATE TABLE services_times ( - timeid int(4) NOT NULL auto_increment, - serviceid int(4) DEFAULT '0' NOT NULL, - type int(2) DEFAULT '0' NOT NULL, - ts_from int(4) DEFAULT '0' NOT NULL, - ts_to int(4) DEFAULT '0' NOT NULL, - note varchar(255) DEFAULT '' NOT NULL, - PRIMARY KEY (timeid), - UNIQUE (serviceid,type,ts_from,ts_to) -) type=InnoDB; - |