diff options
Diffstat (limited to 'upgrades/dbpatches/1.3/mysql')
67 files changed, 0 insertions, 1005 deletions
diff --git a/upgrades/dbpatches/1.3/mysql/patch/acknowledges.sql b/upgrades/dbpatches/1.3/mysql/patch/acknowledges.sql deleted file mode 100644 index 4d9a9b20..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/acknowledges.sql +++ /dev/null @@ -1,15 +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) -) ENGINE=InnoDB ; -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; diff --git a/upgrades/dbpatches/1.3/mysql/patch/actions.sql b/upgrades/dbpatches/1.3/mysql/patch/actions.sql deleted file mode 100644 index 24ab0bf2..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/actions.sql +++ /dev/null @@ -1,30 +0,0 @@ -CREATE TABLE actions_tmp ( - actionid bigint unsigned DEFAULT '0' NOT NULL, - name varchar(255) DEFAULT '' NOT NULL, - eventsource integer DEFAULT '0' NOT NULL, - evaltype integer DEFAULT '0' NOT NULL, - status integer DEFAULT '0' NOT NULL, - PRIMARY KEY (actionid) -) ENGINE=InnoDB; - -CREATE TABLE operations ( - operationid bigint unsigned DEFAULT '0' NOT NULL, - actionid bigint unsigned DEFAULT '0' NOT NULL, - operationtype integer DEFAULT '0' NOT NULL, - object integer DEFAULT '0' NOT NULL, - objectid bigint unsigned DEFAULT '0' NOT NULL, - shortdata varchar(255) DEFAULT '' NOT NULL, - longdata blob DEFAULT '' NOT NULL, - scripts_tmp blob DEFAULT '' NOT NULL, - PRIMARY KEY (operationid) -) ENGINE=InnoDB; -CREATE INDEX operations_1 on operations (actionid); - -insert into actions_tmp select actionid,actionid,source,0,status from actions; - -insert into operations select actionid,actionid,actiontype,recipient,userid,subject,message,scripts from actions; -update operations set longdata=scripts_tmp where operationtype=1; -alter table operations drop scripts_tmp; - -drop table actions; -alter table actions_tmp rename actions; diff --git a/upgrades/dbpatches/1.3/mysql/patch/alerts.sql b/upgrades/dbpatches/1.3/mysql/patch/alerts.sql deleted file mode 100644 index 79ed2860..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/alerts.sql +++ /dev/null @@ -1,26 +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, - nextcheck integer DEFAULT '0' NOT NULL, - PRIMARY KEY (alertid) -) ENGINE=InnoDB ; -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 alertid,actionid,triggerid,userid,clock,mediatypeid,sendto,subject,message,status,retries,error,nextcheck from alerts; -drop table alerts; -alter table alerts_tmp rename alerts; diff --git a/upgrades/dbpatches/1.3/mysql/patch/applications.sql b/upgrades/dbpatches/1.3/mysql/patch/applications.sql deleted file mode 100644 index 97ff0845..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/applications.sql +++ /dev/null @@ -1,14 +0,0 @@ -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) -) ENGINE=InnoDB; - -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; diff --git a/upgrades/dbpatches/1.3/mysql/patch/auditlog.sql b/upgrades/dbpatches/1.3/mysql/patch/auditlog.sql deleted file mode 100644 index 6db8afbf..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/auditlog.sql +++ /dev/null @@ -1,15 +0,0 @@ -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) -) ENGINE=InnoDB; -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; diff --git a/upgrades/dbpatches/1.3/mysql/patch/autoreg.sql b/upgrades/dbpatches/1.3/mysql/patch/autoreg.sql deleted file mode 100644 index 9a9861d2..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/autoreg.sql +++ /dev/null @@ -1,11 +0,0 @@ -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) -) ENGINE=InnoDB; - -insert into autoreg_tmp select * from autoreg; -drop table autoreg; -alter table autoreg_tmp rename autoreg; diff --git a/upgrades/dbpatches/1.3/mysql/patch/conditions.sql b/upgrades/dbpatches/1.3/mysql/patch/conditions.sql deleted file mode 100644 index ddf10df4..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/conditions.sql +++ /dev/null @@ -1,13 +0,0 @@ -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) -) ENGINE=InnoDB; -CREATE INDEX conditions_1 on conditions_tmp (actionid); - -insert into conditions_tmp select * from conditions; -drop table conditions; -alter table conditions_tmp rename conditions; diff --git a/upgrades/dbpatches/1.3/mysql/patch/config.sql b/upgrades/dbpatches/1.3/mysql/patch/config.sql deleted file mode 100644 index 6f88f069..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/config.sql +++ /dev/null @@ -1,13 +0,0 @@ -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, - alert_usrgrpid bigint unsigned DEFAULT '0' NOT NULL, - PRIMARY KEY (configid) -) ENGINE=InnoDB; - -insert into config_tmp select 1,alert_history,alarm_history,refresh_unsupported,work_period,0 from config; -drop table config; -alter table config_tmp rename config; diff --git a/upgrades/dbpatches/1.3/mysql/patch/dchecks.sql b/upgrades/dbpatches/1.3/mysql/patch/dchecks.sql deleted file mode 100644 index cb00b398..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/dchecks.sql +++ /dev/null @@ -1,7 +0,0 @@ -CREATE TABLE dchecks ( - dcheckid bigint unsigned DEFAULT '0' NOT NULL, - druleid bigint unsigned DEFAULT '0' NOT NULL, - type integer DEFAULT '0' NOT NULL, - ports varchar(255) DEFAULT '0' NOT NULL, - PRIMARY KEY (dcheckid) -) type=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/patch/dhosts.sql b/upgrades/dbpatches/1.3/mysql/patch/dhosts.sql deleted file mode 100644 index d15489c8..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/dhosts.sql +++ /dev/null @@ -1,10 +0,0 @@ -CREATE TABLE dhosts ( - dhostid bigint unsigned DEFAULT '0' NOT NULL, - druleid bigint unsigned DEFAULT '0' NOT NULL, - ip varchar(15) DEFAULT '' NOT NULL, - status integer DEFAULT '0' NOT NULL, - lastup integer DEFAULT '0' NOT NULL, - lastdown integer DEFAULT '0' NOT NULL, - eventsent integer DEFAULT '0' NOT NULL, - PRIMARY KEY (dhostid) -) type=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/patch/drules.sql b/upgrades/dbpatches/1.3/mysql/patch/drules.sql deleted file mode 100644 index f2ffd70f..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/drules.sql +++ /dev/null @@ -1,14 +0,0 @@ -CREATE TABLE drules ( - druleid bigint unsigned DEFAULT '0' NOT NULL, - name varchar(255) DEFAULT '' NOT NULL, - ipfirst varchar(15) DEFAULT '' NOT NULL, - iplast varchar(15) DEFAULT '' NOT NULL, - delay integer DEFAULT '0' NOT NULL, - nextcheck integer DEFAULT '0' NOT NULL, - status integer DEFAULT '0' NOT NULL, - upevent integer DEFAULT '0' NOT NULL, - downevent integer DEFAULT '0' NOT NULL, - svcupevent integer DEFAULT '0' NOT NULL, - svcdownevent integer DEFAULT '0' NOT NULL, - PRIMARY KEY (druleid) -) type=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/patch/dservices.sql b/upgrades/dbpatches/1.3/mysql/patch/dservices.sql deleted file mode 100644 index 9c8fc2b2..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/dservices.sql +++ /dev/null @@ -1,11 +0,0 @@ -CREATE TABLE dservices ( - dserviceid bigint unsigned DEFAULT '0' NOT NULL, - dhostid bigint unsigned DEFAULT '0' NOT NULL, - type integer DEFAULT '0' NOT NULL, - port integer DEFAULT '0' NOT NULL, - status integer DEFAULT '0' NOT NULL, - lastup integer DEFAULT '0' NOT NULL, - lastdown integer DEFAULT '0' NOT NULL, - eventsent integer DEFAULT '0' NOT NULL, - PRIMARY KEY (dserviceid) -) type=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/patch/events.sql b/upgrades/dbpatches/1.3/mysql/patch/events.sql deleted file mode 100644 index 14bc669f..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/events.sql +++ /dev/null @@ -1,15 +0,0 @@ -CREATE TABLE events ( - eventid bigint unsigned DEFAULT '0' NOT NULL, - source integer DEFAULT '0' NOT NULL, - object integer DEFAULT '0' NOT NULL, - objectid 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) -) ENGINE=InnoDB; -CREATE INDEX events_1 on events (object,objectid,clock); -CREATE INDEX events_2 on events (clock); - -insert into events select alarmid,0,0,triggerid,clock,value,acknowledged from alarms; -drop table alarms; diff --git a/upgrades/dbpatches/1.3/mysql/patch/functions.sql b/upgrades/dbpatches/1.3/mysql/patch/functions.sql deleted file mode 100644 index e03de6e8..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/functions.sql +++ /dev/null @@ -1,15 +0,0 @@ -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) -) ENGINE=InnoDB; -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; diff --git a/upgrades/dbpatches/1.3/mysql/patch/graphs.sql b/upgrades/dbpatches/1.3/mysql/patch/graphs.sql deleted file mode 100644 index 03bb2fb0..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/graphs.sql +++ /dev/null @@ -1,19 +0,0 @@ -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) -) ENGINE=InnoDB; -CREATE INDEX graphs_graphs_1 on graphs_tmp (name); - -insert into graphs_tmp select *,0 from graphs; -drop table graphs; -alter table graphs_tmp rename graphs; diff --git a/upgrades/dbpatches/1.3/mysql/patch/graphs_items.sql b/upgrades/dbpatches/1.3/mysql/patch/graphs_items.sql deleted file mode 100644 index e5184b6b..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/graphs_items.sql +++ /dev/null @@ -1,17 +0,0 @@ -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) -) ENGINE=InnoDB; - -insert into graphs_items_tmp select * from graphs_items; -drop table graphs_items; -alter table graphs_items_tmp rename graphs_items; diff --git a/upgrades/dbpatches/1.3/mysql/patch/groups.sql b/upgrades/dbpatches/1.3/mysql/patch/groups.sql deleted file mode 100644 index 87ad39b2..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/groups.sql +++ /dev/null @@ -1,10 +0,0 @@ -CREATE TABLE groups_tmp ( - groupid bigint unsigned DEFAULT '0' NOT NULL, - name varchar(64) DEFAULT '' NOT NULL, - PRIMARY KEY (groupid) -) ENGINE=InnoDB; -CREATE INDEX groups_1 on groups_tmp (name); - -insert into groups_tmp select * from groups; -drop table groups; -alter table groups_tmp rename groups; diff --git a/upgrades/dbpatches/1.3/mysql/patch/help_items.sql b/upgrades/dbpatches/1.3/mysql/patch/help_items.sql deleted file mode 100644 index ca347713..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/help_items.sql +++ /dev/null @@ -1,10 +0,0 @@ -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_) -) ENGINE=InnoDB; - -insert into help_items_tmp select * from help_items; -drop table help_items; -alter table help_items_tmp rename help_items; diff --git a/upgrades/dbpatches/1.3/mysql/patch/history.sql b/upgrades/dbpatches/1.3/mysql/patch/history.sql deleted file mode 100644 index c08bae1c..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/history.sql +++ /dev/null @@ -1,10 +0,0 @@ -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 -) ENGINE=InnoDB; -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; diff --git a/upgrades/dbpatches/1.3/mysql/patch/history_log.sql b/upgrades/dbpatches/1.3/mysql/patch/history_log.sql deleted file mode 100644 index 683d0aa9..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/history_log.sql +++ /dev/null @@ -1,15 +0,0 @@ -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) -) ENGINE=InnoDB; -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; diff --git a/upgrades/dbpatches/1.3/mysql/patch/history_str.sql b/upgrades/dbpatches/1.3/mysql/patch/history_str.sql deleted file mode 100644 index add46772..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/history_str.sql +++ /dev/null @@ -1,10 +0,0 @@ -CREATE TABLE history_str_tmp ( - itemid bigint unsigned DEFAULT '0' NOT NULL, - clock integer DEFAULT '0' NOT NULL, - value varchar(255) DEFAULT '' NOT NULL -) ENGINE=InnoDB; -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; diff --git a/upgrades/dbpatches/1.3/mysql/patch/history_str_sync.sql b/upgrades/dbpatches/1.3/mysql/patch/history_str_sync.sql deleted file mode 100644 index 22e1b4f2..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/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) -) ENGINE=InnoDB; -CREATE INDEX history_str_sync_1 on history_str_sync (nodeid,id); diff --git a/upgrades/dbpatches/1.3/mysql/patch/history_sync.sql b/upgrades/dbpatches/1.3/mysql/patch/history_sync.sql deleted file mode 100644 index 17fd64f4..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/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) -) ENGINE=InnoDB; -CREATE INDEX history_sync_1 on history_sync (nodeid,id); diff --git a/upgrades/dbpatches/1.3/mysql/patch/history_text.sql b/upgrades/dbpatches/1.3/mysql/patch/history_text.sql deleted file mode 100644 index f67efcae..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/history_text.sql +++ /dev/null @@ -1,12 +0,0 @@ -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) -) ENGINE=InnoDB; -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; diff --git a/upgrades/dbpatches/1.3/mysql/patch/history_uint.sql b/upgrades/dbpatches/1.3/mysql/patch/history_uint.sql deleted file mode 100644 index 1b451a73..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/history_uint.sql +++ /dev/null @@ -1,10 +0,0 @@ -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 -) ENGINE=InnoDB; -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; diff --git a/upgrades/dbpatches/1.3/mysql/patch/history_uint_sync.sql b/upgrades/dbpatches/1.3/mysql/patch/history_uint_sync.sql deleted file mode 100644 index 3f875b42..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/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) -) ENGINE=InnoDB; -CREATE INDEX history_uint_sync_1 on history_uint_sync (nodeid,id); diff --git a/upgrades/dbpatches/1.3/mysql/patch/hosts.sql b/upgrades/dbpatches/1.3/mysql/patch/hosts.sql deleted file mode 100644 index 82bc0b33..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/hosts.sql +++ /dev/null @@ -1,20 +0,0 @@ -CREATE TABLE hosts_tmp ( - hostid bigint unsigned DEFAULT '0' NOT NULL, - host varchar(64) DEFAULT '' NOT NULL, - dns 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) -) ENGINE=InnoDB; -CREATE INDEX hosts_1 on hosts_tmp (host); -CREATE INDEX hosts_2 on hosts_tmp (status); - -insert into hosts_tmp select hostid,host,host,useip,ip,port,status,disable_until,error,available,errors_from from hosts; -drop table hosts; -alter table hosts_tmp rename hosts; diff --git a/upgrades/dbpatches/1.3/mysql/patch/hosts_groups.sql b/upgrades/dbpatches/1.3/mysql/patch/hosts_groups.sql deleted file mode 100644 index 457d6ffb..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/hosts_groups.sql +++ /dev/null @@ -1,24 +0,0 @@ -CREATE TABLE hosts_groups_tmp ( - hostgroupid bigint unsigned NOT NULL auto_increment, - hostid bigint unsigned DEFAULT '0' NOT NULL, - groupid bigint unsigned DEFAULT '0' NOT NULL, - PRIMARY KEY (hostgroupid) -) ENGINE=InnoDB; -CREATE INDEX hosts_groups_groups_1 on hosts_groups_tmp (hostid,groupid); - -insert into hosts_groups_tmp select NULL,hostid,groupid from hosts_groups; -drop table hosts_groups; -alter table hosts_groups_tmp rename hosts_groups; - - -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) -) ENGINE=InnoDB; -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; diff --git a/upgrades/dbpatches/1.3/mysql/patch/hosts_profiles.sql b/upgrades/dbpatches/1.3/mysql/patch/hosts_profiles.sql deleted file mode 100644 index 8213add8..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/hosts_profiles.sql +++ /dev/null @@ -1,19 +0,0 @@ -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) -) ENGINE=InnoDB; - -insert into hosts_profiles_tmp select * from hosts_profiles; -drop table hosts_profiles; -alter table hosts_profiles_tmp rename hosts_profiles; diff --git a/upgrades/dbpatches/1.3/mysql/patch/hosts_templates.sql b/upgrades/dbpatches/1.3/mysql/patch/hosts_templates.sql deleted file mode 100644 index 98dc2df0..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/hosts_templates.sql +++ /dev/null @@ -1,23 +0,0 @@ -CREATE TABLE hosts_templates_tmp ( - hosttemplateid bigint unsigned NOT NULL auto_increment, - hostid bigint unsigned DEFAULT '0' NOT NULL, - templateid bigint unsigned DEFAULT '0' NOT NULL, - PRIMARY KEY (hosttemplateid) -) ENGINE=InnoDB; -CREATE UNIQUE INDEX hosts_templates_1 on hosts_templates_tmp (hostid,templateid); - -insert into hosts_templates_tmp select NULL,hostid,templateid from hosts_templates; -drop table hosts_templates; -alter table hosts_templates_tmp rename hosts_templates; - -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) -) ENGINE=InnoDB; -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; diff --git a/upgrades/dbpatches/1.3/mysql/patch/housekeeper.sql b/upgrades/dbpatches/1.3/mysql/patch/housekeeper.sql deleted file mode 100644 index 15c88634..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/housekeeper.sql +++ /dev/null @@ -1,11 +0,0 @@ -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) -) ENGINE=InnoDB; - -insert into housekeeper_tmp select * from housekeeper; -drop table housekeeper; -alter table housekeeper_tmp rename housekeeper; diff --git a/upgrades/dbpatches/1.3/mysql/patch/httpstep.sql b/upgrades/dbpatches/1.3/mysql/patch/httpstep.sql deleted file mode 100644 index b0cfd6ba..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/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) -) ENGINE=InnoDB; -CREATE INDEX httpstep_httpstep_1 on httpstep (httptestid); diff --git a/upgrades/dbpatches/1.3/mysql/patch/httpstepitem.sql b/upgrades/dbpatches/1.3/mysql/patch/httpstepitem.sql deleted file mode 100644 index 56b43ff4..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/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) -) ENGINE=InnoDB; -CREATE UNIQUE INDEX httpstepitem_httpstepitem_1 on httpstepitem (httpstepid,itemid); diff --git a/upgrades/dbpatches/1.3/mysql/patch/httptest.sql b/upgrades/dbpatches/1.3/mysql/patch/httptest.sql deleted file mode 100644 index 9c0cacb5..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/httptest.sql +++ /dev/null @@ -1,18 +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, - error varchar(255) DEFAULT '' NOT NULL, - PRIMARY KEY (httptestid) -) ENGINE=InnoDB; -CREATE INDEX httptest_httptest_1 on httptest (httptestid); diff --git a/upgrades/dbpatches/1.3/mysql/patch/httptestitem.sql b/upgrades/dbpatches/1.3/mysql/patch/httptestitem.sql deleted file mode 100644 index 7efcc231..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/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) -) ENGINE=InnoDB; -CREATE UNIQUE INDEX httptestitem_httptestitem_1 on httptestitem (httptestid,itemid); diff --git a/upgrades/dbpatches/1.3/mysql/patch/ids.sql b/upgrades/dbpatches/1.3/mysql/patch/ids.sql deleted file mode 100644 index 9080273f..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/ids.sql +++ /dev/null @@ -1,7 +0,0 @@ -CREATE TABLE ids ( - nodeid integer DEFAULT '0' NOT NULL, - table_name varchar(64) DEFAULT '' NOT NULL, - field_name varchar(64) DEFAULT '' NOT NULL, - nextid bigint unsigned DEFAULT '0' NOT NULL, - PRIMARY KEY (nodeid,table_name,field_name) -) type=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/patch/images.sql b/upgrades/dbpatches/1.3/mysql/patch/images.sql deleted file mode 100644 index d8867e1c..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/images.sql +++ /dev/null @@ -1,12 +0,0 @@ -CREATE TABLE images_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) -) ENGINE=InnoDB; -CREATE INDEX images_1 on images_tmp (imagetype,name); - -insert into images_tmp select * from images; -drop table images; -alter table images_tmp rename images; diff --git a/upgrades/dbpatches/1.3/mysql/patch/items.sql b/upgrades/dbpatches/1.3/mysql/patch/items.sql deleted file mode 100644 index 2093e4a2..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/items.sql +++ /dev/null @@ -1,43 +0,0 @@ -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) -) ENGINE=InnoDB; -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 items_tmp rename items; diff --git a/upgrades/dbpatches/1.3/mysql/patch/items_applications.sql b/upgrades/dbpatches/1.3/mysql/patch/items_applications.sql deleted file mode 100644 index 92178eb7..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/items_applications.sql +++ /dev/null @@ -1,23 +0,0 @@ -CREATE TABLE items_applications_tmp ( - itemappid bigint unsigned NOT NULL auto_increment, - applicationid bigint unsigned DEFAULT '0' NOT NULL, - itemid bigint unsigned DEFAULT '0' NOT NULL, - PRIMARY KEY (itemappid) -) ENGINE=InnoDB; -CREATE INDEX items_applications_1 on items_applications_tmp (applicationid,itemid); - -insert into items_applications_tmp select NULL,applicationid,applicationid from items_applications; -drop table items_applications; -alter table items_applications_tmp rename items_applications; - -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) -) ENGINE=InnoDB; -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; diff --git a/upgrades/dbpatches/1.3/mysql/patch/mappings.sql b/upgrades/dbpatches/1.3/mysql/patch/mappings.sql deleted file mode 100644 index afeb59ac..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/mappings.sql +++ /dev/null @@ -1,12 +0,0 @@ -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) -) ENGINE=InnoDB; -CREATE INDEX mappings_1 on mappings_tmp (valuemapid); - -insert into mappings_tmp select * from mappings; -drop table mappings; -alter table mappings_tmp rename mappings; diff --git a/upgrades/dbpatches/1.3/mysql/patch/media.sql b/upgrades/dbpatches/1.3/mysql/patch/media.sql deleted file mode 100644 index 00540275..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/media.sql +++ /dev/null @@ -1,16 +0,0 @@ -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) -) ENGINE=InnoDB; -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; -alter table media_tmp rename media; diff --git a/upgrades/dbpatches/1.3/mysql/patch/media_type.sql b/upgrades/dbpatches/1.3/mysql/patch/media_type.sql deleted file mode 100644 index 09b55dec..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/media_type.sql +++ /dev/null @@ -1,17 +0,0 @@ -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, - username varchar(255) DEFAULT '' NOT NULL, - passwd varchar(255) DEFAULT '' NOT NULL, - PRIMARY KEY (mediatypeid) -) ENGINE=InnoDB; - -insert into media_type_tmp select mediatypeid,type,description,smtp_server,smtp_helo,smtp_email,exec_path,gsm_modem,'','' from media_type; -drop table media_type; -alter table media_type_tmp rename media_type; diff --git a/upgrades/dbpatches/1.3/mysql/patch/node_cksum.sql b/upgrades/dbpatches/1.3/mysql/patch/node_cksum.sql deleted file mode 100644 index 6e8752a7..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/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) -) ENGINE=InnoDB; -CREATE INDEX node_cksum_cksum_1 on node_cksum (nodeid,tablename,fieldname,recordid,cksumtype); diff --git a/upgrades/dbpatches/1.3/mysql/patch/node_configlog.sql b/upgrades/dbpatches/1.3/mysql/patch/node_configlog.sql deleted file mode 100644 index 121d5737..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/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) -) ENGINE=InnoDB; -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/patch/nodes.sql b/upgrades/dbpatches/1.3/mysql/patch/nodes.sql deleted file mode 100644 index 40be6161..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/nodes.sql +++ /dev/null @@ -1,16 +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, - 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) -) ENGINE=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/patch/operations.sql b/upgrades/dbpatches/1.3/mysql/patch/operations.sql deleted file mode 100644 index 85631027..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/operations.sql +++ /dev/null @@ -1 +0,0 @@ --- See actions.sql diff --git a/upgrades/dbpatches/1.3/mysql/patch/profiles.sql b/upgrades/dbpatches/1.3/mysql/patch/profiles.sql deleted file mode 100644 index ba8e374d..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/profiles.sql +++ /dev/null @@ -1,27 +0,0 @@ -CREATE TABLE profiles_tmp ( - profileid bigint unsigned NOT NULL auto_increment, - 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) -) ENGINE=InnoDB; -CREATE UNIQUE INDEX profiles_1 on profiles_tmp (userid,idx); - -insert into profiles_tmp select NULL,userid,idx,value,valuetype from profiles; -drop table profiles; -alter table profiles_tmp rename profiles; - -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) -) ENGINE=InnoDB; -CREATE UNIQUE INDEX profiles_1 on profiles_tmp (userid,idx); - -insert into profiles_tmp select * from profiles; -drop table profiles; -alter table profiles_tmp rename profiles; diff --git a/upgrades/dbpatches/1.3/mysql/patch/rights.sql b/upgrades/dbpatches/1.3/mysql/patch/rights.sql deleted file mode 100644 index 6d737ea9..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/rights.sql +++ /dev/null @@ -1,13 +0,0 @@ -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) -) ENGINE=InnoDB; -CREATE INDEX rights_1 on rights_tmp (groupid); - ---insert into rights_tmp select * from rights; -drop table rights; -alter table rights_tmp rename rights; diff --git a/upgrades/dbpatches/1.3/mysql/patch/screens.sql b/upgrades/dbpatches/1.3/mysql/patch/screens.sql deleted file mode 100644 index 6c55a4be..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/screens.sql +++ /dev/null @@ -1,11 +0,0 @@ -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) -) ENGINE=InnoDB; - -insert into screens_tmp select * from screens; -drop table screens; -alter table screens_tmp rename screens; diff --git a/upgrades/dbpatches/1.3/mysql/patch/screens_items.sql b/upgrades/dbpatches/1.3/mysql/patch/screens_items.sql deleted file mode 100644 index 2dabadae..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/screens_items.sql +++ /dev/null @@ -1,45 +0,0 @@ -CREATE TABLE screens_items_tmp ( - screenitemid bigint unsigned NOT NULL auto_increment, - 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) -) ENGINE=InnoDB; - -insert into screens_items_tmp select NULL,screenid,resourcetype,resourceid,width,height,x,y,colspan,rowspan,elements,valign,halign,style,url from screens_items; -drop table screens_items; -alter table screens_items_tmp rename screens_items; - -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) -) ENGINE=InnoDB; - -insert into screens_items_tmp select * from screens_items; -drop table screens_items; -alter table screens_items_tmp rename screens_items; diff --git a/upgrades/dbpatches/1.3/mysql/patch/service_alarms.sql b/upgrades/dbpatches/1.3/mysql/patch/service_alarms.sql deleted file mode 100644 index 61b02bc9..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/service_alarms.sql +++ /dev/null @@ -1,13 +0,0 @@ -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) -) ENGINE=InnoDB; -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; diff --git a/upgrades/dbpatches/1.3/mysql/patch/services.sql b/upgrades/dbpatches/1.3/mysql/patch/services.sql deleted file mode 100644 index d6578969..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/services.sql +++ /dev/null @@ -1,15 +0,0 @@ -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) -) ENGINE=InnoDB; - -insert into services_tmp select * from services; -drop table services; -alter table services_tmp rename services; diff --git a/upgrades/dbpatches/1.3/mysql/patch/services_links.sql b/upgrades/dbpatches/1.3/mysql/patch/services_links.sql deleted file mode 100644 index 0eadfb2a..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/services_links.sql +++ /dev/null @@ -1,13 +0,0 @@ -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) -) ENGINE=InnoDB; -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; diff --git a/upgrades/dbpatches/1.3/mysql/patch/services_times.sql b/upgrades/dbpatches/1.3/mysql/patch/services_times.sql deleted file mode 100644 index 1e8190a2..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/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) -) ENGINE=InnoDB; -CREATE INDEX services_times_times_1 on services_times (serviceid,type,ts_from,ts_to); diff --git a/upgrades/dbpatches/1.3/mysql/patch/sessions.sql b/upgrades/dbpatches/1.3/mysql/patch/sessions.sql deleted file mode 100644 index 55d4a669..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/sessions.sql +++ /dev/null @@ -1,10 +0,0 @@ -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) -) ENGINE=InnoDB; - -insert into sessions_tmp select * from sessions; -drop table sessions; -alter table sessions_tmp rename sessions; diff --git a/upgrades/dbpatches/1.3/mysql/patch/slides.sql b/upgrades/dbpatches/1.3/mysql/patch/slides.sql deleted file mode 100644 index ec0e84e7..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/slides.sql +++ /dev/null @@ -1,9 +0,0 @@ -CREATE TABLE slides ( - slideid bigint unsigned DEFAULT '0' NOT NULL, - slideshowid bigint unsigned DEFAULT '0' NOT NULL, - step integer DEFAULT '0' NOT NULL, - delay integer DEFAULT '0' NOT NULL, - PRIMARY KEY (slideid) -) ENGINE=InnoDB; -CREATE INDEX slides_slides_1 on slides (slideshowid); - diff --git a/upgrades/dbpatches/1.3/mysql/patch/slideshows.sql b/upgrades/dbpatches/1.3/mysql/patch/slideshows.sql deleted file mode 100644 index 6d66a442..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/slideshows.sql +++ /dev/null @@ -1,6 +0,0 @@ -CREATE TABLE slideshows ( - slideshowid bigint unsigned DEFAULT '0' NOT NULL, - name varchar(255) DEFAULT '' NOT NULL, - delay integer DEFAULT '0' NOT NULL, - PRIMARY KEY (slideshowid) -) ENGINE=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/patch/sysmaps.sql b/upgrades/dbpatches/1.3/mysql/patch/sysmaps.sql deleted file mode 100644 index e673e3af..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/sysmaps.sql +++ /dev/null @@ -1,15 +0,0 @@ -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) -) ENGINE=InnoDB; -CREATE INDEX sysmaps_1 on sysmaps_tmp (name); - -insert into sysmaps_tmp select s.sysmapid,s.name,s.width,s.height,i.imageid,s.label_type,s.label_location from sysmaps s,images i where s.background=i.name; -drop table sysmaps; -alter table sysmaps_tmp rename sysmaps; diff --git a/upgrades/dbpatches/1.3/mysql/patch/sysmaps_elements.sql b/upgrades/dbpatches/1.3/mysql/patch/sysmaps_elements.sql deleted file mode 100644 index d2ca2594..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/sysmaps_elements.sql +++ /dev/null @@ -1,19 +0,0 @@ -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, - iconid_unknown 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) -) ENGINE=InnoDB; - -insert into sysmaps_elements_tmp select s.selementid,s.sysmapid,s.elementid,s.elementtype,i1.imageid,i2.imageid,i1.imageid,s.label,s.label_location,s.x,s.y,s.url from sysmaps_elements s,images i1,images i2 where s.icon=i1.name and s.icon_on=i2.name; -drop table sysmaps_elements; -alter table sysmaps_elements_tmp rename sysmaps_elements; diff --git a/upgrades/dbpatches/1.3/mysql/patch/sysmaps_links.sql b/upgrades/dbpatches/1.3/mysql/patch/sysmaps_links.sql deleted file mode 100644 index f0e4ffef..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/sysmaps_links.sql +++ /dev/null @@ -1,16 +0,0 @@ -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) -) ENGINE=InnoDB; - -insert into sysmaps_links_tmp select * from sysmaps_links; -drop table sysmaps_links; -alter table sysmaps_links_tmp rename sysmaps_links; diff --git a/upgrades/dbpatches/1.3/mysql/patch/trends.sql b/upgrades/dbpatches/1.3/mysql/patch/trends.sql deleted file mode 100644 index 8694167a..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/trends.sql +++ /dev/null @@ -1,13 +0,0 @@ -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) -) ENGINE=InnoDB; - -insert into trends_tmp select * from trends; -drop table trends; -alter table trends_tmp rename trends; diff --git a/upgrades/dbpatches/1.3/mysql/patch/trigger_depends.sql b/upgrades/dbpatches/1.3/mysql/patch/trigger_depends.sql deleted file mode 100644 index 193de545..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/trigger_depends.sql +++ /dev/null @@ -1,25 +0,0 @@ -CREATE TABLE trigger_depends_tmp ( - triggerdepid bigint unsigned NOT NULL auto_increment, - triggerid_down bigint unsigned DEFAULT '0' NOT NULL, - triggerid_up bigint unsigned DEFAULT '0' NOT NULL, - PRIMARY KEY (triggerdepid) -) ENGINE=InnoDB; -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 NULL,triggerid_down,triggerid_up from trigger_depends; -drop table trigger_depends; -alter table trigger_depends_tmp rename trigger_depends; - -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) -) ENGINE=InnoDB; -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; diff --git a/upgrades/dbpatches/1.3/mysql/patch/triggers.sql b/upgrades/dbpatches/1.3/mysql/patch/triggers.sql deleted file mode 100644 index 1d03e406..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/triggers.sql +++ /dev/null @@ -1,21 +0,0 @@ -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) -) ENGINE=InnoDB; -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; -alter table triggers_tmp rename triggers; diff --git a/upgrades/dbpatches/1.3/mysql/patch/users.sql b/upgrades/dbpatches/1.3/mysql/patch/users.sql deleted file mode 100644 index c2a31e17..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/users.sql +++ /dev/null @@ -1,19 +0,0 @@ -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) -) ENGINE=InnoDB; -CREATE INDEX users_1 on users_tmp (alias); - -insert into users_tmp select userid,alias,name,surname,passwd,url,autologout,lang,refresh,1 from users; -update users_tmp set type=3 where name='Admin'; -drop table users; -alter table users_tmp rename users; diff --git a/upgrades/dbpatches/1.3/mysql/patch/users_groups.sql b/upgrades/dbpatches/1.3/mysql/patch/users_groups.sql deleted file mode 100644 index 1b45595b..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/users_groups.sql +++ /dev/null @@ -1,23 +0,0 @@ -CREATE TABLE users_groups_tmp ( - id bigint unsigned NOT NULL auto_increment, - usrgrpid bigint unsigned DEFAULT '0' NOT NULL, - userid bigint unsigned DEFAULT '0' NOT NULL, - PRIMARY KEY (id) -) ENGINE=InnoDB; -CREATE INDEX users_groups_1 on users_groups_tmp (usrgrpid,userid); - -insert into users_groups_tmp select NULL,usrgrpid,userid from users_groups; -drop table users_groups; -alter table users_groups_tmp rename users_groups; - -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) -) ENGINE=InnoDB; -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; diff --git a/upgrades/dbpatches/1.3/mysql/patch/usrgrp.sql b/upgrades/dbpatches/1.3/mysql/patch/usrgrp.sql deleted file mode 100644 index b9a9b9f6..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/usrgrp.sql +++ /dev/null @@ -1,10 +0,0 @@ -CREATE TABLE usrgrp_tmp ( - usrgrpid bigint unsigned DEFAULT '0' NOT NULL, - name varchar(64) DEFAULT '' NOT NULL, - PRIMARY KEY (usrgrpid) -) ENGINE=InnoDB; -CREATE INDEX usrgrp_1 on usrgrp_tmp (name); - -insert into usrgrp_tmp select * from usrgrp; -drop table usrgrp; -alter table usrgrp_tmp rename usrgrp; diff --git a/upgrades/dbpatches/1.3/mysql/patch/valuemaps.sql b/upgrades/dbpatches/1.3/mysql/patch/valuemaps.sql deleted file mode 100644 index 9febba47..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/valuemaps.sql +++ /dev/null @@ -1,10 +0,0 @@ -CREATE TABLE valuemaps_tmp ( - valuemapid bigint unsigned DEFAULT '0' NOT NULL, - name varchar(64) DEFAULT '' NOT NULL, - PRIMARY KEY (valuemapid) -) ENGINE=InnoDB; -CREATE INDEX valuemaps_1 on valuemaps_tmp (name); - -insert into valuemaps_tmp select * from valuemaps; -drop table valuemaps; -alter table valuemaps_tmp rename valuemaps; |