pay_center_server/storage/sql/all_inc.sql

/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 80019
 Source Host           : localhost:3307
 Source Schema         : pay_center

 Target Server Type    : MySQL
 Target Server Version : 80019
 File Encoding         : 65001

 Date: 19/06/2022 15:09:30
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
                         `id` int NOT NULL AUTO_INCREMENT,
                         `account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户名',
                         `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '密码',
                         `salt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '盐',
                         `created_at` timestamp NULL DEFAULT NULL,
                         `updated_at` timestamp NULL DEFAULT NULL,
                         `login_time` timestamp NULL DEFAULT NULL COMMENT '登陆时间',
                         `status` int NOT NULL DEFAULT '1' COMMENT '状态:1,启用;2,禁用',
                         PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用户管理表';

-- ----------------------------
-- Records of admin
-- ----------------------------
BEGIN;
INSERT INTO `admin` VALUES (2, 'admin123', 'df7ac40c891bfaad01fea02a9fb75587', 'AL7I6f', '2022-04-16 10:57:38', '2022-06-15 17:07:57', '2022-06-15 17:07:57', 1);
INSERT INTO `admin` VALUES (3, 'admin1232', 'a3ab4ce54b0a267873f5456647cd8806', '6Kq9o5', '2022-04-16 13:46:10', '2022-04-16 13:46:10', NULL, 1);
COMMIT;

-- ----------------------------
-- Table structure for config
-- ----------------------------
DROP TABLE IF EXISTS `config`;
CREATE TABLE `config` (
                          `id` int NOT NULL AUTO_INCREMENT,
                          `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
                          `key` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
                          `value` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
                          `created_at` timestamp NULL DEFAULT NULL,
                          `updated_at` timestamp NULL DEFAULT NULL,
                          PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='配置表';

