Index: lams_tool_sbmt/build.properties
===================================================================
diff -u -r02696b4b5a761a0fcc9f72a677d3599656ffb725 -r84332e9d2e99a4c32b5d0d825a7256a2a1721faf
--- lams_tool_sbmt/build.properties	(.../build.properties)	(revision 02696b4b5a761a0fcc9f72a677d3599656ffb725)
+++ lams_tool_sbmt/build.properties	(.../build.properties)	(revision 84332e9d2e99a4c32b5d0d825a7256a2a1721faf)
@@ -8,7 +8,7 @@
 signature=lasbmt11
 
 #project version
-tool.version=20090723
+tool.version=20091028
 
 # Minimum compatible version
 min.server.version.number=2.0.3
Index: lams_tool_sbmt/conf/hibernate/mappings/org/lamsfoundation/lams/tool/sbmt/SubmitFilesReport.hbm.xml
===================================================================
diff -u -r02696b4b5a761a0fcc9f72a677d3599656ffb725 -r84332e9d2e99a4c32b5d0d825a7256a2a1721faf
--- lams_tool_sbmt/conf/hibernate/mappings/org/lamsfoundation/lams/tool/sbmt/SubmitFilesReport.hbm.xml	(.../SubmitFilesReport.hbm.xml)	(revision 02696b4b5a761a0fcc9f72a677d3599656ffb725)
+++ lams_tool_sbmt/conf/hibernate/mappings/org/lamsfoundation/lams/tool/sbmt/SubmitFilesReport.hbm.xml	(.../SubmitFilesReport.hbm.xml)	(revision 84332e9d2e99a4c32b5d0d825a7256a2a1721faf)
@@ -4,84 +4,44 @@
     "-//Hibernate/Hibernate Mapping DTD 3.0//EN" 
     "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
 
-<hibernate-mapping
->
-    <class
-        name="org.lamsfoundation.lams.tool.sbmt.SubmitFilesReport"
-        table="tl_lasbmt11_report"
-    >
+<hibernate-mapping>
+	<class name="org.lamsfoundation.lams.tool.sbmt.SubmitFilesReport"
+		table="tl_lasbmt11_report">
 
-        <id
-            name="reportID"
-            column="report_id"
-            type="java.lang.Long"
-        >
-            <generator class="native">
-              <!--  
-                  To add non XDoclet generator parameters, create a file named 
-                  hibernate-generator-params-SubmitFilesReport.xml 
-                  containing the additional parameters and place it in your merge dir. 
-              --> 
-            </generator>
-        </id>
+		<id name="reportID" column="report_id" type="java.lang.Long">
+			<generator class="native">
+				<!--
+					To add non XDoclet generator parameters, create a file named
+					hibernate-generator-params-SubmitFilesReport.xml containing the
+					additional parameters and place it in your merge dir.
+				-->
+			</generator>
+		</id>
 
-        <property
-            name="comments"
-            type="java.lang.String"
-            update="true"
-            insert="true"
-            column="comments"
-            length="250"
-        />
+		<property name="comments" type="java.lang.String" update="true"
+			insert="true" column="comments" length="65535" />
 
-        <property
-            name="marks"
-            type="java.lang.Float"
-            update="true"
-            insert="true"
-            column="marks"
-        />
+		<property name="marks" type="java.lang.Float" update="true"
+			insert="true" column="marks" />
 
-        <property
-            name="dateMarksReleased"
-            type="java.util.Date"
-            update="true"
-            insert="true"
-            column="date_marks_released"
-            length="19"
-        />
+		<property name="dateMarksReleased" type="java.util.Date"
+			update="true" insert="true" column="date_marks_released" length="19" />
 
-        <property
-            name="markFileUUID"
-            type="java.lang.Long"
-            update="true"
-            insert="true"
-            column="mark_file_uuid"
-        />
+		<property name="markFileUUID" type="java.lang.Long" update="true"
+			insert="true" column="mark_file_uuid" />
 
-        <property
-            name="markFileName"
-            type="java.lang.String"
-            update="true"
-            insert="true"
-            column="mark_file_name"
-            length="255"
-        />
+		<property name="markFileName" type="java.lang.String" update="true"
+			insert="true" column="mark_file_name" length="255" />
 
-        <property
-            name="markFileVersionID"
-            type="java.lang.Long"
-            update="true"
-            insert="true"
-            column="mark_file_version_id"
-        />
+		<property name="markFileVersionID" type="java.lang.Long"
+			update="true" insert="true" column="mark_file_version_id" />
 
-        <!--
-            To add non XDoclet property mappings, create a file named
-                hibernate-properties-SubmitFilesReport.xml
-            containing the additional properties and place it in your merge dir.
-        -->
+		<!--
+			To add non XDoclet property mappings, create a file named
+			hibernate-properties-SubmitFilesReport.xml containing the additional
+			properties and place it in your merge dir.
+		-->
 
-    </class>
+	</class>
 
 </hibernate-mapping>
