friendship-parent/doc/ddl/modify/V5.0.sql

ALTER TABLE `friendship`.`banner_and_radio`
ADD COLUMN `redirect` int(3) NULL COMMENT '跳转页面' AFTER `id`;

ALTER TABLE `friendship`.`pretty_account`
ADD COLUMN `create_time` timestamp(0) NULL COMMENT '创建时间' AFTER `status`;

ALTER TABLE `yingtao`.`room`
ADD COLUMN `score` bigint(15) NULL COMMENT '火力值' AFTER `top_place`;

ALTER TABLE `yingtao`.`room`
CHANGE COLUMN `score` `fire_power` bigint(15) NULL DEFAULT NULL COMMENT '火力值' AFTER `top_place`;

ALTER TABLE `yingtao`.`users`
ADD COLUMN `uq_pretty_account` bigint(10) NULL COMMENT '友期靓号' AFTER `share_code`;

INSERT INTO `yingtao`.`sys_conf`(`config_id`, `config_name`, `config_value`, `name_space`, `config_status`) VALUES ('gift_gain_cost_min_rate', '砸蛋收入最小比例', '0.95', 'draw_rate_min', 1);
INSERT INTO `yingtao`.`sys_conf`(`config_id`, `config_name`, `config_value`, `name_space`, `config_status`) VALUES ('gift_gain_cost_max_rate', '砸蛋收入最大比例', '1.05', 'draw_rate_max', 1);