Index: lams_tool_lamc/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_lamc/build.xml,v
diff -u -r1.1 -r1.2
--- lams_tool_lamc/build.xml	30 Sep 2005 10:11:34 -0000	1.1
+++ lams_tool_lamc/build.xml	30 Sep 2005 17:28:58 -0000	1.2
@@ -84,9 +84,9 @@
 		     </fail>
 	   </target>
 	<!-- =================================================================== -->
-	<!-- Run Middlegen For LearningDesign                                                       -->
+	<!-- Run Middlegen For mc                                                       -->
 	<!-- =================================================================== -->
-		<target name="middlegen" description="Run Middlegen For Submit Fiiles Tool" unless="middlegen.skip" depends="init,fail-if-no-xdoclet-1.2.x,check-driver-present,panic-if-driver-not-present">
+		<target name="middlegen" description="Run Middlegen For mc Tool" unless="middlegen.skip" depends="init,fail-if-no-xdoclet-1.2.x,check-driver-present,panic-if-driver-not-present">
 			<taskdef name="middlegen" classname="middlegen.MiddlegenTask" classpathref="all-libs" />
 			
 			<middlegen appname="lams_tool_lamc11" 
@@ -105,10 +105,12 @@
 						   javaTypeMapper="middlegen.plugins.hibernate.HibernateJavaTypeMapper"
 				/>
 				
-				<table name="tl_lasbmt11_content"/>
-				<table name="tl_lasbmt11_report"/>
-				<table name="tl_lasbmt11_session"/>
-				<table name="tl_lasbmt11_submission_details"/>
+				<table name="tl_lamc11_content"/>
+				<table name="tl_lamc11_session"/>
+				<table name="tl_lamc11_que_usr"/>
+				<table name="tl_lamc11_que_content"/>
+				<table name="tl_lamc11_options_content"/>
+				<table name="tl_lamc11_usr_attempt"/>				
 			</middlegen>
 
 		</target>
Index: lams_tool_lamc/db/model/lams_tool_mc.clay
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_lamc/db/model/lams_tool_mc.clay,v
diff -u -r1.3 -r1.4
--- lams_tool_lamc/db/model/lams_tool_mc.clay	30 Sep 2005 16:11:07 -0000	1.3
+++ lams_tool_lamc/db/model/lams_tool_mc.clay	30 Sep 2005 17:26:57 -0000	1.4
@@ -7,7 +7,7 @@
 <schema-description/>
 <domain-list/>
 <table-list>
-<table name="tl_laqa11_session" alias="" remarks="">
+<table name="tl_lamc11_session" alias="" remarks="">
 <table-description/>
 <table-figure-bounds x="118" y="106" width="181" height="109"/>
 <column-list>
@@ -70,13 +70,13 @@
 </data-type>
 </column>
 </column-list>
-<primary-key name="PK_TL_LAQA11_SESSION" alias="" remarks="">
+<primary-key name="PK_TL_LAMC11_SESSION" alias="" remarks="">
 <primary-key-description/>
 <primary-key-column name="uid"/>
 </primary-key>
 <unique-key-list/>
 <foreign-key-list>
-<foreign-key name="FK_tl_laqa11_session_1" alias="" remarks="" referenced-table-schema="lams" referenced-table="tl_laqa11_content" referenced-key="PK_TL_LAQA11_CONTENT" on-update="" on-delete="" source-multiplicity="0..*" target-multiplicity="1" source-entity-role="" target-entity-role="" source-relationship-type="" target-relationship-type="">
+<foreign-key name="FK_tl_laqa11_session_1" alias="" remarks="" referenced-table-schema="lams" referenced-table="tl_lamc11_content" referenced-key="PK_TL_LAMC11_CONTENT" on-update="" on-delete="" source-multiplicity="0..*" target-multiplicity="1" source-entity-role="" target-entity-role="" source-relationship-type="" target-relationship-type="">
 <foreign-key-description/>
 <foreign-key-figure>
 <fk-fig-bendpoint-list/>
@@ -86,7 +86,7 @@
 </foreign-key-list>
 <index-list/>
 </table>
