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

   1 {* file to handle db changes in 5.5.alpha1 during upgrade *}
   2 #https://lab.civicrm.org/dev/core/issues/228
   3 UPDATE civicrm_option_group SET is_active = 0 WHERE is_active IS NULL;
   4 ALTER TABLE civicrm_option_group MODIFY COLUMN is_active TINYINT(4) NOT NULL DEFAULT 1 COMMENT 'Is this option group active?';
   5 UPDATE civicrm_option_group SET is_locked = 0 WHERE is_locked IS NULL;
   6 ALTER TABLE civicrm_option_group MODIFY COLUMN  is_locked TINYINT(4) NOT NULL DEFAULT 1 COMMENT 'A lock to remove the ability to add new options via the UI.';
   7 #is_reserved already has a default so is effectively required but let's be explicit.
   8 UPDATE civicrm_option_group SET `is_reserved` = 0 WHERE `is_reserved` IS NULL;
   9 ALTER TABLE civicrm_option_group MODIFY COLUMN `is_reserved` tinyint(4) NOT NULL DEFAULT 1 COMMENT 'Is this a predefined system option group (i.e. it can not be deleted)?';
  10
  11 #https://lab.civicrm.org/dev/core/issues/155
  12 {* Fix is_reserved flag on civicrm_option_group table *}
  13 UPDATE civicrm_option_group AS cog INNER JOIN civicrm_custom_field AS ccf
  14 ON cog.id = ccf.option_group_id
  15 SET cog.is_reserved = 0 WHERE cog.is_active = 1 AND ccf.is_active = 1;
  16 UPDATE civicrm_option_group SET is_reserved = 1 WHERE name='environment';
  17
  18 UPDATE civicrm_navigation SET url = 'civicrm/admin/options?action=browse&reset=1' WHERE name = 'Dropdown Options' AND domain_id = {$domainID};