[SHOW TABLES FROM wpblog]

Tables_in_wpblog

INSTALL

falbum_cache

wp_bas_log

wp_bas_os

wp_bas_pages

wp_bas_refer

wp_bas_searches

wp_bas_ua

wp_bas_visitors

wp_categories

wp_comments

wp_linkcategories

wp_links

wp_options

wp_post2cat

wp_postmeta

wp_posts

wp_subscribe2

wp_usermeta

wp_users

[SHOW COLUMNS FROM wp_posts]

Field	Type	Null	Key	Default	Extra
ID	bigint(20) unsigned		PRI		auto_increment
post_author	bigint(20)			0
post_date	datetime			0000-00-00 00:00:00
post_date_gmt	datetime			0000-00-00 00:00:00
post_content	longtext
post_title	text
post_category	int(4)			0
post_excerpt	text
post_status	enum('publish','draft','private','static','object','attachment')			publish
comment_status	enum('open','closed','registered_only')			open
ping_status	enum('open','closed')			open
post_password	varchar(20)
post_name	varchar(200)		MUL
to_ping	text
pinged	text
post_modified	datetime			0000-00-00 00:00:00
post_modified_gmt	datetime			0000-00-00 00:00:00
post_content_filtered	text
post_parent	bigint(20)			0
guid	varchar(255)
menu_order	int(11)			0
post_type	varchar(100)
post_mime_type	varchar(100)
comment_count	bigint(20)			0

[SHOW COLUMNS FROM wp_post2cat]

Field	Type	Null	Key	Default	Extra
rel_id	bigint(20)		PRI		auto_increment
post_id	bigint(20)		MUL	0
category_id	bigint(20)			0

[SHOW COLUMNS FROM wp_postmeta]

Field	Type	Null	Key	Default	Extra
meta_id	bigint(20)		PRI		auto_increment
post_id	bigint(20)		MUL	0
meta_key	varchar(255)	YES	MUL
meta_value	longtext	YES

[SHOW COLUMNS FROM wp_comments]

Field	Type	Null	Key	Default	Extra
comment_ID	bigint(20) unsigned		PRI		auto_increment
comment_post_ID	int(11)		MUL	0
comment_author	tinytext
comment_author_email	varchar(100)
comment_author_url	varchar(200)
comment_author_IP	varchar(100)
comment_date	datetime			0000-00-00 00:00:00
comment_date_gmt	datetime			0000-00-00 00:00:00
comment_content	text
comment_karma	int(11)			0
comment_approved	enum('0','1','spam')		MUL	1
comment_agent	varchar(255)
comment_type	varchar(20)
comment_parent	bigint(20)			0
user_id	bigint(20)			0

[SHOW COLUMNS FROM wp_categories]

Field	Type	Null	Key	Default	Extra
cat_ID	bigint(20)		PRI		auto_increment
cat_name	varchar(55)
category_nicename	varchar(200)		MUL
category_description	longtext
category_parent	bigint(20)			0
category_count	bigint(20)			0

[SHOW COLUMNS FROM wp_categories]

Field	Type	Null	Key	Default	Extra
cat_ID	bigint(20)		PRI		auto_increment
cat_name	varchar(55)
category_nicename	varchar(200)		MUL
category_description	longtext
category_parent	bigint(20)			0
category_count	bigint(20)			0

[SHOW COLUMNS FROM wp_users]

Field	Type	Null	Key	Default	Extra
ID	bigint(20) unsigned		PRI		auto_increment
user_login	varchar(60)		MUL
user_pass	varchar(64)
user_nicename	varchar(50)
user_email	varchar(100)
user_url	varchar(100)
user_registered	datetime			0000-00-00 00:00:00
user_activation_key	varchar(60)
user_status	int(11)			0
display_name	varchar(250)