Index: lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20170101.sql =================================================================== diff -u -r5df0d44b0e94fca808f5d4f70fc01c0c428c3dfe -rd454d435fa7778d1d4a2be6c1cb0ec8d54fc6d06 --- lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20170101.sql (.../patch20170101.sql) (revision 5df0d44b0e94fca808f5d4f70fc01c0c428c3dfe) +++ lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20170101.sql (.../patch20170101.sql) (revision d454d435fa7778d1d4a2be6c1cb0ec8d54fc6d06) @@ -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;