[icinga-checkins] icinga.org: icinga2/master: Fix missing MySQL session_token changes

git at icinga.org git at icinga.org
Tue Aug 2 15:05:50 CEST 2016


Module: icinga2
Branch: master
Commit: 1ff6939f909afcd7089da73de4d169ddf4148e1c
URL:    https://git.icinga.org/?p=icinga2.git;a=commit;h=1ff6939f909afcd7089da73de4d169ddf4148e1c

Author: Michael Friedrich <michael.friedrich at netways.de>
Date:   Tue Aug  2 15:05:21 2016 +0200

Fix missing MySQL session_token changes

refs #12258
refs #12288

---

 lib/db_ido_mysql/schema/mysql.sql |    2 ++
 1 file changed, 2 insertions(+)

diff --git a/lib/db_ido_mysql/schema/mysql.sql b/lib/db_ido_mysql/schema/mysql.sql
index b9142c7..28927d7 100644
--- a/lib/db_ido_mysql/schema/mysql.sql
+++ b/lib/db_ido_mysql/schema/mysql.sql
@@ -979,6 +979,7 @@ CREATE TABLE IF NOT EXISTS icinga_scheduleddowntime (
   is_in_effect smallint default 0,
   trigger_time timestamp  default '0000-00-00 00:00:00',
   name TEXT character set latin1 default NULL,
+  session_token int default NULL,
   PRIMARY KEY  (scheduleddowntime_id),
   UNIQUE KEY instance_id (instance_id,object_id,entry_time,internal_downtime_id)
 ) ENGINE=InnoDB COMMENT='Current scheduled host and service downtime';
@@ -1671,6 +1672,7 @@ CREATE INDEX idx_cv_session_del ON icinga_customvariables (instance_id, session_
 CREATE INDEX idx_cvs_session_del ON icinga_customvariablestatus (instance_id, session_token);
 
 CREATE INDEX idx_comments_session_del ON icinga_comments (instance_id, session_token);
+CREATE INDEX idx_downtimes_session_del ON icinga_scheduleddowntime (instance_id, session_token);
 
 -- #12107
 CREATE INDEX idx_statehistory_cleanup on icinga_statehistory(instance_id, state_time);



More information about the icinga-checkins mailing list