X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2F1.0.2%2F06_geocoding.sql;h=871b20e3a3ac842210e19570c5d68047cb6b4b45;hb=69d311a9e667ba071af1070cfe9a6906a4f0ed32;hp=3d55e15258e8af8ac6081af3683fd72b38cb28fb;hpb=2d89ec936167033886ae76b153605d7ccf19bc20;p=platal.git diff --git a/upgrade/1.0.2/06_geocoding.sql b/upgrade/1.0.2/06_geocoding.sql index 3d55e15..871b20e 100644 --- a/upgrade/1.0.2/06_geocoding.sql +++ b/upgrade/1.0.2/06_geocoding.sql @@ -6,7 +6,6 @@ ALTER TABLE geoloc_countries CHANGE COLUMN country countryEn VARCHAR(255) DEFAUL ALTER TABLE geoloc_countries CHANGE COLUMN countryFR country VARCHAR(255) DEFAULT NULL; ALTER TABLE geoloc_countries CHANGE COLUMN nationality nationalityEn VARCHAR(255) DEFAULT NULL; ALTER TABLE geoloc_countries CHANGE COLUMN nationalityFR nationality VARCHAR(255) DEFAULT NULL; -ALTER TABLE geoloc_countries ADD COLUMN countryLocal VARCHAR(255) DEFAULT NULL; ALTER TABLE geoloc_countries ADD COLUMN countryPlain VARCHAR(255) DEFAULT NULL; INSERT INTO geoloc_countries (iso_3166_1_a2, iso_3166_1_a3, iso_3166_1_num, worldRegion,