"""add_new_columns_campaign

Revision ID: 120b53873f01
Revises: 1e9bcb5c2f0d
Create Date: 2022-07-25 12:53:43.080386

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

# revision identifiers, used by Alembic.
revision = '120b53873f01'
down_revision = '1e9bcb5c2f0d'
branch_labels = None
depends_on = None


def upgrade():
    op.add_column('Campaign', sa.Column('actual_spent', sa.Numeric(precision=12, scale=2), nullable=True))
    op.add_column('Campaign', sa.Column('creative_description', sa.String(), nullable=True))
    op.add_column('Campaign', sa.Column('headline', sa.String(), nullable=True))
    op.add_column('Campaign', sa.Column('call_to_action', sa.String(), nullable=True))


def downgrade():
    op.drop_column('Campaign', 'call_to_action')
    op.drop_column('Campaign', 'headline')
    op.drop_column('Campaign', 'creative_description')
    op.drop_column('Campaign', 'actual_spent')