This repository was archived by the owner on Feb 4, 2021. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 2
Expand file tree
/
Copy pathpay.sql
More file actions
101 lines (86 loc) · 6.15 KB
/
Copy pathpay.sql
File metadata and controls
101 lines (86 loc) · 6.15 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
CREATE TABLE IF NOT EXISTS `config` (
`k` varchar(32) NOT NULL,
`v` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `config` (`k`, `v`) VALUES
('admin_lastlogin', ''),
('admin_pwd', '123456'),
('admin_user', 'zhinai'),
('alipayPublicKey', ''),
('appid', ''),
('houtaiannounce', '<div class="alert alert-info">尊敬的站长您好,欢迎进入红包助手后台管理中心!</div>\r\n<div class="alert alert-danger"><h4>服务说明</h4><br/>每天4:30将会清理数据库，清除24小时以前的所有未支付订单，请码支付的用户务必在当日补单，过期不候！</div>'),
('payer_show_name', '萌哔哩云支付'),
('price', '2'),
('remark', '支付宝返款'),
('saPrivateKey', '');
CREATE TABLE IF NOT EXISTS `dingdan` (
`ID` bigint(20) NOT NULL COMMENT '本地商户订单号',
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '生成订单时间',
`qq` text NOT NULL COMMENT '联系QQ',
`status` text COMMENT '支付状态',
`fankuan` int(1) NOT NULL DEFAULT '0' COMMENT '返款状态',
`totalFee` decimal(10,2) NOT NULL DEFAULT '0.10' COMMENT '交易金额',
`fkFee` decimal(10,2) NOT NULL DEFAULT '0.10' COMMENT '返款金额',
`fromID` int(11) NOT NULL DEFAULT '1' COMMENT '站点ID',
`trade_no` text NOT NULL COMMENT '支付宝订单号',
`fund_bill_list` text NOT NULL COMMENT '用户付款渠道和金额',
`buyer_id` text NOT NULL COMMENT '用户支付宝uid'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `log` (
`ID` int(11) NOT NULL,
`fzID` int(11) NOT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`money_before` decimal(10,2) NOT NULL,
`money_after` decimal(10,2) NOT NULL,
`reason` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `zhandian` (
`ID` int(11) NOT NULL COMMENT '站点ID',
`name` text NOT NULL COMMENT '站点名称',
`usr` text NOT NULL COMMENT '站点用户名',
`pwd` text NOT NULL COMMENT '站点密码',
`status` int(1) NOT NULL DEFAULT '0' COMMENT '站点状态 0正常 1冻结',
`balance` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '站点余额',
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '到期时间',
`sub` text NOT NULL COMMENT '站点绑定二级域名',
`codepay` int(1) NOT NULL DEFAULT '0' COMMENT '是否启用码支付 1启用',
`codepay_id` text NOT NULL COMMENT '码支付ID',
`codepay_key` text NOT NULL COMMENT '码支付KEY',
`appid` text NOT NULL COMMENT '商家应用appid',
`alipayPublicKey` mediumtext NOT NULL COMMENT '支付宝公钥',
`rsaPrivateKey` mediumtext NOT NULL COMMENT '商户私钥',
`ordername` text NOT NULL COMMENT '生成的订单标题',
`tradeFee` int(3) NOT NULL DEFAULT '0' COMMENT '手续费百分比',
`announce` mediumtext NOT NULL COMMENT '首页公告代码',
`notice` mediumtext NOT NULL COMMENT '首页温馨提示代码',
`qq` text NOT NULL,
`api` int(1) NOT NULL DEFAULT '0' COMMENT '是否开启API',
`fenzhan` int(1) NOT NULL DEFAULT '0' COMMENT '是否开启自助开通分站',
`fenzhan_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '自助开通加价',
`nomoney` int(1) NOT NULL DEFAULT '1' COMMENT '余额不足不可下单'
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
INSERT INTO `zhandian` (`ID`, `name`, `usr`, `pwd`, `status`, `balance`, `time`, `sub`, `codepay`, `codepay_id`, `codepay_key`, `appid`, `alipayPublicKey`, `rsaPrivateKey`, `ordername`, `tradeFee`, `announce`, `notice`, `qq`, `api`, `fenzhan`, `fenzhan_price`, `nomoney`) VALUES
(1, '支付宝红包助手', 'admin', 'admin', 0, '0.00', '2019-12-31 16:00:00', '', 0, '', '', '', '', '', '', 0, '<div class="col-xs-12 col-sm-10 col-md-8 center-block" style="float: none;">\r\n<div class="panel panel-primary">\r\n<div class="panel-heading"><h3 class="panel-title">系统公告</h3></div>\r\n<div class="panel-body">\r\n<div class="alert alert-info">欢迎使用萌哔哩红包助手!</div>\r\n<div class="alert alert-danger"><h4>说明</h4><br/>开通分站,自定义个人收款码,系统自动反款,开通联系QQ 12345678,详情可见<a href="https://shimo.im/docs/Yt42CTZObRsDYhSy/">点我查看</a></div>\r\n<div class="alert alert-warning"><h4>操作步骤</h4><br/>输入金额和QQ创建订单 → 支付宝扫描二维码或点击链接跳转 → 付款 → 付款金额会自动转回付款的支付宝</div>\r\n</div>\r\n</div>\r\n</div>', ' <div class="col-xs-12 col-sm-10 col-md-8 center-block" style="float: none;">\r\n<div class="panel panel-primary">\r\n<div class="panel-heading"><h3 class="panel-title">温馨提示</h3></div>\r\n<div class="panel-body">\r\n<font color="red">1.<b>付款后返款会自动返还至付款的支付宝中</b></font>，若1分钟没到可联系客服查询<br/>2.若您还未领取红包，请复制 “1071832” 后打开支付宝，搜索该数字即可<br/>\r\n 3.如果您发现返款金额与您的预计不符，请查看是否为自己操作错误，很多都是每日奖励多次做结果发现没有多返款反而扣了手续费<br/>4.客服QQ <font color="red">12345678</font>，服务时间8:00~23:00，开门见山直接说明情况并附带上商家订单号（非支付宝订单号，可在账单-详情中看到）\r\n</div>\r\n</div>\r\n</div>', '', 0, 0, '0.00', 1);
ALTER TABLE `config`
ADD PRIMARY KEY (`k`);
ALTER TABLE `dingdan`
ADD PRIMARY KEY (`ID`);
ALTER TABLE `log`
ADD PRIMARY KEY (`ID`);
ALTER TABLE `zhandian`
ADD PRIMARY KEY (`ID`);
ALTER TABLE `dingdan`
MODIFY `ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '本地商户订单号';
ALTER TABLE `log`
MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
ALTER TABLE `zhandian`
MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '站点ID',AUTO_INCREMENT=2;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;