9e392fd211524e98fbf7239fb1275d7335e35ff3
1 DROP TABLE IF EXISTS profile_mentor
;
2 DROP TABLE IF EXISTS profile_mentor_country
;
3 DROP TABLE IF EXISTS profile_mentor_sector
;
5 CREATE TABLE IF NOT EXISTS profile_mentor (
6 uid
INT(11) NOT NULL DEFAULT 0,
7 expertise
TEXT NOT NULL,
9 FULLTEXT
INDEX (expertise
)
10 ) ENGINE
=InnoDB
, CHARSET
=utf8
;
12 INSERT INTO profile_mentor (uid
, expertise
)
16 CREATE TABLE IF NOT EXISTS profile_mentor_country (
17 uid
INT(11) NOT NULL DEFAULT 0,
18 country
CHAR(2) NOT NULL DEFAULT "FR",
19 PRIMARY KEY (uid
, country
),
21 ) ENGINE
=InnoDB
, CHARSET
=utf8
;
23 INSERT INTO profile_mentor_country (uid
, country
)
25 FROM #x4dat#.mentor_pays
;
27 CREATE TABLE IF NOT EXISTS profile_mentor_sector (
28 uid
INT(11) NOT NULL DEFAULT 0,
29 sectorid
TINYINT(2) UNSIGNED
NOT NULL,
30 subsectorid
TINYINT(3) UNSIGNED
NOT NULL,
31 PRIMARY KEY (uid
, sectorid
, subsectorid
),
33 ) ENGINE
=InnoDB
, CHARSET
=utf8
;
35 -- vim:set syntax=mysql: