| 1 | -- CRM-9699 |
| 2 | |
| 3 | {if $addDedupeEmail} |
| 4 | ALTER TABLE `civicrm_mailing` ADD `dedupe_email` TINYINT( 4 ) NULL DEFAULT '0' COMMENT 'Remove duplicate emails?'; |
| 5 | {/if} |
| 6 | |
| 7 | {if $worldRegionEmpty} |
| 8 | INSERT INTO `civicrm_worldregion` (`id`, `name`) VALUES |
| 9 | (1, 'Europe and Central Asia'), |
| 10 | (2, 'America South, Central, North and Caribbean'), |
| 11 | (3, 'Middle East and North Africa'), |
| 12 | (4, 'Asia-Pacific'), |
| 13 | (5, 'Africa West, East, Central and Southern'), |
| 14 | (99, 'unassigned'); |
| 15 | {/if} |
| 16 | |
| 17 | SELECT @region_id := max(id) from civicrm_worldregion where name = "Africa West, East, Central and Southern"; |
| 18 | |
| 19 | INSERT INTO `civicrm_country` (`name`, `iso_code`, `country_code`, `idd_prefix`, `ndd_prefix`, `region_id`, `is_province_abbreviated`, `address_format_id`) VALUES ('South Sudan', 'SS', NULL, NULL, NULL, @region_id, 0, NULL) ON DUPLICATE KEY UPDATE iso_code='SS'; |
| 20 | |