| 1 | {* file to handle db changes in 4.6.0 during upgrade *} |
| 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 |
| 31 | {if $multilingual} |
| 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'); |
| 36 | {else} |
| 37 | UPDATE civicrm_option_value v, civicrm_option_group g |
| 38 | SET v.name = v.label |
| 39 | WHERE g.id = v.option_group_id AND g.name IN |
| 40 | ('group_type', 'safe_file_extension', 'wysiwyg_editor'); |
| 41 | {/if} |
| 42 | |
| 43 | --This one is weird. What the heck is this anyway? |
| 44 | UPDATE civicrm_option_value v, civicrm_option_group g |
| 45 | SET v.name = v.value |
| 46 | WHERE g.id = v.option_group_id AND g.name = 'redaction_rule'; |