一、bbs6.7需要的环境

CMS汽车网环境

个人中心汽车网环境

消息队列

论坛汽车网环境

二、论坛汽车网环境数据库配置

1.添加表bbs6_recommendations_cms

CREATE TABLE `bbs6_recommendations_cms` (

`crid` int(8) unsigned NOT NULL COMMENT '主键',

`tid` int(8) unsigned NOT NULL COMMENT '帖子论坛id',

`adminuid` int(8) unsigned NOT NULL COMMENT '推荐编辑id',

`cmsid` int(8) unsigned NOT NULL COMMENT 'cms栏目id',

`cmsfullname` char(64) NOT NULL COMMENT 'cms栏目全称',

`cmstitle` char(64) NOT NULL COMMENT '修改后标题',

`createat` datetime NOT NULL COMMENT '推荐时间',

`oldarticle` smallint(1) NOT NULL DEFAULT '0' COMMENT '是否旧文章',

`urid` int(8) unsigned DEFAULT NULL COMMENT '如果是从版主推荐列表中推荐,所对应的urid',

`red` smallint(1) NOT NULL DEFAULT '0' COMMENT '是否套红',

`keyword` char(16) DEFAULT NULL COMMENT '关键字(预留)',

PRIMARY KEY (`crid`)

) ENGINE=InnoDB DEFAULT CHARSET=gbk

添加表bbs6_recommendations_user

CREATE TABLE `bbs6_recommendations_user` (

`urid` int(8) unsigned NOT NULL COMMENT '主键',

`tid` int(8) unsigned NOT NULL COMMENT '帖子id',

`fid` int(8) unsigned NOT NULL COMMENT '所属板块id',

`uid` int(8) unsigned NOT NULL COMMENT '推荐用户id',

`createat` datetime NOT NULL COMMENT '推荐时间',

`adminrecommended` smallint(1) NOT NULL COMMENT '是否已被编辑推荐',

PRIMARY KEY (`urid`)

) ENGINE=InnoDB DEFAULT CHARSET=gbk

添加数据

insert into `bbs6_user_rights` (`code`, `type`, `name`, `detail`, `seq`) values('allowRecommendation','1','是否允许使用推荐',NULL,'68');

insert into `bbs6_user_rights` (`code`, `type`, `name`, `detail`, `seq`) values('maxRecommendationPerDay','2','每天推荐次数',NULL,'69');

insert into `bbs6_domain_prop` (`domain`, `prop`) values('Forum','recomendation_black');

ALTER TABLE `bbs6_user_limit` ADD COLUMN `recommendcount` INT(2) NOT NULL DEFAULT '0'

ALTER TABLE `bbs6_user_limit2` ADD COLUMN `recommendcount` INT(2) NOT NULL DEFAULT '0'

ORACLE库里:

ALTER TABLE `bbs6_user` ADD (vip NUMBER(1,0));

论坛汽车网更新包