Skip to Content

Wiki source code of DatabaseSchema

Version 60.1 by Helmut Nagy on 2009/02/12
Show last authors
1 1 XWiki Database Schema
2
3 #error("The schema below is out of date. It needs to be updated. Feel free to update it if you know what you're doing :)")
4
5 Following are all of the tables that make up the XWiki database schema. Just taking a brief look at the schema's tables can give you a clue to how the underlying system works.
6
7 Note that there may be minor variances for databases other than MySQL, but if so, they have not yet been documented.
8
9 1.1 Tables
10
11 In alphabetical order
12
13 <table width="100%">
14 <tr>
15 <td style="border-bottom:0px">
16 * [xwikiattachment>DevGuide.DsXWikiAttachment]
17 * [xwikiattachment_archive>DevGuide.XWikiAttachmentArchive]
18 * [xwikiattachment_content>DevGuide.DsXWikiAttachmentContent]
19 * xwikiattrecyclebin
20 * [xwikibooleanclasses>DevGuide.DsXWikiBooleanClasses]
21 * [xwikiclasses>DevGuide.DsXWikiClasses]
22 * [xwikiclassesprop>DevGuide.DsXWikiClassesProp]
23 * xwikicomments
24 * [xwikidateclasses>#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>DevGuide.DsXWikiStringClasses]
51 * [xwikistrings>#XWiki+Strings]
52 </td>
53 </tr>
54 </table>
55
56 * [xwikilistclasses>#XWiki+List+Classes] ... not existing in Release 1.7.1
57
58 1.1.1 XWiki Date Classes
59
60 This table contains the declaration of the date properties in XWiki classes.
61
62 <table border="0" width="100%" class="dbtable" cellpadding="3"
63 cellspacing="0">
64 <tr>
65 <td colspan="8" class="dbhead">xwikidateclasses</td>
66 </tr>
67 <tr>
68 <th class="db0">&nbsp;</th>
69 <th class="db1">Column Name</th>
70 <th class="db2">Datatype</th>
71 <th class="db3">Not null</th>
72 <th class="db4">auto inc</th>
73 <th class="db5">flags</th>
74 <th class="db6">Default Value</th>
75 <th class="db7">Comments</th>
76 </tr>
77 <tr>
78 <td class="db0">{image:db_key.gif|16|16}</td>
79 <td class="db1">XWS_ID</td>
80 <td class="db2">INTEGER</td>
81 <td class="db3">{image:db_check.gif|16|16}</td>
82 <td class="db4">&nbsp;</td>
83 <td class="db5">&nbsp;</td>
84 <td class="db6">0</td>
85 <td class="db7">&nbsp;</td>
86 </tr>
87 <tr>
88 <td class="db0">{image:db_key.gif|16|16}</td>
89 <td class="db1">XWS_NAME</td>
90 <td class="db2">VARCHAR(255)</td>
91 <td class="db3">{image:db_check.gif|16|16}</td>
92 <td class="db4">&nbsp;</td>
93 <td class="db5">&nbsp;</td>
94 <td class="db6">&nbsp;</td>
95 <td class="db7">&nbsp;</td>
96 </tr>
97 <tr>
98 <td class="db0">{image:db_field.gif|16|16}</td>
99 <td class="db1">XWS_SIZE</td>
100 <td class="db2">INTEGER</td>
101 <td class="db3">&nbsp;</td>
102 <td class="db4">&nbsp;</td>
103 <td class="db5">&nbsp;</td>
104 <td class="db6">null</td>
105 <td class="db7">&nbsp;</td>
106 </tr>
107 <tr>
108 <td class="db0">{image:db_field.gif|16|16}</td>
109 <td class="db1">XWS_EMPTY_IS_TODAY</td>
110 <td class="db2">INTEGER</td>
111 <td class="db3">&nbsp;</td>
112 <td class="db4">&nbsp;</td>
113 <td class="db5">&nbsp;</td>
114 <td class="db6">null</td>
115 <td class="db7">&nbsp;</td>
116 </tr>
117 <tr>
118 <td class="db0">{image:db_field.gif|16|16}</td>
119 <td class="db1">XWS_DATE_FORMAT</td>
120 <td class="db2">VARCHAR(255)</td>
121 <td class="db3">&nbsp;</td>
122 <td class="db4">&nbsp;</td>
123 <td class="db5">&nbsp;</td>
124 <td class="db6">null</td>
125 <td class="db7">&nbsp;</td>
126 </tr>
127 </table>
128
129 The field name prefix is this table is wrong. It should be corrected in xwiki.hbm.xml.
130
131 [^ back to top ^>#Tables]
132
133 1.1.1 XWiki Number Classes
134
135 This table contains the declaration of the number (long, integer, double, float) properties in XWiki classes.
136
137 <table border="0" width="100%" class="dbtable" cellpadding="3"
138 cellspacing="0">
139 <tr>
140 <td colspan="8" class="dbhead">xwikinumberclasses</td>
141 </tr>
142 <tr>
143 <th class="db0">&nbsp;</th>
144 <th class="db1">Column Name</th>
145 <th class="db2">Datatype</th>
146 <th class="db3">Not null</th>
147 <th class="db4">auto inc</th>
148 <th class="db5">flags</th>
149 <th class="db6">Default Value</th>
150 <th class="db7">Comments</th>
151 </tr>
152 <tr>
153 <td class="db0">{image:db_key.gif|16|16}</td>
154 <td class="db1">XWN_ID</td>
155 <td class="db2">INTEGER</td>
156 <td class="db3">{image:db_check.gif|16|16}</td>
157 <td class="db4">&nbsp;</td>
158 <td class="db5">&nbsp;</td>
159 <td class="db6">0</td>
160 <td class="db7">&nbsp;</td>
161 </tr>
162 <tr>
163 <td class="db0">{image:db_key.gif|16|16}</td>
164 <td class="db1">XWN_NAME</td>
165 <td class="db2">VARCHAR(255)</td>
166 <td class="db3">{image:db_check.gif|16|16}</td>
167 <td class="db4">&nbsp;</td>
168 <td class="db5">&nbsp;</td>
169 <td class="db6">null&nbsp;</td>
170 <td class="db7">&nbsp;</td>
171 </tr>
172 <tr>
173 <td class="db0">{image:db_field.gif|16|16}</td>
174 <td class="db1">XWN_SIZE</td>
175 <td class="db2">INTEGER</td>
176 <td class="db3">{image:db_check.gif|16|16}</td>
177 <td class="db4">&nbsp;</td>
178 <td class="db5">&nbsp;</td>
179 <td class="db6">null</td>
180 <td class="db7">&nbsp;</td>
181 </tr>
182 <tr>
183 <td class="db0">{image:db_field.gif|16|16}</td>
184 <td class="db1">XWN_NUMBERTYPE</td>
185 <td class="db2">VARCHAR(20)</td>
186 <td class="db3">&nbsp;</td>
187 <td class="db4">&nbsp;</td>
188 <td class="db5">&nbsp;</td>
189 <td class="db6">null</td>
190 <td class="db7">&nbsp;</td>
191 </tr>
192 </table>
193
194 [^ back to top ^>#Tables]
195
196 1.1.1 XWiki List Classes
197
198 This table contains the declaration of the list properties in XWiki classes.
199
200 <table border="0" width="100%" class="dbtable" cellpadding="3"
201 cellspacing="0">
202 <tr>
203 <td colspan="8" class="dbhead">xwikislistclasses</td>
204 </tr>
205 <tr>
206 <th class="db0">&nbsp;</th>
207 <th class="db1">Column Name</th>
208 <th class="db2">Datatype</th>
209 <th class="db3">Not null</th>
210 <th class="db4">auto inc</th>
211 <th class="db5">flags</th>
212 <th class="db6">Default Value</th>
213 <th class="db7">Comments</th>
214 </tr>
215 <tr>
216 <td class="db0">{image:db_key.gif|16|16}</td>
217 <td class="db1">XWL_ID</td>
218 <td class="db2">INTEGER</td>
219 <td class="db3">{image:db_check.gif|16|16}</td>
220 <td class="db4">&nbsp;</td>
221 <td class="db5">&nbsp;</td>
222 <td class="db6">0</td>
223 <td class="db7">&nbsp;</td>
224 </tr>
225 <tr>
226 <td class="db0">{image:db_key.gif|16|16}</td>
227 <td class="db1">XWL_NAME</td>
228 <td class="db2">VARCHAR(255)</td>
229 <td class="db3">{image:db_check.gif|16|16}</td>
230 <td class="db4">&nbsp;</td>
231 <td class="db5">&nbsp;</td>
232 <td class="db6">&nbsp;</td>
233 <td class="db7">&nbsp;</td>
234 </tr>
235 <tr>
236 <td class="db0">{image:db_field.gif|16|16}</td>
237 <td class="db1">XWL_DISPLAYTYPE</td>
238 <td class="db2">VARCHAR(20)</td>
239 <td class="db3">&nbsp;</td>
240 <td class="db4">&nbsp;</td>
241 <td class="db5">&nbsp;</td>
242 <td class="db6">null</td>
243 <td class="db7">&nbsp;</td>
244 </tr>
245 <tr>
246 <td class="db0">{image:db_field.gif|16|16}</td>
247 <td class="db1">XWL_MULTISELECT</td>
248 <td class="db2">TINYINT(1)</td>
249 <td class="db3">&nbsp;</td>
250 <td class="db4">&nbsp;</td>
251 <td class="db5">&nbsp;</td>
252 <td class="db6">null</td>
253 <td class="db7">&nbsp;</td>
254 </tr>
255 <tr>
256 <td class="db0">{image:db_field.gif|16|16}</td>
257 <td class="db1">XWL_SIZE</td>
258 <td class="db2">INTEGER</td>
259 <td class="db3">&nbsp;</td>
260 <td class="db4">&nbsp;</td>
261 <td class="db5">&nbsp;</td>
262 <td class="db6">null</td>
263 <td class="db7">&nbsp;</td>
264 </tr>
265 <tr>
266 <td class="db0">{image:db_field.gif|16|16}</td>
267 <td class="db1">XWL_RELATIONAL</td>
268 <td class="db2">TINYINT(1)</td>
269 <td class="db3">&nbsp;</td>
270 <td class="db4">&nbsp;</td>
271 <td class="db5">&nbsp;</td>
272 <td class="db6">null</td>
273 <td class="db7">&nbsp;</td>
274 </tr>
275 <tr>
276 <td class="db0">{image:db_field.gif|16|16}</td>
277 <td class="db1">XWL_VALUES</td>
278 <td class="db2">TEXT</td>
279 <td class="db3">&nbsp;</td>
280 <td class="db4">&nbsp;</td>
281 <td class="db5">&nbsp;</td>
282 <td class="db6">null</td>
283 <td class="db7">&nbsp;</td>
284 </tr>
285 </table>
286
287 [^ back to top ^>#Tables]
288
289 1.1.1 XWiki Database List Classes
290
291 This table contains the declaration of the database list properties in XWiki classes.
292
293 <table border="0" width="100%" class="dbtable" cellpadding="3"
294 cellspacing="0">
295 <tr>
296 <td colspan="8" class="dbhead">xwikidblistclasses</td>
297 </tr>
298 <tr>
299 <th class="db0">&nbsp;</th>
300 <th class="db1">Column Name</th>
301 <th class="db2">Datatype</th>
302 <th class="db3">Not null</th>
303 <th class="db4">auto inc</th>
304 <th class="db5">flags</th>
305 <th class="db6">Default Value</th>
306 <th class="db7">Comments</th>
307 </tr>
308 <tr>
309 <td class="db0">{image:db_key.gif|16|16}</td>
310 <td class="db1">XWL_ID</td>
311 <td class="db2">INTEGER</td>
312 <td class="db3">{image:db_check.gif|16|16}</td>
313 <td class="db4">&nbsp;</td>
314 <td class="db5">&nbsp;</td>
315 <td class="db6">0</td>
316 <td class="db7">&nbsp;</td>
317 </tr>
318 <tr>
319 <td class="db0">{image:db_key.gif|16|16}</td>
320 <td class="db1">XWL_NAME</td>
321 <td class="db2">VARCHAR(255)</td>
322 <td class="db3">{image:db_check.gif|16|16}</td>
323 <td class="db4">&nbsp;</td>
324 <td class="db5">&nbsp;</td>
325 <td class="db6">&nbsp;</td>
326 <td class="db7">&nbsp;</td>
327 </tr>
328 <tr>
329 <td class="db0">{image:db_field.gif|16|16}</td>
330 <td class="db1">XWL_DISPLAYTYPE</td>
331 <td class="db2">VARCHAR(20)</td>
332 <td class="db3">&nbsp;</td>
333 <td class="db4">&nbsp;</td>
334 <td class="db5">&nbsp;</td>
335 <td class="db6">null</td>
336 <td class="db7">&nbsp;</td>
337 </tr>
338 <tr>
339 <td class="db0">{image:db_field.gif|16|16}</td>
340 <td class="db1">XWL_MULTISELECT</td>
341 <td class="db2">TINYINT(1)</td>
342 <td class="db3">&nbsp;</td>
343 <td class="db4">&nbsp;</td>
344 <td class="db5">&nbsp;</td>
345 <td class="db6">null</td>
346 <td class="db7">&nbsp;</td>
347 </tr>
348 <tr>
349 <td class="db0">{image:db_field.gif|16|16}</td>
350 <td class="db1">XWL_SIZE</td>
351 <td class="db2">INTEGER</td>
352 <td class="db3">&nbsp;</td>
353 <td class="db4">&nbsp;</td>
354 <td class="db5">&nbsp;</td>
355 <td class="db6">null</td>
356 <td class="db7">&nbsp;</td>
357 </tr>
358 <tr>
359 <td class="db0">{image:db_field.gif|16|16}</td>
360 <td class="db1">XWL_RELATIONAL</td>
361 <td class="db2">TINYINT(1)</td>
362 <td class="db3">&nbsp;</td>
363 <td class="db4">&nbsp;</td>
364 <td class="db5">&nbsp;</td>
365 <td class="db6">null</td>
366 <td class="db7">&nbsp;</td>
367 </tr>
368 <tr>
369 <td class="db0">{image:db_field.gif|16|16}</td>
370 <td class="db1">XWL_SQL</td>
371 <td class="db2">TEXT</td>
372 <td class="db3">&nbsp;</td>
373 <td class="db4">&nbsp;</td>
374 <td class="db5">&nbsp;</td>
375 <td class="db6">null</td>
376 <td class="db7">&nbsp;</td>
377 </tr>
378 </table>
379
380 [^ back to top ^>#Tables]
381
382 1.1 XWiki Objects
383
384 This table contains the list of XWiki Objects. Objects can have properties, as declared by their class.
385
386 <table border="0" width="100%" class="dbtable" cellpadding="3"
387 cellspacing="0">
388 <tr>
389 <td colspan="8" class="dbhead">xwikiobjects</td>
390 </tr>
391 <tr>
392 <th class="db0">&nbsp;</th>
393 <th class="db1">Column Name</th>
394 <th class="db2">Datatype</th>
395 <th class="db3">Not null</th>
396 <th class="db4">auto inc</th>
397 <th class="db5">flags</th>
398 <th class="db6">Default Value</th>
399 <th class="db7">Comments</th>
400 </tr>
401 <tr>
402 <td class="db0">{image:db_key.gif|16|16}</td>
403 <td class="db1">XWO_ID</td>
404 <td class="db2">INTEGER</td>
405 <td class="db3">{image:db_check.gif|16|16}</td>
406 <td class="db4">&nbsp;</td>
407 <td class="db5">&nbsp;</td>
408 <td class="db6">0</td>
409 <td class="db7">&nbsp;</td>
410 </tr>
411 <tr>
412 <td class="db0">{image:db_field.gif|16|16}</td>
413 <td class="db1">XWO_NUMBER</td>
414 <td class="db2">INTEGER</td>
415 <td class="db3">&nbsp;</td>
416 <td class="db4">&nbsp;</td>
417 <td class="db5">&nbsp;</td>
418 <td class="db6">null&nbsp;</td>
419 <td class="db7">&nbsp;</td>
420 </tr>
421 <tr>
422 <td class="db0">{image:db_field.gif|16|16}</td>
423 <td class="db1">XWO_NAME</td>
424 <td class="db2">VARCHAR(255)</td>
425 <td class="db3">{image:db_check.gif|16|16}</td>
426 <td class="db4">&nbsp;</td>
427 <td class="db5">&nbsp;</td>
428 <td class="db6">null</td>
429 <td class="db7">&nbsp;</td>
430 </tr>
431 <tr>
432 <td class="db0">{image:db_field.gif|16|16}</td>
433 <td class="db1">XWO_CLASSNAME</td>
434 <td class="db2">VARCHAR(255)</td>
435 <td class="db3">{image:db_check.gif|16|16}</td>
436 <td class="db4">&nbsp;</td>
437 <td class="db5">&nbsp;</td>
438 <td class="db6">&nbsp;</td>
439 <td class="db7">&nbsp;</td>
440 </tr>
441 </table>
442
443 [^ back to top ^>#Tables]
444
445 1.1 XWiki Properties
446
447 This table contains the list of properties in XWiki Objects. Each property has an entry in the type specific table.
448
449 <table border="0" width="100%" class="dbtable" cellpadding="3"
450 cellspacing="0">
451 <tr>
452 <td colspan="8" class="dbhead">xwikiproperties</td>
453 </tr>
454 <tr>
455 <th class="db0">&nbsp;</th>
456 <th class="db1">Column Name</th>
457 <th class="db2">Datatype</th>
458 <th class="db3">Not null</th>
459 <th class="db4">auto inc</th>
460 <th class="db5">flags</th>
461 <th class="db6">Default Value</th>
462 <th class="db7">Comments</th>
463 </tr>
464 <tr>
465 <td class="db0">{image:db_key.gif|16|16}</td>
466 <td class="db1">XWP_ID</td>
467 <td class="db2">INTEGER</td>
468 <td class="db3">{image:db_check.gif|16|16}</td>
469 <td class="db4">&nbsp;</td>
470 <td class="db5">&nbsp;</td>
471 <td class="db6">0</td>
472 <td class="db7">&nbsp;</td>
473 </tr>
474 <tr>
475 <td class="db0">{image:db_key.gif|16|16}</td>
476 <td class="db1">XWP_NAME</td>
477 <td class="db2">VARCHAR(255)</td>
478 <td class="db3">{image:db_check.gif|16|16}</td>
479 <td class="db4">&nbsp;</td>
480 <td class="db5">&nbsp;</td>
481 <td class="db6">&nbsp;</td>
482 <td class="db7">&nbsp;</td>
483 </tr>
484 <tr>
485 <td class="db0">{image:db_field.gif|16|16}</td>
486 <td class="db1">XWP_CLASSTYPE</td>
487 <td class="db2">VARCHAR(255)</td>
488 <td class="db3">&nbsp;</td>
489 <td class="db4">&nbsp;</td>
490 <td class="db5">&nbsp;</td>
491 <td class="db6">null</td>
492 <td class="db7">&nbsp;</td>
493 </tr>
494 </table>
495
496 [^ back to top ^>#Tables]
497
498 1.1.1 XWiki Strings
499
500 This table contains the string data from XWiki Objects.
501
502 <table border="0" width="100%" class="dbtable" cellpadding="3"
503 cellspacing="0">
504 <tr>
505 <td colspan="8" class="dbhead">xwikistrings</td>
506 </tr>
507 <tr>
508 <th class="db0">&nbsp;</th>
509 <th class="db1">Column Name</th>
510 <th class="db2">Datatype</th>
511 <th class="db3">Not null</th>
512 <th class="db4">auto inc</th>
513 <th class="db5">flags</th>
514 <th class="db6">Default Value</th>
515 <th class="db7">Comments</th>
516 </tr>
517 <tr>
518 <td class="db0">{image:db_key.gif|16|16}</td>
519 <td class="db1">XWS_ID</td>
520 <td class="db2">INTEGER</td>
521 <td class="db3">{image:db_check.gif|16|16}</td>
522 <td class="db4">&nbsp;</td>
523 <td class="db5">&nbsp;</td>
524 <td class="db6">0</td>
525 <td class="db7">&nbsp;</td>
526 </tr>
527 <tr>
528 <td class="db0">{image:db_key.gif|16|16}</td>
529 <td class="db1">XWS_NAME</td>
530 <td class="db2">VARCHAR(255)</td>
531 <td class="db3">{image:db_check.gif|16|16}</td>
532 <td class="db4">&nbsp;</td>
533 <td class="db5">&nbsp;</td>
534 <td class="db6">&nbsp;</td>
535 <td class="db7">&nbsp;</td>
536 </tr>
537 <tr>
538 <td class="db0">{image:db_field.gif|16|16}</td>
539 <td class="db1">XWS_VALUE</td>
540 <td class="db2">VARCHAR(255)</td>
541 <td class="db3">&nbsp;</td>
542 <td class="db4">&nbsp;</td>
543 <td class="db5">&nbsp;</td>
544 <td class="db6">null</td>
545 <td class="db7">&nbsp;</td>
546 </tr>
547 </table>
548
549 [^ back to top ^>#Tables]
550
551 1.1.1 XWiki Large Strings
552
553 This table contain the data for textarea properties in XWiki Objects.
554
555 <table border="0" width="100%" class="dbtable" cellpadding="3"
556 cellspacing="0">
557 <tr>
558 <td colspan="8" class="dbhead">xwikilargestrings</td>
559 </tr>
560 <tr>
561 <th class="db0">&nbsp;</th>
562 <th class="db1">Column Name</th>
563 <th class="db2">Datatype</th>
564 <th class="db3">Not null</th>
565 <th class="db4">auto inc</th>
566 <th class="db5">flags</th>
567 <th class="db6">Default Value</th>
568 <th class="db7">Comments</th>
569 </tr>
570 <tr>
571 <td class="db0">{image:db_key.gif|16|16}</td>
572 <td class="db1">XWL_ID</td>
573 <td class="db2">INTEGER</td>
574 <td class="db3">{image:db_check.gif|16|16}</td>
575 <td class="db4">&nbsp;</td>
576 <td class="db5">&nbsp;</td>
577 <td class="db6">0</td>
578 <td class="db7">&nbsp;</td>
579 </tr>
580 <tr>
581 <td class="db0">{image:db_key.gif|16|16}</td>
582 <td class="db1">XWL_NAME</td>
583 <td class="db2">VARCHAR(255)</td>
584 <td class="db3">{image:db_check.gif|16|16}</td>
585 <td class="db4">&nbsp;</td>
586 <td class="db5">&nbsp;</td>
587 <td class="db6">&nbsp;</td>
588 <td class="db7">&nbsp;</td>
589 </tr>
590 <tr>
591 <td class="db0">{image:db_field.gif|16|16}</td>
592 <td class="db1">XWL_VALUE</td>
593 <td class="db2">TEXT</td>
594 <td class="db3">&nbsp;</td>
595 <td class="db4">&nbsp;</td>
596 <td class="db5">&nbsp;</td>
597 <td class="db6">null</td>
598 <td class="db7">&nbsp;</td>
599 </tr>
600 </table>
601
602 [^ back to top ^>#Tables]
603
604 1.1.1 XWiki Dates
605
606 This table contains the data of date properties in XWiki objects.
607
608 <table border="0" width="100%" class="dbtable" cellpadding="3"
609 cellspacing="0">
610 <tr>
611 <td colspan="8" class="dbhead">xwikidates</td>
612 </tr>
613 <tr>
614 <th class="db0">&nbsp;</th>
615 <th class="db1">Column Name</th>
616 <th class="db2">Datatype</th>
617 <th class="db3">Not null</th>
618 <th class="db4">auto inc</th>
619 <th class="db5">flags</th>
620 <th class="db6">Default Value</th>
621 <th class="db7">Comments</th>
622 </tr>
623 <tr>
624 <td class="db0">{image:db_key.gif|16|16}</td>
625 <td class="db1">XWS_ID</td>
626 <td class="db2">INTEGER</td>
627 <td class="db3">{image:db_check.gif|16|16}</td>
628 <td class="db4">&nbsp;</td>
629 <td class="db5">&nbsp;</td>
630 <td class="db6">0</td>
631 <td class="db7">&nbsp;</td>
632 </tr>
633 <tr>
634 <td class="db0">{image:db_key.gif|16|16}</td>
635 <td class="db1">XWS_NAME</td>
636 <td class="db2">VARCHAR(255)</td>
637 <td class="db3">{image:db_check.gif|16|16}</td>
638 <td class="db4">&nbsp;</td>
639 <td class="db5">&nbsp;</td>
640 <td class="db6">&nbsp;</td>
641 <td class="db7">&nbsp;</td>
642 </tr>
643 <tr>
644 <td class="db0">{image:db_field.gif|16|16}</td>
645 <td class="db1">XWS_VALUE</td>
646 <td class="db2">DATETIME</td>
647 <td class="db3">&nbsp;</td>
648 <td class="db4">&nbsp;</td>
649 <td class="db5">&nbsp;</td>
650 <td class="db6">null</td>
651 <td class="db7">&nbsp;</td>
652 </tr>
653 </table>
654
655 The field name prefix is this table is wrong. It should be corrected in xwiki.hbm.xml.
656
657 [^ back to top ^>#Tables]
658
659 1.1.1 XWiki Doubles
660
661 This table contain the data for double properties in XWiki Objects.
662
663 <table border="0" width="100%" class="dbtable" cellpadding="3"
664 cellspacing="0">
665 <tr>
666 <td colspan="8" class="dbhead">xwikidoubles</td>
667 </tr>
668 <tr>
669 <th class="db0">&nbsp;</th>
670 <th class="db1">Column Name</th>
671 <th class="db2">Datatype</th>
672 <th class="db3">Not null</th>
673 <th class="db4">auto inc</th>
674 <th class="db5">flags</th>
675 <th class="db6">Default Value</th>
676 <th class="db7">Comments</th>
677 </tr>
678 <tr>
679 <td class="db0">{image:db_key.gif|16|16}</td>
680 <td class="db1">XWD_ID</td>
681 <td class="db2">INTEGER</td>
682 <td class="db3">{image:db_check.gif|16|16}</td>
683 <td class="db4">&nbsp;</td>
684 <td class="db5">&nbsp;</td>
685 <td class="db6">0</td>
686 <td class="db7">&nbsp;</td>
687 </tr>
688 <tr>
689 <td class="db0">{image:db_key.gif|16|16}</td>
690 <td class="db1">XWD_NAME</td>
691 <td class="db2">VARCHAR(255)</td>
692 <td class="db3">{image:db_check.gif|16|16}</td>
693 <td class="db4">&nbsp;</td>
694 <td class="db5">&nbsp;</td>
695 <td class="db6">&nbsp;</td>
696 <td class="db7">&nbsp;</td>
697 </tr>
698 <tr>
699 <td class="db0">{image:db_field.gif|16|16}</td>
700 <td class="db1">XWD_VALUE</td>
701 <td class="db2">DOUBLE</td>
702 <td class="db3">&nbsp;</td>
703 <td class="db4">&nbsp;</td>
704 <td class="db5">&nbsp;</td>
705 <td class="db6">null</td>
706 <td class="db7">&nbsp;</td>
707 </tr>
708 </table>
709
710 [^ back to top ^>#Tables]
711
712 1.1.1 XWiki Floats
713
714 This table contain the data for floats properties in XWiki Objects.
715
716
717 <table border="0" width="100%" class="dbtable" cellpadding="3"
718 cellspacing="0">
719 <tr>
720 <td colspan="8" class="dbhead">xwikifloats</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">XWF_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">XWF_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">XWF_VALUE</td>
755 <td class="db2">FLOAT</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 Integers
767
768 This table contain the data for integer properties in XWiki Objects.
769
770
771 <table border="0" width="100%" class="dbtable" cellpadding="3"
772 cellspacing="0">
773 <tr>
774 <td colspan="8" class="dbhead">xwikiintegers</td>
775 </tr>
776 <tr>
777 <th class="db0">&nbsp;</th>
778 <th class="db1">Column Name</th>
779 <th class="db2">Datatype</th>
780 <th class="db3">Not null</th>
781 <th class="db4">auto inc</th>
782 <th class="db5">flags</th>
783 <th class="db6">Default Value</th>
784 <th class="db7">Comments</th>
785 </tr>
786 <tr>
787 <td class="db0">{image:db_key.gif|16|16}</td>
788 <td class="db1">XWI_ID</td>
789 <td class="db2">INTEGER</td>
790 <td class="db3">{image:db_check.gif|16|16}</td>
791 <td class="db4">&nbsp;</td>
792 <td class="db5">&nbsp;</td>
793 <td class="db6">0</td>
794 <td class="db7">&nbsp;</td>
795 </tr>
796 <tr>
797 <td class="db0">{image:db_key.gif|16|16}</td>
798 <td class="db1">XWI_NAME</td>
799 <td class="db2">VARCHAR(255)</td>
800 <td class="db3">{image:db_check.gif|16|16}</td>
801 <td class="db4">&nbsp;</td>
802 <td class="db5">&nbsp;</td>
803 <td class="db6">&nbsp;</td>
804 <td class="db7">&nbsp;</td>
805 </tr>
806 <tr>
807 <td class="db0">{image:db_field.gif|16|16}</td>
808 <td class="db1">XWI_VALUE</td>
809 <td class="db2">INTEGER</td>
810 <td class="db3">&nbsp;</td>
811 <td class="db4">&nbsp;</td>
812 <td class="db5">&nbsp;</td>
813 <td class="db6">null</td>
814 <td class="db7">&nbsp;</td>
815 </tr>
816 </table>
817
818 [^ back to top ^>#Tables]
819
820 1.1.1 XWiki Longs
821
822 This table contain the data for long properties in XWiki Objects.
823
824 <table border="0" width="100%" class="dbtable" cellpadding="3"
825 cellspacing="0">
826 <tr>
827 <td colspan="8" class="dbhead">xwikilongs</td>
828 </tr>
829 <tr>
830 <th class="db0">&nbsp;</th>
831 <th class="db1">Column Name</th>
832 <th class="db2">Datatype</th>
833 <th class="db3">Not null</th>
834 <th class="db4">auto inc</th>
835 <th class="db5">flags</th>
836 <th class="db6">Default Value</th>
837 <th class="db7">Comments</th>
838 </tr>
839 <tr>
840 <td class="db0">{image:db_key.gif|16|16}</td>
841 <td class="db1">XWL_ID</td>
842 <td class="db2">INTEGER</td>
843 <td class="db3">{image:db_check.gif|16|16}</td>
844 <td class="db4">&nbsp;</td>
845 <td class="db5">&nbsp;</td>
846 <td class="db6">0</td>
847 <td class="db7">&nbsp;</td>
848 </tr>
849 <tr>
850 <td class="db0">{image:db_key.gif|16|16}</td>
851 <td class="db1">XWL_NAME</td>
852 <td class="db2">VARCHAR(255)</td>
853 <td class="db3">{image:db_check.gif|16|16}</td>
854 <td class="db4">&nbsp;</td>
855 <td class="db5">&nbsp;</td>
856 <td class="db6">&nbsp;</td>
857 <td class="db7">&nbsp;</td>
858 </tr>
859 <tr>
860 <td class="db0">{image:db_field.gif|16|16}</td>
861 <td class="db1">XWL_VALUE</td>
862 <td class="db2">BIGINT(20)</td>
863 <td class="db3">&nbsp;</td>
864 <td class="db4">&nbsp;</td>
865 <td class="db5">&nbsp;</td>
866 <td class="db6">null</td>
867 <td class="db7">&nbsp;</td>
868 </tr>
869 </table>
870
871 [^ back to top ^>#Tables]
872
873 1.1.1 XWiki List Items
874
875 This table contain the data for lists properties in XWiki Objects.
876
877 <table border="0" width="100%" class="dbtable" cellpadding="3"
878 cellspacing="0">
879 <tr>
880 <td colspan="8" class="dbhead">xwikilistitems</td>
881 </tr>
882 <tr>
883 <th class="db0">&nbsp;</th>
884 <th class="db1">Column Name</th>
885 <th class="db2">Datatype</th>
886 <th class="db3">Not null</th>
887 <th class="db4">auto inc</th>
888 <th class="db5">flags</th>
889 <th class="db6">Default Value</th>
890 <th class="db7">Comments</th>
891 </tr>
892 <tr>
893 <td class="db0">{image:db_key.gif|16|16}</td>
894 <td class="db1">XWL_ID</td>
895 <td class="db2">INTEGER</td>
896 <td class="db3">{image:db_check.gif|16|16}</td>
897 <td class="db4">&nbsp;</td>
898 <td class="db5">&nbsp;</td>
899 <td class="db6">0</td>
900 <td class="db7">&nbsp;</td>
901 </tr>
902 <tr>
903 <td class="db0">{image:db_key.gif|16|16}</td>
904 <td class="db1">XWL_NAME</td>
905 <td class="db2">VARCHAR(255)</td>
906 <td class="db3">{image:db_check.gif|16|16}</td>
907 <td class="db4">&nbsp;</td>
908 <td class="db5">&nbsp;</td>
909 <td class="db6">&nbsp;</td>
910 <td class="db7">&nbsp;</td>
911 </tr>
912 <tr>
913 <td class="db0">{image:db_field.gif|16|16}</td>
914 <td class="db1">XWL_VALUE</td>
915 <td class="db2">VARCHAR(255)</td>
916 <td class="db3">&nbsp;</td>
917 <td class="db4">&nbsp;</td>
918 <td class="db5">&nbsp;</td>
919 <td class="db6">null</td>
920 <td class="db7">&nbsp;</td>
921 </tr>
922 <tr>
923 <td class="db0">{image:db_key.gif|16|16}</td>
924 <td class="db1">XWL_NUMBER</td>
925 <td class="db2">INTEGER</td>
926 <td class="db3">{image:db_check.gif|16|16}</td>
927 <td class="db4">&nbsp;</td>
928 <td class="db5">&nbsp;</td>
929 <td class="db6">0</td>
930 <td class="db7">&nbsp;</td>
931 </tr>
932 </table>
933
934 [^ back to top ^>#Tables]
935
936 1.1.1 XWiki Lists
937
938 This table contain the data for lists properties in XWiki Objects.
939
940
941 <table border="0" width="100%" class="dbtable" cellpadding="3"
942 cellspacing="0">
943 <tr>
944 <td colspan="8" class="dbhead">xwikilists</td>
945 </tr>
946 <tr>
947 <th class="db0">&nbsp;</th>
948 <th class="db1">Column Name</th>
949 <th class="db2">Datatype</th>
950 <th class="db3">Not null</th>
951 <th class="db4">auto inc</th>
952 <th class="db5">flags</th>
953 <th class="db6">Default Value</th>
954 <th class="db7">Comments</th>
955 </tr>
956 <tr>
957 <td class="db0">{image:db_key.gif|16|16}</td>
958 <td class="db1">XWL_ID</td>
959 <td class="db2">INTEGER</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">0</td>
964 <td class="db7">&nbsp;</td>
965 </tr>
966 <tr>
967 <td class="db0">{image:db_key.gif|16|16}</td>
968 <td class="db1">XWL_NAME</td>
969 <td class="db2">VARCHAR(255)</td>
970 <td class="db3">{image:db_check.gif|16|16}</td>
971 <td class="db4">&nbsp;</td>
972 <td class="db5">&nbsp;</td>
973 <td class="db6">&nbsp;</td>
974 <td class="db7">&nbsp;</td>
975 </tr>
976 </table>
977
978 [^ back to top ^>#Tables]
979
980 1.1 Statistics
981
982 1.1.1 XWiki Document Stats
983
984 This table contain stats information, namely page/space/wiki views and edits
985 .
986 <table border="0" width="100%" class="dbtable" cellpadding="3"
987 cellspacing="0">
988 <tr>
989 <td colspan="8" class="dbhead">xwikistatsdoc</td>
990 </tr>
991 <tr>
992 <th class="db0">&nbsp;</th>
993 <th class="db1">Column Name</th>
994 <th class="db2">Datatype</th>
995 <th class="db3">Not null</th>
996 <th class="db4">auto inc</th>
997 <th class="db5">flags</th>
998 <th class="db6">Default Value</th>
999 <th class="db7">Comments</th>
1000 </tr>
1001 <tr>
1002 <td class="db0">{image:db_key.gif|16|16}</td>
1003 <td class="db1">XWS_ID</td>
1004 <td class="db2">INTEGER</td>
1005 <td class="db3">{image:db_check.gif|16|16}</td>
1006 <td class="db4">&nbsp;</td>
1007 <td class="db5">&nbsp;</td>
1008 <td class="db6">0</td>
1009 <td class="db7">&nbsp;</td>
1010 </tr>
1011 <tr>
1012 <td class="db0">{image:db_field.gif|16|16}</td>
1013 <td class="db1">XWS_NUMBER</td>
1014 <td class="db2">INTEGER</td>
1015 <td class="db3">&nbsp;</td>
1016 <td class="db4">&nbsp;</td>
1017 <td class="db5">&nbsp;</td>
1018 <td class="db6">null&nbsp;</td>
1019 <td class="db7">&nbsp;</td>
1020 </tr>
1021 <tr>
1022 <td class="db0">{image:db_field.gif|16|16}</td>
1023 <td class="db1">XWS_NAME</td>
1024 <td class="db2">VARCHAR(255)</td>
1025 <td class="db3">{image:db_check.gif|16|16}</td>
1026 <td class="db4">&nbsp;</td>
1027 <td class="db5">&nbsp;</td>
1028 <td class="db6">&nbsp;</td>
1029 <td class="db7">&nbsp;</td>
1030 </tr>
1031 <tr>
1032 <td class="db0">{image:db_field.gif|16|16}</td>
1033 <td class="db1">XWS_CLASSNAME</td>
1034 <td class="db2">VARCHAR(255)</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">&nbsp;</td>
1039 <td class="db7">&nbsp;</td>
1040 </tr>
1041 <tr>
1042 <td class="db0">{image:db_field.gif|16|16}</td>
1043 <td class="db1">XWS_ACTION</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">XWS_PAGE_VIEWS</td>
1054 <td class="db2">INTEGER</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 <tr>
1062 <td class="db0">{image:db_field.gif|16|16}</td>
1063 <td class="db1">XWS_UNIQUE_VISITORS</td>
1064 <td class="db2">INTEGER</td>
1065 <td class="db3">&nbsp;</td>
1066 <td class="db4">&nbsp;</td>
1067 <td class="db5">&nbsp;</td>
1068 <td class="db6">null</td>
1069 <td class="db7">&nbsp;</td>
1070 </tr>
1071 <tr>
1072 <td class="db0">{image:db_field.gif|16|16}</td>
1073 <td class="db1">XWS_PERIOD</td>
1074 <td class="db2">INTEGER</td>
1075 <td class="db3">&nbsp;</td>
1076 <td class="db4">&nbsp;</td>
1077 <td class="db5">&nbsp;</td>
1078 <td class="db6">null</td>
1079 <td class="db7">&nbsp;</td>
1080 </tr>
1081 <tr>
1082 <td class="db0">{image:db_field.gif|16|16}</td>
1083 <td class="db1">XWS_VISITS</td>
1084 <td class="db2">INTEGER</td>
1085 <td class="db3">&nbsp;</td>
1086 <td class="db4">&nbsp;</td>
1087 <td class="db5">&nbsp;</td>
1088 <td class="db6">null</td>
1089 <td class="db7">&nbsp;</td>
1090 </tr>
1091 </table>
1092
1093 [^ back to top ^>#Tables]
1094
1095 1.1.1 XWiki Referer Stats
1096
1097 This page contains the incoming externa links on the Wiki.
1098
1099 <table border="0" width="100%" class="dbtable" cellpadding="3"
1100 cellspacing="0">
1101 <tr>
1102 <td colspan="8" class="dbhead">xwikistatsreferer</td>
1103 </tr>
1104 <tr>
1105 <th class="db0">&nbsp;</th>
1106 <th class="db1">Column Name</th>
1107 <th class="db2">Datatype</th>
1108 <th class="db3">Not null</th>
1109 <th class="db4">auto inc</th>
1110 <th class="db5">flags</th>
1111 <th class="db6">Default Value</th>
1112 <th class="db7">Comments</th>
1113 </tr>
1114 <tr>
1115 <td class="db0">{image:db_key.gif|16|16}</td>
1116 <td class="db1">XWR_ID</td>
1117 <td class="db2">INTEGER</td>
1118 <td class="db3">{image:db_check.gif|16|16}</td>
1119 <td class="db4">&nbsp;</td>
1120 <td class="db5">&nbsp;</td>
1121 <td class="db6">0</td>
1122 <td class="db7">&nbsp;</td>
1123 </tr>
1124 <tr>
1125 <td class="db0">{image:db_field.gif|16|16}</td>
1126 <td class="db1">XWR_NUMBER</td>
1127 <td class="db2">INTEGER</td>
1128 <td class="db3">&nbsp;</td>
1129 <td class="db4">&nbsp;</td>
1130 <td class="db5">&nbsp;</td>
1131 <td class="db6">null</td>
1132 <td class="db7">&nbsp;</td>
1133 </tr>
1134 <tr>
1135 <td class="db0">{image:db_field.gif|16|16}</td>
1136 <td class="db1">XWR_NAME</td>
1137 <td class="db2">VARCHAR(255)</td>
1138 <td class="db3">{image:db_check.gif|16|16}</td>
1139 <td class="db4">&nbsp;</td>
1140 <td class="db5">&nbsp;</td>
1141 <td class="db6">&nbsp;</td>
1142 <td class="db7">&nbsp;</td>
1143 </tr>
1144 <tr>
1145 <td class="db0">{image:db_field.gif|16|16}</td>
1146 <td class="db1">XWR_CLASSNAME</td>
1147 <td class="db2">VARCHAR(255)</td>
1148 <td class="db3">{image:db_check.gif|16|16}</td>
1149 <td class="db4">&nbsp;</td>
1150 <td class="db5">&nbsp;</td>
1151 <td class="db6">&nbsp;</td>
1152 <td class="db7">&nbsp;</td>
1153 </tr>
1154 <tr>
1155 <td class="db0">{image:db_field.gif|16|16}</td>
1156 <td class="db1">XWR_REFERER</td>
1157 <td class="db2">VARCHAR(255)</td>
1158 <td class="db3">{image:db_check.gif|16|16}</td>
1159 <td class="db4">&nbsp;</td>
1160 <td class="db5">&nbsp;</td>
1161 <td class="db6">&nbsp;</td>
1162 <td class="db7">&nbsp;</td>
1163 </tr>
1164 <tr>
1165 <td class="db0">{image:db_field.gif|16|16}</td>
1166 <td class="db1">XWR_PAGE_VIEWS</td>
1167 <td class="db2">INTEGER</td>
1168 <td class="db3">&nbsp;</td>
1169 <td class="db4">&nbsp;</td>
1170 <td class="db5">&nbsp;</td>
1171 <td class="db6">null</td>
1172 <td class="db7">&nbsp;</td>
1173 </tr>
1174 <tr>
1175 <td class="db0">{image:db_field.gif|16|16}</td>
1176 <td class="db1">XWR_PERIOD</td>
1177 <td class="db2">INTEGER</td>
1178 <td class="db3">&nbsp;</td>
1179 <td class="db4">&nbsp;</td>
1180 <td class="db5">&nbsp;</td>
1181 <td class="db6">null</td>
1182 <td class="db7">&nbsp;</td>
1183 </tr>
1184 </table>
1185
1186 [^ back to top ^>#Tables]
1187
1188 1.1.1 XWiki Visits
1189
1190 This table contains the sessions of the named users.
1191
1192 <table border="0" width="100%" class="dbtable" cellpadding="3"
1193 cellspacing="0">
1194 <tr>
1195 <td colspan="8" class="dbhead">xwikistatsvisit</td>
1196 </tr>
1197 <tr>
1198 <th class="db0">&nbsp;</th>
1199 <th class="db1">Column Name</th>
1200 <th class="db2">Datatype</th>
1201 <th class="db3">Not null</th>
1202 <th class="db4">auto inc</th>
1203 <th class="db5">flags</th>
1204 <th class="db6">Default Value</th>
1205 <th class="db7">Comments</th>
1206 </tr>
1207 <tr>
1208 <td class="db0">{image:db_key.gif|16|16}</td>
1209 <td class="db1">XWV_ID</td>
1210 <td class="db2">INTEGER</td>
1211 <td class="db3">{image:db_check.gif|16|16}</td>
1212 <td class="db4">&nbsp;</td>
1213 <td class="db5">&nbsp;</td>
1214 <td class="db6">0</td>
1215 <td class="db7">&nbsp;</td>
1216 </tr>
1217 <tr>
1218 <td class="db0">{image:db_field.gif|16|16}</td>
1219 <td class="db1">XWV_NUMBER</td>
1220 <td class="db2">INTEGER</td>
1221 <td class="db3">&nbsp;</td>
1222 <td class="db4">&nbsp;</td>
1223 <td class="db5">&nbsp;</td>
1224 <td class="db6">null&nbsp;</td>
1225 <td class="db7">&nbsp;</td>
1226 </tr>
1227 <tr>
1228 <td class="db0">{image:db_field.gif|16|16}</td>
1229 <td class="db1">XWV_NAME</td>
1230 <td class="db2">VARCHAR(255)</td>
1231 <td class="db3">{image:db_check.gif|16|16}</td>
1232 <td class="db4">&nbsp;</td>
1233 <td class="db5">&nbsp;</td>
1234 <td class="db6">&nbsp;</td>
1235 <td class="db7">&nbsp;</td>
1236 </tr>
1237 <tr>
1238 <td class="db0">{image:db_field.gif|16|16}</td>
1239 <td class="db1">XWV_CLASSNAME</td>
1240 <td class="db2">VARCHAR(255)</td>
1241 <td class="db3">{image:db_check.gif|16|16}</td>
1242 <td class="db4">&nbsp;</td>
1243 <td class="db5">&nbsp;</td>
1244 <td class="db6">&nbsp;</td>
1245 <td class="db7">&nbsp;</td>
1246 </tr>
1247 <tr>
1248 <td class="db0">{image:db_field.gif|16|16}</td>
1249 <td class="db1">XWV_IP</td>
1250 <td class="db2">VARCHAR(32)</td>
1251 <td class="db3">{image:db_check.gif|16|16}</td>
1252 <td class="db4">&nbsp;</td>
1253 <td class="db5">&nbsp;</td>
1254 <td class="db6">&nbsp;</td>
1255 <td class="db7">&nbsp;</td>
1256 </tr>
1257 <tr>
1258 <td class="db0">{image:db_field.gif|16|16}</td>
1259 <td class="db1">XWV_USER_AGENT</td>
1260 <td class="db2">VARCHAR(255)</td>
1261 <td class="db3">{image:db_check.gif|16|16}</td>
1262 <td class="db4">&nbsp;</td>
1263 <td class="db5">&nbsp;</td>
1264 <td class="db6">&nbsp;</td>
1265 <td class="db7">&nbsp;</td>
1266 </tr>
1267 <tr>
1268 <td class="db0">{image:db_field.gif|16|16}</td>
1269 <td class="db1">XWV_COOKIE</td>
1270 <td class="db2">VARCHAR(255)</td>
1271 <td class="db3">{image:db_check.gif|16|16}</td>
1272 <td class="db4">&nbsp;</td>
1273 <td class="db5">&nbsp;</td>
1274 <td class="db6">&nbsp;</td>
1275 <td class="db7">&nbsp;</td>
1276 </tr>
1277 <tr>
1278 <td class="db0">{image:db_field.gif|16|16}</td>
1279 <td class="db1">XWV_UNIQUE_ID</td>
1280 <td class="db2">VARCHAR(255)</td>
1281 <td class="db3">{image:db_check.gif|16|16}</td>
1282 <td class="db4">&nbsp;</td>
1283 <td class="db5">&nbsp;</td>
1284 <td class="db6">&nbsp;</td>
1285 <td class="db7">&nbsp;</td>
1286 </tr>
1287 <tr>
1288 <td class="db0">{image:db_field.gif|16|16}</td>
1289 <td class="db1">XWV_PAGE_VIEWS</td>
1290 <td class="db2">INTEGER</td>
1291 <td class="db3">&nbsp;</td>
1292 <td class="db4">&nbsp;</td>
1293 <td class="db5">&nbsp;</td>
1294 <td class="db6">null</td>
1295 <td class="db7">&nbsp;</td>
1296 </tr>
1297 <tr>
1298 <td class="db0">{image:db_field.gif|16|16}</td>
1299 <td class="db1">XWV_SAVES</td>
1300 <td class="db2">INTEGER</td>
1301 <td class="db3">&nbsp;</td>
1302 <td class="db4">&nbsp;</td>
1303 <td class="db5">&nbsp;</td>
1304 <td class="db6">null</td>
1305 <td class="db7">&nbsp;</td>
1306 </tr>
1307 <tr>
1308 <td class="db0">{image:db_field.gif|16|16}</td>
1309 <td class="db1">XWV_DOWNLOADS</td>
1310 <td class="db2">INTEGER</td>
1311 <td class="db3">&nbsp;</td>
1312 <td class="db4">&nbsp;</td>
1313 <td class="db5">&nbsp;</td>
1314 <td class="db6">null</td>
1315 <td class="db7">&nbsp;</td>
1316 </tr>
1317 <tr>
1318 <td class="db0">{image:db_field.gif|16|16}</td>
1319 <td class="db1">XWV_START_DATE</td>
1320 <td class="db2">DATETIME</td>
1321 <td class="db3">&nbsp;</td>
1322 <td class="db4">&nbsp;</td>
1323 <td class="db5">&nbsp;</td>
1324 <td class="db6">null</td>
1325 <td class="db7">&nbsp;</td>
1326 </tr>
1327 <tr>
1328 <td class="db0">{image:db_field.gif|16|16}</td>
1329 <td class="db1">XWV_END_DATE</td>
1330 <td class="db2">DATETIME</td>
1331 <td class="db3">&nbsp;</td>
1332 <td class="db4">&nbsp;</td>
1333 <td class="db5">&nbsp;</td>
1334 <td class="db6">null</td>
1335 <td class="db7">&nbsp;</td>
1336 </tr>
1337 </table>
1338
1339 [^ back to top ^>#Tables]
1340 $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