Commit | Line | Data |
---|---|---|
5fecdf6d SJ |
1 | DROP TABLE IF EXISTS profile_mentor; |
2 | DROP TABLE IF EXISTS profile_mentor_country; | |
3 | DROP TABLE IF EXISTS profile_mentor_sector; | |
4 | ||
5 | CREATE TABLE IF NOT EXISTS profile_mentor ( | |
6 | uid INT(11) NOT NULL DEFAULT 0, | |
7 | expertise TEXT NOT NULL, | |
8 | PRIMARY KEY (uid), | |
9 | FULLTEXT INDEX (expertise) | |
950bf4f6 | 10 | ) ENGINE=InnoDB, CHARSET=utf8; |
5fecdf6d SJ |
11 | |
12 | INSERT INTO profile_mentor (uid, expertise) | |
13 | SELECT uid, expertise | |
100e66fc | 14 | FROM #x4dat#.mentor; |
5fecdf6d SJ |
15 | |
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", | |
aaeb5ec6 FB |
19 | PRIMARY KEY (uid, country), |
20 | INDEX uid (uid) | |
950bf4f6 | 21 | ) ENGINE=InnoDB, CHARSET=utf8; |
5fecdf6d SJ |
22 | |
23 | INSERT INTO profile_mentor_country (uid, country) | |
24 | SELECT uid, pid | |
100e66fc | 25 | FROM #x4dat#.mentor_pays; |
5fecdf6d SJ |
26 | |
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, | |
aaeb5ec6 FB |
31 | PRIMARY KEY (uid, sectorid, subsectorid), |
32 | INDEX uid (uid) | |
950bf4f6 | 33 | ) ENGINE=InnoDB, CHARSET=utf8; |
5fecdf6d SJ |
34 | |
35 | -- vim:set syntax=mysql: |