Index: lams_common/db/sql/updatescripts/alter_201_system_tool_user.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/sql/updatescripts/Attic/alter_201_system_tool_user.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ lams_common/db/sql/updatescripts/alter_201_system_tool_user.sql	7 Feb 2007 02:56:06 -0000	1.1
@@ -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;