CRM/Upgrade/Incremental/sql/4.7.alpha1.mysql.tpl

   1 {* file to handle db changes in 4.7.alpha1 during upgrade *}
   2
   3 -- CRM-16354
   4 SELECT @option_group_id_wysiwyg := max(id) from civicrm_option_group where name = 'wysiwyg_editor';
   5
   6 UPDATE civicrm_option_value SET name = 'Textarea', {localize field='label'}label = 'Textarea'{/localize}
   7   WHERE value = 1 AND option_group_id = @option_group_id_wysiwyg;
   8
   9 DELETE FROM civicrm_option_value WHERE name IN ('Joomla Default Editor', 'Drupal Default Editor')
  10   AND option_group_id = @option_group_id_wysiwyg;
  11
  12 UPDATE civicrm_option_value SET is_active = 1, is_reserved = 1 WHERE option_group_id = @option_group_id_wysiwyg;
  13
  14 --CRM-16719
  15 SELECT @option_group_id_report := max(id) from civicrm_option_group where name = 'report_template';
  16
  17 UPDATE civicrm_option_value SET {localize field="label"}label = 'Activity Details Report'{/localize}
  18   WHERE value = 'activity' AND option_group_id = @option_group_id_report;
  19
  20 UPDATE civicrm_option_value SET {localize field="label"}label = 'Activity Summary Report'{/localize}
  21   WHERE value = 'activitySummary' AND option_group_id = @option_group_id_report;