blob: 9672f3e26c7c024185e9a813c9d217a9a847d0ca (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
|
CREATE TABLE icinga_notification_user (
notification_id integer NOT NULL,
user_id integer NOT NULL,
PRIMARY KEY (notification_id, user_id),
CONSTRAINT icinga_notification_user_user
FOREIGN KEY (user_id)
REFERENCES icinga_user (id)
ON DELETE CASCADE
ON UPDATE CASCADE,
CONSTRAINT icinga_notification_user_notification
FOREIGN KEY (notification_id)
REFERENCES icinga_notification (id)
ON DELETE CASCADE
ON UPDATE CASCADE
);
CREATE TABLE icinga_notification_usergroup (
notification_id integer NOT NULL,
usergroup_id integer NOT NULL,
PRIMARY KEY (notification_id, usergroup_id),
CONSTRAINT icinga_notification_usergroup_usergroup
FOREIGN KEY (usergroup_id)
REFERENCES icinga_usergroup (id)
ON DELETE CASCADE
ON UPDATE CASCADE,
CONSTRAINT icinga_notification_usergroup_notification
FOREIGN KEY (notification_id)
REFERENCES icinga_notification (id)
ON DELETE CASCADE
ON UPDATE CASCADE
);
INSERT INTO director_schema_migration
(schema_version, migration_time)
VALUES (86, NOW());
|
