"""Add opt-in password login for review/service accounts.

Revision ID: 178
Revises: 177
"""
import sqlalchemy as sa
from alembic import op

revision = "178"
down_revision = "177"
branch_labels = None
depends_on = None


def upgrade():
    op.add_column("users", sa.Column("password_hash", sa.String(length=255), nullable=True))
    op.add_column(
        "users",
        sa.Column(
            "password_login_enabled",
            sa.Boolean(),
            nullable=False,
            server_default=sa.text("false"),
        ),
    )


def downgrade():
    op.drop_column("users", "password_login_enabled")
    op.drop_column("users", "password_hash")