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 nodes IF NOT EXISTS ( \
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 node_tags IF NOT EXISTS ( \
25 nid int not null, t text);"
27 #define OSM_TABLE_WAY "create table way IF NOT EXISTS ( \
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 way_tags IF NOT EXISTS ( \
42 #define OSM_TABLE_WAY_UPDATES "create table way_updates IF NOT EXISTS ( \
43 wid int primary key, \
47 #define OSM_TABLE_WAY_N2N "create table way_n2n IF NOT EXISTS ( \
52 #define OSM_TABLE_WAY_NAMES "create table way_names IF NOT EXISTS ( \
53 wid int primary key, \
57 #define OSM_TABLE_WAY_PC "create table way_pc IF NOT EXISTS ( \
58 wid int primary key, \
61 #define OSM_TABLE_WAY_NAMES_NLS "create table way_names_nls IF NOT EXISTS ( \
63 lang char(4) not null, \
67 #define OSM_TABLE_ "create table way_ref IF NOT EXISTS ( \
68 rid int primary key, \
70 int_ref varchar(32));"
72 #define OSM_TABLE_PLACES "create table places IF NOT EXISTS ( \
73 nid int primary key, \
76 isin_p int not null, \
77 isin_c int not null);"
79 #define OSM_TABLE_POI "create table poi IF NOT EXISTS ( \
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 category IF NOT EXISTS ( \
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);"