Database Reference
- textpattern
- txp_category
- txp_css
- txp_discuss
- txp_discuss_ipban
- txp_discuss_nonce
- txp_file
- txp_form
- txp_image
- txp_lang
- txp_link
- txp_log
- txp_page
- txp_plugin
- txp_prefs
- txp_section
- txp_users

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
ID	int(11)		The auto-incrementing (identity) primary key identifier for this table.
Posted	datetime	0000-00-00 00:00:00
AuthorID	varchar(64)
LastMod	datetime	0000-00-00 00:00:00
LastModID	varchar(64)
Title	varchar(255)
Title_html	varchar(255)
Body	mediumtext
Body_html	mediumtext
Excerpt	text
Excerpt_html	mediumtext
Image	varchar(255)
Category1	varchar(128)
Category2	varchar(128)
Annotate	int(2)	0
AnnotateInvite	varchar(255)
comments_count	int(8)	0
Status	int(2)	4
textile_body	int(2)	1
textile_excerpt	int(2)	1
Section	varchar(64)
override_form	varchar(255)
Keywords	varchar(255)
url_title	varchar(255)
custom_1	varchar(255)
custom_2	varchar(255)
custom_3	varchar(255)
custom_4	varchar(255)
custom_5	varchar(255)
custom_6	varchar(255)
custom_7	varchar(255)
custom_8	varchar(255)
custom_9	varchar(255)
custom_10	varchar(255)
uid	varchar(32)
feed_time	date	0000-00-00

txp_category

Field	Type	Default	Description
id	int(6)		The auto-incrementing (identity) primary key identifier for this table.
name	varchar(64)
type	varchar(64)
parent	varchar(64)
lft	int(6)	0
rgt	int(6)	0
title	varchar(255)

txp_css

Field	Type	Default	Description
name	varchar(255)
css	text

txp_discuss

Field	Type	Default	Description
discussid	int(6)		The auto-incrementing (identity) primary key identifier for this table.
parentid	int(8)	0
name	varchar(255)
email	varchar(50)
web	varchar(255)
ip	varchar(100)
posted	datetime	0000-00-00 00:00:00
message	text
visible	tinyint(4)	1

txp_discuss_ipban

Field	Type	Default
ip	varchar(255)
name_used	varchar(255)
date_banned	datetime	0000-00-00 00:00:00
banned_on_message	int(8)	0

txp_discuss_nonce

Field	Type	Default
issue_time	datetime	0000-00-00 00:00:00
nonce	varchar(255)
used	tinyint(4)	0
secret	varchar(255)

txp_file

Field	Type	Default	Description
id	int(11)		The auto-incrementing (identity) primary key identifier for this table.
filename	varchar(255)
category	varchar(255)
permissions	varchar(32)	0
description	text
downloads	int(4)	0

txp_form

Field	Type	Default	Description
name	varchar(64)
type	varchar(28)
Form	text

txp_image

Field	Type	Default	Description
id	int(11)		The auto-incrementing (identity) primary key identifier for this table.
name	varchar(255)
category	varchar(255)
ext	varchar(20)
w	int(8)	0
h	int(8)	0
alt	varchar(255)
caption	text
date	datetime	0000-00-00 00:00:00
author	varchar(255)
thumbnail	int(2)	0

txp_lang

Field	Type	Default	Description
id	int(9)		The auto-incrementing (identity) primary key identifier for this table.
lang	varchar(16)
name	varchar(64)
event	varchar(64)
data	tinytext	NULL
lastmod	timestamp	CURRENT_TIMESTAMP

txp_link

Field	Type	Default	Description
id	int(6)		The auto-incrementing (identity) primary key identifier for this table.
date	datetime	0000-00-00 00:00:00
category	varchar(64)
url	text
linkname	varchar(255)
linksort	varchar(128)
description	text

txp_log

Field	Type	Default	Description
id	int(12)		The auto-incrementing (identity) primary key identifier for this table.
time	datetime	0000-00-00 00:00:00
host	varchar(255)
page	varchar(255)
refer	mediumtext
status	int(11)	200
method	varchar(16)	GET
ip	varchar(16)

txp_page

Field	Type	Default	Description
name	varchar(128)
user_html	text

txp_plugin

Field	Type	Default
name	varchar(64)
status	int(2)	1
author	varchar(128)
author_uri	varchar(128)
version	varchar(10)	1.0
description	text
help	text
code	text
code_restore	text
code_md5	varchar(32)
type	int(2)	0

txp_prefs

Field	Type	Default
prefs_id	int(11)
name	varchar(255)
val	varchar(255)
type	smallint(5)	2
event	varchar(12)	publish
html	varchar(64)	text_input
position	smallint(5)	0

txp_section

Field	Type	Default
name	varchar(128)
page	varchar(128)
css	varchar(128)
is_default	int(2)	0
in_rss	int(2)	1
on_frontpage	int(2)	1
searchable	int(2)	1
title	varchar(255)

txp_users

Field	Type	Default	Description
user_id	int(4)		The auto-incrementing (identity) primary key identifier for this table.
name	varchar(64)
pass	varchar(128)
RealName	varchar(64)
email	varchar(100)
privs	tinyint(2)	1
last_access	datetime	0000-00-00 00:00:00
nonce	varchar(64)

Table of Contents

Database Reference

textpattern

txp_category

txp_css

txp_discuss

txp_discuss_ipban

txp_discuss_nonce

txp_file

txp_form

txp_image

txp_lang

txp_link

txp_log

txp_page

txp_plugin

txp_prefs

txp_section

txp_users