CRM/Upgrade/Incremental/sql/4.6.0.mysql.tpl

   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';