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 profile_mentor (
6 pid
INT(11) NOT NULL DEFAULT 0,
7 expertise
TEXT NOT NULL,
9 ) ENGINE
=InnoDB
, CHARSET
=utf8
;
11 INSERT INTO profile_mentor (pid
, expertise
)
15 CREATE TABLE profile_mentor_country (
16 pid
INT(11) NOT NULL DEFAULT 0,
17 country
CHAR(2) NOT NULL DEFAULT "FR",
18 PRIMARY KEY (pid
, country
),
20 ) ENGINE
=InnoDB
, CHARSET
=utf8
;
22 INSERT INTO profile_mentor_country (pid
, country
)
24 FROM #x4dat#.mentor_pays
;
26 CREATE TABLE profile_mentor_sector (
27 pid
INT(11) NOT NULL DEFAULT 0,
28 sectorid
TINYINT(2) UNSIGNED
NOT NULL,
29 subsectorid
TINYINT(3) UNSIGNED
NOT NULL,
30 PRIMARY KEY (pid
, sectorid
, subsectorid
),
32 ) ENGINE
=InnoDB
, CHARSET
=utf8
;
34 -- vim:set syntax=mysql: