wpDbPing
[
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)