Commit | Line | Data |
---|---|---|
b52e2159 | 1 | {* file to handle db changes in 4.7.25 during upgrade *} |
b44dc91e | 2 | |
1435405e SL |
3 | --CRM-21061 Increase report_id size from 64 to 512 to match civicrm_option_value.value column |
4 | ALTER TABLE civicrm_report_instance CHANGE COLUMN report_id report_id varchar(512) COMMENT 'FK to civicrm_option_value for the report template'; | |
f41c4788 | 5 | |
6 | -- CRM-18231 Environment variables support | |
7 | INSERT INTO civicrm_option_group | |
8 | (name, {localize field='title'}title{/localize}, is_reserved, is_active) VALUES ('environment', {localize}'{ts escape="sql"}Environment{/ts}'{/localize}, 0, 1); | |
9 | ||
10 | SELECT @option_group_id_env := max(id) from civicrm_option_group where name = 'environment'; | |
3ae1d54a | 11 | INSERT INTO civicrm_option_value (`option_group_id`, {localize field='label'}label{/localize}, `value`, `name`, `grouping`, `filter`, `is_default`, `weight`, {localize field='description'}description{/localize}, `is_optgroup`, `is_reserved`, `is_active`, `component_id`, `visibility_id`) |
f41c4788 | 12 | VALUES |
13 | (@option_group_id_env, {localize}'{ts escape="sql"}Production{/ts}'{/localize}, 'Production', 'Production', NULL, 0, 1, 1, {localize}'{ts escape="sql"}Production Environment{/ts}'{/localize}, 0, 0, 1, NULL, NULL), | |
14 | (@option_group_id_env, {localize}'{ts escape="sql"}Staging{/ts}'{/localize}, 'Staging', 'Staging', NULL, 0, NULL, 2, {localize}'{ts escape="sql"}Staging Environment{/ts}'{/localize}, 0, 0, 1, NULL, NULL), | |
15 | (@option_group_id_env, {localize}'{ts escape="sql"}Development{/ts}'{/localize}, 'Development', 'Development', NULL, 0, NULL, 3, {localize}'{ts escape="sql"}Development Environment{/ts}'{/localize}, 0, 0, 1, NULL, NULL); | |
52b54dda J |
16 | |
17 | -- CRM-20935 Clean up orphaned profile links for deleted events | |
18 | DELETE civicrm_uf_join | |
19 | FROM civicrm_uf_join | |
20 | LEFT JOIN civicrm_event e on civicrm_uf_join.entity_id = e.id | |
21 | WHERE (civicrm_uf_join.module = 'CiviEvent' OR civicrm_uf_join.module = 'CiviEvent_Additional') | |
22 | AND e.id IS NULL; |