Wiki source code of DatabaseSchema
Version 92.1 by Helmut Nagy on 2009/02/13
Hide last authors
| author | version | line-number | content |
|---|---|---|---|
 |
1.1 | 1 | 1 XWiki Database Schema |
| 2 | |||
 |
89.1 | 3 | #info("The schema below is updated to my 1.7.1 version (3 tables missing) but it should be revised by someone how knows what he is doing :)") |
| |
1.6 | 4 | |
| |
1.1 | 5 | 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. |
| 6 | |||
| 7 | Note that there may be minor variances for databases other than MySQL, but if so, they have not yet been documented. | ||
| 8 | |||
| 9 | 1.1 Tables | ||
| 10 | |||
| |
43.1 | 11 | In alphabetical order |
| 12 | |||
| |
1.1 | 13 | <table width="100%"> |
| 14 | <tr> | ||
| 15 | <td style="border-bottom:0px"> | ||
| |
50.1 | 16 | * [xwikiattachment>DevGuide.DsXWikiAttachment] |
| |
52.1 | 17 | * [xwikiattachment_archive>DevGuide.XWikiAttachmentArchive] |
| |
53.1 | 18 | * [xwikiattachment_content>DevGuide.DsXWikiAttachmentContent] |
| |
83.1 | 19 | * [xwikiattrecyclebin>DevGuide.DsXwikiRecycleBin] |
| |
60.1 | 20 | * [xwikibooleanclasses>DevGuide.DsXWikiBooleanClasses] |
| |
55.1 | 21 | * [xwikiclasses>DevGuide.DsXWikiClasses] |
| |
56.1 | 22 | * [xwikiclassesprop>DevGuide.DsXWikiClassesProp] |
| |
85.1 | 23 | * [xwikicomments>DevGuide.DsXwikiComments] |
| |
62.1 | 24 | * [xwikidateclasses>DevGuide.DsXWikiDateClasses] |
| |
72.1 | 25 | * [xwikidates>DevGuide.DsXWikiDates] |
| |
64.1 | 26 | * [xwikidblistclasses>DevGuide.DsXWikiDatabaseListClasses] |
| |
87.1 | 27 | * [xwikidbversion>DevGuide.DsXWikiDbVersion] |
| |
46.1 | 28 | * [xwikidoc>DevGuide.DsXWikiDoc] |
| |
73.1 | 29 | * [xwikidoubles>DevGuide.DsXWikiDoubles] |
| |
74.1 | 30 | * [xwikifloats>DevGuide.DsXWikiFloats] |
| |
76.1 | 31 | * [xwikiintegers>DevGuide.DsXWikiIntegers] |
| |
72.1 | 32 | * [xwikilargestrings>DevGuide.DsXWikiLargeStrings] |
| |
49.1 | 33 | * [xwikilinks>DevGuide.DsXWikiLinks] |
| |
44.1 | 34 | </td> |
| 35 | <td style="border-bottom:0px"> | ||
| |
79.1 | 36 | * [xwikilistitems>DevGuide.DsXWikiListItems] |
| |
80.1 | 37 | * [xwikilists>DevGuide.DsXWikiLists] |
| |
48.1 | 38 | * [xwikilock>DevGuide.DsXWikiLocks] |
| |
78.1 | 39 | * [xwikilongs>DevGuide.DsXWikiLongs] |
| |
63.1 | 40 | * [xwikinumberclasses>DevGuide.DsXWikiNumberClasses] |
| |
66.1 | 41 | * [xwikiobjects>DevGuide.DsXWikiObjects] |
| |
90.1 | 42 | * [xwikipreferences>DevGuide.DsXWikiPreferences] |
| |
67.1 | 43 | * [xwikiproperties>DevGuide.DsXWikiProperties] |
| |
90.1 | 44 | * [xwikiircs>DevGuide.DsXWikiIrcs] |
| |
91.1 | 45 | * [xwikirecyclebin>DevGuide.DsXwikiRecyleBin] |
| |
82.1 | 46 | * [xwikislistclasses>DevGuide.DsXWikiListClasses] |
| |
81.1 | 47 | * [xwikistatsdoc>DevGuide.DsXWikiDocumentStats] |
| 48 | * [xwikistatsreferer>DevGuide.DsXWikiRefererStats] | ||
| 49 | * [xwikistatsvisit>DevGuide.XWikiVisits] | ||
| |
58.1 | 50 | * [xwikistringclasses>DevGuide.DsXWikiStringClasses] |
| |
69.1 | 51 | * [xwikistrings>DevGuide.DsXWikiStrings] |
| |
1.1 | 52 | </td> |
| 53 | </tr> | ||
| 54 | </table> | ||
 |
1.8 | 55 | $context.setCacheDuration(100000) |
| |
89.1 | 56 |
