X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2Fnewdirectory-0.0.1%2F04_telephone.sql;h=dc091898ba2c50d548a289c05df8ab461ca58595;hb=950bf4f677e923c34f7d1523215f06876e338717;hp=bff48ee349f30b3668de12b9d76b00194405f5d6;hpb=40214aa65f590952c7bb2a586d6d0a9446b3c0e7;p=platal.git

diff --git a/upgrade/newdirectory-0.0.1/04_telephone.sql b/upgrade/newdirectory-0.0.1/04_telephone.sql
index bff48ee..dc09189 100644
--- a/upgrade/newdirectory-0.0.1/04_telephone.sql
+++ b/upgrade/newdirectory-0.0.1/04_telephone.sql
@@ -11,7 +11,7 @@ CREATE TABLE IF NOT EXISTS `profile_phones` (
     PRIMARY KEY(`uid`, `link_type`, `link_id`, `tel_id`),
     INDEX (`search_tel`),
     INDEX uid (uid)
-);
+) ENGINE=InnoDB, CHARSET=utf8;
 
 
 -- Adds a temporary column to convert phone prefixes from varchar to int