1-- ----------------------------------------- 2-- upgrade path for Icinga 2.6.0 3-- 4-- ----------------------------------------- 5-- Icinga 2 | (c) 2012 Icinga GmbH | GPLv2+ 6-- 7-- Please check https://docs.icinga.com for upgrading information! 8-- ----------------------------------------- 9 10-- ----------------------------------------- 11-- #10502 IDO: Support NO_ZERO_DATE and NO_ZERO_IN_DATE SQL modes 12-- ----------------------------------------- 13 14ALTER TABLE icinga_acknowledgements 15 MODIFY COLUMN entry_time timestamp NULL, 16 MODIFY COLUMN end_time timestamp NULL; 17 18ALTER TABLE icinga_commenthistory 19 MODIFY COLUMN entry_time timestamp NULL, 20 MODIFY COLUMN comment_time timestamp NULL, 21 MODIFY COLUMN expiration_time timestamp NULL, 22 MODIFY COLUMN deletion_time timestamp NULL; 23 24ALTER TABLE icinga_comments 25 MODIFY COLUMN entry_time timestamp NULL, 26 MODIFY COLUMN comment_time timestamp NULL, 27 MODIFY COLUMN expiration_time timestamp NULL; 28 29ALTER TABLE icinga_conninfo 30 MODIFY COLUMN connect_time timestamp NULL, 31 MODIFY COLUMN disconnect_time timestamp NULL, 32 MODIFY COLUMN last_checkin_time timestamp NULL, 33 MODIFY COLUMN data_start_time timestamp NULL, 34 MODIFY COLUMN data_end_time timestamp NULL; 35 36ALTER TABLE icinga_contactnotificationmethods 37 MODIFY COLUMN start_time timestamp NULL, 38 MODIFY COLUMN end_time timestamp NULL; 39 40ALTER TABLE icinga_contactnotifications 41 MODIFY COLUMN start_time timestamp NULL, 42 MODIFY COLUMN end_time timestamp NULL; 43 44ALTER TABLE icinga_contactstatus 45 MODIFY COLUMN status_update_time timestamp NULL, 46 MODIFY COLUMN last_host_notification timestamp NULL, 47 MODIFY COLUMN last_service_notification timestamp NULL; 48 49ALTER TABLE icinga_customvariablestatus 50 MODIFY COLUMN status_update_time timestamp NULL; 51 52ALTER TABLE icinga_dbversion 53 MODIFY COLUMN create_time timestamp NULL, 54 MODIFY COLUMN modify_time timestamp NULL; 55 56ALTER TABLE icinga_downtimehistory 57 MODIFY COLUMN entry_time timestamp NULL, 58 MODIFY COLUMN scheduled_start_time timestamp NULL, 59 MODIFY COLUMN scheduled_end_time timestamp NULL, 60 MODIFY COLUMN actual_start_time timestamp NULL, 61 MODIFY COLUMN actual_end_time timestamp NULL, 62 MODIFY COLUMN trigger_time timestamp NULL; 63 64ALTER TABLE icinga_eventhandlers 65 MODIFY COLUMN start_time timestamp NULL, 66 MODIFY COLUMN end_time timestamp NULL; 67 68ALTER TABLE icinga_externalcommands 69 MODIFY COLUMN entry_time timestamp NULL; 70 71ALTER TABLE icinga_flappinghistory 72 MODIFY COLUMN event_time timestamp NULL, 73 MODIFY COLUMN comment_time timestamp NULL; 74 75ALTER TABLE icinga_hostchecks 76 MODIFY COLUMN start_time timestamp NULL, 77 MODIFY COLUMN end_time timestamp NULL; 78 79ALTER TABLE icinga_hoststatus 80 MODIFY COLUMN status_update_time timestamp NULL, 81 MODIFY COLUMN last_check timestamp NULL, 82 MODIFY COLUMN next_check timestamp NULL, 83 MODIFY COLUMN last_state_change timestamp NULL, 84 MODIFY COLUMN last_hard_state_change timestamp NULL, 85 MODIFY COLUMN last_time_up timestamp NULL, 86 MODIFY COLUMN last_time_down timestamp NULL, 87 MODIFY COLUMN last_time_unreachable timestamp NULL, 88 MODIFY COLUMN last_notification timestamp NULL, 89 MODIFY COLUMN next_notification timestamp NULL; 90 91ALTER TABLE icinga_logentries 92 MODIFY COLUMN logentry_time timestamp NULL, 93 MODIFY COLUMN entry_time timestamp NULL; 94 95ALTER TABLE icinga_notifications 96 MODIFY COLUMN start_time timestamp NULL, 97 MODIFY COLUMN end_time timestamp NULL; 98 99ALTER TABLE icinga_processevents 100 MODIFY COLUMN event_time timestamp NULL; 101 102ALTER TABLE icinga_programstatus 103 MODIFY COLUMN status_update_time timestamp NULL, 104 MODIFY COLUMN program_start_time timestamp NULL, 105 MODIFY COLUMN program_end_time timestamp NULL, 106 MODIFY COLUMN last_command_check timestamp NULL, 107 MODIFY COLUMN last_log_rotation timestamp NULL, 108 MODIFY COLUMN disable_notif_expire_time timestamp NULL; 109 110ALTER TABLE icinga_scheduleddowntime 111 MODIFY COLUMN entry_time timestamp NULL, 112 MODIFY COLUMN scheduled_start_time timestamp NULL, 113 MODIFY COLUMN scheduled_end_time timestamp NULL, 114 MODIFY COLUMN actual_start_time timestamp NULL, 115 MODIFY COLUMN trigger_time timestamp NULL; 116 117ALTER TABLE icinga_servicechecks 118 MODIFY COLUMN start_time timestamp NULL, 119 MODIFY COLUMN end_time timestamp NULL; 120 121ALTER TABLE icinga_servicestatus 122 MODIFY COLUMN status_update_time timestamp NULL, 123 MODIFY COLUMN last_check timestamp NULL, 124 MODIFY COLUMN next_check timestamp NULL, 125 MODIFY COLUMN last_state_change timestamp NULL, 126 MODIFY COLUMN last_hard_state_change timestamp NULL, 127 MODIFY COLUMN last_time_ok timestamp NULL, 128 MODIFY COLUMN last_time_warning timestamp NULL, 129 MODIFY COLUMN last_time_unknown timestamp NULL, 130 MODIFY COLUMN last_time_critical timestamp NULL, 131 MODIFY COLUMN last_notification timestamp NULL, 132 MODIFY COLUMN next_notification timestamp NULL; 133 134ALTER TABLE icinga_statehistory 135 MODIFY COLUMN state_time timestamp NULL; 136 137ALTER TABLE icinga_systemcommands 138 MODIFY COLUMN start_time timestamp NULL, 139 MODIFY COLUMN end_time timestamp NULL; 140 141ALTER TABLE icinga_endpointstatus 142 MODIFY COLUMN status_update_time timestamp NULL; 143 144ALTER TABLE icinga_zonestatus 145 MODIFY COLUMN status_update_time timestamp NULL; 146 147-- ----------------------------------------- 148-- set dbversion 149-- ----------------------------------------- 150INSERT INTO icinga_dbversion (name, version, create_time, modify_time) VALUES ('idoutils', '1.14.2', NOW(), NOW()) 151ON DUPLICATE KEY UPDATE version='1.14.2', modify_time=NOW(); 152