From 26f58221719f53b7c02ffa5cb4c0eca6d1312843 Mon Sep 17 00:00:00 2001 From: Kaj-Michael Lang Date: Tue, 2 Oct 2007 13:55:53 +0300 Subject: [PATCH] Fix tables and indexes. - Remove trailing ',' - Remove indexes for old tables --- docs/osm-indexes.sql | 3 --- docs/osm-tables.sql | 2 +- 2 files changed, 1 insertion(+), 4 deletions(-) diff --git a/docs/osm-indexes.sql b/docs/osm-indexes.sql index 4720664..7cd9681 100644 --- a/docs/osm-indexes.sql +++ b/docs/osm-indexes.sql @@ -7,9 +7,6 @@ CREATE INDEX node_lon_idx on nodes (lon); CREATE INDEX way_name_idx on way_names (name); CREATE INDEX way_ref_idx on way_ref (ref); -CREATE INDEX way_seg_wsid_idx on way_seg (wsid); -CREATE INDEX way_seg_node_idx on way_seg (node); - CREATE INDEX way_seg2_wsid_idx on way_s2s (wsid); CREATE INDEX way_seg_f_idx on way_s2s (f); CREATE INDEX way_seg_t_idx on way_s2s (t); diff --git a/docs/osm-tables.sql b/docs/osm-tables.sql index eafbc12..5c92e58 100644 --- a/docs/osm-tables.sql +++ b/docs/osm-tables.sql @@ -14,7 +14,7 @@ create table way ( nodes int not null, flags int not null, speed int not null default 0, - isin int not null default 0, + isin int not null default 0 ); create table way_updates ( -- 2.39.5