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

   1 -- CRM-6148
   2    {include file='../CRM/Upgrade/3.1.5.msg_template/civicrm_msg_template.tpl'}
   3
   4 -- CRM-6156
   5 -- Update the names of several existing Taiwan provinces
   6 UPDATE civicrm_state_province SET name = 'Changhua County'  WHERE id = 4848;
   7 UPDATE civicrm_state_province SET name = 'Chiayi County'    WHERE id = 4849;
   8 UPDATE civicrm_state_province SET name = 'Hsinchu County'   WHERE id = 4850;
   9 UPDATE civicrm_state_province SET name = 'Hualien County'   WHERE id = 4851;
  10 UPDATE civicrm_state_province SET name = 'Ilan County'      WHERE id = 4852;
  11 UPDATE civicrm_state_province SET name = 'Kaohsiung County' WHERE id = 4853;
  12 UPDATE civicrm_state_province SET name = 'Miaoli County'    WHERE id = 4854;
  13 UPDATE civicrm_state_province SET name = 'Nantou County'    WHERE id = 4855;
  14 UPDATE civicrm_state_province SET name = 'Penghu County'    WHERE id = 4856;
  15 UPDATE civicrm_state_province SET name = 'Pingtung County'  WHERE id = 4857;
  16 UPDATE civicrm_state_province SET name = 'Taichung County'  WHERE id = 4858;
  17 UPDATE civicrm_state_province SET name = 'Tainan County'    WHERE id = 4859;
  18 UPDATE civicrm_state_province SET name = 'Taipei County'    WHERE id = 4860;
  19 UPDATE civicrm_state_province SET name = 'Taitung County'   WHERE id = 4861;
  20 UPDATE civicrm_state_province SET name = 'Taoyuan County'   WHERE id = 4862;
  21 UPDATE civicrm_state_province SET name = 'Yunlin Conuty'    WHERE id = 4863;
  22 UPDATE civicrm_state_province SET name = 'Keelung City'     WHERE id = 4864;
  23
  24 -- Create additional Taiwan provinces
  25 SELECT @country_id := id from civicrm_country where name = 'Taiwan';
  26 INSERT IGNORE INTO civicrm_state_province ( country_id, abbreviation, name ) VALUES
  27 ( @country_id, 'TXG', 'Taichung City'  ),
  28 ( @country_id, 'KHH', 'Kaohsiung City' ),
  29 ( @country_id, 'TPE', 'Taipei City'    ),
  30 ( @country_id, 'CYI', 'Chiayi City'    ),
  31 ( @country_id, 'HSZ', 'Hsinchu City'   ),
  32 ( @country_id, 'TNN', 'Tainan City'    );
  33