"""add_id_to_campaign_target_item

Revision ID: 266cad6a2d92
Revises: 6cddb66908f8
Create Date: 2020-05-16 06:51:48.227480

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '266cad6a2d92'
down_revision = '6cddb66908f8'
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.alter_column('Artist', 'id',
               existing_type=sa.BIGINT(),
               type_=sa.Integer(),
               existing_server_default=sa.text('nextval(\'"Artist_id_seq"\'::regclass)'))
    op.add_column('CampaignTargetItem', sa.Column('id', sa.BigInteger(), nullable=True))
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_column('CampaignTargetItem', 'id')
    op.alter_column('Artist', 'id',
               existing_type=sa.Integer(),
               type_=sa.BIGINT(),
               existing_server_default=sa.text('nextval(\'"Artist_id_seq"\'::regclass)'))
    # ### end Alembic commands ###