Mercurial > gemma

diff schema/gemma.sql @ 3778:1b11ff97c1d1

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Add wwname to import of virtual distance marks.
author Sascha Wilde <wilde@intevation.de>
date Thu, 04 Jul 2019 16:30:19 +0200
parents ad67e4286d65
children 4f9a1ff2c2ee
line wrap: on
line diff
--- a/schema/gemma.sql	Thu Jul 04 16:16:44 2019 +0200
+++ b/schema/gemma.sql	Thu Jul 04 16:30:19 2019 +0200
@@ -504,7 +504,8 @@
     CREATE TABLE distance_marks_virtual (
         location_code isrs PRIMARY KEY,
         geom geography(POINT, 4326) NOT NULL,
-        related_enc varchar(12) NOT NULL
+        related_enc varchar(12) NOT NULL,
+        wwname varchar
     )
 
     CREATE TABLE distance_marks (