[platal.git] / upgrade / 1.1.2 / 08_shark.sql

INSERT INTO  profile_job_term_enum (name, full_name)
     VALUES  ('Hedge Fund', 'Hedge Fund (secteur)');

SET @jtid = 0;
SELECT  @jtid := jtid
  FROM  profile_job_term_enum
 WHERE  name = 'Hedge Fund';

INSERT INTO  profile_job_term_search (search, jtid)
     VALUES  ('HEDGE', @jtid), ('FUND', @jtid);
INSERT INTO  profile_job_term_relation (jtid_1, jtid_2, rel, computed)
     VALUES  (697, @jtid, 'narrower', 'computed'), (735, @jtid, 'narrower', 'original'), (@jtid, @jtid, 'narrower', 'computed');

-- vim:set syntax=mysql:
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: