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',
8 ) ENGINE
=InnoDB
, CHARSET
=utf8
;
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
)
19 ) ENGINE
=InnoDB
, CHARSET
=utf8
;
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
)
29 ) ENGINE
=InnoDB
, CHARSET
=utf8
;
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: