The "xwikiproperties" Table

The xwikiproperties table corresponds to the com.xpn.xwiki.objects.BaseProperty class and it stores the list of properties of XWiki objects attached to wiki pages. 

The values of the properties are stored in the corresponding tables, depending on the data type:

TypeJava ClassTable
Integercom.xpn.xwiki.objects.IntegerPropertyxwikiintegers
Longcom.xpn.xwiki.objects.LongPropertyxwikilongs
Floatcom.xpn.xwiki.objects.FloatPropertyxwikifloats
Doublecom.xpn.xwiki.objects.DoublePropertyxwikidoubles
Stringcom.xpn.xwiki.objects.StringPropertyxwikistrings
Datecom.xpn.xwiki.objects.DatePropertyxwikidates
Text Areacom.xpn.xwiki.objects.LargeStringPropertyxwikilargestrings
Static Listcom.xpn.xwiki.objects.StringListPropertyxwikilargestrings
Database Listcom.xpn.xwiki.objects.DBStringListPropertyxwikilists

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

The columns of the xwikiproperties table are:

ColumnData typeClass propertyDefault valuenot-nullIndex
XWP_ID (primary key)bigint(20)id0true-
XWP_NAME (primary key)varchar(255)name-truePROP_NAME
XWP_CLASSTYPEvarchar(255)classType---

 

Related Pages

Search this space