X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2Fnewdirectory-0.0.1%2F13_mentoring.sql;h=90987c1a325f64d748dda18fae036f9cf1657730;hb=a0ad593aec01fe6387ee83f3ef487bcdc3c3c5bd;hp=dbd81271e81aec4b35d91f29fb4f2e3aa15f5653;hpb=e8a898662eeafa5201082067a7aac46573884ebb;p=platal.git

diff --git a/upgrade/newdirectory-0.0.1/13_mentoring.sql b/upgrade/newdirectory-0.0.1/13_mentoring.sql
index dbd8127..90987c1 100644
--- a/upgrade/newdirectory-0.0.1/13_mentoring.sql
+++ b/upgrade/newdirectory-0.0.1/13_mentoring.sql
@@ -16,7 +16,8 @@ INSERT INTO  profile_mentor (uid, expertise)
 CREATE TABLE IF NOT EXISTS profile_mentor_country (
   uid INT(11) NOT NULL DEFAULT 0,
   country CHAR(2) NOT NULL DEFAULT "FR",
-  PRIMARY KEY (uid, country)
+  PRIMARY KEY (uid, country),
+  INDEX uid (uid)
 ) CHARSET=utf8;
 
 INSERT INTO  profile_mentor_country (uid, country)
@@ -27,7 +28,8 @@ CREATE TABLE IF NOT EXISTS profile_mentor_sector (
   uid INT(11) NOT NULL DEFAULT 0,
   sectorid TINYINT(2) UNSIGNED NOT NULL,
   subsectorid TINYINT(3) UNSIGNED NOT NULL,
-  PRIMARY KEY (uid, sectorid, subsectorid)
+  PRIMARY KEY (uid, sectorid, subsectorid),
+  INDEX uid (uid)
 ) CHARSET=utf8;
 
 -- vim:set syntax=mysql: