# game

**Repository Path**: dmnmg/game

## Basic Information

- **Project Name**: game
- **Description**: 电竞api
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 1
- **Created**: 2021-03-16
- **Last Updated**: 2025-01-16

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

alter table payment_order
	add cc_name varchar(255) null;

alter table payment_order
	add cc_no varchar(255) null;

alter table payment_order
	add bank_name varchar(255) null;


2022-05-11
-- auto-generated definition
create table rank_rapid
(
id                bigint auto_increment
primary key,
user_id           bigint       null,
total_game_played int          null,
total_game_won    int          null,
win_rate          double       null,
coins_won         int          null,
user_name         varchar(255) null
)
comment '竞猜榜';

-- auto-generated definition
create table rank_tournament
(
id                int auto_increment
primary key,
type              int            not null comment '1 个人 2 团队',
team_id           bigint         not null comment '团队ID',
team_name         varchar(255)   null comment '团队名称',
total_game_played int            null comment '总场次',
champion          int            null comment '冠军数',
runner_up         int            null comment '亚军',
second_runner_up  int            null comment '季军',
prize_won         decimal(10, 2) null comment '奖金'
)
comment '赛事榜 半年更新一次' auto_increment = 139;

alter table user add referral_code varchar(50) null;
alter table user add referral_id bigint null comment '被邀请人的Id';
create unique index user_referral_code_uindex on user (referral_code);

create table referral_log
(
to_user         bigint         not null,
referral_user   bigint         not null,
amount          decimal(10, 2) not null,
order_id        bigint         not null,
referral_log_id bigint auto_increment
primary key
)
comment '邀请收益记录' auto_increment = 8;


alter table rank_rapid
add avatar varchar(1000) null;
alter table rank_tournament
add avatar varchar(1000) null;


alter table referral_log modify amount decimal(10, 2) not null comment '推荐的人收到的'
alter table referral_log add r_amount decimal(10, 2) null comment '被推荐的人收到的'