Index: lams_common/db/model/lams_11.clay
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/model/lams_11.clay,v
diff -u -r1.11 -r1.12
--- lams_common/db/model/lams_11.clay	24 Jan 2005 23:24:41 -0000	1.11
+++ lams_common/db/model/lams_11.clay	31 Jan 2005 01:22:13 -0000	1.12
@@ -37,7 +37,7 @@
 <variant type-name-pattern="INT ZEROFILL"/>
 </data-type>
 </column>
-<column name="parameters_file_name" alias="" remarks="" mandatory="true" column-size="255" decimal-digits="0" default-value="" auto-increment="false">
+<column name="authentication_method_name" alias="" remarks="" mandatory="true" column-size="255" decimal-digits="0" default-value="" auto-increment="false">
 <column-description/>
 <data-type name="VARCHAR" jdbc-type="12" selected-variant-pattern="VARCHAR(%n)" literal-prefix="'" literal-suffix="'">
 <variant type-name-pattern="VARCHAR(%n)" precision-variable="%n" precision-min="1" precision-max="255"/>
@@ -49,7 +49,12 @@
 <primary-key-description/>
 <primary-key-column name="authentication_method_id"/>
 </primary-key>
-<unique-key-list/>
+<unique-key-list>
+<unique-key name="UQ_lams_authentication_method_1" alias="" remarks="">
+<unique-key-description/>
+<unique-key-column name="authentication_method_name"/>
+</unique-key>
+</unique-key-list>
 <foreign-key-list>
 <foreign-key name="FK_lams_authorization_method_1" alias="" remarks="" referenced-table-schema="DEFAULT_SCHEMA" referenced-table="lams_authentication_method_type" referenced-key="PRIMARY" on-update="NO ACTION" on-delete="NO ACTION" source-multiplicity="0..*" target-multiplicity="1" source-entity-role="" target-entity-role="" source-relationship-type="" target-relationship-type="">
 <foreign-key-description/>
@@ -2020,8 +2025,8 @@
 <column name="lesson_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"/>
@@ -2755,8 +2760,8 @@
 <column name="lesson_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.14 -r1.15
--- lams_common/db/sql/create_lams_11_tables.sql	24 Jan 2005 23:24:30 -0000	1.14
+++ lams_common/db/sql/create_lams_11_tables.sql	31 Jan 2005 01:21:59 -0000	1.15
@@ -87,7 +87,8 @@
 CREATE TABLE lams_authentication_method (
        authentication_method_id BIGINT(20) NOT NULL DEFAULT 0
      , authentication_method_type_id INT(3) NOT NULL DEFAULT 0
-     , parameters_file_name VARCHAR(255) NOT NULL
+     , authentication_method_name VARCHAR(255) NOT NULL
+     , UNIQUE UQ_lams_authentication_method_1 (authentication_method_name)
      , PRIMARY KEY (authentication_method_id)
      , INDEX (authentication_method_type_id)
      , CONSTRAINT FK_lams_authorization_method_1 FOREIGN KEY (authentication_method_type_id)
@@ -441,6 +442,17 @@
                   REFERENCES lams_learning_activity (activity_id)
 )TYPE=InnoDB;
 
+CREATE TABLE lams_lesson_learner (
+       lesson_id BIGINT(20) NOT NULL
+     , user_id BIGINT(20) NOT NULL DEFAULT 0
+     , INDEX (lesson_id)
+     , CONSTRAINT FK_lams_lesson_learner_1 FOREIGN KEY (lesson_id)
+                  REFERENCES lams_lesson (lesson_id)
+     , INDEX (user_id)
+     , CONSTRAINT FK_lams_lesson_learner_2 FOREIGN KEY (user_id)
+                  REFERENCES lams_user (user_id)
+)TYPE=InnoDB;
+
 CREATE TABLE lams_learning_transition (
        transition_id BIGINT(20) NOT NULL DEFAULT 0 AUTO_INCREMENT
      , id INT(11)