blob: 6aca7095b6a459bd6e5ba2eb4c85dd88adc0988b (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
CREATE TABLE icinga_notification_assignment (
id bigserial,
notification_id integer NOT NULL,
filter_string TEXT NOT NULL,
PRIMARY KEY (id),
CONSTRAINT icinga_notification_assignment
FOREIGN KEY (notification_id)
REFERENCES icinga_notification (id)
ON DELETE CASCADE
ON UPDATE CASCADE
);
INSERT INTO director_schema_migration
(schema_version, migration_time)
VALUES (85, NOW());
|