Skip to Content

Wiki source code of DatabaseSchema

Version 54.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>#XWiki+Classes]
22 * [xwikiclassesprop>#XWiki+Properties+Classes]
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 XWiki Properties Classes
59
60 This table contains the list of properties in XWiki Classes. Each property has an entry in the type specific table.
61
62 <table border="0" width="100%" class="dbtable" cellpadding="3"
63 cellspacing="0">
64 <tr>
65 <td colspan="8" class="dbhead">xwikiclassesprop</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">XWP_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">XWP_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">XWP_PRETTYNAME</td>
100 <td class="db2">VARCHAR(255)</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">XWP_CLASSTYPE</td>
110 <td class="db2">VARCHAR(255)</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 <tr>
118 <td class="db0">{image:db_field.gif|16|16}</td>
119 <td class="db1">XWP_UNMODIFIABLE</td>
120 <td class="db2">TINYINT(1)</td>
121 <td class="db3">&nbsp;</td>
122 <td class="db4">&nbsp;</td>
123 <td class="db5">&nbsp;</td>
124 <td class="db6">null</td>
125 <td class="db7">&nbsp;</td>
126 </tr>
127 <tr>
128 <td class="db0">{image:db_field.gif|16|16}</td>
129 <td class="db1">XWP_NUMBER</td>
130 <td class="db2">INTEGER</td>
131 <td class="db3">&nbsp;</td>
132 <td class="db4">&nbsp;</td>
133 <td class="db5">&nbsp;</td>
134 <td class="db6">null</td>
135 <td class="db7">&nbsp;</td>
136 </tr>
137 </table>
138
139 [^ back to top ^>#Tables]
140
141 1.1.1 XWiki String Classes
142
143 This table contains the declaration of the strings properties in XWiki classes.
144
145 <table border="0" width="100%" class="dbtable" cellpadding="3"
146 cellspacing="0">
147 <tr>
148 <td colspan="8" class="dbhead">xwikistringclasses</td>
149 </tr>
150 <tr>
151 <th class="db0">&nbsp;</th>
152 <th class="db1">Column Name</th>
153 <th class="db2">Datatype</th>
154 <th class="db3">Not null</th>
155 <th class="db4">auto inc</th>
156 <th class="db5">flags</th>
157 <th class="db6">Default Value</th>
158 <th class="db7">Comments</th>
159 </tr>
160 <tr>
161 <td class="db0">{image:db_key.gif|16|16}</td>
162 <td class="db1">XWS_ID</td>
163 <td class="db2">INTEGER</td>
164 <td class="db3">{image:db_check.gif|16|16}</td>
165 <td class="db4">&nbsp;</td>
166 <td class="db5">&nbsp;</td>
167 <td class="db6">0</td>
168 <td class="db7">&nbsp;</td>
169 </tr>
170 <tr>
171 <td class="db0">{image:db_key.gif|16|16}</td>
172 <td class="db1">XWS_NAME</td>
173 <td class="db2">VARCHAR(255)</td>
174 <td class="db3">{image:db_check.gif|16|16}</td>
175 <td class="db4">&nbsp;</td>
176 <td class="db5">&nbsp;</td>
177 <td class="db6">&nbsp;</td>
178 <td class="db7">&nbsp;</td>
179 </tr>
180 <tr>
181 <td class="db0">{image:db_field.gif|16|16}</td>
182 <td class="db1">XWS_SIZE</td>
183 <td class="db2">INTEGER</td>
184 <td class="db3">&nbsp;</td>
185 <td class="db4">&nbsp;</td>
186 <td class="db5">&nbsp;</td>
187 <td class="db6">null</td>
188 <td class="db7">&nbsp;</td>
189 </tr>
190 <tr>
191 <td class="db0">{image:db_field.gif|16|16}</td>
192 <td class="db1">XWS_ROWS</td>
193 <td class="db2">INTEGER</td>
194 <td class="db3">&nbsp;</td>
195 <td class="db4">&nbsp;</td>
196 <td class="db5">&nbsp;</td>
197 <td class="db6">null</td>
198 <td class="db7">&nbsp;</td>
199 </tr>
200 </table>
201
202 [^ back to top ^>#Tables]
203
204 1.1.1 XWiki Boolean Classes
205
206 This table contains the declaration of the boolean properties in XWiki classes.
207
208 <table border="0" width="100%" class="dbtable" cellpadding="3"
209 cellspacing="0">
210 <tr>
211 <td colspan="8" class="dbhead">xwikibooleanclasses</td>
212 </tr>
213 <tr>
214 <th class="db0">&nbsp;</th>
215 <th class="db1">Column Name</th>
216 <th class="db2">Datatype</th>
217 <th class="db3">Not null</th>
218 <th class="db4">auto inc</th>
219 <th class="db5">flags</th>
220 <th class="db6">Default Value</th>
221 <th class="db7">Comments</th>
222 </tr>
223 <tr>
224 <td class="db0">{image:db_key.gif|16|16}</td>
225 <td class="db1">XWN_ID</td>
226 <td class="db2">INTEGER</td>
227 <td class="db3">{image:db_check.gif|16|16}</td>
228 <td class="db4">&nbsp;</td>
229 <td class="db5">&nbsp;</td>
230 <td class="db6">0</td>
231 <td class="db7">&nbsp;</td>
232 </tr>
233 <tr>
234 <td class="db0">{image:db_key.gif|16|16}</td>
235 <td class="db1">XWN_NAME</td>
236 <td class="db2">VARCHAR(255)</td>
237 <td class="db3">{image:db_check.gif|16|16}</td>
238 <td class="db4">&nbsp;</td>
239 <td class="db5">&nbsp;</td>
240 <td class="db6">&nbsp;</td>
241 <td class="db7">&nbsp;</td>
242 </tr>
243 <tr>
244 <td class="db0">{image:db_field.gif|16|16}</td>
245 <td class="db1">XWN_DISPLAYTYPE</td>
246 <td class="db2">VARCHAR(20)</td>
247 <td class="db3">&nbsp;</td>
248 <td class="db4">&nbsp;</td>
249 <td class="db5">&nbsp;</td>
250 <td class="db6">null</td>
251 <td class="db7"></td>
252 </tr>
253 </table>
254
255 The field name prefix is this table is wrong. It should be corrected in xwiki.hbm.xml.
256
257 [^ back to top ^>#Tables]
258
259 1.1.1 XWiki Date Classes
260
261 This table contains the declaration of the date properties in XWiki classes.
262
263 <table border="0" width="100%" class="dbtable" cellpadding="3"
264 cellspacing="0">
265 <tr>
266 <td colspan="8" class="dbhead">xwikidateclasses</td>
267 </tr>
268 <tr>
269 <th class="db0">&nbsp;</th>
270 <th class="db1">Column Name</th>
271 <th class="db2">Datatype</th>
272 <th class="db3">Not null</th>
273 <th class="db4">auto inc</th>
274 <th class="db5">flags</th>
275 <th class="db6">Default Value</th>
276 <th class="db7">Comments</th>
277 </tr>
278 <tr>
279 <td class="db0">{image:db_key.gif|16|16}</td>
280 <td class="db1">XWS_ID</td>
281 <td class="db2">INTEGER</td>
282 <td class="db3">{image:db_check.gif|16|16}</td>
283 <td class="db4">&nbsp;</td>
284 <td class="db5">&nbsp;</td>
285 <td class="db6">0</td>
286 <td class="db7">&nbsp;</td>
287 </tr>
288 <tr>
289 <td class="db0">{image:db_key.gif|16|16}</td>
290 <td class="db1">XWS_NAME</td>
291 <td class="db2">VARCHAR(255)</td>
292 <td class="db3">{image:db_check.gif|16|16}</td>
293 <td class="db4">&nbsp;</td>
294 <td class="db5">&nbsp;</td>
295 <td class="db6">&nbsp;</td>
296 <td class="db7">&nbsp;</td>
297 </tr>
298 <tr>
299 <td class="db0">{image:db_field.gif|16|16}</td>
300 <td class="db1">XWS_SIZE</td>
301 <td class="db2">INTEGER</td>
302 <td class="db3">&nbsp;</td>
303 <td class="db4">&nbsp;</td>
304 <td class="db5">&nbsp;</td>
305 <td class="db6">null</td>
306 <td class="db7">&nbsp;</td>
307 </tr>
308 <tr>
309 <td class="db0">{image:db_field.gif|16|16}</td>
310 <td class="db1">XWS_EMPTY_IS_TODAY</td>
311 <td class="db2">INTEGER</td>
312 <td class="db3">&nbsp;</td>
313 <td class="db4">&nbsp;</td>
314 <td class="db5">&nbsp;</td>
315 <td class="db6">null</td>
316 <td class="db7">&nbsp;</td>
317 </tr>
318 <tr>
319 <td class="db0">{image:db_field.gif|16|16}</td>
320 <td class="db1">XWS_DATE_FORMAT</td>
321 <td class="db2">VARCHAR(255)</td>
322 <td class="db3">&nbsp;</td>
323 <td class="db4">&nbsp;</td>
324 <td class="db5">&nbsp;</td>
325 <td class="db6">null</td>
326 <td class="db7">&nbsp;</td>
327 </tr>
328 </table>
329
330 The field name prefix is this table is wrong. It should be corrected in xwiki.hbm.xml.
331
332 [^ back to top ^>#Tables]
333
334 1.1.1 XWiki Number Classes
335
336 This table contains the declaration of the number (long, integer, double, float) properties in XWiki classes.
337
338 <table border="0" width="100%" class="dbtable" cellpadding="3"
339 cellspacing="0">
340 <tr>
341 <td colspan="8" class="dbhead">xwikinumberclasses</td>
342 </tr>
343 <tr>
344 <th class="db0">&nbsp;</th>
345 <th class="db1">Column Name</th>
346 <th class="db2">Datatype</th>
347 <th class="db3">Not null</th>
348 <th class="db4">auto inc</th>
349 <th class="db5">flags</th>
350 <th class="db6">Default Value</th>
351 <th class="db7">Comments</th>
352 </tr>
353 <tr>
354 <td class="db0">{image:db_key.gif|16|16}</td>
355 <td class="db1">XWN_ID</td>
356 <td class="db2">INTEGER</td>
357 <td class="db3">{image:db_check.gif|16|16}</td>
358 <td class="db4">&nbsp;</td>
359 <td class="db5">&nbsp;</td>
360 <td class="db6">0</td>
361 <td class="db7">&nbsp;</td>
362 </tr>
363 <tr>
364 <td class="db0">{image:db_key.gif|16|16}</td>
365 <td class="db1">XWN_NAME</td>
366 <td class="db2">VARCHAR(255)</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">null&nbsp;</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">XWN_SIZE</td>
376 <td class="db2">INTEGER</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">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">XWN_NUMBERTYPE</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 </table>
394
395 [^ back to top ^>#Tables]
396
397 1.1.1 XWiki List Classes
398
399 This table contains the declaration of the list properties in XWiki classes.
400
401 <table border="0" width="100%" class="dbtable" cellpadding="3"
402 cellspacing="0">
403 <tr>
404 <td colspan="8" class="dbhead">xwikislistclasses</td>
405 </tr>
406 <tr>
407 <th class="db0">&nbsp;</th>
408 <th class="db1">Column Name</th>
409 <th class="db2">Datatype</th>
410 <th class="db3">Not null</th>
411 <th class="db4">auto inc</th>
412 <th class="db5">flags</th>
413 <th class="db6">Default Value</th>
414 <th class="db7">Comments</th>
415 </tr>
416 <tr>
417 <td class="db0">{image:db_key.gif|16|16}</td>
418 <td class="db1">XWL_ID</td>
419 <td class="db2">INTEGER</td>
420 <td class="db3">{image:db_check.gif|16|16}</td>
421 <td class="db4">&nbsp;</td>
422 <td class="db5">&nbsp;</td>
423 <td class="db6">0</td>
424 <td class="db7">&nbsp;</td>
425 </tr>
426 <tr>
427 <td class="db0">{image:db_key.gif|16|16}</td>
428 <td class="db1">XWL_NAME</td>
429 <td class="db2">VARCHAR(255)</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">&nbsp;</td>
434 <td class="db7">&nbsp;</td>
435 </tr>
436 <tr>
437 <td class="db0">{image:db_field.gif|16|16}</td>
438 <td class="db1">XWL_DISPLAYTYPE</td>
439 <td class="db2">VARCHAR(20)</td>
440 <td class="db3">&nbsp;</td>
441 <td class="db4">&nbsp;</td>
442 <td class="db5">&nbsp;</td>
443 <td class="db6">null</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_MULTISELECT</td>
449 <td class="db2">TINYINT(1)</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_SIZE</td>
459 <td class="db2">INTEGER</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_RELATIONAL</td>
469 <td class="db2">TINYINT(1)</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_VALUES</td>
479 <td class="db2">TEXT</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 </table>
487
488 [^ back to top ^>#Tables]
489
490 1.1.1 XWiki Database List Classes
491
492 This table contains the declaration of the database list properties in XWiki classes.
493
494 <table border="0" width="100%" class="dbtable" cellpadding="3"
495 cellspacing="0">
496 <tr>
497 <td colspan="8" class="dbhead">xwikidblistclasses</td>
498 </tr>
499 <tr>
500 <th class="db0">&nbsp;</th>
501 <th class="db1">Column Name</th>
502 <th class="db2">Datatype</th>
503 <th class="db3">Not null</th>
504 <th class="db4">auto inc</th>
505 <th class="db5">flags</th>
506 <th class="db6">Default Value</th>
507 <th class="db7">Comments</th>
508 </tr>
509 <tr>
510 <td class="db0">{image:db_key.gif|16|16}</td>
511 <td class="db1">XWL_ID</td>
512 <td class="db2">INTEGER</td>
513 <td class="db3">{image:db_check.gif|16|16}</td>
514 <td class="db4">&nbsp;</td>
515 <td class="db5">&nbsp;</td>
516 <td class="db6">0</td>
517 <td class="db7">&nbsp;</td>
518 </tr>
519 <tr>
520 <td class="db0">{image:db_key.gif|16|16}</td>
521 <td class="db1">XWL_NAME</td>
522 <td class="db2">VARCHAR(255)</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">&nbsp;</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">XWL_DISPLAYTYPE</td>
532 <td class="db2">VARCHAR(20)</td>
533 <td class="db3">&nbsp;</td>
534 <td class="db4">&nbsp;</td>
535 <td class="db5">&nbsp;</td>
536 <td class="db6">null</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">XWL_MULTISELECT</td>
542 <td class="db2">TINYINT(1)</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 <tr>
550 <td class="db0">{image:db_field.gif|16|16}</td>
551 <td class="db1">XWL_SIZE</td>
552 <td class="db2">INTEGER</td>
553 <td class="db3">&nbsp;</td>
554 <td class="db4">&nbsp;</td>
555 <td class="db5">&nbsp;</td>
556 <td class="db6">null</td>
557 <td class="db7">&nbsp;</td>
558 </tr>
559 <tr>
560 <td class="db0">{image:db_field.gif|16|16}</td>
561 <td class="db1">XWL_RELATIONAL</td>
562 <td class="db2">TINYINT(1)</td>
563 <td class="db3">&nbsp;</td>
564 <td class="db4">&nbsp;</td>
565 <td class="db5">&nbsp;</td>
566 <td class="db6">null</td>
567 <td class="db7">&nbsp;</td>
568 </tr>
569 <tr>
570 <td class="db0">{image:db_field.gif|16|16}</td>
571 <td class="db1">XWL_SQL</td>
572 <td class="db2">TEXT</td>
573 <td class="db3">&nbsp;</td>
574 <td class="db4">&nbsp;</td>
575 <td class="db5">&nbsp;</td>
576 <td class="db6">null</td>
577 <td class="db7">&nbsp;</td>
578 </tr>
579 </table>
580
581 [^ back to top ^>#Tables]
582
583 1.1 XWiki Objects
584
585 This table contains the list of XWiki Objects. Objects can have properties, as declared by their class.
586
587 <table border="0" width="100%" class="dbtable" cellpadding="3"
588 cellspacing="0">
589 <tr>
590 <td colspan="8" class="dbhead">xwikiobjects</td>
591 </tr>
592 <tr>
593 <th class="db0">&nbsp;</th>
594 <th class="db1">Column Name</th>
595 <th class="db2">Datatype</th>
596 <th class="db3">Not null</th>
597 <th class="db4">auto inc</th>
598 <th class="db5">flags</th>
599 <th class="db6">Default Value</th>
600 <th class="db7">Comments</th>
601 </tr>
602 <tr>
603 <td class="db0">{image:db_key.gif|16|16}</td>
604 <td class="db1">XWO_ID</td>
605 <td class="db2">INTEGER</td>
606 <td class="db3">{image:db_check.gif|16|16}</td>
607 <td class="db4">&nbsp;</td>
608 <td class="db5">&nbsp;</td>
609 <td class="db6">0</td>
610 <td class="db7">&nbsp;</td>
611 </tr>
612 <tr>
613 <td class="db0">{image:db_field.gif|16|16}</td>
614 <td class="db1">XWO_NUMBER</td>
615 <td class="db2">INTEGER</td>
616 <td class="db3">&nbsp;</td>
617 <td class="db4">&nbsp;</td>
618 <td class="db5">&nbsp;</td>
619 <td class="db6">null&nbsp;</td>
620 <td class="db7">&nbsp;</td>
621 </tr>
622 <tr>
623 <td class="db0">{image:db_field.gif|16|16}</td>
624 <td class="db1">XWO_NAME</td>
625 <td class="db2">VARCHAR(255)</td>
626 <td class="db3">{image:db_check.gif|16|16}</td>
627 <td class="db4">&nbsp;</td>
628 <td class="db5">&nbsp;</td>
629 <td class="db6">null</td>
630 <td class="db7">&nbsp;</td>
631 </tr>
632 <tr>
633 <td class="db0">{image:db_field.gif|16|16}</td>
634 <td class="db1">XWO_CLASSNAME</td>
635 <td class="db2">VARCHAR(255)</td>
636 <td class="db3">{image:db_check.gif|16|16}</td>
637 <td class="db4">&nbsp;</td>
638 <td class="db5">&nbsp;</td>
639 <td class="db6">&nbsp;</td>
640 <td class="db7">&nbsp;</td>
641 </tr>
642 </table>
643
644 [^ back to top ^>#Tables]
645
646 1.1 XWiki Properties
647
648 This table contains the list of properties in XWiki Objects. Each property has an entry in the type specific table.
649
650 <table border="0" width="100%" class="dbtable" cellpadding="3"
651 cellspacing="0">
652 <tr>
653 <td colspan="8" class="dbhead">xwikiproperties</td>
654 </tr>
655 <tr>
656 <th class="db0">&nbsp;</th>
657 <th class="db1">Column Name</th>
658 <th class="db2">Datatype</th>
659 <th class="db3">Not null</th>
660 <th class="db4">auto inc</th>
661 <th class="db5">flags</th>
662 <th class="db6">Default Value</th>
663 <th class="db7">Comments</th>
664 </tr>
665 <tr>
666 <td class="db0">{image:db_key.gif|16|16}</td>
667 <td class="db1">XWP_ID</td>
668 <td class="db2">INTEGER</td>
669 <td class="db3">{image:db_check.gif|16|16}</td>
670 <td class="db4">&nbsp;</td>
671 <td class="db5">&nbsp;</td>
672 <td class="db6">0</td>
673 <td class="db7">&nbsp;</td>
674 </tr>
675 <tr>
676 <td class="db0">{image:db_key.gif|16|16}</td>
677 <td class="db1">XWP_NAME</td>
678 <td class="db2">VARCHAR(255)</td>
679 <td class="db3">{image:db_check.gif|16|16}</td>
680 <td class="db4">&nbsp;</td>
681 <td class="db5">&nbsp;</td>
682 <td class="db6">&nbsp;</td>
683 <td class="db7">&nbsp;</td>
684 </tr>
685 <tr>
686 <td class="db0">{image:db_field.gif|16|16}</td>
687 <td class="db1">XWP_CLASSTYPE</td>
688 <td class="db2">VARCHAR(255)</td>
689 <td class="db3">&nbsp;</td>
690 <td class="db4">&nbsp;</td>
691 <td class="db5">&nbsp;</td>
692 <td class="db6">null</td>
693 <td class="db7">&nbsp;</td>
694 </tr>
695 </table>
696
697 [^ back to top ^>#Tables]
698
699 1.1.1 XWiki Strings
700
701 This table contains the string data from XWiki Objects.
702
703 <table border="0" width="100%" class="dbtable" cellpadding="3"
704 cellspacing="0">
705 <tr>
706 <td colspan="8" class="dbhead">xwikistrings</td>
707 </tr>
708 <tr>
709 <th class="db0">&nbsp;</th>
710 <th class="db1">Column Name</th>
711 <th class="db2">Datatype</th>
712 <th class="db3">Not null</th>
713 <th class="db4">auto inc</th>
714 <th class="db5">flags</th>
715 <th class="db6">Default Value</th>
716 <th class="db7">Comments</th>
717 </tr>
718 <tr>
719 <td class="db0">{image:db_key.gif|16|16}</td>
720 <td class="db1">XWS_ID</td>
721 <td class="db2">INTEGER</td>
722 <td class="db3">{image:db_check.gif|16|16}</td>
723 <td class="db4">&nbsp;</td>
724 <td class="db5">&nbsp;</td>
725 <td class="db6">0</td>
726 <td class="db7">&nbsp;</td>
727 </tr>
728 <tr>
729 <td class="db0">{image:db_key.gif|16|16}</td>
730 <td class="db1">XWS_NAME</td>
731 <td class="db2">VARCHAR(255)</td>
732 <td class="db3">{image:db_check.gif|16|16}</td>
733 <td class="db4">&nbsp;</td>
734 <td class="db5">&nbsp;</td>
735 <td class="db6">&nbsp;</td>
736 <td class="db7">&nbsp;</td>
737 </tr>
738 <tr>
739 <td class="db0">{image:db_field.gif|16|16}</td>
740 <td class="db1">XWS_VALUE</td>
741 <td class="db2">VARCHAR(255)</td>
742 <td class="db3">&nbsp;</td>
743 <td class="db4">&nbsp;</td>
744 <td class="db5">&nbsp;</td>
745 <td class="db6">null</td>
746 <td class="db7">&nbsp;</td>
747 </tr>
748 </table>
749
750 [^ back to top ^>#Tables]
751
752 1.1.1 XWiki Large Strings
753
754 This table contain the data for textarea properties in XWiki Objects.
755
756 <table border="0" width="100%" class="dbtable" cellpadding="3"
757 cellspacing="0">
758 <tr>
759 <td colspan="8" class="dbhead">xwikilargestrings</td>
760 </tr>
761 <tr>
762 <th class="db0">&nbsp;</th>
763 <th class="db1">Column Name</th>
764 <th class="db2">Datatype</th>
765 <th class="db3">Not null</th>
766 <th class="db4">auto inc</th>
767 <th class="db5">flags</th>
768 <th class="db6">Default Value</th>
769 <th class="db7">Comments</th>
770 </tr>
771 <tr>
772 <td class="db0">{image:db_key.gif|16|16}</td>
773 <td class="db1">XWL_ID</td>
774 <td class="db2">INTEGER</td>
775 <td class="db3">{image:db_check.gif|16|16}</td>
776 <td class="db4">&nbsp;</td>
777 <td class="db5">&nbsp;</td>
778 <td class="db6">0</td>
779 <td class="db7">&nbsp;</td>
780 </tr>
781 <tr>
782 <td class="db0">{image:db_key.gif|16|16}</td>
783 <td class="db1">XWL_NAME</td>
784 <td class="db2">VARCHAR(255)</td>
785 <td class="db3">{image:db_check.gif|16|16}</td>
786 <td class="db4">&nbsp;</td>
787 <td class="db5">&nbsp;</td>
788 <td class="db6">&nbsp;</td>
789 <td class="db7">&nbsp;</td>
790 </tr>
791 <tr>
792 <td class="db0">{image:db_field.gif|16|16}</td>
793 <td class="db1">XWL_VALUE</td>
794 <td class="db2">TEXT</td>
795 <td class="db3">&nbsp;</td>
796 <td class="db4">&nbsp;</td>
797 <td class="db5">&nbsp;</td>
798 <td class="db6">null</td>
799 <td class="db7">&nbsp;</td>
800 </tr>
801 </table>
802
803 [^ back to top ^>#Tables]
804
805 1.1.1 XWiki Dates
806
807 This table contains the data of date properties in XWiki objects.
808
809 <table border="0" width="100%" class="dbtable" cellpadding="3"
810 cellspacing="0">
811 <tr>
812 <td colspan="8" class="dbhead">xwikidates</td>
813 </tr>
814 <tr>
815 <th class="db0">&nbsp;</th>
816 <th class="db1">Column Name</th>
817 <th class="db2">Datatype</th>
818 <th class="db3">Not null</th>
819 <th class="db4">auto inc</th>
820 <th class="db5">flags</th>
821 <th class="db6">Default Value</th>
822 <th class="db7">Comments</th>
823 </tr>
824 <tr>
825 <td class="db0">{image:db_key.gif|16|16}</td>
826 <td class="db1">XWS_ID</td>
827 <td class="db2">INTEGER</td>
828 <td class="db3">{image:db_check.gif|16|16}</td>
829 <td class="db4">&nbsp;</td>
830 <td class="db5">&nbsp;</td>
831 <td class="db6">0</td>
832 <td class="db7">&nbsp;</td>
833 </tr>
834 <tr>
835 <td class="db0">{image:db_key.gif|16|16}</td>
836 <td class="db1">XWS_NAME</td>
837 <td class="db2">VARCHAR(255)</td>
838 <td class="db3">{image:db_check.gif|16|16}</td>
839 <td class="db4">&nbsp;</td>
840 <td class="db5">&nbsp;</td>
841 <td class="db6">&nbsp;</td>
842 <td class="db7">&nbsp;</td>
843 </tr>
844 <tr>
845 <td class="db0">{image:db_field.gif|16|16}</td>
846 <td class="db1">XWS_VALUE</td>
847 <td class="db2">DATETIME</td>
848 <td class="db3">&nbsp;</td>
849 <td class="db4">&nbsp;</td>
850 <td class="db5">&nbsp;</td>
851 <td class="db6">null</td>
852 <td class="db7">&nbsp;</td>
853 </tr>
854 </table>
855
856 The field name prefix is this table is wrong. It should be corrected in xwiki.hbm.xml.
857
858 [^ back to top ^>#Tables]
859
860 1.1.1 XWiki Doubles
861
862 This table contain the data for double properties in XWiki Objects.
863
864 <table border="0" width="100%" class="dbtable" cellpadding="3"
865 cellspacing="0">
866 <tr>
867 <td colspan="8" class="dbhead">xwikidoubles</td>
868 </tr>
869 <tr>
870 <th class="db0">&nbsp;</th>
871 <th class="db1">Column Name</th>
872 <th class="db2">Datatype</th>
873 <th class="db3">Not null</th>
874 <th class="db4">auto inc</th>
875 <th class="db5">flags</th>
876 <th class="db6">Default Value</th>
877 <th class="db7">Comments</th>
878 </tr>
879 <tr>
880 <td class="db0">{image:db_key.gif|16|16}</td>
881 <td class="db1">XWD_ID</td>
882 <td class="db2">INTEGER</td>
883 <td class="db3">{image:db_check.gif|16|16}</td>
884 <td class="db4">&nbsp;</td>
885 <td class="db5">&nbsp;</td>
886 <td class="db6">0</td>
887 <td class="db7">&nbsp;</td>
888 </tr>
889 <tr>
890 <td class="db0">{image:db_key.gif|16|16}</td>
891 <td class="db1">XWD_NAME</td>
892 <td class="db2">VARCHAR(255)</td>
893 <td class="db3">{image:db_check.gif|16|16}</td>
894 <td class="db4">&nbsp;</td>
895 <td class="db5">&nbsp;</td>
896 <td class="db6">&nbsp;</td>
897 <td class="db7">&nbsp;</td>
898 </tr>
899 <tr>
900 <td class="db0">{image:db_field.gif|16|16}</td>
901 <td class="db1">XWD_VALUE</td>
902 <td class="db2">DOUBLE</td>
903 <td class="db3">&nbsp;</td>
904 <td class="db4">&nbsp;</td>
905 <td class="db5">&nbsp;</td>
906 <td class="db6">null</td>
907 <td class="db7">&nbsp;</td>
908 </tr>
909 </table>
910
911 [^ back to top ^>#Tables]
912
913 1.1.1 XWiki Floats
914
915 This table contain the data for floats properties in XWiki Objects.
916
917
918 <table border="0" width="100%" class="dbtable" cellpadding="3"
919 cellspacing="0">
920 <tr>
921 <td colspan="8" class="dbhead">xwikifloats</td>
922 </tr>
923 <tr>
924 <th class="db0">&nbsp;</th>
925 <th class="db1">Column Name</th>
926 <th class="db2">Datatype</th>
927 <th class="db3">Not null</th>
928 <th class="db4">auto inc</th>
929 <th class="db5">flags</th>
930 <th class="db6">Default Value</th>
931 <th class="db7">Comments</th>
932 </tr>
933 <tr>
934 <td class="db0">{image:db_key.gif|16|16}</td>
935 <td class="db1">XWF_ID</td>
936 <td class="db2">INTEGER</td>
937 <td class="db3">{image:db_check.gif|16|16}</td>
938 <td class="db4">&nbsp;</td>
939 <td class="db5">&nbsp;</td>
940 <td class="db6">0</td>
941 <td class="db7">&nbsp;</td>
942 </tr>
943 <tr>
944 <td class="db0">{image:db_key.gif|16|16}</td>
945 <td class="db1">XWF_NAME</td>
946 <td class="db2">VARCHAR(255)</td>
947 <td class="db3">{image:db_check.gif|16|16}</td>
948 <td class="db4">&nbsp;</td>
949 <td class="db5">&nbsp;</td>
950 <td class="db6">&nbsp;</td>
951 <td class="db7">&nbsp;</td>
952 </tr>
953 <tr>
954 <td class="db0">{image:db_field.gif|16|16}</td>
955 <td class="db1">XWF_VALUE</td>
956 <td class="db2">FLOAT</td>
957 <td class="db3">&nbsp;</td>
958 <td class="db4">&nbsp;</td>
959 <td class="db5">&nbsp;</td>
960 <td class="db6">null</td>
961 <td class="db7">&nbsp;</td>
962 </tr>
963 </table>
964
965 [^ back to top ^>#Tables]
966
967 1.1.1 XWiki Integers
968
969 This table contain the data for integer properties in XWiki Objects.
970
971
972 <table border="0" width="100%" class="dbtable" cellpadding="3"
973 cellspacing="0">
974 <tr>
975 <td colspan="8" class="dbhead">xwikiintegers</td>
976 </tr>
977 <tr>
978 <th class="db0">&nbsp;</th>
979 <th class="db1">Column Name</th>
980 <th class="db2">Datatype</th>
981 <th class="db3">Not null</th>
982 <th class="db4">auto inc</th>
983 <th class="db5">flags</th>
984 <th class="db6">Default Value</th>
985 <th class="db7">Comments</th>
986 </tr>
987 <tr>
988 <td class="db0">{image:db_key.gif|16|16}</td>
989 <td class="db1">XWI_ID</td>
990 <td class="db2">INTEGER</td>
991 <td class="db3">{image:db_check.gif|16|16}</td>
992 <td class="db4">&nbsp;</td>
993 <td class="db5">&nbsp;</td>
994 <td class="db6">0</td>
995 <td class="db7">&nbsp;</td>
996 </tr>
997 <tr>
998 <td class="db0">{image:db_key.gif|16|16}</td>
999 <td class="db1">XWI_NAME</td>
1000 <td class="db2">VARCHAR(255)</td>
1001 <td class="db3">{image:db_check.gif|16|16}</td>
1002 <td class="db4">&nbsp;</td>
1003 <td class="db5">&nbsp;</td>
1004 <td class="db6">&nbsp;</td>
1005 <td class="db7">&nbsp;</td>
1006 </tr>
1007 <tr>
1008 <td class="db0">{image:db_field.gif|16|16}</td>
1009 <td class="db1">XWI_VALUE</td>
1010 <td class="db2">INTEGER</td>
1011 <td class="db3">&nbsp;</td>
1012 <td class="db4">&nbsp;</td>
1013 <td class="db5">&nbsp;</td>
1014 <td class="db6">null</td>
1015 <td class="db7">&nbsp;</td>
1016 </tr>
1017 </table>
1018
1019 [^ back to top ^>#Tables]
1020
1021 1.1.1 XWiki Longs
1022
1023 This table contain the data for long properties in XWiki Objects.
1024
1025 <table border="0" width="100%" class="dbtable" cellpadding="3"
1026 cellspacing="0">
1027 <tr>
1028 <td colspan="8" class="dbhead">xwikilongs</td>
1029 </tr>
1030 <tr>
1031 <th class="db0">&nbsp;</th>
1032 <th class="db1">Column Name</th>
1033 <th class="db2">Datatype</th>
1034 <th class="db3">Not null</th>
1035 <th class="db4">auto inc</th>
1036 <th class="db5">flags</th>
1037 <th class="db6">Default Value</th>
1038 <th class="db7">Comments</th>
1039 </tr>
1040 <tr>
1041 <td class="db0">{image:db_key.gif|16|16}</td>
1042 <td class="db1">XWL_ID</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 <tr>
1051 <td class="db0">{image:db_key.gif|16|16}</td>
1052 <td class="db1">XWL_NAME</td>
1053 <td class="db2">VARCHAR(255)</td>
1054 <td class="db3">{image:db_check.gif|16|16}</td>
1055 <td class="db4">&nbsp;</td>
1056 <td class="db5">&nbsp;</td>
1057 <td class="db6">&nbsp;</td>
1058 <td class="db7">&nbsp;</td>
1059 </tr>
1060 <tr>
1061 <td class="db0">{image:db_field.gif|16|16}</td>
1062 <td class="db1">XWL_VALUE</td>
1063 <td class="db2">BIGINT(20)</td>
1064 <td class="db3">&nbsp;</td>
1065 <td class="db4">&nbsp;</td>
1066 <td class="db5">&nbsp;</td>
1067 <td class="db6">null</td>
1068 <td class="db7">&nbsp;</td>
1069 </tr>
1070 </table>
1071
1072 [^ back to top ^>#Tables]
1073
1074 1.1.1 XWiki List Items
1075
1076 This table contain the data for lists properties in XWiki Objects.
1077
1078 <table border="0" width="100%" class="dbtable" cellpadding="3"
1079 cellspacing="0">
1080 <tr>
1081 <td colspan="8" class="dbhead">xwikilistitems</td>
1082 </tr>
1083 <tr>
1084 <th class="db0">&nbsp;</th>
1085 <th class="db1">Column Name</th>
1086 <th class="db2">Datatype</th>
1087 <th class="db3">Not null</th>
1088 <th class="db4">auto inc</th>
1089 <th class="db5">flags</th>
1090 <th class="db6">Default Value</th>
1091 <th class="db7">Comments</th>
1092 </tr>
1093 <tr>
1094 <td class="db0">{image:db_key.gif|16|16}</td>
1095 <td class="db1">XWL_ID</td>
1096 <td class="db2">INTEGER</td>
1097 <td class="db3">{image:db_check.gif|16|16}</td>
1098 <td class="db4">&nbsp;</td>
1099 <td class="db5">&nbsp;</td>
1100 <td class="db6">0</td>
1101 <td class="db7">&nbsp;</td>
1102 </tr>
1103 <tr>
1104 <td class="db0">{image:db_key.gif|16|16}</td>
1105 <td class="db1">XWL_NAME</td>
1106 <td class="db2">VARCHAR(255)</td>
1107 <td class="db3">{image:db_check.gif|16|16}</td>
1108 <td class="db4">&nbsp;</td>
1109 <td class="db5">&nbsp;</td>
1110 <td class="db6">&nbsp;</td>
1111 <td class="db7">&nbsp;</td>
1112 </tr>
1113 <tr>
1114 <td class="db0">{image:db_field.gif|16|16}</td>
1115 <td class="db1">XWL_VALUE</td>
1116 <td class="db2">VARCHAR(255)</td>
1117 <td class="db3">&nbsp;</td>
1118 <td class="db4">&nbsp;</td>
1119 <td class="db5">&nbsp;</td>
1120 <td class="db6">null</td>
1121 <td class="db7">&nbsp;</td>
1122 </tr>
1123 <tr>
1124 <td class="db0">{image:db_key.gif|16|16}</td>
1125 <td class="db1">XWL_NUMBER</td>
1126 <td class="db2">INTEGER</td>
1127 <td class="db3">{image:db_check.gif|16|16}</td>
1128 <td class="db4">&nbsp;</td>
1129 <td class="db5">&nbsp;</td>
1130 <td class="db6">0</td>
1131 <td class="db7">&nbsp;</td>
1132 </tr>
1133 </table>
1134
1135 [^ back to top ^>#Tables]
1136
1137 1.1.1 XWiki Lists
1138
1139 This table contain the data for lists properties in XWiki Objects.
1140
1141
1142 <table border="0" width="100%" class="dbtable" cellpadding="3"
1143 cellspacing="0">
1144 <tr>
1145 <td colspan="8" class="dbhead">xwikilists</td>
1146 </tr>
1147 <tr>
1148 <th class="db0">&nbsp;</th>
1149 <th class="db1">Column Name</th>
1150 <th class="db2">Datatype</th>
1151 <th class="db3">Not null</th>
1152 <th class="db4">auto inc</th>
1153 <th class="db5">flags</th>
1154 <th class="db6">Default Value</th>
1155 <th class="db7">Comments</th>
1156 </tr>
1157 <tr>
1158 <td class="db0">{image:db_key.gif|16|16}</td>
1159 <td class="db1">XWL_ID</td>
1160 <td class="db2">INTEGER</td>
1161 <td class="db3">{image:db_check.gif|16|16}</td>
1162 <td class="db4">&nbsp;</td>
1163 <td class="db5">&nbsp;</td>
1164 <td class="db6">0</td>
1165 <td class="db7">&nbsp;</td>
1166 </tr>
1167 <tr>
1168 <td class="db0">{image:db_key.gif|16|16}</td>
1169 <td class="db1">XWL_NAME</td>
1170 <td class="db2">VARCHAR(255)</td>
1171 <td class="db3">{image:db_check.gif|16|16}</td>
1172 <td class="db4">&nbsp;</td>
1173 <td class="db5">&nbsp;</td>
1174 <td class="db6">&nbsp;</td>
1175 <td class="db7">&nbsp;</td>
1176 </tr>
1177 </table>
1178
1179 [^ back to top ^>#Tables]
1180
1181 1.1 Statistics
1182
1183 1.1.1 XWiki Document Stats
1184
1185 This table contain stats information, namely page/space/wiki views and edits
1186 .
1187 <table border="0" width="100%" class="dbtable" cellpadding="3"
1188 cellspacing="0">
1189 <tr>
1190 <td colspan="8" class="dbhead">xwikistatsdoc</td>
1191 </tr>
1192 <tr>
1193 <th class="db0">&nbsp;</th>
1194 <th class="db1">Column Name</th>
1195 <th class="db2">Datatype</th>
1196 <th class="db3">Not null</th>
1197 <th class="db4">auto inc</th>
1198 <th class="db5">flags</th>
1199 <th class="db6">Default Value</th>
1200 <th class="db7">Comments</th>
1201 </tr>
1202 <tr>
1203 <td class="db0">{image:db_key.gif|16|16}</td>
1204 <td class="db1">XWS_ID</td>
1205 <td class="db2">INTEGER</td>
1206 <td class="db3">{image:db_check.gif|16|16}</td>
1207 <td class="db4">&nbsp;</td>
1208 <td class="db5">&nbsp;</td>
1209 <td class="db6">0</td>
1210 <td class="db7">&nbsp;</td>
1211 </tr>
1212 <tr>
1213 <td class="db0">{image:db_field.gif|16|16}</td>
1214 <td class="db1">XWS_NUMBER</td>
1215 <td class="db2">INTEGER</td>
1216 <td class="db3">&nbsp;</td>
1217 <td class="db4">&nbsp;</td>
1218 <td class="db5">&nbsp;</td>
1219 <td class="db6">null&nbsp;</td>
1220 <td class="db7">&nbsp;</td>
1221 </tr>
1222 <tr>
1223 <td class="db0">{image:db_field.gif|16|16}</td>
1224 <td class="db1">XWS_NAME</td>
1225 <td class="db2">VARCHAR(255)</td>
1226 <td class="db3">{image:db_check.gif|16|16}</td>
1227 <td class="db4">&nbsp;</td>
1228 <td class="db5">&nbsp;</td>
1229 <td class="db6">&nbsp;</td>
1230 <td class="db7">&nbsp;</td>
1231 </tr>
1232 <tr>
1233 <td class="db0">{image:db_field.gif|16|16}</td>
1234 <td class="db1">XWS_CLASSNAME</td>
1235 <td class="db2">VARCHAR(255)</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">&nbsp;</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">XWS_ACTION</td>
1245 <td class="db2">VARCHAR(255)</td>
1246 <td class="db3">{image:db_check.gif|16|16}</td>
1247 <td class="db4">&nbsp;</td>
1248 <td class="db5">&nbsp;</td>
1249 <td class="db6">&nbsp;</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">XWS_PAGE_VIEWS</td>
1255 <td class="db2">INTEGER</td>
1256 <td class="db3">&nbsp;</td>
1257 <td class="db4">&nbsp;</td>
1258 <td class="db5">&nbsp;</td>
1259 <td class="db6">null</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">XWS_UNIQUE_VISITORS</td>
1265 <td class="db2">INTEGER</td>
1266 <td class="db3">&nbsp;</td>
1267 <td class="db4">&nbsp;</td>
1268 <td class="db5">&nbsp;</td>
1269 <td class="db6">null</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">XWS_PERIOD</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</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">XWS_VISITS</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 </table>
1293
1294 [^ back to top ^>#Tables]
1295
1296 1.1.1 XWiki Referer Stats
1297
1298 This page contains the incoming externa links on the Wiki.
1299
1300 <table border="0" width="100%" class="dbtable" cellpadding="3"
1301 cellspacing="0">
1302 <tr>
1303 <td colspan="8" class="dbhead">xwikistatsreferer</td>
1304 </tr>
1305 <tr>
1306 <th class="db0">&nbsp;</th>
1307 <th class="db1">Column Name</th>
1308 <th class="db2">Datatype</th>
1309 <th class="db3">Not null</th>
1310 <th class="db4">auto inc</th>
1311 <th class="db5">flags</th>
1312 <th class="db6">Default Value</th>
1313 <th class="db7">Comments</th>
1314 </tr>
1315 <tr>
1316 <td class="db0">{image:db_key.gif|16|16}</td>
1317 <td class="db1">XWR_ID</td>
1318 <td class="db2">INTEGER</td>
1319 <td class="db3">{image:db_check.gif|16|16}</td>
1320 <td class="db4">&nbsp;</td>
1321 <td class="db5">&nbsp;</td>
1322 <td class="db6">0</td>
1323 <td class="db7">&nbsp;</td>
1324 </tr>
1325 <tr>
1326 <td class="db0">{image:db_field.gif|16|16}</td>
1327 <td class="db1">XWR_NUMBER</td>
1328 <td class="db2">INTEGER</td>
1329 <td class="db3">&nbsp;</td>
1330 <td class="db4">&nbsp;</td>
1331 <td class="db5">&nbsp;</td>
1332 <td class="db6">null</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">XWR_NAME</td>
1338 <td class="db2">VARCHAR(255)</td>
1339 <td class="db3">{image:db_check.gif|16|16}</td>
1340 <td class="db4">&nbsp;</td>
1341 <td class="db5">&nbsp;</td>
1342 <td class="db6">&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">XWR_CLASSNAME</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">XWR_REFERER</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">XWR_PAGE_VIEWS</td>
1368 <td class="db2">INTEGER</td>
1369 <td class="db3">&nbsp;</td>
1370 <td class="db4">&nbsp;</td>
1371 <td class="db5">&nbsp;</td>
1372 <td class="db6">null</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">XWR_PERIOD</td>
1378 <td class="db2">INTEGER</td>
1379 <td class="db3">&nbsp;</td>
1380 <td class="db4">&nbsp;</td>
1381 <td class="db5">&nbsp;</td>
1382 <td class="db6">null</td>
1383 <td class="db7">&nbsp;</td>
1384 </tr>
1385 </table>
1386
1387 [^ back to top ^>#Tables]
1388
1389 1.1.1 XWiki Visits
1390
1391 This table contains the sessions of the named users.
1392
1393 <table border="0" width="100%" class="dbtable" cellpadding="3"
1394 cellspacing="0">
1395 <tr>
1396 <td colspan="8" class="dbhead">xwikistatsvisit</td>
1397 </tr>
1398 <tr>
1399 <th class="db0">&nbsp;</th>
1400 <th class="db1">Column Name</th>
1401 <th class="db2">Datatype</th>
1402 <th class="db3">Not null</th>
1403 <th class="db4">auto inc</th>
1404 <th class="db5">flags</th>
1405 <th class="db6">Default Value</th>
1406 <th class="db7">Comments</th>
1407 </tr>
1408 <tr>
1409 <td class="db0">{image:db_key.gif|16|16}</td>
1410 <td class="db1">XWV_ID</td>
1411 <td class="db2">INTEGER</td>
1412 <td class="db3">{image:db_check.gif|16|16}</td>
1413 <td class="db4">&nbsp;</td>
1414 <td class="db5">&nbsp;</td>
1415 <td class="db6">0</td>
1416 <td class="db7">&nbsp;</td>
1417 </tr>
1418 <tr>
1419 <td class="db0">{image:db_field.gif|16|16}</td>
1420 <td class="db1">XWV_NUMBER</td>
1421 <td class="db2">INTEGER</td>
1422 <td class="db3">&nbsp;</td>
1423 <td class="db4">&nbsp;</td>
1424 <td class="db5">&nbsp;</td>
1425 <td class="db6">null&nbsp;</td>
1426 <td class="db7">&nbsp;</td>
1427 </tr>
1428 <tr>
1429 <td class="db0">{image:db_field.gif|16|16}</td>
1430 <td class="db1">XWV_NAME</td>
1431 <td class="db2">VARCHAR(255)</td>
1432 <td class="db3">{image:db_check.gif|16|16}</td>
1433 <td class="db4">&nbsp;</td>
1434 <td class="db5">&nbsp;</td>
1435 <td class="db6">&nbsp;</td>
1436 <td class="db7">&nbsp;</td>
1437 </tr>
1438 <tr>
1439 <td class="db0">{image:db_field.gif|16|16}</td>
1440 <td class="db1">XWV_CLASSNAME</td>
1441 <td class="db2">VARCHAR(255)</td>
1442 <td class="db3">{image:db_check.gif|16|16}</td>
1443 <td class="db4">&nbsp;</td>
1444 <td class="db5">&nbsp;</td>
1445 <td class="db6">&nbsp;</td>
1446 <td class="db7">&nbsp;</td>
1447 </tr>
1448 <tr>
1449 <td class="db0">{image:db_field.gif|16|16}</td>
1450 <td class="db1">XWV_IP</td>
1451 <td class="db2">VARCHAR(32)</td>
1452 <td class="db3">{image:db_check.gif|16|16}</td>
1453 <td class="db4">&nbsp;</td>
1454 <td class="db5">&nbsp;</td>
1455 <td class="db6">&nbsp;</td>
1456 <td class="db7">&nbsp;</td>
1457 </tr>
1458 <tr>
1459 <td class="db0">{image:db_field.gif|16|16}</td>
1460 <td class="db1">XWV_USER_AGENT</td>
1461 <td class="db2">VARCHAR(255)</td>
1462 <td class="db3">{image:db_check.gif|16|16}</td>
1463 <td class="db4">&nbsp;</td>
1464 <td class="db5">&nbsp;</td>
1465 <td class="db6">&nbsp;</td>
1466 <td class="db7">&nbsp;</td>
1467 </tr>
1468 <tr>
1469 <td class="db0">{image:db_field.gif|16|16}</td>
1470 <td class="db1">XWV_COOKIE</td>
1471 <td class="db2">VARCHAR(255)</td>
1472 <td class="db3">{image:db_check.gif|16|16}</td>
1473 <td class="db4">&nbsp;</td>
1474 <td class="db5">&nbsp;</td>
1475 <td class="db6">&nbsp;</td>
1476 <td class="db7">&nbsp;</td>
1477 </tr>
1478 <tr>
1479 <td class="db0">{image:db_field.gif|16|16}</td>
1480 <td class="db1">XWV_UNIQUE_ID</td>
1481 <td class="db2">VARCHAR(255)</td>
1482 <td class="db3">{image:db_check.gif|16|16}</td>
1483 <td class="db4">&nbsp;</td>
1484 <td class="db5">&nbsp;</td>
1485 <td class="db6">&nbsp;</td>
1486 <td class="db7">&nbsp;</td>
1487 </tr>
1488 <tr>
1489 <td class="db0">{image:db_field.gif|16|16}</td>
1490 <td class="db1">XWV_PAGE_VIEWS</td>
1491 <td class="db2">INTEGER</td>
1492 <td class="db3">&nbsp;</td>
1493 <td class="db4">&nbsp;</td>
1494 <td class="db5">&nbsp;</td>
1495 <td class="db6">null</td>
1496 <td class="db7">&nbsp;</td>
1497 </tr>
1498 <tr>
1499 <td class="db0">{image:db_field.gif|16|16}</td>
1500 <td class="db1">XWV_SAVES</td>
1501 <td class="db2">INTEGER</td>
1502 <td class="db3">&nbsp;</td>
1503 <td class="db4">&nbsp;</td>
1504 <td class="db5">&nbsp;</td>
1505 <td class="db6">null</td>
1506 <td class="db7">&nbsp;</td>
1507 </tr>
1508 <tr>
1509 <td class="db0">{image:db_field.gif|16|16}</td>
1510 <td class="db1">XWV_DOWNLOADS</td>
1511 <td class="db2">INTEGER</td>
1512 <td class="db3">&nbsp;</td>
1513 <td class="db4">&nbsp;</td>
1514 <td class="db5">&nbsp;</td>
1515 <td class="db6">null</td>
1516 <td class="db7">&nbsp;</td>
1517 </tr>
1518 <tr>
1519 <td class="db0">{image:db_field.gif|16|16}</td>
1520 <td class="db1">XWV_START_DATE</td>
1521 <td class="db2">DATETIME</td>
1522 <td class="db3">&nbsp;</td>
1523 <td class="db4">&nbsp;</td>
1524 <td class="db5">&nbsp;</td>
1525 <td class="db6">null</td>
1526 <td class="db7">&nbsp;</td>
1527 </tr>
1528 <tr>
1529 <td class="db0">{image:db_field.gif|16|16}</td>
1530 <td class="db1">XWV_END_DATE</td>
1531 <td class="db2">DATETIME</td>
1532 <td class="db3">&nbsp;</td>
1533 <td class="db4">&nbsp;</td>
1534 <td class="db5">&nbsp;</td>
1535 <td class="db6">null</td>
1536 <td class="db7">&nbsp;</td>
1537 </tr>
1538 </table>
1539
1540 [^ back to top ^>#Tables]
1541 $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