CREATE TABLE `cdb_ques_topic` (
`topicid` int(10) unsigned NOT NULL auto_increment,
`subject` varchar(255) NOT NULL default 'NoName',
`message` text NOT NULL,
`author` varchar(255) NOT NULL default 'Unknown',
`authorid` int(8) NOT NULL default '0',
`dateline` int(10) NOT NULL default '0',
`person` int(8) NOT NULL default '100',
`stop` tinyint(1) NOT NULL default '0',
`credit` tinyint(1) NOT NULL default '0',
`postmust` tinyint(1) NOT NULL default '0',
`secret` tinyint(1) NOT NULL default '0',
`exp` int(10) NOT NULL default '0',
KEY `topicid` (`topicid`)
) ENGINE=MYISAM CHARACTER SET gbk COLLATE gbk_chinese_ci;
CREATE TABLE `cdb_ques_option` (
`oid` int(10) unsigned NOT NULL auto_increment,
`topicid` int(10) NOT NULL default '0',
`title` varchar(255) NOT NULL default 'NoName',
`desp` text NOT NULL,
`mark` text NOT NULL,
`option` text NOT NULL,
`key` text NOT NULL,
`order` int(8) NOT NULL default '0',
`least` tinyint(1) NOT NULL default '0',
`type` int(3) NOT NULL default '0',
KEY `oid` (`oid`)
) ENGINE=MYISAM CHARACTER SET gbk COLLATE gbk_chinese_ci;
CREATE TABLE `cdb_ques_user` (
`qid` int(10) unsigned NOT NULL auto_increment,
`topicid` int(10) NOT NULL default '0',
`author` varchar(255) NOT NULL default 'Unknown',
`authorid` int(8) NOT NULL default '0',
`mark` int(10) NOT NULL default '0',
`dateline` int(10) NOT NULL default '0',
KEY `qid` (`qid`)
) ENGINE=MYISAM CHARACTER SET gbk COLLATE gbk_chinese_ci;
CREATE TABLE `cdb_ques_result` (
`qid` int(10) unsigned NOT NULL default '0',
`topicid` int(10) unsigned NOT NULL default '0',
`oid` int(10) unsigned NOT NULL default '0',
`authorid` int(8) NOT NULL default '0',
`answer` text NOT NULL
) ENGINE=MYISAM CHARACTER SET gbk COLLATE gbk_chinese_ci; |