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";
45 ALTER TABLE watch_profile MODIFY field enum('nom', 'freetext', 'mobile', 'nationalite', 'nationalite2',
46 'nationalite3', 'nick', 'web', 'networking', 'edus', 'addresses',
47 'section', 'binets', 'medals', 'cv', 'jobs', 'photo', 'corps');
49 -- vim:set syntax=mysql: