[icinga-checkins] icinga.org: icingaweb2-module-director/master: schema: provide target_property for modifiers

git at icinga.org git at icinga.org
Wed Jul 20 15:21:40 CEST 2016


Module: icingaweb2-module-director
Branch: master
Commit: 8d2f546a2e1051375f434bd545882ccbdaab275d
URL:    https://git.icinga.org/?p=icingaweb2-module-director.git;a=commit;h=8d2f546a2e1051375f434bd545882ccbdaab275d

Author: Thomas Gelf <thomas at gelf.net>
Date:   Wed Jul 20 13:15:05 2016 +0200

schema: provide target_property for modifiers

refs #11949

---

 schema/mysql-migrations/upgrade_100.sql |    6 ++++++
 schema/mysql.sql                        |    1 +
 schema/pgsql-migrations/upgrade_100.sql |    6 ++++++
 schema/pgsql.sql                        |    1 +
 4 files changed, 14 insertions(+)

diff --git a/schema/mysql-migrations/upgrade_100.sql b/schema/mysql-migrations/upgrade_100.sql
new file mode 100644
index 0000000..56f8b54
--- /dev/null
+++ b/schema/mysql-migrations/upgrade_100.sql
@@ -0,0 +1,6 @@
+ALTER TABLE import_row_modifier
+  ADD COLUMN target_property VARCHAR(255) DEFAULT NULL AFTER property_name;
+
+INSERT INTO director_schema_migration
+  (schema_version, migration_time)
+  VALUES (100, NOW());
diff --git a/schema/mysql.sql b/schema/mysql.sql
index e8a1bac..7114a0e 100644
--- a/schema/mysql.sql
+++ b/schema/mysql.sql
@@ -1142,6 +1142,7 @@ CREATE TABLE import_row_modifier (
   id INT(10) UNSIGNED AUTO_INCREMENT NOT NULL,
   source_id INT(10) UNSIGNED NOT NULL,
   property_name VARCHAR(255) NOT NULL,
+  target_property VARCHAR(255) DEFAULT NULL,
   provider_class VARCHAR(72) NOT NULL,
   priority SMALLINT UNSIGNED NOT NULL,
   PRIMARY KEY (id),
diff --git a/schema/pgsql-migrations/upgrade_100.sql b/schema/pgsql-migrations/upgrade_100.sql
new file mode 100644
index 0000000..5f2e708
--- /dev/null
+++ b/schema/pgsql-migrations/upgrade_100.sql
@@ -0,0 +1,6 @@
+ALTER TABLE import_row_modifier
+  ADD COLUMN target_property character varying(255) DEFAULT NULL;
+
+INSERT INTO director_schema_migration
+  (schema_version, migration_time)
+  VALUES (100, NOW());
diff --git a/schema/pgsql.sql b/schema/pgsql.sql
index fc5df15..4abc50a 100644
--- a/schema/pgsql.sql
+++ b/schema/pgsql.sql
@@ -1285,6 +1285,7 @@ CREATE TABLE import_row_modifier (
   id bigserial,
   source_id integer NOT NULL,
   property_name character varying(255) NOT NULL,
+  target_property character varying(255) DEFAULT NULL,
   provider_class character varying(72) NOT NULL,
   priority integer NOT NULL,
   PRIMARY KEY (id),



More information about the icinga-checkins mailing list