get precomputed housenumbers and postcodes from address column

[nominatim.git] / sql / tables.sql

diff --git a/sql/tables.sql b/sql/tables.sql
index 6263025cac969d65755df8d1e6d0feb9abcdb053..f3217d5afa6079bd378145032c67400cae47b2db 100644 (file)
--- a/sql/tables.sql
+++ b/sql/tables.sql
@@ -1,12 +1,15 @@
 drop table if exists import_status;
 CREATE TABLE import_status (
 drop table if exists import_status;
 CREATE TABLE import_status (

-  lastimportdate timestamp NOT NULL
+  lastimportdate timestamp NOT NULL,
+  sequence_id integer,
+  indexed boolean

   );
 GRANT SELECT ON import_status TO "{www-user}" ;
 
 drop table if exists import_osmosis_log;
 CREATE TABLE import_osmosis_log (
   batchend timestamp,
   );
 GRANT SELECT ON import_status TO "{www-user}" ;
 
 drop table if exists import_osmosis_log;
 CREATE TABLE import_osmosis_log (
   batchend timestamp,

+  batchseq integer,

   batchsize integer,
   starttime timestamp,
   endtime timestamp,
   batchsize integer,
   starttime timestamp,
   endtime timestamp,