#####日期:2021-03-09
#####提交人:蔡松林
#####sql 会员表添加字段
#####sql语句
alter table member_member  add column userCertificationLevel int(1) DEFAULT '0' COMMENT '融媒号用户认证级别，普通用户默认0';

alter table member_setting  add column `jsAttenton` varchar(2000) DEFAULT NULL COMMENT '江苏关注权重设置';

ALTER TABLE `member_member` ADD `userType` int(1) NULL DEFAULT 1 COMMENT '用户类型；1：普通用户；2：融媒号用户；';
#####日期:2021-03-24
#####提交人:蔡松林
#####sql 江苏定制数据同步
#####sql语句
UPDATE  member_member m  LEFT JOIN  webtv_spider.st_community_user c on m.id =c.business_id  and m.userType = 2  set  m.userCertificationLevel = 6 WHERE c.certification_id =1;

UPDATE  member_member m  LEFT JOIN  webtv_spider.st_community_user c on m.id =c.business_id  and m.userType = 2  set  m.userCertificationLevel = 3 WHERE c.certification_id =2;

UPDATE  member_member m  LEFT JOIN  webtv_spider.st_community_user c on m.id =c.business_id  and m.userType = 2  set  m.userCertificationLevel = 5 WHERE c.certification_id =4;

UPDATE  member_member m  LEFT JOIN  webtv_spider.st_community_user c on m.id =c.business_id  and m.userType = 2  set  m.userCertificationLevel = 2 WHERE c.certification_id =6;

UPDATE  member_member m  LEFT JOIN  webtv_spider.st_community_user c on m.id =c.business_id  and m.userType = 2  set  m.userCertificationLevel = 1 WHERE c.certification_id =5;

UPDATE  member_member m  LEFT JOIN  webtv_spider.st_community_user c on m.id =c.business_id  and m.userType = 2  set  m.userCertificationLevel = 4 WHERE c.certification_id =3;