uchome数据库字典.docx

1、uchome数据库字典- - Table structure for uchome_ad- -ALTER TABLE uchome_ad MODIFY COLUMN adid smallint(6) unsigned NOT NULL AUTO_INCREMENT COMMENT 广告ID, MODIFY COLUMN available tinyint(1) NOT NULL DEFAULT 1 COMMENT 广告有效性:1为有效,0为无效, MODIFY COLUMN title varchar(50) NOT NULL DEFAULT COMMENT 广告标题, MODIFY COLU

2、MN pagetype varchar(20) NOT NULL DEFAULT COMMENT 广告页面位置:header全站页面上部横幅,rightside查看内容页面,footer全站页脚区域, MODIFY COLUMN adcode text NOT NULL COMMENT 广告代码, MODIFY COLUMN system tinyint(1) NOT NULL DEFAULT 0 COMMENT 广告类型:1为系统内置广告,0为用户自定义广告, ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT=广告表,存放广告设置信息;- - Record

3、s of uchome_ad- - - Table structure for uchome_adminsession- -ALTER TABLE uchome_adminsession MODIFY COLUMN uid mediumint(8) unsigned NOT NULL DEFAULT 0 COMMENT 管理员ID, MODIFY COLUMN ip char(15) NOT NULL DEFAULT COMMENT 管理员登陆IP, MODIFY COLUMN dateline int(10) unsigned NOT NULL DEFAULT 0 COMMENT 管理员登陆

4、时间戳, MODIFY COLUMN errorcount tinyint(1) NOT NULL DEFAULT 0 COMMENT 管理员错误登陆次数, ENGINE=MEMORY DEFAULT CHARSET=utf8 COMMENT=用户管理session表,存放用户登陆后台管理的session;- - Records of uchome_adminsession- - - Table structure for uchome_album- -ALTER TABLE uchome_album MODIFY COLUMN albumid mediumint(8) unsigned NO

5、T NULL AUTO_INCREMENT COMMENT 相册ID, MODIFY COLUMN albumname varchar(50) NOT NULL DEFAULT COMMENT 相册名字, MODIFY COLUMN uid mediumint(8) unsigned NOT NULL DEFAULT 0 COMMENT 相册用户ID, MODIFY COLUMN username varchar(15) NOT NULL DEFAULT COMMENT 相册用户名, MODIFY COLUMN dateline int(10) unsigned NOT NULL DEFAUL

6、T 0 COMMENT 相册建立时间戳, MODIFY COLUMN updatetime int(10) unsigned NOT NULL DEFAULT 0 COMMENT 相册最后修改时间戳, MODIFY COLUMN picnum smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 相册照片数量, MODIFY COLUMN pic varchar(60) NOT NULL DEFAULT COMMENT 相册封面照片, MODIFY COLUMN picflag tinyint(1) NOT NULL DEFAULT 0 COMMENT

7、 相册是否有图片, MODIFY COLUMN friend tinyint(1) NOT NULL DEFAULT 0 COMMENT 相册隐私设置:0全站用户可见,1为全好友可见,2为仅指定的好友可见,3为仅自己可见,4为凭密码查看, MODIFY COLUMN password varchar(10) NOT NULL DEFAULT COMMENT 相册密码, MODIFY COLUMN target_ids text NOT NULL COMMENT 允许查看相册的用户ID,多个用户ID用,间隔, ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT=

8、相册表,存放用户相册信息;- - Records of uchome_album- - - Table structure for uchome_appcreditlog- -ALTER TABLE uchome_appcreditlog MODIFY COLUMN logid mediumint(8) unsigned NOT NULL AUTO_INCREMENT, MODIFY COLUMN uid mediumint(8) unsigned NOT NULL DEFAULT 0, MODIFY COLUMN appid mediumint(8) unsigned NOT NULL DE

