Index: lams_common/db/model/lams_11.clay
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/model/lams_11.clay,v
diff -u -r1.51 -r1.52
--- lams_common/db/model/lams_11.clay	23 May 2006 04:17:26 -0000	1.51
+++ lams_common/db/model/lams_11.clay	31 May 2006 12:34:17 -0000	1.52
@@ -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
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/sql/create_lams_11_tables.sql,v
diff -u -r1.63 -r1.64
--- lams_common/db/sql/create_lams_11_tables.sql	23 May 2006 04:17:26 -0000	1.63
+++ lams_common/db/sql/create_lams_11_tables.sql	31 May 2006 12:33:11 -0000	1.64
@@ -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