用MySQL 5的用户注意:
使用楼主的SQL会出现错误
正确的:
CREATE TABLE `cdb_ques` (
`qid` int(10) unsigned NOT NULL auto_increment,
`subject` varchar(255) NOT NULL default '',
`dateline` int(10) NOT NULL default '0',
`uid` mediumint(8) NOT NULL default '0',
`username` varchar(255) NOT NULL default '',
`exp` int(10) NOT NULL default '0',
`person` mediumint(8) NOT NULL default '20',
`stop` tinyint(1) NOT NULL default '0',
`price` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`qid`)
) ENGINE=MyISAM;
CREATE TABLE `cdb_quesoption` (
`id` int(10) unsigned NOT NULL auto_increment,
`qid` int(10) unsigned NOT NULL,
`type` text NOT NULL,
`check` mediumtext NOT NULL,
`question` mediumtext NOT NULL,
`key` mediumtext NOT NULL,
`open` tinyint(1) NOT NULL default '1',
`mark` mediumint(8) NOT NULL default '0',
`amust` tinyint(1) NOT NULL default '1',
`answeruser` mediumtext NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM;
CREATE TABLE `cdb_queslog` (
`lid` int(10) unsigned NOT NULL auto_increment,
`uid` int(10) unsigned NOT NULL default '0',
`username` varchar(255) NOT NULL default '',
`dateline` int(10) NOT NULL default '0',
`qid` int(10) unsigned NOT NULL,
`id` int(10) unsigned NOT NULL default '0',
`answer` mediumtext NOT NULL,
`mark` mediumint(8) NOT NULL default '0',
KEY (`lid`)
) TYPE=MyISAM;
[ 本帖最后由 magnum 于 2007-5-20 17:49 编辑 ] |