"""Add users is_active flag

Revision ID: b6c2d9a4e731
Revises: 98f8d7817d98
Create Date: 2026-09-30
"""
from alembic import op
import sqlalchemy as sa


revision = "b6c2d9a4e731"
down_revision = "98f8d7817d98"
branch_labels = None
depends_on = None


def upgrade():
    op.add_column(
        "users",
        sa.Column(
            "is_active",
            sa.Boolean(),
            nullable=False,
            server_default=sa.text("1"),
        ),
    )
    # Existing rows, if any, are active by default. Remove the DB-level
    # default afterwards so the SQLAlchemy model remains the source of truth.
    op.alter_column("users", "is_active", server_default=None)


def downgrade():
    op.drop_column("users", "is_active")