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

   1 {* file to handle db changes in 5.3.alpha1 during upgrade *}
   2 ALTER TABLE civicrm_custom_group ALTER column is_multiple SET DEFAULT 0;
   3 UPDATE civicrm_custom_group SET is_multiple = 0 WHERE is_multiple IS NULL;
   4 ALTER TABLE civicrm_custom_group ALTER column is_active SET DEFAULT 1;
   5 ALTER TABLE civicrm_custom_field ALTER column is_view SET DEFAULT 0;
   6 UPDATE civicrm_custom_field SET is_view = 0 WHERE is_view IS NULL;
   7 ALTER TABLE civicrm_custom_field ALTER column is_required SET DEFAULT 0;
   8 UPDATE civicrm_custom_field SET is_required = 0 WHERE is_required IS NULL;
   9 ALTER TABLE civicrm_custom_field ALTER column is_searchable SET DEFAULT 0;
  10 UPDATE civicrm_custom_field SET is_searchable = 0 WHERE is_required IS NULL;
  11 ALTER TABLE civicrm_custom_field ALTER column is_active SET DEFAULT 1;
  12
  13 SET @UKCountryId = (SELECT id FROM civicrm_country cc WHERE cc.name = 'United Kingdom');
  14 INSERT IGNORE INTO civicrm_state_province (country_id, abbreviation, name)
  15 VALUES (@UKCountryId, 'MON', 'Monmouthshire');
  16
  17 {* dev/core/#152 *}
  18 UPDATE `civicrm_custom_field` set `html_type` = "Multi-Select" WHERE `html_type` = "AdvMulti-Select";