1 {* file to handle db changes in 4.6.0 during upgrade *}
3 --CRM-16148 add missing option names
4 SELECT @option_group_id_pcm := max(id) from civicrm_option_group where name = 'preferred_communication_method';
5 SELECT @option_group_id_notePrivacy := max(id) from civicrm_option_group where name = 'note_privacy';
7 UPDATE civicrm_option_value
9 WHERE option_group_id = @option_group_id_pcm AND value = 1;
10 UPDATE civicrm_option_value
12 WHERE option_group_id = @option_group_id_pcm AND value = 2;
13 UPDATE civicrm_option_value
14 SET name = 'Postal Mail'
15 WHERE option_group_id = @option_group_id_pcm AND value = 3;
16 UPDATE civicrm_option_value
18 WHERE option_group_id = @option_group_id_pcm AND value = 4;
19 UPDATE civicrm_option_value
21 WHERE option_group_id = @option_group_id_pcm AND value = 5;
23 UPDATE civicrm_option_value
25 WHERE option_group_id = @option_group_id_notePrivacy AND value = 0;
26 UPDATE civicrm_option_value
27 SET name = 'Author Only'
28 WHERE option_group_id = @option_group_id_notePrivacy AND value = 1;
30 --These labels were never translated so just copy them over as names
32 UPDATE civicrm_option_value v, civicrm_option_group g
33 SET v.name = v.label_{$locales.0}
34 WHERE g.id = v.option_group_id AND g.name IN
35 ('group_type', 'safe_file_extension', 'wysiwyg_editor');
37 UPDATE civicrm_option_value v, civicrm_option_group g
39 WHERE g.id = v.option_group_id AND g.name IN
40 ('group_type', 'safe_file_extension', 'wysiwyg_editor');
43 --This one is weird. What the heck is this anyway?
44 UPDATE civicrm_option_value v, civicrm_option_group g
46 WHERE g.id = v.option_group_id AND g.name = 'redaction_rule';