Skip to Content

Wiki source code of DatabaseSchema

Version 80.1 by Helmut Nagy on 2009/02/12
Show last authors
1 1 XWiki Database Schema
2
3 #error("The schema below is out of date. It needs to be updated. Feel free to update it if you know what you're doing :)")
4
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
11 In alphabetical order
12
13 <table width="100%">
14 <tr>
15 <td style="border-bottom:0px">
16 * [xwikiattachment>DevGuide.DsXWikiAttachment]
17 * [xwikiattachment_archive>DevGuide.XWikiAttachmentArchive]
18 * [xwikiattachment_content>DevGuide.DsXWikiAttachmentContent]
19 * xwikiattrecyclebin
20 * [xwikibooleanclasses>DevGuide.DsXWikiBooleanClasses]
21 * [xwikiclasses>DevGuide.DsXWikiClasses]
22 * [xwikiclassesprop>DevGuide.DsXWikiClassesProp]
23 * xwikicomments
24 * [xwikidateclasses>DevGuide.DsXWikiDateClasses]
25 * [xwikidates>DevGuide.DsXWikiDates]
26 * [xwikidblistclasses>DevGuide.DsXWikiDatabaseListClasses]
27 * xwikidbversion
28 * [xwikidoc>DevGuide.DsXWikiDoc]
29 * [xwikidoubles>DevGuide.DsXWikiDoubles]
30 * [xwikifloats>DevGuide.DsXWikiFloats]
31 * [xwikiintegers>DevGuide.DsXWikiIntegers]
32 * [xwikilargestrings>DevGuide.DsXWikiLargeStrings]
33 * [xwikilinks>DevGuide.DsXWikiLinks]
34 </td>
35 <td style="border-bottom:0px">
36 * [xwikilistitems>DevGuide.DsXWikiListItems]
37 * [xwikilists>DevGuide.DsXWikiLists]
38 * [xwikilock>DevGuide.DsXWikiLocks]
39 * [xwikilongs>DevGuide.DsXWikiLongs]
40 * [xwikinumberclasses>DevGuide.DsXWikiNumberClasses]
41 * [xwikiobjects>DevGuide.DsXWikiObjects]
42 * xwikipreferences
43 * [xwikiproperties>DevGuide.DsXWikiProperties]
44 * xwikiircs
45 * xwikirecyclebin
46 * xwikislistclasses
47 * [xwikistatsdoc>#XWiki+Document+Stats]
48 * [xwikistatsreferer>#XWiki+Referer+Stats]
49 * [xwikistatsvisit>#XWiki+Visits]
50 * [xwikistringclasses>DevGuide.DsXWikiStringClasses]
51 * [xwikistrings>DevGuide.DsXWikiStrings]
52 </td>
53 </tr>
54 </table>
55
56 * [xwikilistclasses>#XWiki+List+Classes] ... not existing in Release 1.7.1
57
58 1.1 Statistics
59
60 1.1.1 XWiki Document Stats
61
62 This table contain stats information, namely page/space/wiki views and edits
63 .
64 <table border="0" width="100%" class="dbtable" cellpadding="3"
65 cellspacing="0">
66 <tr>
67 <td colspan="8" class="dbhead">xwikistatsdoc</td>
68 </tr>
69 <tr>
70 <th class="db0">&nbsp;</th>
71 <th class="db1">Column Name</th>
72 <th class="db2">Datatype</th>
73 <th class="db3">Not null</th>
74 <th class="db4">auto inc</th>
75 <th class="db5">flags</th>
76 <th class="db6">Default Value</th>
77 <th class="db7">Comments</th>
78 </tr>
79 <tr>
80 <td class="db0">{image:db_key.gif|16|16}</td>
81 <td class="db1">XWS_ID</td>
82 <td class="db2">INTEGER</td>
83 <td class="db3">{image:db_check.gif|16|16}</td>
84 <td class="db4">&nbsp;</td>
85 <td class="db5">&nbsp;</td>
86 <td class="db6">0</td>
87 <td class="db7">&nbsp;</td>
88 </tr>
89 <tr>
90 <td class="db0">{image:db_field.gif|16|16}</td>
91 <td class="db1">XWS_NUMBER</td>
92 <td class="db2">INTEGER</td>
93 <td class="db3">&nbsp;</td>
94 <td class="db4">&nbsp;</td>
95 <td class="db5">&nbsp;</td>
96 <td class="db6">null&nbsp;</td>
97 <td class="db7">&nbsp;</td>
98 </tr>
99 <tr>
100 <td class="db0">{image:db_field.gif|16|16}</td>
101 <td class="db1">XWS_NAME</td>
102 <td class="db2">VARCHAR(255)</td>
103 <td class="db3">{image:db_check.gif|16|16}</td>
104 <td class="db4">&nbsp;</td>
105 <td class="db5">&nbsp;</td>
106 <td class="db6">&nbsp;</td>
107 <td class="db7">&nbsp;</td>
108 </tr>
109 <tr>
110 <td class="db0">{image:db_field.gif|16|16}</td>
111 <td class="db1">XWS_CLASSNAME</td>
112 <td class="db2">VARCHAR(255)</td>
113 <td class="db3">{image:db_check.gif|16|16}</td>
114 <td class="db4">&nbsp;</td>
115 <td class="db5">&nbsp;</td>
116 <td class="db6">&nbsp;</td>
117 <td class="db7">&nbsp;</td>
118 </tr>
119 <tr>
120 <td class="db0">{image:db_field.gif|16|16}</td>
121 <td class="db1">XWS_ACTION</td>
122 <td class="db2">VARCHAR(255)</td>
123 <td class="db3">{image:db_check.gif|16|16}</td>
124 <td class="db4">&nbsp;</td>
125 <td class="db5">&nbsp;</td>
126 <td class="db6">&nbsp;</td>
127 <td class="db7">&nbsp;</td>
128 </tr>
129 <tr>
130 <td class="db0">{image:db_field.gif|16|16}</td>
131 <td class="db1">XWS_PAGE_VIEWS</td>
132 <td class="db2">INTEGER</td>
133 <td class="db3">&nbsp;</td>
134 <td class="db4">&nbsp;</td>
135 <td class="db5">&nbsp;</td>
136 <td class="db6">null</td>
137 <td class="db7">&nbsp;</td>
138 </tr>
139 <tr>
140 <td class="db0">{image:db_field.gif|16|16}</td>
141 <td class="db1">XWS_UNIQUE_VISITORS</td>
142 <td class="db2">INTEGER</td>
143 <td class="db3">&nbsp;</td>
144 <td class="db4">&nbsp;</td>
145 <td class="db5">&nbsp;</td>
146 <td class="db6">null</td>
147 <td class="db7">&nbsp;</td>
148 </tr>
149 <tr>
150 <td class="db0">{image:db_field.gif|16|16}</td>
151 <td class="db1">XWS_PERIOD</td>
152 <td class="db2">INTEGER</td>
153 <td class="db3">&nbsp;</td>
154 <td class="db4">&nbsp;</td>
155 <td class="db5">&nbsp;</td>
156 <td class="db6">null</td>
157 <td class="db7">&nbsp;</td>
158 </tr>
159 <tr>
160 <td class="db0">{image:db_field.gif|16|16}</td>
161 <td class="db1">XWS_VISITS</td>
162 <td class="db2">INTEGER</td>
163 <td class="db3">&nbsp;</td>
164 <td class="db4">&nbsp;</td>
165 <td class="db5">&nbsp;</td>
166 <td class="db6">null</td>
167 <td class="db7">&nbsp;</td>
168 </tr>
169 </table>
170
171 [^ back to top ^>#Tables]
172
173 1.1.1 XWiki Referer Stats
174
175 This page contains the incoming externa links on the Wiki.
176
177 <table border="0" width="100%" class="dbtable" cellpadding="3"
178 cellspacing="0">
179 <tr>
180 <td colspan="8" class="dbhead">xwikistatsreferer</td>
181 </tr>
182 <tr>
183 <th class="db0">&nbsp;</th>
184 <th class="db1">Column Name</th>
185 <th class="db2">Datatype</th>
186 <th class="db3">Not null</th>
187 <th class="db4">auto inc</th>
188 <th class="db5">flags</th>
189 <th class="db6">Default Value</th>
190 <th class="db7">Comments</th>
191 </tr>
192 <tr>
193 <td class="db0">{image:db_key.gif|16|16}</td>
194 <td class="db1">XWR_ID</td>
195 <td class="db2">INTEGER</td>
196 <td class="db3">{image:db_check.gif|16|16}</td>
197 <td class="db4">&nbsp;</td>
198 <td class="db5">&nbsp;</td>
199 <td class="db6">0</td>
200 <td class="db7">&nbsp;</td>
201 </tr>
202 <tr>
203 <td class="db0">{image:db_field.gif|16|16}</td>
204 <td class="db1">XWR_NUMBER</td>
205 <td class="db2">INTEGER</td>
206 <td class="db3">&nbsp;</td>
207 <td class="db4">&nbsp;</td>
208 <td class="db5">&nbsp;</td>
209 <td class="db6">null</td>
210 <td class="db7">&nbsp;</td>
211 </tr>
212 <tr>
213 <td class="db0">{image:db_field.gif|16|16}</td>
214 <td class="db1">XWR_NAME</td>
215 <td class="db2">VARCHAR(255)</td>
216 <td class="db3">{image:db_check.gif|16|16}</td>
217 <td class="db4">&nbsp;</td>
218 <td class="db5">&nbsp;</td>
219 <td class="db6">&nbsp;</td>
220 <td class="db7">&nbsp;</td>
221 </tr>
222 <tr>
223 <td class="db0">{image:db_field.gif|16|16}</td>
224 <td class="db1">XWR_CLASSNAME</td>
225 <td class="db2">VARCHAR(255)</td>
226 <td class="db3">{image:db_check.gif|16|16}</td>
227 <td class="db4">&nbsp;</td>
228 <td class="db5">&nbsp;</td>
229 <td class="db6">&nbsp;</td>
230 <td class="db7">&nbsp;</td>
231 </tr>
232 <tr>
233 <td class="db0">{image:db_field.gif|16|16}</td>
234 <td class="db1">XWR_REFERER</td>
235 <td class="db2">VARCHAR(255)</td>
236 <td class="db3">{image:db_check.gif|16|16}</td>
237 <td class="db4">&nbsp;</td>
238 <td class="db5">&nbsp;</td>
239 <td class="db6">&nbsp;</td>
240 <td class="db7">&nbsp;</td>
241 </tr>
242 <tr>
243 <td class="db0">{image:db_field.gif|16|16}</td>
244 <td class="db1">XWR_PAGE_VIEWS</td>
245 <td class="db2">INTEGER</td>
246 <td class="db3">&nbsp;</td>
247 <td class="db4">&nbsp;</td>
248 <td class="db5">&nbsp;</td>
249 <td class="db6">null</td>
250 <td class="db7">&nbsp;</td>
251 </tr>
252 <tr>
253 <td class="db0">{image:db_field.gif|16|16}</td>
254 <td class="db1">XWR_PERIOD</td>
255 <td class="db2">INTEGER</td>
256 <td class="db3">&nbsp;</td>
257 <td class="db4">&nbsp;</td>
258 <td class="db5">&nbsp;</td>
259 <td class="db6">null</td>
260 <td class="db7">&nbsp;</td>
261 </tr>
262 </table>
263
264 [^ back to top ^>#Tables]
265
266 1.1.1 XWiki Visits
267
268 This table contains the sessions of the named users.
269
270 <table border="0" width="100%" class="dbtable" cellpadding="3"
271 cellspacing="0">
272 <tr>
273 <td colspan="8" class="dbhead">xwikistatsvisit</td>
274 </tr>
275 <tr>
276 <th class="db0">&nbsp;</th>
277 <th class="db1">Column Name</th>
278 <th class="db2">Datatype</th>
279 <th class="db3">Not null</th>
280 <th class="db4">auto inc</th>
281 <th class="db5">flags</th>
282 <th class="db6">Default Value</th>
283 <th class="db7">Comments</th>
284 </tr>
285 <tr>
286 <td class="db0">{image:db_key.gif|16|16}</td>
287 <td class="db1">XWV_ID</td>
288 <td class="db2">INTEGER</td>
289 <td class="db3">{image:db_check.gif|16|16}</td>
290 <td class="db4">&nbsp;</td>
291 <td class="db5">&nbsp;</td>
292 <td class="db6">0</td>
293 <td class="db7">&nbsp;</td>
294 </tr>
295 <tr>
296 <td class="db0">{image:db_field.gif|16|16}</td>
297 <td class="db1">XWV_NUMBER</td>
298 <td class="db2">INTEGER</td>
299 <td class="db3">&nbsp;</td>
300 <td class="db4">&nbsp;</td>
301 <td class="db5">&nbsp;</td>
302 <td class="db6">null&nbsp;</td>
303 <td class="db7">&nbsp;</td>
304 </tr>
305 <tr>
306 <td class="db0">{image:db_field.gif|16|16}</td>
307 <td class="db1">XWV_NAME</td>
308 <td class="db2">VARCHAR(255)</td>
309 <td class="db3">{image:db_check.gif|16|16}</td>
310 <td class="db4">&nbsp;</td>
311 <td class="db5">&nbsp;</td>
312 <td class="db6">&nbsp;</td>
313 <td class="db7">&nbsp;</td>
314 </tr>
315 <tr>
316 <td class="db0">{image:db_field.gif|16|16}</td>
317 <td class="db1">XWV_CLASSNAME</td>
318 <td class="db2">VARCHAR(255)</td>
319 <td class="db3">{image:db_check.gif|16|16}</td>
320 <td class="db4">&nbsp;</td>
321 <td class="db5">&nbsp;</td>
322 <td class="db6">&nbsp;</td>
323 <td class="db7">&nbsp;</td>
324 </tr>
325 <tr>
326 <td class="db0">{image:db_field.gif|16|16}</td>
327 <td class="db1">XWV_IP</td>
328 <td class="db2">VARCHAR(32)</td>
329 <td class="db3">{image:db_check.gif|16|16}</td>
330 <td class="db4">&nbsp;</td>
331 <td class="db5">&nbsp;</td>
332 <td class="db6">&nbsp;</td>
333 <td class="db7">&nbsp;</td>
334 </tr>
335 <tr>
336 <td class="db0">{image:db_field.gif|16|16}</td>
337 <td class="db1">XWV_USER_AGENT</td>
338 <td class="db2">VARCHAR(255)</td>
339 <td class="db3">{image:db_check.gif|16|16}</td>
340 <td class="db4">&nbsp;</td>
341 <td class="db5">&nbsp;</td>
342 <td class="db6">&nbsp;</td>
343 <td class="db7">&nbsp;</td>
344 </tr>
345 <tr>
346 <td class="db0">{image:db_field.gif|16|16}</td>
347 <td class="db1">XWV_COOKIE</td>
348 <td class="db2">VARCHAR(255)</td>
349 <td class="db3">{image:db_check.gif|16|16}</td>
350 <td class="db4">&nbsp;</td>
351 <td class="db5">&nbsp;</td>
352 <td class="db6">&nbsp;</td>
353 <td class="db7">&nbsp;</td>
354 </tr>
355 <tr>
356 <td class="db0">{image:db_field.gif|16|16}</td>
357 <td class="db1">XWV_UNIQUE_ID</td>
358 <td class="db2">VARCHAR(255)</td>
359 <td class="db3">{image:db_check.gif|16|16}</td>
360 <td class="db4">&nbsp;</td>
361 <td class="db5">&nbsp;</td>
362 <td class="db6">&nbsp;</td>
363 <td class="db7">&nbsp;</td>
364 </tr>
365 <tr>
366 <td class="db0">{image:db_field.gif|16|16}</td>
367 <td class="db1">XWV_PAGE_VIEWS</td>
368 <td class="db2">INTEGER</td>
369 <td class="db3">&nbsp;</td>
370 <td class="db4">&nbsp;</td>
371 <td class="db5">&nbsp;</td>
372 <td class="db6">null</td>
373 <td class="db7">&nbsp;</td>
374 </tr>
375 <tr>
376 <td class="db0">{image:db_field.gif|16|16}</td>
377 <td class="db1">XWV_SAVES</td>
378 <td class="db2">INTEGER</td>
379 <td class="db3">&nbsp;</td>
380 <td class="db4">&nbsp;</td>
381 <td class="db5">&nbsp;</td>
382 <td class="db6">null</td>
383 <td class="db7">&nbsp;</td>
384 </tr>
385 <tr>
386 <td class="db0">{image:db_field.gif|16|16}</td>
387 <td class="db1">XWV_DOWNLOADS</td>
388 <td class="db2">INTEGER</td>
389 <td class="db3">&nbsp;</td>
390 <td class="db4">&nbsp;</td>
391 <td class="db5">&nbsp;</td>
392 <td class="db6">null</td>
393 <td class="db7">&nbsp;</td>
394 </tr>
395 <tr>
396 <td class="db0">{image:db_field.gif|16|16}</td>
397 <td class="db1">XWV_START_DATE</td>
398 <td class="db2">DATETIME</td>
399 <td class="db3">&nbsp;</td>
400 <td class="db4">&nbsp;</td>
401 <td class="db5">&nbsp;</td>
402 <td class="db6">null</td>
403 <td class="db7">&nbsp;</td>
404 </tr>
405 <tr>
406 <td class="db0">{image:db_field.gif|16|16}</td>
407 <td class="db1">XWV_END_DATE</td>
408 <td class="db2">DATETIME</td>
409 <td class="db3">&nbsp;</td>
410 <td class="db4">&nbsp;</td>
411 <td class="db5">&nbsp;</td>
412 <td class="db6">null</td>
413 <td class="db7">&nbsp;</td>
414 </tr>
415 </table>
416
417 [^ back to top ^>#Tables]
418 1.1.1 XWiki List Classes
419
420 This table contains the declaration of the list properties in XWiki classes.
421
422 <table border="0" width="100%" class="dbtable" cellpadding="3"
423 cellspacing="0">
424 <tr>
425 <td colspan="8" class="dbhead">xwikislistclasses</td>
426 </tr>
427 <tr>
428 <th class="db0">&nbsp;</th>
429 <th class="db1">Column Name</th>
430 <th class="db2">Datatype</th>
431 <th class="db3">Not null</th>
432 <th class="db4">auto inc</th>
433 <th class="db5">flags</th>
434 <th class="db6">Default Value</th>
435 <th class="db7">Comments</th>
436 </tr>
437 <tr>
438 <td class="db0">{image:db_key.gif|16|16}</td>
439 <td class="db1">XWL_ID</td>
440 <td class="db2">INTEGER</td>
441 <td class="db3">{image:db_check.gif|16|16}</td>
442 <td class="db4">&nbsp;</td>
443 <td class="db5">&nbsp;</td>
444 <td class="db6">0</td>
445 <td class="db7">&nbsp;</td>
446 </tr>
447 <tr>
448 <td class="db0">{image:db_key.gif|16|16}</td>
449 <td class="db1">XWL_NAME</td>
450 <td class="db2">VARCHAR(255)</td>
451 <td class="db3">{image:db_check.gif|16|16}</td>
452 <td class="db4">&nbsp;</td>
453 <td class="db5">&nbsp;</td>
454 <td class="db6">&nbsp;</td>
455 <td class="db7">&nbsp;</td>
456 </tr>
457 <tr>
458 <td class="db0">{image:db_field.gif|16|16}</td>
459 <td class="db1">XWL_DISPLAYTYPE</td>
460 <td class="db2">VARCHAR(20)</td>
461 <td class="db3">&nbsp;</td>
462 <td class="db4">&nbsp;</td>
463 <td class="db5">&nbsp;</td>
464 <td class="db6">null</td>
465 <td class="db7">&nbsp;</td>
466 </tr>
467 <tr>
468 <td class="db0">{image:db_field.gif|16|16}</td>
469 <td class="db1">XWL_MULTISELECT</td>
470 <td class="db2">TINYINT(1)</td>
471 <td class="db3">&nbsp;</td>
472 <td class="db4">&nbsp;</td>
473 <td class="db5">&nbsp;</td>
474 <td class="db6">null</td>
475 <td class="db7">&nbsp;</td>
476 </tr>
477 <tr>
478 <td class="db0">{image:db_field.gif|16|16}</td>
479 <td class="db1">XWL_SIZE</td>
480 <td class="db2">INTEGER</td>
481 <td class="db3">&nbsp;</td>
482 <td class="db4">&nbsp;</td>
483 <td class="db5">&nbsp;</td>
484 <td class="db6">null</td>
485 <td class="db7">&nbsp;</td>
486 </tr>
487 <tr>
488 <td class="db0">{image:db_field.gif|16|16}</td>
489 <td class="db1">XWL_RELATIONAL</td>
490 <td class="db2">TINYINT(1)</td>
491 <td class="db3">&nbsp;</td>
492 <td class="db4">&nbsp;</td>
493 <td class="db5">&nbsp;</td>
494 <td class="db6">null</td>
495 <td class="db7">&nbsp;</td>
496 </tr>
497 <tr>
498 <td class="db0">{image:db_field.gif|16|16}</td>
499 <td class="db1">XWL_VALUES</td>
500 <td class="db2">TEXT</td>
501 <td class="db3">&nbsp;</td>
502 <td class="db4">&nbsp;</td>
503 <td class="db5">&nbsp;</td>
504 <td class="db6">null</td>
505 <td class="db7">&nbsp;</td>
506 </tr>
507 </table>
508
509 [^ back to top ^>#Tables]
510 $context.setCacheDuration(100000)

About

About

Support

Platform

User Guide

Admin Guide

Developer Guide

Projects

XWiki

Extensions

Other

Contribute

Status

Practices

Under the Hood

Get Involved

Get Connected