drop requirement for zero distance record for each place_addressline, add import_npi_...

[nominatim.git] / sql / tables.sql

diff --git a/sql/tables.sql b/sql/tables.sql
index f3a82b3bf8eeb93c478810123c9b06b5f1303032..35d6394a36281991f9cdfb76592b53601c34abed 100644 (file)
--- a/sql/tables.sql
+++ b/sql/tables.sql
@@ -13,6 +13,16 @@ CREATE TABLE import_osmosis_log (
   event text
   );
 
+drop table import_npi_log;
+CREATE TABLE import_npi_log (
+  npiid integer,
+  batchend timestamp,
+  batchsize integer,
+  starttime timestamp,
+  endtime timestamp,
+  event text
+  );
+
 --drop table IF EXISTS query_log;
 CREATE TABLE query_log (
   starttime timestamp,