Commit | Line | Data |
---|---|---|
6a488035 TO |
1 | |
2 | -- CRM-7871 | |
3 | INSERT INTO civicrm_option_group | |
4 | (name, {localize field='description'}description{/localize}, is_reserved, is_active) | |
5 | VALUES | |
6 | ('engagement_index', {localize}'{ts escape="sql"}Engagement Levels{/ts}'{/localize}, 0, 1); | |
7 | ||
8 | SELECT @optGrpIdEngagementIndex := max(id) from civicrm_option_group where name = 'engagement_index'; | |
9 | ||
10824d34 | 10 | INSERT INTO civicrm_option_value |
6a488035 TO |
11 | (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) |
12 | VALUES | |
13 | (@optGrpIdEngagementIndex, {localize}'{ts escape="sql"}1{/ts}'{/localize}, 1, 1, NULL, 0, NULL, 1, 0, 0, 1, NULL, NULL), | |
14 | (@optGrpIdEngagementIndex, {localize}'{ts escape="sql"}2{/ts}'{/localize}, 2, 2, NULL, 0, NULL, 2, 0, 0, 1, NULL, NULL), | |
15 | (@optGrpIdEngagementIndex, {localize}'{ts escape="sql"}3{/ts}'{/localize}, 3, 3, NULL, 0, NULL, 3, 0, 0, 1, NULL, NULL), | |
16 | (@optGrpIdEngagementIndex, {localize}'{ts escape="sql"}4{/ts}'{/localize}, 4, 4, NULL, 0, NULL, 4, 0, 0, 1, NULL, NULL), | |
17 | (@optGrpIdEngagementIndex, {localize}'{ts escape="sql"}5{/ts}'{/localize}, 5, 5, NULL, 0, NULL, 5, 0, 0, 1, NULL, NULL); | |
18 | ||
19 | -- insert navigation link. | |
20 | -- NOTE: code below will not work due to spaces in increment statement for weight | |
21 | -- and because CiviCampaign admin links were not inserted during 3.3 upgrade | |
22 | -- fixing both issues in 3.4.1 upgrade: CRM-7956 | |
23 | ||
24 | SELECT @civiCampaignNavId := MAX(id) FROM civicrm_navigation where name = 'CiviCampaign'; | |
25 | SELECT @cmapaignNavMaxWeight := MAX(ROUND(weight)) from civicrm_navigation WHERE parent_id = @civiCampaignNavId; | |
26 | ||
27 | INSERT INTO civicrm_navigation | |
28 | ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight ) | |
29 | VALUES | |
30 | ( {$domainID}, 'civicrm/admin/options/engagement_index&group=engagement_index&reset=1', '{ts escape="sql"}Engagement Index{/ts}', 'Engagement Index', 'administer CiviCampaign', '', @civiCampaignNavId, 1, NULL, @cmapaignNavMaxWeight + 1 ); | |
31 |