The "xwikistatsreferer" Table

The xwikistatsreferer table corresponds to the com.xpn.xwiki.stats.impl.RefererStats class and it stores incoming external links on the wiki.

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

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

<class name="com.xpn.xwiki.stats.impl.RefererStats" table="xwikistatsreferer">
 <id name="id" type="long" unsaved-value="undefined">
   <column name="XWR_ID" not-null="true" />
   <generator class="assigned" />
 </id>
 <property name="number" type="integer" column="XWR_NUMBER" not-null="false" />
 <property name="name" type="string" column="XWR_NAME" not-null="true" length="255" index="XWRS_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="XWR_CLASSNAME" length="255" />
 <property name="referer" type="string" column="XWR_REFERER" not-null="true" length="8192" />
 <property name="pageViews" type="integer" column="XWR_PAGE_VIEWS" index="XWRS_PAGE_VIEWS" not-null="false" />
 <property name="period" type="integer" column="XWR_PERIOD" index="XWRS_PERIOD" not-null="false" />
</class>

The columns of the xwikistatsreferer table are:

ColumnData typeClass propertyDefault valuenot-nullIndex
XWR_ID (primary key)bigint(20)-0true-
XWR_NUMBERint(11)numbernullfalse-
XWR_NAMEvarchar(255)name-trueXWRS_NAME
XWR_CLASSNAMEvarchar(255)className---
XWR_REFERERvarchar(8192)referer-true-
XWR_PAGE_VIEWSint(11)pageViews-falseXWRS_PAGE_VIEWS
XWR_PERIODint(11)period-falseXWRS_PERIOD

    

Related Pages

Trying to decide between Cloud and On Premise? See the comparison on the XWiki Help Center.

Search this space