schema/mysql-migrations/upgrade_134.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19

ALTER TABLE icinga_host
  DROP FOREIGN KEY icinga_host_template_choice,
  ADD CONSTRAINT icinga_host_template_choice_v2
  FOREIGN KEY template_choice (template_choice_id)
  REFERENCES icinga_host_template_choice (id)
    ON DELETE SET NULL
    ON UPDATE CASCADE;

ALTER TABLE icinga_service
  DROP FOREIGN KEY icinga_service_template_choice,
  ADD CONSTRAINT icinga_service_template_choice_v2
  FOREIGN KEY template_choice (template_choice_id)
  REFERENCES icinga_service_template_choice (id)
    ON DELETE SET NULL
    ON UPDATE CASCADE;

INSERT INTO director_schema_migration
  (schema_version, migration_time)
  VALUES (134, NOW());