From dcf173d8f864cdc3a45847f8ba5d64ae0e86e42f Mon Sep 17 00:00:00 2001
From: =?utf8?q?St=C3=A9phane=20Jacob?= <sj@m4x.org>
Date: Sun, 19 Jun 2011 13:08:13 +0200
Subject: [PATCH] Adds Hedge Fund sector.
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

Signed-off-by: Stéphane Jacob <sj@m4x.org>
---
 upgrade/1.1.2/08_shark.sql | 14 ++++++++++++++
 1 file changed, 14 insertions(+)
 create mode 100644 upgrade/1.1.2/08_shark.sql

diff --git a/upgrade/1.1.2/08_shark.sql b/upgrade/1.1.2/08_shark.sql
new file mode 100644
index 0000000..c45cb3f
--- /dev/null
+++ b/upgrade/1.1.2/08_shark.sql
@@ -0,0 +1,14 @@
+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:
-- 
2.1.4