INDEX administrativeAreaId (administrativeAreaId),
INDEX subAdministrativeAreaId (subAdministrativeAreaId),
INDEX countryId (countryId)
-) CHARSET=utf8;
+) ENGINE=InnoDB, CHARSET=utf8;
INSERT INTO profile_addresses (pid, id, postalCode, updateTime, pub, comment, latitude, longitude, countryId,
type, flags)
IF(FIND_IN_SET('courrier', 'statut'), 'mail,', ''),
IF(FIND_IN_SET('active', 'statut'), 'current,', ''),
IF(FIND_IN_SET('temporaire', 'statut'), 'temporary', ''))
- FROM adresses;
+ FROM #x4dat#.adresses;
CREATE TABLE IF NOT EXISTS geoloc_countries (
iso_3166_1_a2 CHAR(2) NOT NULL,
UNIQUE KEY(iso_3166_1_num),
INDEX(iso_3166_1_a2),
INDEX(phonePrefix)
-) CHARSET=utf8;
+) ENGINE=InnoDB, CHARSET=utf8;
UPDATE geoloc_pays
SET n3 = 450
phonePrefix, phoneFormat, licensePlate)
SELECT a2, a3, n3, worldrgn, pays, country, capital, nat, phoneprf, phoneformat, license_plate
FROM geoloc_pays;
+DROP TABLE geoloc_pays;
CREATE TABLE IF NOT EXISTS geoloc_administrativeareas (
id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
INDEX(id),
INDEX(name),
INDEX(country)
-) CHARSET=utf8;
+) ENGINE=InnoDB, CHARSET=utf8;
CREATE TABLE IF NOT EXISTS geoloc_subadministrativeareas (
id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
INDEX(id),
INDEX(name),
INDEX(country)
-) CHARSET=utf8;
+) ENGINE=InnoDB, CHARSET=utf8;
CREATE TABLE IF NOT EXISTS geoloc_localities (
id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
INDEX(id),
INDEX(name),
INDEX(country)
-) CHARSET=utf8;
+) ENGINE=InnoDB, CHARSET=utf8;
-- vim:set syntax=mysql: