Commit | Line | Data |
---|---|---|
01c2b2e1 | 1 | {* file to handle db changes in 5.26.alpha1 during upgrade *} |
2cd5d411 | 2 | |
0298dd55 CW |
3 | ALTER TABLE civicrm_option_value MODIFY COLUMN `filter` int unsigned DEFAULT NULL COMMENT 'Bitwise logic can be used to create subsets of options within an option_group for different uses.'; |
4 | ||
2cd5d411 MM |
5 | UPDATE civicrm_contact SET is_deceased = 0 WHERE is_deceased IS NULL; |
6 | ALTER TABLE civicrm_contact MODIFY COLUMN is_deceased TINYINT NOT NULL DEFAULT 0; | |
b986bcd5 PN |
7 | |
8 | -- Update Colmbra state/province to Coimbra | |
9 | UPDATE civicrm_state_province s | |
10 | INNER JOIN civicrm_country c | |
11 | on c.id = s.country_id AND c.name = 'Portugal' | |
12 | AND s.name = 'Colmbra' | |
13 | SET s.name = 'Coimbra'; | |
e6d79560 | 14 | |
15 | UPDATE civicrm_state_province s | |
16 | INNER JOIN civicrm_country c | |
17 | on c.id = s.country_id AND c.name = 'Portugal' | |
18 | AND s.name = 'Braganca' | |
19 | SET s.name = 'Bragança'; | |
20 | ||
21 | UPDATE civicrm_state_province s | |
22 | INNER JOIN civicrm_country c | |
23 | on c.id = s.country_id AND c.name = 'Portugal' | |
24 | AND s.name = 'Ovora' | |
25 | SET s.name = 'Évora'; | |
26 | ||
27 | UPDATE civicrm_state_province s | |
28 | INNER JOIN civicrm_country c | |
29 | on c.id = s.country_id AND c.name = 'Portugal' | |
30 | AND s.name = 'Santarem' | |
31 | SET s.name = 'Santarém'; | |
32 | ||
33 | UPDATE civicrm_state_province s | |
34 | INNER JOIN civicrm_country c | |
35 | on c.id = s.country_id AND c.name = 'Portugal' | |
36 | AND s.name = 'Setubal' | |
37 | SET s.name = 'Setúbal'; | |
38 | ||
39 | UPDATE civicrm_state_province s | |
40 | INNER JOIN civicrm_country c | |
41 | on c.id = s.country_id AND c.name = 'Portugal' | |
42 | AND s.name = 'Regiao Autonoma dos Acores' | |
43 | SET s.name = 'Região Autónoma dos Açores'; | |
44 | ||
45 | UPDATE civicrm_state_province s | |
46 | INNER JOIN civicrm_country c | |
47 | on c.id = s.country_id AND c.name = 'Portugal' | |
48 | AND s.name = 'Regiao Autonoma da Madeira' | |
49 | SET s.name = 'Região Autónoma da Madeira'; |