CRM/Upgrade/Incremental/sql/4.7.30.mysql.tpl

   1 {* file to handle db changes in 4.7.30 during upgrade *}
   2
   3 -- CRM-21407 ISO compliance for German counties
   4 UPDATE `civicrm_state_province` SET `name` = 'Baden-Württemberg' WHERE `name` = 'Baden-Wuerttemberg' AND `country_id` = 1082;
   5 UPDATE `civicrm_state_province` SET `abbreviation` = 'BE' WHERE `name` = 'Berlin' AND `abbreviation` = 'BR' AND `country_id` = 1082;
   6 UPDATE `civicrm_state_province` SET `name` = 'Thüringen' WHERE `name` = 'Thueringen' AND `country_id` = 1082;
   7
   8 -- CRM-21378 Ensure that email abuse reports are treated as spam
   9 SELECT @bounceTypeID := max(id) FROM civicrm_mailing_bounce_type WHERE name = 'Spam';
  10 INSERT INTO civicrm_mailing_bounce_pattern (bounce_type_id, pattern) VALUES (@bounceTypeID, 'abuse report');
  11
  12
  13 -- CRM-21532 Add French state/departments
  14 SELECT @country_id := id from civicrm_country where name = 'France' AND iso_code = 'FR';
  15 INSERT IGNORE INTO `civicrm_state_province` (`id`, `country_id`, `abbreviation`, `name`) VALUES
  16 (NULL, @country_id, "52", "Haute-Marne");