From b6a1f9f5eee0693dd1bd5fdcb7b1cf6adcbaaf3e Mon Sep 17 00:00:00 2001 From: yashodha Date: Wed, 16 Dec 2015 11:23:38 +0530 Subject: [PATCH] get rid of auto-incremented column id --- CRM/Upgrade/Incremental/sql/4.7.beta3.mysql.tpl | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/CRM/Upgrade/Incremental/sql/4.7.beta3.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.7.beta3.mysql.tpl index 3251b5628e..a2ca323fa4 100644 --- a/CRM/Upgrade/Incremental/sql/4.7.beta3.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/4.7.beta3.mysql.tpl @@ -1,8 +1,8 @@ {* file to handle db changes in 4.7.beta3 during upgrade *} -- CRM-17660 Add missing Cameroon Provinces and add missing Indian province. -INSERT INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES -(NULL, 1038, "LT", "Littoral"), -(NULL, 1038, "NW", "Nord-Ouest"), -(NULL, 1101, "TG", "Telangana"); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES +(1038, "LT", "Littoral"), +(1038, "NW", "Nord-Ouest"), +(1101, "TG", "Telangana"); -- 2.25.1