X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/79b81d39d8ac12e18295628d6658d9a60d49e305..054ea58df11dc3f82563b44d9e1f3a46198b1de7:/sql/partition-tables.src.sql 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,