1 #ifndef _OSM_SQL_TABLES
2 #define _OSM_SQL_TABLES
6 * SQL Table and index definitions
10 #define OSM_TABLE_NODES "create table IF NOT EXISTS nodes ( \
11 nid int primary key, \
16 l int not null default 0, \
17 f int not null default 0);"
19 #define OSM_TABLE_NODE_TAGS "create table IF NOT EXISTS node_tags ( \
20 nid int not null, t text);"
22 #define OSM_TABLE_WAY "create table IF NOT EXISTS way ( \
23 wid int primary key, \
27 speed int not null default 0, \
28 isin_c int not null default 0, \
29 isin_p int not null default 0, \
33 #define OSM_TABLE_WAY_TAGS "create table IF NOT EXISTS way_tags ( \
37 #define OSM_TABLE_WAY_UPDATES "create table IF NOT EXISTS way_updates ( \
38 wid int primary key, \
42 #define OSM_TABLE_WAY_N2N "create table IF NOT EXISTS way_n2n ( \
47 #define OSM_TABLE_WAY_NAMES "create table IF NOT EXISTS way_names ( \
48 wid int primary key, \
52 #define OSM_TABLE_WAY_PC "create table IF NOT EXISTS way_pc ( \
53 wid int primary key, \
56 #define OSM_TABLE_WAY_NAMES_NLS "create table IF NOT EXISTS way_names_nls ( \
58 lang char(4) not null, \
62 #define OSM_TABLE_WAY_REF "create table IF NOT EXISTS way_ref ( \
63 rid int primary key, \
65 int_ref varchar(32));"
67 #define OSM_TABLE_PLACES "create table IF NOT EXISTS places ( \
68 nid int primary key, \
71 isin_p int not null, \
72 isin_c int not null);"
74 #define OSM_TABLE_POI "create table IF NOT EXISTS poi ( \
75 poi_id INTEGER PRIMARY KEY AUTOINCREMENT, \
78 elev real default 0.0, \
83 public int default 1, \
84 source int default 0, \
86 osm_id int default 0, \
87 isin_p int default 0, \
88 isin_c int default 0, \
89 priority int default 2, \
90 addtime int default 0);"
92 #define OSM_TABLE_POI_CATEGORY "create table IF NOT EXISTS category ( \
93 cat_id INTEGER PRIMARY KEY AUTOINCREMENT, \
94 pcat_id int not null default 0, \
95 priority int not null default 2, \
98 color char(6) not null default '#AAAA40', \
100 enabled int not null default 1);"
103 #define OSM_INDEX_1 "CREATE UNIQUE INDEX IF NOT EXISTS poi_lat_lon_idx on poi (lat, lon, cat_id);"
104 #define OSM_INDEX_2 "CREATE INDEX IF NOT EXISTS poi_priority on poi (priority);"
105 #define OSM_INDEX_18 "CREATE INDEX IF NOT EXISTS poi_cat on poi (cat_id);"
108 #define OSM_INDEX_3 "CREATE INDEX IF NOT EXISTS node_rlat_idx on nodes (rlat);"
109 #define OSM_INDEX_4 "CREATE INDEX IF NOT EXISTS node_rlon_idx on nodes (rlon);"
110 #define OSM_INDEX_5 "CREATE INDEX IF NOT EXISTS node_ilat_idx on nodes (ilat);"
111 #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);"
125 #define OSM_INDEX_16 "CREATE INDEX IF NOT EXISTS place_type_idx on places(type);"
126 #define OSM_INDEX_17 "CREATE INDEX IF NOT EXISTS place_name_idx on places(name);"