XWiki Rcs (xwikircs)
Last modified by Thomas Mortagne on 2025/02/18
Table used to store the history of pages.
XWiki 17.1.0+
The full history content is stored. XWiki used to store diff, and only every 5 versions a full content, but we decided that the cration of the diff was too expensive for too little benefit.
To compensate, the xwikirsc table is now:
- COMPRESSED by default in MySQL/MariaDB
- for Oracle is possible to enable the compression using the `xwiki.compressionAllowed` property in the hibernate.cfg.xml using <property name="xwiki.compressionAllowed">true</property>
| xwikircs | |||||||
|---|---|---|---|---|---|---|---|
| Column Name | Datatype | Not null | auto inc | flags | Default value | Comments | |
| XWR_DOCID | BIGINT(20) | 0 | |||||
| XWR_VERSION1 | INTEGER | 0 | |||||
| XWR_VERSION2 | INTEGER | 0 | |||||
| XWR_DATE | DATETIME | 0000-00-00 00:00:00 | |||||
| XWR_COMMENT | TEXT | ||||||
| XWR_AUTHOR | VARCHAR(255) | ||||||
| XWR_ISDIFF | BIT | null | |||||
| XWR_PATCH | LONGTEXT | null | |||||
