def upgrade():
### commands auto generated by Alembic - please adjust! ###
op.create_table('scoreboard',
sa.Column('user_id', sa.BigInteger(), nullable=False),
sa.Column('ladder_name', sa.String(), nullable=False),
sa.Column('mmr', sa.Integer(), nullable=False),
sa.Column('matches', sa.Integer(), server_default='0', nullable=False),
sa.Column('win', sa.Integer(), server_default='0', nullable=False),
sa.Column('loss', sa.Integer(), server_default='0', nullable=False),
sa.Column('dodge', sa.Integer(), server_default='0', nullable=False),
sa.Column('leave', sa.Integer(), server_default='0', nullable=False),
sa.ForeignKeyConstraint(['user_id'], ['user.id'], ),
sa.PrimaryKeyConstraint('user_id', 'ladder_name')
)
op.create_index(op.f('ix_scoreboard_mmr'), 'scoreboard', ['mmr'], unique=False)
op.add_column('match', sa.Column('radiant_win', sa.Boolean(), nullable=True))
op.add_column('match', sa.Column('section', sa.String(), server_default='high', nullable=False))
op.add_column('player_in_match', sa.Column('is_dodge', sa.Boolean(), server_default='false', nullable=False))
op.add_column('user', sa.Column('section', sa.String(), nullable=True))
### end Alembic commands ###
评论列表
文章目录