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,
52 typedef struct _PoiDb PoiDb;
59 typedef struct _PoiData PoiData;
72 sqlite3_stmt *_stmt_select_poi;
73 sqlite3_stmt *_stmt_select_nearest_poi;
74 sqlite3_stmt *_stmt_insert_poi;
75 sqlite3_stmt *_stmt_update_poi;
76 sqlite3_stmt *_stmt_delete_poi;
77 sqlite3_stmt *_stmt_delete_poi_by_catid;
78 sqlite3_stmt *_stmt_nextlabel_poi;
80 sqlite3_stmt *_stmt_select_cat;
81 sqlite3_stmt *_stmt_insert_cat;
82 sqlite3_stmt *_stmt_update_cat;
83 sqlite3_stmt *_stmt_delete_cat;
84 sqlite3_stmt *_stmt_toggle_cat;
85 sqlite3_stmt *_stmt_selall_cat;