ucenterhome数据库帮助手册.docx

1、ucenterhome数据库帮助手册 - - 数据库: 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

2、 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) - - - - “相册”表 - 序号,相册名称,

3、用户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

4、) 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,updatet

5、ime), 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 defau

6、lt 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 NU

7、LL 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、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 defau

9、lt 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 (frie

10、nd,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 ,

11、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 (ca

12、chekey) - - - - “日志分类”表 - 序号,分类名称,用户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留言”表 -

13、序号,用户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)

14、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

15、 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 defa

16、ult , 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) - - -

17、 - 积分规则,邮件,后台的上传图片设置,远程上传设置,多应用设置,备份目录,词法过滤,随便看看模块列表:模块编辑 - 变量,变量值 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 de

18、fault 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_fri

19、end 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 stat

20、us (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

21、) 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,

22、 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(

23、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) unsign

24、ed 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,blogiduid类型 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会员表