"""rename_activities_to_campaigns

Revision ID: 7781536292d2
Revises: ef097a0b1f3a
Create Date: 2020-07-31 11:29:21.731976

"""
from alembic import op


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


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###

    bind = op.get_bind()

    ## RENAME ActivityGoal TO CampaignGoal
    bind.execute('''
            ALTER TABLE "ActivityGoal_id_seq" RENAME TO "CampaignGoal_id_seq";
            ALTER INDEX "pk_ActivityGoal" RENAME TO "pk_CampaignGoal";
    ''')
    bind.execute('''
            ALTER TABLE "ActivityGoal" RENAME TO "CampaignGoal";
        ''')
    bind.execute('''
            ALTER SEQUENCE public."CampaignGoal_id_seq" OWNED BY public."CampaignGoal".id;
        ''')

    ## RENAME ActivityTypeCity TO CampaignTypeCity
    bind.execute('''
            ALTER TABLE "ActivityTypeCity_id_seq" RENAME TO "CampaignTypeCity_id_seq";
            ALTER INDEX "pk_ActivityTypeCity" RENAME TO "pk_CampaignTypeCity";
    ''')
    bind.execute('''
            ALTER TABLE "ActivityTypeCity" RENAME TO "CampaignTypeCity";
    ''')
    bind.execute('''
            ALTER SEQUENCE public."CampaignTypeCity_id_seq" OWNED BY public."CampaignTypeCity".id;
    ''')

    ## RENAME ActivityTypeGroup TO CampaignTypeGroup
    bind.execute('''
            ALTER TABLE "ActivityTypeGroup_id_seq" RENAME TO "CampaignTypeGroup_id_seq";
            ALTER INDEX "pk_ActivityTypeGroup" RENAME TO "pk_CampaignTypeGroup";
    ''')
    bind.execute('''
            ALTER TABLE "ActivityTypeGroup" RENAME TO "CampaignTypeGroup";
    ''')
    bind.execute('''
            ALTER SEQUENCE public."CampaignTypeGroup_id_seq" OWNED BY public."CampaignTypeGroup".id;
    ''')

    ## RENAME ActivityTypeWidget TO CampaignTypeWidget
    bind.execute('''
            ALTER TABLE "ActivityTypeWidget_id_seq" RENAME TO "CampaignTypeWidget_id_seq";
            ALTER INDEX "pk_ActivityTypeWidget" RENAME TO "pk_CampaignTypeWidget";
    ''')
    bind.execute('''
            ALTER TABLE "ActivityTypeWidget" RENAME TO "CampaignTypeWidget";
    ''')
    bind.execute('''
            ALTER SEQUENCE public."CampaignTypeWidget_id_seq" OWNED BY public."CampaignTypeWidget".id;
    ''')

    ## RENAME ActivityObjective TO CampaignObjective
    bind.execute('''
            ALTER TABLE "ActivityObjective_id_seq" RENAME TO "CampaignObjective_id_seq";
            ALTER INDEX "pk_ActivityObjective" RENAME TO "pk_CampaignObjective";
            ALTER TABLE "ActivityObjective" RENAME CONSTRAINT "fk_ActivityObjective_goal_id_ActivityGoal" TO "fk_CampaignObjective_goal_id_CampaignGoal"
    ''')
    bind.execute('''
            ALTER TABLE "ActivityObjective" RENAME TO "CampaignObjective";
    ''')
    bind.execute('''
            ALTER SEQUENCE public."CampaignObjective_id_seq" OWNED BY public."CampaignObjective".id;
    ''')

    ## RENAME ActivityTypeCategory TO CampaignTypeCategory
    bind.execute('''
            ALTER TABLE "ActivityTypeCategory_id_seq" RENAME TO "CampaignTypeCategory_id_seq";
            ALTER INDEX "pk_ActivityTypeCategory" RENAME TO "pk_CampaignTypeCategory";
            ALTER INDEX "uq_ActivityTypeCategory_id" RENAME TO "uq_CampaignTypeCategory_id";
            ALTER TABLE "ActivityTypeCategory" RENAME CONSTRAINT "fk_ActivityTypeCategory_group_id_ActivityTypeGroup" TO "fk_CampaignTypeCategory_group_id_CampaignTypeGroup";
            ALTER TABLE "ActivityTypeCategory" RENAME CONSTRAINT "fk_ActivityTypeCategory_widget_id_ActivityTypeWidget" TO "fk_CampaignTypeCategory_widget_id_CampaignTypeWidget";
    ''')
    bind.execute('''
            ALTER TABLE "ActivityTypeCategory" RENAME TO "CampaignTypeCategory";
    ''')
    bind.execute('''
            ALTER SEQUENCE public."CampaignTypeCategory_id_seq" OWNED BY public."CampaignTypeCategory".id;
    ''')

    ## RENAME Activity TO Campaign
    bind.execute('''
            ALTER TABLE "Activity_id_seq" RENAME TO "Campaign_id_seq";
            ALTER INDEX "pk_Activity" RENAME TO "pk_Campaign";

            ALTER TABLE "Activity" RENAME CONSTRAINT "fk_Activity_create_user_id_User" TO "fk_Campaign_create_user_id_User";
            ALTER TABLE "Activity" RENAME CONSTRAINT "fk_Activity_currency_id_Currency" TO "fk_Campaign_currency_id_Currency";
            ALTER TABLE "Activity" RENAME CONSTRAINT "fk_Activity_edit_user_id_User" TO "fk_Campaign_edit_user_id_User";
            ALTER TABLE "Activity" RENAME CONSTRAINT "fk_Activity_goal_id_ActivityGoal" TO "fk_Campaign_goal_id_CampaignGoal";
            ALTER TABLE "Activity" RENAME CONSTRAINT "fk_Activity_objective_id_ActivityObjective" TO "fk_Campaign_objective_id_CampaignObjective";
            ALTER TABLE "Activity" RENAME CONSTRAINT "fk_Activity_project_id_Project" TO "fk_Campaign_project_id_Project";
    ''')
    bind.execute('''
            ALTER TABLE "Activity" RENAME TO "Campaign";
    ''')
    bind.execute('''
            ALTER SEQUENCE public."Campaign_id_seq" OWNED BY public."Campaign".id;
    ''')

    ## RENAME ActivityTypeValue TO CampaignTypeValue
    bind.execute('''
                ALTER TABLE "ActivityTypeValue_id_seq" RENAME TO "CampaignTypeValue_id_seq";
                ALTER INDEX "pk_ActivityTypeValue" RENAME TO "pk_CampaignTypeValue";
                ALTER INDEX "uq_ActivityTypeValue_name_category_id" RENAME TO "uq_CampaignTypeValue_name_category_id";

                ALTER TABLE "ActivityTypeValue" RENAME CONSTRAINT "fk_ActivityTypeValue_category_id_ActivityTypeCategory" TO "fk_CampaignTypeValue_category_id_CampaignTypeCategory";
                ALTER TABLE "ActivityTypeValue" RENAME CONSTRAINT "fk_ActivityTypeValue_group_id_ActivityTypeGroup" TO "fk_CampaignTypeValue_group_id_CampaignTypeGroup";
        ''')
    bind.execute('''
                ALTER TABLE "ActivityTypeValue" RENAME TO "CampaignTypeValue";
        ''')
    bind.execute('''
                ALTER SEQUENCE public."CampaignTypeValue_id_seq" OWNED BY public."CampaignTypeValue".id;
        ''')

    ## RENAME ActivityTerritory TO CampaignTerritory
    bind.execute('''
                ALTER INDEX "pk_ActivityTerritory" RENAME TO "pk_CampaignTerritory";

                ALTER TABLE "ActivityTerritory" RENAME CONSTRAINT "fk_ActivityTerritory_activity_id_Activity" TO "fk_CampaignTerritory_campaign_id_Campaign";
                ALTER TABLE "ActivityTerritory" RENAME CONSTRAINT "fk_ActivityTerritory_territory_id_Territory" TO "fk_CampaignTerritory_territory_id_Territory";
        ''')
    bind.execute('''
                ALTER TABLE "ActivityTerritory" RENAME TO "CampaignTerritory";
        ''')

    ## RENAME ActivityType TO CampaignType
    bind.execute('''
                ALTER TABLE "ActivityType_id_seq" RENAME TO "CampaignType_id_seq";
                ALTER INDEX "ActivityType_pkey" RENAME TO "pk_CampaignType";

                ALTER TABLE "ActivityType" RENAME CONSTRAINT "fk_ActivityType_activity_id_Activity" TO "fk_CampaignType_campaign_id_Campaign";
                ALTER TABLE "ActivityType" RENAME CONSTRAINT "fk_ActivityType_category_id_ActivityTypeCategory" TO "fk_CampaignType_category_id_CampaignTypeCategory";
                ALTER TABLE "ActivityType" RENAME CONSTRAINT "fk_ActivityType_value_id_ActivityTypeValue" TO "fk_CampaignType_value_id_CampaignTypeValue";
        ''')
    bind.execute('''
                ALTER TABLE "ActivityType" RENAME TO "CampaignType";
        ''')
    bind.execute('''
                ALTER SEQUENCE public."CampaignType_id_seq" OWNED BY public."CampaignType".id;
        ''')

    ## RENAME ActivityTypeCategoryValue TO CampaignTypeCategoryValue
    bind.execute('''
                ALTER INDEX "uq_ActivityTypeCategoryValue_category_id" RENAME TO "uq_CampaignTypeCategoryValue_category_id";

                ALTER TABLE "ActivityTypeCategoryValue" RENAME CONSTRAINT "fk_ActivityTypeCategoryValue_category_id_ActivityTypeCategory" TO "fk_CampaignTypeCategoryValue_category_id_CampaignTypeCategory";
                ALTER TABLE "ActivityTypeCategoryValue" RENAME CONSTRAINT "fk_ActivityTypeCategoryValue_parent_value_id_ActivityTypeValue" TO "fk_CampaignTypeCategoryValue_parent_value_id_CampaignTypeValue";
        ''')
    bind.execute('''
                ALTER TABLE "ActivityTypeCategoryValue" RENAME TO "CampaignTypeCategoryValue";
        ''')

    ## RENAME UserProjectActivityTypeGroup TO UserProjectCampaignTypeGroup
    bind.execute('''
                ALTER INDEX "pk_UserProjectActivityTypeGroup" RENAME TO "pk_UserProjectCampaignTypeGroup";

                ALTER TABLE "UserProjectActivityTypeGroup" RENAME CONSTRAINT "fk_UserProjectActivityTypeGroup_activity_type_group_id_7f12" TO "fk_UserProjectCampaignTypeGroup_campaign_type_group_id_ctg";
                ALTER TABLE "UserProjectActivityTypeGroup" RENAME CONSTRAINT "fk_UserProjectActivityTypeGroup_user_project_id_UserProject" TO "fk_UserProjectCampaignTypeGroup_user_project_id_UserProject";
        ''')
    bind.execute('''
                ALTER TABLE "UserProjectActivityTypeGroup" RENAME TO "UserProjectCampaignTypeGroup";
        ''')

    ## RENAME ActivityCityAndPlacements TO CampaignCityAndPlacements
    bind.execute('''
                ALTER TABLE "ActivityCityAndPlacements_id_seq" RENAME TO "CampaignCityAndPlacements_id_seq";
                ALTER INDEX "pk_ActivityCityAndPlacements" RENAME TO "pk_CampaignCityAndPlacements";

                ALTER TABLE "ActivityCityAndPlacements" RENAME CONSTRAINT "fk_ActivityCityAndPlacements_activity_type_id_ActivityType" TO "fk_CampaignCityAndPlacements_campaign_type_id_CampaignType";
                ALTER TABLE "ActivityCityAndPlacements" RENAME CONSTRAINT "fk_ActivityCityAndPlacements_city_id_ActivityTypeCity" TO "fk_CampaignCityAndPlacements_city_id_CampaignTypeCity";
        ''')
    bind.execute('''
                ALTER TABLE "ActivityCityAndPlacements" RENAME TO "CampaignCityAndPlacements";
        ''')
    bind.execute('''
                ALTER SEQUENCE public."CampaignCityAndPlacements_id_seq" OWNED BY public."CampaignCityAndPlacements".id;
        ''')

    ## RENAME ProjectHistoryItem fields
    bind.execute('''
                ALTER TABLE "ProjectHistoryItem" RENAME CONSTRAINT "fk_ProjectHistoryItem_activity_id_Activity" TO "fk_ProjectHistoryItem_campaign_id_Campaign";
                ALTER TABLE "ProjectHistoryItem" RENAME COLUMN "activity_id" TO "campaign_id";

        ''')

    bind.execute('''
               UPDATE "ProjectHistoryAction" SET type='add_campaign' WHERE id=1;
               UPDATE "ProjectHistoryAction" SET type='remove_campaign' WHERE id=2;
               UPDATE "ProjectHistoryAction" SET type='update_campaign_timeline' WHERE id=3;
               UPDATE "ProjectHistoryAction" SET type='update_campaign_budget' WHERE id=4;
               UPDATE "ProjectHistoryAction" SET type='change_campaign_phases' WHERE id=12;
               UPDATE "ProjectHistoryAction" SET type='change_campaign_platform' WHERE id=13;
               UPDATE "ProjectHistoryAction" SET type='update_campaign_objective' WHERE id=25;
               UPDATE "ProjectHistoryAction" SET type='update_campaign_notes' WHERE id=26;
               UPDATE "ProjectHistoryAction" SET type='update_campaign_types' WHERE id=27;
               UPDATE "ProjectHistoryAction" SET type='update_campaign_name' WHERE id=28;
            ''')


