0370f7b6e3dbb3775ca7cb78800721e8af291544
1 CREATE TABLE profile_hobby (
2 pid
INT(11) UNSIGNED
NOT NULL DEFAULT 0,
3 id TINYINT(3) UNSIGNED
NOT NULL DEFAULT 0 COMMENT 'number of the hobby for the user',
4 type ENUM('Sport', 'Loisir', 'Hobby') NOT NULL DEFAULT 'Hobby',
5 text VARCHAR(255) NOT NULL DEFAULT '',
6 pub
ENUM('hidden','private','ax','public') NOT NULL DEFAULT 'private',
9 CONSTRAINT FOREIGN KEY (pid
) REFERENCES profiles (pid
) ON DELETE CASCADE ON UPDATE CASCADE
10 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8
;
12 -- vim:set syntax=mysql: