From 72b0dd44c20162abb07c3e2b9310332f3a0b1dd7 Mon Sep 17 00:00:00 2001 From: Kaj-Michael Lang Date: Mon, 16 Jul 2007 12:49:44 +0300 Subject: [PATCH] Add place table for storing cities, towns, villages, hamlets and suburbs --- docs/osm-tables.sql | 6 ++++++ 1 file changed, 6 insertions(+) diff --git a/docs/osm-tables.sql b/docs/osm-tables.sql index 8bbe370..7bbfeed 100644 --- a/docs/osm-tables.sql +++ b/docs/osm-tables.sql @@ -47,6 +47,12 @@ create table way_ref ( int_ref varchar(32) ); +create table places ( + nid int primary key, + type int not null, + name text +); + CREATE TABLE poi ( poi_id integer PRIMARY KEY, lat real not null, -- 2.39.5