"""drop is_global rename global to unknown

Revision ID: 99cce4e312a2
Revises: 2527bdb25fb7
Create Date: 2026-04-13 09:50:32.114771

"""
from typing import Sequence, Union

from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision: str = '99cce4e312a2'
down_revision: Union[str, Sequence[str], None] = '2527bdb25fb7'
branch_labels: Union[str, Sequence[str], None] = None
depends_on: Union[str, Sequence[str], None] = None


def upgrade() -> None:
    """Upgrade schema."""
    # Rename "Global" user to "unknown"
    op.execute(
        "UPDATE users SET name = 'unknown' "
        "WHERE id = '00000000-0000-0000-0000-000000000000'"
    )
    # Drop the is_global column (no longer needed — identified by fixed UUID)
    op.drop_column('users', 'is_global')


def downgrade() -> None:
    """Downgrade schema."""
    op.add_column('users', sa.Column('is_global', sa.BOOLEAN(), autoincrement=False, nullable=False, server_default=sa.text('false')))
    # Restore is_global flag and name for the global user
    op.execute(
        "UPDATE users SET is_global = true, name = 'Global' "
        "WHERE id = '00000000-0000-0000-0000-000000000000'"
    )