Commit | Line | Data |
---|---|---|
8fcfc71f SJ |
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: |