Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0013_updateFrom21.sql =================================================================== RCS file: /usr/local/cvsroot/lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0013_updateFrom21.sql,v diff -u -r1.5 -r1.6 --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0013_updateFrom21.sql 29 Oct 2008 05:35:13 -0000 1.5 +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0013_updateFrom21.sql 6 Nov 2008 23:31:42 -0000 1.6 @@ -37,10 +37,8 @@ )TYPE=InnoDB; -- LDEV1929 - Updated script for lesson creation with presence -------------- -CREATE TABLE lams_lesson ( - learner_presence_avail TINYINT(1) DEFAULT 0 - , learner_im_avail TINYINT(1) DEFAULT 0 -)TYPE=InnoDB; +ALTER TABLE lams_lesson ADD COLUMN learner_presence_avail TINYINT(1) DEFAULT 0; +ALTER TABLE lams_lesson ADD COLUMN learner_im_avail TINYINT(1) DEFAULT 0; -- LDEV-1299 - Instead of mapping the conditions that open a gate to fictional sequences, there is only a boolean value ------------- ALTER TABLE lams_branch_activity_entry ADD COLUMN open_gate TINYINT;