def METHOD_NAME():
    # ### commands auto generated by Alembic ! ###
    op.drop_index('idx_prediction_model_grid_subsets_geom', table_name='prediction_model_grid_subsets')
    op.drop_index(op.f('ix_c_haines_polygons_id'), table_name='c_haines_polygons')
    op.drop_index(op.f('ix_c_haines_polygons_c_haines_prediction_id'), table_name='c_haines_polygons')
    op.drop_index('idx_c_haines_polygons_geom', table_name='c_haines_polygons')
    op.drop_table('c_haines_polygons')
    op.drop_index(op.f('ix_c_haines_predictions_model_run_id'), table_name='c_haines_predictions')
    op.drop_index(op.f('ix_c_haines_predictions_id'), table_name='c_haines_predictions')
    op.drop_table('c_haines_predictions')
    op.drop_index(op.f('ix_c_haines_model_runs_prediction_model_id'), table_name='c_haines_model_runs')
    op.drop_index(op.f('ix_c_haines_model_runs_id'), table_name='c_haines_model_runs')
    op.drop_table('c_haines_model_runs')
    op.execute('DROP TYPE c_haines_severity_levels')
    # ### end Alembic commands ###