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

   1 {* file to handle db changes in 4.7.21 during upgrade *}
   2
   3 -- CRM-20606 (spelling mistake in Austrian provinces)
   4 UPDATE civicrm_state_province
   5    SET name = 'Niederösterreich'
   6  WHERE country_id = 1014
   7    AND name = 'Niederosterreich';
   8
   9 UPDATE civicrm_state_province
  10    SET name = 'Oberösterreich'
  11  WHERE country_id = 1014
  12    AND name = 'Oberosterreich';