Index: lams_common/db/model/lams_11.clay
===================================================================
diff -u -r9270acde555c5e9f63cd6b49014ea186391b9c0b -r6fdc01729bb7cb4fae5d054af8d5917c9099d7d4
--- lams_common/db/model/lams_11.clay (.../lams_11.clay) (revision 9270acde555c5e9f63cd6b49014ea186391b9c0b)
+++ lams_common/db/model/lams_11.clay (.../lams_11.clay) (revision 6fdc01729bb7cb4fae5d054af8d5917c9099d7d4)
@@ -173,7 +173,7 @@
-
+
@@ -345,8 +345,8 @@
-
+
@@ -419,6 +419,83 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -461,6 +538,27 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -573,8 +671,8 @@
-
+
@@ -599,8 +697,8 @@
-
+
@@ -612,8 +710,8 @@
-
+
@@ -745,13 +843,6 @@
-
-
-
-
-
-
-
@@ -772,94 +863,15 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
@@ -871,8 +883,8 @@
-
+
@@ -884,8 +896,8 @@
-
+
@@ -927,8 +939,8 @@
-
+
@@ -979,8 +991,8 @@
-
+
@@ -1003,13 +1015,6 @@
-
-
-
-
-
-
-
@@ -1022,76 +1027,9 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
@@ -1139,166 +1077,6 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
@@ -2322,7 +2100,7 @@
-
+
@@ -2361,7 +2139,7 @@
-
+
@@ -2376,6 +2154,50 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -2405,8 +2227,8 @@
-
+
@@ -2468,13 +2290,6 @@
-
-
-
-
-
-
-
@@ -2743,8 +2558,8 @@
-
+
@@ -2756,8 +2571,8 @@
-
+
Index: lams_common/db/model/learning_design.clay
===================================================================
diff -u -r6620d09a078468249f19939b0bae1bf0c50ca7da -r6fdc01729bb7cb4fae5d054af8d5917c9099d7d4
--- lams_common/db/model/learning_design.clay (.../learning_design.clay) (revision 6620d09a078468249f19939b0bae1bf0c50ca7da)
+++ lams_common/db/model/learning_design.clay (.../learning_design.clay) (revision 6fdc01729bb7cb4fae5d054af8d5917c9099d7d4)
@@ -181,7 +181,7 @@
-
+
Index: lams_common/db/sql/create_lams_11_tables.sql
===================================================================
diff -u -r6620d09a078468249f19939b0bae1bf0c50ca7da -r6fdc01729bb7cb4fae5d054af8d5917c9099d7d4
--- lams_common/db/sql/create_lams_11_tables.sql (.../create_lams_11_tables.sql) (revision 6620d09a078468249f19939b0bae1bf0c50ca7da)
+++ lams_common/db/sql/create_lams_11_tables.sql (.../create_lams_11_tables.sql) (revision 6fdc01729bb7cb4fae5d054af8d5917c9099d7d4)
@@ -1,7 +1,11 @@
# Connection: ROOT LOCAL
# Host: localhost
-# Saved: 2004-11-23 15:13:48
+# Saved: 2004-11-26 11:10:27
#
+# Connection: ROOT LOCAL
+# Host: localhost
+# Saved: 2004-11-26 11:09:02
+#
CREATE TABLE lams_gate_activity_level (
gate_activity_level_id INT(11) NOT NULL DEFAULT 0
, description VARCHAR(128) NOT NULL
@@ -45,6 +49,34 @@
)TYPE=InnoDB;
CREATE INDEX gname ON lams_role (name ASC);
+CREATE TABLE lams_tool_content (
+ tool_content_id BIGINT(20) NOT NULL
+ , tool_content_key BIGINT(20) NOT NULL
+ , PRIMARY KEY (tool_content_id)
+)TYPE=InnoDB;
+
+CREATE TABLE lams_tool (
+ tool_id BIGINT(20) NOT NULL
+ , learner_url TEXT NOT NULL
+ , supports_grouping_flag TINYINT(1) NOT NULL DEFAULT 0
+ , author_url TEXT
+ , supports_define_later_flag TINYINT(1) NOT NULL DEFAULT 0
+ , define_later_url TEXT
+ , PRIMARY KEY (tool_id)
+)TYPE=InnoDB;
+
+CREATE TABLE lams_tool_session_state (
+ tool_session_state_id INT(3) NOT NULL
+ , description VARCHAR(255) NOT NULL
+ , PRIMARY KEY (tool_session_state_id)
+)TYPE=InnoDB;
+
+CREATE TABLE lams_user_tool_session_state (
+ user_tool_session_state_id INT(3) NOT NULL
+ , description VARCHAR(255) NOT NULL
+ , PRIMARY KEY (user_tool_session_state_id)
+)TYPE=InnoDB;
+
CREATE TABLE lams_authentication_method_type (
authentication_method_type_id INT(3) NOT NULL DEFAULT 0
, description VARCHAR(64) NOT NULL
@@ -113,16 +145,16 @@
CREATE UNIQUE INDEX UQ_lams_user_login ON lams_user (login ASC);
CREATE INDEX login ON lams_user (login ASC);
+
CREATE TABLE lams_learning_design (
learning_design_id BIGINT(20) NOT NULL DEFAULT 0
, id INT(11)
, description TEXT
, title VARCHAR(255)
, first_activity_id BIGINT(20)
, max_id INT(11)
- , object_type VARCHAR(255)
- , valid_design_flag TINYINT(4)
- , read_only_flag TINYINT(4)
+ , valid_design_flag TINYINT(4) NOT NULL
+ , read_only_flag TINYINT(4) NOT NULL
, date_read_only DATETIME
, read_access BIGINT(20)
, write_access BIGINT(20)
@@ -144,39 +176,31 @@
)TYPE=InnoDB;
CREATE INDEX idx_design_first_act ON lams_learning_design (first_activity_id ASC);
-CREATE TABLE lams_learning_grouping (
- learning_grouping_id BIGINT(20) NOT NULL DEFAULT 0
+
+
+
+CREATE TABLE lams_grouping (
+ grouping_id BIGINT(20) NOT NULL DEFAULT 0
, grouping_type_id INT(11) NOT NULL DEFAULT 0
, number_of_groups INT(11)
, learners_per_group INT(11)
- , PRIMARY KEY (learning_grouping_id)
+ , staff_group_id BIGINT(20) DEFAULT 0
+ , PRIMARY KEY (grouping_id)
, INDEX (grouping_type_id)
, CONSTRAINT FK_lams_learning_grouping_1 FOREIGN KEY (grouping_type_id)
REFERENCES lams_grouping_type (grouping_type_id) ON DELETE NO ACTION ON UPDATE NO ACTION
)TYPE=InnoDB;
-CREATE TABLE lams_organisation (
- organisation_id BIGINT(20) NOT NULL DEFAULT 0
- , name VARCHAR(250)
- , description VARCHAR(250)
- , parent_organisation_id BIGINT(20)
- , organisation_type_id INT(3) NOT NULL DEFAULT 0
- , create_date DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00'
- , workspace_id BIGINT(20)
- , PRIMARY KEY (organisation_id)
- , INDEX (organisation_type_id)
- , CONSTRAINT FK_lams_organisation_1 FOREIGN KEY (organisation_type_id)
- REFERENCES lams_organisation_type (organisation_type_id) ON DELETE NO ACTION ON UPDATE NO ACTION
- , INDEX (workspace_id)
- , CONSTRAINT FK_lams_organisation_2 FOREIGN KEY (workspace_id)
- REFERENCES lams_workspace (workspace_id) ON DELETE NO ACTION ON UPDATE NO ACTION
- , INDEX (parent_organisation_id)
- , CONSTRAINT FK_lams_organisation_3 FOREIGN KEY (parent_organisation_id)
- REFERENCES lams_organisation (organisation_id) ON DELETE NO ACTION ON UPDATE NO ACTION
+CREATE TABLE lams_group (
+ group_id BIGINT(20) NOT NULL DEFAULT 0
+ , grouping_id BIGINT(20) NOT NULL DEFAULT 0
+ , order_id INT(6) NOT NULL DEFAULT 1
+ , PRIMARY KEY (group_id)
+ , INDEX (grouping_id)
+ , CONSTRAINT FK_lams_learning_group_1 FOREIGN KEY (grouping_id)
+ REFERENCES lams_grouping (grouping_id) ON DELETE NO ACTION ON UPDATE NO ACTION
)TYPE=InnoDB;
-
-
CREATE TABLE lams_learning_activity (
activity_id BIGINT(20) NOT NULL DEFAULT 0
, id INT(11)
@@ -186,13 +210,20 @@
, ycoord INT(11)
, parent_activity_id BIGINT(20)
, learning_activity_type_id INT(11) NOT NULL DEFAULT 0
- , learning_grouping_id BIGINT(20)
+ , grouping_id BIGINT(20)
, order_id INT(11)
, define_later_flag TINYINT(4) NOT NULL DEFAULT 0
, learning_design_id BIGINT(20) DEFAULT 0
, learning_library_id BIGINT(20) DEFAULT 0
, create_date_time DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00'
, offline_instructions TEXT
+ , max_number_of_options INT(5)
+ , min_number_of_options INT(5)
+ , tool_id BIGINT(20)
+ , tool_content_id BIGINT(20)
+ , gate_activity_level_id INT(11) DEFAULT 0
+ , gate_start_date_time DATETIME
+ , gate_end_date_time DATETIME
, PRIMARY KEY (activity_id)
, INDEX (learning_library_id)
, CONSTRAINT FK_lams_learning_activity_7 FOREIGN KEY (learning_library_id)
@@ -206,11 +237,42 @@
, INDEX (learning_activity_type_id)
, CONSTRAINT FK_learning_activity_3 FOREIGN KEY (learning_activity_type_id)
REFERENCES lams_learning_activity_type (learning_activity_type_id) ON DELETE NO ACTION ON UPDATE NO ACTION
- , INDEX (learning_grouping_id)
- , CONSTRAINT FK_learning_activity_6 FOREIGN KEY (learning_grouping_id)
- REFERENCES lams_learning_grouping (learning_grouping_id) ON DELETE NO ACTION ON UPDATE NO ACTION
+ , INDEX (grouping_id)
+ , CONSTRAINT FK_learning_activity_6 FOREIGN KEY (grouping_id)
+ REFERENCES lams_grouping (grouping_id) ON DELETE NO ACTION ON UPDATE NO ACTION
+ , INDEX (tool_id)
+ , CONSTRAINT FK_lams_learning_activity_8 FOREIGN KEY (tool_id)
+ REFERENCES lams_tool (tool_id)
+ , INDEX (tool_content_id)
+ , CONSTRAINT FK_lams_learning_activity_9 FOREIGN KEY (tool_content_id)
+ REFERENCES lams_tool_content (tool_content_id)
+ , INDEX (gate_activity_level_id)
+ , CONSTRAINT FK_lams_learning_activity_10 FOREIGN KEY (gate_activity_level_id)
+ REFERENCES lams_gate_activity_level (gate_activity_level_id)
)TYPE=InnoDB;
+CREATE TABLE lams_organisation (
+ organisation_id BIGINT(20) NOT NULL DEFAULT 0
+ , name VARCHAR(250)
+ , description VARCHAR(250)
+ , parent_organisation_id BIGINT(20)
+ , organisation_type_id INT(3) NOT NULL DEFAULT 0
+ , create_date DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00'
+ , workspace_id BIGINT(20)
+ , PRIMARY KEY (organisation_id)
+ , INDEX (organisation_type_id)
+ , CONSTRAINT FK_lams_organisation_1 FOREIGN KEY (organisation_type_id)
+ REFERENCES lams_organisation_type (organisation_type_id) ON DELETE NO ACTION ON UPDATE NO ACTION
+ , INDEX (workspace_id)
+ , CONSTRAINT FK_lams_organisation_2 FOREIGN KEY (workspace_id)
+ REFERENCES lams_workspace (workspace_id) ON DELETE NO ACTION ON UPDATE NO ACTION
+ , INDEX (parent_organisation_id)
+ , CONSTRAINT FK_lams_organisation_3 FOREIGN KEY (parent_organisation_id)
+ REFERENCES lams_organisation (organisation_id) ON DELETE NO ACTION ON UPDATE NO ACTION
+)TYPE=InnoDB;
+
+
+
CREATE TABLE lams_user_organisation (
user_organisation_id BIGINT(20) NOT NULL DEFAULT 0
, organisation_id BIGINT(20) NOT NULL DEFAULT 0
@@ -224,63 +286,48 @@
REFERENCES lams_organisation (organisation_id) ON DELETE NO ACTION ON UPDATE NO ACTION
)TYPE=InnoDB;
-CREATE TABLE lams_learning_gate_activity (
- activity_id BIGINT(20) NOT NULL DEFAULT 0
- , start_date_time DATETIME
- , end_date_time DATETIME
- , gate_activity_level_id INT(11) NOT NULL DEFAULT 0
- , PRIMARY KEY (activity_id)
- , INDEX (gate_activity_level_id)
- , CONSTRAINT FK_lams_learning_gate_activity_2 FOREIGN KEY (gate_activity_level_id)
- REFERENCES lams_gate_activity_level (gate_activity_level_id) ON DELETE NO ACTION ON UPDATE NO ACTION
- , INDEX (activity_id)
- , CONSTRAINT FK_lams_learning_gate_activity_1 FOREIGN KEY (activity_id)
- REFERENCES lams_learning_activity (activity_id) ON DELETE NO ACTION ON UPDATE NO ACTION
+CREATE TABLE lams_lesson (
+ lesson_id BIGINT(20) NOT NULL
+ , learning_design_id BIGINT(20) NOT NULL DEFAULT 0
+ , user_id BIGINT(20) NOT NULL DEFAULT 0
+ , create_date_time DATETIME NOT NULL
+ , PRIMARY KEY (lesson_id)
+ , INDEX (learning_design_id)
+ , CONSTRAINT FK_lams_lesson_1_1 FOREIGN KEY (learning_design_id)
+ REFERENCES lams_learning_design (learning_design_id)
+ , INDEX (user_id)
+ , CONSTRAINT FK_lams_lesson_2 FOREIGN KEY (user_id)
+ REFERENCES lams_user (user_id)
)TYPE=InnoDB;
-CREATE TABLE lams_learning_group (
- learning_group_id BIGINT(20) NOT NULL DEFAULT 0
- , learning_grouping_id BIGINT(20) NOT NULL DEFAULT 0
- , PRIMARY KEY (learning_group_id)
- , INDEX (learning_grouping_id)
- , CONSTRAINT FK_lams_learning_group_1 FOREIGN KEY (learning_grouping_id)
- REFERENCES lams_learning_grouping (learning_grouping_id) ON DELETE NO ACTION ON UPDATE NO ACTION
+CREATE TABLE lams_learner_progress (
+ user_id BIGINT(20) NOT NULL DEFAULT 0
+ , lesson_id BIGINT(20) NOT NULL
+ , learner_progress_id BIGINT(20) NOT NULL
+ , PRIMARY KEY (learner_progress_id)
+ , INDEX (user_id)
+ , CONSTRAINT FK_lams_learner_progress_1 FOREIGN KEY (user_id)
+ REFERENCES lams_user (user_id)
+ , INDEX (lesson_id)
+ , CONSTRAINT FK_lams_learner_progress_2 FOREIGN KEY (lesson_id)
+ REFERENCES lams_lesson (lesson_id)
)TYPE=InnoDB;
-CREATE TABLE lams_learning_grouping_activity (
- activity_id BIGINT(20) NOT NULL DEFAULT 0
- , learning_grouping_id BIGINT(20) NOT NULL DEFAULT 0
- , PRIMARY KEY (activity_id)
- , INDEX (learning_grouping_id)
- , CONSTRAINT FK_lams_learning_grouping_activity_2 FOREIGN KEY (learning_grouping_id)
- REFERENCES lams_learning_grouping (learning_grouping_id) ON DELETE NO ACTION ON UPDATE NO ACTION
- , INDEX (activity_id)
- , CONSTRAINT FK_lams_learning_grouping_activity_1 FOREIGN KEY (activity_id)
- REFERENCES lams_learning_activity (activity_id) ON DELETE NO ACTION ON UPDATE NO ACTION
+CREATE TABLE lams_tool_session (
+ tool_session_id BIGINT(20) NOT NULL
+ , group_id BIGINT(20) DEFAULT 0
+ , activity_id BIGINT(20) NOT NULL DEFAULT 0
+ , tool_session_key BIGINT(20) NOT NULL
+ , tool_session_state_id INT(3) NOT NULL
+ , PRIMARY KEY (tool_session_id)
+ , INDEX (group_id)
+ , CONSTRAINT FK_lams_tool_session_1 FOREIGN KEY (group_id)
+ REFERENCES lams_group (group_id)
+ , INDEX (tool_session_state_id)
+ , CONSTRAINT FK_lams_tool_session_4 FOREIGN KEY (tool_session_state_id)
+ REFERENCES lams_tool_session_state (tool_session_state_id)
)TYPE=InnoDB;
-CREATE TABLE lams_learning_options_activity (
- activity_id BIGINT(20) NOT NULL DEFAULT 0
- , min_number_of_options INT(11)
- , max_number_of_options INT(11)
- , PRIMARY KEY (activity_id)
- , INDEX (activity_id)
- , CONSTRAINT FK_lams_learning_options_activity_1 FOREIGN KEY (activity_id)
- REFERENCES lams_learning_activity (activity_id) ON DELETE NO ACTION ON UPDATE NO ACTION
-)TYPE=InnoDB;
-
-CREATE TABLE lams_learning_tool_activity (
- activity_id BIGINT(20) NOT NULL DEFAULT 0
- , tool_id BIGINT(20) NOT NULL DEFAULT 0
- , tool_content_id BIGINT(20)
- , PRIMARY KEY (activity_id)
- , INDEX (activity_id)
- , CONSTRAINT FK_lams_learning_tool_activity_1 FOREIGN KEY (activity_id)
- REFERENCES lams_learning_activity (activity_id) ON DELETE NO ACTION ON UPDATE NO ACTION
-)TYPE=InnoDB;
-CREATE INDEX idx_toole_act_tool ON lams_learning_tool_activity (tool_id ASC);
-CREATE INDEX idx_toole_act_tool_content ON lams_learning_tool_activity (tool_content_id ASC);
-
CREATE TABLE lams_learning_transition (
transition_id BIGINT(20) NOT NULL DEFAULT 0
, id INT(11)
@@ -315,6 +362,58 @@
REFERENCES lams_user_organisation (user_organisation_id) ON DELETE NO ACTION ON UPDATE NO ACTION
)TYPE=InnoDB;
+CREATE TABLE lams_progress_completed (
+ learner_progress_id BIGINT(20) NOT NULL
+ , activity_id BIGINT(20) NOT NULL DEFAULT 0
+ , PRIMARY KEY (learner_progress_id, activity_id)
+ , INDEX (learner_progress_id)
+ , CONSTRAINT FK_lams_progress_completed_1 FOREIGN KEY (learner_progress_id)
+ REFERENCES lams_learner_progress (learner_progress_id)
+ , INDEX (activity_id)
+ , CONSTRAINT FK_lams_progress_completed_2 FOREIGN KEY (activity_id)
+ REFERENCES lams_learning_activity (activity_id)
+)TYPE=InnoDB;
+
+CREATE TABLE lams_progress_current (
+ learner_progress_id BIGINT(20) NOT NULL
+ , activity_id BIGINT(20) NOT NULL DEFAULT 0
+ , PRIMARY KEY (learner_progress_id, activity_id)
+ , INDEX (learner_progress_id)
+ , CONSTRAINT FK_lams_progress_current_1 FOREIGN KEY (learner_progress_id)
+ REFERENCES lams_learner_progress (learner_progress_id)
+ , INDEX (activity_id)
+ , CONSTRAINT FK_lams_progress_current_2 FOREIGN KEY (activity_id)
+ REFERENCES lams_learning_activity (activity_id)
+)TYPE=InnoDB;
+
+CREATE TABLE lams_user_tool_session (
+ tool_session_id BIGINT(20) NOT NULL
+ , user_id BIGINT(20) NOT NULL DEFAULT 0
+ , user_tool_session_state_id INT(3) NOT NULL
+ , PRIMARY KEY (tool_session_id, user_id)
+ , INDEX (tool_session_id)
+ , CONSTRAINT FK_lams_user_tool_session_1 FOREIGN KEY (tool_session_id)
+ REFERENCES lams_tool_session (tool_session_id)
+ , INDEX (user_id)
+ , CONSTRAINT FK_lams_user_tool_session_2 FOREIGN KEY (user_id)
+ REFERENCES lams_user (user_id)
+ , INDEX (user_tool_session_state_id)
+ , CONSTRAINT FK_lams_user_tool_session_3 FOREIGN KEY (user_tool_session_state_id)
+ REFERENCES lams_user_tool_session_state (user_tool_session_state_id)
+)TYPE=InnoDB;
+
+CREATE TABLE lams_user_group (
+ user_id BIGINT(20) NOT NULL DEFAULT 0
+ , group_id BIGINT(20) NOT NULL DEFAULT 0
+ , PRIMARY KEY (user_id, group_id)
+ , INDEX (user_id)
+ , CONSTRAINT FK_lams_user_group_1 FOREIGN KEY (user_id)
+ REFERENCES lams_user (user_id)
+ , INDEX (group_id)
+ , CONSTRAINT FK_lams_user_group_2 FOREIGN KEY (group_id)
+ REFERENCES lams_group (group_id)
+)TYPE=InnoDB;
+
CREATE TABLE lams_authentication_method_parameter (
authentication_parameter_id BIGINT(20) NOT NULL DEFAULT 0
, authentication_method_id BIGINT(20) NOT NULL DEFAULT 0
Index: lams_common/db/sql/drop_lams_11_tables.sql
===================================================================
diff -u -r6620d09a078468249f19939b0bae1bf0c50ca7da -r6fdc01729bb7cb4fae5d054af8d5917c9099d7d4
--- lams_common/db/sql/drop_lams_11_tables.sql (.../drop_lams_11_tables.sql) (revision 6620d09a078468249f19939b0bae1bf0c50ca7da)
+++ lams_common/db/sql/drop_lams_11_tables.sql (.../drop_lams_11_tables.sql) (revision 6fdc01729bb7cb4fae5d054af8d5917c9099d7d4)
@@ -13,21 +13,23 @@
DROP INDEX parent_folder_id ON lams_workspace_folder;
DROP INDEX PRIMARY ON lams_workspace;
DROP INDEX root_folder_id ON lams_workspace;
+DROP INDEX PRIMARY ON lams_user;
+DROP INDEX UQ_lams_user_login ON lams_user;
+DROP INDEX authentication_method_id ON lams_user;
+DROP INDEX workspace_id ON lams_user;
+DROP INDEX login ON lams_user;
DROP INDEX PRIMARY ON lams_learning_design;
DROP INDEX idx_design_parent_id ON lams_learning_design;
DROP INDEX idx_design_user_id ON lams_learning_design;
DROP INDEX idx_design_first_act ON lams_learning_design;
-DROP INDEX PRIMARY ON lams_learning_grouping;
-DROP INDEX idx_grouping_grouping_type ON lams_learning_grouping;
+DROP INDEX PRIMARY ON lams_grouping;
+DROP INDEX idx_grouping_grouping_type ON lams_grouping;
+DROP INDEX PRIMARY ON lams_group;
+DROP INDEX idx_group_grouping ON lams_group;
DROP INDEX PRIMARY ON lams_organisation;
DROP INDEX organisation_type_id ON lams_organisation;
DROP INDEX workspace_id ON lams_organisation;
DROP INDEX parent_organisation_id ON lams_organisation;
-DROP INDEX PRIMARY ON lams_user;
-DROP INDEX UQ_lams_user_login ON lams_user;
-DROP INDEX authentication_method_id ON lams_user;
-DROP INDEX workspace_id ON lams_user;
-DROP INDEX login ON lams_user;
DROP INDEX PRIMARY ON lams_learning_activity;
DROP INDEX idx_activity_library_id ON lams_learning_activity;
DROP INDEX idx_activity_design_id ON lams_learning_activity;
@@ -37,20 +39,6 @@
DROP INDEX PRIMARY ON lams_user_organisation;
DROP INDEX user_id ON lams_user_organisation;
DROP INDEX organisation_id ON lams_user_organisation;
-DROP INDEX PRIMARY ON lams_learning_gate_activity;
-DROP INDEX idx_gate_act_activity ON lams_learning_gate_activity;
-DROP INDEX idx_gate_act_level ON lams_learning_gate_activity;
-DROP INDEX PRIMARY ON lams_learning_group;
-DROP INDEX idx_group_grouping ON lams_learning_group;
-DROP INDEX PRIMARY ON lams_learning_grouping_activity;
-DROP INDEX idx_grouping_act_activity ON lams_learning_grouping_activity;
-DROP INDEX idx_grouping_act_grouping ON lams_learning_grouping_activity;
-DROP INDEX PRIMARY ON lams_learning_options_activity;
-DROP INDEX idx_options_act_activity ON lams_learning_options_activity;
-DROP INDEX PRIMARY ON lams_learning_tool_activity;
-DROP INDEX idx_toole_act_activity ON lams_learning_tool_activity;
-DROP INDEX idx_toole_act_tool ON lams_learning_tool_activity;
-DROP INDEX idx_toole_act_tool_content ON lams_learning_tool_activity;
DROP INDEX PRIMARY ON lams_learning_transition;
DROP INDEX ldId ON lams_learning_transition;
DROP INDEX idx_transition_to_activity ON lams_learning_transition;
@@ -62,23 +50,30 @@
DROP INDEX authentication_method_id ON lams_authentication_method_parameter;
DROP TABLE lams_authentication_method_parameter;
+DROP TABLE lams_user_group;
+DROP TABLE lams_user_tool_session;
+DROP TABLE lams_progress_current;
+DROP TABLE lams_progress_completed;
DROP TABLE lams_user_organisation_role;
DROP TABLE lams_learning_transition;
-DROP TABLE lams_learning_tool_activity;
-DROP TABLE lams_learning_options_activity;
-DROP TABLE lams_learning_grouping_activity;
-DROP TABLE lams_learning_group;
-DROP TABLE lams_learning_gate_activity;
+DROP TABLE lams_tool_session;
+DROP TABLE lams_learner_progress;
+DROP TABLE lams_lesson;
DROP TABLE lams_user_organisation;
DROP TABLE lams_learning_activity;
-DROP TABLE lams_user;
DROP TABLE lams_organisation;
-DROP TABLE lams_learning_grouping;
+DROP TABLE lams_group;
+DROP TABLE lams_grouping;
DROP TABLE lams_learning_design;
+DROP TABLE lams_user;
DROP TABLE lams_workspace;
DROP TABLE lams_workspace_folder;
DROP TABLE lams_authentication_method;
DROP TABLE lams_authentication_method_type;
+DROP TABLE lams_user_tool_session_state;
+DROP TABLE lams_tool_session_state;
+DROP TABLE lams_tool;
+DROP TABLE lams_tool_content;
DROP TABLE lams_role;
DROP TABLE lams_organisation_type;
DROP TABLE lams_learning_library;
@@ -110,3 +105,10 @@
+
+
+
+
+
+
+