Index: lams_tool_notebook/src/java/org/lamsfoundation/lams/tool/notebook/dbupdates/patch20161123.sql =================================================================== diff -u -rdba506c6b1663eba922793a44b6ad5726f2931d1 -r96067c5bc1f2e387dfde99e6c7ef256018b3b7f1 --- lams_tool_notebook/src/java/org/lamsfoundation/lams/tool/notebook/dbupdates/patch20161123.sql (.../patch20161123.sql) (revision dba506c6b1663eba922793a44b6ad5726f2931d1) +++ lams_tool_notebook/src/java/org/lamsfoundation/lams/tool/notebook/dbupdates/patch20161123.sql (.../patch20161123.sql) (revision 96067c5bc1f2e387dfde99e6c7ef256018b3b7f1) @@ -1,14 +1,14 @@ --- Turn off autocommit, so nothing is committed if there is an error -SET AUTOCOMMIT = 0; -SET FOREIGN_KEY_CHECKS=0; -----------------------Put all sql statements below here------------------------- - --- LDEV-4063 Force student response -ALTER TABLE tl_lantbk11_notebook ADD COLUMN force_response bit DEFAULT 0; - -----------------------Put all sql statements above here------------------------- - --- If there were no errors, commit and restore autocommit to on -COMMIT; -SET AUTOCOMMIT = 1; +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; +----------------------Put all sql statements below here------------------------- + +-- LDEV-4063 Force student response +ALTER TABLE tl_lantbk11_notebook ADD COLUMN force_response bit DEFAULT 0; + +----------------------Put all sql statements above here------------------------- + +-- 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