Skip to Content

Wiki source code of DatabaseSchema

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