Commit | Line | Data |
---|---|---|
2c55873b | 1 | UPDATE civicrm_dashboard |
7f7fa13a EM |
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 "%?%"; | |
2c55873b C |
4 | |
5 | UPDATE civicrm_dashboard | |
7f7fa13a EM |
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 "%?%"; | |
3ebeaf7c | 8 | |
9 | -- CRM-14843 Added States for Chile and Modify Santiago Metropolitan for consistency | |
5559162a | 10 | INSERT IGNORE INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES |
7f7fa13a EM |
11 | (NULL, 1044, "LR", "Los Rios"), |
12 | (NULL, 1044, "AP", "Arica y Parinacota"), | |
13 | (NULL, 1169, "AMA", "Amazonas"); | |
3ebeaf7c | 14 | |
15 | UPDATE civicrm_state_province | |
7f7fa13a EM |
16 | SET name = "Santiago Metropolitan", abbreviation = "SM" |
17 | WHERE name = "Region Metropolitana de Santiago" AND abbreviation = "RM"; | |
3d65c75c AH |
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 | |
7f7fa13a | 23 | ( 'civicrm_contact', 'civicrm_contact', 'Date Field', 'contact_date_reminder_options', 'Annual Options', 'date_field', NULL, NULL); |
3d65c75c | 24 | |
3d535eb3 | 25 | INSERT INTO `civicrm_option_group` (`name`, {localize field='title'}`title`{/localize}, `is_reserved`, `is_active`, `is_locked`) |
3d65c75c | 26 | VALUES |
3d535eb3 | 27 | ('contact_date_reminder_options', {localize}'{ts escape="sql"}Contact Date Reminder Options{/ts}'{/localize}, 1, 1, 1); |
3d65c75c AH |
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` | |
3d535eb3 | 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`) |
3d65c75c | 33 | VALUES |
3d535eb3 | 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); |