From 9e64234f4b78413b94b0fc2173ea13745a88f986 Mon Sep 17 00:00:00 2001 From: =?utf8?q?St=C3=A9phane=20Jacob?= Date: Wed, 18 May 2011 15:21:17 +0200 Subject: [PATCH] Do not change the id. MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Signed-off-by: Stéphane Jacob --- upgrade/1.1.2/xx_retrieve_geocoding.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/upgrade/1.1.2/xx_retrieve_geocoding.sql b/upgrade/1.1.2/xx_retrieve_geocoding.sql index 95da5cd..c239207 100644 --- a/upgrade/1.1.2/xx_retrieve_geocoding.sql +++ b/upgrade/1.1.2/xx_retrieve_geocoding.sql @@ -1,6 +1,6 @@ UPDATE profile_addresses AS pa INNER JOIN tmp_profile_addresses AS ta ON (pa.pid = ta.pid AND pa.jobid = ta.jobid AND pa.groupid = ta.groupid AND pa.type = ta.type AND pa.text = ta.text) - SET pa.id = ta.id, pa.postalText = ta.postalText, pa.formatted_address = ta.formatted_address, pa.types = ta.types, + SET pa.postalText = ta.postalText, pa.formatted_address = ta.formatted_address, pa.types = ta.types, pa.latitude = ta.latitude, pa.longitude = ta.longitude, pa.southwest_latitude = ta.southwest_latitude, pa.southwest_longitude = ta.southwest_longitude, pa.northeast_latitude = ta.northeast_latitude, pa.northeast_longitude = ta.northeast_longitude, pa.location_type = ta.location_type, pa.partial_match = ta.partial_match, -- 2.1.4