00d72983b7a47e5b4841ccc2be25978c4651aeb1
1 ALTER TABLE profile_medals
ADD COLUMN level ENUM('', 'Or', 'Argent', 'Bronze') NOT NULL DEFAULT '';
2 ALTER TABLE profile_medal_enum
MODIFY COLUMN flags
SET('validation', 'has_levels') NOT NULL DEFAULT '';
3 UPDATE profile_medal_enum
SET flags
= 'has_levels' WHERE id = 20; -- Médaille de la Défense Nationale
4 UPDATE profile_medal_enum
SET flags
= 'validation,has_levels' WHERE id IN (61, 62, 63); -- sports
5 DELETE FROM profile_medal_grade_enum
WHERE mid
IN (61, 62, 63); -- Not used in prod yet, thus no need to update.
7 -- vim:set syntax=mysql: