"""Store Discord community identity on users.

Revision ID: 093
Revises: 092
"""
from alembic import op
import sqlalchemy as sa

revision = "093"
down_revision = "092"
branch_labels = None
depends_on = None


def upgrade() -> None:
    op.add_column("users", sa.Column("discord_user_id", sa.String(32), nullable=True))
    op.add_column("users", sa.Column("discord_username", sa.String(64), nullable=True))
    op.add_column(
        "users",
        sa.Column("discord_connected_at", sa.DateTime(timezone=True), nullable=True),
    )
    op.create_index("uq_users_discord_user_id", "users", ["discord_user_id"], unique=True)


def downgrade() -> None:
    op.drop_index("uq_users_discord_user_id", table_name="users")
    op.drop_column("users", "discord_connected_at")
    op.drop_column("users", "discord_username")
    op.drop_column("users", "discord_user_id")