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
)
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
),
23 INSERT INTO profile_mentor_country (uid
, country
)
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
),
35 -- vim:set syntax=mysql: