summaryrefslogtreecommitdiffstats
path: root/schema/mysql-migrations/upgrade_180.sql
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--schema/mysql-migrations/upgrade_180.sql26
1 files changed, 26 insertions, 0 deletions
diff --git a/schema/mysql-migrations/upgrade_180.sql b/schema/mysql-migrations/upgrade_180.sql
new file mode 100644
index 0000000..fb44365
--- /dev/null
+++ b/schema/mysql-migrations/upgrade_180.sql
@@ -0,0 +1,26 @@
+CREATE TABLE branched_icinga_service_set (
+ uuid VARBINARY(16) NOT NULL,
+ branch_uuid VARBINARY(16) NOT NULL,
+ branch_created ENUM('y', 'n') NOT NULL DEFAULT 'n',
+ branch_deleted ENUM('y', 'n') NOT NULL DEFAULT 'n',
+
+ object_name VARCHAR(128) DEFAULT NULL,
+ object_type ENUM('object', 'template', 'external_object') DEFAULT NULL,
+ host VARCHAR(255) DEFAULT NULL,
+ description TEXT DEFAULT NULL,
+ assign_filter TEXT DEFAULT NULL,
+
+ imports TEXT DEFAULT NULL,
+ set_null TEXT DEFAULT NULL,
+ PRIMARY KEY (branch_uuid, uuid),
+ INDEX search_object_name (object_name),
+ CONSTRAINT icinga_service_set_branch
+ FOREIGN KEY branch (branch_uuid)
+ REFERENCES director_branch (uuid)
+ ON DELETE CASCADE
+ ON UPDATE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+INSERT INTO director_schema_migration
+ (schema_version, migration_time)
+ VALUES (180, NOW());