summaryrefslogtreecommitdiffstats
path: root/schema/mysql-legacy-changes/upgrade_6.sql
diff options
context:
space:
mode:
Diffstat (limited to 'schema/mysql-legacy-changes/upgrade_6.sql')
-rw-r--r--schema/mysql-legacy-changes/upgrade_6.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/schema/mysql-legacy-changes/upgrade_6.sql b/schema/mysql-legacy-changes/upgrade_6.sql
new file mode 100644
index 0000000..0834b10
--- /dev/null
+++ b/schema/mysql-legacy-changes/upgrade_6.sql
@@ -0,0 +1,5 @@
+ALTER TABLE icinga_endpoint
+ MODIFY zone_id INT(10) UNSIGNED DEFAULT NULL,
+ MODIFY port SMALLINT UNSIGNED DEFAULT NULL COMMENT '5665 if not set',
+ MODIFY log_duration VARCHAR(32) DEFAULT NULL COMMENT '1d if not set';
+