text: """Add legal_entity_congressional to DetachedAwardFinancialAssistance table
  
  Revision ID: c36ce06daaa1
  Revises: 5f1470603fa0
  Create Date: 2018-03-06 11:08:38.185497
  
  """
  
  # revision identifiers, used by Alembic.
  revision = 'c36ce06daaa1'
  down_revision = '5f1470603fa0'
  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_financial_assistance', sa.Column('legal_entity_congressional', sa.Text(), nullable=True))
      op.create_index(op.f('ix_detached_award_financial_assistance_legal_entity_congressional'), 'detached_award_financial_assistance', ['legal_entity_congressional'], unique=False)
      ### end Alembic commands ###
  
  
  def downgrade_data_broker():
      ### commands auto generated by Alembic - please adjust! ###
      op.drop_index(op.f('ix_detached_award_financial_assistance_legal_entity_congressional'), table_name='detached_award_financial_assistance')
      op.drop_column('detached_award_financial_assistance', 'legal_entity_congressional')
      ### end Alembic commands ###
  
  