"""rename_activity_fields

Revision ID: ddacf0175c71
Revises: 7781536292d2
Create Date: 2020-08-07 12:13:46.230048

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = 'ddacf0175c71'
down_revision = '7781536292d2'
branch_labels = None
depends_on = None


def upgrade():
    bind = op.get_bind()
    bind.execute('''
        ALTER TABLE "CampaignTerritory" RENAME COLUMN activity_id TO campaign_id;
        ALTER TABLE "CampaignType" RENAME COLUMN activity_id TO campaign_id;
        ALTER TABLE "CampaignCityAndPlacements" RENAME COLUMN activity_type_id TO campaign_type_id;
        ALTER TABLE "UserProjectCampaignTypeGroup" RENAME COLUMN activity_type_group_id TO campaign_type_group_id;
    ''')



def downgrade():
    bind = op.get_bind()
    bind.execute('''
        ALTER TABLE "CampaignTerritory" RENAME COLUMN campaign_id TO activity_id;
        ALTER TABLE "CampaignType" RENAME COLUMN campaign_id TO activity_id;
        ALTER TABLE "CampaignCityAndPlacements" RENAME COLUMN campaign_type_id TO activity_type_id;
        ALTER TABLE "UserProjectCampaignTypeGroup" RENAME COLUMN campaign_type_group_id TO activity_type_group_id;
    ''')