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

   1 {* file to handle db changes in 4.7.1 during upgrade *}
   2 # CRM-17852 - Misspeled state names in Estonia/Lithuania
   3
   4 #Estonia
   5 UPDATE civicrm_state_province SET name = 'Harjumaa' where id = 2376;
   6 UPDATE civicrm_state_province SET name = 'Hiiumaa' where id = 2377;
   7 UPDATE civicrm_state_province SET name = 'Ida-Virumaa' where id = 2378;
   8 UPDATE civicrm_state_province SET name = 'Jõgevamaa' where id = 2379;
   9 UPDATE civicrm_state_province SET name = 'Järvamaa' where id = 2380;
  10 UPDATE civicrm_state_province SET name = 'Läänemaa' where id = 2381;
  11 UPDATE civicrm_state_province SET name = 'Lääne-Virumaa' where id = 2382;
  12 UPDATE civicrm_state_province SET name = 'Põlvamaa' where id = 2383;
  13 UPDATE civicrm_state_province SET name = 'Pärnumaa' where id = 2384;
  14 UPDATE civicrm_state_province SET name = 'Raplamaa' where id = 2385;
  15 UPDATE civicrm_state_province SET name = 'Saaremaa' where id = 2386;
  16 UPDATE civicrm_state_province SET name = 'Tartumaa' where id = 2387;
  17 UPDATE civicrm_state_province SET name = 'Viljandimaa' where id = 2389;
  18 UPDATE civicrm_state_province SET name = 'Võrumaa' where id = 2390;
  19
  20 #Lithuania
  21 UPDATE civicrm_state_province SET name = 'Klaipėdos Apskritis' where id = 3514;
  22 UPDATE civicrm_state_province SET name = 'Marijampolės Apskritis' where id = 3515;
  23 UPDATE civicrm_state_province SET name = 'Panevėžio Apskritis' where id = 3516;
  24 UPDATE civicrm_state_province SET name = 'Šiaulių Apskritis' where id = 3517;
  25 UPDATE civicrm_state_province SET name = 'Tauragės Apskritis' where id = 3518;
  26 UPDATE civicrm_state_province SET name = 'Telšių Apskritis' where id = 3519;