Index: lams_tool_chat/db/sql/updatescripts/updateTo20070227.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_chat/db/sql/updatescripts/Attic/updateTo20070227.sql,v
diff -u -r1.1 -r1.2
--- lams_tool_chat/db/sql/updatescripts/updateTo20070227.sql	27 Feb 2007 02:28:34 -0000	1.1
+++ lams_tool_chat/db/sql/updatescripts/updateTo20070227.sql	7 Mar 2007 23:22:07 -0000	1.2
@@ -1,8 +1,4 @@
 -- Update the Notebook tables to 20070227
 -- This is for the LAMS 2.0.1 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';
+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_forum/db/sql/updatescripts/updateTo20070227.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_forum/db/sql/updatescripts/Attic/updateTo20070227.sql,v
diff -u -r1.2 -r1.3
--- lams_tool_forum/db/sql/updatescripts/updateTo20070227.sql	7 Mar 2007 23:08:09 -0000	1.2
+++ lams_tool_forum/db/sql/updatescripts/updateTo20070227.sql	7 Mar 2007 23:22:06 -0000	1.3
@@ -1,8 +1,4 @@
 -- Update the Notebook tables to 20070227
 -- This is for the LAMS 2.0.1 release.
 
-UPDATE lams_tool
-set modified_date_time = now()
-, classpath_addition = 'lams-tool-lafrum11.jar'
-, context_file = '/org/lamsfoundation/lams/tool/forum/forumApplicationContext.xml'
-where tool_signature = 'lafrum11';
+UPDATE lams_tool set modified_date_time = now(), classpath_addition = 'lams-tool-lafrum11.jar', context_file = '/org/lamsfoundation/lams/tool/forum/forumApplicationContext.xml' where tool_signature = 'lafrum11';
Index: lams_tool_lamc/db/sql/updatescripts/updateTo20070214.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_lamc/db/sql/updatescripts/Attic/updateTo20070214.sql,v
diff -u -r1.3 -r1.4
--- lams_tool_lamc/db/sql/updatescripts/updateTo20070214.sql	7 Mar 2007 23:07:54 -0000	1.3
+++ lams_tool_lamc/db/sql/updatescripts/updateTo20070214.sql	7 Mar 2007 23:22:09 -0000	1.4
@@ -1,12 +1,6 @@
 -- Update the Multiple Choice tables from version 20061113 to 20070214
 -- This is for the LAMS 2.0.1 release.
 
-ALTER TABLE tl_lamc11_que_usr 
-CHANGE COLUMN username username VARCHAR(255),
-CHANGE COLUMN fullname fullname VARCHAR(255);
+ALTER TABLE tl_lamc11_que_usr CHANGE COLUMN username username VARCHAR(255), CHANGE COLUMN fullname fullname VARCHAR(255);
 
-UPDATE lams_tool
-set modified_date_time = now()
-, classpath_addition = 'lams-tool-lamc11.jar'
-, context_file = '/org/lamsfoundation/lams/tool/mc/mcApplicationContext.xml'
-where tool_signature = 'lamc11';
\ No newline at end of file
+UPDATE lams_tool set modified_date_time = now(), classpath_addition = 'lams-tool-lamc11.jar', context_file = '/org/lamsfoundation/lams/tool/mc/mcApplicationContext.xml' where tool_signature = 'lamc11';
\ No newline at end of file
Index: lams_tool_laqa/db/sql/updatescripts/updateTo20070214.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_laqa/db/sql/updatescripts/Attic/updateTo20070214.sql,v
diff -u -r1.3 -r1.4
--- lams_tool_laqa/db/sql/updatescripts/updateTo20070214.sql	7 Mar 2007 23:07:39 -0000	1.3
+++ lams_tool_laqa/db/sql/updatescripts/updateTo20070214.sql	7 Mar 2007 23:22:05 -0000	1.4
@@ -1,12 +1,6 @@
 -- Update the Q&A tables from version 20061113 to 20070214
 -- This is for the LAMS 2.0.1 release.
 
-ALTER TABLE tl_laqa11_que_usr 
-CHANGE COLUMN username username VARCHAR(255),
-CHANGE COLUMN fullname fullname VARCHAR(255);
+ALTER TABLE tl_laqa11_que_usr CHANGE COLUMN username username VARCHAR(255), CHANGE COLUMN fullname fullname VARCHAR(255);
 