Index: lams_tool_sbmt/db/sql/create_lams_tool_sbmt.sql
===================================================================
diff -u -r02696b4b5a761a0fcc9f72a677d3599656ffb725 -r84332e9d2e99a4c32b5d0d825a7256a2a1721faf
--- lams_tool_sbmt/db/sql/create_lams_tool_sbmt.sql	(.../create_lams_tool_sbmt.sql)	(revision 02696b4b5a761a0fcc9f72a677d3599656ffb725)
+++ lams_tool_sbmt/db/sql/create_lams_tool_sbmt.sql	(.../create_lams_tool_sbmt.sql)	(revision 84332e9d2e99a4c32b5d0d825a7256a2a1721faf)
@@ -51,7 +51,7 @@
 )TYPE=InnoDB;
 create table tl_lasbmt11_report (
    report_id bigint not null auto_increment,
-   comments varchar(250),
+   comments text,
    marks float,
    date_marks_released datetime,
    mark_file_uuid bigint,
Index: lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/SubmitFilesReport.hbm.xml
===================================================================
diff -u -r02696b4b5a761a0fcc9f72a677d3599656ffb725 -r84332e9d2e99a4c32b5d0d825a7256a2a1721faf
--- lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/SubmitFilesReport.hbm.xml	(.../SubmitFilesReport.hbm.xml)	(revision 02696b4b5a761a0fcc9f72a677d3599656ffb725)
+++ lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/SubmitFilesReport.hbm.xml	(.../SubmitFilesReport.hbm.xml)	(revision 84332e9d2e99a4c32b5d0d825a7256a2a1721faf)
@@ -4,84 +4,44 @@
     "-//Hibernate/Hibernate Mapping DTD 3.0//EN" 
     "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
 
-<hibernate-mapping
->
-    <class
-        name="org.lamsfoundation.lams.tool.sbmt.SubmitFilesReport"
-        table="tl_lasbmt11_report"
-    >
+<hibernate-mapping>
+	<class name="org.lamsfoundation.lams.tool.sbmt.SubmitFilesReport"
+		table="tl_lasbmt11_report">
 
-        <id
-            name="reportID"
-            column="report_id"
-            type="java.lang.Long"
-        >
-            <generator class="native">
-              <!--  
-                  To add non XDoclet generator parameters, create a file named 
-                  hibernate-generator-params-SubmitFilesReport.xml 
-                  containing the additional parameters and place it in your merge dir. 
-              --> 
-            </generator>
-        </id>
+		<id name="reportID" column="report_id" type="java.lang.Long">
+			<generator class="native">
+				<!--
+					To add non XDoclet generator parameters, create a file named
+					hibernate-generator-params-SubmitFilesReport.xml containing the
+					additional parameters and place it in your merge dir.
+				-->
+			</generator>
+		</id>
 
-        <property
-            name="comments"
-            type="java.lang.String"
-            update="true"
-            insert="true"
-            column="comments"
-            length="250"
-        />
+		<property name="comments" type="java.lang.String" update="true"
+			insert="true" column="comments" length="65535" />
 
-        <property
-            name="marks"
-            type="java.lang.Float"
-            update="true"
-            insert="true"
-            column="marks"
-        />
+		<property name="marks" type="java.lang.Float" update="true"
+			insert="true" column="marks" />
 
-        <property
-            name="dateMarksReleased"
-            type="java.util.Date"
-            update="true"
-            insert="true"
-            column="date_marks_released"
-            length="19"
-        />
+		<property name="dateMarksReleased" type="java.util.Date"
+			update="true" insert="true" column="date_marks_released" length="19" />
 
-        <property
-            name="markFileUUID"
-            type="java.lang.Long"
-            update="true"
-            insert="true"
-            column="mark_file_uuid"
-        />
+		<property name="markFileUUID" type="java.lang.Long" update="true"
+			insert="true" column="mark_file_uuid" />
 
-        <property
-            name="markFileName"
-            type="java.lang.String"
-            update="true"
-            insert="true"
-            column="mark_file_name"
-            length="255"
-        />
+		<property name="markFileName" type="java.lang.String" update="true"
+			insert="true" column="mark_file_name" length="255" />
 
-        <property
-            name="markFileVersionID"
-            type="java.lang.Long"
-            update="true"
-            insert="true"
-            column="mark_file_version_id"
-        />
+		<property name="markFileVersionID" type="java.lang.Long"
+			update="true" insert="true" column="mark_file_version_id" />
 
-        <!--
-            To add non XDoclet property mappings, create a file named
-                hibernate-properties-SubmitFilesReport.xml
-            containing the additional properties and place it in your merge dir.
-        -->
+		<!--
+			To add non XDoclet property mappings, create a file named
+			hibernate-properties-SubmitFilesReport.xml containing the additional
+			properties and place it in your merge dir.
+		-->
 
-    </class>
+	</class>
 
 </hibernate-mapping>
Index: lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/SubmitFilesReport.java
===================================================================
diff -u -r02696b4b5a761a0fcc9f72a677d3599656ffb725 -r84332e9d2e99a4c32b5d0d825a7256a2a1721faf
--- lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/SubmitFilesReport.java	(.../SubmitFilesReport.java)	(revision 02696b4b5a761a0fcc9f72a677d3599656ffb725)
+++ lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/SubmitFilesReport.java	(.../SubmitFilesReport.java)	(revision 84332e9d2e99a4c32b5d0d825a7256a2a1721faf)
@@ -87,7 +87,7 @@
     }
 
     /**
-     * @hibernate.property column="comments" length="250"
+     * @hibernate.property column="comments" length="65535"
      */
     public String getComments() {
 	return this.comments;
Index: lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/patch20091028_updatefrom232.sql
===================================================================
diff -u
--- lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/patch20091028_updatefrom232.sql	(revision 0)
+++ lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/patch20091028_updatefrom232.sql	(revision 84332e9d2e99a4c32b5d0d825a7256a2a1721faf)
@@ -0,0 +1,14 @@
+-- SQL statements to update from LAMS 2.3.1
+
+-- Turn off autocommit, so nothing is committed if there is an error
+SET AUTOCOMMIT = 0;
+
+----------------------Put all sql statements below here-------------------------
+
+alter table tl_lasbmt11_report modify column comments text;
+
+----------------------Put all sql statements above here-------------------------
+
+-- If there were no errors, commit and restore autocommit to on
+COMMIT;
+SET AUTOCOMMIT = 1;
\ No newline at end of file