friendship-parent/doc/ddl/table/V4.9.sql

-- 举报相关信息表
CREATE TABLE `friendship`.`report_and_appeal`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `target_id` bigint(20) NULL COMMENT '目标id',
  `target_name` varchar(144) NULL COMMENT '目标名',
  `report_obj` tinyint(2) NULL COMMENT '举报对象:0用户,1:群聊房间,2:语音房',
  `report_type` varchar(64) NULL COMMENT '举报类型',
  `report_img_urls` varchar(512) NULL COMMENT '举报图片地址',
  `report_des` varchar(255) NULL COMMENT '举报描述',
  `report_user_id` bigint(20) NULL COMMENT '举报人id',
  `report_time` timestamp(0) NULL COMMENT '举报时间',
  `report_status` tinyint(2) NULL COMMENT '举报状态',
  `appeal_img_urls` varchar(512) NULL COMMENT '申诉图片地址',
  `appeal_des` varchar(255) NULL COMMENT '申诉描述',
  `appeal_time` timestamp(0) NULL COMMENT '申诉时间',
  `appeal_status` tinyint(2) NULL COMMENT '申诉状态',
  `appeal_count` integer(1) NULL COMMENT '申诉次数',
  PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 10101011 COMMENT = '举报申诉表';

-- 举报申诉历史日志表
CREATE TABLE `friendship`.`report_and_appeal_history`  (
  `id` bigint(10) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `report_id` bigint(20) NULL COMMENT '举报记录id',
  `time` timestamp(0) NULL COMMENT '操作时间',
  `des` varchar(144) NULL COMMENT '描述',
  PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 10001011 COMMENT = '举报申诉历史日志表';

-- ios充值白名单
CREATE TABLE `friendship`.`ios_charge_white_user`  (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) NOT NULL COMMENT '用户id',
  `create_time` timestamp(0) NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) COMMENT = 'ios充值白名单,不受充值的限制';

-- ios充值黑名单
CREATE TABLE `friendship`.`ios_charge_black_user`  (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) NOT NULL COMMENT '用户id',
  `create_time` timestamp(0) NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) COMMENT = 'ios充值黑名单,受充值的限制';

-- ios设备充值黑名单
CREATE TABLE `friendship`.`ios_charge_black_device`  (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `device_token` varchar(64) NOT NULL COMMENT '用户设备token',
  `create_time` timestamp(0) NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) COMMENT = 'ios充值设备黑名单,受充值的限制';

-- 用户异常行为记录表
CREATE TABLE `friendship`.`ios_user_exception_history`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) NULL COMMENT '用户id',
  `user_exception_des` varchar(64) NULL COMMENT '用户异常行为',
  `create_time` timestamp(0) NULL,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 1000010;
) ENGINE = InnoDB AUTO_INCREMENT = 1000010;
--用户权限表
CREATE TABLE `friendship`.`user_permissions`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `userId` bigint(20) NOT NULL COMMENT '用户id',
  `private_chat` tinyint(2) NULL DEFAULT 0 COMMENT '私聊',
  `recommend_dynamics` tinyint(2) NULL DEFAULT 0 COMMENT '推荐的动态列表',
  `other_user_home_page` tinyint(2) NULL DEFAULT 0 COMMENT '其他用户首页',
  `works` tinyint(2) NULL DEFAULT 0 COMMENT '语音心情页',
  `topic` tinyint(2) NULL DEFAULT 0 COMMENT '话题',
  `send_gift` tinyint(2) NULL DEFAULT 0 COMMENT '送礼',
  `create_order` tinyint(2) NULL DEFAULT 0 COMMENT '下单',
  `live_room` tinyint(2) NULL DEFAULT 0 COMMENT '直播间',
  PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 10011101 COMMENT = '用户权限表';

-- 用户日充值表
CREATE TABLE `friendship`.`user_daily_charge_count`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) NULL COMMENT '用户id',
  `date` varchar(10) NULL COMMENT '日期字符串',
  `charge_total` integer(4) NULL COMMENT '充值金额',
  PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 10000100 COMMENT = '用户日充值记录表';

-- 2020-10-15 14:54 申诉表
CREATE TABLE `friendship`.`appeal`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `report_timestamp` bigint(0) NOT NULL COMMENT '举报记录的时间戳',
  `appeal_img_urls` varchar(512) NOT NULL COMMENT '申诉的图片',
  `appeal_des` varchar(255) NULL COMMENT '申诉描述',
  `appeal_user_id` bigint(20) NULL COMMENT '申诉用户id',
  `appeal_time` timestamp(0) NULL COMMENT '申诉时间',
  `appeal_status` tinyint(2) NULL COMMENT '申诉状态',
  `appeal_count` int(2) NULL DEFAULT 0 COMMENT '申诉次数',
  PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 10010011 COMMENT = '申诉表';