Advertisement
Guest User

Untitled

a guest
Mar 4th, 2015
180
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.64 KB | None | 0 0
  1. `qid`, `category`, `question`, `choice_1`, `choice_2`, `choice_3`, `answer`
  2.  
  3. CREATE TABLE IF NOT EXISTS `difi_questions` (
  4. `qid` smallint(6) NOT NULL AUTO_INCREMENT,
  5. `category` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  6. `question` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  7. `choice_1` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  8. `choice_2` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  9. `choice_3` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  10. `answer` enum('1','2','3') COLLATE utf8_unicode_ci DEFAULT NULL,
  11. PRIMARY KEY (`qid`)
  12. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1959 ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement