Index: lams_tool_notebook/src/java/org/lamsfoundation/lams/tool/notebook/dbupdates/patch20161123.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_notebook/src/java/org/lamsfoundation/lams/tool/notebook/dbupdates/Attic/patch20161123.sql,v diff -u -r1.1.2.1 -r1.1.2.2 --- lams_tool_notebook/src/java/org/lamsfoundation/lams/tool/notebook/dbupdates/patch20161123.sql 23 Nov 2016 08:11:46 -0000 1.1.2.1 +++ lams_tool_notebook/src/java/org/lamsfoundation/lams/tool/notebook/dbupdates/patch20161123.sql 24 Nov 2016 00:56:50 -0000 1.1.2.2 @@ -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