X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/cd997ff0589f583b0712d6652e614320a7c8a917..7dfe645b5f2fcfc320264baad73f52c8003e857f:/sql/tables.sql?ds=inline diff --git a/sql/tables.sql b/sql/tables.sql index 5686bcd2..d15e42c4 100644 --- a/sql/tables.sql +++ b/sql/tables.sql @@ -1,6 +1,6 @@ drop table if exists import_status; CREATE TABLE import_status ( - lastimportdate timestamp NOT NULL, + lastimportdate timestamp with time zone NOT NULL, sequence_id integer, indexed boolean ); @@ -35,8 +35,6 @@ GRANT UPDATE ON new_query_log TO "{www-user}" ; GRANT SELECT ON new_query_log TO "{www-user}" ; GRANT SELECT ON TABLE country_name TO "{www-user}"; -GRANT SELECT ON TABLE gb_postcode TO "{www-user}"; -GRANT SELECT ON TABLE us_postcode TO "{www-user}"; drop table IF EXISTS word; CREATE TABLE word (