数据库主表与副表创建

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;