From: Thomas Minvielle <thomas.minvielle@polytechnique.org>
Date: Sun, 12 Oct 2014 18:51:31 +0000 (+0200)
Subject: Delete non-graduated diplomas on existing accounts.
X-Git-Url: http://git.polytechnique.org/?p=platal.git;a=commitdiff_plain;h=d284f750d006b2988870f96ba55a01bf6144a358

Delete non-graduated diplomas on existing accounts.
---

diff --git a/upgrade/1.1.14/03_deleteMaster.sql b/upgrade/1.1.14/03_deleteMaster.sql
new file mode 100644
index 0000000..fe25cd7
--- /dev/null
+++ b/upgrade/1.1.14/03_deleteMaster.sql
@@ -0,0 +1,11 @@
+DELETE FROM profile_education WHERE pid = 43014 AND id = 101;
+DELETE FROM profile_education WHERE pid = 42132 AND id = 101;
+DELETE FROM profile_education WHERE pid = 41502 AND id = 101;
+DELETE FROM profile_education WHERE pid = 42517 AND id = 101;
+DELETE FROM profile_education WHERE pid = 41549 AND id = 101;
+DELETE FROM profile_education WHERE pid = 42442 AND id = 101;
+DELETE FROM profile_education WHERE pid = 42197 AND id = 101;
+DELETE FROM profile_education WHERE pid = 42248 AND id = 101;
+DELETE FROM profile_education WHERE pid = 42435 AND id = 101;
+DELETE FROM profile_education WHERE pid = 41998 AND id = 101;
+DELETE FROM profile_education WHERE pid = 24507 AND id = 101;