blob: 5940754be71727c2ac65a69ad5d8c8c513e43d48 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
PRAGMA main.auto_vacuum = 1;
-- Icinga DB's flapping_history#start_time per flapping_end row (IDO's icinga_flappinghistory#flappinghistory_id).
CREATE TABLE IF NOT EXISTS end_start_time (
history_id INT PRIMARY KEY,
event_time INT NOT NULL,
event_time_usec INT NOT NULL
);
-- Helper table, the last start_time per icinga_statehistory#object_id.
CREATE TABLE IF NOT EXISTS last_start_time (
object_id INT PRIMARY KEY,
event_time INT NOT NULL,
event_time_usec INT NOT NULL
);
|
