From 34d77cd777bd44d7bfe0e3ab3379f9be256ca88b Mon Sep 17 00:00:00 2001 From: Karan Jayachandra Date: Sun, 9 Nov 2025 09:56:59 +0100 Subject: Moved to javascript codebase --- migrations/versions/c08245a9c93f_.py | 122 ----------------------------------- 1 file changed, 122 deletions(-) delete mode 100644 migrations/versions/c08245a9c93f_.py (limited to 'migrations/versions/c08245a9c93f_.py') diff --git a/migrations/versions/c08245a9c93f_.py b/migrations/versions/c08245a9c93f_.py deleted file mode 100644 index 48b115b..0000000 --- a/migrations/versions/c08245a9c93f_.py +++ /dev/null @@ -1,122 +0,0 @@ -"""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 ### -- cgit v1.3.1