Mercurial > gemma
diff schema/gemma.sql @ 1662:d8ca44615bfc
Implemented first version of fairway availability import.
author | Raimund Renkert <raimund.renkert@intevation.de> |
---|---|
date | Fri, 21 Dec 2018 15:56:28 +0100 |
parents | 49c04bb64e0a |
children | b20b68adfe80 |
line wrap: on
line diff
--- a/schema/gemma.sql Fri Dec 21 14:15:33 2018 +0100 +++ b/schema/gemma.sql Fri Dec 21 15:56:28 2018 +0100 @@ -139,9 +139,13 @@ ); CREATE TABLE levels_of_service ( - level_of_service smallint PRIMARY KEY + level_of_service smallint PRIMARY KEY, + name varchar(4) ); -INSERT INTO levels_of_service VALUES (1), (2), (3); +INSERT INTO levels_of_service ( + level_of_service, + name +) VALUES (1, 'LOS1'), (2, 'LOS2'), (3, 'LOS3'); CREATE TABLE riverbed_materials ( material varchar PRIMARY KEY