| 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', |
| 7 | PRIMARY KEY (pid, id), |
| 8 | KEY pid (pid), |
| 9 | CONSTRAINT FOREIGN KEY (pid) REFERENCES profiles (pid) ON DELETE CASCADE ON UPDATE CASCADE |
| 10 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
| 11 | |
| 12 | -- vim:set syntax=mysql: |