blob: 32bc55eb0538b3b0efa945ba7315bd30d49222c1 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
DROP TABLE IF EXISTS icinga_sla_periods;
CREATE TABLE icinga_sla_periods (
timeperiod_object_id BIGINT(20) UNSIGNED NOT NULL,
start_time timestamp NOT NULL,
end_time timestamp NULL DEFAULT NULL,
PRIMARY KEY tp_start (timeperiod_object_id, start_time),
UNIQUE KEY tp_end (timeperiod_object_id, end_time)
) ENGINE InnoDB;
DROP TABLE IF EXISTS icinga_outofsla_periods;
CREATE TABLE icinga_outofsla_periods (
timeperiod_object_id BIGINT(20) UNSIGNED NOT NULL,
start_time timestamp NOT NULL,
end_time timestamp NULL DEFAULT NULL,
PRIMARY KEY tp_start (timeperiod_object_id, start_time),
UNIQUE KEY tp_end (timeperiod_object_id, end_time)
) ENGINE InnoDB;
|
