# HG changeset patch
# User Sascha L. Teichmann <sascha.teichmann@intevation.de>
# Date 1570720214 -7200
# Node ID 28999c7c0c180d74582889b1bb00466c5612efdd
# Parent  8f38a1bb9b79efd9ffc7c69b4751d07af878d16e
Fill single and multi into survey type table.

diff -r 8f38a1bb9b79 -r 28999c7c0c18 schema/gemma.sql
--- 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
 );
diff -r 8f38a1bb9b79 -r 28999c7c0c18 schema/updates/1301/01.fill-survey-types.sql
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/schema/updates/1301/01.fill-survey-types.sql	Thu Oct 10 17:10:14 2019 +0200
@@ -0,0 +1,3 @@
+INSERT INTO survey_types (survey_type) VALUES ('single'), ('multi')
+  ON CONFLICT (survey_type) DO NOTHING;
+
diff -r 8f38a1bb9b79 -r 28999c7c0c18 schema/version.sql
--- a/schema/version.sql	Thu Oct 10 16:13:11 2019 +0200
+++ b/schema/version.sql	Thu Oct 10 17:10:14 2019 +0200
@@ -1,1 +1,1 @@
-INSERT INTO gemma_schema_version(version) VALUES (1300);
+INSERT INTO gemma_schema_version(version) VALUES (1301);