crm.fsf.org/20131203/files/sites/all/modules-new/civicrm/CRM/Upgrade/Incremental/sql/4.5.alpha2.mysql.tpl

   1 UPDATE civicrm_dashboard
   2   SET civicrm_dashboard.url = CONCAT(SUBSTRING(url FROM 1 FOR LOCATE('&', url) - 1), '?', SUBSTRING(url FROM LOCATE('&', url) + 1))
   3   WHERE civicrm_dashboard.url LIKE "%&%" AND civicrm_dashboard.url NOT LIKE "%?%";
   4
   5 UPDATE civicrm_dashboard
   6   SET civicrm_dashboard.fullscreen_url = CONCAT(SUBSTRING(fullscreen_url FROM 1 FOR LOCATE('&', fullscreen_url) - 1), '?', SUBSTRING(fullscreen_url FROM LOCATE('&', fullscreen_url) + 1))
   7   WHERE civicrm_dashboard.fullscreen_url LIKE "%&%" AND civicrm_dashboard.fullscreen_url NOT LIKE "%?%";
   8
   9 -- CRM-14843 Added States for Chile and Modify Santiago Metropolitan for consistency
  10 INSERT IGNORE INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES
  11   (NULL, 1044, "LR",  "Los Rios"),
  12   (NULL, 1044, "AP",  "Arica y Parinacota"),
  13   (NULL, 1169, "AMA", "Amazonas");
  14
  15 UPDATE civicrm_state_province
  16   SET name = "Santiago Metropolitan", abbreviation = "SM"
  17   WHERE name = "Region Metropolitana de Santiago" AND abbreviation = "RM";
  18
  19 -- CRM-14879 contact fields for scheduled reminders
  20 INSERT INTO civicrm_action_mapping
  21   (entity, entity_value, entity_value_label, entity_status, entity_status_label, entity_date_start, entity_date_end, entity_recipient)
  22   VALUES
  23   ( 'civicrm_contact', 'civicrm_contact', 'Date Field', 'contact_date_reminder_options', 'Annual Options', 'date_field', NULL, NULL);
  24
  25 INSERT INTO `civicrm_option_group` (`name`, {localize field='title'}`title`{/localize}, `is_reserved`, `is_active`, `is_locked`)
  26   VALUES
  27   ('contact_date_reminder_options', {localize}'{ts escape="sql"}Contact Date Reminder Options{/ts}'{/localize}, 1, 1, 1);
  28
  29 SELECT @option_group_id_contactDateMode := max(id) from civicrm_option_group where name = 'contact_date_reminder_options';
  30
  31 INSERT INTO `civicrm_option_value`
  32   (`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`)
  33   VALUES
  34   (@option_group_id_contactDateMode, {localize}'{ts escape="sql"}Actual date only{/ts}'{/localize}, '1', 'Actual date only', NULL, NULL, 0, 1, 0, 1, 1, NULL, NULL),
  35   (@option_group_id_contactDateMode, {localize}'{ts escape="sql"}Each anniversary{/ts}'{/localize}, '2', 'Each anniversary', NULL, NULL, 0, 2, 0, 1, 1, NULL, NULL);