9、FAULT 0, MODIFY COLUMN appname varchar(60) NOT NULL DEFAULT , MODIFY COLUMN type tinyint(1) NOT NULL DEFAULT 0, MODIFY COLUMN credit mediumint(8) unsigned NOT NULL DEFAULT 0, MODIFY COLUMN note text NOT NULL, MODIFY COLUMN dateline int(10) unsigned NOT NULL DEFAULT 0, ENGINE=MyISAM DEFAULT CHARSET=u

10、tf8;- - Records of uchome_appcreditlog- - - Table structure for uchome_blacklist- -ALTER TABLE uchome_blacklist MODIFY COLUMN uid mediumint(8) unsigned NOT NULL DEFAULT 0 COMMENT 用户ID, MODIFY COLUMN buid mediumint(8) unsigned NOT NULL DEFAULT 0 COMMENT 被屏蔽的用户ID, MODIFY COLUMN dateline int(10) unsign

11、ed NOT NULL DEFAULT 0 COMMENT 被屏蔽的时间戳, ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT=用户屏蔽表;- - Records of uchome_blacklist- - - Table structure for uchome_block- -ALTER TABLE uchome_block MODIFY COLUMN bid smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 数据调用模块ID, MODIFY COLUMN blockname varchar(40

12、) NOT NULL DEFAULT COMMENT 数据调用模块名, MODIFY COLUMN blocksql text NOT NULL COMMENT 数据调用模块SQL语句, MODIFY COLUMN cachename varchar(30) NOT NULL DEFAULT COMMENT 模块缓存名, MODIFY COLUMN cachetime smallint(6) unsigned NOT NULL DEFAULT 0 COMMENT 数据调用模块缓存时间, MODIFY COLUMN startnum tinyint(3) unsigned NOT NULL DE

13、FAULT 0 COMMENT 数据调用开始数, MODIFY COLUMN num tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT 只获取满足条件的前多少条数据, MODIFY COLUMN perpage tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT 当全部获取时每页显示多少条, MODIFY COLUMN htmlcode text NOT NULL COMMENT 数据显示HTML代码, ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT=数据调用模块表,存放

14、数据调用的信息;- - Records of uchome_block- - - Table structure for uchome_blog- -ALTER TABLE uchome_blog MODIFY COLUMN blogid mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT 日志ID, MODIFY COLUMN topicid mediumint(8) unsigned NOT NULL DEFAULT 0 COMMENT 热闹ID, MODIFY COLUMN uid mediumint(8) unsigned NOT

15、 NULL DEFAULT 0 COMMENT 日志所属用户ID, MODIFY COLUMN username char(15) NOT NULL DEFAULT COMMENT 日志所属用户名, MODIFY COLUMN subject char(80) NOT NULL DEFAULT COMMENT 日志标题, MODIFY COLUMN classid smallint(6) unsigned NOT NULL DEFAULT 0 COMMENT 日志类别ID, MODIFY COLUMN viewnum mediumint(8) unsigned NOT NULL DEFAULT

16、 0 COMMENT 日志查看数, MODIFY COLUMN replynum mediumint(8) unsigned NOT NULL DEFAULT 0 COMMENT 日志回复数, MODIFY COLUMN hot mediumint(8) unsigned NOT NULL DEFAULT 0 COMMENT 日志热度, MODIFY COLUMN dateline int(10) unsigned NOT NULL DEFAULT 0 COMMENT 日志产生时间戳, MODIFY COLUMN pic char(120) NOT NULL DEFAULT COMMENT 相

17、册标题图片, MODIFY COLUMN picflag tinyint(1) NOT NULL DEFAULT 0 COMMENT 日志是否有图片, MODIFY COLUMN noreply tinyint(1) NOT NULL DEFAULT 0 COMMENT 是否允许评论:0为允许,1为不允许, MODIFY COLUMN friend tinyint(1) NOT NULL DEFAULT 0 COMMENT 日志隐私设置:0为全站用户可见,1为全好友可见,2为仅指定的好友可见,3为仅自己可见,4为凭密码查看, MODIFY COLUMN password char(10) NO

