From 8e034766bb7e2d23f88c5ff1a254126f11a5f412 Mon Sep 17 00:00:00 2001 From: Tolmachev Igor Date: Mon, 23 Mar 2026 02:33:54 +0300 Subject: Fix database models --- alembic/versions/5d998cafe1ba_init_database.py | 55 -------------------------- 1 file changed, 55 deletions(-) delete mode 100644 alembic/versions/5d998cafe1ba_init_database.py (limited to 'alembic/versions/5d998cafe1ba_init_database.py') diff --git a/alembic/versions/5d998cafe1ba_init_database.py b/alembic/versions/5d998cafe1ba_init_database.py deleted file mode 100644 index e55e4ed..0000000 --- a/alembic/versions/5d998cafe1ba_init_database.py +++ /dev/null @@ -1,55 +0,0 @@ -"""init database - -Revision ID: 5d998cafe1ba -Revises: -Create Date: 2026-03-23 00:05:14.621886 - -""" -from typing import Sequence, Union - -from alembic import op -import sqlalchemy as sa - - -# revision identifiers, used by Alembic. -revision: str = '5d998cafe1ba' -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('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.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') - # ### end Alembic commands ### -- cgit v1.3