data.sql

mv 具体不是很清楚

  `config` text NOT NULL,
  `index_show` tinyint(1) NOT NULL default '0',
  `list_html` varchar(255) NOT NULL default '',
  `bencandy_html` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`fid`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;

#
# 导出表中的数据 `p8_mv_sort`
#

INSERT INTO `p8_mv_sort` (`fid`, `fup`, `name`, `class`, `sons`, `type`, `admin`, `list`, `listorder`, `passwd`, `logo`, `descrip`, `style`, `template`, `jumpurl`, `maxperpage`, `metakeywords`, `metadescription`, `allowcomment`, `allowpost`, `allowviewtitle`, `allowviewcontent`, `allowdownload`, `forbidshow`, `config`, `index_show`, `list_html`, `bencandy_html`) VALUES (1, 0, '小视频', 1, 2, 1, '', 0, 0, '', '', '', '', 'N;', '', 0, '', '', 0, '', '', '', '', 0, 'a:4:{s:11:"sonTitleRow";s:0:"";s:12:"sonTitleLeng";s:0:"";s:9:"cachetime";N;s:12:"sonListorder";s:1:"0";}', 0, '', '');
INSERT INTO `p8_mv_sort` (`fid`, `fup`, `name`, `class`, `sons`, `type`, `admin`, `list`, `listorder`, `passwd`, `logo`, `descrip`, `style`, `template`, `jumpurl`, `maxperpage`, `metakeywords`, `metadescription`, `allowcomment`, `allowpost`, `allowviewtitle`, `allowviewcontent`, `allowdownload`, `forbidshow`, `config`, `index_show`, `list_html`, `bencandy_html`) VALUES (2, 1, '明星视频', 2, 0, 0, '', 0, 0, '', '', '', '', 'N;', '', 0, '', '', 0, '', '', '', '', 0, 'a:4:{s:11:"sonTitleRow";s:0:"";s:12:"sonTitleLeng";s:0:"";s:9:"cachetime";N;s:12:"sonListorder";s:1:"0";}', 1, '', '');
INSERT INTO `p8_mv_sort` (`fid`, `fup`, `name`, `class`, `sons`, `type`, `admin`, `list`, `listorder`, `passwd`, `logo`, `descrip`, `style`, `template`, `jumpurl`, `maxperpage`, `metakeywords`, `metadescription`, `allowcomment`, `allowpost`, `allowviewtitle`, `allowviewcontent`, `allowdownload`, `forbidshow`, `config`, `index_show`, `list_html`, `bencandy_html`) VALUES (3, 1, '搞笑视频', 2, 0, 0, '', 0, 0, '', '', '', '', 'N;', '', 0, '', '', 0, '', '', '', '', 0, 'a:4:{s:11:"sonTitleRow";s:0:"";s:12:"sonTitleLeng";s:0:"";s:9:"cachetime";N;s:12:"sonListorder";s:1:"0";}', 1, '', '');

# --------------------------------------------------------

#
# 表的结构 `p8_mv_video`
#

DROP TABLE IF EXISTS `p8_mv_video`;
CREATE TABLE `p8_mv_video` (
  `id` mediumint(7) NOT NULL auto_increment,
  `title` varchar(100) NOT NULL default '',
  `albumid` mediumint(7) NOT NULL default '0',
  `albumname` varchar(50) NOT NULL default '',
  `fid` mediumint(7) NOT NULL default '0',
  `fname` varchar(50) NOT NULL default '',
  `info` tinyint(2) NOT NULL default '0',
  `hits` mediumint(7) NOT NULL default '0',
  `comments` mediumint(7) NOT NULL default '0',
  `posttime` int(10) NOT NULL default '0',
  `list` int(10) default NULL,
  `uid` mediumint(7) NOT NULL default '0',
  `username` varchar(30) NOT NULL default '',
  `author` varchar(30) NOT NULL default '',
  `titlecolor` varchar(15) NOT NULL default '',
  `fonttype` tinyint(1) NOT NULL default '0',
  `picurl` varchar(150) NOT NULL default '',
  `ispic` tinyint(1) NOT NULL default '0',
  `yz` tinyint(1) NOT NULL default '0',
  `yzer` varchar(30) NOT NULL default '',
  `yztime` int(10) NOT NULL default '0',
  `levels` tinyint(2) NOT NULL default '0',
  `levelstime` int(10) NOT NULL default '0',
  `keywords` varchar(100) NOT NULL default '',
  `jumpurl` varchar(150) NOT NULL default '',
  `iframeurl` varchar(150) NOT NULL default '',
  `style` varchar(15) NOT NULL default '',
  `head_tpl` varchar(150) NOT NULL default '',
  `main_tpl` varchar(150) NOT NULL default '',
  `foot_tpl` varchar(100) NOT NULL default '',
  `target` tinyint(1) NOT NULL default '0',
  `ishtml` tinyint(1) NOT NULL default '0',
  `ip` varchar(15) NOT NULL default '',
  `lastfid` mediumint(7) NOT NULL default '0',
  `money` mediumint(7) NOT NULL default '0',
  `buyuser` text NOT NULL,
  `passwd` varchar(32) NOT NULL default '',
  `editer` varchar(30) NOT NULL default '',
  `edittime` int(10) NOT NULL default '0',
  `begintime` int(10) NOT NULL default '0',
  `endtime` int(10) NOT NULL default '0',
  `content` text NOT NULL,
  `videourl` text NOT NULL,
  `isflv` tinyint(1) NOT NULL default '0',
  `config` text NOT NULL,
  `lastview` int(10) NOT NULL default '0',
  `forbidshow` tinyint(1) NOT NULL default '0',
  `playtype` enum('auto','avi','rm','swf','flv','mp3') NOT NULL default 'auto',
  PRIMARY KEY  (`id`),
  KEY `yz` (`yz`),
  KEY `fid` (`fid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# 导出表中的数据 `p8_mv_video`
#