"""campaign_history

Revision ID: 1ae9a74e9123
Revises: b909216b4972
Create Date: 2019-11-01 13:53:16.262192

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '1ae9a74e9123'
down_revision = 'b909216b4972'
branch_labels = None
depends_on = None


def upgrade():
    op.alter_column('CampaignHistory', 'history_user_id',
               existing_type=sa.VARCHAR(),
               nullable=True)
    op.alter_column('CampaignHistory', 'user_id',
               existing_type=sa.INTEGER(),
               nullable=False)
    op.create_foreign_key(op.f('fk_CampaignHistory_activity_id_Activity'), 'CampaignHistory', 'Activity', ['activity_id'], ['id'])
    op.create_foreign_key(op.f('fk_CampaignHistory_campaign_id_Campaign'), 'CampaignHistory', 'Campaign', ['campaign_id'], ['id'])


def downgrade():
    op.drop_constraint(op.f('fk_CampaignHistory_campaign_id_Campaign'), 'CampaignHistory', type_='foreignkey')
    op.drop_constraint(op.f('fk_CampaignHistory_activity_id_Activity'), 'CampaignHistory', type_='foreignkey')
    op.alter_column('CampaignHistory', 'user_id',
               existing_type=sa.INTEGER(),
               nullable=True)
    op.alter_column('CampaignHistory', 'history_user_id',
               existing_type=sa.VARCHAR(),
               nullable=False)