Index: lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20110413_updateTo236.sql
===================================================================
diff -u -rf6a03ee21a18654d54498cd94d9f68fbea3b996a -r0406974dc82eb3022cc73a173452aa6cf6e226d9
--- lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20110413_updateTo236.sql	(.../patch20110413_updateTo236.sql)	(revision f6a03ee21a18654d54498cd94d9f68fbea3b996a)
+++ lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20110413_updateTo236.sql	(.../patch20110413_updateTo236.sql)	(revision 0406974dc82eb3022cc73a173452aa6cf6e226d9)
@@ -12,7 +12,7 @@
 ALTER TABLE tl_laasse10_assessment ADD COLUMN display_summary tinyint DEFAULT false;
 
 -- LDEV-2714 Pool of questions for assessment tool 
-create table tl_laasse10_question_reference (
+CREATE TABLE tl_laasse10_question_reference (
    uid bigint not null auto_increment,
    question_uid bigint,
    question_type smallint,
@@ -24,6 +24,10 @@
    primary key (uid)
 )ENGINE=InnoDB;
 
+-- LDEV-2805 On update from 2.3.5, make all available questions in previous assessment activities part of the questions in the list
+INSERT INTO tl_laasse10_question_reference ( question_uid , question_type , title, sequence_id, default_grade, random_question, assessment_uid ) 
+SELECT uid , question_type , title, sequence_id, default_grade, 0, assessment_uid FROM tl_laasse10_assessment_question;
+
 -- LDEV-2717 Add passing mark feature to assessment tool
 ALTER TABLE tl_laasse10_assessment ADD COLUMN passing_mark integer DEFAULT 0;