1 Install and upgrade
1.1  System Requirements
1.2  Source Code Installation
1.3  One-Click Installation for Windows
1.4  Zsite, ZenTao and Zdoo
1.5  Install Zsite with online scripts
1.6  Upgrade Zsite
1.7  Upgrade Zsite with online scripts
1.8  Zsite Themes
1.9  Decryption
2 About Zsite
2.1  About Zsite
2.2  Marketing in the era of mobile internet
2.3  Zsite License
2.4  Zsite and ZenTao
3 How to use Zsite
3.1 Content
3.1.1 Article
3.1.1.1  Article Category
3.1.1.2  Publish an Article
3.1.1.3  Edit, Delete and Attach
3.1.2 Page
3.1.2.1  Zsite Page
3.1.3 Blog
3.1.3.1  Zsite blog
3.1.4 Book
3.1.4.1  Add a book
3.1.4.2  Add chapters to a book
3.1.4.3  Write articles for a chapter
3.1.4.4  Book settings
3.1.5 Submission
3.1.5.1  Submit an article
3.2 Mall
3.2.1  Orders and Settings
3.2.2 Product
3.2.2.1  Product category
3.2.2.2  Add a product: basic info
3.2.2.3  Add a product: attributions
3.2.2.4  Add a product: images
3.3 User
3.3.1 User Management
3.3.1.1  User list
3.3.2 Comment
3.3.2.1  Review and reply a comment
3.3.3 Forum
3.3.3.1  Board settings
3.3.3.2  Board moderator and descriptions
3.3.3.3  Edit, delete, reply and stick a thread
3.4 SEO
3.4.1  Traffic Statistics
3.4.2  Keywords
3.4.3  Links
3.5 UI
3.5.1 Interface
3.5.1.1  Theme
3.5.1.2  Layout
3.5.1.3  Appearance
3.5.1.4  Code
3.5.1.5  Source
3.5.1.6  Mobile site
3.5.2 Logo
3.5.2.1  Site logo
3.5.2.2  Site favicon
3.5.3  Slides
3.5.4  Navigation
3.5.5 Widget
3.5.5.1  Manage a widget
3.5.5.2  Example: customized widget
3.5.5.3  Example: use Widget to set the style
3.5.6  Visual Editor
3.5.7  Other Settings
3.5.8  Custom Themes
3.6 Ext
3.6.1  Extensions and Themes
3.6.2  Import JS
3.7 Set
3.7.1 Site
3.7.1.1  Basic settings
3.7.1.2  Language
3.7.1.3  Path
3.7.1.4  Domain settings
3.7.1.5  CND settings
3.7.1.6  Cache settings
3.7.1.7  Homepage menu
3.7.1.8  Full text retrieval
3.7.1.9  Backup/Restore
3.7.1.10  Agreement
3.7.1.11  Static Settings
3.7.2 Company
3.7.2.1  Company Information
3.7.2.2  Contact
3.7.3  Points
3.7.4 API
3.7.4.1  Email Setting
3.7.4.2 OAuth
3.7.4.2.1  GitHub
3.7.4.2.2  Facebook
3.7.5 Security
3.7.5.1  Basic settings
3.7.5.2  Filters and Blacklist/Whitelist
3.7.5.3  Sensitive words and attachment
3.7.5.4  Verification Code
3.7.5.5  Admin and Privileges
4 System Maintenance
4.1  Configure web server for URL
4.2  Backup Zsite
4.3  Install Zend Guard Loader
4.4  Install Ioncube
4.5 Install other PHP extensions
4.5.1  Install PHP-openssl
4.5.2  Install PHP-curl
4.5.3  Install PHP-json
4.5.4  Install PHP-mbstring
4.5.5  Install PHP-gd
4.5.6  Install PDO
5 Customization
5.1  Before you start
5.2  Zsite source code
5.3  Zsite directory structure
5.4  Find the code to modify
5.5  Database structure
6 Zsite Cloud
6.1  Zsite License
6.2  Zsite versions
6.3  Resolve domain name to Zsite server
6.4  Why my site is locked?
6.5  How to backup my Zsite data?

Database structure

2016-08-29 10:12:30
tengfei
17426
Last edited by Zeze on 2016-11-02 08:20:37

eps_address  Address

id id
account account
contact contact
address address
phone phone
zipcode zipcode
lang language

eps_article Article

id id
title title
alias alias
keywords keyword
summary summary
content content
source source
copySite copySite
copyURL copyURL
author author
addedBy addedBy
editor editor
addedDate addedDate
editedDate editedDate
status statu
type type
submittion submission
views viewa
sticky sticky
order order
link link
css CSS
js JS
onlyBody onlyBody
lang language

eps_blacklist  blacklist

type type
identity identity
reason reason
expiredDate expiredDate
times times
lang lang

eps_block  Block layout

id ID
originID originID
template template
type type
title titile
content content
lang language

eps_book  Manual/Book

id ID
title titile
alias alias
keywords keywords
summary summary
content

content


type type
parent parent
path path
grade grade
author author
editor editor
addedDate addedDate
editedDate editedDate
views views
order order
lang language

