Version 2.1 by Helmut Nagy on 2009/02/13

Show last authors
1
2 <style>
3 td, th {border-bottom:1px solid #666}
4 table.dbtable{border:1px solid #666;border-bottom:0px}
5 th {background-color:#EFEFEF}
6 .db0{width:1%;border-right:1px solid #666;}
7 .db1{width:25%;border-right:1px solid #666}
8 .db2{width:10%;border-right:1px solid #666}
9 .db3{width:7%;border-right:1px solid #666}
10 .db4{width:7%;border-right:1px solid #666}
11 .db5{width:10%;border-right:1px solid #666}
12 .db6{width:20%;border-right:1px solid #666}
13 .db7{width:20%}
14 .dbhead{background-color:#CCC;font-weight:bold}
15 </style>
16
17 1.1 XWiki Preferences (xwikipreferences)
18
19 This table contains the xwiki preferences.
20
21 <table border="0" width="100%" class="dbtable" cellpadding="3"
22 cellspacing="0">
23 <tr>
24 <td colspan="8" class="dbhead">xwikipreferences</td>
25 </tr>
26 <tr>
27 <th class="db0">&nbsp;</th>
28 <th class="db1">Column Name</th>
29 <th class="db2">Datatype</th>
30 <th class="db3">Not null</th>
31 <th class="db4">auto inc</th>
32 <th class="db5">flags</th>
33 <th class="db6">Default Value</th>
34 <th class="db7">Comments</th>
35 </tr>
36 <tr>
37 <td class="db0">{image:db_key.gif|16|16|document=DevGuide.DatabaseSchema}</td>
38 <td class="db1">XWP_ID</td>
39 <td class="db2">INTEGER</td>
40 <td class="db3">{image:db_check.gif|16|16|document=DevGuide.DatabaseSchema}</td>
41 <td class="db4">&nbsp;</td>
42 <td class="db5">&nbsp;</td>
43 <td class="db6">0</td>
44 <td class="db7">&nbsp;</td>
45 </tr>
46 <tr>
47 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
48 <td class="db1">XWP_LANGUAGE</td>
49 <td class="db2">VARCHAR(255)</td>
50 <td class="db3">&nbsp;</td>
51 <td class="db4">&nbsp;</td>
52 <td class="db5">&nbsp;</td>
53 <td class="db6">null</td>
54 <td class="db7">&nbsp;</td>
55 </tr>
56 <tr>
57 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
58 <td class="db1">XWP_DEFAULT_LANGUAGE</td>
59 <td class="db2">VARCHAR(255)</td>
60 <td class="db3">&nbsp;</td>
61 <td class="db4">&nbsp;</td>
62 <td class="db5">&nbsp;</td>
63 <td class="db6">null</td>
64 <td class="db7">&nbsp;</td>
65 </tr>
66 <tr>
67 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
68 <td class="db1">XWP_MULTI_LINGUAL</td>
69 <td class="db2">INTEGER</td>
70 <td class="db3">&nbsp;</td>
71 <td class="db4">&nbsp;</td>
72 <td class="db5">&nbsp;</td>
73 <td class="db6">0</td>
74 <td class="db7">&nbsp;</td>
75 </tr>
76 <tr>
77 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
78 <td class="db1">XWP_AUTHENTICATE_EDIT</td>
79 <td class="db2">INTEGER</td>
80 <td class="db3">&nbsp;</td>
81 <td class="db4">&nbsp;</td>
82 <td class="db5">&nbsp;</td>
83 <td class="db6">0</td>
84 <td class="db7">&nbsp;</td>
85 </tr>
86 <tr>
87 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
88 <td class="db1">XWP_AUTHENTICATE_VIEW</td>
89 <td class="db2">INTEGER</td>
90 <td class="db3">&nbsp;</td>
91 <td class="db4">&nbsp;</td>
92 <td class="db5">&nbsp;</td>
93 <td class="db6">0</td>
94 <td class="db7">&nbsp;</td>
95 </tr>
96 <tr>
97 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
98 <td class="db1">XWP_AUTH_ACTIVE_CHECK</td>
99 <td class="db2">INTEGER</td>
100 <td class="db3">&nbsp;</td>
101 <td class="db4">&nbsp;</td>
102 <td class="db5">&nbsp;</td>
103 <td class="db6">0</td>
104 <td class="db7">&nbsp;</td>
105 </tr>
106 <tr>
107 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
108 <td class="db1">XWP_BACKLINKS</td>
109 <td class="db2">INTEGER</td>
110 <td class="db3">&nbsp;</td>
111 <td class="db4">&nbsp;</td>
112 <td class="db5">&nbsp;</td>
113 <td class="db6">0</td>
114 <td class="db7">&nbsp;</td>
115 </tr>
116 <tr>
117 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
118 <td class="db1">XWP_SKIN</td>
119 <td class="db2">VARCHAR(255)</td>
120 <td class="db3">&nbsp;</td>
121 <td class="db4">&nbsp;</td>
122 <td class="db5">&nbsp;</td>
123 <td class="db6">null</td>
124 <td class="db7">&nbsp;</td>
125 </tr>
126 <tr>
127 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
128 <td class="db1">XWP_STYLESHEET</td>
129 <td class="db2">VARCHAR(255)</td>
130 <td class="db3">&nbsp;</td>
131 <td class="db4">&nbsp;</td>
132 <td class="db5">&nbsp;</td>
133 <td class="db6">null</td>
134 <td class="db7">&nbsp;</td>
135 </tr>
136 <tr>
137 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
138 <td class="db1">XWP_STYLESHEETS</td>
139 <td class="db2">VARCHAR(255)</td>
140 <td class="db3">&nbsp;</td>
141 <td class="db4">&nbsp;</td>
142 <td class="db5">&nbsp;</td>
143 <td class="db6">null</td>
144 <td class="db7">&nbsp;</td>
145 </tr>
146 <tr>
147 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
148 <td class="db1">XWP_EDITOR</td>
149 <td class="db2">VARCHAR(255)</td>
150 <td class="db3">&nbsp;</td>
151 <td class="db4">&nbsp;</td>
152 <td class="db5">&nbsp;</td>
153 <td class="db6">null</td>
154 <td class="db7">&nbsp;</td>
155 </tr>
156 <tr>
157 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
158 <td class="db1">XWP_EDITBOX_WIDTH</td>
159 <td class="db2">VARCHAR(255)</td>
160 <td class="db3">&nbsp;</td>
161 <td class="db4">&nbsp;</td>
162 <td class="db5">&nbsp;</td>
163 <td class="db6">null</td>
164 <td class="db7">&nbsp;</td>
165 </tr>
166 <tr>
167 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
168 <td class="db1">XWP_EDITBOX_HEIGHT</td>
169 <td class="db2">VARCHAR(255)</td>
170 <td class="db3">&nbsp;</td>
171 <td class="db4">&nbsp;</td>
172 <td class="db5">&nbsp;</td>
173 <td class="db6">null</td>
174 <td class="db7">&nbsp;</td>
175 </tr>
176 <tr>
177 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
178 <td class="db1">XWP_WEBCOPYRIGHT</td>
179 <td class="db2">VARCHAR(255)</td>
180 <td class="db3">&nbsp;</td>
181 <td class="db4">&nbsp;</td>
182 <td class="db5">&nbsp;</td>
183 <td class="db6">null</td>
184 <td class="db7">&nbsp;</td>
185 </tr>
186 <tr>
187 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
188 <td class="db1">XWP_TITLE</td>
189 <td class="db2">VARCHAR(255)</td>
190 <td class="db3">&nbsp;</td>
191 <td class="db4">&nbsp;</td>
192 <td class="db5">&nbsp;</td>
193 <td class="db6">null</td>
194 <td class="db7">&nbsp;</td>
195 </tr>
196 <tr>
197 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
198 <td class="db1">XWP_VERSION</td>
199 <td class="db2">VARCHAR(255)</td>
200 <td class="db3">&nbsp;</td>
201 <td class="db4">&nbsp;</td>
202 <td class="db5">&nbsp;</td>
203 <td class="db6">null</td>
204 <td class="db7">&nbsp;</td>
205 </tr>
206 <tr>
207 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
208 <td class="db1">XWP_MENU</td>
209 <td class="db2">TEXT</td>
210 <td class="db3">&nbsp;</td>
211 <td class="db4">&nbsp;</td>
212 <td class="db5">&nbsp;</td>
213 <td class="db6">null</td>
214 <td class="db7">&nbsp;</td>
215 </tr>
216 <tr>
217 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
218 <td class="db1">XWP_META</td>
219 <td class="db2">TEXT</td>
220 <td class="db3">&nbsp;</td>
221 <td class="db4">&nbsp;</td>
222 <td class="db5">&nbsp;</td>
223 <td class="db6">null</td>
224 <td class="db7">&nbsp;</td>
225 </tr>
226 <tr>
227 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
228 <td class="db1">XWP_USE_EMAIL_VERIFICATION</td>
229 <td class="db2">INTEGER</td>
230 <td class="db3">&nbsp;</td>
231 <td class="db4">&nbsp;</td>
232 <td class="db5">&nbsp;</td>
233 <td class="db6">0</td>
234 <td class="db7">&nbsp;</td>
235 </tr>
236 <tr>
237 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
238 <td class="db1">XWP_SMTP_SERVER</td>
239 <td class="db2">VARCHAR(255)</td>
240 <td class="db3">&nbsp;</td>
241 <td class="db4">&nbsp;</td>
242 <td class="db5">&nbsp;</td>
243 <td class="db6">null</td>
244 <td class="db7">&nbsp;</td>
245 </tr>
246 <tr>
247 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
248 <td class="db1">XWP_ADMIN_EMAIL</td>
249 <td class="db2">VARCHAR(255)</td>
250 <td class="db3">&nbsp;</td>
251 <td class="db4">&nbsp;</td>
252 <td class="db5">&nbsp;</td>
253 <td class="db6">null</td>
254 <td class="db7">&nbsp;</td>
255 </tr>
256 <tr>
257 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
258 <td class="db1">XWP_VALIDATION_EMAIL_CONTENT</td>
259 <td class="db2">TEXT</td>
260 <td class="db3">&nbsp;</td>
261 <td class="db4">&nbsp;</td>
262 <td class="db5">&nbsp;</td>
263 <td class="db6">null</td>
264 <td class="db7">&nbsp;</td>
265 </tr>
266 <tr>
267 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
268 <td class="db1">XWP_CONFIRMATION_EMAIL_CONTENT</td>
269 <td class="db2">TEXT</td>
270 <td class="db3">&nbsp;</td>
271 <td class="db4">&nbsp;</td>
272 <td class="db5">&nbsp;</td>
273 <td class="db6">null</td>
274 <td class="db7">&nbsp;</td>
275 </tr>
276 <tr>
277 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
278 <td class="db1">XWP_INVITATION_EMAIL_CONTENT</td>
279 <td class="db2">TEXT</td>
280 <td class="db3">&nbsp;</td>
281 <td class="db4">&nbsp;</td>
282 <td class="db5">&nbsp;</td>
283 <td class="db6">null</td>
284 <td class="db7">&nbsp;</td>
285 </tr>
286 <tr>
287 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
288 <td class="db1">XWP_MACROS_LANGUAGE</td>
289 <td class="db2">VARCHAR(255)</td>
290 <td class="db3">&nbsp;</td>
291 <td class="db4">&nbsp;</td>
292 <td class="db5">&nbsp;</td>
293 <td class="db6">null</td>
294 <td class="db7">&nbsp;</td>
295 </tr>
296 <tr>
297 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
298 <td class="db1">XWP_MACROS_VELOCITY</td>
299 <td class="db2">VARCHAR(255)</td>
300 <td class="db3">&nbsp;</td>
301 <td class="db4">&nbsp;</td>
302 <td class="db5">&nbsp;</td>
303 <td class="db6">null</td>
304 <td class="db7">&nbsp;</td>
305 </tr>
306 <tr>
307 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
308 <td class="db1">XWP_MACROS_GROOVY</td>
309 <td class="db2">VARCHAR(255)</td>
310 <td class="db3">&nbsp;</td>
311 <td class="db4">&nbsp;</td>
312 <td class="db5">&nbsp;</td>
313 <td class="db6">null</td>
314 <td class="db7">&nbsp;</td>
315 </tr>
316 <tr>
317 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
318 <td class="db1">XWP_MACROS_XWIKI2</td>
319 <td class="db2">VARCHAR(255)</td>
320 <td class="db3">&nbsp;</td>
321 <td class="db4">&nbsp;</td>
322 <td class="db5">&nbsp;</td>
323 <td class="db6">null</td>
324 <td class="db7">&nbsp;</td>
325 </tr>
326 <tr>
327 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
328 <td class="db1">XWP_MACROS_MAPPING</td>
329 <td class="db2">TEXT</td>
330 <td class="db3">&nbsp;</td>
331 <td class="db4">&nbsp;</td>
332 <td class="db5">&nbsp;</td>
333 <td class="db6">null</td>
334 <td class="db7">&nbsp;</td>
335 </tr>
336 <tr>
337 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
338 <td class="db1">XWP_NOTIFICATION_PAGES</td>
339 <td class="db2">VARCHAR(255)</td>
340 <td class="db3">&nbsp;</td>
341 <td class="db4">&nbsp;</td>
342 <td class="db5">&nbsp;</td>
343 <td class="db6">null</td>
344 <td class="db7">&nbsp;</td>
345 </tr>
346 <tr>
347 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
348 <td class="db1">XWP_LEFT_PANELS</td>
349 <td class="db2">TEXT</td>
350 <td class="db3">&nbsp;</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|document=DevGuide.DatabaseSchema}</td>
358 <td class="db1">XWP_RIGHT_PANELS</td>
359 <td class="db2">TEXT</td>
360 <td class="db3">&nbsp;</td>
361 <td class="db4">&nbsp;</td>
362 <td class="db5">&nbsp;</td>
363 <td class="db6">null</td>
364 <td class="db7">&nbsp;</td>
365 </tr>
366 <tr>
367 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
368 <td class="db1">XWP_SHOW_LEFT_PANELS</td>
369 <td class="db2">INTEGER</td>
370 <td class="db3">&nbsp;</td>
371 <td class="db4">&nbsp;</td>
372 <td class="db5">&nbsp;</td>
373 <td class="db6">0</td>
374 <td class="db7">&nbsp;</td>
375 </tr>
376 <tr>
377 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
378 <td class="db1">XWP_SHOW_RIGHT_PANELS</td>
379 <td class="db2">INTEGER</td>
380 <td class="db3">&nbsp;</td>
381 <td class="db4">&nbsp;</td>
382 <td class="db5">&nbsp;</td>
383 <td class="db6">0</td>
384 <td class="db7">&nbsp;</td>
385 </tr>
386 <tr>
387 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
388 <td class="db1">XWP_PAGE_WIDTH</td>
389 <td class="db2">VARCHAR(255)</td>
390 <td class="db3">&nbsp;</td>
391 <td class="db4">&nbsp;</td>
392 <td class="db5">&nbsp;</td>
393 <td class="db6">null</td>
394 <td class="db7">&nbsp;</td>
395 </tr>
396 <tr>
397 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
398 <td class="db1">XWP_LANGUAGES</td>
399 <td class="db2">VARCHAR(255)</td>
400 <td class="db3">&nbsp;</td>
401 <td class="db4">&nbsp;</td>
402 <td class="db5">&nbsp;</td>
403 <td class="db6">null</td>
404 <td class="db7">&nbsp;</td>
405 </tr>
406 <tr>
407 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
408 <td class="db1">XWP_REGISTRATION_ANONYMOUS</td>
409 <td class="db2">VARCHAR(255)</td>
410 <td class="db3">&nbsp;</td>
411 <td class="db4">&nbsp;</td>
412 <td class="db5">&nbsp;</td>
413 <td class="db6">null</td>
414 <td class="db7">&nbsp;</td>
415 </tr>
416 <tr>
417 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
418 <td class="db1">XWP_REGISTRATION_REGISTERED</td>
419 <td class="db2">VARCHAR(255)</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|document=DevGuide.DatabaseSchema}</td>
428 <td class="db1">XWP_EDIT_ANONYMOUS</td>
429 <td class="db2">VARCHAR(255)</td>
430 <td class="db3">&nbsp;</td>
431 <td class="db4">&nbsp;</td>
432 <td class="db5">&nbsp;</td>
433 <td class="db6">null</td>
434 <td class="db7">&nbsp;</td>
435 </tr>
436 <tr>
437 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
438 <td class="db1">XWP_EDIT_REGISTERED</td>
439 <td class="db2">VARCHAR(255)</td>
440 <td class="db3">&nbsp;</td>
441 <td class="db4">&nbsp;</td>
442 <td class="db5">&nbsp;</td>
443 <td class="db6">null</td>
444 <td class="db7">&nbsp;</td>
445 </tr>
446 <tr>
447 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
448 <td class="db1">XWP_COMMENT_ANONYMOUS</td>
449 <td class="db2">VARCHAR(255)</td>
450 <td class="db3">&nbsp;</td>
451 <td class="db4">&nbsp;</td>
452 <td class="db5">&nbsp;</td>
453 <td class="db6">null</td>
454 <td class="db7">&nbsp;</td>
455 </tr>
456 <tr>
457 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
458 <td class="db1">XWP_COMMENT_REGISTERED</td>
459 <td class="db2">VARCHAR(255)</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|document=DevGuide.DatabaseSchema}</td>
468 <td class="db1">XWP_DOCUMENT_BUNDLES</td>
469 <td class="db2">VARCHAR(255)</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>

Get Connected