MapWidgetIntegration:

[mapper] / src / osm-sql-tables.h

diff --git a/src/osm-sql-tables.h b/src/osm-sql-tables.h
index ac86b502b250e48042abbca688d5603fe638f6ab..43c7c88f43a02c3e6f5d5252fb666678bc928105 100644 (file)
--- a/src/osm-sql-tables.h
+++ b/src/osm-sql-tables.h
@@ -102,10 +102,15 @@
 /* Indexes */
 #define OSM_INDEX_1 "CREATE UNIQUE INDEX IF NOT EXISTS poi_lat_lon_idx on poi (lat, lon, cat_id);"
 #define OSM_INDEX_2 "CREATE INDEX IF NOT EXISTS poi_priority on poi (priority);"
+#define OSM_INDEX_18 "CREATE INDEX IF NOT EXISTS poi_cat on poi (cat_id);"
+
+/* Nodes */
 #define OSM_INDEX_3 "CREATE INDEX IF NOT EXISTS node_rlat_idx on nodes (rlat);"
 #define OSM_INDEX_4 "CREATE INDEX IF NOT EXISTS node_rlon_idx on nodes (rlon);"
 #define OSM_INDEX_5 "CREATE INDEX IF NOT EXISTS node_ilat_idx on nodes (ilat);"
 #define OSM_INDEX_6 "CREATE INDEX IF NOT EXISTS node_ilon_idx on nodes (ilon);"
+
+/* Ways */
 #define OSM_INDEX_7 "CREATE INDEX IF NOT EXISTS way_name_idx on way_names (name);"
 #define OSM_INDEX_8 "CREATE INDEX IF NOT EXISTS way_norm_name_idx on way_names (norm);"
 #define OSM_INDEX_9 "CREATE INDEX IF NOT EXISTS way_name_nls_id_idx on way_names_nls (wid);"
@@ -116,4 +121,8 @@
 #define OSM_INDEX_14 "CREATE INDEX IF NOT EXISTS way_n2n_f_idx on way_n2n (f);"
 #define OSM_INDEX_15 "CREATE INDEX IF NOT EXISTS way_n2n_t_idx on way_n2n (t);"
 
+/* Places */
+#define OSM_INDEX_16 "CREATE INDEX IF NOT EXISTS place_type_idx on places(type);"
+#define OSM_INDEX_17 "CREATE INDEX IF NOT EXISTS place_name_idx on places(name);"
+
 #endif