blob: 4e6a810e40ed16470d25958e64b8971904ef393c (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
|
CREATE TABLE icinga_service_assignment (
id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
service_id INT(10) UNSIGNED NOT NULL,
filter_string TEXT NOT NULL,
PRIMARY KEY (id),
CONSTRAINT icinga_service_assignment
FOREIGN KEY service (service_id)
REFERENCES icinga_service (id)
ON DELETE CASCADE
ON UPDATE CASCADE
) ENGINE=InnoDB;
|
