From b09c6d56832eb1718c07d74abf3bc6ae3fe4e030 Mon Sep 17 00:00:00 2001
From: Daniel Baumann <daniel.baumann@progress-linux.org>
Date: Sun, 28 Apr 2024 14:36:04 +0200
Subject: Adding upstream version 1.1.0.

Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
---
 cmd/icingadb-migrate/embed/event_time_cache_schema.sql | 15 +++++++++++++++
 1 file changed, 15 insertions(+)
 create mode 100644 cmd/icingadb-migrate/embed/event_time_cache_schema.sql

(limited to 'cmd/icingadb-migrate/embed/event_time_cache_schema.sql')

diff --git a/cmd/icingadb-migrate/embed/event_time_cache_schema.sql b/cmd/icingadb-migrate/embed/event_time_cache_schema.sql
new file mode 100644
index 0000000..5940754
--- /dev/null
+++ b/cmd/icingadb-migrate/embed/event_time_cache_schema.sql
@@ -0,0 +1,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
+);
-- 
cgit v1.2.3

