Skip to Content

Wiki source code of XWiki Documents (xwikidoc)

Version 8.1 by Helmut Nagy on 2009/02/12
Hide last authors
Helmut Nagy 1.1 1 <style>
2 td, th {border-bottom:1px solid #666}
3 table.dbtable{border:1px solid #666;border-bottom:0px}
4 th {background-color:#EFEFEF}
5 .db0{width:1%;border-right:1px solid #666;}
6 .db1{width:25%;border-right:1px solid #666}
7 .db2{width:10%;border-right:1px solid #666}
8 .db3{width:7%;border-right:1px solid #666}
9 .db4{width:7%;border-right:1px solid #666}
10 .db5{width:10%;border-right:1px solid #666}
11 .db6{width:20%;border-right:1px solid #666}
12 .db7{width:20%}
13 .dbhead{background-color:#CCC;font-weight:bold}
14 </style>
15
16 1.1 XWiki Documents (xwikidoc)
17
18 This table contains information about XWiki Documents. This is the main table.
19
20 XWiki documents are identified by ~~XWD_WEB~~ and ~~XWD_NAME~~ (see the user guide for more information about this). But for a given URL (with a unique ~~XWD_WEB~~ and ~~XWD_NAME~~), you may find different XWiki documents because some offshoots of the original document called translations may have been added and they have been tagged with their own specific language code (e.g., "en" for English, "fr" for French). Hence, there are 2 kinds of documents in XWiki and you can think of them as 1) "regular" or "main" documents and 2) "translations" (of "main" documents). The first kind has a value of 0 in the ~~XWD_TRANSLATION~~ field whereas the second kind has a value of 1. If you look at the database, there should exist at most one document for each ~~XWD_WEB~~ and ~~XWD_NAME~~ combination that comes with a value of 0 for the ~~XWD_TRANSLATION~~ attribute. All the other documents bearing the same ~~XWD_WEB~~ and ~~XWD_NAME~~ attribute values will have a value of 1 for the ~~XWD_TRANSLATION~~ attribute. Of course, in practice the user doesn't have to worry about that as she would use XWiki's interface to add or remove translations and original documents. But there have been situations in which the database gets corrupted and as a result you could see 2 documents with the same values for ~~XWD_WEB~~, ~~XWD_NAME~~ and ~~XWD_LANGUAGE~~ (e.g., in practice 2 "en" buttons appear on the web page and you can only access one of these translation documents from the interface, the other one is masked). If that happens to you, remove the document bearing a 1 in ~~XWD_TRANSLATION~~ to fix the database (or tag it as another language, "it" for example).
21
22 <table border="0" width="100%" class="dbtable" cellpadding="3"
23 cellspacing="0">
24 <tr>
25 <td colspan="8" class="dbhead">xwikidoc</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>
Helmut Nagy 5.1 38 <td class="db0">{image:db_key.gif|16|16|document=DevGuide.DatabaseSchema}</td>
Helmut Nagy 1.1 39 <td class="db1">XWD_ID</td>
40 <td class="db2">BIGINT(20)</td>
Helmut Nagy 6.1 41 <td class="db3">{image:db_check.gif|16|16|document=DevGuide.DatabaseSchema}</td>
Helmut Nagy 1.1 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>
Helmut Nagy 6.1 48 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
Helmut Nagy 1.1 49 <td class="db1">XWD_FULLNAME</td>
50 <td class="db2">VARCHAR(255)</td>
Helmut Nagy 6.1 51 <td class="db3">{image:db_check.gif|16|16|document=DevGuide.DatabaseSchema}</td>
Helmut Nagy 1.1 52 <td class="db4">&nbsp;</td>
53 <td class="db5">&nbsp;</td>
54 <td class="db6">&nbsp;</td>
55 <td class="db7">&nbsp;</td>
56 </tr>
57 <tr>
Helmut Nagy 6.1 58 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
Helmut Nagy 1.1 59 <td class="db1">XWD_NAME</td>
60 <td class="db2">VARCHAR(255)</td>
Helmut Nagy 7.1 61 <td class="db3">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
Helmut Nagy 1.1 62 <td class="db4">&nbsp;</td>
63 <td class="db5">&nbsp;</td>
Helmut Nagy 8.1 64 <td class="db6">&nbsp;</td>
Helmut Nagy 1.1 65 <td class="db7">&nbsp;</td>
66 </tr>
67 <tr>
Helmut Nagy 6.1 68 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
Helmut Nagy 3.1 69 <td class="db1">XWD_TITLE</td>
70 <td class="db2">VARCHAR(255)</td>
Helmut Nagy 7.1 71 <td class="db3">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
Helmut Nagy 3.1 72 <td class="db4">&nbsp;</td>
73 <td class="db5">&nbsp;</td>
Helmut Nagy 7.1 74 <td class="db6">&nbsp;</td>
Helmut Nagy 3.1 75 <td class="db7">&nbsp;</td>
76 </tr>
77 <tr>
Helmut Nagy 6.1 78 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
Helmut Nagy 1.1 79 <td class="db1">XWD_LANGUAGE</td>
80 <td class="db2">VARCHAR(5)</td>
81 <td class="db3">&nbsp;</td>
82 <td class="db4">&nbsp;</td>
83 <td class="db5">&nbsp;</td>
84 <td class="db6">null</td>
85 <td class="db7">&nbsp;</td>
86 </tr>
87 <tr>
Helmut Nagy 6.1 88 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
Helmut Nagy 1.1 89 <td class="db1">XWD_DEFAULT_LANGUAGE</td>
90 <td class="db2">VARCHAR(5)</td>
91 <td class="db3">&nbsp;</td>
92 <td class="db4">&nbsp;</td>
93 <td class="db5">&nbsp;</td>
94 <td class="db6">null</td>
95 <td class="db7">&nbsp;</td>
96 </tr>
97 <tr>
Helmut Nagy 6.1 98 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
Helmut Nagy 1.1 99 <td class="db1">XWD_TRANSLATION</td>
100 <td class="db2">INTEGER</td>
Helmut Nagy 6.1 101 <td class="db3">{image:db_check.gif|16|16|document=DevGuide.DatabaseSchema}</td>
Helmut Nagy 1.1 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>
Helmut Nagy 6.1 108 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
Helmut Nagy 1.1 109 <td class="db1">XWD_DATE</td>
110 <td class="db2">DATETIME</td>
Helmut Nagy 6.1 111 <td class="db3">{image:db_check.gif|16|16|document=DevGuide.DatabaseSchema}</td>
Helmut Nagy 1.1 112 <td class="db4">&nbsp;</td>
113 <td class="db5">&nbsp;</td>
114 <td class="db6">0000-00-00 00:00:00</td>
115 <td class="db7">&nbsp;</td>
116 </tr>
117 <tr>
Helmut Nagy 6.1 118 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
Helmut Nagy 4.1 119 <td class="db1">XWD_CONTENT_UPDATE_DATE</td>
120 <td class="db2">DATETIME</td>
Helmut Nagy 6.1 121 <td class="db3">{image:db_check.gif|16|16|document=DevGuide.DatabaseSchema}</td>
Helmut Nagy 4.1 122 <td class="db4">&nbsp;</td>
123 <td class="db5">&nbsp;</td>
124 <td class="db6">0000-00-00 00:00:00</td>
125 <td class="db7">&nbsp;</td>
126 </tr>
127 <tr>
Helmut Nagy 6.1 128 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
Helmut Nagy 1.1 129 <td class="db1">XWD_CREATION_DATE</td>
130 <td class="db2">DATETIME</td>
131 <td class="db3">&nbsp;</td>
132 <td class="db4">&nbsp;</td>
133 <td class="db5">&nbsp;</td>
Helmut Nagy 7.1 134 <td class="db6">0000-00-00 00:00:00</td>
Helmut Nagy 1.1 135 <td class="db7">&nbsp;</td>
136 </tr>
137 <tr>
Helmut Nagy 6.1 138 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
Helmut Nagy 1.1 139 <td class="db1">XWD_AUTHOR</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>
Helmut Nagy 7.1 144 <td class="db6">&nbsp;</td>
Helmut Nagy 1.1 145 <td class="db7">&nbsp;</td>
146 </tr>
147 <tr>
Helmut Nagy 6.1 148 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
Helmut Nagy 4.1 149 <td class="db1">XWD_CONTENT_AUTHOR</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>
Helmut Nagy 7.1 154 <td class="db6">&nbsp:</td>
Helmut Nagy 4.1 155 <td class="db7">&nbsp;</td>
156 </tr>
157 <tr>
Helmut Nagy 6.1 158 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
Helmut Nagy 1.1 159 <td class="db1">XWD_CREATOR</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>
Helmut Nagy 7.1 164 <td class="db6">&nbsp;</td>
Helmut Nagy 1.1 165 <td class="db7">&nbsp;</td>
166 </tr>
167 <tr>
Helmut Nagy 6.1 168 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
Helmut Nagy 1.1 169 <td class="db1">XWD_WEB</td>
170 <td class="db2">VARCHAR(255)</td>
Helmut Nagy 6.1 171 <td class="db3">{image:db_check.gif|16|16|document=DevGuide.DatabaseSchema}</td>
Helmut Nagy 1.1 172 <td class="db4">&nbsp;</td>
173 <td class="db5">&nbsp;</td>
Helmut Nagy 7.1 174 <td class="db6">&nbsp;</td>
Helmut Nagy 1.1 175 <td class="db7">&nbsp;</td>
176 </tr>
177 <tr>
Helmut Nagy 6.1 178 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
Helmut Nagy 1.1 179 <td class="db1">XWD_CONTENT</td>
180 <td class="db2">MEDIUMTEXT</td>
Helmut Nagy 6.1 181 <td class="db3">{image:db_check.gif|16|16|document=DevGuide.DatabaseSchema}</td>
Helmut Nagy 1.1 182 <td class="db4">&nbsp;</td>
183 <td class="db5">&nbsp;</td>
184 <td class="db6">&nbsp;</td>
185 <td class="db7">&nbsp;</td>
186 </tr>
187 <tr>
Helmut Nagy 6.1 188 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
Helmut Nagy 4.1 189 <td class="db1">XWD_VERSION</td>
190 <td class="db2">VARCHAR(255)</td>
Helmut Nagy 6.1 191 <td class="db3">{image:db_check.gif|16|16|document=DevGuide.DatabaseSchema}</td>
Helmut Nagy 1.1 192 <td class="db4">&nbsp;</td>
193 <td class="db5">&nbsp;</td>
Helmut Nagy 7.1 194 <td class="db6">&nbsp;</td>
Helmut Nagy 1.1 195 <td class="db7">&nbsp;</td>
196 </tr>
197 <tr>
Helmut Nagy 6.1 198 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
Helmut Nagy 4.1 199 <td class="db1">XWD_CUSTOM_CLASS</td>
Helmut Nagy 1.1 200 <td class="db2">VARCHAR(255)</td>
Helmut Nagy 6.1 201 <td class="db3">{image:db_check.gif|16|16|document=DevGuide.DatabaseSchema}</td>
Helmut Nagy 1.1 202 <td class="db4">&nbsp;</td>
203 <td class="db5">&nbsp;</td>
Helmut Nagy 7.1 204 <td class="db6">&nbsp;</td>
Helmut Nagy 1.1 205 <td class="db7">&nbsp;</td>
206 </tr>
207 <tr>
Helmut Nagy 6.1 208 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
Helmut Nagy 1.1 209 <td class="db1">XWD_PARENT</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>
Helmut Nagy 7.1 214 <td class="db6">&nbsp;</td>
Helmut Nagy 1.1 215 <td class="db7">&nbsp;</td>
216 </tr>
Helmut Nagy 4.1 217 <tr>
Helmut Nagy 6.1 218 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
Helmut Nagy 4.1 219 <td class="db1">XWD_CLASS_XML</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>
Helmut Nagy 7.1 224 <td class="db6">null</td>
Helmut Nagy 4.1 225 <td class="db7">&nbsp;</td>
226 </tr>
227 <tr>
Helmut Nagy 6.1 228 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
Helmut Nagy 4.1 229 <td class="db1">XWD_ELEMENTS</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>
Helmut Nagy 7.1 234 <td class="db6">null</td>
Helmut Nagy 4.1 235 <td class="db7">&nbsp;</td>
236 </tr>
237 <tr>
Helmut Nagy 6.1 238 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
Helmut Nagy 4.1 239 <td class="db1">XWD_DEFAULT_TEMPLATE</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>
Helmut Nagy 7.1 244 <td class="db6">&nbsp</td>
Helmut Nagy 4.1 245 <td class="db7">&nbsp;</td>
246 </tr>
247 <tr>
Helmut Nagy 6.1 248 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
Helmut Nagy 4.1 249 <td class="db1">XWD_VALIDATION_SCRIPT</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>
Helmut Nagy 7.1 254 <td class="db6">&nbsp;</td>
Helmut Nagy 4.1 255 <td class="db7">&nbsp;</td>
256 </tr>
257 <tr>
Helmut Nagy 6.1 258 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
Helmut Nagy 4.1 259 <td class="db1">XWD_COMMENT</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>
Helmut Nagy 7.1 264 <td class="db6">&nbsp;</td>
Helmut Nagy 4.1 265 <td class="db7">&nbsp;</td>
266 </tr>
267 <tr>
Helmut Nagy 6.1 268 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
Helmut Nagy 4.1 269 <td class="db1">XWD_MINOREDIT</td>
270 <td class="db2">BIT</td>
271 <td class="db3">&nbsp;</td>
272 <td class="db4">&nbsp;</td>
273 <td class="db5">&nbsp;</td>
Helmut Nagy 7.1 274 <td class="db6">&nbsp;</td>
Helmut Nagy 4.1 275 <td class="db7">&nbsp;</td>
276 </tr>
277 <tr>
Helmut Nagy 6.1 278 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
Helmut Nagy 4.1 279 <td class="db1">XWD_SYNTAX_ID</td>
280 <td class="db2">VARCHAR(50)</td>
281 <td class="db3">&nbsp;</td>
282 <td class="db4">&nbsp;</td>
283 <td class="db5">&nbsp;</td>
Helmut Nagy 7.1 284 <td class="db6">null</td>
Helmut Nagy 4.1 285 <td class="db7">&nbsp;</td>
286 </tr>
287 <tr>
Helmut Nagy 6.1 288 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
Helmut Nagy 4.1 289 <td class="db1">XWD_HIDDEN</td>
290 <td class="db2">BIT</td>
291 <td class="db3">&nbsp;</td>
292 <td class="db4">&nbsp;</td>
293 <td class="db5">&nbsp;</td>
Helmut Nagy 7.1 294 <td class="db6">null</td>
Helmut Nagy 4.1 295 <td class="db7">&nbsp;</td>
296 </tr>
Helmut Nagy 1.1 297 </table>

About

About

Support

Platform

User Guide

Admin Guide

Developer Guide

Projects

XWiki

Extensions

Other

Contribute

Status

Practices

Under the Hood

Get Involved

Get Connected