"""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 ###