Mercurial > gemma

diff schema/gemma.sql @ 4628:28999c7c0c18

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Fill single and multi into survey type table.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Thu, 10 Oct 2019 17:10:14 +0200
parents 30bb2d819d57
children 66fcd898efd9
line wrap: on
line diff
--- a/schema/gemma.sql	Thu Oct 10 16:13:11 2019 +0200
+++ b/schema/gemma.sql	Thu Oct 10 17:10:14 2019 +0200
@@ -325,6 +325,8 @@
     survey_type varchar PRIMARY KEY
 );
 
+INSERT INTO survey_types (survey_type) VALUES ('single'), ('multi');
+
 CREATE TABLE coverage_types (
     coverage_type varchar PRIMARY KEY
 );