Wiki source code of XWiki Database Schema
Version 140.1 by Thomas Mortagne on 2017/01/24
Hide last authors
| author | version | line-number | content |
|---|---|---|---|
 |
101.1 | 1 | This diagram shows the mappings of internal classes to database tables. |
| 2 | The tables are shown with the table name on the left top and the Java class name on the right top. | ||
 |
103.4 | 3 | In the left column you can find the names of the columns in the table and in the right column you can find the get methods in the class for accessing those values. |
| |
101.1 | 4 | In a hibernate query you can use the same name as the get method but without the get and with the first letter lowercase so the SQL query: |
| 5 | {{code language="sql"}}SELECT doc.XWD_TITLE FROM xwikidoc AS doc WHERE doc.XWD_FULLNAME = 'Main.WebHome'{{/code}} | ||
| 6 | is equivalent to the HQL query: | ||
| 7 | {{code language="sql"}}SELECT doc.title FROM XWikiDocument AS doc WHERE doc.fullName = 'Main.WebHome'{{/code}} | ||
| 8 | because ##XWD_TITLE## maps to ##getTitle()## which maps to ##title##. | ||
| 9 | |||
 |
132.1 | 10 | {{image reference="database-90000.png"/}} |
| |
101.1 | 11 | |
 |
107.1 | 12 | Following are all of the tables that make up the XWiki database schema. Just taking a brief look at the schema's tables can give you a clue to how the underlying system works. Roughly, in order to support defining data types dynamically, the documents metadata are stored in a table, the objects are stored in another table and then the values of the properties of the objects are stored each in their own table, depending on the type of property. |
 |
1.1 | 13 | |
| 14 | Note that there may be minor variances for databases other than MySQL, but if so, they have not yet been documented. | ||
| 15 | |||
| |
123.1 | 16 | You can also access the raw {{scm path="xwiki-platform-core/xwiki-platform-oldcore/src/main/resources/xwiki.hbm.xml"}}Hibernate mapping file{{/scm}}. In your XWiki installation this file is bundled inside the ##WEB-INF/lib/xwiki-platform-legacy-oldcore*.jar## (or ##WEB-INF/lib/xwiki-platform-oldcore*.jar##), along with specific mapping files for various databases. |
| 17 | |||
 |
99.2 | 18 | = Tables = |
| |
1.1 | 19 | |
 |
43.1 | 20 | In alphabetical order |
| |
102.1 | 21 | (% style="width:99%" %) |
| |
99.2 | 22 | | (((* [[xwikiattachment>>DevGuide.DsXWikiAttachment]] |
| |
99.1 | 23 | * [[xwikiattachment_archive>>DevGuide.XWikiAttachmentArchive]] |
| 24 | * [[xwikiattachment_content>>DevGuide.DsXWikiAttachmentContent]] | ||
| 25 | * [[xwikiattrecyclebin>>DevGuide.DsXwikiRecycleBin]] | ||
| 26 | * [[xwikidates>>DevGuide.DsXWikiDates]] | ||
| 27 | * [[xwikidbversion>>DevGuide.DsXWikiDbVersion]] | ||
| 28 | * [[xwikidoc>>DevGuide.DsXWikiDoc]] | ||
| 29 | * [[xwikidoubles>>DevGuide.DsXWikiDoubles]] | ||
| 30 | * [[xwikifloats>>DevGuide.DsXWikiFloats]] | ||
| 31 | * [[xwikiintegers>>DevGuide.DsXWikiIntegers]] | ||
| 32 | * [[xwikilargestrings>>DevGuide.DsXWikiLargeStrings]] | ||
| |
99.2 | 33 | * [[xwikilinks>>DevGuide.DsXWikiLinks]]))) | (((* [[xwikilistitems>>DevGuide.DsXWikiListItems]] |
| |
99.1 | 34 | * [[xwikilists>>DevGuide.DsXWikiLists]] |
| 35 | * [[xwikilock>>DevGuide.DsXWikiLocks]] | ||
| 36 | * [[xwikilongs>>DevGuide.DsXWikiLongs]] | ||
| 37 | * [[xwikiobjects>>DevGuide.DsXWikiObjects]] | ||
| 38 | * [[xwikiproperties>>DevGuide.DsXWikiProperties]] | ||
| 39 | * [[xwikiircs>>DevGuide.DsXWikiIrcs]] | ||
| 40 | * [[xwikirecyclebin>>DevGuide.DsXwikiRecyleBin]] | ||
| |
109.1 | 41 | * [[xwikispace>>DevGuide.DsXwikiSpace]] |
| |
99.1 | 42 | * [[xwikistringclasses>>DevGuide.DsXWikiStringClasses]] |
 |
105.1 | 43 | * [[xwikistrings>>DevGuide.DsXWikiStrings]] |
| 44 | * [[xwikistringlists>>DevGuide.DsXWikiStringLists]]))) | ||
| |
99.2 | 45 | |
| |
102.1 | 46 | == Tables used for custom mapping of XWiki classes == |
| 47 | (% style="width:99%" %) | ||
| 48 | | (((* [[xwikicomments>>DevGuide.DsXwikiComments]] | ||
| 49 | * [[xwikipreferences>>DevGuide.DsXWikiPreferences]]))) | ||
| 50 | |||
| |
103.4 | 51 | Note: Custom mapping of comments is disabled by default so the ##xwikicomments## table will be empty. |
| |
102.1 | 52 | |
| 53 | == Tables used by the statistics plugin == | ||
| 54 | If the stats plugin is not enabled then these will be empty. | ||
| 55 | (% style="width:99%" %) | ||
| 56 | | (((* [[xwikistatsdoc>>DevGuide.DsXWikiDocumentStats]] | ||
| 57 | * [[xwikistatsreferer>>DevGuide.DsXWikiRefererStats]] | ||
| 58 | * [[xwikistatsvisit>>DevGuide.XWikiVisits]]))) | ||
| 59 | |||
| 60 | == Tables used in the deprecated table class property system == | ||
| 61 | These are not used anymore, class information is now stored in XML format in the ##XWD_CLASS_XML## column in the ##xwikidoc## table. | ||
| 62 | (% style="width:99%" %) | ||
| 63 | | (((* [[xwikibooleanclasses>>DevGuide.DsXWikiBooleanClasses]] | ||
| 64 | * [[xwikiclasses>>DevGuide.DsXWikiClasses]] | ||
| 65 | * [[xwikiclassesprop>>DevGuide.DsXWikiClassesProp]] | ||
| 66 | * [[xwikidateclasses>>DevGuide.DsXWikiDateClasses]] | ||
| 67 | * [[xwikidblistclasses>>DevGuide.DsXWikiDatabaseListClasses]] | ||
| |
103.3 | 68 | * [[xwikinumberclasses>>DevGuide.DsXWikiNumberClasses]] |
| |
103.2 | 69 | * xwikilistclasses |
| 70 | * xwikistringclasses | ||
| |
103.3 | 71 | ))) |
| |
102.1 | 72 | |
| |
99.2 | 73 | {{velocity}} |
| |
102.1 | 74 | $xcontext.setCacheDuration(100000) |
| |
99.1 | 75 | {{/velocity}} |
