# HG changeset patch
# User Tom Gottfried <tom@intevation.de>
# Date 1527278067 -7200
# Node ID 21df0e95db4a597dc13568652f60373b74cf115e
# Parent  cad19acc53b335a5e89f831ece6c06c1d22fff9c
Fix thinkos and syntax errors in previous commit.

diff -r cad19acc53b3 -r 21df0e95db4a wamos.sql
--- a/wamos.sql	Fri May 25 21:45:08 2018 +0200
+++ b/wamos.sql	Fri May 25 21:54:27 2018 +0200
@@ -159,9 +159,10 @@
        );
 
 CREATE TABLE wamos.fairway_availability (
+       id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
        bottleneck_id varchar NOT NULL REFERENCES bottlenecks,
        surdat date NOT NULL,
-       PRIMARY KEY (bottleneck_id, surdat),
+       UNIQUE (bottleneck_id, surdat),
        position varchar REFERENCES spot_marks,
        -- additional_data xml -- Currently not relevant for WAMOS
        critical boolean,
@@ -173,8 +174,7 @@
        FOR EACH ROW EXECUTE PROCEDURE update_date_info();
 
 CREATE TABLE wamos.fa_reference_values (
-       id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
-       fairway_availability_id NOT NULL REFERENCES fairway_availability,
+       fairway_availability_id int NOT NULL REFERENCES fairway_availability,
        level_of_service smallint NOT NULL REFERENCES levels_of_service,
        PRIMARY KEY (fairway_availability_id, level_of_service),
        fairway_depth smallint,
@@ -185,8 +185,7 @@
        );
 
 CREATE TABLE wamos.bottleneck_pdfs (
-       id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
-       fairway_availability_id NOT NULL REFERENCES fairway_availability,
+       fairway_availability_id int NOT NULL REFERENCES fairway_availability,
        profile_pdf_filename varchar NOT NULL, -- redundant to last part of URL
        profile_pdf_url varchar NOT NULL, -- prohibit insecure URLs somehow?
        PRIMARY KEY (fairway_availability_id, profile_pdf_url),
@@ -195,8 +194,7 @@
        );
 
 CREATE TABLE wamos.effective_fairway_availability (
-       id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
-       fairway_availability_id NOT NULL REFERENCES fairway_availability,
+       fairway_availability_id int NOT NULL REFERENCES fairway_availability,
        measure_date timestamp with time zone NOT NULL,
        level_of_service smallint NOT NULL REFERENCES levels_of_service,
        PRIMARY KEY (fairway_availability_id, measure_date, level_of_service),