Add a SIREN field to profile_jobs_enum.

[platal.git] / upgrade / 1.1.12 / 07_create_SIREN.sql

diff --git a/upgrade/1.1.12/07_create_SIREN.sql b/upgrade/1.1.12/07_create_SIREN.sql
new file mode 100644 (file)
index 0000000..c5afc14
--- /dev/null
+++ b/upgrade/1.1.12/07_create_SIREN.sql
@@ -0,0 +1 @@
+ALTER TABLE profile_job_enum ADD SIREN_code CHAR(9) NULL DEFAULT NULL AFTER holdingid;