Mercurial > gemma

diff schema/updates/1301/01.fill-survey-types.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
children
line wrap: on
line diff
--- /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;
+