From faf06e1fc43ff91bf4a7d52f175fc351f9646123 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Fri, 21 Feb 2020 13:58:15 -0500 Subject: [PATCH] LP#1863929 - Fix sample survey data. Since we enter the surveys, questions, and answers with specified ID values but don't set the values to one higher, testers were unable to enter survey data. Signed-off-by: Chris Sharp Signed-off-by: Bill Erickson --- Open-ILS/tests/datasets/sql/surveys.sql | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/Open-ILS/tests/datasets/sql/surveys.sql b/Open-ILS/tests/datasets/sql/surveys.sql index f45de8d441..c9c6566463 100644 --- a/Open-ILS/tests/datasets/sql/surveys.sql +++ b/Open-ILS/tests/datasets/sql/surveys.sql @@ -26,6 +26,10 @@ INSERT INTO action.survey_answer (id, question, answer) VALUES (16, 3, 'Redshirt INSERT INTO action.survey_answer (id, question, answer) VALUES (17, 3, 'TARDIS blue.'); INSERT INTO action.survey_answer (id, question, answer) VALUES (18, 3, 'This is getting too silly - I quit.'); +SELECT SETVAL('action.survey_id_seq'::TEXT, 100); +SELECT SETVAL('action.survey_question_id_seq'::TEXT, 100); +SELECT SETVAL('action.survey_answer_id_seq'::TEXT, 100); + /** for every user with an id not evenly divisible by 6, * add a randomized response for every question in the survey */ -- 2.43.2