summaryrefslogtreecommitdiffstats
path: root/schema/mysql-migrations/upgrade_133.sql
blob: 9f1a474fe92f9521836acf0be1925fe6f1aaebfe (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
CREATE TABLE icinga_service_template_choice (
  id INT(10) UNSIGNED AUTO_INCREMENT NOT NULL,
  object_name VARCHAR(64) NOT NULL,
  description TEXT DEFAULT NULL,
  min_required SMALLINT UNSIGNED NOT NULL DEFAULT 0,
  max_allowed SMALLINT UNSIGNED NOT NULL DEFAULT 1,
  PRIMARY KEY (id),
  UNIQUE KEY (object_name)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE icinga_service
  ADD COLUMN template_choice_id INT(10) UNSIGNED DEFAULT NULL,
  ADD CONSTRAINT icinga_service_template_choice
  FOREIGN KEY choice (template_choice_id)
  REFERENCES icinga_service_template_choice (id)
    ON DELETE RESTRICT
    ON UPDATE CASCADE;

INSERT INTO director_schema_migration
(schema_version, migration_time)
VALUES (133, NOW());