Index: lams_common/db/model/lams_11.clay
===================================================================
diff -u -r197c186ee89cbca891240c59437053e0d23524f5 -r24d49560e56c272817e399fc3b0854c88816e098
--- lams_common/db/model/lams_11.clay	(.../lams_11.clay)	(revision 197c186ee89cbca891240c59437053e0d23524f5)
+++ lams_common/db/model/lams_11.clay	(.../lams_11.clay)	(revision 24d49560e56c272817e399fc3b0854c88816e098)
@@ -1611,8 +1611,8 @@
 <column name="organisation_state_id" alias="" remarks="" mandatory="true" column-size="3" decimal-digits="0" default-value="" auto-increment="false">
 <column-description/>
 <data-type name="INT" jdbc-type="4" selected-variant-pattern="INT(%n)">
-<variant type-name-pattern="INT"/>
 <variant type-name-pattern="INT(%n)" precision-variable="%n" precision-min="0" precision-max="10"/>
+<variant type-name-pattern="INT"/>
 <variant type-name-pattern="INT(%n) UNSIGNED" precision-variable="%n" precision-min="0" precision-max="10"/>
 <variant type-name-pattern="INT(%n) UNSIGNED ZEROFILL" precision-variable="%n" precision-min="0" precision-max="10"/>
 <variant type-name-pattern="INT(%n) ZEROFILL" precision-variable="%n" precision-min="0" precision-max="10"/>
@@ -2775,7 +2775,13 @@
 <foreign-key-column column-name="previous_activity_id" referenced-key-column-name="activity_id"/>
 </foreign-key>
 </foreign-key-list>
-<index-list/>
+<index-list>
+<index name="IX_lams_learner_progress_1" alias="" remarks="" unique="true">
+<index-description/>
+<index-column name="user_id" sort="ASC"/>
+<index-column name="lesson_id" sort="ASC"/>
+</index>
+</index-list>
 </table>
 <table name="lams_tool" alias="" remarks="">
 <table-description/>
@@ -4896,8 +4902,8 @@
 <column name="organisation_state_id" alias="" remarks="" mandatory="true" column-size="3" decimal-digits="0" default-value="" auto-increment="false">
 <column-description/>
 <data-type name="INT" jdbc-type="4" selected-variant-pattern="INT(%n)">
-<variant type-name-pattern="INT"/>
 <variant type-name-pattern="INT(%n)" precision-variable="%n" precision-min="0" precision-max="10"/>
+<variant type-name-pattern="INT"/>
 <variant type-name-pattern="INT(%n) UNSIGNED" precision-variable="%n" precision-min="0" precision-max="10"/>
 <variant type-name-pattern="INT(%n) UNSIGNED ZEROFILL" precision-variable="%n" precision-min="0" precision-max="10"/>
 <variant type-name-pattern="INT(%n) ZEROFILL" precision-variable="%n" precision-min="0" precision-max="10"/>
Index: lams_common/db/sql/create_lams_11_tables.sql
===================================================================
diff -u -r197c186ee89cbca891240c59437053e0d23524f5 -r24d49560e56c272817e399fc3b0854c88816e098
--- lams_common/db/sql/create_lams_11_tables.sql	(.../create_lams_11_tables.sql)	(revision 197c186ee89cbca891240c59437053e0d23524f5)
+++ lams_common/db/sql/create_lams_11_tables.sql	(.../create_lams_11_tables.sql)	(revision 24d49560e56c272817e399fc3b0854c88816e098)
@@ -580,6 +580,7 @@
      , CONSTRAINT FK_lams_learner_progress_5 FOREIGN KEY (previous_activity_id)
                   REFERENCES lams_learning_activity (activity_id)
 )TYPE=InnoDB;
+CREATE UNIQUE INDEX IX_lams_learner_progress_1 ON lams_learner_progress (user_id ASC, lesson_id ASC);
 
 CREATE TABLE lams_cr_node (
        node_id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT