From b92f65c62bba097771bedba6a26a8b356be6cd37 Mon Sep 17 00:00:00 2001 From: Kaj-Michael Lang Date: Mon, 30 Jul 2007 13:56:29 +0300 Subject: [PATCH] Use way_name id as primary key. Set page size pragma to hopefully speed up things a bit. --- docs/osm-tables.sql | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) diff --git a/docs/osm-tables.sql b/docs/osm-tables.sql index fe8e133..57e4b57 100644 --- a/docs/osm-tables.sql +++ b/docs/osm-tables.sql @@ -1,3 +1,6 @@ +PRAGMA page_size=4096; +PRAGMA encoding = "UTF-8"; + create table nodes ( nid int primary key, lat int not null, @@ -28,7 +31,7 @@ create table area ( ); create table way_names ( - wid int not null, + wid int primary key, name varchar(256) ); -- 2.39.5