aboutsummaryrefslogtreecommitdiff
path: root/migrations/versions/c08245a9c93f_.py
diff options
context:
space:
mode:
authorKaran Jayachandra <karan.jayachandra@nxp.com>2025-11-09 09:56:59 +0100
committerKaran Jayachandra <karan.jayachandra@nxp.com>2025-11-09 09:56:59 +0100
commit34d77cd777bd44d7bfe0e3ab3379f9be256ca88b (patch)
tree04fba9f8bb99ac8fa15a1048b0ee06cbfed7f25d /migrations/versions/c08245a9c93f_.py
parent90390365bd93a4ee086c2931bb70ffa571a726b9 (diff)
Moved to javascript codebase
Diffstat (limited to 'migrations/versions/c08245a9c93f_.py')
-rw-r--r--migrations/versions/c08245a9c93f_.py122
1 files changed, 0 insertions, 122 deletions
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 ###