Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0013_updateFrom21.sql =================================================================== diff -u -r8386a3fecd9c7baf6ed69d499016dedd8a83eac6 -refb2ec520c430c4361de9ce26492bc18de4eba2f --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0013_updateFrom21.sql (.../patch0013_updateFrom21.sql) (revision 8386a3fecd9c7baf6ed69d499016dedd8a83eac6) +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0013_updateFrom21.sql (.../patch0013_updateFrom21.sql) (revision efb2ec520c430c4361de9ce26492bc18de4eba2f) @@ -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;