working on struts/hibernate for content-admin
[mir.git] / source / mir / core / model / Comment.hbm.xml
index 69126ff..b834a02 100755 (executable)
 <class 
     name="mir.core.model.Comment" 
     table="comment"
+    proxy="mir.core.model.IComment"
 >
     <id
         name="id"
         type="int"
         column="id"
+        unsaved-value="0"
     >
         <generator class="sequence">
                <param name="sequence">comment_id_seq</param> 
         </generator>
     </id>
+
     <property
         name="title"
         type="java.lang.String"
@@ -46,6 +49,7 @@
         not-null="true"
         sql-type="text" 
     />
+
     <property
         name="mainUrl"
         type="java.lang.String"
@@ -70,6 +74,7 @@
         column="phone"
         length="20"
     />
+
     <property
         name="webdbCreate"
         type="java.sql.Timestamp"
@@ -77,6 +82,7 @@
         not-null="true"
         length="8"
     />
+
     <property
         name="published"
         type="boolean"
         not-null="true"
         length="1"
     />
-    <property
-        name="toLanguage"
-        type="int"
-        column="to_language"
-        not-null="true"
-        length="4"
-    />
-    <property
-        name="toMedia"
-        type="int"
-        column="to_media"
-        not-null="true"
-        length="4"
-    />
-    <property
-        name="toCommentStatus"
-        type="short"
-        column="to_comment_status"
-        length="2"
-    />
+
     <property
         name="checksum"
         type="int"
         column="checksum"
         length="4"
     />
+
     <property
         name="html"
         type="boolean"
     />
 
     <!-- associations -->
+   
+    <many-to-one
+        name="language"
+        class="mir.core.model.Language"
+        column="to_language"
+    />
+
+    <!-- dont know why but with Media it does not work -->
+    <many-to-one
+        name="media"
+        class="mir.core.model.Content"
+        column="to_media"
+    />
+
+    <many-to-one
+        name="commentStatus"
+        class="mir.core.model.CommentStatus"
+        column="to_comment_status"
+    />    
 
 </class>
 </hibernate-mapping>