crm.fsf.org/20131203/files/sites/all/modules-old/civicrm/CRM/Upgrade/Incremental/sql/4.6.beta3.mysql.tpl

   1 {* file to handle db changes in 4.6.beta3 during upgrade *}
   2
   3 {*--CRM-15979 - differentiate between standalone mailings, A/B tests, and A/B final-winner *}
   4 ALTER TABLE  `civicrm_mailing` ADD mailing_type varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci COMMENT  'differentiate between standalone mailings, A/B tests, and A/B final-winner';
   5
   6 UPDATE `civicrm_mailing`cm
   7 LEFT JOIN civicrm_mailing_abtest ab
   8 ON cm.id = ab.mailing_id_a
   9   OR cm.id = ab.mailing_id_b
  10   OR cm.id = ab.mailing_id_c
  11   SET `mailing_type` = CASE
  12     WHEN cm.id IN (ab.mailing_id_a,ab.mailing_id_b) THEN 'experiment'
  13     WHEN cm.id IN (ab.mailing_id_c) THEN 'winner'
  14     ELSE 'standalone'
  15   END
  16 WHERE cm.id IS NOT NULL;
  17
  18 -- CRM-16059
  19 UPDATE civicrm_state_province SET name = 'Dobrich' WHERE name = 'Dobric';
  20 UPDATE civicrm_state_province SET name = 'Yambol' WHERE name = 'Jambol';
  21 UPDATE civicrm_state_province SET name = 'Kardzhali' WHERE name = 'Kardzali';
  22 UPDATE civicrm_state_province SET name = 'Kyustendil' WHERE name = 'Kjstendil';
  23 UPDATE civicrm_state_province SET name = 'Lovech' WHERE name = 'Lovec';
  24 UPDATE civicrm_state_province SET name = 'Smolyan' WHERE name = 'Smoljan';
  25 UPDATE civicrm_state_province SET name = 'Shumen' WHERE name = 'Sumen';
  26 UPDATE civicrm_state_province SET name = 'Targovishte' WHERE name = 'Targoviste';
  27 UPDATE civicrm_state_province SET name = 'Vratsa' WHERE name = 'Vraca';