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