indexes_post_import.sql

CREATE INDEX IF NOT EXISTS idx_point_country_iso2     ON imposm_osm_point(country_iso2);
CREATE INDEX IF NOT EXISTS idx_point_amenity          ON imposm_osm_point(amenity);
CREATE INDEX IF NOT EXISTS idx_point_shop             ON imposm_osm_point(shop);
CREATE INDEX IF NOT EXISTS idx_point_craft            ON imposm_osm_point(craft);
CREATE INDEX IF NOT EXISTS idx_point_office           ON imposm_osm_point(office);
CREATE INDEX IF NOT EXISTS idx_point_emergency        ON imposm_osm_point(emergency);
CREATE INDEX IF NOT EXISTS idx_point_tobacco          ON imposm_osm_point(tobacco);
CREATE INDEX IF NOT EXISTS idx_point_healthcare       ON imposm_osm_point(healthcare);
CREATE INDEX IF NOT EXISTS idx_point_ohcovid19        ON imposm_osm_point("opening_hours:covid19");
CREATE INDEX IF NOT EXISTS idx_polygon_country_iso2   ON imposm_osm_polygon(country_iso2);
CREATE INDEX IF NOT EXISTS idx_polygon_amenity        ON imposm_osm_polygon(amenity);
CREATE INDEX IF NOT EXISTS idx_polygon_shop           ON imposm_osm_polygon(shop);
CREATE INDEX IF NOT EXISTS idx_polygon_craft          ON imposm_osm_polygon(craft);
CREATE INDEX IF NOT EXISTS idx_polygon_office         ON imposm_osm_polygon(office);
CREATE INDEX IF NOT EXISTS idx_polygon_emergency      ON imposm_osm_polygon(emergency);
CREATE INDEX IF NOT EXISTS idx_polygon_tobacco        ON imposm_osm_polygon(tobacco);
CREATE INDEX IF NOT EXISTS idx_polygon_healthcare     ON imposm_osm_polygon(healthcare);
CREATE INDEX IF NOT EXISTS idx_polygon_ohcovid19      ON imposm_osm_polygon("opening_hours:covid19");