Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0013_updateFrom21.sql =================================================================== diff -u -r084c57ccf6900aab12ece57c600182485a999aa6 -ra88f2279fe15ee02e37ffecc5a0778ec6c4c8485 --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0013_updateFrom21.sql (.../patch0013_updateFrom21.sql) (revision 084c57ccf6900aab12ece57c600182485a999aa6) +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0013_updateFrom21.sql (.../patch0013_updateFrom21.sql) (revision a88f2279fe15ee02e37ffecc5a0778ec6c4c8485) @@ -60,6 +60,16 @@ -- LDEV-1871 Creating extra column in lams_tool table for tool adapters ALTER TABLE lams_tool ADD COLUMN ext_lms_id VARCHAR(255); +-- LDEV-1581 Add a collumn to the lams_grouping table for learner's choice grouping +ALTER TABLE lams_grouping ADD COLUMN equal_number_of_learners_per_group TINYINT DEFAULT 0; + + + +-- Update the configuration table to have the current version of LAMS +UPDATE lams_configuration SET config_value='2.2' WHERE config_key='Version'; +UPDATE lams_configuration SET config_value='2.2.0.200811310000' WHERE config_key='AuthoringClientVersion' OR config_key='MonitorClientVersion' OR config_key='LearnerClientVersion' OR config_key='ServerVersionNumber'; +UPDATE lams_configuration SET config_value='2008-11-31' WHERE config_key='DictionaryDateCreated'; + ----------------------Put all sql statements above here------------------------- -- If there were no errors, commit and restore autocommit to on