phpcms v9 数据表结构 - 数据结构 - V9帮助中心:
|
PHPCMS V9 数据结构 （2013-7-5 舒克整理） |
表 1 : v9_admin 管理员表
|
字段 |
类型 |
Null |
默认 |
额外 |
注释 |
|
userid |
mediumint(6) unsigned |
PK |
|
auto_increment |
用户id |
|
username |
varchar(20) |
YES |
|
|
用户名 |
|
password |
varchar(32) |
YES |
|
|
密码 |
|
roleid |
smallint(5) |
YES |
0 |
|
角色 |
|
encrypt |
varchar(6) |
YES |
|
|
加密因子 |
|
lastloginip |
varchar(15) |
YES |
|
|
最后登录ip |
|
lastlogintime |
int(10) unsigned |
YES |
0 |
|
最后登录时间 |
|
email |
varchar(40) |
YES |
|
|
Email |
|
realname |
varchar(50) |
NO |
|
|
真是姓名 |
|
card |
varchar(255) |
NO |
|
|
密保卡 |
|
|
键名 |
类型 |
字段 |
|
PRIMARY |
PRIMARY |
userid |
|
username |
INDEX |
username |
表 2 : v9_admin_panel 快捷面板
|
字段 |
类型 |
Null |
默认 |
额外 |
注释 |
|
menuid |
mediumint(8) unsigned |
PK |
|
|
菜单id |
|
userid |
mediumint(8) unsigned |
NO |
0 |
|
管理员id |
|
name |
char(32) |
YES |
|
|
菜单名称 |
|
url |
char(255) |
YES |
|
|
菜单url |
|
datetime |
int(10) unsigned |
YES |
0 |
|
添加时间 |
|
|
键名 |
类型 |
字段 |
|
userid |
INDEX |
menuid |
|
userid |
INDEX |
userid |
表 3 : v9_admin_role 角色表
|
字段 |
类型 |
Null |
默认 |
额外 |
注释 |
|
roleid |
tinyint(3) unsigned |
PK |
|
auto_increment |
角色id |
|
rolename |
varchar(50) |
NO |
|
|
角色名称 |
|
description |
text |
NO |
|
|
描述 |
|
listorder |
smallint(5) unsigned |
NO |
0 |
|
排序 |
|
disabled |
tinyint(1) unsigned |
NO |
0 |
|
状态：1，禁用 |
|
|
键名 |
类型 |
字段 |
|
PRIMARY |
PRIMARY |
roleid |
|
listorder |
INDEX |
listorder |
|
disabled |
INDEX |
disabled |
表 4 : v9_admin_role_priv 管理员权限表
|
字段 |
类型 |
Null |
默认 |
额外 |
注释 |
|
roleid |
tinyint(3) unsigned |
PK |
0 |
|
角色id |
|
m |
char(20) |
NO |
|
|
m |
|
c |
char(20) |
NO |
|
|
c |
|
a |
char(20) |
NO |
|
|
a |
|
data |
char(30) |
NO |
|
|
附件属性 |
|
siteid |
smallint(5) unsigned |
NO |
0 |
|
所属站点 |
|
|
键名 |
类型 |
字段 |
|
roleid |
INDEX |
roleid |
|
roleid |
INDEX |
m |
|
roleid |
INDEX |
c |
|
roleid |
INDEX |
a |
|
roleid |
INDEX |
siteid |
表 5 : v9_announce 公告表
|
字段 |
类型 |
Null |
默认 |
额外 |
注释 |
|
aid |
smallint(4) unsigned |
PK |
|
auto_increment |
公告ID |
|
siteid |
smallint(5) unsigned |
NO |
0 |
|
站点ID |
|
title |
char(80) |
NO |
|
|
公告标题 |
|
content |
text |
NO |
|
|
公告内容 |
|
starttime |
date |
NO |
0000-00-00 |
|
有效起始时间 |
|
endtime |
date |
NO |
0000-00-00 |
|
有效结束时间 |
|
username |
varchar(40) |
NO |
|
|
添加者 |
|
addtime |
int(10) unsigned |
NO |
0 |
|
添加时间 |
|
hits |
smallint(5) unsigned |
NO |
0 |
|
浏览次数 |
|
passed |
tinyint(1) unsigned |
NO |
0 |
|
是否通过1：通过；0：为通过 |
|
style |
char(15) |
NO |
|
|
样式 |
|
show_template |
char(30) |
NO |
|
|
模板 |
|
|
键名 |
类型 |
字段 |
|
PRIMARY |
PRIMARY |
aid |
|
siteid |
INDEX |
siteid |
|
siteid |
INDEX |
passed |
|
siteid |
INDEX |
endtime |
表 6 : v9_attachment 附件表
|
字段 |
类型 |
Null |
默认 |
额外 |
注释 |
|
aid |
int(10) unsigned |
PK |
|
auto_increment |
附件ID |
|
module |
char(15) |
NO |
|
|
模块名称 |
|
catid |
smallint(5) unsigned |
NO |
0 |
|
栏目ID |
|
filename |
char(50) |
NO |
|
|
附件名称 |
|
filepath |
char(200) |
NO |
|
|
附件路径 |
|
filesize |
int(10) unsigned |
NO |
0 |
|
附件大小 |
|
fileext |
char(10) |
NO |
|
|
附件扩展名 |
|
isimage |
tinyint(1) unsigned |
NO |
0 |
|
是否为图片 1为图片 |
|
isthumb |
tinyint(1) unsigned |
NO |
0 |
|
是否为缩略图 1为缩略图 |
|
downloads |
mediumint(8) unsigned |
NO |
0 |
|
|
|
userid |
mediumint(8) unsigned |
NO |
0 |
|
userid |
|
uploadtime |
int(10) unsigned |
NO |
0 |
|
上传时间 |
|
uploadip |
char(15) |
NO |
|
|
上传ip |
|
status |
tinyint(1) |
NO |
0 |
|
附件使用状态 |
|
authcode |
char(32) |
NO |
|
|
附件路径MD5值 |
|
siteid |
smallint(5) unsigned |
NO |
0 |
|
站点id |
|
|
键名 |
类型 |
字段 |
|
PRIMARY |
PRIMARY |
aid |
|
authcode |
INDEX |
authcode |
表 7 : v9_attachment_index 附件关系表
|
字段 |
类型 |
Null |
默认 |
额外 |
注释 |
|
keyid |
char(30) |
PK |
|
|
关联id |
|
aid |
char(10) |
NO |
|
|
附件ID |
|
|
键名 |
类型 |
字段 |
|
keyid |
INDEX |
keyid |
|
aid |
INDEX |
aid |
表 8 : v9_badword 敏感词
|
字段 |
类型 |
Null |
默认 |
额外 |
注释 |
|
badid |
smallint(5) unsigned |
PK |
|
auto_increment |
感敏词ID |
|
badword |
char(20) |
NO |
|
|
感敏词 |
|
level |
tinyint(5) |
NO |
1 |
|
感敏级别 |
|
replaceword |
char(20) |
NO |
0 |
|
换替文字 |
|
lastusetime |
int(10) unsigned |
NO |
0 |
|
添加时间 |
|
listorder |
tinyint(3) unsigned |
NO |
0 |
|
排序 |
|
|
键名 |
类型 |
字段 |
|
PRIMARY |
PRIMARY |
badid |
|
badword |
INDEX |
badword |
|
usetimes |
INDEX |
replaceword |
|
usetimes |
INDEX |
listorder |
|
hits |
INDEX |
listorder |
表 9 : v9_block 碎片表
|
字段 |
类型 |
Null |
默认 |
额外 |
注释 |
|
id |
int(10) |
PK |
|
auto_increment |
碎片ID |
|
siteid |
smallint(5) unsigned |
YES |
0 |
|
站点ID |
|
name |
char(50) |
YES |
|
|
碎片名 |
|
pos |
char(30) |
YES |
|
|
位置 |
|
type |
tinyint(1) |
YES |
0 |
|
型类{1:代码型,2:格式化数据型} |
|
data |
text |
YES |
|
|
数据内容 |
|
template |
text |
YES |
|
|
模板 |
|
|
键名 |
类型 |
字段 |
|
PRIMARY |
PRIMARY |
id |
|
pos |
INDEX |
pos |
|
type |
INDEX |
type |
|
siteid |
INDEX |
siteid |
表 10 : v9_block_history 碎片历史记录表
|
字段 |
类型 |
Null |
默认 |
额外 |
注释 |
|
id |
int(10) |
PK |
|
auto_increment |
|
|
blockid |
int(10) unsigned |
YES |
0 |
|
碎片ID |
|
data |
text |
YES |
|
|
碎片内容 |
|
creat_at |
int(10) unsigned |
YES |
0 |
|
时间 |
|
userid |
mediumint(8) unsigned |
YES |
0 |
|
用户ID |
|
username |
char(20) |
YES |
|
|
用户名 |
|
|
键名 |
类型 |
字段 |
|
PRIMARY |
PRIMARY |
id |
表 11 : v9_block_priv 碎片权限表
|
字段 |
类型 |
Null |
默认 |
额外 |
注释 |
|
id |
int(10) unsigned |
PK |
|
auto_increment |
|
|
roleid |
tinyint(3) unsigned |
YES |
0 |
|
角色ID |
|
siteid |
smallint(5) unsigned |
YES |
0 |
|
站点ID |
|
blockid |
int(10) unsigned |
YES |
0 |
|
碎片ID |
|
|
键名 |
类型 |
字段 |
|
PRIMARY |
PRIMARY |
id |
|
blockid |
INDEX |
blockid |
|
roleid |
INDEX |
roleid |
|
roleid |
INDEX |
siteid |
表 12 : v9_cache 缓存表
|
字段 |
类型 |
Null |
默认 |
额外 |
注释 |
|
filename |
char(50) |
PK |
|
|
|
|
path |
char(50) |
NO |
|
|
|
|
data |
mediumtext |
NO |
|
|
|
|
|
键名 |
类型 |
字段 |
|
PRIMARY |
PRIMARY |
filename |
|
PRIMARY |
PRIMARY |
path |
表 13 : v9_category 栏目表
|
字段 |
类型 |
Null |
默认 |
额外 |
注释 |
|
catid |
smallint(5) unsigned |
PK |
|
auto_increment |
栏目id |
|
siteid |
smallint(5) unsigned |
NO |
0 |
|
站点id |
|
module |
varchar(15) |
NO |
|
|
所属模块 |
|
type |
tinyint(1) unsigned |
NO |
0 |
|
类别 |
|
modelid |
tinyint(5) unsigned |
NO |
0 |
|
模型id |
|
parentid |
smallint(5) unsigned |
NO |
0 |
|
父id |
|
arrparentid |
varchar(255) |
NO |
|
|
所有父id |
|
child |
tinyint(1) unsigned |
NO |
0 |
|
是否存在子栏目，1，存在 |
|
arrchildid |
mediumtext |
NO |
|
|
所有子栏目id |
|
catname |
varchar(30) |
NO |
|
|
栏目名称 |
|
style |
varchar(5) |
NO |
|
|
风格 |
|
image |
varchar(100) |
NO |
|
|
图片 |
|
description |
mediumtext |
NO |
|
|
描述 |
|
parentdir |
varchar(100) |
NO |
|
|
父目录 |
|
catdir |
varchar(30) |
NO |
|
|
目录 |
|
url |
varchar(100) |
NO |
|
|
链接地址 |
|
items |
mediumint(8) unsigned |
NO |
0 |
|
栏目数量 |
|
hits |
int(10) unsigned |
NO |
0 |
|
点击数量 |
|
setting |
mediumtext |
NO |
|
|
相关配置信息 |
|
listorder |
smallint(5) unsigned |
NO |
0 |
|
排序 |
|
ismenu |
tinyint(1) unsigned |
NO |
1 |
|
是否显示，1 显示 |
|
sethtml |
tinyint(1) unsigned |
NO |
0 |
|
生成静态，1 静态 |
|
letter |
varchar(30) |
NO |
|
|
拼音 |
|
usable_type |
varchar(255) |
NO |
|
|
当前可用类别，多id用逗号隔开 |
|
|
键名 |
类型 |
字段 |
|
PRIMARY |
PRIMARY |
catid |
|
module |
INDEX |
module |
|
module |
INDEX |
parentid |
|
module |
INDEX |
listorder |
|
module |
INDEX |
catid |
|
siteid |
INDEX |
siteid |
|
siteid |
INDEX |
type |
表 14 : v9_category_priv 栏目权限表
|
字段 |
类型 |
Null |
默认 |
额外 |
注释 |
|
catid |
smallint(5) unsigned |
PK |
0 |
|
栏目id |
|
siteid |
smallint(5) unsigned |
NO |
0 |
|
站点id |
|
roleid |
smallint(5) unsigned |
NO |
0 |
|
角色或者组id |
|
is_admin |
tinyint(1) unsigned |
NO |
0 |
|
是否为管理员 1、管理员 |
|
action |
char(30) |
NO |
|
|
动作 |
|
|
键名 |
类型 |
字段 |
|
catid |
INDEX |
catid |
|
catid |
INDEX |
roleid |
|
catid |
INDEX |
is_admin |
|
catid |
INDEX |
action |
|
siteid |
INDEX |
siteid |
表 15 : v9_collection_content 采集内容表
|
字段 |
类型 |
Null |
默认 |
额外 |
注释 |
|
id |
int(10) unsigned |
PK |
|
auto_increment |
|
|
nodeid |
int(10) unsigned |
NO |
0 |
|
节点ID |
|
siteid |
mediumint(5) unsigned |
NO |
0 |
|
站点ID |
|
status |
tinyint(1) unsigned |
NO |
0 |
|
采集状态{0:未采集,1:已采集,2:已导入} |
|
url |
char(255) |
NO |
|
|
文章URL |
|
title |
char(100) |
NO |
|
|
文章标题 |
|
data |
text |
NO |
|
|
文章数据 |
|
|
键名 |
类型 |
字段 |
|
PRIMARY |
PRIMARY |
id |
|
nodeid |
INDEX |
nodeid |
|
nodeid |
INDEX |
siteid |
|
status |
INDEX |
status |
表 16 : v9_collection_history 采集历史
|
字段 |
类型 |
Null |
默认 |
额外 |
注释 |
|
md5 |
char(32) |
PK |
|
|
URL地址MD5值 |
|
siteid |
smallint(5) unsigned |
NO |
0 |
|
站点ID |
|
|
键名 |
类型 |
字段 |
|
PRIMARY |
PRIMARY |
md5 |
|
PRIMARY |
PRIMARY |
siteid |
表 17 : v9_collection_node 采集节点配置
|
字段 |
类型 |
Null |
默认 |
额外 |
注释 |
|
nodeid |
smallint(6) unsigned |
PK |
|
auto_increment |
采集节点ID |
|
name |
varchar(20) |
NO |
|
|
名称 |
|
lastdate |
int(10) unsigned |
NO |
0 |
|
最后采集时间 |
|
siteid |
smallint(5) unsigned |
NO |
0 |
|
站点ID |
|
sourcecharset |
varchar(8) |
NO |
|
|
采集点字符集 |
|
sourcetype |
tinyint(1) unsigned |
NO |
0 |
|
网址类型 |
|
urlpage |
text |
NO |
|
|
采集地址 |
|
pagesize_start |
tinyint(3) unsigned |
NO |
0 |
|
页码开始 |
|
pagesize_end |
mediumint(8) unsigned |
NO |
0 |
|
页码结束 |
|
page_base |
char(255) |
NO |
|
|
网址base |
|
par_num |
tinyint(3) unsigned |
NO |
1 |
|
每次增加数 |
|
url_contain |
char(100) |
NO |
|
|
网址中必须包含 |
|
url_except |
char(100) |
NO |
|
|
网址中不能包含 |
|
url_start |
char(100) |
NO |
|
|
网址开始 |
|
url_end |
char(100) |
NO |
|
|
网址结束 |
|
title_rule |
char(100) |
NO |
|
|
标题采集规则 |
|
title_html_rule |
text |
NO |
|
|
标题过滤规则 |
|
author_rule |
char(100) |
NO |
|
|
作者采集规则 |
|
author_html_rule |
text |
NO |
|
|
作者过滤规则 |
|
comeform_rule |
char(100) |
NO |
|
|
来源采集规则 |
|
comeform_html_rule |
text |
NO |
|
|
来源过滤规则 |
|
time_rule |
char(100) |
NO |
|
|
时间采集规则 |
|
time_html_rule |
text |
NO |
|
|
时间过滤规则 |
|
content_rule |
char(100) |
NO |
|
|
内容采集规则 |
|
content_html_rule |
text |
NO |
|
|
内容过滤规则 |
|
content_page_start |
char(100) |
NO |
|
|
内容分页开始 |
|
content_page_end |
char(100) |
NO |
|
|
内容分页结束 |
|
content_page_rule |
tinyint(1) unsigned |
NO |
0 |
|
分页模式 |
|
content_page |
tinyint(1) unsigned |
NO |
0 |
|
内容采集是否分页 |
|
content_nextpage |
char(100) |
NO |
|
|
下一页标识符 |
|
down_attachment |
tinyint(1) unsigned |
NO |
0 |
|
是否下载图片 |
|
watermark |
tinyint(1) unsigned |
NO |
0 |
|
图片加水印 |
|
coll_order |
tinyint(3) unsigned |
NO |
0 |
|
导入顺序 |
|
customize_config |
text |
NO |
|
|
自定义采集规则 |
|
|
键名 |
类型 |
字段 |
|
PRIMARY |
PRIMARY |
nodeid |
|
siteid |
INDEX |
siteid |
表 18 : v9_collection_program 采集导入规则表
|
字段 |
类型 |
Null |
默认 |
额外 |
注释 |
|
id |
int(10) unsigned |
PK |
|
auto_increment |
|
|
siteid |
smallint(5) unsigned |
NO |
0 |
|
站点ID |
|
nodeid |
int(10) unsigned |
NO |
0 |
|
采集点 |
|
modelid |
mediumint(6) unsigned |
NO |
0 |
|
模型ID |
|
catid |
int(10) unsigned |
NO |
0 |
|
栏目ID |
|
config |
text |
NO |
|
|
配置信息 |
|
|
键名 |
类型 |
字段 |
|
PRIMARY |
PRIMARY |
id |
|
siteid |
INDEX |
siteid |
|
nodeid |
INDEX |
nodeid |
表 19 : v9_comment
|
字段 |
类型 |
Null |
默认 |
额外 |
注释 |
|
commentid |
char(30) |
PK |
|
|
|
|
siteid |
smallint(5) |
NO |
0 |
|
|
|
title |
char(255) |
NO |
|
|
|
|
url |
char(255) |
NO |
|
|
|
|
total |
int(8) unsigned |
YES |
0 |
|
|
|
square |
mediumint(8) unsigned |
YES |
0 |
|
|
|
anti |
mediumint(8) unsigned |
YES |
0 |
|
|
|
neutral |
mediumint(8) unsigned |
YES |
0 |
|
|
|
display_type |
tinyint(1) |
YES |
0 |
|
|
|
tableid |
mediumint(8) unsigned |
YES |
0 |
|
|
|
lastupdate |
int(10) unsigned |
YES |
0 |
|
|
|
|
键名 |
类型 |
字段 |
|
PRIMARY |
PRIMARY |
commentid |
|
lastupdate |
INDEX |
lastupdate |
|
siteid |
INDEX |
siteid |
表 20 : v9_comment_check
|
字段 |
类型 |
Null |
默认 |
额外 |
注释 |
|
id |
int(10) |
PK |
|
auto_increment |
|
|
comment_data_id |
int(10) |
YES |
0 |
|
|
|
siteid |
smallint(5) |
NO |
0 |
|
վ |
|
tableid |
mediumint(8) |
YES |
0 |
|
|
|
|
键名 |
类型 |
字段 |
|
PRIMARY |
PRIMARY |
id |
|
siteid |
INDEX |
siteid |
|
comment_data_id |
INDEX |
comment_data_id |
表 21 : v9_comment_data_1
|
字段 |
类型 |
Null |
默认 |
额外 |
注释 |
|
id |
int(10) unsigned |
PK |
|
auto_increment |
|
|
commentid |
char(30) |
NO |
|
|
|
|
siteid |
smallint(5) |
NO |
0 |
|
վ |
|
userid |
int(10) unsigned |
YES |
0 |
|
|
|
username |
varchar(20) |
YES |
|
|
|
|
creat_at |
int(10) |
YES |
|
|
|
|
ip |
varchar(15) |
YES |
|
|
|
|
status |
tinyint(1) |
YES |
0 |
|
|
|
content |
text |
YES |
|
|
|
|
direction |
tinyint(1) |
YES |
0 |
|
|
|
support |
mediumint(8) unsigned |
YES |
0 |
|
֧ |
|
reply |
tinyint(1) |
NO |
0 |
|
|
|
|
键名 |
类型 |
字段 |
|
PRIMARY |
PRIMARY |
id |
|
commentid |
INDEX |
commentid |
|
direction |
INDEX |
direction |
|
siteid |
INDEX |
siteid |
|
support |
INDEX |
support |
表 22 : v9_comment_setting
|
字段 |
类型 |
Null |
默认 |
额外 |
注释 |
|
siteid |
smallint(5) |
PK |
0 |
|
վ |
|
guest |
tinyint(1) |
YES |
0 |
|
|
|
check |
tinyint(1) |
YES |
0 |
|
|
|
code |
tinyint(1) |
YES |
0 |
|
|
|
add_point |
tinyint(3) unsigned |
YES |
0 |
|
|
|
del_point |
tinyint(3) unsigned |
YES |
0 |
|
|
|
|
键名 |
类型 |
字段 |
|
PRIMARY |
PRIMARY |
siteid |
表 23 : v9_comment_table
|
字段 |
类型 |
Null |
默认 |
额外 |
注释 |
|
tableid |
mediumint(8) |
PK |
|
auto_increment |
|
|
total |
int(10) unsigned |
YES |
0 |
|
|
|
creat_at |
int(10) |
YES |
0 |
|
|
|
|
键名 |
类型 |
字段 |
|
PRIMARY |
PRIMARY |
tableid |
表 24 : v9_content_check 内容审核表
|
字段 |
类型 |
Null |
默认 |
额外 |
注释 |
|
checkid |
char(15) |
NO |
|
|
|
|
catid |
smallint(5) unsigned |
NO |
0 |
|
栏目ID |
|
siteid |
smallint(5) unsigned |
NO |
0 |
|
站点ID |
|
title |
char(80) |
NO |
|
|
标题 |
|
username |
char(20) |
PK |
|
|
用户名 |
|
inputtime |
int(10) unsigned |
NO |
0 |
|
录入时间 |
|
status |
tinyint(1) unsigned |
NO |
0 |
|
0、退稿 1~4审核阶段 99通过 |
|
|
键名 |
类型 |
字段 |
|
username |
INDEX |
username |
|
checkid |
INDEX |
checkid |
|
status |
INDEX |
status |
|
status |
INDEX |
inputtime |
表 25 : v9_copyfrom 来源表
|
字段 |
类型 |
Null |
默认 |
额外 |
注释 |
|
id |
smallint(5) unsigned |
PK |
|
auto_increment |
|
|
siteid |
smallint(5) unsigned |
NO |
0 |
|
所属站点 |
|
sitename |
varchar(30) |
NO |
|
|
网站名称 |
|
siteurl |
varchar(100) |
NO |
|
|
网站url |
|
thumb |
varchar(100) |
NO |
|
|
缩略图 |
|
listorder |
smallint(5) unsigned |
NO |
0 |
|
排序 |
|
|
键名 |
类型 |
字段 |
|
PRIMARY |
PRIMARY |
id |
表 26 : v9_datacall 数据调用
|
字段 |
类型 |
Null |
默认 |
额外 |
注释 |
|
id |
int(10) |
PK |
|
auto_increment |
|
|
name |
char(40) |
YES |
|
|
数据源名 |
|
dis_type |
tinyint(1) unsigned |
YES |
0 |
|
显示格式{1:json,2:xml,3:js} |
|
type |
tinyint(1) |
YES |
0 |
|
查询方式{0:模型配置,1:自定义SQL} |
|
module |
char(20) |
YES |
|
|
模块名 |
|
action |
char(20) |
YES |
|
|
操作事件 |
|
data |
text |
YES |
|
|
配置参数 |
|
template |
text |
YES |
|
|
模板 |
|
cache |
mediumint(8) |
YES |
|
|
缓存时间 |
|
num |
smallint(6) unsigned |
YES |
|
|
调用条数 |
|
|
键名 |
类型 |
字段 |
|
PRIMARY |
PRIMARY |
id |
|
type |
INDEX |
type |
表 27 : v9_dbsource 数据源
|
字段 |
类型 |
Null |
默认 |
额外 |
注释 |
|
id |
int(10) |
PK |
|
auto_increment |
|
|
siteid |
smallint(5) unsigned |
NO |
0 |
|
站点ID |
|
name |
varchar(50) |
NO |
|
|
名称 |
|
host |
varchar(20) |
NO |
|
|
数据库服务器 |
|
port |
int(5) |
NO |
3306 |
|
端口 |
|
username |
varchar(50) |
NO |
|
|
用户名 |
|
password |
varchar(50) |
NO |
|
|
密码 |
|
dbname |
varchar(50) |
NO |
|
|
数据库名 |
|
charset |
varchar(10) |
NO |
|
|
字符集 |
|
|
键名 |
类型 |
字段 |
|
PRIMARY |
PRIMARY |
id |
|
siteid |
INDEX |
siteid |
表 28 : v9_download
|
字段 |
类型 |
Null |
默认 |
额外 |
注释 |
|
id |
mediumint(8) unsigned |
PK |
|
auto_increment |
id |
|
catid |
smallint(5) unsigned |
NO |
0 |
|
栏目id |
|
typeid |
smallint(5) unsigned |
NO |
|
|
类别id |
|
title |
varchar(80) |
NO |
|
|
标题 |
|
style |
varchar(24) |
NO |
|
|
样式 |
|
thumb |
varchar(100) |
NO |
|
|
缩略图 |
|
keywords |
varchar(40) |
NO |
|
|
关键词 |
|
description |
varchar(255) |
NO |
|
|
摘要 |
|
posids |
tinyint(1) unsigned |
NO |
0 |
|
推荐位 |
|
url |
varchar(100) |
NO |
|
|
链接地址 |
|
listorder |
tinyint(3) unsigned |
NO |
0 |
|
排序 |
|
status |
tinyint(2) unsigned |
NO |
1 |
|
状态：0退稿，1~4审核状态 99通过 |
|
sysadd |
tinyint(1) unsigned |
NO |
0 |
|
管理员添加：1后台管理员添加 |
|
islink |
tinyint(1) unsigned |
NO |
0 |
|
外部链接 |
|
username |
varchar(20) |
NO |
|
|
用户名 |
|
inputtime |
int(10) unsigned |
NO |
0 |
|
添加时间 |
|
updatetime |
int(10) unsigned |
NO |
0 |
|
更新时间 |
|
systems |
varchar(100) |
NO |
Win2000/WinXP/Win2003 |
|
软件平台 |
|
copytype |
varchar(15) |
NO |
|
|
软件授权形式 |
|
language |
varchar(10) |
NO |
|
|
软件语言 |
|
classtype |
varchar(20) |
NO |
|
|
软件类型 |
|
version |
varchar(20) |
NO |
|
|
版本号 |
|
filesize |
varchar(10) |
NO |
未知 |
|
文件大小 |
|
stars |
varchar(20) |
NO |
|
|
评分等级 |
|
|
键名 |
类型 |
字段 |
|
PRIMARY |
PRIMARY |
id |
|
status |
INDEX |
status |
|
status |
INDEX |
listorder |
|
status |
INDEX |
id |
|
listorder |
INDEX |
catid |
|
listorder |
INDEX |
status |
|
listorder |
INDEX |
listorder |
|
listorder |
INDEX |
id |
|
catid |
INDEX |
catid |
|
catid |
INDEX |
status |
|
catid |
INDEX |
id |
表 29 : v9_download_data
|
字段 |
类型 |
Null |
默认 |
额外 |
注释 |
|
id |
mediumint(8) unsigned |
PK |
0 |
|
|
|
content |
text |
NO |
|
|
内容 |
|
readpoint |
smallint(5) unsigned |
NO |
0 |
|
阅读点数 |
|
groupids_view |
varchar(100) |
NO |
|
|
阅读权限 |
|
paginationtype |
tinyint(1) |
NO |
|
|
分页方式 |
|
maxcharperpage |
mediumint(6) |
NO |
|
|
分页字符数 |
|
template |
varchar(30) |
NO |
|
|
模板 |
|
paytype |
tinyint(1) unsigned |
NO |
0 |
|
支付类别 |
|
relation |
varchar(255) |
NO |
|
|
相关文章 |
|
allow_comment |
tinyint(3) unsigned |
NO |
0 |
|
是否允许评论 |
|
downfiles |
mediumtext |
NO |
|
|
文件下载 |
|
downfile |
varchar(255) |
NO |
|
|
镜像下载 |
|
表 30 : v9_downservers 镜像服务器表
|
字段 |
类型 |
Null |
默认 |
额外 |
注释 |
|
id |
mediumint(8) |
PK |
|
auto_increment |
ID |
|
sitename |
varchar(100) |
YES |
|
|
站点名称 |
|
siteurl |
varchar(255) |
YES |
|
|
下载服务器地址 |
|
listorder |
smallint(5) unsigned |
NO |
0 |
|
排序 |
|
siteid |
smallint(5) unsigned |
NO |
0 |
|
站点id |
|
|
键名 |
类型 |
字段 |
|
PRIMARY |
PRIMARY |
id |
表 31 : v9_favorite 用户收藏表
|
字段 |
类型 |
Null |
默认 |
额外 |
注释 |
|
id |
int(10) unsigned |
PK |
|
auto_increment |
识标id |
|
userid |
mediumint(8) unsigned |
NO |
0 |
|
户用id |
|
title |
char(100) |
NO |
|
|
题标 |
|
url |
char(100) |
NO |
|
|
接链地址 |
|
adddate |
int(10) unsigned |
NO |
0 |
|
加添日期 |
|
|
键名 |
类型 |
字段 |
|
PRIMARY |
PRIMARY |
id |
|
userid |
INDEX |
userid |
表 32 : v9_formguide
|
字段 |
类型 |
Null |
默认 |
额外 |
注释 |
|
formid |
smallint(5) unsigned |
PK |
|
auto_increment |
|
|
siteid |
smallint(5) unsigned |
NO |
0 |
|
|
|
name |
varchar(30) |
NO |
|
|
|
|
tablename |
varchar(20) |
NO |
|
|
|
|
introduce |
varchar(255) |
NO |
|
|
|
|
setting |
text |
NO |
|
|
|
|
addtime |
int(10) unsigned |
NO |
|
|
|
|
items |
mediumint(8) unsigned |
NO |
0 |
|
|
|
style |
varchar(20) |
NO |
|
|
|
|
template |
varchar(30) |
NO |
|
|
|
|
disabled |
tinyint(1) unsigned |
NO |
0 |
|
|
|
|
键名 |
类型 |
字段 |
|
PRIMARY |
PRIMARY |
formid |
|
formid |
INDEX |
formid |
|
formid |
INDEX |
siteid |
|
siteid |
INDEX |
siteid |
|
siteid |
INDEX |
disabled |
表 33 : v9_formguide_fields
|
字段 |
类型 |
Null |
默认 |
额外 |
注释 |
|
fieldid |
mediumint(8) unsigned |
PK |
|
auto_increment |
|
|
formid |
smallint(5) unsigned |
NO |
0 |
|
|
|
siteid |
smallint(5) unsigned |
NO |
0 |
|
|
|
field |
varchar(20) |
NO |
|
|
|
|
name |
varchar(30) |
NO |
|
|
|
|
tips |
text |
NO |
|
|
|
|
css |
varchar(30) |
NO |
|
|
|
|
minlength |
int(10) unsigned |
NO |
0 |
|
|
|
maxlength |
int(10) unsigned |
NO |
0 |
|
|
|
pattern |
varchar(255) |
NO |
|
|
|
|
errortips |
varchar(255) |
NO |
|
|
|
|
formtype |
varchar(20) |
NO |
|
|
|
|
setting |
mediumtext |
NO |
|
|
|
|
formattribute |
varchar(255) |
NO |
|
|
|
|
unsetgroupids |
varchar(255) |
NO |
|
|
|
|
unsetroleids |
varchar(255) |
NO |
|
|
|
|
iscore |
tinyint(1) unsigned |
NO |
0 |
|
|
|
issystem |
tinyint(1) unsigned |
NO |
0 |
|
|
|
isunique |
tinyint(1) unsigned |
NO |
0 |
|
|
|
isbase |
tinyint(1) unsigned |
NO |
0 |
|
|
|
issearch |
tinyint(1) unsigned |
NO |
0 |
|
|
|
isselect |
tinyint(1) unsigned |
NO |
0 |
|
|
|
iswhere |
tinyint(1) unsigned |
NO |
0 |
|
|
|
isorder |
tinyint(1) unsigned |
NO |
0 |
|
|
|
islist |
tinyint(1) unsigned |
NO |
0 |
|
|
|
isshow |
tinyint(1) unsigned |
NO |
0 |
|
|
|
isadd |
tinyint(1) unsigned |
NO |
0 |
|
|
|
isfulltext |
tinyint(1) unsigned |
NO |
0 |
|
|
|
isposition |
tinyint(1) unsigned |
NO |
0 |
|
|
|
listorder |
mediumint(8) unsigned |
NO |
0 |
|
|
|
disabled |
tinyint(1) unsigned |
NO |
0 |
|
|
|
isomnipotent |
tinyint(1) unsigned |
NO |
0 |
|
|
|
|
键名 |
类型 |
字段 |
|
PRIMARY |
PRIMARY |
fieldid |
|
formid |
INDEX |
formid |
|
formid |
INDEX |
disabled |
|
field |
INDEX |
field |
|
field |
INDEX |
formid |
表 34 : v9_hits 访问统计
|
字段 |
类型 |
Null |
默认 |
额外 |
注释 |
|
hitsid |
char(30) |
PK |
|
|
主键 |
|
views |
int(10) unsigned |
NO |
0 |
|
总数 |
|
yesterdayviews |
int(10) unsigned |
NO |
0 |
|
最日 |
|
dayviews |
int(10) unsigned |
NO |
0 |
|
今日 |
|
weekviews |
int(10) unsigned |
NO |
0 |
|
本周访问 |
|
monthviews |
int(10) unsigned |
NO |
0 |
|
本月访问 |
|
updatetime |
int(10) unsigned |
NO |
0 |
|
最后更新时间 |
|
|
键名 |
类型 |
字段 |
|
PRIMARY |
PRIMARY |
hitsid |
表 35 : v9_ipbanned IP禁止
|
字段 |
类型 |
Null |
默认 |
额外 |
注释 |
|
ipbannedid |
smallint(5) |
PK |
|
auto_increment |
IP禁止ID |
|
ip |
char(15) |
NO |
|
|
IP地址 |
|
expires |
int(10) unsigned |
NO |
0 |
|
解封日期 |
|
|
键名 |
类型 |
字段 |
|
PRIMARY |
PRIMARY |
ipbannedid |
表 36 : v9_keylink 关联链接
|
字段 |
类型 |
Null |
默认 |
额外 |
注释 |
|
keylinkid |
smallint(5) unsigned |
PK |
|
auto_increment |
链接ID |
|
word |
char(40) |
NO |
|
|
关联链接名称 |
|
url |
char(100) |
NO |
|
|
关联链接URL |
|
|
键名 |
类型 |
字段 |
|
PRIMARY |
PRIMARY |
keylinkid |
表 37 : v9_link
|
字段 |
类型 |
Null |
默认 |
额外 |
注释 |
|
linkid |
smallint(5) unsigned |
PK |
|
auto_increment |
|
|
siteid |
smallint(5) unsigned |
YES |
0 |
|
|
|
typeid |
smallint(5) unsigned |
NO |
0 |
|
|
|
linktype |
tinyint(1) unsigned |
NO |
0 |
|
|
|
name |
varchar(50) |
NO |
|
|
|
|
url |
varchar(255) |
NO |
|
|
|
|
logo |
varchar(255) |
NO |
|
|
|
|
introduce |
text |
NO |
|
|
|
|
username |
varchar(30) |
NO |
|
|
|
|
listorder |
smallint(5) unsigned |
NO |
0 |
|
|
|
elite |
tinyint(1) unsigned |
NO |
0 |
|
|
|
passed |
tinyint(1) unsigned |
NO |
0 |
|
|
|
addtime |
int(10) unsigned |
NO |
0 |
|
