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/pgsql.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/pgsql.sql | 9 |
1 files changed, 8 insertions, 1 deletions
diff --git a/schema/pgsql.sql b/schema/pgsql.sql index b9b2cf8..32931e6 100644 --- a/schema/pgsql.sql +++ b/schema/pgsql.sql @@ -246,6 +246,7 @@ CREATE INDEX start_time_idx ON director_deployment_log (start_time); CREATE TABLE director_datalist ( id serial, + uuid bytea CHECK(LENGTH(uuid) = 16) NOT NULL, list_name character varying(255) NOT NULL, owner character varying(255) NOT NULL, PRIMARY KEY (id) @@ -283,6 +284,7 @@ CREATE UNIQUE INDEX datafield_category_name ON director_datafield_category (cate CREATE TABLE director_datafield ( id serial, + uuid bytea CHECK(LENGTH(uuid) = 16) NOT NULL, category_id integer DEFAULT NULL, varname character varying(64) NOT NULL, caption character varying(255) NOT NULL, @@ -1503,6 +1505,8 @@ CREATE TABLE icinga_notification ( command_id integer DEFAULT NULL, period_id integer DEFAULT NULL, zone_id integer DEFAULT NULL, + users_var character varying(255) DEFAULT NULL, + user_groups_var character varying(255) DEFAULT NULL, assign_filter text DEFAULT NULL, PRIMARY KEY (id), CONSTRAINT icinga_notification_host @@ -1604,6 +1608,7 @@ CREATE TABLE import_row_modifier ( target_property character varying(255) DEFAULT NULL, provider_class character varying(128) NOT NULL, priority integer NOT NULL, + filter_expression text DEFAULT NULL, description text DEFAULT NULL, PRIMARY KEY (id), CONSTRAINT row_modifier_import_source @@ -2684,6 +2689,8 @@ CREATE TABLE branched_icinga_notification ( command character varying(255) DEFAULT NULL, period character varying(255) DEFAULT NULL, zone character varying(255) DEFAULT NULL, + users_var character varying(255) DEFAULT NULL, + user_groups_var character varying(255) DEFAULT NULL, assign_filter text DEFAULT NULL, states TEXT DEFAULT NULL, @@ -2778,4 +2785,4 @@ CREATE INDEX branched_dependency_search_object_name ON branched_icinga_dependenc INSERT INTO director_schema_migration (schema_version, migration_time) - VALUES (182, NOW()); + VALUES (187, NOW()); |