From 1ee148f04a4ef3b950ef4b2e887d086f64a4a28d Mon Sep 17 00:00:00 2001
From: =?utf8?q?St=C3=A9phane=20Jacob?= <sj@m4x.org>
Date: Tue, 26 Apr 2011 13:27:17 +0200
Subject: [PATCH] Updates json in newsletter_issues according to 9a6abd.
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.1/11_promo_filter.sql | 8 ++++++++
 1 file changed, 8 insertions(+)
 create mode 100644 upgrade/1.1.1/11_promo_filter.sql

diff --git a/upgrade/1.1.1/11_promo_filter.sql b/upgrade/1.1.1/11_promo_filter.sql
new file mode 100644
index 0000000..8b7e335
--- /dev/null
+++ b/upgrade/1.1.1/11_promo_filter.sql
@@ -0,0 +1,8 @@
+UPDATE  newsletter_issues
+   SET  sufb_json = REPLACE(sufb_json, 'Ing.', 'Ingénieur');
+UPDATE  newsletter_issues
+   SET  sufb_json = REPLACE(sufb_json, 'M%', 'Master');
+UPDATE  newsletter_issues
+   SET  sufb_json = REPLACE(sufb_json, 'PhD', 'Doctorat');
+
+-- vim:set syntax=mysql:
-- 
2.1.4