Wiki source code of DatabaseSchema

Version 62.1 by Helmut Nagy on 2009/02/12

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

Get Connected