From d9c87bd20efdffa32bc9efb16bf00a19174505bb 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.11.0