Skip to Content

Wiki source code of DatabaseSchema

Version 63.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>#XWiki+Dates]
26 * [xwikidblistclasses>#XWiki+Database+List+Classes]
27 * xwikidbversion
28 * [xwikidoc>DevGuide.DsXWikiDoc]
29 * [xwikidoubles>#XWiki+Doubles]
30 * [xwikifloats>#XWiki+Floats]
31 * [xwikiintegers>#XWiki+Integers]
32 * [xwikilargestrings>#XWiki+Large+Strings]
33 * [xwikilinks>DevGuide.DsXWikiLinks]
34 </td>
35 <td style="border-bottom:0px">
36 * [xwikilistitems>#XWiki+List+Items]
37 * [xwikilists>#XWiki+Lists]
38 * [xwikilock>DevGuide.DsXWikiLocks]
39 * [xwikilongs>#XWiki+Longs]
40 * [xwikinumberclasses>DevGuide.DsXWikiNumberClasses]
41 * [xwikiobjects>#XWiki+Objects]
42 * xwikipreferences
43 * [xwikiproperties>#XWiki+Properties]
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>#XWiki+Strings]
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 List Classes
59
60 This table contains the declaration of the list properties in XWiki classes.
61
62 <table border="0" width="100%" class="dbtable" cellpadding="3"
63 cellspacing="0">
64 <tr>
65 <td colspan="8" class="dbhead">xwikislistclasses</td>
66 </tr>
67 <tr>
68 <th class="db0">&nbsp;</th>
69 <th class="db1">Column Name</th>
70 <th class="db2">Datatype</th>
71 <th class="db3">Not null</th>
72 <th class="db4">auto inc</th>
73 <th class="db5">flags</th>
74 <th class="db6">Default Value</th>
75 <th class="db7">Comments</th>
76 </tr>
77 <tr>
78 <td class="db0">{image:db_key.gif|16|16}</td>
79 <td class="db1">XWL_ID</td>
80 <td class="db2">INTEGER</td>
81 <td class="db3">{image:db_check.gif|16|16}</td>
82 <td class="db4">&nbsp;</td>
83 <td class="db5">&nbsp;</td>
84 <td class="db6">0</td>
85 <td class="db7">&nbsp;</td>
86 </tr>
87 <tr>
88 <td class="db0">{image:db_key.gif|16|16}</td>
89 <td class="db1">XWL_NAME</td>
90 <td class="db2">VARCHAR(255)</td>
91 <td class="db3">{image:db_check.gif|16|16}</td>
92 <td class="db4">&nbsp;</td>
93 <td class="db5">&nbsp;</td>
94 <td class="db6">&nbsp;</td>
95 <td class="db7">&nbsp;</td>
96 </tr>
97 <tr>
98 <td class="db0">{image:db_field.gif|16|16}</td>
99 <td class="db1">XWL_DISPLAYTYPE</td>
100 <td class="db2">VARCHAR(20)</td>
101 <td class="db3">&nbsp;</td>
102 <td class="db4">&nbsp;</td>
103 <td class="db5">&nbsp;</td>
104 <td class="db6">null</td>
105 <td class="db7">&nbsp;</td>
106 </tr>
107 <tr>
108 <td class="db0">{image:db_field.gif|16|16}</td>
109 <td class="db1">XWL_MULTISELECT</td>
110 <td class="db2">TINYINT(1)</td>
111 <td class="db3">&nbsp;</td>
112 <td class="db4">&nbsp;</td>
113 <td class="db5">&nbsp;</td>
114 <td class="db6">null</td>
115 <td class="db7">&nbsp;</td>
116 </tr>
117 <tr>
118 <td class="db0">{image:db_field.gif|16|16}</td>
119 <td class="db1">XWL_SIZE</td>
120 <td class="db2">INTEGER</td>
121 <td class="db3">&nbsp;</td>
122 <td class="db4">&nbsp;</td>
123 <td class="db5">&nbsp;</td>
124 <td class="db6">null</td>
125 <td class="db7">&nbsp;</td>
126 </tr>
127 <tr>
128 <td class="db0">{image:db_field.gif|16|16}</td>
129 <td class="db1">XWL_RELATIONAL</td>
130 <td class="db2">TINYINT(1)</td>
131 <td class="db3">&nbsp;</td>
132 <td class="db4">&nbsp;</td>
133 <td class="db5">&nbsp;</td>
134 <td class="db6">null</td>
135 <td class="db7">&nbsp;</td>
136 </tr>
137 <tr>
138 <td class="db0">{image:db_field.gif|16|16}</td>
139 <td class="db1">XWL_VALUES</td>
140 <td class="db2">TEXT</td>
141 <td class="db3">&nbsp;</td>
142 <td class="db4">&nbsp;</td>
143 <td class="db5">&nbsp;</td>
144 <td class="db6">null</td>
145 <td class="db7">&nbsp;</td>
146 </tr>
147 </table>
148
149 [^ back to top ^>#Tables]
150
151 1.1.1 XWiki Database List Classes
152
153 This table contains the declaration of the database list properties in XWiki classes.
154
155 <table border="0" width="100%" class="dbtable" cellpadding="3"
156 cellspacing="0">
157 <tr>
158 <td colspan="8" class="dbhead">xwikidblistclasses</td>
159 </tr>
160 <tr>
161 <th class="db0">&nbsp;</th>
162 <th class="db1">Column Name</th>
163 <th class="db2">Datatype</th>
164 <th class="db3">Not null</th>
165 <th class="db4">auto inc</th>
166 <th class="db5">flags</th>
167 <th class="db6">Default Value</th>
168 <th class="db7">Comments</th>
169 </tr>
170 <tr>
171 <td class="db0">{image:db_key.gif|16|16}</td>
172 <td class="db1">XWL_ID</td>
173 <td class="db2">INTEGER</td>
174 <td class="db3">{image:db_check.gif|16|16}</td>
175 <td class="db4">&nbsp;</td>
176 <td class="db5">&nbsp;</td>
177 <td class="db6">0</td>
178 <td class="db7">&nbsp;</td>
179 </tr>
180 <tr>
181 <td class="db0">{image:db_key.gif|16|16}</td>
182 <td class="db1">XWL_NAME</td>
183 <td class="db2">VARCHAR(255)</td>
184 <td class="db3">{image:db_check.gif|16|16}</td>
185 <td class="db4">&nbsp;</td>
186 <td class="db5">&nbsp;</td>
187 <td class="db6">&nbsp;</td>
188 <td class="db7">&nbsp;</td>
189 </tr>
190 <tr>
191 <td class="db0">{image:db_field.gif|16|16}</td>
192 <td class="db1">XWL_DISPLAYTYPE</td>
193 <td class="db2">VARCHAR(20)</td>
194 <td class="db3">&nbsp;</td>
195 <td class="db4">&nbsp;</td>
196 <td class="db5">&nbsp;</td>
197 <td class="db6">null</td>
198 <td class="db7">&nbsp;</td>
199 </tr>
200 <tr>
201 <td class="db0">{image:db_field.gif|16|16}</td>
202 <td class="db1">XWL_MULTISELECT</td>
203 <td class="db2">TINYINT(1)</td>
204 <td class="db3">&nbsp;</td>
205 <td class="db4">&nbsp;</td>
206 <td class="db5">&nbsp;</td>
207 <td class="db6">null</td>
208 <td class="db7">&nbsp;</td>
209 </tr>
210 <tr>
211 <td class="db0">{image:db_field.gif|16|16}</td>
212 <td class="db1">XWL_SIZE</td>
213 <td class="db2">INTEGER</td>
214 <td class="db3">&nbsp;</td>
215 <td class="db4">&nbsp;</td>
216 <td class="db5">&nbsp;</td>
217 <td class="db6">null</td>
218 <td class="db7">&nbsp;</td>
219 </tr>
220 <tr>
221 <td class="db0">{image:db_field.gif|16|16}</td>
222 <td class="db1">XWL_RELATIONAL</td>
223 <td class="db2">TINYINT(1)</td>
224 <td class="db3">&nbsp;</td>
225 <td class="db4">&nbsp;</td>
226 <td class="db5">&nbsp;</td>
227 <td class="db6">null</td>
228 <td class="db7">&nbsp;</td>
229 </tr>
230 <tr>
231 <td class="db0">{image:db_field.gif|16|16}</td>
232 <td class="db1">XWL_SQL</td>
233 <td class="db2">TEXT</td>
234 <td class="db3">&nbsp;</td>
235 <td class="db4">&nbsp;</td>
236 <td class="db5">&nbsp;</td>
237 <td class="db6">null</td>
238 <td class="db7">&nbsp;</td>
239 </tr>
240 </table>
241
242 [^ back to top ^>#Tables]
243
244 1.1 XWiki Objects
245
246 This table contains the list of XWiki Objects. Objects can have properties, as declared by their class.
247
248 <table border="0" width="100%" class="dbtable" cellpadding="3"
249 cellspacing="0">
250 <tr>
251 <td colspan="8" class="dbhead">xwikiobjects</td>
252 </tr>
253 <tr>
254 <th class="db0">&nbsp;</th>
255 <th class="db1">Column Name</th>
256 <th class="db2">Datatype</th>
257 <th class="db3">Not null</th>
258 <th class="db4">auto inc</th>
259 <th class="db5">flags</th>
260 <th class="db6">Default Value</th>
261 <th class="db7">Comments</th>
262 </tr>
263 <tr>
264 <td class="db0">{image:db_key.gif|16|16}</td>
265 <td class="db1">XWO_ID</td>
266 <td class="db2">INTEGER</td>
267 <td class="db3">{image:db_check.gif|16|16}</td>
268 <td class="db4">&nbsp;</td>
269 <td class="db5">&nbsp;</td>
270 <td class="db6">0</td>
271 <td class="db7">&nbsp;</td>
272 </tr>
273 <tr>
274 <td class="db0">{image:db_field.gif|16|16}</td>
275 <td class="db1">XWO_NUMBER</td>
276 <td class="db2">INTEGER</td>
277 <td class="db3">&nbsp;</td>
278 <td class="db4">&nbsp;</td>
279 <td class="db5">&nbsp;</td>
280 <td class="db6">null&nbsp;</td>
281 <td class="db7">&nbsp;</td>
282 </tr>
283 <tr>
284 <td class="db0">{image:db_field.gif|16|16}</td>
285 <td class="db1">XWO_NAME</td>
286 <td class="db2">VARCHAR(255)</td>
287 <td class="db3">{image:db_check.gif|16|16}</td>
288 <td class="db4">&nbsp;</td>
289 <td class="db5">&nbsp;</td>
290 <td class="db6">null</td>
291 <td class="db7">&nbsp;</td>
292 </tr>
293 <tr>
294 <td class="db0">{image:db_field.gif|16|16}</td>
295 <td class="db1">XWO_CLASSNAME</td>
296 <td class="db2">VARCHAR(255)</td>
297 <td class="db3">{image:db_check.gif|16|16}</td>
298 <td class="db4">&nbsp;</td>
299 <td class="db5">&nbsp;</td>
300 <td class="db6">&nbsp;</td>
301 <td class="db7">&nbsp;</td>
302 </tr>
303 </table>
304
305 [^ back to top ^>#Tables]
306
307 1.1 XWiki Properties
308
309 This table contains the list of properties in XWiki Objects. Each property has an entry in the type specific table.
310
311 <table border="0" width="100%" class="dbtable" cellpadding="3"
312 cellspacing="0">
313 <tr>
314 <td colspan="8" class="dbhead">xwikiproperties</td>
315 </tr>
316 <tr>
317 <th class="db0">&nbsp;</th>
318 <th class="db1">Column Name</th>
319 <th class="db2">Datatype</th>
320 <th class="db3">Not null</th>
321 <th class="db4">auto inc</th>
322 <th class="db5">flags</th>
323 <th class="db6">Default Value</th>
324 <th class="db7">Comments</th>
325 </tr>
326 <tr>
327 <td class="db0">{image:db_key.gif|16|16}</td>
328 <td class="db1">XWP_ID</td>
329 <td class="db2">INTEGER</td>
330 <td class="db3">{image:db_check.gif|16|16}</td>
331 <td class="db4">&nbsp;</td>
332 <td class="db5">&nbsp;</td>
333 <td class="db6">0</td>
334 <td class="db7">&nbsp;</td>
335 </tr>
336 <tr>
337 <td class="db0">{image:db_key.gif|16|16}</td>
338 <td class="db1">XWP_NAME</td>
339 <td class="db2">VARCHAR(255)</td>
340 <td class="db3">{image:db_check.gif|16|16}</td>
341 <td class="db4">&nbsp;</td>
342 <td class="db5">&nbsp;</td>
343 <td class="db6">&nbsp;</td>
344 <td class="db7">&nbsp;</td>
345 </tr>
346 <tr>
347 <td class="db0">{image:db_field.gif|16|16}</td>
348 <td class="db1">XWP_CLASSTYPE</td>
349 <td class="db2">VARCHAR(255)</td>
350 <td class="db3">&nbsp;</td>
351 <td class="db4">&nbsp;</td>
352 <td class="db5">&nbsp;</td>
353 <td class="db6">null</td>
354 <td class="db7">&nbsp;</td>
355 </tr>
356 </table>
357
358 [^ back to top ^>#Tables]
359
360 1.1.1 XWiki Strings
361
362 This table contains the string data from XWiki Objects.
363
364 <table border="0" width="100%" class="dbtable" cellpadding="3"
365 cellspacing="0">
366 <tr>
367 <td colspan="8" class="dbhead">xwikistrings</td>
368 </tr>
369 <tr>
370 <th class="db0">&nbsp;</th>
371 <th class="db1">Column Name</th>
372 <th class="db2">Datatype</th>
373 <th class="db3">Not null</th>
374 <th class="db4">auto inc</th>
375 <th class="db5">flags</th>
376 <th class="db6">Default Value</th>
377 <th class="db7">Comments</th>
378 </tr>
379 <tr>
380 <td class="db0">{image:db_key.gif|16|16}</td>
381 <td class="db1">XWS_ID</td>
382 <td class="db2">INTEGER</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">0</td>
387 <td class="db7">&nbsp;</td>
388 </tr>
389 <tr>
390 <td class="db0">{image:db_key.gif|16|16}</td>
391 <td class="db1">XWS_NAME</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">XWS_VALUE</td>
402 <td class="db2">VARCHAR(255)</td>
403 <td class="db3">&nbsp;</td>
404 <td class="db4">&nbsp;</td>
405 <td class="db5">&nbsp;</td>
406 <td class="db6">null</td>
407 <td class="db7">&nbsp;</td>
408 </tr>
409 </table>
410
411 [^ back to top ^>#Tables]
412
413 1.1.1 XWiki Large Strings
414
415 This table contain the data for textarea properties in XWiki Objects.
416
417 <table border="0" width="100%" class="dbtable" cellpadding="3"
418 cellspacing="0">
419 <tr>
420 <td colspan="8" class="dbhead">xwikilargestrings</td>
421 </tr>
422 <tr>
423 <th class="db0">&nbsp;</th>
424 <th class="db1">Column Name</th>
425 <th class="db2">Datatype</th>
426 <th class="db3">Not null</th>
427 <th class="db4">auto inc</th>
428 <th class="db5">flags</th>
429 <th class="db6">Default Value</th>
430 <th class="db7">Comments</th>
431 </tr>
432 <tr>
433 <td class="db0">{image:db_key.gif|16|16}</td>
434 <td class="db1">XWL_ID</td>
435 <td class="db2">INTEGER</td>
436 <td class="db3">{image:db_check.gif|16|16}</td>
437 <td class="db4">&nbsp;</td>
438 <td class="db5">&nbsp;</td>
439 <td class="db6">0</td>
440 <td class="db7">&nbsp;</td>
441 </tr>
442 <tr>
443 <td class="db0">{image:db_key.gif|16|16}</td>
444 <td class="db1">XWL_NAME</td>
445 <td class="db2">VARCHAR(255)</td>
446 <td class="db3">{image:db_check.gif|16|16}</td>
447 <td class="db4">&nbsp;</td>
448 <td class="db5">&nbsp;</td>
449 <td class="db6">&nbsp;</td>
450 <td class="db7">&nbsp;</td>
451 </tr>
452 <tr>
453 <td class="db0">{image:db_field.gif|16|16}</td>
454 <td class="db1">XWL_VALUE</td>
455 <td class="db2">TEXT</td>
456 <td class="db3">&nbsp;</td>
457 <td class="db4">&nbsp;</td>
458 <td class="db5">&nbsp;</td>
459 <td class="db6">null</td>
460 <td class="db7">&nbsp;</td>
461 </tr>
462 </table>
463
464 [^ back to top ^>#Tables]
465
466 1.1.1 XWiki Dates
467
468 This table contains the data of date properties in XWiki objects.
469
470 <table border="0" width="100%" class="dbtable" cellpadding="3"
471 cellspacing="0">
472 <tr>
473 <td colspan="8" class="dbhead">xwikidates</td>
474 </tr>
475 <tr>
476 <th class="db0">&nbsp;</th>
477 <th class="db1">Column Name</th>
478 <th class="db2">Datatype</th>
479 <th class="db3">Not null</th>
480 <th class="db4">auto inc</th>
481 <th class="db5">flags</th>
482 <th class="db6">Default Value</th>
483 <th class="db7">Comments</th>
484 </tr>
485 <tr>
486 <td class="db0">{image:db_key.gif|16|16}</td>
487 <td class="db1">XWS_ID</td>
488 <td class="db2">INTEGER</td>
489 <td class="db3">{image:db_check.gif|16|16}</td>
490 <td class="db4">&nbsp;</td>
491 <td class="db5">&nbsp;</td>
492 <td class="db6">0</td>
493 <td class="db7">&nbsp;</td>
494 </tr>
495 <tr>
496 <td class="db0">{image:db_key.gif|16|16}</td>
497 <td class="db1">XWS_NAME</td>
498 <td class="db2">VARCHAR(255)</td>
499 <td class="db3">{image:db_check.gif|16|16}</td>
500 <td class="db4">&nbsp;</td>
501 <td class="db5">&nbsp;</td>
502 <td class="db6">&nbsp;</td>
503 <td class="db7">&nbsp;</td>
504 </tr>
505 <tr>
506 <td class="db0">{image:db_field.gif|16|16}</td>
507 <td class="db1">XWS_VALUE</td>
508 <td class="db2">DATETIME</td>
509 <td class="db3">&nbsp;</td>
510 <td class="db4">&nbsp;</td>
511 <td class="db5">&nbsp;</td>
512 <td class="db6">null</td>
513 <td class="db7">&nbsp;</td>
514 </tr>
515 </table>
516
517 The field name prefix is this table is wrong. It should be corrected in xwiki.hbm.xml.
518
519 [^ back to top ^>#Tables]
520
521 1.1.1 XWiki Doubles
522
523 This table contain the data for double properties in XWiki Objects.
524
525 <table border="0" width="100%" class="dbtable" cellpadding="3"
526 cellspacing="0">
527 <tr>
528 <td colspan="8" class="dbhead">xwikidoubles</td>
529 </tr>
530 <tr>
531 <th class="db0">&nbsp;</th>
532 <th class="db1">Column Name</th>
533 <th class="db2">Datatype</th>
534 <th class="db3">Not null</th>
535 <th class="db4">auto inc</th>
536 <th class="db5">flags</th>
537 <th class="db6">Default Value</th>
538 <th class="db7">Comments</th>
539 </tr>
540 <tr>
541 <td class="db0">{image:db_key.gif|16|16}</td>
542 <td class="db1">XWD_ID</td>
543 <td class="db2">INTEGER</td>
544 <td class="db3">{image:db_check.gif|16|16}</td>
545 <td class="db4">&nbsp;</td>
546 <td class="db5">&nbsp;</td>
547 <td class="db6">0</td>
548 <td class="db7">&nbsp;</td>
549 </tr>
550 <tr>
551 <td class="db0">{image:db_key.gif|16|16}</td>
552 <td class="db1">XWD_NAME</td>
553 <td class="db2">VARCHAR(255)</td>
554 <td class="db3">{image:db_check.gif|16|16}</td>
555 <td class="db4">&nbsp;</td>
556 <td class="db5">&nbsp;</td>
557 <td class="db6">&nbsp;</td>
558 <td class="db7">&nbsp;</td>
559 </tr>
560 <tr>
561 <td class="db0">{image:db_field.gif|16|16}</td>
562 <td class="db1">XWD_VALUE</td>
563 <td class="db2">DOUBLE</td>
564 <td class="db3">&nbsp;</td>
565 <td class="db4">&nbsp;</td>
566 <td class="db5">&nbsp;</td>
567 <td class="db6">null</td>
568 <td class="db7">&nbsp;</td>
569 </tr>
570 </table>
571
572 [^ back to top ^>#Tables]
573
574 1.1.1 XWiki Floats
575
576 This table contain the data for floats properties in XWiki Objects.
577
578
579 <table border="0" width="100%" class="dbtable" cellpadding="3"
580 cellspacing="0">
581 <tr>
582 <td colspan="8" class="dbhead">xwikifloats</td>
583 </tr>
584 <tr>
585 <th class="db0">&nbsp;</th>
586 <th class="db1">Column Name</th>
587 <th class="db2">Datatype</th>
588 <th class="db3">Not null</th>
589 <th class="db4">auto inc</th>
590 <th class="db5">flags</th>
591 <th class="db6">Default Value</th>
592 <th class="db7">Comments</th>
593 </tr>
594 <tr>
595 <td class="db0">{image:db_key.gif|16|16}</td>
596 <td class="db1">XWF_ID</td>
597 <td class="db2">INTEGER</td>
598 <td class="db3">{image:db_check.gif|16|16}</td>
599 <td class="db4">&nbsp;</td>
600 <td class="db5">&nbsp;</td>
601 <td class="db6">0</td>
602 <td class="db7">&nbsp;</td>
603 </tr>
604 <tr>
605 <td class="db0">{image:db_key.gif|16|16}</td>
606 <td class="db1">XWF_NAME</td>
607 <td class="db2">VARCHAR(255)</td>
608 <td class="db3">{image:db_check.gif|16|16}</td>
609 <td class="db4">&nbsp;</td>
610 <td class="db5">&nbsp;</td>
611 <td class="db6">&nbsp;</td>
612 <td class="db7">&nbsp;</td>
613 </tr>
614 <tr>
615 <td class="db0">{image:db_field.gif|16|16}</td>
616 <td class="db1">XWF_VALUE</td>
617 <td class="db2">FLOAT</td>
618 <td class="db3">&nbsp;</td>
619 <td class="db4">&nbsp;</td>
620 <td class="db5">&nbsp;</td>
621 <td class="db6">null</td>
622 <td class="db7">&nbsp;</td>
623 </tr>
624 </table>
625
626 [^ back to top ^>#Tables]
627
628 1.1.1 XWiki Integers
629
630 This table contain the data for integer properties in XWiki Objects.
631
632
633 <table border="0" width="100%" class="dbtable" cellpadding="3"
634 cellspacing="0">
635 <tr>
636 <td colspan="8" class="dbhead">xwikiintegers</td>
637 </tr>
638 <tr>
639 <th class="db0">&nbsp;</th>
640 <th class="db1">Column Name</th>
641 <th class="db2">Datatype</th>
642 <th class="db3">Not null</th>
643 <th class="db4">auto inc</th>
644 <th class="db5">flags</th>
645 <th class="db6">Default Value</th>
646 <th class="db7">Comments</th>
647 </tr>
648 <tr>
649 <td class="db0">{image:db_key.gif|16|16}</td>
650 <td class="db1">XWI_ID</td>
651 <td class="db2">INTEGER</td>
652 <td class="db3">{image:db_check.gif|16|16}</td>
653 <td class="db4">&nbsp;</td>
654 <td class="db5">&nbsp;</td>
655 <td class="db6">0</td>
656 <td class="db7">&nbsp;</td>
657 </tr>
658 <tr>
659 <td class="db0">{image:db_key.gif|16|16}</td>
660 <td class="db1">XWI_NAME</td>
661 <td class="db2">VARCHAR(255)</td>
662 <td class="db3">{image:db_check.gif|16|16}</td>
663 <td class="db4">&nbsp;</td>
664 <td class="db5">&nbsp;</td>
665 <td class="db6">&nbsp;</td>
666 <td class="db7">&nbsp;</td>
667 </tr>
668 <tr>
669 <td class="db0">{image:db_field.gif|16|16}</td>
670 <td class="db1">XWI_VALUE</td>
671 <td class="db2">INTEGER</td>
672 <td class="db3">&nbsp;</td>
673 <td class="db4">&nbsp;</td>
674 <td class="db5">&nbsp;</td>
675 <td class="db6">null</td>
676 <td class="db7">&nbsp;</td>
677 </tr>
678 </table>
679
680 [^ back to top ^>#Tables]
681
682 1.1.1 XWiki Longs
683
684 This table contain the data for long properties in XWiki Objects.
685
686 <table border="0" width="100%" class="dbtable" cellpadding="3"
687 cellspacing="0">
688 <tr>
689 <td colspan="8" class="dbhead">xwikilongs</td>
690 </tr>
691 <tr>
692 <th class="db0">&nbsp;</th>
693 <th class="db1">Column Name</th>
694 <th class="db2">Datatype</th>
695 <th class="db3">Not null</th>
696 <th class="db4">auto inc</th>
697 <th class="db5">flags</th>
698 <th class="db6">Default Value</th>
699 <th class="db7">Comments</th>
700 </tr>
701 <tr>
702 <td class="db0">{image:db_key.gif|16|16}</td>
703 <td class="db1">XWL_ID</td>
704 <td class="db2">INTEGER</td>
705 <td class="db3">{image:db_check.gif|16|16}</td>
706 <td class="db4">&nbsp;</td>
707 <td class="db5">&nbsp;</td>
708 <td class="db6">0</td>
709 <td class="db7">&nbsp;</td>
710 </tr>
711 <tr>
712 <td class="db0">{image:db_key.gif|16|16}</td>
713 <td class="db1">XWL_NAME</td>
714 <td class="db2">VARCHAR(255)</td>
715 <td class="db3">{image:db_check.gif|16|16}</td>
716 <td class="db4">&nbsp;</td>
717 <td class="db5">&nbsp;</td>
718 <td class="db6">&nbsp;</td>
719 <td class="db7">&nbsp;</td>
720 </tr>
721 <tr>
722 <td class="db0">{image:db_field.gif|16|16}</td>
723 <td class="db1">XWL_VALUE</td>
724 <td class="db2">BIGINT(20)</td>
725 <td class="db3">&nbsp;</td>
726 <td class="db4">&nbsp;</td>
727 <td class="db5">&nbsp;</td>
728 <td class="db6">null</td>
729 <td class="db7">&nbsp;</td>
730 </tr>
731 </table>
732
733 [^ back to top ^>#Tables]
734
735 1.1.1 XWiki List Items
736
737 This table contain the data for lists properties in XWiki Objects.
738
739 <table border="0" width="100%" class="dbtable" cellpadding="3"
740 cellspacing="0">
741 <tr>
742 <td colspan="8" class="dbhead">xwikilistitems</td>
743 </tr>
744 <tr>
745 <th class="db0">&nbsp;</th>
746 <th class="db1">Column Name</th>
747 <th class="db2">Datatype</th>
748 <th class="db3">Not null</th>
749 <th class="db4">auto inc</th>
750 <th class="db5">flags</th>
751 <th class="db6">Default Value</th>
752 <th class="db7">Comments</th>
753 </tr>
754 <tr>
755 <td class="db0">{image:db_key.gif|16|16}</td>
756 <td class="db1">XWL_ID</td>
757 <td class="db2">INTEGER</td>
758 <td class="db3">{image:db_check.gif|16|16}</td>
759 <td class="db4">&nbsp;</td>
760 <td class="db5">&nbsp;</td>
761 <td class="db6">0</td>
762 <td class="db7">&nbsp;</td>
763 </tr>
764 <tr>
765 <td class="db0">{image:db_key.gif|16|16}</td>
766 <td class="db1">XWL_NAME</td>
767 <td class="db2">VARCHAR(255)</td>
768 <td class="db3">{image:db_check.gif|16|16}</td>
769 <td class="db4">&nbsp;</td>
770 <td class="db5">&nbsp;</td>
771 <td class="db6">&nbsp;</td>
772 <td class="db7">&nbsp;</td>
773 </tr>
774 <tr>
775 <td class="db0">{image:db_field.gif|16|16}</td>
776 <td class="db1">XWL_VALUE</td>
777 <td class="db2">VARCHAR(255)</td>
778 <td class="db3">&nbsp;</td>
779 <td class="db4">&nbsp;</td>
780 <td class="db5">&nbsp;</td>
781 <td class="db6">null</td>
782 <td class="db7">&nbsp;</td>
783 </tr>
784 <tr>
785 <td class="db0">{image:db_key.gif|16|16}</td>
786 <td class="db1">XWL_NUMBER</td>
787 <td class="db2">INTEGER</td>
788 <td class="db3">{image:db_check.gif|16|16}</td>
789 <td class="db4">&nbsp;</td>
790 <td class="db5">&nbsp;</td>
791 <td class="db6">0</td>
792 <td class="db7">&nbsp;</td>
793 </tr>
794 </table>
795
796 [^ back to top ^>#Tables]
797
798 1.1.1 XWiki Lists
799
800 This table contain the data for lists properties in XWiki Objects.
801
802
803 <table border="0" width="100%" class="dbtable" cellpadding="3"
804 cellspacing="0">
805 <tr>
806 <td colspan="8" class="dbhead">xwikilists</td>
807 </tr>
808 <tr>
809 <th class="db0">&nbsp;</th>
810 <th class="db1">Column Name</th>
811 <th class="db2">Datatype</th>
812 <th class="db3">Not null</th>
813 <th class="db4">auto inc</th>
814 <th class="db5">flags</th>
815 <th class="db6">Default Value</th>
816 <th class="db7">Comments</th>
817 </tr>
818 <tr>
819 <td class="db0">{image:db_key.gif|16|16}</td>
820 <td class="db1">XWL_ID</td>
821 <td class="db2">INTEGER</td>
822 <td class="db3">{image:db_check.gif|16|16}</td>
823 <td class="db4">&nbsp;</td>
824 <td class="db5">&nbsp;</td>
825 <td class="db6">0</td>
826 <td class="db7">&nbsp;</td>
827 </tr>
828 <tr>
829 <td class="db0">{image:db_key.gif|16|16}</td>
830 <td class="db1">XWL_NAME</td>
831 <td class="db2">VARCHAR(255)</td>
832 <td class="db3">{image:db_check.gif|16|16}</td>
833 <td class="db4">&nbsp;</td>
834 <td class="db5">&nbsp;</td>
835 <td class="db6">&nbsp;</td>
836 <td class="db7">&nbsp;</td>
837 </tr>
838 </table>
839
840 [^ back to top ^>#Tables]
841
842 1.1 Statistics
843
844 1.1.1 XWiki Document Stats
845
846 This table contain stats information, namely page/space/wiki views and edits
847 .
848 <table border="0" width="100%" class="dbtable" cellpadding="3"
849 cellspacing="0">
850 <tr>
851 <td colspan="8" class="dbhead">xwikistatsdoc</td>
852 </tr>
853 <tr>
854 <th class="db0">&nbsp;</th>
855 <th class="db1">Column Name</th>
856 <th class="db2">Datatype</th>
857 <th class="db3">Not null</th>
858 <th class="db4">auto inc</th>
859 <th class="db5">flags</th>
860 <th class="db6">Default Value</th>
861 <th class="db7">Comments</th>
862 </tr>
863 <tr>
864 <td class="db0">{image:db_key.gif|16|16}</td>
865 <td class="db1">XWS_ID</td>
866 <td class="db2">INTEGER</td>
867 <td class="db3">{image:db_check.gif|16|16}</td>
868 <td class="db4">&nbsp;</td>
869 <td class="db5">&nbsp;</td>
870 <td class="db6">0</td>
871 <td class="db7">&nbsp;</td>
872 </tr>
873 <tr>
874 <td class="db0">{image:db_field.gif|16|16}</td>
875 <td class="db1">XWS_NUMBER</td>
876 <td class="db2">INTEGER</td>
877 <td class="db3">&nbsp;</td>
878 <td class="db4">&nbsp;</td>
879 <td class="db5">&nbsp;</td>
880 <td class="db6">null&nbsp;</td>
881 <td class="db7">&nbsp;</td>
882 </tr>
883 <tr>
884 <td class="db0">{image:db_field.gif|16|16}</td>
885 <td class="db1">XWS_NAME</td>
886 <td class="db2">VARCHAR(255)</td>
887 <td class="db3">{image:db_check.gif|16|16}</td>
888 <td class="db4">&nbsp;</td>
889 <td class="db5">&nbsp;</td>
890 <td class="db6">&nbsp;</td>
891 <td class="db7">&nbsp;</td>
892 </tr>
893 <tr>
894 <td class="db0">{image:db_field.gif|16|16}</td>
895 <td class="db1">XWS_CLASSNAME</td>
896 <td class="db2">VARCHAR(255)</td>
897 <td class="db3">{image:db_check.gif|16|16}</td>
898 <td class="db4">&nbsp;</td>
899 <td class="db5">&nbsp;</td>
900 <td class="db6">&nbsp;</td>
901 <td class="db7">&nbsp;</td>
902 </tr>
903 <tr>
904 <td class="db0">{image:db_field.gif|16|16}</td>
905 <td class="db1">XWS_ACTION</td>
906 <td class="db2">VARCHAR(255)</td>
907 <td class="db3">{image:db_check.gif|16|16}</td>
908 <td class="db4">&nbsp;</td>
909 <td class="db5">&nbsp;</td>
910 <td class="db6">&nbsp;</td>
911 <td class="db7">&nbsp;</td>
912 </tr>
913 <tr>
914 <td class="db0">{image:db_field.gif|16|16}</td>
915 <td class="db1">XWS_PAGE_VIEWS</td>
916 <td class="db2">INTEGER</td>
917 <td class="db3">&nbsp;</td>
918 <td class="db4">&nbsp;</td>
919 <td class="db5">&nbsp;</td>
920 <td class="db6">null</td>
921 <td class="db7">&nbsp;</td>
922 </tr>
923 <tr>
924 <td class="db0">{image:db_field.gif|16|16}</td>
925 <td class="db1">XWS_UNIQUE_VISITORS</td>
926 <td class="db2">INTEGER</td>
927 <td class="db3">&nbsp;</td>
928 <td class="db4">&nbsp;</td>
929 <td class="db5">&nbsp;</td>
930 <td class="db6">null</td>
931 <td class="db7">&nbsp;</td>
932 </tr>
933 <tr>
934 <td class="db0">{image:db_field.gif|16|16}</td>
935 <td class="db1">XWS_PERIOD</td>
936 <td class="db2">INTEGER</td>
937 <td class="db3">&nbsp;</td>
938 <td class="db4">&nbsp;</td>
939 <td class="db5">&nbsp;</td>
940 <td class="db6">null</td>
941 <td class="db7">&nbsp;</td>
942 </tr>
943 <tr>
944 <td class="db0">{image:db_field.gif|16|16}</td>
945 <td class="db1">XWS_VISITS</td>
946 <td class="db2">INTEGER</td>
947 <td class="db3">&nbsp;</td>
948 <td class="db4">&nbsp;</td>
949 <td class="db5">&nbsp;</td>
950 <td class="db6">null</td>
951 <td class="db7">&nbsp;</td>
952 </tr>
953 </table>
954
955 [^ back to top ^>#Tables]
956
957 1.1.1 XWiki Referer Stats
958
959 This page contains the incoming externa links on the Wiki.
960
961 <table border="0" width="100%" class="dbtable" cellpadding="3"
962 cellspacing="0">
963 <tr>
964 <td colspan="8" class="dbhead">xwikistatsreferer</td>
965 </tr>
966 <tr>
967 <th class="db0">&nbsp;</th>
968 <th class="db1">Column Name</th>
969 <th class="db2">Datatype</th>
970 <th class="db3">Not null</th>
971 <th class="db4">auto inc</th>
972 <th class="db5">flags</th>
973 <th class="db6">Default Value</th>
974 <th class="db7">Comments</th>
975 </tr>
976 <tr>
977 <td class="db0">{image:db_key.gif|16|16}</td>
978 <td class="db1">XWR_ID</td>
979 <td class="db2">INTEGER</td>
980 <td class="db3">{image:db_check.gif|16|16}</td>
981 <td class="db4">&nbsp;</td>
982 <td class="db5">&nbsp;</td>
983 <td class="db6">0</td>
984 <td class="db7">&nbsp;</td>
985 </tr>
986 <tr>
987 <td class="db0">{image:db_field.gif|16|16}</td>
988 <td class="db1">XWR_NUMBER</td>
989 <td class="db2">INTEGER</td>
990 <td class="db3">&nbsp;</td>
991 <td class="db4">&nbsp;</td>
992 <td class="db5">&nbsp;</td>
993 <td class="db6">null</td>
994 <td class="db7">&nbsp;</td>
995 </tr>
996 <tr>
997 <td class="db0">{image:db_field.gif|16|16}</td>
998 <td class="db1">XWR_NAME</td>
999 <td class="db2">VARCHAR(255)</td>
1000 <td class="db3">{image:db_check.gif|16|16}</td>
1001 <td class="db4">&nbsp;</td>
1002 <td class="db5">&nbsp;</td>
1003 <td class="db6">&nbsp;</td>
1004 <td class="db7">&nbsp;</td>
1005 </tr>
1006 <tr>
1007 <td class="db0">{image:db_field.gif|16|16}</td>
1008 <td class="db1">XWR_CLASSNAME</td>
1009 <td class="db2">VARCHAR(255)</td>
1010 <td class="db3">{image:db_check.gif|16|16}</td>
1011 <td class="db4">&nbsp;</td>
1012 <td class="db5">&nbsp;</td>
1013 <td class="db6">&nbsp;</td>
1014 <td class="db7">&nbsp;</td>
1015 </tr>
1016 <tr>
1017 <td class="db0">{image:db_field.gif|16|16}</td>
1018 <td class="db1">XWR_REFERER</td>
1019 <td class="db2">VARCHAR(255)</td>
1020 <td class="db3">{image:db_check.gif|16|16}</td>
1021 <td class="db4">&nbsp;</td>
1022 <td class="db5">&nbsp;</td>
1023 <td class="db6">&nbsp;</td>
1024 <td class="db7">&nbsp;</td>
1025 </tr>
1026 <tr>
1027 <td class="db0">{image:db_field.gif|16|16}</td>
1028 <td class="db1">XWR_PAGE_VIEWS</td>
1029 <td class="db2">INTEGER</td>
1030 <td class="db3">&nbsp;</td>
1031 <td class="db4">&nbsp;</td>
1032 <td class="db5">&nbsp;</td>
1033 <td class="db6">null</td>
1034 <td class="db7">&nbsp;</td>
1035 </tr>
1036 <tr>
1037 <td class="db0">{image:db_field.gif|16|16}</td>
1038 <td class="db1">XWR_PERIOD</td>
1039 <td class="db2">INTEGER</td>
1040 <td class="db3">&nbsp;</td>
1041 <td class="db4">&nbsp;</td>
1042 <td class="db5">&nbsp;</td>
1043 <td class="db6">null</td>
1044 <td class="db7">&nbsp;</td>
1045 </tr>
1046 </table>
1047
1048 [^ back to top ^>#Tables]
1049
1050 1.1.1 XWiki Visits
1051
1052 This table contains the sessions of the named users.
1053
1054 <table border="0" width="100%" class="dbtable" cellpadding="3"
1055 cellspacing="0">
1056 <tr>
1057 <td colspan="8" class="dbhead">xwikistatsvisit</td>
1058 </tr>
1059 <tr>
1060 <th class="db0">&nbsp;</th>
1061 <th class="db1">Column Name</th>
1062 <th class="db2">Datatype</th>
1063 <th class="db3">Not null</th>
1064 <th class="db4">auto inc</th>
1065 <th class="db5">flags</th>
1066 <th class="db6">Default Value</th>
1067 <th class="db7">Comments</th>
1068 </tr>
1069 <tr>
1070 <td class="db0">{image:db_key.gif|16|16}</td>
1071 <td class="db1">XWV_ID</td>
1072 <td class="db2">INTEGER</td>
1073 <td class="db3">{image:db_check.gif|16|16}</td>
1074 <td class="db4">&nbsp;</td>
1075 <td class="db5">&nbsp;</td>
1076 <td class="db6">0</td>
1077 <td class="db7">&nbsp;</td>
1078 </tr>
1079 <tr>
1080 <td class="db0">{image:db_field.gif|16|16}</td>
1081 <td class="db1">XWV_NUMBER</td>
1082 <td class="db2">INTEGER</td>
1083 <td class="db3">&nbsp;</td>
1084 <td class="db4">&nbsp;</td>
1085 <td class="db5">&nbsp;</td>
1086 <td class="db6">null&nbsp;</td>
1087 <td class="db7">&nbsp;</td>
1088 </tr>
1089 <tr>
1090 <td class="db0">{image:db_field.gif|16|16}</td>
1091 <td class="db1">XWV_NAME</td>
1092 <td class="db2">VARCHAR(255)</td>
1093 <td class="db3">{image:db_check.gif|16|16}</td>
1094 <td class="db4">&nbsp;</td>
1095 <td class="db5">&nbsp;</td>
1096 <td class="db6">&nbsp;</td>
1097 <td class="db7">&nbsp;</td>
1098 </tr>
1099 <tr>
1100 <td class="db0">{image:db_field.gif|16|16}</td>
1101 <td class="db1">XWV_CLASSNAME</td>
1102 <td class="db2">VARCHAR(255)</td>
1103 <td class="db3">{image:db_check.gif|16|16}</td>
1104 <td class="db4">&nbsp;</td>
1105 <td class="db5">&nbsp;</td>
1106 <td class="db6">&nbsp;</td>
1107 <td class="db7">&nbsp;</td>
1108 </tr>
1109 <tr>
1110 <td class="db0">{image:db_field.gif|16|16}</td>
1111 <td class="db1">XWV_IP</td>
1112 <td class="db2">VARCHAR(32)</td>
1113 <td class="db3">{image:db_check.gif|16|16}</td>
1114 <td class="db4">&nbsp;</td>
1115 <td class="db5">&nbsp;</td>
1116 <td class="db6">&nbsp;</td>
1117 <td class="db7">&nbsp;</td>
1118 </tr>
1119 <tr>
1120 <td class="db0">{image:db_field.gif|16|16}</td>
1121 <td class="db1">XWV_USER_AGENT</td>
1122 <td class="db2">VARCHAR(255)</td>
1123 <td class="db3">{image:db_check.gif|16|16}</td>
1124 <td class="db4">&nbsp;</td>
1125 <td class="db5">&nbsp;</td>
1126 <td class="db6">&nbsp;</td>
1127 <td class="db7">&nbsp;</td>
1128 </tr>
1129 <tr>
1130 <td class="db0">{image:db_field.gif|16|16}</td>
1131 <td class="db1">XWV_COOKIE</td>
1132 <td class="db2">VARCHAR(255)</td>
1133 <td class="db3">{image:db_check.gif|16|16}</td>
1134 <td class="db4">&nbsp;</td>
1135 <td class="db5">&nbsp;</td>
1136 <td class="db6">&nbsp;</td>
1137 <td class="db7">&nbsp;</td>
1138 </tr>
1139 <tr>
1140 <td class="db0">{image:db_field.gif|16|16}</td>
1141 <td class="db1">XWV_UNIQUE_ID</td>
1142 <td class="db2">VARCHAR(255)</td>
1143 <td class="db3">{image:db_check.gif|16|16}</td>
1144 <td class="db4">&nbsp;</td>
1145 <td class="db5">&nbsp;</td>
1146 <td class="db6">&nbsp;</td>
1147 <td class="db7">&nbsp;</td>
1148 </tr>
1149 <tr>
1150 <td class="db0">{image:db_field.gif|16|16}</td>
1151 <td class="db1">XWV_PAGE_VIEWS</td>
1152 <td class="db2">INTEGER</td>
1153 <td class="db3">&nbsp;</td>
1154 <td class="db4">&nbsp;</td>
1155 <td class="db5">&nbsp;</td>
1156 <td class="db6">null</td>
1157 <td class="db7">&nbsp;</td>
1158 </tr>
1159 <tr>
1160 <td class="db0">{image:db_field.gif|16|16}</td>
1161 <td class="db1">XWV_SAVES</td>
1162 <td class="db2">INTEGER</td>
1163 <td class="db3">&nbsp;</td>
1164 <td class="db4">&nbsp;</td>
1165 <td class="db5">&nbsp;</td>
1166 <td class="db6">null</td>
1167 <td class="db7">&nbsp;</td>
1168 </tr>
1169 <tr>
1170 <td class="db0">{image:db_field.gif|16|16}</td>
1171 <td class="db1">XWV_DOWNLOADS</td>
1172 <td class="db2">INTEGER</td>
1173 <td class="db3">&nbsp;</td>
1174 <td class="db4">&nbsp;</td>
1175 <td class="db5">&nbsp;</td>
1176 <td class="db6">null</td>
1177 <td class="db7">&nbsp;</td>
1178 </tr>
1179 <tr>
1180 <td class="db0">{image:db_field.gif|16|16}</td>
1181 <td class="db1">XWV_START_DATE</td>
1182 <td class="db2">DATETIME</td>
1183 <td class="db3">&nbsp;</td>
1184 <td class="db4">&nbsp;</td>
1185 <td class="db5">&nbsp;</td>
1186 <td class="db6">null</td>
1187 <td class="db7">&nbsp;</td>
1188 </tr>
1189 <tr>
1190 <td class="db0">{image:db_field.gif|16|16}</td>
1191 <td class="db1">XWV_END_DATE</td>
1192 <td class="db2">DATETIME</td>
1193 <td class="db3">&nbsp;</td>
1194 <td class="db4">&nbsp;</td>
1195 <td class="db5">&nbsp;</td>
1196 <td class="db6">null</td>
1197 <td class="db7">&nbsp;</td>
1198 </tr>
1199 </table>
1200
1201 [^ back to top ^>#Tables]
1202 $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