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;