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

diff --git a/upgrade/newdirectory-0.0.1/04_telephone.sql b/upgrade/newdirectory-0.0.1/04_telephone.sql
index f415a79..dc09189 100644
--- a/upgrade/newdirectory-0.0.1/04_telephone.sql
+++ b/upgrade/newdirectory-0.0.1/04_telephone.sql
@@ -9,8 +9,9 @@ CREATE TABLE IF NOT EXISTS `profile_phones` (
     `pub` enum('private', 'ax', 'public') NOT NULL DEFAULT 'private',
     `comment` varchar(80) NOT NULL,
     PRIMARY KEY(`uid`, `link_type`, `link_id`, `tel_id`),
-    INDEX (`search_tel`)
-);
+    INDEX (`search_tel`),
+    INDEX uid (uid)
+) ENGINE=InnoDB, CHARSET=utf8;
 
 
 -- Adds a temporary column to convert phone prefixes from varchar to int
@@ -19,3 +20,4 @@ ALTER TABLE `geoloc_pays` ADD COLUMN `tmp_phoneprf` smallint unsigned NULL;
 -- Adds phone format column
 ALTER TABLE `geoloc_pays` ADD COLUMN `phoneformat` varchar(25) NOT NULL AFTER `nat`;
 
+# vim:set syntax=mysql: