X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/df7b81dc06bea97c926bf113d4dfe0f6e0669923..b4c87a09a194a7d966724ce48ba2d8ef0d044ca0:/sql/tables.sql?ds=inline diff --git a/sql/tables.sql b/sql/tables.sql index 212d78c6..3bb41e28 100644 --- a/sql/tables.sql +++ b/sql/tables.sql @@ -70,7 +70,6 @@ drop table IF EXISTS word; CREATE TABLE word ( word_id INTEGER, word_token text, - word_trigram text, word text, class text, type text, @@ -78,9 +77,7 @@ CREATE TABLE word ( search_name_count INTEGER, operator TEXT ); -SELECT AddGeometryColumn('word', 'location', 4326, 'GEOMETRY', 2); CREATE INDEX idx_word_word_token on word USING BTREE (word_token); ---CREATE INDEX idx_word_trigram ON word USING gin(word_trigram gin_trgm_ops) WITH (fastupdate = off); GRANT SELECT ON word TO "www-data" ; DROP SEQUENCE seq_word; CREATE SEQUENCE seq_word start 1; @@ -124,8 +121,8 @@ CREATE INDEX idx_location_property_tiger_parent_place_id ON location_property_ti CREATE INDEX idx_location_property_tiger_housenumber_parent_place_id ON location_property_tiger USING BTREE (parent_place_id, housenumber); GRANT SELECT ON location_property_tiger TO "www-data"; -drop table IF EXISTS search_name_blank CASCADE; -CREATE TABLE search_name_blank ( +drop table IF EXISTS search_name; +CREATE TABLE search_name ( place_id BIGINT, search_rank integer, address_rank integer, @@ -134,10 +131,7 @@ CREATE TABLE search_name_blank ( name_vector integer[], nameaddress_vector integer[] ); -SELECT AddGeometryColumn('search_name_blank', 'centroid', 4326, 'GEOMETRY', 2); - -drop table IF EXISTS search_name; -CREATE TABLE search_name () INHERITS (search_name_blank); +SELECT AddGeometryColumn('search_name', 'centroid', 4326, 'GEOMETRY', 2); CREATE INDEX idx_search_name_place_id ON search_name USING BTREE (place_id); drop table IF EXISTS place_addressline;