"""Add is_admin flag to users table.
Revision ID: 005
Revises: 004
Create Date: 2024-01-05 00:00:00.000000
Replaces hardcoded email domain checks for admin access with
an explicit is_admin boolean flag.
"""
from collections.abc import Sequence
import sqlalchemy as sa
from alembic import op
# revision identifiers, used by Alembic.
revision: str = "005"
down_revision: str | None = "004"
branch_labels: str | Sequence[str] | None = None
depends_on: str | Sequence[str] | None = None
def upgrade() -> None:
# Add is_admin column to users table
op.add_column(
"users",
sa.Column("is_admin", sa.Boolean(), server_default="false", nullable=False),
)
def downgrade() -> None:
op.drop_column("users", "is_admin")
