Index: lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20130808.sql =================================================================== diff -u --- lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20130808.sql (revision 0) +++ lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20130808.sql (revision a3b81e85053355a310ddfbaeb3a8f1a8165769c1) @@ -0,0 +1,13 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; + +----------------------Put all sql statements below here------------------------- + +-- LKC-15 adding a constraint to the scratchie user table so no same user_id and session_id can be repetead +ALTER TABLE tl_lascrt11_user ADD UNIQUE INDEX(user_id, session_uid); + +----------------------Put all sql statements above here------------------------- + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; \ No newline at end of file Index: lams_tool_scratchie/web/pages/monitoring/editactivity.jsp =================================================================== diff -u -r6aaee4b2fe2caa08b0c63a0de11f05042d5a3e18 -ra3b81e85053355a310ddfbaeb3a8f1a8165769c1 --- lams_tool_scratchie/web/pages/monitoring/editactivity.jsp (.../editactivity.jsp) (revision 6aaee4b2fe2caa08b0c63a0de11f05042d5a3e18) +++ lams_tool_scratchie/web/pages/monitoring/editactivity.jsp (.../editactivity.jsp) (revision a3b81e85053355a310ddfbaeb3a8f1a8165769c1) @@ -29,15 +29,17 @@ -