def downgrade():
    bind = op.get_bind()

    ## RENAME CampaignGoal TO ActivityGoal
    bind.execute('''
            ALTER TABLE "CampaignGoal_id_seq" RENAME TO "ActivityGoal_id_seq";
            ALTER INDEX "pk_CampaignGoal" RENAME TO "pk_ActivityGoal";
    ''')
    bind.execute('''
            ALTER TABLE "CampaignGoal" RENAME TO "ActivityGoal";
        ''')
    bind.execute('''
            ALTER SEQUENCE public."ActivityGoal_id_seq" OWNED BY public."ActivityGoal".id;
        ''')

    ## RENAME CampaignTypeCity TO ActivityTypeCity
    bind.execute('''
            ALTER TABLE "CampaignTypeCity_id_seq" RENAME TO "ActivityTypeCity_id_seq";
            ALTER INDEX "pk_CampaignTypeCity" RENAME TO "pk_ActivityTypeCity";
    ''')
    bind.execute('''
            ALTER TABLE "CampaignTypeCity" RENAME TO "ActivityTypeCity";
    ''')
    bind.execute('''
            ALTER SEQUENCE public."ActivityTypeCity_id_seq" OWNED BY public."ActivityTypeCity".id;
    ''')

    ## RENAME CampaignTypeGroup TO ActivityTypeGroup
    bind.execute('''
            ALTER TABLE "CampaignTypeGroup_id_seq" RENAME TO "ActivityTypeGroup_id_seq";
            ALTER INDEX "pk_CampaignTypeGroup" RENAME TO "pk_ActivityTypeGroup";
    ''')
    bind.execute('''
            ALTER TABLE "CampaignTypeGroup" RENAME TO "ActivityTypeGroup";
    ''')
    bind.execute('''
            ALTER SEQUENCE public."ActivityTypeGroup_id_seq" OWNED BY public."ActivityTypeGroup".id;
    ''')

    ## RENAME CampaignTypeWidget TO ActivityTypeWidget
    bind.execute('''
            ALTER TABLE "CampaignTypeWidget_id_seq" RENAME TO "ActivityTypeWidget_id_seq";
            ALTER INDEX "pk_CampaignTypeWidget" RENAME TO "pk_ActivityTypeWidget";
    ''')
    bind.execute('''
            ALTER TABLE "CampaignTypeWidget" RENAME TO "ActivityTypeWidget";
    ''')
    bind.execute('''
            ALTER SEQUENCE public."ActivityTypeWidget_id_seq" OWNED BY public."ActivityTypeWidget".id;
    ''')

    ## RENAME CampaignObjective TO ActivityObjective
    bind.execute('''
            ALTER TABLE "CampaignObjective_id_seq" RENAME TO "ActivityObjective_id_seq";
            ALTER INDEX "pk_CampaignObjective" RENAME TO "pk_ActivityObjective";
            ALTER TABLE "CampaignObjective" RENAME CONSTRAINT "fk_CampaignObjective_goal_id_CampaignGoal" TO "fk_ActivityObjective_goal_id_ActivityGoal"
    ''')
    bind.execute('''
            ALTER TABLE "CampaignObjective" RENAME TO "ActivityObjective";
    ''')
    bind.execute('''
            ALTER SEQUENCE public."ActivityObjective_id_seq" OWNED BY public."ActivityObjective".id;
    ''')

    ## RENAME CampaignTypeCategory TO ActivityTypeCategory
    bind.execute('''
            ALTER TABLE "CampaignTypeCategory_id_seq" RENAME TO "ActivityTypeCategory_id_seq";
            ALTER INDEX "pk_CampaignTypeCategory" RENAME TO "pk_ActivityTypeCategory";
            ALTER INDEX "uq_CampaignTypeCategory_id" RENAME TO "uq_ActivityTypeCategory_id";
            ALTER TABLE "CampaignTypeCategory" RENAME CONSTRAINT "fk_CampaignTypeCategory_group_id_CampaignTypeGroup" TO "fk_ActivityTypeCategory_group_id_ActivityTypeGroup";
            ALTER TABLE "CampaignTypeCategory" RENAME CONSTRAINT "fk_CampaignTypeCategory_widget_id_CampaignTypeWidget" TO "fk_ActivityTypeCategory_widget_id_ActivityTypeWidget";
    ''')
    bind.execute('''
            ALTER TABLE "CampaignTypeCategory" RENAME TO "ActivityTypeCategory";
    ''')
    bind.execute('''
            ALTER SEQUENCE public."ActivityTypeCategory_id_seq" OWNED BY public."ActivityTypeCategory".id;
    ''')

    ## RENAME Campaign TO Activity
    bind.execute('''
            ALTER TABLE "Campaign_id_seq" RENAME TO "Activity_id_seq";
            ALTER INDEX "pk_Campaign" RENAME TO "pk_Activity";

            ALTER TABLE "Campaign" RENAME CONSTRAINT "fk_Campaign_create_user_id_User" TO "fk_Activity_create_user_id_User";
            ALTER TABLE "Campaign" RENAME CONSTRAINT "fk_Campaign_currency_id_Currency" TO "fk_Activity_currency_id_Currency";
            ALTER TABLE "Campaign" RENAME CONSTRAINT "fk_Campaign_edit_user_id_User" TO "fk_Activity_edit_user_id_User";
            ALTER TABLE "Campaign" RENAME CONSTRAINT "fk_Campaign_goal_id_CampaignGoal" TO "fk_Activity_goal_id_ActivityGoal";
            ALTER TABLE "Campaign" RENAME CONSTRAINT "fk_Campaign_objective_id_CampaignObjective" TO "fk_Activity_objective_id_ActivityObjective";
            ALTER TABLE "Campaign" RENAME CONSTRAINT "fk_Campaign_project_id_Project" TO "fk_Activity_project_id_Project";
    ''')
    bind.execute('''
            ALTER TABLE "Campaign" RENAME TO "Activity";
    ''')
    bind.execute('''
            ALTER SEQUENCE public."Activity_id_seq" OWNED BY public."Activity".id;
    ''')

    ## RENAME CampaignTerritory TO ActivityTerritory
    bind.execute('''
                ALTER INDEX "pk_CampaignTerritory" RENAME TO "pk_ActivityTerritory";

                ALTER TABLE "CampaignTerritory" RENAME CONSTRAINT "fk_CampaignTerritory_campaign_id_Campaign" TO "fk_ActivityTerritory_activity_id_Activity";
                ALTER TABLE "CampaignTerritory" RENAME CONSTRAINT "fk_CampaignTerritory_territory_id_Territory" TO "fk_ActivityTerritory_territory_id_Territory";
        ''')
    bind.execute('''
                ALTER TABLE "CampaignTerritory" RENAME TO "ActivityTerritory";
        ''')

    ## RENAME CampaignTypeValue TO ActivityTypeValue
    bind.execute('''
                ALTER TABLE "CampaignTypeValue_id_seq" RENAME TO "ActivityTypeValue_id_seq";
                ALTER INDEX "pk_CampaignTypeValue" RENAME TO "pk_ActivityTypeValue";
                ALTER INDEX "uq_CampaignTypeValue_name_category_id" RENAME TO "uq_ActivityTypeValue_name_category_id";

                ALTER TABLE "CampaignTypeValue" RENAME CONSTRAINT "fk_CampaignTypeValue_category_id_CampaignTypeCategory" TO "fk_ActivityTypeValue_category_id_ActivityTypeCategory";
                ALTER TABLE "CampaignTypeValue" RENAME CONSTRAINT "fk_CampaignTypeValue_group_id_CampaignTypeGroup" TO "fk_ActivityTypeValue_group_id_ActivityTypeGroup";
        ''')
    bind.execute('''
                ALTER TABLE "CampaignTypeValue" RENAME TO "ActivityTypeValue";
        ''')
    bind.execute('''
                ALTER SEQUENCE public."ActivityTypeValue_id_seq" OWNED BY public."ActivityTypeValue".id;
        ''')

    ## RENAME CampaignType TO ActivityType
    bind.execute('''
                ALTER TABLE "CampaignType_id_seq" RENAME TO "ActivityType_id_seq";
                ALTER INDEX "pk_CampaignType" RENAME TO "ActivityType_pkey";

                ALTER TABLE "CampaignType" RENAME CONSTRAINT "fk_CampaignType_campaign_id_Campaign" TO "fk_ActivityType_activity_id_Activity";
                ALTER TABLE "CampaignType" RENAME CONSTRAINT "fk_CampaignType_category_id_CampaignTypeCategory" TO "fk_ActivityType_category_id_ActivityTypeCategory";
                ALTER TABLE "CampaignType" RENAME CONSTRAINT "fk_CampaignType_value_id_CampaignTypeValue" TO "fk_ActivityType_value_id_ActivityTypeValue";
        ''')
    bind.execute('''
                ALTER TABLE "CampaignType" RENAME TO "ActivityType";
        ''')
    bind.execute('''
                ALTER SEQUENCE public."ActivityType_id_seq" OWNED BY public."ActivityType".id;
        ''')

    ## RENAME CampaignTypeCategoryValue TO ActivityTypeCategoryValue
    bind.execute('''
                ALTER INDEX "uq_CampaignTypeCategoryValue_category_id" RENAME TO "uq_ActivityTypeCategoryValue_category_id";

                ALTER TABLE "CampaignTypeCategoryValue" RENAME CONSTRAINT "fk_CampaignTypeCategoryValue_category_id_CampaignTypeCategory" TO "fk_ActivityTypeCategoryValue_category_id_ActivityTypeCategory";
                ALTER TABLE "CampaignTypeCategoryValue" RENAME CONSTRAINT "fk_CampaignTypeCategoryValue_parent_value_id_CampaignTypeValue" TO "fk_ActivityTypeCategoryValue_parent_value_id_ActivityTypeValue";
        ''')
    bind.execute('''
                ALTER TABLE "CampaignTypeCategoryValue" RENAME TO "ActivityTypeCategoryValue";
        ''')

    ## RENAME UserProjectCampaignTypeGroup TO UserProjectActivityTypeGroup
    bind.execute('''
                ALTER INDEX "pk_UserProjectCampaignTypeGroup" RENAME TO "pk_UserProjectActivityTypeGroup";

                ALTER TABLE "UserProjectCampaignTypeGroup" RENAME CONSTRAINT "fk_UserProjectCampaignTypeGroup_campaign_type_group_id_ctg" TO "fk_UserProjectActivityTypeGroup_activity_type_group_id_7f12";
                ALTER TABLE "UserProjectCampaignTypeGroup" RENAME CONSTRAINT "fk_UserProjectCampaignTypeGroup_user_project_id_UserProject" TO "fk_UserProjectActivityTypeGroup_user_project_id_UserProject";
        ''')
    bind.execute('''
                ALTER TABLE "UserProjectCampaignTypeGroup" RENAME TO "UserProjectActivityTypeGroup";
        ''')

    ## RENAME CampaignCityAndPlacements TO ActivityCityAndPlacements
    bind.execute('''
                ALTER TABLE "CampaignCityAndPlacements_id_seq" RENAME TO "ActivityCityAndPlacements_id_seq";
                ALTER INDEX "pk_CampaignCityAndPlacements" RENAME TO "pk_ActivityCityAndPlacements";

                ALTER TABLE "CampaignCityAndPlacements" RENAME CONSTRAINT "fk_CampaignCityAndPlacements_campaign_type_id_CampaignType" TO "fk_ActivityCityAndPlacements_activity_type_id_ActivityType";
                ALTER TABLE "CampaignCityAndPlacements" RENAME CONSTRAINT "fk_CampaignCityAndPlacements_city_id_CampaignTypeCity" TO "fk_ActivityCityAndPlacements_city_id_ActivityTypeCity";
        ''')
    bind.execute('''
                ALTER TABLE "CampaignCityAndPlacements" RENAME TO "ActivityCityAndPlacements";
        ''')
    bind.execute('''
                ALTER SEQUENCE public."ActivityCityAndPlacements_id_seq" OWNED BY public."ActivityCityAndPlacements".id;
        ''')

    ## RENAME ProjectHistoryItem fields
    bind.execute('''
                ALTER TABLE "ProjectHistoryItem" RENAME CONSTRAINT "fk_ProjectHistoryItem_campaign_id_Campaign" TO "fk_ProjectHistoryItem_activity_id_Activity";
                ALTER TABLE "ProjectHistoryItem" RENAME COLUMN "campaign_id" TO "activity_id";

        ''')