/* 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='支付类型表';