-- 2020-07-06 10:00 -- 陪玩游戏配置表 ALTER TABLE `friendship`.`play_game_config` MODIFY COLUMN `status` tinyint(2) NULL DEFAULT 0 COMMENT '状态' AFTER `create_time`; -- 2020-07-06 10:00 -- 陪玩师注册表 ALTER TABLE `friendship`.`play_user_registered` ADD COLUMN `service_total_num` int(10) NULL DEFAULT 0 COMMENT '服务人数' AFTER `game_cover`; ALTER TABLE `friendship`.`play_user_registered` ADD COLUMN `remark` varchar(128) NULL COMMENT '拒绝理由' AFTER `service_total_num`; -- 2020-07-06 10:00 -- 陪玩师认证 ALTER TABLE `friendship`.`user` ADD COLUMN `game_authenticate` tinyint(2) NULL COMMENT '陪玩认证' AFTER `home_img`; -- 2020-07-07 20:13 ALTER TABLE `friendship`.`play_game_config` ADD COLUMN `certification_picture_template` varchar(256) NULL COMMENT '技能认证示例图' AFTER `game_cover`; -- 2020-07-08 19：00 ALTER TABLE `friendship`.`play_game_config` ADD COLUMN `dictionary_id` bigint(20) NULL COMMENT '技能段位字典id' AFTER `game_name`; -- 2020-07-08 20:13 -- 修改陪玩订单表 ALTER TABLE `friendship`.`play_orders` ADD COLUMN `create_time` timestamp(0) NULL COMMENT '订单创建时间' AFTER `status`, ADD COLUMN `receiving_order_time` timestamp(0) NULL COMMENT '接单时间' AFTER `create_time`, ADD COLUMN `confirm_service_time` timestamp(0) NULL COMMENT '确认服务时间' AFTER `receiving_order_time`, ADD COLUMN `start_service_time` timestamp(0) NULL COMMENT '开始服务时间' AFTER `confirm_service_time`, ADD COLUMN `complete_service_time` timestamp(0) NULL COMMENT '完成服务时间' AFTER `start_service_time`; ADD COLUMN `cancel_time` timestamp(0) NULL COMMENT '取消订单时间' AFTER `complete_service_time`; ADD COLUMN `pay_time` timestamp(0) NULL COMMENT '支付时间' AFTER `cancel_time`; ADD COLUMN `price` int(10) NULL COMMENT '每局的单价' AFTER `pay_time`; ADD COLUMN `refuse_order_time` timestamp(0) NULL COMMENT '拒绝订单时间' AFTER `price`; -- 2020-07-09 -- 增加系统配置 INSERT INTO `friendship`.`system_config`(`id`, `name`, `value`, `des`, `create_time`, `update_time`, `sn`) VALUES (10001024, '陪玩系统抽成', '0.2', '', '2020-07-09 10:50:48', '2020-07-09 10:50:51', 'PWXTCC'); INSERT INTO `friendship`.`system_config`(`id`, `name`, `value`, `des`, `create_time`, `update_time`, `sn`) VALUES (10001025, '陪玩每局游戏默认的U豆数', '30', NULL, '2020-07-09 16:06:04', '2020-07-09 16:06:06', 'PWMRYXYD'); -- 2020-07-09 -- 话题表增加推荐到首页的状态 ALTER TABLE `friendship`.`topic` ADD COLUMN `recomand_status` tinyint(2) DEFAULT NULL COMMENT '推荐到首页状态 0:已推荐,未推荐' AFTER `status`; -- 2020-07-17 -- 动态点赞增加未读消息状态 ALTER TABLE `friendship`.`daily_dynamics_user` ADD COLUMN `read_status` tinyint(2) NULL COMMENT '是否已读' AFTER `create_time`; -- 2020-07-17 -- 声卡点赞增加未读消息状态 ALTER TABLE `friendship`.`user_like_miss` ADD COLUMN `read_status` tinyint(2) NULL COMMENT '是否已读' AFTER `update_time`; -- 2020-07-20 -- 用户信息表 update user set game_authenticate = 0 where game_authenticate is null; -- 2020-07-20 -- 系统配置表 INSERT INTO `friendship`.`system_config`(`id`, `name`, `value`, `des`, `create_time`, `update_time`, `sn`) VALUES (10001026, '陪玩师默认的消息', '你好,需要游戏陪玩的可以直接发消息给我哦,我会尽快给你答复的,暂时不闲聊哈。', NULL, NULL, NULL, 'PWMRXX'); -- 2020-07-20 -- 配置默认审核状态 ALTER TABLE `friendship`.`play_user_registered` MODIFY COLUMN `service_status` tinyint(2) NULL DEFAULT 0 COMMENT '服务状态(接单中/暂停接单)' AFTER `verify_status`; -- 作品id 需要先清理数据 ALTER TABLE `friendship`.`user_like_miss` DROP INDEX `idx_userid_workId`, ADD UNIQUE INDEX `idx_userid_workId`(`user_id`, `works_id`) USING BTREE; -- 用户收入表 ALTER TABLE `friendship`.`reward_detail` CHANGE COLUMN `reward_user_id` `from_user_id` bigint(20) NULL DEFAULT NULL COMMENT '打赏/下单的用户id' AFTER `id`, CHANGE COLUMN `receive_reward_user_id` `to_user_id` bigint(20) NULL DEFAULT NULL COMMENT '收到收入的用户id' AFTER `from_user_id`, ADD COLUMN `type` tinyint(2) NULL COMMENT '收入类型' AFTER `receive_total_sugar`, ADD COLUMN `des` varchar(16) NULL COMMENT '收入说明' AFTER `type`; MODIFY COLUMN `type` tinyint(2) NULL DEFAULT 0 COMMENT '收入类型' AFTER `receive_total_sugar`; ALTER TABLE reward_detail RENAME TO user_income_detail; update user_income_detail set type = 1,des = '游戏陪玩收入' where gift_name is null; update user_income_detail set type = 0,des = '礼物打赏收入' where gift_name is not null; -- 2020-07-25 -- 陪玩订单表 ALTER TABLE `friendship`.`play_orders` ADD COLUMN `sugar` double(10, 2) NULL COMMENT 'Q糖' AFTER `refuse_order_time`, ADD COLUMN `money` double(10, 2) NULL COMMENT '对应的金额' AFTER `sugar`; -- 2020-07-27 -- 陪玩图片形象卡 ALTER TABLE `friendship`.`play_user_image_card_pictures` ADD COLUMN `is_fill` tinyint(2) NULL COMMENT '是否拉伸' AFTER `update_time`, ADD COLUMN `new_picture_src` varchar(300) NULL COMMENT '最新上传的图片url' AFTER `is_fill`; ADD COLUMN `new_picture_src_is_fill` tinyint(2) NULL COMMENT '新上传的图片是否需要拉伸' AFTER `new_picture_src`; -- 2020-07-27 -- 陪玩视频形象卡 ALTER TABLE `friendship`.`play_user_image_card_video` ADD COLUMN `is_fill` tinyint(2) NULL COMMENT '是否拉伸' AFTER `update_time`, ADD COLUMN `new_video_src` varchar(300) NULL COMMENT '新的视频url' AFTER `is_fill`, ADD COLUMN `new_video_cover_src` varchar(300) NULL COMMENT '新的视频的封面' AFTER `new_video_src`; ADD COLUMN `new_video_is_fill` tinyint(2) NULL COMMENT '新的视频是否需要拉伸' AFTER `new_video_cover_src`; update `friendship`.`system_config` set `value` = '150',`update_time` = '2020-07-27 11:51:20' where id = '10001025'; INSERT INTO `friendship`.`system_config`(`id`, `name`, `value`, `des`, `create_time`, `update_time`, `sn`) VALUES (10001027, '陪玩价格推荐价格', '150,300,500','价格之间用逗号隔开', NULL, NULL, 'PWTJXX'); -- 游戏技能配置增加计费方式 ALTER TABLE `friendship`.`play_game_config` ADD COLUMN `billing_way` tinyint(2) NULL COMMENT '计费方式' AFTER `status`; -- 更新收入表 update user_income_detail set type = 0,des = '礼物打赏收入' where type is null; -- 陪玩图片形象卡 ALTER TABLE `friendship`.`play_user_image_card_pictures` MODIFY COLUMN `is_fill` tinyint(2) NULL DEFAULT 0 COMMENT '是否拉伸' AFTER `update_time`; -- 陪玩形象卡推荐表 ALTER TABLE `friendship`.`play_image_card_recommend` ADD COLUMN `is_fill_status` varchar(20) NULL COMMENT '拉伸状态' AFTER `des`; -- 陪玩视频形象卡 ALTER TABLE `friendship`.`play_user_image_card_video` MODIFY COLUMN `is_fill` tinyint(2) NULL DEFAULT 0 COMMENT '是否拉伸' AFTER `update_time`; MODIFY COLUMN `new_video_is_fill` tinyint(2) NULL DEFAULT 0 COMMENT '新的视频是否需要拉伸' AFTER `new_video_cover_src`; -- 交友形象卡图片 ALTER TABLE `friendship`.`user_image_card_pictures` ADD COLUMN `is_fill` tinyint(2) NULL COMMENT '是否拉伸' AFTER `update_time`; MODIFY COLUMN `is_fill` tinyint(2) NULL DEFAULT 0 COMMENT '是否拉伸' AFTER `update_time`; -- 交友形象卡视频 ALTER TABLE `friendship`.`user_image_card_video` ADD COLUMN `is_fill` tinyint(2) NULL DEFAULT 0 COMMENT '是否拉伸' AFTER `update_time`; -- 形象卡推荐表 ALTER TABLE `friendship`.`image_card_recommand` ADD COLUMN `is_fill` varchar(16) NULL COMMENT '推荐的拉伸状态' AFTER `logic_delete`; -- 直播间 ALTER TABLE `friendship`.`live_room` ADD UNIQUE INDEX `idx_userId`(`user_id`) USING BTREE COMMENT '用户id唯一索引'; ALTER TABLE `friendship`.`live_room` ADD COLUMN `message_id` varchar(32) NOT NULL COMMENT '消息id' AFTER `create_time`; ALTER TABLE `friendship`.`live_room` ADD COLUMN `tag_id` varchar(32) NULL COMMENT '房间标签' AFTER `message_id`; ALTER TABLE `friendship`.`live_room` ADD COLUMN `type` tinyint(2) NULL COMMENT '房间类型' AFTER `tag_id`; ALTER TABLE `friendship`.`live_room` CHANGE COLUMN `create_time` `live_room_create_time` timestamp(0) NULL DEFAULT NULL COMMENT '创建时间' AFTER `live_status`, ADD COLUMN `live_room_close_time` timestamp(0) NULL COMMENT '直播间关闭时间' AFTER `type`; ADD COLUMN `live_room_close_time` timestamp(0) NULL COMMENT '直播间关闭时间' AFTER `type`; ALTER TABLE `friendship`.`live_room` ADD COLUMN `accompany_chat_chat_sec` int(10) NULL COMMENT '陪聊房间陪聊时长设置' AFTER `live_room_close_time`, ADD COLUMN `accompany_chat_gold_num` bigint(10) NULL COMMENT '陪聊金币' AFTER `accompany_chat_chat_sec`, ADD COLUMN `back_pic_url` varchar(255) NULL COMMENT '背景图' AFTER `accompany_chat_gold_num`; -- 修改group表名 ALTER TABLE `friendship`.`group` RENAME TO `topic_group`; -- 账户详情表 ALTER TABLE `friendship`.`user_account_detail` ADD COLUMN `to_user_id` bigint(20) NULL COMMENT '收到收入的用户id' AFTER `user_id`, ADD COLUMN `gift_id` bigint(20) NULL COMMENT '礼物id' AFTER `to_user_id`, ADD COLUMN `type` tinyint(2) NULL COMMENT '类型' AFTER `des`;