Skip to Content

Wiki source code of DatabaseSchema

Version 65.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 Properties
60
61 This table contains the list of properties in XWiki Objects. Each property has an entry in the type specific table.
62
63 <table border="0" width="100%" class="dbtable" cellpadding="3"
64 cellspacing="0">
65 <tr>
66 <td colspan="8" class="dbhead">xwikiproperties</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">XWP_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">XWP_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">XWP_CLASSTYPE</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 Strings
113
114 This table contains the string data from XWiki Objects.
115
116 <table border="0" width="100%" class="dbtable" cellpadding="3"
117 cellspacing="0">
118 <tr>
119 <td colspan="8" class="dbhead">xwikistrings</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">XWS_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">XWS_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">XWS_VALUE</td>
154 <td class="db2">VARCHAR(255)</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 Large Strings
166
167 This table contain the data for textarea 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">xwikilargestrings</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">XWL_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">XWL_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">XWL_VALUE</td>
207 <td class="db2">TEXT</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 [^ back to top ^>#Tables]
217
218 1.1.1 XWiki Dates
219
220 This table contains the data of date properties in XWiki objects.
221
222 <table border="0" width="100%" class="dbtable" cellpadding="3"
223 cellspacing="0">
224 <tr>
225 <td colspan="8" class="dbhead">xwikidates</td>
226 </tr>
227 <tr>
228 <th class="db0">&nbsp;</th>
229 <th class="db1">Column Name</th>
230 <th class="db2">Datatype</th>
231 <th class="db3">Not null</th>
232 <th class="db4">auto inc</th>
233 <th class="db5">flags</th>
234 <th class="db6">Default Value</th>
235 <th class="db7">Comments</th>
236 </tr>
237 <tr>
238 <td class="db0">{image:db_key.gif|16|16}</td>
239 <td class="db1">XWS_ID</td>
240 <td class="db2">INTEGER</td>
241 <td class="db3">{image:db_check.gif|16|16}</td>
242 <td class="db4">&nbsp;</td>
243 <td class="db5">&nbsp;</td>
244 <td class="db6">0</td>
245 <td class="db7">&nbsp;</td>
246 </tr>
247 <tr>
248 <td class="db0">{image:db_key.gif|16|16}</td>
249 <td class="db1">XWS_NAME</td>
250 <td class="db2">VARCHAR(255)</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">&nbsp;</td>
255 <td class="db7">&nbsp;</td>
256 </tr>
257 <tr>
258 <td class="db0">{image:db_field.gif|16|16}</td>
259 <td class="db1">XWS_VALUE</td>
260 <td class="db2">DATETIME</td>
261 <td class="db3">&nbsp;</td>
262 <td class="db4">&nbsp;</td>
263 <td class="db5">&nbsp;</td>
264 <td class="db6">null</td>
265 <td class="db7">&nbsp;</td>
266 </tr>
267 </table>
268
269 The field name prefix is this table is wrong. It should be corrected in xwiki.hbm.xml.
270
271 [^ back to top ^>#Tables]
272
273 1.1.1 XWiki Doubles
274
275 This table contain the data for double properties in XWiki Objects.
276
277 <table border="0" width="100%" class="dbtable" cellpadding="3"
278 cellspacing="0">
279 <tr>
280 <td colspan="8" class="dbhead">xwikidoubles</td>
281 </tr>
282 <tr>
283 <th class="db0">&nbsp;</th>
284 <th class="db1">Column Name</th>
285 <th class="db2">Datatype</th>
286 <th class="db3">Not null</th>
287 <th class="db4">auto inc</th>
288 <th class="db5">flags</th>
289 <th class="db6">Default Value</th>
290 <th class="db7">Comments</th>
291 </tr>
292 <tr>
293 <td class="db0">{image:db_key.gif|16|16}</td>
294 <td class="db1">XWD_ID</td>
295 <td class="db2">INTEGER</td>
296 <td class="db3">{image:db_check.gif|16|16}</td>
297 <td class="db4">&nbsp;</td>
298 <td class="db5">&nbsp;</td>
299 <td class="db6">0</td>
300 <td class="db7">&nbsp;</td>
301 </tr>
302 <tr>
303 <td class="db0">{image:db_key.gif|16|16}</td>
304 <td class="db1">XWD_NAME</td>
305 <td class="db2">VARCHAR(255)</td>
306 <td class="db3">{image:db_check.gif|16|16}</td>
307 <td class="db4">&nbsp;</td>
308 <td class="db5">&nbsp;</td>
309 <td class="db6">&nbsp;</td>
310 <td class="db7">&nbsp;</td>
311 </tr>
312 <tr>
313 <td class="db0">{image:db_field.gif|16|16}</td>
314 <td class="db1">XWD_VALUE</td>
315 <td class="db2">DOUBLE</td>
316 <td class="db3">&nbsp;</td>
317 <td class="db4">&nbsp;</td>
318 <td class="db5">&nbsp;</td>
319 <td class="db6">null</td>
320 <td class="db7">&nbsp;</td>
321 </tr>
322 </table>
323
324 [^ back to top ^>#Tables]
325
326 1.1.1 XWiki Floats
327
328 This table contain the data for floats properties in XWiki Objects.
329
330
331 <table border="0" width="100%" class="dbtable" cellpadding="3"
332 cellspacing="0">
333 <tr>
334 <td colspan="8" class="dbhead">xwikifloats</td>
335 </tr>
336 <tr>
337 <th class="db0">&nbsp;</th>
338 <th class="db1">Column Name</th>
339 <th class="db2">Datatype</th>
340 <th class="db3">Not null</th>
341 <th class="db4">auto inc</th>
342 <th class="db5">flags</th>
343 <th class="db6">Default Value</th>
344 <th class="db7">Comments</th>
345 </tr>
346 <tr>
347 <td class="db0">{image:db_key.gif|16|16}</td>
348 <td class="db1">XWF_ID</td>
349 <td class="db2">INTEGER</td>
350 <td class="db3">{image:db_check.gif|16|16}</td>
351 <td class="db4">&nbsp;</td>
352 <td class="db5">&nbsp;</td>
353 <td class="db6">0</td>
354 <td class="db7">&nbsp;</td>
355 </tr>
356 <tr>
357 <td class="db0">{image:db_key.gif|16|16}</td>
358 <td class="db1">XWF_NAME</td>
359 <td class="db2">VARCHAR(255)</td>
360 <td class="db3">{image:db_check.gif|16|16}</td>
361 <td class="db4">&nbsp;</td>
362 <td class="db5">&nbsp;</td>
363 <td class="db6">&nbsp;</td>
364 <td class="db7">&nbsp;</td>
365 </tr>
366 <tr>
367 <td class="db0">{image:db_field.gif|16|16}</td>
368 <td class="db1">XWF_VALUE</td>
369 <td class="db2">FLOAT</td>
370 <td class="db3">&nbsp;</td>
371 <td class="db4">&nbsp;</td>
372 <td class="db5">&nbsp;</td>
373 <td class="db6">null</td>
374 <td class="db7">&nbsp;</td>
375 </tr>
376 </table>
377
378 [^ back to top ^>#Tables]
379
380 1.1.1 XWiki Integers
381
382 This table contain the data for integer properties in XWiki Objects.
383
384
385 <table border="0" width="100%" class="dbtable" cellpadding="3"
386 cellspacing="0">
387 <tr>
388 <td colspan="8" class="dbhead">xwikiintegers</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">XWI_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">XWI_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">XWI_VALUE</td>
423 <td class="db2">INTEGER</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 Longs
435
436 This table contain the data for long 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">xwikilongs</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">BIGINT(20)</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 </table>
484
485 [^ back to top ^>#Tables]
486
487 1.1.1 XWiki List Items
488
489 This table contain the data for lists properties in XWiki Objects.
490
491 <table border="0" width="100%" class="dbtable" cellpadding="3"
492 cellspacing="0">
493 <tr>
494 <td colspan="8" class="dbhead">xwikilistitems</td>
495 </tr>
496 <tr>
497 <th class="db0">&nbsp;</th>
498 <th class="db1">Column Name</th>
499 <th class="db2">Datatype</th>
500 <th class="db3">Not null</th>
501 <th class="db4">auto inc</th>
502 <th class="db5">flags</th>
503 <th class="db6">Default Value</th>
504 <th class="db7">Comments</th>
505 </tr>
506 <tr>
507 <td class="db0">{image:db_key.gif|16|16}</td>
508 <td class="db1">XWL_ID</td>
509 <td class="db2">INTEGER</td>
510 <td class="db3">{image:db_check.gif|16|16}</td>
511 <td class="db4">&nbsp;</td>
512 <td class="db5">&nbsp;</td>
513 <td class="db6">0</td>
514 <td class="db7">&nbsp;</td>
515 </tr>
516 <tr>
517 <td class="db0">{image:db_key.gif|16|16}</td>
518 <td class="db1">XWL_NAME</td>
519 <td class="db2">VARCHAR(255)</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">&nbsp;</td>
524 <td class="db7">&nbsp;</td>
525 </tr>
526 <tr>
527 <td class="db0">{image:db_field.gif|16|16}</td>
528 <td class="db1">XWL_VALUE</td>
529 <td class="db2">VARCHAR(255)</td>
530 <td class="db3">&nbsp;</td>
531 <td class="db4">&nbsp;</td>
532 <td class="db5">&nbsp;</td>
533 <td class="db6">null</td>
534 <td class="db7">&nbsp;</td>
535 </tr>
536 <tr>
537 <td class="db0">{image:db_key.gif|16|16}</td>
538 <td class="db1">XWL_NUMBER</td>
539 <td class="db2">INTEGER</td>
540 <td class="db3">{image:db_check.gif|16|16}</td>
541 <td class="db4">&nbsp;</td>
542 <td class="db5">&nbsp;</td>
543 <td class="db6">0</td>
544 <td class="db7">&nbsp;</td>
545 </tr>
546 </table>
547
548 [^ back to top ^>#Tables]
549
550 1.1.1 XWiki Lists
551
552 This table contain the data for lists properties in XWiki Objects.
553
554
555 <table border="0" width="100%" class="dbtable" cellpadding="3"
556 cellspacing="0">
557 <tr>
558 <td colspan="8" class="dbhead">xwikilists</td>
559 </tr>
560 <tr>
561 <th class="db0">&nbsp;</th>
562 <th class="db1">Column Name</th>
563 <th class="db2">Datatype</th>
564 <th class="db3">Not null</th>
565 <th class="db4">auto inc</th>
566 <th class="db5">flags</th>
567 <th class="db6">Default Value</th>
568 <th class="db7">Comments</th>
569 </tr>
570 <tr>
571 <td class="db0">{image:db_key.gif|16|16}</td>
572 <td class="db1">XWL_ID</td>
573 <td class="db2">INTEGER</td>
574 <td class="db3">{image:db_check.gif|16|16}</td>
575 <td class="db4">&nbsp;</td>
576 <td class="db5">&nbsp;</td>
577 <td class="db6">0</td>
578 <td class="db7">&nbsp;</td>
579 </tr>
580 <tr>
581 <td class="db0">{image:db_key.gif|16|16}</td>
582 <td class="db1">XWL_NAME</td>
583 <td class="db2">VARCHAR(255)</td>
584 <td class="db3">{image:db_check.gif|16|16}</td>
585 <td class="db4">&nbsp;</td>
586 <td class="db5">&nbsp;</td>
587 <td class="db6">&nbsp;</td>
588 <td class="db7">&nbsp;</td>
589 </tr>
590 </table>
591
592 [^ back to top ^>#Tables]
593
594 1.1 Statistics
595
596 1.1.1 XWiki Document Stats
597
598 This table contain stats information, namely page/space/wiki views and edits
599 .
600 <table border="0" width="100%" class="dbtable" cellpadding="3"
601 cellspacing="0">
602 <tr>
603 <td colspan="8" class="dbhead">xwikistatsdoc</td>
604 </tr>
605 <tr>
606 <th class="db0">&nbsp;</th>
607 <th class="db1">Column Name</th>
608 <th class="db2">Datatype</th>
609 <th class="db3">Not null</th>
610 <th class="db4">auto inc</th>
611 <th class="db5">flags</th>
612 <th class="db6">Default Value</th>
613 <th class="db7">Comments</th>
614 </tr>
615 <tr>
616 <td class="db0">{image:db_key.gif|16|16}</td>
617 <td class="db1">XWS_ID</td>
618 <td class="db2">INTEGER</td>
619 <td class="db3">{image:db_check.gif|16|16}</td>
620 <td class="db4">&nbsp;</td>
621 <td class="db5">&nbsp;</td>
622 <td class="db6">0</td>
623 <td class="db7">&nbsp;</td>
624 </tr>
625 <tr>
626 <td class="db0">{image:db_field.gif|16|16}</td>
627 <td class="db1">XWS_NUMBER</td>
628 <td class="db2">INTEGER</td>
629 <td class="db3">&nbsp;</td>
630 <td class="db4">&nbsp;</td>
631 <td class="db5">&nbsp;</td>
632 <td class="db6">null&nbsp;</td>
633 <td class="db7">&nbsp;</td>
634 </tr>
635 <tr>
636 <td class="db0">{image:db_field.gif|16|16}</td>
637 <td class="db1">XWS_NAME</td>
638 <td class="db2">VARCHAR(255)</td>
639 <td class="db3">{image:db_check.gif|16|16}</td>
640 <td class="db4">&nbsp;</td>
641 <td class="db5">&nbsp;</td>
642 <td class="db6">&nbsp;</td>
643 <td class="db7">&nbsp;</td>
644 </tr>
645 <tr>
646 <td class="db0">{image:db_field.gif|16|16}</td>
647 <td class="db1">XWS_CLASSNAME</td>
648 <td class="db2">VARCHAR(255)</td>
649 <td class="db3">{image:db_check.gif|16|16}</td>
650 <td class="db4">&nbsp;</td>
651 <td class="db5">&nbsp;</td>
652 <td class="db6">&nbsp;</td>
653 <td class="db7">&nbsp;</td>
654 </tr>
655 <tr>
656 <td class="db0">{image:db_field.gif|16|16}</td>
657 <td class="db1">XWS_ACTION</td>
658 <td class="db2">VARCHAR(255)</td>
659 <td class="db3">{image:db_check.gif|16|16}</td>
660 <td class="db4">&nbsp;</td>
661 <td class="db5">&nbsp;</td>
662 <td class="db6">&nbsp;</td>
663 <td class="db7">&nbsp;</td>
664 </tr>
665 <tr>
666 <td class="db0">{image:db_field.gif|16|16}</td>
667 <td class="db1">XWS_PAGE_VIEWS</td>
668 <td class="db2">INTEGER</td>
669 <td class="db3">&nbsp;</td>
670 <td class="db4">&nbsp;</td>
671 <td class="db5">&nbsp;</td>
672 <td class="db6">null</td>
673 <td class="db7">&nbsp;</td>
674 </tr>
675 <tr>
676 <td class="db0">{image:db_field.gif|16|16}</td>
677 <td class="db1">XWS_UNIQUE_VISITORS</td>
678 <td class="db2">INTEGER</td>
679 <td class="db3">&nbsp;</td>
680 <td class="db4">&nbsp;</td>
681 <td class="db5">&nbsp;</td>
682 <td class="db6">null</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">XWS_PERIOD</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">XWS_VISITS</td>
698 <td class="db2">INTEGER</td>
699 <td class="db3">&nbsp;</td>
700 <td class="db4">&nbsp;</td>
701 <td class="db5">&nbsp;</td>
702 <td class="db6">null</td>
703 <td class="db7">&nbsp;</td>
704 </tr>
705 </table>
706
707 [^ back to top ^>#Tables]
708
709 1.1.1 XWiki Referer Stats
710
711 This page contains the incoming externa links on the Wiki.
712
713 <table border="0" width="100%" class="dbtable" cellpadding="3"
714 cellspacing="0">
715 <tr>
716 <td colspan="8" class="dbhead">xwikistatsreferer</td>
717 </tr>
718 <tr>
719 <th class="db0">&nbsp;</th>
720 <th class="db1">Column Name</th>
721 <th class="db2">Datatype</th>
722 <th class="db3">Not null</th>
723 <th class="db4">auto inc</th>
724 <th class="db5">flags</th>
725 <th class="db6">Default Value</th>
726 <th class="db7">Comments</th>
727 </tr>
728 <tr>
729 <td class="db0">{image:db_key.gif|16|16}</td>
730 <td class="db1">XWR_ID</td>
731 <td class="db2">INTEGER</td>
732 <td class="db3">{image:db_check.gif|16|16}</td>
733 <td class="db4">&nbsp;</td>
734 <td class="db5">&nbsp;</td>
735 <td class="db6">0</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">XWR_NUMBER</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">XWR_NAME</td>
751 <td class="db2">VARCHAR(255)</td>
752 <td class="db3">{image:db_check.gif|16|16}</td>
753 <td class="db4">&nbsp;</td>
754 <td class="db5">&nbsp;</td>
755 <td class="db6">&nbsp;</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">XWR_CLASSNAME</td>
761 <td class="db2">VARCHAR(255)</td>
762 <td class="db3">{image:db_check.gif|16|16}</td>
763 <td class="db4">&nbsp;</td>
764 <td class="db5">&nbsp;</td>
765 <td class="db6">&nbsp;</td>
766 <td class="db7">&nbsp;</td>
767 </tr>
768 <tr>
769 <td class="db0">{image:db_field.gif|16|16}</td>
770 <td class="db1">XWR_REFERER</td>
771 <td class="db2">VARCHAR(255)</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">&nbsp;</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">XWR_PAGE_VIEWS</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</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">XWR_PERIOD</td>
791 <td class="db2">INTEGER</td>
792 <td class="db3">&nbsp;</td>
793 <td class="db4">&nbsp;</td>
794 <td class="db5">&nbsp;</td>
795 <td class="db6">null</td>
796 <td class="db7">&nbsp;</td>
797 </tr>
798 </table>
799
800 [^ back to top ^>#Tables]
801
802 1.1.1 XWiki Visits
803
804 This table contains the sessions of the named users.
805
806 <table border="0" width="100%" class="dbtable" cellpadding="3"
807 cellspacing="0">
808 <tr>
809 <td colspan="8" class="dbhead">xwikistatsvisit</td>
810 </tr>
811 <tr>
812 <th class="db0">&nbsp;</th>
813 <th class="db1">Column Name</th>
814 <th class="db2">Datatype</th>
815 <th class="db3">Not null</th>
816 <th class="db4">auto inc</th>
817 <th class="db5">flags</th>
818 <th class="db6">Default Value</th>
819 <th class="db7">Comments</th>
820 </tr>
821 <tr>
822 <td class="db0">{image:db_key.gif|16|16}</td>
823 <td class="db1">XWV_ID</td>
824 <td class="db2">INTEGER</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">0</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">XWV_NUMBER</td>
834 <td class="db2">INTEGER</td>
835 <td class="db3">&nbsp;</td>
836 <td class="db4">&nbsp;</td>
837 <td class="db5">&nbsp;</td>
838 <td class="db6">null&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">XWV_NAME</td>
844 <td class="db2">VARCHAR(255)</td>
845 <td class="db3">{image:db_check.gif|16|16}</td>
846 <td class="db4">&nbsp;</td>
847 <td class="db5">&nbsp;</td>
848 <td class="db6">&nbsp;</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">XWV_CLASSNAME</td>
854 <td class="db2">VARCHAR(255)</td>
855 <td class="db3">{image:db_check.gif|16|16}</td>
856 <td class="db4">&nbsp;</td>
857 <td class="db5">&nbsp;</td>
858 <td class="db6">&nbsp;</td>
859 <td class="db7">&nbsp;</td>
860 </tr>
861 <tr>
862 <td class="db0">{image:db_field.gif|16|16}</td>
863 <td class="db1">XWV_IP</td>
864 <td class="db2">VARCHAR(32)</td>
865 <td class="db3">{image:db_check.gif|16|16}</td>
866 <td class="db4">&nbsp;</td>
867 <td class="db5">&nbsp;</td>
868 <td class="db6">&nbsp;</td>
869 <td class="db7">&nbsp;</td>
870 </tr>
871 <tr>
872 <td class="db0">{image:db_field.gif|16|16}</td>
873 <td class="db1">XWV_USER_AGENT</td>
874 <td class="db2">VARCHAR(255)</td>
875 <td class="db3">{image:db_check.gif|16|16}</td>
876 <td class="db4">&nbsp;</td>
877 <td class="db5">&nbsp;</td>
878 <td class="db6">&nbsp;</td>
879 <td class="db7">&nbsp;</td>
880 </tr>
881 <tr>
882 <td class="db0">{image:db_field.gif|16|16}</td>
883 <td class="db1">XWV_COOKIE</td>
884 <td class="db2">VARCHAR(255)</td>
885 <td class="db3">{image:db_check.gif|16|16}</td>
886 <td class="db4">&nbsp;</td>
887 <td class="db5">&nbsp;</td>
888 <td class="db6">&nbsp;</td>
889 <td class="db7">&nbsp;</td>
890 </tr>
891 <tr>
892 <td class="db0">{image:db_field.gif|16|16}</td>
893 <td class="db1">XWV_UNIQUE_ID</td>
894 <td class="db2">VARCHAR(255)</td>
895 <td class="db3">{image:db_check.gif|16|16}</td>
896 <td class="db4">&nbsp;</td>
897 <td class="db5">&nbsp;</td>
898 <td class="db6">&nbsp;</td>
899 <td class="db7">&nbsp;</td>
900 </tr>
901 <tr>
902 <td class="db0">{image:db_field.gif|16|16}</td>
903 <td class="db1">XWV_PAGE_VIEWS</td>
904 <td class="db2">INTEGER</td>
905 <td class="db3">&nbsp;</td>
906 <td class="db4">&nbsp;</td>
907 <td class="db5">&nbsp;</td>
908 <td class="db6">null</td>
909 <td class="db7">&nbsp;</td>
910 </tr>
911 <tr>
912 <td class="db0">{image:db_field.gif|16|16}</td>
913 <td class="db1">XWV_SAVES</td>
914 <td class="db2">INTEGER</td>
915 <td class="db3">&nbsp;</td>
916 <td class="db4">&nbsp;</td>
917 <td class="db5">&nbsp;</td>
918 <td class="db6">null</td>
919 <td class="db7">&nbsp;</td>
920 </tr>
921 <tr>
922 <td class="db0">{image:db_field.gif|16|16}</td>
923 <td class="db1">XWV_DOWNLOADS</td>
924 <td class="db2">INTEGER</td>
925 <td class="db3">&nbsp;</td>
926 <td class="db4">&nbsp;</td>
927 <td class="db5">&nbsp;</td>
928 <td class="db6">null</td>
929 <td class="db7">&nbsp;</td>
930 </tr>
931 <tr>
932 <td class="db0">{image:db_field.gif|16|16}</td>
933 <td class="db1">XWV_START_DATE</td>
934 <td class="db2">DATETIME</td>
935 <td class="db3">&nbsp;</td>
936 <td class="db4">&nbsp;</td>
937 <td class="db5">&nbsp;</td>
938 <td class="db6">null</td>
939 <td class="db7">&nbsp;</td>
940 </tr>
941 <tr>
942 <td class="db0">{image:db_field.gif|16|16}</td>
943 <td class="db1">XWV_END_DATE</td>
944 <td class="db2">DATETIME</td>
945 <td class="db3">&nbsp;</td>
946 <td class="db4">&nbsp;</td>
947 <td class="db5">&nbsp;</td>
948 <td class="db6">null</td>
949 <td class="db7">&nbsp;</td>
950 </tr>
951 </table>
952
953 [^ back to top ^>#Tables]
954 1.1.1 XWiki List Classes
955
956 This table contains the declaration of the list properties in XWiki classes.
957
958 <table border="0" width="100%" class="dbtable" cellpadding="3"
959 cellspacing="0">
960 <tr>
961 <td colspan="8" class="dbhead">xwikislistclasses</td>
962 </tr>
963 <tr>
964 <th class="db0">&nbsp;</th>
965 <th class="db1">Column Name</th>
966 <th class="db2">Datatype</th>
967 <th class="db3">Not null</th>
968 <th class="db4">auto inc</th>
969 <th class="db5">flags</th>
970 <th class="db6">Default Value</th>
971 <th class="db7">Comments</th>
972 </tr>
973 <tr>
974 <td class="db0">{image:db_key.gif|16|16}</td>
975 <td class="db1">XWL_ID</td>
976 <td class="db2">INTEGER</td>
977 <td class="db3">{image:db_check.gif|16|16}</td>
978 <td class="db4">&nbsp;</td>
979 <td class="db5">&nbsp;</td>
980 <td class="db6">0</td>
981 <td class="db7">&nbsp;</td>
982 </tr>
983 <tr>
984 <td class="db0">{image:db_key.gif|16|16}</td>
985 <td class="db1">XWL_NAME</td>
986 <td class="db2">VARCHAR(255)</td>
987 <td class="db3">{image:db_check.gif|16|16}</td>
988 <td class="db4">&nbsp;</td>
989 <td class="db5">&nbsp;</td>
990 <td class="db6">&nbsp;</td>
991 <td class="db7">&nbsp;</td>
992 </tr>
993 <tr>
994 <td class="db0">{image:db_field.gif|16|16}</td>
995 <td class="db1">XWL_DISPLAYTYPE</td>
996 <td class="db2">VARCHAR(20)</td>
997 <td class="db3">&nbsp;</td>
998 <td class="db4">&nbsp;</td>
999 <td class="db5">&nbsp;</td>
1000 <td class="db6">null</td>
1001 <td class="db7">&nbsp;</td>
1002 </tr>
1003 <tr>
1004 <td class="db0">{image:db_field.gif|16|16}</td>
1005 <td class="db1">XWL_MULTISELECT</td>
1006 <td class="db2">TINYINT(1)</td>
1007 <td class="db3">&nbsp;</td>
1008 <td class="db4">&nbsp;</td>
1009 <td class="db5">&nbsp;</td>
1010 <td class="db6">null</td>
1011 <td class="db7">&nbsp;</td>
1012 </tr>
1013 <tr>
1014 <td class="db0">{image:db_field.gif|16|16}</td>
1015 <td class="db1">XWL_SIZE</td>
1016 <td class="db2">INTEGER</td>
1017 <td class="db3">&nbsp;</td>
1018 <td class="db4">&nbsp;</td>
1019 <td class="db5">&nbsp;</td>
1020 <td class="db6">null</td>
1021 <td class="db7">&nbsp;</td>
1022 </tr>
1023 <tr>
1024 <td class="db0">{image:db_field.gif|16|16}</td>
1025 <td class="db1">XWL_RELATIONAL</td>
1026 <td class="db2">TINYINT(1)</td>
1027 <td class="db3">&nbsp;</td>
1028 <td class="db4">&nbsp;</td>
1029 <td class="db5">&nbsp;</td>
1030 <td class="db6">null</td>
1031 <td class="db7">&nbsp;</td>
1032 </tr>
1033 <tr>
1034 <td class="db0">{image:db_field.gif|16|16}</td>
1035 <td class="db1">XWL_VALUES</td>
1036 <td class="db2">TEXT</td>
1037 <td class="db3">&nbsp;</td>
1038 <td class="db4">&nbsp;</td>
1039 <td class="db5">&nbsp;</td>
1040 <td class="db6">null</td>
1041 <td class="db7">&nbsp;</td>
1042 </tr>
1043 </table>
1044
1045 [^ back to top ^>#Tables]
1046 $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