"""add_ad_sets_table

Revision ID: d34838b29791
Revises: cd934930f352
Create Date: 2020-09-09 14:22:46.477935

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

# revision identifiers, used by Alembic.
revision = 'd34838b29791'
down_revision = 'cd934930f352'
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.create_table('CampaignAd',
    sa.Column('id', sa.BigInteger(), nullable=False),
    sa.Column('external_id', sa.String(), nullable=True),
    sa.Column('name', sa.String(), nullable=False),
    sa.Column('start_date', sa.Date(), nullable=False),
    sa.Column('end_date', sa.Date(), nullable=True),
    sa.Column('planned_budget', sa.Numeric(precision=12, scale=2), nullable=False),
    sa.Column('budget_spend', sa.Numeric(precision=12, scale=2), nullable=True),
    sa.Column('is_deleted', sa.Boolean(), server_default='FALSE', nullable=False),
    sa.Column('age_range', postgresql.INT4RANGE(), nullable=False),
    sa.Column('objective_id', sa.Integer(), nullable=False),
    sa.Column('campaign_id', sa.BigInteger(), nullable=True),
    sa.Column('currency_id', sa.Integer(), nullable=True),
    sa.Column('campaign_link', sa.String(), nullable=True),
    sa.Column('platform', sa.String(), nullable=False),
    sa.Column('created_at', sa.TIMESTAMP(timezone=True), server_default=sa.text('CURRENT_TIMESTAMP'), nullable=False),
    sa.Column('updated_at', sa.TIMESTAMP(timezone=True), server_default=sa.text('CURRENT_TIMESTAMP'), nullable=False),
    sa.ForeignKeyConstraint(['campaign_id'], ['Campaign.id'], name=op.f('fk_CampaignAd_campaign_id_Campaign'), ondelete='CASCADE'),
    sa.ForeignKeyConstraint(['currency_id'], ['Currency.id'], name=op.f('fk_CampaignAd_currency_id_Currency')),
    sa.ForeignKeyConstraint(['objective_id'], ['CampaignObjective.id'], name=op.f('fk_CampaignAd_objective_id_CampaignObjective')),
    sa.PrimaryKeyConstraint('id', name=op.f('pk_CampaignAd')),
    sa.UniqueConstraint('external_id', name=op.f('uq_CampaignAd_external_id'))
    )
    op.create_table('CampaignAdGender',
    sa.Column('campaign_ad_id', sa.Integer(), nullable=False),
    sa.Column('gender_id', sa.Integer(), nullable=False),
    sa.ForeignKeyConstraint(['campaign_ad_id'], ['CampaignAd.id'], name=op.f('fk_CampaignAdGender_campaign_ad_id_CampaignAd'), ondelete='CASCADE'),
    sa.ForeignKeyConstraint(['gender_id'], ['Gender.id'], name=op.f('fk_CampaignAdGender_gender_id_Gender'), ondelete='CASCADE')
    )
    op.create_table('CampaignAdLink',
    sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
    sa.Column('campaign_ad_id', sa.Integer(), nullable=False),
    sa.Column('link', sa.String(), nullable=True),
    sa.ForeignKeyConstraint(['campaign_ad_id'], ['CampaignAd.id'], name=op.f('fk_CampaignAdLink_campaign_ad_id_CampaignAd'), ondelete='CASCADE'),
    sa.PrimaryKeyConstraint('id', name=op.f('pk_CampaignAdLink')),
    sa.UniqueConstraint('campaign_ad_id', 'link', name='_campaign_ad_id_link_uc')
    )
    op.create_table('CampaignAdTerritory',
    sa.Column('campaign_ad_id', sa.BigInteger(), nullable=False),
    sa.Column('territory_id', sa.Integer(), nullable=False),
    sa.ForeignKeyConstraint(['campaign_ad_id'], ['CampaignAd.id'], name=op.f('fk_CampaignAdTerritory_campaign_ad_id_CampaignAd'), ondelete='CASCADE'),
    sa.ForeignKeyConstraint(['territory_id'], ['Territory.id'], name=op.f('fk_CampaignAdTerritory_territory_id_Territory'), ondelete='CASCADE'),
    sa.PrimaryKeyConstraint('campaign_ad_id', 'territory_id', name=op.f('pk_CampaignAdTerritory'))
    )

    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_table('CampaignAdTerritory')
    op.drop_table('CampaignAdLink')
    op.drop_table('CampaignAdGender')
    op.drop_table('CampaignAd')
    # ### end Alembic commands ###