Skip to Content

Wiki source code of DatabaseSchema

Version 79.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>#XWiki+Lists]
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.1 XWiki Lists
59
60 This table contain the data for lists properties in XWiki Objects.
61
62
63 <table border="0" width="100%" class="dbtable" cellpadding="3"
64 cellspacing="0">
65 <tr>
66 <td colspan="8" class="dbhead">xwikilists</td>
67 </tr>
68 <tr>
69 <th class="db0">&nbsp;</th>
70 <th class="db1">Column Name</th>
71 <th class="db2">Datatype</th>
72 <th class="db3">Not null</th>
73 <th class="db4">auto inc</th>
74 <th class="db5">flags</th>
75 <th class="db6">Default Value</th>
76 <th class="db7">Comments</th>
77 </tr>
78 <tr>
79 <td class="db0">{image:db_key.gif|16|16}</td>
80 <td class="db1">XWL_ID</td>
81 <td class="db2">INTEGER</td>
82 <td class="db3">{image:db_check.gif|16|16}</td>
83 <td class="db4">&nbsp;</td>
84 <td class="db5">&nbsp;</td>
85 <td class="db6">0</td>
86 <td class="db7">&nbsp;</td>
87 </tr>
88 <tr>
89 <td class="db0">{image:db_key.gif|16|16}</td>
90 <td class="db1">XWL_NAME</td>
91 <td class="db2">VARCHAR(255)</td>
92 <td class="db3">{image:db_check.gif|16|16}</td>
93 <td class="db4">&nbsp;</td>
94 <td class="db5">&nbsp;</td>
95 <td class="db6">&nbsp;</td>
96 <td class="db7">&nbsp;</td>
97 </tr>
98 </table>
99
100 [^ back to top ^>#Tables]
101
102 1.1 Statistics
103
104 1.1.1 XWiki Document Stats
105
106 This table contain stats information, namely page/space/wiki views and edits
107 .
108 <table border="0" width="100%" class="dbtable" cellpadding="3"
109 cellspacing="0">
110 <tr>
111 <td colspan="8" class="dbhead">xwikistatsdoc</td>
112 </tr>
113 <tr>
114 <th class="db0">&nbsp;</th>
115 <th class="db1">Column Name</th>
116 <th class="db2">Datatype</th>
117 <th class="db3">Not null</th>
118 <th class="db4">auto inc</th>
119 <th class="db5">flags</th>
120 <th class="db6">Default Value</th>
121 <th class="db7">Comments</th>
122 </tr>
123 <tr>
124 <td class="db0">{image:db_key.gif|16|16}</td>
125 <td class="db1">XWS_ID</td>
126 <td class="db2">INTEGER</td>
127 <td class="db3">{image:db_check.gif|16|16}</td>
128 <td class="db4">&nbsp;</td>
129 <td class="db5">&nbsp;</td>
130 <td class="db6">0</td>
131 <td class="db7">&nbsp;</td>
132 </tr>
133 <tr>
134 <td class="db0">{image:db_field.gif|16|16}</td>
135 <td class="db1">XWS_NUMBER</td>
136 <td class="db2">INTEGER</td>
137 <td class="db3">&nbsp;</td>
138 <td class="db4">&nbsp;</td>
139 <td class="db5">&nbsp;</td>
140 <td class="db6">null&nbsp;</td>
141 <td class="db7">&nbsp;</td>
142 </tr>
143 <tr>
144 <td class="db0">{image:db_field.gif|16|16}</td>
145 <td class="db1">XWS_NAME</td>
146 <td class="db2">VARCHAR(255)</td>
147 <td class="db3">{image:db_check.gif|16|16}</td>
148 <td class="db4">&nbsp;</td>
149 <td class="db5">&nbsp;</td>
150 <td class="db6">&nbsp;</td>
151 <td class="db7">&nbsp;</td>
152 </tr>
153 <tr>
154 <td class="db0">{image:db_field.gif|16|16}</td>
155 <td class="db1">XWS_CLASSNAME</td>
156 <td class="db2">VARCHAR(255)</td>
157 <td class="db3">{image:db_check.gif|16|16}</td>
158 <td class="db4">&nbsp;</td>
159 <td class="db5">&nbsp;</td>
160 <td class="db6">&nbsp;</td>
161 <td class="db7">&nbsp;</td>
162 </tr>
163 <tr>
164 <td class="db0">{image:db_field.gif|16|16}</td>
165 <td class="db1">XWS_ACTION</td>
166 <td class="db2">VARCHAR(255)</td>
167 <td class="db3">{image:db_check.gif|16|16}</td>
168 <td class="db4">&nbsp;</td>
169 <td class="db5">&nbsp;</td>
170 <td class="db6">&nbsp;</td>
171 <td class="db7">&nbsp;</td>
172 </tr>
173 <tr>
174 <td class="db0">{image:db_field.gif|16|16}</td>
175 <td class="db1">XWS_PAGE_VIEWS</td>
176 <td class="db2">INTEGER</td>
177 <td class="db3">&nbsp;</td>
178 <td class="db4">&nbsp;</td>
179 <td class="db5">&nbsp;</td>
180 <td class="db6">null</td>
181 <td class="db7">&nbsp;</td>
182 </tr>
183 <tr>
184 <td class="db0">{image:db_field.gif|16|16}</td>
185 <td class="db1">XWS_UNIQUE_VISITORS</td>
186 <td class="db2">INTEGER</td>
187 <td class="db3">&nbsp;</td>
188 <td class="db4">&nbsp;</td>
189 <td class="db5">&nbsp;</td>
190 <td class="db6">null</td>
191 <td class="db7">&nbsp;</td>
192 </tr>
193 <tr>
194 <td class="db0">{image:db_field.gif|16|16}</td>
195 <td class="db1">XWS_PERIOD</td>
196 <td class="db2">INTEGER</td>
197 <td class="db3">&nbsp;</td>
198 <td class="db4">&nbsp;</td>
199 <td class="db5">&nbsp;</td>
200 <td class="db6">null</td>
201 <td class="db7">&nbsp;</td>
202 </tr>
203 <tr>
204 <td class="db0">{image:db_field.gif|16|16}</td>
205 <td class="db1">XWS_VISITS</td>
206 <td class="db2">INTEGER</td>
207 <td class="db3">&nbsp;</td>
208 <td class="db4">&nbsp;</td>
209 <td class="db5">&nbsp;</td>
210 <td class="db6">null</td>
211 <td class="db7">&nbsp;</td>
212 </tr>
213 </table>
214
215 [^ back to top ^>#Tables]
216
217 1.1.1 XWiki Referer Stats
218
219 This page contains the incoming externa links on the Wiki.
220
221 <table border="0" width="100%" class="dbtable" cellpadding="3"
222 cellspacing="0">
223 <tr>
224 <td colspan="8" class="dbhead">xwikistatsreferer</td>
225 </tr>
226 <tr>
227 <th class="db0">&nbsp;</th>
228 <th class="db1">Column Name</th>
229 <th class="db2">Datatype</th>
230 <th class="db3">Not null</th>
231 <th class="db4">auto inc</th>
232 <th class="db5">flags</th>
233 <th class="db6">Default Value</th>
234 <th class="db7">Comments</th>
235 </tr>
236 <tr>
237 <td class="db0">{image:db_key.gif|16|16}</td>
238 <td class="db1">XWR_ID</td>
239 <td class="db2">INTEGER</td>
240 <td class="db3">{image:db_check.gif|16|16}</td>
241 <td class="db4">&nbsp;</td>
242 <td class="db5">&nbsp;</td>
243 <td class="db6">0</td>
244 <td class="db7">&nbsp;</td>
245 </tr>
246 <tr>
247 <td class="db0">{image:db_field.gif|16|16}</td>
248 <td class="db1">XWR_NUMBER</td>
249 <td class="db2">INTEGER</td>
250 <td class="db3">&nbsp;</td>
251 <td class="db4">&nbsp;</td>
252 <td class="db5">&nbsp;</td>
253 <td class="db6">null</td>
254 <td class="db7">&nbsp;</td>
255 </tr>
256 <tr>
257 <td class="db0">{image:db_field.gif|16|16}</td>
258 <td class="db1">XWR_NAME</td>
259 <td class="db2">VARCHAR(255)</td>
260 <td class="db3">{image:db_check.gif|16|16}</td>
261 <td class="db4">&nbsp;</td>
262 <td class="db5">&nbsp;</td>
263 <td class="db6">&nbsp;</td>
264 <td class="db7">&nbsp;</td>
265 </tr>
266 <tr>
267 <td class="db0">{image:db_field.gif|16|16}</td>
268 <td class="db1">XWR_CLASSNAME</td>
269 <td class="db2">VARCHAR(255)</td>
270 <td class="db3">{image:db_check.gif|16|16}</td>
271 <td class="db4">&nbsp;</td>
272 <td class="db5">&nbsp;</td>
273 <td class="db6">&nbsp;</td>
274 <td class="db7">&nbsp;</td>
275 </tr>
276 <tr>
277 <td class="db0">{image:db_field.gif|16|16}</td>
278 <td class="db1">XWR_REFERER</td>
279 <td class="db2">VARCHAR(255)</td>
280 <td class="db3">{image:db_check.gif|16|16}</td>
281 <td class="db4">&nbsp;</td>
282 <td class="db5">&nbsp;</td>
283 <td class="db6">&nbsp;</td>
284 <td class="db7">&nbsp;</td>
285 </tr>
286 <tr>
287 <td class="db0">{image:db_field.gif|16|16}</td>
288 <td class="db1">XWR_PAGE_VIEWS</td>
289 <td class="db2">INTEGER</td>
290 <td class="db3">&nbsp;</td>
291 <td class="db4">&nbsp;</td>
292 <td class="db5">&nbsp;</td>
293 <td class="db6">null</td>
294 <td class="db7">&nbsp;</td>
295 </tr>
296 <tr>
297 <td class="db0">{image:db_field.gif|16|16}</td>
298 <td class="db1">XWR_PERIOD</td>
299 <td class="db2">INTEGER</td>
300 <td class="db3">&nbsp;</td>
301 <td class="db4">&nbsp;</td>
302 <td class="db5">&nbsp;</td>
303 <td class="db6">null</td>
304 <td class="db7">&nbsp;</td>
305 </tr>
306 </table>
307
308 [^ back to top ^>#Tables]
309
310 1.1.1 XWiki Visits
311
312 This table contains the sessions of the named users.
313
314 <table border="0" width="100%" class="dbtable" cellpadding="3"
315 cellspacing="0">
316 <tr>
317 <td colspan="8" class="dbhead">xwikistatsvisit</td>
318 </tr>
319 <tr>
320 <th class="db0">&nbsp;</th>
321 <th class="db1">Column Name</th>
322 <th class="db2">Datatype</th>
323 <th class="db3">Not null</th>
324 <th class="db4">auto inc</th>
325 <th class="db5">flags</th>
326 <th class="db6">Default Value</th>
327 <th class="db7">Comments</th>
328 </tr>
329 <tr>
330 <td class="db0">{image:db_key.gif|16|16}</td>
331 <td class="db1">XWV_ID</td>
332 <td class="db2">INTEGER</td>
333 <td class="db3">{image:db_check.gif|16|16}</td>
334 <td class="db4">&nbsp;</td>
335 <td class="db5">&nbsp;</td>
336 <td class="db6">0</td>
337 <td class="db7">&nbsp;</td>
338 </tr>
339 <tr>
340 <td class="db0">{image:db_field.gif|16|16}</td>
341 <td class="db1">XWV_NUMBER</td>
342 <td class="db2">INTEGER</td>
343 <td class="db3">&nbsp;</td>
344 <td class="db4">&nbsp;</td>
345 <td class="db5">&nbsp;</td>
346 <td class="db6">null&nbsp;</td>
347 <td class="db7">&nbsp;</td>
348 </tr>
349 <tr>
350 <td class="db0">{image:db_field.gif|16|16}</td>
351 <td class="db1">XWV_NAME</td>
352 <td class="db2">VARCHAR(255)</td>
353 <td class="db3">{image:db_check.gif|16|16}</td>
354 <td class="db4">&nbsp;</td>
355 <td class="db5">&nbsp;</td>
356 <td class="db6">&nbsp;</td>
357 <td class="db7">&nbsp;</td>
358 </tr>
359 <tr>
360 <td class="db0">{image:db_field.gif|16|16}</td>
361 <td class="db1">XWV_CLASSNAME</td>
362 <td class="db2">VARCHAR(255)</td>
363 <td class="db3">{image:db_check.gif|16|16}</td>
364 <td class="db4">&nbsp;</td>
365 <td class="db5">&nbsp;</td>
366 <td class="db6">&nbsp;</td>
367 <td class="db7">&nbsp;</td>
368 </tr>
369 <tr>
370 <td class="db0">{image:db_field.gif|16|16}</td>
371 <td class="db1">XWV_IP</td>
372 <td class="db2">VARCHAR(32)</td>
373 <td class="db3">{image:db_check.gif|16|16}</td>
374 <td class="db4">&nbsp;</td>
375 <td class="db5">&nbsp;</td>
376 <td class="db6">&nbsp;</td>
377 <td class="db7">&nbsp;</td>
378 </tr>
379 <tr>
380 <td class="db0">{image:db_field.gif|16|16}</td>
381 <td class="db1">XWV_USER_AGENT</td>
382 <td class="db2">VARCHAR(255)</td>
383 <td class="db3">{image:db_check.gif|16|16}</td>
384 <td class="db4">&nbsp;</td>
385 <td class="db5">&nbsp;</td>
386 <td class="db6">&nbsp;</td>
387 <td class="db7">&nbsp;</td>
388 </tr>
389 <tr>
390 <td class="db0">{image:db_field.gif|16|16}</td>
391 <td class="db1">XWV_COOKIE</td>
392 <td class="db2">VARCHAR(255)</td>
393 <td class="db3">{image:db_check.gif|16|16}</td>
394 <td class="db4">&nbsp;</td>
395 <td class="db5">&nbsp;</td>
396 <td class="db6">&nbsp;</td>
397 <td class="db7">&nbsp;</td>
398 </tr>
399 <tr>
400 <td class="db0">{image:db_field.gif|16|16}</td>
401 <td class="db1">XWV_UNIQUE_ID</td>
402 <td class="db2">VARCHAR(255)</td>
403 <td class="db3">{image:db_check.gif|16|16}</td>
404 <td class="db4">&nbsp;</td>
405 <td class="db5">&nbsp;</td>
406 <td class="db6">&nbsp;</td>
407 <td class="db7">&nbsp;</td>
408 </tr>
409 <tr>
410 <td class="db0">{image:db_field.gif|16|16}</td>
411 <td class="db1">XWV_PAGE_VIEWS</td>
412 <td class="db2">INTEGER</td>
413 <td class="db3">&nbsp;</td>
414 <td class="db4">&nbsp;</td>
415 <td class="db5">&nbsp;</td>
416 <td class="db6">null</td>
417 <td class="db7">&nbsp;</td>
418 </tr>
419 <tr>
420 <td class="db0">{image:db_field.gif|16|16}</td>
421 <td class="db1">XWV_SAVES</td>
422 <td class="db2">INTEGER</td>
423 <td class="db3">&nbsp;</td>
424 <td class="db4">&nbsp;</td>
425 <td class="db5">&nbsp;</td>
426 <td class="db6">null</td>
427 <td class="db7">&nbsp;</td>
428 </tr>
429 <tr>
430 <td class="db0">{image:db_field.gif|16|16}</td>
431 <td class="db1">XWV_DOWNLOADS</td>
432 <td class="db2">INTEGER</td>
433 <td class="db3">&nbsp;</td>
434 <td class="db4">&nbsp;</td>
435 <td class="db5">&nbsp;</td>
436 <td class="db6">null</td>
437 <td class="db7">&nbsp;</td>
438 </tr>
439 <tr>
440 <td class="db0">{image:db_field.gif|16|16}</td>
441 <td class="db1">XWV_START_DATE</td>
442 <td class="db2">DATETIME</td>
443 <td class="db3">&nbsp;</td>
444 <td class="db4">&nbsp;</td>
445 <td class="db5">&nbsp;</td>
446 <td class="db6">null</td>
447 <td class="db7">&nbsp;</td>
448 </tr>
449 <tr>
450 <td class="db0">{image:db_field.gif|16|16}</td>
451 <td class="db1">XWV_END_DATE</td>
452 <td class="db2">DATETIME</td>
453 <td class="db3">&nbsp;</td>
454 <td class="db4">&nbsp;</td>
455 <td class="db5">&nbsp;</td>
456 <td class="db6">null</td>
457 <td class="db7">&nbsp;</td>
458 </tr>
459 </table>
460
461 [^ back to top ^>#Tables]
462 1.1.1 XWiki List Classes
463
464 This table contains the declaration of the list properties in XWiki classes.
465
466 <table border="0" width="100%" class="dbtable" cellpadding="3"
467 cellspacing="0">
468 <tr>
469 <td colspan="8" class="dbhead">xwikislistclasses</td>
470 </tr>
471 <tr>
472 <th class="db0">&nbsp;</th>
473 <th class="db1">Column Name</th>
474 <th class="db2">Datatype</th>
475 <th class="db3">Not null</th>
476 <th class="db4">auto inc</th>
477 <th class="db5">flags</th>
478 <th class="db6">Default Value</th>
479 <th class="db7">Comments</th>
480 </tr>
481 <tr>
482 <td class="db0">{image:db_key.gif|16|16}</td>
483 <td class="db1">XWL_ID</td>
484 <td class="db2">INTEGER</td>
485 <td class="db3">{image:db_check.gif|16|16}</td>
486 <td class="db4">&nbsp;</td>
487 <td class="db5">&nbsp;</td>
488 <td class="db6">0</td>
489 <td class="db7">&nbsp;</td>
490 </tr>
491 <tr>
492 <td class="db0">{image:db_key.gif|16|16}</td>
493 <td class="db1">XWL_NAME</td>
494 <td class="db2">VARCHAR(255)</td>
495 <td class="db3">{image:db_check.gif|16|16}</td>
496 <td class="db4">&nbsp;</td>
497 <td class="db5">&nbsp;</td>
498 <td class="db6">&nbsp;</td>
499 <td class="db7">&nbsp;</td>
500 </tr>
501 <tr>
502 <td class="db0">{image:db_field.gif|16|16}</td>
503 <td class="db1">XWL_DISPLAYTYPE</td>
504 <td class="db2">VARCHAR(20)</td>
505 <td class="db3">&nbsp;</td>
506 <td class="db4">&nbsp;</td>
507 <td class="db5">&nbsp;</td>
508 <td class="db6">null</td>
509 <td class="db7">&nbsp;</td>
510 </tr>
511 <tr>
512 <td class="db0">{image:db_field.gif|16|16}</td>
513 <td class="db1">XWL_MULTISELECT</td>
514 <td class="db2">TINYINT(1)</td>
515 <td class="db3">&nbsp;</td>
516 <td class="db4">&nbsp;</td>
517 <td class="db5">&nbsp;</td>
518 <td class="db6">null</td>
519 <td class="db7">&nbsp;</td>
520 </tr>
521 <tr>
522 <td class="db0">{image:db_field.gif|16|16}</td>
523 <td class="db1">XWL_SIZE</td>
524 <td class="db2">INTEGER</td>
525 <td class="db3">&nbsp;</td>
526 <td class="db4">&nbsp;</td>
527 <td class="db5">&nbsp;</td>
528 <td class="db6">null</td>
529 <td class="db7">&nbsp;</td>
530 </tr>
531 <tr>
532 <td class="db0">{image:db_field.gif|16|16}</td>
533 <td class="db1">XWL_RELATIONAL</td>
534 <td class="db2">TINYINT(1)</td>
535 <td class="db3">&nbsp;</td>
536 <td class="db4">&nbsp;</td>
537 <td class="db5">&nbsp;</td>
538 <td class="db6">null</td>
539 <td class="db7">&nbsp;</td>
540 </tr>
541 <tr>
542 <td class="db0">{image:db_field.gif|16|16}</td>
543 <td class="db1">XWL_VALUES</td>
544 <td class="db2">TEXT</td>
545 <td class="db3">&nbsp;</td>
546 <td class="db4">&nbsp;</td>
547 <td class="db5">&nbsp;</td>
548 <td class="db6">null</td>
549 <td class="db7">&nbsp;</td>
550 </tr>
551 </table>
552
553 [^ back to top ^>#Tables]
554 $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