"""remove_unused_tables

Revision ID: d13af6030e77
Revises: ff55991be102
Create Date: 2020-04-22 10:13:53.835689

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

# revision identifiers, used by Alembic.
revision = 'd13af6030e77'
down_revision = '531c40a3f0fb'
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_constraint('fk_Activity_create_user_id_HistoryUser', 'Activity', type_='foreignkey')
    op.drop_constraint('fk_Activity_activity_type_id_CampaignType', 'Activity', type_='foreignkey')
    op.drop_constraint('fk_Activity_edit_user_id_HistoryUser', 'Activity', type_='foreignkey')
    op.create_foreign_key(op.f('fk_Activity_edit_user_id_User'), 'Activity', 'User', ['edit_user_id'], ['auth0_id'])
    op.create_foreign_key(op.f('fk_Activity_create_user_id_User'), 'Activity', 'User', ['create_user_id'], ['auth0_id'])
    op.drop_column('Activity', 'activity_type_id')
    op.drop_constraint('fk_Campaign_edit_user_id_HistoryUser', 'Campaign', type_='foreignkey')
    op.drop_constraint('fk_Campaign_color_schema_id_ColorSchema', 'Campaign', type_='foreignkey')
    op.drop_constraint('fk_Campaign_create_user_id_HistoryUser', 'Campaign', type_='foreignkey')
    op.create_foreign_key(op.f('fk_Campaign_create_user_id_User'), 'Campaign', 'User', ['create_user_id'], ['auth0_id'])
    op.create_foreign_key(op.f('fk_Campaign_edit_user_id_User'), 'Campaign', 'User', ['edit_user_id'], ['auth0_id'])
    op.drop_column('Campaign', 'color_schema_id')
    op.drop_constraint('fk_CampaignHistoryItem_activity_id_Activity', 'CampaignHistoryItem', type_='foreignkey')
    op.drop_constraint('fk_CampaignHistoryItem_campaign_id_Campaign', 'CampaignHistoryItem', type_='foreignkey')
    op.create_foreign_key(op.f('fk_CampaignHistoryItem_activity_id_Activity'), 'CampaignHistoryItem', 'Activity', ['activity_id'], ['id'], ondelete='CASCADE')
    op.create_foreign_key(op.f('fk_CampaignHistoryItem_campaign_id_Campaign'), 'CampaignHistoryItem', 'Campaign', ['campaign_id'], ['id'], ondelete='CASCADE')

    op.drop_constraint('fk_CampaignCampaignTypeDetailItem_campaign_type_detail__0d99', 'CampaignCampaignTypeDetailItem', type_='foreignkey')
    op.drop_constraint('fk_CampaignCampaignTypeDetailText_campaign_type_detail__3c43', 'CampaignCampaignTypeDetailText', type_='foreignkey')
    op.drop_constraint('fk_CampaignTypeDetailItem_campaign_type_detail_id_Campa_116b', 'CampaignTypeDetailItem', type_='foreignkey')

    op.drop_table('CampaignTypeDetail')
    op.drop_table('CampaignCampaignTypeDetailItem')
    op.drop_table('ColorSchema')
    op.drop_table('CampaignTypeDetailItem')
    op.drop_table('CampaignType')
    op.drop_table('HistoryUser')
    op.drop_table('CampaignCampaignTypeDetailText')
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_constraint(op.f('fk_CampaignHistoryItem_campaign_id_Campaign'), 'CampaignHistoryItem', type_='foreignkey')
    op.drop_constraint(op.f('fk_CampaignHistoryItem_activity_id_Activity'), 'CampaignHistoryItem', type_='foreignkey')
    op.create_foreign_key('fk_CampaignHistoryItem_campaign_id_Campaign', 'CampaignHistoryItem', 'Campaign', ['campaign_id'], ['id'])
    op.create_foreign_key('fk_CampaignHistoryItem_activity_id_Activity', 'CampaignHistoryItem', 'Activity', ['activity_id'], ['id'])
    op.add_column('Campaign', sa.Column('color_schema_id', sa.INTEGER(), server_default=sa.text('3'), autoincrement=False, nullable=False))
    op.drop_constraint(op.f('fk_Campaign_edit_user_id_User'), 'Campaign', type_='foreignkey')
    op.drop_constraint(op.f('fk_Campaign_create_user_id_User'), 'Campaign', type_='foreignkey')
    op.create_foreign_key('fk_Campaign_create_user_id_HistoryUser', 'Campaign', 'HistoryUser', ['create_user_id'], ['id'])
    op.create_foreign_key('fk_Campaign_color_schema_id_ColorSchema', 'Campaign', 'ColorSchema', ['color_schema_id'], ['id'])
    op.create_foreign_key('fk_Campaign_edit_user_id_HistoryUser', 'Campaign', 'HistoryUser', ['edit_user_id'], ['id'])
    op.add_column('Activity', sa.Column('activity_type_id', sa.INTEGER(), autoincrement=False, nullable=True))
    op.drop_constraint(op.f('fk_Activity_create_user_id_User'), 'Activity', type_='foreignkey')
    op.drop_constraint(op.f('fk_Activity_edit_user_id_User'), 'Activity', type_='foreignkey')
    op.create_foreign_key('fk_Activity_edit_user_id_HistoryUser', 'Activity', 'HistoryUser', ['edit_user_id'], ['id'])
    op.create_foreign_key('fk_Activity_activity_type_id_CampaignType', 'Activity', 'CampaignType', ['activity_type_id'], ['id'])
    op.create_foreign_key('fk_Activity_create_user_id_HistoryUser', 'Activity', 'HistoryUser', ['create_user_id'], ['id'])
    op.create_table('CampaignTypeDetail',
    sa.Column('id', sa.INTEGER(), server_default=sa.text('nextval(\'"CampaignTypeDetail_id_seq"\'::regclass)'), autoincrement=True, nullable=False),
    sa.Column('name', sa.VARCHAR(), autoincrement=False, nullable=False),
    sa.Column('is_text', sa.BOOLEAN(), autoincrement=False, nullable=False),
    sa.Column('campaign_type_id', sa.INTEGER(), autoincrement=False, nullable=False),
    sa.Column('parent_campaign_type_detail_item_id', sa.INTEGER(), autoincrement=False, nullable=True),
    sa.ForeignKeyConstraint(['campaign_type_id'], ['CampaignType.id'], name='fk_CampaignTypeDetail_campaign_type_id_CampaignType'),
    sa.ForeignKeyConstraint(['parent_campaign_type_detail_item_id'], ['CampaignTypeDetailItem.id'], name='fk_CampaignTypeDetail_parent_campaign_type_detail_item__f263'),
    sa.PrimaryKeyConstraint('id', name='pk_CampaignTypeDetail'), postgresql_ignore_search_path=False)
    op.create_table('CampaignCampaignTypeDetailText',
    sa.Column('id', sa.BIGINT(), server_default=sa.text('nextval(\'"CampaignCampaignTypeDetailText_id_seq"\'::regclass)'), autoincrement=True, nullable=False),
    sa.Column('campaign_id', sa.BIGINT(), autoincrement=False, nullable=False),
    sa.Column('campaign_type_detail_id', sa.INTEGER(), autoincrement=False, nullable=False),
    sa.Column('value', sa.VARCHAR(), autoincrement=False, nullable=False),
    sa.Column('activity_id', sa.INTEGER(), autoincrement=False, nullable=True),
    sa.ForeignKeyConstraint(['activity_id'], ['Activity.id'], name='fk_CampaignCampaignTypeDetailText_activity_id_Activity', ondelete='CASCADE'),
    sa.ForeignKeyConstraint(['campaign_id'], ['Campaign.id'], name='fk_CampaignCampaignTypeDetailText_campaign_id_Campaign', ondelete='CASCADE'),
    sa.ForeignKeyConstraint(['campaign_type_detail_id'], ['CampaignTypeDetail.id'], name='fk_CampaignCampaignTypeDetailText_campaign_type_detail__3c43'),
    sa.PrimaryKeyConstraint('id', name='pk_CampaignCampaignTypeDetailText'))
    op.create_table('HistoryUser',
    sa.Column('id', sa.VARCHAR(), autoincrement=False, nullable=False),
    sa.Column('email', sa.VARCHAR(), autoincrement=False, nullable=False),
    sa.Column('created_at', postgresql.TIMESTAMP(timezone=True), server_default=sa.text('CURRENT_TIMESTAMP'), autoincrement=False, nullable=False),
    sa.PrimaryKeyConstraint('id', name='pk_HistoryUser'), postgresql_ignore_search_path=False)
    op.create_table('CampaignType',
    sa.Column('id', sa.INTEGER(), server_default=sa.text('nextval(\'"CampaignType_id_seq"\'::regclass)'), autoincrement=True, nullable=False),
    sa.Column('name', sa.VARCHAR(), autoincrement=False, nullable=False),
    sa.PrimaryKeyConstraint('id', name='pk_CampaignType'), postgresql_ignore_search_path=False)
    op.create_table('CampaignTypeDetailItem',
    sa.Column('id', sa.INTEGER(), server_default=sa.text('nextval(\'"CampaignTypeDetailItem_id_seq"\'::regclass)'), autoincrement=True, nullable=False),
    sa.Column('name', sa.VARCHAR(), autoincrement=False, nullable=False),
    sa.Column('campaign_type_detail_id', sa.INTEGER(), autoincrement=False, nullable=False),
    sa.ForeignKeyConstraint(['campaign_type_detail_id'], ['CampaignTypeDetail.id'], name='fk_CampaignTypeDetailItem_campaign_type_detail_id_Campa_116b'),
    sa.PrimaryKeyConstraint('id', name='pk_CampaignTypeDetailItem'), postgresql_ignore_search_path=False)
    op.create_table('ColorSchema',
    sa.Column('id', sa.INTEGER(), server_default=sa.text('nextval(\'"ColorSchema_id_seq"\'::regclass)'), autoincrement=True, nullable=False),
    sa.Column('name', sa.VARCHAR(), autoincrement=False, nullable=False),
    sa.Column('schema', postgresql.JSON(astext_type=sa.Text()), autoincrement=False, nullable=False),
    sa.PrimaryKeyConstraint('id', name='pk_ColorSchema'), postgresql_ignore_search_path=False)
    op.create_table('CampaignCampaignTypeDetailItem',
    sa.Column('id', sa.BIGINT(), server_default=sa.text('nextval(\'"CampaignCampaignTypeDetailItem_id_seq"\'::regclass)'), autoincrement=True, nullable=False),
    sa.Column('campaign_id', sa.BIGINT(), autoincrement=False, nullable=False),
    sa.Column('campaign_type_detail_id', sa.INTEGER(), autoincrement=False, nullable=False),
    sa.Column('campaign_type_detail_item_id', sa.INTEGER(), autoincrement=False, nullable=False),
    sa.Column('activity_id', sa.INTEGER(), autoincrement=False, nullable=True),
    sa.ForeignKeyConstraint(['activity_id'], ['Activity.id'], name='fk_CampaignCampaignTypeDetailItem_activity_id_Activity', ondelete='CASCADE'),
    sa.ForeignKeyConstraint(['campaign_id'], ['Campaign.id'], name='fk_CampaignCampaignTypeDetailItem_campaign_id_Campaign', ondelete='CASCADE'),
    sa.ForeignKeyConstraint(['campaign_type_detail_id'], ['CampaignTypeDetail.id'], name='fk_CampaignCampaignTypeDetailItem_campaign_type_detail__0d99'),
    sa.ForeignKeyConstraint(['campaign_type_detail_item_id'], ['CampaignTypeDetailItem.id'], name='fk_CampaignCampaignTypeDetailItem_campaign_type_detail__5d28'),
    sa.PrimaryKeyConstraint('id', name='pk_CampaignCampaignTypeDetailItem')
    )
    # ### end Alembic commands ###