The "xwikilargestrings" Table

The xwikilargestrings table stores data from XWiki objects of type "Text Area" and "Static List". This table corresponds to the com.xpn.xwiki.objects.StringListProperty and com.xpn.xwiki.objects.LargeStringProperty classes which are a sub-classes 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.LargeStringProperty" table="xwikilargestrings">
   <key>
     <column name="XWL_ID" />
     <column name="XWL_NAME" index="XWLS_NAME" />
   </key>
   <property name="value" type="text" column="XWL_VALUE" length="60000" />
 </joined-subclass>
 <joined-subclass name="com.xpn.xwiki.objects.StringListProperty" table="xwikilargestrings">
   <key>
     <column name="XWL_ID" />
     <column name="XWL_NAME" />
   </key>
   <property name="textValue" type="text" column="XWL_VALUE" length="60000" />
 </joined-subclass>
</class>

The columns of the xwikilargestrings table are:

ColumnData type"LargeStringProperty" class property"StringListProperty" class propertyDefault valuenot-nullIndex
XWL_ID (primary key)bigint(20)--0true-
XWL_NAME (primary key)varchar(255)---trueXWLS_NAME
XWL_VALUElongtextvaluetextValuenullfalse-

  

Related Pages

Search this space