-<table name="tl_laqa11_content" alias="" remarks="">
+<table name="tl_lamc11_content" alias="" remarks="">
 <table-description/>
 <table-figure-bounds x="96" y="391" width="203" height="304"/>
 <column-list>
@@ -116,14 +116,14 @@
 <variant type-name-pattern="BIGINT ZEROFILL"/>
 </data-type>
 </column>
-<column name="title" alias="" remarks="" mandatory="true" column-size="250" decimal-digits="0" default-value="Questions and Answers" auto-increment="false">
+<column name="title" alias="" remarks="" mandatory="true" column-size="250" decimal-digits="0" default-value="Multiple Choice" 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"/>
 <variant type-name-pattern="VARCHAR(%n) BINARY" precision-variable="%n" precision-min="1" precision-max="255"/>
 </data-type>
 </column>
-<column name="instructions" alias="" remarks="" mandatory="true" column-size="250" decimal-digits="0" default-value="Please, take a minute to answer the following questions." auto-increment="false">
+<column name="instructions" alias="" remarks="" mandatory="true" column-size="250" decimal-digits="0" default-value="Please answer the questions until you reach the passmark." 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"/>
@@ -309,15 +309,15 @@
 </data-type>
 </column>
 </column-list>
-<primary-key name="PK_TL_LAQA11_CONTENT" alias="" remarks="">
+<primary-key name="PK_TL_LAMC11_CONTENT" alias="" remarks="">
 <primary-key-description/>
 <primary-key-column name="uid"/>
 </primary-key>
 <unique-key-list/>
 <foreign-key-list/>
 <index-list/>
 </table>
-<table name="tl_laqa11_que_usr" alias="" remarks="">
+<table name="tl_lamc11_que_usr" alias="" remarks="">
 <table-description/>
 <table-figure-bounds x="479" y="106" width="-1" height="-1"/>
 <column-list>
@@ -375,13 +375,13 @@
 </data-type>
 </column>
 </column-list>
-<primary-key name="PK_TL_LAQA11_QUE_USR" alias="" remarks="">
+<primary-key name="PK_TL_LAMC11_QUE_USR" alias="" remarks="">
 <primary-key-description/>
 <primary-key-column name="uid"/>
 </primary-key>
 <unique-key-list/>
 <foreign-key-list>
-<foreign-key name="FK_tl_laqa11_que_usr_1" alias="" remarks="" referenced-table-schema="lams" referenced-table="tl_laqa11_session" referenced-key="PK_TL_LAQA11_SESSION" on-update="" on-delete="" source-multiplicity="0..*" target-multiplicity="1" source-entity-role="" target-entity-role="" source-relationship-type="" target-relationship-type="">
+<foreign-key name="FK_tl_laqa11_que_usr_1" alias="" remarks="" referenced-table-schema="lams" referenced-table="tl_lamc11_session" referenced-key="PK_TL_LAMC11_SESSION" on-update="" on-delete="" source-multiplicity="0..*" target-multiplicity="1" source-entity-role="" target-entity-role="" source-relationship-type="" target-relationship-type="">
 <foreign-key-description/>
 <foreign-key-figure>
 <fk-fig-bendpoint-list/>
@@ -391,7 +391,7 @@
 </foreign-key-list>
 <index-list/>
 </table>
-<table name="tl_laqa11_que_content" alias="" remarks="">
+<table name="tl_lamc11_que_content" alias="" remarks="">
 <table-description/>
 <table-figure-bounds x="584" y="485" width="176" height="95"/>
 <column-list>
@@ -455,13 +455,13 @@
 </data-type>
 </column>
 </column-list>
-<primary-key name="PK_TL_LAQA11_QUE_CONTENT" alias="" remarks="">
+<primary-key name="PK_TL_LAMC11_QUE_CONTENT" alias="" remarks="">
 <primary-key-description/>
 <primary-key-column name="uid"/>
 </primary-key>
 <unique-key-list/>
 <foreign-key-list>
