friendship-parent/doc/ddl/modify/V4.8.sql

-- user_auth_hold_pic
ALTER TABLE `friendship`.`user_auth_hold_pic`
ADD COLUMN `remark` varchar(140) NULL COMMENT '拒绝理由' AFTER `status`;
ALTER TABLE `friendship`.`user_auth_hold_pic`
MODIFY COLUMN `user_hold_pic` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户手持身份证照片地址' AFTER `real_name`;
ALTER TABLE `friendship`.`user_auth_hold_pic`
ADD COLUMN `create_time` timestamp(0) NULL COMMENT '创建时间' AFTER `remark`;

ALTER TABLE `friendship`.`user_auth_hold_pic`
MODIFY COLUMN `verify_time` timestamp(0) NULL DEFAULT NULL COMMENT '审核时间' AFTER `verify_user_id`;

ALTER TABLE `friendship`.`user_auth_hold_pic`
ADD COLUMN `verify_user_id` int(10) NULL COMMENT '审核的管理员id' AFTER `create_time`,
ADD COLUMN `verify_time` int(10) NULL COMMENT '审核时间' AFTER `verify_user_id`;

-- auth
ALTER TABLE `friendship`.`authenticate`
MODIFY COLUMN `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键' FIRST;

-- 陪玩订单
ALTER TABLE `friendship`.`play_orders`
ADD COLUMN `comment_status` tinyint(2) NULL DEFAULT 0 COMMENT '评论状态,0:评论状态' AFTER `money`;

-- 陪玩订单评论表
ALTER TABLE `friendship`.`play_order_comment`
CHANGE COLUMN `skill_id` `game_id` bigint(20) NULL DEFAULT NULL COMMENT '陪玩师注册的技能id' AFTER `id`,
ADD COLUMN `player_user_id` bigint(20) NULL COMMENT '陪玩师用户id' AFTER `game_id`;
ALTER TABLE `friendship`.`play_order_comment`
ADD COLUMN `order_id` bigint(20) NULL COMMENT '订单id' AFTER `start`;

-- 字典
ALTER TABLE `friendship`.`dictionary`
MODIFY COLUMN `sn` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '字典编码' AFTER `name`;
MODIFY COLUMN `sn` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '字典编码' AFTER `name`;
-- 2020/09/11 17:32 陪玩师注册表语音介绍
ALTER TABLE `friendship`.`play_user_registered`
ADD COLUMN `voice_introduce` varchar(255) NULL DEFAULT NULL COMMENT '语音介绍' AFTER `price`;

-- 2020/09/12 11:15 系统技能游戏配置表增加 游戏区服 擅长位置
ALTER TABLE `friendship`.`play_game_config`
ADD COLUMN `game_zone` varchar(144) NULL DEFAULT NULL COMMENT '游戏区服' AFTER `game_name`,
ADD COLUMN `good_at_location` varchar(144) NULL DEFAULT NULL COMMENT '擅长位置' AFTER `game_zone`;

-- 2020/09/14 10:10 陪玩师注册表增加 游戏区服index,擅长位置index,个性标签id
ALTER TABLE `friendship`.`play_user_registered`
ADD COLUMN `game_zone` varchar(64) NULL DEFAULT NULL COMMENT '游戏区服' AFTER `voice_introduce`,
ADD COLUMN `good_at_location` varchar(64) NULL DEFAULT NULL COMMENT '擅长位置' AFTER `game_zone`,
ADD COLUMN `character_tag_id` bigint(20) NULL DEFAULT NULL COMMENT '个性标签id' AFTER `good_at_location`,
ADD COLUMN `game_level_status` tinyint(2) NULL DEFAULT NULL COMMENT '段位审核状态' AFTER `user_game_level`,
ADD COLUMN `new_screen_shot` varchar(255) NULL DEFAULT NULL COMMENT '新段位截图' AFTER `game_level_status`,
ADD COLUMN `new_game_level` varchar(255) NULL DEFAULT NULL COMMENT '新游戏段位' AFTER `new_screen_shot`;

-- 2020/09/15 10:39
ALTER TABLE `friendship`.`play_user_registered`
ADD COLUMN `summary_of_skill` varchar(144) NULL DEFAULT NULL COMMENT '技能简介' AFTER `voice_introduce`;

-- 2020/09/16 10:39
ALTER TABLE `friendship`.`ios_menu`
ADD COLUMN `find_cover_picture` varchar(128) NULL COMMENT '发现封面图片' AFTER `type`;
ADD COLUMN `find_cover_picture` varchar(128) NULL COMMENT '发现封面图片' AFTER `type`;
-- 2020/09/15 15:52
ALTER TABLE `friendship`.`play_user_registered`
ADD COLUMN `voice_duration` int(4) NULL DEFAULT NULL COMMENT '语音时长' AFTER `voice_introduce`;
ADD COLUMN `voice_duration` int(4) NULL DEFAULT NULL COMMENT '语音时长' AFTER `voice_introduce`;
ADD COLUMN `find_cover_picture` varchar(128) NULL COMMENT '发现封面图片' AFTER `type`;

--2020/09/17 14:39  play_user_image_card_last_review
ALTER TABLE `friendship`.`play_user_image_card_last_review`
ADD COLUMN `create_time` timestamp(0) NULL COMMENT '创建时间' AFTER `last_verify_imagecard_pic`;

--2020/09/18 14:39  game_skill_recommend
ALTER TABLE `friendship`.`game_skill_recommend`
ADD COLUMN `voice_introduce` varchar(200) NULL COMMENT '语音介绍' AFTER `billing_way`;

-- 2020/09/17 10:45
ALTER TABLE `friendship`.`play_user_registered`
DROP COLUMN `character_tag_id`;

-- 2020/09/18
ALTER TABLE `friendship`.`play_game_config`
ADD COLUMN `voice_introduce_temp` varchar(144) NULL DEFAULT NULL COMMENT '语音介绍示例' AFTER `good_at_location`;
ADD COLUMN `voice_introduce_temp` varchar(144) NULL DEFAULT NULL COMMENT '语音介绍示例' AFTER `good_at_location`;

ALTER TABLE `friendship`.`play_user_image_card_last_review`
CHANGE COLUMN `userId` `user_id` bigint(20) NULL DEFAULT NULL COMMENT '用户id' AFTER `id`;


ALTER TABLE `friendship`.`game_skill_recommend`
ADD COLUMN `status` tinyint(2) NULL DEFAULT 0 COMMENT '逻辑删除状态' AFTER `voice_introduce`;

ALTER TABLE `friendship`.`play_image_card_recommend_index_flag`
ADD COLUMN `status` tinyint(2) NULL DEFAULT 0 COMMENT '逻辑删除状态' AFTER `update_time`;

ALTER TABLE `friendship`.`play_image_card_recommend_index_flag`
DROP COLUMN `recommend_status`;

ALTER TABLE `friendship`.`game_skill_recommend`
ADD COLUMN `voice_duration` int(10) NULL DEFAULT 0 COMMENT '语音时长' AFTER `status`;

ALTER TABLE `friendship`.`play_order_comment`
CHANGE COLUMN `start` `star` int(1) NULL DEFAULT NULL COMMENT '评分' AFTER `user_id`;

ALTER TABLE `friendship`.`advert_promote_user_device`
MODIFY COLUMN `c_id` varchar(32) NULL DEFAULT NULL COMMENT '创意id' AFTER `d_id`;

ALTER TABLE `friendship`.`user_device`
MODIFY COLUMN `ip` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0.0.0.0' COMMENT '用户IP' AFTER `androidid`;

-- 2020-09-23 陪玩师注册表
ALTER TABLE `friendship`.`play_game_config`
ADD COLUMN `sort_score` int(4) NULL DEFAULT 0 COMMENT '排序权重' AFTER `billing_way`,
ADD COLUMN `is_edit_rank` tinyint(2) NULL DEFAULT 1 COMMENT '段位是否可编辑0:不可编辑，1:可编辑' AFTER `sort_score`;

-- 2020-09-4 陪玩形象卡推荐
ALTER TABLE `friendship`.`play_image_card_recommend`
ADD COLUMN `score` double(14, 0) NULL COMMENT '排名(分值越大越靠前)' AFTER `user_gender`;

--2020-09-25 发现菜单
ALTER TABLE `friendship`.`ios_menu`
ADD COLUMN `sort_score` int(4) NULL DEFAULT 0 COMMENT '排序权重' AFTER `type`;

-- 2020-09-26 用户信息
ALTER TABLE `friendship`.`user_info`
ADD COLUMN `auth_time` int(2) NULL DEFAULT 0 COMMENT '实名认证次数' AFTER `tags`;

-- 客户端信息
ALTER TABLE `friendship`.`user_device`
ADD COLUMN `system_version` varchar(24) NULL COMMENT '科幻端系统版本' AFTER `retention`;

-- 2020-09-27
ALTER TABLE `friendship`.`play_game_config`
ADD COLUMN `min_ios_version` varchar(16) NULL COMMENT 'ios最低支持版本' AFTER `is_edit_rank`,
ADD COLUMN `min_android_version` varchar(16) NULL COMMENT '安卓最低支持版本' AFTER `min_ios_version`;