From d5994e732d7b1dfa469cf400132ba49c8f75315e Mon Sep 17 00:00:00 2001 From: Tolmachev Igor Date: Mon, 23 Mar 2026 18:40:40 +0300 Subject: Add new_invoice command --- alembic/versions/940afc736a0f_init_database.py | 72 -------------------------- 1 file changed, 72 deletions(-) delete mode 100644 alembic/versions/940afc736a0f_init_database.py (limited to 'alembic/versions/940afc736a0f_init_database.py') diff --git a/alembic/versions/940afc736a0f_init_database.py b/alembic/versions/940afc736a0f_init_database.py deleted file mode 100644 index bfaa771..0000000 --- a/alembic/versions/940afc736a0f_init_database.py +++ /dev/null @@ -1,72 +0,0 @@ -"""init database - -Revision ID: 940afc736a0f -Revises: -Create Date: 2026-03-23 02:21:35.245634 - -""" - -from typing import Sequence, Union - -import sqlalchemy as sa - -from alembic import op - -# revision identifiers, used by Alembic. -revision: str = "940afc736a0f" -down_revision: Union[str, Sequence[str], None] = None -branch_labels: Union[str, Sequence[str], None] = None -depends_on: Union[str, Sequence[str], None] = None - - -def upgrade() -> None: - """Upgrade schema.""" - # ### commands auto generated by Alembic - please adjust! ### - op.create_table( - "announcement", - sa.Column("id", sa.Integer(), autoincrement=True, nullable=False), - sa.Column("message", sa.JSON(), nullable=False), - sa.Column("datetime", sa.DateTime(), nullable=False), - sa.PrimaryKeyConstraint("id", name=op.f("pk_announcement")), - ) - op.create_table( - "invoice", - sa.Column("id", sa.Integer(), autoincrement=True, nullable=False), - sa.Column("amount", sa.Float(), nullable=False), - sa.Column("datetime", sa.DateTime(), nullable=False), - sa.PrimaryKeyConstraint("id", name=op.f("pk_invoice")), - ) - op.create_table( - "user", - sa.Column("id", sa.Integer(), autoincrement=False, nullable=False), - sa.Column("role", sa.Enum("REGULAR", "ADMIN", name="userrole"), nullable=False), - sa.Column("vpn_link", sa.String(), nullable=False), - sa.Column("datetime", sa.DateTime(), nullable=False), - sa.PrimaryKeyConstraint("id", name=op.f("pk_user")), - ) - op.create_table( - "payment", - sa.Column("id", sa.Integer(), autoincrement=True, nullable=False), - sa.Column("user_id", sa.Integer(), nullable=False), - sa.Column("invoice_id", sa.Integer(), nullable=False), - sa.Column("receipt_file_id", sa.String(), nullable=False), - sa.Column("datetime", sa.DateTime(), nullable=False), - sa.ForeignKeyConstraint( - ["invoice_id"], ["invoice.id"], name=op.f("fk_payment_invoice_id_invoice") - ), - sa.ForeignKeyConstraint( - ["user_id"], ["user.id"], name=op.f("fk_payment_user_id_user") - ), - sa.PrimaryKeyConstraint("id", name=op.f("pk_payment")), - ) - # ### end Alembic commands ### - - -def downgrade() -> None: - """Downgrade schema.""" - # ### commands auto generated by Alembic - please adjust! ### - op.drop_table("payment") - op.drop_table("user") - op.drop_table("invoice") - op.drop_table("announcement") - # ### end Alembic commands ### -- cgit v1.3