Mercurial > gemma

comparison schema/gemma.sql @ 368:78588014ad0a

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Populate levels_of_service
author Tom Gottfried <tom@intevation.de>
date Thu, 09 Aug 2018 15:19:56 +0200
parents f5087cebc740
children fe87457a05d7
comparison
equal deleted inserted replaced
367:7ecc4f8c895c 368:78588014ad0a
112 ); 112 );
113 113
114 CREATE TABLE levels_of_service ( 114 CREATE TABLE levels_of_service (
115 level_of_service smallint PRIMARY KEY 115 level_of_service smallint PRIMARY KEY
116 ); 116 );
117 INSERT INTO levels_of_service VALUES (1), (2), (3);
117 118
118 CREATE TABLE riverbed_materials ( 119 CREATE TABLE riverbed_materials (
119 material varchar PRIMARY KEY 120 material varchar PRIMARY KEY
120 -- XXX: Should this table contain choices from DRC 2.2.3 or 121 -- XXX: Should this table contain choices from DRC 2.2.3 or
121 -- from IENC Encoding Guide M.4.3, attribute NATSUR? 122 -- from IENC Encoding Guide M.4.3, attribute NATSUR?