Mercurial > gemma

changeset 67:d218aa96170f

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Tweak ER-diagramm.
author Tom Gottfried <tom@intevation.de>
date Fri, 25 May 2018 21:56:22 +0200
parents 21df0e95db4a
children 7a91106668b8
files wamos.sql
diffstat 1 files changed, 1 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/wamos.sql	Fri May 25 21:54:27 2018 +0200
+++ b/wamos.sql	Fri May 25 21:56:22 2018 +0200
@@ -160,10 +160,10 @@
 
 CREATE TABLE wamos.fairway_availability (
        id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
+       position varchar REFERENCES spot_marks,
        bottleneck_id varchar NOT NULL REFERENCES bottlenecks,
        surdat date NOT NULL,
        UNIQUE (bottleneck_id, surdat),
-       position varchar REFERENCES spot_marks,
        -- additional_data xml -- Currently not relevant for WAMOS
        critical boolean,
        date_info timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,