def METHOD_NAME():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_index(op.f('ix_user_idp_userid'), table_name='user')
    op.drop_column('user', 'idp_userid')
    op.create_unique_constraint('payment_type_code_key', 'payment_type', ['code'])
    op.create_unique_constraint('org_type_code_key', 'org_type', ['code'])
    op.drop_index(op.f('ix_entity_folio_number'), table_name='entity')
    op.alter_column('entity', 'corp_type_code',
                    existing_type=sa.VARCHAR(length=15),
                    nullable=True)
    op.drop_constraint('contact_link_affidavit_fk', 'contact_link', type_='foreignkey')
    op.drop_column('contact_link', 'affidavit_id')
    op.drop_index(op.f('ix_affidavit_document_id'), table_name='affidavit')
    op.drop_table('affidavit')
    op.drop_table('affidavit_status')
    op.execute('update org set access_type=\'BCSC\' where access_type=\'REGULAR\'')
    op.execute('delete from org_status where code=\'REJECTED\'')
    # ### end Alembic commands ###