3NSDKut6

1CREATE TABLE IF NOT EXISTS `genre` (
2  `genre_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
3  `image` text,
4  `title` varchar(255) DEFAULT NULL,
5  PRIMARY KEY (`genre_id`)
6) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
7
8CREATE TABLE IF NOT EXISTS `genre_user_assoc` (
9   `genre_id` int(10) unsigned NOT NULL,
10   `user_id` int(10) unsigned NOT NULL,
11   PRIMARY KEY (`genre_id`,`user_id`),
12   KEY `fk_user_genre_assoc` (`user_id`)	
13   CONSTRAINT `fk_genre_user_assoc` FOREIGN KEY (`genre_id`) REFERENCES `genre` (`genre_id`) ON DELETE CASCADE ON UPDATE CASCADE,
14   CONSTRAINT `fk_user_genre_assoc` FOREIGN KEY (`user_id`) REFERENCES `usuarios` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
15) ENGINE=InnoDB DEFAULT CHARSET=utf8;