Index: lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/patch20140407.sql =================================================================== diff -u --- lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/patch20140407.sql (revision 0) +++ lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/patch20140407.sql (revision 4a4224923670122d3a30c1e68c0f7679553ad7b5) @@ -0,0 +1,17 @@ +-- 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-3147 Simplify tools: get rid of instructions tab, define in monitor and offline activity options +ALTER TABLE tl_lasbmt11_content MODIFY title varchar(255) not null; +ALTER TABLE tl_lasbmt11_content MODIFY reflect_instructions text; + +UPDATE lams_tool SET tool_version='20140407' WHERE tool_signature='lasbmt11'; + +----------------------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 Index: lams_tool_sbmt/web/authoring/advance.jsp =================================================================== diff -u -rbf1c66f82afbc349f5702f29a0c6ab6ff9add34a -r4a4224923670122d3a30c1e68c0f7679553ad7b5 --- lams_tool_sbmt/web/authoring/advance.jsp (.../advance.jsp) (revision bf1c66f82afbc349f5702f29a0c6ab6ff9add34a) +++ lams_tool_sbmt/web/authoring/advance.jsp (.../advance.jsp) (revision 4a4224923670122d3a30c1e68c0f7679553ad7b5) @@ -57,7 +57,7 @@