Index: lams_common/db/sql/updatescripts/alter_21_editonfly.sql =================================================================== RCS file: /usr/local/cvsroot/lams_common/db/sql/updatescripts/Attic/alter_21_editonfly.sql,v diff -u -r1.1.2.1 -r1.1.2.2 --- lams_common/db/sql/updatescripts/alter_21_editonfly.sql 20 Feb 2007 06:17:02 -0000 1.1.2.1 +++ lams_common/db/sql/updatescripts/alter_21_editonfly.sql 20 Feb 2007 06:43:15 -0000 1.1.2.2 @@ -10,3 +10,7 @@ alter table lams_lesson ADD COLUMN locked_for_edit TINYINT DEFAULT 0 ,ADD COLUMN version INTEGER DEFAULT 1; + +UPDATE lams_learning_activity +SET read_only = 1 +WHERE learning_design_id IN (SELECT learning_design_id FROM lams_learning_design WHERE copy_type_id IN (2,3))