Wiki source code of XWiki Visits (xwikistatsvisit)

Version 3.1 by Helmut Nagy on 2009/02/12

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 1.1.1 XWiki Visits (xwikistatsvisit)
17
18 This table contains the sessions of the named users.
19
20 <table border="0" width="100%" class="dbtable" cellpadding="3"
21 cellspacing="0">
22 <tr>
23 <td colspan="8" class="dbhead">xwikistatsvisit</td>
24 </tr>
25 <tr>
26 <th class="db0">&nbsp;</th>
27 <th class="db1">Column Name</th>
28 <th class="db2">Datatype</th>
29 <th class="db3">Not null</th>
30 <th class="db4">auto inc</th>
31 <th class="db5">flags</th>
32 <th class="db6">Default Value</th>
33 <th class="db7">Comments</th>
34 </tr>
35 <tr>
36 <td class="db0">{image:db_key.gif|16|16|document=DevGuide.DatabaseSchema}</td>
37 <td class="db1">XWV_ID</td>
38 <td class="db2">INTEGER</td>
39 <td class="db3">{image:db_check.gif|16|16|document=DevGuide.DatabaseSchema}</td>
40 <td class="db4">&nbsp;</td>
41 <td class="db5">&nbsp;</td>
42 <td class="db6">0</td>
43 <td class="db7">&nbsp;</td>
44 </tr>
45 <tr>
46 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
47 <td class="db1">XWV_NUMBER</td>
48 <td class="db2">INTEGER</td>
49 <td class="db3">&nbsp;</td>
50 <td class="db4">&nbsp;</td>
51 <td class="db5">&nbsp;</td>
52 <td class="db6">null&nbsp;</td>
53 <td class="db7">&nbsp;</td>
54 </tr>
55 <tr>
56 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
57 <td class="db1">XWV_NAME</td>
58 <td class="db2">VARCHAR(255)</td>
59 <td class="db3">{image:db_check.gif|16|16|document=DevGuide.DatabaseSchema}</td>
60 <td class="db4">&nbsp;</td>
61 <td class="db5">&nbsp;</td>
62 <td class="db6">&nbsp;</td>
63 <td class="db7">&nbsp;</td>
64 </tr>
65 <tr>
66 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
67 <td class="db1">XWV_CLASSNAME</td>
68 <td class="db2">VARCHAR(255)</td>
69 <td class="db3">{image:db_check.gif|16|16|document=DevGuide.DatabaseSchema}</td>
70 <td class="db4">&nbsp;</td>
71 <td class="db5">&nbsp;</td>
72 <td class="db6">&nbsp;</td>
73 <td class="db7">&nbsp;</td>
74 </tr>
75 <tr>
76 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
77 <td class="db1">XWV_IP</td>
78 <td class="db2">VARCHAR(255)</td>
79 <td class="db3">{image:db_check.gif|16|16|document=DevGuide.DatabaseSchema}</td>
80 <td class="db4">&nbsp;</td>
81 <td class="db5">&nbsp;</td>
82 <td class="db6">&nbsp;</td>
83 <td class="db7">&nbsp;</td>
84 </tr>
85 <tr>
86 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
87 <td class="db1">XWV_USER_AGENT</td>
88 <td class="db2">TEXT</td>
89 <td class="db3">{image:db_check.gif|16|16|document=DevGuide.DatabaseSchema}</td>
90 <td class="db4">&nbsp;</td>
91 <td class="db5">&nbsp;</td>
92 <td class="db6">&nbsp;</td>
93 <td class="db7">&nbsp;</td>
94 </tr>
95 <tr>
96 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
97 <td class="db1">XWV_COOKIE</td>
98 <td class="db2">TEXT</td>
99 <td class="db3">{image:db_check.gif|16|16|document=DevGuide.DatabaseSchema}</td>
100 <td class="db4">&nbsp;</td>
101 <td class="db5">&nbsp;</td>
102 <td class="db6">&nbsp;</td>
103 <td class="db7">&nbsp;</td>
104 </tr>
105 <tr>
106 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
107 <td class="db1">XWV_UNIQUE_ID</td>
108 <td class="db2">VARCHAR(255)</td>
109 <td class="db3">{image:db_check.gif|16|16|document=DevGuide.DatabaseSchema}</td>
110 <td class="db4">&nbsp;</td>
111 <td class="db5">&nbsp;</td>
112 <td class="db6">&nbsp;</td>
113 <td class="db7">&nbsp;</td>
114 </tr>
115 <tr>
116 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
117 <td class="db1">XWV_PAGE_VIEWS</td>
118 <td class="db2">INTEGER</td>
119 <td class="db3">&nbsp;</td>
120 <td class="db4">&nbsp;</td>
121 <td class="db5">&nbsp;</td>
122 <td class="db6">null</td>
123 <td class="db7">&nbsp;</td>
124 </tr>
125 <tr>
126 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
127 <td class="db1">XWV_SAVES</td>
128 <td class="db2">INTEGER</td>
129 <td class="db3">&nbsp;</td>
130 <td class="db4">&nbsp;</td>
131 <td class="db5">&nbsp;</td>
132 <td class="db6">null</td>
133 <td class="db7">&nbsp;</td>
134 </tr>
135 <tr>
136 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
137 <td class="db1">XWV_DOWNLOADS</td>
138 <td class="db2">INTEGER</td>
139 <td class="db3">&nbsp;</td>
140 <td class="db4">&nbsp;</td>
141 <td class="db5">&nbsp;</td>
142 <td class="db6">null</td>
143 <td class="db7">&nbsp;</td>
144 </tr>
145 <tr>
146 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
147 <td class="db1">XWV_START_DATE</td>
148 <td class="db2">DATETIME</td>
149 <td class="db3">&nbsp;</td>
150 <td class="db4">&nbsp;</td>
151 <td class="db5">&nbsp;</td>
152 <td class="db6">null</td>
153 <td class="db7">&nbsp;</td>
154 </tr>
155 <tr>
156 <td class="db0">{image:db_field.gif|16|16|document=DevGuide.DatabaseSchema}</td>
157 <td class="db1">XWV_END_DATE</td>
158 <td class="db2">DATETIME</td>
159 <td class="db3">&nbsp;</td>
160 <td class="db4">&nbsp;</td>
161 <td class="db5">&nbsp;</td>
162 <td class="db6">null</td>
163 <td class="db7">&nbsp;</td>
164 </tr>
165 </table>

Get Connected