ads_ad_types
Field |
Type |
Null |
Default |
type_id
|
tinyint(3) |
No |
|
type_title
|
varchar(255) |
No |
|
type_required
|
int(6) |
No |
0 |
type_use
|
int(6) |
No |
0 |
option1
|
varchar(255) |
No |
|
def_option1
|
varchar(255) |
No |
|
option2
|
varchar(255) |
No |
|
def_option2
|
varchar(255) |
No |
|
option3
|
varchar(255) |
No |
|
def_option3
|
varchar(255) |
No |
|
option4
|
varchar(255) |
No |
|
def_option4
|
varchar(255) |
No |
|
option5
|
varchar(255) |
No |
|
def_option5
|
varchar(255) |
No |
|
option6
|
varchar(255) |
No |
|
def_option6
|
varchar(255) |
No |
|
option7
|
varchar(255) |
No |
|
def_option7
|
varchar(255) |
No |
|
option8
|
varchar(255) |
No |
|
def_option8
|
varchar(255) |
No |
|
option9
|
varchar(255) |
No |
|
def_option9
|
varchar(255) |
No |
|
option10
|
varchar(255) |
No |
|
def_option10
|
varchar(255) |
No |
|
template
|
mediumtext |
No |
|
ads_ads
Field |
Type |
Null |
Default |
ad_id
|
int(10) |
No |
|
ad_status
|
tinyint(1) |
No |
0 |
ad_user_id
|
int(5) |
No |
0 |
ad_category
|
int(5) |
No |
0 |
ad_date_begin
|
varchar(10) |
No |
|
ad_date_end
|
varchar(10) |
No |
|
ad_type
|
tinyint(3) |
No |
0 |
ad_title
|
varchar(255) |
No |
|
ad_description
|
text |
No |
|
ad_image1
|
varchar(255) |
No |
|
ad_image2
|
varchar(255) |
No |
|
ad_image3
|
varchar(255) |
No |
|
ad_image4
|
varchar(255) |
No |
|
ad_image5
|
varchar(255) |
No |
|
ad_options
|
int(10) |
No |
0 |
ad_optional_1
|
varchar(255) |
No |
|
ad_optional_2
|
varchar(255) |
No |
|
ad_optional_3
|
varchar(255) |
No |
|
ad_optional_4
|
varchar(255) |
No |
|
ad_optional_5
|
varchar(255) |
No |
|
ad_type_optional1
|
varchar(255) |
No |
|
ad_type_optional2
|
varchar(255) |
No |
|
ad_type_optional3
|
varchar(255) |
No |
|
ad_type_optional4
|
varchar(255) |
No |
|
ad_type_optional5
|
varchar(255) |
No |
|
ad_type_optional6
|
varchar(255) |
No |
|
ad_type_optional7
|
varchar(255) |
No |
|
ad_type_optional8
|
varchar(255) |
No |
|
ad_type_optional9
|
varchar(255) |
No |
|
ad_type_optional10
|
varchar(255) |
No |
|
ad_price
|
varchar(255) |
No |
0.00 |
ad_condition
|
tinyint(4) |
No |
0 |
ad_views
|
int(4) |
No |
0 |
ad_address
|
varchar(255) |
No |
|
ad_city
|
varchar(255) |
No |
|
ad_state
|
varchar(255) |
No |
|
ad_postal
|
varchar(255) |
No |
|
ad_country
|
varchar(255) |
No |
|
ad_city_code
|
int(11) |
No |
0 |
ad_state_code
|
int(4) |
No |
0 |
ad_country_code
|
int(3) |
No |
0 |
ad_fee
|
float(6,2) |
No |
0.00 |
ad_anon_name
|
varchar(255) |
No |
|
ad_anon_email
|
varchar(255) |
No |
|
ads_banner_groups
Field |
Type |
Null |
Default |
group_id
|
int(3) |
No |
|
group_banners
|
varchar(255) |
No |
|
group_title
|
varchar(255) |
No |
|
ads_banners
Field |
Type |
Null |
Default |
banner_id
|
int(5) |
No |
|
banner_name
|
varchar(255) |
No |
|
banner_text
|
varchar(255) |
No |
|
banner_url
|
varchar(255) |
No |
|
banner_image
|
varchar(255) |
No |
|
banner_image_url
|
varchar(255) |
No |
|
banner_image_tracker
|
varchar(255) |
No |
|
banner_height
|
int(4) |
No |
0 |
banner_width
|
int(4) |
No |
0 |
ads_categories
Field |
Type |
Null |
Default |
category_id
|
int(5) |
No |
|
category_order
|
int(3) |
No |
0 |
category_parent
|
int(5) |
No |
0 |
category_title
|
varchar(255) |
No |
|
category_desc
|
text |
No |
|
category_img
|
varchar(255) |
No |
|
category_ad_types
|
varchar(255) |
No |
|
category_ad_prices
|
varchar(255) |
No |
|
category_optional_1
|
varchar(255) |
No |
|
category_optional_1_def
|
varchar(255) |
No |
|
category_optional_2
|
varchar(255) |
No |
|
category_optional_2_def
|
varchar(255) |
No |
|
category_optional_3
|
varchar(255) |
No |
|
category_optional_3_def
|
varchar(255) |
No |
|
category_optional_4
|
varchar(255) |
No |
|
category_optional_4_def
|
varchar(255) |
No |
|
category_optional_5
|
varchar(255) |
No |
|
category_optional_5_def
|
varchar(255) |
No |
|
category_subs
|
int(5) |
No |
0 |
category_listings
|
int(5) |
No |
0 |
banner_top
|
varchar(5) |
No |
|
banner_bottom
|
varchar(5) |
No |
|
category_related
|
varchar(255) |
No |
|
ads_coupons
Field |
Type |
Null |
Default |
coupon_id
|
int(11) |
No |
|
coupon_code
|
varchar(255) |
No |
|
coupon_percent
|
tinyint(3) |
No |
0 |
coupon_amount
|
float(6,2) |
No |
0.00 |
coupon_expires
|
date |
No |
0000-00-00 |
coupon_uses
|
int(5) |
No |
0 |
coupon_restrict
|
tinyint(1) |
No |
0 |
coupon_type
|
tinyint(1) |
No |
0 |
ads_coupons_lock
Field |
Type |
Null |
Default |
coupon_code
|
varchar(255) |
No |
|
user_id
|
int(5) |
No |
0 |
ads_statistics
Field |
Type |
Null |
Default |
stat_my
|
varchar(7) |
No |
|
stat_item
|
char(1) |
No |
|
stat_detail
|
varchar(10) |
No |
|
stat_count
|
float(8,2) |
No |
0.00 |
ads_system
Field |
Type |
Null |
Default |
id
|
int(2) |
No |
|
item
|
varchar(255) |
No |
|
value
|
text |
No |
|
artists
Field |
Type |
Null |
Default |
id
|
int(11) |
No |
|
name
|
varchar(100) |
No |
|
photo
|
varchar(100) |
No |
|
photo2
|
varchar(100) |
No |
|
photo3
|
varchar(100) |
No |
|
bio
|
text |
No |
|
message
|
text |
No |
|
ad
|
text |
No |
|
player
|
text |
No |
|
folder
|
varchar(20) |
No |
|
cd1pic
|
varchar(100) |
No |
|
cd1name
|
varchar(100) |
No |
|
cd2pic
|
varchar(100) |
No |
|
cd2name
|
varchar(100) |
No |
|
cd3pic
|
varchar(100) |
No |
|
cd3name
|
varchar(100) |
No |
|
cd4pic
|
varchar(100) |
No |
|
cd4name
|
varchar(100) |
No |
|
lyrics
|
text |
No |
|
thumbnail
|
varchar(100) |
No |
|
asLinks_categories
Field |
Type |
Null |
Default |
id
|
smallint(10) |
No |
|
name
|
varchar(255) |
Yes |
NULL |
parent
|
smallint(10) |
No |
0 |
counter
|
smallint(10) |
No |
0 |
subCategories
|
smallint(10) |
No |
0 |
asLinks_config
Field |
Type |
Null |
Default |
name
|
varchar(150) |
No |
|
value
|
text |
Yes |
NULL |
comment
|
varchar(150) |
Yes |
NULL |
title
|
varchar(150) |
Yes |
NULL |
asLinks_links
Field |
Type |
Null |
Default |
id
|
smallint(10) |
No |
|
name
|
varchar(255) |
Yes |
NULL |
email
|
varchar(255) |
Yes |
NULL |
url
|
varchar(255) |
Yes |
NULL |
title
|
text |
Yes |
NULL |
description
|
text |
Yes |
NULL |
category
|
smallint(10) |
No |
0 |
reciprocal
|
varchar(255) |
Yes |
NULL |
confirmed
|
smallint(1) |
No |
0 |
approved
|
smallint(1) |
No |
0 |
added
|
int(10) |
No |
0 |
nextcheck
|
int(10) |
No |
0 |
nocheck
|
smallint(1) |
No |
0 |
bak_banner
Field |
Type |
Null |
Default |
bid
|
int(11) |
No |
|
cid
|
int(11) |
No |
0 |
type
|
varchar(30) |
No |
banner |
name
|
varchar(255) |
No |
|
alias
|
varchar(255) |
No |
|
imptotal
|
int(11) |
No |
0 |
impmade
|
int(11) |
No |
0 |
clicks
|
int(11) |
No |
0 |
imageurl
|
varchar(100) |
No |
|
clickurl
|
varchar(200) |
No |
|
date
|
datetime |
Yes |
NULL |
showBanner
|
tinyint(1) |
No |
0 |
checked_out
|
tinyint(1) |
No |
0 |
checked_out_time
|
datetime |
No |
0000-00-00 00:00:00 |
editor
|
varchar(50) |
Yes |
NULL |
custombannercode
|
text |
Yes |
NULL |
catid
|
int(10) |
No |
0 |
description
|
text |
No |
|
sticky
|
tinyint(1) |
No |
0 |
ordering
|
int(11) |
No |
0 |
publish_up
|
datetime |
No |
0000-00-00 00:00:00 |
publish_down
|
datetime |
No |
0000-00-00 00:00:00 |
tags
|
text |
No |
|
params
|
text |
No |
|
bak_bannerclient
Field |
Type |
Null |
Default |
cid
|
int(11) |
No |
|
name
|
varchar(255) |
No |
|
contact
|
varchar(255) |
No |
|
email
|
varchar(255) |
No |
|
extrainfo
|
text |
No |
|
checked_out
|
tinyint(1) |
No |
0 |
checked_out_time
|
time |
Yes |
NULL |
editor
|
varchar(50) |
Yes |
NULL |
bak_bannertrack
Field |
Type |
Null |
Default |
track_date
|
date |
No |
0000-00-00 |
track_type
|
int(10) |
No |
0 |
banner_id
|
int(10) |
No |
0 |
bak_categories
Field |
Type |
Null |
Default |
id
|
int(11) |
No |
|
parent_id
|
int(11) |
No |
0 |
title
|
varchar(255) |
No |
|
name
|
varchar(255) |
No |
|
alias
|
varchar(255) |
No |
|
image
|
varchar(255) |
No |
|
section
|
varchar(50) |
No |
|
image_position
|
varchar(30) |
No |
|
description
|
text |
No |
|
published
|
tinyint(1) |
No |
0 |
checked_out
|
int(11) |
No |
0 |
checked_out_time
|
datetime |
No |
0000-00-00 00:00:00 |
editor
|
varchar(50) |
Yes |
NULL |
ordering
|
int(11) |
No |
0 |
access
|
tinyint(3) |
No |
0 |
count
|
int(11) |
No |
0 |
params
|
text |
No |
|
bak_components
Field |
Type |
Null |
Default |
id
|
int(11) |
No |
|
name
|
varchar(50) |
No |
|
link
|
varchar(255) |
No |
|
menuid
|
int(11) |
No |
0 |
parent
|
int(11) |
No |
0 |
admin_menu_link
|
varchar(255) |
No |
|
admin_menu_alt
|
varchar(255) |
No |
|
option
|
varchar(50) |
No |
|
ordering
|
int(11) |
No |
0 |
admin_menu_img
|
varchar(255) |
No |
|
iscore
|
tinyint(4) |
No |
0 |
params
|
text |
No |
|
enabled
|
tinyint(4) |
No |
1 |
bak_contact_details
Field |
Type |
Null |
Default |
id
|
int(11) |
No |
|
name
|
varchar(255) |
No |
|
alias
|
varchar(255) |
No |
|
con_position
|
varchar(255) |
Yes |
NULL |
address
|
text |
Yes |
NULL |
suburb
|
varchar(100) |
Yes |
NULL |
state
|
varchar(100) |
Yes |
NULL |
country
|
varchar(100) |
Yes |
NULL |
postcode
|
varchar(100) |
Yes |
NULL |
telephone
|
varchar(255) |
Yes |
NULL |
fax
|
varchar(255) |
Yes |
NULL |
misc
|
mediumtext |
Yes |
NULL |
image
|
varchar(255) |
Yes |
NULL |
imagepos
|
varchar(20) |
Yes |
NULL |
email_to
|
varchar(255) |
Yes |
NULL |
default_con
|
tinyint(1) |
No |
0 |
published
|
tinyint(1) |
No |
0 |
checked_out
|
int(11) |
No |
0 |
checked_out_time
|
datetime |
No |
0000-00-00 00:00:00 |
ordering
|
int(11) |
No |
0 |
params
|
text |
No |
|
user_id
|
int(11) |
No |
0 |
catid
|
int(11) |
No |
0 |
access
|
tinyint(3) |
No |
0 |
mobile
|
varchar(255) |
No |
|
webpage
|
varchar(255) |
No |
|
bak_content
Field |
Type |
Null |
Default |
id
|
int(11) |
No |
|
title
|
varchar(255) |
No |
|
alias
|
varchar(255) |
No |
|
title_alias
|
varchar(255) |
No |
|
introtext
|
mediumtext |
No |
|
fulltext
|
mediumtext |
No |
|
state
|
tinyint(3) |
No |
0 |
sectionid
|
int(11) |
No |
0 |
mask
|
int(11) |
No |
0 |
catid
|
int(11) |
No |
0 |
created
|
datetime |
No |
0000-00-00 00:00:00 |
created_by
|
int(11) |
No |
0 |
created_by_alias
|
varchar(255) |
No |
|
modified
|
datetime |
No |
0000-00-00 00:00:00 |
modified_by
|
int(11) |
No |
0 |
checked_out
|
int(11) |
No |
0 |
checked_out_time
|
datetime |
No |
0000-00-00 00:00:00 |
publish_up
|
datetime |
No |
0000-00-00 00:00:00 |
publish_down
|
datetime |
No |
0000-00-00 00:00:00 |
images
|
text |
No |
|
urls
|
text |
No |
|
attribs
|
text |
No |
|
version
|
int(11) |
No |
1 |
parentid
|
int(11) |
No |
0 |
ordering
|
int(11) |
No |
0 |
metakey
|
text |
No |
|
metadesc
|
text |
No |
|
access
|
int(11) |
No |
0 |
hits
|
int(11) |
No |
0 |
metadata
|
text |
No |
|
bak_content_frontpage
Field |
Type |
Null |
Default |
content_id
|
int(11) |
No |
0 |
ordering
|
int(11) |
No |
0 |
bak_content_rating
Field |
Type |
Null |
Default |
content_id
|
int(11) |
No |
0 |
rating_sum
|
int(11) |
No |
0 |
rating_count
|
int(11) |
No |
0 |
lastip
|
varchar(50) |
No |
|
bak_core_acl_aro
Field |
Type |
Null |
Default |
id
|
int(11) |
No |
|
section_value
|
varchar(240) |
No |
0 |
value
|
varchar(240) |
No |
|
order_value
|
int(11) |
No |
0 |
name
|
varchar(255) |
No |
|
hidden
|
int(11) |
No |
0 |
bak_core_acl_aro_groups
Field |
Type |
Null |
Default |
id
|
int(11) |
No |
|
parent_id
|
int(11) |
No |
0 |
name
|
varchar(255) |
No |
|
lft
|
int(11) |
No |
0 |
rgt
|
int(11) |
No |
0 |
value
|
varchar(255) |
No |
|
bak_core_acl_aro_map
Field |
Type |
Null |
Default |
acl_id
|
int(11) |
No |
0 |
section_value
|
varchar(230) |
No |
0 |
value
|
varchar(100) |
No |
|
bak_core_acl_aro_sections
Field |
Type |
Null |
Default |
id
|
int(11) |
No |
|
value
|
varchar(230) |
No |
|
order_value
|
int(11) |
No |
0 |
name
|
varchar(230) |
No |
|
hidden
|
int(11) |
No |
0 |
bak_core_acl_groups_aro_map
Field |
Type |
Null |
Default |
group_id
|
int(11) |
No |
0 |
section_value
|
varchar(240) |
No |
|
aro_id
|
int(11) |
No |
0 |
bak_core_log_items
Field |
Type |
Null |
Default |
time_stamp
|
date |
No |
0000-00-00 |
item_table
|
varchar(50) |
No |
|
item_id
|
int(11) |
No |
0 |
hits
|
int(11) |
No |
0 |
bak_core_log_searches
Field |
Type |
Null |
Default |
search_term
|
varchar(128) |
No |
|
hits
|
int(11) |
No |
0 |
bak_groups
Field |
Type |
Null |
Default |
id
|
tinyint(3) |
No |
0 |
name
|
varchar(50) |
No |
|
bak_menu
Field |
Type |
Null |
Default |
id
|
int(11) |
No |
|
menutype
|
varchar(75) |
Yes |
NULL |
name
|
varchar(255) |
Yes |
NULL |
alias
|
varchar(255) |
No |
|
link
|
text |
Yes |
NULL |
type
|
varchar(50) |
No |
|
published
|
tinyint(1) |
No |
0 |
parent
|
int(11) |
No |
0 |
componentid
|
int(11) |
No |
0 |
sublevel
|
int(11) |
Yes |
0 |
ordering
|
int(11) |
Yes |
0 |
checked_out
|
int(11) |
No |
0 |
checked_out_time
|
datetime |
No |
0000-00-00 00:00:00 |
pollid
|
int(11) |
No |
0 |
browserNav
|
tinyint(4) |
Yes |
0 |
access
|
tinyint(3) |
No |
0 |
utaccess
|
tinyint(3) |
No |
0 |
params
|
text |
No |
|
lft
|
int(11) |
No |
0 |
rgt
|
int(11) |
No |
0 |
home
|
int(1) |
No |
0 |
bak_menu_types
Field |
Type |
Null |
Default |
id
|
int(10) |
No |
|
menutype
|
varchar(75) |
No |
|
title
|
varchar(255) |
No |
|
description
|
varchar(255) |
No |
|
bak_messages
Field |
Type |
Null |
Default |
message_id
|
int(10) |
No |
|
user_id_from
|
int(10) |
No |
0 |
user_id_to
|
int(10) |
No |
0 |
folder_id
|
int(10) |
No |
0 |
date_time
|
datetime |
No |
0000-00-00 00:00:00 |
state
|
int(11) |
No |
0 |
priority
|
int(1) |
No |
0 |
subject
|
text |
No |
|
message
|
text |
No |
|
bak_messages_cfg
Field |
Type |
Null |
Default |
user_id
|
int(10) |
No |
0 |
cfg_name
|
varchar(100) |
No |
|
cfg_value
|
varchar(255) |
No |
|
bak_migration_backlinks
Field |
Type |
Null |
Default |
itemid
|
int(11) |
No |
0 |
name
|
varchar(100) |
No |
|
url
|
text |
No |
|
sefurl
|
text |
No |
|
newurl
|
text |
No |
|
bak_modules
Field |
Type |
Null |
Default |
id
|
int(11) |
No |
|
title
|
text |
No |
|
content
|
text |
No |
|
ordering
|
int(11) |
No |
0 |
position
|
varchar(50) |
Yes |
NULL |
checked_out
|
int(11) |
No |
0 |
checked_out_time
|
datetime |
No |
0000-00-00 00:00:00 |
published
|
tinyint(1) |
No |
0 |
module
|
varchar(50) |
Yes |
NULL |
numnews
|
int(11) |
No |
0 |
access
|
tinyint(3) |
No |
0 |
showtitle
|
tinyint(3) |
No |
1 |
params
|
text |
No |
|
iscore
|
tinyint(4) |
No |
0 |
client_id
|
tinyint(4) |
No |
0 |
control
|
text |
No |
|
bak_modules_menu
Field |
Type |
Null |
Default |
moduleid
|
int(11) |
No |
0 |
menuid
|
int(11) |
No |
0 |
bak_newsfeeds
Field |
Type |
Null |
Default |
catid
|
int(11) |
No |
0 |
id
|
int(11) |
No |
|
name
|
text |
No |
|
alias
|
varchar(255) |
No |
|
link
|
text |
No |
|
filename
|
varchar(200) |
Yes |
NULL |
published
|
tinyint(1) |
No |
0 |
numarticles
|
int(11) |
No |
1 |
cache_time
|
int(11) |
No |
3600 |
checked_out
|
tinyint(3) |
No |
0 |
checked_out_time
|
datetime |
No |
0000-00-00 00:00:00 |
ordering
|
int(11) |
No |
0 |
rtl
|
tinyint(4) |
No |
0 |
bak_plugins
Field |
Type |
Null |
Default |
id
|
int(11) |
No |
|
name
|
varchar(100) |
No |
|
element
|
varchar(100) |
No |
|
folder
|
varchar(100) |
No |
|
access
|
tinyint(3) |
No |
0 |
ordering
|
int(11) |
No |
0 |
published
|
tinyint(3) |
No |
0 |
iscore
|
tinyint(3) |
No |
0 |
client_id
|
tinyint(3) |
No |
0 |
checked_out
|
int(11) |
No |
0 |
checked_out_time
|
datetime |
No |
0000-00-00 00:00:00 |
params
|
text |
No |
|
bak_poll_data
Field |
Type |
Null |
Default |
id
|
int(11) |
No |
|
pollid
|
int(11) |
No |
0 |
text
|
text |
No |
|
hits
|
int(11) |
No |
0 |
bak_poll_date
Field |
Type |
Null |
Default |
id
|
bigint(20) |
No |
|
date
|
datetime |
No |
0000-00-00 00:00:00 |
vote_id
|
int(11) |
No |
0 |
poll_id
|
int(11) |
No |
0 |
bak_poll_menu
Field |
Type |
Null |
Default |
pollid
|
int(11) |
No |
0 |
menuid
|
int(11) |
No |
0 |
bak_polls
Field |
Type |
Null |
Default |
id
|
int(11) |
No |
|
title
|
varchar(255) |
No |
|
alias
|
varchar(255) |
No |
|
voters
|
int(9) |
No |
0 |
checked_out
|
int(11) |
No |
0 |
checked_out_time
|
datetime |
No |
0000-00-00 00:00:00 |
published
|
tinyint(1) |
No |
0 |
access
|
int(11) |
No |
0 |
lag
|
int(11) |
No |
0 |
bak_sections
Field |
Type |
Null |
Default |
id
|
int(11) |
No |
|
title
|
varchar(255) |
No |
|
name
|
varchar(255) |
No |
|
alias
|
varchar(255) |
No |
|
image
|
text |
No |
|
scope
|
varchar(50) |
No |
|
image_position
|
varchar(30) |
No |
|
description
|
text |
No |
|
published
|
tinyint(1) |
No |
0 |
checked_out
|
int(11) |
No |
0 |
checked_out_time
|
datetime |
No |
0000-00-00 00:00:00 |
ordering
|
int(11) |
No |
0 |
access
|
tinyint(3) |
No |
0 |
count
|
int(11) |
No |
0 |
params
|
text |
No |
|
bak_session
Field |
Type |
Null |
Default |
username
|
varchar(150) |
Yes |
|
time
|
varchar(14) |
Yes |
|
session_id
|
varchar(200) |
No |
0 |
guest
|
tinyint(4) |
Yes |
1 |
userid
|
int(11) |
Yes |
0 |
usertype
|
varchar(50) |
Yes |
|
gid
|
tinyint(3) |
No |
0 |
client_id
|
tinyint(3) |
No |
0 |
data
|
longtext |
Yes |
NULL |
bak_stats_agents
Field |
Type |
Null |
Default |
agent
|
varchar(255) |
No |
|
type
|
tinyint(1) |
No |
0 |
hits
|
int(11) |
No |
1 |
bak_templates_menu
Field |
Type |
Null |
Default |
template
|
varchar(255) |
No |
|
menuid
|
int(11) |
No |
0 |
client_id
|
tinyint(4) |
No |
0 |
bak_users
Field |
Type |
Null |
Default |
id
|
int(11) |
No |
|
name
|
varchar(255) |
No |
|
username
|
varchar(150) |
No |
|
email
|
varchar(100) |
No |
|
password
|
varchar(100) |
No |
|
usertype
|
varchar(25) |
No |
|
block
|
tinyint(4) |
No |
0 |
sendEmail
|
tinyint(4) |
Yes |
0 |
gid
|
tinyint(3) |
No |
1 |
registerDate
|
datetime |
No |
0000-00-00 00:00:00 |
lastvisitDate
|
datetime |
No |
0000-00-00 00:00:00 |
activation
|
varchar(100) |
No |
|
params
|
text |
No |
|
bak_weblinks
Field |
Type |
Null |
Default |
id
|
int(11) |
No |
|
catid
|
int(11) |
No |
0 |
sid
|
int(11) |
No |
0 |
title
|
varchar(250) |
No |
|
alias
|
varchar(255) |
No |
|
url
|
varchar(250) |
No |
|
description
|
text |
No |
|
date
|
datetime |
No |
0000-00-00 00:00:00 |
hits
|
int(11) |
No |
0 |
published
|
tinyint(1) |
No |
0 |
checked_out
|
int(11) |
No |
0 |
checked_out_time
|
datetime |
No |
0000-00-00 00:00:00 |
ordering
|
int(11) |
No |
0 |
archived
|
tinyint(1) |
No |
0 |
approved
|
tinyint(1) |
No |
1 |
params
|
text |
No |
|
bd_world_cities
Field |
Type |
Null |
Default |
cityID
|
int(11) |
No |
|
rID
|
int(4) |
No |
0 |
cID
|
int(3) |
No |
0 |
cityName
|
varchar(255) |
No |
|
bd_world_countries
Field |
Type |
Null |
Default |
cID
|
int(3) |
No |
|
cName
|
varchar(255) |
No |
|
bd_world_regions
Field |
Type |
Null |
Default |
rID
|
int(4) |
No |
|
rCountry
|
int(3) |
No |
0 |
rName
|
varchar(255) |
No |
|
bos_ad_types
Field |
Type |
Null |
Default |
type_id
|
tinyint(3) |
No |
|
type_title
|
varchar(255) |
No |
|
type_required
|
int(6) |
No |
0 |
type_use
|
int(6) |
No |
0 |
option1
|
varchar(255) |
No |
|
def_option1
|
varchar(255) |
No |
|
option2
|
varchar(255) |
No |
|
def_option2
|
varchar(255) |
No |
|
option3
|
varchar(255) |
No |
|
def_option3
|
varchar(255) |
No |
|
option4
|
varchar(255) |
No |
|
def_option4
|
varchar(255) |
No |
|
option5
|
varchar(255) |
No |
|
def_option5
|
varchar(255) |
No |
|
option6
|
varchar(255) |
No |
|
def_option6
|
varchar(255) |
No |
|
option7
|
varchar(255) |
No |
|
def_option7
|
varchar(255) |
No |
|
option8
|
varchar(255) |
No |
|
def_option8
|
varchar(255) |
No |
|
option9
|
varchar(255) |
No |
|
def_option9
|
varchar(255) |
No |
|
option10
|
varchar(255) |
No |
|
def_option10
|
varchar(255) |
No |
|
template
|
mediumtext |
No |
|
bos_ads
Field |
Type |
Null |
Default |
ad_id
|
int(10) |
No |
|
ad_status
|
tinyint(1) |
No |
0 |
ad_user_id
|
int(5) |
No |
0 |
ad_category
|
int(5) |
No |
0 |
ad_date_begin
|
varchar(10) |
No |
|
ad_date_end
|
varchar(10) |
No |
|
ad_type
|
tinyint(3) |
No |
0 |
ad_title
|
varchar(255) |
No |
|
ad_description
|
text |
No |
|
ad_image1
|
varchar(255) |
No |
|
ad_image2
|
varchar(255) |
No |
|
ad_image3
|
varchar(255) |
No |
|
ad_image4
|
varchar(255) |
No |
|
ad_image5
|
varchar(255) |
No |
|
ad_options
|
int(10) |
No |
0 |
ad_optional_1
|
varchar(255) |
No |
|
ad_optional_2
|
varchar(255) |
No |
|
ad_optional_3
|
varchar(255) |
No |
|
ad_optional_4
|
varchar(255) |
No |
|
ad_optional_5
|
varchar(255) |
No |
|
ad_type_optional1
|
varchar(255) |
No |
|
ad_type_optional2
|
varchar(255) |
No |
|
ad_type_optional3
|
varchar(255) |
No |
|
ad_type_optional4
|
varchar(255) |
No |
|
ad_type_optional5
|
varchar(255) |
No |
|
ad_type_optional6
|
varchar(255) |
No |
|
ad_type_optional7
|
varchar(255) |
No |
|
ad_type_optional8
|
varchar(255) |
No |
|
ad_type_optional9
|
varchar(255) |
No |
|
ad_type_optional10
|
varchar(255) |
No |
|
ad_price
|
varchar(255) |
No |
0.00 |
ad_condition
|
tinyint(4) |
No |
0 |
ad_views
|
int(4) |
No |
0 |
ad_address
|
varchar(255) |
No |
|
ad_city
|
varchar(255) |
No |
|
ad_state
|
varchar(255) |
No |
|
ad_postal
|
varchar(255) |
No |
|
ad_country
|
varchar(255) |
No |
|
ad_city_code
|
int(11) |
No |
0 |
ad_state_code
|
int(4) |
No |
0 |
ad_country_code
|
int(3) |
No |
0 |
ad_fee
|
float(6,2) |
No |
0.00 |
ad_anon_name
|
varchar(255) |
No |
|
ad_anon_email
|
varchar(255) |
No |
|
bos_banner_groups
Field |
Type |
Null |
Default |
group_id
|
int(3) |
No |
|
group_banners
|
varchar(255) |
No |
|
group_title
|
varchar(255) |
No |
|
bos_banners
Field |
Type |
Null |
Default |
banner_id
|
int(5) |
No |
|
banner_name
|
varchar(255) |
No |
|
banner_text
|
varchar(255) |
No |
|
banner_url
|
varchar(255) |
No |
|
banner_image
|
varchar(255) |
No |
|
banner_image_url
|
varchar(255) |
No |
|
banner_image_tracker
|
varchar(255) |
No |
|
banner_height
|
int(4) |
No |
0 |
banner_width
|
int(4) |
No |
0 |
bos_categories
Field |
Type |
Null |
Default |
category_id
|
int(5) |
No |
|
category_order
|
int(3) |
No |
0 |
category_parent
|
int(5) |
No |
0 |
category_title
|
varchar(255) |
No |
|
category_desc
|
text |
No |
|
category_img
|
varchar(255) |
No |
|
category_ad_types
|
varchar(255) |
No |
|
category_ad_prices
|
varchar(255) |
No |
|
category_optional_1
|
varchar(255) |
No |
|
category_optional_1_def
|
varchar(255) |
No |
|
category_optional_2
|
varchar(255) |
No |
|
category_optional_2_def
|
varchar(255) |
No |
|
category_optional_3
|
varchar(255) |
No |
|
category_optional_3_def
|
varchar(255) |
No |
|
category_optional_4
|
varchar(255) |
No |
|
category_optional_4_def
|
varchar(255) |
No |
|
category_optional_5
|
varchar(255) |
No |
|
category_optional_5_def
|
varchar(255) |
No |
|
category_subs
|
int(5) |
No |
0 |
category_listings
|
int(5) |
No |
0 |
banner_top
|
varchar(5) |
No |
|
banner_bottom
|
varchar(5) |
No |
|
category_related
|
varchar(255) |
No |
|
bos_coupons
Field |
Type |
Null |
Default |
coupon_id
|
int(11) |
No |
|
coupon_code
|
varchar(255) |
No |
|
coupon_percent
|
tinyint(3) |
No |
0 |
coupon_amount
|
float(6,2) |
No |
0.00 |
coupon_expires
|
date |
No |
0000-00-00 |
coupon_uses
|
int(5) |
No |
0 |
coupon_restrict
|
tinyint(1) |
No |
0 |
coupon_type
|
tinyint(1) |
No |
0 |
bos_coupons_lock
Field |
Type |
Null |
Default |
coupon_code
|
varchar(255) |
No |
|
user_id
|
int(5) |
No |
0 |
bos_statistics
Field |
Type |
Null |
Default |
stat_my
|
varchar(7) |
No |
|
stat_item
|
char(1) |
No |
|
stat_detail
|
varchar(10) |
No |
|
stat_count
|
float(8,2) |
No |
0.00 |
bos_system
Field |
Type |
Null |
Default |
id
|
int(2) |
No |
|
item
|
varchar(255) |
No |
|
value
|
text |
No |
|
bosdevUUS
Field |
Type |
Null |
Default |
id
|
int(5) |
No |
|
username
|
varchar(255) |
No |
|
password
|
varchar(255) |
No |
|
email
|
varchar(255) |
No |
|
status
|
tinyint(1) |
No |
0 |
last_login
|
date |
No |
0000-00-00 |
bd1
|
tinyint(2) |
No |
0 |
bd2
|
varchar(255) |
No |
|
bd3
|
varchar(255) |
No |
|
bd4
|
varchar(255) |
No |
|
bd5
|
varchar(255) |
No |
|
bc1
|
tinyint(2) |
No |
0 |
bc2
|
varchar(255) |
No |
0 |
bc3
|
varchar(255) |
No |
|
bc4
|
varchar(255) |
No |
|
bc5
|
varchar(255) |
No |
|
bdir1
|
tinyint(2) |
No |
0 |
bdir2
|
varchar(255) |
No |
|
bdir3
|
varchar(255) |
No |
|
bdir4
|
varchar(255) |
No |
|
bdir5
|
varchar(255) |
No |
|
bm1
|
tinyint(2) |
No |
0 |
bm2
|
varchar(255) |
No |
|
bm3
|
varchar(255) |
No |
|
bm4
|
varchar(255) |
No |
|
bm5
|
varchar(255) |
No |
|
bn1
|
tinyint(2) |
No |
0 |
bn2
|
varchar(255) |
No |
|
bn3
|
varchar(255) |
No |
|
bn4
|
varchar(255) |
No |
|
bn5
|
varchar(255) |
No |
|
bf1
|
varchar(255) |
No |
|
bf2
|
varchar(255) |
No |
|
bf3
|
varchar(255) |
No |
|
bf4
|
varchar(255) |
No |
|
bf5
|
varchar(255) |
No |
|
bdl
|
varchar(255) |
No |
|
extraFName
|
varchar(255) |
No |
|
extraLName
|
varchar(255) |
No |
|
extraAddr1
|
varchar(255) |
No |
|
extraAddr2
|
varchar(255) |
No |
|
extraCity
|
varchar(255) |
No |
|
extraState
|
varchar(255) |
No |
|
extraPostal
|
varchar(255) |
No |
|
extraHPhone
|
varchar(255) |
No |
|
extraMPhone
|
varchar(255) |
No |
|
cooking
Field |
Type |
Null |
Default |
id
|
smallint(3) |
No |
|
name
|
varchar(35) |
No |
|
phone
|
varchar(15) |
No |
|
website
|
varchar(50) |
No |
|
location
|
varchar(35) |
No |
|
pic
|
varchar(35) |
No |
|
djs
Field |
Type |
Null |
Default |
id
|
smallint(4) |
No |
|
name
|
varchar(50) |
No |
|
phone1
|
varchar(15) |
No |
|
phone2
|
varchar(15) |
No |
|
type
|
varchar(50) |
No |
|
website
|
varchar(50) |
No |
|
location
|
varchar(35) |
No |
|
smallpic
|
varchar(35) |
No |
|
largepic
|
varchar(35) |
No |
|
email_autoresponders
Table comments : InnoDB free: 730112 kB
Field |
Type |
Null |
Default |
autoresponderid
|
int(11) |
No |
|
name
|
varchar(255) |
Yes |
NULL |
subject
|
varchar(255) |
Yes |
NULL |
format
|
char(1) |
Yes |
NULL |
textbody
|
longtext |
Yes |
NULL |
htmlbody
|
longtext |
Yes |
NULL |
createdate
|
int(11) |
Yes |
0 |
active
|
int(11) |
Yes |
0 |
hoursaftersubscription
|
int(11) |
Yes |
0 |
ownerid
|
int(11) |
No |
0 |
searchcriteria
|
mediumtext |
Yes |
NULL |
listid
|
int(11) |
Yes |
0 |
tracklinks
|
char(1) |
Yes |
1 |
trackopens
|
char(1) |
Yes |
1 |
multipart
|
char(1) |
Yes |
1 |
queueid
|
int(11) |
Yes |
0 |
sendfromname
|
varchar(255) |
Yes |
NULL |
sendfromemail
|
varchar(255) |
Yes |
NULL |
replytoemail
|
varchar(255) |
Yes |
NULL |
bounceemail
|
varchar(255) |
Yes |
NULL |
charset
|
varchar(255) |
Yes |
NULL |
embedimages
|
char(1) |
Yes |
0 |
to_firstname
|
int(11) |
Yes |
0 |
to_lastname
|
int(11) |
Yes |
0 |
autorespondersize
|
int(11) |
Yes |
0 |
email_banned_emails
Table comments : InnoDB free: 730112 kB
Field |
Type |
Null |
Default |
banid
|
int(11) |
No |
|
emailaddress
|
varchar(255) |
Yes |
NULL |
list
|
varchar(10) |
Yes |
NULL |
bandate
|
int(11) |
Yes |
NULL |
email_config_settings
Field |
Type |
Null |
Default |
area
|
varchar(255) |
No |
|
areavalue
|
text |
Yes |
NULL |
email_customfield_lists
Table comments : InnoDB free: 730112 kB
Field |
Type |
Null |
Default |
cflid
|
int(11) |
No |
|
fieldid
|
int(11) |
No |
0 |
listid
|
int(11) |
No |
0 |
email_customfields
Table comments : InnoDB free: 730112 kB
Field |
Type |
Null |
Default |
fieldid
|
int(11) |
No |
|
name
|
varchar(255) |
Yes |
NULL |
fieldtype
|
varchar(100) |
Yes |
NULL |
defaultvalue
|
varchar(255) |
Yes |
NULL |
required
|
char(1) |
Yes |
0 |
fieldsettings
|
mediumtext |
Yes |
NULL |
createdate
|
int(11) |
Yes |
0 |
ownerid
|
int(11) |
Yes |
0 |
email_form_customfields
Table comments : InnoDB free: 730112 kB
Field |
Type |
Null |
Default |
formid
|
int(11) |
Yes |
0 |
fieldid
|
varchar(10) |
Yes |
0 |
fieldorder
|
int(11) |
Yes |
0 |
email_form_lists
Table comments : InnoDB free: 730112 kB
Field |
Type |
Null |
Default |
formid
|
int(11) |
No |
0 |
listid
|
int(11) |
Yes |
0 |
email_form_pages
Table comments : InnoDB free: 730112 kB
Field |
Type |
Null |
Default |
pageid
|
int(11) |
No |
|
formid
|
int(11) |
Yes |
0 |
pagetype
|
varchar(100) |
Yes |
NULL |
html
|
longtext |
Yes |
NULL |
url
|
varchar(255) |
Yes |
NULL |
sendfromname
|
varchar(255) |
Yes |
NULL |
sendfromemail
|
varchar(255) |
Yes |
NULL |
replytoemail
|
varchar(255) |
Yes |
NULL |
bounceemail
|
varchar(255) |
Yes |
NULL |
emailsubject
|
varchar(255) |
Yes |
NULL |
emailhtml
|
longtext |
Yes |
NULL |
emailtext
|
longtext |
Yes |
NULL |
email_forms
Table comments : InnoDB free: 730112 kB
Field |
Type |
Null |
Default |
formid
|
int(11) |
No |
|
name
|
varchar(255) |
Yes |
NULL |
design
|
varchar(255) |
Yes |
NULL |
formhtml
|
longtext |
Yes |
NULL |
chooseformat
|
varchar(2) |
Yes |
NULL |
changeformat
|
char(1) |
Yes |
0 |
sendthanks
|
char(1) |
Yes |
0 |
requireconfirm
|
char(1) |
Yes |
0 |
ownerid
|
int(11) |
Yes |
0 |
formtype
|
char(1) |
Yes |
NULL |
createdate
|
int(11) |
Yes |
0 |
contactform
|
char(1) |
Yes |
0 |
usecaptcha
|
char(1) |
Yes |
0 |
email_jobs
Table comments : InnoDB free: 730112 kB
Field |
Type |
Null |
Default |
jobid
|
int(11) |
No |
|
jobtype
|
varchar(255) |
Yes |
NULL |
jobstatus
|
char(1) |
Yes |
NULL |
jobtime
|
int(11) |
Yes |
0 |
jobdetails
|
text |
Yes |
NULL |
fkid
|
int(11) |
Yes |
0 |
lastupdatetime
|
int(11) |
Yes |
0 |
fktype
|
varchar(255) |
Yes |
NULL |
queueid
|
int(11) |
Yes |
0 |
ownerid
|
int(11) |
Yes |
0 |
approved
|
int(11) |
Yes |
0 |
authorisedtosend
|
int(11) |
Yes |
0 |
resendcount
|
int(11) |
Yes |
0 |
email_jobs_lists
Table comments : InnoDB free: 730112 kB
Field |
Type |
Null |
Default |
jobid
|
int(11) |
Yes |
0 |
listid
|
int(11) |
Yes |
0 |
email_links
Table comments : InnoDB free: 730112 kB
Field |
Type |
Null |
Default |
linkid
|
int(11) |
No |
|
url
|
varchar(255) |
Yes |
NULL |
email_list_subscriber_bounces
Table comments : InnoDB free: 730112 kB
Field |
Type |
Null |
Default |
bounceid
|
int(11) |
No |
|
subscriberid
|
int(11) |
Yes |
0 |
statid
|
int(11) |
Yes |
0 |
listid
|
int(11) |
Yes |
0 |
bouncetime
|
int(11) |
Yes |
0 |
bouncetype
|
varchar(255) |
Yes |
NULL |
bouncerule
|
varchar(255) |
Yes |
NULL |
bouncemessage
|
longtext |
Yes |
NULL |
email_list_subscribers
Table comments : InnoDB free: 730112 kB
Field |
Type |
Null |
Default |
subscriberid
|
int(11) |
No |
|
listid
|
int(11) |
No |
0 |
emailaddress
|
varchar(200) |
Yes |
NULL |
domainname
|
varchar(100) |
Yes |
NULL |
format
|
char(1) |
Yes |
NULL |
confirmed
|
char(1) |
Yes |
0 |
confirmcode
|
varchar(32) |
Yes |
NULL |
requestdate
|
int(11) |
Yes |
0 |
requestip
|
varchar(20) |
Yes |
NULL |
confirmdate
|
int(11) |
Yes |
0 |
confirmip
|
varchar(20) |
Yes |
NULL |
subscribedate
|
int(11) |
Yes |
0 |
bounced
|
int(11) |
Yes |
0 |
unsubscribed
|
int(11) |
Yes |
0 |
unsubscribeconfirmed
|
char(1) |
Yes |
0 |
formid
|
int(11) |
Yes |
0 |
email_list_subscribers_unsubscribe
Table comments : InnoDB free: 730112 kB
Field |
Type |
Null |
Default |
subscriberid
|
int(11) |
No |
0 |
unsubscribetime
|
int(11) |
No |
0 |
unsubscribeip
|
varchar(20) |
Yes |
NULL |
unsubscriberequesttime
|
int(11) |
Yes |
0 |
unsubscriberequestip
|
varchar(20) |
Yes |
NULL |
listid
|
int(11) |
No |
0 |
statid
|
int(11) |
Yes |
0 |
unsubscribearea
|
varchar(20) |
Yes |
NULL |
email_lists
Table comments : InnoDB free: 730112 kB
Field |
Type |
Null |
Default |
listid
|
int(11) |
No |
|
name
|
varchar(255) |
Yes |
NULL |
ownername
|
varchar(255) |
Yes |
NULL |
owneremail
|
varchar(100) |
Yes |
NULL |
bounceemail
|
varchar(100) |
Yes |
NULL |
replytoemail
|
varchar(100) |
Yes |
NULL |
bounceserver
|
varchar(100) |
Yes |
NULL |
bounceusername
|
varchar(100) |
Yes |
NULL |
bouncepassword
|
varchar(100) |
Yes |
NULL |
extramailsettings
|
varchar(100) |
Yes |
NULL |
companyname
|
varchar(255) |
Yes |
NULL |
companyaddress
|
varchar(255) |
Yes |
NULL |
companyphone
|
varchar(20) |
Yes |
NULL |
format
|
char(1) |
Yes |
NULL |
notifyowner
|
char(1) |
Yes |
0 |
imapaccount
|
char(1) |
Yes |
0 |
createdate
|
int(11) |
Yes |
0 |
subscribecount
|
int(11) |
Yes |
0 |
unsubscribecount
|
int(11) |
Yes |
0 |
bouncecount
|
int(11) |
Yes |
0 |
processbounce
|
char(1) |
Yes |
0 |
agreedelete
|
char(1) |
Yes |
0 |
visiblefields
|
text |
No |
|
ownerid
|
int(11) |
Yes |
0 |
email_log_system_administrator
Table comments : InnoDB free: 730112 kB
Field |
Type |
Null |
Default |
logid
|
int(11) |
No |
|
loguserid
|
int(11) |
No |
0 |
logip
|
varchar(30) |
No |
|
logdate
|
int(11) |
No |
0 |
logtodo
|
varchar(100) |
No |
|
logdata
|
text |
No |
|
email_log_system_system
Table comments : InnoDB free: 730112 kB
Field |
Type |
Null |
Default |
logid
|
int(11) |
No |
|
logtype
|
varchar(20) |
Yes |
NULL |
logmodule
|
varchar(100) |
No |
|
logseverity
|
char(1) |
No |
4 |
logsummary
|
varchar(250) |
No |
|
logmsg
|
text |
No |
|
logdate
|
int(11) |
No |
0 |
email_module_tracker
Table comments : InnoDB free: 730112 kB
Field |
Type |
Null |
Default |
statid
|
int(11) |
No |
0 |
stattype
|
varchar(50) |
No |
|
trackername
|
varchar(50) |
No |
|
newsletterid
|
int(11) |
Yes |
NULL |
datastring
|
text |
Yes |
NULL |
email_modules
Table comments : InnoDB free: 730112 kB
Field |
Type |
Null |
Default |
modulename
|
varchar(50) |
No |
|
moduleversion
|
int(11) |
Yes |
0 |
email_newsletters
Table comments : InnoDB free: 730112 kB
Field |
Type |
Null |
Default |
newsletterid
|
int(11) |
No |
|
name
|
varchar(255) |
Yes |
NULL |
format
|
char(1) |
Yes |
NULL |
subject
|
varchar(255) |
Yes |
NULL |
textbody
|
longtext |
Yes |
NULL |
htmlbody
|
longtext |
Yes |
NULL |
createdate
|
int(11) |
Yes |
0 |
active
|
int(11) |
Yes |
0 |
archive
|
int(11) |
Yes |
0 |
ownerid
|
int(11) |
No |
0 |
email_queues
Table comments : InnoDB free: 730112 kB
Field |
Type |
Null |
Default |
queueid
|
int(11) |
Yes |
0 |
queuetype
|
varchar(255) |
Yes |
NULL |
ownerid
|
int(11) |
No |
0 |
recipient
|
int(11) |
Yes |
0 |
processed
|
char(1) |
Yes |
0 |
sent
|
char(1) |
Yes |
0 |
processtime
|
datetime |
Yes |
NULL |
email_queues_sequence
Table comments : InnoDB free: 730112 kB
Field |
Type |
Null |
Default |
id
|
int(11) |
No |
|
email_queues_unsent
Table comments : InnoDB free: 730112 kB
Field |
Type |
Null |
Default |
recipient
|
int(11) |
No |
0 |
queueid
|
int(11) |
Yes |
0 |
reasoncode
|
int(11) |
Yes |
0 |
reason
|
text |
Yes |
NULL |
email_segments
Table comments : InnoDB free: 730112 kB
Field |
Type |
Null |
Default |
segmentid
|
int(11) |
No |
|
segmentname
|
varchar(255) |
No |
|
createdate
|
int(11) |
Yes |
0 |
ownerid
|
int(11) |
No |
0 |
searchinfo
|
text |
No |
|
email_settings
Table comments : InnoDB free: 730112 kB
Field |
Type |
Null |
Default |
cronok
|
char(1) |
No |
0 |
cronrun1
|
int(11) |
Yes |
0 |
cronrun2
|
int(11) |
Yes |
0 |
database_version
|
int(11) |
Yes |
0 |
email_settings_cron_schedule
Field |
Type |
Null |
Default |
jobtype
|
varchar(20) |
No |
|
lastrun
|
int(11) |
Yes |
0 |
email_stats_autoresponders
Table comments : InnoDB free: 730112 kB
Field |
Type |
Null |
Default |
statid
|
int(11) |
No |
0 |
htmlrecipients
|
int(11) |
Yes |
0 |
textrecipients
|
int(11) |
Yes |
0 |
multipartrecipients
|
int(11) |
Yes |
0 |
bouncecount_soft
|
int(11) |
Yes |
0 |
bouncecount_hard
|
int(11) |
Yes |
0 |
bouncecount_unknown
|
int(11) |
Yes |
0 |
unsubscribecount
|
int(11) |
Yes |
0 |
autoresponderid
|
int(11) |
Yes |
0 |
linkclicks
|
int(11) |
Yes |
0 |
emailopens
|
int(11) |
Yes |
0 |
emailforwards
|
int(11) |
Yes |
0 |
emailopens_unique
|
int(11) |
Yes |
0 |
htmlopens
|
int(11) |
Yes |
0 |
htmlopens_unique
|
int(11) |
Yes |
0 |
textopens
|
int(11) |
Yes |
0 |
textopens_unique
|
int(11) |
Yes |
0 |
hiddenby
|
int(11) |
Yes |
0 |
email_stats_autoresponders_recipients
Table comments : InnoDB free: 730112 kB
Field |
Type |
Null |
Default |
statid
|
int(11) |
No |
0 |
autoresponderid
|
int(11) |
Yes |
0 |
send_status
|
char(1) |
Yes |
NULL |
recipient
|
int(11) |
Yes |
0 |
reason
|
varchar(20) |
Yes |
NULL |
sendtime
|
int(11) |
Yes |
NULL |
email_stats_emailforwards
Table comments : InnoDB free: 730112 kB
Field |
Type |
Null |
Default |
forwardid
|
int(11) |
No |
|
forwardtime
|
int(11) |
Yes |
0 |
forwardip
|
varchar(20) |
Yes |
NULL |
subscriberid
|
int(11) |
Yes |
NULL |
statid
|
int(11) |
Yes |
0 |
subscribed
|
int(11) |
Yes |
0 |
listid
|
int(11) |
Yes |
NULL |
emailaddress
|
varchar(255) |
Yes |
NULL |
email_stats_emailopens
Table comments : InnoDB free: 730112 kB
Field |
Type |
Null |
Default |
openid
|
int(11) |
No |
|
subscriberid
|
int(11) |
Yes |
0 |
statid
|
int(11) |
Yes |
0 |
opentime
|
int(11) |
Yes |
0 |
openip
|
varchar(20) |
Yes |
NULL |
fromlink
|
char(1) |
Yes |
0 |
opentype
|
char(1) |
Yes |
u |
email_stats_linkclicks
Table comments : InnoDB free: 730112 kB
Field |
Type |
Null |
Default |
clickid
|
int(11) |
No |
|
clicktime
|
int(11) |
Yes |
0 |
clickip
|
varchar(20) |
Yes |
NULL |
subscriberid
|
int(11) |
Yes |
0 |
statid
|
int(11) |
Yes |
0 |
linkid
|
int(11) |
Yes |
0 |
email_stats_links
Table comments : InnoDB free: 730112 kB
Field |
Type |
Null |
Default |
statid
|
int(11) |
Yes |
0 |
linkid
|
int(11) |
Yes |
0 |
email_stats_newsletter_lists
Table comments : InnoDB free: 730112 kB
Field |
Type |
Null |
Default |
statid
|
int(11) |
Yes |
NULL |
listid
|
int(11) |
Yes |
0 |
email_stats_newsletters
Table comments : InnoDB free: 730112 kB
Field |
Type |
Null |
Default |
statid
|
int(11) |
No |
0 |
queueid
|
int(11) |
Yes |
0 |
jobid
|
int(11) |
Yes |
0 |
starttime
|
int(11) |
Yes |
0 |
finishtime
|
int(11) |
Yes |
0 |
htmlrecipients
|
int(11) |
Yes |
0 |
textrecipients
|
int(11) |
Yes |
0 |
multipartrecipients
|
int(11) |
Yes |
0 |
trackopens
|
char(1) |
Yes |
0 |
tracklinks
|
char(1) |
Yes |
0 |
bouncecount_soft
|
int(11) |
Yes |
0 |
bouncecount_hard
|
int(11) |
Yes |
0 |
bouncecount_unknown
|
int(11) |
Yes |
0 |
unsubscribecount
|
int(11) |
Yes |
0 |
newsletterid
|
int(11) |
Yes |
0 |
sendfromname
|
varchar(200) |
Yes |
NULL |
sendfromemail
|
varchar(200) |
Yes |
NULL |
bounceemail
|
varchar(200) |
Yes |
NULL |
replytoemail
|
varchar(200) |
Yes |
NULL |
charset
|
varchar(200) |
Yes |
NULL |
sendinformation
|
mediumtext |
Yes |
NULL |
sendsize
|
int(11) |
Yes |
0 |
sentby
|
int(11) |
Yes |
0 |
notifyowner
|
char(1) |
Yes |
0 |
linkclicks
|
int(11) |
Yes |
0 |
emailopens
|
int(11) |
Yes |
0 |
emailforwards
|
int(11) |
Yes |
0 |
emailopens_unique
|
int(11) |
Yes |
0 |
htmlopens
|
int(11) |
Yes |
0 |
htmlopens_unique
|
int(11) |
Yes |
0 |
textopens
|
int(11) |
Yes |
0 |
textopens_unique
|
int(11) |
Yes |
0 |
hiddenby
|
int(11) |
Yes |
0 |
sendtestmode
|
int(11) |
Yes |
0 |
email_stats_sequence
Table comments : InnoDB free: 730112 kB
Field |
Type |
Null |
Default |
id
|
int(11) |
No |
|
email_stats_users
Table comments : InnoDB free: 730112 kB
Field |
Type |
Null |
Default |
userid
|
int(11) |
Yes |
0 |
statid
|
int(11) |
No |
0 |
jobid
|
int(11) |
Yes |
0 |
queuesize
|
int(11) |
Yes |
0 |
queuetime
|
int(11) |
Yes |
0 |
email_subscribers_data
Table comments : InnoDB free: 730112 kB
Field |
Type |
Null |
Default |
subscriberid
|
int(11) |
No |
0 |
fieldid
|
int(11) |
No |
0 |
data
|
text |
Yes |
NULL |
email_templates
Table comments : InnoDB free: 730112 kB
Field |
Type |
Null |
Default |
templateid
|
int(11) |
No |
|
name
|
varchar(255) |
Yes |
NULL |
format
|
char(1) |
Yes |
NULL |
textbody
|
longtext |
Yes |
NULL |
htmlbody
|
longtext |
Yes |
NULL |
createdate
|
int(11) |
Yes |
0 |
active
|
int(11) |
Yes |
0 |
isglobal
|
int(11) |
Yes |
0 |
ownerid
|
int(11) |
No |
0 |
email_user_access
Table comments : InnoDB free: 730112 kB
Field |
Type |
Null |
Default |
userid
|
int(11) |
Yes |
0 |
area
|
varchar(255) |
Yes |
NULL |
id
|
int(11) |
No |
0 |
email_user_permissions
Table comments : InnoDB free: 730112 kB
Field |
Type |
Null |
Default |
userid
|
int(11) |
Yes |
0 |
area
|
varchar(255) |
Yes |
NULL |
subarea
|
varchar(255) |
Yes |
NULL |
email_user_stats_emailsperhour
Table comments : InnoDB free: 730112 kB
Field |
Type |
Null |
Default |
summaryid
|
int(11) |
No |
|
statid
|
int(11) |
Yes |
0 |
sendtime
|
int(11) |
Yes |
0 |
emailssent
|
int(11) |
Yes |
0 |
userid
|
int(11) |
Yes |
0 |
email_users
Table comments : InnoDB free: 730112 kB
Field |
Type |
Null |
Default |
userid
|
int(11) |
No |
|
username
|
varchar(255) |
Yes |
NULL |
password
|
varchar(32) |
Yes |
NULL |
admintype
|
char(1) |
Yes |
NULL |
listadmintype
|
char(1) |
Yes |
NULL |
templateadmintype
|
char(1) |
Yes |
NULL |
segmentadmintype
|
char(1) |
Yes |
NULL |
status
|
char(1) |
Yes |
0 |
fullname
|
varchar(255) |
Yes |
NULL |
emailaddress
|
varchar(100) |
Yes |
NULL |
settings
|
text |
Yes |
NULL |
editownsettings
|
char(1) |
Yes |
1 |
usertimezone
|
varchar(10) |
Yes |
NULL |
textfooter
|
mediumtext |
Yes |
NULL |
htmlfooter
|
mediumtext |
Yes |
NULL |
maxlists
|
int(11) |
Yes |
0 |
perhour
|
int(11) |
Yes |
0 |
permonth
|
int(11) |
Yes |
0 |
unlimitedmaxemails
|
char(1) |
Yes |
0 |
maxemails
|
int(11) |
Yes |
0 |
infotips
|
char(1) |
Yes |
1 |
smtpserver
|
varchar(255) |
Yes |
NULL |
smtpusername
|
varchar(255) |
Yes |
NULL |
smtppassword
|
varchar(255) |
Yes |
NULL |
smtpport
|
int(11) |
Yes |
0 |
createdate
|
int(11) |
Yes |
0 |
lastloggedin
|
int(11) |
Yes |
0 |
forgotpasscode
|
varchar(32) |
Yes |
|
usewysiwyg
|
char(1) |
Yes |
1 |
xmlapi
|
char(1) |
Yes |
0 |
xmltoken
|
varchar(40) |
Yes |
NULL |
gettingstarted
|
int(11) |
No |
0 |
extcal2_categories
Table comments : Table for event categories
Field |
Type |
Null |
Default |
cat_id
|
int(11) |
No |
|
cat_parent
|
int(11) |
No |
0 |
cat_name
|
varchar(150) |
No |
|
description
|
text |
No |
|
color
|
varchar(10) |
Yes |
#000000 |
bgcolor
|
varchar(10) |
Yes |
#EEF0F0 |
options
|
tinyint(4) |
Yes |
0 |
enabled
|
tinyint(4) |
Yes |
0 |
extcal2_config
Table comments : Table for configurable parameters
Field |
Type |
Null |
Default |
name
|
varchar(40) |
No |
|
value
|
varchar(255) |
No |
|
extcal2_events
Table comments : Table holding events and their attributes
Field |
Type |
Null |
Default |
id
|
int(11) |
No |
|
title
|
varchar(255) |
No |
|
description
|
text |
No |
|
contact
|
text |
No |
|
url
|
varchar(100) |
No |
|
email
|
varchar(120) |
No |
|
picture
|
varchar(100) |
No |
|
cat
|
tinyint(2) |
No |
0 |
day
|
tinyint(2) |
No |
0 |
month
|
smallint(2) |
No |
0 |
year
|
smallint(4) |
No |
0 |
approved
|
tinyint(1) |
No |
0 |
start_date
|
datetime |
No |
0000-00-00 00:00:00 |
end_date
|
datetime |
Yes |
0000-00-00 00:00:00 |
recur_type
|
varchar(16) |
Yes |
NULL |
recur_val
|
tinyint(4) |
Yes |
0 |
recur_end_type
|
tinyint(1) |
No |
0 |
recur_count
|
tinyint(3) |
No |
0 |
recur_until
|
date |
Yes |
0000-00-00 |
extcal2_groups
Table comments : Table holding user groups
Field |
Type |
Null |
Default |
group_id
|
int(11) |
No |
|
group_name
|
varchar(255) |
No |
|
description
|
varchar(255) |
No |
|
has_admin_access
|
tinyint(1) |
No |
0 |
can_manage_accounts
|
tinyint(1) |
No |
0 |
can_change_settings
|
tinyint(1) |
No |
0 |
can_manage_cats
|
tinyint(1) |
No |
0 |
upl_need_approval
|
tinyint(1) |
No |
1 |
locked
|
tinyint(1) |
No |
0 |
extcal2_plugins
Table comments : Table holding installed plugins
Field |
Type |
Null |
Default |
plugin_id
|
int(11) |
No |
|
plugin_name
|
varchar(64) |
No |
|
plugin_priority
|
tinyint(2) |
No |
50 |
plugin_path
|
varchar(255) |
Yes |
NULL |
extcal2_templates
Table comments : Table for custom interface template
Field |
Type |
Null |
Default |
template_id
|
int(11) |
No |
|
template_type
|
varchar(16) |
No |
|
template_description
|
varchar(255) |
Yes |
NULL |
template_status
|
tinyint(1) |
No |
0 |
template_value
|
text |
Yes |
NULL |
last_access
|
datetime |
No |
0000-00-00 00:00:00 |
extcal2_users
Table comments : Table for calendar users
Field |
Type |
Null |
Default |
user_id
|
int(11) |
No |
|
username
|
varchar(30) |
No |
|
password
|
varchar(64) |
No |
|
firstname
|
varchar(64) |
Yes |
|
lastname
|
varchar(64) |
Yes |
|
group_id
|
int(11) |
No |
2 |
lastvisit
|
datetime |
No |
0000-00-00 00:00:00 |
email
|
varchar(255) |
No |
|
user_regdate
|
datetime |
No |
0000-00-00 00:00:00 |
user_lang
|
varchar(255) |
No |
|
user_website
|
varchar(255) |
No |
|
user_location
|
varchar(255) |
No |
|
user_occupation
|
varchar(255) |
No |
|
reg_key
|
varchar(64) |
Yes |
NULL |
user_status
|
tinyint(1) |
No |
0 |
extcal_1categories
Table comments : Table for event categories
Field |
Type |
Null |
Default |
cat_id
|
int(11) |
No |
|
cat_parent
|
int(11) |
No |
0 |
cat_name
|
varchar(150) |
No |
|
description
|
text |
No |
|
color
|
varchar(10) |
Yes |
#000000 |
bgcolor
|
varchar(10) |
Yes |
#EEF0F0 |
options
|
tinyint(4) |
Yes |
0 |
enabled
|
tinyint(4) |
Yes |
0 |
extcal_1config
Table comments : Table for configurable parameters
Field |
Type |
Null |
Default |
name
|
varchar(40) |
No |
|
value
|
varchar(255) |
No |
|
extcal_1events
Table comments : Table holding events and their attributes
Field |
Type |
Null |
Default |
id
|
int(11) |
No |
|
title
|
varchar(255) |
No |
|
description
|
text |
No |
|
contact
|
text |
No |
|
url
|
varchar(100) |
No |
|
email
|
varchar(120) |
No |
|
picture
|
varchar(100) |
No |
|
cat
|
tinyint(2) |
No |
0 |
day
|
tinyint(2) |
No |
0 |
month
|
smallint(2) |
No |
0 |
year
|
smallint(4) |
No |
0 |
approved
|
tinyint(1) |
No |
0 |
start_date
|
datetime |
No |
0000-00-00 00:00:00 |
end_date
|
datetime |
Yes |
0000-00-00 00:00:00 |
recur_type
|
varchar(16) |
Yes |
NULL |
recur_val
|
tinyint(4) |
Yes |
0 |
recur_end_type
|
tinyint(1) |
No |
0 |
recur_count
|
tinyint(3) |
No |
0 |
recur_until
|
date |
Yes |
0000-00-00 |
user_id
|
int(11) |
No |
0 |
group_id
|
int(11) |
No |
0 |
showevent
|
char(1) |
No |
3 |
extcal_1groups
Table comments : Table holding user groups
Field |
Type |
Null |
Default |
group_id
|
int(11) |
No |
|
group_name
|
varchar(255) |
No |
|
description
|
varchar(255) |
No |
|
has_admin_access
|
tinyint(1) |
No |
0 |
can_manage_accounts
|
tinyint(1) |
No |
0 |
can_change_settings
|
tinyint(1) |
No |
0 |
can_manage_cats
|
tinyint(1) |
No |
0 |
can_create_events
|
tinyint(1) |
No |
0 |
can_edit_events
|
tinyint(1) |
No |
0 |
can_submit_events
|
tinyint(1) |
No |
0 |
upl_need_approval
|
tinyint(1) |
No |
1 |
locked
|
tinyint(1) |
No |
0 |
extcal_1plugins
Table comments : Table holding installed plugins
Field |
Type |
Null |
Default |
plugin_id
|
int(11) |
No |
|
plugin_name
|
varchar(64) |
No |
|
plugin_priority
|
tinyint(2) |
No |
50 |
plugin_path
|
varchar(255) |
Yes |
NULL |
extcal_1templates
Table comments : Table for custom interface template
Field |
Type |
Null |
Default |
template_id
|
int(11) |
No |
|
template_type
|
varchar(16) |
No |
|
template_description
|
varchar(255) |
Yes |
NULL |
template_status
|
tinyint(1) |
No |
0 |
template_value
|
text |
Yes |
NULL |
last_access
|
datetime |
No |
0000-00-00 00:00:00 |
extcal_1users
Table comments : Table for calendar users
Field |
Type |
Null |
Default |
user_id
|
int(11) |
No |
|
username
|
varchar(30) |
No |
|
password
|
varchar(64) |
No |
|
firstname
|
varchar(64) |
Yes |
|
lastname
|
varchar(64) |
Yes |
|
group_id
|
int(11) |
No |
2 |
lastvisit
|
datetime |
No |
0000-00-00 00:00:00 |
email
|
varchar(255) |
No |
|
user_regdate
|
datetime |
No |
0000-00-00 00:00:00 |
user_lang
|
varchar(255) |
No |
|
user_website
|
varchar(255) |
No |
|
user_location
|
varchar(255) |
No |
|
user_occupation
|
varchar(255) |
No |
|
reg_key
|
varchar(64) |
Yes |
NULL |
user_status
|
tinyint(1) |
No |
0 |
extcal_2categories
Table comments : Table for event categories
Field |
Type |
Null |
Default |
cat_id
|
int(11) |
No |
|
cat_parent
|
int(11) |
No |
0 |
cat_name
|
varchar(150) |
No |
|
description
|
text |
No |
|
color
|
varchar(10) |
Yes |
#000000 |
bgcolor
|
varchar(10) |
Yes |
#EEF0F0 |
options
|
tinyint(4) |
Yes |
0 |
enabled
|
tinyint(4) |
Yes |
0 |
extcal_2config
Table comments : Table for configurable parameters
Field |
Type |
Null |
Default |
name
|
varchar(40) |
No |
|
value
|
varchar(255) |
No |
|
extcal_2events
Table comments : Table holding events and their attributes
Field |
Type |
Null |
Default |
id
|
int(11) |
No |
|
title
|
varchar(255) |
No |
|
description
|
text |
No |
|
contact
|
text |
No |
|
url
|
varchar(100) |
No |
|
email
|
varchar(120) |
No |
|
picture
|
varchar(100) |
No |
|
cat
|
tinyint(2) |
No |
0 |
day
|
tinyint(2) |
No |
0 |
month
|
smallint(2) |
No |
0 |
year
|
smallint(4) |
No |
0 |
approved
|
tinyint(1) |
No |
0 |
start_date
|
datetime |
No |
0000-00-00 00:00:00 |
end_date
|
datetime |
Yes |
0000-00-00 00:00:00 |
recur_type
|
varchar(16) |
Yes |
NULL |
recur_val
|
tinyint(4) |
Yes |
0 |
recur_end_type
|
tinyint(1) |
No |
0 |
recur_count
|
tinyint(3) |
No |
0 |
recur_until
|
date |
Yes |
0000-00-00 |
user_id
|
int(11) |
No |
0 |
group_id
|
int(11) |
No |
0 |
showevent
|
char(1) |
No |
3 |
extcal_2groups
Table comments : Table holding user groups
Field |
Type |
Null |
Default |
group_id
|
int(11) |
No |
|
group_name
|
varchar(255) |
No |
|
description
|
varchar(255) |
No |
|
has_admin_access
|
tinyint(1) |
No |
0 |
can_manage_accounts
|
tinyint(1) |
No |
0 |
can_change_settings
|
tinyint(1) |
No |
0 |
can_manage_cats
|
tinyint(1) |
No |
0 |
can_create_events
|
tinyint(1) |
No |
0 |
can_edit_events
|
tinyint(1) |
No |
0 |
can_submit_events
|
tinyint(1) |
No |
0 |
upl_need_approval
|
tinyint(1) |
No |
1 |
locked
|
tinyint(1) |
No |
0 |
extcal_2plugins
Table comments : Table holding installed plugins
Field |
Type |
Null |
Default |
plugin_id
|
int(11) |
No |
|
plugin_name
|
varchar(64) |
No |
|
plugin_priority
|
tinyint(2) |
No |
50 |
plugin_path
|
varchar(255) |
Yes |
NULL |
extcal_2templates
Table comments : Table for custom interface template
Field |
Type |
Null |
Default |
template_id
|
int(11) |
No |
|
template_type
|
varchar(16) |
No |
|
template_description
|
varchar(255) |
Yes |
NULL |
template_status
|
tinyint(1) |
No |
0 |
template_value
|
text |
Yes |
NULL |
last_access
|
datetime |
No |
0000-00-00 00:00:00 |
extcal_2users
Table comments : Table for calendar users
Field |
Type |
Null |
Default |
user_id
|
int(11) |
No |
|
username
|
varchar(30) |
No |
|
password
|
varchar(64) |
No |
|
firstname
|
varchar(64) |
Yes |
|
lastname
|
varchar(64) |
Yes |
|
group_id
|
int(11) |
No |
2 |
lastvisit
|
datetime |
No |
0000-00-00 00:00:00 |
email
|
varchar(255) |
No |
|
user_regdate
|
datetime |
No |
0000-00-00 00:00:00 |
user_lang
|
varchar(255) |
No |
|
user_website
|
varchar(255) |
No |
|
user_location
|
varchar(255) |
No |
|
user_occupation
|
varchar(255) |
No |
|
reg_key
|
varchar(64) |
Yes |
NULL |
user_status
|
tinyint(1) |
No |
0 |
extcal_categories
Table comments : Table for event categories
Field |
Type |
Null |
Default |
cat_id
|
int(11) |
No |
|
cat_parent
|
int(11) |
No |
0 |
cat_name
|
varchar(150) |
No |
|
description
|
text |
No |
|
color
|
varchar(10) |
Yes |
#000000 |
bgcolor
|
varchar(10) |
Yes |
#EEF0F0 |
options
|
tinyint(4) |
Yes |
0 |
enabled
|
tinyint(4) |
Yes |
0 |
extcal_config
Table comments : Table for configurable parameters
Field |
Type |
Null |
Default |
name
|
varchar(40) |
No |
|
value
|
varchar(255) |
No |
|
extcal_events
Table comments : Table holding events and their attributes
Field |
Type |
Null |
Default |
id
|
int(11) |
No |
|
title
|
varchar(255) |
No |
|
description
|
text |
No |
|
contact
|
text |
No |
|
url
|
varchar(100) |
No |
|
email
|
varchar(120) |
No |
|
picture
|
varchar(100) |
No |
|
cat
|
tinyint(2) |
No |
0 |
day
|
tinyint(2) |
No |
0 |
month
|
smallint(2) |
No |
0 |
year
|
smallint(4) |
No |
0 |
approved
|
tinyint(1) |
No |
0 |
start_date
|
datetime |
No |
0000-00-00 00:00:00 |
end_date
|
datetime |
Yes |
0000-00-00 00:00:00 |
recur_type
|
varchar(16) |
Yes |
NULL |
recur_val
|
tinyint(4) |
Yes |
0 |
recur_end_type
|
tinyint(1) |
No |
0 |
recur_count
|
tinyint(3) |
No |
0 |
recur_until
|
date |
Yes |
0000-00-00 |
user_id
|
int(11) |
No |
0 |
group_id
|
int(11) |
No |
0 |
showevent
|
char(1) |
No |
3 |
extcal_groups
Table comments : Table holding user groups
Field |
Type |
Null |
Default |
group_id
|
int(11) |
No |
|
group_name
|
varchar(255) |
No |
|
description
|
varchar(255) |
No |
|
has_admin_access
|
tinyint(1) |
No |
0 |
can_manage_accounts
|
tinyint(1) |
No |
0 |
can_change_settings
|
tinyint(1) |
No |
0 |
can_manage_cats
|
tinyint(1) |
No |
0 |
upl_need_approval
|
tinyint(1) |
No |
1 |
locked
|
tinyint(1) |
No |
0 |
can_edit_events
|
tinyint(1) |
No |
0 |
can_create_events
|
tinyint(1) |
No |
0 |
extcal_plugins
Table comments : Table holding installed plugins
Field |
Type |
Null |
Default |
plugin_id
|
int(11) |
No |
|
plugin_name
|
varchar(64) |
No |
|
plugin_priority
|
tinyint(2) |
No |
50 |
plugin_path
|
varchar(255) |
Yes |
NULL |
extcal_templates
Table comments : Table for custom interface template
Field |
Type |
Null |
Default |
template_id
|
int(11) |
No |
|
template_type
|
varchar(16) |
No |
|
template_description
|
varchar(255) |
Yes |
NULL |
template_status
|
tinyint(1) |
No |
0 |
template_value
|
text |
Yes |
NULL |
last_access
|
datetime |
No |
0000-00-00 00:00:00 |
extcal_users
Table comments : Table for calendar users
Field |
Type |
Null |
Default |
user_id
|
int(11) |
No |
|
username
|
varchar(30) |
No |
|
password
|
varchar(64) |
No |
|
firstname
|
varchar(64) |
Yes |
|
lastname
|
varchar(64) |
Yes |
|
group_id
|
int(11) |
No |
2 |
lastvisit
|
datetime |
No |
0000-00-00 00:00:00 |
email
|
varchar(255) |
No |
|
user_regdate
|
datetime |
No |
0000-00-00 00:00:00 |
user_lang
|
varchar(255) |
No |
|
user_website
|
varchar(255) |
No |
|
user_location
|
varchar(255) |
No |
|
user_occupation
|
varchar(255) |
No |
|
reg_key
|
varchar(64) |
Yes |
NULL |
user_status
|
tinyint(1) |
No |
0 |
jos_banner
Field |
Type |
Null |
Default |
bid
|
int(11) |
No |
|
cid
|
int(11) |
No |
0 |
type
|
varchar(30) |
No |
banner |
name
|
varchar(255) |
No |
|
alias
|
varchar(255) |
No |
|
imptotal
|
int(11) |
No |
0 |
impmade
|
int(11) |
No |
0 |
clicks
|
int(11) |
No |
0 |
imageurl
|
varchar(100) |
No |
|
clickurl
|
varchar(200) |
No |
|
date
|
datetime |
Yes |
NULL |
showBanner
|
tinyint(1) |
No |
0 |
checked_out
|
tinyint(1) |
No |
0 |
checked_out_time
|
datetime |
No |
0000-00-00 00:00:00 |
editor
|
varchar(50) |
Yes |
NULL |
custombannercode
|
text |
Yes |
NULL |
catid
|
int(10) |
No |
0 |
description
|
text |
No |
|
sticky
|
tinyint(1) |
No |
0 |
ordering
|
int(11) |
No |
0 |
publish_up
|
datetime |
No |
0000-00-00 00:00:00 |
publish_down
|
datetime |
No |
0000-00-00 00:00:00 |
tags
|
text |
No |
|
params
|
text |
No |
|
jos_bannerclient
Field |
Type |
Null |
Default |
cid
|
int(11) |
No |
|
name
|
varchar(255) |
No |
|
contact
|
varchar(255) |
No |
|
email
|
varchar(255) |
No |
|
extrainfo
|
text |
No |
|
checked_out
|
tinyint(1) |
No |
0 |
checked_out_time
|
time |
Yes |
NULL |
editor
|
varchar(50) |
Yes |
NULL |
jos_bannertrack
Field |
Type |
Null |
Default |
track_date
|
date |
No |
0000-00-00 |
track_type
|
int(10) |
No |
0 |
banner_id
|
int(10) |
No |
0 |
jos_categories
Field |
Type |
Null |
Default |
id
|
int(11) |
No |
|
parent_id
|
int(11) |
No |
0 |
title
|
varchar(255) |
No |
|
name
|
varchar(255) |
No |
|
alias
|
varchar(255) |
No |
|
image
|
varchar(255) |
No |
|
section
|
varchar(50) |
No |
|
image_position
|
varchar(30) |
No |
|
description
|
text |
No |
|
published
|
tinyint(1) |
No |
0 |
checked_out
|
int(11) |
No |
0 |
checked_out_time
|
datetime |
No |
0000-00-00 00:00:00 |
editor
|
varchar(50) |
Yes |
NULL |
ordering
|
int(11) |
No |
0 |
access
|
tinyint(3) |
No |
0 |
count
|
int(11) |
No |
0 |
params
|
text |
No |
|
jos_components
Field |
Type |
Null |
Default |
id
|
int(11) |
No |
|
name
|
varchar(50) |
No |
|
link
|
varchar(255) |
No |
|
menuid
|
int(11) |
No |
0 |
parent
|
int(11) |
No |
0 |
admin_menu_link
|
varchar(255) |
No |
|
admin_menu_alt
|
varchar(255) |
No |
|
option
|
varchar(50) |
No |
|
ordering
|
int(11) |
No |
0 |
admin_menu_img
|
varchar(255) |
No |
|
iscore
|
tinyint(4) |
No |
0 |
params
|
text |
No |
|
enabled
|
tinyint(4) |
No |
1 |
jos_contact_details
Field |
Type |
Null |
Default |
id
|
int(11) |
No |
|
name
|
varchar(255) |
No |
|
alias
|
varchar(255) |
No |
|
con_position
|
varchar(255) |
Yes |
NULL |
address
|
text |
Yes |
NULL |
suburb
|
varchar(100) |
Yes |
NULL |
state
|
varchar(100) |
Yes |
NULL |
country
|
varchar(100) |
Yes |
NULL |
postcode
|
varchar(100) |
Yes |
NULL |
telephone
|
varchar(255) |
Yes |
NULL |
fax
|
varchar(255) |
Yes |
NULL |
misc
|
mediumtext |
Yes |
NULL |
image
|
varchar(255) |
Yes |
NULL |
imagepos
|
varchar(20) |
Yes |
NULL |
email_to
|
varchar(255) |
Yes |
NULL |
default_con
|
tinyint(1) |
No |
0 |
published
|
tinyint(1) |
No |
0 |
checked_out
|
int(11) |
No |
0 |
checked_out_time
|
datetime |
No |
0000-00-00 00:00:00 |
ordering
|
int(11) |
No |
0 |
params
|
text |
No |
|
user_id
|
int(11) |
No |
0 |
catid
|
int(11) |
No |
0 |
access
|
tinyint(3) |
No |
0 |
mobile
|
varchar(255) |
No |
|
webpage
|
varchar(255) |
No |
|
jos_content
Field |
Type |
Null |
Default |
id
|
int(11) |
No |
|
title
|
varchar(255) |
No |
|
alias
|
varchar(255) |
No |
|
title_alias
|
varchar(255) |
No |
|
introtext
|
mediumtext |
No |
|
fulltext
|
mediumtext |
No |
|
state
|
tinyint(3) |
No |
0 |
sectionid
|
int(11) |
No |
0 |
mask
|
int(11) |
No |
0 |
catid
|
int(11) |
No |
0 |
created
|
datetime |
No |
0000-00-00 00:00:00 |
created_by
|
int(11) |
No |
0 |
created_by_alias
|
varchar(255) |
No |
|
modified
|
datetime |
No |
0000-00-00 00:00:00 |
modified_by
|
int(11) |
No |
0 |
checked_out
|
int(11) |
No |
0 |
checked_out_time
|
datetime |
No |
0000-00-00 00:00:00 |
publish_up
|
datetime |
No |
0000-00-00 00:00:00 |
publish_down
|
datetime |
No |
0000-00-00 00:00:00 |
images
|
text |
No |
|
urls
|
text |
No |
|
attribs
|
text |
No |
|
version
|
int(11) |
No |
1 |
parentid
|
int(11) |
No |
0 |
ordering
|
int(11) |
No |
0 |
metakey
|
text |
No |
|
metadesc
|
text |
No |
|
access
|
int(11) |
No |
0 |
hits
|
int(11) |
No |
0 |
metadata
|
text |
No |
|
jos_content_frontpage
Field |
Type |
Null |
Default |
content_id
|
int(11) |
No |
0 |
ordering
|
int(11) |
No |
0 |
jos_content_rating
Field |
Type |
Null |
Default |
content_id
|
int(11) |
No |
0 |
rating_sum
|
int(11) |
No |
0 |
rating_count
|
int(11) |
No |
0 |
lastip
|
varchar(50) |
No |
|
jos_core_acl_aro
Field |
Type |
Null |
Default |
id
|
int(11) |
No |
|
section_value
|
varchar(240) |
No |
0 |
value
|
varchar(240) |
No |
|
order_value
|
int(11) |
No |
0 |
name
|
varchar(255) |
No |
|
hidden
|
int(11) |
No |
0 |
jos_core_acl_aro_groups
Field |
Type |
Null |
Default |
id
|
int(11) |
No |
|
parent_id
|
int(11) |
No |
0 |
name
|
varchar(255) |
No |
|
lft
|
int(11) |
No |
0 |
rgt
|
int(11) |
No |
0 |
value
|
varchar(255) |
No |
|
jos_core_acl_aro_map
Field |
Type |
Null |
Default |
acl_id
|
int(11) |
No |
0 |
section_value
|
varchar(230) |
No |
0 |
value
|
varchar(100) |
No |
|
jos_core_acl_aro_sections
Field |
Type |
Null |
Default |
id
|
int(11) |
No |
|
value
|
varchar(230) |
No |
|
order_value
|
int(11) |
No |
0 |
name
|
varchar(230) |
No |
|
hidden
|
int(11) |
No |
0 |
jos_core_acl_groups_aro_map
Field |
Type |
Null |
Default |
group_id
|
int(11) |
No |
0 |
section_value
|
varchar(240) |
No |
|
aro_id
|
int(11) |
No |
0 |
jos_core_log_items
Field |
Type |
Null |
Default |
time_stamp
|
date |
No |
0000-00-00 |
item_table
|
varchar(50) |
No |
|
item_id
|
int(11) |
No |
0 |
hits
|
int(11) |
No |
0 |
jos_core_log_searches
Field |
Type |
Null |
Default |
search_term
|
varchar(128) |
No |
|
hits
|
int(11) |
No |
0 |
jos_groups
Field |
Type |
Null |
Default |
id
|
tinyint(3) |
No |
0 |
name
|
varchar(50) |
No |
|
jos_menu
Field |
Type |
Null |
Default |
id
|
int(11) |
No |
|
menutype
|
varchar(75) |
Yes |
NULL |
name
|
varchar(255) |
Yes |
NULL |
alias
|
varchar(255) |
No |
|
link
|
text |
Yes |
NULL |
type
|
varchar(50) |
No |
|
published
|
tinyint(1) |
No |
0 |
parent
|
int(11) |
No |
0 |
componentid
|
int(11) |
No |
0 |
sublevel
|
int(11) |
Yes |
0 |
ordering
|
int(11) |
Yes |
0 |
checked_out
|
int(11) |
No |
0 |
checked_out_time
|
datetime |
No |
0000-00-00 00:00:00 |
pollid
|
int(11) |
No |
0 |
browserNav
|
tinyint(4) |
Yes |
0 |
access
|
tinyint(3) |
No |
0 |
utaccess
|
tinyint(3) |
No |
0 |
params
|
text |
No |
|
lft
|
int(11) |
No |
0 |
rgt
|
int(11) |
No |
0 |
home
|
int(1) |
No |
0 |
jos_menu_types
Field |
Type |
Null |
Default |
id
|
int(10) |
No |
|
menutype
|
varchar(75) |
No |
|
title
|
varchar(255) |
No |
|
description
|
varchar(255) |
No |
|
jos_messages
Field |
Type |
Null |
Default |
message_id
|
int(10) |
No |
|
user_id_from
|
int(10) |
No |
0 |
user_id_to
|
int(10) |
No |
0 |
folder_id
|
int(10) |
No |
0 |
date_time
|
datetime |
No |
0000-00-00 00:00:00 |
state
|
int(11) |
No |
0 |
priority
|
int(1) |
No |
0 |
subject
|
text |
No |
|
message
|
text |
No |
|
jos_messages_cfg
Field |
Type |
Null |
Default |
user_id
|
int(10) |
No |
0 |
cfg_name
|
varchar(100) |
No |
|
cfg_value
|
varchar(255) |
No |
|
jos_migration_backlinks
Field |
Type |
Null |
Default |
itemid
|
int(11) |
No |
0 |
name
|
varchar(100) |
No |
|
url
|
text |
No |
|
sefurl
|
text |
No |
|
newurl
|
text |
No |
|
jos_modules
Field |
Type |
Null |
Default |
id
|
int(11) |
No |
|
title
|
text |
No |
|
content
|
text |
No |
|
ordering
|
int(11) |
No |
0 |
position
|
varchar(50) |
Yes |
NULL |
checked_out
|
int(11) |
No |
0 |
checked_out_time
|
datetime |
No |
0000-00-00 00:00:00 |
published
|
tinyint(1) |
No |
0 |
module
|
varchar(50) |
Yes |
NULL |
numnews
|
int(11) |
No |
0 |
access
|
tinyint(3) |
No |
0 |
showtitle
|
tinyint(3) |
No |
1 |
params
|
text |
No |
|
iscore
|
tinyint(4) |
No |
0 |
client_id
|
tinyint(4) |
No |
0 |
control
|
text |
No |
|
jos_modules_menu
Field |
Type |
Null |
Default |
moduleid
|
int(11) |
No |
0 |
menuid
|
int(11) |
No |
0 |
jos_newsfeeds
Field |
Type |
Null |
Default |
catid
|
int(11) |
No |
0 |
id
|
int(11) |
No |
|
name
|
text |
No |
|
alias
|
varchar(255) |
No |
|
link
|
text |
No |
|
filename
|
varchar(200) |
Yes |
NULL |
published
|
tinyint(1) |
No |
0 |
numarticles
|
int(11) |
No |
1 |
cache_time
|
int(11) |
No |
3600 |
checked_out
|
tinyint(3) |
No |
0 |
checked_out_time
|
datetime |
No |
0000-00-00 00:00:00 |
ordering
|
int(11) |
No |
0 |
rtl
|
tinyint(4) |
No |
0 |
jos_plugins
Field |
Type |
Null |
Default |
id
|
int(11) |
No |
|
name
|
varchar(100) |
No |
|
element
|
varchar(100) |
No |
|
folder
|
varchar(100) |
No |
|
access
|
tinyint(3) |
No |
0 |
ordering
|
int(11) |
No |
0 |
published
|
tinyint(3) |
No |
0 |
iscore
|
tinyint(3) |
No |
0 |
client_id
|
tinyint(3) |
No |
0 |
checked_out
|
int(11) |
No |
0 |
checked_out_time
|
datetime |
No |
0000-00-00 00:00:00 |
params
|
text |
No |
|
jos_poll_data
Field |
Type |
Null |
Default |
id
|
int(11) |
No |
|
pollid
|
int(11) |
No |
0 |
text
|
text |
No |
|
hits
|
int(11) |
No |
0 |
jos_poll_date
Field |
Type |
Null |
Default |
id
|
bigint(20) |
No |
|
date
|
datetime |
No |
0000-00-00 00:00:00 |
vote_id
|
int(11) |
No |
0 |
poll_id
|
int(11) |
No |
0 |
jos_poll_menu
Field |
Type |
Null |
Default |
pollid
|
int(11) |
No |
0 |
menuid
|
int(11) |
No |
0 |
jos_polls
Field |
Type |
Null |
Default |
id
|
int(11) |
No |
|
title
|
varchar(255) |
No |
|
alias
|
varchar(255) |
No |
|
voters
|
int(9) |
No |
0 |
checked_out
|
int(11) |
No |
0 |
checked_out_time
|
datetime |
No |
0000-00-00 00:00:00 |
published
|
tinyint(1) |
No |
0 |
access
|
int(11) |
No |
0 |
lag
|
int(11) |
No |
0 |
jos_sections
Field |
Type |
Null |
Default |
id
|
int(11) |
No |
|
title
|
varchar(255) |
No |
|
name
|
varchar(255) |
No |
|
alias
|
varchar(255) |
No |
|
image
|
text |
No |
|
scope
|
varchar(50) |
No |
|
image_position
|
varchar(30) |
No |
|
description
|
text |
No |
|
published
|
tinyint(1) |
No |
0 |
checked_out
|
int(11) |
No |
0 |
checked_out_time
|
datetime |
No |
0000-00-00 00:00:00 |
ordering
|
int(11) |
No |
0 |
access
|
tinyint(3) |
No |
0 |
count
|
int(11) |
No |
0 |
params
|
text |
No |
|
jos_session
Field |
Type |
Null |
Default |
username
|
varchar(150) |
Yes |
|
time
|
varchar(14) |
Yes |
|
session_id
|
varchar(200) |
No |
0 |
guest
|
tinyint(4) |
Yes |
1 |
userid
|
int(11) |
Yes |
0 |
usertype
|
varchar(50) |
Yes |
|
gid
|
tinyint(3) |
No |
0 |
client_id
|
tinyint(3) |
No |
0 |
data
|
longtext |
Yes |
NULL |
jos_stats_agents
Field |
Type |
Null |
Default |
agent
|
varchar(255) |
No |
|
type
|
tinyint(1) |
No |
0 |
hits
|
int(11) |
No |
1 |
jos_templates_menu
Field |
Type |
Null |
Default |
template
|
varchar(255) |
No |
|
menuid
|
int(11) |
No |
0 |
client_id
|
tinyint(4) |
No |
0 |
jos_users
Field |
Type |
Null |
Default |
id
|
int(11) |
No |
|
name
|
varchar(255) |
No |
|
username
|
varchar(150) |
No |
|
email
|
varchar(100) |
No |
|
password
|
varchar(100) |
No |
|
usertype
|
varchar(25) |
No |
|
block
|
tinyint(4) |
No |
0 |
sendEmail
|
tinyint(4) |
Yes |
0 |
gid
|
tinyint(3) |
No |
1 |
registerDate
|
datetime |
No |
0000-00-00 00:00:00 |
lastvisitDate
|
datetime |
No |
0000-00-00 00:00:00 |
activation
|
varchar(100) |
No |
|
params
|
text |
No |
|
jos_weblinks
Field |
Type |
Null |
Default |
id
|
int(11) |
No |
|
catid
|
int(11) |
No |
0 |
sid
|
int(11) |
No |
0 |
title
|
varchar(250) |
No |
|
alias
|
varchar(255) |
No |
|
url
|
varchar(250) |
No |
|
description
|
text |
No |
|
date
|
datetime |
No |
0000-00-00 00:00:00 |
hits
|
int(11) |
No |
0 |
published
|
tinyint(1) |
No |
0 |
checked_out
|
int(11) |
No |
0 |
checked_out_time
|
datetime |
No |
0000-00-00 00:00:00 |
ordering
|
int(11) |
No |
0 |
archived
|
tinyint(1) |
No |
0 |
approved
|
tinyint(1) |
No |
1 |
params
|
text |
No |
|
kxtn
Field |
Type |
Null |
Default |
rank
|
int(2) |
No |
0 |
song
|
varchar(75) |
No |
|
playstw
|
char(3) |
No |
|
playslw
|
char(3) |
No |
|
video
|
varchar(200) |
No |
|
audio
|
longtext |
No |
|
lyrics
|
varchar(200) |
No |
|
label
|
varchar(50) |
No |
|
pic
|
varchar(50) |
No |
|
lyrics
Field |
Type |
Null |
Default |
id
|
int(10) |
No |
|
title
|
varchar(50) |
No |
|
artist
|
varchar(50) |
No |
|
album
|
varchar(50) |
No |
|
words
|
longtext |
No |
|
extras
|
varchar(225) |
No |
|
file
|
varchar(100) |
No |
|
mega101
Field |
Type |
Null |
Default |
rank
|
int(2) |
No |
0 |
song
|
varchar(50) |
No |
|
playstw
|
char(3) |
No |
|
playslw
|
char(3) |
No |
|
video
|
varchar(200) |
No |
|
audio
|
longtext |
No |
|
lyrics
|
varchar(200) |
No |
|
label
|
varchar(50) |
No |
|
pic
|
varchar(50) |
No |
|
networkgirls
Field |
Type |
Null |
Default |
id
|
int(10) |
No |
|
fname
|
varchar(100) |
No |
|
lname
|
varchar(100) |
No |
|
address
|
varchar(100) |
No |
|
city
|
varchar(100) |
No |
|
state
|
varchar(100) |
No |
|
zip
|
varchar(100) |
No |
|
phone
|
varchar(100) |
No |
|
bilingual
|
varchar(100) |
No |
|
pic
|
varchar(100) |
No |
|
phorum_banlists
Field |
Type |
Null |
Default |
id
|
int(11) |
No |
|
forum_id
|
int(11) |
No |
0 |
type
|
tinyint(4) |
No |
0 |
pcre
|
tinyint(4) |
No |
0 |
string
|
varchar(255) |
No |
|
phorum_files
Field |
Type |
Null |
Default |
file_id
|
int(11) |
No |
|
user_id
|
int(11) |
No |
0 |
filename
|
varchar(255) |
No |
|
filesize
|
int(11) |
No |
0 |
file_data
|
mediumtext |
No |
|
add_datetime
|
int(10) |
No |
0 |
message_id
|
int(10) |
No |
0 |
link
|
varchar(10) |
No |
|
phorum_forum_group_xref
Field |
Type |
Null |
Default |
forum_id
|
int(11) |
No |
0 |
group_id
|
int(11) |
No |
0 |
permission
|
int(10) |
No |
0 |
phorum_forums
Field |
Type |
Null |
Default |
forum_id
|
int(10) |
No |
|
name
|
varchar(50) |
No |
|
active
|
smallint(6) |
No |
0 |
description
|
text |
Yes |
NULL |
template
|
varchar(50) |
No |
|
folder_flag
|
tinyint(1) |
No |
0 |
parent_id
|
int(10) |
No |
0 |
list_length_flat
|
int(10) |
No |
0 |
list_length_threaded
|
int(10) |
No |
0 |
moderation
|
int(10) |
No |
0 |
threaded_list
|
tinyint(4) |
No |
0 |
threaded_read
|
tinyint(4) |
No |
0 |
float_to_top
|
tinyint(4) |
No |
0 |
check_duplicate
|
tinyint(4) |
No |
0 |
allow_attachment_types
|
varchar(100) |
No |
|
max_attachment_size
|
int(10) |
No |
0 |
max_totalattachment_size
|
int(10) |
No |
0 |
max_attachments
|
int(10) |
No |
0 |
pub_perms
|
int(10) |
No |
0 |
reg_perms
|
int(10) |
No |
0 |
display_ip_address
|
smallint(5) |
No |
1 |
allow_email_notify
|
smallint(5) |
No |
1 |
language
|
varchar(100) |
No |
english |
email_moderators
|
tinyint(1) |
No |
0 |
message_count
|
int(10) |
No |
0 |
sticky_count
|
int(10) |
No |
0 |
thread_count
|
int(10) |
No |
0 |
last_post_time
|
int(10) |
No |
0 |
display_order
|
int(10) |
No |
0 |
read_length
|
int(10) |
No |
0 |
vroot
|
int(10) |
No |
0 |
edit_post
|
tinyint(1) |
No |
1 |
template_settings
|
text |
Yes |
NULL |
count_views
|
tinyint(1) |
No |
0 |
display_fixed
|
tinyint(1) |
No |
0 |
reverse_threading
|
tinyint(1) |
No |
0 |
inherit_id
|
int(10) |
Yes |
NULL |
phorum_groups
Field |
Type |
Null |
Default |
group_id
|
int(11) |
No |
|
name
|
varchar(255) |
No |
0 |
open
|
tinyint(3) |
No |
0 |
phorum_messages
Field |
Type |
Null |
Default |
message_id
|
int(10) |
No |
|
forum_id
|
int(10) |
No |
0 |
thread
|
int(10) |
No |
0 |
parent_id
|
int(10) |
No |
0 |
author
|
varchar(37) |
No |
|
subject
|
varchar(255) |
No |
|
body
|
text |
No |
|
email
|
varchar(100) |
No |
|
ip
|
varchar(255) |
No |
|
status
|
tinyint(4) |
No |
2 |
msgid
|
varchar(100) |
No |
|
modifystamp
|
int(10) |
No |
0 |
user_id
|
int(10) |
No |
0 |
thread_count
|
int(10) |
No |
0 |
moderator_post
|
tinyint(3) |
No |
0 |
sort
|
tinyint(4) |
No |
2 |
datestamp
|
int(10) |
No |
0 |
meta
|
mediumtext |
Yes |
NULL |
viewcount
|
int(10) |
No |
0 |
closed
|
tinyint(4) |
No |
0 |
phorum_pm_buddies
Field |
Type |
Null |
Default |
pm_buddy_id
|
int(10) |
No |
|
user_id
|
int(10) |
No |
0 |
buddy_user_id
|
int(10) |
No |
0 |
phorum_pm_folders
Field |
Type |
Null |
Default |
pm_folder_id
|
int(10) |
No |
|
user_id
|
int(10) |
No |
0 |
foldername
|
varchar(20) |
No |
|
phorum_pm_messages
Field |
Type |
Null |
Default |
pm_message_id
|
int(10) |
No |
|
from_user_id
|
int(10) |
No |
0 |
from_username
|
varchar(50) |
No |
|
subject
|
varchar(100) |
No |
|
message
|
text |
No |
|
datestamp
|
int(10) |
No |
0 |
meta
|
mediumtext |
Yes |
NULL |
phorum_pm_xref
Field |
Type |
Null |
Default |
pm_xref_id
|
int(10) |
No |
|
user_id
|
int(10) |
No |
0 |
pm_folder_id
|
int(10) |
No |
0 |
special_folder
|
varchar(10) |
Yes |
NULL |
pm_message_id
|
int(10) |
No |
0 |
read_flag
|
tinyint(1) |
No |
0 |
reply_flag
|
tinyint(1) |
No |
0 |
phorum_search
Field |
Type |
Null |
Default |
message_id
|
int(10) |
No |
0 |
forum_id
|
int(10) |
No |
0 |
search_text
|
mediumtext |
No |
|
phorum_settings
Field |
Type |
Null |
Default |
name
|
varchar(255) |
No |
|
type
|
enum('V', 'S') |
No |
V |
data
|
text |
No |
|
phorum_subscribers
Field |
Type |
Null |
Default |
user_id
|
int(10) |
No |
0 |
forum_id
|
int(10) |
No |
0 |
sub_type
|
int(10) |
No |
0 |
thread
|
int(10) |
No |
0 |
phorum_user_custom_fields
Field |
Type |
Null |
Default |
user_id
|
int(11) |
No |
0 |
type
|
int(11) |
No |
0 |
data
|
text |
Yes |
NULL |
phorum_user_group_xref
Field |
Type |
Null |
Default |
user_id
|
int(11) |
No |
0 |
group_id
|
int(11) |
No |
0 |
status
|
tinyint(3) |
No |
1 |
phorum_user_newflags
Field |
Type |
Null |
Default |
user_id
|
int(11) |
No |
0 |
forum_id
|
int(11) |
No |
0 |
message_id
|
int(11) |
No |
0 |
phorum_user_permissions
Field |
Type |
Null |
Default |
user_id
|
int(10) |
No |
0 |
forum_id
|
int(10) |
No |
0 |
permission
|
int(10) |
No |
0 |
phorum_users
Field |
Type |
Null |
Default |
user_id
|
int(10) |
No |
|
username
|
varchar(50) |
No |
|
password
|
varchar(50) |
No |
|
cookie_sessid_lt
|
varchar(50) |
No |
|
sessid_st
|
varchar(50) |
No |
|
sessid_st_timeout
|
int(10) |
No |
0 |
password_temp
|
varchar(50) |
No |
|
email
|
varchar(100) |
No |
|
email_temp
|
varchar(110) |
No |
|
hide_email
|
tinyint(1) |
No |
0 |
active
|
tinyint(1) |
No |
0 |
user_data
|
text |
Yes |
NULL |
signature
|
text |
Yes |
NULL |
threaded_list
|
tinyint(4) |
No |
0 |
posts
|
int(10) |
No |
0 |
admin
|
tinyint(1) |
No |
0 |
threaded_read
|
tinyint(4) |
No |
0 |
date_added
|
int(10) |
No |
0 |
date_last_active
|
int(10) |
No |
0 |
last_active_forum
|
int(10) |
No |
0 |
hide_activity
|
tinyint(1) |
No |
0 |
show_signature
|
tinyint(1) |
No |
0 |
email_notify
|
tinyint(1) |
No |
0 |
pm_email_notify
|
tinyint(1) |
No |
1 |
tz_offset
|
tinyint(2) |
No |
-99 |
is_dst
|
tinyint(1) |
No |
0 |
user_language
|
varchar(100) |
No |
|
user_template
|
varchar(100) |
No |
|
moderator_data
|
text |
Yes |
NULL |
moderation_email
|
tinyint(2) |
No |
1 |
photopost_admingroups
Field |
Type |
Null |
Default |
id
|
int(3) |
No |
|
name
|
varchar(35) |
No |
|
photopost_admlog
Field |
Type |
Null |
Default |
id
|
int(10) |
No |
|
adminuser
|
varchar(50) |
No |
|
description
|
varchar(255) |
No |
|
datestamp
|
int(20) |
No |
0 |
ip
|
varchar(35) |
No |
|
photopost_cache
Field |
Type |
Null |
Default |
id
|
tinyint(1) |
No |
1 |
timestamp
|
int(15) |
No |
0 |
statscache
|
mediumtext |
Yes |
NULL |
recentcache
|
mediumtext |
Yes |
NULL |
popularcache
|
mediumtext |
Yes |
NULL |
randomcache
|
mediumtext |
Yes |
NULL |
calcache
|
mediumtext |
Yes |
NULL |
catcache
|
mediumtext |
Yes |
NULL |
catprops
|
mediumtext |
Yes |
NULL |
photopost_categories
Field |
Type |
Null |
Default |
id
|
int(12) |
No |
|
catname
|
varchar(255) |
No |
|
description
|
varchar(255) |
Yes |
NULL |
catorder
|
mediumint(4) |
No |
9999 |
thumbs
|
varchar(4) |
No |
yes |
parent
|
int(5) |
No |
0 |
header
|
varchar(200) |
Yes |
NULL |
footer
|
varchar(200) |
Yes |
NULL |
headtags
|
varchar(200) |
Yes |
NULL |
private
|
varchar(5) |
No |
no |
ugnoview
|
varchar(255) |
Yes |
NULL |
ugnoupload
|
varchar(255) |
Yes |
NULL |
ugnopost
|
varchar(255) |
Yes |
NULL |
ugnovote
|
varchar(255) |
Yes |
NULL |
ugnoanno
|
varchar(255) |
Yes |
NULL |
children
|
text |
Yes |
NULL |
albums
|
text |
Yes |
NULL |
subalbum
|
int(12) |
No |
0 |
lastpost
|
int(11) |
Yes |
NULL |
lastphoto
|
int(11) |
Yes |
NULL |
photos
|
int(11) |
Yes |
0 |
posts
|
int(11) |
Yes |
0 |
password
|
varchar(24) |
Yes |
NULL |
cattype
|
varchar(4) |
No |
c |
theme
|
varchar(32) |
Yes |
NULL |
thumbtype
|
int(2) |
Yes |
0 |
catdepth
|
varchar(6) |
Yes |
NULL |
watermark
|
varchar(250) |
No |
|
sortorder
|
int(2) |
No |
1 |
extra1
|
varchar(250) |
Yes |
NULL |
extra2
|
varchar(250) |
Yes |
NULL |
extra3
|
varchar(250) |
Yes |
NULL |
extra4
|
varchar(250) |
Yes |
NULL |
extra5
|
varchar(250) |
Yes |
NULL |
extra6
|
varchar(250) |
Yes |
NULL |
thumbnail
|
int(15) |
No |
0 |
maximages
|
int(12) |
No |
0 |
canzip
|
char(3) |
No |
no |
frames
|
varchar(32) |
No |
0 |
intro
|
char(3) |
No |
no |
introtitle
|
varchar(128) |
Yes |
NULL |
introcopy
|
text |
Yes |
NULL |
moderators
|
text |
Yes |
NULL |
numextra
|
int(3) |
No |
0 |
ratingtype
|
int(1) |
No |
0 |
takevotes
|
int(1) |
No |
0 |
ismember
|
smallint(1) |
No |
0 |
photopost_comments
Field |
Type |
Null |
Default |
id
|
int(11) |
No |
|
username
|
varchar(32) |
No |
|
userid
|
int(11) |
No |
0 |
date
|
int(15) |
No |
0 |
rating
|
float(12,2) |
Yes |
NULL |
comment
|
text |
No |
|
photo
|
int(11) |
No |
0 |
cat
|
int(11) |
No |
0 |
approved
|
int(2) |
No |
0 |
ipaddress
|
varchar(32) |
Yes |
0 |
photopost_ecards
Field |
Type |
Null |
Default |
id
|
int(25) |
No |
|
fromname
|
varchar(100) |
No |
|
toname
|
varchar(100) |
No |
|
subject
|
varchar(150) |
No |
|
message
|
text |
No |
|
photoid
|
int(25) |
No |
0 |
date
|
int(25) |
No |
0 |
backcolor
|
varchar(12) |
No |
#696969 |
bordcolor
|
varchar(12) |
No |
#000000 |
fontcolor
|
varchar(12) |
No |
#FFFFFF |
pickfont
|
varchar(32) |
No |
arial |
layout
|
varchar(24) |
No |
tobottom |
returnr
|
int(15) |
No |
0 |
readdate
|
int(15) |
No |
0 |
photopost_exif
Field |
Type |
Null |
Default |
photoid
|
int(11) |
No |
0 |
exifinfo
|
text |
Yes |
NULL |
photopost_extrafields
Field |
Type |
Null |
Default |
id
|
int(12) |
No |
|
cat
|
int(12) |
Yes |
NULL |
fieldname
|
varchar(255) |
Yes |
NULL |
fieldtype
|
char(2) |
Yes |
NULL |
fieldoptions
|
text |
Yes |
NULL |
photopost_favorites
Field |
Type |
Null |
Default |
id
|
int(12) |
No |
|
userid
|
int(8) |
No |
0 |
photo
|
int(11) |
No |
0 |
photopost_ipcache
Field |
Type |
Null |
Default |
id
|
int(10) |
No |
|
userid
|
int(25) |
No |
0 |
ipaddr
|
varchar(75) |
No |
|
date
|
int(11) |
Yes |
NULL |
type
|
varchar(4) |
No |
|
photo
|
int(10) |
No |
0 |
photopost_iponline
Field |
Type |
Null |
Default |
userid
|
varchar(128) |
No |
|
ipaddr
|
varchar(75) |
No |
|
date
|
int(11) |
Yes |
NULL |
what
|
varchar(64) |
No |
|
item
|
varchar(16) |
No |
|
photopost_laston
Field |
Type |
Null |
Default |
cat
|
smallint(4) |
No |
0 |
userid
|
mediumint(9) |
No |
0 |
laston
|
int(11) |
Yes |
NULL |
photopost_notify
Field |
Type |
Null |
Default |
id
|
int(15) |
No |
|
userid
|
int(25) |
No |
0 |
photo
|
int(25) |
No |
0 |
type
|
int(2) |
No |
0 |
photopost_photoextras
Field |
Type |
Null |
Default |
id
|
int(12) |
No |
|
photo
|
int(12) |
Yes |
NULL |
extraid
|
int(12) |
Yes |
NULL |
selection
|
text |
Yes |
NULL |
photopost_photos
Field |
Type |
Null |
Default |
id
|
int(10) |
No |
|
user
|
varchar(50) |
No |
|
userid
|
int(8) |
No |
0 |
cat
|
int(11) |
No |
0 |
storeid
|
int(12) |
No |
0 |
storecat
|
int(12) |
No |
0 |
date
|
int(15) |
No |
0 |
title
|
varchar(75) |
Yes |
|
description
|
text |
Yes |
NULL |
keywords
|
varchar(150) |
Yes |
NULL |
bigimage
|
varchar(100) |
No |
|
width
|
smallint(6) |
Yes |
NULL |
height
|
smallint(4) |
Yes |
NULL |
filesize
|
int(10) |
Yes |
0 |
views
|
int(10) |
No |
0 |
medwidth
|
int(12) |
Yes |
0 |
medheight
|
smallint(6) |
Yes |
0 |
medsize
|
mediumint(9) |
Yes |
0 |
approved
|
tinyint(2) |
No |
0 |
lastpost
|
int(15) |
No |
0 |
rating
|
float(12,2) |
No |
0.00 |
watermarked
|
varchar(5) |
No |
no |
allowprint
|
varchar(5) |
No |
yes |
extra1
|
varchar(255) |
Yes |
NULL |
extra2
|
varchar(255) |
Yes |
NULL |
extra3
|
varchar(255) |
Yes |
NULL |
extra4
|
varchar(255) |
Yes |
NULL |
extra5
|
varchar(255) |
Yes |
NULL |
extra6
|
varchar(255) |
Yes |
NULL |
disporder
|
int(5) |
No |
99999 |
ipaddress
|
varchar(32) |
Yes |
0 |
numcom
|
int(8) |
No |
0 |
lastposter
|
varchar(255) |
Yes |
NULL |
lastpid
|
int(8) |
No |
0 |
allowrate
|
int(1) |
No |
1 |
allowcoms
|
int(1) |
No |
1 |
photopost_photoviews
Field |
Type |
Null |
Default |
photoid
|
mediumint(9) |
No |
0 |
photopost_settings
Field |
Type |
Null |
Default |
id
|
int(11) |
No |
|
title
|
varchar(255) |
No |
|
varname
|
varchar(25) |
No |
|
description
|
varchar(250) |
No |
|
setting
|
varchar(250) |
No |
|
optionorder
|
int(3) |
No |
0 |
section
|
int(3) |
No |
0 |
photopost_sort
Field |
Type |
Null |
Default |
sortid
|
int(15) |
No |
|
name
|
varchar(35) |
No |
|
code
|
varchar(75) |
No |
|
photopost_sortmemb
Field |
Type |
Null |
Default |
sortid
|
int(15) |
No |
|
name
|
varchar(35) |
No |
|
code
|
varchar(75) |
No |
|
photopost_usergroups
Field |
Type |
Null |
Default |
groupid
|
int(5) |
No |
|
groupname
|
varchar(50) |
No |
|
cpaccess
|
smallint(3) |
No |
0 |
modaccess
|
smallint(3) |
No |
0 |
uploads
|
smallint(3) |
No |
1 |
comments
|
smallint(3) |
No |
1 |
diskspace
|
int(10) |
Yes |
NULL |
uploadsize
|
int(10) |
Yes |
NULL |
uplimit
|
int(5) |
No |
0 |
editpho
|
int(3) |
No |
0 |
editposts
|
int(3) |
No |
0 |
useralbums
|
int(3) |
No |
0 |
reqmod
|
int(3) |
No |
0 |
canassign
|
int(3) |
No |
0 |
photopost_users
Field |
Type |
Null |
Default |
userid
|
int(25) |
No |
|
usergroupid
|
int(5) |
No |
0 |
username
|
varchar(30) |
No |
|
password
|
varchar(50) |
No |
|
email
|
varchar(75) |
No |
|
homepage
|
varchar(100) |
Yes |
NULL |
icq
|
varchar(50) |
Yes |
NULL |
aim
|
varchar(30) |
Yes |
NULL |
yahoo
|
varchar(30) |
Yes |
NULL |
joindate
|
int(25) |
No |
0 |
posts
|
int(20) |
No |
0 |
birthday
|
date |
No |
0000-00-00 |
ipaddress
|
varchar(18) |
Yes |
NULL |
location
|
varchar(100) |
Yes |
NULL |
interests
|
varchar(250) |
Yes |
NULL |
occupation
|
varchar(250) |
Yes |
NULL |
bio
|
varchar(250) |
Yes |
NULL |
site
|
varchar(30) |
Yes |
NULL |
offset
|
smallint(2) |
No |
0 |
views
|
int(10) |
No |
0 |
cellphone
|
varchar(255) |
Yes |
NULL |
pics
Field |
Type |
Null |
Default |
month
|
char(2) |
No |
0 |
day
|
char(2) |
No |
0 |
year
|
int(4) |
No |
0 |
link1
|
text |
No |
|
entertainer
|
varchar(200) |
No |
|
eventname
|
varchar(100) |
No |
|
venue
|
varchar(50) |
No |
|
city
|
varchar(50) |
No |
|
weekday
|
varchar(10) |
No |
|
poll_comment
Field |
Type |
Null |
Default |
com_id
|
int(9) |
No |
|
poll_id
|
int(9) |
No |
0 |
time
|
int(11) |
No |
0 |
host
|
varchar(255) |
No |
|
browser
|
varchar(255) |
No |
|
name
|
varchar(60) |
No |
|
email
|
varchar(100) |
No |
|
message
|
text |
No |
|
poll_config
Field |
Type |
Null |
Default |
config_id
|
smallint(5) |
No |
|
base_gif
|
varchar(60) |
No |
|
lang
|
varchar(20) |
No |
|
title
|
varchar(60) |
No |
|
vote_button
|
varchar(30) |
No |
|
result_text
|
varchar(40) |
No |
|
total_text
|
varchar(40) |
No |
|
voted
|
varchar(40) |
No |
|
send_com
|
varchar(40) |
No |
|
img_height
|
int(5) |
No |
0 |
img_length
|
int(5) |
No |
0 |
table_width
|
varchar(6) |
No |
|
bgcolor_tab
|
varchar(7) |
No |
|
bgcolor_fr
|
varchar(7) |
No |
|
font_face
|
varchar(70) |
No |
|
font_color
|
varchar(7) |
No |
|
type
|
varchar(10) |
No |
0 |
check_ip
|
smallint(2) |
No |
0 |
lock_timeout
|
int(9) |
No |
0 |
time_offset
|
varchar(5) |
No |
0 |
entry_pp
|
int(4) |
No |
0 |
poll_version
|
varchar(5) |
No |
0 |
base_url
|
varchar(100) |
No |
|
result_order
|
varchar(20) |
No |
|
def_options
|
smallint(3) |
No |
0 |
polls_pp
|
int(5) |
No |
0 |
captcha
|
varchar(5) |
No |
|
poll_data
Field |
Type |
Null |
Default |
id
|
int(11) |
No |
|
poll_id
|
int(11) |
No |
0 |
option_id
|
int(11) |
No |
0 |
option_text
|
varchar(100) |
No |
|
color
|
varchar(20) |
No |
|
votes
|
int(14) |
No |
0 |
poll_index
Field |
Type |
Null |
Default |
poll_id
|
int(11) |
No |
|
question
|
varchar(100) |
No |
|
timestamp
|
int(11) |
No |
0 |
status
|
smallint(2) |
No |
0 |
logging
|
smallint(2) |
No |
0 |
exp_time
|
int(11) |
No |
0 |
expire
|
smallint(2) |
No |
0 |
comments
|
smallint(2) |
No |
0 |
poll_ip
Field |
Type |
Null |
Default |
ip_id
|
int(11) |
No |
|
poll_id
|
int(11) |
No |
0 |
ip_addr
|
varchar(15) |
No |
|
timestamp
|
int(11) |
No |
0 |
poll_log
Field |
Type |
Null |
Default |
log_id
|
int(11) |
No |
|
poll_id
|
int(11) |
No |
0 |
option_id
|
int(11) |
No |
0 |
timestamp
|
int(11) |
No |
0 |
ip_addr
|
varchar(15) |
No |
|
host
|
varchar(255) |
No |
|
agent
|
varchar(255) |
No |
0 |
poll_templates
Field |
Type |
Null |
Default |
tpl_id
|
int(10) |
No |
|
tplset_id
|
int(10) |
No |
0 |
title
|
varchar(100) |
No |
|
template
|
mediumtext |
No |
|
poll_templateset
Field |
Type |
Null |
Default |
tplset_id
|
int(10) |
No |
|
tplset_name
|
varchar(50) |
No |
|
created
|
datetime |
Yes |
0000-00-00 00:00:00 |
poll_user
Field |
Type |
Null |
Default |
user_id
|
smallint(5) |
No |
|
username
|
varchar(30) |
No |
|
userpass
|
varchar(32) |
No |
|
session
|
varchar(32) |
No |
|
last_visit
|
int(11) |
No |
0 |
radio
Field |
Type |
Null |
Default |
id
|
smallint(10) |
No |
|
amfm
|
varchar(4) |
No |
|
letters
|
varchar(8) |
No |
|
frequency
|
varchar(8) |
No |
|
format
|
varchar(75) |
No |
|
website
|
varchar(30) |
No |
|
owner
|
varchar(20) |
No |
|
city
|
varchar(20) |
No |
|
state
|
varchar(20) |
No |
|
test
Field |
Type |
Null |
Default |
field1
|
varchar(100) |
No |
|
top40vids
Field |
Type |
Null |
Default |
id
|
int(10) |
No |
|
artist
|
varchar(100) |
No |
|
title
|
varchar(100) |
No |
|
url
|
varchar(100) |
No |
|
users
Field |
Type |
Null |
Default |
ip
|
varchar(15) |
No |
|
time
|
int(11) |
No |
0 |
url
|
text |
No |
|
users2
Field |
Type |
Null |
Default |
ip
|
varchar(15) |
No |
|
time
|
int(11) |
No |
0 |
url
|
text |
No |
|
videos
Field |
Type |
Null |
Default |
id
|
int(10) |
No |
|
artist
|
varchar(100) |
No |
|
title
|
varchar(100) |
No |
|
url
|
varchar(100) |
No |
|
vids
Field |
Type |
Null |
Default |
id
|
int(4) |
No |
|
artist
|
varchar(50) |
No |
|
title
|
varchar(50) |
No |
|
link
|
varchar(200) |
No |
|
wp_1_comments
Field |
Type |
Null |
Default |
comment_ID
|
bigint(20) |
No |
|
comment_post_ID
|
int(11) |
No |
0 |
comment_author
|
tinytext |
No |
|
comment_author_email
|
varchar(100) |
No |
|
comment_author_url
|
varchar(200) |
No |
|
comment_author_IP
|
varchar(100) |
No |
|
comment_date
|
datetime |
No |
0000-00-00 00:00:00 |
comment_date_gmt
|
datetime |
No |
0000-00-00 00:00:00 |
comment_content
|
text |
No |
|
comment_karma
|
int(11) |
No |
0 |
comment_approved
|
varchar(20) |
No |
1 |
comment_agent
|
varchar(255) |
No |
|
comment_type
|
varchar(20) |
No |
|
comment_parent
|
bigint(20) |
No |
0 |
user_id
|
bigint(20) |
No |
0 |
wp_1_links
Field |
Type |
Null |
Default |
link_id
|
bigint(20) |
No |
|
link_url
|
varchar(255) |
No |
|
link_name
|
varchar(255) |
No |
|
link_image
|
varchar(255) |
No |
|
link_target
|
varchar(25) |
No |
|
link_category
|
bigint(20) |
No |
0 |
link_description
|
varchar(255) |
No |
|
link_visible
|
varchar(20) |
No |
Y |
link_owner
|
int(11) |
No |
1 |
link_rating
|
int(11) |
No |
0 |
link_updated
|
datetime |
No |
0000-00-00 00:00:00 |
link_rel
|
varchar(255) |
No |
|
link_notes
|
mediumtext |
No |
|
link_rss
|
varchar(255) |
No |
|
wp_1_options
Field |
Type |
Null |
Default |
option_id
|
bigint(20) |
No |
|
blog_id
|
int(11) |
No |
0 |
option_name
|
varchar(64) |
No |
|
option_value
|
longtext |
No |
|
autoload
|
varchar(20) |
No |
yes |
wp_1_postmeta
Field |
Type |
Null |
Default |
meta_id
|
bigint(20) |
No |
|
post_id
|
bigint(20) |
No |
0 |
meta_key
|
varchar(255) |
Yes |
NULL |
meta_value
|
longtext |
Yes |
NULL |
wp_1_posts
Field |
Type |
Null |
Default |
ID
|
bigint(20) |
No |
|
post_author
|
bigint(20) |
No |
0 |
post_date
|
datetime |
No |
0000-00-00 00:00:00 |
post_date_gmt
|
datetime |
No |
0000-00-00 00:00:00 |
post_content
|
longtext |
No |
|
post_title
|
text |
No |
|
post_category
|
int(4) |
No |
0 |
post_excerpt
|
text |
No |
|
post_status
|
varchar(20) |
No |
publish |
comment_status
|
varchar(20) |
No |
open |
ping_status
|
varchar(20) |
No |
open |
post_password
|
varchar(20) |
No |
|
post_name
|
varchar(200) |
No |
|
to_ping
|
text |
No |
|
pinged
|
text |
No |
|
post_modified
|
datetime |
No |
0000-00-00 00:00:00 |
post_modified_gmt
|
datetime |
No |
0000-00-00 00:00:00 |
post_content_filtered
|
text |
No |
|
post_parent
|
bigint(20) |
No |
0 |
guid
|
varchar(255) |
No |
|
menu_order
|
int(11) |
No |
0 |
post_type
|
varchar(20) |
No |
post |
post_mime_type
|
varchar(100) |
No |
|
comment_count
|
bigint(20) |
No |
0 |
wp_1_term_relationships
Field |
Type |
Null |
Default |
object_id
|
bigint(20) |
No |
0 |
term_taxonomy_id
|
bigint(20) |
No |
0 |
term_order
|
int(11) |
No |
0 |
wp_1_term_taxonomy
Field |
Type |
Null |
Default |
term_taxonomy_id
|
bigint(20) |
No |
|
term_id
|
bigint(20) |
No |
0 |
taxonomy
|
varchar(32) |
No |
|
description
|
longtext |
No |
|
parent
|
bigint(20) |
No |
0 |
count
|
bigint(20) |
No |
0 |
wp_1_terms
Field |
Type |
Null |
Default |
term_id
|
bigint(20) |
No |
|
name
|
varchar(55) |
No |
|
slug
|
varchar(200) |
No |
|
term_group
|
bigint(10) |
No |
0 |
wp_2_comments
Field |
Type |
Null |
Default |
comment_ID
|
bigint(20) |
No |
|
comment_post_ID
|
int(11) |
No |
0 |
comment_author
|
tinytext |
No |
|
comment_author_email
|
varchar(100) |
No |
|
comment_author_url
|
varchar(200) |
No |
|
comment_author_IP
|
varchar(100) |
No |
|
comment_date
|
datetime |
No |
0000-00-00 00:00:00 |
comment_date_gmt
|
datetime |
No |
0000-00-00 00:00:00 |
comment_content
|
text |
No |
|
comment_karma
|
int(11) |
No |
0 |
comment_approved
|
varchar(20) |
No |
1 |
comment_agent
|
varchar(255) |
No |
|
comment_type
|
varchar(20) |
No |
|
comment_parent
|
bigint(20) |
No |
0 |
user_id
|
bigint(20) |
No |
0 |
wp_2_links
Field |
Type |
Null |
Default |
link_id
|
bigint(20) |
No |
|
link_url
|
varchar(255) |
No |
|
link_name
|
varchar(255) |
No |
|
link_image
|
varchar(255) |
No |
|
link_target
|
varchar(25) |
No |
|
link_category
|
bigint(20) |
No |
0 |
link_description
|
varchar(255) |
No |
|
link_visible
|
varchar(20) |
No |
Y |
link_owner
|
int(11) |
No |
1 |
link_rating
|
int(11) |
No |
0 |
link_updated
|
datetime |
No |
0000-00-00 00:00:00 |
link_rel
|
varchar(255) |
No |
|
link_notes
|
mediumtext |
No |
|
link_rss
|
varchar(255) |
No |
|
wp_2_options
Field |
Type |
Null |
Default |
option_id
|
bigint(20) |
No |
|
blog_id
|
int(11) |
No |
0 |
option_name
|
varchar(64) |
No |
|
option_value
|
longtext |
No |
|
autoload
|
varchar(20) |
No |
yes |
wp_2_postmeta
Field |
Type |
Null |
Default |
meta_id
|
bigint(20) |
No |
|
post_id
|
bigint(20) |
No |
0 |
meta_key
|
varchar(255) |
Yes |
NULL |
meta_value
|
longtext |
Yes |
NULL |
wp_2_posts
Field |
Type |
Null |
Default |
ID
|
bigint(20) |
No |
|
post_author
|
bigint(20) |
No |
0 |
post_date
|
datetime |
No |
0000-00-00 00:00:00 |
post_date_gmt
|
datetime |
No |
0000-00-00 00:00:00 |
post_content
|
longtext |
No |
|
post_title
|
text |
No |
|
post_category
|
int(4) |
No |
0 |
post_excerpt
|
text |
No |
|
post_status
|
varchar(20) |
No |
publish |
comment_status
|
varchar(20) |
No |
open |
ping_status
|
varchar(20) |
No |
open |
post_password
|
varchar(20) |
No |
|
post_name
|
varchar(200) |
No |
|
to_ping
|
text |
No |
|
pinged
|
text |
No |
|
post_modified
|
datetime |
No |
0000-00-00 00:00:00 |
post_modified_gmt
|
datetime |
No |
0000-00-00 00:00:00 |
post_content_filtered
|
text |
No |
|
post_parent
|
bigint(20) |
No |
0 |
guid
|
varchar(255) |
No |
|
menu_order
|
int(11) |
No |
0 |
post_type
|
varchar(20) |
No |
post |
post_mime_type
|
varchar(100) |
No |
|
comment_count
|
bigint(20) |
No |
0 |
wp_2_term_relationships
Field |
Type |
Null |
Default |
object_id
|
bigint(20) |
No |
0 |
term_taxonomy_id
|
bigint(20) |
No |
0 |
term_order
|
int(11) |
No |
0 |
wp_2_term_taxonomy
Field |
Type |
Null |
Default |
term_taxonomy_id
|
bigint(20) |
No |
|
term_id
|
bigint(20) |
No |
0 |
taxonomy
|
varchar(32) |
No |
|
description
|
longtext |
No |
|
parent
|
bigint(20) |
No |
0 |
count
|
bigint(20) |
No |
0 |
wp_2_terms
Field |
Type |
Null |
Default |
term_id
|
bigint(20) |
No |
|
name
|
varchar(55) |
No |
|
slug
|
varchar(200) |
No |
|
term_group
|
bigint(10) |
No |
0 |
wp_3_comments
Field |
Type |
Null |
Default |
comment_ID
|
bigint(20) |
No |
|
comment_post_ID
|
int(11) |
No |
0 |
comment_author
|
tinytext |
No |
|
comment_author_email
|
varchar(100) |
No |
|
comment_author_url
|
varchar(200) |
No |
|
comment_author_IP
|
varchar(100) |
No |
|
comment_date
|
datetime |
No |
0000-00-00 00:00:00 |
comment_date_gmt
|
datetime |
No |
0000-00-00 00:00:00 |
comment_content
|
text |
No |
|
comment_karma
|
int(11) |
No |
0 |
comment_approved
|
varchar(20) |
No |
1 |
comment_agent
|
varchar(255) |
No |
|
comment_type
|
varchar(20) |
No |
|
comment_parent
|
bigint(20) |
No |
0 |
user_id
|
bigint(20) |
No |
0 |
wp_3_links
Field |
Type |
Null |
Default |
link_id
|
bigint(20) |
No |
|
link_url
|
varchar(255) |
No |
|
link_name
|
varchar(255) |
No |
|
link_image
|
varchar(255) |
No |
|
link_target
|
varchar(25) |
No |
|
link_category
|
bigint(20) |
No |
0 |
link_description
|
varchar(255) |
No |
|
link_visible
|
varchar(20) |
No |
Y |
link_owner
|
int(11) |
No |
1 |
link_rating
|
int(11) |
No |
0 |
link_updated
|
datetime |
No |
0000-00-00 00:00:00 |
link_rel
|
varchar(255) |
No |
|
link_notes
|
mediumtext |
No |
|
link_rss
|
varchar(255) |
No |
|
wp_3_options
Field |
Type |
Null |
Default |
option_id
|
bigint(20) |
No |
|
blog_id
|
int(11) |
No |
0 |
option_name
|
varchar(64) |
No |
|
option_value
|
longtext |
No |
|
autoload
|
varchar(20) |
No |
yes |
wp_3_postmeta
Field |
Type |
Null |
Default |
meta_id
|
bigint(20) |
No |
|
post_id
|
bigint(20) |
No |
0 |
meta_key
|
varchar(255) |
Yes |
NULL |
meta_value
|
longtext |
Yes |
NULL |
wp_3_posts
Field |
Type |
Null |
Default |
ID
|
bigint(20) |
No |
|
post_author
|
bigint(20) |
No |
0 |
post_date
|
datetime |
No |
0000-00-00 00:00:00 |
post_date_gmt
|
datetime |
No |
0000-00-00 00:00:00 |
post_content
|
longtext |
No |
|
post_title
|
text |
No |
|
post_category
|
int(4) |
No |
0 |
post_excerpt
|
text |
No |
|
post_status
|
varchar(20) |
No |
publish |
comment_status
|
varchar(20) |
No |
open |
ping_status
|
varchar(20) |
No |
open |
post_password
|
varchar(20) |
No |
|
post_name
|
varchar(200) |
No |
|
to_ping
|
text |
No |
|
pinged
|
text |
No |
|
post_modified
|
datetime |
No |
0000-00-00 00:00:00 |
post_modified_gmt
|
datetime |
No |
0000-00-00 00:00:00 |
post_content_filtered
|
text |
No |
|
post_parent
|
bigint(20) |
No |
0 |
guid
|
varchar(255) |
No |
|
menu_order
|
int(11) |
No |
0 |
post_type
|
varchar(20) |
No |
post |
post_mime_type
|
varchar(100) |
No |
|
comment_count
|
bigint(20) |
No |
0 |
wp_3_term_relationships
Field |
Type |
Null |
Default |
object_id
|
bigint(20) |
No |
0 |
term_taxonomy_id
|
bigint(20) |
No |
0 |
term_order
|
int(11) |
No |
0 |
wp_3_term_taxonomy
Field |
Type |
Null |
Default |
term_taxonomy_id
|
bigint(20) |
No |
|
term_id
|
bigint(20) |
No |
0 |
taxonomy
|
varchar(32) |
No |
|
description
|
longtext |
No |
|
parent
|
bigint(20) |
No |
0 |
count
|
bigint(20) |
No |
0 |
wp_3_terms
Field |
Type |
Null |
Default |
term_id
|
bigint(20) |
No |
|
name
|
varchar(55) |
No |
|
slug
|
varchar(200) |
No |
|
term_group
|
bigint(10) |
No |
0 |
wp_4_comments
Field |
Type |
Null |
Default |
comment_ID
|
bigint(20) |
No |
|
comment_post_ID
|
int(11) |
No |
0 |
comment_author
|
tinytext |
No |
|
comment_author_email
|
varchar(100) |
No |
|
comment_author_url
|
varchar(200) |
No |
|
comment_author_IP
|
varchar(100) |
No |
|
comment_date
|
datetime |
No |
0000-00-00 00:00:00 |
comment_date_gmt
|
datetime |
No |
0000-00-00 00:00:00 |
comment_content
|
text |
No |
|
comment_karma
|
int(11) |
No |
0 |
comment_approved
|
varchar(20) |
No |
1 |
comment_agent
|
varchar(255) |
No |
|
comment_type
|
varchar(20) |
No |
|
comment_parent
|
bigint(20) |
No |
0 |
user_id
|
bigint(20) |
No |
0 |
wp_4_links
Field |
Type |
Null |
Default |
link_id
|
bigint(20) |
No |
|
link_url
|
varchar(255) |
No |
|
link_name
|
varchar(255) |
No |
|
link_image
|
varchar(255) |
No |
|
link_target
|
varchar(25) |
No |
|
link_category
|
bigint(20) |
No |
0 |
link_description
|
varchar(255) |
No |
|
link_visible
|
varchar(20) |
No |
Y |
link_owner
|
int(11) |
No |
1 |
link_rating
|
int(11) |
No |
0 |
link_updated
|
datetime |
No |
0000-00-00 00:00:00 |
link_rel
|
varchar(255) |
No |
|
link_notes
|
mediumtext |
No |
|
link_rss
|
varchar(255) |
No |
|
wp_4_options
Field |
Type |
Null |
Default |
option_id
|
bigint(20) |
No |
|
blog_id
|
int(11) |
No |
0 |
option_name
|
varchar(64) |
No |
|
option_value
|
longtext |
No |
|
autoload
|
varchar(20) |
No |
yes |
wp_4_postmeta
Field |
Type |
Null |
Default |
meta_id
|
bigint(20) |
No |
|
post_id
|
bigint(20) |
No |
0 |
meta_key
|
varchar(255) |
Yes |
NULL |
meta_value
|
longtext |
Yes |
NULL |
wp_4_posts
Field |
Type |
Null |
Default |
ID
|
bigint(20) |
No |
|
post_author
|
bigint(20) |
No |
0 |
post_date
|
datetime |
No |
0000-00-00 00:00:00 |
post_date_gmt
|
datetime |
No |
0000-00-00 00:00:00 |
post_content
|
longtext |
No |
|
post_title
|
text |
No |
|
post_category
|
int(4) |
No |
0 |
post_excerpt
|
text |
No |
|
post_status
|
varchar(20) |
No |
publish |
comment_status
|
varchar(20) |
No |
open |
ping_status
|
varchar(20) |
No |
open |
post_password
|
varchar(20) |
No |
|
post_name
|
varchar(200) |
No |
|
to_ping
|
text |
No |
|
pinged
|
text |
No |
|
post_modified
|
datetime |
No |
0000-00-00 00:00:00 |
post_modified_gmt
|
datetime |
No |
0000-00-00 00:00:00 |
post_content_filtered
|
text |
No |
|
post_parent
|
bigint(20) |
No |
0 |
guid
|
varchar(255) |
No |
|
menu_order
|
int(11) |
No |
0 |
post_type
|
varchar(20) |
No |
post |
post_mime_type
|
varchar(100) |
No |
|
comment_count
|
bigint(20) |
No |
0 |
wp_4_term_relationships
Field |
Type |
Null |
Default |
object_id
|
bigint(20) |
No |
0 |
term_taxonomy_id
|
bigint(20) |
No |
0 |
term_order
|
int(11) |
No |
0 |
wp_4_term_taxonomy
Field |
Type |
Null |
Default |
term_taxonomy_id
|
bigint(20) |
No |
|
term_id
|
bigint(20) |
No |
0 |
taxonomy
|
varchar(32) |
No |
|
description
|
longtext |
No |
|
parent
|
bigint(20) |
No |
0 |
count
|
bigint(20) |
No |
0 |
wp_4_terms
Field |
Type |
Null |
Default |
term_id
|
bigint(20) |
No |
|
name
|
varchar(55) |
No |
|
slug
|
varchar(200) |
No |
|
term_group
|
bigint(10) |
No |
0 |
wp_5_comments
Field |
Type |
Null |
Default |
comment_ID
|
bigint(20) |
No |
|
comment_post_ID
|
int(11) |
No |
0 |
comment_author
|
tinytext |
No |
|
comment_author_email
|
varchar(100) |
No |
|
comment_author_url
|
varchar(200) |
No |
|
comment_author_IP
|
varchar(100) |
No |
|
comment_date
|
datetime |
No |
0000-00-00 00:00:00 |
comment_date_gmt
|
datetime |
No |
0000-00-00 00:00:00 |
comment_content
|
text |
No |
|
comment_karma
|
int(11) |
No |
0 |
comment_approved
|
varchar(20) |
No |
1 |
comment_agent
|
varchar(255) |
No |
|
comment_type
|
varchar(20) |
No |
|
comment_parent
|
bigint(20) |
No |
0 |
user_id
|
bigint(20) |
No |
0 |
wp_5_links
Field |
Type |
Null |
Default |
link_id
|
bigint(20) |
No |
|
link_url
|
varchar(255) |
No |
|
link_name
|
varchar(255) |
No |
|
link_image
|
varchar(255) |
No |
|
link_target
|
varchar(25) |
No |
|
link_category
|
bigint(20) |
No |
0 |
link_description
|
varchar(255) |
No |
|
link_visible
|
varchar(20) |
No |
Y |
link_owner
|
int(11) |
No |
1 |
link_rating
|
int(11) |
No |
0 |
link_updated
|
datetime |
No |
0000-00-00 00:00:00 |
link_rel
|
varchar(255) |
No |
|
link_notes
|
mediumtext |
No |
|
link_rss
|
varchar(255) |
No |
|
wp_5_options
Field |
Type |
Null |
Default |
option_id
|
bigint(20) |
No |
|
blog_id
|
int(11) |
No |
0 |
option_name
|
varchar(64) |
No |
|
option_value
|
longtext |
No |
|
autoload
|
varchar(20) |
No |
yes |
wp_5_postmeta
Field |
Type |
Null |
Default |
meta_id
|
bigint(20) |
No |
|
post_id
|
bigint(20) |
No |
0 |
meta_key
|
varchar(255) |
Yes |
NULL |
meta_value
|
longtext |
Yes |
NULL |
wp_5_posts
Field |
Type |
Null |
Default |
ID
|
bigint(20) |
No |
|
post_author
|
bigint(20) |
No |
0 |
post_date
|
datetime |
No |
0000-00-00 00:00:00 |
post_date_gmt
|
datetime |
No |
0000-00-00 00:00:00 |
post_content
|
longtext |
No |
|
post_title
|
text |
No |
|
post_category
|
int(4) |
No |
0 |
post_excerpt
|
text |
No |
|
post_status
|
varchar(20) |
No |
publish |
comment_status
|
varchar(20) |
No |
open |
ping_status
|
varchar(20) |
No |
open |
post_password
|
varchar(20) |
No |
|
post_name
|
varchar(200) |
No |
|
to_ping
|
text |
No |
|
pinged
|
text |
No |
|
post_modified
|
datetime |
No |
0000-00-00 00:00:00 |
post_modified_gmt
|
datetime |
No |
0000-00-00 00:00:00 |
post_content_filtered
|
text |
No |
|
post_parent
|
bigint(20) |
No |
0 |
guid
|
varchar(255) |
No |
|
menu_order
|
int(11) |
No |
0 |
post_type
|
varchar(20) |
No |
post |
post_mime_type
|
varchar(100) |
No |
|
comment_count
|
bigint(20) |
No |
0 |
wp_5_term_relationships
Field |
Type |
Null |
Default |
object_id
|
bigint(20) |
No |
0 |
term_taxonomy_id
|
bigint(20) |
No |
0 |
term_order
|
int(11) |
No |
0 |
wp_5_term_taxonomy
Field |
Type |
Null |
Default |
term_taxonomy_id
|
bigint(20) |
No |
|
term_id
|
bigint(20) |
No |
0 |
taxonomy
|
varchar(32) |
No |
|
description
|
longtext |
No |
|
parent
|
bigint(20) |
No |
0 |
count
|
bigint(20) |
No |
0 |
wp_5_terms
Field |
Type |
Null |
Default |
term_id
|
bigint(20) |
No |
|
name
|
varchar(55) |
No |
|
slug
|
varchar(200) |
No |
|
term_group
|
bigint(10) |
No |
0 |
wp_7_comments
Field |
Type |
Null |
Default |
comment_ID
|
bigint(20) |
No |
|
comment_post_ID
|
int(11) |
No |
0 |
comment_author
|
tinytext |
No |
|
comment_author_email
|
varchar(100) |
No |
|
comment_author_url
|
varchar(200) |
No |
|
comment_author_IP
|
varchar(100) |
No |
|
comment_date
|
datetime |
No |
0000-00-00 00:00:00 |
comment_date_gmt
|
datetime |
No |
0000-00-00 00:00:00 |
comment_content
|
text |
No |
|
comment_karma
|
int(11) |
No |
0 |
comment_approved
|
varchar(20) |
No |
1 |
comment_agent
|
varchar(255) |
No |
|
comment_type
|
varchar(20) |
No |
|
comment_parent
|
bigint(20) |
No |
0 |
user_id
|
bigint(20) |
No |
0 |
wp_7_links
Field |
Type |
Null |
Default |
link_id
|
bigint(20) |
No |
|
link_url
|
varchar(255) |
No |
|
link_name
|
varchar(255) |
No |
|
link_image
|
varchar(255) |
No |
|
link_target
|
varchar(25) |
No |
|
link_category
|
bigint(20) |
No |
0 |
link_description
|
varchar(255) |
No |
|
link_visible
|
varchar(20) |
No |
Y |
link_owner
|
int(11) |
No |
1 |
link_rating
|
int(11) |
No |
0 |
link_updated
|
datetime |
No |
0000-00-00 00:00:00 |
link_rel
|
varchar(255) |
No |
|
link_notes
|
mediumtext |
No |
|
link_rss
|
varchar(255) |
No |
|
wp_7_options
Field |
Type |
Null |
Default |
option_id
|
bigint(20) |
No |
|
blog_id
|
int(11) |
No |
0 |
option_name
|
varchar(64) |
No |
|
option_value
|
longtext |
No |
|
autoload
|
varchar(20) |
No |
yes |
wp_7_postmeta
Field |
Type |
Null |
Default |
meta_id
|
bigint(20) |
No |
|
post_id
|
bigint(20) |
No |
0 |
meta_key
|
varchar(255) |
Yes |
NULL |
meta_value
|
longtext |
Yes |
NULL |
wp_7_posts
Field |
Type |
Null |
Default |
ID
|
bigint(20) |
No |
|
post_author
|
bigint(20) |
No |
0 |
post_date
|
datetime |
No |
0000-00-00 00:00:00 |
post_date_gmt
|
datetime |
No |
0000-00-00 00:00:00 |
post_content
|
longtext |
No |
|
post_title
|
text |
No |
|
post_category
|
int(4) |
No |
0 |
post_excerpt
|
text |
No |
|
post_status
|
varchar(20) |
No |
publish |
comment_status
|
varchar(20) |
No |
open |
ping_status
|
varchar(20) |
No |
open |
post_password
|
varchar(20) |
No |
|
post_name
|
varchar(200) |
No |
|
to_ping
|
text |
No |
|
pinged
|
text |
No |
|
post_modified
|
datetime |
No |
0000-00-00 00:00:00 |
post_modified_gmt
|
datetime |
No |
0000-00-00 00:00:00 |
post_content_filtered
|
text |
No |
|
post_parent
|
bigint(20) |
No |
0 |
guid
|
varchar(255) |
No |
|
menu_order
|
int(11) |
No |
0 |
post_type
|
varchar(20) |
No |
post |
post_mime_type
|
varchar(100) |
No |
|
comment_count
|
bigint(20) |
No |
0 |
wp_7_term_relationships
Field |
Type |
Null |
Default |
object_id
|
bigint(20) |
No |
0 |
term_taxonomy_id
|
bigint(20) |
No |
0 |
term_order
|
int(11) |
No |
0 |
wp_7_term_taxonomy
Field |
Type |
Null |
Default |
term_taxonomy_id
|
bigint(20) |
No |
|
term_id
|
bigint(20) |
No |
0 |
taxonomy
|
varchar(32) |
No |
|
description
|
longtext |
No |
|
parent
|
bigint(20) |
No |
0 |
count
|
bigint(20) |
No |
0 |
wp_7_terms
Field |
Type |
Null |
Default |
term_id
|
bigint(20) |
No |
|
name
|
varchar(55) |
No |
|
slug
|
varchar(200) |
No |
|
term_group
|
bigint(10) |
No |
0 |
wp_8_comments
Field |
Type |
Null |
Default |
comment_ID
|
bigint(20) |
No |
|
comment_post_ID
|
int(11) |
No |
0 |
comment_author
|
tinytext |
No |
|
comment_author_email
|
varchar(100) |
No |
|
comment_author_url
|
varchar(200) |
No |
|
comment_author_IP
|
varchar(100) |
No |
|
comment_date
|
datetime |
No |
0000-00-00 00:00:00 |
comment_date_gmt
|
datetime |
No |
0000-00-00 00:00:00 |
comment_content
|
text |
No |
|
comment_karma
|
int(11) |
No |
0 |
comment_approved
|
varchar(20) |
No |
1 |
comment_agent
|
varchar(255) |
No |
|
comment_type
|
varchar(20) |
No |
|
comment_parent
|
bigint(20) |
No |
0 |
user_id
|
bigint(20) |
No |
0 |
wp_8_links
Field |
Type |
Null |
Default |
link_id
|
bigint(20) |
No |
|
link_url
|
varchar(255) |
No |
|
link_name
|
varchar(255) |
No |
|
link_image
|
varchar(255) |
No |
|
link_target
|
varchar(25) |
No |
|
link_category
|
bigint(20) |
No |
0 |
link_description
|
varchar(255) |
No |
|
link_visible
|
varchar(20) |
No |
Y |
link_owner
|
int(11) |
No |
1 |
link_rating
|
int(11) |
No |
0 |
link_updated
|
datetime |
No |
0000-00-00 00:00:00 |
link_rel
|
varchar(255) |
No |
|
link_notes
|
mediumtext |
No |
|
link_rss
|
varchar(255) |
No |
|
wp_8_options
Field |
Type |
Null |
Default |
option_id
|
bigint(20) |
No |
|
blog_id
|
int(11) |
No |
0 |
option_name
|
varchar(64) |
No |
|
option_value
|
longtext |
No |
|
autoload
|
varchar(20) |
No |
yes |
wp_8_postmeta
Field |
Type |
Null |
Default |
meta_id
|
bigint(20) |
No |
|
post_id
|
bigint(20) |
No |
0 |
meta_key
|
varchar(255) |
Yes |
NULL |
meta_value
|
longtext |
Yes |
NULL |
wp_8_posts
Field |
Type |
Null |
Default |
ID
|
bigint(20) |
No |
|
post_author
|
bigint(20) |
No |
0 |
post_date
|
datetime |
No |
0000-00-00 00:00:00 |
post_date_gmt
|
datetime |
No |
0000-00-00 00:00:00 |
post_content
|
longtext |
No |
|
post_title
|
text |
No |
|
post_category
|
int(4) |
No |
0 |
post_excerpt
|
text |
No |
|
post_status
|
varchar(20) |
No |
publish |
comment_status
|
varchar(20) |
No |
open |
ping_status
|
varchar(20) |
No |
open |
post_password
|
varchar(20) |
No |
|
post_name
|
varchar(200) |
No |
|
to_ping
|
text |
No |
|
pinged
|
text |
No |
|
post_modified
|
datetime |
No |
0000-00-00 00:00:00 |
post_modified_gmt
|
datetime |
No |
0000-00-00 00:00:00 |
post_content_filtered
|
text |
No |
|
post_parent
|
bigint(20) |
No |
0 |
guid
|
varchar(255) |
No |
|
menu_order
|
int(11) |
No |
0 |
post_type
|
varchar(20) |
No |
post |
post_mime_type
|
varchar(100) |
No |
|
comment_count
|
bigint(20) |
No |
0 |
wp_8_term_relationships
Field |
Type |
Null |
Default |
object_id
|
bigint(20) |
No |
0 |
term_taxonomy_id
|
bigint(20) |
No |
0 |
term_order
|
int(11) |
No |
0 |
wp_8_term_taxonomy
Field |
Type |
Null |
Default |
term_taxonomy_id
|
bigint(20) |
No |
|
term_id
|
bigint(20) |
No |
0 |
taxonomy
|
varchar(32) |
No |
|
description
|
longtext |
No |
|
parent
|
bigint(20) |
No |
0 |
count
|
bigint(20) |
No |
0 |
wp_8_terms
Field |
Type |
Null |
Default |
term_id
|
bigint(20) |
No |
|
name
|
varchar(55) |
No |
|
slug
|
varchar(200) |
No |
|
term_group
|
bigint(10) |
No |
0 |
wp_9_comments
Field |
Type |
Null |
Default |
comment_ID
|
bigint(20) |
No |
|
comment_post_ID
|
int(11) |
No |
0 |
comment_author
|
tinytext |
No |
|
comment_author_email
|
varchar(100) |
No |
|
comment_author_url
|
varchar(200) |
No |
|
comment_author_IP
|
varchar(100) |
No |
|
comment_date
|
datetime |
No |
0000-00-00 00:00:00 |
comment_date_gmt
|
datetime |
No |
0000-00-00 00:00:00 |
comment_content
|
text |
No |
|
comment_karma
|
int(11) |
No |
0 |
comment_approved
|
varchar(20) |
No |
1 |
comment_agent
|
varchar(255) |
No |
|
comment_type
|
varchar(20) |
No |
|
comment_parent
|
bigint(20) |
No |
0 |
user_id
|
bigint(20) |
No |
0 |
wp_9_links
Field |
Type |
Null |
Default |
link_id
|
bigint(20) |
No |
|
link_url
|
varchar(255) |
No |
|
link_name
|
varchar(255) |
No |
|
link_image
|
varchar(255) |
No |
|
link_target
|
varchar(25) |
No |
|
link_category
|
bigint(20) |
No |
0 |
link_description
|
varchar(255) |
No |
|
link_visible
|
varchar(20) |
No |
Y |
link_owner
|
int(11) |
No |
1 |
link_rating
|
int(11) |
No |
0 |
link_updated
|
datetime |
No |
0000-00-00 00:00:00 |
link_rel
|
varchar(255) |
No |
|
link_notes
|
mediumtext |
No |
|
link_rss
|
varchar(255) |
No |
|
wp_9_options
Field |
Type |
Null |
Default |
option_id
|
bigint(20) |
No |
|
blog_id
|
int(11) |
No |
0 |
option_name
|
varchar(64) |
No |
|
option_value
|
longtext |
No |
|
autoload
|
varchar(20) |
No |
yes |
wp_9_postmeta
Field |
Type |
Null |
Default |
meta_id
|
bigint(20) |
No |
|
post_id
|
bigint(20) |
No |
0 |
meta_key
|
varchar(255) |
Yes |
NULL |
meta_value
|
longtext |
Yes |
NULL |
wp_9_posts
Field |
Type |
Null |
Default |
ID
|
bigint(20) |
No |
|
post_author
|
bigint(20) |
No |
0 |
post_date
|
datetime |
No |
0000-00-00 00:00:00 |
post_date_gmt
|
datetime |
No |
0000-00-00 00:00:00 |
post_content
|
longtext |
No |
|
post_title
|
text |
No |
|
post_category
|
int(4) |
No |
0 |
post_excerpt
|
text |
No |
|
post_status
|
varchar(20) |
No |
publish |
comment_status
|
varchar(20) |
No |
open |
ping_status
|
varchar(20) |
No |
open |
post_password
|
varchar(20) |
No |
|
post_name
|
varchar(200) |
No |
|
to_ping
|
text |
No |
|
pinged
|
text |
No |
|
post_modified
|
datetime |
No |
0000-00-00 00:00:00 |
post_modified_gmt
|
datetime |
No |
0000-00-00 00:00:00 |
post_content_filtered
|
text |
No |
|
post_parent
|
bigint(20) |
No |
0 |
guid
|
varchar(255) |
No |
|
menu_order
|
int(11) |
No |
0 |
post_type
|
varchar(20) |
No |
post |
post_mime_type
|
varchar(100) |
No |
|
comment_count
|
bigint(20) |
No |
0 |
wp_9_term_relationships
Field |
Type |
Null |
Default |
object_id
|
bigint(20) |
No |
0 |
term_taxonomy_id
|
bigint(20) |
No |
0 |
term_order
|
int(11) |
No |
0 |
wp_9_term_taxonomy
Field |
Type |
Null |
Default |
term_taxonomy_id
|
bigint(20) |
No |
|
term_id
|
bigint(20) |
No |
0 |
taxonomy
|
varchar(32) |
No |
|
description
|
longtext |
No |
|
parent
|
bigint(20) |
No |
0 |
count
|
bigint(20) |
No |
0 |
wp_9_terms
Field |
Type |
Null |
Default |
term_id
|
bigint(20) |
No |
|
name
|
varchar(55) |
No |
|
slug
|
varchar(200) |
No |
|
term_group
|
bigint(10) |
No |
0 |
wp_blog_versions
Field |
Type |
Null |
Default |
blog_id
|
bigint(20) |
No |
0 |
db_version
|
varchar(20) |
No |
|
last_updated
|
datetime |
No |
0000-00-00 00:00:00 |
wp_blogs
Field |
Type |
Null |
Default |
blog_id
|
bigint(20) |
No |
|
site_id
|
bigint(20) |
No |
0 |
domain
|
varchar(200) |
No |
|
path
|
varchar(100) |
No |
|
registered
|
datetime |
No |
0000-00-00 00:00:00 |
last_updated
|
datetime |
No |
0000-00-00 00:00:00 |
public
|
tinyint(2) |
No |
1 |
archived
|
enum('0', '1') |
No |
0 |
mature
|
tinyint(2) |
No |
0 |
spam
|
tinyint(2) |
No |
0 |
deleted
|
tinyint(2) |
No |
0 |
lang_id
|
int(11) |
No |
0 |
wp_registration_log
Field |
Type |
Null |
Default |
ID
|
bigint(20) |
No |
|
email
|
varchar(255) |
No |
|
IP
|
varchar(30) |
No |
|
blog_id
|
bigint(20) |
No |
0 |
date_registered
|
datetime |
No |
0000-00-00 00:00:00 |
wp_signups
Field |
Type |
Null |
Default |
domain
|
varchar(200) |
No |
|
path
|
varchar(100) |
No |
|
title
|
longtext |
No |
|
user_login
|
varchar(60) |
No |
|
user_email
|
varchar(100) |
No |
|
registered
|
datetime |
No |
0000-00-00 00:00:00 |
activated
|
datetime |
No |
0000-00-00 00:00:00 |
active
|
tinyint(1) |
No |
0 |
activation_key
|
varchar(50) |
No |
|
meta
|
longtext |
Yes |
NULL |
wp_site
Field |
Type |
Null |
Default |
id
|
bigint(20) |
No |
|
domain
|
varchar(200) |
No |
|
path
|
varchar(100) |
No |
|
wp_sitecategories
Field |
Type |
Null |
Default |
cat_ID
|
bigint(20) |
No |
|
cat_name
|
varchar(55) |
No |
|
category_nicename
|
varchar(200) |
No |
|
last_updated
|
timestamp |
Yes |
CURRENT_TIMESTAMP |
wp_sitemeta
Field |
Type |
Null |
Default |
meta_id
|
bigint(20) |
No |
|
site_id
|
bigint(20) |
No |
0 |
meta_key
|
varchar(255) |
Yes |
NULL |
meta_value
|
longtext |
Yes |
NULL |
wp_usermeta
Field |
Type |
Null |
Default |
umeta_id
|
bigint(20) |
No |
|
user_id
|
bigint(20) |
No |
0 |
meta_key
|
varchar(255) |
Yes |
NULL |
meta_value
|
longtext |
Yes |
NULL |
wp_users
Field |
Type |
Null |
Default |
ID
|
bigint(20) |
No |
|
user_login
|
varchar(60) |
No |
|
user_pass
|
varchar(64) |
No |
|
user_nicename
|
varchar(50) |
No |
|
user_email
|
varchar(100) |
No |
|
user_url
|
varchar(100) |
No |
|
user_registered
|
datetime |
No |
0000-00-00 00:00:00 |
user_activation_key
|
varchar(60) |
No |
|
user_status
|
int(11) |
No |
0 |
display_name
|
varchar(250) |
No |
|
spam
|
tinyint(2) |
No |
0 |
deleted
|
tinyint(2) |
No |
0 |