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

--- 2020-06-01
ALTER TABLE `friendship`.`user_not_interested_info`
ADD COLUMN `create_time` timestamp(0) NULL COMMENT '创建时间' AFTER `type`;


ALTER TABLE `friendship`.`topic`
add column `topic_group_manager` bigint(20) NULL COMMENT '话题群主' AFTER `title`;

--- 20200602
ALTER TABLE `friendship`.`user_black`
ADD UNIQUE INDEX `idx_userId_targetUserId`(`user_id`, `target_user_id`) USING BTREE COMMENT '用户id和targetid创建唯一索引';

--- 20200603
ALTER TABLE `friendship`.`fatelink_history`
ADD COLUMN `type` tinyint(1) NULL COMMENT '类型,语音畅聊/文字连连看' AFTER `chat_room_id`;

-- 20200609
ALTER TABLE `friendship`.`user_video`
ADD COLUMN `is_fill` tinyint(1) NULL COMMENT '是否撑满屏幕' AFTER `video_url`;

-- 20200611
ALTER TABLE `friendship`.`topic`
ADD COLUMN `new_title` varchar(120) NULL COMMENT '新标题' AFTER `status`,
ADD COLUMN `new_cover_img` varchar(255) NULL COMMENT '新背景' AFTER `new_title`,
ADD COLUMN `create_time` timestamp(0) NULL COMMENT '创建时间' AFTER `release_time`,
ADD column `verify_user_id` bigint(20) NULL COMMENT '审核人id' AFTER `create_time`,
ADD COLUMN `verify_date` timestamp(0) NULL COMMENT '审核时间' AFTER `verify_user_id`;

-- 20200612
ALTER TABLE `friendship`.`topic`
ADD COLUMN `announcement_title` varchar(120) NULL COMMENT '公告标题' AFTER `title`,
ADD COLUMN `announcement_content` varchar(240) NULL COMMENT '公告内容' AFTER `announcement_title`;

-- 20200615
INSERT INTO  `friendship`.`system_config`(`name`,`value`,`des`,`create_time`,`sn`) values ('创建话题需要的u豆',50,'4.2.0版本第一次创建话题免费',now(),'CJHTXYDUD');

ALTER TABLE `friendship`.`topic`
ADD COLUMN `user_account_detail_id` bigint(20) NULL COMMENT '消费u豆订单Id' AFTER `create_time`,
ADD COLUMN `before_edit_status` tinyint(3) NULL COMMENT '编辑话题之前的状态' AFTER `status`;


-- 20200617
ALTER TABLE `friendship`.`group`
DROP INDEX `topicId`,
ADD UNIQUE INDEX `topicId`(`group_topic_id`) USING BTREE;

-- 20200622
ALTER TABLE `friendship`.`user_account`
MODIFY COLUMN `sugar` double(20, 2) NULL DEFAULT 0.0000 COMMENT 'q糖果' AFTER `user_id`,
MODIFY COLUMN `recharged` tinyint(1) NULL DEFAULT 0 COMMENT '是否充值过;0:未充值,1:充值过' AFTER `beans`,
MODIFY COLUMN `withdrawal_amount` decimal(10, 2) NULL DEFAULT 0.0000 COMMENT '提现总额' AFTER `recharged`;

ALTER TABLE `friendship`.`user_account_detail`
MODIFY COLUMN `before_sugar` double(20, 2) NULL DEFAULT 0.0000 COMMENT '交易前q糖' AFTER `after_beans`,
MODIFY COLUMN `trade_sugar` double(10, 2) NULL DEFAULT 0.0000 COMMENT '交易q糖' AFTER `before_sugar`,
MODIFY COLUMN `after_sugar` double(20, 2) NULL DEFAULT 0.0000 COMMENT '交易后的q糖' AFTER `trade_sugar`;

ALTER TABLE `friendship`.`vistor_info`
ADD UNIQUE INDEX `idx_userId_targetId`(`user_id`, `vistor_user_id`) USING BTREE COMMENT '用户id和被访问人的id生成唯一索引';

ALTER TABLE `friendship`.`user_account_with_draw_detail`
MODIFY COLUMN `remark` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注信息' AFTER `verify_date`;