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