Update has_separator field in civicrm_navigation

[civicrm-core.git] / CRM / Upgrade / Incremental / sql / 5.28.alpha1.mysql.tpl

diff --git a/CRM/Upgrade/Incremental/sql/5.28.alpha1.mysql.tpl b/CRM/Upgrade/Incremental/sql/5.28.alpha1.mysql.tpl
index a82693b7f0a36e85ca0941a2270d7746a326bb68..13a26cf3e67babf03e12b7c5b73db5f4fd66c8ec 100644 (file)
--- a/CRM/Upgrade/Incremental/sql/5.28.alpha1.mysql.tpl
+++ b/CRM/Upgrade/Incremental/sql/5.28.alpha1.mysql.tpl
@@ -1,5 +1,9 @@
 {* file to handle db changes in 5.28.alpha1 during upgrade *}
 
+-- https://github.com/civicrm/civicrm-core/pull/17579
+ALTER TABLE `civicrm_navigation` CHANGE `has_separator`
+`has_separator` tinyint   DEFAULT 0 COMMENT 'Place a separator either before or after this menu item.';
+
 -- https://github.com/civicrm/civicrm-core/pull/17450
 ALTER TABLE `civicrm_activity` CHANGE `activity_date_time` `activity_date_time` datetime NULL  DEFAULT CURRENT_TIMESTAMP COMMENT 'Date and time this activity is scheduled to occur. Formerly named scheduled_date_time.';
 ALTER TABLE `civicrm_activity` CHANGE `created_date` `created_date` timestamp NULL  DEFAULT CURRENT_TIMESTAMP COMMENT 'When was the activity was created.';