"""add_linkfire

Revision ID: 5d7fe66de1a3
Revises: ce5be15884af
Create Date: 2021-05-14 08:37:55.673693

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '5d7fe66de1a3'
down_revision = 'ce5be15884af'
branch_labels = None
depends_on = None



def upgrade():
    op.create_table('Linkfire',
        sa.Column('id', sa.BigInteger(), primary_key=True),
        sa.Column('link_id', sa.String(), nullable=False),
        sa.Column('link_url', sa.String(), nullable=False),
        sa.PrimaryKeyConstraint('id', name=op.f('pk_Linkfire')),
    )

    op.create_table('LinkfireProject',
        sa.Column('id', sa.BigInteger(), primary_key=True),

        sa.Column('linkfire_id', sa.BigInteger(), nullable=False),
        sa.Column('project_id', sa.BigInteger(), nullable=False),
        sa.Column('add_type', sa.BigInteger(), server_default='1', nullable=False),
        sa.ForeignKeyConstraint(
            ['project_id'],
            ['Project.id'],
            name=op.f('fk_LinkfireProject_project_id_Project'),
            ondelete="CASCADE"),
        sa.ForeignKeyConstraint(
            ['linkfire_id'],
            ['Linkfire.id'],
            name=op.f('fk_LinkfireProject_linkfire_id_Linkfire'),
            ondelete="CASCADE"),
        sa.PrimaryKeyConstraint('id', name=op.f('pk_LinkfireProject'))
    )

    op.create_unique_constraint('uq_LinkfireProject_linkfire_id_project_id', 'LinkfireProject', ['linkfire_id', 'project_id'])

    op.create_table('LinkfireCampaign',
        sa.Column('id', sa.BigInteger(), primary_key=True),
        sa.Column('linkfire_id', sa.BigInteger(), nullable=False),
        sa.Column('campaign_id', sa.BigInteger(), nullable=False),
        sa.Column('add_type', sa.BigInteger(), server_default='1', nullable=False),
        sa.ForeignKeyConstraint(
            ['campaign_id'],
            ['Campaign.id'],
            name=op.f('fk_LinkfireCampaign_campaign_id_Campaign'),
            ondelete="CASCADE"),
        sa.ForeignKeyConstraint(
            ['linkfire_id'],
            ['Linkfire.id'],
            name=op.f('fk_LinkfireCampaign_linkfire_id_Linkfire'),
            ondelete="CASCADE"),
        sa.PrimaryKeyConstraint('id', name=op.f('pk_LinkfireCampaign'))
    )

    op.create_unique_constraint('uq_LinkfireCampaign_linkfire_id_campaign_id', 'LinkfireCampaign', ['linkfire_id', 'campaign_id'])




def downgrade():
    op.drop_table("LinkfireProject")
    op.drop_table("LinkfireCampaign")
    op.drop_table("Linkfire")