Mercurial > gemma

comparison schema/gemma.sql @ 5725:2a1eff7c4af0 errors-in-csv-export

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Merged default.
author Sascha Wilde <wilde@sha-bang.de>
date Tue, 19 Dec 2023 16:01:20 +0100
parents 4bfcbb747768
children 689f55d73bf0
comparison
equal deleted inserted replaced
5717:1c3bdd114ca1 5725:2a1eff7c4af0
661 -- e.g. for cutting bottleneck area out of waterway area based on virtual 661 -- e.g. for cutting bottleneck area out of waterway area based on virtual
662 -- distance marks along waterway axis (see SUC7). 662 -- distance marks along waterway axis (see SUC7).
663 CREATE TABLE distance_marks_virtual ( 663 CREATE TABLE distance_marks_virtual (
664 location_code isrs PRIMARY KEY, 664 location_code isrs PRIMARY KEY,
665 geom geography(POINT, 4326) NOT NULL, 665 geom geography(POINT, 4326) NOT NULL,
666 related_enc varchar(12) NOT NULL, 666 related_enc varchar(12),
667 wwname varchar 667 wwname varchar
668 ) 668 )
669 669
670 CREATE TABLE distance_marks ( 670 CREATE TABLE distance_marks (
671 id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY, 671 id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,