The "xwikilists" Table

The xwikilists table corresponds to the com.xpn.xwiki.objects.DBStringListProperty class and it stores the data for XWiki objects of type "Database List". The data for list items is stored in the xwikilistitems table. Also, the "DBStringListProperty" class is a sub-class of com.xpn.xwiki.objects.BaseProperty.

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

<class name="com.xpn.xwiki.objects.BaseProperty" table="xwikiproperties">
 <composite-id unsaved-value="undefined">
   <key-property name="id" column="XWP_ID" type="long" />
   <key-property name="name" type="string">
     <column name="XWP_NAME" index="PROP_NAME" />
 <property name="classType" type="string" column="XWP_CLASSTYPE" length="255" />
 <joined-subclass name="com.xpn.xwiki.objects.DBStringListProperty" table="xwikilists">
     <column name="XWL_ID" />
     <column name="XWL_NAME" index="XWLIST_NAME" />
   <list name="list" table="xwikilistitems" lazy="false">
       <column name="XWL_ID" />
       <column name="XWL_NAME" index="XWLI_NAME" />
     <index column="XWL_NUMBER" />
     <element type="string">
       <column name="XWL_VALUE" index="XWLI_VALUE" />

The columns of the xwikilists table are:

ColumnData typeDefault valuenot-nullIndex
XWL_ID (primary key)bigint(20)0true-
XWL_NAME (primary key)varchar(255)-trueXWLIST_NAME


Related Pages

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

Search this space