X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/388ebcbae2b895279727edafebfb8ed794f0c4cc..f542d65da63cea44b2059913c4bb1c6550506449:/lib-sql/tokenizer/legacy_tokenizer_indices.sql diff --git a/lib-sql/tokenizer/legacy_tokenizer_indices.sql b/lib-sql/tokenizer/legacy_tokenizer_indices.sql index 44a2909c..016c518a 100644 --- a/lib-sql/tokenizer/legacy_tokenizer_indices.sql +++ b/lib-sql/tokenizer/legacy_tokenizer_indices.sql @@ -1,2 +1,10 @@ -CREATE INDEX {{sql.if_index_not_exists}} idx_word_word_id +-- 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. + +-- Required for details lookup. +CREATE INDEX IF NOT EXISTS idx_word_word_id ON word USING BTREE (word_id) {{db.tablespace.search_index}};