sql更新

2019-5-27

## 增加appoint_winner表

SET FOREIGN_KEY_CHECKS=0;

DROP TABLE IF EXISTS `appoint_winner`;

CREATE TABLE `appoint_winner`(

`id` int(11) NOT NULL AUTO_INCREMENT,

`admin_id` int(11) DEFAULT NULL,

`period_id` int(11) DEFAULT NULL,

`player_id` int(11) DEFAULT NULL,

`create_time` datetime(6) DEFAULT NULL,

PRIMARY KEY (`id`),

KEY `appoint_winner_general_index_admin_id` (`admin_id`),

KEY `appoint_winner_general_index_period_id` (`period_id`),

KEY `appoint_winner_general_index_player_id` (`player_id`),

CONSTRAINT `fk_appoint_winner_admin_id` FOREIGN KEY (`admin_id`) REFERENCES `administrator`(`userprofilebasic_ptr_id`),

CONSTRAINT `fk_appoint_winner_period_id` FOREIGN KEY (`period_id`) REFERENCES `period`(`id`),

CONSTRAINT `fk_appoint_winner_player_id` FOREIGN KEY (`player_id`) REFERENCES `game_player`(`userprofilebasic_ptr_id`)

)ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

ALTER TABLE `platform_everyday_data` ADD `shipment_phone_deposit_cny` decimal(16, 1) DEFAULT NULL;

ALTER TABLE `platform_everyday_data` ADD `shipment_phone_shipment_cny` decimal(16, 1) DEFAULT NULL;

ALTER TABLE `platform_everyday_data` ADD `shipment_phone_profit_and_loss`decimal(16,1) DEFAULT NULL;

CREATE TABLE `section_money_record`(

`id` int(11) NOT NULL AUTO_INCREMENT,

`section_mix` int(11) DEFAULT 0,

`section_max` int(11) DEFAULT 0,

`present_amounts` int(11) DEFAULT 0,

`text` longtext DEFAULT '',

PRIMARY KEY (`id`)

)ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

ALTER TABLE `commodity` ADD `cover` varchar(1024) DEFAULT NULL;

ALTER TABLE `rb_everyday_info` ADD `ls_cny` decimal(16,1) DEFAULT NULL;

SET FOREIGN_KEY_CHECKS=0;

DROP TABLE IF EXISTS `user_everymonth_info`;

CREATE TABLE `user_everymonth_info`(

`id` int(11) NOT NULL AUTO_INCREMENT,

`player_id` int(11) DEFAULT NULL,

`consume_money` decimal(8,1) DEFAULT NULL,

`deposit_money` decimal(8,1) DEFAULT NULL,

`bonus` decimal(8,1) DEFAULT NULL,

`presents_money` decimal(8,1) DEFAULT NULL,

`snatch_treasure_b` decimal(8,1) DEFAULT NULL,

`order_count`  int(11) DEFAULT NULL,

`player_id` int(11) DEFAULT NULL,

`data_date` varchar(16) DEFAULT NULL,

`update_time` datetime(6) DEFAULT NULL,

PRIMARY KEY (`id`),

KEY `user_everymonth_info_general_index_player_id` (`player_id`),

CONSTRAINT `fk_user_everymonth_info_player_id` FOREIGN KEY (`player_id`) REFERENCES `game_player`(`userprofilebasic_ptr_id`)

)ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;