rebuilding head
[mir.git] / source / mir / core / model / Audio.hbm.xml
index 771ccf6..b4e08d5 100755 (executable)
-<?xml version="1.0"?>\r
-<!DOCTYPE hibernate-mapping PUBLIC\r
-    "-//Hibernate/Hibernate Mapping DTD//EN"\r
-    "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd" >\r
-    \r
-<hibernate-mapping>\r
-\r
-<!-- \r
-    Created by Middlegen Hibernate plugin\r
-\r
-    http://boss.bekk.no/boss/middlegen/\r
-    http://hibernate.sourceforge.net/\r
--->\r
-\r
-<class \r
-    name="mir.core.model.Audio" \r
-    table="audio"\r
->\r
-    <id\r
-        name="id"\r
-        type="int"\r
-        column="id"\r
-    >\r
-       <generator class="sequence"/>\r
-    </id>\r
-    <property\r
-        name="title"\r
-        type="java.lang.String"\r
-        column="title"\r
-        not-null="true"\r
-        length="80"\r
-    />\r
-    <property\r
-        name="subtitle"\r
-        type="java.lang.String"\r
-        column="subtitle"\r
-        length="30"\r
-    />\r
-    <property\r
-        name="edittitle"\r
-        type="java.lang.String"\r
-        column="edittitle"\r
-        length="30"\r
-    />\r
-    <property\r
-        name="date"\r
-        type="java.lang.String"\r
-        column="date"\r
-        not-null="true"\r
-        length="8"\r
-    />\r
-    <property\r
-        name="creator"\r
-        type="java.lang.String"\r
-        column="creator"\r
-        length="80"\r
-    />\r
-    <property\r
-        name="creatorMainUrl"\r
-        type="java.lang.String"\r
-        column="creator_main_url"\r
-        length="255"\r
-    />\r
-    <property\r
-        name="creatorEmail"\r
-        type="java.lang.String"\r
-        column="creator_email"\r
-        length="80"\r
-    />\r
-    <property\r
-        name="creatorAddress"\r
-        type="java.lang.String"\r
-        column="creator_address"\r
-        length="80"\r
-    />\r
-    <property\r
-        name="creatorPhone"\r
-        type="java.lang.String"\r
-        column="creator_phone"\r
-        length="20"\r
-    />\r
-    <property\r
-        name="description"\r
-        type="java.lang.String"\r
-        column="description"\r
-        length="-1"\r
-    />\r
-    <property\r
-        name="keywords"\r
-        type="java.lang.String"\r
-        column="keywords"\r
-        length="-1"\r
-    />\r
-    <property\r
-        name="comment"\r
-        type="java.lang.String"\r
-        column="comment"\r
-        length="-1"\r
-    />\r
-    <property\r
-        name="source"\r
-        type="java.lang.String"\r
-        column="source"\r
-        length="255"\r
-    />\r
-    <property\r
-        name="publishDate"\r
-        type="java.sql.Timestamp"\r
-        column="publish_date"\r
-        length="8"\r
-    />\r
-    <property\r
-        name="publishServer"\r
-        type="java.lang.String"\r
-        column="publish_server"\r
-        length="255"\r
-    />\r
-    <property\r
-        name="publishPath"\r
-        type="java.lang.String"\r
-        column="publish_path"\r
-        length="255"\r
-    />\r
-    <property\r
-        name="isPublished"\r
-        type="boolean"\r
-        column="is_published"\r
-        not-null="true"\r
-        length="1"\r
-    />\r
-    <property\r
-        name="isProduced"\r
-        type="boolean"\r
-        column="is_produced"\r
-        not-null="true"\r
-        length="1"\r
-    />\r
-    <property\r
-        name="webdbCreate"\r
-        type="java.sql.Timestamp"\r
-        column="webdb_create"\r
-        not-null="true"\r
-        length="8"\r
-    />\r
-    <property\r
-        name="webdbLastchange"\r
-        type="java.sql.Timestamp"\r
-        column="webdb_lastchange"\r
-        length="8"\r
-    />\r
-       <property\r
-        name="iconIsProduced"\r
-        type="boolean"\r
-        column="icon_is_produced"\r
-        not-null="true"\r
-        length="1"\r
-    />\r
-    <property\r
-        name="iconPath"\r
-        type="java.lang.String"\r
-        column="icon_path"\r
-        length="255"\r
-    />   \r
-    <property\r
-        name="kbits"\r
-        type="short"\r
-        column="kbits"\r
-        length="2"\r
-    />     \r
-    <!-- associations -->\r
-    <one-to-one\r
-        name="feature"\r
-        class="mir.core.model.Feature"\r
-        column="to_feature"\r
-    />\r
-    <one-to-one\r
-        name="mediaFolder"\r
-        class="mir.core.model.MediaFolder"\r
-        column="to_media_folder"\r
-    />\r
-    <one-to-one\r
-        name="mediaType"\r
-        class="mir.core.model.MediaType"\r
-        column="to_media_type"\r
-    />\r
-    <one-to-one\r
-        name="publisher"\r
-        class="mir.core.model.MirUser"\r
-        column="to_publisher"\r
-    />\r
-    <one-to-one\r
-        name="language"\r
-        class="mir.core.model.Language"\r
-        column="to_language"\r
-    />\r
-    <one-to-one\r
-        name="rights"\r
-        class="mir.core.model.Rights"\r
-        column="to_rights"\r
-    />\r
-    <set name="content" table="content_x_media" lazy="true">\r
-           <key column="media_id"/>\r
-           <many-to-many column="content_id" class="mir.core.model.Content"/>\r
-       </set>\r
-    \r
-</class>\r
-</hibernate-mapping>\r
+<?xml version="1.0"?>
+<!DOCTYPE hibernate-mapping PUBLIC
+    "-//Hibernate/Hibernate Mapping DTD//EN"
+    "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd" >
+    
+<hibernate-mapping>
+
+<!-- 
+    Created by Middlegen Hibernate plugin
+
+    http://boss.bekk.no/boss/middlegen/
+    http://hibernate.sourceforge.net/
+-->
+
+<class 
+    name="mir.core.model.Audio" 
+    table="audio"
+>
+    <id
+        name="id"
+        type="int"
+        column="id"
+    >
+        <generator class="sequence">
+               <param name="sequence">media_id_seq</param> 
+        </generator>
+    </id>
+    <property
+        name="title"
+        type="java.lang.String"
+        column="title"
+        not-null="true"
+        length="80"
+    />
+    <property
+        name="subtitle"
+        type="java.lang.String"
+        column="subtitle"
+        length="30"
+    />
+    <property
+        name="edittitle"
+        type="java.lang.String"
+        column="edittitle"
+        length="30"
+    />
+    <property
+        name="date"
+        type="java.lang.String"
+        column="date"
+        not-null="true"
+        length="8"
+    />
+    <property
+        name="creator"
+        type="java.lang.String"
+        column="creator"
+        length="80"
+    />
+    <property
+        name="creatorMainUrl"
+        type="java.lang.String"
+        column="creator_main_url"
+        length="255"
+    />
+    <property
+        name="creatorEmail"
+        type="java.lang.String"
+        column="creator_email"
+        length="80"
+    />
+    <property
+        name="creatorAddress"
+        type="java.lang.String"
+        column="creator_address"
+        length="80"
+    />
+    <property
+        name="creatorPhone"
+        type="java.lang.String"
+        column="creator_phone"
+        length="20"
+    />
+    <property
+        name="description"
+        type="java.lang.String"
+        column="description"
+        sqltype="text"
+    />
+    <property
+        name="comment"
+        type="java.lang.String"
+        column="comment"
+               sql-type="text" 
+    />
+    <property
+        name="source"
+        type="java.lang.String"
+        column="source"
+        length="255"
+    />
+    <property
+        name="publishDate"
+        type="java.sql.Timestamp"
+        column="publish_date"
+        length="8"
+    />
+    <property
+        name="publishServer"
+        type="java.lang.String"
+        column="publish_server"
+        length="255"
+    />
+    <property
+        name="publishPath"
+        type="java.lang.String"
+        column="publish_path"
+        length="255"
+    />
+    <property
+        name="published"
+        type="boolean"
+        column="is_published"
+        not-null="true"
+        length="1"
+    />
+    <property
+        name="produced"
+        type="boolean"
+        column="is_produced"
+        not-null="true"
+        length="1"
+    />
+    <property
+        name="webdbCreate"
+        type="java.sql.Timestamp"
+        column="webdb_create"
+        not-null="true"
+        length="8"
+    />
+    <property
+        name="webdbLastchange"
+        type="java.sql.Timestamp"
+        column="webdb_lastchange"
+        length="8"
+    />
+       <property
+        name="iconIsProduced"
+        type="boolean"
+        column="icon_is_produced"
+        not-null="true"
+        length="1"
+    />
+    <property
+        name="iconPath"
+        type="java.lang.String"
+        column="icon_path"
+        length="255"
+    />   
+    <property
+        name="kbits"
+        type="short"
+        column="kbits"
+        length="2"
+    />     
+    <!-- associations -->
+    <many-to-one
+        name="mediaType"
+        class="mir.core.model.MediaType"
+        column="to_media_type"
+    />    
+    <many-to-one
+        name="mediaFolder"
+        class="mir.core.model.MediaFolder"
+        column="to_media_folder"
+    />
+    <many-to-one
+        name="publisher"
+        class="mir.core.model.MirUser"
+        column="to_publisher"
+    />
+    <many-to-one
+        name="language"
+        class="mir.core.model.Language"
+        column="to_language"
+    />
+    <many-to-one
+        name="rights"
+        class="mir.core.model.Rights"
+        column="to_rights"
+    /> 
+    <set name="content" table="content_x_media" lazy="true">
+           <key column="media_id"/>
+           <many-to-many column="content_id" class="mir.core.model.Content"/>
+       </set>
+    
+</class>
+</hibernate-mapping>