dev/core#1833 Change default value of participant_listing_id to NULL from 0

[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 13a26cf3e67babf03e12b7c5b73db5f4fd66c8ec..bb5e5c989522bfdf3b215c7c7df8e0f4630d4476 100644 (file)
--- a/CRM/Upgrade/Incremental/sql/5.28.alpha1.mysql.tpl
+++ b/CRM/Upgrade/Incremental/sql/5.28.alpha1.mysql.tpl
@@ -14,3 +14,7 @@ ALTER TABLE civicrm_contact_type CHANGE is_active is_active tinyint DEFAULT 1  C
 ALTER TABLE civicrm_contact_type CHANGE is_reserved is_reserved tinyint DEFAULT 0  COMMENT 'Is this contact type a predefined system type';
 UPDATE civicrm_contact_type SET is_active = 1 WHERE is_active IS NULL;
 UPDATE civicrm_contact_type SET is_reserved = 0 WHERE is_reserved IS NULL;
+
+-- https://lab.civicrm.org/dev/core/-/issues/1833
+ALTER TABLE civicrm_event CHANGE participant_listing_id participant_listing_id int unsigned   DEFAULT NULL COMMENT 'Should we expose the participant list? Implicit FK to civicrm_option_value where option_group = participant_listing.';
+UPDATE civicrm_event SET participant_listing_id = NULL WHERE participant_listing_id = 0;