Mercurial > gemma

diff 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
line wrap: on
line diff
--- a/schema/gemma.sql	Thu Aug 09 13:11:50 2018 +0200
+++ b/schema/gemma.sql	Thu Aug 09 15:19:56 2018 +0200
@@ -114,6 +114,7 @@
 CREATE TABLE levels_of_service (
     level_of_service smallint PRIMARY KEY
 );
+INSERT INTO levels_of_service VALUES (1), (2), (3);
 
 CREATE TABLE riverbed_materials (
     material varchar PRIMARY KEY