Commit | Line | Data |
---|---|---|
59dbca94 | 1 | {* file to handle db changes in 4.7.28 during upgrade *} |
20039351 B |
2 | |
3 | -- CRM-21268 Missing French overseas departments. | |
59dbca94 | 4 | INSERT IGNORE INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES |
20039351 | 5 | (NULL, 1076, "WF", "Wallis-et-Futuna"), |
07b81c55 | 6 | (NULL, 1076, "NC", "Nouvelle-Calédonie"), |
09f58e1d SL |
7 | |
8 | -- CRM-21283 Add in missing parishes and regions of Barbados and Antigua and Barbuda | |
09f58e1d SL |
9 | (NULL, 1009, "03", "Saint George"), |
10 | (NULL, 1009, "04", "Saint John"), | |
11 | (NULL, 1009, "05", "Saint Mary"), | |
12 | (NULL, 1009, "06", "Saint Paul"), | |
13 | (NULL, 1009, "07", "Saint Peter"), | |
14 | (NULL, 1009, "08", "Saint Philip"), | |
15 | (NULL, 1009, "10", "Barbuda"), | |
16 | (NULL, 1009, "11", "Redonda"), | |
17 | (NULL, 1018, "01", "Christ Church"), | |
18 | (NULL, 1018, "02", "Saint Andrew"), | |
19 | (NULL, 1018, "03", "Saint George"), | |
20 | (NULL, 1018, "04", "Saint James"), | |
21 | (NULL, 1018, "05", "Saint John"), | |
22 | (NULL, 1018, "06", "Saint Joseph"), | |
23 | (NULL, 1018, "07", "Saint Lucy"), | |
24 | (NULL, 1018, "08", "Saint Michael"), | |
25 | (NULL, 1018, "09", "Saint Peter"), | |
26 | (NULL, 1018, "10", "Saint Philip"), | |
27 | (NULL, 1018, "11", "Saint Thomas"); | |
4922627d J |
28 | |
29 | -- CRM-21337 ISO compliance for Romanian and Bulgarian counties | |
30 | UPDATE `civicrm_state_province` SET `name` = 'Argeș' WHERE `name` = 'Arges' AND `country_id` = 1176; | |
31 | UPDATE `civicrm_state_province` SET `name` = 'Bacău' WHERE `name` = 'Bacau' AND `country_id` = 1176; | |
32 | UPDATE `civicrm_state_province` SET `name` = 'Bistrița-Năsăud' WHERE `name` = 'Bistrita-Nasaud' AND `country_id` = 1176; | |
33 | UPDATE `civicrm_state_province` SET `name` = 'Botoșani' WHERE `name` = 'Boto\'ani' AND `country_id` = 1176; | |
34 | UPDATE `civicrm_state_province` SET `name` = 'Brașov' WHERE `name` = 'Bra\'ov' AND `country_id` = 1176; | |
35 | UPDATE `civicrm_state_province` SET `name` = 'Brăila' WHERE `name` = 'Braila' AND `country_id` = 1176; | |
36 | UPDATE `civicrm_state_province` SET `name` = 'Buzău' WHERE `name` = 'Buzau' AND `country_id` = 1176; | |
37 | UPDATE `civicrm_state_province` SET `name` = 'Caraș-Severin' WHERE `name` = 'Caras-Severin' AND `country_id` = 1176; | |
38 | UPDATE `civicrm_state_province` SET `name` = 'Călărași' WHERE `name` = 'Ca la ras\'i' AND `country_id` = 1176; | |
39 | UPDATE `civicrm_state_province` SET `name` = 'Constanța' WHERE `name` = 'Constant\'a' AND `country_id` = 1176; | |
40 | UPDATE `civicrm_state_province` SET `name` = 'Dâmbovița' WHERE `name` = 'Dambovit\'a' AND `country_id` = 1176; | |
41 | UPDATE `civicrm_state_province` SET `name` = 'Galați' WHERE `name` = 'Galat\'i' AND `country_id` = 1176; | |
42 | UPDATE `civicrm_state_province` SET `name` = 'Ialomița' WHERE `name` = 'Ialomit\'a' AND `country_id` = 1176; | |
43 | UPDATE `civicrm_state_province` SET `name` = 'Iași' WHERE `name` = 'Ias\'i' AND `country_id` = 1176; | |
44 | UPDATE `civicrm_state_province` SET `name` = 'Maramureș' WHERE `name` = 'Maramures' AND `country_id` = 1176; | |
45 | UPDATE `civicrm_state_province` SET `name` = 'Mehedinți' WHERE `name` = 'Mehedint\'i' AND `country_id` = 1176; | |
46 | UPDATE `civicrm_state_province` SET `name` = 'Mureș' WHERE `name` = 'Mures' AND `country_id` = 1176; | |
47 | UPDATE `civicrm_state_province` SET `name` = 'Neamț' WHERE `name` = 'Neamt' AND `country_id` = 1176; | |
48 | UPDATE `civicrm_state_province` SET `name` = 'Sălaj' WHERE `name` = 'Sa laj' AND `country_id` = 1176; | |
49 | UPDATE `civicrm_state_province` SET `name` = 'Timiș' WHERE `name` = 'Timis' AND `country_id` = 1176; | |
50 | UPDATE `civicrm_state_province` SET `name` = 'Vâlcea' WHERE `name` = 'Valcea' AND `country_id` = 1176; | |
51 | UPDATE `civicrm_state_province` SET `name` = 'Pazardzhik' WHERE `name` = 'Pazardzik' AND `country_id` = 1033; | |
25e0f950 MW |
52 | |
53 | -- CRM-20772 Price set calculation precision when sales tax enabled | |
54 | ALTER TABLE `civicrm_membership_type` CHANGE `minimum_fee` `minimum_fee` DECIMAL(18,9) NULL DEFAULT '0.00' COMMENT 'Minimum fee for this membership (0 for free/complimentary memberships).'; | |
55 | ALTER TABLE `civicrm_price_field_value` CHANGE `amount` `amount` DECIMAL(18,9) NOT NULL COMMENT 'Price field option amount'; | |
288a5aae | 56 |