The "xwikistatsvisit" Table

The xwikistatsvisit table corresponds to the com.xpn.xwiki.stats.impl.VisitStats class and it stores data about the users sessions.

In case you haven't enabled the Statistics plugin on your wiki, the xwikistatsvisit table will be empty. 

The mapping information is available in the xwiki.hbm.xml file:

<class name="com.xpn.xwiki.stats.impl.VisitStats" table="xwikistatsvisit">
 <id name="id" type="long" unsaved-value="undefined">
   <column name="XWV_ID" not-null="true" />
   <generator class="assigned" />
 </id>
 <property name="number" type="integer" column="XWV_NUMBER" not-null="false" />
 <property name="name" type="string" column="XWV_NAME" not-null="true" length="255" index="XWVS_NAME" />
 <!-- Before XWiki 2.2M2 this column was always containing the "internal" string to tell the storage
       implementation Stats objects were special. Starting with XWiki 2.2M2 the check is now on whether the class
       name is empty ("") or null. Thus this column can now contain both "internal" (old stats) and ""
       (new stats) -->

 <property name="className" type="string" column="XWV_CLASSNAME" length="255" />
 <property name="IP" type="string" column="XWV_IP" not-null="true" length="255" index="XWVS_IP" />
 <property name="userAgent" type="string" column="XWV_USER_AGENT" not-null="true" length="8192" />
 <property name="cookie" type="string" column="XWV_COOKIE" not-null="true" length="8192" />
 <property name="uniqueID" type="string" column="XWV_UNIQUE_ID" index="XWVS_UNIQUE_ID" not-null="true" length="255" />
 <property name="pageViews" type="integer" column="XWV_PAGE_VIEWS" index="XWVS_PAGE_VIEWS" not-null="false" />
 <property name="pageSaves" type="integer" column="XWV_PAGE_SAVES" index="XWVS_PAGE_SAVES" not-null="false" />
 <property name="downloads" type="integer" column="XWV_DOWNLOADS" index="XWVS_DOWNLOADS" not-null="false" />
 <property name="startDate" type="timestamp" column="XWV_START_DATE" index="XWVS_START_DATE" not-null="false" />
 <property name="endDate" type="timestamp" column="XWV_END_DATE" index="XWVS_END_DATE" not-null="false" />
</class>

The columns of the xwikistatsvisit table are:

ColumnData typeClass propertyIndex
XWV_ID (primary key)bigint(20)--
XWV_NUMBERint(11)number-
XWV_NAMEvarchar(255)nameXWVS_NAME
XWV_CLASSNAMEvarchar(255)className-
XWV_IPvarchar(255)IPXWVS_IP
XWV_USER_AGENTvarchar(8192)userAgent-
XWV_COOKIEvarchar(8192)cookie-
XWV_UNIQUE_IDvarchar(255)uniqueIDXWVS_UNIQUE_ID
XWV_PAGE_VIEWSint(11)pageViewsXWVS_PAGE_VIEWS
XWV_PAGE_SAVEint(11)pageSavesXWVS_PAGE_SAVES
XWV_DOWNLOADSint(11)downloadsXWVS_DOWNLOADS
XWV_START_DATEdatetimestartDateXWVS_START_DATE
XWV_END_DATEdatetimeendDateXWVS_END_DATE

    

Search this space