"""refactor activity and campaign tables

Revision ID: 51b32afcd395
Revises: cfa57bfd688a
Create Date: 2019-07-04 13:37:59.946518

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '51b32afcd395'
down_revision = 'cfa57bfd688a'
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.add_column('Activity', sa.Column('currency_id', sa.Integer(), nullable=True))
    op.drop_constraint('fk_Activity_campaign_id_Campaign', 'Activity', type_='foreignkey')
    op.create_foreign_key(op.f('fk_Activity_currency_id_Currency'), 'Activity', 'Currency', ['currency_id'], ['id'])
    op.create_foreign_key(op.f('fk_Activity_campaign_id_Campaign'), 'Activity', 'Campaign', ['campaign_id'], ['id'], ondelete='CASCADE')
    op.drop_constraint('fk_Campaign_kpi_id_Kpi', 'Campaign', type_='foreignkey')
    op.drop_constraint('fk_Campaign_campaign_type_id_CampaignType', 'Campaign', type_='foreignkey')
    op.drop_column('Campaign', 'actual_budget')
    op.drop_column('Campaign', 'kpi_id')
    op.drop_column('Campaign', 'campaign_type_id')
    op.add_column('CampaignCampaignTypeDetailText', sa.Column('activity_id', sa.Integer(), nullable=True))
    op.create_foreign_key(op.f('fk_CampaignCampaignTypeDetailText_activity_id_Activity'), 'CampaignCampaignTypeDetailText', 'Activity', ['activity_id'], ['id'], ondelete='CASCADE')
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_constraint(op.f('fk_CampaignCampaignTypeDetailText_activity_id_Activity'), 'CampaignCampaignTypeDetailText', type_='foreignkey')
    op.drop_column('CampaignCampaignTypeDetailText', 'activity_id')
    op.add_column('Campaign', sa.Column('campaign_type_id', sa.INTEGER(), autoincrement=False, nullable=True))
    op.add_column('Campaign', sa.Column('kpi_id', sa.INTEGER(), autoincrement=False, nullable=True))
    op.add_column('Campaign', sa.Column('actual_budget', sa.NUMERIC(precision=12, scale=2), autoincrement=False, nullable=True))
    op.create_foreign_key('fk_Campaign_campaign_type_id_CampaignType', 'Campaign', 'CampaignType', ['campaign_type_id'], ['id'])
    op.create_foreign_key('fk_Campaign_kpi_id_Kpi', 'Campaign', 'Kpi', ['kpi_id'], ['id'])
    op.drop_constraint(op.f('fk_Activity_campaign_id_Campaign'), 'Activity', type_='foreignkey')
    op.drop_constraint(op.f('fk_Activity_currency_id_Currency'), 'Activity', type_='foreignkey')
    op.create_foreign_key('fk_Activity_campaign_id_Campaign', 'Activity', 'Campaign', ['campaign_id'], ['id'])
    op.drop_column('Activity', 'currency_id')
    # ### end Alembic commands ###