

后台数据库工具里,复制进去执行
DROP TABLE IF EXISTS `qb_cms_content4`; CREATE TABLE IF NOT EXISTS `qb_cms_content4` ( `id` int(8) unsigned NOT NULL AUTO_INCREMENT, `mid` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '模型ID', `fid` mediumint(7) unsigned NOT NULL DEFAULT '0' COMMENT '栏目ID', `title` varchar(256) NOT NULL DEFAULT '' COMMENT '标题', `ispic` tinyint(2) NOT NULL DEFAULT '0' COMMENT '是否带组图', `picurl` text NOT NULL COMMENT '封面图', `uid` int(8) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID', `view` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '浏览量', `status` tinyint(2) NOT NULL DEFAULT '1' COMMENT '状态:0未审 1已审 2推荐', `agree` mediumint(5) NOT NULL DEFAULT '0' COMMENT '点赞', `replynum` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '评论数', `content` text NOT NULL COMMENT '内容介绍', `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间', `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间', `list` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序值', `voice_url` text NOT NULL COMMENT '音频地址', `province_id` mediumint(5) NOT NULL COMMENT '省会ID', `city_id` mediumint(5) NOT NULL COMMENT '城市ID', `zone_id` mediumint(5) NOT NULL COMMENT '县级市或所在区ID', `street_id` mediumint(5) NOT NULL COMMENT '乡镇或区域街道ID', `ext_sys` mediumint(5) NOT NULL COMMENT '扩展字段,关联的系统', `ext_id` int(8) NOT NULL COMMENT '扩展字段,供其它调用', `keywords` varchar(128) NOT NULL COMMENT 'SEO关键字', `price` decimal(10,2) NOT NULL COMMENT '收费阅读', `description` varchar(255) NOT NULL COMMENT '简介(SEO描述)', `fx1` decimal(5,2) NOT NULL COMMENT '直接推荐人收益', `fx2` decimal(5,2) NOT NULL COMMENT '间接推荐人收益', `fx3` decimal(5,2) NOT NULL COMMENT '三级推荐人收益', `myfid` int(7) NOT NULL COMMENT '我的分类', PRIMARY KEY (`id`), KEY `mid` (`mid`), KEY `fid` (`fid`), KEY `view` (`view`), KEY `status` (`status`), KEY `list` (`list`), KEY `ispic` (`ispic`), KEY `province_id` (`province_id`), KEY `city_id` (`city_id`), KEY `ext_id` (`ext_id`,`ext_sys`), KEY `uid` (`uid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='音频模型内容主表' AUTO_INCREMENT=1 ;