blob: 2709186bfa852224a9aa922ef908497fd016528d (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
ALTER TABLE icinga_hostgroup_parent DROP FOREIGN KEY icinga_hostgroup_parent_parent;
ALTER TABLE icinga_hostgroup_parent ADD CONSTRAINT icinga_hostgroup_parent_parent
FOREIGN KEY parent (parent_hostgroup_id)
REFERENCES icinga_hostgroup (id)
ON DELETE RESTRICT
ON UPDATE CASCADE;
ALTER TABLE icinga_usergroup_parent DROP FOREIGN KEY icinga_usergroup_parent_parent;
ALTER TABLE icinga_usergroup_parent ADD CONSTRAINT icinga_usergroup_parent_parent
FOREIGN KEY parent (parent_usergroup_id)
REFERENCES icinga_usergroup (id)
ON DELETE RESTRICT
ON UPDATE CASCADE;
|
