X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/511204c158d4e218d2c2ca83e03b308b26487aa0..9e21c6a8621661f0641a40875b1093b85adc68d1:/sql/partition-tables.src.sql?ds=inline diff --git a/sql/partition-tables.src.sql b/sql/partition-tables.src.sql index 57806898..8749243e 100644 --- a/sql/partition-tables.src.sql +++ b/sql/partition-tables.src.sql @@ -1,30 +1,3 @@ -drop type if exists nearplace cascade; -create type nearplace as ( - place_id BIGINT -); - -drop type if exists nearfeature cascade; -create type nearfeature as ( - place_id BIGINT, - keywords int[], - rank_address smallint, - rank_search smallint, - distance float, - isguess boolean -); - -drop type if exists nearfeaturecentr cascade; -create type nearfeaturecentr as ( - place_id BIGINT, - keywords int[], - rank_address smallint, - rank_search smallint, - distance float, - isguess boolean, - postcode TEXT, - centroid GEOMETRY -); - drop table IF EXISTS search_name_blank CASCADE; CREATE TABLE search_name_blank ( place_id BIGINT,