diff options
Diffstat (limited to '')
-rw-r--r-- | schema/pgsql-migrations/upgrade_146.sql | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/schema/pgsql-migrations/upgrade_146.sql b/schema/pgsql-migrations/upgrade_146.sql new file mode 100644 index 0000000..ce92a31 --- /dev/null +++ b/schema/pgsql-migrations/upgrade_146.sql @@ -0,0 +1,14 @@ +ALTER TABLE icinga_host + DROP COLUMN flapping_threshold, + ADD COLUMN flapping_threshold_high smallint DEFAULT NULL, + ADD COLUMN flapping_threshold_low smallint DEFAULT NULL; + +ALTER TABLE icinga_service + DROP COLUMN flapping_threshold, + ADD COLUMN flapping_threshold_high smallint DEFAULT NULL, + ADD COLUMN flapping_threshold_low smallint DEFAULT NULL; + + +INSERT INTO director_schema_migration + (schema_version, migration_time) + VALUES (146, NOW()); |