"""empty message

Revision ID: c08245a9c93f
Revises: d158cf8f4950
Create Date: 2025-07-12 21:27:46.932139

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = 'c08245a9c93f'
down_revision = 'd158cf8f4950'
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.create_table('court',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('status', sa.Boolean(), nullable=False),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('player',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('first_name', sa.String(length=64), nullable=False),
    sa.Column('last_name', sa.String(length=64), nullable=False),
    sa.Column('team', sa.Integer(), nullable=False),
    sa.Column('status', sa.Boolean(), nullable=False),
    sa.Column('level', sa.Integer(), nullable=False),
    sa.PrimaryKeyConstraint('id')
    )
    with op.batch_alter_table('player', schema=None) as batch_op:
        batch_op.create_index(batch_op.f('ix_player_first_name'), ['first_name'], unique=False)
        batch_op.create_index(batch_op.f('ix_player_last_name'), ['last_name'], unique=False)
        batch_op.create_index(batch_op.f('ix_player_team'), ['team'], unique=False)

    op.create_table('game',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('round_id', sa.Integer(), nullable=False),
    sa.Column('court_id', sa.Integer(), nullable=False),
    sa.Column('player_1', sa.Integer(), nullable=False),
    sa.Column('player_2', sa.Integer(), nullable=False),
    sa.Column('player_3', sa.Integer(), nullable=False),
    sa.Column('player_4', sa.Integer(), nullable=False),
    sa.Column('date', sa.DateTime(), nullable=False),
    sa.ForeignKeyConstraint(['court_id'], ['court.id'], ),
    sa.ForeignKeyConstraint(['player_1'], ['player.id'], ),
    sa.ForeignKeyConstraint(['player_2'], ['player.id'], ),
    sa.ForeignKeyConstraint(['player_3'], ['player.id'], ),
    sa.ForeignKeyConstraint(['player_4'], ['player.id'], ),
    sa.PrimaryKeyConstraint('id')
    )
    with op.batch_alter_table('game', schema=None) as batch_op:
        batch_op.create_index(batch_op.f('ix_game_court_id'), ['court_id'], unique=False)
        batch_op.create_index(batch_op.f('ix_game_date'), ['date'], unique=False)
        batch_op.create_index(batch_op.f('ix_game_player_1'), ['player_1'], unique=False)
        batch_op.create_index(batch_op.f('ix_game_player_2'), ['player_2'], unique=False)
        batch_op.create_index(batch_op.f('ix_game_player_3'), ['player_3'], unique=False)
        batch_op.create_index(batch_op.f('ix_game_player_4'), ['player_4'], unique=False)
        batch_op.create_index(batch_op.f('ix_game_round_id'), ['round_id'], unique=False)

    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    with op.batch_alter_table('game', schema=None) as batch_op:
        batch_op.drop_index(batch_op.f('ix_game_round_id'))
        batch_op.drop_index(batch_op.f('ix_game_player_4'))
        batch_op.drop_index(batch_op.f('ix_game_player_3'))
        batch_op.drop_index(batch_op.f('ix_game_player_2'))
        batch_op.drop_index(batch_op.f('ix_game_player_1'))
        batch_op.drop_index(batch_op.f('ix_game_date'))
        batch_op.drop_index(batch_op.f('ix_game_court_id'))

    op.drop_table('game')
    with op.batch_alter_table('player', schema=None) as batch_op:
        batch_op.drop_index(batch_op.f('ix_player_team'))
        batch_op.drop_index(batch_op.f('ix_player_last_name'))
        batch_op.drop_index(batch_op.f('ix_player_first_name'))

    op.drop_table('player')
    op.drop_table('court')
    # ### end Alembic commands ###