From 6d244669afc8712a0824839a306a52c43d33d5b8 Mon Sep 17 00:00:00 2001 From: Kaj-Michael Lang Date: Mon, 4 Feb 2008 15:34:27 +0200 Subject: [PATCH] Fix missing ", fix wrong table name --- src/osm-sql-tables.h | 32 ++++++++++++++++---------------- 1 file changed, 16 insertions(+), 16 deletions(-) diff --git a/src/osm-sql-tables.h b/src/osm-sql-tables.h index 11649d0..1a69e3d 100644 --- a/src/osm-sql-tables.h +++ b/src/osm-sql-tables.h @@ -64,7 +64,7 @@ PRAGMA encoding = "UTF-8"; name varchar(256), \ norm varchar(256));" -#define OSM_TABLE_ "create table way_ref IF NOT EXISTS ( \ +#define OSM_TABLE_WAY_REF "create table way_ref IF NOT EXISTS ( \ rid int primary key, \ ref varchar(32), \ int_ref varchar(32));" @@ -105,20 +105,20 @@ PRAGMA encoding = "UTF-8"; enabled int not null default 1);" /* Indexes */ -#define OSM_INDEX_1 CREATE UNIQUE INDEX IF NOT EXISTS poi_lat_lon_idx on poi (lat, lon, cat_id);" -#define OSM_INDEX_2 CREATE INDEX IF NOT EXISTS poi_priority on poi (priority);" -#define OSM_INDEX_3 CREATE INDEX IF NOT EXISTS node_rlat_idx on nodes (rlat);" -#define OSM_INDEX_4 CREATE INDEX IF NOT EXISTS node_rlon_idx on nodes (rlon);" -#define OSM_INDEX_5 CREATE INDEX IF NOT EXISTS node_ilat_idx on nodes (ilat);" -#define OSM_INDEX_6 CREATE INDEX IF NOT EXISTS node_ilon_idx on nodes (ilon);" -#define OSM_INDEX_7 CREATE INDEX IF NOT EXISTS way_name_idx on way_names (name);" -#define OSM_INDEX_8 CREATE INDEX IF NOT EXISTS way_norm_name_idx on way_names (norm);" -#define OSM_INDEX_9 CREATE INDEX IF NOT EXISTS way_name_nls_id_idx on way_names_nls (wid);" -#define OSM_INDEX_10 CREATE INDEX IF NOT EXISTS way_name_nls_name_idx on way_names_nls (name);" -#define OSM_INDEX_11 CREATE INDEX IF NOT EXISTS way_norm_nls_name_idx on way_names_nls (norm);" -#define OSM_INDEX_12 CREATE INDEX IF NOT EXISTS way_ref_idx on way_ref (ref);" -#define OSM_INDEX_13 CREATE INDEX IF NOT EXISTS way_n2n_wid_idx on way_n2n (wid);" -#define OSM_INDEX_14 CREATE INDEX IF NOT EXISTS way_n2n_f_idx on way_n2n (f);" -#define OSM_INDEX_15 CREATE INDEX IF NOT EXISTS way_n2n_t_idx on way_n2n (t);" +#define OSM_INDEX_1 "CREATE UNIQUE INDEX IF NOT EXISTS poi_lat_lon_idx on poi (lat, lon, cat_id);" +#define OSM_INDEX_2 "CREATE INDEX IF NOT EXISTS poi_priority on poi (priority);" +#define OSM_INDEX_3 "CREATE INDEX IF NOT EXISTS node_rlat_idx on nodes (rlat);" +#define OSM_INDEX_4 "CREATE INDEX IF NOT EXISTS node_rlon_idx on nodes (rlon);" +#define OSM_INDEX_5 "CREATE INDEX IF NOT EXISTS node_ilat_idx on nodes (ilat);" +#define OSM_INDEX_6 "CREATE INDEX IF NOT EXISTS node_ilon_idx on nodes (ilon);" +#define OSM_INDEX_7 "CREATE INDEX IF NOT EXISTS way_name_idx on way_names (name);" +#define OSM_INDEX_8 "CREATE INDEX IF NOT EXISTS way_norm_name_idx on way_names (norm);" +#define OSM_INDEX_9 "CREATE INDEX IF NOT EXISTS way_name_nls_id_idx on way_names_nls (wid);" +#define OSM_INDEX_10 "CREATE INDEX IF NOT EXISTS way_name_nls_name_idx on way_names_nls (name);" +#define OSM_INDEX_11 "CREATE INDEX IF NOT EXISTS way_norm_nls_name_idx on way_names_nls (norm);" +#define OSM_INDEX_12 "CREATE INDEX IF NOT EXISTS way_ref_idx on way_ref (ref);" +#define OSM_INDEX_13 "CREATE INDEX IF NOT EXISTS way_n2n_wid_idx on way_n2n (wid);" +#define OSM_INDEX_14 "CREATE INDEX IF NOT EXISTS way_n2n_f_idx on way_n2n (f);" +#define OSM_INDEX_15 "CREATE INDEX IF NOT EXISTS way_n2n_t_idx on way_n2n (t);" #endif -- 2.39.5