| 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: |