Table of Contents

Database Reference

The following is a complete list of all Textpattern database tables and their respective fields. Primary key fields are underlined.

textpattern

Field Type Default Description
IDint(11) The auto-incrementing (identity) primary key identifier for this table.
Posteddatetime0000-00-00 00:00:00
AuthorIDvarchar(64)
LastModdatetime0000-00-00 00:00:00
LastModIDvarchar(64)
Titlevarchar(255)
Title_htmlvarchar(255)
Bodymediumtext
Body_htmlmediumtext
Excerpttext
Excerpt_htmlmediumtext
Imagevarchar(255)
Category1varchar(128)
Category2varchar(128)
Annotateint(2)0
AnnotateInvitevarchar(255)
comments_countint(8)0
Statusint(2)4
textile_bodyint(2)1
textile_excerptint(2)1
Sectionvarchar(64)
override_formvarchar(255)
Keywordsvarchar(255)
url_titlevarchar(255)
custom_1varchar(255)
custom_2varchar(255)
custom_3varchar(255)
custom_4varchar(255)
custom_5varchar(255)
custom_6varchar(255)
custom_7varchar(255)
custom_8varchar(255)
custom_9varchar(255)
custom_10varchar(255)
uidvarchar(32)
feed_timedate0000-00-00

txp_category

Field Type Default Description
idint(6) The auto-incrementing (identity) primary key identifier for this table.
namevarchar(64)
typevarchar(64)
parentvarchar(64)
lftint(6)0
rgtint(6)0
titlevarchar(255)

txp_css

Field Type Default Description
namevarchar(255)
csstext

txp_discuss

Field Type Default Description
discussidint(6) The auto-incrementing (identity) primary key identifier for this table.
parentidint(8)0
namevarchar(255)
emailvarchar(50)
webvarchar(255)
ipvarchar(100)
posteddatetime0000-00-00 00:00:00
messagetext
visibletinyint(4)1

txp_discuss_ipban

Field Type Default Description
ipvarchar(255)
name_usedvarchar(255)
date_banneddatetime0000-00-00 00:00:00
banned_on_messageint(8)0

txp_discuss_nonce

Field Type Default Description
issue_timedatetime0000-00-00 00:00:00
noncevarchar(255)
usedtinyint(4)0
secretvarchar(255)

txp_file

Field Type Default Description
idint(11) The auto-incrementing (identity) primary key identifier for this table.
filenamevarchar(255)
categoryvarchar(255)
permissionsvarchar(32)0
descriptiontext
downloadsint(4)0

txp_form

Field Type Default Description
namevarchar(64)
typevarchar(28)
Formtext

txp_image

Field Type Default Description
idint(11) The auto-incrementing (identity) primary key identifier for this table.
namevarchar(255)
categoryvarchar(255)
extvarchar(20)
wint(8)0
hint(8)0
altvarchar(255)
captiontext
datedatetime0000-00-00 00:00:00
authorvarchar(255)
thumbnailint(2)0

txp_lang

Field Type Default Description
idint(9) The auto-incrementing (identity) primary key identifier for this table.
langvarchar(16)
namevarchar(64)
eventvarchar(64)
datatinytextNULL
lastmodtimestampCURRENT_TIMESTAMP
Field Type Default Description
idint(6) The auto-incrementing (identity) primary key identifier for this table.
datedatetime0000-00-00 00:00:00
categoryvarchar(64)
urltext
linknamevarchar(255)
linksortvarchar(128)
descriptiontext

txp_log

Field Type Default Description
idint(12) The auto-incrementing (identity) primary key identifier for this table.
timedatetime0000-00-00 00:00:00
hostvarchar(255)
pagevarchar(255)
refermediumtext
statusint(11)200
methodvarchar(16)GET
ipvarchar(16)

txp_page

Field Type Default Description
namevarchar(128)
user_htmltext

txp_plugin

Field Type Default Description
namevarchar(64)
statusint(2)1
authorvarchar(128)
author_urivarchar(128)
versionvarchar(10)1.0
descriptiontext
helptext
codetext
code_restoretext
code_md5varchar(32)
typeint(2)0

txp_prefs

Field Type Default Description
prefs_idint(11)
namevarchar(255)
valvarchar(255)
typesmallint(5)2
eventvarchar(12)publish
htmlvarchar(64)text_input
positionsmallint(5)0

txp_section

Field Type Default Description
namevarchar(128)
pagevarchar(128)
cssvarchar(128)
is_defaultint(2)0
in_rssint(2)1
on_frontpageint(2)1
searchableint(2)1
titlevarchar(255)

txp_users

Field Type Default Description
user_idint(4) The auto-incrementing (identity) primary key identifier for this table.
namevarchar(64)
passvarchar(128)
RealNamevarchar(64)
emailvarchar(100)
privstinyint(2)1
last_accessdatetime0000-00-00 00:00:00
noncevarchar(64)