Skip to Content

Wiki source code of DatabaseSchema

Version 58.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>#XWiki+Boolean+Classes]
21 * [xwikiclasses>DevGuide.DsXWikiClasses]
22 * [xwikiclassesprop>DevGuide.DsXWikiClassesProp]
23 * xwikicomments
24 * [xwikidateclasses>#XWiki+Date+Classes]
25 * [xwikidates>#XWiki+Dates]
26 * [xwikidblistclasses>#XWiki+Database+List+Classes]
27 * xwikidbversion
28 * [xwikidoc>DevGuide.DsXWikiDoc]
29 * [xwikidoubles>#XWiki+Doubles]
30 * [xwikifloats>#XWiki+Floats]
31 * [xwikiintegers>#XWiki+Integers]
32 * [xwikilargestrings>#XWiki+Large+Strings]
33 * [xwikilinks>DevGuide.DsXWikiLinks]
34 </td>
35 <td style="border-bottom:0px">
36 * [xwikilistitems>#XWiki+List+Items]
37 * [xwikilists>#XWiki+Lists]
38 * [xwikilock>DevGuide.DsXWikiLocks]
39 * [xwikilongs>#XWiki+Longs]
40 * [xwikinumberclasses>#XWiki+Number+Classes]
41 * [xwikiobjects>#XWiki+Objects]
42 * xwikipreferences
43 * [xwikiproperties>#XWiki+Properties]
44 * xwikiircs
45 * xwikirecyclebin
46 * xwikislistclasses
47 * [xwikistatsdoc>#XWiki+Document+Stats]
48 * [xwikistatsreferer>#XWiki+Referer+Stats]
49 * [xwikistatsvisit>#XWiki+Visits]
50 * [xwikistringclasses>DevGuide.DsXWikiStringClasses]
51 * [xwikistrings>#XWiki+Strings]
52 </td>
53 </tr>
54 </table>
55
56 * [xwikilistclasses>#XWiki+List+Classes] ... not existing in Release 1.7.1
57
58 1.1.1 XWiki Boolean Classes
59
60 This table contains the declaration of the boolean properties in XWiki classes.
61
62 <table border="0" width="100%" class="dbtable" cellpadding="3"
63 cellspacing="0">
64 <tr>
65 <td colspan="8" class="dbhead">xwikibooleanclasses</td>
66 </tr>
67 <tr>
68 <th class="db0">&nbsp;</th>
69 <th class="db1">Column Name</th>
70 <th class="db2">Datatype</th>
71 <th class="db3">Not null</th>
72 <th class="db4">auto inc</th>
73 <th class="db5">flags</th>
74 <th class="db6">Default Value</th>
75 <th class="db7">Comments</th>
76 </tr>
77 <tr>
78 <td class="db0">{image:db_key.gif|16|16}</td>
79 <td class="db1">XWN_ID</td>
80 <td class="db2">INTEGER</td>
81 <td class="db3">{image:db_check.gif|16|16}</td>
82 <td class="db4">&nbsp;</td>
83 <td class="db5">&nbsp;</td>
84 <td class="db6">0</td>
85 <td class="db7">&nbsp;</td>
86 </tr>
87 <tr>
88 <td class="db0">{image:db_key.gif|16|16}</td>
89 <td class="db1">XWN_NAME</td>
90 <td class="db2">VARCHAR(255)</td>
91 <td class="db3">{image:db_check.gif|16|16}</td>
92 <td class="db4">&nbsp;</td>
93 <td class="db5">&nbsp;</td>
94 <td class="db6">&nbsp;</td>
95 <td class="db7">&nbsp;</td>
96 </tr>
97 <tr>
98 <td class="db0">{image:db_field.gif|16|16}</td>
99 <td class="db1">XWN_DISPLAYTYPE</td>
100 <td class="db2">VARCHAR(20)</td>
101 <td class="db3">&nbsp;</td>
102 <td class="db4">&nbsp;</td>
103 <td class="db5">&nbsp;</td>
104 <td class="db6">null</td>
105 <td class="db7"></td>
106 </tr>
107 </table>
108
109 The field name prefix is this table is wrong. It should be corrected in xwiki.hbm.xml.
110
111 [^ back to top ^>#Tables]
112
113 1.1.1 XWiki Date Classes
114
115 This table contains the declaration of the date properties in XWiki classes.
116
117 <table border="0" width="100%" class="dbtable" cellpadding="3"
118 cellspacing="0">
119 <tr>
120 <td colspan="8" class="dbhead">xwikidateclasses</td>
121 </tr>
122 <tr>
123 <th class="db0">&nbsp;</th>
124 <th class="db1">Column Name</th>
125 <th class="db2">Datatype</th>
126 <th class="db3">Not null</th>
127 <th class="db4">auto inc</th>
128 <th class="db5">flags</th>
129 <th class="db6">Default Value</th>
130 <th class="db7">Comments</th>
131 </tr>
132 <tr>
133 <td class="db0">{image:db_key.gif|16|16}</td>
134 <td class="db1">XWS_ID</td>
135 <td class="db2">INTEGER</td>
136 <td class="db3">{image:db_check.gif|16|16}</td>
137 <td class="db4">&nbsp;</td>
138 <td class="db5">&nbsp;</td>
139 <td class="db6">0</td>
140 <td class="db7">&nbsp;</td>
141 </tr>
142 <tr>
143 <td class="db0">{image:db_key.gif|16|16}</td>
144 <td class="db1">XWS_NAME</td>
145 <td class="db2">VARCHAR(255)</td>
146 <td class="db3">{image:db_check.gif|16|16}</td>
147 <td class="db4">&nbsp;</td>
148 <td class="db5">&nbsp;</td>
149 <td class="db6">&nbsp;</td>
150 <td class="db7">&nbsp;</td>
151 </tr>
152 <tr>
153 <td class="db0">{image:db_field.gif|16|16}</td>
154 <td class="db1">XWS_SIZE</td>
155 <td class="db2">INTEGER</td>
156 <td class="db3">&nbsp;</td>
157 <td class="db4">&nbsp;</td>
158 <td class="db5">&nbsp;</td>
159 <td class="db6">null</td>
160 <td class="db7">&nbsp;</td>
161 </tr>
162 <tr>
163 <td class="db0">{image:db_field.gif|16|16}</td>
164 <td class="db1">XWS_EMPTY_IS_TODAY</td>
165 <td class="db2">INTEGER</td>
166 <td class="db3">&nbsp;</td>
167 <td class="db4">&nbsp;</td>
168 <td class="db5">&nbsp;</td>
169 <td class="db6">null</td>
170 <td class="db7">&nbsp;</td>
171 </tr>
172 <tr>
173 <td class="db0">{image:db_field.gif|16|16}</td>
174 <td class="db1">XWS_DATE_FORMAT</td>
175 <td class="db2">VARCHAR(255)</td>
176 <td class="db3">&nbsp;</td>
177 <td class="db4">&nbsp;</td>
178 <td class="db5">&nbsp;</td>
179 <td class="db6">null</td>
180 <td class="db7">&nbsp;</td>
181 </tr>
182 </table>
183
184 The field name prefix is this table is wrong. It should be corrected in xwiki.hbm.xml.
185
186 [^ back to top ^>#Tables]
187
188 1.1.1 XWiki Number Classes
189
190 This table contains the declaration of the number (long, integer, double, float) properties in XWiki classes.
191
192 <table border="0" width="100%" class="dbtable" cellpadding="3"
193 cellspacing="0">
194 <tr>
195 <td colspan="8" class="dbhead">xwikinumberclasses</td>
196 </tr>
197 <tr>
198 <th class="db0">&nbsp;</th>
199 <th class="db1">Column Name</th>
200 <th class="db2">Datatype</th>
201 <th class="db3">Not null</th>
202 <th class="db4">auto inc</th>
203 <th class="db5">flags</th>
204 <th class="db6">Default Value</th>
205 <th class="db7">Comments</th>
206 </tr>
207 <tr>
208 <td class="db0">{image:db_key.gif|16|16}</td>
209 <td class="db1">XWN_ID</td>
210 <td class="db2">INTEGER</td>
211 <td class="db3">{image:db_check.gif|16|16}</td>
212 <td class="db4">&nbsp;</td>
213 <td class="db5">&nbsp;</td>
214 <td class="db6">0</td>
215 <td class="db7">&nbsp;</td>
216 </tr>
217 <tr>
218 <td class="db0">{image:db_key.gif|16|16}</td>
219 <td class="db1">XWN_NAME</td>
220 <td class="db2">VARCHAR(255)</td>
221 <td class="db3">{image:db_check.gif|16|16}</td>
222 <td class="db4">&nbsp;</td>
223 <td class="db5">&nbsp;</td>
224 <td class="db6">null&nbsp;</td>
225 <td class="db7">&nbsp;</td>
226 </tr>
227 <tr>
228 <td class="db0">{image:db_field.gif|16|16}</td>
229 <td class="db1">XWN_SIZE</td>
230 <td class="db2">INTEGER</td>
231 <td class="db3">{image:db_check.gif|16|16}</td>
232 <td class="db4">&nbsp;</td>
233 <td class="db5">&nbsp;</td>
234 <td class="db6">null</td>
235 <td class="db7">&nbsp;</td>
236 </tr>
237 <tr>
238 <td class="db0">{image:db_field.gif|16|16}</td>
239 <td class="db1">XWN_NUMBERTYPE</td>
240 <td class="db2">VARCHAR(20)</td>
241 <td class="db3">&nbsp;</td>
242 <td class="db4">&nbsp;</td>
243 <td class="db5">&nbsp;</td>
244 <td class="db6">null</td>
245 <td class="db7">&nbsp;</td>
246 </tr>
247 </table>
248
249 [^ back to top ^>#Tables]
250
251 1.1.1 XWiki List Classes
252
253 This table contains the declaration of the list properties in XWiki classes.
254
255 <table border="0" width="100%" class="dbtable" cellpadding="3"
256 cellspacing="0">
257 <tr>
258 <td colspan="8" class="dbhead">xwikislistclasses</td>
259 </tr>
260 <tr>
261 <th class="db0">&nbsp;</th>
262 <th class="db1">Column Name</th>
263 <th class="db2">Datatype</th>
264 <th class="db3">Not null</th>
265 <th class="db4">auto inc</th>
266 <th class="db5">flags</th>
267 <th class="db6">Default Value</th>
268 <th class="db7">Comments</th>
269 </tr>
270 <tr>
271 <td class="db0">{image:db_key.gif|16|16}</td>
272 <td class="db1">XWL_ID</td>
273 <td class="db2">INTEGER</td>
274 <td class="db3">{image:db_check.gif|16|16}</td>
275 <td class="db4">&nbsp;</td>
276 <td class="db5">&nbsp;</td>
277 <td class="db6">0</td>
278 <td class="db7">&nbsp;</td>
279 </tr>
280 <tr>
281 <td class="db0">{image:db_key.gif|16|16}</td>
282 <td class="db1">XWL_NAME</td>
283 <td class="db2">VARCHAR(255)</td>
284 <td class="db3">{image:db_check.gif|16|16}</td>
285 <td class="db4">&nbsp;</td>
286 <td class="db5">&nbsp;</td>
287 <td class="db6">&nbsp;</td>
288 <td class="db7">&nbsp;</td>
289 </tr>
290 <tr>
291 <td class="db0">{image:db_field.gif|16|16}</td>
292 <td class="db1">XWL_DISPLAYTYPE</td>
293 <td class="db2">VARCHAR(20)</td>
294 <td class="db3">&nbsp;</td>
295 <td class="db4">&nbsp;</td>
296 <td class="db5">&nbsp;</td>
297 <td class="db6">null</td>
298 <td class="db7">&nbsp;</td>
299 </tr>
300 <tr>
301 <td class="db0">{image:db_field.gif|16|16}</td>
302 <td class="db1">XWL_MULTISELECT</td>
303 <td class="db2">TINYINT(1)</td>
304 <td class="db3">&nbsp;</td>
305 <td class="db4">&nbsp;</td>
306 <td class="db5">&nbsp;</td>
307 <td class="db6">null</td>
308 <td class="db7">&nbsp;</td>
309 </tr>
310 <tr>
311 <td class="db0">{image:db_field.gif|16|16}</td>
312 <td class="db1">XWL_SIZE</td>
313 <td class="db2">INTEGER</td>
314 <td class="db3">&nbsp;</td>
315 <td class="db4">&nbsp;</td>
316 <td class="db5">&nbsp;</td>
317 <td class="db6">null</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">XWL_RELATIONAL</td>
323 <td class="db2">TINYINT(1)</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 <tr>
331 <td class="db0">{image:db_field.gif|16|16}</td>
332 <td class="db1">XWL_VALUES</td>
333 <td class="db2">TEXT</td>
334 <td class="db3">&nbsp;</td>
335 <td class="db4">&nbsp;</td>
336 <td class="db5">&nbsp;</td>
337 <td class="db6">null</td>
338 <td class="db7">&nbsp;</td>
339 </tr>
340 </table>
341
342 [^ back to top ^>#Tables]
343
344 1.1.1 XWiki Database List Classes
345
346 This table contains the declaration of the database list properties in XWiki classes.
347
348 <table border="0" width="100%" class="dbtable" cellpadding="3"
349 cellspacing="0">
350 <tr>
351 <td colspan="8" class="dbhead">xwikidblistclasses</td>
352 </tr>
353 <tr>
354 <th class="db0">&nbsp;</th>
355 <th class="db1">Column Name</th>
356 <th class="db2">Datatype</th>
357 <th class="db3">Not null</th>
358 <th class="db4">auto inc</th>
359 <th class="db5">flags</th>
360 <th class="db6">Default Value</th>
361 <th class="db7">Comments</th>
362 </tr>
363 <tr>
364 <td class="db0">{image:db_key.gif|16|16}</td>
365 <td class="db1">XWL_ID</td>
366 <td class="db2">INTEGER</td>
367 <td class="db3">{image:db_check.gif|16|16}</td>
368 <td class="db4">&nbsp;</td>
369 <td class="db5">&nbsp;</td>
370 <td class="db6">0</td>
371 <td class="db7">&nbsp;</td>
372 </tr>
373 <tr>
374 <td class="db0">{image:db_key.gif|16|16}</td>
375 <td class="db1">XWL_NAME</td>
376 <td class="db2">VARCHAR(255)</td>
377 <td class="db3">{image:db_check.gif|16|16}</td>
378 <td class="db4">&nbsp;</td>
379 <td class="db5">&nbsp;</td>
380 <td class="db6">&nbsp;</td>
381 <td class="db7">&nbsp;</td>
382 </tr>
383 <tr>
384 <td class="db0">{image:db_field.gif|16|16}</td>
385 <td class="db1">XWL_DISPLAYTYPE</td>
386 <td class="db2">VARCHAR(20)</td>
387 <td class="db3">&nbsp;</td>
388 <td class="db4">&nbsp;</td>
389 <td class="db5">&nbsp;</td>
390 <td class="db6">null</td>
391 <td class="db7">&nbsp;</td>
392 </tr>
393 <tr>
394 <td class="db0">{image:db_field.gif|16|16}</td>
395 <td class="db1">XWL_MULTISELECT</td>
396 <td class="db2">TINYINT(1)</td>
397 <td class="db3">&nbsp;</td>
398 <td class="db4">&nbsp;</td>
399 <td class="db5">&nbsp;</td>
400 <td class="db6">null</td>
401 <td class="db7">&nbsp;</td>
402 </tr>
403 <tr>
404 <td class="db0">{image:db_field.gif|16|16}</td>
405 <td class="db1">XWL_SIZE</td>
406 <td class="db2">INTEGER</td>
407 <td class="db3">&nbsp;</td>
408 <td class="db4">&nbsp;</td>
409 <td class="db5">&nbsp;</td>
410 <td class="db6">null</td>
411 <td class="db7">&nbsp;</td>
412 </tr>
413 <tr>
414 <td class="db0">{image:db_field.gif|16|16}</td>
415 <td class="db1">XWL_RELATIONAL</td>
416 <td class="db2">TINYINT(1)</td>
417 <td class="db3">&nbsp;</td>
418 <td class="db4">&nbsp;</td>
419 <td class="db5">&nbsp;</td>
420 <td class="db6">null</td>
421 <td class="db7">&nbsp;</td>
422 </tr>
423 <tr>
424 <td class="db0">{image:db_field.gif|16|16}</td>
425 <td class="db1">XWL_SQL</td>
426 <td class="db2">TEXT</td>
427 <td class="db3">&nbsp;</td>
428 <td class="db4">&nbsp;</td>
429 <td class="db5">&nbsp;</td>
430 <td class="db6">null</td>
431 <td class="db7">&nbsp;</td>
432 </tr>
433 </table>
434
435 [^ back to top ^>#Tables]
436
437 1.1 XWiki Objects
438
439 This table contains the list of XWiki Objects. Objects can have properties, as declared by their class.
440
441 <table border="0" width="100%" class="dbtable" cellpadding="3"
442 cellspacing="0">
443 <tr>
444 <td colspan="8" class="dbhead">xwikiobjects</td>
445 </tr>
446 <tr>
447 <th class="db0">&nbsp;</th>
448 <th class="db1">Column Name</th>
449 <th class="db2">Datatype</th>
450 <th class="db3">Not null</th>
451 <th class="db4">auto inc</th>
452 <th class="db5">flags</th>
453 <th class="db6">Default Value</th>
454 <th class="db7">Comments</th>
455 </tr>
456 <tr>
457 <td class="db0">{image:db_key.gif|16|16}</td>
458 <td class="db1">XWO_ID</td>
459 <td class="db2">INTEGER</td>
460 <td class="db3">{image:db_check.gif|16|16}</td>
461 <td class="db4">&nbsp;</td>
462 <td class="db5">&nbsp;</td>
463 <td class="db6">0</td>
464 <td class="db7">&nbsp;</td>
465 </tr>
466 <tr>
467 <td class="db0">{image:db_field.gif|16|16}</td>
468 <td class="db1">XWO_NUMBER</td>
469 <td class="db2">INTEGER</td>
470 <td class="db3">&nbsp;</td>
471 <td class="db4">&nbsp;</td>
472 <td class="db5">&nbsp;</td>
473 <td class="db6">null&nbsp;</td>
474 <td class="db7">&nbsp;</td>
475 </tr>
476 <tr>
477 <td class="db0">{image:db_field.gif|16|16}</td>
478 <td class="db1">XWO_NAME</td>
479 <td class="db2">VARCHAR(255)</td>
480 <td class="db3">{image:db_check.gif|16|16}</td>
481 <td class="db4">&nbsp;</td>
482 <td class="db5">&nbsp;</td>
483 <td class="db6">null</td>
484 <td class="db7">&nbsp;</td>
485 </tr>
486 <tr>
487 <td class="db0">{image:db_field.gif|16|16}</td>
488 <td class="db1">XWO_CLASSNAME</td>
489 <td class="db2">VARCHAR(255)</td>
490 <td class="db3">{image:db_check.gif|16|16}</td>
491 <td class="db4">&nbsp;</td>
492 <td class="db5">&nbsp;</td>
493 <td class="db6">&nbsp;</td>
494 <td class="db7">&nbsp;</td>
495 </tr>
496 </table>
497
498 [^ back to top ^>#Tables]
499
500 1.1 XWiki Properties
501
502 This table contains the list of properties in XWiki Objects. Each property has an entry in the type specific table.
503
504 <table border="0" width="100%" class="dbtable" cellpadding="3"
505 cellspacing="0">
506 <tr>
507 <td colspan="8" class="dbhead">xwikiproperties</td>
508 </tr>
509 <tr>
510 <th class="db0">&nbsp;</th>
511 <th class="db1">Column Name</th>
512 <th class="db2">Datatype</th>
513 <th class="db3">Not null</th>
514 <th class="db4">auto inc</th>
515 <th class="db5">flags</th>
516 <th class="db6">Default Value</th>
517 <th class="db7">Comments</th>
518 </tr>
519 <tr>
520 <td class="db0">{image:db_key.gif|16|16}</td>
521 <td class="db1">XWP_ID</td>
522 <td class="db2">INTEGER</td>
523 <td class="db3">{image:db_check.gif|16|16}</td>
524 <td class="db4">&nbsp;</td>
525 <td class="db5">&nbsp;</td>
526 <td class="db6">0</td>
527 <td class="db7">&nbsp;</td>
528 </tr>
529 <tr>
530 <td class="db0">{image:db_key.gif|16|16}</td>
531 <td class="db1">XWP_NAME</td>
532 <td class="db2">VARCHAR(255)</td>
533 <td class="db3">{image:db_check.gif|16|16}</td>
534 <td class="db4">&nbsp;</td>
535 <td class="db5">&nbsp;</td>
536 <td class="db6">&nbsp;</td>
537 <td class="db7">&nbsp;</td>
538 </tr>
539 <tr>
540 <td class="db0">{image:db_field.gif|16|16}</td>
541 <td class="db1">XWP_CLASSTYPE</td>
542 <td class="db2">VARCHAR(255)</td>
543 <td class="db3">&nbsp;</td>
544 <td class="db4">&nbsp;</td>
545 <td class="db5">&nbsp;</td>
546 <td class="db6">null</td>
547 <td class="db7">&nbsp;</td>
548 </tr>
549 </table>
550
551 [^ back to top ^>#Tables]
552
553 1.1.1 XWiki Strings
554
555 This table contains the string data from XWiki Objects.
556
557 <table border="0" width="100%" class="dbtable" cellpadding="3"
558 cellspacing="0">
559 <tr>
560 <td colspan="8" class="dbhead">xwikistrings</td>
561 </tr>
562 <tr>
563 <th class="db0">&nbsp;</th>
564 <th class="db1">Column Name</th>
565 <th class="db2">Datatype</th>
566 <th class="db3">Not null</th>
567 <th class="db4">auto inc</th>
568 <th class="db5">flags</th>
569 <th class="db6">Default Value</th>
570 <th class="db7">Comments</th>
571 </tr>
572 <tr>
573 <td class="db0">{image:db_key.gif|16|16}</td>
574 <td class="db1">XWS_ID</td>
575 <td class="db2">INTEGER</td>
576 <td class="db3">{image:db_check.gif|16|16}</td>
577 <td class="db4">&nbsp;</td>
578 <td class="db5">&nbsp;</td>
579 <td class="db6">0</td>
580 <td class="db7">&nbsp;</td>
581 </tr>
582 <tr>
583 <td class="db0">{image:db_key.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_VALUE</td>
595 <td class="db2">VARCHAR(255)</td>
596 <td class="db3">&nbsp;</td>
597 <td class="db4">&nbsp;</td>
598 <td class="db5">&nbsp;</td>
599 <td class="db6">null</td>
600 <td class="db7">&nbsp;</td>
601 </tr>
602 </table>
603
604 [^ back to top ^>#Tables]
605
606 1.1.1 XWiki Large Strings
607
608 This table contain the data for textarea properties in XWiki Objects.
609
610 <table border="0" width="100%" class="dbtable" cellpadding="3"
611 cellspacing="0">
612 <tr>
613 <td colspan="8" class="dbhead">xwikilargestrings</td>
614 </tr>
615 <tr>
616 <th class="db0">&nbsp;</th>
617 <th class="db1">Column Name</th>
618 <th class="db2">Datatype</th>
619 <th class="db3">Not null</th>
620 <th class="db4">auto inc</th>
621 <th class="db5">flags</th>
622 <th class="db6">Default Value</th>
623 <th class="db7">Comments</th>
624 </tr>
625 <tr>
626 <td class="db0">{image:db_key.gif|16|16}</td>
627 <td class="db1">XWL_ID</td>
628 <td class="db2">INTEGER</td>
629 <td class="db3">{image:db_check.gif|16|16}</td>
630 <td class="db4">&nbsp;</td>
631 <td class="db5">&nbsp;</td>
632 <td class="db6">0</td>
633 <td class="db7">&nbsp;</td>
634 </tr>
635 <tr>
636 <td class="db0">{image:db_key.gif|16|16}</td>
637 <td class="db1">XWL_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">XWL_VALUE</td>
648 <td class="db2">TEXT</td>
649 <td class="db3">&nbsp;</td>
650 <td class="db4">&nbsp;</td>
651 <td class="db5">&nbsp;</td>
652 <td class="db6">null</td>
653 <td class="db7">&nbsp;</td>
654 </tr>
655 </table>
656
657 [^ back to top ^>#Tables]
658
659 1.1.1 XWiki Dates
660
661 This table contains the data of date properties in XWiki objects.
662
663 <table border="0" width="100%" class="dbtable" cellpadding="3"
664 cellspacing="0">
665 <tr>
666 <td colspan="8" class="dbhead">xwikidates</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_key.gif|16|16}</td>
690 <td class="db1">XWS_NAME</td>
691 <td class="db2">VARCHAR(255)</td>
692 <td class="db3">{image:db_check.gif|16|16}</td>
693 <td class="db4">&nbsp;</td>
694 <td class="db5">&nbsp;</td>
695 <td class="db6">&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_VALUE</td>
701 <td class="db2">DATETIME</td>
702 <td class="db3">&nbsp;</td>
703 <td class="db4">&nbsp;</td>
704 <td class="db5">&nbsp;</td>
705 <td class="db6">null</td>
706 <td class="db7">&nbsp;</td>
707 </tr>
708 </table>
709
710 The field name prefix is this table is wrong. It should be corrected in xwiki.hbm.xml.
711
712 [^ back to top ^>#Tables]
713
714 1.1.1 XWiki Doubles
715
716 This table contain the data for double properties in XWiki Objects.
717
718 <table border="0" width="100%" class="dbtable" cellpadding="3"
719 cellspacing="0">
720 <tr>
721 <td colspan="8" class="dbhead">xwikidoubles</td>
722 </tr>
723 <tr>
724 <th class="db0">&nbsp;</th>
725 <th class="db1">Column Name</th>
726 <th class="db2">Datatype</th>
727 <th class="db3">Not null</th>
728 <th class="db4">auto inc</th>
729 <th class="db5">flags</th>
730 <th class="db6">Default Value</th>
731 <th class="db7">Comments</th>
732 </tr>
733 <tr>
734 <td class="db0">{image:db_key.gif|16|16}</td>
735 <td class="db1">XWD_ID</td>
736 <td class="db2">INTEGER</td>
737 <td class="db3">{image:db_check.gif|16|16}</td>
738 <td class="db4">&nbsp;</td>
739 <td class="db5">&nbsp;</td>
740 <td class="db6">0</td>
741 <td class="db7">&nbsp;</td>
742 </tr>
743 <tr>
744 <td class="db0">{image:db_key.gif|16|16}</td>
745 <td class="db1">XWD_NAME</td>
746 <td class="db2">VARCHAR(255)</td>
747 <td class="db3">{image:db_check.gif|16|16}</td>
748 <td class="db4">&nbsp;</td>
749 <td class="db5">&nbsp;</td>
750 <td class="db6">&nbsp;</td>
751 <td class="db7">&nbsp;</td>
752 </tr>
753 <tr>
754 <td class="db0">{image:db_field.gif|16|16}</td>
755 <td class="db1">XWD_VALUE</td>
756 <td class="db2">DOUBLE</td>
757 <td class="db3">&nbsp;</td>
758 <td class="db4">&nbsp;</td>
759 <td class="db5">&nbsp;</td>
760 <td class="db6">null</td>
761 <td class="db7">&nbsp;</td>
762 </tr>
763 </table>
764
765 [^ back to top ^>#Tables]
766
767 1.1.1 XWiki Floats
768
769 This table contain the data for floats properties in XWiki Objects.
770
771
772 <table border="0" width="100%" class="dbtable" cellpadding="3"
773 cellspacing="0">
774 <tr>
775 <td colspan="8" class="dbhead">xwikifloats</td>
776 </tr>
777 <tr>
778 <th class="db0">&nbsp;</th>
779 <th class="db1">Column Name</th>
780 <th class="db2">Datatype</th>
781 <th class="db3">Not null</th>
782 <th class="db4">auto inc</th>
783 <th class="db5">flags</th>
784 <th class="db6">Default Value</th>
785 <th class="db7">Comments</th>
786 </tr>
787 <tr>
788 <td class="db0">{image:db_key.gif|16|16}</td>
789 <td class="db1">XWF_ID</td>
790 <td class="db2">INTEGER</td>
791 <td class="db3">{image:db_check.gif|16|16}</td>
792 <td class="db4">&nbsp;</td>
793 <td class="db5">&nbsp;</td>
794 <td class="db6">0</td>
795 <td class="db7">&nbsp;</td>
796 </tr>
797 <tr>
798 <td class="db0">{image:db_key.gif|16|16}</td>
799 <td class="db1">XWF_NAME</td>
800 <td class="db2">VARCHAR(255)</td>
801 <td class="db3">{image:db_check.gif|16|16}</td>
802 <td class="db4">&nbsp;</td>
803 <td class="db5">&nbsp;</td>
804 <td class="db6">&nbsp;</td>
805 <td class="db7">&nbsp;</td>
806 </tr>
807 <tr>
808 <td class="db0">{image:db_field.gif|16|16}</td>
809 <td class="db1">XWF_VALUE</td>
810 <td class="db2">FLOAT</td>
811 <td class="db3">&nbsp;</td>
812 <td class="db4">&nbsp;</td>
813 <td class="db5">&nbsp;</td>
814 <td class="db6">null</td>
815 <td class="db7">&nbsp;</td>
816 </tr>
817 </table>
818
819 [^ back to top ^>#Tables]
820
821 1.1.1 XWiki Integers
822
823 This table contain the data for integer properties in XWiki Objects.
824
825
826 <table border="0" width="100%" class="dbtable" cellpadding="3"
827 cellspacing="0">
828 <tr>
829 <td colspan="8" class="dbhead">xwikiintegers</td>
830 </tr>
831 <tr>
832 <th class="db0">&nbsp;</th>
833 <th class="db1">Column Name</th>
834 <th class="db2">Datatype</th>
835 <th class="db3">Not null</th>
836 <th class="db4">auto inc</th>
837 <th class="db5">flags</th>
838 <th class="db6">Default Value</th>
839 <th class="db7">Comments</th>
840 </tr>
841 <tr>
842 <td class="db0">{image:db_key.gif|16|16}</td>
843 <td class="db1">XWI_ID</td>
844 <td class="db2">INTEGER</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">0</td>
849 <td class="db7">&nbsp;</td>
850 </tr>
851 <tr>
852 <td class="db0">{image:db_key.gif|16|16}</td>
853 <td class="db1">XWI_NAME</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">XWI_VALUE</td>
864 <td class="db2">INTEGER</td>
865 <td class="db3">&nbsp;</td>
866 <td class="db4">&nbsp;</td>
867 <td class="db5">&nbsp;</td>
868 <td class="db6">null</td>
869 <td class="db7">&nbsp;</td>
870 </tr>
871 </table>
872
873 [^ back to top ^>#Tables]
874
875 1.1.1 XWiki Longs
876
877 This table contain the data for long properties in XWiki Objects.
878
879 <table border="0" width="100%" class="dbtable" cellpadding="3"
880 cellspacing="0">
881 <tr>
882 <td colspan="8" class="dbhead">xwikilongs</td>
883 </tr>
884 <tr>
885 <th class="db0">&nbsp;</th>
886 <th class="db1">Column Name</th>
887 <th class="db2">Datatype</th>
888 <th class="db3">Not null</th>
889 <th class="db4">auto inc</th>
890 <th class="db5">flags</th>
891 <th class="db6">Default Value</th>
892 <th class="db7">Comments</th>
893 </tr>
894 <tr>
895 <td class="db0">{image:db_key.gif|16|16}</td>
896 <td class="db1">XWL_ID</td>
897 <td class="db2">INTEGER</td>
898 <td class="db3">{image:db_check.gif|16|16}</td>
899 <td class="db4">&nbsp;</td>
900 <td class="db5">&nbsp;</td>
901 <td class="db6">0</td>
902 <td class="db7">&nbsp;</td>
903 </tr>
904 <tr>
905 <td class="db0">{image:db_key.gif|16|16}</td>
906 <td class="db1">XWL_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">XWL_VALUE</td>
917 <td class="db2">BIGINT(20)</td>
918 <td class="db3">&nbsp;</td>
919 <td class="db4">&nbsp;</td>
920 <td class="db5">&nbsp;</td>
921 <td class="db6">null</td>
922 <td class="db7">&nbsp;</td>
923 </tr>
924 </table>
925
926 [^ back to top ^>#Tables]
927
928 1.1.1 XWiki List Items
929
930 This table contain the data for lists properties in XWiki Objects.
931
932 <table border="0" width="100%" class="dbtable" cellpadding="3"
933 cellspacing="0">
934 <tr>
935 <td colspan="8" class="dbhead">xwikilistitems</td>
936 </tr>
937 <tr>
938 <th class="db0">&nbsp;</th>
939 <th class="db1">Column Name</th>
940 <th class="db2">Datatype</th>
941 <th class="db3">Not null</th>
942 <th class="db4">auto inc</th>
943 <th class="db5">flags</th>
944 <th class="db6">Default Value</th>
945 <th class="db7">Comments</th>
946 </tr>
947 <tr>
948 <td class="db0">{image:db_key.gif|16|16}</td>
949 <td class="db1">XWL_ID</td>
950 <td class="db2">INTEGER</td>
951 <td class="db3">{image:db_check.gif|16|16}</td>
952 <td class="db4">&nbsp;</td>
953 <td class="db5">&nbsp;</td>
954 <td class="db6">0</td>
955 <td class="db7">&nbsp;</td>
956 </tr>
957 <tr>
958 <td class="db0">{image:db_key.gif|16|16}</td>
959 <td class="db1">XWL_NAME</td>
960 <td class="db2">VARCHAR(255)</td>
961 <td class="db3">{image:db_check.gif|16|16}</td>
962 <td class="db4">&nbsp;</td>
963 <td class="db5">&nbsp;</td>
964 <td class="db6">&nbsp;</td>
965 <td class="db7">&nbsp;</td>
966 </tr>
967 <tr>
968 <td class="db0">{image:db_field.gif|16|16}</td>
969 <td class="db1">XWL_VALUE</td>
970 <td class="db2">VARCHAR(255)</td>
971 <td class="db3">&nbsp;</td>
972 <td class="db4">&nbsp;</td>
973 <td class="db5">&nbsp;</td>
974 <td class="db6">null</td>
975 <td class="db7">&nbsp;</td>
976 </tr>
977 <tr>
978 <td class="db0">{image:db_key.gif|16|16}</td>
979 <td class="db1">XWL_NUMBER</td>
980 <td class="db2">INTEGER</td>
981 <td class="db3">{image:db_check.gif|16|16}</td>
982 <td class="db4">&nbsp;</td>
983 <td class="db5">&nbsp;</td>
984 <td class="db6">0</td>
985 <td class="db7">&nbsp;</td>
986 </tr>
987 </table>
988
989 [^ back to top ^>#Tables]
990
991 1.1.1 XWiki Lists
992
993 This table contain the data for lists properties in XWiki Objects.
994
995
996 <table border="0" width="100%" class="dbtable" cellpadding="3"
997 cellspacing="0">
998 <tr>
999 <td colspan="8" class="dbhead">xwikilists</td>
1000 </tr>
1001 <tr>
1002 <th class="db0">&nbsp;</th>
1003 <th class="db1">Column Name</th>
1004 <th class="db2">Datatype</th>
1005 <th class="db3">Not null</th>
1006 <th class="db4">auto inc</th>
1007 <th class="db5">flags</th>
1008 <th class="db6">Default Value</th>
1009 <th class="db7">Comments</th>
1010 </tr>
1011 <tr>
1012 <td class="db0">{image:db_key.gif|16|16}</td>
1013 <td class="db1">XWL_ID</td>
1014 <td class="db2">INTEGER</td>
1015 <td class="db3">{image:db_check.gif|16|16}</td>
1016 <td class="db4">&nbsp;</td>
1017 <td class="db5">&nbsp;</td>
1018 <td class="db6">0</td>
1019 <td class="db7">&nbsp;</td>
1020 </tr>
1021 <tr>
1022 <td class="db0">{image:db_key.gif|16|16}</td>
1023 <td class="db1">XWL_NAME</td>
1024 <td class="db2">VARCHAR(255)</td>
1025 <td class="db3">{image:db_check.gif|16|16}</td>
1026 <td class="db4">&nbsp;</td>
1027 <td class="db5">&nbsp;</td>
1028 <td class="db6">&nbsp;</td>
1029 <td class="db7">&nbsp;</td>
1030 </tr>
1031 </table>
1032
1033 [^ back to top ^>#Tables]
1034
1035 1.1 Statistics
1036
1037 1.1.1 XWiki Document Stats
1038
1039 This table contain stats information, namely page/space/wiki views and edits
1040 .
1041 <table border="0" width="100%" class="dbtable" cellpadding="3"
1042 cellspacing="0">
1043 <tr>
1044 <td colspan="8" class="dbhead">xwikistatsdoc</td>
1045 </tr>
1046 <tr>
1047 <th class="db0">&nbsp;</th>
1048 <th class="db1">Column Name</th>
1049 <th class="db2">Datatype</th>
1050 <th class="db3">Not null</th>
1051 <th class="db4">auto inc</th>
1052 <th class="db5">flags</th>
1053 <th class="db6">Default Value</th>
1054 <th class="db7">Comments</th>
1055 </tr>
1056 <tr>
1057 <td class="db0">{image:db_key.gif|16|16}</td>
1058 <td class="db1">XWS_ID</td>
1059 <td class="db2">INTEGER</td>
1060 <td class="db3">{image:db_check.gif|16|16}</td>
1061 <td class="db4">&nbsp;</td>
1062 <td class="db5">&nbsp;</td>
1063 <td class="db6">0</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">XWS_NUMBER</td>
1069 <td class="db2">INTEGER</td>
1070 <td class="db3">&nbsp;</td>
1071 <td class="db4">&nbsp;</td>
1072 <td class="db5">&nbsp;</td>
1073 <td class="db6">null&nbsp;</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">XWS_NAME</td>
1079 <td class="db2">VARCHAR(255)</td>
1080 <td class="db3">{image:db_check.gif|16|16}</td>
1081 <td class="db4">&nbsp;</td>
1082 <td class="db5">&nbsp;</td>
1083 <td class="db6">&nbsp;</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">XWS_CLASSNAME</td>
1089 <td class="db2">VARCHAR(255)</td>
1090 <td class="db3">{image:db_check.gif|16|16}</td>
1091 <td class="db4">&nbsp;</td>
1092 <td class="db5">&nbsp;</td>
1093 <td class="db6">&nbsp;</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">XWS_ACTION</td>
1099 <td class="db2">VARCHAR(255)</td>
1100 <td class="db3">{image:db_check.gif|16|16}</td>
1101 <td class="db4">&nbsp;</td>
1102 <td class="db5">&nbsp;</td>
1103 <td class="db6">&nbsp;</td>
1104 <td class="db7">&nbsp;</td>
1105 </tr>
1106 <tr>
1107 <td class="db0">{image:db_field.gif|16|16}</td>
1108 <td class="db1">XWS_PAGE_VIEWS</td>
1109 <td class="db2">INTEGER</td>
1110 <td class="db3">&nbsp;</td>
1111 <td class="db4">&nbsp;</td>
1112 <td class="db5">&nbsp;</td>
1113 <td class="db6">null</td>
1114 <td class="db7">&nbsp;</td>
1115 </tr>
1116 <tr>
1117 <td class="db0">{image:db_field.gif|16|16}</td>
1118 <td class="db1">XWS_UNIQUE_VISITORS</td>
1119 <td class="db2">INTEGER</td>
1120 <td class="db3">&nbsp;</td>
1121 <td class="db4">&nbsp;</td>
1122 <td class="db5">&nbsp;</td>
1123 <td class="db6">null</td>
1124 <td class="db7">&nbsp;</td>
1125 </tr>
1126 <tr>
1127 <td class="db0">{image:db_field.gif|16|16}</td>
1128 <td class="db1">XWS_PERIOD</td>
1129 <td class="db2">INTEGER</td>
1130 <td class="db3">&nbsp;</td>
1131 <td class="db4">&nbsp;</td>
1132 <td class="db5">&nbsp;</td>
1133 <td class="db6">null</td>
1134 <td class="db7">&nbsp;</td>
1135 </tr>
1136 <tr>
1137 <td class="db0">{image:db_field.gif|16|16}</td>
1138 <td class="db1">XWS_VISITS</td>
1139 <td class="db2">INTEGER</td>
1140 <td class="db3">&nbsp;</td>
1141 <td class="db4">&nbsp;</td>
1142 <td class="db5">&nbsp;</td>
1143 <td class="db6">null</td>
1144 <td class="db7">&nbsp;</td>
1145 </tr>
1146 </table>
1147
1148 [^ back to top ^>#Tables]
1149
1150 1.1.1 XWiki Referer Stats
1151
1152 This page contains the incoming externa links on the Wiki.
1153
1154 <table border="0" width="100%" class="dbtable" cellpadding="3"
1155 cellspacing="0">
1156 <tr>
1157 <td colspan="8" class="dbhead">xwikistatsreferer</td>
1158 </tr>
1159 <tr>
1160 <th class="db0">&nbsp;</th>
1161 <th class="db1">Column Name</th>
1162 <th class="db2">Datatype</th>
1163 <th class="db3">Not null</th>
1164 <th class="db4">auto inc</th>
1165 <th class="db5">flags</th>
1166 <th class="db6">Default Value</th>
1167 <th class="db7">Comments</th>
1168 </tr>
1169 <tr>
1170 <td class="db0">{image:db_key.gif|16|16}</td>
1171 <td class="db1">XWR_ID</td>
1172 <td class="db2">INTEGER</td>
1173 <td class="db3">{image:db_check.gif|16|16}</td>
1174 <td class="db4">&nbsp;</td>
1175 <td class="db5">&nbsp;</td>
1176 <td class="db6">0</td>
1177 <td class="db7">&nbsp;</td>
1178 </tr>
1179 <tr>
1180 <td class="db0">{image:db_field.gif|16|16}</td>
1181 <td class="db1">XWR_NUMBER</td>
1182 <td class="db2">INTEGER</td>
1183 <td class="db3">&nbsp;</td>
1184 <td class="db4">&nbsp;</td>
1185 <td class="db5">&nbsp;</td>
1186 <td class="db6">null</td>
1187 <td class="db7">&nbsp;</td>
1188 </tr>
1189 <tr>
1190 <td class="db0">{image:db_field.gif|16|16}</td>
1191 <td class="db1">XWR_NAME</td>
1192 <td class="db2">VARCHAR(255)</td>
1193 <td class="db3">{image:db_check.gif|16|16}</td>
1194 <td class="db4">&nbsp;</td>
1195 <td class="db5">&nbsp;</td>
1196 <td class="db6">&nbsp;</td>
1197 <td class="db7">&nbsp;</td>
1198 </tr>
1199 <tr>
1200 <td class="db0">{image:db_field.gif|16|16}</td>
1201 <td class="db1">XWR_CLASSNAME</td>
1202 <td class="db2">VARCHAR(255)</td>
1203 <td class="db3">{image:db_check.gif|16|16}</td>
1204 <td class="db4">&nbsp;</td>
1205 <td class="db5">&nbsp;</td>
1206 <td class="db6">&nbsp;</td>
1207 <td class="db7">&nbsp;</td>
1208 </tr>
1209 <tr>
1210 <td class="db0">{image:db_field.gif|16|16}</td>
1211 <td class="db1">XWR_REFERER</td>
1212 <td class="db2">VARCHAR(255)</td>
1213 <td class="db3">{image:db_check.gif|16|16}</td>
1214 <td class="db4">&nbsp;</td>
1215 <td class="db5">&nbsp;</td>
1216 <td class="db6">&nbsp;</td>
1217 <td class="db7">&nbsp;</td>
1218 </tr>
1219 <tr>
1220 <td class="db0">{image:db_field.gif|16|16}</td>
1221 <td class="db1">XWR_PAGE_VIEWS</td>
1222 <td class="db2">INTEGER</td>
1223 <td class="db3">&nbsp;</td>
1224 <td class="db4">&nbsp;</td>
1225 <td class="db5">&nbsp;</td>
1226 <td class="db6">null</td>
1227 <td class="db7">&nbsp;</td>
1228 </tr>
1229 <tr>
1230 <td class="db0">{image:db_field.gif|16|16}</td>
1231 <td class="db1">XWR_PERIOD</td>
1232 <td class="db2">INTEGER</td>
1233 <td class="db3">&nbsp;</td>
1234 <td class="db4">&nbsp;</td>
1235 <td class="db5">&nbsp;</td>
1236 <td class="db6">null</td>
1237 <td class="db7">&nbsp;</td>
1238 </tr>
1239 </table>
1240
1241 [^ back to top ^>#Tables]
1242
1243 1.1.1 XWiki Visits
1244
1245 This table contains the sessions of the named users.
1246
1247 <table border="0" width="100%" class="dbtable" cellpadding="3"
1248 cellspacing="0">
1249 <tr>
1250 <td colspan="8" class="dbhead">xwikistatsvisit</td>
1251 </tr>
1252 <tr>
1253 <th class="db0">&nbsp;</th>
1254 <th class="db1">Column Name</th>
1255 <th class="db2">Datatype</th>
1256 <th class="db3">Not null</th>
1257 <th class="db4">auto inc</th>
1258 <th class="db5">flags</th>
1259 <th class="db6">Default Value</th>
1260 <th class="db7">Comments</th>
1261 </tr>
1262 <tr>
1263 <td class="db0">{image:db_key.gif|16|16}</td>
1264 <td class="db1">XWV_ID</td>
1265 <td class="db2">INTEGER</td>
1266 <td class="db3">{image:db_check.gif|16|16}</td>
1267 <td class="db4">&nbsp;</td>
1268 <td class="db5">&nbsp;</td>
1269 <td class="db6">0</td>
1270 <td class="db7">&nbsp;</td>
1271 </tr>
1272 <tr>
1273 <td class="db0">{image:db_field.gif|16|16}</td>
1274 <td class="db1">XWV_NUMBER</td>
1275 <td class="db2">INTEGER</td>
1276 <td class="db3">&nbsp;</td>
1277 <td class="db4">&nbsp;</td>
1278 <td class="db5">&nbsp;</td>
1279 <td class="db6">null&nbsp;</td>
1280 <td class="db7">&nbsp;</td>
1281 </tr>
1282 <tr>
1283 <td class="db0">{image:db_field.gif|16|16}</td>
1284 <td class="db1">XWV_NAME</td>
1285 <td class="db2">VARCHAR(255)</td>
1286 <td class="db3">{image:db_check.gif|16|16}</td>
1287 <td class="db4">&nbsp;</td>
1288 <td class="db5">&nbsp;</td>
1289 <td class="db6">&nbsp;</td>
1290 <td class="db7">&nbsp;</td>
1291 </tr>
1292 <tr>
1293 <td class="db0">{image:db_field.gif|16|16}</td>
1294 <td class="db1">XWV_CLASSNAME</td>
1295 <td class="db2">VARCHAR(255)</td>
1296 <td class="db3">{image:db_check.gif|16|16}</td>
1297 <td class="db4">&nbsp;</td>
1298 <td class="db5">&nbsp;</td>
1299 <td class="db6">&nbsp;</td>
1300 <td class="db7">&nbsp;</td>
1301 </tr>
1302 <tr>
1303 <td class="db0">{image:db_field.gif|16|16}</td>
1304 <td class="db1">XWV_IP</td>
1305 <td class="db2">VARCHAR(32)</td>
1306 <td class="db3">{image:db_check.gif|16|16}</td>
1307 <td class="db4">&nbsp;</td>
1308 <td class="db5">&nbsp;</td>
1309 <td class="db6">&nbsp;</td>
1310 <td class="db7">&nbsp;</td>
1311 </tr>
1312 <tr>
1313 <td class="db0">{image:db_field.gif|16|16}</td>
1314 <td class="db1">XWV_USER_AGENT</td>
1315 <td class="db2">VARCHAR(255)</td>
1316 <td class="db3">{image:db_check.gif|16|16}</td>
1317 <td class="db4">&nbsp;</td>
1318 <td class="db5">&nbsp;</td>
1319 <td class="db6">&nbsp;</td>
1320 <td class="db7">&nbsp;</td>
1321 </tr>
1322 <tr>
1323 <td class="db0">{image:db_field.gif|16|16}</td>
1324 <td class="db1">XWV_COOKIE</td>
1325 <td class="db2">VARCHAR(255)</td>
1326 <td class="db3">{image:db_check.gif|16|16}</td>
1327 <td class="db4">&nbsp;</td>
1328 <td class="db5">&nbsp;</td>
1329 <td class="db6">&nbsp;</td>
1330 <td class="db7">&nbsp;</td>
1331 </tr>
1332 <tr>
1333 <td class="db0">{image:db_field.gif|16|16}</td>
1334 <td class="db1">XWV_UNIQUE_ID</td>
1335 <td class="db2">VARCHAR(255)</td>
1336 <td class="db3">{image:db_check.gif|16|16}</td>
1337 <td class="db4">&nbsp;</td>
1338 <td class="db5">&nbsp;</td>
1339 <td class="db6">&nbsp;</td>
1340 <td class="db7">&nbsp;</td>
1341 </tr>
1342 <tr>
1343 <td class="db0">{image:db_field.gif|16|16}</td>
1344 <td class="db1">XWV_PAGE_VIEWS</td>
1345 <td class="db2">INTEGER</td>
1346 <td class="db3">&nbsp;</td>
1347 <td class="db4">&nbsp;</td>
1348 <td class="db5">&nbsp;</td>
1349 <td class="db6">null</td>
1350 <td class="db7">&nbsp;</td>
1351 </tr>
1352 <tr>
1353 <td class="db0">{image:db_field.gif|16|16}</td>
1354 <td class="db1">XWV_SAVES</td>
1355 <td class="db2">INTEGER</td>
1356 <td class="db3">&nbsp;</td>
1357 <td class="db4">&nbsp;</td>
1358 <td class="db5">&nbsp;</td>
1359 <td class="db6">null</td>
1360 <td class="db7">&nbsp;</td>
1361 </tr>
1362 <tr>
1363 <td class="db0">{image:db_field.gif|16|16}</td>
1364 <td class="db1">XWV_DOWNLOADS</td>
1365 <td class="db2">INTEGER</td>
1366 <td class="db3">&nbsp;</td>
1367 <td class="db4">&nbsp;</td>
1368 <td class="db5">&nbsp;</td>
1369 <td class="db6">null</td>
1370 <td class="db7">&nbsp;</td>
1371 </tr>
1372 <tr>
1373 <td class="db0">{image:db_field.gif|16|16}</td>
1374 <td class="db1">XWV_START_DATE</td>
1375 <td class="db2">DATETIME</td>
1376 <td class="db3">&nbsp;</td>
1377 <td class="db4">&nbsp;</td>
1378 <td class="db5">&nbsp;</td>
1379 <td class="db6">null</td>
1380 <td class="db7">&nbsp;</td>
1381 </tr>
1382 <tr>
1383 <td class="db0">{image:db_field.gif|16|16}</td>
1384 <td class="db1">XWV_END_DATE</td>
1385 <td class="db2">DATETIME</td>
1386 <td class="db3">&nbsp;</td>
1387 <td class="db4">&nbsp;</td>
1388 <td class="db5">&nbsp;</td>
1389 <td class="db6">null</td>
1390 <td class="db7">&nbsp;</td>
1391 </tr>
1392 </table>
1393
1394 [^ back to top ^>#Tables]
1395 $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