1 #ifndef _OSM_SQL_TABLES
2 #define _OSM_SQL_TABLES
6 * SQL Table and index definitions
11 PRAGMA page_size=4096;
12 PRAGMA encoding = "UTF-8";
15 #define OSM_TABLE_NODES "create table IF NOT EXISTS nodes ( \
16 nid int primary key, \
21 l int not null default 0, \
22 f int not null default 0);"
24 #define OSM_TABLE_NODE_TAGS "create table IF NOT EXISTS node_tags ( \
25 nid int not null, t text);"
27 #define OSM_TABLE_WAY "create table IF NOT EXISTS way ( \
28 wid int primary key, \
32 speed int not null default 0, \
33 isin_c int not null default 0, \
34 isin_p int not null default 0, \
38 #define OSM_TABLE_WAY_TAGS "create table IF NOT EXISTS way_tags ( \
42 #define OSM_TABLE_WAY_UPDATES "create table IF NOT EXISTS way_updates ( \
43 wid int primary key, \
47 #define OSM_TABLE_WAY_N2N "create table IF NOT EXISTS way_n2n ( \
52 #define OSM_TABLE_WAY_NAMES "create table IF NOT EXISTS way_names ( \
53 wid int primary key, \
57 #define OSM_TABLE_WAY_PC "create table IF NOT EXISTS way_pc ( \
58 wid int primary key, \
61 #define OSM_TABLE_WAY_NAMES_NLS "create table IF NOT EXISTS way_names_nls ( \
63 lang char(4) not null, \
67 #define OSM_TABLE_WAY_REF "create table IF NOT EXISTS way_ref ( \
68 rid int primary key, \
70 int_ref varchar(32));"
72 #define OSM_TABLE_PLACES "create table IF NOT EXISTS places ( \
73 nid int primary key, \
76 isin_p int not null, \
77 isin_c int not null);"
79 #define OSM_TABLE_POI "create table IF NOT EXISTS poi ( \
80 poi_id INTEGER PRIMARY KEY AUTOINCREMENT, \
83 elev real default 0.0, \
88 public int default 1, \
89 source int default 0, \
91 osm_id int default 0, \
92 isin_p int default 0, \
93 isin_c int default 0, \
94 priority int default 2, \
95 addtime int default 0);"
97 #define OSM_TABLE_POI_CATEGORY "create table IF NOT EXISTS category ( \
98 cat_id INTEGER PRIMARY KEY AUTOINCREMENT, \
99 pcat_id int not null default 0, \
100 priority int not null default 2, \
103 color char(6) not null default '#AAAA40', \
105 enabled int not null default 1);"
108 #define OSM_INDEX_1 "CREATE UNIQUE INDEX IF NOT EXISTS poi_lat_lon_idx on poi (lat, lon, cat_id);"
109 #define OSM_INDEX_2 "CREATE INDEX IF NOT EXISTS poi_priority on poi (priority);"
110 #define OSM_INDEX_3 "CREATE INDEX IF NOT EXISTS node_rlat_idx on nodes (rlat);"
111 #define OSM_INDEX_4 "CREATE INDEX IF NOT EXISTS node_rlon_idx on nodes (rlon);"
112 #define OSM_INDEX_5 "CREATE INDEX IF NOT EXISTS node_ilat_idx on nodes (ilat);"
113 #define OSM_INDEX_6 "CREATE INDEX IF NOT EXISTS node_ilon_idx on nodes (ilon);"
114 #define OSM_INDEX_7 "CREATE INDEX IF NOT EXISTS way_name_idx on way_names (name);"
115 #define OSM_INDEX_8 "CREATE INDEX IF NOT EXISTS way_norm_name_idx on way_names (norm);"
116 #define OSM_INDEX_9 "CREATE INDEX IF NOT EXISTS way_name_nls_id_idx on way_names_nls (wid);"
117 #define OSM_INDEX_10 "CREATE INDEX IF NOT EXISTS way_name_nls_name_idx on way_names_nls (name);"
118 #define OSM_INDEX_11 "CREATE INDEX IF NOT EXISTS way_norm_nls_name_idx on way_names_nls (norm);"
119 #define OSM_INDEX_12 "CREATE INDEX IF NOT EXISTS way_ref_idx on way_ref (ref);"
120 #define OSM_INDEX_13 "CREATE INDEX IF NOT EXISTS way_n2n_wid_idx on way_n2n (wid);"
121 #define OSM_INDEX_14 "CREATE INDEX IF NOT EXISTS way_n2n_f_idx on way_n2n (f);"
122 #define OSM_INDEX_15 "CREATE INDEX IF NOT EXISTS way_n2n_t_idx on way_n2n (t);"