5 -- public POIs from different sources
6 -- (Fuel, pubs, museums, etc)
9 poi_id integer PRIMARY KEY,
29 -- Shared categories for POIs and landmarks
30 create table category (
31 cat_id integer PRIMARY KEY,
43 - Esso, Teboil, BP, Nest, etc
76 typedef struct _PoiDb PoiDb;
83 typedef struct _PoiData PoiData;
91 /** Data to describe a POI. */
92 typedef struct _PoiInfo PoiInfo;
102 /** Data used during action: add or edit category/poi **/
103 typedef struct _DeletePOI DeletePOI;
115 sqlite3_stmt *_stmt_select_poi;
116 sqlite3_stmt *_stmt_select_nearest_poi;
117 sqlite3_stmt *_stmt_insert_poi;
118 sqlite3_stmt *_stmt_update_poi;
119 sqlite3_stmt *_stmt_delete_poi;
120 sqlite3_stmt *_stmt_delete_poi_by_catid;
121 sqlite3_stmt *_stmt_nextlabel_poi;
123 sqlite3_stmt *_stmt_select_cat;
124 sqlite3_stmt *_stmt_insert_cat;
125 sqlite3_stmt *_stmt_update_cat;
126 sqlite3_stmt *_stmt_delete_cat;
127 sqlite3_stmt *_stmt_toggle_cat;
128 sqlite3_stmt *_stmt_selall_cat;