diff options
Diffstat (limited to 'alembic/versions')
| -rw-r--r-- | alembic/versions/c0c4d0fbcee2_init_database.py (renamed from alembic/versions/1627487324fd_init_database.py) | 13 |
1 files changed, 9 insertions, 4 deletions
diff --git a/alembic/versions/1627487324fd_init_database.py b/alembic/versions/c0c4d0fbcee2_init_database.py index f25277f..8f61846 100644 --- a/alembic/versions/1627487324fd_init_database.py +++ b/alembic/versions/c0c4d0fbcee2_init_database.py | |||
| @@ -1,8 +1,8 @@ | |||
| 1 | """init database | 1 | """init database |
| 2 | 2 | ||
| 3 | Revision ID: 1627487324fd | 3 | Revision ID: c0c4d0fbcee2 |
| 4 | Revises: | 4 | Revises: |
| 5 | Create Date: 2026-03-23 18:33:08.493629 | 5 | Create Date: 2026-03-23 21:19:28.195907 |
| 6 | 6 | ||
| 7 | """ | 7 | """ |
| 8 | 8 | ||
| @@ -13,7 +13,7 @@ import sqlalchemy as sa | |||
| 13 | from alembic import op | 13 | from alembic import op |
| 14 | 14 | ||
| 15 | # revision identifiers, used by Alembic. | 15 | # revision identifiers, used by Alembic. |
| 16 | revision: str = "1627487324fd" | 16 | revision: str = "c0c4d0fbcee2" |
| 17 | down_revision: Union[str, Sequence[str], None] = None | 17 | down_revision: Union[str, Sequence[str], None] = None |
| 18 | branch_labels: Union[str, Sequence[str], None] = None | 18 | branch_labels: Union[str, Sequence[str], None] = None |
| 19 | depends_on: Union[str, Sequence[str], None] = None | 19 | depends_on: Union[str, Sequence[str], None] = None |
| @@ -49,7 +49,12 @@ def upgrade() -> None: | |||
| 49 | sa.Column("id", sa.Integer(), autoincrement=True, nullable=False), | 49 | sa.Column("id", sa.Integer(), autoincrement=True, nullable=False), |
| 50 | sa.Column("user_id", sa.Integer(), nullable=False), | 50 | sa.Column("user_id", sa.Integer(), nullable=False), |
| 51 | sa.Column("invoice_id", sa.Integer(), nullable=False), | 51 | sa.Column("invoice_id", sa.Integer(), nullable=False), |
| 52 | sa.Column("receipt_file_id", sa.String(), nullable=False), | 52 | sa.Column("receipt_file", sa.JSON(), nullable=False), |
| 53 | sa.Column( | ||
| 54 | "status", | ||
| 55 | sa.Enum("PENDING", "ACCEPTED", "REJECTED", name="paymentstatus"), | ||
| 56 | nullable=False, | ||
| 57 | ), | ||
| 53 | sa.Column("datetime", sa.DateTime(), nullable=False), | 58 | sa.Column("datetime", sa.DateTime(), nullable=False), |
| 54 | sa.ForeignKeyConstraint( | 59 | sa.ForeignKeyConstraint( |
| 55 | ["invoice_id"], ["invoice.id"], name=op.f("fk_payment_invoice_id_invoice") | 60 | ["invoice_id"], ["invoice.id"], name=op.f("fk_payment_invoice_id_invoice") |
