-- PHPDisk SQL Dump
-- version 6.0.0 T-Core
-- http://www.phpdisk.com/
--

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- 数据库: `phpdisk`
--

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

--
-- 表的结构 `pd_adminsession`
--

DROP TABLE IF EXISTS `pd_adminsession`;
CREATE TABLE IF NOT EXISTS `pd_adminsession` (
  `id` tinyint(3) unsigned NOT NULL auto_increment,
  `userid` int(10) unsigned NOT NULL default '0',
  `login_time` int(10) unsigned NOT NULL default '0',
  `hashcode` char(9) NOT NULL,
  `ip` varchar(15) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- 导出表中的数据 `pd_adminsession`
--


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

--
-- 表的结构 `pd_advertisements`
--

DROP TABLE IF EXISTS `pd_advertisements`;
CREATE TABLE IF NOT EXISTS `pd_advertisements` (
  `advid` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(255) NOT NULL,
  `adv_type` varchar(30) NOT NULL,
  `adv_position` varchar(50) NOT NULL,
  `params` text NOT NULL,
  `code` text NOT NULL,
  `show_order` tinyint(3) unsigned NOT NULL default '0',
  `starttime` int(10) unsigned NOT NULL default '0',
  `endtime` int(10) unsigned NOT NULL default '0',
  `is_hidden` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`advid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- 导出表中的数据 `pd_advertisements`
--


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

--
-- 表的结构 `pd_announces`
--

DROP TABLE IF EXISTS `pd_announces`;
CREATE TABLE IF NOT EXISTS `pd_announces` (
  `annid` mediumint(8) unsigned NOT NULL auto_increment,
  `userid` int(10) unsigned NOT NULL default '0',
  `subject` varchar(100) NOT NULL,
  `content` text NOT NULL,
  `show_order` tinyint(1) unsigned NOT NULL default '0',
  `is_hidden` tinyint(1) unsigned NOT NULL default '0',
  `is_expand` tinyint(1) unsigned NOT NULL default '0',
  `in_time` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`annid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

--
-- 导出表中的数据 `pd_announces`
--

INSERT INTO `pd_announces` (`annid`, `userid`, `subject`, `content`, `show_order`, `is_hidden`, `is_expand`, `in_time`) VALUES
(2, 1, 'PHPDISK v5.1 新增功能与修正列表', '[新增]分布式服务器管理员可自行添加ID作为FTP与文件的对应标识。<br>[新增]公共文件,缩短地址，网盘文件的直接显示外链地址。<br>[新增]如果是共享文件/公共文件，点击后有下载页面，私人文件直接下载。<br>[新增]文件管理添加目录显示。<br>[新增]充值选项，自动转化为积分。<br>[新增]MYSQL数据库类提交错误时，输入email，处理完发邮件通知用户。<br>[修正]整合，在linux下无法整合UC，通信不成功问题。<br>[修正]GBK上传添加描述、标签出现乱码问题。<br>[修正]Mysql类出错时在linux主机下的目录问题。<br>[修正]只能设置为共享的文件才能使用提取码功能。<br>[修正]使用代码广告会令页面不断跳转。', 0, 0, 1, 1286171569),
(3, 1, 'PHPDISK 5.3.0新增功能与改进', '[新增]支持PHPWIND论坛整合。<br>[新增]新增几种广告管理，让管理员更好的投放广告。<br>[新增]支持常用的文件在线浏览，如mp3播放，flash播放等支持。<br>[新增]PHPDISK可实现在线检测自动升级，比起传统手动升级更加便捷。<br>[新增]标题排序，用户可以直接点击表头，对网盘中的文件进行排序，如，按大小、按日期等。<br>[新增]引入用户经验等级模式，用户使用网盘，帐号会自动升级。<br>[新增]增加首页幻灯片展示效果，可以让网盘更具个性效果。<br>[新增]用户充值方式支持使用网银接口与易宝支付接口。<br>[修正]公告模式的改进，阅读、显示更加人性化。<br>[修正]改进结构系统布局UI，引入更华丽的ajax效果，大大提升用户交互体验。<br>[修正]在生成外链的[img]代码直接变成&lt;IMG src=""&gt;  代码，多一种模式的显示。<br>[修正]修正UCenter整合时出现用户重复记录问题。<br>[修正]修正搜索引擎直接收录文件问题，而不能通过文件展示页下载的问题。<br>[修正]分布服务器插件，可支持子程序配置，同时可支持FTP中转上传与子程序直接上传的形式。大大减少主服务器资源消耗。<br>[修正]外链，提取码等可由管理员设定，后台使用了大部分的开关形式。<br>[修正]SEO插件nginx修正。<br>[修正]移动文件到二级公共文件时文件无法显示问题。<br>[修正]管理员后台更加精细的分类。<br>[修正]修正公共文件显示文件空间不正确问题。', 0, 0, 0, 1288057490),
(4, 1, 'PHPDisk 6.0.0 T-Core系列', '[增加]客户端整合支持，可以使用客户端上传下载文件。<br>[增加]用户注册审核机制。<br>[增加]网盘面板语言包切换功能。<br>[增加]管理员可以通过后台补单的方式对一些充值有问题的订单修复。<br>[优化]优化系统代码缓存功能（增强版），使用此缓存可以达到静态化访问类似的效果，可以大幅提升网盘运行速度，大大降低对数据库的压力。据测试，至少可以提升3倍以上的运行速度（重点）。<br>[修正]支付接口修正，更有效、人性化的统计。<br><br>[修正]其他已知BUG修正', 0, 0, 0, 1306468034);

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

--
-- 表的结构 `pd_buddys`
--

DROP TABLE IF EXISTS `pd_buddys`;
CREATE TABLE IF NOT EXISTS `pd_buddys` (
  `bdid` int(11) unsigned NOT NULL auto_increment,
  `userid` int(10) unsigned NOT NULL default '0',
  `touserid` int(10) unsigned NOT NULL default '0',
  `in_time` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`bdid`),
  KEY `userid` (`userid`),
  KEY `touserid` (`touserid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- 导出表中的数据 `pd_buddys`
--


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

--
-- 表的结构 `pd_categories`
--

DROP TABLE IF EXISTS `pd_categories`;
CREATE TABLE IF NOT EXISTS `pd_categories` (
  `cate_id` int(10) unsigned NOT NULL auto_increment,
  `pid` int(10) unsigned NOT NULL default '0',
  `cate_name` varchar(50) NOT NULL,
  `cate_size` int(10) unsigned NOT NULL default '0',
  `show_order` tinyint(3) unsigned NOT NULL default '0',
  `is_hidden` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`cate_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

--
-- 导出表中的数据 `pd_categories`
--

INSERT INTO `pd_categories` (`cate_id`, `pid`, `cate_name`, `cate_size`, `show_order`, `is_hidden`) VALUES
(1, 0, 'hhhdg', 1070310, 0, 0),
(2, 3, 'bbb', 1340996, 0, 0),
(3, 0, 'hhh32', 655, 0, 0),
(4, 0, 'test', 0, 0, 0);

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

--
-- 表的结构 `pd_comments`
--

DROP TABLE IF EXISTS `pd_comments`;
CREATE TABLE IF NOT EXISTS `pd_comments` (
  `cmt_id` int(10) unsigned NOT NULL auto_increment,
  `file_id` bigint(20) unsigned NOT NULL default '0',
  `file_key` char(8) NOT NULL,
  `content` text NOT NULL,
  `userid` int(10) unsigned NOT NULL default '0',
  `is_checked` tinyint(1) unsigned NOT NULL default '0',
  `in_time` int(10) unsigned NOT NULL default '0',
  `ip` varchar(15) NOT NULL,
  PRIMARY KEY  (`cmt_id`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- 导出表中的数据 `pd_comments`
--


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

--
-- 表的结构 `pd_cp_shortcut`
--

DROP TABLE IF EXISTS `pd_cp_shortcut`;
CREATE TABLE IF NOT EXISTS `pd_cp_shortcut` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `url` varchar(255) NOT NULL,
  `title` varchar(50) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- 导出表中的数据 `pd_cp_shortcut`
--


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

--
-- 表的结构 `pd_datacalls`
--

DROP TABLE IF EXISTS `pd_datacalls`;
CREATE TABLE IF NOT EXISTS `pd_datacalls` (
  `dcid` int(10) unsigned NOT NULL auto_increment,
  `c_key` varchar(255) NOT NULL,
  `c_value` mediumtext NOT NULL,
  PRIMARY KEY  (`dcid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- 导出表中的数据 `pd_datacalls`
--


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

--
-- 表的结构 `pd_disk2user`
--

DROP TABLE IF EXISTS `pd_disk2user`;
CREATE TABLE IF NOT EXISTS `pd_disk2user` (
  `duid` int(11) unsigned NOT NULL auto_increment,
  `userid` int(10) unsigned NOT NULL default '0',
  `disk_id` mediumint(8) unsigned NOT NULL default '0',
  `starttime` int(10) unsigned NOT NULL default '0',
  `endtime` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`duid`),
  KEY `userid` (`userid`),
  KEY `diskid` (`disk_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- 导出表中的数据 `pd_disk2user`
--


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

--
-- 表的结构 `pd_disks`
--

DROP TABLE IF EXISTS `pd_disks`;
CREATE TABLE IF NOT EXISTS `pd_disks` (
  `disk_id` mediumint(8) unsigned NOT NULL auto_increment,
  `title` varchar(100) NOT NULL,
  `logo` varchar(250) NOT NULL,
  `space` varchar(50) NOT NULL,
  `price` int(10) unsigned NOT NULL default '0',
  `expire` smallint(5) unsigned NOT NULL default '0',
  `show_order` tinyint(1) unsigned NOT NULL default '0',
  `is_hidden` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`disk_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- 导出表中的数据 `pd_disks`
--



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

--
-- 表的结构 `pd_extracts`
--

DROP TABLE IF EXISTS `pd_extracts`;
CREATE TABLE IF NOT EXISTS `pd_extracts` (
  `extract_id` int(10) unsigned NOT NULL auto_increment,
  `userid` int(10) unsigned NOT NULL default '0',
  `extract_code` varchar(16) NOT NULL,
  `extract_file_ids` text NOT NULL,
  `extract_total` smallint(5) unsigned NOT NULL default '0',
  `extract_count` smallint(5) unsigned NOT NULL default '0',
  `extract_time` int(10) unsigned NOT NULL default '0',
  `extract_type` tinyint(1) unsigned NOT NULL default '0',
  `extract_locked` tinyint(1) unsigned NOT NULL default '0',
  `in_time` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`extract_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- 导出表中的数据 `pd_extracts`
--


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

--
-- 表的结构 `pd_file2tag`
--

DROP TABLE IF EXISTS `pd_file2tag`;
CREATE TABLE IF NOT EXISTS `pd_file2tag` (
  `ftid` int(11) unsigned NOT NULL auto_increment,
  `tag_name` varchar(30) NOT NULL,
  `file_id` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`ftid`),
  KEY `tag_name` (`tag_name`),
  KEY `file_id` (`file_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- 导出表中的数据 `pd_file2tag`
--


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

--
-- 表的结构 `pd_files`
--

DROP TABLE IF EXISTS `pd_files`;
CREATE TABLE IF NOT EXISTS `pd_files` (
  `file_id` bigint(20) unsigned NOT NULL auto_increment,
  `file_name` varchar(100) NOT NULL,
  `file_key` char(8) NOT NULL,
  `file_short_url` char(6) NOT NULL,
  `file_extension` varchar(10) NOT NULL,
  `is_image` tinyint(1) unsigned NOT NULL default '0',
  `file_mime` varchar(50) NOT NULL,
  `file_description` text NOT NULL,
  `file_store_path` char(10) NOT NULL,
  `file_real_name` char(32) NOT NULL,
  `file_md5` char(32) NOT NULL,
  `server_oid` smallint(5) unsigned NOT NULL default '0',
  `file_size` int(10) unsigned NOT NULL default '0',
  `thumb_size` int(10) unsigned NOT NULL default '0',
  `file_time` int(10) unsigned NOT NULL default '0',
  `file_views` int(10) unsigned default '0',
  `file_downs` int(10) unsigned NOT NULL default '0',
  `file_last_view` int(10) unsigned default '0',
  `file_credit` tinyint(2) unsigned NOT NULL default '0',
  `report_status` tinyint(1) unsigned NOT NULL default '0',
  `in_share` tinyint(1) unsigned NOT NULL default '0',
  `space_pos` tinyint(1) unsigned NOT NULL default '0',
  `good_count` mediumint(8) unsigned NOT NULL default '0',
  `bad_count` mediumint(8) unsigned NOT NULL default '0',
  `is_locked` tinyint(1) unsigned NOT NULL default '0',
  `is_checked` tinyint(1) unsigned NOT NULL default '0',
  `is_public` tinyint(1) unsigned NOT NULL default '0',
  `userid` int(10) unsigned NOT NULL default '0',
  `folder_id` bigint(20) NOT NULL default '0',
  `cate_id` int(10) unsigned NOT NULL default '0',
  `subcate_id` int(10) unsigned NOT NULL default '0',
  `in_recycle` tinyint(1) unsigned NOT NULL default '0',
  `ip` varchar(15) NOT NULL,
  PRIMARY KEY  (`file_id`),
  KEY `userid` (`userid`),
  KEY `folder_id` (`folder_id`),
  KEY `server_id` (`server_oid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- 导出表中的数据 `pd_files`
--


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

--
-- 表的结构 `pd_folders`
--

DROP TABLE IF EXISTS `pd_folders`;
CREATE TABLE IF NOT EXISTS `pd_folders` (
  `folder_id` bigint(20) unsigned NOT NULL auto_increment,
  `parent_id` bigint(20) NOT NULL default '0',
  `folder_node` tinyint(1) unsigned NOT NULL default '0',
  `folder_name` varchar(50) NOT NULL,
  `folder_description` varchar(255) NOT NULL,
  `in_recycle` tinyint(1) unsigned NOT NULL default '0',
  `in_share` tinyint(1) unsigned NOT NULL default '0',
  `folder_order` smallint(5) unsigned NOT NULL default '0',
  `folder_size` int(10) unsigned NOT NULL default '0',
  `userid` int(10) unsigned NOT NULL default '0',
  `in_time` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`folder_id`),
  KEY `userid` (`userid`),
  KEY `parent_id` (`parent_id`),
  KEY `folder_node` (`folder_node`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- 导出表中的数据 `pd_folders`
--


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

--
-- 表的结构 `pd_gallery`
--

DROP TABLE IF EXISTS `pd_gallery`;
CREATE TABLE IF NOT EXISTS `pd_gallery` (
  `gal_id` int(10) unsigned NOT NULL auto_increment,
  `gal_path` varchar(200) NOT NULL,
  `gal_title` varchar(150) NOT NULL,
  `go_url` varchar(200) NOT NULL,
  `gal_target` varchar(10) NOT NULL,
  `show_order` tinyint(1) unsigned NOT NULL default '0',
  `is_hidden` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`gal_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- 导出表中的数据 `pd_gallery`
--

INSERT INTO `pd_gallery` (`gal_id`, `gal_path`, `gal_title`, `go_url`, `gal_target`, `show_order`, `is_hidden`) VALUES
(1, 'images/01.jpg', '丰富的插件、模板下载，满足您全方位的需求。', 'http://www.phpdisk.com/store.html', '_blank', 0, 0),
(2, 'images/02.jpg', '全新架构，重构内核，PHPDISK v6.0.0全面启动', 'http://bbs.phpdisk.com/', '_blank', 0, 0);

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

--
-- 表的结构 `pd_groups`
--

DROP TABLE IF EXISTS `pd_groups`;
CREATE TABLE IF NOT EXISTS `pd_groups` (
  `gid` tinyint(3) unsigned NOT NULL,
  `group_type` tinyint(1) unsigned NOT NULL default '0',
  `group_name` varchar(50) NOT NULL,
  `max_messages` tinyint(3) unsigned NOT NULL default '0',
  `max_flow_down` varchar(20) NOT NULL default '0',
  `max_flow_view` varchar(20) NOT NULL default '0',
  `max_storage` varchar(20) NOT NULL default '0',
  `group_file_types` varchar(150) NOT NULL,
  `max_filesize` varchar(20) NOT NULL default '0',
  `max_folders` int(10) unsigned NOT NULL default '0',
  `max_files` int(10) unsigned NOT NULL default '0',
  `can_share` tinyint(1) unsigned NOT NULL default '0',
  `secs_loading` smallint(5) unsigned NOT NULL default '0',
  `server_ids` varchar(30) NOT NULL,
  PRIMARY KEY  (`gid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 导出表中的数据 `pd_groups`
--

INSERT INTO `pd_groups` (`gid`, `group_type`, `group_name`, `max_messages`, `max_flow_down`, `max_flow_view`, `max_storage`, `group_file_types`, `max_filesize`, `max_folders`, `max_files`, `can_share`, `secs_loading`, `server_ids`) VALUES
(1, 1, '系统管理员', 0, '0', '0', '0', '', '0', 0, 0, 1, 5, '0'),
(2, 1, 'VIP会员', 0, '10g', '20g', '0', '', '1m', 0, 0, 1, 0, '0'),
(3, 1, '高级会员', 0, '0', '0', '0', '', '0', 0, 0, 1, 0, '1'),
(4, 1, '普通会员', 0, '0', '0', '0', '', '0', 0, 0, 1, 0, '1');

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

--
-- 表的结构 `pd_invitelog`
--

DROP TABLE IF EXISTS `pd_invitelog`;
CREATE TABLE IF NOT EXISTS `pd_invitelog` (
  `bdid` int(10) unsigned NOT NULL auto_increment,
  `userid` int(10) unsigned NOT NULL default '0',
  `touserid` int(10) unsigned NOT NULL default '0',
  `in_time` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`bdid`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- 导出表中的数据 `pd_invitelog`
--


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

--
-- 表的结构 `pd_langs`
--

DROP TABLE IF EXISTS `pd_langs`;
CREATE TABLE IF NOT EXISTS `pd_langs` (
  `lang_name` varchar(30) NOT NULL,
  `actived` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`lang_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 导出表中的数据 `pd_langs`
--

INSERT INTO `pd_langs` (`lang_name`, `actived`) VALUES
('zh-cn', 1),
('zh-hk', 0);

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

--
-- 表的结构 `pd_links`
--

DROP TABLE IF EXISTS `pd_links`;
CREATE TABLE IF NOT EXISTS `pd_links` (
  `linkid` mediumint(8) unsigned NOT NULL auto_increment,
  `title` varchar(100) NOT NULL,
  `url` varchar(100) NOT NULL,
  `logo` varchar(200) NOT NULL,
  `show_order` tinyint(1) unsigned NOT NULL default '0',
  `is_hidden` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`linkid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- 导出表中的数据 `pd_links`
--

INSERT INTO `pd_links` (`linkid`, `title`, `url`, `logo`, `show_order`, `is_hidden`) VALUES
(1, 'PHPDisk网络硬盘', 'http://www.phpdisk.com', './images/logo_small.gif', 2, 0),
(2, 'PHPDisk交流论坛', 'http://bbs.phpdisk.com', '', 0, 0);

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

--
-- 表的结构 `pd_messages`
--

DROP TABLE IF EXISTS `pd_messages`;
CREATE TABLE IF NOT EXISTS `pd_messages` (
  `msgid` int(11) unsigned NOT NULL auto_increment,
  `reply_id` int(11) unsigned NOT NULL default '0',
  `userid` int(10) unsigned NOT NULL default '0',
  `touserid` int(10) unsigned NOT NULL default '0',
  `content` text NOT NULL,
  `is_new` tinyint(1) NOT NULL,
  `in_sendbox` tinyint(1) unsigned NOT NULL default '0',
  `is_del` tinyint(1) unsigned NOT NULL default '0',
  `is_reply` tinyint(1) unsigned NOT NULL default '0',
  `in_time` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`msgid`),
  KEY `touserid` (`touserid`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- 导出表中的数据 `pd_messages`
--


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

--
-- 表的结构 `pd_navigations`
--

DROP TABLE IF EXISTS `pd_navigations`;
CREATE TABLE IF NOT EXISTS `pd_navigations` (
  `navid` int(10) unsigned NOT NULL auto_increment,
  `text` varchar(30) NOT NULL,
  `title` varchar(50) NOT NULL,
  `href` varchar(80) NOT NULL,
  `target` varchar(10) NOT NULL,
  `position` varchar(10) NOT NULL,
  `show_order` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`navid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- 导出表中的数据 `pd_navigations`
--

INSERT INTO `pd_navigations` (`navid`, `text`, `title`, `href`, `target`, `position`, `show_order`) VALUES
(1, 'PHPDisk论坛', 'PHPDisk官方交流论坛', 'http://bbs.phpdisk.com', '_blank', 'top', 1);

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

--
-- 表的结构 `pd_orders`
--

DROP TABLE IF EXISTS `pd_orders`;
CREATE TABLE IF NOT EXISTS `pd_orders` (
  `order_id` int(11) unsigned NOT NULL auto_increment,
  `pay_method` varchar(10) NOT NULL,
  `userid` int(10) unsigned NOT NULL default '0',
  `order_number` varchar(50) NOT NULL,
  `total_fee` float unsigned NOT NULL default '0',
  `pay_status` varchar(10) NOT NULL,
  `retcode` tinyint(3) unsigned NOT NULL default '0',
  `in_time` int(10) unsigned NOT NULL default '0',
  `ip` varchar(15) NOT NULL,
  PRIMARY KEY  (`order_id`),
  KEY `pay_method` (`pay_method`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- 导出表中的数据 `pd_orders`
--


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

--
-- 表的结构 `pd_plugins`
--

DROP TABLE IF EXISTS `pd_plugins`;
CREATE TABLE IF NOT EXISTS `pd_plugins` (
  `plugin_name` varchar(100) NOT NULL,
  `actived` tinyint(1) NOT NULL default '0',
  `action_time` int(10) unsigned NOT NULL default '0',
  `in_shortcut` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`plugin_name`),
  KEY `in_shortcut` (`in_shortcut`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 导出表中的数据 `pd_plugins`
--


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

--
-- 表的结构 `pd_replys`
--

DROP TABLE IF EXISTS `pd_replys`;
CREATE TABLE IF NOT EXISTS `pd_replys` (
  `rpid` int(11) unsigned NOT NULL auto_increment,
  `tid` int(11) unsigned NOT NULL default '0',
  `userid` int(10) NOT NULL,
  `content` text NOT NULL,
  `is_best` tinyint(1) unsigned NOT NULL default '0',
  `in_time` int(10) unsigned NOT NULL default '0',
  `ip` varchar(15) NOT NULL,
  PRIMARY KEY  (`rpid`),
  KEY `tid` (`tid`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- 导出表中的数据 `pd_replys`
--


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

--
-- 表的结构 `pd_reports`
--

DROP TABLE IF EXISTS `pd_reports`;
CREATE TABLE IF NOT EXISTS `pd_reports` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `file_id` bigint(20) unsigned NOT NULL default '0',
  `file_key` char(8) NOT NULL,
  `content` varchar(255) NOT NULL,
  `userid` int(10) unsigned NOT NULL default '0',
  `is_new` tinyint(1) unsigned NOT NULL default '0',
  `in_time` int(10) unsigned NOT NULL default '0',
  `ip` varchar(15) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- 导出表中的数据 `pd_reports`
--


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

--
-- 表的结构 `pd_search_index`
--

DROP TABLE IF EXISTS `pd_search_index`;
CREATE TABLE IF NOT EXISTS `pd_search_index` (
  `searchid` int(11) NOT NULL auto_increment,
  `userid` int(10) unsigned NOT NULL default '0',
  `scope` varchar(6) NOT NULL,
  `word` varchar(200) NOT NULL,
  `search_time` int(10) NOT NULL default '0',
  `total_count` smallint(6) NOT NULL default '0',
  `file_ids` text NOT NULL,
  `ip` varchar(15) NOT NULL,
  PRIMARY KEY  (`searchid`),
  KEY `userid` (`userid`),
  KEY `scope` (`scope`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- 导出表中的数据 `pd_search_index`
--


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

--
-- 表的结构 `pd_servers`
--

DROP TABLE IF EXISTS `pd_servers`;
CREATE TABLE IF NOT EXISTS `pd_servers` (
  `server_id` smallint(5) unsigned NOT NULL auto_increment,
  `server_oid` smallint(5) unsigned NOT NULL default '0',
  `server_name` varchar(50) NOT NULL,
  `server_host` varchar(100) NOT NULL,
  `server_closed` tinyint(1) unsigned NOT NULL default '0',
  `server_store_path` varchar(50) NOT NULL,
  `server_key` varchar(50) NOT NULL,
  `ftp_host` varchar(50) NOT NULL,
  `ftp_port` varchar(10) NOT NULL,
  `ftp_user` varchar(20) NOT NULL,
  `ftp_pass` varchar(20) NOT NULL,
  `ftp_ssl` tinyint(1) unsigned NOT NULL default '0',
  `ftp_pasv` tinyint(1) unsigned NOT NULL default '0',
  `ftp_path` varchar(30) NOT NULL,
  `ftp_closed` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`server_id`),
  KEY `server_oid` (`server_oid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- 导出表中的数据 `pd_servers`
--

INSERT INTO `pd_servers` (`server_id`, `server_oid`, `server_name`, `server_host`, `server_closed`, `server_store_path`, `server_key`, `ftp_host`, `ftp_port`, `ftp_user`, `ftp_pass`, `ftp_ssl`, `ftp_pasv`, `ftp_path`, `ftp_closed`) VALUES
(1, 0, 'Local Server', '-', 0, '-', '', '-', '', '-', '-', 0, 0, '', 0);

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

--
-- 表的结构 `pd_settings`
--

DROP TABLE IF EXISTS `pd_settings`;
CREATE TABLE IF NOT EXISTS `pd_settings` (
  `vars` varchar(100) NOT NULL,
  `value` text NOT NULL,
  PRIMARY KEY  (`vars`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 导出表中的数据 `pd_settings`
--
INSERT INTO `pd_settings` (`vars`, `value`) VALUES
('site_title', 'PHPDisk网盘系统'),
('phpdisk_url', 'http://localhost/pd_t/'),
('file_path', 'filestores'),
('max_file_size', '0'),
('perpage', '20'),
('gzipcompress', '1'),
('allow_access', '1'),
('allow_register', '1'),
('close_access_reason', '系统维护中...'),
('close_register_reason', '系统暂时关闭注册...'),
('meta_keywords', ''),
('meta_description', ''),
('site_stat', ''),
('miibeian', ''),
('contact_us', 'mail@mail.com1'),
('ali_partner', '123456789'),
('public_upload', '1'),
('credit_convert', '1'),
('check_public_file', '1'),
('debug_info', '1'),
('open_demo_login', '1'),
('open_share', '1'),
('open_link', '1'),
('open_link_domain', '*.phpdisk.com|www.163.com|'),
('report_word', ''),
('encrypt_key', 'r2FITb5S6CtR1'),
('register_verycode', '1'),
('login_verycode', '1'),
('open_seo', '1'),
('version_info', '1'),
('email_address', 'email@163.com'),
('email_pwd', '123456'),
('email_user', 'test'),
('email_smtp', 'smtp.163.com'),
('email_port', '25'),
('email_ssl', '0'),
('open_rewrite', '0'),
('ali_security_code', '312456978'),
('ali_seller_email', 'test@test.com'),
('login_down_file', '0'),
('online_demo', '0'),
('credit_down_my', '1'),
('filter_extension', 'asp,asa,aspx,ascx,dtd,xsd,xsl,xslt,as,wml,java,vtm,vtml,jst,asr,php,php3,php4,php5,vb,vbs,jsf,jsp,pl,cgi,js,html,htm,xhtml,xml,css,shtm,cfm,cfml,shtml,bat,sh'),
('open_thunder', '1'),
('thunder_pid', '11111'),
('open_flashget', '1'),
('flashget_uid', '222'),
('ten_mch', '12345678'),
('ten_key', '125457812121sfsd'),
('connect_uc', '0'),
('thumb_width', '120'),
('thumb_height', '90'),
('check_comment', '0'),
('secs_loading', '2'),
('true_link', '1'),
('true_link_extension', 'gif,png,bmp,wav,mp3,torrent,jpg,exe'),
('open_verycode', '1'),
('verycode_type', '2'),
('forget_verycode', '0'),
('open_tag', '1'),
('open_comment', '1'),
('open_vote', '0'),
('open_file_url', '0'),
('open_report', '1'),
('viewfile_keyword', ''),
('open_advance', '0'),
('powered_info', '1'),
('open_plugins_cp', '1'),
('open_payment', '1'),
('open_alipay', '0'),
('open_credit_convert', '0'),
('open_multi_server', '1'),
('open_time_link', '0'),
('local_download', ''),
('thunder_download', '0,1,2,8,9,10,13,14,15'),
('flashget_download', '3,7,8,9,10,16'),
('open_guest_upload', '1'),
('check_guest_upload', '1'),
('show_index', '1'),
('show_public', '1'),
('open_email', '1'),
('secs_for_user', '0'),
('open_plugins_last', '1'),
('connect_uc_type', 'discuz'),
('open_yeepay', '1'),
('yeepay_mch', '10001126856'),
('yeepay_key', '69cl522AV6q613Ii4W6u8K6XuW8vM1N6bFgyv769220IuYe9u37N4y7rI4Pl'),
('open_chinabank', '1'),
('chinabank_mch', '1001'),
('chinabank_key', 'test'),
('open_file_preview', '1'),
('open_file_extract_code', '0'),
('open_file_outlink', '1'),
('open_file_shorturl', '0'),
('downfile_directly', '0'),
('open_gallery_index', '1'),
('gallery_type', '1'),
('gallery_size_width', '650'),
('gallery_size_height', '200'),
('open_autoupdate', '0'),
('downfile_stat_time', '3600'),
('create_default_folder', ''),
('default_amount', '10'),
('show_relative_file', '1'),
('show_announce_detail', '0'),
('wealth_reg', '0'),
('wealth_login', '0'),
('wealth_invite', '0'),
('wealth_msg', '0'),
('wealth_upload', '0'),
('wealth_down', '0'),
('wealth_down_my', '0'),
('exp_reg', '20'),
('exp_login', '2'),
('exp_invite', '6'),
('exp_msg', '1'),
('exp_upload', '3'),
('exp_down', '2'),
('exp_down_my', '1'),
('credit_union', '积分'),
('wealth_union', '金钱'),
('exp_union', '经验'),
('exp_const', '50'),
('show_stat_index', '1'),
('invite_register_encode', '1'),
('share_tool', 'PCEtLSBKaWFUaGlzIEJ1dHRvbiBCRUdJTiAtLT4NCjxkaXYgaWQ9ImNrZXBvcCI+DQoJPGEgaHJlZj0iaHR0cDovL3d3dy5qaWF0aGlzLmNvbS9zaGFyZS8/dWlkPTkxODMxIiBjbGFzcz0iamlhdGhpcyBqaWF0aGlzX3R4dCBqdGljbyBqdGljb19qaWF0aGlzIiB0YXJnZXQ9Il9ibGFuayI+U2hhcmVUb++8mjwvYT4NCgk8YSBjbGFzcz0iamlhdGhpc19idXR0b25fdG9vbHNfMSI+PC9hPg0KCTxhIGNsYXNzPSJqaWF0aGlzX2J1dHRvbl90b29sc18yIj48L2E+DQoJPGEgY2xhc3M9ImppYXRoaXNfYnV0dG9uX3Rvb2xzXzMiPjwvYT4NCgk8L2Rpdj4NCjxzY3JpcHQgdHlwZT0idGV4dC9qYXZhc2NyaXB0Ij52YXIgamlhdGhpc19jb25maWcgPSB7ImRhdGFfdHJhY2tfY2xpY2tiYWNrIjp0cnVlfTs8L3NjcmlwdD4NCjxzY3JpcHQgdHlwZT0idGV4dC9qYXZhc2NyaXB0IiBzcmM9Imh0dHA6Ly92MS5qaWF0aGlzLmNvbS9jb2RlL2ppYS5qcz91aWQ9OTE4MzEiIGNoYXJzZXQ9InV0Zi04Ij48L3NjcmlwdD4NCjwhLS0gSmlhVGhpcyBCdXR0b24gRU5EIC0tPg=='),
('file_to_public_checked', '0'),
('all_file_share', '0'),
('user_active', '0'),
('show_hot_file_right', '1'),
('open_client', '1'),
('cache_time', '1');


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

--
-- 表的结构 `pd_stats`
--

DROP TABLE IF EXISTS `pd_stats`;
CREATE TABLE IF NOT EXISTS `pd_stats` (
  `vars` varchar(50) NOT NULL,
  `value` varchar(50) NOT NULL,
  PRIMARY KEY  (`vars`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 导出表中的数据 `pd_stats`
--


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

--
-- 表的结构 `pd_tags`
--

DROP TABLE IF EXISTS `pd_tags`;
CREATE TABLE IF NOT EXISTS `pd_tags` (
  `tag_id` int(11) unsigned NOT NULL auto_increment,
  `tag_name` varchar(30) NOT NULL,
  `tag_count` int(10) unsigned NOT NULL default '0',
  `is_hidden` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`tag_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- 导出表中的数据 `pd_tags`
--


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

--
-- 表的结构 `pd_templates`
--

DROP TABLE IF EXISTS `pd_templates`;
CREATE TABLE IF NOT EXISTS `pd_templates` (
  `tpl_name` varchar(50) NOT NULL,
  `actived` tinyint(1) unsigned NOT NULL,
  `tpl_type` varchar(30) NOT NULL,
  PRIMARY KEY  (`tpl_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 导出表中的数据 `pd_templates`
--

INSERT INTO `pd_templates` (`tpl_name`, `actived`, `tpl_type`) VALUES
('admin', 1, 'admin'),
('cool_black', 0, 'user'),
('default', 1, 'user');

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

--
-- 表的结构 `pd_topics`
--

DROP TABLE IF EXISTS `pd_topics`;
CREATE TABLE IF NOT EXISTS `pd_topics` (
  `tid` int(11) unsigned NOT NULL auto_increment,
  `userid` int(10) unsigned NOT NULL default '0',
  `credit` tinyint(3) unsigned NOT NULL default '0',
  `subject` varchar(100) NOT NULL,
  `content` text NOT NULL,
  `is_closed` tinyint(1) unsigned NOT NULL default '0',
  `in_time` int(10) unsigned NOT NULL default '0',
  `ip` varchar(15) NOT NULL,
  PRIMARY KEY  (`tid`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- 导出表中的数据 `pd_topics`
--


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

--
-- 表的结构 `pd_users`
--

DROP TABLE IF EXISTS `pd_users`;
CREATE TABLE IF NOT EXISTS `pd_users` (
  `userid` int(10) unsigned NOT NULL auto_increment,
  `username` varchar(64) NOT NULL,
  `password` varchar(32) NOT NULL,
  `email` varchar(255) NOT NULL,
  `gid` tinyint(3) unsigned default '0',
  `reset_code` varchar(32) NOT NULL,
  `is_activated` tinyint(1) default '0',
  `is_locked` tinyint(1) default '0',
  `last_login_time` int(11) default '0',
  `last_login_ip` varchar(15) NOT NULL,
  `reg_time` int(10) unsigned default '0',
  `reg_ip` varchar(15) NOT NULL,
  `credit` int(10) unsigned NOT NULL default '0',
  `wealth` float NOT NULL default '0',
  `rank` tinyint(3) unsigned NOT NULL default '0',
  `exp` smallint(5) unsigned NOT NULL default '0',
  `accept_pm` tinyint(1) default '1',
  `show_email` tinyint(1) default '0',
  `space_pos` tinyint(1) unsigned NOT NULL default '0',
  `user_file_types` varchar(150) NOT NULL,
  `user_store_space` varchar(30) NOT NULL,
  `user_rent_space` varchar(30) NOT NULL,
  `space_day_credits` float NOT NULL,
  `down_flow_count` varchar(20) NOT NULL default '0',
  `view_flow_count` varchar(20) NOT NULL default '0',
  `flow_reset_time` int(10) unsigned NOT NULL default '0',
  `max_flow_down` varchar(30) NOT NULL,
  `max_flow_view` varchar(30) NOT NULL,
  PRIMARY KEY  (`userid`),
  KEY `username` (`username`),
  KEY `gid` (`gid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- 导出表中的数据 `pd_users`
--
-- --------------------------------------------------------

--
-- 表的结构 `pd_client_set`
--

CREATE TABLE IF NOT EXISTS `pd_client_set` (
  `client_id` int(10) unsigned NOT NULL auto_increment,
  `client_info` text NOT NULL,
  PRIMARY KEY  (`client_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

