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

   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