PHPVOD 3.0 标准版数据字典

PHPVOD 3.0 标准版数据字典

CREATE TABLE `pv_advert` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '广告ID',
  `uid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
  `ckey` varchar(32) NOT NULL DEFAULT '' COMMENT '广告位置',
  `descrip` varchar(255) NOT NULL DEFAULT '' COMMENT '广告描述',
  `config` text NOT NULL COMMENT '广告数据',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM COMMENT='广告表';

CREATE TABLE `pv_artclass` (
  `cid` smallint(6) unsigned NOT NULL AUTO_INCREMENT COMMENT '文档类别ID',
  `caption` varchar(80) NOT NULL DEFAULT '' COMMENT '类别名称',
  `vieworder` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '显示顺序',
  PRIMARY KEY (`cid`)
) ENGINE=MyISAM COMMENT='文档类别表';

CREATE TABLE `pv_article` (
  `aid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '文档ID',
  `classid` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '类别ID',
  `author` char(20) NOT NULL DEFAULT '' COMMENT '发布人',
  `authorid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '发布人ID',
  `subject` varchar(255) NOT NULL DEFAULT '' COMMENT '文档标题',
  `content` mediumtext NOT NULL COMMENT '文档内容',
  `hits` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '浏览数',
  `vieworder` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '显示顺序',
  `timestamp` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '发布时间',
  PRIMARY KEY (`aid`)
) ENGINE=MyISAM COMMENT='文档表';

CREATE TABLE `pv_buy`  (
  `bid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `vid` mediumint(8) UNSIGNED NOT NULL DEFAULT 0 COMMENT '视频ID',
  `uid` mediumint(8) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用户ID',
  `timestamp` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '购买时间',
  PRIMARY KEY (`bid`),
  KEY `vid` (`vid`),
  KEY `uid` (`uid`)
) ENGINE=MyISAM COMMENT='视频购买表';

CREATE TABLE `pv_class` (
  `cid` smallint(6) unsigned NOT NULL AUTO_INCREMENT COMMENT '栏目ID',
  `cup` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '上级栏目ID',
  `lv` tinyint(2) NOT NULL DEFAULT '0' COMMENT '层级',
  `fathers` varchar(255) NOT NULL DEFAULT '' COMMENT '上层栏目ID',
  `caption` varchar(80) NOT NULL DEFAULT '' COMMENT '栏目名称',
  `vieworder` tinyint(3) NOT NULL DEFAULT '0' COMMENT '显示顺序',
  `type` enum('hidden','members','free') NOT NULL DEFAULT 'free' COMMENT '栏目类型',
  `orderway` enum('replier','hits','lastdate','postdate') NOT NULL DEFAULT 'postdate' COMMENT '排序依据',
  `orderasc` tinyint(1) NOT NULL DEFAULT '1' COMMENT '排序方式',
  `link` varchar(255) NOT NULL DEFAULT '' COMMENT '外部链接',
  `tplfile` varchar(255) NOT NULL DEFAULT '' COMMENT '列表页模板文件名',
  `read_tplfile` varchar(255) NOT NULL DEFAULT '' COMMENT '详情页模板文件名',
  `play_tplfile` varchar(255) NOT NULL DEFAULT '' COMMENT '播放页模板文件名',
  `atccheck` tinyint(1) NOT NULL DEFAULT '0' COMMENT '审核方式',
  `rvrcneed` int(11) NOT NULL DEFAULT '0' COMMENT '访问栏目所需威望',
  `moneyneed` int(11) NOT NULL DEFAULT '0' COMMENT '访问栏目所需金钱',
  `postneed` int(11) NOT NULL DEFAULT '0' COMMENT '访问栏目所需视频发布数',
  `password` char(32) NOT NULL DEFAULT '' COMMENT '栏目密码',
  `allowvisit` varchar(255) NOT NULL DEFAULT '' COMMENT '允许访问栏目的用户组',
  `allowplay` varchar(255) NOT NULL DEFAULT '' COMMENT '允许播放视频的用户组',
  `allowpost` varchar(255) NOT NULL DEFAULT '' COMMENT '允许发布视频的用户组',
  `allowrp` varchar(255) NOT NULL DEFAULT '' COMMENT '允许发布评论的用户组',
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT '页面标题',
  `keywords` varchar(255) NOT NULL DEFAULT '' COMMENT '页面关键词',
  `description` varchar(255) NOT NULL DEFAULT '' COMMENT '页面描述',
  PRIMARY KEY (`cid`),
  KEY `hup` (`cup`)
) ENGINE=MyISAM COMMENT='栏目表';

