From d808162561556637545d06f3edf0ad3aae68dbad Mon Sep 17 00:00:00 2001
From: =?utf8?q?St=C3=A9phane=20Jacob?= <jacou@melix.net>
Date: Wed, 27 Aug 2008 20:41:46 +0200
Subject: [PATCH] Alters applis table to add MIA diploma.

---
 upgrade/0.9.18/00_edu.sql | 6 ++++++
 1 file changed, 6 insertions(+)
 create mode 100644 upgrade/0.9.18/00_edu.sql

diff --git a/upgrade/0.9.18/00_edu.sql b/upgrade/0.9.18/00_edu.sql
new file mode 100644
index 0000000..812f473
--- /dev/null
+++ b/upgrade/0.9.18/00_edu.sql
@@ -0,0 +1,6 @@
+ALTER TABLE applis_ins MODIFY type enum('Corps','Ingénieur','MBA','ME','MS','PhD','Diplôme','DEA','MiF','MPA', 'MIA');
+
+ALTER TABLE applis_def MODIFY type set('Corps','Ingénieur','MBA','ME','MS','PhD','Diplôme','DEA','MiF','MPA', 'MIA')
+
+# vim:set syntax=mysql:
+
-- 
2.1.4