mirror of
https://github.com/Icinga/icingaweb2-module-director.git
synced 2025-07-31 01:34:12 +02:00
13 lines
574 B
SQL
13 lines
574 B
SQL
ALTER TABLE icinga_hostgroup_parent DROP CONSTRAINT icinga_hostgroup_parent_parent;
|
|
ALTER TABLE icinga_hostgroup_parent ADD CONSTRAINT icinga_hostgroup_parent_parent
|
|
FOREIGN KEY (parent_hostgroup_id)
|
|
REFERENCES icinga_hostgroup (id)
|
|
ON DELETE RESTRICT
|
|
ON UPDATE CASCADE;
|
|
|
|
ALTER TABLE icinga_usergroup_parent DROP CONSTRAINT icinga_usergroup_parent_parent;
|
|
ALTER TABLE icinga_usergroup_parent ADD CONSTRAINT icinga_usergroup_parent_parent
|
|
FOREIGN KEY (parent_usergroup_id)
|
|
REFERENCES icinga_usergroup (id)
|
|
ON DELETE RESTRICT
|
|
ON UPDATE CASCADE; |