mirror of
https://github.com/Icinga/icingaweb2-module-director.git
synced 2025-07-31 01:34:12 +02:00
9 lines
287 B
SQL
9 lines
287 B
SQL
ALTER TABLE icinga_zone
|
|
DROP FOREIGN KEY icinga_zone_parent_zone,
|
|
CHANGE parent_zone_id parent_id INT(10) UNSIGNED DEFAULT NULL,
|
|
ADD CONSTRAINT icinga_zone_parent
|
|
FOREIGN KEY parent_zone (parent_id)
|
|
REFERENCES icinga_zone (id)
|
|
ON DELETE RESTRICT
|
|
ON UPDATE CASCADE;
|