diff options
Diffstat (limited to '')
| -rw-r--r-- | schema/mysql-legacy-changes/upgrade_43.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/schema/mysql-legacy-changes/upgrade_43.sql b/schema/mysql-legacy-changes/upgrade_43.sql new file mode 100644 index 0000000..4e6a810 --- /dev/null +++ b/schema/mysql-legacy-changes/upgrade_43.sql @@ -0,0 +1,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; + + |