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

   1 -- http://forum.civicrm.org/?topic=12481
   2 UPDATE civicrm_state_province SET name = 'Guizhou' WHERE name = 'Gulzhou';
   3
   4 -- CRM-5824
   5 {if $multilingual}
   6     UPDATE civicrm_option_value ov
   7 INNER JOIN civicrm_option_group og ON ( og.id = ov.option_group_id )
   8        SET ov.name = ov.label_{$config->lcMessages}
   9      WHERE og.name = 'case_type'
  10        AND ov.name IS NULL;
  11 {else}
  12     UPDATE civicrm_option_value ov
  13 INNER JOIN civicrm_option_group og ON ( og.id = ov.option_group_id )
  14        SET ov.name = ov.label
  15      WHERE og.name = 'case_type'
  16        AND ov.name IS NULL;
  17 {/if}
  18
  19 -- CRM-6008
  20 {if $multilingual}
  21 INSERT INTO civicrm_membership_status
  22     ({localize field='name'}`name`{/localize}, `start_event`, `end_event`, `is_current_member`, `is_admin`, `weight`, `is_default`, `is_active`, `is_reserved`)
  23     (SELECT {localize}'Pending'{/localize}, 'join_date', 'join_date', 0, 0, 5, 0, 1, 1 FROM dual
  24      WHERE NOT EXISTS (SELECT * FROM civicrm_membership_status WHERE `name_{$config->lcMessages}` = 'Pending'));
  25
  26  UPDATE `civicrm_membership_status` SET `is_reserved` = 1 WHERE `name_{$config->lcMessages}` = 'Pending';
  27 {else}
  28  INSERT INTO civicrm_membership_status
  29    (`name`, `start_event`, `end_event`, `is_current_member`, `is_admin`, `weight`, `is_default`, `is_active`, `is_reserved`)
  30     (SELECT 'Pending', 'join_date', 'join_date', 0, 0, 5, 0, 1, 1 FROM dual
  31      WHERE NOT EXISTS (SELECT * FROM civicrm_membership_status WHERE name = 'Pending'));
  32   UPDATE `civicrm_membership_status` SET `is_reserved` = 1 WHERE `name` = 'Pending';
  33 {/if}