Delete non-graduated diplomas on existing accounts.

[platal.git] / upgrade / 1.1.14 / 03_deleteMaster.sql

diff --git a/upgrade/1.1.14/03_deleteMaster.sql b/upgrade/1.1.14/03_deleteMaster.sql
new file mode 100644 (file)
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;