Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE `users_flyers_views` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `user_id` int(11) NOT NULL,
- `flyer_id` int(11) NOT NULL,
- `views` int(11) NOT NULL DEFAULT '0',
- `last_viewed` datetime NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `user_id` (`user_id`,`flyer_id`),
- KEY `flyer_id` (`flyer_id`),
- CONSTRAINT `users_flyers_views_ibfk_1` FOREIGN KEY (`flyer_id`) REFERENCES `flyers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
- CONSTRAINT `users_flyers_views_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement