"""add_deleted_at_to_transactions

Adds soft-delete support to the transactions table via a nullable deleted_at column.

Revision ID: txn002_add_deleted_at
Revises: 2695c78766a8
Create Date: 2026-04-24
"""
from alembic import op
import sqlalchemy as sa

revision = "txn002_add_deleted_at"
down_revision = "2695c78766a8"
branch_labels = None
depends_on = None


def upgrade() -> None:
    op.add_column(
        "transactions",
        sa.Column("deleted_at", sa.DateTime(), nullable=True),
    )
    op.create_index(
        "ix_transactions_deleted_at",
        "transactions",
        ["deleted_at"],
        unique=False,
    )


def downgrade() -> None:
    op.drop_index("ix_transactions_deleted_at", table_name="transactions")
    op.drop_column("transactions", "deleted_at")