-- ----------------------------
-- Records of config
-- ----------------------------
BEGIN;
INSERT INTO `config` VALUES (13, '回调地址', 'pay_notify_url', 'http://ios.server.com/', NULL, NULL);
INSERT INTO `config` VALUES (14, 'TG消息服务器', 'tg_msg_server', 'http://noticenter_server.test.wg8.site/', NULL, NULL);
INSERT INTO `config` VALUES (15, 'TG接口AUTH-TOKEN', 'tg_api_token', '01bf1a5d15c01b12b289bda6c8838bf4', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for merchant
-- ----------------------------
DROP TABLE IF EXISTS `merchant`;
CREATE TABLE `merchant` (
                            `id` int NOT NULL AUTO_INCREMENT,
                            `uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
                            `username` varchar(100) COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户名',
                            `account` varchar(100) COLLATE utf8mb4_general_ci NOT NULL COMMENT '账号名',
                            `password` varchar(255) COLLATE utf8mb4_general_ci NOT NULL COMMENT '密码',
                            `status` tinyint NOT NULL DEFAULT '1' COMMENT '状态:1,启用;2禁用',
                            `merchant_code` varchar(100) COLLATE utf8mb4_general_ci NOT NULL COMMENT '商户号',
                            `key` varchar(300) COLLATE utf8mb4_general_ci NOT NULL COMMENT '商户密钥',
                            `cache_notice_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '缓存消息通知地址',
                            `created_at` datetime DEFAULT NULL,
                            `updated_at` datetime DEFAULT NULL,
                            PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='商户表';

-- ----------------------------
-- Table structure for merchant_payment_type
-- ----------------------------
DROP TABLE IF EXISTS `merchant_payment_type`;
CREATE TABLE `merchant_payment_type` (
                                         `id` int NOT NULL AUTO_INCREMENT,
                                         `merchant_uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
                                         `payment_type_uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
                                         `created_at` datetime DEFAULT NULL,
                                         `updated_at` datetime DEFAULT NULL,
                                         PRIMARY KEY (`id`),
                                         UNIQUE KEY `merchant_uid_payment_type_uid` (`merchant_uid`,`payment_type_uid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='商户通道关联表';


-- ----------------------------
-- Table structure for order
-- ----------------------------
DROP TABLE IF EXISTS `order`;
CREATE TABLE `order` (
                         `id` int NOT NULL AUTO_INCREMENT,
                         `order_sn` varchar(125) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '订单号',
                         `merchant_order_sn` varchar(125) COLLATE utf8mb4_general_ci NOT NULL COMMENT '商户订单号',
                         `merchant_uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '商户uid',
                         `order_amount` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '订单金额',
                         `real_amount` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '实付金额',
                         `status` tinyint NOT NULL DEFAULT '1' COMMENT '1待支付2已支付3已取消',
                         `notice_status` tinyint NOT NULL DEFAULT '1' COMMENT '1未通知 2已通知',
                         `payment_uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '支付方式uid',
                         `payment_attr_uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '支付通道uid',
                         `pay_type` tinyint NOT NULL DEFAULT '1' COMMENT '支付类型：1,支付宝;2,微信;3:usdt;',
                         `notify_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '商户异步通知地址',
                         `redirect_url` varchar(255) COLLATE utf8mb4_general_ci NOT NULL COMMENT '同步跳转地址',
                         `product_name` varchar(255) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '商品名',
                         `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '备注',
                         `callback_sent_times` int NOT NULL DEFAULT '0' COMMENT '回调发送次数',
                         `merchant_info` varchar(500) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '商户请求数据',
                         `created_at` datetime DEFAULT NULL,
                         `updated_at` datetime DEFAULT NULL,
                         `notice_at` datetime DEFAULT NULL COMMENT '通知时间',
                         `pay_at` datetime DEFAULT NULL COMMENT '支付时间',
                         PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='订单表';

-- ----------------------------
-- Table structure for pay_total
-- ----------------------------
DROP TABLE IF EXISTS `pay_total`;
CREATE TABLE `pay_total` (
                             `id` int NOT NULL AUTO_INCREMENT,
                             `merchant_uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
                             `payment_uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
                             `payment_attr_uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
                             `total_order` int NOT NULL DEFAULT '0' COMMENT '总单数',
                             `success_order` int NOT NULL DEFAULT '0' COMMENT '成功单数',
                             `total_amount` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '总金额',
                             `success_amount` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '成功金额',
                             `date` date NOT NULL COMMENT '插入时间',
                             `created_at` datetime DEFAULT NULL,
                             `updated_at` datetime DEFAULT NULL,
                             PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='统计表';

-- ----------------------------
-- Table structure for payment
-- ----------------------------
DROP TABLE IF EXISTS `payment`;
CREATE TABLE `payment` (
                           `id` int unsigned NOT NULL AUTO_INCREMENT,
                           `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '名称',
                           `pay_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '通道编码',
                           `partner_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '商户号',
                           `uid` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
                           `status` int NOT NULL DEFAULT '1' COMMENT '状态 1开启; 2: 禁用',
                           `created_at` datetime DEFAULT NULL COMMENT '创建时间',
                           `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
                           PRIMARY KEY (`id`) USING BTREE,
                           KEY `idx_uid` (`uid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='支付方式';


-- ----------------------------
-- Table structure for payment_attr
-- ----------------------------
DROP TABLE IF EXISTS `payment_attr`;
CREATE TABLE `payment_attr` (
                                `id` int unsigned NOT NULL AUTO_INCREMENT,
                                `uid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
                                `pay_uid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '通道uid',
                                `code` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '标识',
                                `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '名称',
                                `status` int NOT NULL DEFAULT '1' COMMENT '状态 1开启; 2: 禁用',
                                `created_at` datetime DEFAULT NULL,
                                `updated_at` datetime DEFAULT NULL,
                                PRIMARY KEY (`id`) USING BTREE,
                                UNIQUE KEY `p_uid` (`uid`) USING BTREE,
                                KEY `pay_code_key` (`pay_uid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='支付通道';

-- ----------------------------
-- Table structure for payment_type
-- ----------------------------
DROP TABLE IF EXISTS `payment_type`;
CREATE TABLE `payment_type` (
                                `id` int unsigned NOT NULL AUTO_INCREMENT,
                                `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '名称',
                                `payment_uid` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '关联外键',
                                `payment_attr_uid` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '支付类型UID',
                                `pay_type` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '支付类型：1,支付宝;2,微信;5:usdt;',
                                `limit_type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '限制类型 1 固定金额;2 金额范围 ',
                                `limit` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '支持的金额范围',
                                `status` tinyint unsigned NOT NULL DEFAULT '1' COMMENT '状态 1开启; 2: 禁用',
                                `weights` int unsigned NOT NULL DEFAULT '0' COMMENT '支付权重',
                                `rate` int NOT NULL DEFAULT '0' COMMENT '费率',
                                `uid` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
                                `belong_device` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '空为所有; A-安卓；I-ios',
                                `remark` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '备注',
                                `created_at` timestamp NULL DEFAULT NULL COMMENT '创建时间',
                                `updated_at` timestamp NULL DEFAULT NULL COMMENT '更新时间',
                                PRIMARY KEY (`id`) USING BTREE,
                                KEY `idx_uid` (`uid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='支付类型表';