Commit | Line | Data |
---|---|---|
6a488035 TO |
1 | -- Do not make any changes to this file once alpha3 is tagged |
2 | -- CRM-3546 CRM-2105 CRM-3248 CRM-3869 CRM-4013 | |
10824d34 | 3 | |
6a488035 TO |
4 | {if $multilingual} |
5 | INSERT INTO civicrm_option_group (name, {foreach from=$locales item=locale}description_{$locale},{/foreach} is_reserved, is_active) VALUES ('mail_protocol', {foreach from=$locales item=locale}'Mail Protocol',{/foreach} 0, 1 ); | |
6 | {else} | |
7 | INSERT INTO civicrm_option_group (name, description, is_reserved, is_active ) VALUES ('mail_protocol', 'Mail Protocol', 0, 1 ); | |
8 | {/if} | |
10824d34 | 9 | |
6a488035 TO |
10 | UPDATE civicrm_option_group SET is_reserved = 0, is_active = 1 WHERE name IN( 'mail_protocol', 'visibility', 'greeting_type', 'phone_type' ); |
11 | UPDATE civicrm_option_group SET is_active = 1 WHERE name = 'encounter_medium'; | |
12 | SELECT @option_group_id_mp := max(id) from civicrm_option_group where name = 'mail_protocol'; | |
13 | ||
14 | {if $multilingual} | |
15 | INSERT INTO civicrm_option_value | |
16 | (option_group_id, {foreach from=$locales item=locale}label_{$locale},{/foreach} value, name, weight) VALUES | |
17 | (@option_group_id_mp, {foreach from=$locales item=locale}'IMAP',{/foreach} 1, 'IMAP', 1), | |
18 | (@option_group_id_mp, {foreach from=$locales item=locale}'Maildir',{/foreach} 2, 'Maildir', 2), | |
19 | (@option_group_id_mp, {foreach from=$locales item=locale}'POP3',{/foreach} 3, 'POP3', 3); | |
20 | {else} | |
21 | INSERT INTO civicrm_option_value | |
22 | (option_group_id, label, value, name, weight) VALUES | |
23 | (@option_group_id_mp, 'IMAP' , 1, 'IMAP', 1), | |
24 | (@option_group_id_mp, 'Maildir', 2, 'Maildir', 2), | |
25 | (@option_group_id_mp, 'POP3' , 3, 'POP3', 3); | |
26 | {/if} | |
27 | ||
10824d34 | 28 | ALTER TABLE `civicrm_domain` |
6a488035 TO |
29 | MODIFY version varchar(32) COMMENT 'The civicrm version this instance is running'; |
30 | ||
31 | -- CRM-3989 | |
32 | ALTER TABLE `civicrm_pcp_block` | |
33 | ADD notify_email varchar(255) DEFAULT NULL COMMENT 'If set, notification is automatically emailed to this email-address on create/update Personal Campaign Page'; | |
34 | ||
35 | -- PCP userDashboard Option | |
36 | ||
37 | SELECT @option_group_id_udOpt := max(id) from civicrm_option_group where name = 'user_dashboard_options'; | |
38 | SELECT @maxValue := max(value) from civicrm_option_value where option_group_id=@option_group_id_udOpt ; | |
39 | ||
40 | {if $multilingual} | |
10824d34 | 41 | INSERT INTO civicrm_option_value |
6a488035 TO |
42 | (option_group_id, {foreach from=$locales item=locale}label_{$locale},{/foreach} value, name, weight, is_reserved, is_active) VALUES |
43 | (@option_group_id_udOpt, {foreach from=$locales item=locale}'Personal Campaign Pages',{/foreach} @maxValue + 1,'PCP', @maxValue + 1, 0, 1); | |
44 | {else} | |
45 | INSERT INTO civicrm_option_value | |
46 | (option_group_id, label, value, name, weight, is_reserved, is_active) VALUES | |
47 | (@option_group_id_udOpt, 'Personal Campaign Pages', @maxValue + 1, 'PCP', @maxValue + 1, 0, 1 ); | |
48 | {/if} | |
49 | ||
50 | -- PCP Status Option Group | |
51 | {if $multilingual} | |
10824d34 | 52 | INSERT INTO civicrm_option_group |
53 | (name, {foreach from=$locales item=locale}description_{$locale},{/foreach} is_reserved, is_active) VALUES | |
6a488035 TO |
54 | ('pcp_status', {foreach from=$locales item=locale}'PCP Status',{/foreach} 0, 1); |
55 | ||
56 | SELECT @option_group_id_pcp := max(id) from civicrm_option_group where name = 'pcp_status'; | |
10824d34 | 57 | |
6a488035 TO |
58 | INSERT INTO civicrm_option_value |
59 | (option_group_id, {foreach from=$locales item=locale}label_{$locale},{/foreach} value, name, weight, is_reserved, is_active) VALUES | |
60 | (@option_group_id_pcp, {foreach from=$locales item=locale}'Waiting Review',{/foreach} 1, 'Waiting Review', 1, 1, 1 ), | |
61 | (@option_group_id_pcp, {foreach from=$locales item=locale}'Approved',{/foreach} 2, 'Approved', 2, 1, 1 ), | |
62 | (@option_group_id_pcp, {foreach from=$locales item=locale}'Not Approved',{/foreach} 3, 'Not Approved', 3, 1, 1 ); | |
63 | {else} | |
10824d34 | 64 | INSERT INTO civicrm_option_group |
6a488035 TO |
65 | ( name, description, is_reserved, is_active) VALUES |
66 | ('pcp_status','PCP Status', 0, 1 ); | |
67 | ||
68 | SELECT @option_group_id_pcp := max(id) from civicrm_option_group where name = 'pcp_status'; | |
69 | ||
10824d34 | 70 | INSERT INTO civicrm_option_value |
6a488035 TO |
71 | (option_group_id, label, value, name, weight, is_reserved, is_active) VALUES |
72 | (@option_group_id_pcp, 'Waiting Review', 1, 'Waiting Review', 1, 1, 1 ), | |
73 | (@option_group_id_pcp, 'Approved' , 2, 'Approved' , 2, 1, 1 ), | |
74 | (@option_group_id_pcp, 'Not Approved' , 3, 'Not Approved' , 3, 1, 1 ); | |
75 | {/if} |