CREATE?TABLE?`subject`?(
`id`?int(11)?unsigned?NOT?NULL?AUTO_INCREMENT?COMMENT?'pk',
`img`?varchar(512)?NOT?NULL?COMMENT?'圖片',
`option`?varchar(512)?NOT?NULL?DEFAULT?''?COMMENT?'題目選項(xiàng)，為json格式',
`answer_key`?varchar(32)?NOT?NULL?DEFAULT?''?COMMENT?'選擇題的key，為ABCD等字符',?
`answer_value`?varchar(32)?NOT?NULL?DEFAULT?''?COMMENT?'答案value，電影名',
`create_time`?timestamp?NOT?NULL?DEFAULT?CURRENT_TIMESTAMP?COMMENT?'創(chuàng)建時(shí)間',?
`status`?tinyint(4)?NOT?NULL?DEFAULT?'0'?COMMENT?'狀態(tài)',?
`hash`?char(32)?NOT?NULL?DEFAULT?''?COMMENT?'哈希值',
PRIMARY?KEY?(`id`))?ENGINE=InnoDB?AUTO_INCREMENT=2046?DEFAULT?CHARSET=utf8?COMMENT='題目表';
INSERT?INTO?`subject`?(`id`,?`img`,?`option`,?`answer_key`,?`answer_value`,?`create_time`,?`status`,?`hash`)VALUES
(1,?'/img/cut/yaoshen.webp',?'{?\"A\":?\"無人區(qū)\",?\"B\":?\"人在囧途\",?\"C\":?\"我不是藥神\",?\"D\":?\"心花路放\"?}',?'C',?'我不是藥神',?'2018-09-08?12:34:06',?0,?'');
INSERT?INTO?`subject`?(`id`,?`img`,?`option`,?`answer_key`,?`answer_value`,?`create_time`,?`status`,?`hash`)VALUES
(2,?'/img/cut/bat.webp',?'{?\"A\":?\"黑暗騎士崛起\",?\"B\":?\"蝙蝠俠大戰(zhàn)超人\",?\"C\":?\"俠影之謎\",?\"D\":?\"黑暗騎士\"?}',?'D',?'黑暗騎士',?'2018-09-08?12:34:19',?0,?'');