[icinga-checkins] icinga.org: icinga2/feature/incremental-ido-updates-12435: Fix IDO MySQL update sql

git at icinga.org git at icinga.org
Mon Aug 15 11:41:41 CEST 2016


Module: icinga2
Branch: feature/incremental-ido-updates-12435
Commit: d4aeb733c08b6d3424689aba39c07e99f7180685
URL:    https://git.icinga.org/?p=icinga2.git;a=commit;h=d4aeb733c08b6d3424689aba39c07e99f7180685

Author: Michael Friedrich <michael.friedrich at netways.de>
Date:   Mon Aug 15 11:41:22 2016 +0200

Fix IDO MySQL update sql

---

 lib/db_ido_mysql/schema/upgrade/2.5.0.sql |   18 ------------------
 1 file changed, 18 deletions(-)

diff --git a/lib/db_ido_mysql/schema/upgrade/2.5.0.sql b/lib/db_ido_mysql/schema/upgrade/2.5.0.sql
index 1e545cc..2aae0ba 100644
--- a/lib/db_ido_mysql/schema/upgrade/2.5.0.sql
+++ b/lib/db_ido_mysql/schema/upgrade/2.5.0.sql
@@ -61,24 +61,6 @@ CREATE INDEX idx_zonestatus_parent_object_id on icinga_zonestatus(parent_zone_ob
 CREATE INDEX idx_statehistory_cleanup on icinga_statehistory(instance_id, state_time);
 
 -- -----------------------------------------
--- #12210
--- -----------------------------------------
-
-ALTER TABLE icinga_hostgroup_members ADD COLUMN session_token int default NULL;
-ALTER TABLE icinga_servicegroup_members ADD COLUMN session_token int default NULL;
-ALTER TABLE icinga_contactgroup_members ADD COLUMN session_token int default NULL;
-
-CREATE INDEX idx_hg_session_del ON icinga_hostgroup_members (instance_id, session_token);
-CREATE INDEX idx_sg_session_del ON icinga_servicegroup_members (instance_id, session_token);
-CREATE INDEX idx_cg_session_del ON icinga_contactgroup_members (instance_id, session_token);
-
-DROP INDEX cv_session_del_idx ON icinga_customvariables;
-DROP INDEX cvs_session_del_idx ON icinga_customvariablestatus;
-
-CREATE INDEX idx_cv_session_del ON icinga_customvariables (instance_id, session_token);
-CREATE INDEX idx_cvs_session_del ON icinga_customvariablestatus (instance_id, session_token);
-
--- -----------------------------------------
 -- #12258
 -- -----------------------------------------
 ALTER TABLE icinga_comments ADD COLUMN session_token INTEGER default NULL;



More information about the icinga-checkins mailing list