From e91f14923daed9147a68bffa42c545c7306b70fb 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 --- 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..505af46855 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, 2); +SELECT SETVAL('action.survey_question_id_seq'::TEXT, 4); +SELECT SETVAL('action.survey_answer_id_seq'::TEXT, 19); + /** for every user with an id not evenly divisible by 6, * add a randomized response for every question in the survey */ -- 2.11.0