Files
2026-11-16 20:45:22 +08:00

30 lines
825 B
Python

"""add web admin hardening user fields
Revision ID: 0009_web_admin_hardening
Revises: 0008_admin_audit_user_active
Create Date: 2026-06-06
"""
from __future__ import annotations
import sqlalchemy as sa
from alembic import op
revision = "0009_web_admin_hardening"
down_revision = "0008_admin_audit_user_active"
branch_labels = None
depends_on = None
def upgrade() -> None:
op.add_column("users", sa.Column("disabled_at", sa.DateTime(timezone=True), nullable=True))
op.add_column("users", sa.Column("disabled_reason", sa.Text(), nullable=True))
op.add_column("users", sa.Column("token_version", sa.Integer(), nullable=False, server_default="0"))
def downgrade() -> None:
op.drop_column("users", "token_version")
op.drop_column("users", "disabled_reason")
op.drop_column("users", "disabled_at")