def METHOD_NAME():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_constraint(None, 'inspection', type_='foreignkey')
    op.drop_column('inspection', 'inspection_type_id')
    op.drop_column('inspection', 'inspection_report_sent_date')
    op.create_table('legislation',
    sa.Column('legislation_id', sa.INTEGER(), autoincrement=True, nullable=False),
    sa.Column('order_stop_detail_id', sa.INTEGER(), autoincrement=False, nullable=True),
    sa.Column('estimated_incident_date', postgresql.TIMESTAMP(), autoincrement=False, nullable=True),
    sa.Column('noncompliant_description', sa.VARCHAR(length=256), autoincrement=False, nullable=True),
    sa.Column('parent_act_id', sa.INTEGER(), autoincrement=False, nullable=True),
    sa.Column('legislation_act_section_id', sa.INTEGER(), autoincrement=False, nullable=True),
    sa.Column('compliance_article_id', sa.INTEGER(), autoincrement=False, nullable=True),
    sa.ForeignKeyConstraint(['compliance_article_id'], ['legislation_compliance_article.legislation_compliance_article_id'], name='legislation_compliance_article_id_fkey'),
    sa.ForeignKeyConstraint(['legislation_act_section_id'], ['legislation_act_section.legislation_act_section_id'], name='legislation_legislation_act_section_id_fkey'),
    sa.ForeignKeyConstraint(['order_stop_detail_id'], ['order_stop_detail.order_stop_detail_id'], name='legislation_order_stop_detail_id_fkey'),
    sa.ForeignKeyConstraint(['parent_act_id'], ['legislation_act.legislation_act_id'], name='legislation_parent_act_id_fkey'),
    sa.PrimaryKeyConstraint('legislation_id', name='legislation_pkey')
    )
    op.drop_table('noncompliance_permit')
    op.drop_table('noncompliance_legislation')
    op.drop_table('inspection_type')
    # ### end Alembic commands ###