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-

    

Related Pages

Search this space

 

Most popular tags

Failed to execute the [groovy] macro
  1. access rights
  2. activity stream
  3. annotation
  4. attachment
  5. comment
  6. Document Tree Macro
  7. export
  8. Extension Manager
  9. Flamingo skin
  10. global user
  11. Groovy event listener
  12. group
  13. nested page
  14. search
  15. skin
  16. syntax
  17. user
  18. user profile
  19. velocity macros
  20. wiki
  21. wysiwyg
  22. XWiki Applications
  23. xwikiattachment_archive table
  24. xwikiattachment table
  25. xwikiattrecyclebin table
  26. xwikiproperties table

[Display all tags from this space]