Mercurial > gemma

diff schema/gemma.sql @ 1662:d8ca44615bfc

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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