Index: lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20110413_updateTo236.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20110413_updateTo236.sql,v
diff -u -r1.6 -r1.7
--- lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20110413_updateTo236.sql	19 Feb 2012 20:17:03 -0000	1.6
+++ lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20110413_updateTo236.sql	20 Feb 2012 15:38:46 -0000	1.7
@@ -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;