Skip to Content

Wiki source code of DatabaseSchema

Version 74.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>DevGuide.DsXWikiDates]
26 * [xwikidblistclasses>DevGuide.DsXWikiDatabaseListClasses]
27 * xwikidbversion
28 * [xwikidoc>DevGuide.DsXWikiDoc]
29 * [xwikidoubles>DevGuide.DsXWikiDoubles]
30 * [xwikifloats>DevGuide.DsXWikiFloats]
31 * [xwikiintegers>#XWiki+Integers]
32 * [xwikilargestrings>DevGuide.DsXWikiLargeStrings]
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>DevGuide.DsXWikiNumberClasses]
41 * [xwikiobjects>DevGuide.DsXWikiObjects]
42 * xwikipreferences
43 * [xwikiproperties>DevGuide.DsXWikiProperties]
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>DevGuide.DsXWikiStrings]
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 Integers
59
60 This table contain the data for integer properties in XWiki Objects.
61
62
63 <table border="0" width="100%" class="dbtable" cellpadding="3"
64 cellspacing="0">
65 <tr>
66 <td colspan="8" class="dbhead">xwikiintegers</td>
67 </tr>
68 <tr>
69 <th class="db0">&nbsp;</th>
70 <th class="db1">Column Name</th>
71 <th class="db2">Datatype</th>
72 <th class="db3">Not null</th>
73 <th class="db4">auto inc</th>
74 <th class="db5">flags</th>
75 <th class="db6">Default Value</th>
76 <th class="db7">Comments</th>
77 </tr>
78 <tr>
79 <td class="db0">{image:db_key.gif|16|16}</td>
80 <td class="db1">XWI_ID</td>
81 <td class="db2">INTEGER</td>
82 <td class="db3">{image:db_check.gif|16|16}</td>
83 <td class="db4">&nbsp;</td>
84 <td class="db5">&nbsp;</td>
85 <td class="db6">0</td>
86 <td class="db7">&nbsp;</td>
87 </tr>
88 <tr>
89 <td class="db0">{image:db_key.gif|16|16}</td>
90 <td class="db1">XWI_NAME</td>
91 <td class="db2">VARCHAR(255)</td>
92 <td class="db3">{image:db_check.gif|16|16}</td>
93 <td class="db4">&nbsp;</td>
94 <td class="db5">&nbsp;</td>
95 <td class="db6">&nbsp;</td>
96 <td class="db7">&nbsp;</td>
97 </tr>
98 <tr>
99 <td class="db0">{image:db_field.gif|16|16}</td>
100 <td class="db1">XWI_VALUE</td>
101 <td class="db2">INTEGER</td>
102 <td class="db3">&nbsp;</td>
103 <td class="db4">&nbsp;</td>
104 <td class="db5">&nbsp;</td>
105 <td class="db6">null</td>
106 <td class="db7">&nbsp;</td>
107 </tr>
108 </table>
109
110 [^ back to top ^>#Tables]
111
112 1.1.1 XWiki Longs
113
114 This table contain the data for long properties in XWiki Objects.
115
116 <table border="0" width="100%" class="dbtable" cellpadding="3"
117 cellspacing="0">
118 <tr>
119 <td colspan="8" class="dbhead">xwikilongs</td>
120 </tr>
121 <tr>
122 <th class="db0">&nbsp;</th>
123 <th class="db1">Column Name</th>
124 <th class="db2">Datatype</th>
125 <th class="db3">Not null</th>
126 <th class="db4">auto inc</th>
127 <th class="db5">flags</th>
128 <th class="db6">Default Value</th>
129 <th class="db7">Comments</th>
130 </tr>
131 <tr>
132 <td class="db0">{image:db_key.gif|16|16}</td>
133 <td class="db1">XWL_ID</td>
134 <td class="db2">INTEGER</td>
135 <td class="db3">{image:db_check.gif|16|16}</td>
136 <td class="db4">&nbsp;</td>
137 <td class="db5">&nbsp;</td>
138 <td class="db6">0</td>
139 <td class="db7">&nbsp;</td>
140 </tr>
141 <tr>
142 <td class="db0">{image:db_key.gif|16|16}</td>
143 <td class="db1">XWL_NAME</td>
144 <td class="db2">VARCHAR(255)</td>
145 <td class="db3">{image:db_check.gif|16|16}</td>
146 <td class="db4">&nbsp;</td>
147 <td class="db5">&nbsp;</td>
148 <td class="db6">&nbsp;</td>
149 <td class="db7">&nbsp;</td>
150 </tr>
151 <tr>
152 <td class="db0">{image:db_field.gif|16|16}</td>
153 <td class="db1">XWL_VALUE</td>
154 <td class="db2">BIGINT(20)</td>
155 <td class="db3">&nbsp;</td>
156 <td class="db4">&nbsp;</td>
157 <td class="db5">&nbsp;</td>
158 <td class="db6">null</td>
159 <td class="db7">&nbsp;</td>
160 </tr>
161 </table>
162
163 [^ back to top ^>#Tables]
164
165 1.1.1 XWiki List Items
166
167 This table contain the data for lists properties in XWiki Objects.
168
169 <table border="0" width="100%" class="dbtable" cellpadding="3"
170 cellspacing="0">
171 <tr>
172 <td colspan="8" class="dbhead">xwikilistitems</td>
173 </tr>
174 <tr>
175 <th class="db0">&nbsp;</th>
176 <th class="db1">Column Name</th>
177 <th class="db2">Datatype</th>
178 <th class="db3">Not null</th>
179 <th class="db4">auto inc</th>
180 <th class="db5">flags</th>
181 <th class="db6">Default Value</th>
182 <th class="db7">Comments</th>
183 </tr>
184 <tr>
185 <td class="db0">{image:db_key.gif|16|16}</td>
186 <td class="db1">XWL_ID</td>
187 <td class="db2">INTEGER</td>
188 <td class="db3">{image:db_check.gif|16|16}</td>
189 <td class="db4">&nbsp;</td>
190 <td class="db5">&nbsp;</td>
191 <td class="db6">0</td>
192 <td class="db7">&nbsp;</td>
193 </tr>
194 <tr>
195 <td class="db0">{image:db_key.gif|16|16}</td>
196 <td class="db1">XWL_NAME</td>
197 <td class="db2">VARCHAR(255)</td>
198 <td class="db3">{image:db_check.gif|16|16}</td>
199 <td class="db4">&nbsp;</td>
200 <td class="db5">&nbsp;</td>
201 <td class="db6">&nbsp;</td>
202 <td class="db7">&nbsp;</td>
203 </tr>
204 <tr>
205 <td class="db0">{image:db_field.gif|16|16}</td>
206 <td class="db1">XWL_VALUE</td>
207 <td class="db2">VARCHAR(255)</td>
208 <td class="db3">&nbsp;</td>
209 <td class="db4">&nbsp;</td>
210 <td class="db5">&nbsp;</td>
211 <td class="db6">null</td>
212 <td class="db7">&nbsp;</td>
213 </tr>
214 <tr>
215 <td class="db0">{image:db_key.gif|16|16}</td>
216 <td class="db1">XWL_NUMBER</td>
217 <td class="db2">INTEGER</td>
218 <td class="db3">{image:db_check.gif|16|16}</td>
219 <td class="db4">&nbsp;</td>
220 <td class="db5">&nbsp;</td>
221 <td class="db6">0</td>
222 <td class="db7">&nbsp;</td>
223 </tr>
224 </table>
225
226 [^ back to top ^>#Tables]
227
228 1.1.1 XWiki Lists
229
230 This table contain the data for lists properties in XWiki Objects.
231
232
233 <table border="0" width="100%" class="dbtable" cellpadding="3"
234 cellspacing="0">
235 <tr>
236 <td colspan="8" class="dbhead">xwikilists</td>
237 </tr>
238 <tr>
239 <th class="db0">&nbsp;</th>
240 <th class="db1">Column Name</th>
241 <th class="db2">Datatype</th>
242 <th class="db3">Not null</th>
243 <th class="db4">auto inc</th>
244 <th class="db5">flags</th>
245 <th class="db6">Default Value</th>
246 <th class="db7">Comments</th>
247 </tr>
248 <tr>
249 <td class="db0">{image:db_key.gif|16|16}</td>
250 <td class="db1">XWL_ID</td>
251 <td class="db2">INTEGER</td>
252 <td class="db3">{image:db_check.gif|16|16}</td>
253 <td class="db4">&nbsp;</td>
254 <td class="db5">&nbsp;</td>
255 <td class="db6">0</td>
256 <td class="db7">&nbsp;</td>
257 </tr>
258 <tr>
259 <td class="db0">{image:db_key.gif|16|16}</td>
260 <td class="db1">XWL_NAME</td>
261 <td class="db2">VARCHAR(255)</td>
262 <td class="db3">{image:db_check.gif|16|16}</td>
263 <td class="db4">&nbsp;</td>
264 <td class="db5">&nbsp;</td>
265 <td class="db6">&nbsp;</td>
266 <td class="db7">&nbsp;</td>
267 </tr>
268 </table>
269
270 [^ back to top ^>#Tables]
271
272 1.1 Statistics
273
274 1.1.1 XWiki Document Stats
275
276 This table contain stats information, namely page/space/wiki views and edits
277 .
278 <table border="0" width="100%" class="dbtable" cellpadding="3"
279 cellspacing="0">
280 <tr>
281 <td colspan="8" class="dbhead">xwikistatsdoc</td>
282 </tr>
283 <tr>
284 <th class="db0">&nbsp;</th>
285 <th class="db1">Column Name</th>
286 <th class="db2">Datatype</th>
287 <th class="db3">Not null</th>
288 <th class="db4">auto inc</th>
289 <th class="db5">flags</th>
290 <th class="db6">Default Value</th>
291 <th class="db7">Comments</th>
292 </tr>
293 <tr>
294 <td class="db0">{image:db_key.gif|16|16}</td>
295 <td class="db1">XWS_ID</td>
296 <td class="db2">INTEGER</td>
297 <td class="db3">{image:db_check.gif|16|16}</td>
298 <td class="db4">&nbsp;</td>
299 <td class="db5">&nbsp;</td>
300 <td class="db6">0</td>
301 <td class="db7">&nbsp;</td>
302 </tr>
303 <tr>
304 <td class="db0">{image:db_field.gif|16|16}</td>
305 <td class="db1">XWS_NUMBER</td>
306 <td class="db2">INTEGER</td>
307 <td class="db3">&nbsp;</td>
308 <td class="db4">&nbsp;</td>
309 <td class="db5">&nbsp;</td>
310 <td class="db6">null&nbsp;</td>
311 <td class="db7">&nbsp;</td>
312 </tr>
313 <tr>
314 <td class="db0">{image:db_field.gif|16|16}</td>
315 <td class="db1">XWS_NAME</td>
316 <td class="db2">VARCHAR(255)</td>
317 <td class="db3">{image:db_check.gif|16|16}</td>
318 <td class="db4">&nbsp;</td>
319 <td class="db5">&nbsp;</td>
320 <td class="db6">&nbsp;</td>
321 <td class="db7">&nbsp;</td>
322 </tr>
323 <tr>
324 <td class="db0">{image:db_field.gif|16|16}</td>
325 <td class="db1">XWS_CLASSNAME</td>
326 <td class="db2">VARCHAR(255)</td>
327 <td class="db3">{image:db_check.gif|16|16}</td>
328 <td class="db4">&nbsp;</td>
329 <td class="db5">&nbsp;</td>
330 <td class="db6">&nbsp;</td>
331 <td class="db7">&nbsp;</td>
332 </tr>
333 <tr>
334 <td class="db0">{image:db_field.gif|16|16}</td>
335 <td class="db1">XWS_ACTION</td>
336 <td class="db2">VARCHAR(255)</td>
337 <td class="db3">{image:db_check.gif|16|16}</td>
338 <td class="db4">&nbsp;</td>
339 <td class="db5">&nbsp;</td>
340 <td class="db6">&nbsp;</td>
341 <td class="db7">&nbsp;</td>
342 </tr>
343 <tr>
344 <td class="db0">{image:db_field.gif|16|16}</td>
345 <td class="db1">XWS_PAGE_VIEWS</td>
346 <td class="db2">INTEGER</td>
347 <td class="db3">&nbsp;</td>
348 <td class="db4">&nbsp;</td>
349 <td class="db5">&nbsp;</td>
350 <td class="db6">null</td>
351 <td class="db7">&nbsp;</td>
352 </tr>
353 <tr>
354 <td class="db0">{image:db_field.gif|16|16}</td>
355 <td class="db1">XWS_UNIQUE_VISITORS</td>
356 <td class="db2">INTEGER</td>
357 <td class="db3">&nbsp;</td>
358 <td class="db4">&nbsp;</td>
359 <td class="db5">&nbsp;</td>
360 <td class="db6">null</td>
361 <td class="db7">&nbsp;</td>
362 </tr>
363 <tr>
364 <td class="db0">{image:db_field.gif|16|16}</td>
365 <td class="db1">XWS_PERIOD</td>
366 <td class="db2">INTEGER</td>
367 <td class="db3">&nbsp;</td>
368 <td class="db4">&nbsp;</td>
369 <td class="db5">&nbsp;</td>
370 <td class="db6">null</td>
371 <td class="db7">&nbsp;</td>
372 </tr>
373 <tr>
374 <td class="db0">{image:db_field.gif|16|16}</td>
375 <td class="db1">XWS_VISITS</td>
376 <td class="db2">INTEGER</td>
377 <td class="db3">&nbsp;</td>
378 <td class="db4">&nbsp;</td>
379 <td class="db5">&nbsp;</td>
380 <td class="db6">null</td>
381 <td class="db7">&nbsp;</td>
382 </tr>
383 </table>
384
385 [^ back to top ^>#Tables]
386
387 1.1.1 XWiki Referer Stats
388
389 This page contains the incoming externa links on the Wiki.
390
391 <table border="0" width="100%" class="dbtable" cellpadding="3"
392 cellspacing="0">
393 <tr>
394 <td colspan="8" class="dbhead">xwikistatsreferer</td>
395 </tr>
396 <tr>
397 <th class="db0">&nbsp;</th>
398 <th class="db1">Column Name</th>
399 <th class="db2">Datatype</th>
400 <th class="db3">Not null</th>
401 <th class="db4">auto inc</th>
402 <th class="db5">flags</th>
403 <th class="db6">Default Value</th>
404 <th class="db7">Comments</th>
405 </tr>
406 <tr>
407 <td class="db0">{image:db_key.gif|16|16}</td>
408 <td class="db1">XWR_ID</td>
409 <td class="db2">INTEGER</td>
410 <td class="db3">{image:db_check.gif|16|16}</td>
411 <td class="db4">&nbsp;</td>
412 <td class="db5">&nbsp;</td>
413 <td class="db6">0</td>
414 <td class="db7">&nbsp;</td>
415 </tr>
416 <tr>
417 <td class="db0">{image:db_field.gif|16|16}</td>
418 <td class="db1">XWR_NUMBER</td>
419 <td class="db2">INTEGER</td>
420 <td class="db3">&nbsp;</td>
421 <td class="db4">&nbsp;</td>
422 <td class="db5">&nbsp;</td>
423 <td class="db6">null</td>
424 <td class="db7">&nbsp;</td>
425 </tr>
426 <tr>
427 <td class="db0">{image:db_field.gif|16|16}</td>
428 <td class="db1">XWR_NAME</td>
429 <td class="db2">VARCHAR(255)</td>
430 <td class="db3">{image:db_check.gif|16|16}</td>
431 <td class="db4">&nbsp;</td>
432 <td class="db5">&nbsp;</td>
433 <td class="db6">&nbsp;</td>
434 <td class="db7">&nbsp;</td>
435 </tr>
436 <tr>
437 <td class="db0">{image:db_field.gif|16|16}</td>
438 <td class="db1">XWR_CLASSNAME</td>
439 <td class="db2">VARCHAR(255)</td>
440 <td class="db3">{image:db_check.gif|16|16}</td>
441 <td class="db4">&nbsp;</td>
442 <td class="db5">&nbsp;</td>
443 <td class="db6">&nbsp;</td>
444 <td class="db7">&nbsp;</td>
445 </tr>
446 <tr>
447 <td class="db0">{image:db_field.gif|16|16}</td>
448 <td class="db1">XWR_REFERER</td>
449 <td class="db2">VARCHAR(255)</td>
450 <td class="db3">{image:db_check.gif|16|16}</td>
451 <td class="db4">&nbsp;</td>
452 <td class="db5">&nbsp;</td>
453 <td class="db6">&nbsp;</td>
454 <td class="db7">&nbsp;</td>
455 </tr>
456 <tr>
457 <td class="db0">{image:db_field.gif|16|16}</td>
458 <td class="db1">XWR_PAGE_VIEWS</td>
459 <td class="db2">INTEGER</td>
460 <td class="db3">&nbsp;</td>
461 <td class="db4">&nbsp;</td>
462 <td class="db5">&nbsp;</td>
463 <td class="db6">null</td>
464 <td class="db7">&nbsp;</td>
465 </tr>
466 <tr>
467 <td class="db0">{image:db_field.gif|16|16}</td>
468 <td class="db1">XWR_PERIOD</td>
469 <td class="db2">INTEGER</td>
470 <td class="db3">&nbsp;</td>
471 <td class="db4">&nbsp;</td>
472 <td class="db5">&nbsp;</td>
473 <td class="db6">null</td>
474 <td class="db7">&nbsp;</td>
475 </tr>
476 </table>
477
478 [^ back to top ^>#Tables]
479
480 1.1.1 XWiki Visits
481
482 This table contains the sessions of the named users.
483
484 <table border="0" width="100%" class="dbtable" cellpadding="3"
485 cellspacing="0">
486 <tr>
487 <td colspan="8" class="dbhead">xwikistatsvisit</td>
488 </tr>
489 <tr>
490 <th class="db0">&nbsp;</th>
491 <th class="db1">Column Name</th>
492 <th class="db2">Datatype</th>
493 <th class="db3">Not null</th>
494 <th class="db4">auto inc</th>
495 <th class="db5">flags</th>
496 <th class="db6">Default Value</th>
497 <th class="db7">Comments</th>
498 </tr>
499 <tr>
500 <td class="db0">{image:db_key.gif|16|16}</td>
501 <td class="db1">XWV_ID</td>
502 <td class="db2">INTEGER</td>
503 <td class="db3">{image:db_check.gif|16|16}</td>
504 <td class="db4">&nbsp;</td>
505 <td class="db5">&nbsp;</td>
506 <td class="db6">0</td>
507 <td class="db7">&nbsp;</td>
508 </tr>
509 <tr>
510 <td class="db0">{image:db_field.gif|16|16}</td>
511 <td class="db1">XWV_NUMBER</td>
512 <td class="db2">INTEGER</td>
513 <td class="db3">&nbsp;</td>
514 <td class="db4">&nbsp;</td>
515 <td class="db5">&nbsp;</td>
516 <td class="db6">null&nbsp;</td>
517 <td class="db7">&nbsp;</td>
518 </tr>
519 <tr>
520 <td class="db0">{image:db_field.gif|16|16}</td>
521 <td class="db1">XWV_NAME</td>
522 <td class="db2">VARCHAR(255)</td>
523 <td class="db3">{image:db_check.gif|16|16}</td>
524 <td class="db4">&nbsp;</td>
525 <td class="db5">&nbsp;</td>
526 <td class="db6">&nbsp;</td>
527 <td class="db7">&nbsp;</td>
528 </tr>
529 <tr>
530 <td class="db0">{image:db_field.gif|16|16}</td>
531 <td class="db1">XWV_CLASSNAME</td>
532 <td class="db2">VARCHAR(255)</td>
533 <td class="db3">{image:db_check.gif|16|16}</td>
534 <td class="db4">&nbsp;</td>
535 <td class="db5">&nbsp;</td>
536 <td class="db6">&nbsp;</td>
537 <td class="db7">&nbsp;</td>
538 </tr>
539 <tr>
540 <td class="db0">{image:db_field.gif|16|16}</td>
541 <td class="db1">XWV_IP</td>
542 <td class="db2">VARCHAR(32)</td>
543 <td class="db3">{image:db_check.gif|16|16}</td>
544 <td class="db4">&nbsp;</td>
545 <td class="db5">&nbsp;</td>
546 <td class="db6">&nbsp;</td>
547 <td class="db7">&nbsp;</td>
548 </tr>
549 <tr>
550 <td class="db0">{image:db_field.gif|16|16}</td>
551 <td class="db1">XWV_USER_AGENT</td>
552 <td class="db2">VARCHAR(255)</td>
553 <td class="db3">{image:db_check.gif|16|16}</td>
554 <td class="db4">&nbsp;</td>
555 <td class="db5">&nbsp;</td>
556 <td class="db6">&nbsp;</td>
557 <td class="db7">&nbsp;</td>
558 </tr>
559 <tr>
560 <td class="db0">{image:db_field.gif|16|16}</td>
561 <td class="db1">XWV_COOKIE</td>
562 <td class="db2">VARCHAR(255)</td>
563 <td class="db3">{image:db_check.gif|16|16}</td>
564 <td class="db4">&nbsp;</td>
565 <td class="db5">&nbsp;</td>
566 <td class="db6">&nbsp;</td>
567 <td class="db7">&nbsp;</td>
568 </tr>
569 <tr>
570 <td class="db0">{image:db_field.gif|16|16}</td>
571 <td class="db1">XWV_UNIQUE_ID</td>
572 <td class="db2">VARCHAR(255)</td>
573 <td class="db3">{image:db_check.gif|16|16}</td>
574 <td class="db4">&nbsp;</td>
575 <td class="db5">&nbsp;</td>
576 <td class="db6">&nbsp;</td>
577 <td class="db7">&nbsp;</td>
578 </tr>
579 <tr>
580 <td class="db0">{image:db_field.gif|16|16}</td>
581 <td class="db1">XWV_PAGE_VIEWS</td>
582 <td class="db2">INTEGER</td>
583 <td class="db3">&nbsp;</td>
584 <td class="db4">&nbsp;</td>
585 <td class="db5">&nbsp;</td>
586 <td class="db6">null</td>
587 <td class="db7">&nbsp;</td>
588 </tr>
589 <tr>
590 <td class="db0">{image:db_field.gif|16|16}</td>
591 <td class="db1">XWV_SAVES</td>
592 <td class="db2">INTEGER</td>
593 <td class="db3">&nbsp;</td>
594 <td class="db4">&nbsp;</td>
595 <td class="db5">&nbsp;</td>
596 <td class="db6">null</td>
597 <td class="db7">&nbsp;</td>
598 </tr>
599 <tr>
600 <td class="db0">{image:db_field.gif|16|16}</td>
601 <td class="db1">XWV_DOWNLOADS</td>
602 <td class="db2">INTEGER</td>
603 <td class="db3">&nbsp;</td>
604 <td class="db4">&nbsp;</td>
605 <td class="db5">&nbsp;</td>
606 <td class="db6">null</td>
607 <td class="db7">&nbsp;</td>
608 </tr>
609 <tr>
610 <td class="db0">{image:db_field.gif|16|16}</td>
611 <td class="db1">XWV_START_DATE</td>
612 <td class="db2">DATETIME</td>
613 <td class="db3">&nbsp;</td>
614 <td class="db4">&nbsp;</td>
615 <td class="db5">&nbsp;</td>
616 <td class="db6">null</td>
617 <td class="db7">&nbsp;</td>
618 </tr>
619 <tr>
620 <td class="db0">{image:db_field.gif|16|16}</td>
621 <td class="db1">XWV_END_DATE</td>
622 <td class="db2">DATETIME</td>
623 <td class="db3">&nbsp;</td>
624 <td class="db4">&nbsp;</td>
625 <td class="db5">&nbsp;</td>
626 <td class="db6">null</td>
627 <td class="db7">&nbsp;</td>
628 </tr>
629 </table>
630
631 [^ back to top ^>#Tables]
632 1.1.1 XWiki List Classes
633
634 This table contains the declaration of the list properties in XWiki classes.
635
636 <table border="0" width="100%" class="dbtable" cellpadding="3"
637 cellspacing="0">
638 <tr>
639 <td colspan="8" class="dbhead">xwikislistclasses</td>
640 </tr>
641 <tr>
642 <th class="db0">&nbsp;</th>
643 <th class="db1">Column Name</th>
644 <th class="db2">Datatype</th>
645 <th class="db3">Not null</th>
646 <th class="db4">auto inc</th>
647 <th class="db5">flags</th>
648 <th class="db6">Default Value</th>
649 <th class="db7">Comments</th>
650 </tr>
651 <tr>
652 <td class="db0">{image:db_key.gif|16|16}</td>
653 <td class="db1">XWL_ID</td>
654 <td class="db2">INTEGER</td>
655 <td class="db3">{image:db_check.gif|16|16}</td>
656 <td class="db4">&nbsp;</td>
657 <td class="db5">&nbsp;</td>
658 <td class="db6">0</td>
659 <td class="db7">&nbsp;</td>
660 </tr>
661 <tr>
662 <td class="db0">{image:db_key.gif|16|16}</td>
663 <td class="db1">XWL_NAME</td>
664 <td class="db2">VARCHAR(255)</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">&nbsp;</td>
669 <td class="db7">&nbsp;</td>
670 </tr>
671 <tr>
672 <td class="db0">{image:db_field.gif|16|16}</td>
673 <td class="db1">XWL_DISPLAYTYPE</td>
674 <td class="db2">VARCHAR(20)</td>
675 <td class="db3">&nbsp;</td>
676 <td class="db4">&nbsp;</td>
677 <td class="db5">&nbsp;</td>
678 <td class="db6">null</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_MULTISELECT</td>
684 <td class="db2">TINYINT(1)</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_SIZE</td>
694 <td class="db2">INTEGER</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_RELATIONAL</td>
704 <td class="db2">TINYINT(1)</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_VALUES</td>
714 <td class="db2">TEXT</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 </table>
722
723 [^ back to top ^>#Tables]
724 $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