Drop NAF_code when inappropriate.

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 (file)
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]$';