1 CREATE TABLE IF NOT EXISTS profile_corps (
3 original_corpsid INT(4) UNSIGNED NOT NULL DEFAULT 0,
4 current_corpsid INT(4) UNSIGNED NOT NULL DEFAULT 0,
5 rankid INT(4) UNSIGNED NOT NULL DEFAULT 0,
6 corps_pub ENUM('private', 'ax', 'public') NOT NULL DEFAULT 'private',
11 CREATE TABLE IF NOT EXISTS profile_corps_enum (
12 id INT(4) UNSIGNED NOT NULL AUTO_INCREMENT,
13 name VARCHAR(255) NOT NULL DEFAULT '',
14 abbreviation CHAR(5) NOT NULL DEFAULT '',
15 still_exists TINYINT(1) UNSIGNED NOT NULL DEFAULT 1,
18 UNIQUE KEY(abbreviation)
22 CREATE TABLE IF NOT EXISTS profile_corps_rank_enum (
23 id INT(4) UNSIGNED NOT NULL AUTO_INCREMENT,
24 name VARCHAR(255) NOT NULL DEFAULT '',
25 abbreviation CHAR(5) NOT NULL DEFAULT '',
28 UNIQUE KEY(abbreviation)
31 UPDATE profile_corps AS c
32 INNER JOIN profile_corps_enum AS e ON (c.original_corpsid = e.id)
33 LEFT JOIN profile_corps_enum AS a ON (a.name = "Aucun (anc. démissionnaire)")
34 SET c.original_corpsid = a.id
35 WHERE e.name = "Ancien élève étranger";
37 UPDATE profile_corps_enum
39 WHERE name = "Aucun (anc. démissionnaire)";
41 DELETE FROM profile_corps_enum
42 WHERE name = "Ancien élève étranger";
44 -- vim:set syntax=mysql: