Index: lams_tool_vote/src/java/org/lamsfoundation/lams/tool/vote/dbupdates/patch20171023.sql =================================================================== diff -u --- lams_tool_vote/src/java/org/lamsfoundation/lams/tool/vote/dbupdates/patch20171023.sql (revision 0) +++ lams_tool_vote/src/java/org/lamsfoundation/lams/tool/vote/dbupdates/patch20171023.sql (revision e4ee7783c9375d25ac80b9766a8f451604d440c4) @@ -0,0 +1,21 @@ +-- 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-4440 Change tool access URLs after migration to Spring MVC +UPDATE lams_tool SET + author_url = 'tool/lavote11/authoring/start.do', + learner_url = 'tool/lavote11/learning/start.do?mode=learner', + monitor_url = 'tool/lavote11/monitoring/start.do', + pedagogical_planner_url = 'tool/lavote11/pedagogicalPlanner/initPedagogicalPlannerForm.do' +WHERE tool_signature = 'lavote11'; + +UPDATE lams_tool SET tool_version='20171023' WHERE tool_signature='lavote11'; + +----------------------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