X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/65daef70c1f9aa80e6d37fc12198309e49b883ca..f863040b38a6c7586c06623715f1010c268b1f37:/sql/tables.sql diff --git a/sql/tables.sql b/sql/tables.sql index 0559abd4..0245e3c3 100644 --- a/sql/tables.sql +++ b/sql/tables.sql @@ -268,7 +268,9 @@ CREATE TABLE wikipedia_article ( lon double precision, importance double precision, osm_type character(1), - osm_id bigint + osm_id bigint, + wd_page_title text, + instance_of text ); ALTER TABLE ONLY wikipedia_article ADD CONSTRAINT wikipedia_article_pkey PRIMARY KEY (language, title); CREATE INDEX idx_wikipedia_article_osm_id ON wikipedia_article USING btree (osm_type, osm_id);