Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20170101.sql =================================================================== RCS file: /usr/local/cvsroot/lams_common/src/java/org/lamsfoundation/lams/dbupdates/Attic/patch20170101.sql,v diff -u -r1.1.2.1 -r1.1.2.2 --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20170101.sql 1 Mar 2017 12:10:30 -0000 1.1.2.1 +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20170101.sql 7 Mar 2017 22:54:37 -0000 1.1.2.2 @@ -25,7 +25,7 @@ ALTER TABLE lams_learning_activity DROP COLUMN define_later_flag, DROP COLUMN run_offline_flag, DROP COLUMN help_text, - MODIFY COLUMN readonly TINYINT(1), + MODIFY COLUMN read_only TINYINT(1), MODIFY COLUMN initialised TINYINT(1), MODIFY COLUMN stop_after_activity TINYINT(1); Index: lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20170101.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/Attic/patch20170101.sql,v diff -u -r1.1.2.1 -r1.1.2.2 --- lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20170101.sql 27 Feb 2017 14:00:15 -0000 1.1.2.1 +++ lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20170101.sql 7 Mar 2017 23:00:30 -0000 1.1.2.2 @@ -12,9 +12,8 @@ ALTER TABLE tl_lascrt11_session MODIFY COLUMN status TINYINT(1), MODIFY COLUMN scratching_finished TINYINT(1) DEFAULT 0; -ALTER TABLE tl_lascrt11_user MODIFY COLUMN session_finished TINYINT(1), - MODIFY COLUMN scratching_finished TINYINT(1); - +ALTER TABLE tl_lascrt11_user MODIFY COLUMN session_finished TINYINT(1); + ALTER TABLE tl_lascrt11_scratchie_answer MODIFY COLUMN correct TINYINT(1); ALTER TABLE tl_lascrt11_scratchie_item MODIFY COLUMN create_by_author TINYINT(1); @@ -28,4 +27,4 @@ -- 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 +SET FOREIGN_KEY_CHECKS=1; Index: lams_tool_task/src/java/org/lamsfoundation/lams/tool/taskList/dbupdates/patch20170101.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_task/src/java/org/lamsfoundation/lams/tool/taskList/dbupdates/Attic/patch20170101.sql,v diff -u -r1.1.2.1 -r1.1.2.2 --- lams_tool_task/src/java/org/lamsfoundation/lams/tool/taskList/dbupdates/patch20170101.sql 27 Feb 2017 14:00:10 -0000 1.1.2.1 +++ lams_tool_task/src/java/org/lamsfoundation/lams/tool/taskList/dbupdates/patch20170101.sql 7 Mar 2017 22:55:15 -0000 1.1.2.2 @@ -4,14 +4,13 @@ ----------------------Put all sql statements below here------------------------- -- LDEV-4180 -ALTER TABLE tl_latask10_tasklist MODIFY COLUMN lock_on_finished TINYINT(1), +ALTER TABLE tl_latask10_tasklist MODIFY COLUMN lock_when_finished TINYINT(1), MODIFY COLUMN content_in_use TINYINT(1), MODIFY COLUMN define_later TINYINT(1), MODIFY COLUMN is_sequential_order TINYINT(1), MODIFY COLUMN reflect_on_activity TINYINT(1), MODIFY COLUMN allow_contribute_tasks TINYINT(1), - MODIFY COLUMN is_monitor_verification_required TINYINT(1), - MODIFY COLUMN allow_contribute_tasks TINYINT(1); + MODIFY COLUMN is_monitor_verification_required TINYINT(1); ALTER TABLE tl_latask10_tasklist_item MODIFY COLUMN create_by_author TINYINT(1), MODIFY COLUMN is_required TINYINT(1), @@ -37,4 +36,4 @@ -- 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 +SET FOREIGN_KEY_CHECKS=1;