Index: lams_tool_chat/db/sql/updatescripts/updateTo20070315.sql
===================================================================
diff -u
--- lams_tool_chat/db/sql/updatescripts/updateTo20070315.sql	(revision 0)
+++ lams_tool_chat/db/sql/updatescripts/updateTo20070315.sql	(revision 5dab5904038c73f8cb902dda9c77bf9483c08279)
@@ -0,0 +1,4 @@
+-- Update the Notebook tables to 20070315
+-- This is for the LAMS 2.0.2 release.
+
+UPDATE lams_tool set modified_date_time = now(), classpath_addition = 'lams-tool-lachat11.jar', context_file = '/org/lamsfoundation/lams/tool/chat/chatApplicationContext.xml' where tool_signature = 'lachat11';
Index: lams_tool_nb/db/sql/updatescripts/updateTo20070315.sql
===================================================================
diff -u
--- lams_tool_nb/db/sql/updatescripts/updateTo20070315.sql	(revision 0)
+++ lams_tool_nb/db/sql/updatescripts/updateTo20070315.sql	(revision 5dab5904038c73f8cb902dda9c77bf9483c08279)
@@ -0,0 +1,6 @@
+-- Update the Noticeboard tables to 20070315
+-- This is for the LAMS 2.0.2 release.
+
+ALTER TABLE tl_lanb11_user CHANGE COLUMN username username VARCHAR(255), CHANGE COLUMN fullname fullname VARCHAR(255);
+
+UPDATE lams_tool set modified_date_time = now(), classpath_addition = 'lams-tool-lanb11.jar', context_file = '/org/lamsfoundation/lams/tool/noticeboard/applicationContext.xml' where tool_signature = 'lanb11';