-<foreign-key name="FK_tl_laqa11_que_content_1" alias="" remarks="" referenced-table-schema="lams" referenced-table="tl_laqa11_content" referenced-key="PK_TL_LAQA11_CONTENT" on-update="" on-delete="" source-multiplicity="0..*" target-multiplicity="1" source-entity-role="" target-entity-role="" source-relationship-type="" target-relationship-type="">
+<foreign-key name="FK_tl_laqa11_que_content_1" alias="" remarks="" referenced-table-schema="lams" referenced-table="tl_lamc11_content" referenced-key="PK_TL_LAMC11_CONTENT" on-update="" on-delete="" source-multiplicity="0..*" target-multiplicity="1" source-entity-role="" target-entity-role="" source-relationship-type="" target-relationship-type="">
 <foreign-key-description/>
 <foreign-key-figure>
 <fk-fig-bendpoint-list/>
@@ -471,7 +471,7 @@
 </foreign-key-list>
 <index-list/>
 </table>
-<table name="tl_laqa11_usr_attempt" alias="" remarks="">
+<table name="tl_lamc11_usr_attempt" alias="" remarks="">
 <table-description/>
 <table-figure-bounds x="930" y="73" width="206" height="125"/>
 <column-list>
@@ -527,12 +527,17 @@
 <variant type-name-pattern="BIGINT ZEROFILL"/>
 </data-type>
 </column>
-<column name="qa_que_option_id" alias="" remarks="" mandatory="true" column-size="10" decimal-digits="0" default-value="" auto-increment="false">
+<column name="qa_que_option_id" alias="" remarks="" mandatory="true" column-size="20" decimal-digits="0" default-value="" auto-increment="false">
 <column-description/>
-<data-type name="CHAR" jdbc-type="1" selected-variant-pattern="CHAR(%n)" literal-prefix="'" literal-suffix="'">
-<variant type-name-pattern="CHAR"/>
-<variant type-name-pattern="CHAR(%n)" precision-variable="%n" precision-min="0" precision-max="255"/>
-<variant type-name-pattern="CHAR(%n) BINARY" precision-variable="%n" precision-min="0" precision-max="255"/>
+<data-type name="BIGINT" jdbc-type="-5" selected-variant-pattern="BIGINT(%n)">
+<variant type-name-pattern="BIGINT"/>
+<variant type-name-pattern="BIGINT(%n)" precision-variable="%n" precision-min="0" precision-max="19"/>
+<variant type-name-pattern="BIGINT(%n) UNSIGNED" precision-variable="%n" precision-min="0" precision-max="19"/>
+<variant type-name-pattern="BIGINT(%n) UNSIGNED ZEROFILL" precision-variable="%n" precision-min="0" precision-max="19"/>
+<variant type-name-pattern="BIGINT(%n) ZEROFILL" precision-variable="%n" precision-min="0" precision-max="19"/>
+<variant type-name-pattern="BIGINT UNSIGNED"/>
+<variant type-name-pattern="BIGINT UNSIGNED ZEROFILL"/>
+<variant type-name-pattern="BIGINT ZEROFILL"/>
 </data-type>
 </column>
 <column name="attempt_time" alias="" remarks="" mandatory="false" column-size="0" decimal-digits="0" default-value="" auto-increment="false">
@@ -549,27 +554,27 @@
 </data-type>
 </column>
 </column-list>
-<primary-key name="PK_TL_LAQA11_USR_ATTEMPT" alias="" remarks="">
+<primary-key name="PK_TL_LAMC11_USR_ATTEMPT" alias="" remarks="">
 <primary-key-description/>
 <primary-key-column name="uid"/>
 </primary-key>
 <unique-key-list/>
 <foreign-key-list>
-<foreign-key name="FK_tl_laqa11_usr_resp_1" alias="" remarks="" referenced-table-schema="lams" referenced-table="tl_laqa11_que_usr" referenced-key="PK_TL_LAQA11_QUE_USR" on-update="" on-delete="" source-multiplicity="0..*" target-multiplicity="1" source-entity-role="" target-entity-role="" source-relationship-type="" target-relationship-type="">
+<foreign-key name="FK_tl_lamc11_usr_attempt_3" alias="" remarks="" referenced-table-schema="lams" referenced-table="tl_lamc11_que_usr" referenced-key="PK_TL_LAMC11_QUE_USR" on-update="" on-delete="" source-multiplicity="0..*" target-multiplicity="1" source-entity-role="" target-entity-role="" source-relationship-type="" target-relationship-type="">
 <foreign-key-description/>
 <foreign-key-figure>
 <fk-fig-bendpoint-list/>
 </foreign-key-figure>
 <foreign-key-column column-name="que_usr_id" referenced-key-column-name="uid"/>
 </foreign-key>
