Mercurial > gemma

changeset 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 7ecc4f8c895c
children a43495c91856
files schema/gemma.sql
diffstat 1 files changed, 1 insertions(+), 0 deletions(-) [+]
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