Version 6.1 by Helmut Nagy on 2009/02/12

Show last authors
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 1.1 XWiki Attachments (xwikiattachment)
16
17 This table contains attachment information (not including the content and versions).
18
19 <table border="0" width="100%" class="dbtable" cellpadding="3" cellspacing="0">
20 <tr>
21 <td colspan="8" class="dbhead">xwikiattachment</td>
22 </tr>
23 <tr>
24 <th class="db0">&nbsp;</th>
25 <th class="db1">Column Name</th>
26 <th class="db2">Datatype</th>
27 <th class="db3">Not null</th>
28 <th class="db4">auto inc</th>
29 <th class="db5">flags</th>
30 <th class="db6">Default Value</th>
31 <th class="db7">Comments</th>
32 </tr>
33 <tr>
34 <td class="db0">{image:db_key.gif|16|16|document=DevGuide.DatabaseSchema}</td>
35 <td class="db1">XWA_ID</td>
36 <td class="db2">BIG_INT(20)</td>
37 <td class="db3">{image:db_check.gif|16|16|document=DevGuide.DatabaseSchema}</td>
38 <td class="db4">&nbsp;</td>
39 <td class="db5">&nbsp;</td>
40 <td class="db6">0</td>
41 <td class="db7">&nbsp;</td>
42 </tr>
43 <tr>
44 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
45 <td class="db1">XWA_DOC_ID</td>
46 <td class="db2">BIG_INT(20)</td>
47 <td class="db3">&nbsp;</td>
48 <td class="db4">&nbsp;</td>
49 <td class="db5">&nbsp;</td>
50 <td class="db6">null</td>
51 <td class="db7">&nbsp;</td>
52 </tr>
53 <tr>
54 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
55 <td class="db1">XWA_FILENAME</td>
56 <td class="db2">VARCHAR(255)</td>
57 <td class="db3">{image:db_check.gif|16|16|document=DevGuide.DatabaseSchema}</td>
58 <td class="db4">&nbsp;</td>
59 <td class="db5">&nbsp;</td>
60 <td class="db6">&nbsp;</td>
61 <td class="db7">&nbsp;</td>
62 </tr>
63 <tr>
64 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
65 <td class="db1">XWA_SIZE</td>
66 <td class="db2">INTEGER</td>
67 <td class="db3">&nbsp;</td>
68 <td class="db4">&nbsp;</td>
69 <td class="db5">&nbsp;</td>
70 <td class="db6">null</td>
71 <td class="db7">&nbsp;</td>
72 </tr>
73 <tr>
74 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
75 <td class="db1">XWA_DATE</td>
76 <td class="db2">DATETIME</td>
77 <td class="db3">{image:db_check.gif|16|16|document=DevGuide.DatabaseSchema}</td>
78 <td class="db4">&nbsp;</td>
79 <td class="db5">&nbsp;</td>
80 <td class="db6">0000-00-00 00:00:00</td>
81 <td class="db7">&nbsp;</td>
82 </tr>
83 <tr>
84 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
85 <td class="db1">XWA_AUTHOR</td>
86 <td class="db2">VARCHAR(255)</td>
87 <td class="db3">&nbsp;</td>
88 <td class="db4">&nbsp;</td>
89 <td class="db5">&nbsp;</td>
90 <td class="db6">null</td>
91 <td class="db7">&nbsp;</td>
92 </tr>
93 <tr>
94 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
95 <td class="db1">XWA_VERSION</td>
96 <td class="db2">VARCHAR(255)</td>
97 <td class="db3">{image:db_check.gif|16|16|document=DevGuide.DatabaseSchema}</td>
98 <td class="db4">&nbsp;</td>
99 <td class="db5">&nbsp;</td>
100 <td class="db6">&nbsp;</td>
101 <td class="db7">&nbsp;</td>
102 </tr>
103 <tr>
104 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
105 <td class="db1">XWA_COMMENT</td>
106 <td class="db2">VARCHAR(255)</td>
107 <td class="db3">&nbsp;</td>
108 <td class="db4">&nbsp;</td>
109 <td class="db5">&nbsp;</td>
110 <td class="db6">null</td>
111 <td class="db7">&nbsp;</td>
112 </tr>
113 </table>

Get Connected