The "xwikiattrecyclebin" Table

The xwikiattrecyclebin table corresponds to the com.xpn.xwiki.doc.DeletedAttachment class and it stores information about deleted attachments.

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

<class name="com.xpn.xwiki.doc.DeletedAttachment" table="xwikiattrecyclebin" mutable="false">
 <id name="id" column="XDA_ID">
   <generator class="native" />
 </id>
 <natural-id mutable="false">
   <!-- We use docId because most databases do not support indexes on lengthy columns. -->
   <property name="docId" column="XDA_DOCID" type="long" />
   <property name="filename" column="XDA_FILENAME" type="string" length="255" index="XDA_FILENAME" />
   <property name="date" type="timestamp" column="XDA_DATE" index="XDA_DATE" />
 </natural-id>
 <property name="docName" column="XDA_DOC_NAME" type="string" length="255" index="XDA_DOC_NAME" />
 <property name="deleter" type="string" column="XDA_DELETER" index="XDA_DELETER" />
 <property name="xml" type="materialized_clob" column="XDA_XML" not-null="true" length="1000000000" />
</class>

The columns of the xwikiattrecyclebin table are:

ColumnData typeClass propertyDefault valuenot-nullIndex
XDA_ID (primary key and auto incremented)
bigint(20)
-
0
true
-
XDA_DOCID (unique)bigint(20)docId-trueXDA_DOCID
XDA_FILENAME (unique)varchar(255)filename-trueXDA_FILENAME
XDA_DATE (unique)datetimedate0000-00-00 00:00:00trueXDA_DATE
XDA_DOC_NAMEvarchar(255)docNamenullfalseXDA_DOC_NAME
XDA_DELETERvarchar(255)deleternullfalseXDA_DELETER
XDA_XMLlongtextxml-true-

    

Search this space