Version 3.1 by Manuel Smeria on 2013/02/22

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

Get Connected