def METHOD_NAME():
    op.drop_table("officer_links")
    op.drop_table("officer_incidents")
    op.drop_table("incident_links")
    op.drop_table("incident_license_plates")
    op.drop_index(op.f("ix_incidents_report_number"), table_name="incidents")
    op.drop_index(op.f("ix_incidents_date"), table_name="incidents")
    op.drop_table("incidents")
    op.drop_index(op.f("ix_locations_zip_code"), table_name="locations")
    op.drop_index(op.f("ix_locations_street_name"), table_name="locations")
    op.drop_index(op.f("ix_locations_state"), table_name="locations")
    op.drop_index(op.f("ix_locations_city"), table_name="locations")
    op.drop_table("locations")
    op.drop_index(op.f("ix_links_link_type"), table_name="links")
    op.drop_table("links")
    op.drop_index(op.f("ix_license_plates_state"), table_name="license_plates")
    op.drop_index(op.f("ix_license_plates_number"), table_name="license_plates")
    op.drop_table("license_plates")