X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2Fnewdirectory-0.0.1%2F08_nationalities.sql;h=439ba606d58a9980da1dcb0e508f874e935eed76;hb=d0293d9bdccabb68ee4bb9a3915101cf682439f1;hp=247c102e1299a11b884258b607a93b3ca88ea877;hpb=f875fdc7a9cd2b879598a1e0ac0cb73456e4e809;p=platal.git

diff --git a/upgrade/newdirectory-0.0.1/08_nationalities.sql b/upgrade/newdirectory-0.0.1/08_nationalities.sql
index 247c102..439ba60 100644
--- a/upgrade/newdirectory-0.0.1/08_nationalities.sql
+++ b/upgrade/newdirectory-0.0.1/08_nationalities.sql
@@ -1,11 +1,12 @@
 ALTER TABLE geoloc_pays ADD COLUMN license_plate CHAR(4) DEFAULT NULL;
+DROP TABLE IF EXISTS tmp_update_geoloc_pays;
 
 CREATE TEMPORARY TABLE IF NOT EXISTS tmp_update_geoloc_pays (
   a2 CHAR(2) DEFAULT NULL,
   code CHAR(4) DEFAULT NULL,
   PRIMARY KEY(a2),
   UNIQUE KEY(code)
-) CHARSET=utf8;
+) ENGINE=InnoDB, CHARSET=utf8;
 
 INSERT IGNORE INTO  tmp_update_geoloc_pays (a2, code)
             VALUES  ('AF', 'AFG'),