Index: lams_common/db/sql/updatescripts/alter_201_system_tool_user.sql =================================================================== diff -u --- lams_common/db/sql/updatescripts/alter_201_system_tool_user.sql (revision 0) +++ lams_common/db/sql/updatescripts/alter_201_system_tool_user.sql (revision 114ef93fa9475a4ba6be62fb11173a55a022691f) @@ -0,0 +1,16 @@ +-- Script to be run for LAMS 2.0.1 release, on LAMS 2.0 tables. +-- Change the url for the learner progress screen for grouping. +-- Add a flag to the user table to indicate that the user needs to change their password + +UPDATE lams_system_tool +SET learner_progress_url = "learning/grouping.do?method=viewGrouping&mode=teacher" +WHERE tool_display_name = "Grouping"; + +ALTER TABLE lams_user +ADD COLUMN change_password TINYINT DEFAULT 0; + +UPDATE lams_user +SET change_password = 0 +WHERE change_password is null; + +COMMIT;