/* Navicat MySQL Data Transfer Source Server : 本地数据库 Source Server Version : 50726 Source Host : localhost:3306 Source Database : skpan Target Server Type : MYSQL Target Server Version : 50726 File Encoding : 65001 Date: 2021-10-11 11:45:14 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for sk_certify -- ---------------------------- DROP TABLE IF EXISTS `sk_certify`; CREATE TABLE `sk_certify` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NOT NULL DEFAULT '0' COMMENT '实名用户', `name` varchar(60) DEFAULT NULL COMMENT '姓名', `idcard` varchar(18) DEFAULT NULL COMMENT '身份证号码', `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '提交时间', `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '实名状态', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='实名认证表'; -- ---------------------------- -- Records of sk_certify -- ---------------------------- INSERT INTO `sk_certify` VALUES ('1', '5', '运力', '432524200003012514', '1631483731', '1'); -- ---------------------------- -- Table structure for sk_folders -- ---------------------------- DROP TABLE IF EXISTS `sk_folders`; CREATE TABLE `sk_folders` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NOT NULL DEFAULT '0' COMMENT '目录所有人', `shares_id` int(11) NOT NULL DEFAULT '0' COMMENT '分享id', `folder_name` text NOT NULL COMMENT '目录名称', `parent_folder` int(11) NOT NULL DEFAULT '0' COMMENT '上级目录', `desc` text COMMENT '描述', `size` int(11) NOT NULL DEFAULT '0', `ext` int(11) NOT NULL DEFAULT '755', `count_down` int(11) NOT NULL DEFAULT '0' COMMENT '下载统计', `count_open` int(11) NOT NULL DEFAULT '0' COMMENT '浏览统计', `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间', `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间', `delete_time` int(11) DEFAULT NULL COMMENT '软删除', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 COMMENT='文件夹'; -- ---------------------------- -- Records of sk_folders -- ---------------------------- INSERT INTO `sk_folders` VALUES ('1', '4', '0', '根目录', '0', null, '0', '755', '0', '0', '1631186682', '0', null); INSERT INTO `sk_folders` VALUES ('8', '5', '0', '根目录', '0', null, '0', '755', '0', '0', '1631210019', '0', null); INSERT INTO `sk_folders` VALUES ('14', '5', '6', '图片资源', '13', '会议深入学习贯彻习近平总书记关于文艺工作的重要论述，贯彻落实中宣部关于文娱领域综合治理工作部署要求和广电总局广播电视和网络视听文艺工作者座谈会精神，研究提高网络视听文艺节目质量水平的思路举措和发展方向，廓清网络视听领域风气，切实推动网络视听文艺高质量发展。', '0', '755', '0', '0', '1631307651', '1631307651', null); INSERT INTO `sk_folders` VALUES ('15', '5', '39', 'aaaa', '13', '', '0', '755', '0', '0', '1631308784', '1631308784', null); INSERT INTO `sk_folders` VALUES ('16', '5', '40', 'vvvvvvvv', '14', '', '0', '755', '0', '0', '1631308789', '1631308789', null); INSERT INTO `sk_folders` VALUES ('17', '5', '41', 'sssss', '16', '', '0', '755', '0', '0', '1631308795', '1631308795', null); INSERT INTO `sk_folders` VALUES ('18', '5', '42', 'ddddd', '15', '', '0', '755', '0', '0', '1631308807', '1631308807', null); INSERT INTO `sk_folders` VALUES ('19', '4', '44', '等待', '1', 'a', '1', '755', '0', '12', '1631402716', '1632901435', null); INSERT INTO `sk_folders` VALUES ('20', '7', '0', '根目录', '0', null, '0', '755', '0', '0', '1631553262', '0', null); INSERT INTO `sk_folders` VALUES ('23', '4', '124', 'test', '19', '', '0', '755', '0', '0', '1632902549', '1632902713', null); INSERT INTO `sk_folders` VALUES ('24', '8', '0', '根目录', '0', null, '0', '755', '0', '0', '1633923568', '0', null); INSERT INTO `sk_folders` VALUES ('25', '8', '130', '22', '24', '', '0', '755', '0', '0', '1633923797', '1633923797', null); -- ---------------------------- -- Table structure for sk_groups -- ---------------------------- DROP TABLE IF EXISTS `sk_groups`; CREATE TABLE `sk_groups` ( `id` int(11) NOT NULL AUTO_INCREMENT, `group_name` varchar(120) DEFAULT '' COMMENT '用户组名称', `policy_id` int(11) NOT NULL DEFAULT '0' COMMENT '存储策略ID', `max_storage` bigint(20) NOT NULL DEFAULT '0' COMMENT '最大存储', `speed` varchar(20) DEFAULT NULL COMMENT '下载限速', `allow_share` tinyint(1) NOT NULL DEFAULT '0' COMMENT '允许分享', `is_sys` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否为系统用户组', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='用户组'; -- ---------------------------- -- Records of sk_groups -- ---------------------------- INSERT INTO `sk_groups` VALUES ('1', '管理员', '1', '1073741824', '', '1', '1'); INSERT INTO `sk_groups` VALUES ('2', '游客', '1', '0', '5', '0', '1'); INSERT INTO `sk_groups` VALUES ('3', '普通用户', '1', '104857600', '20', '1', '1'); INSERT INTO `sk_groups` VALUES ('4', 'VIP用户', '1', '209715200', '', '1', '0'); -- ---------------------------- -- Table structure for sk_order -- ---------------------------- DROP TABLE IF EXISTS `sk_order`; CREATE TABLE `sk_order` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NOT NULL DEFAULT '0' COMMENT '开通用户', `trade_no` varchar(40) NOT NULL DEFAULT '' COMMENT '订单号', `out_trade_no` varchar(40) NOT NULL DEFAULT '' COMMENT '易支付订单号', `type` varchar(20) NOT NULL DEFAULT '' COMMENT '支付方式', `profit_id` int(11) NOT NULL DEFAULT '0' COMMENT '收益链接ID', `money` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '支付金额', `vip_day` int(11) NOT NULL DEFAULT '0' COMMENT 'VIP时长', `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间', `pay_time` int(11) NOT NULL DEFAULT '0' COMMENT '支付时间', `status` tinyint(3) NOT NULL DEFAULT '0' COMMENT '支付状态 0 等待支付 1支付成功 2订单关闭', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COMMENT='订单记录'; -- ---------------------------- -- Records of sk_order -- ---------------------------- INSERT INTO `sk_order` VALUES ('18', '5', 'VIP_202109281904568FD7FCB859', '', 'alipay', '118', '2.00', '30', '1632827096', '0', '2'); INSERT INTO `sk_order` VALUES ('19', '4', 'VIP_202109292221141CD93DFBD8', '', 'alipay', '0', '3.00', '180', '1632925274', '0', '0'); INSERT INTO `sk_order` VALUES ('20', '4', 'VIP_20210929224018EAAAACEA58', '', 'alipay', '0', '20.00', '9999', '1632926418', '0', '0'); -- ---------------------------- -- Table structure for sk_policys -- ---------------------------- DROP TABLE IF EXISTS `sk_policys`; CREATE TABLE `sk_policys` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(120) DEFAULT NULL COMMENT '上传策略名称', `type` varchar(60) NOT NULL DEFAULT '' COMMENT '上传策略类型', `filetype` text COMMENT '允许上传的类型', `max_size` bigint(20) NOT NULL DEFAULT '0' COMMENT '单文件最大大小', `config` text COMMENT '配置信息', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='储存策略'; -- ---------------------------- -- Records of sk_policys -- ---------------------------- INSERT INTO `sk_policys` VALUES ('1', '默认存储', 'local', '', '2097152', '{\"save_dir\":\"\\/default\\/\",\"access_token\":\"\",\"server_uri\":\"\"}'); INSERT INTO `sk_policys` VALUES ('3', '远程服务器一', 'remote', '', '1073741824', '{\"save_dir\":\"\\/uploads\\/\",\"access_token\":\"asdasfasfasfasfasfa\",\"server_uri\":\"http:\\/\\/tp.com:8080\\/server\\/index.php\"}'); INSERT INTO `sk_policys` VALUES ('4', '测试阿里云', 'aliyunoss', '', '0', '{\"save_dir\":\"\\/uploads\\/\",\"endpoint\":\"oss-cn-hangzhou.aliyuncs.com\",\"bucket\":\"skpan-store-1\",\"access_key\":\"LTAI5tRkL7PfE5YrYnK5i5Vp\",\"access_secret\":\"LSRzPi3vGLsOdKh6Q48Wl89nTp6O9R\"}'); INSERT INTO `sk_policys` VALUES ('5', '测试腾讯云', 'txyunoss', '', '0', '{\"save_dir\":\"\\/uploads\\/\",\"secret_id\":\"AKIDpEJHRNjG2nQtFTowuqlaKeDg5Pi0weuA\",\"secret_key\":\"Lajv0umaEi4KAuY9bzFQzTrBMwMct461\",\"bucket\":\"skpan-1253809068\",\"region\":\"ap-guangzhou\"}'); -- ---------------------------- -- Table structure for sk_profit -- ---------------------------- DROP TABLE IF EXISTS `sk_profit`; CREATE TABLE `sk_profit` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NOT NULL DEFAULT '0' COMMENT '用户ID', `file_id` int(11) NOT NULL DEFAULT '0' COMMENT '文件ID', `count_view` int(11) NOT NULL DEFAULT '0' COMMENT '浏览量', `count_down` int(11) NOT NULL DEFAULT '0' COMMENT '下载量', `count_reg` int(11) NOT NULL DEFAULT '0' COMMENT '注册量', `count_order` int(11) NOT NULL DEFAULT '0' COMMENT '总订单', `count_order_yes` int(11) NOT NULL DEFAULT '0' COMMENT '成功订单', `count_money` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '金额', `count_profit` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '收益', `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COMMENT='收益记录'; -- ---------------------------- -- Records of sk_profit -- ---------------------------- INSERT INTO `sk_profit` VALUES ('32', '4', '163', '34', '20', '0', '0', '0', '0.00', '0.00', '1632902703'); INSERT INTO `sk_profit` VALUES ('34', '4', '166', '15', '5', '0', '0', '0', '0.00', '0.00', '1632907302'); INSERT INTO `sk_profit` VALUES ('35', '4', '167', '55', '23', '0', '0', '0', '0.00', '0.00', '1632909029'); -- ---------------------------- -- Table structure for sk_record -- ---------------------------- DROP TABLE IF EXISTS `sk_record`; CREATE TABLE `sk_record` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NOT NULL DEFAULT '0', `type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0 增加 1减少', `source` varchar(60) DEFAULT NULL COMMENT '来源', `money` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '变更金额', `after_money` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '变更前', `before_money` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '变更后金额', `remark` varchar(255) DEFAULT NULL COMMENT '操作原因', `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='财务记录'; -- ---------------------------- -- Records of sk_record -- ---------------------------- INSERT INTO `sk_record` VALUES ('1', '5', '1', '用户提现', '20.00', '480.00', '500.00', '余额提现20元至支付宝', '1631487541'); INSERT INTO `sk_record` VALUES ('2', '5', '1', '用户提现', '10.00', '470.00', '480.00', '余额提现10元至支付宝', '1631489052'); INSERT INTO `sk_record` VALUES ('3', '5', '1', '用户提现', '100.00', '370.00', '470.00', '余额提现100元至支付宝', '1631537650'); INSERT INTO `sk_record` VALUES ('4', '5', '1', '提现退回', '100.00', '270.00', '370.00', '提现系统退回金额', '1631537867'); INSERT INTO `sk_record` VALUES ('5', '5', '1', '用户提现', '20.00', '250.00', '270.00', '余额提现20元至支付宝', '1631538068'); INSERT INTO `sk_record` VALUES ('6', '5', '0', '提现退回', '20.00', '270.00', '250.00', '提现系统退回金额', '1631538080'); -- ---------------------------- -- Table structure for sk_reports -- ---------------------------- DROP TABLE IF EXISTS `sk_reports`; CREATE TABLE `sk_reports` ( `id` int(11) NOT NULL AUTO_INCREMENT, `shares_id` int(11) NOT NULL DEFAULT '0' COMMENT '资源ID', `source_name` varchar(255) DEFAULT NULL COMMENT '文件名', `source_url` varchar(255) NOT NULL DEFAULT '' COMMENT '链接地址', `source_uid` int(11) NOT NULL DEFAULT '0' COMMENT '所属用户UID', `source_username` varchar(60) NOT NULL DEFAULT '' COMMENT '所属用户帐号', `source_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0 文件 1目录', `type` varchar(10) NOT NULL DEFAULT '' COMMENT '举报类型', `contact` varchar(255) NOT NULL DEFAULT '' COMMENT '联系方式', `content` text COMMENT '详细描述', `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '举报时间', `real_ip` varchar(32) DEFAULT NULL COMMENT '举报IP', `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '举报处理', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='文件举报'; -- ---------------------------- -- Records of sk_reports -- ---------------------------- INSERT INTO `sk_reports` VALUES ('1', '0', 'phpStudy_64.zip', 'http://192.168.1.39:8080/s/yI7jAvQrtQ', '5', 'ceshi123', '0', '病毒', '02132132', '0.sada2.3sd', '1631625163', '192.168.1.40', '1'); -- ---------------------------- -- Table structure for sk_setting -- ---------------------------- DROP TABLE IF EXISTS `sk_setting`; CREATE TABLE `sk_setting` ( `id` int(11) NOT NULL AUTO_INCREMENT, `set_name` varchar(255) DEFAULT NULL COMMENT '配置名称', `set_value` text NOT NULL COMMENT '配置值', `set_type` varchar(60) NOT NULL DEFAULT '' COMMENT '配置类型', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 COMMENT='系统配置表'; -- ---------------------------- -- Records of sk_setting -- ---------------------------- INSERT INTO `sk_setting` VALUES ('1', 'site_name', '闪客网盘 | 分享赚钱,让资源有价值!', 'basic'); INSERT INTO `sk_setting` VALUES ('2', 'site_keywords', '闪客网盘 | 闪客云盘 | 网络云盘 | 网盘联盟 | 网赚网盘 | 云盘 | 云存储', 'basic'); INSERT INTO `sk_setting` VALUES ('3', 'site_desc', '闪客云盘是一款速度快、不打扰、够安全、易于分享的网络云盘,提供了分享下载分成功能,分享赚钱,让资源变的有收益有价值!', 'basic'); INSERT INTO `sk_setting` VALUES ('4', 'site_head', '', 'basic'); INSERT INTO `sk_setting` VALUES ('5', 'site_foot', '', 'basic'); INSERT INTO `sk_setting` VALUES ('6', 'allow_register', '1', 'register'); INSERT INTO `sk_setting` VALUES ('7', 'login_captcha', '1', 'register'); INSERT INTO `sk_setting` VALUES ('8', 'default_group', '3', 'register'); INSERT INTO `sk_setting` VALUES ('9', 'register_captcha', '1', 'register'); INSERT INTO `sk_setting` VALUES ('10', 'forget_captcha', '0', 'register'); INSERT INTO `sk_setting` VALUES ('11', 'site_title', 'SK网盘', 'basic'); INSERT INTO `sk_setting` VALUES ('12', 'site_logo', '/assets/logo/logo.gif', 'basic'); INSERT INTO `sk_setting` VALUES ('13', 'api_gateway', 'https://pay.yckjjg.cn/submit.php', 'pay'); INSERT INTO `sk_setting` VALUES ('14', 'api_pid', '678679', 'pay'); INSERT INTO `sk_setting` VALUES ('15', 'api_type', 'wxpay,alipay', 'pay'); INSERT INTO `sk_setting` VALUES ('16', 'api_key', 'BC9CC2EC25BE461E7DB6A44E9476D705', 'pay'); INSERT INTO `sk_setting` VALUES ('17', 'vip_group', '4', 'vip'); INSERT INTO `sk_setting` VALUES ('18', 'vip_rule', '周付VIP|1|7|周|7.0|立省 12 原价15元|高速多线程下载文件，原价9元。|0\n月付VIP|2|30|月|6.3|立省175元 仅 1.33元/月|高速多线程下载文件，比周付省11%。|1\n半年VIP|3|180|半年|5.2|立省420元 原价450元|高速多线程下载文件，比月付省35%。|1\n一年VIP|4|360|年|4.7|立省420元 原价450元|高速多线程下载文件，比月付省50%。|1\n永久VIP|20|9999|永久|2.7|立省420元 原价450元|高速多线程下载文件，比月付省73%。|0', 'vip'); INSERT INTO `sk_setting` VALUES ('19', 'site_email', 'test@admin.com', 'basic'); INSERT INTO `sk_setting` VALUES ('20', 'smtp_host', 'smtp.qq.com', 'email'); INSERT INTO `sk_setting` VALUES ('21', 'smtp_port', '465', 'email'); INSERT INTO `sk_setting` VALUES ('22', 'nickname', 'SK网盘官方', 'email'); INSERT INTO `sk_setting` VALUES ('23', 'username', 'zygphper@foxmail.com', 'email'); INSERT INTO `sk_setting` VALUES ('24', 'password', 'xyuufcokuxendbfi', 'email'); INSERT INTO `sk_setting` VALUES ('25', 'template_forget', '

 

\n\n\n\n\n\n\n\n\n
 \n
\n\n\n\n\n\n\n\n\n\n
找回密码验证 -【{site_title}】
\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
亲爱的 {username} ：
请点击下方按钮完成密码重设。十分钟之内有效，如果非你本人操作，请忽略此邮件。
点击设置新密码
感谢您选择{site_title}。
\n
\n
\n\n\n\n\n\n\n
此邮件由系统自动发送，请不要直接回复。
\n

\n
\n		 
', 'email'); INSERT INTO `sk_setting` VALUES ('26', 'site_kefu', '客服QQ：1665555255

客服在线时间：早上9点-晚上22点

如遇到任何问题请联系客服处理
对此给您带来的不便深感抱歉', 'basic'); INSERT INTO `sk_setting` VALUES ('27', 'vip_profit', '50', 'vip'); INSERT INTO `sk_setting` VALUES ('28', 'index_theme', 'new1', 'basic'); -- ---------------------------- -- Table structure for sk_shares -- ---------------------------- DROP TABLE IF EXISTS `sk_shares`; CREATE TABLE `sk_shares` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NOT NULL DEFAULT '0' COMMENT '用户ID', `source_id` int(11) NOT NULL DEFAULT '0' COMMENT '文件 / 目录ID', `type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0 文件 1目录', `speed` tinyint(1) NOT NULL DEFAULT '0' COMMENT '限速开关', `code` varchar(10) NOT NULL DEFAULT '' COMMENT '短网址代码', `pwd` varchar(8) DEFAULT NULL COMMENT '分享密码', `pwd_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '密码状态', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=131 DEFAULT CHARSET=utf8 COMMENT='分享表'; -- ---------------------------- -- Records of sk_shares -- ---------------------------- INSERT INTO `sk_shares` VALUES ('1', '5', '13', '1', '0', 'QVNbueubNW', 'fmrw', '0'); INSERT INTO `sk_shares` VALUES ('4', '5', '54', '0', '0', 'aYbA3iNCSk', 'kHIb', '0'); INSERT INTO `sk_shares` VALUES ('5', '5', '55', '0', '0', 'JJBjIvUM80', '', '0'); INSERT INTO `sk_shares` VALUES ('6', '5', '14', '1', '0', '7NVjYnhxwT', 'jPAT', '0'); INSERT INTO `sk_shares` VALUES ('7', '5', '56', '0', '0', 'yaYJ3mrsYP', 'Wt9G', '0'); INSERT INTO `sk_shares` VALUES ('8', '5', '57', '0', '0', 'qy2a6fp7PW', 'CkLp', '0'); INSERT INTO `sk_shares` VALUES ('9', '5', '58', '0', '0', '7bmANrUqUE', 'MyFS', '0'); INSERT INTO `sk_shares` VALUES ('10', '5', '59', '0', '0', 'NJVjEzpLFh', 'BFaM', '0'); INSERT INTO `sk_shares` VALUES ('11', '5', '60', '0', '0', 'mmArMvpqNn', '5XPd', '0'); INSERT INTO `sk_shares` VALUES ('12', '5', '61', '0', '0', 'nUjuQz1qb2', '98Zl', '0'); INSERT INTO `sk_shares` VALUES ('13', '5', '62', '0', '0', 'MzUnIjCVom', '5ERQ', '0'); INSERT INTO `sk_shares` VALUES ('14', '5', '63', '0', '0', 'IziqeylQaJ', '1Qmi', '0'); INSERT INTO `sk_shares` VALUES ('15', '5', '64', '0', '0', '2uAnEr0QFn', 'FNx2', '0'); INSERT INTO `sk_shares` VALUES ('16', '5', '65', '0', '0', 'YB7bI3IucT', 'MCpN', '0'); INSERT INTO `sk_shares` VALUES ('17', '5', '66', '0', '0', 'qERnMf08KE', 'iKVU', '0'); INSERT INTO `sk_shares` VALUES ('18', '5', '67', '0', '0', 'YFJbiySL45', 'c8Mu', '0'); INSERT INTO `sk_shares` VALUES ('19', '5', '68', '0', '0', 'UFjIf2QqnV', '3G2H', '0'); INSERT INTO `sk_shares` VALUES ('20', '5', '69', '0', '0', 'EzuYburVJs', 'qkIU', '0'); INSERT INTO `sk_shares` VALUES ('21', '5', '70', '0', '0', '6Vzmmu1ksV', 'SHdA', '0'); INSERT INTO `sk_shares` VALUES ('22', '5', '71', '0', '0', 'MbIr2yNNJT', 'yV7I', '0'); INSERT INTO `sk_shares` VALUES ('23', '5', '72', '0', '0', 'JzyeInn1Pi', 'Gmmb', '0'); INSERT INTO `sk_shares` VALUES ('24', '5', '73', '0', '0', 'imiQraBLcN', 'Pa2p', '0'); INSERT INTO `sk_shares` VALUES ('25', '5', '74', '0', '0', 'EJZRZrJMbq', 'W2IS', '0'); INSERT INTO `sk_shares` VALUES ('26', '5', '75', '0', '0', 'eqAfaiWH7R', 'D1B8', '0'); INSERT INTO `sk_shares` VALUES ('27', '5', '76', '0', '0', 'UFj2uq57f4', 'SQ9u', '0'); INSERT INTO `sk_shares` VALUES ('28', '5', '77', '0', '0', 'Bf6vEfdCoU', 'sgnk', '0'); INSERT INTO `sk_shares` VALUES ('29', '5', '78', '0', '0', 'imaqyala0O', 'oTAG', '0'); INSERT INTO `sk_shares` VALUES ('30', '5', '79', '0', '0', 'VfMV7fnMhl', 'TWAr', '0'); INSERT INTO `sk_shares` VALUES ('31', '5', '80', '0', '0', 'QVbeqiRTAZ', 'eaCW', '0'); INSERT INTO `sk_shares` VALUES ('32', '5', '81', '0', '0', 'JBBfUvPgwv', 'uzc5', '0'); INSERT INTO `sk_shares` VALUES ('33', '5', '82', '0', '0', 'FFNJzmsgjK', 'NU7M', '0'); INSERT INTO `sk_shares` VALUES ('34', '5', '83', '0', '0', '2aiEZbNudq', 'ynBq', '0'); INSERT INTO `sk_shares` VALUES ('35', '5', '84', '0', '0', '3aMFVfKSwN', 'gkRD', '0'); INSERT INTO `sk_shares` VALUES ('36', '5', '85', '0', '0', 'uqiYfaxfkv', 'QxfD', '0'); INSERT INTO `sk_shares` VALUES ('37', '5', '86', '0', '0', 'VVZzyaLcG0', 'HRhA', '0'); INSERT INTO `sk_shares` VALUES ('38', '5', '87', '0', '0', 'FJv2mmUflN', 'Fg90', '0'); INSERT INTO `sk_shares` VALUES ('39', '5', '15', '1', '0', '73eA32Tg7o', '4uA5', '0'); INSERT INTO `sk_shares` VALUES ('40', '5', '16', '1', '0', 'YNfUzmZhx8', 'nEMH', '0'); INSERT INTO `sk_shares` VALUES ('41', '5', '17', '1', '0', 'eiiQFjdEpA', 'sBNK', '0'); INSERT INTO `sk_shares` VALUES ('42', '5', '18', '1', '0', 'YreIjqrjMS', 'CdZc', '0'); INSERT INTO `sk_shares` VALUES ('43', '5', '88', '0', '0', 'QfIzAvSL40', 'lZcP', '0'); INSERT INTO `sk_shares` VALUES ('44', '4', '19', '1', '0', 'j6ZnqaMTRo', 'wAvF', '0'); INSERT INTO `sk_shares` VALUES ('45', '4', '89', '0', '0', 'VZVnumE7Km', '02tC', '0'); INSERT INTO `sk_shares` VALUES ('46', '5', '90', '0', '0', 'NbUFFfo3sb', 'J8tF', '0'); INSERT INTO `sk_shares` VALUES ('47', '5', '91', '0', '0', 'EfQ3QbG4aK', 'Bctq', '0'); INSERT INTO `sk_shares` VALUES ('48', '5', '92', '0', '0', 'NZb6B3ic49', 'jrDc', '0'); INSERT INTO `sk_shares` VALUES ('49', '5', '93', '0', '0', 'aqUNNnZmR2', '632a', '0'); INSERT INTO `sk_shares` VALUES ('50', '5', '94', '0', '0', 'qeeMFrQTea', 'adpb', '0'); INSERT INTO `sk_shares` VALUES ('51', '5', '95', '0', '0', 'v6vyIbYLEW', '5Guc', '0'); INSERT INTO `sk_shares` VALUES ('52', '5', '96', '0', '0', 'FZrIZ3YkZE', '7d65', '0'); INSERT INTO `sk_shares` VALUES ('53', '5', '97', '0', '0', 'FzyqmqBrEb', '2xry', '0'); INSERT INTO `sk_shares` VALUES ('54', '5', '98', '0', '0', 'qim2qmNTqN', '2yOS', '0'); INSERT INTO `sk_shares` VALUES ('55', '5', '99', '0', '0', 'iuQJnuSQHT', 'UJmM', '0'); INSERT INTO `sk_shares` VALUES ('56', '5', '100', '0', '0', 'MBbuUrgjwi', 'lmSD', '0'); INSERT INTO `sk_shares` VALUES ('57', '5', '101', '0', '0', '3yUF7vPc7e', 'I0uV', '0'); INSERT INTO `sk_shares` VALUES ('58', '5', '102', '0', '0', 'mm6ZRfXZCa', 'prqi', '0'); INSERT INTO `sk_shares` VALUES ('59', '5', '103', '0', '0', 'ryqeuivWSs', 'i5Ly', '0'); INSERT INTO `sk_shares` VALUES ('60', '5', '104', '0', '0', 'UN3M3mhxHw', 'ZpfC', '0'); INSERT INTO `sk_shares` VALUES ('61', '5', '105', '0', '0', 'FRZjyewFnu', 'SRYT', '0'); INSERT INTO `sk_shares` VALUES ('62', '5', '106', '0', '0', 'muQ3aeS48W', 'ic2y', '0'); INSERT INTO `sk_shares` VALUES ('63', '5', '107', '0', '0', 'qY3yi2Wfc9', 'nRHo', '0'); INSERT INTO `sk_shares` VALUES ('64', '5', '108', '0', '0', 'iAfEryWcv1', 'upsi', '0'); INSERT INTO `sk_shares` VALUES ('65', '5', '109', '0', '0', '7VVjUzFoMO', 'jwTR', '0'); INSERT INTO `sk_shares` VALUES ('66', '5', '110', '0', '0', 'ENrUZfUfgi', 'xYVP', '0'); INSERT INTO `sk_shares` VALUES ('67', '5', '111', '0', '0', 'nMNf2u68pm', 'idbJ', '0'); INSERT INTO `sk_shares` VALUES ('68', '5', '112', '0', '0', 'RvINn2qOaE', 'nFo1', '0'); INSERT INTO `sk_shares` VALUES ('69', '5', '113', '0', '0', 'F3aYnacuCu', 'azXJ', '0'); INSERT INTO `sk_shares` VALUES ('70', '5', '114', '0', '0', '6FR3mebo4b', 'IqyQ', '0'); INSERT INTO `sk_shares` VALUES ('71', '5', '115', '0', '0', 'mi2Qjm9MOT', '6tKy', '0'); INSERT INTO `sk_shares` VALUES ('72', '5', '116', '0', '0', 'U32IvaBozx', 'JP7x', '0'); INSERT INTO `sk_shares` VALUES ('73', '5', '117', '0', '0', 'IVRBJbXC8c', 'ZO9x', '0'); INSERT INTO `sk_shares` VALUES ('74', '5', '118', '0', '0', 'ANn2muSUlr', 'fWlr', '0'); INSERT INTO `sk_shares` VALUES ('75', '5', '119', '0', '0', 'qiYvUv3ERC', 'GP8y', '0'); INSERT INTO `sk_shares` VALUES ('76', '5', '120', '0', '0', 'jQVRRftjKV', 'y8Gz', '0'); INSERT INTO `sk_shares` VALUES ('77', '5', '121', '0', '0', 'vmyIre9Isy', 'QQ9G', '0'); INSERT INTO `sk_shares` VALUES ('78', '5', '122', '0', '0', 'iQ7Nva6kEo', 'H2P8', '0'); INSERT INTO `sk_shares` VALUES ('79', '5', '123', '0', '0', '6BBn2eGfaa', 'Fngu', '0'); INSERT INTO `sk_shares` VALUES ('80', '5', '124', '0', '0', 'FZBFBjTu6D', 'QN63', '0'); INSERT INTO `sk_shares` VALUES ('81', '5', '125', '0', '0', 'aimiyqgMq7', 'fIjC', '0'); INSERT INTO `sk_shares` VALUES ('82', '5', '126', '0', '0', 'q6Nn2iu8v9', 'cZ6U', '0'); INSERT INTO `sk_shares` VALUES ('83', '5', '127', '0', '0', 'umy6ZnVIzB', 'YO7G', '0'); INSERT INTO `sk_shares` VALUES ('84', '5', '128', '0', '0', 'zqmUZfk2y3', 'MnYF', '0'); INSERT INTO `sk_shares` VALUES ('85', '5', '129', '0', '0', '3eEbUzMnxT', '2zTb', '0'); INSERT INTO `sk_shares` VALUES ('86', '5', '130', '0', '0', 'JZjU3aeep6', '6fuE', '0'); INSERT INTO `sk_shares` VALUES ('87', '5', '131', '0', '0', '2IF3u25i8Y', 'LcbB', '0'); INSERT INTO `sk_shares` VALUES ('88', '5', '132', '0', '0', 'biaiaqZkzS', 'OqbL', '0'); INSERT INTO `sk_shares` VALUES ('89', '5', '133', '0', '0', 'FfQRJjr7NK', '6btE', '0'); INSERT INTO `sk_shares` VALUES ('90', '5', '134', '0', '0', 'BRFnQfqGqa', 'wgTz', '0'); INSERT INTO `sk_shares` VALUES ('91', '5', '135', '0', '0', 'RzmmYv8Qjg', 'OJcS', '0'); INSERT INTO `sk_shares` VALUES ('92', '5', '136', '0', '0', 'nMRvI3Xo05', 'b8t3', '0'); INSERT INTO `sk_shares` VALUES ('93', '5', '137', '0', '0', 'y67nEnWzjz', 'lhK7', '0'); INSERT INTO `sk_shares` VALUES ('94', '5', '138', '0', '0', '3YVB3qb5b7', 'o3GV', '0'); INSERT INTO `sk_shares` VALUES ('95', '5', '139', '0', '0', 'r6jEJfmGhy', '3U6u', '0'); INSERT INTO `sk_shares` VALUES ('96', '5', '140', '0', '0', 'yI7jAvQrtQ', 'm3Do', '0'); INSERT INTO `sk_shares` VALUES ('97', '5', '141', '0', '0', 'yAR7fqlAYT', 'A1ft', '0'); INSERT INTO `sk_shares` VALUES ('98', '5', '142', '0', '0', 'VJbai2zHA8', 'lQjh', '0'); INSERT INTO `sk_shares` VALUES ('99', '5', '143', '0', '0', 'NrYVvqD4sP', 'StfT', '0'); INSERT INTO `sk_shares` VALUES ('100', '5', '144', '0', '0', 'uauIFjPko6', 'sijd', '0'); INSERT INTO `sk_shares` VALUES ('101', '5', '21', '1', '0', 'eIRrQnOHwE', 'RhXA', '0'); INSERT INTO `sk_shares` VALUES ('102', '5', '145', '0', '0', 'UbIRB3mwAm', 'lFCk', '0'); INSERT INTO `sk_shares` VALUES ('103', '5', '146', '0', '0', 'mMVJryGgMx', 'tSWc', '0'); INSERT INTO `sk_shares` VALUES ('104', '5', '147', '0', '0', 'jaymMn1wGq', 'mdRd', '0'); INSERT INTO `sk_shares` VALUES ('105', '5', '148', '0', '0', 'ZvIJrqS7Le', 'wT76', '0'); INSERT INTO `sk_shares` VALUES ('106', '5', '149', '0', '0', 'Vb2UVvXaa4', 'scFW', '0'); INSERT INTO `sk_shares` VALUES ('107', '5', '150', '0', '0', 'NjuIn2UYst', 'FpEu', '0'); INSERT INTO `sk_shares` VALUES ('108', '5', '151', '0', '0', '7zMnamgVkz', '0f5q', '0'); INSERT INTO `sk_shares` VALUES ('109', '5', '152', '0', '0', 'NRvyUj2gSj', 'HS0r', '0'); INSERT INTO `sk_shares` VALUES ('110', '5', '153', '0', '0', 'MfIFNv3eXU', 'iXem', '0'); INSERT INTO `sk_shares` VALUES ('111', '5', '154', '0', '0', '3IF7RrQmXS', 'j6h7', '0'); INSERT INTO `sk_shares` VALUES ('112', '5', '155', '0', '0', 'EbUnMz8tEk', 'Kd6r', '0'); INSERT INTO `sk_shares` VALUES ('113', '5', '156', '0', '0', 'yUfI7vCa0g', 'zVjs', '0'); INSERT INTO `sk_shares` VALUES ('114', '5', '157', '0', '0', 'YnqQ3uQyZP', 'uUBj', '0'); INSERT INTO `sk_shares` VALUES ('115', '5', '158', '0', '0', 'Nnqauir1hq', 'QCNO', '0'); INSERT INTO `sk_shares` VALUES ('116', '5', '159', '0', '0', 'EJbayy279G', 'CBDs', '0'); INSERT INTO `sk_shares` VALUES ('117', '5', '160', '0', '0', 'zmUzuu8VXP', 'R3P7', '0'); INSERT INTO `sk_shares` VALUES ('118', '5', '161', '0', '0', 'RruAjyBGlS', 'dnbr', '0'); INSERT INTO `sk_shares` VALUES ('119', '5', '162', '0', '0', '22MRZfAi5u', 'IMMz', '0'); INSERT INTO `sk_shares` VALUES ('120', '4', '163', '0', '0', 'jEjyEbzADW', 'Tn3M', '0'); INSERT INTO `sk_shares` VALUES ('121', '4', '164', '0', '0', 'AZfqaqOZHp', '0xsQ', '0'); INSERT INTO `sk_shares` VALUES ('122', '4', '22', '1', '0', 'RBf6zyBuO9', 'f4fg', '0'); INSERT INTO `sk_shares` VALUES ('123', '4', '165', '0', '0', 'Z7jqqaU6RB', 'Wb6i', '0'); INSERT INTO `sk_shares` VALUES ('124', '4', '23', '1', '0', 'nY7B3anZl7', 'QkE0', '0'); INSERT INTO `sk_shares` VALUES ('125', '4', '166', '0', '0', '63YJvq0WBf', '6666', '1'); INSERT INTO `sk_shares` VALUES ('126', '4', '167', '0', '0', '2I3Mzyqy4W', 'HOO8', '1'); INSERT INTO `sk_shares` VALUES ('127', '5', '168', '0', '0', 'z6ju6fQ6l1', 'UW4P', '1'); INSERT INTO `sk_shares` VALUES ('128', '5', '169', '0', '0', 'AFBnEnmKNE', 'c5ug', '0'); INSERT INTO `sk_shares` VALUES ('129', '8', '170', '0', '0', 'beAvmqnabl', 'qwEK', '0'); INSERT INTO `sk_shares` VALUES ('130', '8', '25', '1', '0', 're6fA396Rh', 'vbBY', '0'); -- ---------------------------- -- Table structure for sk_stores -- ---------------------------- DROP TABLE IF EXISTS `sk_stores`; CREATE TABLE `sk_stores` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NOT NULL DEFAULT '0' COMMENT '所属用户', `shares_id` int(11) NOT NULL DEFAULT '0' COMMENT '分享id', `origin_name` varchar(255) NOT NULL DEFAULT '' COMMENT '源文件名', `file_name` text NOT NULL COMMENT '存储文件名', `size` bigint(20) NOT NULL DEFAULT '0' COMMENT '文件大小', `meta` text COMMENT '文件元属性', `mime_type` varchar(60) NOT NULL DEFAULT '' COMMENT '文件类型', `ext` varchar(60) NOT NULL DEFAULT '' COMMENT '文件后缀', `parent_folder` int(11) NOT NULL DEFAULT '0' COMMENT '所属目录', `policy_id` int(11) NOT NULL DEFAULT '0' COMMENT '存储策略', `count_down` int(11) NOT NULL DEFAULT '0' COMMENT '下载量', `count_open` int(11) NOT NULL DEFAULT '0' COMMENT '浏览量', `dir` text COMMENT '文件目录', `desc` text COMMENT '文件描述', `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间', `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间', `delete_time` int(11) DEFAULT NULL COMMENT '软删除', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=171 DEFAULT CHARSET=utf8 COMMENT='储存文件'; -- ---------------------------- -- Records of sk_stores -- ---------------------------- INSERT INTO `sk_stores` VALUES ('163', '4', '120', 'hidatarecovery_7df90c1c.exe', '/uploads/20210929/4/file_6153ee4b6ce301632890443.exe', '1449440', '', '', 'exe', '23', '4', '20', '37', '', null, '1632890447', '1632902713', null); INSERT INTO `sk_stores` VALUES ('166', '4', '125', 'new-skapn.rar', '/uploads/20210929/4/file_6154301dc6bb01632907293.rar', '1632931', '', '', 'rar', '1', '5', '5', '15', '', null, '1632907297', '1632907297', null); INSERT INTO `sk_stores` VALUES ('167', '4', '126', 'ShenDuHuiFu_DNGJ8.1.4.exe', '/uploads/20210929/4/file_615436d49b4601632909012.exe', '4394904', '', '', 'exe', '1', '5', '23', '55', '', null, '1632909021', '1632909021', null); INSERT INTO `sk_stores` VALUES ('169', '5', '128', '1.png', '/uploads/20210930/5/file_61555172827541632981362.png', '4286', null, '', 'png', '8', '5', '0', '0', null, null, '1632981362', '1632981362', null); INSERT INTO `sk_stores` VALUES ('170', '8', '129', '4182144.png', '/default/20211011/8/file_6163b2b268d491633923762.png', '226890', null, '', 'png', '25', '1', '0', '0', null, '', '1633923762', '1633923762', null); -- ---------------------------- -- Table structure for sk_users -- ---------------------------- DROP TABLE IF EXISTS `sk_users`; CREATE TABLE `sk_users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(60) NOT NULL DEFAULT '' COMMENT '用户名', `nickname` varchar(60) DEFAULT NULL COMMENT '用户昵称', `email` varchar(100) NOT NULL DEFAULT '' COMMENT '邮箱账号', `password` varchar(40) NOT NULL DEFAULT '' COMMENT '密码', `avatar` varchar(255) DEFAULT NULL COMMENT '用户头像', `desc` varchar(255) DEFAULT NULL COMMENT '个性签名', `amount` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '用户余额', `group` int(11) NOT NULL DEFAULT '0' COMMENT '用户组', `group_expire` int(11) NOT NULL DEFAULT '0' COMMENT '用户组过期时间', `is_auth` tinyint(3) NOT NULL DEFAULT '0' COMMENT '是否实名认证', `wx_openid` varchar(64) DEFAULT NULL COMMENT '微信开放平台ID', `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '注册时间', `login_time` int(11) NOT NULL DEFAULT '0' COMMENT '最近登录时间', `login_real_ip` varchar(60) NOT NULL DEFAULT '', `status` tinyint(2) NOT NULL DEFAULT '1' COMMENT '用户状态 1 正常 0封禁', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='用户表'; -- ---------------------------- -- Records of sk_users -- ---------------------------- INSERT INTO `sk_users` VALUES ('1', 'admin', '管理员', 'admin@skpan.net', '3e9464c59cc03ef5f3c5ed555e2757e2', null, null, '10.00', '1', '0', '0', null, '1631009197', '0', '', '1'); INSERT INTO `sk_users` VALUES ('4', '1655545174', 'DDDAAA', '1655545174@qq.com', 'bbc3b9b91ed52618ee9d2259bd467099', '/avatar/20210930/afd3f2595c23f931de482215bbec6243.jpg', '你好世界', '0.00', '3', '0', '0', null, '1631186682', '0', '', '1'); INSERT INTO `sk_users` VALUES ('5', 'ceshi123', 'ceshi1233', '1950412285@qq.com', '221da9e890927b42c61a73770d331f39', null, '', '270.00', '3', '0', '1', null, '1631210019', '0', '', '1'); INSERT INTO `sk_users` VALUES ('6', 'aa1122', 'AAAA', 'aa1122@qq.com', '221da9e890927b42c61a73770d331f39', null, null, '0.00', '3', '0', '0', null, '1631553201', '0', '', '1'); INSERT INTO `sk_users` VALUES ('7', 'aa11223', 'abc', 'aa1122d@qq.com', '99c0342da49856be2e9f6fbf55116e57', null, null, '0.00', '3', '0', '0', null, '1631553262', '0', '', '1'); INSERT INTO `sk_users` VALUES ('8', 'zixuan', 'Zixuan', '825166808@qq.com', 'f890f825c0d6aae83005c731fc2c4892', null, null, '0.00', '3', '0', '0', null, '1633923568', '0', '', '1'); -- ---------------------------- -- Table structure for sk_withdraw -- ---------------------------- DROP TABLE IF EXISTS `sk_withdraw`; CREATE TABLE `sk_withdraw` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NOT NULL DEFAULT '0' COMMENT '提现用户', `money` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '提现金额', `alipay_account` varchar(255) DEFAULT NULL COMMENT '支付宝帐号', `alipay_name` varchar(60) DEFAULT NULL COMMENT '支付宝姓名', `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '提现时间', `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '提现状态 0 等待处理 1提现成功', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='用户提现记录'; -- ---------------------------- -- Records of sk_withdraw -- ---------------------------- INSERT INTO `sk_withdraw` VALUES ('1', '5', '20.00', '1655545174@qq.com', '蓝天', '1631487541', '1'); INSERT INTO `sk_withdraw` VALUES ('2', '5', '10.00', '1655545174@qq.com', '蓝天', '1631489052', '1'); INSERT INTO `sk_withdraw` VALUES ('3', '5', '100.00', '1655545174@qq.com', '啊啊', '1631537650', '2'); INSERT INTO `sk_withdraw` VALUES ('4', '5', '20.00', '1655545174@qq.com', '啊啊', '1631538068', '2');