Skip to Content

Wiki source code of DatabaseSchema

Version 67.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>DevGuide.DsXWikiDatabaseListClasses]
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 * [xwikilistclasses>DevGuide.DsXWikiListClasses]
39 * [xwikilock>DevGuide.DsXWikiLocks]
40 * [xwikilongs>#XWiki+Longs]
41 * [xwikinumberclasses>DevGuide.DsXWikiNumberClasses]
42 * [xwikiobjects>DevGuide.DsXWikiObjects]
43 * xwikipreferences
44 * [xwikiproperties>DevGuide.DsXWikiProperties]
45 * xwikiircs
46 * xwikirecyclebin
47 * xwikislistclasses
48 * [xwikistatsdoc>#XWiki+Document+Stats]
49 * [xwikistatsreferer>#XWiki+Referer+Stats]
50 * [xwikistatsvisit>#XWiki+Visits]
51 * [xwikistringclasses>DevGuide.DsXWikiStringClasses]
52 * [xwikistrings>#XWiki+Strings]
53 </td>
54 </tr>
55 </table>
56
57 * [xwikilistclasses>#XWiki+List+Classes] ... not existing in Release 1.7.1
58
59 1.1.1 XWiki Strings
60
61 This table contains the string data from XWiki Objects.
62
63 <table border="0" width="100%" class="dbtable" cellpadding="3"
64 cellspacing="0">
65 <tr>
66 <td colspan="8" class="dbhead">xwikistrings</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">XWS_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">XWS_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 <tr>
99 <td class="db0">{image:db_field.gif|16|16}</td>
100 <td class="db1">XWS_VALUE</td>
101 <td class="db2">VARCHAR(255)</td>
102 <td class="db3">&nbsp;</td>
103 <td class="db4">&nbsp;</td>
104 <td class="db5">&nbsp;</td>
105 <td class="db6">null</td>
106 <td class="db7">&nbsp;</td>
107 </tr>
108 </table>
109
110 [^ back to top ^>#Tables]
111
112 1.1.1 XWiki Large Strings
113
114 This table contain the data for textarea properties in XWiki Objects.
115
116 <table border="0" width="100%" class="dbtable" cellpadding="3"
117 cellspacing="0">
118 <tr>
119 <td colspan="8" class="dbhead">xwikilargestrings</td>
120 </tr>
121 <tr>
122 <th class="db0">&nbsp;</th>
123 <th class="db1">Column Name</th>
124 <th class="db2">Datatype</th>
125 <th class="db3">Not null</th>
126 <th class="db4">auto inc</th>
127 <th class="db5">flags</th>
128 <th class="db6">Default Value</th>
129 <th class="db7">Comments</th>
130 </tr>
131 <tr>
132 <td class="db0">{image:db_key.gif|16|16}</td>
133 <td class="db1">XWL_ID</td>
134 <td class="db2">INTEGER</td>
135 <td class="db3">{image:db_check.gif|16|16}</td>
136 <td class="db4">&nbsp;</td>
137 <td class="db5">&nbsp;</td>
138 <td class="db6">0</td>
139 <td class="db7">&nbsp;</td>
140 </tr>
141 <tr>
142 <td class="db0">{image:db_key.gif|16|16}</td>
143 <td class="db1">XWL_NAME</td>
144 <td class="db2">VARCHAR(255)</td>
145 <td class="db3">{image:db_check.gif|16|16}</td>
146 <td class="db4">&nbsp;</td>
147 <td class="db5">&nbsp;</td>
148 <td class="db6">&nbsp;</td>
149 <td class="db7">&nbsp;</td>
150 </tr>
151 <tr>
152 <td class="db0">{image:db_field.gif|16|16}</td>
153 <td class="db1">XWL_VALUE</td>
154 <td class="db2">TEXT</td>
155 <td class="db3">&nbsp;</td>
156 <td class="db4">&nbsp;</td>
157 <td class="db5">&nbsp;</td>
158 <td class="db6">null</td>
159 <td class="db7">&nbsp;</td>
160 </tr>
161 </table>
162
163 [^ back to top ^>#Tables]
164
165 1.1.1 XWiki Dates
166
167 This table contains the data of date properties in XWiki objects.
168
169 <table border="0" width="100%" class="dbtable" cellpadding="3"
170 cellspacing="0">
171 <tr>
172 <td colspan="8" class="dbhead">xwikidates</td>
173 </tr>
174 <tr>
175 <th class="db0">&nbsp;</th>
176 <th class="db1">Column Name</th>
177 <th class="db2">Datatype</th>
178 <th class="db3">Not null</th>
179 <th class="db4">auto inc</th>
180 <th class="db5">flags</th>
181 <th class="db6">Default Value</th>
182 <th class="db7">Comments</th>
183 </tr>
184 <tr>
185 <td class="db0">{image:db_key.gif|16|16}</td>
186 <td class="db1">XWS_ID</td>
187 <td class="db2">INTEGER</td>
188 <td class="db3">{image:db_check.gif|16|16}</td>
189 <td class="db4">&nbsp;</td>
190 <td class="db5">&nbsp;</td>
191 <td class="db6">0</td>
192 <td class="db7">&nbsp;</td>
193 </tr>
194 <tr>
195 <td class="db0">{image:db_key.gif|16|16}</td>
196 <td class="db1">XWS_NAME</td>
197 <td class="db2">VARCHAR(255)</td>
198 <td class="db3">{image:db_check.gif|16|16}</td>
199 <td class="db4">&nbsp;</td>
200 <td class="db5">&nbsp;</td>
201 <td class="db6">&nbsp;</td>
202 <td class="db7">&nbsp;</td>
203 </tr>
204 <tr>
205 <td class="db0">{image:db_field.gif|16|16}</td>
206 <td class="db1">XWS_VALUE</td>
207 <td class="db2">DATETIME</td>
208 <td class="db3">&nbsp;</td>
209 <td class="db4">&nbsp;</td>
210 <td class="db5">&nbsp;</td>
211 <td class="db6">null</td>
212 <td class="db7">&nbsp;</td>
213 </tr>
214 </table>
215
216 The field name prefix is this table is wrong. It should be corrected in xwiki.hbm.xml.
217
218 [^ back to top ^>#Tables]
219
220 1.1.1 XWiki Doubles
221
222 This table contain the data for double properties in XWiki Objects.
223
224 <table border="0" width="100%" class="dbtable" cellpadding="3"
225 cellspacing="0">
226 <tr>
227 <td colspan="8" class="dbhead">xwikidoubles</td>
228 </tr>
229 <tr>
230 <th class="db0">&nbsp;</th>
231 <th class="db1">Column Name</th>
232 <th class="db2">Datatype</th>
233 <th class="db3">Not null</th>
234 <th class="db4">auto inc</th>
235 <th class="db5">flags</th>
236 <th class="db6">Default Value</th>
237 <th class="db7">Comments</th>
238 </tr>
239 <tr>
240 <td class="db0">{image:db_key.gif|16|16}</td>
241 <td class="db1">XWD_ID</td>
242 <td class="db2">INTEGER</td>
243 <td class="db3">{image:db_check.gif|16|16}</td>
244 <td class="db4">&nbsp;</td>
245 <td class="db5">&nbsp;</td>
246 <td class="db6">0</td>
247 <td class="db7">&nbsp;</td>
248 </tr>
249 <tr>
250 <td class="db0">{image:db_key.gif|16|16}</td>
251 <td class="db1">XWD_NAME</td>
252 <td class="db2">VARCHAR(255)</td>
253 <td class="db3">{image:db_check.gif|16|16}</td>
254 <td class="db4">&nbsp;</td>
255 <td class="db5">&nbsp;</td>
256 <td class="db6">&nbsp;</td>
257 <td class="db7">&nbsp;</td>
258 </tr>
259 <tr>
260 <td class="db0">{image:db_field.gif|16|16}</td>
261 <td class="db1">XWD_VALUE</td>
262 <td class="db2">DOUBLE</td>
263 <td class="db3">&nbsp;</td>
264 <td class="db4">&nbsp;</td>
265 <td class="db5">&nbsp;</td>
266 <td class="db6">null</td>
267 <td class="db7">&nbsp;</td>
268 </tr>
269 </table>
270
271 [^ back to top ^>#Tables]
272
273 1.1.1 XWiki Floats
274
275 This table contain the data for floats properties in XWiki Objects.
276
277
278 <table border="0" width="100%" class="dbtable" cellpadding="3"
279 cellspacing="0">
280 <tr>
281 <td colspan="8" class="dbhead">xwikifloats</td>
282 </tr>
283 <tr>
284 <th class="db0">&nbsp;</th>
285 <th class="db1">Column Name</th>
286 <th class="db2">Datatype</th>
287 <th class="db3">Not null</th>
288 <th class="db4">auto inc</th>
289 <th class="db5">flags</th>
290 <th class="db6">Default Value</th>
291 <th class="db7">Comments</th>
292 </tr>
293 <tr>
294 <td class="db0">{image:db_key.gif|16|16}</td>
295 <td class="db1">XWF_ID</td>
296 <td class="db2">INTEGER</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">0</td>
301 <td class="db7">&nbsp;</td>
302 </tr>
303 <tr>
304 <td class="db0">{image:db_key.gif|16|16}</td>
305 <td class="db1">XWF_NAME</td>
306 <td class="db2">VARCHAR(255)</td>
307 <td class="db3">{image:db_check.gif|16|16}</td>
308 <td class="db4">&nbsp;</td>
309 <td class="db5">&nbsp;</td>
310 <td class="db6">&nbsp;</td>
311 <td class="db7">&nbsp;</td>
312 </tr>
313 <tr>
314 <td class="db0">{image:db_field.gif|16|16}</td>
315 <td class="db1">XWF_VALUE</td>
316 <td class="db2">FLOAT</td>
317 <td class="db3">&nbsp;</td>
318 <td class="db4">&nbsp;</td>
319 <td class="db5">&nbsp;</td>
320 <td class="db6">null</td>
321 <td class="db7">&nbsp;</td>
322 </tr>
323 </table>
324
325 [^ back to top ^>#Tables]
326
327 1.1.1 XWiki Integers
328
329 This table contain the data for integer properties in XWiki Objects.
330
331
332 <table border="0" width="100%" class="dbtable" cellpadding="3"
333 cellspacing="0">
334 <tr>
335 <td colspan="8" class="dbhead">xwikiintegers</td>
336 </tr>
337 <tr>
338 <th class="db0">&nbsp;</th>
339 <th class="db1">Column Name</th>
340 <th class="db2">Datatype</th>
341 <th class="db3">Not null</th>
342 <th class="db4">auto inc</th>
343 <th class="db5">flags</th>
344 <th class="db6">Default Value</th>
345 <th class="db7">Comments</th>
346 </tr>
347 <tr>
348 <td class="db0">{image:db_key.gif|16|16}</td>
349 <td class="db1">XWI_ID</td>
350 <td class="db2">INTEGER</td>
351 <td class="db3">{image:db_check.gif|16|16}</td>
352 <td class="db4">&nbsp;</td>
353 <td class="db5">&nbsp;</td>
354 <td class="db6">0</td>
355 <td class="db7">&nbsp;</td>
356 </tr>
357 <tr>
358 <td class="db0">{image:db_key.gif|16|16}</td>
359 <td class="db1">XWI_NAME</td>
360 <td class="db2">VARCHAR(255)</td>
361 <td class="db3">{image:db_check.gif|16|16}</td>
362 <td class="db4">&nbsp;</td>
363 <td class="db5">&nbsp;</td>
364 <td class="db6">&nbsp;</td>
365 <td class="db7">&nbsp;</td>
366 </tr>
367 <tr>
368 <td class="db0">{image:db_field.gif|16|16}</td>
369 <td class="db1">XWI_VALUE</td>
370 <td class="db2">INTEGER</td>
371 <td class="db3">&nbsp;</td>
372 <td class="db4">&nbsp;</td>
373 <td class="db5">&nbsp;</td>
374 <td class="db6">null</td>
375 <td class="db7">&nbsp;</td>
376 </tr>
377 </table>
378
379 [^ back to top ^>#Tables]
380
381 1.1.1 XWiki Longs
382
383 This table contain the data for long properties in XWiki Objects.
384
385 <table border="0" width="100%" class="dbtable" cellpadding="3"
386 cellspacing="0">
387 <tr>
388 <td colspan="8" class="dbhead">xwikilongs</td>
389 </tr>
390 <tr>
391 <th class="db0">&nbsp;</th>
392 <th class="db1">Column Name</th>
393 <th class="db2">Datatype</th>
394 <th class="db3">Not null</th>
395 <th class="db4">auto inc</th>
396 <th class="db5">flags</th>
397 <th class="db6">Default Value</th>
398 <th class="db7">Comments</th>
399 </tr>
400 <tr>
401 <td class="db0">{image:db_key.gif|16|16}</td>
402 <td class="db1">XWL_ID</td>
403 <td class="db2">INTEGER</td>
404 <td class="db3">{image:db_check.gif|16|16}</td>
405 <td class="db4">&nbsp;</td>
406 <td class="db5">&nbsp;</td>
407 <td class="db6">0</td>
408 <td class="db7">&nbsp;</td>
409 </tr>
410 <tr>
411 <td class="db0">{image:db_key.gif|16|16}</td>
412 <td class="db1">XWL_NAME</td>
413 <td class="db2">VARCHAR(255)</td>
414 <td class="db3">{image:db_check.gif|16|16}</td>
415 <td class="db4">&nbsp;</td>
416 <td class="db5">&nbsp;</td>
417 <td class="db6">&nbsp;</td>
418 <td class="db7">&nbsp;</td>
419 </tr>
420 <tr>
421 <td class="db0">{image:db_field.gif|16|16}</td>
422 <td class="db1">XWL_VALUE</td>
423 <td class="db2">BIGINT(20)</td>
424 <td class="db3">&nbsp;</td>
425 <td class="db4">&nbsp;</td>
426 <td class="db5">&nbsp;</td>
427 <td class="db6">null</td>
428 <td class="db7">&nbsp;</td>
429 </tr>
430 </table>
431
432 [^ back to top ^>#Tables]
433
434 1.1.1 XWiki List Items
435
436 This table contain the data for lists properties in XWiki Objects.
437
438 <table border="0" width="100%" class="dbtable" cellpadding="3"
439 cellspacing="0">
440 <tr>
441 <td colspan="8" class="dbhead">xwikilistitems</td>
442 </tr>
443 <tr>
444 <th class="db0">&nbsp;</th>
445 <th class="db1">Column Name</th>
446 <th class="db2">Datatype</th>
447 <th class="db3">Not null</th>
448 <th class="db4">auto inc</th>
449 <th class="db5">flags</th>
450 <th class="db6">Default Value</th>
451 <th class="db7">Comments</th>
452 </tr>
453 <tr>
454 <td class="db0">{image:db_key.gif|16|16}</td>
455 <td class="db1">XWL_ID</td>
456 <td class="db2">INTEGER</td>
457 <td class="db3">{image:db_check.gif|16|16}</td>
458 <td class="db4">&nbsp;</td>
459 <td class="db5">&nbsp;</td>
460 <td class="db6">0</td>
461 <td class="db7">&nbsp;</td>
462 </tr>
463 <tr>
464 <td class="db0">{image:db_key.gif|16|16}</td>
465 <td class="db1">XWL_NAME</td>
466 <td class="db2">VARCHAR(255)</td>
467 <td class="db3">{image:db_check.gif|16|16}</td>
468 <td class="db4">&nbsp;</td>
469 <td class="db5">&nbsp;</td>
470 <td class="db6">&nbsp;</td>
471 <td class="db7">&nbsp;</td>
472 </tr>
473 <tr>
474 <td class="db0">{image:db_field.gif|16|16}</td>
475 <td class="db1">XWL_VALUE</td>
476 <td class="db2">VARCHAR(255)</td>
477 <td class="db3">&nbsp;</td>
478 <td class="db4">&nbsp;</td>
479 <td class="db5">&nbsp;</td>
480 <td class="db6">null</td>
481 <td class="db7">&nbsp;</td>
482 </tr>
483 <tr>
484 <td class="db0">{image:db_key.gif|16|16}</td>
485 <td class="db1">XWL_NUMBER</td>
486 <td class="db2">INTEGER</td>
487 <td class="db3">{image:db_check.gif|16|16}</td>
488 <td class="db4">&nbsp;</td>
489 <td class="db5">&nbsp;</td>
490 <td class="db6">0</td>
491 <td class="db7">&nbsp;</td>
492 </tr>
493 </table>
494
495 [^ back to top ^>#Tables]
496
497 1.1.1 XWiki Lists
498
499 This table contain the data for lists properties in XWiki Objects.
500
501
502 <table border="0" width="100%" class="dbtable" cellpadding="3"
503 cellspacing="0">
504 <tr>
505 <td colspan="8" class="dbhead">xwikilists</td>
506 </tr>
507 <tr>
508 <th class="db0">&nbsp;</th>
509 <th class="db1">Column Name</th>
510 <th class="db2">Datatype</th>
511 <th class="db3">Not null</th>
512 <th class="db4">auto inc</th>
513 <th class="db5">flags</th>
514 <th class="db6">Default Value</th>
515 <th class="db7">Comments</th>
516 </tr>
517 <tr>
518 <td class="db0">{image:db_key.gif|16|16}</td>
519 <td class="db1">XWL_ID</td>
520 <td class="db2">INTEGER</td>
521 <td class="db3">{image:db_check.gif|16|16}</td>
522 <td class="db4">&nbsp;</td>
523 <td class="db5">&nbsp;</td>
524 <td class="db6">0</td>
525 <td class="db7">&nbsp;</td>
526 </tr>
527 <tr>
528 <td class="db0">{image:db_key.gif|16|16}</td>
529 <td class="db1">XWL_NAME</td>
530 <td class="db2">VARCHAR(255)</td>
531 <td class="db3">{image:db_check.gif|16|16}</td>
532 <td class="db4">&nbsp;</td>
533 <td class="db5">&nbsp;</td>
534 <td class="db6">&nbsp;</td>
535 <td class="db7">&nbsp;</td>
536 </tr>
537 </table>
538
539 [^ back to top ^>#Tables]
540
541 1.1 Statistics
542
543 1.1.1 XWiki Document Stats
544
545 This table contain stats information, namely page/space/wiki views and edits
546 .
547 <table border="0" width="100%" class="dbtable" cellpadding="3"
548 cellspacing="0">
549 <tr>
550 <td colspan="8" class="dbhead">xwikistatsdoc</td>
551 </tr>
552 <tr>
553 <th class="db0">&nbsp;</th>
554 <th class="db1">Column Name</th>
555 <th class="db2">Datatype</th>
556 <th class="db3">Not null</th>
557 <th class="db4">auto inc</th>
558 <th class="db5">flags</th>
559 <th class="db6">Default Value</th>
560 <th class="db7">Comments</th>
561 </tr>
562 <tr>
563 <td class="db0">{image:db_key.gif|16|16}</td>
564 <td class="db1">XWS_ID</td>
565 <td class="db2">INTEGER</td>
566 <td class="db3">{image:db_check.gif|16|16}</td>
567 <td class="db4">&nbsp;</td>
568 <td class="db5">&nbsp;</td>
569 <td class="db6">0</td>
570 <td class="db7">&nbsp;</td>
571 </tr>
572 <tr>
573 <td class="db0">{image:db_field.gif|16|16}</td>
574 <td class="db1">XWS_NUMBER</td>
575 <td class="db2">INTEGER</td>
576 <td class="db3">&nbsp;</td>
577 <td class="db4">&nbsp;</td>
578 <td class="db5">&nbsp;</td>
579 <td class="db6">null&nbsp;</td>
580 <td class="db7">&nbsp;</td>
581 </tr>
582 <tr>
583 <td class="db0">{image:db_field.gif|16|16}</td>
584 <td class="db1">XWS_NAME</td>
585 <td class="db2">VARCHAR(255)</td>
586 <td class="db3">{image:db_check.gif|16|16}</td>
587 <td class="db4">&nbsp;</td>
588 <td class="db5">&nbsp;</td>
589 <td class="db6">&nbsp;</td>
590 <td class="db7">&nbsp;</td>
591 </tr>
592 <tr>
593 <td class="db0">{image:db_field.gif|16|16}</td>
594 <td class="db1">XWS_CLASSNAME</td>
595 <td class="db2">VARCHAR(255)</td>
596 <td class="db3">{image:db_check.gif|16|16}</td>
597 <td class="db4">&nbsp;</td>
598 <td class="db5">&nbsp;</td>
599 <td class="db6">&nbsp;</td>
600 <td class="db7">&nbsp;</td>
601 </tr>
602 <tr>
603 <td class="db0">{image:db_field.gif|16|16}</td>
604 <td class="db1">XWS_ACTION</td>
605 <td class="db2">VARCHAR(255)</td>
606 <td class="db3">{image:db_check.gif|16|16}</td>
607 <td class="db4">&nbsp;</td>
608 <td class="db5">&nbsp;</td>
609 <td class="db6">&nbsp;</td>
610 <td class="db7">&nbsp;</td>
611 </tr>
612 <tr>
613 <td class="db0">{image:db_field.gif|16|16}</td>
614 <td class="db1">XWS_PAGE_VIEWS</td>
615 <td class="db2">INTEGER</td>
616 <td class="db3">&nbsp;</td>
617 <td class="db4">&nbsp;</td>
618 <td class="db5">&nbsp;</td>
619 <td class="db6">null</td>
620 <td class="db7">&nbsp;</td>
621 </tr>
622 <tr>
623 <td class="db0">{image:db_field.gif|16|16}</td>
624 <td class="db1">XWS_UNIQUE_VISITORS</td>
625 <td class="db2">INTEGER</td>
626 <td class="db3">&nbsp;</td>
627 <td class="db4">&nbsp;</td>
628 <td class="db5">&nbsp;</td>
629 <td class="db6">null</td>
630 <td class="db7">&nbsp;</td>
631 </tr>
632 <tr>
633 <td class="db0">{image:db_field.gif|16|16}</td>
634 <td class="db1">XWS_PERIOD</td>
635 <td class="db2">INTEGER</td>
636 <td class="db3">&nbsp;</td>
637 <td class="db4">&nbsp;</td>
638 <td class="db5">&nbsp;</td>
639 <td class="db6">null</td>
640 <td class="db7">&nbsp;</td>
641 </tr>
642 <tr>
643 <td class="db0">{image:db_field.gif|16|16}</td>
644 <td class="db1">XWS_VISITS</td>
645 <td class="db2">INTEGER</td>
646 <td class="db3">&nbsp;</td>
647 <td class="db4">&nbsp;</td>
648 <td class="db5">&nbsp;</td>
649 <td class="db6">null</td>
650 <td class="db7">&nbsp;</td>
651 </tr>
652 </table>
653
654 [^ back to top ^>#Tables]
655
656 1.1.1 XWiki Referer Stats
657
658 This page contains the incoming externa links on the Wiki.
659
660 <table border="0" width="100%" class="dbtable" cellpadding="3"
661 cellspacing="0">
662 <tr>
663 <td colspan="8" class="dbhead">xwikistatsreferer</td>
664 </tr>
665 <tr>
666 <th class="db0">&nbsp;</th>
667 <th class="db1">Column Name</th>
668 <th class="db2">Datatype</th>
669 <th class="db3">Not null</th>
670 <th class="db4">auto inc</th>
671 <th class="db5">flags</th>
672 <th class="db6">Default Value</th>
673 <th class="db7">Comments</th>
674 </tr>
675 <tr>
676 <td class="db0">{image:db_key.gif|16|16}</td>
677 <td class="db1">XWR_ID</td>
678 <td class="db2">INTEGER</td>
679 <td class="db3">{image:db_check.gif|16|16}</td>
680 <td class="db4">&nbsp;</td>
681 <td class="db5">&nbsp;</td>
682 <td class="db6">0</td>
683 <td class="db7">&nbsp;</td>
684 </tr>
685 <tr>
686 <td class="db0">{image:db_field.gif|16|16}</td>
687 <td class="db1">XWR_NUMBER</td>
688 <td class="db2">INTEGER</td>
689 <td class="db3">&nbsp;</td>
690 <td class="db4">&nbsp;</td>
691 <td class="db5">&nbsp;</td>
692 <td class="db6">null</td>
693 <td class="db7">&nbsp;</td>
694 </tr>
695 <tr>
696 <td class="db0">{image:db_field.gif|16|16}</td>
697 <td class="db1">XWR_NAME</td>
698 <td class="db2">VARCHAR(255)</td>
699 <td class="db3">{image:db_check.gif|16|16}</td>
700 <td class="db4">&nbsp;</td>
701 <td class="db5">&nbsp;</td>
702 <td class="db6">&nbsp;</td>
703 <td class="db7">&nbsp;</td>
704 </tr>
705 <tr>
706 <td class="db0">{image:db_field.gif|16|16}</td>
707 <td class="db1">XWR_CLASSNAME</td>
708 <td class="db2">VARCHAR(255)</td>
709 <td class="db3">{image:db_check.gif|16|16}</td>
710 <td class="db4">&nbsp;</td>
711 <td class="db5">&nbsp;</td>
712 <td class="db6">&nbsp;</td>
713 <td class="db7">&nbsp;</td>
714 </tr>
715 <tr>
716 <td class="db0">{image:db_field.gif|16|16}</td>
717 <td class="db1">XWR_REFERER</td>
718 <td class="db2">VARCHAR(255)</td>
719 <td class="db3">{image:db_check.gif|16|16}</td>
720 <td class="db4">&nbsp;</td>
721 <td class="db5">&nbsp;</td>
722 <td class="db6">&nbsp;</td>
723 <td class="db7">&nbsp;</td>
724 </tr>
725 <tr>
726 <td class="db0">{image:db_field.gif|16|16}</td>
727 <td class="db1">XWR_PAGE_VIEWS</td>
728 <td class="db2">INTEGER</td>
729 <td class="db3">&nbsp;</td>
730 <td class="db4">&nbsp;</td>
731 <td class="db5">&nbsp;</td>
732 <td class="db6">null</td>
733 <td class="db7">&nbsp;</td>
734 </tr>
735 <tr>
736 <td class="db0">{image:db_field.gif|16|16}</td>
737 <td class="db1">XWR_PERIOD</td>
738 <td class="db2">INTEGER</td>
739 <td class="db3">&nbsp;</td>
740 <td class="db4">&nbsp;</td>
741 <td class="db5">&nbsp;</td>
742 <td class="db6">null</td>
743 <td class="db7">&nbsp;</td>
744 </tr>
745 </table>
746
747 [^ back to top ^>#Tables]
748
749 1.1.1 XWiki Visits
750
751 This table contains the sessions of the named users.
752
753 <table border="0" width="100%" class="dbtable" cellpadding="3"
754 cellspacing="0">
755 <tr>
756 <td colspan="8" class="dbhead">xwikistatsvisit</td>
757 </tr>
758 <tr>
759 <th class="db0">&nbsp;</th>
760 <th class="db1">Column Name</th>
761 <th class="db2">Datatype</th>
762 <th class="db3">Not null</th>
763 <th class="db4">auto inc</th>
764 <th class="db5">flags</th>
765 <th class="db6">Default Value</th>
766 <th class="db7">Comments</th>
767 </tr>
768 <tr>
769 <td class="db0">{image:db_key.gif|16|16}</td>
770 <td class="db1">XWV_ID</td>
771 <td class="db2">INTEGER</td>
772 <td class="db3">{image:db_check.gif|16|16}</td>
773 <td class="db4">&nbsp;</td>
774 <td class="db5">&nbsp;</td>
775 <td class="db6">0</td>
776 <td class="db7">&nbsp;</td>
777 </tr>
778 <tr>
779 <td class="db0">{image:db_field.gif|16|16}</td>
780 <td class="db1">XWV_NUMBER</td>
781 <td class="db2">INTEGER</td>
782 <td class="db3">&nbsp;</td>
783 <td class="db4">&nbsp;</td>
784 <td class="db5">&nbsp;</td>
785 <td class="db6">null&nbsp;</td>
786 <td class="db7">&nbsp;</td>
787 </tr>
788 <tr>
789 <td class="db0">{image:db_field.gif|16|16}</td>
790 <td class="db1">XWV_NAME</td>
791 <td class="db2">VARCHAR(255)</td>
792 <td class="db3">{image:db_check.gif|16|16}</td>
793 <td class="db4">&nbsp;</td>
794 <td class="db5">&nbsp;</td>
795 <td class="db6">&nbsp;</td>
796 <td class="db7">&nbsp;</td>
797 </tr>
798 <tr>
799 <td class="db0">{image:db_field.gif|16|16}</td>
800 <td class="db1">XWV_CLASSNAME</td>
801 <td class="db2">VARCHAR(255)</td>
802 <td class="db3">{image:db_check.gif|16|16}</td>
803 <td class="db4">&nbsp;</td>
804 <td class="db5">&nbsp;</td>
805 <td class="db6">&nbsp;</td>
806 <td class="db7">&nbsp;</td>
807 </tr>
808 <tr>
809 <td class="db0">{image:db_field.gif|16|16}</td>
810 <td class="db1">XWV_IP</td>
811 <td class="db2">VARCHAR(32)</td>
812 <td class="db3">{image:db_check.gif|16|16}</td>
813 <td class="db4">&nbsp;</td>
814 <td class="db5">&nbsp;</td>
815 <td class="db6">&nbsp;</td>
816 <td class="db7">&nbsp;</td>
817 </tr>
818 <tr>
819 <td class="db0">{image:db_field.gif|16|16}</td>
820 <td class="db1">XWV_USER_AGENT</td>
821 <td class="db2">VARCHAR(255)</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">&nbsp;</td>
826 <td class="db7">&nbsp;</td>
827 </tr>
828 <tr>
829 <td class="db0">{image:db_field.gif|16|16}</td>
830 <td class="db1">XWV_COOKIE</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 <tr>
839 <td class="db0">{image:db_field.gif|16|16}</td>
840 <td class="db1">XWV_UNIQUE_ID</td>
841 <td class="db2">VARCHAR(255)</td>
842 <td class="db3">{image:db_check.gif|16|16}</td>
843 <td class="db4">&nbsp;</td>
844 <td class="db5">&nbsp;</td>
845 <td class="db6">&nbsp;</td>
846 <td class="db7">&nbsp;</td>
847 </tr>
848 <tr>
849 <td class="db0">{image:db_field.gif|16|16}</td>
850 <td class="db1">XWV_PAGE_VIEWS</td>
851 <td class="db2">INTEGER</td>
852 <td class="db3">&nbsp;</td>
853 <td class="db4">&nbsp;</td>
854 <td class="db5">&nbsp;</td>
855 <td class="db6">null</td>
856 <td class="db7">&nbsp;</td>
857 </tr>
858 <tr>
859 <td class="db0">{image:db_field.gif|16|16}</td>
860 <td class="db1">XWV_SAVES</td>
861 <td class="db2">INTEGER</td>
862 <td class="db3">&nbsp;</td>
863 <td class="db4">&nbsp;</td>
864 <td class="db5">&nbsp;</td>
865 <td class="db6">null</td>
866 <td class="db7">&nbsp;</td>
867 </tr>
868 <tr>
869 <td class="db0">{image:db_field.gif|16|16}</td>
870 <td class="db1">XWV_DOWNLOADS</td>
871 <td class="db2">INTEGER</td>
872 <td class="db3">&nbsp;</td>
873 <td class="db4">&nbsp;</td>
874 <td class="db5">&nbsp;</td>
875 <td class="db6">null</td>
876 <td class="db7">&nbsp;</td>
877 </tr>
878 <tr>
879 <td class="db0">{image:db_field.gif|16|16}</td>
880 <td class="db1">XWV_START_DATE</td>
881 <td class="db2">DATETIME</td>
882 <td class="db3">&nbsp;</td>
883 <td class="db4">&nbsp;</td>
884 <td class="db5">&nbsp;</td>
885 <td class="db6">null</td>
886 <td class="db7">&nbsp;</td>
887 </tr>
888 <tr>
889 <td class="db0">{image:db_field.gif|16|16}</td>
890 <td class="db1">XWV_END_DATE</td>
891 <td class="db2">DATETIME</td>
892 <td class="db3">&nbsp;</td>
893 <td class="db4">&nbsp;</td>
894 <td class="db5">&nbsp;</td>
895 <td class="db6">null</td>
896 <td class="db7">&nbsp;</td>
897 </tr>
898 </table>
899
900 [^ back to top ^>#Tables]
901 1.1.1 XWiki List Classes
902
903 This table contains the declaration of the list properties in XWiki classes.
904
905 <table border="0" width="100%" class="dbtable" cellpadding="3"
906 cellspacing="0">
907 <tr>
908 <td colspan="8" class="dbhead">xwikislistclasses</td>
909 </tr>
910 <tr>
911 <th class="db0">&nbsp;</th>
912 <th class="db1">Column Name</th>
913 <th class="db2">Datatype</th>
914 <th class="db3">Not null</th>
915 <th class="db4">auto inc</th>
916 <th class="db5">flags</th>
917 <th class="db6">Default Value</th>
918 <th class="db7">Comments</th>
919 </tr>
920 <tr>
921 <td class="db0">{image:db_key.gif|16|16}</td>
922 <td class="db1">XWL_ID</td>
923 <td class="db2">INTEGER</td>
924 <td class="db3">{image:db_check.gif|16|16}</td>
925 <td class="db4">&nbsp;</td>
926 <td class="db5">&nbsp;</td>
927 <td class="db6">0</td>
928 <td class="db7">&nbsp;</td>
929 </tr>
930 <tr>
931 <td class="db0">{image:db_key.gif|16|16}</td>
932 <td class="db1">XWL_NAME</td>
933 <td class="db2">VARCHAR(255)</td>
934 <td class="db3">{image:db_check.gif|16|16}</td>
935 <td class="db4">&nbsp;</td>
936 <td class="db5">&nbsp;</td>
937 <td class="db6">&nbsp;</td>
938 <td class="db7">&nbsp;</td>
939 </tr>
940 <tr>
941 <td class="db0">{image:db_field.gif|16|16}</td>
942 <td class="db1">XWL_DISPLAYTYPE</td>
943 <td class="db2">VARCHAR(20)</td>
944 <td class="db3">&nbsp;</td>
945 <td class="db4">&nbsp;</td>
946 <td class="db5">&nbsp;</td>
947 <td class="db6">null</td>
948 <td class="db7">&nbsp;</td>
949 </tr>
950 <tr>
951 <td class="db0">{image:db_field.gif|16|16}</td>
952 <td class="db1">XWL_MULTISELECT</td>
953 <td class="db2">TINYINT(1)</td>
954 <td class="db3">&nbsp;</td>
955 <td class="db4">&nbsp;</td>
956 <td class="db5">&nbsp;</td>
957 <td class="db6">null</td>
958 <td class="db7">&nbsp;</td>
959 </tr>
960 <tr>
961 <td class="db0">{image:db_field.gif|16|16}</td>
962 <td class="db1">XWL_SIZE</td>
963 <td class="db2">INTEGER</td>
964 <td class="db3">&nbsp;</td>
965 <td class="db4">&nbsp;</td>
966 <td class="db5">&nbsp;</td>
967 <td class="db6">null</td>
968 <td class="db7">&nbsp;</td>
969 </tr>
970 <tr>
971 <td class="db0">{image:db_field.gif|16|16}</td>
972 <td class="db1">XWL_RELATIONAL</td>
973 <td class="db2">TINYINT(1)</td>
974 <td class="db3">&nbsp;</td>
975 <td class="db4">&nbsp;</td>
976 <td class="db5">&nbsp;</td>
977 <td class="db6">null</td>
978 <td class="db7">&nbsp;</td>
979 </tr>
980 <tr>
981 <td class="db0">{image:db_field.gif|16|16}</td>
982 <td class="db1">XWL_VALUES</td>
983 <td class="db2">TEXT</td>
984 <td class="db3">&nbsp;</td>
985 <td class="db4">&nbsp;</td>
986 <td class="db5">&nbsp;</td>
987 <td class="db6">null</td>
988 <td class="db7">&nbsp;</td>
989 </tr>
990 </table>
991
992 [^ back to top ^>#Tables]
993 $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