#####日期:2020-12-23
#####提交人:蔡松林
#####sql 新增用户活跃度记录表（江苏）
#####sql语句
CREATE TABLE `member_activelog` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `uid` bigint(20) NOT NULL COMMENT '用户id',
  `activeTime` date NOT NULL COMMENT '活跃时间（以天为单位）',
  `count` int(11) DEFAULT NULL COMMENT '当天活跃次数',
  PRIMARY KEY (`id`),
  KEY `idx_uid` (`uid`),
  KEY `idx_time` (`activeTime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `member_version` ( `version`, `update_time`) VALUES ('3.0.16.7',NOW());

#####日期:2020-12-23
#####提交人:赵彦
#####sql 新增订单extend字段
#####sql语句
ALTER TABLE member_orders ADD COLUMN extend text CHARACTER SET utf8 DEFAULT NULL COMMENT '京东蓝海豚订单信息';

INSERT INTO `member_version` ( `version`, `update_time`) VALUES ('3.0.16.20',NOW());

#####日期:2020-12-30
#####提交人:赵彦
#####sql 新增member_setting表jscnAli,jscnWechart,jscnJdjli字段
#####sql语句
ALTER TABLE member_setting ADD COLUMN jscnAli text CHARACTER SET utf8 DEFAULT NULL COMMENT '江苏有线支付宝支付相关配置';
ALTER TABLE member_setting ADD COLUMN jscnWechart text CHARACTER SET utf8 DEFAULT NULL COMMENT '江苏有线微信支付相关配置';
ALTER TABLE member_setting ADD COLUMN jscnJdjli text CHARACTER SET utf8 DEFAULT NULL COMMENT '江苏有线蓝海豚相关配置';

INSERT INTO `member_version` ( `version`, `update_time`) VALUES ('3.1.1.15',NOW());

#####日期:2021-01-06
#####提交人:赵彦
#####sql 新增member_setting表codeUrl字段
#####sql语句
ALTER TABLE member_setting ADD COLUMN codeUrl varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '下载二维码地址';

INSERT INTO `member_version` ( `version`, `update_time`) VALUES ('3.1.1.20',NOW());

#####日期:2021-01-11
#####提交人:赵彦
#####sql 新增member_setting表codeUrl字段
#####sql语句
ALTER TABLE member_invitationlog ADD COLUMN equipmentid varchar(50) CHARACTER SET utf8 DEFAULT NULL COMMENT '设备id';
ALTER TABLE member_invitationlog ADD COLUMN macAddress varchar(50) CHARACTER SET utf8 DEFAULT NULL COMMENT 'mac地址';

INSERT INTO `member_version` ( `version`, `update_time`) VALUES ('3.1.1.36',NOW());


#####日期:2021-01-14
#####提交人:蔡松林
#####sql 新增索引字段
#####sql语句
alter table member_invitationlog add index idx_inviterID (inviterID);
alter table member_member_party add index idx_mobilephone (mobilephone);

INSERT INTO `member_version` ( `version`, `update_time`) VALUES ('3.1.1.52',NOW());

#####日期:2021-01-21
#####提交人:赵彦
#####sql 新增腾讯ai任务log表
#####sql语句
CREATE TABLE `aitasklog` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `uid` bigint(11) DEFAULT NULL COMMENT '用户ID',
  `taskId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '任务ID',
  `status` int(20) DEFAULT NULL COMMENT '0进行中,1成功,2失败',
  `taskType` int(20) DEFAULT NULL COMMENT '任务类型',
  `message` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '返回成功或失败信息',
  `result` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '返回结果',
  `addUserName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '用户名',
  `addTime` datetime DEFAULT NULL COMMENT '添加时间',
  `source` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '请求数据',
  `sensitiveWord` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '敏感词',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8;

INSERT INTO `member_version` ( `version`, `update_time`) VALUES ('3.1.1.58',NOW());