From c472583b575697d84fd7f07dc3857a3af623e0b7 Mon Sep 17 00:00:00 2001 From: Kaj-Michael Lang Date: Tue, 24 Jul 2007 23:38:07 +0300 Subject: [PATCH] Add speed and isin fields for ways. --- docs/osm-tables.sql | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/docs/osm-tables.sql b/docs/osm-tables.sql index 8f0138e..fe8e133 100644 --- a/docs/osm-tables.sql +++ b/docs/osm-tables.sql @@ -10,7 +10,8 @@ create table way ( type int not null, nodes int not null, flags int not null, - len real + speed int not null default 0, + isin int not null default 0 ); create table way_seg ( @@ -28,8 +29,7 @@ create table area ( create table way_names ( wid int not null, - name varchar(256), - isin varchar(256) + name varchar(256) ); create table way_ref ( @@ -39,7 +39,7 @@ create table way_ref ( ); create table places ( - nid int primary key, + nid int primary key, type int not null, name text, isin int -- 2.39.5