blob: 9fe8d5ede0bae26b9ceb89f2f851a796bcb27b7e (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
ALTER TABLE icinga_usergroup
ADD COLUMN zone_id integer DEFAULT NULL,
ADD CONSTRAINT icinga_usergroup_zone
FOREIGN KEY (zone_id)
REFERENCES icinga_zone (id)
ON DELETE RESTRICT
ON UPDATE CASCADE;
CREATE INDEX usergroup_zone ON icinga_usergroup (zone_id);
INSERT INTO director_schema_migration
(schema_version, migration_time)
VALUES (149, NOW());
|
