Skip to Content

Wiki source code of DatabaseSchema

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