X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/511204c158d4e218d2c2ca83e03b308b26487aa0..f59af7483b5a918f463fae160a41eacefe47e7f0:/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);