From cd989f9c3aff968e19a3aeabc4eb9085787a6673 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sun, 28 Apr 2024 14:43:12 +0200 Subject: Adding upstream version 1.10.2. Signed-off-by: Daniel Baumann --- schema/mysql-migrations/upgrade_147.sql | 20 ++++++++++++++++++++ 1 file changed, 20 insertions(+) create mode 100644 schema/mysql-migrations/upgrade_147.sql (limited to 'schema/mysql-migrations/upgrade_147.sql') diff --git a/schema/mysql-migrations/upgrade_147.sql b/schema/mysql-migrations/upgrade_147.sql new file mode 100644 index 0000000..d609cda --- /dev/null +++ b/schema/mysql-migrations/upgrade_147.sql @@ -0,0 +1,20 @@ +CREATE TABLE icinga_host_service_blacklist ( + host_id INT(10) UNSIGNED NOT NULL, + service_id INT(10) UNSIGNED NOT NULL, + PRIMARY KEY (host_id, service_id), + CONSTRAINT icinga_host_service_bl_host + FOREIGN KEY host (host_id) + REFERENCES icinga_host (id) + ON DELETE CASCADE + ON UPDATE CASCADE, + CONSTRAINT icinga_host_service_bl_service + FOREIGN KEY service (service_id) + REFERENCES icinga_service (id) + ON DELETE CASCADE + ON UPDATE CASCADE +) ENGINE=InnoDB; + + +INSERT INTO director_schema_migration + (schema_version, migration_time) + VALUES (147, NOW()); -- cgit v1.2.3