restoring head

[mir.git] / source / org / codecoop / mir / core / model / Media.hbm.xml

diff --git a/source/org/codecoop/mir/core/model/Media.hbm.xml b/source/org/codecoop/mir/core/model/Media.hbm.xml
new file mode 100755 (executable)
index 0000000..f5dd7ce
--- /dev/null
+++ b/source/org/codecoop/mir/core/model/Media.hbm.xml
@@ -0,0 +1,111 @@
+<?xml version="1.0"?>
+<!DOCTYPE hibernate-mapping PUBLIC
+    "-//Hibernate/Hibernate Mapping DTD 2.0//EN"
+    "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd" >   
+
+<hibernate-mapping>
+       <class 
+               name="org.codecoop.mir.core.model.Media" 
+               table="media">
+               <id
+                       column="id"
+                       name="id"
+                       type="java.lang.Integer"
+               >
+                       <generator class="native">
+                               <param name="sequence">media_id_seq</param>
+                       </generator>
+               </id>
+               <property
+                       column="title"
+                       length="255"
+                       name="title"
+                       type="java.lang.String"
+                />             
+               <property
+                       name="description"
+                       type="java.lang.String">
+                       <column name="description" sql-type="text"/>
+               </property>             
+               <property
+                       column="creator"
+                       length="80"
+                       name="creator"
+                       type="java.lang.String"
+                />
+               <property
+                       column="creator_main_url"
+                       length="255"
+                       name="creatorMainUrl"
+                       type="java.lang.String"
+                />
+               <property
+                       column="creator_email"
+                       length="80"
+                       name="creatorEmail"
+                       type="java.lang.String"
+                />
+               <property
+                       column="creator_address"
+                       length="80"
+                       name="creatorAddress"
+                       type="java.lang.String"
+                />
+               <property
+                       column="creator_phone"
+                       length="80"
+                       name="creatorPhone"
+                       type="java.lang.String"
+                />
+               <property
+                       column="internal_comment"
+                       length="255"
+                       name="internalComment"
+                       type="java.lang.String"
+                />
+               <property
+                       column="is_produced"
+                       length="1"
+                       name="produced"
+                       not-null="true"
+                       type="boolean"
+                />
+               <property
+                       column="creation_date"
+                       length="8"
+                       name="creationDate"
+                       not-null="true"
+                       type="java.sql.Timestamp"
+                />
+               <property
+                       column="last_change"
+                       length="8"
+                       name="lastChange"
+                       type="java.sql.Timestamp"
+                />              
+               <many-to-one
+                       class="org.codecoop.mir.core.model.User"
+                       column="to_publisher"
+                       name="publisher"
+                       foreign-key="fk_media_user"
+                />              
+               <map 
+                       name="relatedMedias" 
+                       table="media_x_media" 
+                       lazy="true" 
+                       inverse="false" 
+                       cascade="save-update">
+                       <key 
+                               column="source_media_id" 
+                               foreign-key="fk_mediaxmedia_sourcemedia"/>
+                       <index-many-to-many 
+                               column="related_media_id" 
+                               class="org.codecoop.mir.core.model.Media" 
+                               foreign-key="fk_mediaxmedia_relatedmedia"/>
+                       <many-to-many 
+                               column="media_relation_type_id" 
+                               class="org.codecoop.mir.core.model.MediaRelationType"
+                               foreign-key="fk_mediaxmedia_mediarelationtype"/>
+               </map>
+       </class>
+</hibernate-mapping>