- CREATE TABLE `cdb_ques_topic` (
- `[color=Red]topicid[/color]` 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 `tid` (`tid`)
- ) ENGINE=MyISAM;
复制代码 改为:- CREATE TABLE `cdb_ques_topic` (
- `[color=Red]tid[/color]` 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 `tid` (`tid`)
- ) ENGINE=MyISAM;
复制代码 |