eps_cart  Shopping cart

id id
account account
product product
count count
lang lang

eps_category  category

id id
name name
abbr abbr
alias alias
desc desc
keywords keywords
parent parent
path path
grade grade
order order
type type
readonly readonly
moderators moderators
threads threads
posts posts
postedBy postedBy
postedDate postedDate
postID postID
replyID replyID
link link
unsaleable unsaleable
lang lang

eps_config  config

id id
owner owner
module module
section section
key key
value value
lang lang

eps_down  down

id id
account account
file file
ip ip
time time
referer referer
lang lang

eps_file attachment

id Id
pathname pathname
title titile
extension extension
size size
width width
height height
objectType objectType
objectID objectID
addedBy addedBy
addedDate addedDate
public public
score score
downloads downloads
extra extra
primary primary
editor editor
lang language

eps_group  Group

id ID
name group nmae
role role
desc group description
lang language

eps_grouppriv  grouppriv

group group
module module
method method
lang language

eps_layout  layout

template template
plan plan
page page
region region
object object
blocks blocks
import import
lang language

eps_log  log

id id
account account
browser browser
ip ip
location location
date date
desc description
ext extension
type type
lang language

eps_message  Message

id ID
type type
objectType objectType
objectID objectID
account account
from from
to to
phone phone
mobile mobile
email email
qq QQ
date date
content content
link link
ip ip
status status
public public
readed read
receiveEmail receiveEmail
lang language

eps_oauth  oauth

account account
provider provider
openID openID
lang language

eps_operationlog  operationlog

id id
type type
identity identity
operation operation
count count
createdTime createdTime
lang language

eps_order_product  Orders

id ID
orderID orderID
productID productID
productName productName
price price
count count
lang language

eps_package Plug-ins

id ID
name name
code code
version version
author author
desc desccription
license license
type type
site site
chanzhiCompatible chanzhiCompatible
templateCompatible templateCompatible
installedTime installedTime
depends depends
dirs dirs
files files
status status
lang language

eps_product_custom  Product

id ID
product product
label label
value value
order order
lang language

eps_relation  relation

type type
id id
category category
lang language

eps_reply  Reply

id Id
thread thread
content content
author author
editor editor
addedDate addedDate
editedDate editedDate
hidden hidden
lang language

eps_score  Score/Reward Point

id ID
account account
method method
type type
count count
before before
after after
objectType objectType
objectID objectID
actor actor
note note
time time
lang language

eps_search_index  Search

id id
objectType objectType
objectID objectID
title title
content content
params params
addedDate addedDate
editedDate editedDate
status status
lang lang

eps_slide  Slide

id id
group slide group
title title
titleColor titile color
mainLink main link
target target
backgroundType backgroundType
backgroundColor backgroundColor
height height
image image
label lable
buttonClass buttonClass
buttonUrl button Url
buttonTarget buttonTarget
summary summary
createdDate createdDate
order order
lang lang

eps_statlog  statlog

id id
referer referer
domain domain
url url
link link
searchEngine searchEngine
keywords keywords
visitor visitor
osName osName
browserName browserName
browserVersion browserVersion
ip ip
country country
province province
city city
account account
year year
month month
day day
hour hour
new new
mobile mobile
lang language

eps_statreferer  statreferer

id id
url url
domain domain
searchEngine searchEngine
keywords keywords
lang lang

eps_statregion  statregion

id id
timeType timeType
timeValue timeValue
country country
province province
city city
pv pv
uv uv
ip ip
lang lang

eps_statreport  statreport

id id
type type
item item
extra extra
timeType timeType
timeValue timeValue
pv pv
uv uv
ip ip
lang lang

eps_statvisitor  statvisitor

id id
osName osName
osVersion osVersion
browserName browserName
browserVersion browserVersion
browserLanguage browserLanguage
device device
resolution resolution
createdTime createdTime
lang lang

eps_tag  Keyword

id id
tag tag
link link
rank rank
lang language

eps_thread  主题

id ID
board board
title tiltile
color color
content content
author author
editor editor
addedDate addedDate
editedDate editedDate
readonly Read only
views views
stick stick
replies replies
repliedBy repliedBy
repliedDate repliedDate
replyID replyID
hidden hidden
link link
lang language
status status
ip ip

eps_user  Member

id ID
account account
password password
realname real name
realnames realnames
nickname nickname
admin admin
avatar avatar
birthday birthday
gender gender
email email
skype skype
qq QQ
yahoo yahoo
gtalk Gtalk
wangwang wangwang
site site
mobile mobile
phone phone
company compnay/organization
address

address

zipcode zip code
visits visits
ip IP
last last login
score reward point/score
rank rank
maxLogin maxLogin
fails fails
referer referer
join date of joining
reset reset
locked once looked,  please try in %s
public public
emailCertified emailCertified
security security
os os
browser browser
lang language

eps_usergroup  usergroup

account account
group group
lang lang

eps_widget  Widget

id id
account account
type type
title widget name
params
order order
grid grid
hidden hidden
lang language

eps_wx_response  wx

id id
public public
key key
group group
type type
source source
content content
lang language