mirror of
https://github.com/Icinga/icingadb.git
synced 2026-02-03 20:40:34 -05:00
15 lines
521 B
SQL
15 lines
521 B
SQL
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
|
|
);
|