Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE `quiz_common` (
- `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `user_id` INT(10) UNSIGNED NOT NULL,
- `title` VARCHAR(50) NOT NULL,
- `subtitle` VARCHAR(50) NOT NULL,
- `finished` tinyint(1) NOT NULL DEFAULT '0',
- `created` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
- PRIMARY KEY (`id`),
- KEY `user_id` (`user_id`),
- CONSTRAINT `quiz_common_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
- ) ENGINE=InnoDB AUTO_INCREMENT=141 DEFAULT CHARSET=utf8
Add Comment
Please, Sign In to add comment