Commit | Line | Data |
---|---|---|
6a488035 TO |
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 |