CRM/Upgrade/Incremental/sql/3.1.alpha2.mysql.tpl

   1 -- CRM-3507: upgrade message templates (if changed)
   2 {include file='../CRM/Upgrade/3.1.alpha2.msg_template/civicrm_msg_template.tpl'}
   3
   4 --  CRM-5263
   5
   6 UPDATE civicrm_country SET is_province_abbreviated = 1
   7 WHERE name IN ('Canada', 'United States');
   8
   9 --  CRM-5106
  10 --  Updating weight for Autocomplete search options
  11
  12 SELECT @option_group_id_acsOpt := max(id) from civicrm_option_group where name = 'contact_autocomplete_options';
  13
  14 DELETE FROM `civicrm_option_value` WHERE option_group_id = @option_group_id_acsOpt;
  15
  16 INSERT INTO `civicrm_option_value`
  17     (`option_group_id`, {localize field='label'}`label`{/localize}, `value`, `name`, `grouping`, `filter`, `is_default`, `weight`, `is_optgroup`, `is_reserved`, `is_active`, `component_id`, `visibility_id`)
  18 VALUES
  19     (@option_group_id_acsOpt, {localize}'Email Address'{/localize}  , 2, 'email',          NULL, 0, NULL, 2,  0, 0, 1, NULL, NULL),
  20     (@option_group_id_acsOpt, {localize}'Phone'{/localize}          , 3, 'phone',          NULL, 0, NULL, 3,  0, 0, 1, NULL, NULL),
  21     (@option_group_id_acsOpt, {localize}'Street Address'{/localize} , 4, 'street_address', NULL, 0, NULL, 4,  0, 0, 1, NULL, NULL),
  22     (@option_group_id_acsOpt, {localize}'City'{/localize}           , 5, 'city',           NULL, 0, NULL, 5,  0, 0, 1, NULL, NULL),
  23     (@option_group_id_acsOpt, {localize}'State/Province'{/localize} , 6, 'state_province', NULL, 0, NULL, 6,  0, 0, 1, NULL, NULL),
  24     (@option_group_id_acsOpt, {localize}'Country'{/localize}        , 7, 'country',        NULL, 0, NULL, 7,  0, 0, 1, NULL, NULL);