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,
latitude, longitude, countryId, type)
- SELECT uid, entrid, 0, postcode, adr_pub, NULL, glat, glng,
- IF(country = '' OR country = '00', NULL, country), 'job'
- FROM #x4dat#.entreprises;
+ SELECT e.uid, j.id, e.entrid, e.postcode, e.adr_pub, NULL, e.glat, e.glng,
+ IF(e.country = '' OR e.country = '00', NULL, e.country), 'job'
+ FROM #x4dat#.entreprises AS e
+ INNER JOIN profile_job_enum AS j ON (e.entreprise = j.name);
DROP TABLE IF EXISTS geoloc_countries;
CREATE TABLE geoloc_countries (