blob: d08510ff56f4cc74c089f3babbadaf7f43e86c74 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
ALTER TABLE icinga_host
DROP CONSTRAINT icinga_host_template_choice,
ADD CONSTRAINT icinga_host_template_choice_v2
FOREIGN KEY (template_choice_id)
REFERENCES icinga_host_template_choice (id)
ON DELETE SET NULL
ON UPDATE CASCADE;
ALTER TABLE icinga_service
DROP CONSTRAINT icinga_service_template_choice,
ADD CONSTRAINT icinga_service_template_choice_v2
FOREIGN KEY (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());
|
