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" />
   </key-property>
 </composite-id>
 <property name="classType" type="string" column="XWP_CLASSTYPE" length="255" />
 <joined-subclass name="com.xpn.xwiki.objects.DBStringListProperty" table="xwikilists">
   <key>
     <column name="XWL_ID" />
     <column name="XWL_NAME" index="XWLIST_NAME" />
   </key>
   <list name="list" table="xwikilistitems" lazy="false">
     <key>
       <column name="XWL_ID" />
       <column name="XWL_NAME" index="XWLI_NAME" />
     </key>
     <index column="XWL_NUMBER" />
     <element type="string">
       <column name="XWL_VALUE" index="XWLI_VALUE" />
     </element>
   </list>
 </joined-subclass>
</class>

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

Search this space