Index: lams_tool_vote/db/sql/updatescripts/updateTo20080326.sql =================================================================== diff -u -r2e9dc3798ab786dc455c429b78330b253ce8fe49 -rc51e891385bdc541b9351c8dd36e1cdaab2ca1a0 --- lams_tool_vote/db/sql/updatescripts/updateTo20080326.sql (.../updateTo20080326.sql) (revision 2e9dc3798ab786dc455c429b78330b253ce8fe49) +++ lams_tool_vote/db/sql/updatescripts/updateTo20080326.sql (.../updateTo20080326.sql) (revision c51e891385bdc541b9351c8dd36e1cdaab2ca1a0) @@ -1,20 +1,13 @@ -- 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 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 lams_tool set supports_outputs = 1 where tool_signature = "lavote11"; -ALTER TABLE tl_lavote11_content -ADD COLUMN show_results TINYINT(1) NOT NULL DEFAULT 1; +ALTER TABLE tl_lavote11_content ADD COLUMN show_results TINYINT(1) NOT NULL DEFAULT 1; UPDATE tl_lavote11_content set show_results = 1;