Skip to Content

Wiki source code of DatabaseSchema

Version 71.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>DsXWikiLargeStrings]
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>DevGuide.DsXWikiNumberClasses]
41 * [xwikiobjects>DevGuide.DsXWikiObjects]
42 * xwikipreferences
43 * [xwikiproperties>DevGuide.DsXWikiProperties]
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>DevGuide.DsXWikiStrings]
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 Dates
59
60 This table contains the data of date properties in XWiki objects.
61
62 <table border="0" width="100%" class="dbtable" cellpadding="3"
63 cellspacing="0">
64 <tr>
65 <td colspan="8" class="dbhead">xwikidates</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_VALUE</td>
100 <td class="db2">DATETIME</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 </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 Doubles
114
115 This table contain the data for double properties in XWiki Objects.
116
117 <table border="0" width="100%" class="dbtable" cellpadding="3"
118 cellspacing="0">
119 <tr>
120 <td colspan="8" class="dbhead">xwikidoubles</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">XWD_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">XWD_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">XWD_VALUE</td>
155 <td class="db2">DOUBLE</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 </table>
163
164 [^ back to top ^>#Tables]
165
166 1.1.1 XWiki Floats
167
168 This table contain the data for floats properties in XWiki Objects.
169
170
171 <table border="0" width="100%" class="dbtable" cellpadding="3"
172 cellspacing="0">
173 <tr>
174 <td colspan="8" class="dbhead">xwikifloats</td>
175 </tr>
176 <tr>
177 <th class="db0">&nbsp;</th>
178 <th class="db1">Column Name</th>
179 <th class="db2">Datatype</th>
180 <th class="db3">Not null</th>
181 <th class="db4">auto inc</th>
182 <th class="db5">flags</th>
183 <th class="db6">Default Value</th>
184 <th class="db7">Comments</th>
185 </tr>
186 <tr>
187 <td class="db0">{image:db_key.gif|16|16}</td>
188 <td class="db1">XWF_ID</td>
189 <td class="db2">INTEGER</td>
190 <td class="db3">{image:db_check.gif|16|16}</td>
191 <td class="db4">&nbsp;</td>
192 <td class="db5">&nbsp;</td>
193 <td class="db6">0</td>
194 <td class="db7">&nbsp;</td>
195 </tr>
196 <tr>
197 <td class="db0">{image:db_key.gif|16|16}</td>
198 <td class="db1">XWF_NAME</td>
199 <td class="db2">VARCHAR(255)</td>
200 <td class="db3">{image:db_check.gif|16|16}</td>
201 <td class="db4">&nbsp;</td>
202 <td class="db5">&nbsp;</td>
203 <td class="db6">&nbsp;</td>
204 <td class="db7">&nbsp;</td>
205 </tr>
206 <tr>
207 <td class="db0">{image:db_field.gif|16|16}</td>
208 <td class="db1">XWF_VALUE</td>
209 <td class="db2">FLOAT</td>
210 <td class="db3">&nbsp;</td>
211 <td class="db4">&nbsp;</td>
212 <td class="db5">&nbsp;</td>
213 <td class="db6">null</td>
214 <td class="db7">&nbsp;</td>
215 </tr>
216 </table>
217
218 [^ back to top ^>#Tables]
219
220 1.1.1 XWiki Integers
221
222 This table contain the data for integer properties in XWiki Objects.
223
224
225 <table border="0" width="100%" class="dbtable" cellpadding="3"
226 cellspacing="0">
227 <tr>
228 <td colspan="8" class="dbhead">xwikiintegers</td>
229 </tr>
230 <tr>
231 <th class="db0">&nbsp;</th>
232 <th class="db1">Column Name</th>
233 <th class="db2">Datatype</th>
234 <th class="db3">Not null</th>
235 <th class="db4">auto inc</th>
236 <th class="db5">flags</th>
237 <th class="db6">Default Value</th>
238 <th class="db7">Comments</th>
239 </tr>
240 <tr>
241 <td class="db0">{image:db_key.gif|16|16}</td>
242 <td class="db1">XWI_ID</td>
243 <td class="db2">INTEGER</td>
244 <td class="db3">{image:db_check.gif|16|16}</td>
245 <td class="db4">&nbsp;</td>
246 <td class="db5">&nbsp;</td>
247 <td class="db6">0</td>
248 <td class="db7">&nbsp;</td>
249 </tr>
250 <tr>
251 <td class="db0">{image:db_key.gif|16|16}</td>
252 <td class="db1">XWI_NAME</td>
253 <td class="db2">VARCHAR(255)</td>
254 <td class="db3">{image:db_check.gif|16|16}</td>
255 <td class="db4">&nbsp;</td>
256 <td class="db5">&nbsp;</td>
257 <td class="db6">&nbsp;</td>
258 <td class="db7">&nbsp;</td>
259 </tr>
260 <tr>
261 <td class="db0">{image:db_field.gif|16|16}</td>
262 <td class="db1">XWI_VALUE</td>
263 <td class="db2">INTEGER</td>
264 <td class="db3">&nbsp;</td>
265 <td class="db4">&nbsp;</td>
266 <td class="db5">&nbsp;</td>
267 <td class="db6">null</td>
268 <td class="db7">&nbsp;</td>
269 </tr>
270 </table>
271
272 [^ back to top ^>#Tables]
273
274 1.1.1 XWiki Longs
275
276 This table contain the data for long properties in XWiki Objects.
277
278 <table border="0" width="100%" class="dbtable" cellpadding="3"
279 cellspacing="0">
280 <tr>
281 <td colspan="8" class="dbhead">xwikilongs</td>
282 </tr>
283 <tr>
284 <th class="db0">&nbsp;</th>
285 <th class="db1">Column Name</th>
286 <th class="db2">Datatype</th>
287 <th class="db3">Not null</th>
288 <th class="db4">auto inc</th>
289 <th class="db5">flags</th>
290 <th class="db6">Default Value</th>
291 <th class="db7">Comments</th>
292 </tr>
293 <tr>
294 <td class="db0">{image:db_key.gif|16|16}</td>
295 <td class="db1">XWL_ID</td>
296 <td class="db2">INTEGER</td>
297 <td class="db3">{image:db_check.gif|16|16}</td>
298 <td class="db4">&nbsp;</td>
299 <td class="db5">&nbsp;</td>
300 <td class="db6">0</td>
301 <td class="db7">&nbsp;</td>
302 </tr>
303 <tr>
304 <td class="db0">{image:db_key.gif|16|16}</td>
305 <td class="db1">XWL_NAME</td>
306 <td class="db2">VARCHAR(255)</td>
307 <td class="db3">{image:db_check.gif|16|16}</td>
308 <td class="db4">&nbsp;</td>
309 <td class="db5">&nbsp;</td>
310 <td class="db6">&nbsp;</td>
311 <td class="db7">&nbsp;</td>
312 </tr>
313 <tr>
314 <td class="db0">{image:db_field.gif|16|16}</td>
315 <td class="db1">XWL_VALUE</td>
316 <td class="db2">BIGINT(20)</td>
317 <td class="db3">&nbsp;</td>
318 <td class="db4">&nbsp;</td>
319 <td class="db5">&nbsp;</td>
320 <td class="db6">null</td>
321 <td class="db7">&nbsp;</td>
322 </tr>
323 </table>
324
325 [^ back to top ^>#Tables]
326
327 1.1.1 XWiki List Items
328
329 This table contain the data for lists properties in XWiki Objects.
330
331 <table border="0" width="100%" class="dbtable" cellpadding="3"
332 cellspacing="0">
333 <tr>
334 <td colspan="8" class="dbhead">xwikilistitems</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">XWL_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">XWL_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">XWL_VALUE</td>
369 <td class="db2">VARCHAR(255)</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 <tr>
377 <td class="db0">{image:db_key.gif|16|16}</td>
378 <td class="db1">XWL_NUMBER</td>
379 <td class="db2">INTEGER</td>
380 <td class="db3">{image:db_check.gif|16|16}</td>
381 <td class="db4">&nbsp;</td>
382 <td class="db5">&nbsp;</td>
383 <td class="db6">0</td>
384 <td class="db7">&nbsp;</td>
385 </tr>
386 </table>
387
388 [^ back to top ^>#Tables]
389
390 1.1.1 XWiki Lists
391
392 This table contain the data for lists properties in XWiki Objects.
393
394
395 <table border="0" width="100%" class="dbtable" cellpadding="3"
396 cellspacing="0">
397 <tr>
398 <td colspan="8" class="dbhead">xwikilists</td>
399 </tr>
400 <tr>
401 <th class="db0">&nbsp;</th>
402 <th class="db1">Column Name</th>
403 <th class="db2">Datatype</th>
404 <th class="db3">Not null</th>
405 <th class="db4">auto inc</th>
406 <th class="db5">flags</th>
407 <th class="db6">Default Value</th>
408 <th class="db7">Comments</th>
409 </tr>
410 <tr>
411 <td class="db0">{image:db_key.gif|16|16}</td>
412 <td class="db1">XWL_ID</td>
413 <td class="db2">INTEGER</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">0</td>
418 <td class="db7">&nbsp;</td>
419 </tr>
420 <tr>
421 <td class="db0">{image:db_key.gif|16|16}</td>
422 <td class="db1">XWL_NAME</td>
423 <td class="db2">VARCHAR(255)</td>
424 <td class="db3">{image:db_check.gif|16|16}</td>
425 <td class="db4">&nbsp;</td>
426 <td class="db5">&nbsp;</td>
427 <td class="db6">&nbsp;</td>
428 <td class="db7">&nbsp;</td>
429 </tr>
430 </table>
431
432 [^ back to top ^>#Tables]
433
434 1.1 Statistics
435
436 1.1.1 XWiki Document Stats
437
438 This table contain stats information, namely page/space/wiki views and edits
439 .
440 <table border="0" width="100%" class="dbtable" cellpadding="3"
441 cellspacing="0">
442 <tr>
443 <td colspan="8" class="dbhead">xwikistatsdoc</td>
444 </tr>
445 <tr>
446 <th class="db0">&nbsp;</th>
447 <th class="db1">Column Name</th>
448 <th class="db2">Datatype</th>
449 <th class="db3">Not null</th>
450 <th class="db4">auto inc</th>
451 <th class="db5">flags</th>
452 <th class="db6">Default Value</th>
453 <th class="db7">Comments</th>
454 </tr>
455 <tr>
456 <td class="db0">{image:db_key.gif|16|16}</td>
457 <td class="db1">XWS_ID</td>
458 <td class="db2">INTEGER</td>
459 <td class="db3">{image:db_check.gif|16|16}</td>
460 <td class="db4">&nbsp;</td>
461 <td class="db5">&nbsp;</td>
462 <td class="db6">0</td>
463 <td class="db7">&nbsp;</td>
464 </tr>
465 <tr>
466 <td class="db0">{image:db_field.gif|16|16}</td>
467 <td class="db1">XWS_NUMBER</td>
468 <td class="db2">INTEGER</td>
469 <td class="db3">&nbsp;</td>
470 <td class="db4">&nbsp;</td>
471 <td class="db5">&nbsp;</td>
472 <td class="db6">null&nbsp;</td>
473 <td class="db7">&nbsp;</td>
474 </tr>
475 <tr>
476 <td class="db0">{image:db_field.gif|16|16}</td>
477 <td class="db1">XWS_NAME</td>
478 <td class="db2">VARCHAR(255)</td>
479 <td class="db3">{image:db_check.gif|16|16}</td>
480 <td class="db4">&nbsp;</td>
481 <td class="db5">&nbsp;</td>
482 <td class="db6">&nbsp;</td>
483 <td class="db7">&nbsp;</td>
484 </tr>
485 <tr>
486 <td class="db0">{image:db_field.gif|16|16}</td>
487 <td class="db1">XWS_CLASSNAME</td>
488 <td class="db2">VARCHAR(255)</td>
489 <td class="db3">{image:db_check.gif|16|16}</td>
490 <td class="db4">&nbsp;</td>
491 <td class="db5">&nbsp;</td>
492 <td class="db6">&nbsp;</td>
493 <td class="db7">&nbsp;</td>
494 </tr>
495 <tr>
496 <td class="db0">{image:db_field.gif|16|16}</td>
497 <td class="db1">XWS_ACTION</td>
498 <td class="db2">VARCHAR(255)</td>
499 <td class="db3">{image:db_check.gif|16|16}</td>
500 <td class="db4">&nbsp;</td>
501 <td class="db5">&nbsp;</td>
502 <td class="db6">&nbsp;</td>
503 <td class="db7">&nbsp;</td>
504 </tr>
505 <tr>
506 <td class="db0">{image:db_field.gif|16|16}</td>
507 <td class="db1">XWS_PAGE_VIEWS</td>
508 <td class="db2">INTEGER</td>
509 <td class="db3">&nbsp;</td>
510 <td class="db4">&nbsp;</td>
511 <td class="db5">&nbsp;</td>
512 <td class="db6">null</td>
513 <td class="db7">&nbsp;</td>
514 </tr>
515 <tr>
516 <td class="db0">{image:db_field.gif|16|16}</td>
517 <td class="db1">XWS_UNIQUE_VISITORS</td>
518 <td class="db2">INTEGER</td>
519 <td class="db3">&nbsp;</td>
520 <td class="db4">&nbsp;</td>
521 <td class="db5">&nbsp;</td>
522 <td class="db6">null</td>
523 <td class="db7">&nbsp;</td>
524 </tr>
525 <tr>
526 <td class="db0">{image:db_field.gif|16|16}</td>
527 <td class="db1">XWS_PERIOD</td>
528 <td class="db2">INTEGER</td>
529 <td class="db3">&nbsp;</td>
530 <td class="db4">&nbsp;</td>
531 <td class="db5">&nbsp;</td>
532 <td class="db6">null</td>
533 <td class="db7">&nbsp;</td>
534 </tr>
535 <tr>
536 <td class="db0">{image:db_field.gif|16|16}</td>
537 <td class="db1">XWS_VISITS</td>
538 <td class="db2">INTEGER</td>
539 <td class="db3">&nbsp;</td>
540 <td class="db4">&nbsp;</td>
541 <td class="db5">&nbsp;</td>
542 <td class="db6">null</td>
543 <td class="db7">&nbsp;</td>
544 </tr>
545 </table>
546
547 [^ back to top ^>#Tables]
548
549 1.1.1 XWiki Referer Stats
550
551 This page contains the incoming externa links on the Wiki.
552
553 <table border="0" width="100%" class="dbtable" cellpadding="3"
554 cellspacing="0">
555 <tr>
556 <td colspan="8" class="dbhead">xwikistatsreferer</td>
557 </tr>
558 <tr>
559 <th class="db0">&nbsp;</th>
560 <th class="db1">Column Name</th>
561 <th class="db2">Datatype</th>
562 <th class="db3">Not null</th>
563 <th class="db4">auto inc</th>
564 <th class="db5">flags</th>
565 <th class="db6">Default Value</th>
566 <th class="db7">Comments</th>
567 </tr>
568 <tr>
569 <td class="db0">{image:db_key.gif|16|16}</td>
570 <td class="db1">XWR_ID</td>
571 <td class="db2">INTEGER</td>
572 <td class="db3">{image:db_check.gif|16|16}</td>
573 <td class="db4">&nbsp;</td>
574 <td class="db5">&nbsp;</td>
575 <td class="db6">0</td>
576 <td class="db7">&nbsp;</td>
577 </tr>
578 <tr>
579 <td class="db0">{image:db_field.gif|16|16}</td>
580 <td class="db1">XWR_NUMBER</td>
581 <td class="db2">INTEGER</td>
582 <td class="db3">&nbsp;</td>
583 <td class="db4">&nbsp;</td>
584 <td class="db5">&nbsp;</td>
585 <td class="db6">null</td>
586 <td class="db7">&nbsp;</td>
587 </tr>
588 <tr>
589 <td class="db0">{image:db_field.gif|16|16}</td>
590 <td class="db1">XWR_NAME</td>
591 <td class="db2">VARCHAR(255)</td>
592 <td class="db3">{image:db_check.gif|16|16}</td>
593 <td class="db4">&nbsp;</td>
594 <td class="db5">&nbsp;</td>
595 <td class="db6">&nbsp;</td>
596 <td class="db7">&nbsp;</td>
597 </tr>
598 <tr>
599 <td class="db0">{image:db_field.gif|16|16}</td>
600 <td class="db1">XWR_CLASSNAME</td>
601 <td class="db2">VARCHAR(255)</td>
602 <td class="db3">{image:db_check.gif|16|16}</td>
603 <td class="db4">&nbsp;</td>
604 <td class="db5">&nbsp;</td>
605 <td class="db6">&nbsp;</td>
606 <td class="db7">&nbsp;</td>
607 </tr>
608 <tr>
609 <td class="db0">{image:db_field.gif|16|16}</td>
610 <td class="db1">XWR_REFERER</td>
611 <td class="db2">VARCHAR(255)</td>
612 <td class="db3">{image:db_check.gif|16|16}</td>
613 <td class="db4">&nbsp;</td>
614 <td class="db5">&nbsp;</td>
615 <td class="db6">&nbsp;</td>
616 <td class="db7">&nbsp;</td>
617 </tr>
618 <tr>
619 <td class="db0">{image:db_field.gif|16|16}</td>
620 <td class="db1">XWR_PAGE_VIEWS</td>
621 <td class="db2">INTEGER</td>
622 <td class="db3">&nbsp;</td>
623 <td class="db4">&nbsp;</td>
624 <td class="db5">&nbsp;</td>
625 <td class="db6">null</td>
626 <td class="db7">&nbsp;</td>
627 </tr>
628 <tr>
629 <td class="db0">{image:db_field.gif|16|16}</td>
630 <td class="db1">XWR_PERIOD</td>
631 <td class="db2">INTEGER</td>
632 <td class="db3">&nbsp;</td>
633 <td class="db4">&nbsp;</td>
634 <td class="db5">&nbsp;</td>
635 <td class="db6">null</td>
636 <td class="db7">&nbsp;</td>
637 </tr>
638 </table>
639
640 [^ back to top ^>#Tables]
641
642 1.1.1 XWiki Visits
643
644 This table contains the sessions of the named users.
645
646 <table border="0" width="100%" class="dbtable" cellpadding="3"
647 cellspacing="0">
648 <tr>
649 <td colspan="8" class="dbhead">xwikistatsvisit</td>
650 </tr>
651 <tr>
652 <th class="db0">&nbsp;</th>
653 <th class="db1">Column Name</th>
654 <th class="db2">Datatype</th>
655 <th class="db3">Not null</th>
656 <th class="db4">auto inc</th>
657 <th class="db5">flags</th>
658 <th class="db6">Default Value</th>
659 <th class="db7">Comments</th>
660 </tr>
661 <tr>
662 <td class="db0">{image:db_key.gif|16|16}</td>
663 <td class="db1">XWV_ID</td>
664 <td class="db2">INTEGER</td>
665 <td class="db3">{image:db_check.gif|16|16}</td>
666 <td class="db4">&nbsp;</td>
667 <td class="db5">&nbsp;</td>
668 <td class="db6">0</td>
669 <td class="db7">&nbsp;</td>
670 </tr>
671 <tr>
672 <td class="db0">{image:db_field.gif|16|16}</td>
673 <td class="db1">XWV_NUMBER</td>
674 <td class="db2">INTEGER</td>
675 <td class="db3">&nbsp;</td>
676 <td class="db4">&nbsp;</td>
677 <td class="db5">&nbsp;</td>
678 <td class="db6">null&nbsp;</td>
679 <td class="db7">&nbsp;</td>
680 </tr>
681 <tr>
682 <td class="db0">{image:db_field.gif|16|16}</td>
683 <td class="db1">XWV_NAME</td>
684 <td class="db2">VARCHAR(255)</td>
685 <td class="db3">{image:db_check.gif|16|16}</td>
686 <td class="db4">&nbsp;</td>
687 <td class="db5">&nbsp;</td>
688 <td class="db6">&nbsp;</td>
689 <td class="db7">&nbsp;</td>
690 </tr>
691 <tr>
692 <td class="db0">{image:db_field.gif|16|16}</td>
693 <td class="db1">XWV_CLASSNAME</td>
694 <td class="db2">VARCHAR(255)</td>
695 <td class="db3">{image:db_check.gif|16|16}</td>
696 <td class="db4">&nbsp;</td>
697 <td class="db5">&nbsp;</td>
698 <td class="db6">&nbsp;</td>
699 <td class="db7">&nbsp;</td>
700 </tr>
701 <tr>
702 <td class="db0">{image:db_field.gif|16|16}</td>
703 <td class="db1">XWV_IP</td>
704 <td class="db2">VARCHAR(32)</td>
705 <td class="db3">{image:db_check.gif|16|16}</td>
706 <td class="db4">&nbsp;</td>
707 <td class="db5">&nbsp;</td>
708 <td class="db6">&nbsp;</td>
709 <td class="db7">&nbsp;</td>
710 </tr>
711 <tr>
712 <td class="db0">{image:db_field.gif|16|16}</td>
713 <td class="db1">XWV_USER_AGENT</td>
714 <td class="db2">VARCHAR(255)</td>
715 <td class="db3">{image:db_check.gif|16|16}</td>
716 <td class="db4">&nbsp;</td>
717 <td class="db5">&nbsp;</td>
718 <td class="db6">&nbsp;</td>
719 <td class="db7">&nbsp;</td>
720 </tr>
721 <tr>
722 <td class="db0">{image:db_field.gif|16|16}</td>
723 <td class="db1">XWV_COOKIE</td>
724 <td class="db2">VARCHAR(255)</td>
725 <td class="db3">{image:db_check.gif|16|16}</td>
726 <td class="db4">&nbsp;</td>
727 <td class="db5">&nbsp;</td>
728 <td class="db6">&nbsp;</td>
729 <td class="db7">&nbsp;</td>
730 </tr>
731 <tr>
732 <td class="db0">{image:db_field.gif|16|16}</td>
733 <td class="db1">XWV_UNIQUE_ID</td>
734 <td class="db2">VARCHAR(255)</td>
735 <td class="db3">{image:db_check.gif|16|16}</td>
736 <td class="db4">&nbsp;</td>
737 <td class="db5">&nbsp;</td>
738 <td class="db6">&nbsp;</td>
739 <td class="db7">&nbsp;</td>
740 </tr>
741 <tr>
742 <td class="db0">{image:db_field.gif|16|16}</td>
743 <td class="db1">XWV_PAGE_VIEWS</td>
744 <td class="db2">INTEGER</td>
745 <td class="db3">&nbsp;</td>
746 <td class="db4">&nbsp;</td>
747 <td class="db5">&nbsp;</td>
748 <td class="db6">null</td>
749 <td class="db7">&nbsp;</td>
750 </tr>
751 <tr>
752 <td class="db0">{image:db_field.gif|16|16}</td>
753 <td class="db1">XWV_SAVES</td>
754 <td class="db2">INTEGER</td>
755 <td class="db3">&nbsp;</td>
756 <td class="db4">&nbsp;</td>
757 <td class="db5">&nbsp;</td>
758 <td class="db6">null</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">XWV_DOWNLOADS</td>
764 <td class="db2">INTEGER</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 <tr>
772 <td class="db0">{image:db_field.gif|16|16}</td>
773 <td class="db1">XWV_START_DATE</td>
774 <td class="db2">DATETIME</td>
775 <td class="db3">&nbsp;</td>
776 <td class="db4">&nbsp;</td>
777 <td class="db5">&nbsp;</td>
778 <td class="db6">null</td>
779 <td class="db7">&nbsp;</td>
780 </tr>
781 <tr>
782 <td class="db0">{image:db_field.gif|16|16}</td>
783 <td class="db1">XWV_END_DATE</td>
784 <td class="db2">DATETIME</td>
785 <td class="db3">&nbsp;</td>
786 <td class="db4">&nbsp;</td>
787 <td class="db5">&nbsp;</td>
788 <td class="db6">null</td>
789 <td class="db7">&nbsp;</td>
790 </tr>
791 </table>
792
793 [^ back to top ^>#Tables]
794 1.1.1 XWiki List Classes
795
796 This table contains the declaration of the list properties in XWiki classes.
797
798 <table border="0" width="100%" class="dbtable" cellpadding="3"
799 cellspacing="0">
800 <tr>
801 <td colspan="8" class="dbhead">xwikislistclasses</td>
802 </tr>
803 <tr>
804 <th class="db0">&nbsp;</th>
805 <th class="db1">Column Name</th>
806 <th class="db2">Datatype</th>
807 <th class="db3">Not null</th>
808 <th class="db4">auto inc</th>
809 <th class="db5">flags</th>
810 <th class="db6">Default Value</th>
811 <th class="db7">Comments</th>
812 </tr>
813 <tr>
814 <td class="db0">{image:db_key.gif|16|16}</td>
815 <td class="db1">XWL_ID</td>
816 <td class="db2">INTEGER</td>
817 <td class="db3">{image:db_check.gif|16|16}</td>
818 <td class="db4">&nbsp;</td>
819 <td class="db5">&nbsp;</td>
820 <td class="db6">0</td>
821 <td class="db7">&nbsp;</td>
822 </tr>
823 <tr>
824 <td class="db0">{image:db_key.gif|16|16}</td>
825 <td class="db1">XWL_NAME</td>
826 <td class="db2">VARCHAR(255)</td>
827 <td class="db3">{image:db_check.gif|16|16}</td>
828 <td class="db4">&nbsp;</td>
829 <td class="db5">&nbsp;</td>
830 <td class="db6">&nbsp;</td>
831 <td class="db7">&nbsp;</td>
832 </tr>
833 <tr>
834 <td class="db0">{image:db_field.gif|16|16}</td>
835 <td class="db1">XWL_DISPLAYTYPE</td>
836 <td class="db2">VARCHAR(20)</td>
837 <td class="db3">&nbsp;</td>
838 <td class="db4">&nbsp;</td>
839 <td class="db5">&nbsp;</td>
840 <td class="db6">null</td>
841 <td class="db7">&nbsp;</td>
842 </tr>
843 <tr>
844 <td class="db0">{image:db_field.gif|16|16}</td>
845 <td class="db1">XWL_MULTISELECT</td>
846 <td class="db2">TINYINT(1)</td>
847 <td class="db3">&nbsp;</td>
848 <td class="db4">&nbsp;</td>
849 <td class="db5">&nbsp;</td>
850 <td class="db6">null</td>
851 <td class="db7">&nbsp;</td>
852 </tr>
853 <tr>
854 <td class="db0">{image:db_field.gif|16|16}</td>
855 <td class="db1">XWL_SIZE</td>
856 <td class="db2">INTEGER</td>
857 <td class="db3">&nbsp;</td>
858 <td class="db4">&nbsp;</td>
859 <td class="db5">&nbsp;</td>
860 <td class="db6">null</td>
861 <td class="db7">&nbsp;</td>
862 </tr>
863 <tr>
864 <td class="db0">{image:db_field.gif|16|16}</td>
865 <td class="db1">XWL_RELATIONAL</td>
866 <td class="db2">TINYINT(1)</td>
867 <td class="db3">&nbsp;</td>
868 <td class="db4">&nbsp;</td>
869 <td class="db5">&nbsp;</td>
870 <td class="db6">null</td>
871 <td class="db7">&nbsp;</td>
872 </tr>
873 <tr>
874 <td class="db0">{image:db_field.gif|16|16}</td>
875 <td class="db1">XWL_VALUES</td>
876 <td class="db2">TEXT</td>
877 <td class="db3">&nbsp;</td>
878 <td class="db4">&nbsp;</td>
879 <td class="db5">&nbsp;</td>
880 <td class="db6">null</td>
881 <td class="db7">&nbsp;</td>
882 </tr>
883 </table>
884
885 [^ back to top ^>#Tables]
886 $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