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;