"""add_campaign_style_json_column

Revision ID: 40a744571c9f
Revises: 81afc0752e2f
Create Date: 2023-03-02 15:25:32.419630

"""
from alembic import op
import sqlalchemy as sa
from sqlalchemy.dialects import postgresql

# revision identifiers, used by Alembic.
revision = '40a744571c9f'
down_revision = '81afc0752e2f'
branch_labels = None
depends_on = None


def upgrade():
    op.add_column('Campaign', sa.Column('style', postgresql.JSONB(astext_type=sa.Text()), nullable=True))
    op.alter_column('MediaPlan', 'project_id',
               existing_type=sa.BIGINT(),
               nullable=True)


def downgrade():
    op.alter_column('MediaPlan', 'project_id',
               existing_type=sa.BIGINT(),
               nullable=False)
    op.drop_column('Campaign', 'style')