"""server_default_age_range_provider_id_fix

Revision ID: ebed3dbf4601
Revises: 6f1944095fce
Create Date: 2022-06-30 10:33:04.655813

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = 'ebed3dbf4601'
down_revision = '6f1944095fce'
branch_labels = None
depends_on = None


def upgrade():
    bind = op.get_bind()
    op.alter_column("Campaign", "age_range", server_default=None)
    op.alter_column("Campaign", "provider_id", server_default=None)

    bind.execute(''' UPDATE "Campaign" set age_range = null, provider_id = null where order_in_phase = 0 and campaign_status_id = 4 and (name is null or name = '') ''')


def downgrade():
    pass