Commit | Line | Data |
---|---|---|
6a488035 TO |
1 | -- CRM-6148 |
2 | {include file='../CRM/Upgrade/3.1.5.msg_template/civicrm_msg_template.tpl'} | |
3 | ||
4 | -- CRM-6156 | |
10824d34 | 5 | -- Update the names of several existing Taiwan provinces |
6a488035 TO |
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 | ||
10824d34 | 24 | -- Create additional Taiwan provinces |
6a488035 | 25 | SELECT @country_id := id from civicrm_country where name = 'Taiwan'; |
cff67e98 | 26 | INSERT IGNORE INTO civicrm_state_province ( country_id, abbreviation, name ) VALUES |
6a488035 TO |
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' ), | |
cff67e98 EM |
32 | ( @country_id, 'TNN', 'Tainan City' ); |
33 |