blob: 92a7a6d58bf8cbb5f7980f9c0f29cd78e6e8ebf3 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
UPDATE icinga_user u
SET period_id = NULL
WHERE NOT EXISTS (
SELECT id FROM icinga_timeperiod
WHERE id = u.period_id
) AND u.period_id IS NOT NULL;
ALTER TABLE icinga_user
ADD CONSTRAINT icinga_user_period
FOREIGN KEY period (period_id)
REFERENCES icinga_timeperiod (id)
ON DELETE RESTRICT
ON UPDATE CASCADE;
INSERT INTO director_schema_migration
(schema_version, migration_time)
VALUES (150, NOW());
|
