CREATE TABLE `Webmeng_products_data` (
`id` int(20) NOT NULL,
`content` text,
`wapcontent` text COMMENT '内容1',
`instructions_use` text COMMENT '内容2',
`wapinstructions_use` text,
`helpcontent` text,
`waphelpcontent` text
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `Webmeng_products` (
`id` int(20) NOT NULL,
`lid` varchar(2) DEFAULT '1' COMMENT '语言ID',
`catid` int(9) NOT NULL COMMENT '分类编号',
`type` int(2) NOT NULL,
`cpads` varchar(255) DEFAULT NULL,
`brand` varchar(20) NOT NULL,
`uid` varchar(199) NOT NULL,
`style` int(2) NOT NULL,
`push` varchar(21) DEFAULT NULL,
`ads_img` varchar(250) DEFAULT NULL,
`sort` varchar(9) NOT NULL COMMENT '文章排序',
`title` varchar(50) DEFAULT NULL COMMENT '文章标题',
`number` varchar(2) NOT NULL,
`publisher` varchar(20) NOT NULL COMMENT '发布者',
`thumb` varchar(300) NOT NULL DEFAULT '0',
`imgs` text NOT NULL,
`keywords` text NOT NULL COMMENT '关键字',
`copyfrom` varchar(30) NOT NULL COMMENT '来源',
`description` text NOT NULL COMMENT '简述',
`posids` int(10) NOT NULL,
`hit` int(10) NOT NULL DEFAULT '0' COMMENT '文章热度',
`content` text,
`url` varchar(255) NOT NULL,
`listorder` varchar(22) NOT NULL,
`status` int(2) NOT NULL,
`sysadd` int(2) NOT NULL,
`islink` int(1) NOT NULL,
`username` varchar(40) NOT NULL,
`updatetime` datetime NOT NULL,
`recommend` int(2) NOT NULL COMMENT '推荐',
`inputtime` datetime DEFAULT NULL,
`readpoint` varchar(2) NOT NULL,
`groupids_view` varchar(2) NOT NULL,
`paginationtype` varchar(2) NOT NULL,
`maxcharperpage` varchar(2) NOT NULL,
`template` varchar(2) NOT NULL,
`paytype` varchar(2) NOT NULL,
`relation` varchar(2) NOT NULL,
`voteid` varchar(2) NOT NULL,
`allow_comment` varchar(2) NOT NULL,
`attrs` varchar(200) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;