-- 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 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;

UPDATE tl_lavote11_content set show_results = 1;

-- 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 = "20080326" WHERE tool_signature = "lavote11";