18、T NULL DEFAULT COMMENT 日志密码, MODIFY COLUMN click_1 smallint(6) unsigned NOT NULL DEFAULT 0 COMMENT 路过表态数, MODIFY COLUMN click_2 smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 鸡蛋表态数, MODIFY COLUMN click_3 smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 鲜花表态数, MODIFY COLUMN click_4 smallint(5) unsign

19、ed NOT NULL DEFAULT 0 COMMENT 握手表态数, MODIFY COLUMN click_5 smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 累人表态数, ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT=用户日志表,存放用户日志标题等信息;- - Records of uchome_blog- - - Table structure for uchome_blogfield- -ALTER TABLE uchome_blogfield MODIFY COLUMN blogid medi

20、umint(8) unsigned NOT NULL DEFAULT 0 COMMENT 日志ID, MODIFY COLUMN uid mediumint(8) unsigned NOT NULL DEFAULT 0 COMMENT 日志所属用户ID, MODIFY COLUMN tag varchar(255) NOT NULL DEFAULT COMMENT 日志TAG, MODIFY COLUMN message mediumtext NOT NULL COMMENT 日志内容, MODIFY COLUMN postip varchar(20) NOT NULL DEFAULT COM

21、MENT 发表日志的IP, MODIFY COLUMN related text NOT NULL COMMENT 相关日志数据信息, MODIFY COLUMN relatedtime int(10) unsigned NOT NULL DEFAULT 0 COMMENT 相关日志产生时间戳, MODIFY COLUMN target_ids text NOT NULL COMMENT 允许查看日志的用户ID多个ID以,间隔, MODIFY COLUMN hotuser text NOT NULL COMMENT 参与热度的用户ID多个ID以,间隔, MODIFY COLUMN magicc

22、olor tinyint(3) NOT NULL DEFAULT 0 COMMENT 彩色灯道具, MODIFY COLUMN magicpaper tinyint(3) NOT NULL DEFAULT 0 COMMENT 信纸道具, MODIFY COLUMN magiccall tinyint(1) NOT NULL DEFAULT 0 COMMENT 互访卡道具, ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT=日志附加字段表,存放用户日志内容等信息;- - Records of uchome_blogfield- - - Table struct

23、ure for uchome_cache- -ALTER TABLE uchome_cache MODIFY COLUMN cachekey varchar(16) NOT NULL DEFAULT COMMENT 缓存键值, MODIFY COLUMN value mediumtext NOT NULL COMMENT 缓存值, MODIFY COLUMN mtime int(10) unsigned NOT NULL DEFAULT 0 COMMENT 缓存时间, ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT=缓存表,存放缓存信息;- - Recor

24、ds of uchome_cache- - - Table structure for uchome_class- -ALTER TABLE uchome_class MODIFY COLUMN classid mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT 分类ID, MODIFY COLUMN classname char(40) NOT NULL DEFAULT COMMENT 分类名, MODIFY COLUMN uid mediumint(8) unsigned NOT NULL DEFAULT 0 COMMENT 分类所属

25、用户ID, MODIFY COLUMN dateline int(10) unsigned NOT NULL DEFAULT 0 COMMENT 分类创建时间戳, ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT=分类表,存放分类信息;- - Records of uchome_class- - - Table structure for uchome_click- -ALTER TABLE uchome_click MODIFY COLUMN clickid smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 表态类型ID, MODIFY COLUMN name varchar(50) NOT NULL DEFAULT COMMENT 表态名称, MODIFY COLUMN icon varchar(100) NOT NULL DEFAULT COMMENT 表态图标, MODIFY COLUMN idtype varchar(15) NOT NULL DEFAULT COMMENT 表态类型:blogid日志,picid图片,tid话题, MODIFY COLUMN displayorder tinyint(3) unsigned NOT NUL