Commit | Line | Data |
---|---|---|
dcf173d8 SJ |
1 | INSERT INTO profile_job_term_enum (name, full_name) |
2 | VALUES ('Hedge Fund', 'Hedge Fund (secteur)'); | |
3 | ||
4 | SET @jtid = 0; | |
5 | SELECT @jtid := jtid | |
6 | FROM profile_job_term_enum | |
7 | WHERE name = 'Hedge Fund'; | |
8 | ||
9 | INSERT INTO profile_job_term_search (search, jtid) | |
10 | VALUES ('HEDGE', @jtid), ('FUND', @jtid); | |
11 | INSERT INTO profile_job_term_relation (jtid_1, jtid_2, rel, computed) | |
12 | VALUES (697, @jtid, 'narrower', 'computed'), (735, @jtid, 'narrower', 'original'), (@jtid, @jtid, 'narrower', 'computed'); | |
13 | ||
14 | -- vim:set syntax=mysql: |