# Table: ANSWER
#
# 答题表
CREATE TABLE `ANSWER` (
`id` bigint(20) unsigned NOT NULL auto_increment, # 问题ID
`type` varchar(100) NOT NULL default , # 问题类型
`ask` blob NOT NULL, # 问题描述
`answer_a` blob NOT NULL, # 答案1描述
`answer_b` blob NOT NULL, # 答案2描述
`answer_c` blob NOT NULL, # 答案3描述
`answer_d` blob NOT NULL, # 答案4描述
`answer_e` blob NOT NULL,
`answer_f` blob NOT NULL,
`the_answer` bigint(20) NOT NULL default 0, # 正确答案编号
`quiz_type` int(11) NOT NULL default 0, # 竞赛类型,0为全国答题,1为个人答题
PRIMARY KEY (`id`)
) TYPE=MyISAM;
|