69126ff3cbfbb57f73d1b35c76aa9666a8d0309d
[mir.git] / source / mir / core / model / Comment.hbm.xml
1 <?xml version="1.0"?>
2 <!DOCTYPE hibernate-mapping PUBLIC
3     "-//Hibernate/Hibernate Mapping DTD//EN"
4     "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd" >
5     
6 <hibernate-mapping>
7
8 <!-- 
9     Created by Middlegen Hibernate plugin
10
11     http://boss.bekk.no/boss/middlegen/
12     http://hibernate.sourceforge.net/
13 -->
14
15 <class 
16     name="mir.core.model.Comment" 
17     table="comment"
18 >
19     <id
20         name="id"
21         type="int"
22         column="id"
23     >
24         <generator class="sequence">
25                 <param name="sequence">comment_id_seq</param> 
26         </generator>
27     </id>
28     <property
29         name="title"
30         type="java.lang.String"
31         column="title"
32         not-null="true"
33         length="255"
34     />
35     <property
36         name="creator"
37         type="java.lang.String"
38         column="creator"
39         not-null="true"
40         length="80"
41     />
42     <property
43         name="description"
44         type="java.lang.String"
45         column="description"
46         not-null="true"
47         sql-type="text" 
48     />
49     <property
50         name="mainUrl"
51         type="java.lang.String"
52         column="main_url"
53         length="255"
54     />
55     <property
56         name="email"
57         type="java.lang.String"
58         column="email"
59         length="80"
60     />
61     <property
62         name="address"
63         type="java.lang.String"
64         column="address"
65         length="80"
66     />
67     <property
68         name="phone"
69         type="java.lang.String"
70         column="phone"
71         length="20"
72     />
73     <property
74         name="webdbCreate"
75         type="java.sql.Timestamp"
76         column="webdb_create"
77         not-null="true"
78         length="8"
79     />
80     <property
81         name="published"
82         type="boolean"
83         column="is_published"
84         not-null="true"
85         length="1"
86     />
87     <property
88         name="toLanguage"
89         type="int"
90         column="to_language"
91         not-null="true"
92         length="4"
93     />
94     <property
95         name="toMedia"
96         type="int"
97         column="to_media"
98         not-null="true"
99         length="4"
100     />
101     <property
102         name="toCommentStatus"
103         type="short"
104         column="to_comment_status"
105         length="2"
106     />
107     <property
108         name="checksum"
109         type="int"
110         column="checksum"
111         length="4"
112     />
113     <property
114         name="html"
115         type="boolean"
116         column="is_html"
117         not-null="true"
118         length="1"
119     />
120
121     <!-- associations -->
122
123 </class>
124 </hibernate-mapping>