Mercurial > gemma
changeset 929:688e1530f66a geo-style
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