Index: lams_tool_laqa/db/sql/updatescripts/updateTo20080108.sql =================================================================== diff -u --- lams_tool_laqa/db/sql/updatescripts/updateTo20080108.sql (revision 0) +++ lams_tool_laqa/db/sql/updatescripts/updateTo20080108.sql (revision a3c6639c17b068cf013cbfe81e49e48ff5c650a4) @@ -0,0 +1,16 @@ +-- Update the Q&A tables to version 20080108 +-- This is for the LAMS 2.1 release. + +UPDATE tl_laqa11_content +SET lockWhenFinished = 0 +WHERE qa_content_id = ( + SELECT default_tool_content_id + FROM lams_tool + WHERE tool_signature = 'laqa11' +); + +UPDATE lams_tool SET modified_date_time = NOW() WHERE tool_signature = 'laqa11'; + +-- update the tool version - special code that should only be executed if the upgrade is being done manually. +-- if it is being done via the tool deployer then it will update the version automatically. +UPDATE lams_tool SET tool_version = "20080108" WHERE tool_signature = "laqa11"; Index: lams_tool_vote/db/sql/updatescripts/updateTo20080108.sql =================================================================== diff -u --- lams_tool_vote/db/sql/updatescripts/updateTo20080108.sql (revision 0) +++ lams_tool_vote/db/sql/updatescripts/updateTo20080108.sql (revision a3c6639c17b068cf013cbfe81e49e48ff5c650a4) @@ -0,0 +1,16 @@ +-- Update the Vote tables to version 20080108 +-- This is for the LAMS 2.1 release. + +UPDATE tl_lavote11_content +SET lock_on_finish = 0 +WHERE content_id = ( + SELECT default_tool_content_id + FROM lams_tool + WHERE tool_signature = 'lavote11' +); + +UPDATE lams_tool SET modified_date_time = NOW() WHERE tool_signature = 'lavote11'; + +-- update the tool version - special code that should only be executed if the upgrade is being done manually. +-- if it is being done via the tool deployer then it will update the version automatically. +UPDATE lams_tool SET tool_version = "20080108" WHERE tool_signature = "lavote11";