X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2Fnewdirectory-0.0.1%2F16_countries.sql;h=c12b9e97c89bcaebc7b22d5a37e095ff9b05289d;hb=5096676e03dcd626d6e64696cb9d6ee5d8e054da;hp=a302a0aa1d938379e31a368c2b97a6955a91a4b4;hpb=00ca0ad5370df5be4a0272364fb16a4385ffabfe;p=platal.git

diff --git a/upgrade/newdirectory-0.0.1/16_countries.sql b/upgrade/newdirectory-0.0.1/16_countries.sql
index a302a0a..c12b9e9 100644
--- a/upgrade/newdirectory-0.0.1/16_countries.sql
+++ b/upgrade/newdirectory-0.0.1/16_countries.sql
@@ -1,7 +1,7 @@
 ALTER TABLE geoloc_countries MODIFY COLUMN phoneFormat VARCHAR(255) NOT NULL DEFAULT "";
 
 DELETE FROM  geoloc_countries
-      WHERE  iso_3166_1_a2 = "TP" OR iso_3166_1_a2 = "YU";
+      WHERE  iso_3166_1_a2 = "TP" OR iso_3166_1_a2 = "YU" OR iso_3166_1_a2 = "00";
 
 INSERT INTO  geoloc_countries (iso_3166_1_a2, iso_3166_1_a3, iso_3166_1_num, worldRegion,
                                country, countryFR, capital, nationalityFR,
@@ -647,7 +647,7 @@ UPDATE  geoloc_countries
  WHERE  iso_3166_1_a2 = "PY";
 
 UPDATE  geoloc_countries
-   SET  nationalityFR = NULL, belongsTo = "US"
+   SET  nationalityFR = "Porto-ricain", belongsTo = "US"
  WHERE  iso_3166_1_a2 = "PR";
 
 UPDATE  geoloc_countries
@@ -659,7 +659,7 @@ UPDATE  geoloc_countries
  WHERE  iso_3166_1_a2 = "RW";
 
 UPDATE  geoloc_countries
-   SET  nationalityFR = NULL, capital = ""
+   SET  nationalityFR = "Saharien occidental", capital = ""
  WHERE  iso_3166_1_a2 = "EH";
 
 UPDATE  geoloc_countries