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

  

Related Pages

Search this space

 

Most popular tags

Failed to execute the [groovy] macro
  1. access rights
  2. activity stream
  3. annotation
  4. attachment
  5. comment
  6. Document Tree Macro
  7. export
  8. Extension Manager
  9. Flamingo skin
  10. global user
  11. Groovy event listener
  12. group
  13. nested page
  14. search
  15. skin
  16. syntax
  17. user
  18. user profile
  19. velocity macros
  20. wiki
  21. wysiwyg
  22. XWiki Applications
  23. xwikiattachment_archive table
  24. xwikiattachment table
  25. xwikiattrecyclebin table
  26. xwikiproperties table

[Display all tags from this space]