program - php
这里是PHP程序交流平台.
--
-- ucenter home 数据库
--
-- 数据库: uchome
--
-- --------------------------------------------------------
--
-- “广告”表
-- 序号,是否激活,标题,位置,代码,类型
uchome_ad
adid smallint(6) unsigned NOT NULL auto_increment,
available tinyint(1) NOT NULL default '1',
title varchar(50) NOT NULL default '',
pagetype varchar(20) NOT NULL default '',
adcode text NOT NULL,
system tinyint(1) NOT NULL default '0',
PRIMARY KEY (adid)
-- --------------------------------------------------------
--
-- “管理员session记录”表
-- 序号,ip,创建日期,错误数量
uchome_adminsession
uid mediumint(8) unsigned NOT NULL default '0',
ip char(15) NOT NULL default '',
dateline int(10) unsigned NOT NULL default '0',
errorcount tinyint(1) NOT NULL default '0',
PRIMARY KEY (uid)
-- --------------------------------------------------------
--
-- “相册”表
-- 序号,相册名称,用户ID,用户名,创建日期,更新日期,图片数量,最近图片地址,x,可见度,查看密码
uchome_album
albumid mediumint(8) unsigned NOT NULL auto_increment,
albumname varchar(50) NOT NULL default '',
uid mediumint(8) unsigned NOT NULL default '0',
username varchar(15) NOT NULL default '',
dateline int(10) unsigned NOT NULL default '0',
updatetime int(10) unsigned NOT NULL default '0',
picnum smallint(6) unsigned NOT NULL default '0',
pic varchar(60) NOT NULL default '',
picflag tinyint(1) NOT NULL default '0',
friend tinyint(1) NOT NULL default '0',
`password` varchar(10) NOT NULL default '',
target_ids text NOT NULL,
PRIMARY KEY (albumid),
KEY uid (uid,updatetime),
KEY friend (friend,updatetime),
KEY updatetime (updatetime)
-- --------------------------------------------------------
--
-- “uchome app”表
-- 用户ID,应用ID,数量,更新日期
uchome_app
uid mediumint(8) unsigned NOT NULL default '0',
appid smallint(6) unsigned NOT NULL default '0',
num mediumint(8) unsigned NOT NULL default '0',
updatetime int(10) unsigned NOT NULL default '0',
PRIMARY KEY (uid,appid)
-- --------------------------------------------------------
--
-- 数据调用 表
-- 序号,调用名称,调用sql语句,缓存变量,缓存时间,获取的记录数,每页的记录数,html代码
uchome_block
bid smallint(6) unsigned NOT NULL auto_increment,
blockname varchar(40) NOT NULL default '',
blocksql text NOT NULL,
cachename varchar(30) NOT NULL default '',
cachetime smallint(6) unsigned NOT NULL default '0',
num tinyint(3) unsigned NOT NULL default '0',
perpage tinyint(3) unsigned NOT NULL default '0',
htmlcode text NOT NULL,
PRIMARY KEY (bid)
-- --------------------------------------------------------
--
-- “日志”表
-- 序号,用户id,用户名,主题,分类id,浏览数,回复数,发布日期,图片地址,是否有图片,没有回复,X,查看密码
uchome_blog
blogid mediumint(8) unsigned NOT NULL auto_increment,
uid mediumint(8) unsigned NOT NULL default '0',
username char(15) NOT NULL default '',
`subject` char(80) NOT NULL default '',
classid smallint(6) unsigned NOT NULL default '0',
viewnum mediumint(8) unsigned NOT NULL default '0',
replynum mediumint(8) unsigned NOT NULL default '0',
tracenum mediumint(8) unsigned NOT NULL default '0',
dateline int(10) unsigned NOT NULL default '0',
pic char(120) NOT NULL default '',
picflag tinyint(1) NOT NULL default '0',
noreply tinyint(1) NOT NULL default '0',
friend tinyint(1) NOT NULL default '0',
`password` char(10) NOT NULL default '',
PRIMARY KEY (blogid),
KEY uid (uid,dateline),
KEY friend (friend,dateline),
KEY dateline (dateline)
-- --------------------------------------------------------
--
-- “日志摘要”表
-- 序号,用户ID,表签,消息,发送IP,内容,生成日期,x
uchome_blogfield
blogid mediumint(8) unsigned NOT NULL default '0',
uid mediumint(8) unsigned NOT NULL default '0',
tag varchar(255) NOT NULL default '',
message mediumtext NOT NULL,
postip varchar(20) NOT NULL default '',
related text NOT NULL,
relatedtime int(10) unsigned NOT NULL default '0',
target_ids text NOT NULL,
PRIMARY KEY (blogid)
-- --------------------------------------------------------
--
-- “模块缓存”表 模块调用数据时(站点设置)
-- 缓存的密钥,值,时间
uchome_cache
cachekey varchar(16) NOT NULL default '',
`value` mediumtext NOT NULL,
mtime int(10) unsigned NOT NULL default '0',
PRIMARY KEY (cachekey)
-- --------------------------------------------------------
--
-- “日志分类”表
-- 序号,分类名称,用户ID,创建日期
uchome_class
classid mediumint(8) unsigned NOT NULL auto_increment,
classname char(40) NOT NULL default '',
uid mediumint(8) unsigned NOT NULL default '0',
dateline int(10) unsigned NOT NULL default '0',
PRIMARY KEY (classid),
KEY uid (uid)
-- --------------------------------------------------------
--
-- “space留言”表
-- 序号,用户ID,x,ID类型,作者的ID,作者,ip,创建日期,内容
uchome_comment
cid mediumint(8) unsigned NOT NULL auto_increment,
uid mediumint(8) unsigned NOT NULL default '0',
id mediumint(8) unsigned NOT NULL default '0',
idtype varchar(20) NOT NULL default '',
authorid mediumint(8) unsigned NOT NULL default '0',
author varchar(15) NOT NULL default '',
ip varchar(20) NOT NULL default '',
dateline int(10) unsigned NOT NULL default '0',
message text NOT NULL,
PRIMARY KEY (cid),
KEY id (id,idtype,dateline)
-- --------------------------------------------------------
--
-- “ucenter基本设置”表 后台的站点设置,隐私设置:允许访问的IP列表,禁止访问的IP列表,新用户默认隐私设置
--
uchome_config
var varchar(30) NOT NULL default '',
datavalue text NOT NULL,
PRIMARY KEY (var)
-- --------------------------------------------------------
--
-- 定表:更新浏览数统计,清理过期的feed,清里个人通知,统计uc的feed[后台的Task]
--
uchome_cron
cronid smallint(6) unsigned NOT NULL auto_increment,
available tinyint(1) NOT NULL default '0',
`type` enum('user','system') NOT NULL default 'user',
`name` char(50) NOT NULL default '',
filename char(50) NOT NULL default '',
lastrun int(10) unsigned NOT NULL default '0',
nextrun int(10) unsigned NOT NULL default '0',
weekday tinyint(1) NOT NULL default '0',
`day` tinyint(2) NOT NULL default '0',
`hour` tinyint(2) NOT NULL default '0',
`minute` char(36) NOT NULL default '',
PRIMARY KEY (cronid),
KEY nextrun (available,nextrun)
-- --------------------------------------------------------
--
-- 积分规则,邮件,后台的上传图片设置,远程上传设置,多应用设置,备份目录,词法过滤,随便看看模块列表:模块编辑
-- 变量,变量值
uchome_data
var varchar(20) NOT NULL default '',
datavalue text NOT NULL,
PRIMARY KEY (var)
-- --------------------------------------------------------
--
-- “迷你博客”表
-- 序号,用户ID,用户名,创建日期,内容,ip
uchome_doing
doid mediumint(8) unsigned NOT NULL auto_increment,
uid mediumint(8) unsigned NOT NULL default '0',
username char(15) NOT NULL default '',
dateline int(10) unsigned NOT NULL default '0',
message char(200) NOT NULL default '',
ip char(20) NOT NULL default '',
PRIMARY KEY (doid),
KEY uid (uid,dateline),
KEY dateline (dateline)
-- --------------------------------------------------------
--
-- “加好友”表
-- 用户ID,要加好友的ID,要加好友的名字,状态(0=s,1=d),把好友放到哪个组中,备
uchome_friend
uid mediumint(8) unsigned NOT NULL default '0',
fuid mediumint(8) unsigned NOT NULL default '0',
fusername char(15) NOT NULL default '',
status tinyint(1) NOT NULL default '0',
gid smallint(6) unsigned NOT NULL default '0',
note char(50) NOT NULL default '',
PRIMARY KEY (uid,fuid),
KEY fuid (fuid),
KEY status (uid, status)
-- --------------------------------------------------------
--
-- “反馈”表
-- 序号,应用ID,图标,用户ID,用户名,创建日期,x,x,x,标题模板,标题数据,正文模板,正文数据
uchome_feed (
feedid mediumint(8) unsigned NOT NULL auto_increment,
appid smallint(6) unsigned NOT NULL default '0',
icon varchar(30) NOT NULL default '',
uid mediumint(8) unsigned NOT NULL default '0',
username varchar(15) NOT NULL default '',
dateline int(10) unsigned NOT NULL default '0',
friend tinyint(1) NOT NULL default '0',
hash_template varchar(32) NOT NULL default '',
hash_data varchar(32) NOT NULL default '',
title_template text NOT NULL,
title_data text NOT NULL,
body_template text NOT NULL,
body_data text NOT NULL,
body_general text NOT NULL,
image_1 varchar(255) NOT NULL default '',
image_1_link varchar(255) NOT NULL default '',
image_2 varchar(255) NOT NULL default '',
image_2_link varchar(255) NOT NULL default '',
image_3 varchar(255) NOT NULL default '',
image_3_link varchar(255) NOT NULL default '',
image_4 varchar(255) NOT NULL default '',
image_4_link varchar(255) NOT NULL default '',
target_ids text NOT NULL,
PRIMARY KEY (feedid),
KEY uid (uid,dateline),
KEY dateline (dateline)
-- --------------------------------------------------------
--
-- “邀请好友”表
-- 序号,用户ID,邀请码,被邀请好友的ID,被邀请用户名
uchome_invite (
id mediumint(8) unsigned NOT NULL auto_increment,
uid mediumint(8) unsigned NOT NULL default '0',
code char(20) NOT NULL default '',
fuid mediumint(8) unsigned NOT NULL default '0',
fusername char(15) NOT NULL default '',
PRIMARY KEY (id),
KEY uid (uid)
-- --------------------------------------------------------
--
-- uchome日志
-- 序号,数据实例ID,blogid[uid]类型
uchome_log (
logid mediumint(8) unsigned NOT NULL auto_increment,
id mediumint(8) unsigned NOT NULL default '0',
idtype char(20) NOT NULL default '',
PRIMARY KEY (logid)
-- --------------------------------------------------------
--
-- uchome会员表
-- 序号,用户名,密码
uchome_member (
uid mediumint(8) unsigned NOT NULL auto_increment,
username char(15) NOT NULL default '',
`password` char(32) NOT NULL default '',
PRIMARY KEY (uid)
-- --------------------------------------------------------
--
-- 自定义选吧 表
-- 序号,选吧名称,选吧的ID,人数,吧主,状态,公告,图片
uchome_mtag
tagid mediumint(8) unsigned NOT NULL auto_increment,
tagname varchar(40) NOT NULL default '',
fieldid smallint(6) NOT NULL default '0',
membernum mediumint(8) unsigned NOT NULL default '0',
moderator varchar(255) NOT NULL default '',
`close` tinyint(1) NOT NULL default '0',
announcement varchar(255) NOT NULL default '',
pic varchar(150) NOT NULL default '',
PRIMARY KEY (tagid),
KEY tagname (tagname),
KEY fieldid (fieldid,membernum),
KEY membernum (membernum)
-- --------------------------------------------------------
--
-- “通知”表
-- 序号,接收用户ID,类型,是否新通知,作者ID,作者用户名,备注,创建日期
uchome_notification
id mediumint(8) unsigned NOT NULL auto_increment,
uid mediumint(8) unsigned NOT NULL default '0',
`type` varchar(20) NOT NULL default '',
`new` tinyint(1) NOT NULL default '0',
authorid mediumint(8) unsigned NOT NULL default '0',
author varchar(15) NOT NULL default '',
note text NOT NULL,
dateline int(10) unsigned NOT NULL default '0',
PRIMARY KEY (id),
KEY uid (uid)
-- --------------------------------------------------------
--
-- “相片”表
-- 相片ID,相册ID,用户ID，创建日期,源文件名,主题,格式,大小,图片路径
uchome_pic (
picid mediumint(8) NOT NULL auto_increment,
albumid mediumint(8) unsigned NOT NULL default '0',
uid mediumint(8) unsigned NOT NULL default '0',
dateline int(10) unsigned NOT NULL default '0',
filename char(100) NOT NULL default '',
title char(150) NOT NULL default '',
`type` char(20) NOT NULL default '',
size int(10) unsigned NOT NULL default '0',
filepath char(60) NOT NULL default '',
thumb tinyint(1) NOT NULL default '0',
remote tinyint(1) NOT NULL default '0',
PRIMARY KEY (picid),
KEY albumid (albumid,dateline)
-- --------------------------------------------------------
--
-- “打招呼”表
-- (向谁)用户ID,(发送招呼)用户ID,(发送招呼的)用户名，备注
uchome_poke (
uid mediumint(8) unsigned NOT NULL default '0',
fromuid mediumint(8) unsigned NOT NULL default '0',
fromusername char(15) NOT NULL default '',
note char(50) NOT NULL default '',
PRIMARY KEY (uid,fromuid)
-- --------------------------------------------------------
--
-- “发帖”表
-- 帖子ID,选吧ID,主贴ID,用户ID,用户名,ip,创建日期,内容,图片,是否为回复(1为发贴,0为回贴)
uchome_post (
pid mediumint(8) unsigned NOT NULL auto_increment,
tagid mediumint(8) unsigned NOT NULL default '0',
tid mediumint(8) unsigned NOT NULL default '0',
uid mediumint(8) unsigned NOT NULL default '0',
username varchar(15) NOT NULL default '',
ip varchar(20) NOT NULL default '',
dateline int(10) unsigned NOT NULL default '0',
message text NOT NULL,
pic varchar(255) NOT NULL default '',
isthread tinyint(1) NOT NULL default '0',
PRIMARY KEY (pid),
KEY tid (tid,dateline)
-- --------------------------------------------------------
--
-- 选吧的主题(默认为定表)
-- 序号,选吧的主题,选吧介绍,控件的类型,输入框类型,选项,显示顺序
uchome_profield (
fieldid smallint(6) unsigned NOT NULL auto_increment,
title varchar(80) NOT NULL default '',
note varchar(255) NOT NULL default '',
formtype varchar(20) NOT NULL default '0',
inputnum smallint(3) unsigned NOT NULL default '0',
choice text NOT NULL,
displayorder tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (fieldid)
-- --------------------------------------------------------
--
-- 后台用户栏目:注册会员时的附加控件,跟会员表uchome_member关联
-- 序号,标题,备注,控件的类型,最大的数量,是否为必填项(1否,0是),是否隐藏(0否,1是),是否允许搜索(0否,1是),选项名称(radio,select),显示顺序
uchome_profilefield (
fieldid smallint(6) unsigned NOT NULL auto_increment,
title varchar(80) NOT NULL default '',
note varchar(255) NOT NULL default '',
formtype varchar(20) NOT NULL default '0',
maxsize tinyint(3) unsigned NOT NULL default '0',
required tinyint(1) NOT NULL default '0',
invisible tinyint(1) NOT NULL default '0',
allowsearch tinyint(1) NOT NULL default '0',
choice text NOT NULL,
displayorder tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (fieldid)
-- --------------------------------------------------------
--
-- “在线session”表
-- 用户ID,用户名,密码,权限,积分,最后上线日期,站内信,屏蔽CSS
uchome_session (
uid mediumint(8) unsigned NOT NULL default '0',
username char(15) NOT NULL default '',
`password` char(32) NOT NULL default '',
groupid smallint(6) unsigned NOT NULL default '0',
credit int(10) NOT NULL default '0',
lastactivity int(10) unsigned NOT NULL default '0',
newpm tinyint(1) NOT NULL default '0',
nocss tinyint(1) NOT NULL default '0',
PRIMARY KEY (uid)
-- --------------------------------------------------------
--
-- “分享”表
-- 分享ID,类别,分享者ID,分享者用户名,分享日期,x,主题模板,正文模板(占位符),正文的文本,图片,图片连接
uchome_share
sid mediumint(8) unsigned NOT NULL auto_increment,
type varchar(30) NOT NULL default '',
uid mediumint(8) unsigned NOT NULL default '0',
username varchar(15) NOT NULL default '',
dateline int(10) unsigned NOT NULL default '0',
hash_data varchar(32) NOT NULL default '',
title_template text NOT NULL,
body_template text NOT NULL,
body_data text NOT NULL,
body_general text NOT NULL,
image varchar(255) NOT NULL default '',
image_link varchar(255) NOT NULL default '',
PRIMARY KEY (sid),
KEY uid (uid,dateline),
KEY dateline (dateline)
-- --------------------------------------------------------
--
-- “个人空间”表
-- ID,权限,积分,用户名,个人主页网址,空间名称,浏览数量,好友数量,创建日期,更新日期,最后(搜)索引日期,最后提交日期,已用的空间(字节)数,x,x
uchome_space
uid mediumint(8) unsigned NOT NULL default '0',
groupid smallint(6) unsigned NOT NULL default '0',
credit int(10) NOT NULL default '0',
username char(15) NOT NULL default '',
domain char(15) NOT NULL default '',
spacename char(30) NOT NULL default '',
viewnum int(10) unsigned NOT NULL default '0',
friendnum int(10) unsigned NOT NULL default '0',
dateline int(10) unsigned NOT NULL default '0',
updatetime int(10) unsigned NOT NULL default '0',
lastsearch int(10) unsigned NOT NULL default '0',
lastpost int(10) unsigned NOT NULL default '0',
attachsize int(10) NOT NULL default '0',
addsize int(10) NOT NULL default '0',
flag tinyint(1) NOT NULL default '0',
PRIMARY KEY (uid),
KEY username (username),
KEY domain (domain),
KEY updatetime (updatetime)
-- --------------------------------------------------------
--
-- “个人资料” 表
-- 用户ID,性别,邮箱,qq,msn,出生年,出生月,出生日,血性,婚姻状况,出生的省,出生的市,现居省,现居市,最后的日志,x,是否选用个性模板,个人空间模板，X,X,X,X
uchome_spacefield
uid mediumint(8) unsigned NOT NULL default '0',
sex tinyint(1) NOT NULL default '0',
email varchar(100) NOT NULL default '',
qq varchar(20) NOT NULL default '',
msn varchar(80) NOT NULL default '',
birthyear smallint(6) unsigned NOT NULL default '0',
birthmonth tinyint(3) unsigned NOT NULL default '0',
birthday tinyint(3) unsigned NOT NULL default '0',
blood varchar(5) NOT NULL default '',
marry tinyint(1) NOT NULL default '0',
birthprovince varchar(20) NOT NULL default '',
birthcity varchar(20) NOT NULL default '',
resideprovince varchar(20) NOT NULL default '',
residecity varchar(20) NOT NULL default '',
note varchar(255) NOT NULL default '',
authstr varchar(20) NOT NULL default '',
nocss tinyint(1) NOT NULL default '0',
theme varchar(20) NOT NULL default '',
css text NOT NULL,
privacy text NOT NULL,
friend text NOT NULL,
feedfriend text NOT NULL,
PRIMARY KEY (uid)
-- --------------------------------------------------------
--
-- “日志关键字”表
-- 关键字序号,关键字名称,用户ID,创建日期,日志数量,x
uchome_tag
tagid mediumint(8) unsigned NOT NULL auto_increment,
tagname char(30) NOT NULL default '',
uid mediumint(8) unsigned NOT NULL default '0',
dateline int(10) unsigned NOT NULL default '0',
blognum smallint(6) unsigned NOT NULL default '0',
`close` tinyint(1) NOT NULL default '0',
PRIMARY KEY (tagid),
KEY tagname (tagname)
-- --------------------------------------------------------
--
-- “日志”表跟“日志关键字”表的中间表
-- 关键字ID,日志ID
uchome_tagblog
tagid mediumint(8) unsigned NOT NULL default '0',
blogid mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (tagid,blogid)
-- --------------------------------------------------------
--
-- “用户”表和“选吧”表的中间表
-- 选吧ID,用户ID,用户名
uchome_tagspace
tagid mediumint(8) unsigned NOT NULL default '0',
uid mediumint(8) unsigned NOT NULL default '0',
username char(15) NOT NULL default '',
PRIMARY KEY (tagid,uid),
KEY uid (uid)
-- --------------------------------------------------------
--
-- “贴子”表
-- 贴子ID,选吧的ID,主题,作者ID,作者用户名,发帖日期,查看数,回复数,最后回复时间,最后回复人,最后回复人ID,排序,置顶
uchome_thread
tid mediumint(8) unsigned NOT NULL auto_increment,
tagid mediumint(8) unsigned NOT NULL default '0',
`subject` char(80) NOT NULL default '',
uid mediumint(8) unsigned NOT NULL default '0',
username char(15) NOT NULL default '',
dateline int(10) unsigned NOT NULL default '0',
viewnum mediumint(8) unsigned NOT NULL default '0',
replynum mediumint(8) unsigned NOT NULL default '0',
lastpost int(10) unsigned NOT NULL default '0',
lastauthor char(15) NOT NULL default '',
lastauthorid mediumint(8) unsigned NOT NULL default '0',
displayorder tinyint(1) unsigned NOT NULL default '0',
digest tinyint(1) NOT NULL default '0',
PRIMARY KEY (tid),
KEY tagid (tagid,displayorder,lastpost),
KEY uid (uid,lastpost),
KEY lastpost (lastpost)
-- --------------------------------------------------------
--
-- “日志的脚印”表
-- 被踩日志ID,踩脚印者ID,踩者用户名,踩脚印的时间
uchome_trace
blogid mediumint(8) unsigned NOT NULL default '0',
uid mediumint(8) unsigned NOT NULL default '0',
username char(15) NOT NULL default '',
dateline int(10) unsigned NOT NULL default '0',
PRIMARY KEY (blogid,uid),
KEY dateline (blogid,dateline),
KEY uid (uid,dateline)
-- --------------------------------------------------------
--
-- 会员的分类[后台的用户组] 表
--
uchome_usergroup
gid smallint(6) unsigned NOT NULL auto_increment,
grouptitle char(20) NOT NULL default '',
system tinyint(1) NOT NULL default '0',
creditlower int(10) NOT NULL default '0',
maxfriendnum smallint(6) unsigned NOT NULL default '0',
maxattachsize int(10) unsigned NOT NULL default '0',
allowhtml tinyint(1) NOT NULL default '0',
allowcomment tinyint(1) NOT NULL default '0',
searchinterval smallint(6) unsigned NOT NULL default '0',
postinterval smallint(6) unsigned NOT NULL default '0',
allowblog tinyint(1) NOT NULL default '0',
allowdoing tinyint(1) NOT NULL default '0',
allowupload tinyint(1) NOT NULL default '0',
allowshare tinyint(1) NOT NULL default '0',
allowthread tinyint(1) NOT NULL default '0',
allowpost tinyint(1) NOT NULL default '0',
domainlength smallint(6) unsigned NOT NULL default '0',
closeignore tinyint(1) NOT NULL default '0',
manageconfig tinyint(1) NOT NULL default '0',
managenetwork tinyint(1) NOT NULL default '0',
manageprofilefield tinyint(1) NOT NULL default '0',
manageprofield tinyint(1) NOT NULL default '0',
manageusergroup tinyint(1) NOT NULL default '0',
managefeed tinyint(1) NOT NULL default '0',
manageshare tinyint(1) NOT NULL default '0',
managedoing tinyint(1) NOT NULL default '0',
manageblog tinyint(1) NOT NULL default '0',
managetag tinyint(1) NOT NULL default '0',
managetagtpl tinyint(1) NOT NULL default '0',
managealbum tinyint(1) NOT NULL default '0',
managecomment tinyint(1) NOT NULL default '0',
managemtag tinyint(1) NOT NULL default '0',
managethread tinyint(1) NOT NULL default '0',
managespace tinyint(1) NOT NULL default '0',
managecensor tinyint(1) NOT NULL default '0',
managead tinyint(1) NOT NULL default '0',
managebackup tinyint(1) NOT NULL default '0',
manageblock tinyint(1) NOT NULL default '0',
managetemplate tinyint(1) NOT NULL default '0',
managestat tinyint(1) NOT NULL default '0',
managecache tinyint(1) NOT NULL default '0',
managecredit tinyint(1) NOT NULL default '0',
managecron tinyint(1) NOT NULL default '0',
PRIMARY KEY (gid)
-- --------------------------------------------------------
--
-- “最新访客”表
-- 受访者ID,访客ID,访客用户名,访问时间
uchome_visitor
uid mediumint(8) unsigned NOT NULL default '0',
vuid mediumint(8) unsigned NOT NULL default '0',
vusername char(15) NOT NULL default '',
dateline int(10) unsigned NOT NULL default '0',
PRIMARY KEY (uid,vuid),
KEY dateline (uid,dateline)
-大家好是三成---
