2 PRAGMA encoding = "UTF-8";
8 l int not null default 0,
9 f int not null default 0
12 create table node_tags (
17 create table way_tags (
27 speed int not null default 0,
28 isin int not null default 0
31 create table way_updates (
37 create table way_n2n (
43 create table way_names (
48 create table way_names_nls (
50 lang char(4) not null,
54 create table way_ref (
68 poi_id INTEGER PRIMARY KEY AUTOINCREMENT,
71 elev real default 0.0,
80 priority int default 2,
84 create table category (
85 cat_id INTEGER PRIMARY KEY AUTOINCREMENT,
87 priority int not null default 2,
90 color char(6) not null default '#AAAA40',
92 enabled int not null default 1