From 69fb829dd034d6f61d5b80f950175f133983ab1e Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Sun, 2 Dec 2012 23:51:45 +0100 Subject: [PATCH] remove unused SQL statements --- sql/tables.sql | 10 ---------- 1 file changed, 10 deletions(-) diff --git a/sql/tables.sql b/sql/tables.sql index acca8cbd..212d78c6 100644 --- a/sql/tables.sql +++ b/sql/tables.sql @@ -249,17 +249,7 @@ CREATE TRIGGER place_before_delete BEFORE DELETE ON place CREATE TRIGGER place_before_insert BEFORE INSERT ON place FOR EACH ROW EXECUTE PROCEDURE place_insert(); -alter table placex add column geometry_sector INTEGER; -alter table placex add column indexed_status INTEGER; -alter table placex add column indexed_date TIMESTAMP; - -update placex set geometry_sector = geometry_sector(geometry); -drop index idx_placex_pendingbylatlon; -drop index idx_placex_interpolation; drop index idx_placex_sector; -CREATE INDEX idx_placex_pendingbylatlon ON placex USING BTREE (geometry_index(geometry_sector,indexed,name),rank_search) - where geometry_index(geometry_sector,indexed,name) IS NOT NULL; -CREATE INDEX idx_placex_interpolation ON placex USING BTREE (geometry_sector) where indexed = false and class='place' and type='houses'; CREATE INDEX idx_placex_sector ON placex USING BTREE (geometry_sector,rank_address,osm_type,osm_id); DROP SEQUENCE seq_postcodes; -- 2.39.5