"""Adding new columns to DetachedAwardProcurement table

Revision ID: cbe6511d50ef
Revises: c048f1dcdfa2
Create Date: 2017-08-14 09:35:03.931423

"""

# revision identifiers, used by Alembic.
revision = 'cbe6511d50ef'
down_revision = 'c048f1dcdfa2'
branch_labels = None
depends_on = None

from alembic import op
import sqlalchemy as sa


def upgrade(engine_name):
    globals()["upgrade_%s" % engine_name]()


def downgrade(engine_name):
    globals()["downgrade_%s" % engine_name]()





def upgrade_data_broker():
    ### commands auto generated by Alembic - please adjust! ###
    op.add_column('detached_award_procurement', sa.Column('annual_revenue', sa.Text(), nullable=True))
    op.add_column('detached_award_procurement', sa.Column('division_name', sa.Text(), nullable=True))
    op.add_column('detached_award_procurement', sa.Column('division_number_or_office', sa.Text(), nullable=True))
    op.add_column('detached_award_procurement', sa.Column('number_of_employees', sa.Text(), nullable=True))
    op.add_column('detached_award_procurement', sa.Column('vendor_alternate_name', sa.Text(), nullable=True))
    op.add_column('detached_award_procurement', sa.Column('vendor_alternate_site_code', sa.Text(), nullable=True))
    op.add_column('detached_award_procurement', sa.Column('vendor_enabled', sa.Text(), nullable=True))
    op.add_column('detached_award_procurement', sa.Column('vendor_legal_org_name', sa.Text(), nullable=True))
    op.add_column('detached_award_procurement', sa.Column('vendor_location_disabled_f', sa.Text(), nullable=True))
    op.add_column('detached_award_procurement', sa.Column('vendor_site_code', sa.Text(), nullable=True))
    ### end Alembic commands ###


def downgrade_data_broker():
    ### commands auto generated by Alembic - please adjust! ###
    op.drop_column('detached_award_procurement', 'vendor_site_code')
    op.drop_column('detached_award_procurement', 'vendor_location_disabled_f')
    op.drop_column('detached_award_procurement', 'vendor_legal_org_name')
    op.drop_column('detached_award_procurement', 'vendor_enabled')
    op.drop_column('detached_award_procurement', 'vendor_alternate_site_code')
    op.drop_column('detached_award_procurement', 'vendor_alternate_name')
    op.drop_column('detached_award_procurement', 'number_of_employees')
    op.drop_column('detached_award_procurement', 'division_number_or_office')
    op.drop_column('detached_award_procurement', 'division_name')
    op.drop_column('detached_award_procurement', 'annual_revenue')
    ### end Alembic commands ###

