X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/fbbdd31399da42b94188d9d4aa4f084efd4876a4..2337cc653b679c9873344cc7278410a714a94a23:/lib-sql/tokenizer/legacy_tokenizer_tables.sql?ds=sidebyside diff --git a/lib-sql/tokenizer/legacy_tokenizer_tables.sql b/lib-sql/tokenizer/legacy_tokenizer_tables.sql index 3410b763..7969f1ca 100644 --- a/lib-sql/tokenizer/legacy_tokenizer_tables.sql +++ b/lib-sql/tokenizer/legacy_tokenizer_tables.sql @@ -1,3 +1,10 @@ +-- SPDX-License-Identifier: GPL-2.0-only +-- +-- This file is part of Nominatim. (https://nominatim.org) +-- +-- Copyright (C) 2022 by the Nominatim developer community. +-- For a full list of authors see the git log. + DROP TABLE IF EXISTS word; CREATE TABLE word ( word_id INTEGER, @@ -12,6 +19,8 @@ CREATE TABLE word ( CREATE INDEX idx_word_word_token ON word USING BTREE (word_token) {{db.tablespace.search_index}}; +CREATE INDEX idx_word_word ON word + USING BTREE (word) {{db.tablespace.search_index}} WHERE word is not null; GRANT SELECT ON word TO "{{config.DATABASE_WEBUSER}}"; DROP SEQUENCE IF EXISTS seq_word;