原语句:
CREATE TABLE IF NOT EXISTS `uchome_app_ask` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`typeid` smallint(4) NOT NULL default '0',
`uid` int(11) NOT NULL default '0',
`username` varchar(50) NOT NULL default '',
`content` text,
`tag` varchar(250) default NULL,
`dateline` int(11) NOT NULL default '0',
`score` smallint(4) NOT NULL default '0',
`view_count` int(11) NOT NULL default '0',
`reply_count` int(11) NOT NULL default '0',
`status` smallint(1) NOT NULL default '0',
`msg` text,
PRIMARY KEY (`id`),
KEY `typeid` (`typeid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
CREATE TABLE IF NOT EXISTS `uchome_app_ask_reply` (
`id` int(11) NOT NULL auto_increment,
`ask_id` int(11) NOT NULL default '0',
`content` text NOT NULL,
`uid` int(11) NOT NULL default '0',
`username` varchar(50) NOT NULL default '',
`score` smallint(4) NOT NULL default '0',
`dateline` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `ask_id` (`ask_id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
修改成:http://www.314051.cn/space.php?uid=1&do=thread&id=667 |