Commit | Line | Data |
---|---|---|
19402431 | 1 | {* file to handle db changes in 5.32.alpha1 during upgrade *} |
03c79b96 SM |
2 | |
3 | -- update italian provinces (pull request #18859) | |
4 | UPDATE civicrm_state_province s | |
5 | INNER JOIN civicrm_country c | |
6 | on c.id = s.country_id AND c.name = 'Italy' | |
7 | AND s.abbreviation = 'Bar' | |
8 | SET s.abbreviation = 'BT'; | |
9 | ||
10 | UPDATE civicrm_state_province s | |
11 | INNER JOIN civicrm_country c | |
12 | on c.id = s.country_id AND c.name = 'Italy' | |
13 | AND s.abbreviation = 'Fer' | |
14 | SET s.abbreviation = 'FM'; | |
15 | ||
16 | UPDATE civicrm_state_province s | |
17 | INNER JOIN civicrm_country c | |
18 | on c.id = s.country_id AND c.name = 'Italy' | |
19 | AND s.abbreviation = 'Mon' | |
20 | SET s.abbreviation = 'MB'; |