diff options
Diffstat (limited to 'schema/pgsql.sql')
| -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()); |