Index: lams_tool_chat/db/sql/updatescripts/updateTo20070315.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_chat/db/sql/updatescripts/Attic/updateTo20070315.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ lams_tool_chat/db/sql/updatescripts/updateTo20070315.sql	22 Mar 2007 05:12:24 -0000	1.1
@@ -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
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_nb/db/sql/updatescripts/Attic/updateTo20070315.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ lams_tool_nb/db/sql/updatescripts/updateTo20070315.sql	22 Mar 2007 05:12:25 -0000	1.1
@@ -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';