-INSERT INTO profile_addresses (pid, id, postalCode, updateTime, pub, comment, latitude, longitude, countryId,
- type, flags)
- SELECT uid, adrid, postcode, datemaj, pub, NULL, glat, glng, country,
+INSERT INTO profile_addresses (pid, id, postalCode, updateTime, pub, comment, latitude, longitude,
+ countryId, type, flags)
+ SELECT uid, adrid, postcode, datemaj, pub, NULL, glat, glng, IF(country = '' OR country = '00', NULL, country),