Mercurial > gemma

comparison 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
comparison
equal deleted inserted replaced
4460:ace7c8d6290d 4461:7128741faeb9
702 -- 702 --
703 -- Fairway availability 703 -- Fairway availability
704 -- 704 --
705 CREATE TABLE fairway_availability ( 705 CREATE TABLE fairway_availability (
706 id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY, 706 id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
707 position_code char(2) REFERENCES position_codes, 707 position varchar,
708 bottleneck_id varchar NOT NULL, 708 bottleneck_id varchar NOT NULL,
709 surdat date NOT NULL, 709 surdat date NOT NULL,
710 UNIQUE (bottleneck_id, surdat), 710 UNIQUE (bottleneck_id, surdat),
711 -- additional_data xml -- Currently not relevant for GEMMA 711 -- additional_data xml -- Currently not relevant for GEMMA
712 critical boolean, 712 critical boolean,