The "xwikirecyclebin" Table

The xwikirecyclebin table corresponds to the com.xpn.xwiki.doc.XWikiDeletedDocument class and it stores the list of documents deleted from the wiki.

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

<class name="com.xpn.xwiki.doc.XWikiDeletedDocument" table="xwikirecyclebin" mutable="false">
 <id name="id" column="XDD_ID">
   <generator class="native" />
 </id>
 <natural-id mutable="false">
   <property name="fullName" column="XDD_FULLNAME" type="string" length="255" />
   <property name="language" column="XDD_LANGUAGE" type="string" length="5" index="XDD_LANGUAGE" />
   <property name="date" type="timestamp" column="XDD_DATE" index="XDD_DATE" />
 </natural-id>
 <property name="deleter" type="string" column="XDD_DELETER" index="XDD_DELETER" />
 <property name="xml" type="materialized_clob" column="XDD_XML" not-null="true" length="1000000000" />
</class>

The columns of the xwikirecyclebin table are:

ColumnData typeClass propertyDefault valuenot-nullIndex
XDD_ID (primary key, auto incremented)bigint(20)-0true-
XDD_FULLNAME (unique)varchar(255)fullName-true-
XDD_LANGUAGE (unique)varchar(5)language-trueXDD_LANGUAGE
XDD_DATE (unique)datetimedate0000-00-00 00:00:00trueXDD_DATE
XDD_DELETERvarchar(255)deleternullfalseXDD_DELETER
XDD_XMLlongtextxml-true-

  

Related Pages

Trying to decide between Cloud and On Premise? See the comparison on the XWiki Help Center.

Search this space