Advertisement
Guest User

XWiki hibernate scheme

a guest
Jun 27th, 2012
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
XML 25.93 KB | None | 0 0
  1. <?xml version="1.0" encoding="UTF-8"?>
  2.  
  3. <!--
  4. * See the NOTICE file distributed with this work for additional
  5. * information regarding copyright ownership.
  6. *
  7. * This is free software; you can redistribute it and/or modify it
  8. * under the terms of the GNU Lesser General Public License as
  9. * published by the Free Software Foundation; either version 2.1 of
  10. * the License, or (at your option) any later version.
  11. *
  12. * This software is distributed in the hope that it will be useful,
  13. * but WITHOUT ANY WARRANTY; without even the implied warranty of
  14. * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
  15. * Lesser General Public License for more details.
  16. *
  17. * You should have received a copy of the GNU Lesser General Public
  18. * License along with this software; if not, write to the Free
  19. * Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA
  20. * 02110-1301 USA, or see the FSF site: http://www.fsf.org.
  21. -->
  22.  
  23. <!DOCTYPE hibernate-mapping PUBLIC
  24.  "-//Hibernate/Hibernate Mapping DTD//EN"
  25.  "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
  26. <hibernate-mapping auto-import="true" default-lazy="false">
  27.  
  28.     <!--
  29.     All new table names should be all lower case versions of the name of the class which they represent
  30.     for example:
  31.     XWikiDocument should map to a table called xwikidocument
  32.     All new column names should be all lower case versions of the property which they represent for example:
  33.     fullName should map to a column called fullname
  34.    -->
  35.  
  36.     <!-- com.xpn.xwiki.doc.XWikiDocument root -->
  37.     <class name="com.xpn.xwiki.doc.XWikiDocument" table="xwikidoc">
  38.         <id name="id" type="long" unsaved-value="undefined">
  39.             <column name="XWD_ID" not-null="true"/>
  40.             <generator class="assigned"/>
  41.         </id>
  42.         <property name="fullName" type="string" column="XWD_FULLNAME" length="255" index="DOC_FULLNAME" not-null="true"/>
  43.         <property name="name" type="string" column="XWD_NAME" length="255" index="DOC_NAME" not-null="true"/>
  44.         <property name="title" type="string" column="XWD_TITLE" length="255" index="DOC_TITLE" not-null="true"/>
  45.         <property name="language" type="string" column="XWD_LANGUAGE" index="DOC_LANGUAGE" length="5"/>
  46.         <property name="defaultLanguage" type="string" column="XWD_DEFAULT_LANGUAGE" index="DOC_DEFAULT_LANGUAGE" length="5"/>
  47.         <property name="translation" type="integer" column="XWD_TRANSLATION" not-null="true"/>
  48.         <property name="date" type="timestamp" column="XWD_DATE" index="DOC_DATE" not-null="true"/>
  49.         <property name="contentUpdateDate" type="timestamp" column="XWD_CONTENT_UPDATE_DATE" index="DOC_CONTENT_UPDATE_DATE" not-null="true"/>
  50.         <property name="creationDate" type="timestamp" column="XWD_CREATION_DATE" index="DOC_CREATION_DATE" not-null="true"/>
  51.         <property name="author" type="string" column="XWD_AUTHOR" length="255" index="DOC_AUTHOR" not-null="true"/>
  52.         <property name="contentAuthor" type="string" column="XWD_CONTENT_AUTHOR" length="255" index="DOC_CONTENT_AUTHOR" not-null="true"/>
  53.         <property name="creator" type="string" column="XWD_CREATOR" length="255" index="DOC_CREATOR" not-null="true"/>
  54.         <!-- This property is deprecated and should not be used anymore. Use .space instead. -->
  55.         <property name="web" type="string" update="false" insert="false" column="XWD_WEB" length="255" not-null="true"/>
  56.         <property name="space" type="string" column="XWD_WEB" length="255" index="DOC_SPACE" not-null="true"/>
  57.         <property name="content" type="text" column="XWD_CONTENT" length="200000" not-null="true"/>
  58.         <property name="version" type="string" column="XWD_VERSION" length="255" not-null="true"/>
  59.         <property name="customClass" type="string" column="XWD_CUSTOM_CLASS" length="255" not-null="true"/>
  60.         <property name="parent" type="string" column="XWD_PARENT" length="511" not-null="true"/>
  61.         <property name="xWikiClassXML" type="text" column="XWD_CLASS_XML" length="60000" not-null="false"/>
  62.         <property name="elements" type="integer" not-null="true" column="XWD_ELEMENTS"/>
  63.         <property name="defaultTemplate" type="string" column="XWD_DEFAULT_TEMPLATE" not-null="true"/>
  64.         <property name="validationScript" type="string" column="XWD_VALIDATION_SCRIPT" not-null="true"/>
  65.         <property name="comment" type="string" column="XWD_COMMENT" length="1023" not-null="true"/>
  66.         <property name="minorEdit1" type="boolean" column="XWD_MINOREDIT" index="DOC_MINOREDIT" not-null="true"/>
  67.         <property name="syntaxId" type="string" column="XWD_SYNTAX_ID" length="50"/>
  68.         <property name="hidden" type="boolean" column="XWD_HIDDEN" index="DOC_HIDDEN" not-null="true"/>
  69.     </class>
  70.  
  71.     <class name="com.xpn.xwiki.doc.rcs.XWikiRCSNodeInfo" table="xwikircs">
  72.         <composite-id name="id" class="com.xpn.xwiki.doc.rcs.XWikiRCSNodeId">
  73.             <key-property name="docId" column="XWR_DOCID" type="long"/>
  74.             <key-property name="version1" column="XWR_VERSION1" type="integer"/>
  75.             <key-property name="version2" column="XWR_VERSION2" type="integer"/>
  76.         </composite-id>
  77.         <property name="date" type="timestamp" column="XWR_DATE" index="REV_DATE" not-null="true"/>
  78.         <property name="comment" type="string" column="XWR_COMMENT" not-null="true"/>
  79.         <property name="author" type="string" column="XWR_AUTHOR" index="REV_AUTHOR" not-null="true"/>
  80.         <property name="diff" type="boolean" column="XWR_ISDIFF" index="REV_ISDIFF" not-null="false" update="false" insert="false"/>
  81.     </class>
  82.  
  83.     <class name="com.xpn.xwiki.doc.rcs.XWikiRCSNodeContent" table="xwikircs">
  84.         <composite-id name="id" class="com.xpn.xwiki.doc.rcs.XWikiRCSNodeId">
  85.             <key-property name="docId" column="XWR_DOCID" type="long"/>
  86.             <key-property name="version1" column="XWR_VERSION1" type="integer"/>
  87.             <key-property name="version2" column="XWR_VERSION2" type="integer"/>
  88.         </composite-id>
  89.         <component name="patch">
  90.             <property name="diff" type="boolean" column="XWR_ISDIFF" not-null="false"/>
  91.             <property name="content" type="materialized_clob" column="XWR_PATCH" not-null="false" length="1000000000"/>
  92.         </component>
  93.     </class>
  94.  
  95.     <class name="com.xpn.xwiki.doc.XWikiDeletedDocument" table="xwikirecyclebin" mutable="false">
  96.         <id name="id" column="XDD_ID">
  97.             <generator class="native"/>
  98.         </id>
  99.         <natural-id mutable="false">
  100.             <property name="fullName" column="XDD_FULLNAME" type="string" length="255"/>
  101.             <property name="language" column="XDD_LANGUAGE" type="string" length="5" index="XDD_LANGUAGE"/>
  102.             <property name="date" type="timestamp" column="XDD_DATE" index="XDD_DATE"/>
  103.         </natural-id>
  104.         <property name="deleter" type="string" column="XDD_DELETER" index="XDD_DELETER"/>
  105.         <property name="xml" type="materialized_clob" column="XDD_XML" not-null="true" length="1000000000"/>
  106.     </class>
  107.  
  108.     <class name="com.xpn.xwiki.doc.DeletedAttachment" table="xwikiattrecyclebin" mutable="false">
  109.         <id name="id" column="XDA_ID">
  110.             <generator class="native"/>
  111.         </id>
  112.         <natural-id mutable="false">
  113.             <!-- We use docId because most databases do not support indexes on lengthy columns. -->
  114.             <property name="docId" column="XDA_DOCID" type="long"/>
  115.             <property name="filename" column="XDA_FILENAME" type="string" length="255" index="XDA_FILENAME"/>
  116.             <property name="date" type="timestamp" column="XDA_DATE" index="XDA_DATE"/>
  117.         </natural-id>
  118.         <property name="docName" column="XDA_DOC_NAME" type="string" length="255" index="XDA_DOC_NAME"/>
  119.         <property name="deleter" type="string" column="XDA_DELETER" index="XDA_DELETER"/>
  120.         <property name="xml" type="materialized_clob" column="XDA_XML" not-null="true" length="1000000000"/>
  121.     </class>
  122.  
  123.     <class name="com.xpn.xwiki.doc.XWikiLock" table="xwikilock">
  124.         <id name="docId" type="long" unsaved-value="undefined">
  125.             <column name="XWL_DOC_ID" not-null="true"/>
  126.             <generator class="assigned"/>
  127.         </id>
  128.         <property name="userName" type="string" column="XWL_AUTHOR" length="255"/>
  129.         <property name="date" type="timestamp" column="XWL_DATE" not-null="true"/>
  130.     </class>
  131.  
  132.     <class name="com.xpn.xwiki.doc.XWikiLink" table="xwikilinks">
  133.         <composite-id unsaved-value="undefined">
  134.             <key-property name="docId" column="XWL_DOC_ID" type="long"/>
  135.             <key-property name="link" type="string" length="255">
  136.                 <column name="XWL_LINK" index="XWLNK_LINK"/>
  137.             </key-property>
  138.         </composite-id>
  139.         <property name="fullName" type="string" column="XWL_FULLNAME" length="255"/>
  140.     </class>
  141.  
  142.     <class name="com.xpn.xwiki.doc.XWikiAttachment" table="xwikiattachment">
  143.         <id name="id" type="long" unsaved-value="undefined">
  144.             <column name="XWA_ID" not-null="true"/>
  145.             <generator class="assigned"/>
  146.         </id>
  147.         <property name="docId" type="long" column="XWA_DOC_ID" index="ATT_DOC_ID"/>
  148.         <property name="filename" type="string" column="XWA_FILENAME" length="255" not-null="true"/>
  149.         <property name="filesize" type="integer" column="XWA_SIZE"/>
  150.         <property name="date" type="timestamp" column="XWA_DATE" index="ATT_DATE" not-null="true"/>
  151.         <property name="author" type="string" column="XWA_AUTHOR" length="255" index="ATT_AUTHOR"/>
  152.         <property name="version" type="string" column="XWA_VERSION" length="255" not-null="true"/>
  153.         <property name="comment" type="string" column="XWA_COMMENT" length="255"/>
  154.     </class>
  155.  
  156.     <class name="com.xpn.xwiki.doc.XWikiAttachmentContent" table="xwikiattachment_content">
  157.         <id name="id" type="long" unsaved-value="undefined">
  158.             <column name="XWA_ID" not-null="true"/>
  159.             <generator class="assigned"/>
  160.         </id>
  161.         <property name="content" type="materialized_blob" column="XWA_CONTENT" length="1000000000" not-null="true"/>
  162.     </class>
  163.  
  164.     <class name="com.xpn.xwiki.doc.XWikiAttachmentArchive" table="xwikiattachment_archive">
  165.         <id name="id" type="long" unsaved-value="undefined">
  166.             <column name="XWA_ID" not-null="true"/>
  167.             <generator class="assigned"/>
  168.         </id>
  169.         <property name="archive" type="materialized_blob" column="XWA_ARCHIVE" length="1000000000"/>
  170.     </class>
  171.  
  172.     <class name="com.xpn.xwiki.objects.BaseProperty" table="xwikiproperties">
  173.         <composite-id unsaved-value="undefined">
  174.             <key-property name="id" column="XWP_ID" type="long"/>
  175.             <key-property name="name" type="string">
  176.                 <column name="XWP_NAME" index="PROP_NAME"/>
  177.             </key-property>
  178.         </composite-id>
  179.         <property name="classType" type="string" column="XWP_CLASSTYPE" length="255"/>
  180.  
  181.         <joined-subclass name="com.xpn.xwiki.objects.IntegerProperty" table="xwikiintegers">
  182.             <key>
  183.                 <column name="XWI_ID"/>
  184.                 <column name="XWI_NAME" index="XWINT_NAME"/>
  185.             </key>
  186.             <property name="value" type="integer" column="XWI_VALUE" index="XWINT_VALUE"/>
  187.         </joined-subclass>
  188.  
  189.         <joined-subclass name="com.xpn.xwiki.objects.LongProperty" table="xwikilongs">
  190.             <key>
  191.                 <column name="XWL_ID"/>
  192.                 <column name="XWL_NAME" index="XWLONG_NAME"/>
  193.             </key>
  194.             <property name="value" type="long" column="XWL_VALUE" index="XWLONG_VALUE"/>
  195.         </joined-subclass>
  196.  
  197.         <joined-subclass name="com.xpn.xwiki.objects.FloatProperty" table="xwikifloats">
  198.             <key>
  199.                 <column name="XWF_ID"/>
  200.                 <column name="XWF_NAME" index="XWFLOAT_NAME"/>
  201.             </key>
  202.             <property name="value" type="float" column="XWF_VALUE" index="XWFLOAT_VALUE"/>
  203.         </joined-subclass>
  204.  
  205.         <joined-subclass name="com.xpn.xwiki.objects.DoubleProperty" table="xwikidoubles">
  206.             <key>
  207.                 <column name="XWD_ID"/>
  208.                 <column name="XWD_NAME" index="XWDOUBLE_NAME"/>
  209.             </key>
  210.             <property name="value" type="double" column="XWD_VALUE" index="XWDOUBLE_VALUE"/>
  211.         </joined-subclass>
  212.  
  213.         <joined-subclass name="com.xpn.xwiki.objects.StringProperty" table="xwikistrings">
  214.             <key>
  215.                 <column name="XWS_ID"/>
  216.                 <column name="XWS_NAME" index="XWSTR_NAME"/>
  217.             </key>
  218.             <property name="value" type="string" column="XWS_VALUE" length="255" index="XWSTR_VALUE"/>
  219.         </joined-subclass>
  220.  
  221.         <joined-subclass name="com.xpn.xwiki.objects.DateProperty" table="xwikidates">
  222.             <key>
  223.                 <column name="XWS_ID"/>
  224.                 <column name="XWS_NAME" index="XWDATE_NAME"/>
  225.             </key>
  226.             <property name="value" type="timestamp" column="XWS_VALUE" index="XWDATE_VALUE"/>
  227.         </joined-subclass>
  228.  
  229.         <joined-subclass name="com.xpn.xwiki.objects.LargeStringProperty" table="xwikilargestrings">
  230.             <key>
  231.                 <column name="XWL_ID"/>
  232.                 <column name="XWL_NAME" index="XWLS_NAME"/>
  233.             </key>
  234.             <property name="value" type="text" column="XWL_VALUE" length="60000"/>
  235.         </joined-subclass>
  236.  
  237.         <joined-subclass name="com.xpn.xwiki.objects.StringListProperty" table="xwikilargestrings">
  238.             <key>
  239.                 <column name="XWL_ID"/>
  240.                 <column name="XWL_NAME"/>
  241.             </key>
  242.             <property name="textValue" type="text" column="XWL_VALUE" length="60000"/>
  243.         </joined-subclass>
  244.  
  245.         <joined-subclass name="com.xpn.xwiki.objects.DBStringListProperty" table="xwikilists">
  246.             <key>
  247.                 <column name="XWL_ID"/>
  248.                 <column name="XWL_NAME" index="XWLIST_NAME"/>
  249.             </key>
  250.             <list name="list" table="xwikilistitems" lazy="false">
  251.                 <key>
  252.                     <column name="XWL_ID"/>
  253.                     <column name="XWL_NAME" index="XWLI_NAME"/>
  254.                 </key>
  255.                 <index column="XWL_NUMBER"/>
  256.                 <element type="string">
  257.                     <column name="XWL_VALUE" index="XWLI_VALUE"/>
  258.                 </element>
  259.             </list>
  260.         </joined-subclass>
  261.     </class>
  262.  
  263.     <class name="com.xpn.xwiki.objects.BaseObject" table="xwikiobjects">
  264.         <id name="id" type="long" unsaved-value="undefined">
  265.             <column name="XWO_ID" not-null="true"/>
  266.             <generator class="assigned"/>
  267.         </id>
  268.         <property name="number" type="integer" column="XWO_NUMBER" index="OBJ_NUMBER" not-null="false"/>
  269.         <property name="name" type="string" column="XWO_NAME" index="OBJ_NAME" not-null="true" length="255"/>
  270.         <property name="className" type="string" column="XWO_CLASSNAME" index="OBJ_CLASSNAME" not-null="true" length="255"/>
  271.         <property name="guid" type="string" column="XWO_GUID" not-null="false" length="255"/>
  272.     </class>
  273.  
  274.     <class name="com.xpn.xwiki.stats.impl.DocumentStats" table="xwikistatsdoc">
  275.         <id name="id" type="long" unsaved-value="undefined">
  276.             <column name="XWS_ID" not-null="true"/>
  277.             <generator class="assigned"/>
  278.         </id>
  279.         <property name="number" type="integer" column="XWS_NUMBER" not-null="false"/>
  280.         <property name="name" type="string" column="XWS_NAME" not-null="true" length="255" index="XWDS_NAME"/>
  281.         <!-- Before XWiki 2.2M2 this column was always containing the "internal" string to tell the storage
  282.             implementation Stats objects were special. Starting with XWiki 2.2M2 the check is now on whether the class
  283.             name is empty ("") or null. Thus this column can now contain both "internal" (old stats) and ""
  284.             (new stats) -->
  285.         <property name="className" type="string" column="XWS_CLASSNAME" length="255"/>
  286.         <property name="action" type="string" column="XWS_ACTION" not-null="true" length="255" index="XWDS_ACTION"/>
  287.         <property name="pageViews" type="integer" column="XWS_PAGE_VIEWS" index="XWDS_PAGE_VIEWS" not-null="false"/>
  288.         <property name="uniqueVisitors" type="integer" column="XWS_UNIQUE_VISITORS" index="XWDS_UNIQUE_VISITORS" not-null="false"/>
  289.         <property name="period" type="integer" column="XWS_PERIOD" index="XWDS_PERIOD" not-null="false"/>
  290.         <property name="visits" type="integer" column="XWS_VISITS" index="XWDS_VISITS" not-null="false"/>
  291.     </class>
  292.  
  293.     <class name="com.xpn.xwiki.stats.impl.RefererStats" table="xwikistatsreferer">
  294.         <id name="id" type="long" unsaved-value="undefined">
  295.             <column name="XWR_ID" not-null="true"/>
  296.             <generator class="assigned"/>
  297.         </id>
  298.         <property name="number" type="integer" column="XWR_NUMBER" not-null="false"/>
  299.         <property name="name" type="string" column="XWR_NAME" not-null="true" length="255" index="XWRS_NAME"/>
  300.         <!-- Before XWiki 2.2M2 this column was always containing the "internal" string to tell the storage
  301.             implementation Stats objects were special. Starting with XWiki 2.2M2 the check is now on whether the class
  302.             name is empty ("") or null. Thus this column can now contain both "internal" (old stats) and ""
  303.             (new stats) -->
  304.         <property name="className" type="string" column="XWR_CLASSNAME" length="255"/>
  305.         <property name="referer" type="string" column="XWR_REFERER" not-null="true" length="8192"/>
  306.         <property name="pageViews" type="integer" column="XWR_PAGE_VIEWS" index="XWRS_PAGE_VIEWS" not-null="false"/>
  307.         <property name="period" type="integer" column="XWR_PERIOD" index="XWRS_PERIOD" not-null="false"/>
  308.     </class>
  309.  
  310.     <class name="com.xpn.xwiki.stats.impl.VisitStats" table="xwikistatsvisit">
  311.         <id name="id" type="long" unsaved-value="undefined">
  312.             <column name="XWV_ID" not-null="true"/>
  313.             <generator class="assigned"/>
  314.         </id>
  315.         <property name="number" type="integer" column="XWV_NUMBER" not-null="false"/>
  316.         <property name="name" type="string" column="XWV_NAME" not-null="true" length="255" index="XWVS_NAME"/>
  317.         <!-- Before XWiki 2.2M2 this column was always containing the "internal" string to tell the storage
  318.             implementation Stats objects were special. Starting with XWiki 2.2M2 the check is now on whether the class
  319.             name is empty ("") or null. Thus this column can now contain both "internal" (old stats) and ""
  320.             (new stats) -->
  321.         <property name="className" type="string" column="XWV_CLASSNAME" length="255"/>
  322.         <property name="IP" type="string" column="XWV_IP" not-null="true" length="255" index="XWVS_IP"/>
  323.         <property name="userAgent" type="string" column="XWV_USER_AGENT" not-null="true" length="8192"/>
  324.         <property name="cookie" type="string" column="XWV_COOKIE" not-null="true" length="8192"/>
  325.         <property name="uniqueID" type="string" column="XWV_UNIQUE_ID" index="XWVS_UNIQUE_ID" not-null="true" length="255"/>
  326.         <property name="pageViews" type="integer" column="XWV_PAGE_VIEWS" index="XWVS_PAGE_VIEWS" not-null="false"/>
  327.         <property name="pageSaves" type="integer" column="XWV_PAGE_SAVES" index="XWVS_PAGE_SAVES" not-null="false"/>
  328.         <property name="downloads" type="integer" column="XWV_DOWNLOADS" index="XWVS_DOWNLOADS" not-null="false"/>
  329.         <property name="startDate" type="timestamp" column="XWV_START_DATE" index="XWVS_START_DATE" not-null="false"/>
  330.         <property name="endDate" type="timestamp" column="XWV_END_DATE" index="XWVS_END_DATE" not-null="false"/>
  331.     </class>
  332.  
  333.     <!-- XWikiPreferences custom mapping -->
  334.     <class entity-name="XWiki.XWikiPreferences" table="xwikipreferences">
  335.         <id name="id" type="long" unsaved-value="undefined">
  336.             <column name="XWP_ID" not-null="true"/>
  337.             <generator class="assigned"/>
  338.         </id>
  339.         <property name="language" type="string" column="XWP_LANGUAGE" length="255"/>
  340.         <property name="default_language" type="string" column="XWP_DEFAULT_LANGUAGE" length="255"/>
  341.         <property name="multilingual" type="integer" column="XWP_MULTI_LINGUAL"/>
  342.         <property name="authenticate_edit" type="integer" column="XWP_AUTHENTICATE_EDIT"/>
  343.         <property name="authenticate_view" type="integer" column="XWP_AUTHENTICATE_VIEW"/>
  344.         <property name="auth_active_check" type="integer" column="XWP_AUTH_ACTIVE_CHECK"/>
  345.         <property name="backlinks" type="integer" column="XWP_BACKLINKS"/>
  346.         <property name="skin" type="string" column="XWP_SKIN" length="255"/>
  347.         <property name="stylesheet" type="string" column="XWP_STYLESHEET" length="255"/>
  348.         <property name="stylesheets" type="string" column="XWP_STYLESHEETS" length="255"/>
  349.         <property name="editor" type="string" column="XWP_EDITOR" length="255"/>
  350.         <property name="webcopyright" type="string" column="XWP_WEBCOPYRIGHT" length="255"/>
  351.         <property name="title" type="string" column="XWP_TITLE" length="255"/>
  352.         <property name="version" type="string" column="XWP_VERSION" length="255"/>
  353.         <property name="meta" type="text" column="XWP_META" length="30000"/>
  354.         <property name="use_email_verification" type="integer" column="XWP_USE_EMAIL_VERIFICATION"/>
  355.         <property name="smtp_server" type="string" column="XWP_SMTP_SERVER" length="255"/>
  356.         <property name="admin_email" type="string" column="XWP_ADMIN_EMAIL" length="255"/>
  357.         <property name="validation_email_content" type="text" column="XWP_VALIDATION_EMAIL_CONTENT" length="30000"/>
  358.         <property name="confirmation_email_content" type="text" column="XWP_CONFIRMATION_EMAIL_CONTENT" length="30000"/>
  359.         <property name="invitation_email_content" type="text" column="XWP_INVITATION_EMAIL_CONTENT" length="30000"/>
  360.         <property name="leftPanels" type="string" column="XWP_LEFT_PANELS" length="2000"/>
  361.         <property name="rightPanels" type="string" column="XWP_RIGHT_PANELS" length="2000"/>
  362.         <property name="showLeftPanels" type="integer" column="XWP_SHOW_LEFT_PANELS"/>
  363.         <property name="showRightPanels" type="integer" column="XWP_SHOW_RIGHT_PANELS"/>
  364.         <property name="languages" type="string" column="XWP_LANGUAGES" length="255"/>
  365.         <property name="registration_anonymous" type="string" column="XWP_REGISTRATION_ANONYMOUS" length="255"/>
  366.         <property name="registration_registered" type="string" column="XWP_REGISTRATION_REGISTERED" length="255"/>
  367.         <property name="edit_anonymous" type="string" column="XWP_EDIT_ANONYMOUS" length="255"/>
  368.         <property name="edit_registered" type="string" column="XWP_EDIT_REGISTERED" length="255"/>
  369.         <property name="comment_anonymous" type="string" column="XWP_COMMENT_ANONYMOUS" length="255"/>
  370.         <property name="comment_registered" type="string" column="XWP_COMMENT_REGISTERED" length="255"/>
  371.         <property name="documentBundles" type="string" column="XWP_DOCUMENT_BUNDLES" length="2000"/>
  372.     </class>
  373.  
  374.     <!-- XWikiComments custom mapping -->
  375.     <class entity-name="XWiki.XWikiComments" table="xwikicomments">
  376.         <id name="id" type="long" unsaved-value="undefined">
  377.             <column name="XWC_ID" not-null="true"/>
  378.             <generator class="assigned"/>
  379.         </id>
  380.         <property name="author" type="string" column="XWC_AUTHOR" length="255" index="COMMENT_AUTHOR"/>
  381.         <property name="highlight" type="text" column="XWC_HIGHLIGHT" length="60000"/>
  382.         <property name="comment" type="text" column="XWC_COMMENT" length="60000"/>
  383.         <property name="replyto" type="integer" column="XWP_REPLYTO" index="COMMENT_REPLYTO"/>
  384.         <property name="date" type="timestamp" column="XWP_DATE" index="COMMENT_DATE"/>
  385.     </class>
  386.  
  387.     <!-- XWikiPreferences custom mapping -->
  388.     <!--
  389.    <class entity-name="XWiki.XWikiUsers" table="xwikiusers">
  390.        <id name="id" type="integer" unsaved-value="undefined">
  391.            <column name="XWU_ID" not-null="true" />
  392.            <generator class="assigned" />
  393.        </id>
  394.        <property name="first_name" type="string" unique="false" optimistic-lock="true" lazy="false" generated="never" column="XWU_FIRST_NAME" length="255" not-null="false" />
  395.        <property name="last_name" type="string" unique="false" optimistic-lock="true" lazy="false" generated="never" column="XWU_LAST_NAME" length="255" not-null="false" />
  396.        <property name="email" type="string" unique="false" optimistic-lock="true" lazy="false" generated="never" column="XWU_EMAIL" length="50" />
  397.        <property name="company" type="string" unique="false" optimistic-lock="true" lazy="false" generated="never" column="XWU_COMPANY" length="255" />
  398.        <property name="password" type="string" unique="false" optimistic-lock="true" lazy="false" generated="never" column="XWU_PASSWORD" length="255" />
  399.        <property name="validationKey" type="string" unique="false" optimistic-lock="true" lazy="false" generated="never" column="XWU_VALIDATION_KEY" />
  400.        <property name="skin" type="string" column="XWU_SKIN" length="255" />
  401.        <property name="leftPanels" type="string" column="XWU_LEFT_PANELS" length="2000" />
  402.        <property name="rightPanels" type="string" column="XWU_RIGHT_PANELS" length="2000" />
  403.        <property name="showLeftPanels" type="integer" column="XWU_SHOW_LEFT_PANELS" />
  404.        <property name="showRightPanels" type="integer" column="XWU_SHOW_RIGHT_PANELS" />
  405.        <property name="pageWidth" type="string" column="XWU_PAGE_WIDTH" length="255" />
  406.        <property name="avatar" type="string" column="XWU_AVATAR" length="255" />
  407.    </class>
  408.    -->
  409.  
  410.     <class name="com.xpn.xwiki.store.migration.XWikiDBVersion" table="xwikidbversion">
  411.         <id name="version" type="integer" unsaved-value="undefined">
  412.             <column name="XWV_VERSION" not-null="true"/>
  413.             <generator class="assigned"/>
  414.         </id>
  415.     </class>
  416. </hibernate-mapping>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement