[icinga-checkins] icinga.org: icingaweb2-module-director/master: schema/pgsql: fix forgotten column configs

git at icinga.org git at icinga.org
Thu Oct 6 19:49:03 CEST 2016


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

Author: Thomas Gelf <thomas at gelf.net>
Date:   Thu Oct  6 17:46:14 2016 +0000

schema/pgsql: fix forgotten column configs

thanks @greatexpectations!

fixes #12863

---

 schema/pgsql-migrations/upgrade_113.sql |    6 ++++++
 schema/pgsql.sql                        |    6 +++---
 2 files changed, 9 insertions(+), 3 deletions(-)

diff --git a/schema/pgsql-migrations/upgrade_113.sql b/schema/pgsql-migrations/upgrade_113.sql
new file mode 100644
index 0000000..6bc541a
--- /dev/null
+++ b/schema/pgsql-migrations/upgrade_113.sql
@@ -0,0 +1,6 @@
+COMMENT ON COLUMN icinga_timeperiod_range.range_key IS 'monday, ...';
+COMMENT ON COLUMN icinga_timeperiod_range.range_value IS '00:00-24:00, ...';
+
+INSERT INTO director_schema_migration
+  (schema_version, migration_time)
+  VALUES (113, NOW());
diff --git a/schema/pgsql.sql b/schema/pgsql.sql
index 943dfce..cb00d15 100644
--- a/schema/pgsql.sql
+++ b/schema/pgsql.sql
@@ -325,8 +325,8 @@ CREATE TABLE icinga_timeperiod_range (
 );
 
 CREATE INDEX timeperiod_range_timeperiod ON icinga_timeperiod_range (timeperiod_id);
-COMMENT ON COLUMN icinga_timeperiod_range.timeperiod_key IS 'monday, ...';
-COMMENT ON COLUMN icinga_timeperiod_range.timeperiod_value IS '00:00-24:00, ...';
+COMMENT ON COLUMN icinga_timeperiod_range.range_key IS 'monday, ...';
+COMMENT ON COLUMN icinga_timeperiod_range.range_value IS '00:00-24:00, ...';
 COMMENT ON COLUMN icinga_timeperiod_range.range_type IS 'include -> ranges {}, exclude ranges_ignore {} - not yet';
 COMMENT ON COLUMN icinga_timeperiod_range.merge_behaviour IS 'set -> = {}, add -> += {}, substract -> -= {}';
 
@@ -1545,4 +1545,4 @@ CREATE UNIQUE INDEX notification_inheritance ON icinga_notification_inheritance
 
 INSERT INTO director_schema_migration
   (schema_version, migration_time)
-  VALUES (111, NOW());
+  VALUES (113, NOW());



More information about the icinga-checkins mailing list