The "xwikipreferences" Table

The xwikipreferences table stores data from "XWiki.XWikiPreferences" objects.

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

<!-- XWikiPreferences custom mapping -->
<class entity-name="XWiki.XWikiPreferences" table="xwikipreferences">
 <id name="id" type="long" unsaved-value="undefined">
   <column name="XWP_ID" not-null="true" />
   <generator class="assigned" />
 </id>
 <property name="language" type="string" column="XWP_LANGUAGE" length="255" />
 <property name="default_language" type="string" column="XWP_DEFAULT_LANGUAGE" length="255" />
 <property name="multilingual" type="integer" column="XWP_MULTI_LINGUAL" />
 <property name="authenticate_edit" type="integer" column="XWP_AUTHENTICATE_EDIT" />
 <property name="authenticate_view" type="integer" column="XWP_AUTHENTICATE_VIEW" />
 <property name="auth_active_check" type="integer" column="XWP_AUTH_ACTIVE_CHECK" />
 <property name="backlinks" type="integer" column="XWP_BACKLINKS" />
 <property name="skin" type="string" column="XWP_SKIN" length="255" />
 <property name="stylesheet" type="string" column="XWP_STYLESHEET" length="255" />
 <property name="stylesheets" type="string" column="XWP_STYLESHEETS" length="255" />
 <property name="editor" type="string" column="XWP_EDITOR" length="255" />
 <property name="webcopyright" type="string" column="XWP_WEBCOPYRIGHT" length="255" />
 <property name="title" type="string" column="XWP_TITLE" length="255" />
 <property name="version" type="string" column="XWP_VERSION" length="255" />
 <property name="meta" type="text" column="XWP_META" length="30000" />
 <property name="use_email_verification" type="integer" column="XWP_USE_EMAIL_VERIFICATION" />
 <property name="smtp_server" type="string" column="XWP_SMTP_SERVER" length="255" />
 <property name="admin_email" type="string" column="XWP_ADMIN_EMAIL" length="255" />
 <property name="validation_email_content" type="text" column="XWP_VALIDATION_EMAIL_CONTENT" length="30000" />
 <property name="confirmation_email_content" type="text" column="XWP_CONFIRMATION_EMAIL_CONTENT" length="30000" />
 <property name="invitation_email_content" type="text" column="XWP_INVITATION_EMAIL_CONTENT" length="30000" />
 <property name="leftPanels" type="string" column="XWP_LEFT_PANELS" length="2000" />
 <property name="rightPanels" type="string" column="XWP_RIGHT_PANELS" length="2000" />
 <property name="showLeftPanels" type="integer" column="XWP_SHOW_LEFT_PANELS" />
 <property name="showRightPanels" type="integer" column="XWP_SHOW_RIGHT_PANELS" />
 <property name="languages" type="string" column="XWP_LANGUAGES" length="255" />
 <property name="registration_anonymous" type="string" column="XWP_REGISTRATION_ANONYMOUS" length="255" />
 <property name="registration_registered" type="string" column="XWP_REGISTRATION_REGISTERED" length="255" />
 <property name="edit_anonymous" type="string" column="XWP_EDIT_ANONYMOUS" length="255" />
 <property name="edit_registered" type="string" column="XWP_EDIT_REGISTERED" length="255" />
 <property name="comment_anonymous" type="string" column="XWP_COMMENT_ANONYMOUS" length="255" />
 <property name="comment_registered" type="string" column="XWP_COMMENT_REGISTERED" length="255" />
 <property name="documentBundles" type="string" column="XWP_DOCUMENT_BUNDLES" length="2000" />
</class>

The columns of the xwikipreferences table are:

ColumnData typeClass property
XWP_ID (primary key)bigint(20)-
XWP_LANGUAGEvarchar(255)language
XWP_DEFAULT_LANGUAGEvarchar(255)default_language
XWP_MULTI_LINGUALint(11)multilingual
XWP_AUTHENTICATE_EDITint(11)authenticate_edit
XWP_AUTHENTICATE_VIEWint(11)authenticate_view
XWP_AUTH_ACTIVE_CHECKint(11)auth_active_check
XWP_BACKLINKSint(11)backlinks
XWP_SKINvarchar(255)skin
XWP_STYLESHEETvarchar(255)stylesheet
XWP_STYLESHEETSvarchar(255)stylesheets
XWP_EDITORvarchar(255)editor
XWP_WEBCOPYRIGHTvarchar(255)webcopyright
XWP_TITLEvarchar(255)title
XWP_VERSIONvarchar(255)version
XWP_METAlongtextmeta
XWP_USE_EMAIL_VERIFICATIONint(11)use_email_verification
XWP_SMTP_SERVERvarchar(255)smtp_server
XWP_ADMIN_EMAILvarchar(255)admin_email
XWP_VALIDATION_EMAIL_CONTENTlongtextvalidation_email_content
XWP_CONFIRMATION_EMAIL_CONTENTlongtextconfirmation_email_content
XWP_INVITATION_EMAIL_CONTENTlongtextinvitation_email_content
XWP_LEFT_PANELSvarchar(2000)leftPanels
XWP_RIGHT_PANELSvarchar(2000)rightPanels
XWP_SHOW_LEFT_PANELSint(11)showLeftPanels
XWP_SHOW_RIGHT_PANELSint(11)showRightPanels
XWP_LANGUAGESvarchar(255)languages
XWP_REGISTRATION_ANONYMOUSvarchar(255)registration_anonymous
XWP_REGISTRATION_REGISTEREDvarchar(255)registration_registered
XWP_EDIT_ANONYMOUSvarchar(255)edit_anonymous
XWP_EDIT_REGISTEREDvarchar(255)edit_registered
XWP_COMMENT_ANONYMOUSvarchar(255)comment_anonymous
XWP_COMMENT_REGISTEREDvarchar(255)comment_registered
XWP_DOCUMENT_BUNDLESvarchar(2000)documentBundles

  

Search this space