"""accounts: add temp_password column for credential email pre-fill

Revision ID: 0048
Revises: 0047
Create Date: 2026-07-02

Changes:
  - accounts: add temp_password VARCHAR(255) NULL
    Stores the plain-text temporary password until the admin first logs in.
    Cleared to NULL after first login or manual reset.
"""
from alembic import op
import sqlalchemy as sa

revision = "0048"
down_revision = "0047"
branch_labels = None
depends_on = None


def upgrade() -> None:
    conn = op.get_bind()
    conn.execute(sa.text(
        "ALTER TABLE accounts ADD COLUMN IF NOT EXISTS temp_password VARCHAR(255) NULL"
    ))


def downgrade() -> None:
    conn = op.get_bind()
    conn.execute(sa.text("ALTER TABLE accounts DROP COLUMN IF EXISTS temp_password"))