diff options
| author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-14 13:17:47 +0000 |
|---|---|---|
| committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-14 13:17:47 +0000 |
| commit | 5419d4428c86c488a43124f85e5407d7cbae6541 (patch) | |
| tree | 772c4221a20fd7d1b3e7e67c6e21755a50e80fd7 /schema/mysql.sql | |
| parent | Adding upstream version 1.10.2. (diff) | |
| download | icingaweb2-module-director-5419d4428c86c488a43124f85e5407d7cbae6541.tar.xz icingaweb2-module-director-5419d4428c86c488a43124f85e5407d7cbae6541.zip | |
Adding upstream version 1.11.1.upstream/1.11.1upstream
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to '')
| -rw-r--r-- | schema/mysql.sql | 9 |
1 files changed, 8 insertions, 1 deletions
diff --git a/schema/mysql.sql b/schema/mysql.sql index 02ac5d9..832ab12 100644 --- a/schema/mysql.sql +++ b/schema/mysql.sql @@ -177,6 +177,7 @@ CREATE TABLE director_deployment_log ( CREATE TABLE director_datalist ( id INT(10) UNSIGNED AUTO_INCREMENT NOT NULL, + uuid VARBINARY(16) NOT NULL, list_name VARCHAR(255) NOT NULL, owner VARCHAR(255) NOT NULL, PRIMARY KEY (id), @@ -207,6 +208,7 @@ CREATE TABLE director_datafield_category ( CREATE TABLE director_datafield ( id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, + uuid VARBINARY(16) NOT NULL, category_id INT(10) UNSIGNED DEFAULT NULL, varname VARCHAR(64) NOT NULL COLLATE utf8_bin, caption VARCHAR(255) NOT NULL, @@ -1260,6 +1262,8 @@ CREATE TABLE icinga_notification ( command_id INT(10) UNSIGNED DEFAULT NULL, period_id INT(10) UNSIGNED DEFAULT NULL, zone_id INT(10) UNSIGNED DEFAULT NULL, + users_var VARCHAR(255) DEFAULT NULL, + user_groups_var VARCHAR(255) DEFAULT NULL, assign_filter TEXT DEFAULT NULL, PRIMARY KEY (id), UNIQUE INDEX uuid (uuid), @@ -1455,6 +1459,7 @@ CREATE TABLE import_row_modifier ( target_property VARCHAR(255) DEFAULT NULL, provider_class VARCHAR(128) NOT NULL, priority SMALLINT UNSIGNED NOT NULL, + filter_expression TEXT DEFAULT NULL, description TEXT DEFAULT NULL, PRIMARY KEY (id), KEY search_idx (property_name), @@ -2351,6 +2356,8 @@ CREATE TABLE branched_icinga_notification ( command VARCHAR(255) DEFAULT NULL, period VARCHAR(255) DEFAULT NULL, zone VARCHAR(255) DEFAULT NULL, + users_var VARCHAR(255) DEFAULT NULL, + user_groups_var VARCHAR(255) DEFAULT NULL, assign_filter TEXT DEFAULT NULL, states TEXT DEFAULT NULL, @@ -2439,4 +2446,4 @@ CREATE TABLE branched_icinga_dependency ( INSERT INTO director_schema_migration (schema_version, migration_time) - VALUES (182, NOW()); + VALUES (187, NOW()); |