projects / civicrm-core.git / blame
| Commit | Line | Data |
|---|---|---|
| 36610486 | 1 | {* file to handle db changes in 4.7.18 during upgrade *} |
| 2 | ||
| 3 | -- CRM-20062 New counties of Kenya. | |
| 4 | SELECT @country_id := max(id) from civicrm_country where iso_code = "KE"; | |
| 5 | INSERT IGNORE INTO civicrm_state_province (country_id, abbreviation, name) VALUES | |
| 6 | (@country_id, "01", "Baringo"), | |
| 7 | (@country_id, "02", "Bomet"), | |
| 8 | (@country_id, "03", "Bungoma"), | |
| 9 | (@country_id, "04", "Busia"), | |
| 10 | (@country_id, "05", "Elgeyo/Marakwet"), | |
| 11 | (@country_id, "06", "Embu"), | |
| 12 | (@country_id, "07", "Garissa"), | |
| 13 | (@country_id, "08", "Homa Bay"), | |
| 14 | (@country_id, "09", "Isiolo"), | |
| 15 | (@country_id, "10", "Kajiado"), | |
| 16 | (@country_id, "11", "Kakamega"), | |
| 17 | (@country_id, "12", "Kericho"), | |
| 18 | (@country_id, "13", "Kiambu"), | |
| 19 | (@country_id, "14", "Kilifi"), | |
| 20 | (@country_id, "15", "Kirinyaga"), | |
| 21 | (@country_id, "16", "Kisii"), | |
| 22 | (@country_id, "17", "Kisumu"), | |
| 23 | (@country_id, "18", "Kitui"), | |
| 24 | (@country_id, "19", "Kwale"), | |
| 25 | (@country_id, "20", "Laikipia"), | |
| 26 | (@country_id, "21", "Lamu"), | |
| 27 | (@country_id, "22", "Machakos"), | |
| 28 | (@country_id, "23", "Makueni"), | |
| 29 | (@country_id, "24", "Mandera"), | |
| 30 | (@country_id, "25", "Marsabit"), | |
| 31 | (@country_id, "26", "Meru"), | |
| 32 | (@country_id, "27", "Migori"), | |
| 33 | (@country_id, "28", "Mombasa"), | |
| 34 | (@country_id, "29", "Murang'a"), | |
| 35 | (@country_id, "30", "Nairobi City"), | |
| 36 | (@country_id, "31", "Nakuru"), | |
| 37 | (@country_id, "32", "Nandi"), | |
| 38 | (@country_id, "33", "Narok"), | |
| 39 | (@country_id, "34", "Nyamira"), | |
| 40 | (@country_id, "35", "Nyandarua"), | |
| 41 | (@country_id, "36", "Nyeri"), | |
| 42 | (@country_id, "37", "Samburu"), | |
| 43 | (@country_id, "38", "Siaya"), | |
| 44 | (@country_id, "39", "Taita/Taveta"), | |
| 45 | (@country_id, "40", "Tana River"), | |
| 46 | (@country_id, "41", "Tharaka-Nithi"), | |
| 47 | (@country_id, "42", "Trans Nzoia"), | |
| 48 | (@country_id, "43", "Turkana"), | |
| 49 | (@country_id, "44", "Uasin Gishu"), | |
| 50 | (@country_id, "45", "Vihiga"), | |
| 51 | (@country_id, "46", "Wajir"), | |
| 52 | (@country_id, "47", "West Pokot"); | |
| 53 | ||
| 7b5908f7 J |
54 | -- CRM-19993 Fixes for ISO compliance with countries and counties |
| 55 | INSERT INTO `civicrm_state_province` (`id`, `country_id`, `abbreviation`, `name`) VALUES | |
| 56 | (NULL, 1101, "CH", "Chandigarh"), | |
| 57 | (NULL, 1083, "CP", "Central"), | |
| 58 | (NULL, 1083, "EP", "Eastern"), | |
| 59 | (NULL, 1083, "NP", "Northern"), | |
| 60 | (NULL, 1083, "WP", "Western"), | |
| 61 | (NULL, 1181, "K", "Saint Kitts"), | |
| 62 | (NULL, 1181, "N", "Nevis"), | |
| 63 | (NULL, 1190, "E", "Eastern"), | |
| 64 | (NULL, 1190, "N", "Northern"), | |
| 65 | (NULL, 1190, "S", "Southern"); | |
| 66 | ||
| 67 | UPDATE `civicrm_state_province` SET `name`='Uttarakhand', `abbreviation`='UT' WHERE `name` = 'Uttaranchal' AND `abbreviation`='UL'; | |
| 68 | UPDATE `civicrm_state_province` SET `name`='Yunlin County' WHERE `name` = 'Yunlin Conuty'; | |
| 69 | UPDATE `civicrm_country` SET `name`='Palestine, State of' WHERE `name` = 'Palestinian Territory'; | |
| 70 | UPDATE `civicrm_country` SET `name`='Virgin Islands, British' WHERE `name` = 'Virgin Islands,British'; | |
| 335dc92d | 71 | |
| 60a5e820 CW |
72 | -- CRM-20102 make case_type_id required |
| 73 | ALTER TABLE `civicrm_case` DROP FOREIGN KEY `FK_civicrm_case_case_type_id`; | |
| 74 | ALTER TABLE `civicrm_case` MODIFY `case_type_id` int(10) unsigned NOT NULL COMMENT 'FK to civicrm_case_type.id'; | |
| 75 | ALTER TABLE `civicrm_case` ADD CONSTRAINT `FK_civicrm_case_case_type_id` FOREIGN KEY (`case_type_id`) REFERENCES `civicrm_case_type` (`id`); | |
| 76 | ||
| 335dc92d | 77 | --- CRM-19715 Remove Close Accounting Period code - now in an extension. |
| 78 | DELETE FROM civicrm_navigation | |
| 79 | WHERE url = 'civicrm/admin/contribute/closeaccperiod?reset=1' AND name = 'Close Accounting Period'; |