-UPDATE lams_tool
-set modified_date_time = now()
-, classpath_addition = 'lams-tool-laqa11.jar'
-, context_file = '/org/lamsfoundation/lams/tool/qa/qaApplicationContext.xml'
-where tool_signature = 'laqa11';
+UPDATE lams_tool set modified_date_time = now(), classpath_addition = 'lams-tool-laqa11.jar', context_file = '/org/lamsfoundation/lams/tool/qa/qaApplicationContext.xml' where tool_signature = 'laqa11';
Index: lams_tool_larsrc/db/sql/updatescripts/updateTo20070227.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_larsrc/db/sql/updatescripts/Attic/updateTo20070227.sql,v
diff -u -r1.2 -r1.3
--- lams_tool_larsrc/db/sql/updatescripts/updateTo20070227.sql	7 Mar 2007 23:07:30 -0000	1.2
+++ lams_tool_larsrc/db/sql/updatescripts/updateTo20070227.sql	7 Mar 2007 23:22:07 -0000	1.3
@@ -1,8 +1,4 @@
 -- Update the Share Resource tables to 20070227
 -- This is for the LAMS 2.0.1 release.
 
-UPDATE lams_tool
-set modified_date_time = now()
-, classpath_addition = 'lams-tool-larsrc11.jar'
-, context_file = '/org/lamsfoundation/lams/tool/rsrc/rsrcApplicationContext.xml'
-where tool_signature = 'larsrc11';
+UPDATE lams_tool set modified_date_time = now(), classpath_addition = 'lams-tool-larsrc11.jar', context_file = '/org/lamsfoundation/lams/tool/rsrc/rsrcApplicationContext.xml' where tool_signature = 'larsrc11';
Index: lams_tool_nb/db/sql/updatescripts/updateTo20070214.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_nb/db/sql/updatescripts/Attic/updateTo20070214.sql,v
diff -u -r1.3 -r1.4
--- lams_tool_nb/db/sql/updatescripts/updateTo20070214.sql	7 Mar 2007 23:07:19 -0000	1.3
+++ lams_tool_nb/db/sql/updatescripts/updateTo20070214.sql	7 Mar 2007 23:22:08 -0000	1.4
@@ -1,12 +1,6 @@
 -- Update the Noticeboard tables to 20070214
 -- This is for the LAMS 2.0.1 release.
 
-ALTER TABLE tl_lanb11_user 
-CHANGE COLUMN username username VARCHAR(255),
-CHANGE COLUMN fullname fullname VARCHAR(255);
+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';
+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';
Index: lams_tool_notebook/db/sql/updatescripts/updateTo20070227.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_notebook/db/sql/updatescripts/Attic/updateTo20070227.sql,v
diff -u -r1.2 -r1.3
--- lams_tool_notebook/db/sql/updatescripts/updateTo20070227.sql	7 Mar 2007 23:07:09 -0000	1.2
+++ lams_tool_notebook/db/sql/updatescripts/updateTo20070227.sql	7 Mar 2007 23:22:06 -0000	1.3
@@ -1,8 +1,4 @@
 -- Update the Notebook tables to 20070227
 -- This is for the LAMS 2.0.1 release.
 
-UPDATE lams_tool
-set modified_date_time = now()
-, classpath_addition = 'lams-tool-lantbk11.jar'
-, context_file = '/org/lamsfoundation/lams/tool/notebook/notebookApplicationContext.xml'
-where tool_signature = 'lantbk11';
+UPDATE lams_tool set modified_date_time = now(), classpath_addition = 'lams-tool-lantbk11.jar', context_file = '/org/lamsfoundation/lams/tool/notebook/notebookApplicationContext.xml' where tool_signature = 'lantbk11';
Index: lams_tool_sbmt/db/sql/updatescripts/updateTo20070227.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_sbmt/db/sql/updatescripts/Attic/updateTo20070227.sql,v
diff -u -r1.2 -r1.3
--- lams_tool_sbmt/db/sql/updatescripts/updateTo20070227.sql	7 Mar 2007 23:06:56 -0000	1.2
+++ lams_tool_sbmt/db/sql/updatescripts/updateTo20070227.sql	7 Mar 2007 23:22:05 -0000	1.3
@@ -1,8 +1,4 @@
 -- Update the File Submit tables to 20070227
 -- This is for the LAMS 2.0.1 release.
 
