1 -- Do not make any changes to this file once alpha3 is tagged
2 -- CRM-3546 CRM-2105 CRM-3248 CRM-3869 CRM-4013
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 );
7 INSERT INTO civicrm_option_group (name, description, is_reserved, is_active ) VALUES ('mail_protocol', 'Mail Protocol', 0, 1 );
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';
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);
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);
28 ALTER TABLE `civicrm_domain`
29 MODIFY version varchar(32) COMMENT 'The civicrm version this instance is running';
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';
35 -- PCP userDashboard Option
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 ;
41 INSERT INTO civicrm_option_value
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);
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 );
50 -- PCP Status Option Group
52 INSERT INTO civicrm_option_group
53 (name, {foreach from=$locales item=locale}description_{$locale},{/foreach} is_reserved, is_active) VALUES
54 ('pcp_status', {foreach from=$locales item=locale}'PCP Status',{/foreach} 0, 1);
56 SELECT @option_group_id_pcp := max(id) from civicrm_option_group where name = 'pcp_status';
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 );
64 INSERT INTO civicrm_option_group
65 ( name, description, is_reserved, is_active) VALUES
66 ('pcp_status','PCP Status', 0, 1 );
68 SELECT @option_group_id_pcp := max(id) from civicrm_option_group where name = 'pcp_status';
70 INSERT INTO civicrm_option_value
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 );