CRM/Upgrade/Incremental/sql/5.28.alpha1.mysql.tpl

   1 {* file to handle db changes in 5.28.alpha1 during upgrade *}
   2
   3 -- https://github.com/civicrm/civicrm-core/pull/17579
   4 ALTER TABLE `civicrm_navigation` CHANGE `has_separator`
   5 `has_separator` tinyint   DEFAULT 0 COMMENT 'Place a separator either before or after this menu item.';
   6
   7 -- https://github.com/civicrm/civicrm-core/pull/17450
   8 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.';
   9 ALTER TABLE `civicrm_activity` CHANGE `created_date` `created_date` timestamp NULL  DEFAULT CURRENT_TIMESTAMP COMMENT 'When was the activity was created.';
  10
  11 -- https://github.com/civicrm/civicrm-core/pull/17548
  12 ALTER TABLE civicrm_contact_type CHANGE name  name varchar(64) not null comment 'Internal name of Contact Type (or Subtype).';
  13 ALTER TABLE civicrm_contact_type CHANGE is_active is_active tinyint DEFAULT 1  COMMENT 'Is this entry active?';
  14 ALTER TABLE civicrm_contact_type CHANGE is_reserved is_reserved tinyint DEFAULT 0  COMMENT 'Is this contact type a predefined system type';
  15 UPDATE civicrm_contact_type SET is_active = 1 WHERE is_active IS NULL;
  16 UPDATE civicrm_contact_type SET is_reserved = 0 WHERE is_reserved IS NULL;
  17
  18 -- https://lab.civicrm.org/dev/core/-/issues/1833
  19 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.';
  20 UPDATE civicrm_event SET participant_listing_id = NULL WHERE participant_listing_id = 0;
  21
  22 -- https://lab.civicrm.org/dev/core/-/issues/1852
  23 -- Ensure all domains have the same value for locales
  24 UPDATE civicrm_domain SET locales = (SELECT locales FROM (SELECT locales FROM civicrm_domain ORDER BY id LIMIT 1) d);