uchome数据库字典

题等信息';

-- ---------------------------- -- Records of uchome_blog -- ----------------------------

-- ----------------------------

-- Table structure for `uchome_blogfield` -- ----------------------------

ALTER TABLE `uchome_blogfield`

MODIFY COLUMN `blogid` mediumint(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 '' COMMENT '发表日志的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 `magiccolor` 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 structure 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='缓存表,存放缓存信息';

-- ---------------------------- -- Records 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 '分类所属用户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 NULL DEFAULT '0' COMMENT '表态顺序',

ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COMMENT='表态类型表';

-- ---------------------------- -- Records of uchome_click -- ----------------------------

-- ----------------------------

-- Table structure for `uchome_clickuser` -- ----------------------------

ALTER TABLE `uchome_clickuser`

MODIFY COLUMN `uid` mediumint(8) unsigned NOT NULL DEFAULT '0', MODIFY COLUMN `username` varchar(15) NOT NULL DEFAULT '',

MODIFY COLUMN `id` mediumint(8) unsigned NOT NULL DEFAULT '0', MODIFY COLUMN `idtype` varchar(15) NOT NULL DEFAULT '',

MODIFY COLUMN `clickid` smallint(6) unsigned NOT NULL DEFAULT '0', MODIFY COLUMN `dateline` int(10) unsigned NOT NULL DEFAULT '0', ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='表态用户表';

-- ----------------------------

-- Records of uchome_clickuser -- ----------------------------

-- ----------------------------

-- Table structure for `uchome_comment` -- ----------------------------

ALTER TABLE `uchome_comment`

MODIFY COLUMN `cid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '评论ID',

MODIFY COLUMN `uid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',

MODIFY COLUMN `id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID或者日志ID,或者图片ID,或者分享ID',

MODIFY COLUMN `idtype` varchar(20) NOT NULL DEFAULT '' COMMENT '评论类型:''uid''为留言,''picid''为图片评论,''blogid''为日志评论,''sid''为分享评论',

MODIFY COLUMN `authorid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '若为回复,回复作者用户ID',

MODIFY COLUMN `author` varchar(15) NOT NULL DEFAULT '' COMMENT '若为回复,回复作者用户名',

MODIFY COLUMN `ip` varchar(20) NOT NULL DEFAULT '' COMMENT '评论IP',

MODIFY COLUMN `dateline` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '评论时间戳',

MODIFY COLUMN `message` text NOT NULL COMMENT '评论内容',

MODIFY COLUMN `magicflicker` tinyint(1) NOT NULL DEFAULT '0' COMMENT '彩虹炫道具',

ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='评论回复留言信息表,存放用户留言,评论,回复';

-- ----------------------------

-- Records of uchome_comment

-- ----------------------------

-- ----------------------------

-- Table structure for `uchome_config` -- ----------------------------

ALTER TABLE `uchome_config`

MODIFY COLUMN `var` varchar(30) NOT NULL DEFAULT '' COMMENT '配置变量', MODIFY COLUMN `datavalue` text NOT NULL COMMENT '配置变量值',

ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='站点配置信息表,存放站点配置信息';

-- ---------------------------- -- Records of uchome_config -- ----------------------------

-- ----------------------------

-- Table structure for `uchome_creditlog` -- ----------------------------

ALTER TABLE `uchome_creditlog`

MODIFY COLUMN `clid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,

MODIFY COLUMN `uid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',

MODIFY COLUMN `rid` mediumint(8) unsigned NOT NULL DEFAULT '0', MODIFY COLUMN `total` mediumint(8) unsigned NOT NULL DEFAULT '0',

MODIFY COLUMN `cyclenum` mediumint(8) unsigned NOT NULL DEFAULT '0', MODIFY COLUMN `credit` mediumint(8) unsigned NOT NULL DEFAULT '0',

MODIFY COLUMN `experience` mediumint(8) unsigned NOT NULL DEFAULT '0', MODIFY COLUMN `starttime` int(10) unsigned NOT NULL DEFAULT '0', MODIFY COLUMN `info` text NOT NULL, MODIFY COLUMN `user` text NOT NULL, MODIFY COLUMN `app` text NOT NULL,

MODIFY COLUMN `dateline` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '时间戳',

ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COMMENT='积分记录表';

-- ----------------------------

-- Records of uchome_creditlog -- ----------------------------

-- ----------------------------

-- Table structure for `uchome_creditrule` -- ----------------------------

ALTER TABLE `uchome_creditrule`