[icinga-checkins] icinga.org: icingaweb2-module-director/master: schema/mysql: delete ranges on time period deletion

git at icinga.org git at icinga.org
Fri Feb 26 14:12:05 CET 2016


Module: icingaweb2-module-director
Branch: master
Commit: f0cf938ddce9411e59a9c5d3435e62df47ca6e7b
URL:    https://git.icinga.org/?p=icingaweb2-module-director.git;a=commit;h=f0cf938ddce9411e59a9c5d3435e62df47ca6e7b

Author: Thomas Gelf <thomas at gelf.net>
Date:   Fri Feb 26 14:11:47 2016 +0100

schema/mysql: delete ranges on time period deletion

---

 schema/mysql-migrations/upgrade_70.sql |   13 +++++++++++++
 schema/mysql.sql                       |    2 +-
 2 files changed, 14 insertions(+), 1 deletion(-)

diff --git a/schema/mysql-migrations/upgrade_70.sql b/schema/mysql-migrations/upgrade_70.sql
new file mode 100644
index 0000000..1312c02
--- /dev/null
+++ b/schema/mysql-migrations/upgrade_70.sql
@@ -0,0 +1,13 @@
+ALTER TABLE icinga_timeperiod_range
+  DROP FOREIGN KEY icinga_timeperiod_range_timeperiod;
+
+ALTER TABLE icinga_timeperiod_range
+  ADD CONSTRAINT icinga_timeperiod_range_timeperiod
+    FOREIGN KEY timeperiod (timeperiod_id)
+    REFERENCES icinga_timeperiod (id)
+    ON DELETE CASCADE
+    ON UPDATE CASCADE;
+
+INSERT INTO director_schema_migration
+  SET migration_time = NOW(),
+      schema_version = 70;
diff --git a/schema/mysql.sql b/schema/mysql.sql
index 7e86e7c..41d709c 100644
--- a/schema/mysql.sql
+++ b/schema/mysql.sql
@@ -1069,5 +1069,5 @@ CREATE TABLE sync_run (
 
 INSERT INTO director_schema_migration
   SET migration_time = NOW(),
-      schema_version = 69
+      schema_version = 70;
 



More information about the icinga-checkins mailing list