Index: lams_common/db/sql/create_lams_db.sql =================================================================== diff -u -r7b8226a1234ecedac9073ffd3f6f7081104d3d6d -rc81b345a12784e7be6e9c9853acf75522fd88fc0 --- lams_common/db/sql/create_lams_db.sql (.../create_lams_db.sql) (revision 7b8226a1234ecedac9073ffd3f6f7081104d3d6d) +++ lams_common/db/sql/create_lams_db.sql (.../create_lams_db.sql) (revision c81b345a12784e7be6e9c9853acf75522fd88fc0) @@ -183,6 +183,7 @@ , number_of_groups INT(11) , learners_per_group INT(11) , staff_group_id BIGINT(20) DEFAULT 0 + , max_number_of_groups INT(3) , PRIMARY KEY (grouping_id) , INDEX (grouping_type_id) , CONSTRAINT FK_lams_learning_grouping_1 FOREIGN KEY (grouping_type_id) @@ -244,7 +245,6 @@ , create_date DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' , authentication_method_id BIGINT(20) NOT NULL DEFAULT 0 , workspace_id BIGINT(20) - , user_organisation_id BIGINT(20) NOT NULL DEFAULT 0 , base_organisation_id BIGINT(20) NOT NULL DEFAULT 0 , PRIMARY KEY (user_id) , INDEX (authentication_method_id) @@ -315,6 +315,7 @@ , gate_activity_level_id INT(11) DEFAULT 0 , gate_start_date_time DATETIME , gate_end_date_time DATETIME + , library_activity_ui_image VARCHAR(255) , PRIMARY KEY (activity_id) , INDEX (learning_library_id) , CONSTRAINT FK_lams_learning_activity_7 FOREIGN KEY (learning_library_id)