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