| 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'; |