Wiki source code of XWiki Visits (xwikistatsvisit)

Version 4.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 Visits (xwikistatsvisit) ===
19
20 This table contains the sessions of the named users.
21 <p/>
22 <table border="0" width="100%" class="dbtable" cellpadding="3"
23 cellspacing="0">
24 <tr>
25 <td colspan="8" class="dbhead">xwikistatsvisit</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">XWV_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">XWV_NUMBER</td>
50 <td class="db2">INTEGER</td>
51 <td class="db3">&nbsp;</td>
52 <td class="db4">&nbsp;</td>
53 <td class="db5">&nbsp;</td>
54 <td class="db6">null&nbsp;</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">XWV_NAME</td>
60 <td class="db2">VARCHAR(255)</td>
61 <td class="db3">[[image:DevGuide.DatabaseSchema@db_check.gif||height="16" width="16"]]</td>
62 <td class="db4">&nbsp;</td>
63 <td class="db5">&nbsp;</td>
64 <td class="db6">&nbsp;</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">XWV_CLASSNAME</td>
70 <td class="db2">VARCHAR(255)</td>
71 <td class="db3">[[image:DevGuide.DatabaseSchema@db_check.gif||height="16" width="16"]]</td>
72 <td class="db4">&nbsp;</td>
73 <td class="db5">&nbsp;</td>
74 <td class="db6">&nbsp;</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">XWV_IP</td>
80 <td class="db2">VARCHAR(255)</td>
81 <td class="db3">[[image:DevGuide.DatabaseSchema@db_check.gif||height="16" width="16"]]</td>
82 <td class="db4">&nbsp;</td>
83 <td class="db5">&nbsp;</td>
84 <td class="db6">&nbsp;</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">XWV_USER_AGENT</td>
90 <td class="db2">TEXT</td>
91 <td class="db3">[[image:DevGuide.DatabaseSchema@db_check.gif||height="16" width="16"]]</td>
92 <td class="db4">&nbsp;</td>
93 <td class="db5">&nbsp;</td>
94 <td class="db6">&nbsp;</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">XWV_COOKIE</td>
100 <td class="db2">TEXT</td>
101 <td class="db3">[[image:DevGuide.DatabaseSchema@db_check.gif||height="16" width="16"]]</td>
102 <td class="db4">&nbsp;</td>
103 <td class="db5">&nbsp;</td>
104 <td class="db6">&nbsp;</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">XWV_UNIQUE_ID</td>
110 <td class="db2">VARCHAR(255)</td>
111 <td class="db3">[[image:DevGuide.DatabaseSchema@db_check.gif||height="16" width="16"]]</td>
112 <td class="db4">&nbsp;</td>
113 <td class="db5">&nbsp;</td>
114 <td class="db6">&nbsp;</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">XWV_PAGE_VIEWS</td>
120 <td class="db2">INTEGER</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">XWV_SAVES</td>
130 <td class="db2">INTEGER</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">XWV_DOWNLOADS</td>
140 <td class="db2">INTEGER</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">XWV_START_DATE</td>
150 <td class="db2">DATETIME</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">XWV_END_DATE</td>
160 <td class="db2">DATETIME</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 </table>
168 {{/html}}

Get Connected