blob: 76be96f7211c02aae16c60a398800123431d0421 (
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_host_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_host
ADD COLUMN template_choice_id INT(10) UNSIGNED DEFAULT NULL,
ADD CONSTRAINT icinga_host_template_choice
FOREIGN KEY choice (template_choice_id)
REFERENCES icinga_host_template_choice (id)
ON DELETE RESTRICT
ON UPDATE CASCADE;
INSERT INTO director_schema_migration
(schema_version, migration_time)
VALUES (132, NOW());
|
