"""create form lead external api post table

Revision ID: 2d93a63c1312
Revises: 38b2248e857d
Create Date: 2020-07-12 15:02:56.142002

"""

# revision identifiers, used by Alembic.
revision = '2d93a63c1312'
down_revision = '38b2248e857d'
branch_labels = None
depends_on = None

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


def upgrade():
    op.create_table('external_api_form_lead_post_tie',
                    sa.Column('created_on',
                              postgresql.TIMESTAMP(timezone=True),
                              nullable=False),
                    sa.Column('updated_on',
                              postgresql.TIMESTAMP(timezone=True),
                              nullable=False),
                    sa.Column('id', sa.INTEGER(), nullable=False),
                    sa.Column('form_id', sa.INTEGER(),
                              nullable=False),
                    sa.Column('form_lead_id', sa.INTEGER(),
                              nullable=False),
                    sa.Column('external_api_service_provider_id', sa.INTEGER(),
                              nullable=False),
                    sa.Column('external_api_lead_id', sa.VARCHAR(length=255),
                              nullable=False),
                    sa.PrimaryKeyConstraint('id', name=u'external_api_form_lead_post_tie_pkey'))


def downgrade():
    op.drop_table('external_api_form_lead_post_tie')