CREATE TABLE IF NOT EXISTS `uchome_app_info` (
`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_info_reply` (
`id` int(11) NOT NULL auto_increment,
`info_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 `info_id` (`info_id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk; |