""" Enforce the nocase collation on the email table

Revision ID: 049fed905da7
Revises: 49d77a93118e
Create Date: 2018-04-21 13:23:56.571524

"""

# revision identifiers, used by Alembic.
revision = '049fed905da7'
down_revision = '49d77a93118e'

from alembic import op
import sqlalchemy as sa


def upgrade():
    with op.batch_alter_table('user') as batch:
        batch.alter_column('email', type_=sa.String(length=255, collation="NOCASE"))


def downgrade():
    with op.batch_alter_table('user') as batch:
        batch.alter_column('email', type_=sa.String(length=255))


Enforce the nocase collation on the email table