Index: lams_tool_chat/db/sql/updatescripts/updateTo20070227.sql
===================================================================
diff -u -rba7fcf73decb86f3f83fa7cf5810b82f4d2a1f59 -r487f2c5d01d76b996ecb1b534220b5ae496cdba9
--- lams_tool_chat/db/sql/updatescripts/updateTo20070227.sql	(.../updateTo20070227.sql)	(revision ba7fcf73decb86f3f83fa7cf5810b82f4d2a1f59)
+++ lams_tool_chat/db/sql/updatescripts/updateTo20070227.sql	(.../updateTo20070227.sql)	(revision 487f2c5d01d76b996ecb1b534220b5ae496cdba9)
@@ -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
===================================================================
diff -u -r92fdad7c2e0da1caa6561334642360c2f54de2f9 -r487f2c5d01d76b996ecb1b534220b5ae496cdba9
--- lams_tool_forum/db/sql/updatescripts/updateTo20070227.sql	(.../updateTo20070227.sql)	(revision 92fdad7c2e0da1caa6561334642360c2f54de2f9)
+++ lams_tool_forum/db/sql/updatescripts/updateTo20070227.sql	(.../updateTo20070227.sql)	(revision 487f2c5d01d76b996ecb1b534220b5ae496cdba9)
@@ -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
===================================================================
diff -u -r92fdad7c2e0da1caa6561334642360c2f54de2f9 -r487f2c5d01d76b996ecb1b534220b5ae496cdba9
--- lams_tool_lamc/db/sql/updatescripts/updateTo20070214.sql	(.../updateTo20070214.sql)	(revision 92fdad7c2e0da1caa6561334642360c2f54de2f9)
+++ lams_tool_lamc/db/sql/updatescripts/updateTo20070214.sql	(.../updateTo20070214.sql)	(revision 487f2c5d01d76b996ecb1b534220b5ae496cdba9)
@@ -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
===================================================================
diff -u -r92fdad7c2e0da1caa6561334642360c2f54de2f9 -r487f2c5d01d76b996ecb1b534220b5ae496cdba9
--- lams_tool_laqa/db/sql/updatescripts/updateTo20070214.sql	(.../updateTo20070214.sql)	(revision 92fdad7c2e0da1caa6561334642360c2f54de2f9)
+++ lams_tool_laqa/db/sql/updatescripts/updateTo20070214.sql	(.../updateTo20070214.sql)	(revision 487f2c5d01d76b996ecb1b534220b5ae496cdba9)
@@ -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
===================================================================
diff -u -r92fdad7c2e0da1caa6561334642360c2f54de2f9 -r487f2c5d01d76b996ecb1b534220b5ae496cdba9
--- lams_tool_larsrc/db/sql/updatescripts/updateTo20070227.sql	(.../updateTo20070227.sql)	(revision 92fdad7c2e0da1caa6561334642360c2f54de2f9)
+++ lams_tool_larsrc/db/sql/updatescripts/updateTo20070227.sql	(.../updateTo20070227.sql)	(revision 487f2c5d01d76b996ecb1b534220b5ae496cdba9)
@@ -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
===================================================================
diff -u -r92fdad7c2e0da1caa6561334642360c2f54de2f9 -r487f2c5d01d76b996ecb1b534220b5ae496cdba9
--- lams_tool_nb/db/sql/updatescripts/updateTo20070214.sql	(.../updateTo20070214.sql)	(revision 92fdad7c2e0da1caa6561334642360c2f54de2f9)
+++ lams_tool_nb/db/sql/updatescripts/updateTo20070214.sql	(.../updateTo20070214.sql)	(revision 487f2c5d01d76b996ecb1b534220b5ae496cdba9)
@@ -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
===================================================================
diff -u -r92fdad7c2e0da1caa6561334642360c2f54de2f9 -r487f2c5d01d76b996ecb1b534220b5ae496cdba9
--- lams_tool_notebook/db/sql/updatescripts/updateTo20070227.sql	(.../updateTo20070227.sql)	(revision 92fdad7c2e0da1caa6561334642360c2f54de2f9)
+++ lams_tool_notebook/db/sql/updatescripts/updateTo20070227.sql	(.../updateTo20070227.sql)	(revision 487f2c5d01d76b996ecb1b534220b5ae496cdba9)
@@ -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
===================================================================
diff -u -r92fdad7c2e0da1caa6561334642360c2f54de2f9 -r487f2c5d01d76b996ecb1b534220b5ae496cdba9
--- lams_tool_sbmt/db/sql/updatescripts/updateTo20070227.sql	(.../updateTo20070227.sql)	(revision 92fdad7c2e0da1caa6561334642360c2f54de2f9)
+++ lams_tool_sbmt/db/sql/updatescripts/updateTo20070227.sql	(.../updateTo20070227.sql)	(revision 487f2c5d01d76b996ecb1b534220b5ae496cdba9)
@@ -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
===================================================================
diff -u -r92fdad7c2e0da1caa6561334642360c2f54de2f9 -r487f2c5d01d76b996ecb1b534220b5ae496cdba9
--- lams_tool_scribe/db/sql/updatescripts/updateTo20070227.sql	(.../updateTo20070227.sql)	(revision 92fdad7c2e0da1caa6561334642360c2f54de2f9)
+++ lams_tool_scribe/db/sql/updatescripts/updateTo20070227.sql	(.../updateTo20070227.sql)	(revision 487f2c5d01d76b996ecb1b534220b5ae496cdba9)
@@ -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
===================================================================
diff -u -r92fdad7c2e0da1caa6561334642360c2f54de2f9 -r487f2c5d01d76b996ecb1b534220b5ae496cdba9
--- lams_tool_survey/db/sql/updatescripts/updateTo20070220.sql	(.../updateTo20070220.sql)	(revision 92fdad7c2e0da1caa6561334642360c2f54de2f9)
+++ lams_tool_survey/db/sql/updatescripts/updateTo20070220.sql	(.../updateTo20070220.sql)	(revision 487f2c5d01d76b996ecb1b534220b5ae496cdba9)
@@ -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
===================================================================
diff -u -r92fdad7c2e0da1caa6561334642360c2f54de2f9 -r487f2c5d01d76b996ecb1b534220b5ae496cdba9
--- lams_tool_vote/db/sql/updatescripts/updateTo20070214.sql	(.../updateTo20070214.sql)	(revision 92fdad7c2e0da1caa6561334642360c2f54de2f9)
+++ lams_tool_vote/db/sql/updatescripts/updateTo20070214.sql	(.../updateTo20070214.sql)	(revision 487f2c5d01d76b996ecb1b534220b5ae496cdba9)
@@ -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';