"""add_new_prs_field

Revision ID: 66b1d16db276
Revises: 1d810cfcceec
Create Date: 2021-03-12 09:22:55.903555

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '66b1d16db276'
down_revision = '1d810cfcceec'
branch_labels = None
depends_on = None


def upgrade():
    op.add_column('RawPRSPurchaseOrders', sa.Column('is_under_uncommited_blanket', sa.String(), nullable=False, server_default='N'))
    op.add_column('PRSPurchaseOrder', sa.Column('is_under_uncommited_blanket', sa.Boolean(), nullable=False, server_default='False'))


def downgrade():
    op.drop_column('RawPRSPurchaseOrders', 'is_under_uncommited_blanket')
    op.drop_column('PRSPurchaseOrder', 'is_under_uncommited_blanket')