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