Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20170512.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_common/src/java/org/lamsfoundation/lams/dbupdates/Attic/patch20170512.sql,v
diff -u -r1.1.2.1 -r1.1.2.2
--- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20170512.sql	17 May 2017 01:16:24 -0000	1.1.2.1
+++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20170512.sql	24 May 2017 11:35:42 -0000	1.1.2.2
@@ -39,35 +39,8 @@
 JOIN tmp_imagegallery_rating_sessionid tmp ON r.uid = tmp.rating_uid
 SET r.tool_session_id = tmp.session_id;
 
--- Update existing Peer Review
-DROP TABLE IF EXISTS tmp_peerreview_rating_sessionid;
-CREATE TEMPORARY TABLE tmp_peerreview_rating_sessionid AS
-SELECT r.uid rating_uid, prs.session_id session_id
-FROM lams_rating r
-JOIN lams_rating_criteria rc ON r.rating_criteria_id = rc.rating_criteria_id
-JOIN tl_laprev11_peerreview pr ON rc.tool_content_id = pr.content_id
-JOIN tl_laprev11_session prs ON pr.uid = prs.peerreview_uid
-JOIN tl_laprev11_user pru ON r.user_id = pru.user_id AND prs.uid = pru.session_uid;
+-- Update existing Peer Review done by the Peer Review tool
 
-UPDATE lams_rating r
-JOIN tmp_peerreview_rating_sessionid tmp ON r.uid = tmp.rating_uid
-SET r.tool_session_id = tmp.session_id;
-
-DROP TABLE tmp_peerreview_rating_sessionid;
-CREATE TEMPORARY TABLE tmp_peerreview_rating_sessionid AS
-SELECT r.uid rating_uid, prs.session_id session_id
-FROM lams_rating_comment r
-JOIN lams_rating_criteria rc ON r.rating_criteria_id = rc.rating_criteria_id
-JOIN tl_laprev11_peerreview pr ON rc.tool_content_id = pr.content_id
-JOIN tl_laprev11_session prs ON pr.uid = prs.peerreview_uid
-JOIN tl_laprev11_user pru ON r.user_id = pru.user_id AND prs.uid = pru.session_uid;
-
-UPDATE lams_rating_comment r
-JOIN tmp_peerreview_rating_sessionid tmp ON r.uid = tmp.rating_uid
-SET r.tool_session_id = tmp.session_id;
-
-DROP TABLE tmp_peerreview_rating_sessionid;
-
 -- Update existing QA
 DROP TABLE IF EXISTS tmp_qa_rating_sessionid;
 CREATE TEMPORARY TABLE tmp_qa_rating_sessionid AS
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `lams_tool_preview/src/java/org/lamsfoundation/lams/tool/peerreview/dbupdates/patch20170512.sql'.
Fisheye: No comparison available.  Pass `N' to diff?