-- ----------------------------
-- 日期:2022-01-17
-- 提交人:黄晓雷
-- sql 会员表新增表(关注,取消关注记录表)
-- sql语句
-- ----------------------------
CREATE TABLE `member_audit`
(
    `id`            bigint(11) UNSIGNED NOT NULL AUTO_INCREMENT,
    `member_id`     bigint(11) UNSIGNED NOT NULL COMMENT '会员主表id',
    `mobile`        varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '会员手机号，数据冗余方便查询',
    `type`          tinyint(1) UNSIGNED NOT NULL COMMENT '审核变更项 1:头像、2:昵称、3:简介',
    `original_info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '原始信息',
    `new_info`      varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '变更的信息',
    `submit_time`   datetime(0) NOT NULL,
    `status`        tinyint(1) NOT NULL COMMENT '审核状态 1:待审核、2:审核通过、3:审核不通过',
    `audit_time`    datetime(0) NULL DEFAULT NULL COMMENT '审核的时间',
    `audit_user`    varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '审核人的user_token，用来从cmc获取最新的用户名',
    PRIMARY KEY (`id`) USING BTREE,
    INDEX           `idx_member_type_status`(`member_id`, `status`, `type`) USING BTREE
) ENGINE = InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

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