Commit | Line | Data |
---|---|---|
6a488035 TO |
1 | -- CRM-5224 |
2 | SELECT @country_id := id FROM civicrm_country WHERE name = 'United Kingdom'; | |
3 | INSERT IGNORE INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES (2712, @country_id, 'LIN', 'Lincolnshire'); | |
4 | ||
5 | -- CRM-5938 | |
6 | ||
7 | SELECT @domainID := min(id) FROM civicrm_domain; | |
10824d34 | 8 | INSERT INTO `civicrm_dashboard` |
9 | ( `domain_id`, {localize field='label'}`label`{/localize}, `url`, `content`, `permission`, `permission_operator`, `column_no`, `is_minimized`, `is_active`, `weight`, `created_date`, `is_fullscreen`, `is_reserved`) | |
10 | VALUES | |
6a488035 TO |
11 | ( @domainID, {localize}'My Cases'{/localize}, 'civicrm/dashlet/myCases&reset=1&snippet=4', NULL, 'access my cases and activities', NULL , 0, 0, 1, 2, NULL, 1, 1), |
12 | ( @domainID, {localize}'All Cases'{/localize}, 'civicrm/dashlet/allCases&reset=1&snippet=4', NULL, 'access all cases and activities', NULL , 0, 0, 1, 3, NULL, 1, 1); | |
13 | ||
14 | -- CRM-6294 | |
15 | SELECT @option_group_id_eventBadge := max(id) from civicrm_option_group where name = 'event_badge'; | |
16 | {if $multilingual} | |
17 | INSERT INTO civicrm_option_value | |
10824d34 | 18 | (option_group_id, {foreach from=$locales item=locale}label_{$locale}, description_{$locale}, {/foreach} value, name, weight, is_active, component_id ) |
6a488035 TO |
19 | VALUES |
20 | (@option_group_id_eventBadge , {foreach from=$locales item=locale}'With Logo', 'You can set your own background image', {/foreach} '3', 'CRM_Event_Badge_Logo', 1, 1, NULL ); | |
21 | {else} | |
22 | INSERT INTO civicrm_option_value | |
10824d34 | 23 | (option_group_id, label, description, value, name, weight, is_active, component_id ) |
6a488035 TO |
24 | VALUES |
25 | (@option_group_id_eventBadge , '{ts escape="sql"}With Logo{/ts}', '{ts escape="sql"}You can set your own background image{/ts}', '3', 'CRM_Event_Badge_Logo', 1, 1, NULL ); | |
26 | {/if} | |
27 | ||
28 |