The "xwikicomments" Table

The xwikicomments table stores data from "XWiki.XWikiComments" objects.

For the moment, the "XWikiComments" class is not using the xwiki.hbm.xml custom mapping, so the xwikicomments table will be empty.

The mapping information is available in the xwiki.hbm.xml file:

<!-- XWikiComments custom mapping -->
<class entity-name="XWiki.XWikiComments" table="xwikicomments">
 <id name="id" type="long" unsaved-value="undefined">
   <column name="XWC_ID" not-null="true" />
   <generator class="assigned" />
 </id>
 <property name="author" type="string" column="XWC_AUTHOR" length="255" index="COMMENT_AUTHOR" />
 <property name="highlight" type="text" column="XWC_HIGHLIGHT" length="60000" />
 <property name="comment" type="text" column="XWC_COMMENT" length="60000" />
 <property name="replyto" type="integer" column="XWP_REPLYTO" index="COMMENT_REPLYTO" />
 <property name="date" type="timestamp" column="XWP_DATE" index="COMMENT_DATE" />
</class>

The columns of the xwikicomments table are:

ColumnData typeClass propertyDefault valuenot-nullIndex
XWC_ID (primary key)bigint(20)-0true-
XWC_AUTHORvarchar(255)authornullfalseCOMMENT_AUTHOR
XWC_HIGHLIGHTlongtexthighlightnullfalse-
XWC_COMMENTlongtextcommentnullfalse-
XWP_REPLYTOint(11)replytonullfalseCOMMENT_REPLYTO
XWP_DATEdatetimedate0000-00-00 00:00:00-COMMENT_DATE

    

Related Pages

Search this space