"""remove CampaignTerritory

Revision ID: f56140b04fc1
Revises: bbdb0b646783
Create Date: 2019-07-16 14:46:10.672464

"""
from alembic import op
import sqlalchemy as sa
from sqlalchemy.dialects import postgresql

# revision identifiers, used by Alembic.
revision = 'f56140b04fc1'
down_revision = 'bbdb0b646783'
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_table('CampaignTerritory')


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.create_table('CampaignTerritory',
    sa.Column('campaign_id', sa.BIGINT(), autoincrement=False, nullable=False),
    sa.Column('territory_id', sa.INTEGER(), autoincrement=False, nullable=False),
    sa.ForeignKeyConstraint(['campaign_id'], ['Campaign.id'], name='fk_CampaignTerritory_campaign_id_Campaign', ondelete='CASCADE'),
    sa.ForeignKeyConstraint(['territory_id'], ['Territory.id'], name='fk_CampaignTerritory_territory_id_Territory'),
    sa.PrimaryKeyConstraint('campaign_id', 'territory_id', name='pk_CampaignTerritory')
    )
    # ### end Alembic commands ###