Update update.sh

[platal.git] / upgrade / newdirectory-0.0.1 / 13_mentoring.sql

diff --git a/upgrade/newdirectory-0.0.1/13_mentoring.sql b/upgrade/newdirectory-0.0.1/13_mentoring.sql
index dbd8127..9191616 100644 (file)
--- a/upgrade/newdirectory-0.0.1/13_mentoring.sql
+++ b/upgrade/newdirectory-0.0.1/13_mentoring.sql
@@ -11,23 +11,25 @@ CREATE TABLE IF NOT EXISTS profile_mentor (
 
 INSERT INTO  profile_mentor (uid, expertise)
      SELECT  uid, expertise
-       FROM  mentor;
+       FROM  #x4dat#.mentor;
 
 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)
      SELECT  uid, pid
-       FROM  mentor_pays;
+       FROM  #x4dat#.mentor_pays;
 
 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: