From 68f434ea31c2e427f625e2006d176fabf4b57710 Mon Sep 17 00:00:00 2001 From: =?utf8?q?St=C3=A9phane=20Jacob?= Date: Thu, 24 Jun 2010 11:52:02 +0200 Subject: [PATCH] Fixes import of addresses flag (Closes #1150). MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Signed-off-by: Stéphane Jacob --- upgrade/newdirectory-0.0.1/15_addresses.sql | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/upgrade/newdirectory-0.0.1/15_addresses.sql b/upgrade/newdirectory-0.0.1/15_addresses.sql index 824e69a..8ce64b6 100644 --- a/upgrade/newdirectory-0.0.1/15_addresses.sql +++ b/upgrade/newdirectory-0.0.1/15_addresses.sql @@ -38,10 +38,10 @@ INSERT INTO profile_addresses (pid, id, postalCode, updateTime, pub, comment, l countryId, type, flags) SELECT uid, adrid, postcode, datemaj, pub, NULL, glat, glng, IF(country = '' OR country = '00', NULL, country), IF(FIND_IN_SET('pro', 'statut'), 'job', 'home'), - CONCAT(IF(FIND_IN_SET('res-secondaire', 'statut'), 'secondary,', ''), - IF(FIND_IN_SET('courrier', 'statut'), 'mail,', ''), - IF(FIND_IN_SET('active', 'statut'), 'current,', ''), - IF(FIND_IN_SET('temporaire', 'statut'), 'temporary', '')) + CONCAT(IF(FIND_IN_SET('res-secondaire', statut), 'secondary,', ''), + IF(FIND_IN_SET('courrier', statut), 'mail,', ''), + IF(FIND_IN_SET('active', statut), 'current,', ''), + IF(FIND_IN_SET('temporaire', statut), 'temporary', '')) FROM #x4dat#.adresses; INSERT INTO profile_addresses (pid, jobid, id, postalCode, pub, comment, -- 2.1.4