Fix import scripts.

[platal.git] / upgrade / newdirectory-0.0.1 / 08_nationalities.sql

diff --git a/upgrade/newdirectory-0.0.1/08_nationalities.sql b/upgrade/newdirectory-0.0.1/08_nationalities.sql
index 247c102..439ba60 100644 (file)
--- 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'),