Guest User

Untitled

a guest
Aug 16th, 2018
105
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.50 KB | None | 0 0
  1. CREATE TABLE `quiz_common` (
  2.  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  3.  `user_id` INT(10) UNSIGNED NOT NULL,
  4.  `title` VARCHAR(50) NOT NULL,
  5.  `subtitle` VARCHAR(50) NOT NULL,
  6.  `finished` tinyint(1) NOT NULL DEFAULT '0',
  7.  `created` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  8.  PRIMARY KEY (`id`),
  9.  KEY `user_id` (`user_id`),
  10.  CONSTRAINT `quiz_common_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
  11. ) ENGINE=InnoDB AUTO_INCREMENT=141 DEFAULT CHARSET=utf8
Add Comment
Please, Sign In to add comment