Index: lams_common/db/model/lams_11.clay
===================================================================
diff -u -r97a20e3454d113286b226f7a3f4a1371377df1d1 -r84861fe0f6370b07582541e94edaa156fab08694
--- lams_common/db/model/lams_11.clay (.../lams_11.clay) (revision 97a20e3454d113286b226f7a3f4a1371377df1d1)
+++ lams_common/db/model/lams_11.clay (.../lams_11.clay) (revision 84861fe0f6370b07582541e94edaa156fab08694)
@@ -2194,6 +2194,19 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -2215,6 +2228,13 @@
+
+
+
+
+
+
+
@@ -2503,7 +2523,7 @@
-
+
@@ -2534,7 +2554,7 @@
-
+
Index: lams_common/db/sql/create_lams_11_tables.sql
===================================================================
diff -u -r97a20e3454d113286b226f7a3f4a1371377df1d1 -r84861fe0f6370b07582541e94edaa156fab08694
--- lams_common/db/sql/create_lams_11_tables.sql (.../create_lams_11_tables.sql) (revision 97a20e3454d113286b226f7a3f4a1371377df1d1)
+++ lams_common/db/sql/create_lams_11_tables.sql (.../create_lams_11_tables.sql) (revision 84861fe0f6370b07582541e94edaa156fab08694)
@@ -329,13 +329,17 @@
, lesson_completed_flag TINYINT(1) NOT NULL DEFAULT 0
, start_date_time DATETIME NOT NULL
, finish_date_time DATETIME
+ , activity_id BIGINT(20) NOT NULL DEFAULT 0
, 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)
+ , INDEX (activity_id)
+ , CONSTRAINT FK_lams_learner_progress_3 FOREIGN KEY (activity_id)
+ REFERENCES lams_learning_activity (activity_id)
)TYPE=InnoDB;
CREATE TABLE lams_tool_session (
@@ -379,7 +383,7 @@
REFERENCES lams_learning_activity (activity_id)
)TYPE=InnoDB;
-CREATE TABLE lams_progress_current (
+CREATE TABLE lams_progress_attempted (
learner_progress_id BIGINT(20) NOT NULL
, activity_id BIGINT(20) NOT NULL DEFAULT 0
, PRIMARY KEY (learner_progress_id, activity_id)
Index: lams_common/db/sql/drop_lams_11_tables.sql
===================================================================
diff -u -r97a20e3454d113286b226f7a3f4a1371377df1d1 -r84861fe0f6370b07582541e94edaa156fab08694
--- lams_common/db/sql/drop_lams_11_tables.sql (.../drop_lams_11_tables.sql) (revision 97a20e3454d113286b226f7a3f4a1371377df1d1)
+++ lams_common/db/sql/drop_lams_11_tables.sql (.../drop_lams_11_tables.sql) (revision 84861fe0f6370b07582541e94edaa156fab08694)
@@ -52,7 +52,7 @@
DROP TABLE lams_tool_content;
DROP TABLE lams_user_group;
DROP TABLE lams_user_tool_session;
-DROP TABLE lams_progress_current;
+DROP TABLE lams_progress_attempted;
DROP TABLE lams_progress_completed;
DROP TABLE lams_user_organisation_role;
DROP TABLE lams_tool_session;