"""accounts.union_id for the sign-in allowlist

Revision ID: 0002_account_union_id
Revises: 0001_initial
Create Date: 2026-10-14

"""
from alembic import op
import sqlalchemy as sa


revision = '0002_account_union_id'
down_revision = '0001_initial'
branch_labels = None
depends_on = None


def upgrade():
    with op.batch_alter_table('accounts', schema=None) as batch_op:
        batch_op.add_column(sa.Column('union_id', sa.String(length=64), nullable=True))


def downgrade():
    with op.batch_alter_table('accounts', schema=None) as batch_op:
        batch_op.drop_column('union_id')