From: Sarah Hoffmann <lonvia@denofr.de>
Date: Wed, 3 Feb 2021 13:13:09 +0000 (+0100)
Subject: add migration info for status table
X-Git-Tag: v3.7.0~41^2~1
X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/b2f8fb620175157d97254a4163f6c5bba62199db?ds=inline

add migration info for status table
---

diff --git a/docs/admin/Migration.md b/docs/admin/Migration.md
index 5aae3448..333c2477 100644
--- a/docs/admin/Migration.md
+++ b/docs/admin/Migration.md
@@ -8,6 +8,16 @@ SQL statements should be executed from the PostgreSQL commandline. Execute
 
 ## 3.6.0 -> master
 
+### Status table contains now time zone information
+
+The `import_status` table has been changed to include timezone information
+with the time stamp. You need to alter an existing table before running
+any replication functions with:
+
+```sql
+ALTER TABLE import_status ALTER COLUMN lastimportdate TYPE timestamp with time zone;
+```
+
 ### New location for data files
 
 External data files for Wikipedia importance, postcodes etc. are no longer