Mercurial > gemma

diff schema/gemma.sql @ 4461:7128741faeb9

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Changed fa data to accept "position" as strings, not a 2char "position_code"
author Sascha Wilde <wilde@intevation.de>
date Mon, 23 Sep 2019 12:59:48 +0200
parents ce884af9f42f
children f7b57136c800 d2eac69ba86b
line wrap: on
line diff
--- a/schema/gemma.sql	Mon Sep 23 11:34:06 2019 +0200
+++ b/schema/gemma.sql	Mon Sep 23 12:59:48 2019 +0200
@@ -704,7 +704,7 @@
     --
     CREATE TABLE fairway_availability (
         id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
-        position_code char(2) REFERENCES position_codes,
+        position varchar,
         bottleneck_id varchar NOT NULL,
         surdat date NOT NULL,
         UNIQUE (bottleneck_id, surdat),