drupal-civicrm/sites/all/modules/civicrm/CRM/Upgrade/Incremental/sql/4.7.21.mysql.tpl

13 lines
355 B
Smarty
Raw Permalink Normal View History

2018-01-14 15:10:16 +02:00
{* file to handle db changes in 4.7.21 during upgrade *}
-- CRM-20606 (spelling mistake in Austrian provinces)
UPDATE civicrm_state_province
SET name = 'Niederösterreich'
WHERE country_id = 1014
AND name = 'Niederosterreich';
UPDATE civicrm_state_province
SET name = 'Oberösterreich'
WHERE country_id = 1014
AND name = 'Oberosterreich';