出现问号的解决办法是把楼主的发布的文件里SQL语句
- 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;
- 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;
- 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;
- 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;
复制代码
换成下面这个执行就可以解决了!!!
- 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`)
- ) TYPE=MyISAM;
- 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`)
- ) TYPE=MyISAM;
- 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`)
- ) TYPE=MyISAM;
- 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
- ) TYPE=MyISAM;
复制代码 |