Skip to Content

Wiki source code of DatabaseSchema

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