-UPDATE lams_tool
-set modified_date_time = now()
-, classpath_addition = 'lams-tool-lasbmt11.jar'
-, context_file = '/org/lamsfoundation/lams/tool/sbmt/submitFilesApplicationContext.xml'
-where tool_signature = 'lasbmt11';
+UPDATE lams_tool set modified_date_time = now(), classpath_addition = 'lams-tool-lasbmt11.jar', context_file = '/org/lamsfoundation/lams/tool/sbmt/submitFilesApplicationContext.xml' where tool_signature = 'lasbmt11';
Index: lams_tool_scribe/db/sql/updatescripts/updateTo20070227.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_scribe/db/sql/updatescripts/Attic/updateTo20070227.sql,v
diff -u -r1.2 -r1.3
--- lams_tool_scribe/db/sql/updatescripts/updateTo20070227.sql	7 Mar 2007 23:06:45 -0000	1.2
+++ lams_tool_scribe/db/sql/updatescripts/updateTo20070227.sql	7 Mar 2007 23:22:09 -0000	1.3
@@ -1,8 +1,4 @@
 -- Update the Scribe tables to 20070227
 -- This is for the LAMS 2.0.1 release.
 
-UPDATE lams_tool
-set modified_date_time = now()
-, classpath_addition = 'lams-tool-lascrb11.jar'
-, context_file = '/org/lamsfoundation/lams/tool/scribe/scribeApplicationContext.xml'
-where tool_signature = 'lascrb11';
+UPDATE lams_tool set modified_date_time = now(), classpath_addition = 'lams-tool-lascrb11.jar', context_file = '/org/lamsfoundation/lams/tool/scribe/scribeApplicationContext.xml' where tool_signature = 'lascrb11';
Index: lams_tool_survey/db/sql/updatescripts/updateTo20070220.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_survey/db/sql/updatescripts/Attic/updateTo20070220.sql,v
diff -u -r1.3 -r1.4
--- lams_tool_survey/db/sql/updatescripts/updateTo20070220.sql	7 Mar 2007 23:06:32 -0000	1.3
+++ lams_tool_survey/db/sql/updatescripts/updateTo20070220.sql	7 Mar 2007 23:22:06 -0000	1.4
@@ -1,11 +1,6 @@
 -- Update the Survey tables from version 20061102 to 20070220
 -- This is for the LAMS 2.0.1 release.
 
-ALTER TABLE tl_lasurv11_answer 
-CHANGE COLUMN answer_text answer_text text;
+ALTER TABLE tl_lasurv11_answer CHANGE COLUMN answer_text answer_text text;
 
-UPDATE lams_tool
-set modified_date_time = now()
-, classpath_addition = 'lams-tool-lasurv11.jar'
-, context_file = '/org/lamsfoundation/lams/tool/survey/surveyApplicationContext.xml'
-where tool_signature = 'lasurv11';
+UPDATE lams_tool set modified_date_time = now(), classpath_addition = 'lams-tool-lasurv11.jar', context_file = '/org/lamsfoundation/lams/tool/survey/surveyApplicationContext.xml' where tool_signature = 'lasurv11';
Index: lams_tool_vote/db/sql/updatescripts/updateTo20070214.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_vote/db/sql/updatescripts/Attic/updateTo20070214.sql,v
diff -u -r1.3 -r1.4
--- lams_tool_vote/db/sql/updatescripts/updateTo20070214.sql	7 Mar 2007 23:06:19 -0000	1.3
+++ lams_tool_vote/db/sql/updatescripts/updateTo20070214.sql	7 Mar 2007 23:22:08 -0000	1.4
@@ -1,12 +1,6 @@
 -- Update the Vote tables to 20070214
 -- This is for the LAMS 2.0.1 release.
 
-ALTER TABLE tl_lavote11_usr 
-CHANGE COLUMN username username VARCHAR(255),
-CHANGE COLUMN fullname fullname VARCHAR(255);
+ALTER TABLE tl_lavote11_usr CHANGE COLUMN username username VARCHAR(255), CHANGE COLUMN fullname fullname VARCHAR(255);
 
-UPDATE lams_tool
-set modified_date_time = now()
-, classpath_addition = 'lams-tool-lavote11.jar'
-, context_file = '/org/lamsfoundation/lams/tool/vote/voteApplicationContext.xml'
-where tool_signature = 'lavote11';
+UPDATE lams_tool set modified_date_time = now(), classpath_addition = 'lams-tool-lavote11.jar', context_file = '/org/lamsfoundation/lams/tool/vote/voteApplicationContext.xml' where tool_signature = 'lavote11';