Skip to Content

Wiki source code of DatabaseSchema

Version 56.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>#XWiki+String+Classes]
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 String Classes
59
60 This table contains the declaration of the strings 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">xwikistringclasses</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">XWS_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">XWS_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">XWS_SIZE</td>
100 <td class="db2">INTEGER</td>
101 <td class="db3">&nbsp;</td>
102 <td class="db4">&nbsp;</td>
103 <td class="db5">&nbsp;</td>
104 <td class="db6">null</td>
105 <td class="db7">&nbsp;</td>
106 </tr>
107 <tr>
108 <td class="db0">{image:db_field.gif|16|16}</td>
109 <td class="db1">XWS_ROWS</td>
110 <td class="db2">INTEGER</td>
111 <td class="db3">&nbsp;</td>
112 <td class="db4">&nbsp;</td>
113 <td class="db5">&nbsp;</td>
114 <td class="db6">null</td>
115 <td class="db7">&nbsp;</td>
116 </tr>
117 </table>
118
119 [^ back to top ^>#Tables]
120
121 1.1.1 XWiki Boolean Classes
122
123 This table contains the declaration of the boolean properties in XWiki classes.
124
125 <table border="0" width="100%" class="dbtable" cellpadding="3"
126 cellspacing="0">
127 <tr>
128 <td colspan="8" class="dbhead">xwikibooleanclasses</td>
129 </tr>
130 <tr>
131 <th class="db0">&nbsp;</th>
132 <th class="db1">Column Name</th>
133 <th class="db2">Datatype</th>
134 <th class="db3">Not null</th>
135 <th class="db4">auto inc</th>
136 <th class="db5">flags</th>
137 <th class="db6">Default Value</th>
138 <th class="db7">Comments</th>
139 </tr>
140 <tr>
141 <td class="db0">{image:db_key.gif|16|16}</td>
142 <td class="db1">XWN_ID</td>
143 <td class="db2">INTEGER</td>
144 <td class="db3">{image:db_check.gif|16|16}</td>
145 <td class="db4">&nbsp;</td>
146 <td class="db5">&nbsp;</td>
147 <td class="db6">0</td>
148 <td class="db7">&nbsp;</td>
149 </tr>
150 <tr>
151 <td class="db0">{image:db_key.gif|16|16}</td>
152 <td class="db1">XWN_NAME</td>
153 <td class="db2">VARCHAR(255)</td>
154 <td class="db3">{image:db_check.gif|16|16}</td>
155 <td class="db4">&nbsp;</td>
156 <td class="db5">&nbsp;</td>
157 <td class="db6">&nbsp;</td>
158 <td class="db7">&nbsp;</td>
159 </tr>
160 <tr>
161 <td class="db0">{image:db_field.gif|16|16}</td>
162 <td class="db1">XWN_DISPLAYTYPE</td>
163 <td class="db2">VARCHAR(20)</td>
164 <td class="db3">&nbsp;</td>
165 <td class="db4">&nbsp;</td>
166 <td class="db5">&nbsp;</td>
167 <td class="db6">null</td>
168 <td class="db7"></td>
169 </tr>
170 </table>
171
172 The field name prefix is this table is wrong. It should be corrected in xwiki.hbm.xml.
173
174 [^ back to top ^>#Tables]
175
176 1.1.1 XWiki Date Classes
177
178 This table contains the declaration of the date properties in XWiki classes.
179
180 <table border="0" width="100%" class="dbtable" cellpadding="3"
181 cellspacing="0">
182 <tr>
183 <td colspan="8" class="dbhead">xwikidateclasses</td>
184 </tr>
185 <tr>
186 <th class="db0">&nbsp;</th>
187 <th class="db1">Column Name</th>
188 <th class="db2">Datatype</th>
189 <th class="db3">Not null</th>
190 <th class="db4">auto inc</th>
191 <th class="db5">flags</th>
192 <th class="db6">Default Value</th>
193 <th class="db7">Comments</th>
194 </tr>
195 <tr>
196 <td class="db0">{image:db_key.gif|16|16}</td>
197 <td class="db1">XWS_ID</td>
198 <td class="db2">INTEGER</td>
199 <td class="db3">{image:db_check.gif|16|16}</td>
200 <td class="db4">&nbsp;</td>
201 <td class="db5">&nbsp;</td>
202 <td class="db6">0</td>
203 <td class="db7">&nbsp;</td>
204 </tr>
205 <tr>
206 <td class="db0">{image:db_key.gif|16|16}</td>
207 <td class="db1">XWS_NAME</td>
208 <td class="db2">VARCHAR(255)</td>
209 <td class="db3">{image:db_check.gif|16|16}</td>
210 <td class="db4">&nbsp;</td>
211 <td class="db5">&nbsp;</td>
212 <td class="db6">&nbsp;</td>
213 <td class="db7">&nbsp;</td>
214 </tr>
215 <tr>
216 <td class="db0">{image:db_field.gif|16|16}</td>
217 <td class="db1">XWS_SIZE</td>
218 <td class="db2">INTEGER</td>
219 <td class="db3">&nbsp;</td>
220 <td class="db4">&nbsp;</td>
221 <td class="db5">&nbsp;</td>
222 <td class="db6">null</td>
223 <td class="db7">&nbsp;</td>
224 </tr>
225 <tr>
226 <td class="db0">{image:db_field.gif|16|16}</td>
227 <td class="db1">XWS_EMPTY_IS_TODAY</td>
228 <td class="db2">INTEGER</td>
229 <td class="db3">&nbsp;</td>
230 <td class="db4">&nbsp;</td>
231 <td class="db5">&nbsp;</td>
232 <td class="db6">null</td>
233 <td class="db7">&nbsp;</td>
234 </tr>
235 <tr>
236 <td class="db0">{image:db_field.gif|16|16}</td>
237 <td class="db1">XWS_DATE_FORMAT</td>
238 <td class="db2">VARCHAR(255)</td>
239 <td class="db3">&nbsp;</td>
240 <td class="db4">&nbsp;</td>
241 <td class="db5">&nbsp;</td>
242 <td class="db6">null</td>
243 <td class="db7">&nbsp;</td>
244 </tr>
245 </table>
246
247 The field name prefix is this table is wrong. It should be corrected in xwiki.hbm.xml.
248
249 [^ back to top ^>#Tables]
250
251 1.1.1 XWiki Number Classes
252
253 This table contains the declaration of the number (long, integer, double, float) 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">xwikinumberclasses</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">XWN_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">XWN_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">null&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">XWN_SIZE</td>
293 <td class="db2">INTEGER</td>
294 <td class="db3">{image:db_check.gif|16|16}</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">XWN_NUMBERTYPE</td>
303 <td class="db2">VARCHAR(20)</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 </table>
311
312 [^ back to top ^>#Tables]
313
314 1.1.1 XWiki List Classes
315
316 This table contains the declaration of the list properties in XWiki classes.
317
318 <table border="0" width="100%" class="dbtable" cellpadding="3"
319 cellspacing="0">
320 <tr>
321 <td colspan="8" class="dbhead">xwikislistclasses</td>
322 </tr>
323 <tr>
324 <th class="db0">&nbsp;</th>
325 <th class="db1">Column Name</th>
326 <th class="db2">Datatype</th>
327 <th class="db3">Not null</th>
328 <th class="db4">auto inc</th>
329 <th class="db5">flags</th>
330 <th class="db6">Default Value</th>
331 <th class="db7">Comments</th>
332 </tr>
333 <tr>
334 <td class="db0">{image:db_key.gif|16|16}</td>
335 <td class="db1">XWL_ID</td>
336 <td class="db2">INTEGER</td>
337 <td class="db3">{image:db_check.gif|16|16}</td>
338 <td class="db4">&nbsp;</td>
339 <td class="db5">&nbsp;</td>
340 <td class="db6">0</td>
341 <td class="db7">&nbsp;</td>
342 </tr>
343 <tr>
344 <td class="db0">{image:db_key.gif|16|16}</td>
345 <td class="db1">XWL_NAME</td>
346 <td class="db2">VARCHAR(255)</td>
347 <td class="db3">{image:db_check.gif|16|16}</td>
348 <td class="db4">&nbsp;</td>
349 <td class="db5">&nbsp;</td>
350 <td class="db6">&nbsp;</td>
351 <td class="db7">&nbsp;</td>
352 </tr>
353 <tr>
354 <td class="db0">{image:db_field.gif|16|16}</td>
355 <td class="db1">XWL_DISPLAYTYPE</td>
356 <td class="db2">VARCHAR(20)</td>
357 <td class="db3">&nbsp;</td>
358 <td class="db4">&nbsp;</td>
359 <td class="db5">&nbsp;</td>
360 <td class="db6">null</td>
361 <td class="db7">&nbsp;</td>
362 </tr>
363 <tr>
364 <td class="db0">{image:db_field.gif|16|16}</td>
365 <td class="db1">XWL_MULTISELECT</td>
366 <td class="db2">TINYINT(1)</td>
367 <td class="db3">&nbsp;</td>
368 <td class="db4">&nbsp;</td>
369 <td class="db5">&nbsp;</td>
370 <td class="db6">null</td>
371 <td class="db7">&nbsp;</td>
372 </tr>
373 <tr>
374 <td class="db0">{image:db_field.gif|16|16}</td>
375 <td class="db1">XWL_SIZE</td>
376 <td class="db2">INTEGER</td>
377 <td class="db3">&nbsp;</td>
378 <td class="db4">&nbsp;</td>
379 <td class="db5">&nbsp;</td>
380 <td class="db6">null</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_RELATIONAL</td>
386 <td class="db2">TINYINT(1)</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_VALUES</td>
396 <td class="db2">TEXT</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 </table>
404
405 [^ back to top ^>#Tables]
406
407 1.1.1 XWiki Database List Classes
408
409 This table contains the declaration of the database list properties in XWiki classes.
410
411 <table border="0" width="100%" class="dbtable" cellpadding="3"
412 cellspacing="0">
413 <tr>
414 <td colspan="8" class="dbhead">xwikidblistclasses</td>
415 </tr>
416 <tr>
417 <th class="db0">&nbsp;</th>
418 <th class="db1">Column Name</th>
419 <th class="db2">Datatype</th>
420 <th class="db3">Not null</th>
421 <th class="db4">auto inc</th>
422 <th class="db5">flags</th>
423 <th class="db6">Default Value</th>
424 <th class="db7">Comments</th>
425 </tr>
426 <tr>
427 <td class="db0">{image:db_key.gif|16|16}</td>
428 <td class="db1">XWL_ID</td>
429 <td class="db2">INTEGER</td>
430 <td class="db3">{image:db_check.gif|16|16}</td>
431 <td class="db4">&nbsp;</td>
432 <td class="db5">&nbsp;</td>
433 <td class="db6">0</td>
434 <td class="db7">&nbsp;</td>
435 </tr>
436 <tr>
437 <td class="db0">{image:db_key.gif|16|16}</td>
438 <td class="db1">XWL_NAME</td>
439 <td class="db2">VARCHAR(255)</td>
440 <td class="db3">{image:db_check.gif|16|16}</td>
441 <td class="db4">&nbsp;</td>
442 <td class="db5">&nbsp;</td>
443 <td class="db6">&nbsp;</td>
444 <td class="db7">&nbsp;</td>
445 </tr>
446 <tr>
447 <td class="db0">{image:db_field.gif|16|16}</td>
448 <td class="db1">XWL_DISPLAYTYPE</td>
449 <td class="db2">VARCHAR(20)</td>
450 <td class="db3">&nbsp;</td>
451 <td class="db4">&nbsp;</td>
452 <td class="db5">&nbsp;</td>
453 <td class="db6">null</td>
454 <td class="db7">&nbsp;</td>
455 </tr>
456 <tr>
457 <td class="db0">{image:db_field.gif|16|16}</td>
458 <td class="db1">XWL_MULTISELECT</td>
459 <td class="db2">TINYINT(1)</td>
460 <td class="db3">&nbsp;</td>
461 <td class="db4">&nbsp;</td>
462 <td class="db5">&nbsp;</td>
463 <td class="db6">null</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">XWL_SIZE</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</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">XWL_RELATIONAL</td>
479 <td class="db2">TINYINT(1)</td>
480 <td class="db3">&nbsp;</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">XWL_SQL</td>
489 <td class="db2">TEXT</td>
490 <td class="db3">&nbsp;</td>
491 <td class="db4">&nbsp;</td>
492 <td class="db5">&nbsp;</td>
493 <td class="db6">null</td>
494 <td class="db7">&nbsp;</td>
495 </tr>
496 </table>
497
498 [^ back to top ^>#Tables]
499
500 1.1 XWiki Objects
501
502 This table contains the list of XWiki Objects. Objects can have properties, as declared by their class.
503
504 <table border="0" width="100%" class="dbtable" cellpadding="3"
505 cellspacing="0">
506 <tr>
507 <td colspan="8" class="dbhead">xwikiobjects</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">XWO_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_field.gif|16|16}</td>
531 <td class="db1">XWO_NUMBER</td>
532 <td class="db2">INTEGER</td>
533 <td class="db3">&nbsp;</td>
534 <td class="db4">&nbsp;</td>
535 <td class="db5">&nbsp;</td>
536 <td class="db6">null&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">XWO_NAME</td>
542 <td class="db2">VARCHAR(255)</td>
543 <td class="db3">{image:db_check.gif|16|16}</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 <tr>
550 <td class="db0">{image:db_field.gif|16|16}</td>
551 <td class="db1">XWO_CLASSNAME</td>
552 <td class="db2">VARCHAR(255)</td>
553 <td class="db3">{image:db_check.gif|16|16}</td>
554 <td class="db4">&nbsp;</td>
555 <td class="db5">&nbsp;</td>
556 <td class="db6">&nbsp;</td>
557 <td class="db7">&nbsp;</td>
558 </tr>
559 </table>
560
561 [^ back to top ^>#Tables]
562
563 1.1 XWiki Properties
564
565 This table contains the list of properties in XWiki Objects. Each property has an entry in the type specific table.
566
567 <table border="0" width="100%" class="dbtable" cellpadding="3"
568 cellspacing="0">
569 <tr>
570 <td colspan="8" class="dbhead">xwikiproperties</td>
571 </tr>
572 <tr>
573 <th class="db0">&nbsp;</th>
574 <th class="db1">Column Name</th>
575 <th class="db2">Datatype</th>
576 <th class="db3">Not null</th>
577 <th class="db4">auto inc</th>
578 <th class="db5">flags</th>
579 <th class="db6">Default Value</th>
580 <th class="db7">Comments</th>
581 </tr>
582 <tr>
583 <td class="db0">{image:db_key.gif|16|16}</td>
584 <td class="db1">XWP_ID</td>
585 <td class="db2">INTEGER</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">0</td>
590 <td class="db7">&nbsp;</td>
591 </tr>
592 <tr>
593 <td class="db0">{image:db_key.gif|16|16}</td>
594 <td class="db1">XWP_NAME</td>
595 <td class="db2">VARCHAR(255)</td>
596 <td class="db3">{image:db_check.gif|16|16}</td>
597 <td class="db4">&nbsp;</td>
598 <td class="db5">&nbsp;</td>
599 <td class="db6">&nbsp;</td>
600 <td class="db7">&nbsp;</td>
601 </tr>
602 <tr>
603 <td class="db0">{image:db_field.gif|16|16}</td>
604 <td class="db1">XWP_CLASSTYPE</td>
605 <td class="db2">VARCHAR(255)</td>
606 <td class="db3">&nbsp;</td>
607 <td class="db4">&nbsp;</td>
608 <td class="db5">&nbsp;</td>
609 <td class="db6">null</td>
610 <td class="db7">&nbsp;</td>
611 </tr>
612 </table>
613
614 [^ back to top ^>#Tables]
615
616 1.1.1 XWiki Strings
617
618 This table contains the string data from XWiki Objects.
619
620 <table border="0" width="100%" class="dbtable" cellpadding="3"
621 cellspacing="0">
622 <tr>
623 <td colspan="8" class="dbhead">xwikistrings</td>
624 </tr>
625 <tr>
626 <th class="db0">&nbsp;</th>
627 <th class="db1">Column Name</th>
628 <th class="db2">Datatype</th>
629 <th class="db3">Not null</th>
630 <th class="db4">auto inc</th>
631 <th class="db5">flags</th>
632 <th class="db6">Default Value</th>
633 <th class="db7">Comments</th>
634 </tr>
635 <tr>
636 <td class="db0">{image:db_key.gif|16|16}</td>
637 <td class="db1">XWS_ID</td>
638 <td class="db2">INTEGER</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">0</td>
643 <td class="db7">&nbsp;</td>
644 </tr>
645 <tr>
646 <td class="db0">{image:db_key.gif|16|16}</td>
647 <td class="db1">XWS_NAME</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_VALUE</td>
658 <td class="db2">VARCHAR(255)</td>
659 <td class="db3">&nbsp;</td>
660 <td class="db4">&nbsp;</td>
661 <td class="db5">&nbsp;</td>
662 <td class="db6">null</td>
663 <td class="db7">&nbsp;</td>
664 </tr>
665 </table>
666
667 [^ back to top ^>#Tables]
668
669 1.1.1 XWiki Large Strings
670
671 This table contain the data for textarea properties in XWiki Objects.
672
673 <table border="0" width="100%" class="dbtable" cellpadding="3"
674 cellspacing="0">
675 <tr>
676 <td colspan="8" class="dbhead">xwikilargestrings</td>
677 </tr>
678 <tr>
679 <th class="db0">&nbsp;</th>
680 <th class="db1">Column Name</th>
681 <th class="db2">Datatype</th>
682 <th class="db3">Not null</th>
683 <th class="db4">auto inc</th>
684 <th class="db5">flags</th>
685 <th class="db6">Default Value</th>
686 <th class="db7">Comments</th>
687 </tr>
688 <tr>
689 <td class="db0">{image:db_key.gif|16|16}</td>
690 <td class="db1">XWL_ID</td>
691 <td class="db2">INTEGER</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">0</td>
696 <td class="db7">&nbsp;</td>
697 </tr>
698 <tr>
699 <td class="db0">{image:db_key.gif|16|16}</td>
700 <td class="db1">XWL_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">XWL_VALUE</td>
711 <td class="db2">TEXT</td>
712 <td class="db3">&nbsp;</td>
713 <td class="db4">&nbsp;</td>
714 <td class="db5">&nbsp;</td>
715 <td class="db6">null</td>
716 <td class="db7">&nbsp;</td>
717 </tr>
718 </table>
719
720 [^ back to top ^>#Tables]
721
722 1.1.1 XWiki Dates
723
724 This table contains the data of date properties in XWiki objects.
725
726 <table border="0" width="100%" class="dbtable" cellpadding="3"
727 cellspacing="0">
728 <tr>
729 <td colspan="8" class="dbhead">xwikidates</td>
730 </tr>
731 <tr>
732 <th class="db0">&nbsp;</th>
733 <th class="db1">Column Name</th>
734 <th class="db2">Datatype</th>
735 <th class="db3">Not null</th>
736 <th class="db4">auto inc</th>
737 <th class="db5">flags</th>
738 <th class="db6">Default Value</th>
739 <th class="db7">Comments</th>
740 </tr>
741 <tr>
742 <td class="db0">{image:db_key.gif|16|16}</td>
743 <td class="db1">XWS_ID</td>
744 <td class="db2">INTEGER</td>
745 <td class="db3">{image:db_check.gif|16|16}</td>
746 <td class="db4">&nbsp;</td>
747 <td class="db5">&nbsp;</td>
748 <td class="db6">0</td>
749 <td class="db7">&nbsp;</td>
750 </tr>
751 <tr>
752 <td class="db0">{image:db_key.gif|16|16}</td>
753 <td class="db1">XWS_NAME</td>
754 <td class="db2">VARCHAR(255)</td>
755 <td class="db3">{image:db_check.gif|16|16}</td>
756 <td class="db4">&nbsp;</td>
757 <td class="db5">&nbsp;</td>
758 <td class="db6">&nbsp;</td>
759 <td class="db7">&nbsp;</td>
760 </tr>
761 <tr>
762 <td class="db0">{image:db_field.gif|16|16}</td>
763 <td class="db1">XWS_VALUE</td>
764 <td class="db2">DATETIME</td>
765 <td class="db3">&nbsp;</td>
766 <td class="db4">&nbsp;</td>
767 <td class="db5">&nbsp;</td>
768 <td class="db6">null</td>
769 <td class="db7">&nbsp;</td>
770 </tr>
771 </table>
772
773 The field name prefix is this table is wrong. It should be corrected in xwiki.hbm.xml.
774
775 [^ back to top ^>#Tables]
776
777 1.1.1 XWiki Doubles
778
779 This table contain the data for double properties in XWiki Objects.
780
781 <table border="0" width="100%" class="dbtable" cellpadding="3"
782 cellspacing="0">
783 <tr>
784 <td colspan="8" class="dbhead">xwikidoubles</td>
785 </tr>
786 <tr>
787 <th class="db0">&nbsp;</th>
788 <th class="db1">Column Name</th>
789 <th class="db2">Datatype</th>
790 <th class="db3">Not null</th>
791 <th class="db4">auto inc</th>
792 <th class="db5">flags</th>
793 <th class="db6">Default Value</th>
794 <th class="db7">Comments</th>
795 </tr>
796 <tr>
797 <td class="db0">{image:db_key.gif|16|16}</td>
798 <td class="db1">XWD_ID</td>
799 <td class="db2">INTEGER</td>
800 <td class="db3">{image:db_check.gif|16|16}</td>
801 <td class="db4">&nbsp;</td>
802 <td class="db5">&nbsp;</td>
803 <td class="db6">0</td>
804 <td class="db7">&nbsp;</td>
805 </tr>
806 <tr>
807 <td class="db0">{image:db_key.gif|16|16}</td>
808 <td class="db1">XWD_NAME</td>
809 <td class="db2">VARCHAR(255)</td>
810 <td class="db3">{image:db_check.gif|16|16}</td>
811 <td class="db4">&nbsp;</td>
812 <td class="db5">&nbsp;</td>
813 <td class="db6">&nbsp;</td>
814 <td class="db7">&nbsp;</td>
815 </tr>
816 <tr>
817 <td class="db0">{image:db_field.gif|16|16}</td>
818 <td class="db1">XWD_VALUE</td>
819 <td class="db2">DOUBLE</td>
820 <td class="db3">&nbsp;</td>
821 <td class="db4">&nbsp;</td>
822 <td class="db5">&nbsp;</td>
823 <td class="db6">null</td>
824 <td class="db7">&nbsp;</td>
825 </tr>
826 </table>
827
828 [^ back to top ^>#Tables]
829
830 1.1.1 XWiki Floats
831
832 This table contain the data for floats properties in XWiki Objects.
833
834
835 <table border="0" width="100%" class="dbtable" cellpadding="3"
836 cellspacing="0">
837 <tr>
838 <td colspan="8" class="dbhead">xwikifloats</td>
839 </tr>
840 <tr>
841 <th class="db0">&nbsp;</th>
842 <th class="db1">Column Name</th>
843 <th class="db2">Datatype</th>
844 <th class="db3">Not null</th>
845 <th class="db4">auto inc</th>
846 <th class="db5">flags</th>
847 <th class="db6">Default Value</th>
848 <th class="db7">Comments</th>
849 </tr>
850 <tr>
851 <td class="db0">{image:db_key.gif|16|16}</td>
852 <td class="db1">XWF_ID</td>
853 <td class="db2">INTEGER</td>
854 <td class="db3">{image:db_check.gif|16|16}</td>
855 <td class="db4">&nbsp;</td>
856 <td class="db5">&nbsp;</td>
857 <td class="db6">0</td>
858 <td class="db7">&nbsp;</td>
859 </tr>
860 <tr>
861 <td class="db0">{image:db_key.gif|16|16}</td>
862 <td class="db1">XWF_NAME</td>
863 <td class="db2">VARCHAR(255)</td>
864 <td class="db3">{image:db_check.gif|16|16}</td>
865 <td class="db4">&nbsp;</td>
866 <td class="db5">&nbsp;</td>
867 <td class="db6">&nbsp;</td>
868 <td class="db7">&nbsp;</td>
869 </tr>
870 <tr>
871 <td class="db0">{image:db_field.gif|16|16}</td>
872 <td class="db1">XWF_VALUE</td>
873 <td class="db2">FLOAT</td>
874 <td class="db3">&nbsp;</td>
875 <td class="db4">&nbsp;</td>
876 <td class="db5">&nbsp;</td>
877 <td class="db6">null</td>
878 <td class="db7">&nbsp;</td>
879 </tr>
880 </table>
881
882 [^ back to top ^>#Tables]
883
884 1.1.1 XWiki Integers
885
886 This table contain the data for integer properties in XWiki Objects.
887
888
889 <table border="0" width="100%" class="dbtable" cellpadding="3"
890 cellspacing="0">
891 <tr>
892 <td colspan="8" class="dbhead">xwikiintegers</td>
893 </tr>
894 <tr>
895 <th class="db0">&nbsp;</th>
896 <th class="db1">Column Name</th>
897 <th class="db2">Datatype</th>
898 <th class="db3">Not null</th>
899 <th class="db4">auto inc</th>
900 <th class="db5">flags</th>
901 <th class="db6">Default Value</th>
902 <th class="db7">Comments</th>
903 </tr>
904 <tr>
905 <td class="db0">{image:db_key.gif|16|16}</td>
906 <td class="db1">XWI_ID</td>
907 <td class="db2">INTEGER</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">0</td>
912 <td class="db7">&nbsp;</td>
913 </tr>
914 <tr>
915 <td class="db0">{image:db_key.gif|16|16}</td>
916 <td class="db1">XWI_NAME</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">XWI_VALUE</td>
927 <td class="db2">INTEGER</td>
928 <td class="db3">&nbsp;</td>
929 <td class="db4">&nbsp;</td>
930 <td class="db5">&nbsp;</td>
931 <td class="db6">null</td>
932 <td class="db7">&nbsp;</td>
933 </tr>
934 </table>
935
936 [^ back to top ^>#Tables]
937
938 1.1.1 XWiki Longs
939
940 This table contain the data for long properties in XWiki Objects.
941
942 <table border="0" width="100%" class="dbtable" cellpadding="3"
943 cellspacing="0">
944 <tr>
945 <td colspan="8" class="dbhead">xwikilongs</td>
946 </tr>
947 <tr>
948 <th class="db0">&nbsp;</th>
949 <th class="db1">Column Name</th>
950 <th class="db2">Datatype</th>
951 <th class="db3">Not null</th>
952 <th class="db4">auto inc</th>
953 <th class="db5">flags</th>
954 <th class="db6">Default Value</th>
955 <th class="db7">Comments</th>
956 </tr>
957 <tr>
958 <td class="db0">{image:db_key.gif|16|16}</td>
959 <td class="db1">XWL_ID</td>
960 <td class="db2">INTEGER</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">0</td>
965 <td class="db7">&nbsp;</td>
966 </tr>
967 <tr>
968 <td class="db0">{image:db_key.gif|16|16}</td>
969 <td class="db1">XWL_NAME</td>
970 <td class="db2">VARCHAR(255)</td>
971 <td class="db3">{image:db_check.gif|16|16}</td>
972 <td class="db4">&nbsp;</td>
973 <td class="db5">&nbsp;</td>
974 <td class="db6">&nbsp;</td>
975 <td class="db7">&nbsp;</td>
976 </tr>
977 <tr>
978 <td class="db0">{image:db_field.gif|16|16}</td>
979 <td class="db1">XWL_VALUE</td>
980 <td class="db2">BIGINT(20)</td>
981 <td class="db3">&nbsp;</td>
982 <td class="db4">&nbsp;</td>
983 <td class="db5">&nbsp;</td>
984 <td class="db6">null</td>
985 <td class="db7">&nbsp;</td>
986 </tr>
987 </table>
988
989 [^ back to top ^>#Tables]
990
991 1.1.1 XWiki List Items
992
993 This table contain the data for lists properties in XWiki Objects.
994
995 <table border="0" width="100%" class="dbtable" cellpadding="3"
996 cellspacing="0">
997 <tr>
998 <td colspan="8" class="dbhead">xwikilistitems</td>
999 </tr>
1000 <tr>
1001 <th class="db0">&nbsp;</th>
1002 <th class="db1">Column Name</th>
1003 <th class="db2">Datatype</th>
1004 <th class="db3">Not null</th>
1005 <th class="db4">auto inc</th>
1006 <th class="db5">flags</th>
1007 <th class="db6">Default Value</th>
1008 <th class="db7">Comments</th>
1009 </tr>
1010 <tr>
1011 <td class="db0">{image:db_key.gif|16|16}</td>
1012 <td class="db1">XWL_ID</td>
1013 <td class="db2">INTEGER</td>
1014 <td class="db3">{image:db_check.gif|16|16}</td>
1015 <td class="db4">&nbsp;</td>
1016 <td class="db5">&nbsp;</td>
1017 <td class="db6">0</td>
1018 <td class="db7">&nbsp;</td>
1019 </tr>
1020 <tr>
1021 <td class="db0">{image:db_key.gif|16|16}</td>
1022 <td class="db1">XWL_NAME</td>
1023 <td class="db2">VARCHAR(255)</td>
1024 <td class="db3">{image:db_check.gif|16|16}</td>
1025 <td class="db4">&nbsp;</td>
1026 <td class="db5">&nbsp;</td>
1027 <td class="db6">&nbsp;</td>
1028 <td class="db7">&nbsp;</td>
1029 </tr>
1030 <tr>
1031 <td class="db0">{image:db_field.gif|16|16}</td>
1032 <td class="db1">XWL_VALUE</td>
1033 <td class="db2">VARCHAR(255)</td>
1034 <td class="db3">&nbsp;</td>
1035 <td class="db4">&nbsp;</td>
1036 <td class="db5">&nbsp;</td>
1037 <td class="db6">null</td>
1038 <td class="db7">&nbsp;</td>
1039 </tr>
1040 <tr>
1041 <td class="db0">{image:db_key.gif|16|16}</td>
1042 <td class="db1">XWL_NUMBER</td>
1043 <td class="db2">INTEGER</td>
1044 <td class="db3">{image:db_check.gif|16|16}</td>
1045 <td class="db4">&nbsp;</td>
1046 <td class="db5">&nbsp;</td>
1047 <td class="db6">0</td>
1048 <td class="db7">&nbsp;</td>
1049 </tr>
1050 </table>
1051
1052 [^ back to top ^>#Tables]
1053
1054 1.1.1 XWiki Lists
1055
1056 This table contain the data for lists properties in XWiki Objects.
1057
1058
1059 <table border="0" width="100%" class="dbtable" cellpadding="3"
1060 cellspacing="0">
1061 <tr>
1062 <td colspan="8" class="dbhead">xwikilists</td>
1063 </tr>
1064 <tr>
1065 <th class="db0">&nbsp;</th>
1066 <th class="db1">Column Name</th>
1067 <th class="db2">Datatype</th>
1068 <th class="db3">Not null</th>
1069 <th class="db4">auto inc</th>
1070 <th class="db5">flags</th>
1071 <th class="db6">Default Value</th>
1072 <th class="db7">Comments</th>
1073 </tr>
1074 <tr>
1075 <td class="db0">{image:db_key.gif|16|16}</td>
1076 <td class="db1">XWL_ID</td>
1077 <td class="db2">INTEGER</td>
1078 <td class="db3">{image:db_check.gif|16|16}</td>
1079 <td class="db4">&nbsp;</td>
1080 <td class="db5">&nbsp;</td>
1081 <td class="db6">0</td>
1082 <td class="db7">&nbsp;</td>
1083 </tr>
1084 <tr>
1085 <td class="db0">{image:db_key.gif|16|16}</td>
1086 <td class="db1">XWL_NAME</td>
1087 <td class="db2">VARCHAR(255)</td>
1088 <td class="db3">{image:db_check.gif|16|16}</td>
1089 <td class="db4">&nbsp;</td>
1090 <td class="db5">&nbsp;</td>
1091 <td class="db6">&nbsp;</td>
1092 <td class="db7">&nbsp;</td>
1093 </tr>
1094 </table>
1095
1096 [^ back to top ^>#Tables]
1097
1098 1.1 Statistics
1099
1100 1.1.1 XWiki Document Stats
1101
1102 This table contain stats information, namely page/space/wiki views and edits
1103 .
1104 <table border="0" width="100%" class="dbtable" cellpadding="3"
1105 cellspacing="0">
1106 <tr>
1107 <td colspan="8" class="dbhead">xwikistatsdoc</td>
1108 </tr>
1109 <tr>
1110 <th class="db0">&nbsp;</th>
1111 <th class="db1">Column Name</th>
1112 <th class="db2">Datatype</th>
1113 <th class="db3">Not null</th>
1114 <th class="db4">auto inc</th>
1115 <th class="db5">flags</th>
1116 <th class="db6">Default Value</th>
1117 <th class="db7">Comments</th>
1118 </tr>
1119 <tr>
1120 <td class="db0">{image:db_key.gif|16|16}</td>
1121 <td class="db1">XWS_ID</td>
1122 <td class="db2">INTEGER</td>
1123 <td class="db3">{image:db_check.gif|16|16}</td>
1124 <td class="db4">&nbsp;</td>
1125 <td class="db5">&nbsp;</td>
1126 <td class="db6">0</td>
1127 <td class="db7">&nbsp;</td>
1128 </tr>
1129 <tr>
1130 <td class="db0">{image:db_field.gif|16|16}</td>
1131 <td class="db1">XWS_NUMBER</td>
1132 <td class="db2">INTEGER</td>
1133 <td class="db3">&nbsp;</td>
1134 <td class="db4">&nbsp;</td>
1135 <td class="db5">&nbsp;</td>
1136 <td class="db6">null&nbsp;</td>
1137 <td class="db7">&nbsp;</td>
1138 </tr>
1139 <tr>
1140 <td class="db0">{image:db_field.gif|16|16}</td>
1141 <td class="db1">XWS_NAME</td>
1142 <td class="db2">VARCHAR(255)</td>
1143 <td class="db3">{image:db_check.gif|16|16}</td>
1144 <td class="db4">&nbsp;</td>
1145 <td class="db5">&nbsp;</td>
1146 <td class="db6">&nbsp;</td>
1147 <td class="db7">&nbsp;</td>
1148 </tr>
1149 <tr>
1150 <td class="db0">{image:db_field.gif|16|16}</td>
1151 <td class="db1">XWS_CLASSNAME</td>
1152 <td class="db2">VARCHAR(255)</td>
1153 <td class="db3">{image:db_check.gif|16|16}</td>
1154 <td class="db4">&nbsp;</td>
1155 <td class="db5">&nbsp;</td>
1156 <td class="db6">&nbsp;</td>
1157 <td class="db7">&nbsp;</td>
1158 </tr>
1159 <tr>
1160 <td class="db0">{image:db_field.gif|16|16}</td>
1161 <td class="db1">XWS_ACTION</td>
1162 <td class="db2">VARCHAR(255)</td>
1163 <td class="db3">{image:db_check.gif|16|16}</td>
1164 <td class="db4">&nbsp;</td>
1165 <td class="db5">&nbsp;</td>
1166 <td class="db6">&nbsp;</td>
1167 <td class="db7">&nbsp;</td>
1168 </tr>
1169 <tr>
1170 <td class="db0">{image:db_field.gif|16|16}</td>
1171 <td class="db1">XWS_PAGE_VIEWS</td>
1172 <td class="db2">INTEGER</td>
1173 <td class="db3">&nbsp;</td>
1174 <td class="db4">&nbsp;</td>
1175 <td class="db5">&nbsp;</td>
1176 <td class="db6">null</td>
1177 <td class="db7">&nbsp;</td>
1178 </tr>
1179 <tr>
1180 <td class="db0">{image:db_field.gif|16|16}</td>
1181 <td class="db1">XWS_UNIQUE_VISITORS</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">XWS_PERIOD</td>
1192 <td class="db2">INTEGER</td>
1193 <td class="db3">&nbsp;</td>
1194 <td class="db4">&nbsp;</td>
1195 <td class="db5">&nbsp;</td>
1196 <td class="db6">null</td>
1197 <td class="db7">&nbsp;</td>
1198 </tr>
1199 <tr>
1200 <td class="db0">{image:db_field.gif|16|16}</td>
1201 <td class="db1">XWS_VISITS</td>
1202 <td class="db2">INTEGER</td>
1203 <td class="db3">&nbsp;</td>
1204 <td class="db4">&nbsp;</td>
1205 <td class="db5">&nbsp;</td>
1206 <td class="db6">null</td>
1207 <td class="db7">&nbsp;</td>
1208 </tr>
1209 </table>
1210
1211 [^ back to top ^>#Tables]
1212
1213 1.1.1 XWiki Referer Stats
1214
1215 This page contains the incoming externa links on the Wiki.
1216
1217 <table border="0" width="100%" class="dbtable" cellpadding="3"
1218 cellspacing="0">
1219 <tr>
1220 <td colspan="8" class="dbhead">xwikistatsreferer</td>
1221 </tr>
1222 <tr>
1223 <th class="db0">&nbsp;</th>
1224 <th class="db1">Column Name</th>
1225 <th class="db2">Datatype</th>
1226 <th class="db3">Not null</th>
1227 <th class="db4">auto inc</th>
1228 <th class="db5">flags</th>
1229 <th class="db6">Default Value</th>
1230 <th class="db7">Comments</th>
1231 </tr>
1232 <tr>
1233 <td class="db0">{image:db_key.gif|16|16}</td>
1234 <td class="db1">XWR_ID</td>
1235 <td class="db2">INTEGER</td>
1236 <td class="db3">{image:db_check.gif|16|16}</td>
1237 <td class="db4">&nbsp;</td>
1238 <td class="db5">&nbsp;</td>
1239 <td class="db6">0</td>
1240 <td class="db7">&nbsp;</td>
1241 </tr>
1242 <tr>
1243 <td class="db0">{image:db_field.gif|16|16}</td>
1244 <td class="db1">XWR_NUMBER</td>
1245 <td class="db2">INTEGER</td>
1246 <td class="db3">&nbsp;</td>
1247 <td class="db4">&nbsp;</td>
1248 <td class="db5">&nbsp;</td>
1249 <td class="db6">null</td>
1250 <td class="db7">&nbsp;</td>
1251 </tr>
1252 <tr>
1253 <td class="db0">{image:db_field.gif|16|16}</td>
1254 <td class="db1">XWR_NAME</td>
1255 <td class="db2">VARCHAR(255)</td>
1256 <td class="db3">{image:db_check.gif|16|16}</td>
1257 <td class="db4">&nbsp;</td>
1258 <td class="db5">&nbsp;</td>
1259 <td class="db6">&nbsp;</td>
1260 <td class="db7">&nbsp;</td>
1261 </tr>
1262 <tr>
1263 <td class="db0">{image:db_field.gif|16|16}</td>
1264 <td class="db1">XWR_CLASSNAME</td>
1265 <td class="db2">VARCHAR(255)</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">&nbsp;</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">XWR_REFERER</td>
1275 <td class="db2">VARCHAR(255)</td>
1276 <td class="db3">{image:db_check.gif|16|16}</td>
1277 <td class="db4">&nbsp;</td>
1278 <td class="db5">&nbsp;</td>
1279 <td class="db6">&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">XWR_PAGE_VIEWS</td>
1285 <td class="db2">INTEGER</td>
1286 <td class="db3">&nbsp;</td>
1287 <td class="db4">&nbsp;</td>
1288 <td class="db5">&nbsp;</td>
1289 <td class="db6">null</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">XWR_PERIOD</td>
1295 <td class="db2">INTEGER</td>
1296 <td class="db3">&nbsp;</td>
1297 <td class="db4">&nbsp;</td>
1298 <td class="db5">&nbsp;</td>
1299 <td class="db6">null</td>
1300 <td class="db7">&nbsp;</td>
1301 </tr>
1302 </table>
1303
1304 [^ back to top ^>#Tables]
1305
1306 1.1.1 XWiki Visits
1307
1308 This table contains the sessions of the named users.
1309
1310 <table border="0" width="100%" class="dbtable" cellpadding="3"
1311 cellspacing="0">
1312 <tr>
1313 <td colspan="8" class="dbhead">xwikistatsvisit</td>
1314 </tr>
1315 <tr>
1316 <th class="db0">&nbsp;</th>
1317 <th class="db1">Column Name</th>
1318 <th class="db2">Datatype</th>
1319 <th class="db3">Not null</th>
1320 <th class="db4">auto inc</th>
1321 <th class="db5">flags</th>
1322 <th class="db6">Default Value</th>
1323 <th class="db7">Comments</th>
1324 </tr>
1325 <tr>
1326 <td class="db0">{image:db_key.gif|16|16}</td>
1327 <td class="db1">XWV_ID</td>
1328 <td class="db2">INTEGER</td>
1329 <td class="db3">{image:db_check.gif|16|16}</td>
1330 <td class="db4">&nbsp;</td>
1331 <td class="db5">&nbsp;</td>
1332 <td class="db6">0</td>
1333 <td class="db7">&nbsp;</td>
1334 </tr>
1335 <tr>
1336 <td class="db0">{image:db_field.gif|16|16}</td>
1337 <td class="db1">XWV_NUMBER</td>
1338 <td class="db2">INTEGER</td>
1339 <td class="db3">&nbsp;</td>
1340 <td class="db4">&nbsp;</td>
1341 <td class="db5">&nbsp;</td>
1342 <td class="db6">null&nbsp;</td>
1343 <td class="db7">&nbsp;</td>
1344 </tr>
1345 <tr>
1346 <td class="db0">{image:db_field.gif|16|16}</td>
1347 <td class="db1">XWV_NAME</td>
1348 <td class="db2">VARCHAR(255)</td>
1349 <td class="db3">{image:db_check.gif|16|16}</td>
1350 <td class="db4">&nbsp;</td>
1351 <td class="db5">&nbsp;</td>
1352 <td class="db6">&nbsp;</td>
1353 <td class="db7">&nbsp;</td>
1354 </tr>
1355 <tr>
1356 <td class="db0">{image:db_field.gif|16|16}</td>
1357 <td class="db1">XWV_CLASSNAME</td>
1358 <td class="db2">VARCHAR(255)</td>
1359 <td class="db3">{image:db_check.gif|16|16}</td>
1360 <td class="db4">&nbsp;</td>
1361 <td class="db5">&nbsp;</td>
1362 <td class="db6">&nbsp;</td>
1363 <td class="db7">&nbsp;</td>
1364 </tr>
1365 <tr>
1366 <td class="db0">{image:db_field.gif|16|16}</td>
1367 <td class="db1">XWV_IP</td>
1368 <td class="db2">VARCHAR(32)</td>
1369 <td class="db3">{image:db_check.gif|16|16}</td>
1370 <td class="db4">&nbsp;</td>
1371 <td class="db5">&nbsp;</td>
1372 <td class="db6">&nbsp;</td>
1373 <td class="db7">&nbsp;</td>
1374 </tr>
1375 <tr>
1376 <td class="db0">{image:db_field.gif|16|16}</td>
1377 <td class="db1">XWV_USER_AGENT</td>
1378 <td class="db2">VARCHAR(255)</td>
1379 <td class="db3">{image:db_check.gif|16|16}</td>
1380 <td class="db4">&nbsp;</td>
1381 <td class="db5">&nbsp;</td>
1382 <td class="db6">&nbsp;</td>
1383 <td class="db7">&nbsp;</td>
1384 </tr>
1385 <tr>
1386 <td class="db0">{image:db_field.gif|16|16}</td>
1387 <td class="db1">XWV_COOKIE</td>
1388 <td class="db2">VARCHAR(255)</td>
1389 <td class="db3">{image:db_check.gif|16|16}</td>
1390 <td class="db4">&nbsp;</td>
1391 <td class="db5">&nbsp;</td>
1392 <td class="db6">&nbsp;</td>
1393 <td class="db7">&nbsp;</td>
1394 </tr>
1395 <tr>
1396 <td class="db0">{image:db_field.gif|16|16}</td>
1397 <td class="db1">XWV_UNIQUE_ID</td>
1398 <td class="db2">VARCHAR(255)</td>
1399 <td class="db3">{image:db_check.gif|16|16}</td>
1400 <td class="db4">&nbsp;</td>
1401 <td class="db5">&nbsp;</td>
1402 <td class="db6">&nbsp;</td>
1403 <td class="db7">&nbsp;</td>
1404 </tr>
1405 <tr>
1406 <td class="db0">{image:db_field.gif|16|16}</td>
1407 <td class="db1">XWV_PAGE_VIEWS</td>
1408 <td class="db2">INTEGER</td>
1409 <td class="db3">&nbsp;</td>
1410 <td class="db4">&nbsp;</td>
1411 <td class="db5">&nbsp;</td>
1412 <td class="db6">null</td>
1413 <td class="db7">&nbsp;</td>
1414 </tr>
1415 <tr>
1416 <td class="db0">{image:db_field.gif|16|16}</td>
1417 <td class="db1">XWV_SAVES</td>
1418 <td class="db2">INTEGER</td>
1419 <td class="db3">&nbsp;</td>
1420 <td class="db4">&nbsp;</td>
1421 <td class="db5">&nbsp;</td>
1422 <td class="db6">null</td>
1423 <td class="db7">&nbsp;</td>
1424 </tr>
1425 <tr>
1426 <td class="db0">{image:db_field.gif|16|16}</td>
1427 <td class="db1">XWV_DOWNLOADS</td>
1428 <td class="db2">INTEGER</td>
1429 <td class="db3">&nbsp;</td>
1430 <td class="db4">&nbsp;</td>
1431 <td class="db5">&nbsp;</td>
1432 <td class="db6">null</td>
1433 <td class="db7">&nbsp;</td>
1434 </tr>
1435 <tr>
1436 <td class="db0">{image:db_field.gif|16|16}</td>
1437 <td class="db1">XWV_START_DATE</td>
1438 <td class="db2">DATETIME</td>
1439 <td class="db3">&nbsp;</td>
1440 <td class="db4">&nbsp;</td>
1441 <td class="db5">&nbsp;</td>
1442 <td class="db6">null</td>
1443 <td class="db7">&nbsp;</td>
1444 </tr>
1445 <tr>
1446 <td class="db0">{image:db_field.gif|16|16}</td>
1447 <td class="db1">XWV_END_DATE</td>
1448 <td class="db2">DATETIME</td>
1449 <td class="db3">&nbsp;</td>
1450 <td class="db4">&nbsp;</td>
1451 <td class="db5">&nbsp;</td>
1452 <td class="db6">null</td>
1453 <td class="db7">&nbsp;</td>
1454 </tr>
1455 </table>
1456
1457 [^ back to top ^>#Tables]
1458 $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