Commit | Line | Data |
---|---|---|
c060946e | 1 | {* file to handle db changes in 4.6.0 during upgrade *} |
2e26e3ba CW |
2 | |
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'; | |
6 | ||
7 | UPDATE civicrm_option_value | |
8 | SET name = 'Phone' | |
9 | WHERE option_group_id = @option_group_id_pcm AND value = 1; | |
10 | UPDATE civicrm_option_value | |
11 | SET name = 'Email' | |
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 | |
17 | SET name = 'SMS' | |
18 | WHERE option_group_id = @option_group_id_pcm AND value = 4; | |
19 | UPDATE civicrm_option_value | |
20 | SET name = 'Fax' | |
21 | WHERE option_group_id = @option_group_id_pcm AND value = 5; | |
22 | ||
23 | UPDATE civicrm_option_value | |
24 | SET name = 'None' | |
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; | |
29 | ||
30 | --These labels were never translated so just copy them over as names | |
928e011e | 31 | {if $multilingual} |
55e590cf | 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'); | |
928e011e | 36 | {else} |
37 | UPDATE civicrm_option_value v, civicrm_option_group g | |
55e590cf | 38 | SET v.name = v.label |
928e011e | 39 | WHERE g.id = v.option_group_id AND g.name IN |
40 | ('group_type', 'safe_file_extension', 'wysiwyg_editor'); | |
41 | {/if} | |
2e26e3ba | 42 | |
b44e3f84 | 43 | --This one is weird. What the heck is this anyway? |
2e26e3ba CW |
44 | UPDATE civicrm_option_value v, civicrm_option_group g |
45 | SET v.name = v.value | |
928e011e | 46 | WHERE g.id = v.option_group_id AND g.name = 'redaction_rule'; |