Skip to Content

Wiki source code of DatabaseSchema

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