+INSERT INTO profile_addresses (pid, jobid, id, postalCode, pub, comment,
+ latitude, longitude, countryId, type)
+ 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 (