select table_name, column_name from columns where table_schema like '%ecshop' order by table_name, column_name, ordinal_position
ecs_account_log
change_desc
change_time
change_type
frozen_money
log_id
pay_points
rank_points
user_id
user_money
ecs_ad
ad_code
ad_id
ad_link
ad_name
click_count
enabled
end_time
link_email
link_man
link_phone
media_type
position_id
start_time
ecs_admin_action
action_code
action_id
parent_id
relevance
ecs_admin_log
ip_address
log_id
log_info
log_time
user_id
ecs_admin_message
deleted
message
message_id
readed
read_time
receiver_id
sender_id
sent_time
title
ecs_admin_user
action_list
add_time
agency_id
email
lang_type
last_ip
last_login
nav_list
password
role_id
suppliers_id
todolist
user_id
user_name
ecs_adsense
clicks
from_ad
referer
ecs_ad_custom
add_time
ad_id
ad_name
ad_status
ad_type
content
url
ecs_ad_position
ad_height
ad_width
position_desc
position_id
position_name
position_style
ecs_affiliate_log
log_id
money
order_id
point
separate_type
time
user_id
user_name
ecs_agency
agency_desc
agency_id
agency_name
ecs_area_region
region_id
shipping_area_id
ecs_article
add_time
article_id
article_type
author
author_email
cat_id
content
description
file_url
is_open
keywords
link
open_type
title
ecs_article_cat
cat_desc
cat_id
cat_name
cat_type
keywords
parent_id
show_in_nav
sort_order
ecs_attribute
attr_group
attr_id
attr_index
attr_input_type
attr_name
attr_type
attr_values
cat_id
is_linked
sort_order
ecs_auction_log
act_id
bid_price
bid_time
bid_user
log_id
ecs_auto_manage
endtime
item_id
starttime
type
ecs_back_goods
back_id
brand_name
goods_attr
goods_id
goods_name
goods_sn
is_real
product_id
product_sn
rec_id
send_number
ecs_back_order
action_user
address
add_time
agency_id
back_id
best_time
city
consignee
country
delivery_sn
district
email
how_oos
insure_fee
invoice_no
mobile
order_id
order_sn
postscript
province
return_time
shipping_fee
shipping_id
shipping_name
sign_building
status
suppliers_id
tel
update_time
user_id
zipcode
ecs_bonus_type
max_amount
min_amount
min_goods_amount
send_end_date
send_start_date
send_type
type_id
type_money
type_name
use_end_date
use_start_date
ecs_booking_goods
booking_time
dispose_note
dispose_time
dispose_user
email
goods_desc
goods_id
goods_number
is_dispose
link_man
rec_id
tel
user_id
ecs_brand
brand_desc
brand_id
brand_logo
brand_name
is_show
site_url
sort_order
ecs_card
card_desc
card_fee
card_id
card_img
card_name
free_money
ecs_cart
can_handsel
extension_code
goods_attr
goods_attr_id
goods_id
goods_name
goods_number
goods_price
goods_sn
is_gift
is_real
is_shipping
market_price
parent_id
product_id
rec_id
rec_type
session_id
user_id
ecs_category
cat_desc
cat_id
cat_name
filter_attr
grade
is_show
keywords
measure_unit
parent_id
show_in_nav
sort_order
style
template_file
ecs_cat_recommend
cat_id
recommend_type
ecs_collect_goods
add_time
goods_id
is_attention
rec_id
user_id
ecs_comment
add_time
comment_id
comment_rank
comment_type
content
email
id_value
ip_address
parent_id
status
user_id
user_name
ecs_crons
allow_ip
alow_files
cron_code
cron_config
cron_desc
cron_id
cron_name
cron_order
day
enable
hour
minute
nextime
run_once
thistime
week
ecs_delivery_goods
brand_name
delivery_id
extension_code
goods_attr
goods_id
goods_name
goods_sn
is_real
parent_id
product_id
product_sn
rec_id
send_number
ecs_delivery_order
action_user
address
add_time
agency_id
best_time
city
consignee
country
delivery_id
delivery_sn
district
email
how_oos
insure_fee
invoice_no
mobile
order_id
order_sn
postscript
province
shipping_fee
shipping_id
shipping_name
sign_building
status
suppliers_id
tel
update_time
user_id
zipcode
ecs_email_list
email
hash
id
stat
ecs_email_sendlist
email
email_content
error
id
last_send
pri
template_id
ecs_error_log
file
id
info
time
ecs_exchange_goods
exchange_integral
goods_id
is_exchange
is_hot
ecs_favourable_activity
act_id
act_name
act_range
act_range_ext
act_type
act_type_ext
end_time
gift
max_amount
min_amount
sort_order
start_time
user_rank
ecs_feedback
message_img
msg_area
msg_content
msg_id
msg_status
msg_time
msg_title
msg_type
order_id
parent_id
user_email
user_id
user_name
ecs_friend_link
link_id
link_logo
link_name
link_url
show_order
ecs_goods
add_time
bonus_type_id
brand_id
cat_id
click_count
extension_code
give_integral
goods_brief
goods_desc
goods_id
goods_img
goods_name
goods_name_style
goods_number
goods_sn
goods_thumb
goods_type
goods_weight
integral
is_alone_sale
is_best
is_check
is_delete
is_hot
is_new
is_on_sale
is_promote
is_real
is_shipping
keywords
last_update
market_price
original_img
promote_end_date
promote_price
promote_start_date
provider_name
rank_integral
seller_note
shop_price
sort_order
suppliers_id
warn_number
ecs_goods_activity
act_desc
act_id
act_name
act_type
end_time
ext_info
goods_id
goods_name
is_finished
product_id
start_time
ecs_goods_article
admin_id
article_id
goods_id
ecs_goods_attr
attr_id
attr_price
attr_value
goods_attr_id
goods_id
ecs_goods_cat
cat_id
goods_id
ecs_goods_gallery
goods_id
img_desc
img_id
img_original
img_url
thumb_url
ecs_goods_type
attr_group
cat_id
cat_name
enabled
ecs_group_goods
admin_id
goods_id
goods_price
parent_id
ecs_keywords
count
date
keyword
searchengine
ecs_link_goods
admin_id
goods_id
is_double
link_goods_id
ecs_mail_templates
is_html
last_modify
last_send
template_code
template_content
template_id
template_subject
type
ecs_member_price
goods_id
price_id
user_price
user_rank
ecs_nav
cid
ctype
id
ifshow
name
opennew
type
url
vieworder
ecs_order_action
action_id
action_note
action_place
action_user
log_time
order_id
order_status
pay_status
shipping_status
ecs_order_goods
extension_code
goods_attr
goods_attr_id
goods_id
goods_name
goods_number
goods_price
goods_sn
is_gift
is_real
market_price
order_id
parent_id
product_id
rec_id
send_number
ecs_order_info
address
add_time
agency_id
best_time
bonus
bonus_id
card_fee
card_id
card_message
card_name
city
confirm_time
consignee
country
discount
district
email
extension_code
extension_id
from_ad
goods_amount
how_oos
how_surplus
insure_fee
integral
integral_money
invoice_no
inv_content
inv_payee
inv_type
is_separate
mobile
money_paid
order_amount
order_id
order_sn
order_status
pack_fee
pack_id
pack_name
parent_id
pay_fee
pay_id
pay_name
pay_note
pay_status
pay_time
postscript
province
referer
shipping_fee
shipping_id
shipping_name
shipping_status
shipping_time
sign_building
surplus
tax
tel
to_buyer
user_id
zipcode
ecs_pack
free_money
pack_desc
pack_fee
pack_id
pack_img
pack_name
ecs_package_goods
admin_id
goods_id
goods_number
package_id
product_id
ecs_payment
enabled
is_cod
is_online
pay_code
pay_config
pay_desc
pay_fee
pay_id
pay_name
pay_order
ecs_pay_log
is_paid
log_id
order_amount
order_id
order_type
ecs_plugins
assign
code
install_date
library
version
ecs_products
goods_attr
goods_id
product_id
product_number
product_sn
ecs_region
agency_id
parent_id
region_id
region_name
region_type
ecs_reg_extend_info
content
Id
reg_field_id
user_id
ecs_reg_fields
display
dis_order
id
is_need
reg_field_name
type
ecs_role
action_list
role_describe
role_id
role_name
ecs_searchengine
count
date
searchengine
ecs_sessions
adminid
data
discount
email
expiry
ip
sesskey
userid
user_name
user_rank
ecs_sessions_data
data
expiry
sesskey
ecs_shipping
config_lable
enabled
insure
print_bg
print_model
shipping_code
shipping_desc
shipping_id
shipping_name
shipping_print
support_cod
ecs_shipping_area
configure
shipping_area_id
shipping_area_name
shipping_id
ecs_shop_config
code
id
parent_id
sort_order
store_dir
store_range
type
value
ecs_snatch_log
bid_price
bid_time
log_id
snatch_id
user_id
ecs_stats
access_time
access_url
area
browser
ip_address
language
referer_domain
referer_path
system
visit_times
ecs_suppliers
is_check
suppliers_desc
suppliers_id
suppliers_name
ecs_tag
goods_id
tag_id
tag_words
user_id
ecs_template
filename
id
library
number
region
remarks
sort_order
theme
type
ecs_topic
base_style
css
data
description
end_time
htmls
intro
keywords
start_time
template
title
title_pic
topic_id
topic_img
ecs_users
address_id
alias
answer
birthday
credit_line
email
flag
frozen_money
home_phone
is_special
is_validated
last_ip
last_login
last_time
mobile_phone
msn
office_phone
parent_id
passwd_answer
passwd_question
password
pay_points
qq
question
rank_points
reg_time
salt
sex
user_id
user_money
user_name
user_rank
visit_count
ecs_user_account
add_time
admin_note
admin_user
amount
id
is_paid
paid_time
payment
process_type
user_id
user_note
ecs_user_address
address
address_id
address_name
best_time
city
consignee
country
district
email
mobile
province
sign_building
tel
user_id
zipcode
ecs_user_bonus
bonus_id
bonus_sn
bonus_type_id
emailed
order_id
used_time
user_id
ecs_user_feed
feed_id
feed_type
goods_id
is_feed
user_id
value_id
ecs_user_rank
discount
max_points
min_points
rank_id
rank_name
show_price
special_rank
ecs_virtual_card
add_date
card_id
card_password
card_sn
crc32
end_date
goods_id
is_saled
order_sn
ecs_volume_price
goods_id
price_type
volume_number
volume_price
ecs_vote
can_multi
end_time
start_time
vote_count
vote_id
vote_name
ecs_vote_log
ip_address
log_id
vote_id
vote_time
ecs_vote_option
option_count
option_id
option_name
option_order
vote_id
ecs_wholesale
act_id
enabled
goods_id
goods_name
prices
rank_ids