Mercurial > gemma

changeset 929:688e1530f66a geo-style

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Merged default into geo-style branch.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Mon, 08 Oct 2018 14:29:59 +0200
parents 0a0013fbda4a (current diff) 48f70782400d (diff)
children e758e12b38c9
files schema/gemma.sql
diffstat 1 files changed, 5 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- a/schema/gemma.sql	Mon Oct 08 13:09:02 2018 +0200
+++ b/schema/gemma.sql	Mon Oct 08 14:29:59 2018 +0200
@@ -84,12 +84,17 @@
 CREATE TABLE catccls (
     catccl smallint PRIMARY KEY
     -- TODO: Do we need name and/or definition from IENC feature catalogue?
+    -- (see page 328 of edition 2.3)
 );
+INSERT INTO catccls VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10),(11);
 
 CREATE TABLE dirimps (
     dirimp smallint PRIMARY KEY
     -- TODO: Do we need name and/or definition from IENC feature catalogue?
+    -- (see page 381 of edition 2.3)
 );
+INSERT INTO dirimps VALUES (1), (2), (3), (4);
+-- dirimp_5 left out because it cannot be used for waterway area
 
 CREATE TABLE depth_references (
     depth_reference varchar(4) PRIMARY KEY