Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20170315.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20170822.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20171011.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20171016.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20171218.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20180330.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20180425.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20180515.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20190103.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20190103_updateTo31.sql
===================================================================
diff -u
--- lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20190103_updateTo31.sql	(revision 0)
+++ lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20190103_updateTo31.sql	(revision 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d)
@@ -0,0 +1,117 @@
+SET AUTOCOMMIT = 0;
+SET FOREIGN_KEY_CHECKS = 0;
+
+-- This patch contains files patch20170315.sql to patch20190103.sql
+-- It should upgrade this tool to version 3.1
+
+
+-- LDEV-4271 Remove unnecessary fields
+ALTER TABLE `tl_laasse10_assessment_question` DROP FOREIGN KEY `FK_NEW_1720029621_F52D1F93758092FB`;
+ALTER TABLE `tl_laasse10_assessment_question` DROP COLUMN `create_by`, DROP INDEX `FK_NEW_1720029621_F52D1F93758092FB`;
+
+ALTER TABLE `tl_laasse10_assessment_question` DROP COLUMN `create_date`;
+
+UPDATE lams_tool SET tool_version='20170315' WHERE tool_signature='laasse10';
+
+
+
+-- LDEV-4410 Add unique index to prevent duplicate result copied from leader
+ALTER TABLE tl_laasse10_assessment_result ADD UNIQUE KEY UQ_tl_laasse10_assessment_result_4 (assessment_uid, user_uid, finish_date);
+
+UPDATE lams_tool SET tool_version='20170822' WHERE tool_signature='laasse10';
+
+
+
+-- LDEV-4438 Add unique constraint to prevent duplicate results with 'latest' flag being ON
+
+--remove all duplicates that have identical pairs (assessment_uid, user_uid, latest) where latest=1 
+DELETE a
+FROM tl_laasse10_assessment_result as a, tl_laasse10_assessment_result as b
+WHERE
+          (a.assessment_uid   = b.assessment_uid OR a.assessment_uid IS NULL AND b.assessment_uid IS NULL)
+      AND (a.user_uid = b.user_uid OR a.user_uid IS NULL AND b.user_uid IS NULL)
+      AND (a.latest = 1 AND b.latest = 1)
+      AND a.uid < b.uid;
+      
+--set up tl_laasse10_assessment_result table to properly handle constraint
+UPDATE tl_laasse10_assessment_result SET latest=NULL WHERE latest='0';
+ALTER TABLE tl_laasse10_assessment_result CHANGE COLUMN latest latest TINYINT(1) NULL DEFAULT NULL;
+
+--add unique constraint
+ALTER TABLE tl_laasse10_assessment_result ADD UNIQUE KEY UQ_tl_laasse10_assessment_result_5 (assessment_uid, user_uid, latest);
+
+--remove unique constraint previously added in patch20170822.sql (LDEV-4410 Add unique index to prevent duplicate result copied from leader)
+ALTER TABLE tl_laasse10_assessment_result DROP INDEX UQ_tl_laasse10_assessment_result_4;
+
+UPDATE lams_tool SET tool_version='20171011' WHERE tool_signature='laasse10';
+
+
+
+-----------------Put all sql statements below here-------------------------
+
+-- LDEV-4451 add 'Enable Confidence levels' advanced setting
+ALTER TABLE tl_laasse10_assessment ADD COLUMN enable_confidence_levels TINYINT(1) NOT NULL DEFAULT 0;
+
+--add questions' hashes in order to be able to search for the similar questions with the same title and question
+ALTER TABLE tl_laasse10_assessment_question ADD COLUMN question_hash CHAR(40);
+UPDATE tl_laasse10_assessment_question SET question_hash = SHA1(question);
+
+--add confidence level property to tl_laasse10_question_result
+ALTER TABLE tl_laasse10_question_result ADD COLUMN confidence_level int;
+
+UPDATE lams_tool SET tool_version='20171016' WHERE tool_signature='laasse10';
+
+
+
+-- LDEV-4490 Fix NULL ConfidenceLevel columns creating exceptions
+UPDATE tl_laasse10_question_result SET confidence_level = 0 WHERE confidence_level IS NULL;
+
+ALTER TABLE tl_laasse10_question_result
+CHANGE COLUMN confidence_level confidence_level INT(11) NOT NULL DEFAULT 0;
+
+
+
+
+-- LDEV-4540 Allow teachers to release correct and other groups' answers in monitor
+
+ALTER TABLE tl_laasse10_assessment ADD COLUMN allow_disclose_answers TINYINT(1) DEFAULT 0 AFTER allow_overall_feedback;
+
+ALTER TABLE tl_laasse10_assessment_question ADD COLUMN correct_answers_disclosed TINYINT(1) DEFAULT 0,
+											ADD COLUMN groups_answers_disclosed TINYINT(1) DEFAULT 0;
+
+											
+											
+
+-- LDEV-4558 Increase db text size for all user inputs
+ALTER TABLE tl_laasse10_assessment MODIFY instructions MEDIUMTEXT;
+ALTER TABLE tl_laasse10_assessment MODIFY reflect_instructions MEDIUMTEXT;
+ALTER TABLE tl_laasse10_assessment_overall_feedback MODIFY feedback MEDIUMTEXT;
+ALTER TABLE tl_laasse10_assessment_question MODIFY question MEDIUMTEXT;
+ALTER TABLE tl_laasse10_assessment_question MODIFY general_feedback MEDIUMTEXT;
+ALTER TABLE tl_laasse10_assessment_question MODIFY feedback MEDIUMTEXT;
+ALTER TABLE tl_laasse10_assessment_question MODIFY feedback_on_correct MEDIUMTEXT;
+ALTER TABLE tl_laasse10_assessment_question MODIFY feedback_on_partially_correct MEDIUMTEXT;
+ALTER TABLE tl_laasse10_assessment_question MODIFY feedback_on_incorrect MEDIUMTEXT;
+ALTER TABLE tl_laasse10_question_option MODIFY question MEDIUMTEXT;
+ALTER TABLE tl_laasse10_question_option MODIFY option_string MEDIUMTEXT;
+ALTER TABLE tl_laasse10_question_option MODIFY feedback MEDIUMTEXT;
+ALTER TABLE tl_laasse10_question_result MODIFY answer_string MEDIUMTEXT;
+
+
+
+
+-- LDEV-4582 Option to add prefix letter to assessment MCQ answers 
+ALTER TABLE tl_laasse10_assessment_question ADD COLUMN prefix_answers_with_letters TINYINT(1) NOT NULL DEFAULT 0;
+
+
+
+
+-- LDEV-4743 Update tools version for LAMS 3.1 release
+UPDATE lams_tool SET tool_version='20190103' WHERE tool_signature='laasse10';
+
+
+
+-- If there were no errors, commit and restore autocommit to on
+COMMIT;
+SET AUTOCOMMIT = 1;
+SET FOREIGN_KEY_CHECKS=1;
\ No newline at end of file
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dbupdates/patch20180801.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dbupdates/patch20190103.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dbupdates/patch20190103_updateTo31.sql
===================================================================
diff -u
--- lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dbupdates/patch20190103_updateTo31.sql	(revision 0)
+++ lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dbupdates/patch20190103_updateTo31.sql	(revision 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d)
@@ -0,0 +1,28 @@
+SET AUTOCOMMIT = 0;
+SET FOREIGN_KEY_CHECKS = 0;
+
+-- This patch contains files patch20180801.sql to patch20190103.sql
+-- It should upgrade this tool to version 3.1
+
+-- LDEV-4440 Change tool access URLs after migration to Spring MVC
+UPDATE lams_tool SET 
+	author_url = 'tool/lachat11/authoring/authoring.do',
+	learner_url = 'tool/lachat11/learning/learning.do?mode=learner',
+	learner_preview_url = 'tool/lachat11/learning/learning.do?mode=author',
+	learner_progress_url = 'tool/lachat11/learning/learning.do?mode=teacher',
+	monitor_url = 'tool/lachat11/monitoring/monitoring.do',
+	pedagogical_planner_url = 'tool/lachat11/pedagogicalPlanner/initPedagogicalPlannerForm.do'
+WHERE tool_signature = 'lachat11';
+
+UPDATE lams_tool SET tool_version='20180801' WHERE tool_signature='lachat11';
+
+
+
+-- LDEV-4743 Update tools version for LAMS 3.1 release
+UPDATE lams_tool SET tool_version='20190103' WHERE tool_signature='lachat11';
+
+
+-- If there were no errors, commit and restore autocommit to on
+COMMIT;
+SET AUTOCOMMIT = 1;
+SET FOREIGN_KEY_CHECKS=1;
\ No newline at end of file
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_daco/src/java/org/lamsfoundation/lams/tool/daco/dbupdates/patch20180425.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_daco/src/java/org/lamsfoundation/lams/tool/daco/dbupdates/patch20190103.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: lams_tool_daco/src/java/org/lamsfoundation/lams/tool/daco/dbupdates/patch20190103_updateTo31.sql
===================================================================
diff -u
--- lams_tool_daco/src/java/org/lamsfoundation/lams/tool/daco/dbupdates/patch20190103_updateTo31.sql	(revision 0)
+++ lams_tool_daco/src/java/org/lamsfoundation/lams/tool/daco/dbupdates/patch20190103_updateTo31.sql	(revision 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d)
@@ -0,0 +1,21 @@
+SET AUTOCOMMIT = 0;
+SET FOREIGN_KEY_CHECKS = 0;
+
+-- This patch contains files patch20180425.sql to patch20190103.sql
+-- It should upgrade this tool to version 3.1
+
+-- LDEV-4558 Increase db text size for all user inputs
+ALTER TABLE tl_ladaco10_answers MODIFY answer MEDIUMTEXT;
+ALTER TABLE tl_ladaco10_contents MODIFY instructions MEDIUMTEXT;
+ALTER TABLE tl_ladaco10_contents MODIFY reflect_instructions MEDIUMTEXT;
+ALTER TABLE tl_ladaco10_questions MODIFY description MEDIUMTEXT;
+
+
+-- LDEV-4743 Update tools version for LAMS 3.1 release
+UPDATE lams_tool SET tool_version='20190103' WHERE tool_signature='ladaco10';
+
+
+-- If there were no errors, commit and restore autocommit to on
+COMMIT;
+SET AUTOCOMMIT = 1;
+SET FOREIGN_KEY_CHECKS=1;
\ No newline at end of file
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_doku/src/java/org/lamsfoundation/lams/tool/dokumaran/dbupdates/patch20170303.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_doku/src/java/org/lamsfoundation/lams/tool/dokumaran/dbupdates/patch20180425.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_doku/src/java/org/lamsfoundation/lams/tool/dokumaran/dbupdates/patch20190103.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: lams_tool_doku/src/java/org/lamsfoundation/lams/tool/dokumaran/dbupdates/patch20190103_updateTo31.sql
===================================================================
diff -u
--- lams_tool_doku/src/java/org/lamsfoundation/lams/tool/dokumaran/dbupdates/patch20190103_updateTo31.sql	(revision 0)
+++ lams_tool_doku/src/java/org/lamsfoundation/lams/tool/dokumaran/dbupdates/patch20190103_updateTo31.sql	(revision 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d)
@@ -0,0 +1,23 @@
+SET AUTOCOMMIT = 0;
+SET FOREIGN_KEY_CHECKS = 0;
+
+-- This patch contains files patch20170303.sql to patch20190103.sql
+-- It should upgrade this tool to version 3.1
+
+-- LDEV-4259 Add time limit feature
+ALTER TABLE tl_ladoku11_dokumaran ADD COLUMN time_limit integer DEFAULT 0;
+ALTER TABLE tl_ladoku11_dokumaran ADD COLUMN time_limit_launched_date datetime;
+
+
+-- LDEV-4558 Increase db text size for all user inputs
+ALTER TABLE tl_ladoku11_dokumaran MODIFY instructions MEDIUMTEXT;
+ALTER TABLE tl_ladoku11_dokumaran MODIFY reflect_instructions MEDIUMTEXT;
+
+-- LDEV-4743 Update tools version for LAMS 3.1 release
+UPDATE lams_tool SET tool_version='20190103' WHERE tool_signature='ladoku11';
+
+
+-- If there were no errors, commit and restore autocommit to on
+COMMIT;
+SET AUTOCOMMIT = 1;
+SET FOREIGN_KEY_CHECKS=1;
\ No newline at end of file
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20170308.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20170707.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20180425.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20180625.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20180707.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20180806.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20181202.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20190103.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20190103_updateTo31.sql
===================================================================
diff -u
--- lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20190103_updateTo31.sql	(revision 0)
+++ lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20190103_updateTo31.sql	(revision 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d)
@@ -0,0 +1,81 @@
+SET AUTOCOMMIT = 0;
+SET FOREIGN_KEY_CHECKS = 0;
+
+-- This patch contains files patch20170308.sql to patch20190103.sql
+-- It should upgrade this tool to version 3.1
+
+-- LDEV-4261 Remove optimistic locking management
+ALTER TABLE tl_lafrum11_tool_session DROP COLUMN version;
+
+
+
+-- LDEV-4371 Add Forum admin page
+CREATE TABLE tl_lafrum11_configuration (
+  uid bigint(20) NOT NULL AUTO_INCREMENT,
+  config_key VARCHAR(30),
+  config_value VARCHAR(255),
+  PRIMARY KEY (uid),
+  UNIQUE KEY config_key (config_key)
+);
+
+INSERT INTO tl_lafrum11_configuration (config_key, config_value) VALUES ('keepLearnerContent',	'false');
+
+UPDATE lams_tool SET admin_url='tool/lafrum11/admin/start.do' WHERE tool_signature='lafrum11';
+
+
+
+
+-- LDEV-4558 Increase db text size for all user inputs
+ALTER TABLE tl_lafrum11_forum MODIFY instructions MEDIUMTEXT;
+ALTER TABLE tl_lafrum11_forum MODIFY reflect_instructions MEDIUMTEXT;
+ALTER TABLE tl_lafrum11_message MODIFY body MEDIUMTEXT;
+ALTER TABLE tl_lafrum11_report MODIFY comment MEDIUMTEXT;
+
+
+
+
+-- LDEV-4603 Delete preview lessons with peer review activity doesn't work
+ALTER TABLE tl_lafrum11_message_rating DROP FOREIGN KEY FK_tl_lafrum11_message_rating_2;
+ALTER TABLE tl_lafrum11_message_rating ADD CONSTRAINT FK_tl_lafrum11_message_rating_2
+  FOREIGN KEY (message_id)
+  REFERENCES tl_lafrum11_message (uid)
+  ON DELETE CASCADE
+  ON UPDATE CASCADE;
+
+  
+  
+  
+-- LDEV-4621 Release marks is now a state
+ALTER TABLE tl_lafrum11_report DROP COLUMN release_date;
+
+
+
+
+-- LDEV-4440 Change tool access URLs after migration to Spring MVC
+UPDATE lams_tool SET 
+	author_url = 'tool/lafrum11/authoring/authoring.do',
+	learner_url = 'tool/lafrum11/learning/viewForum.do?mode=learner',
+	learner_preview_url = 'tool/lafrum11/learning/viewForum.do?mode=author',
+	learner_progress_url = 'tool/lafrum11/learning/viewForum.do?mode=teacher',
+	monitor_url = 'tool/lafrum11/monitoring/monitoring.do',
+	pedagogical_planner_url = 'tool/lafrum11/authoring/initPedagogicalPlannerForm.do'
+WHERE tool_signature = 'lafrum11';
+
+UPDATE lams_tool SET tool_version='20180806' WHERE tool_signature='lafrum11';
+
+
+
+						    
+-- Trigger class name rename when importing an old LD
+UPDATE lams_tool SET tool_version='20181202' WHERE tool_signature='lafrum11';
+
+
+
+-- LDEV-4743 Update tools version for LAMS 3.1 release
+UPDATE lams_tool SET tool_version='20190103' WHERE tool_signature='lafrum11';
+
+
+-- If there were no errors, commit and restore autocommit to on
+COMMIT;
+SET AUTOCOMMIT = 1;
+SET FOREIGN_KEY_CHECKS=1;
\ No newline at end of file
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_images/src/java/org/lamsfoundation/lams/tool/imageGallery/dbupdates/patch20170731.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_images/src/java/org/lamsfoundation/lams/tool/imageGallery/dbupdates/patch20180425.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_images/src/java/org/lamsfoundation/lams/tool/imageGallery/dbupdates/patch20190103.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: lams_tool_images/src/java/org/lamsfoundation/lams/tool/imageGallery/dbupdates/patch20190103_updateTo31.sql
===================================================================
diff -u
--- lams_tool_images/src/java/org/lamsfoundation/lams/tool/imageGallery/dbupdates/patch20190103_updateTo31.sql	(revision 0)
+++ lams_tool_images/src/java/org/lamsfoundation/lams/tool/imageGallery/dbupdates/patch20190103_updateTo31.sql	(revision 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d)
@@ -0,0 +1,31 @@
+SET AUTOCOMMIT = 0;
+SET FOREIGN_KEY_CHECKS = 0;
+
+-- This patch contains files patch20170731.sql to patch20190103.sql
+-- It should upgrade this tool to version 3.1
+-- LDEV-4396 Remove obsolete fields
+ALTER TABLE tl_laimag10_imagegallery_item DROP COLUMN file_version_id;
+ALTER TABLE tl_laimag10_imagegallery_item DROP COLUMN file_type;
+
+UPDATE lams_tool SET tool_version='20170731' WHERE tool_signature='laimag10';
+
+
+
+
+-- LDEV-4558 Increase db text size for all user inputs
+ALTER TABLE tl_laimag10_imagegallery MODIFY instructions MEDIUMTEXT;
+ALTER TABLE tl_laimag10_imagegallery MODIFY reflect_instructions MEDIUMTEXT;
+ALTER TABLE tl_laimag10_imagegallery_item MODIFY description MEDIUMTEXT;
+
+
+
+
+-- LDEV-4743 Update tools version for LAMS 3.1 release
+UPDATE lams_tool SET tool_version='20190103' WHERE tool_signature='laimag10';
+
+
+
+-- If there were no errors, commit and restore autocommit to on
+COMMIT;
+SET AUTOCOMMIT = 1;
+SET FOREIGN_KEY_CHECKS=1;
\ No newline at end of file
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_imscc/src/java/org/lamsfoundation/lams/tool/commonCartridge/dbupdates/patch20180425.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_imscc/src/java/org/lamsfoundation/lams/tool/commonCartridge/dbupdates/patch20181012.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_imscc/src/java/org/lamsfoundation/lams/tool/commonCartridge/dbupdates/patch20190103.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: lams_tool_imscc/src/java/org/lamsfoundation/lams/tool/commonCartridge/dbupdates/patch20190103_updateTo31.sql
===================================================================
diff -u
--- lams_tool_imscc/src/java/org/lamsfoundation/lams/tool/commonCartridge/dbupdates/patch20190103_updateTo31.sql	(revision 0)
+++ lams_tool_imscc/src/java/org/lamsfoundation/lams/tool/commonCartridge/dbupdates/patch20190103_updateTo31.sql	(revision 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d)
@@ -0,0 +1,69 @@
+SET AUTOCOMMIT = 0;
+SET FOREIGN_KEY_CHECKS = 0;
+
+-- This patch contains files patch20171031.sql to patch20190103.sql
+-- It should upgrade this tool to version 3.1
+
+
+-- LDEV-4451 add 'Enable Confidence levels' advanced setting
+ALTER TABLE tl_lamc11_content ADD COLUMN enable_confidence_levels TINYINT(1) NOT NULL DEFAULT 0;
+
+--add questions' hashes in order to be able to search for the similar questions with the same title and question
+ALTER TABLE tl_lamc11_que_content ADD COLUMN question_hash CHAR(40);
+UPDATE tl_lamc11_que_content SET question_hash = SHA1(question);
+
+--add confidence level property to tl_laasse10_question_result
+ALTER TABLE tl_lamc11_usr_attempt ADD COLUMN confidence_level int;
+
+UPDATE lams_tool SET tool_version='20171031' WHERE tool_signature='lamc11';
+
+
+
+-- LDEV-4490 Fix NULL ConfidenceLevel columns creating exceptions
+UPDATE tl_lamc11_usr_attempt SET confidence_level = 0 WHERE confidence_level IS NULL;
+
+ALTER TABLE tl_lamc11_usr_attempt
+CHANGE COLUMN confidence_level confidence_level INT(11) NOT NULL DEFAULT 0;
+
+
+-- LDEV-4558 Increase db text size for all user inputs
+ALTER TABLE tl_lamc11_content MODIFY instructions MEDIUMTEXT;
+ALTER TABLE tl_lamc11_content MODIFY reflectionSubject MEDIUMTEXT;
+ALTER TABLE tl_lamc11_options_content MODIFY mc_que_option_text MEDIUMTEXT;
+
+ALTER TABLE tl_lamc11_que_content MODIFY question MEDIUMTEXT;
+ALTER TABLE tl_lamc11_que_content MODIFY feedback MEDIUMTEXT;
+
+
+-- LDEV-4577 Split feedback and marks in MCQ
+ALTER TABLE tl_lamc11_content ADD COLUMN display_feedback_only TINYINT(1) NOT NULL DEFAULT 0;
+
+
+
+-- LDEV-4440 Change tool access URLs after migration to Spring MVC
+UPDATE lams_tool SET 
+	author_url = 'tool/lamc11/authoring/authoring.do',
+	learner_url = 'tool/lamc11/learning/learning.do?mode=learner',
+	learner_preview_url = 'tool/lamc11/learning/learning.do?mode=author',
+	learner_progress_url = 'tool/lamc11/learning/learning.do?mode=teacher',
+	monitor_url = 'tool/lamc11/monitoring/monitoring.do',
+	pedagogical_planner_url = 'tool/lamc11/pedagogicalPlanner/initPedagogicalPlannerForm.do'
+WHERE tool_signature = 'lamc11';
+
+UPDATE lams_tool SET tool_version='20180724' WHERE tool_signature='lamc11';
+
+
+
+-- Trigger class name rename when importing an old LD
+UPDATE lams_tool SET tool_version='20181202' WHERE tool_signature='lamc11';
+
+
+
+-- LDEV-4743 Update tools version for LAMS 3.1 release
+UPDATE lams_tool SET tool_version='20190103' WHERE tool_signature='lamc11';
+
+
+-- If there were no errors, commit and restore autocommit to on
+COMMIT;
+SET AUTOCOMMIT = 1;
+SET FOREIGN_KEY_CHECKS=1;
\ No newline at end of file
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dbupdates/patch20171031.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dbupdates/patch20171218.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dbupdates/patch20180425.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dbupdates/patch20180511.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dbupdates/patch20180724.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dbupdates/patch20181202.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dbupdates/patch20190103.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dbupdates/patch20190103_updateTo31.sql
===================================================================
diff -u
--- lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dbupdates/patch20190103_updateTo31.sql	(revision 0)
+++ lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dbupdates/patch20190103_updateTo31.sql	(revision 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d)
@@ -0,0 +1,25 @@
+SET AUTOCOMMIT = 0;
+SET FOREIGN_KEY_CHECKS = 0;
+
+-- This patch contains files patch20180425.sql to patch20190103.sql
+-- It should upgrade this tool to version 3.1
+
+
+-- LDEV-4558 Increase db text size for all user inputs
+ALTER TABLE tl_laimsc11_commoncartridge MODIFY instructions MEDIUMTEXT;
+ALTER TABLE tl_laimsc11_commoncartridge MODIFY reflect_instructions MEDIUMTEXT;
+
+
+-- LDEV-4671 Remove "locked when finished" option
+ALTER TABLE tl_laimsc11_commoncartridge DROP COLUMN lock_on_finished;
+
+
+
+-- LDEV-4743 Update tools version for LAMS 3.1 release
+UPDATE lams_tool SET tool_version='20190103' WHERE tool_signature='laimsc11';
+
+
+-- If there were no errors, commit and restore autocommit to on
+COMMIT;
+SET AUTOCOMMIT = 1;
+SET FOREIGN_KEY_CHECKS=1;
\ No newline at end of file
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20180425.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20180729.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20180926.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20181202.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20190103.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20190103_updateTo31.sql
===================================================================
diff -u
--- lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20190103_updateTo31.sql	(revision 0)
+++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20190103_updateTo31.sql	(revision 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d)
@@ -0,0 +1,51 @@
+SET AUTOCOMMIT = 0;
+SET FOREIGN_KEY_CHECKS = 0;
+
+-- This patch contains files patch20180425.sql to patch20190103.sql
+-- It should upgrade this tool to version 3.1
+
+
+-- LDEV-4558 Increase db text size for all user inputs
+ALTER TABLE tl_laqa11_content MODIFY instructions MEDIUMTEXT;
+ALTER TABLE tl_laqa11_content MODIFY reflectionSubject MEDIUMTEXT;
+ALTER TABLE tl_laqa11_que_content MODIFY question MEDIUMTEXT;
+ALTER TABLE tl_laqa11_que_content MODIFY feedback MEDIUMTEXT;
+ALTER TABLE tl_laqa11_usr_resp MODIFY answer MEDIUMTEXT;
+ALTER TABLE tl_laqa11_usr_resp MODIFY answer_autosaved MEDIUMTEXT;
+
+
+-- LDEV-4440 Change tool access URLs after migration to Spring MVC
+UPDATE lams_tool SET 
+	author_url = 'tool/laqa11/authoring/authoring.do',
+	learner_url = 'tool/laqa11/learning/learning.do?mode=learner',
+	learner_preview_url = 'tool/laqa11/learning/learning.do?mode=author',
+	learner_progress_url = 'tool/laqa11/learning/learning.do?mode=teacher',
+	monitor_url = 'tool/laqa11/monitoring/monitoring.do',
+	pedagogical_planner_url = 'tool/laqa11/pedagogicalPlanner/initPedagogicalPlannerForm.do',
+	admin_url= 'tool/laqa11/admin.do' 
+WHERE tool_signature = 'laqa11';
+
+
+
+--  LDEV-4665 Remove Cognitive Skills Wizard
+DROP TABLE tl_laqa11_wizard_category;
+DROP TABLE tl_laqa11_wizard_cognitive_skill;
+DROP TABLE tl_laqa11_wizard_question;
+DROP TABLE tl_laqa11_configuration;
+UPDATE lams_tool SET admin_url= NULL WHERE tool_signature = 'laqa11';
+
+
+						    
+-- Trigger class name rename when importing an old LD
+UPDATE lams_tool SET tool_version='20181202' WHERE tool_signature='laqa11';
+
+
+
+-- LDEV-4743 Update tool version to mark LAMS 3.1 release
+UPDATE lams_tool SET tool_version='20190103' WHERE tool_signature='laqa11';
+
+
+-- If there were no errors, commit and restore autocommit to on
+COMMIT;
+SET AUTOCOMMIT = 1;
+SET FOREIGN_KEY_CHECKS=1;
\ No newline at end of file
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20170419.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20171220.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20180123.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20180425.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20190103.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20190103_updateTo31.sql
===================================================================
diff -u
--- lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20190103_updateTo31.sql	(revision 0)
+++ lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20190103_updateTo31.sql	(revision 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d)
@@ -0,0 +1,37 @@
+SET AUTOCOMMIT = 0;
+SET FOREIGN_KEY_CHECKS = 0;
+
+-- This patch contains files patch20170419.sql to patch20190103.sql
+-- It should upgrade this tool to version 3.1
+
+
+-- LDEV-2999 Rating Option for each Item
+ALTER TABLE tl_larsrc11_resource_item ADD COLUMN is_allow_rating TINYINT(1) default 0;
+
+
+
+-- LDEV-2999 Rating Option for each Item
+ALTER TABLE tl_larsrc11_resource_item ADD COLUMN is_allow_comments TINYINT(1) default 0;
+
+
+
+-- LDEV-4502 Redo change as it was lost in the sql merges
+-- LDEV-2941 Enable the option "Open URL in pop-up" for the example URL by default
+UPDATE tl_larsrc11_resource_item SET open_url_new_window=1 WHERE uid='1';
+
+
+
+-- LDEV-4558 Increase db text size for all user inputs
+ALTER TABLE tl_larsrc11_item_instruction MODIFY description MEDIUMTEXT;
+ALTER TABLE tl_larsrc11_resource MODIFY instructions MEDIUMTEXT;
+ALTER TABLE tl_larsrc11_resource MODIFY reflect_instructions MEDIUMTEXT;
+
+
+-- LDEV-4743 Update tool version to mark LAMS 3.1 release
+UPDATE lams_tool SET tool_version='20190103' WHERE tool_signature='larsrc11';
+
+
+-- If there were no errors, commit and restore autocommit to on
+COMMIT;
+SET AUTOCOMMIT = 1;
+SET FOREIGN_KEY_CHECKS=1;
\ No newline at end of file
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_leader/src/java/org/lamsfoundation/lams/tool/leaderselection/dbupdates/patch20190103.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: lams_tool_leader/src/java/org/lamsfoundation/lams/tool/leaderselection/dbupdates/patch20190103_updateTo31.sql
===================================================================
diff -u
--- lams_tool_leader/src/java/org/lamsfoundation/lams/tool/leaderselection/dbupdates/patch20190103_updateTo31.sql	(revision 0)
+++ lams_tool_leader/src/java/org/lamsfoundation/lams/tool/leaderselection/dbupdates/patch20190103_updateTo31.sql	(revision 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d)
@@ -0,0 +1,15 @@
+SET AUTOCOMMIT = 0;
+SET FOREIGN_KEY_CHECKS = 0;
+
+-- This patch contains only patch20190103.sql
+-- It was created for naming consitency with other tools
+-- It should upgrade this tool to version 3.1
+
+-- LDEV-4743 Update tools version for LAMS 3.1 release
+UPDATE lams_tool SET tool_version='20190103' WHERE tool_signature='lalead11';
+
+
+-- If there were no errors, commit and restore autocommit to on
+COMMIT;
+SET AUTOCOMMIT = 1;
+SET FOREIGN_KEY_CHECKS=1;
\ No newline at end of file
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_mindmap/src/java/org/lamsfoundation/lams/tool/mindmap/dbupdates/patch20180517.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_mindmap/src/java/org/lamsfoundation/lams/tool/mindmap/dbupdates/patch20180731.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_mindmap/src/java/org/lamsfoundation/lams/tool/mindmap/dbupdates/patch20190103.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: lams_tool_mindmap/src/java/org/lamsfoundation/lams/tool/mindmap/dbupdates/patch20190103_updateTo31.sql
===================================================================
diff -u
--- lams_tool_mindmap/src/java/org/lamsfoundation/lams/tool/mindmap/dbupdates/patch20190103_updateTo31.sql	(revision 0)
+++ lams_tool_mindmap/src/java/org/lamsfoundation/lams/tool/mindmap/dbupdates/patch20190103_updateTo31.sql	(revision 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d)
@@ -0,0 +1,36 @@
+SET AUTOCOMMIT = 0;
+SET FOREIGN_KEY_CHECKS = 0;
+
+-- This patch contains files patch20180517.sql to patch20190103.sql
+-- It should upgrade this tool to version 3.1
+
+
+-- Convert to mindmup. Color now #xxxxxx not just xxxxxx
+ALTER TABLE tl_lamind10_node MODIFY node_color VARCHAR(7);
+UPDATE tl_lamind10_node SET node_color = CONCAT('#',node_color) WHERE NOT node_color LIKE ('#%');
+
+
+
+-- LDEV-4440 Change tool access URLs after migration to Spring MVC
+UPDATE lams_tool SET 
+	author_url = 'tool/lamind10/authoring/authoring.do',
+	learner_url = 'tool/lamind10/learning/learning.do?mode=learner',
+	learner_preview_url = 'tool/lamind10/learning/learning.do?mode=author',
+	learner_progress_url = 'tool/lamind10/learning/learning.do?mode=teacher',
+	monitor_url = 'tool/lamind10/monitoring/monitoring.do',
+	pedagogical_planner_url = 'tool/lamind10/pedagogicalPlanner/initPedagogicalPlannerForm.do'
+WHERE tool_signature = 'lamind10';
+
+UPDATE lams_tool SET tool_version='20180731' WHERE tool_signature='lamind10';
+
+
+
+-- LDEV-4743 Update tools version for LAMS 3.1 release
+UPDATE lams_tool SET tool_version='20190103' WHERE tool_signature='lamind10';
+
+
+
+-- If there were no errors, commit and restore autocommit to on
+COMMIT;
+SET AUTOCOMMIT = 1;
+SET FOREIGN_KEY_CHECKS=1;
\ No newline at end of file
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dbupdates/patch20180425.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dbupdates/patch20180508.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dbupdates/patch20180716.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dbupdates/patch20181202.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dbupdates/patch20190103.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dbupdates/patch20190103_updateTo31.sql
===================================================================
diff -u
--- lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dbupdates/patch20190103_updateTo31.sql	(revision 0)
+++ lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dbupdates/patch20190103_updateTo31.sql	(revision 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d)
@@ -0,0 +1,47 @@
+SET AUTOCOMMIT = 0;
+SET FOREIGN_KEY_CHECKS = 0;
+
+-- This patch contains files patch20180425.sql to patch20190103.sql
+-- It should upgrade this tool to version 3.1
+
+-- LDEV-4558 Increase db text size for all user inputs
+ALTER TABLE tl_lanb11_content MODIFY content MEDIUMTEXT;
+ALTER TABLE tl_lanb11_content MODIFY reflect_instructions MEDIUMTEXT;
+
+
+
+
+-- LDEV-4559 Option to allow students to post anonymously
+ALTER TABLE tl_lanb11_content ADD COLUMN allow_anonymous TINYINT(1) DEFAULT 0;
+
+
+
+
+-- LDEV-4440 Change tool access URLs after migration to Spring MVC
+UPDATE lams_tool SET 
+	author_url = 'tool/lanb11/authoring/authoring.do',
+	learner_url = 'tool/lanb11/learning/learner.do',
+	learner_preview_url = 'tool/lanb11/learning/author.do',
+	learner_progress_url = 'tool/lanb11/learning/teacher.do',
+	monitor_url = 'tool/lanb11/monitoring/monitoring.do',
+	pedagogical_planner_url = 'tool/lanb11/pedagogicalPlanner/initPedagogicalPlannerForm.do'
+WHERE tool_signature = 'lanb11';
+
+UPDATE lams_tool SET tool_version='20180716' WHERE tool_signature='lanb11';
+
+
+
+						    
+-- Trigger class name rename when importing an old LD
+UPDATE lams_tool SET tool_version='20181202' WHERE tool_signature='lanb11';
+
+
+
+-- LDEV-4743 Update tools version for LAMS 3.1 release
+UPDATE lams_tool SET tool_version='20190103' WHERE tool_signature='lanb11';
+
+
+-- If there were no errors, commit and restore autocommit to on
+COMMIT;
+SET AUTOCOMMIT = 1;
+SET FOREIGN_KEY_CHECKS=1;
\ No newline at end of file
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_notebook/src/java/org/lamsfoundation/lams/tool/notebook/dbupdates/patch20190103.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: lams_tool_notebook/src/java/org/lamsfoundation/lams/tool/notebook/dbupdates/patch20190103_updateTo31.sql
===================================================================
diff -u
--- lams_tool_notebook/src/java/org/lamsfoundation/lams/tool/notebook/dbupdates/patch20190103_updateTo31.sql	(revision 0)
+++ lams_tool_notebook/src/java/org/lamsfoundation/lams/tool/notebook/dbupdates/patch20190103_updateTo31.sql	(revision 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d)
@@ -0,0 +1,15 @@
+SET AUTOCOMMIT = 0;
+SET FOREIGN_KEY_CHECKS = 0;
+
+-- This patch contains only patch20190103.sql
+-- It was created for naming consitency with other tools
+-- It should upgrade this tool to version 3.1
+
+-- LDEV-4743 Update tools version for LAMS 3.1 release
+UPDATE lams_tool SET tool_version='20190103' WHERE tool_signature='lantbk11';
+
+
+-- If there were no errors, commit and restore autocommit to on
+COMMIT;
+SET AUTOCOMMIT = 1;
+SET FOREIGN_KEY_CHECKS=1;
\ No newline at end of file
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_pixlr/src/java/org/lamsfoundation/lams/tool/pixlr/dbupdates/patch20190103.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: lams_tool_pixlr/src/java/org/lamsfoundation/lams/tool/pixlr/dbupdates/patch20190103_updateTo31.sql
===================================================================
diff -u
--- lams_tool_pixlr/src/java/org/lamsfoundation/lams/tool/pixlr/dbupdates/patch20190103_updateTo31.sql	(revision 0)
+++ lams_tool_pixlr/src/java/org/lamsfoundation/lams/tool/pixlr/dbupdates/patch20190103_updateTo31.sql	(revision 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d)
@@ -0,0 +1,15 @@
+SET AUTOCOMMIT = 0;
+SET FOREIGN_KEY_CHECKS = 0;
+
+-- This patch contains only patch20190103.sql
+-- It was created for naming consitency with other tools
+-- It should upgrade this tool to version 3.1
+
+-- LDEV-4743 Update tool version to mark LAMS 3.1 release
+UPDATE lams_tool SET tool_version='20190103' WHERE tool_signature='lapixl10';
+
+
+-- If there were no errors, commit and restore autocommit to on
+COMMIT;
+SET AUTOCOMMIT = 1;
+SET FOREIGN_KEY_CHECKS=1;
\ No newline at end of file
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_preview/src/java/org/lamsfoundation/lams/tool/peerreview/dbupdates/patch20170215.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_preview/src/java/org/lamsfoundation/lams/tool/peerreview/dbupdates/patch20170512.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_preview/src/java/org/lamsfoundation/lams/tool/peerreview/dbupdates/patch20180425.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_preview/src/java/org/lamsfoundation/lams/tool/peerreview/dbupdates/patch20190103.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: lams_tool_preview/src/java/org/lamsfoundation/lams/tool/peerreview/dbupdates/patch20190103_updateTo31.sql
===================================================================
diff -u
--- lams_tool_preview/src/java/org/lamsfoundation/lams/tool/peerreview/dbupdates/patch20190103_updateTo31.sql	(revision 0)
+++ lams_tool_preview/src/java/org/lamsfoundation/lams/tool/peerreview/dbupdates/patch20190103_updateTo31.sql	(revision 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d)
@@ -0,0 +1,60 @@
+SET AUTOCOMMIT = 0;
+SET FOREIGN_KEY_CHECKS = 0;
+
+-- This patch contains files patch20170215.sql to patch20190103.sql
+-- It should upgrade this tool to version 3.1
+
+-- LDEV-4233: Ability to remove users from Peer Review tool
+ALTER TABLE tl_laprev11_user ADD COLUMN hidden TINYINT(1) DEFAULT '0';
+
+
+
+
+--     LDEV-2999 Include a rating option for viewed resources. The one in 
+-- the core needs to run first but we cannot force that.
+-- Update existing Peer Review
+DROP TABLE IF EXISTS tmp_peerreview_rating_sessionid;
+CREATE TEMPORARY TABLE tmp_peerreview_rating_sessionid AS
+SELECT r.uid rating_uid, prs.session_id session_id
+FROM lams_rating r
+JOIN lams_rating_criteria rc ON r.rating_criteria_id = rc.rating_criteria_id
+JOIN tl_laprev11_peerreview pr ON rc.tool_content_id = pr.content_id
+JOIN tl_laprev11_session prs ON pr.uid = prs.peerreview_uid
+JOIN tl_laprev11_user pru ON r.user_id = pru.user_id AND prs.uid = pru.session_uid;
+
+UPDATE lams_rating r
+JOIN tmp_peerreview_rating_sessionid tmp ON r.uid = tmp.rating_uid
+SET r.tool_session_id = tmp.session_id;
+
+DROP TABLE tmp_peerreview_rating_sessionid;
+CREATE TEMPORARY TABLE tmp_peerreview_rating_sessionid AS
+SELECT r.uid rating_uid, prs.session_id session_id
+FROM lams_rating_comment r
+JOIN lams_rating_criteria rc ON r.rating_criteria_id = rc.rating_criteria_id
+JOIN tl_laprev11_peerreview pr ON rc.tool_content_id = pr.content_id
+JOIN tl_laprev11_session prs ON pr.uid = prs.peerreview_uid
+JOIN tl_laprev11_user pru ON r.user_id = pru.user_id AND prs.uid = pru.session_uid;
+
+UPDATE lams_rating_comment r
+JOIN tmp_peerreview_rating_sessionid tmp ON r.uid = tmp.rating_uid
+SET r.tool_session_id = tmp.session_id;
+
+DROP TABLE tmp_peerreview_rating_sessionid;
+
+
+
+
+-- LDEV-4558 Increase db text size for all user inputs
+ALTER TABLE tl_laprev11_peerreview MODIFY instructions MEDIUMTEXT;
+ALTER TABLE tl_laprev11_peerreview MODIFY reflect_instructions MEDIUMTEXT;
+
+
+
+-- LDEV-4743 Update tool version to mark LAMS 3.1 release
+UPDATE lams_tool SET tool_version='20190103' WHERE tool_signature='laprev11';
+
+
+-- If there were no errors, commit and restore autocommit to on
+COMMIT;
+SET AUTOCOMMIT = 1;
+SET FOREIGN_KEY_CHECKS=1;
\ No newline at end of file
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/patch20171114.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/patch20180425.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/patch20180702.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/patch20180720.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/patch20181202.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/patch20190103.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/patch20190103_updateTo31.sql
===================================================================
diff -u
--- lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/patch20190103_updateTo31.sql	(revision 0)
+++ lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/patch20190103_updateTo31.sql	(revision 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d)
@@ -0,0 +1,69 @@
+SET AUTOCOMMIT = 0;
+SET FOREIGN_KEY_CHECKS = 0;
+
+-- This patch contains files patch20171114.sql to patch20190103.sql
+-- It should upgrade this tool to version 3.1
+
+-- LDEV-4482
+
+
+ALTER TABLE tl_lasbmt11_content ADD COLUMN use_select_leader_tool_ouput TINYINT(1) NOT NULL DEFAULT 0;
+
+ALTER TABLE tl_lasbmt11_session ADD COLUMN group_leader_uid BIGINT;
+ALTER TABLE tl_lasbmt11_session ADD INDEX FK_lasbmt11_session_1 (group_leader_uid), ADD CONSTRAINT tl_lasbmt11_session FOREIGN KEY (group_leader_uid) REFERENCES tl_lasbmt11_user (uid) ON DELETE CASCADE ON UPDATE CASCADE;
+
+-- Adding a constraint to the assessment user table so no same user_id and session_id can be repetead 
+-- (Please, note there are some duplicate users exist (their session_uid is null), they got formed when techers created questions in authoring. It's required to keep track of questions' authors.) 
+ALTER TABLE tl_lasbmt11_user ADD UNIQUE INDEX(user_id, session_id);
+ 
+
+
+
+-- LDEV-4558 Increase db text size for all user inputs
+ALTER TABLE tl_lasbmt11_content MODIFY instruction MEDIUMTEXT;
+ALTER TABLE tl_lasbmt11_content MODIFY reflect_instructions MEDIUMTEXT;
+ALTER TABLE tl_lasbmt11_report MODIFY comments MEDIUMTEXT;
+ALTER TABLE tl_lasbmt11_submission_details MODIFY fileDescription MEDIUMTEXT;
+
+
+
+-- LDEV-4611 Release marks is now a state
+ALTER TABLE tl_lasbmt11_session ADD COLUMN marks_released TINYINT(1) DEFAULT 0;
+
+UPDATE tl_lasbmt11_session as sessions, tl_lasbmt11_report as report, tl_lasbmt11_submission_details as details
+		SET sessions.marks_released = 1 
+		WHERE report.report_id = details.submission_id AND details.session_id=sessions.session_id AND report.date_marks_released IS NOT NULL;
+
+ALTER TABLE tl_lasbmt11_report DROP COLUMN date_marks_released;
+
+
+
+
+-- LDEV-4440 Change tool access URLs after migration to Spring MVC
+UPDATE lams_tool SET 
+	author_url = 'tool/lasbmt11/authoring/authoring.do',
+	learner_url = 'tool/lasbmt11/learning/learner.do',
+	learner_preview_url = 'tool/lasbmt11/learning/author.do',
+	learner_progress_url = 'tool/lasbmt11/learning/teacher.do',
+	monitor_url = 'tool/lasbmt11/monitoring/monitoring.do',
+	pedagogical_planner_url = 'tool/lasbmt11/pedagogicalPlanner/initPedagogicalPlannerForm.do'
+WHERE tool_signature = 'lasbmt11';
+
+UPDATE lams_tool SET tool_version='20180720' WHERE tool_signature='lasbmt11';
+
+
+
+						    
+-- Trigger class name rename when importing an old LD
+UPDATE lams_tool SET tool_version='20181202' WHERE tool_signature='lasbmt11';
+
+
+
+
+-- LDEV-4743 Update tool version to mark LAMS 3.1 release
+UPDATE lams_tool SET tool_version='20190103' WHERE tool_signature='lasbmt11';
+
+-- If there were no errors, commit and restore autocommit to on
+COMMIT;
+SET AUTOCOMMIT = 1;
+SET FOREIGN_KEY_CHECKS=1;
\ No newline at end of file
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20170221.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20171026.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20171106.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20180223.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20180316.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20180425.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20180828.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20190103.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20190103_updateTo31.sql
===================================================================
diff -u
--- lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20190103_updateTo31.sql	(revision 0)
+++ lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20190103_updateTo31.sql	(revision 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d)
@@ -0,0 +1,59 @@
+SET AUTOCOMMIT = 0;
+SET FOREIGN_KEY_CHECKS = 0;
+
+-- This patch contains files patch20170221.sql to patch20190103.sql
+-- It should upgrade this tool to version 3.1
+
+
+--  LDEV-4244 Add new advanced option - shuffle scratchie Items
+ALTER TABLE tl_lascrt11_scratchie ADD COLUMN shuffle_items TINYINT(1) DEFAULT 0;
+
+
+
+-- LDEV-4451 add 'Display confidence levels' advanced option
+ALTER TABLE tl_lascrt11_scratchie ADD COLUMN confidence_levels_activity_uiid INT(11);
+
+
+
+-- LDEV-4458 Add option to overwrite default scoring system
+ALTER TABLE tl_lascrt11_scratchie ADD COLUMN preset_marks varchar(255);
+
+
+
+
+-- LDEV-3224 Ability to change, add, remove questions even after student have reached it
+ALTER TABLE tl_lascrt11_user DROP FOREIGN KEY FK_NEW_610529188_30113BFC309ED320;
+ALTER TABLE tl_lascrt11_user DROP COLUMN scratchie_uid, DROP INDEX FK_NEW_610529188_30113BFC309ED320;
+
+UPDATE lams_tool SET tool_version='20180223' WHERE tool_signature='lascrt11';
+
+
+
+-- LDEV-4530 Turn on/off showing scratchies to learners on results page
+ALTER TABLE tl_lascrt11_scratchie ADD COLUMN show_scratchies_in_results TINYINT(1) DEFAULT 1;
+
+
+
+
+-- LDEV-4558 Increase db text size for all user inputs
+ALTER TABLE tl_lascrt11_scratchie MODIFY instructions MEDIUMTEXT;
+ALTER TABLE tl_lascrt11_scratchie MODIFY reflect_instructions MEDIUMTEXT;
+ALTER TABLE tl_lascrt11_scratchie_answer MODIFY description MEDIUMTEXT;
+ALTER TABLE tl_lascrt11_scratchie_item MODIFY description MEDIUMTEXT;
+
+
+
+-- LDEV-4558 Bump tool version so we can import tool content from older versions
+UPDATE lams_tool SET tool_version='20180828' WHERE tool_signature='lascrt11';
+
+
+
+-- LDEV-4743 Update tool version to mark LAMS 3.1 release
+UPDATE lams_tool SET tool_version='20190103' WHERE tool_signature='lascrt11';
+
+
+
+-- If there were no errors, commit and restore autocommit to on
+COMMIT;
+SET AUTOCOMMIT = 1;
+SET FOREIGN_KEY_CHECKS=1;
\ No newline at end of file
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_scribe/src/java/org/lamsfoundation/lams/tool/scribe/dbupdates/patch20170308.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_scribe/src/java/org/lamsfoundation/lams/tool/scribe/dbupdates/patch20190103.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: lams_tool_scribe/src/java/org/lamsfoundation/lams/tool/scribe/dbupdates/patch20190103_updateTo31.sql
===================================================================
diff -u
--- lams_tool_scribe/src/java/org/lamsfoundation/lams/tool/scribe/dbupdates/patch20190103_updateTo31.sql	(revision 0)
+++ lams_tool_scribe/src/java/org/lamsfoundation/lams/tool/scribe/dbupdates/patch20190103_updateTo31.sql	(revision 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d)
@@ -0,0 +1,19 @@
+SET AUTOCOMMIT = 0;
+SET FOREIGN_KEY_CHECKS = 0;
+
+-- This patch contains files patch20170308.sql to patch20190103.sql
+-- It should upgrade this tool to version 3.1
+
+
+-- LDEV-4261 Remove optimistic locking management
+ALTER TABLE tl_lascrb11_session DROP COLUMN version;
+
+
+-- LDEV-4743 Update tool version to mark LAMS 3.1 release
+UPDATE lams_tool SET tool_version='20190103' WHERE tool_signature='lascrb11';
+
+
+-- If there were no errors, commit and restore autocommit to on
+COMMIT;
+SET AUTOCOMMIT = 1;
+SET FOREIGN_KEY_CHECKS=1;
\ No newline at end of file
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_spreadsheet/src/java/org/lamsfoundation/lams/tool/spreadsheet/dbupdates/patch20180425.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_spreadsheet/src/java/org/lamsfoundation/lams/tool/spreadsheet/dbupdates/patch20190103.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: lams_tool_spreadsheet/src/java/org/lamsfoundation/lams/tool/spreadsheet/dbupdates/patch20190103_updateTo31.sql
===================================================================
diff -u
--- lams_tool_spreadsheet/src/java/org/lamsfoundation/lams/tool/spreadsheet/dbupdates/patch20190103_updateTo31.sql	(revision 0)
+++ lams_tool_spreadsheet/src/java/org/lamsfoundation/lams/tool/spreadsheet/dbupdates/patch20190103_updateTo31.sql	(revision 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d)
@@ -0,0 +1,23 @@
+SET AUTOCOMMIT = 0;
+SET FOREIGN_KEY_CHECKS = 0;
+
+-- This patch contains files patch20180425.sql to patch20190103.sql
+-- It should upgrade this tool to version 3.1
+
+
+-- LDEV-4558 Increase db text size for all user inputs
+ALTER TABLE tl_lasprd10_spreadsheet MODIFY instructions MEDIUMTEXT;
+ALTER TABLE tl_lasprd10_spreadsheet MODIFY reflect_instructions MEDIUMTEXT;
+ALTER TABLE tl_lasprd10_spreadsheet_mark MODIFY comments MEDIUMTEXT;
+
+
+
+-- LDEV-4743 Update tool version to mark LAMS 3.1 release
+UPDATE lams_tool SET tool_version='20190103' WHERE tool_signature='lasprd10';
+
+
+
+-- If there were no errors, commit and restore autocommit to on
+COMMIT;
+SET AUTOCOMMIT = 1;
+SET FOREIGN_KEY_CHECKS=1;
\ No newline at end of file
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/dbupdates/patch20180425.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/dbupdates/patch20190103.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/dbupdates/patch20190103_updateTo31.sql
===================================================================
diff -u
--- lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/dbupdates/patch20190103_updateTo31.sql	(revision 0)
+++ lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/dbupdates/patch20190103_updateTo31.sql	(revision 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d)
@@ -0,0 +1,25 @@
+SET AUTOCOMMIT = 0;
+SET FOREIGN_KEY_CHECKS = 0;
+
+-- This patch contains files patch20180425.sql to patch20190103.sql
+-- It should upgrade this tool to version 3.1
+
+
+
+-- LDEV-4558 Increase db text size for all user inputs
+ALTER TABLE tl_lasurv11_question MODIFY description MEDIUMTEXT;
+ALTER TABLE tl_lasurv11_answer MODIFY answer_text MEDIUMTEXT;
+ALTER TABLE tl_lasurv11_option MODIFY description MEDIUMTEXT;
+ALTER TABLE tl_lasurv11_survey MODIFY instructions MEDIUMTEXT;
+ALTER TABLE tl_lasurv11_survey MODIFY reflect_instructions MEDIUMTEXT;
+
+
+-- LDEV-4743 Update tool version to mark LAMS 3.1 release
+UPDATE lams_tool SET tool_version='20190103' WHERE tool_signature='lasurv11';
+
+
+
+-- If there were no errors, commit and restore autocommit to on
+COMMIT;
+SET AUTOCOMMIT = 1;
+SET FOREIGN_KEY_CHECKS=1;
\ No newline at end of file
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_task/src/java/org/lamsfoundation/lams/tool/taskList/dbupdates/patch20180425.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_task/src/java/org/lamsfoundation/lams/tool/taskList/dbupdates/patch20181216.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_task/src/java/org/lamsfoundation/lams/tool/taskList/dbupdates/patch20190103.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: lams_tool_task/src/java/org/lamsfoundation/lams/tool/taskList/dbupdates/patch20190103_updateTo31.sql
===================================================================
diff -u
--- lams_tool_task/src/java/org/lamsfoundation/lams/tool/taskList/dbupdates/patch20190103_updateTo31.sql	(revision 0)
+++ lams_tool_task/src/java/org/lamsfoundation/lams/tool/taskList/dbupdates/patch20190103_updateTo31.sql	(revision 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d)
@@ -0,0 +1,32 @@
+SET AUTOCOMMIT = 0;
+SET FOREIGN_KEY_CHECKS = 0;
+
+-- This patch contains files patch20180425.sql to patch20190103.sql
+-- It should upgrade this tool to version 3.1
+
+
+
+
+-- LDEV-4558 Increase db text size for all user inputs
+ALTER TABLE tl_latask10_item_comment MODIFY comment MEDIUMTEXT;
+ALTER TABLE tl_latask10_tasklist MODIFY instructions MEDIUMTEXT;
+ALTER TABLE tl_latask10_tasklist MODIFY reflect_instructions MEDIUMTEXT;
+ALTER TABLE tl_latask10_tasklist_item MODIFY description MEDIUMTEXT;
+
+
+-- LDEV-4707 Remove never used fields from TaskListItem
+ALTER TABLE tl_latask10_tasklist_item DROP COLUMN show_comments_to_all,
+	DROP COLUMN is_comments_files_allowed;
+
+UPDATE lams_tool SET tool_version='20181216' WHERE tool_signature='latask10';
+
+
+
+-- LDEV-4743 Update tool version to mark LAMS 3.1 release
+UPDATE lams_tool SET tool_version='20190103' WHERE tool_signature='latask10';
+
+
+-- If there were no errors, commit and restore autocommit to on
+COMMIT;
+SET AUTOCOMMIT = 1;
+SET FOREIGN_KEY_CHECKS=1;
\ No newline at end of file
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_vote/src/java/org/lamsfoundation/lams/tool/vote/dbupdates/patch20171023.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_vote/src/java/org/lamsfoundation/lams/tool/vote/dbupdates/patch20180425.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_vote/src/java/org/lamsfoundation/lams/tool/vote/dbupdates/patch20181202.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_vote/src/java/org/lamsfoundation/lams/tool/vote/dbupdates/patch20190103.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: lams_tool_vote/src/java/org/lamsfoundation/lams/tool/vote/dbupdates/patch20190103_updateTo31.sql
===================================================================
diff -u
--- lams_tool_vote/src/java/org/lamsfoundation/lams/tool/vote/dbupdates/patch20190103_updateTo31.sql	(revision 0)
+++ lams_tool_vote/src/java/org/lamsfoundation/lams/tool/vote/dbupdates/patch20190103_updateTo31.sql	(revision 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d)
@@ -0,0 +1,41 @@
+SET AUTOCOMMIT = 0;
+SET FOREIGN_KEY_CHECKS = 0;
+
+-- This patch contains files patch20180425.sql to patch20190103.sql
+-- It should upgrade this tool to version 3.1
+
+
+-- LDEV-4440 Change tool access URLs after migration to Spring MVC
+UPDATE lams_tool SET 
+	author_url = 'tool/lavote11/authoring/start.do',
+	learner_url = 'tool/lavote11/learning/start.do?mode=learner',
+	learner_preview_url = 'tool/lavote11/learning/start.do?mode=author',
+	learner_progress_url = 'tool/lavote11/learning/start.do?mode=teacher',
+	monitor_url = 'tool/lavote11/monitoring/start.do',
+	pedagogical_planner_url = 'tool/lavote11/pedagogicalPlanner/initPedagogicalPlannerForm.do'
+WHERE tool_signature = 'lavote11';
+
+UPDATE lams_tool SET tool_version='20171023' WHERE tool_signature='lavote11';
+
+
+-- LDEV-4558 Increase db text size for all user inputs
+ALTER TABLE tl_lavote11_content MODIFY instructions MEDIUMTEXT;
+ALTER TABLE tl_lavote11_content MODIFY reflectionSubject MEDIUMTEXT;
+ALTER TABLE tl_lavote11_nomination_content MODIFY nomination MEDIUMTEXT;
+
+
+						    
+-- Trigger class name rename when importing an old LD
+UPDATE lams_tool SET tool_version='20181202' WHERE tool_signature='lavote11';
+
+
+
+-- LDEV-4743 Update tool version to mark LAMS 3.1 release
+UPDATE lams_tool SET tool_version='20190103' WHERE tool_signature='lavote11';
+
+
+
+-- If there were no errors, commit and restore autocommit to on
+COMMIT;
+SET AUTOCOMMIT = 1;
+SET FOREIGN_KEY_CHECKS=1;
\ No newline at end of file
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_wiki/src/java/org/lamsfoundation/lams/tool/wiki/dbupdates/patch20180425.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_wiki/src/java/org/lamsfoundation/lams/tool/wiki/dbupdates/patch20180810.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_wiki/src/java/org/lamsfoundation/lams/tool/wiki/dbupdates/patch20190103.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: lams_tool_wiki/src/java/org/lamsfoundation/lams/tool/wiki/dbupdates/patch20190103_updateTo31.sql
===================================================================
diff -u
--- lams_tool_wiki/src/java/org/lamsfoundation/lams/tool/wiki/dbupdates/patch20190103_updateTo31.sql	(revision 0)
+++ lams_tool_wiki/src/java/org/lamsfoundation/lams/tool/wiki/dbupdates/patch20190103_updateTo31.sql	(revision 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d)
@@ -0,0 +1,33 @@
+SET AUTOCOMMIT = 0;
+SET FOREIGN_KEY_CHECKS = 0;
+
+-- This patch contains files patch20171023.sql to patch20190103.sql
+-- It should upgrade this tool to version 3.1
+
+
+-- LDEV-4558 Increase db text size for all user inputs
+ALTER TABLE tl_lanb11_content MODIFY content MEDIUMTEXT;
+ALTER TABLE tl_lanb11_content MODIFY reflect_instructions MEDIUMTEXT;
+
+
+-- LDEV-4440 Change tool access URLs after migration to Spring MVC
+UPDATE lams_tool SET 
+	author_url = 'tool/lawiki10/authoring/authoring.do',
+	learner_url = 'tool/lawiki10/learning/learning.do?mode=learner',
+	learner_preview_url = 'tool/lawiki10/learning/learning.do?mode=author',
+	learner_progress_url = 'tool/lawiki10/learning/learning.do?mode=teacher',
+	monitor_url = 'tool/lawiki10/monitoring/monitoring.do',
+	pedagogical_planner_url = 'tool/lawiki10/authoring/initPedagogicalPlannerForm.do'
+WHERE tool_signature = 'lawiki10';
+
+UPDATE lams_tool SET tool_version='20180810' WHERE tool_signature='lawiki10';
+
+
+
+-- LDEV-4743 Update tool version to mark LAMS 3.1 release
+UPDATE lams_tool SET tool_version='20190103' WHERE tool_signature='lawiki10';
+
+-- If there were no errors, commit and restore autocommit to on
+COMMIT;
+SET AUTOCOMMIT = 1;
+SET FOREIGN_KEY_CHECKS=1;
\ No newline at end of file
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_zoom/src/java/org/lamsfoundation/lams/tool/zoom/dbupdates/patch20180917.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d refers to a dead (removed) revision in file `lams_tool_zoom/src/java/org/lamsfoundation/lams/tool/zoom/dbupdates/patch20190103.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: lams_tool_zoom/src/java/org/lamsfoundation/lams/tool/zoom/dbupdates/patch20190103_updateTo31.sql
===================================================================
diff -u
--- lams_tool_zoom/src/java/org/lamsfoundation/lams/tool/zoom/dbupdates/patch20190103_updateTo31.sql	(revision 0)
+++ lams_tool_zoom/src/java/org/lamsfoundation/lams/tool/zoom/dbupdates/patch20190103_updateTo31.sql	(revision 2bbc9f861c8ae11c17da087af6ce1a0cd49a966d)
@@ -0,0 +1,29 @@
+SET AUTOCOMMIT = 0;
+SET FOREIGN_KEY_CHECKS = 0;
+
+-- This patch contains files patch20180917.sql to patch20190103.sql
+-- It should upgrade this tool to version 3.1
+
+
+-- LDEV-4440 Change tool access URLs after migration to Spring MVC
+UPDATE lams_tool SET 
+	author_url = 'tool/lazoom10/authoring/start.do',
+	learner_url = 'tool/lazoom10/learning/start.do?mode=learner',
+	learner_preview_url = 'tool/lazoom10/learning/start.do?mode=author',
+	learner_progress_url = 'tool/lazoom10/learning/start.do?mode=teacher',
+	monitor_url = 'tool/lazoom10/monitoring/start.do',
+	admin_url = 'tool/lazoom10/admin/start.do'
+WHERE tool_signature = 'lazoom10';
+
+UPDATE lams_tool SET tool_version='20180917' WHERE tool_signature='lazoom10';
+
+
+
+-- LDEV-4743 Update tool version to mark LAMS 3.1 release
+UPDATE lams_tool SET tool_version='20190103' WHERE tool_signature='lazoom10';
+
+
+-- If there were no errors, commit and restore autocommit to on
+COMMIT;
+SET AUTOCOMMIT = 1;
+SET FOREIGN_KEY_CHECKS=1;
\ No newline at end of file