CREATE TABLE `pv_config` (
  `db_name` varchar(30) NOT NULL DEFAULT '' COMMENT '名称',
  `db_value` text NOT NULL COMMENT '值',
  `decrip` text NOT NULL COMMENT '描述',
  PRIMARY KEY (`db_name`)
) ENGINE=MyISAM COMMENT='全局配置表';

CREATE TABLE `pv_credits` (
  `cid` tinyint(3) unsigned NOT NULL AUTO_INCREMENT COMMENT '积分ID',
  `name` char(30) NOT NULL DEFAULT '' COMMENT '积分名称',
  `description` char(255) NOT NULL DEFAULT '' COMMENT '积分描述',
  PRIMARY KEY (`cid`)
) ENGINE=MyISAM COMMENT='自定义积分表';

CREATE TABLE `pv_extgroups`  (
  `uid` mediumint(8) UNSIGNED NOT NULL DEFAULT 0 COMMENT '会员ID',
  `groups` mediumtext NOT NULL COMMENT '扩展组列表',
  KEY `uid`(`uid`)
) ENGINE=MyISAM COMMENT='扩展组表';

CREATE TABLE `pv_favorite`  (
  `fid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `vid` mediumint(8) UNSIGNED NOT NULL DEFAULT 0 COMMENT '视频ID',
  `uid` mediumint(8) UNSIGNED NOT NULL DEFAULT 0 COMMENT '会员ID',
  `timestamp` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '收藏时间',
  PRIMARY KEY (`fid`),
  KEY `vid`(`vid`),
  KEY `uid`(`uid`)
) ENGINE=MyISAM COMMENT='视频收藏表';

CREATE TABLE `pv_hack` (
  `hid` smallint(6) unsigned NOT NULL AUTO_INCREMENT COMMENT '插件ID',
  `name` varchar(100) NOT NULL DEFAULT '' COMMENT '插件名称',
  `directory` varchar(100) NOT NULL DEFAULT '' COMMENT '插件目录',
  `hidden` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否启用',
  `spos` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '前台显示位置',
  `listener` varchar(255) NOT NULL DEFAULT '' COMMENT '监听器路径',
  `version` varchar(100) NOT NULL DEFAULT '' COMMENT '版本号',
  PRIMARY KEY (`hid`)
) ENGINE=MyISAM COMMENT='插件表';

CREATE TABLE `pv_hackvar` (
  `hk_name` varchar(30) NOT NULL DEFAULT '' COMMENT '名称',
  `hk_value` text NOT NULL COMMENT '值',
  `decrip` text NOT NULL COMMENT '描述',
  PRIMARY KEY (`hk_name`)
) ENGINE=MyISAM COMMENT='插件配置表';

CREATE TABLE `pv_listener`  (
  `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `file` varchar(255) NOT NULL DEFAULT '' COMMENT '监听器路径',
  `callorder` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT '执行顺序',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM COMMENT='监听器配置表';

CREATE TABLE `pv_membercredit` (
  `uid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
  `cid` tinyint(3) NOT NULL DEFAULT '0' COMMENT '积分ID',
  `value` mediumint(8) NOT NULL DEFAULT '0' COMMENT '积分数',
  KEY `uid` (`uid`),
  KEY `cid` (`cid`)
) ENGINE=MyISAM COMMENT='会员积分表';

CREATE TABLE `pv_memberdata` (
  `uid` mediumint(8) unsigned NOT NULL DEFAULT '1' COMMENT '用户ID',
  `postnum` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '视频发布数',
  `rvrc` int(10) NOT NULL DEFAULT '0' COMMENT '威望',
  `money` int(10) NOT NULL DEFAULT '0' COMMENT '金钱',
  `onlineip` char(30) NOT NULL DEFAULT '' COMMENT '最后登录IP',
  PRIMARY KEY (`uid`)
) ENGINE=MyISAM COMMENT='会员数据表';

CREATE TABLE `pv_memberinfo`  (
  `uid` mediumint(8) UNSIGNED NOT NULL DEFAULT 1 COMMENT '会员ID',
  `adsips` mediumtext NOT NULL COMMENT '宣传推广用户IP列表',
  PRIMARY KEY (`uid`)
) ENGINE=MyISAM COMMENT='会员相关资料表';

CREATE TABLE `pv_members` (
  `uid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `ucuid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'UCenter用户ID',
  `username` varchar(20) NOT NULL DEFAULT '' COMMENT '用户名',
  `password` varchar(40) NOT NULL DEFAULT '' COMMENT '密码',
  `email` varchar(60) NOT NULL DEFAULT '' COMMENT '邮箱',
  `publicmail` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否公开邮箱',
  `groupid` smallint(6) NOT NULL DEFAULT '-1' COMMENT '系统组ID',
  `memberid` smallint(6) NOT NULL DEFAULT '0' COMMENT '用户组ID',
  `groupexpiry` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户组过期时间',
  `togid` smallint(6) NOT NULL DEFAULT '-1' COMMENT '过期后的用户组ID',
  `icon` varchar(100) NOT NULL DEFAULT 'none.gif' COMMENT '头像',
  `gender` tinyint(1) NOT NULL DEFAULT '0' COMMENT '性别',
  `regdate` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '注册时间',
  `signature` varchar(255) NOT NULL DEFAULT '' COMMENT '签名',
  `oicq` varchar(12) NOT NULL DEFAULT '' COMMENT '腾讯QQ',
  `msn` varchar(35) NOT NULL DEFAULT '' COMMENT 'MSN',
  `site` varchar(75) NOT NULL DEFAULT '' COMMENT '个人主页',
  `honor` varchar(30) NOT NULL DEFAULT '' COMMENT '自定义头衔',
  `bday` varchar(10) NOT NULL DEFAULT '' COMMENT '出生年月',
  `receivemail` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否接收系统邮件',
  `yz` int(10) NOT NULL DEFAULT '1' COMMENT '审核状态',
  `newpm` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否有未阅读的短消息',
  PRIMARY KEY (`uid`),
  KEY `username` (`username`),
  KEY `groupid` (`groupid`)
) ENGINE=MyISAM COMMENT='会员信息表';

CREATE TABLE `pv_msg` (
  `mid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '短消息ID',
  `type` enum('rebox','sebox','public') NOT NULL DEFAULT 'rebox' COMMENT '短消息类型',
  `touid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '收件人',
  `fromuid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '发件人',
  `username` varchar(15) NOT NULL DEFAULT '' COMMENT '发件人用户名',
  `ifnew` tinyint(1) NOT NULL DEFAULT '0' COMMENT '短消息是否已阅读',
  `title` varchar(130) NOT NULL DEFAULT '' COMMENT '标题',
  `content` mediumtext NOT NULL COMMENT '内容',
  `mdate` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '发送时间',
  PRIMARY KEY (`mid`),
  KEY `touid` (`touid`),
  KEY `fromuid` (`fromuid`)
) ENGINE=MyISAM COMMENT='短消息表';

CREATE TABLE `pv_nations` (
  `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `subject` char(20) NOT NULL DEFAULT '' COMMENT '名称',
  `vieworder` smallint(6) NOT NULL DEFAULT '0' COMMENT '显示顺序',
  PRIMARY KEY (`id`),
  KEY `subject` (`subject`)
) ENGINE=MyISAM COMMENT='国家地区表';

CREATE TABLE `pv_player` (
  `pid` smallint(6) unsigned NOT NULL AUTO_INCREMENT COMMENT '播放器ID',
  `name` char(50) NOT NULL DEFAULT '' COMMENT '播放器名称',
  `subject` char(100) NOT NULL DEFAULT '' COMMENT '描述',
  `playpath` char(100) NOT NULL DEFAULT '' COMMENT '播放器文件名',
  `hidden` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否启用',
  PRIMARY KEY (`pid`)
) ENGINE=MyISAM COMMENT='播放器表';

CREATE TABLE `pv_reply` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `vid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '视频ID',
  `author` varchar(50) NOT NULL DEFAULT '' COMMENT '发布人',
  `authorid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '发布人ID',
  `postdate` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '发布时间',
  `top` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '顶',
  `down` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '踩',
  `content` mediumtext NOT NULL COMMENT '评论内容',
  `yz` tinyint(1) NOT NULL DEFAULT '1' COMMENT '审核状态',
  PRIMARY KEY (`id`),
  KEY `vid` (`vid`)
) ENGINE=MyISAM COMMENT='视频评论表';

CREATE TABLE `pv_report` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `vid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '视频ID',
  `uid` mediumint(8) NOT NULL DEFAULT '0' COMMENT '用户ID',
  `type` char(255) NOT NULL DEFAULT '0' COMMENT '举报类型',
  `reason` char(255) NOT NULL DEFAULT '' COMMENT '举报原因',
  PRIMARY KEY (`id`),
  KEY `type` (`type`)
) ENGINE=MyISAM COMMENT='视频举报表';

CREATE TABLE `pv_sharelinks` (
  `sid` smallint(6) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `threadorder` tinyint(3) NOT NULL DEFAULT '0' COMMENT '显示顺序',
  `name` char(100) NOT NULL DEFAULT '' COMMENT '网站名称',
  `url` char(100) NOT NULL DEFAULT '' COMMENT '网站URL',
  `descrip` char(200) NOT NULL DEFAULT '0' COMMENT '网站说明',
  `logo` char(100) NOT NULL DEFAULT '' COMMENT '网站LOGO',
  PRIMARY KEY (`sid`)
) ENGINE=MyISAM COMMENT='友情链接表';

CREATE TABLE `pv_styles` (
  `sid` smallint(6) unsigned NOT NULL AUTO_INCREMENT COMMENT '风格ID',
  `name` char(50) NOT NULL DEFAULT '' COMMENT '风格名称',
  `stylepath` char(50) NOT NULL DEFAULT '' COMMENT '图片目录名',
  `tplpath` char(50) NOT NULL DEFAULT '' COMMENT '模板目录名',
  PRIMARY KEY (`sid`)
) ENGINE=MyISAM COMMENT='模板风格配置表';

CREATE TABLE `pv_urls` (
  `uid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `vid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '视频ID',
  `pid` smallint(6) NOT NULL DEFAULT '1' COMMENT '播放器ID',
  `url` text NOT NULL COMMENT '播放地址',
  `playgroup` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '播放组',
  PRIMARY KEY (`uid`),
  KEY `vid` (`vid`)
) ENGINE=MyISAM COMMENT='视频播放地址表';

CREATE TABLE `pv_usergroups` (
  `gid` smallint(6) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户组ID',
  `gptype` enum('default','member','system') NOT NULL DEFAULT 'member' COMMENT '用户组类型',
  `grouptitle` varchar(60) NOT NULL DEFAULT '' COMMENT '用户组名称',
  `groupimg` varchar(15) NOT NULL DEFAULT '' COMMENT '用户组图片',
  `grouppost` int(10) NOT NULL DEFAULT '0' COMMENT '升级所需点数',
  `maxmsg` int(10) NOT NULL DEFAULT '10' COMMENT '最大短消息数目',
  `allowread` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许浏览视频',
  `allowrp` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许发布评论',
  `allowhonor` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许自定义头衔',
  `alloweditatc` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许编辑自己发布的影片',
  `allowdelatc` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许删除自己发布的影片',
  `allowpost` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许发布影片',
  `allowmessage` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许发送短消息',
  `allowplay` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许播放影片',
  `allowplayvip` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否允许播放收费视频',  
  `atccheck` tinyint(1) NOT NULL DEFAULT '0' COMMENT '发布的影片是否需要管理员审核',
  `rpcheck` tinyint(1) NOT NULL DEFAULT '0' COMMENT '发布的评论是否需要管理员审核',
  `allowprofile` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许查看会员资料',
  `allowseticon` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许用户使用自定义头像',
  `allowupicon` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许用户使用头像上传功能',
  `allowsell` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许用户发布出售影片',
  `allowbuy` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户组是否允许购买',
  `selltype` varchar(60) NOT NULL DEFAULT '' COMMENT '购买币种',
  `sellprice` smallint(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT '每日价格',
  `selllimit` smallint(5) UNSIGNED NOT NULL DEFAULT '1' COMMENT '购买天数限制',
  `sellinfo` varchar(255) NOT NULL DEFAULT '' COMMENT '购买描述', 
  `ifdefault` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否采用默认用户组权限',
  `allowadmincp` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许进后台',
  `allowadminedit` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许编辑视频',
  `allowadmindel` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许删除视频',
  `allowadminshow` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许浏览未审核的视频',
  `permissions` text NOT NULL COMMENT '后台权限列表',
  PRIMARY KEY (`gid`),
  KEY `gptype` (`gptype`),
  KEY `grouppost` (`grouppost`)
) ENGINE=MyISAM COMMENT='用户组表';

CREATE TABLE `pv_video` (
  `vid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '视频ID',
  `cid` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '栏目ID',
  `nid` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '国家地区ID',
  `type` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '视频类型(收费/普通)',
  `author` char(20) NOT NULL DEFAULT '' COMMENT '发布人',
  `authorid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '发布人ID',
  `postdate` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '发布时间',
  `lastdate` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后更新时间',
  `subject` char(100) NOT NULL DEFAULT '' COMMENT '视频标题',
  `picserver` varchar(255) NOT NULL DEFAULT '' COMMENT '视频图片远程地址',
  `picfolder` char(50) NOT NULL DEFAULT '' COMMENT '视频图片所在目录',
  `pic` char(100) NOT NULL DEFAULT '' COMMENT '视频图片',
  `playactor` char(30) NOT NULL DEFAULT '' COMMENT '演员',
  `director` char(30) NOT NULL DEFAULT '' COMMENT '导演',
  `tag` char(100) NOT NULL DEFAULT '' COMMENT '标签',
  `year` char(10) NOT NULL DEFAULT '' COMMENT '年代',
  `best` tinyint(1) NOT NULL DEFAULT '0' COMMENT '推荐类型',
  `serialise` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '连载状态',
  `memo` char(100) CHARACTER SET gbk NOT NULL COMMENT '备注',
  `reply` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '评论数',
  `sale` char(30) NOT NULL DEFAULT '' COMMENT '视频出售',
  `hits` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '点击数',
  `yesterday_hits` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '昨日点击数',
  `day_hits` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '今日点击数',
  `week_hits` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '本周点击数',
  `month_hits` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '本月点击数',
  `hits_update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后访问时间',
  `usernth` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '参与投票人数',
  `fraction` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '总得分',
  `star` float(10,1) unsigned NOT NULL DEFAULT '0.0' COMMENT '平均分',
  `yz` tinyint(1) NOT NULL DEFAULT '1' COMMENT '审核状态',
  PRIMARY KEY (`vid`),
  KEY `bid` (`cid`),
  KEY `nid` (`nid`)
) ENGINE=MyISAM COMMENT='视频信息表';

CREATE TABLE `pv_videodata` (
  `vid` mediumint(8) unsigned NOT NULL COMMENT '视频ID',
  `synopsis` mediumtext NOT NULL COMMENT '视频简介',
  PRIMARY KEY (`vid`)
) ENGINE=MyISAM COMMENT='视频数据表';

results for ""

    No results matching ""