Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20180102.sql
===================================================================
diff -u
--- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20180102.sql (revision 0)
+++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20180102.sql (revision 82bf89723d09c2fce9fdb8ddb6e70db837123f6d)
@@ -0,0 +1,20 @@
+SET AUTOCOMMIT = 0;
+set FOREIGN_KEY_CHECKS = 0;
+
+-- LDEV-4421 Need an item column to support Share Resources comments
+-- No point having the unique index comment_ext_sig_user any longer
+-- as it would need to include external_secondary_id which could be null
+-- and two null values are always treated as distinct. Keeping an index on
+-- signature and main id for lookup efficiency.
+ALTER TABLE lams_comment_session
+ADD COLUMN external_secondary_id BIGINT(20);
+
+ALTER TABLE lams_comment_session
+DROP INDEX comment_ext_sig_user;
+
+ALTER TABLE lams_comment_session
+ADD INDEX comment_ext_sig (external_id ASC, external_signature ASC);
+
+COMMIT;
+SET AUTOCOMMIT = 1;
+set FOREIGN_KEY_CHECKS = 1;
Index: lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20171220.sql
===================================================================
diff -u
--- lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20171220.sql (revision 0)
+++ lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20171220.sql (revision 82bf89723d09c2fce9fdb8ddb6e70db837123f6d)
@@ -0,0 +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-2999 Rating Option for each Item
+ALTER TABLE tl_larsrc11_resource_item ADD COLUMN is_allow_comments TINYINT(1) 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
Index: lams_tool_larsrc/web/pages/authoring/parts/ratings.jsp
===================================================================
diff -u
--- lams_tool_larsrc/web/pages/authoring/parts/ratings.jsp (revision 0)
+++ lams_tool_larsrc/web/pages/authoring/parts/ratings.jsp (revision 82bf89723d09c2fce9fdb8ddb6e70db837123f6d)
@@ -0,0 +1,7 @@
+<%@ include file="/common/taglibs.jsp"%>
+
+
+
+
+
+
\ No newline at end of file
Index: lams_tool_larsrc/web/pages/monitoring/comments.jsp
===================================================================
diff -u
--- lams_tool_larsrc/web/pages/monitoring/comments.jsp (revision 0)
+++ lams_tool_larsrc/web/pages/monitoring/comments.jsp (revision 82bf89723d09c2fce9fdb8ddb6e70db837123f6d)
@@ -0,0 +1,31 @@
+
+
+
+<%@ include file="/common/taglibs.jsp"%>
+<%@ page import="org.lamsfoundation.lams.tool.rsrc.ResourceConstants"%>
+
+
+
+
+
+
+
+
+
+
+
+
+ ${requestScope.itemTitle}
+
+
+
+
+ ${requestScope.itemTitle}:
+
+
+
+
+
+
+
+