Index: lams_tool_lamc/conf/hibernate/mappings/org/lamsfoundation/lams/tool/mc/McContent.hbm.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_lamc/conf/hibernate/mappings/org/lamsfoundation/lams/tool/mc/Attic/McContent.hbm.xml,v
diff -u -r1.15 -r1.16
--- lams_tool_lamc/conf/hibernate/mappings/org/lamsfoundation/lams/tool/mc/McContent.hbm.xml	13 Jan 2006 16:18:27 -0000	1.15
+++ lams_tool_lamc/conf/hibernate/mappings/org/lamsfoundation/lams/tool/mc/McContent.hbm.xml	2 Feb 2006 14:46:24 -0000	1.16
@@ -62,10 +62,10 @@
 
     <property
         name="creationDate"
-        type="java.lang.String"
+        type="java.util.Date"
         access="property"        
         column="creation_date"
-        length="10"
+        length="20"
     />
 
 
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.24 -r1.25
--- lams_tool_lamc/db/model/lams_tool_mc.clay	14 Dec 2005 15:29:25 -0000	1.24
+++ lams_tool_lamc/db/model/lams_tool_mc.clay	2 Feb 2006 14:46:24 -0000	1.25
@@ -49,11 +49,10 @@
 <variant type-name-pattern="TEXT"/>
 </data-type>
 </column>
-<column alias="" auto-increment="false" column-size="100" decimal-digits="0" default-value="" mandatory="false" name="creation_date" remarks="">
+<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="" mandatory="false" name="creation_date" remarks="">
 <column-description></column-description>
-<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
-<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
-<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
+<data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="DATETIME" selected-variant-pattern="DATETIME">
+<variant type-name-pattern="DATETIME"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="" mandatory="false" name="update_date" remarks="">
Index: lams_tool_lamc/db/sql/create_lams_tool_mc.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_lamc/db/sql/create_lams_tool_mc.sql,v
diff -u -r1.3 -r1.4
--- lams_tool_lamc/db/sql/create_lams_tool_mc.sql	14 Dec 2005 15:29:25 -0000	1.3
+++ lams_tool_lamc/db/sql/create_lams_tool_mc.sql	2 Feb 2006 14:46:24 -0000	1.4
@@ -3,7 +3,7 @@
      , content_id BIGINT(20) NOT NULL
      , title TEXT NOT NULL
      , instructions TEXT NOT NULL
-     , creation_date VARCHAR(100)
+     , creation_date DATETIME
      , update_date DATETIME
      , questions_sequenced TINYINT(1) NOT NULL DEFAULT 0
      , username_visible TINYINT(1) NOT NULL DEFAULT 0
@@ -113,7 +113,6 @@
                   REFERENCES lams.tl_lamc11_content (uid)
 )TYPE=InnoDB;
 
-
 INSERT INTO lams.tl_lamc11_content(uid, content_id , title , instructions , creation_date , questions_sequenced , username_visible , created_by , monitoring_report_title , report_title , run_offline , define_later, synch_in_monitor, offline_instructions, online_instructions, end_learning_message, content_in_use, retries, show_feedback, show_report) VALUES (1, ${default_content_id} ,'Mc Title','Mc Instructions', NOW(), 0, 0,1,'Monitoring Report','Report', 0, 0, 0,'offline instructions','online instructions','Finished Activity...', 0, 0, 0, 0);
 
 INSERT INTO lams.tl_lamc11_que_content  (uid,question, weight, disabled, display_order,  mc_content_id) VALUES (1, 'a sample question', 0, 1, 1,	1);
Index: lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/pojos/McContent.java
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/pojos/McContent.java,v
diff -u -r1.4 -r1.5
--- lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/pojos/McContent.java	26 Jan 2006 12:27:01 -0000	1.4
+++ lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/pojos/McContent.java	2 Feb 2006 14:46:24 -0000	1.5
@@ -65,7 +65,7 @@
     private boolean runOffline;
 
     /** nullable persistent field */
-    private String creationDate;
+    private Date creationDate;
 
     /** nullable persistent field */
     private Date updateDate;
@@ -123,7 +123,7 @@
     private Set mcAttachments;
 
     /** full constructor */
-    public McContent(Long mcContentId, String title, String instructions, boolean defineLater, boolean runOffline, String creationDate, 
+    public McContent(Long mcContentId, String title, String instructions, boolean defineLater, boolean runOffline, Date creationDate, 
     		Date updateDate, boolean questionsSequenced, boolean usernameVisible, String reportTitle, String monitoringReportTitle, 
 			long createdBy, boolean synchInMonitor, boolean contentInUse, String offlineInstructions, String onlineInstructions, 
 			String endLearningMessage, Integer passMark, boolean showReport, boolean showFeedback, boolean retries, Set mcQueContents, Set mcSessions, 
@@ -308,14 +308,6 @@
         this.runOffline = runOffline;
     }
 
-    public String getCreationDate() {
-        return this.creationDate;
-    }
-
-    public void setCreationDate(String creationDate) {
-        this.creationDate = creationDate;
-    }
-
     public Date getUpdateDate() {
         return this.updateDate;
     }
@@ -485,4 +477,16 @@
 	public void setMcAttachments(Set mcAttachments) {
 		this.mcAttachments = mcAttachments;
 	}
+	/**
+	 * @return Returns the creationDate.
+	 */
+	public Date getCreationDate() {
+		return creationDate;
+	}
+	/**
+	 * @param creationDate The creationDate to set.
+	 */
+	public void setCreationDate(Date creationDate) {
+		this.creationDate = creationDate;
+	}
 }