"""add email column to login table

Revision ID: add_email_to_login
Revises: bd97ab8ba7db
Create Date: 2025-06-24
"""

from alembic import op
import sqlalchemy as sa

def upgrade():
    op.add_column('login', sa.Column('email', sa.String(length=120), nullable=True))
    op.create_unique_constraint('uq_login_email', 'login', ['email'])

def downgrade():
    op.drop_constraint('uq_login_email', 'login', type_='unique')
    op.drop_column('login', 'email')