"""Remove varchar constraints

Revision ID: ac5ce0f00261
Revises: 9d5891808931
Create Date: 2019-04-30 16:29:15.574643

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = 'ac5ce0f00261'
down_revision = '9d5891808931'
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.alter_column(
        'Artist', 'name',
        existing_type=sa.VARCHAR(length=200),
        type_=sa.String(),
        existing_nullable=False)
    op.alter_column(
        'Campaign', 'name',
        existing_type=sa.VARCHAR(length=200),
        type_=sa.String(),
        existing_nullable=False)
    op.alter_column(
        'CampaignCampaignTypeDetailText', 'value',
        existing_type=sa.VARCHAR(length=200),
        type_=sa.String(),
        existing_nullable=False)
    op.alter_column(
        'CampaignType', 'name',
        existing_type=sa.VARCHAR(length=50),
        type_=sa.String(),
        existing_nullable=False)
    op.alter_column(
        'CampaignTypeDetail', 'name',
        existing_type=sa.VARCHAR(length=50),
        type_=sa.String(),
        existing_nullable=False)
    op.alter_column(
        'CampaignTypeDetailItem', 'name',
        existing_type=sa.VARCHAR(length=50),
        type_=sa.String(),
        existing_nullable=False)
    op.alter_column(
        'Contact', 'email',
        existing_type=sa.VARCHAR(length=100),
        type_=sa.String(),
        existing_nullable=False)
    op.alter_column(
        'Contact', 'name',
        existing_type=sa.VARCHAR(length=200),
        type_=sa.String(),
        existing_nullable=False)
    op.alter_column(
        'Contact', 'phone',
        existing_type=sa.VARCHAR(length=50),
        type_=sa.String(),
        existing_nullable=False)
    op.alter_column(
        'Currency', 'name',
        existing_type=sa.VARCHAR(length=50),
        type_=sa.String(),
        existing_nullable=False)
    op.alter_column(
        'Label', 'name',
        existing_type=sa.VARCHAR(length=50),
        type_=sa.String(),
        existing_nullable=False)
    op.alter_column(
        'Record', 'name',
        existing_type=sa.VARCHAR(length=200),
        type_=sa.String(),
        existing_nullable=False)
    op.alter_column(
        'RecordType', 'name',
        existing_type=sa.VARCHAR(length=50),
        type_=sa.String(),
        existing_nullable=False)
    op.alter_column(
        'Territory', 'name',
        existing_type=sa.VARCHAR(length=50),
        type_=sa.String(),
        existing_nullable=False)
    op.alter_column(
        'TerritoryType', 'name',
        existing_type=sa.VARCHAR(length=50),
        type_=sa.String(),
        existing_nullable=False)
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.alter_column(
        'TerritoryType', 'name',
        existing_type=sa.String(),
        type_=sa.VARCHAR(length=50),
        existing_nullable=False)
    op.alter_column(
        'Territory', 'name',
        existing_type=sa.String(),
        type_=sa.VARCHAR(length=50),
        existing_nullable=False)
    op.alter_column(
        'RecordType', 'name',
        existing_type=sa.String(),
        type_=sa.VARCHAR(length=50),
        existing_nullable=False)
    op.alter_column(
        'Record', 'name',
        existing_type=sa.String(),
        type_=sa.VARCHAR(length=200),
        existing_nullable=False)
    op.alter_column(
        'Label', 'name',
        existing_type=sa.String(),
        type_=sa.VARCHAR(length=50),
        existing_nullable=False)
    op.alter_column(
        'Currency', 'name',
        existing_type=sa.String(),
        type_=sa.VARCHAR(length=50),
        existing_nullable=False)
    op.alter_column(
        'Contact', 'phone',
        existing_type=sa.String(),
        type_=sa.VARCHAR(length=50),
        existing_nullable=False)
    op.alter_column(
        'Contact', 'name',
        existing_type=sa.String(),
        type_=sa.VARCHAR(length=200),
        existing_nullable=False)
    op.alter_column(
        'Contact', 'email',
        existing_type=sa.String(),
        type_=sa.VARCHAR(length=100),
        existing_nullable=False)
    op.alter_column(
        'CampaignTypeDetailItem', 'name',
        existing_type=sa.String(),
        type_=sa.VARCHAR(length=50),
        existing_nullable=False)
    op.alter_column(
        'CampaignTypeDetail', 'name',
        existing_type=sa.String(),
        type_=sa.VARCHAR(length=50),
        existing_nullable=False)
    op.alter_column(
        'CampaignType', 'name',
        existing_type=sa.String(),
        type_=sa.VARCHAR(length=50),
        existing_nullable=False)
    op.alter_column(
        'CampaignCampaignTypeDetailText', 'value',
        existing_type=sa.String(),
        type_=sa.VARCHAR(length=200),
        existing_nullable=False)
    op.alter_column(
        'Campaign', 'name',
        existing_type=sa.String(),
        type_=sa.VARCHAR(length=200),
        existing_nullable=False)
    op.alter_column(
        'Artist', 'name',
        existing_type=sa.String(),
        type_=sa.VARCHAR(length=200),
        existing_nullable=False)
    # ### end Alembic commands ###