From fda78a6777a5f385537fc9f291afb310e12525e5 Mon Sep 17 00:00:00 2001
From: Thomas Minvielle <thomas.minvielle@polytechnique.org>
Date: Sun, 23 Feb 2014 13:32:47 +0100
Subject: [PATCH] Drop NAF_code when inappropriate.

---
 upgrade/1.1.12/05_drop_job_NAF_code.sql | 1 +
 1 file changed, 1 insertion(+)
 create mode 100644 upgrade/1.1.12/05_drop_job_NAF_code.sql

diff --git a/upgrade/1.1.12/05_drop_job_NAF_code.sql b/upgrade/1.1.12/05_drop_job_NAF_code.sql
new file mode 100644
index 0000000..e132508
--- /dev/null
+++ b/upgrade/1.1.12/05_drop_job_NAF_code.sql
@@ -0,0 +1 @@
+UPDATE profile_job_enum SET NAF_code = NULL WHERE NAF_code NOT REGEXP '^[0-9]{4}[a-z]$';
-- 
2.1.4