From 2c8b13abaf972f2d1f7c9e456decdee549f4e847 Mon Sep 17 00:00:00 2001 From: =?utf8?q?St=C3=A9phane=20Jacob?= Date: Tue, 17 Mar 2009 17:55:58 +0100 Subject: [PATCH] Changes corps options to something more politicaly correct. --- upgrade/newdirectory-0.0.1/07_corps | 13 +++++++++++++ 1 file changed, 13 insertions(+) diff --git a/upgrade/newdirectory-0.0.1/07_corps b/upgrade/newdirectory-0.0.1/07_corps index 50ed7d5..4e5eae2 100644 --- a/upgrade/newdirectory-0.0.1/07_corps +++ b/upgrade/newdirectory-0.0.1/07_corps @@ -28,4 +28,17 @@ CREATE TABLE IF NOT EXISTS profile_corps_rank_enum ( UNIQUE KEY(abbreviation) ) CHARSET=utf8; + UPDATE profile_corps AS c +INNER JOIN profile_corps_enum AS e ON (c.original_corpsid = e.id) + LEFT JOIN profile_corps_enum AS a ON (a.name = "Aucun (anc. démissionnaire)") + SET c.original_corpsid = a.id + WHERE e.name = "Ancien élève étranger"; + +UPDATE profile_corps_enum + SET name = "Aucun" + WHERE name = "Aucun (anc. démissionnaire)"; + +DELETE FROM profile_corps_enum + WHERE name = "Ancien élève étranger"; + -- vim:set syntax=mysql: -- 2.1.4