"""added annonymous field & fix issues(FWF-1023) in Application & FormProcessMapper Table

Revision ID: e2b6b0b35d87
Revises: 166054bd81b5
Create Date: 2022-01-18 04:32:02.043887

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = "e2b6b0b35d87"
down_revision = "166054bd81b5"
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_column("application", "revision_no")
    op.add_column(
        "form_process_mapper", sa.Column("tenant", sa.String(length=100), nullable=True)
    )
    op.add_column(
        "form_process_mapper", sa.Column("is_anonymous", sa.Boolean(), nullable=True)
    )
    op.add_column(
        "form_process_mapper", sa.Column("deleted", sa.Boolean(), nullable=True)
    )
    op.drop_column("form_process_mapper", "tenant_id")
    op.drop_column("form_process_mapper", "form_revision_number")
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.add_column(
        "form_process_mapper",
        sa.Column(
            "form_revision_number",
            sa.VARCHAR(length=10),
            autoincrement=False,
            nullable=False,
        ),
    )
    op.add_column(
        "form_process_mapper",
        sa.Column("tenant_id", sa.INTEGER(), autoincrement=False, nullable=True),
    )
    op.drop_column("form_process_mapper", "deleted")
    op.drop_column("form_process_mapper", "is_anonymous")
    op.drop_column("form_process_mapper", "tenant")
    op.add_column(
        "application",
        sa.Column("revision_no", sa.INTEGER(), autoincrement=False, nullable=False),
    )
    # ### end Alembic commands ###