-<foreign-key name="FK_tl_laqa11_usr_attempt_2" alias="" remarks="" referenced-table-schema="lams" referenced-table="tl_laqa11_que_content" referenced-key="PK_TL_LAQA11_QUE_CONTENT" on-update="" on-delete="" source-multiplicity="0..*" target-multiplicity="1" source-entity-role="" target-entity-role="" source-relationship-type="" target-relationship-type="">
+<foreign-key name="FK_tl_lamc11_usr_attempt_2" alias="" remarks="" referenced-table-schema="lams" referenced-table="tl_lamc11_que_content" referenced-key="PK_TL_LAMC11_QUE_CONTENT" on-update="" on-delete="" source-multiplicity="0..*" target-multiplicity="1" source-entity-role="" target-entity-role="" source-relationship-type="" target-relationship-type="">
 <foreign-key-description/>
 <foreign-key-figure>
 <fk-fig-bendpoint-list/>
 </foreign-key-figure>
 <foreign-key-column column-name="qa_que_content_id" referenced-key-column-name="uid"/>
 </foreign-key>
-<foreign-key name="FK_tl_laqa11_usr_attempt_3" alias="" remarks="" referenced-table-schema="lams" referenced-table="tl_laqa11_options_content" referenced-key="PK_TL_LAQA11_OPTIONS_CONTENT" on-update="" on-delete="" source-multiplicity="0..*" target-multiplicity="1" source-entity-role="" target-entity-role="" source-relationship-type="" target-relationship-type="">
+<foreign-key name="FK_tl_lamc11_usr_attempt_4" alias="" remarks="" referenced-table-schema="lams" referenced-table="tl_lamc11_options_content" referenced-key="PK_TL_LAMC11_OPTIONS_CONTENT" on-update="" on-delete="" source-multiplicity="0..*" target-multiplicity="1" source-entity-role="" target-entity-role="" source-relationship-type="" target-relationship-type="">
 <foreign-key-description/>
 <foreign-key-figure>
 <fk-fig-bendpoint-list/>
@@ -579,9 +584,9 @@
 </foreign-key-list>
 <index-list/>
 </table>
-<table name="tl_laqa11_options_content" alias="" remarks="">
+<table name="tl_lamc11_options_content" alias="" remarks="">
 <table-description/>
-<table-figure-bounds x="949" y="483" width="193" height="101"/>
+<table-figure-bounds x="949" y="483" width="192" height="92"/>
 <column-list>
 <column name="uid" alias="" remarks="" mandatory="true" column-size="20" decimal-digits="0" default-value="" auto-increment="true">
 <column-description/>
@@ -643,13 +648,13 @@
 </data-type>
 </column>
 </column-list>
-<primary-key name="PK_TL_LAQA11_OPTIONS_CONTENT" alias="" remarks="">
+<primary-key name="PK_TL_LAMC11_OPTIONS_CONTENT" alias="" remarks="">
 <primary-key-description/>
 <primary-key-column name="uid"/>
 </primary-key>
 <unique-key-list/>
 <foreign-key-list>
-<foreign-key name="FK_tl_laqa11_options_content_1" alias="" remarks="" referenced-table-schema="lams" referenced-table="tl_laqa11_que_content" referenced-key="PK_TL_LAQA11_QUE_CONTENT" on-update="" on-delete="" source-multiplicity="0..*" target-multiplicity="1" source-entity-role="" target-entity-role="" source-relationship-type="" target-relationship-type="">
+<foreign-key name="FK_tl_laqa11_options_content_1" alias="" remarks="" referenced-table-schema="lams" referenced-table="tl_lamc11_que_content" referenced-key="PK_TL_LAMC11_QUE_CONTENT" on-update="" on-delete="" source-multiplicity="0..*" target-multiplicity="1" source-entity-role="" target-entity-role="" source-relationship-type="" target-relationship-type="">
 <foreign-key-description/>
 <foreign-key-figure>
 <fk-fig-bendpoint-list/>