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" />
 <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" />

The columns of the xwikistatsvisit table are:

ColumnData typeClass propertyIndex
XWV_ID (primary key)bigint(20)--


Related Pages

Search this space


Most popular tags

Failed to execute the [groovy] macro
  1. access rights
  2. activity stream
  3. annotation
  4. attachment
  5. comment
  6. Document Tree Macro
  7. export
  8. Extension Manager
  9. Flamingo skin
  10. global user
  11. Groovy event listener
  12. group
  13. nested page
  14. search
  15. skin
  16. syntax
  17. user
  18. user profile
  19. velocity macros
  20. wiki
  21. wysiwyg
  22. XWiki Applications
  23. xwikiattachment_archive table
  24. xwikiattachment table
  25. xwikiattrecyclebin table
  26. xwikiproperties table

[Display all tags from this space]