2024最版源支付YPay-V7版本开源版V1.0.2

CREATE TABLE `admin_admin` ( `id` int(11) UNSIGNED NOT NULL COMMENT 'ID', `username` varchar(30) NOT NULL COMMENT '用户名，登陆使用', `password` varchar(30) NOT NULL COMMENT '用户密码', `nickname` varchar(30) NOT NULL COMMENT '用户昵称', `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '用户状态：1正常,2禁用 默认1', `token` varchar(60) DEFAULT NULL COMMENT 'token', `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间', `update_time` timestamp NULL DEFAULT NULL COMMENT '更新时间' ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='管理表'; -- -------------------------------------------------------- -- -- 表的结构 `admin_admin_log` -- CREATE TABLE `admin_admin_log` ( `id` int(11) UNSIGNED NOT NULL COMMENT 'ID', `uid` int(11) DEFAULT NULL COMMENT '管理员ID', `url` varchar(255) NOT NULL DEFAULT '' COMMENT '操作页面', `desc` text COMMENT '日志内容', `ip` varchar(20) NOT NULL DEFAULT '' COMMENT '操作IP', `user_agent` text NOT NULL COMMENT 'User-Agent', `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间' ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='管理员日志'; -- -------------------------------------------------------- -- -- 表的结构 `admin_admin_permission` -- CREATE TABLE `admin_admin_permission` ( `id` int(11) UNSIGNED NOT NULL COMMENT 'ID', `admin_id` int(11) DEFAULT NULL COMMENT '用户ID', `permission_id` int(11) DEFAULT NULL COMMENT '权限ID' ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='管理-权限中间表'; -- -------------------------------------------------------- -- -- 表的结构 `admin_admin_role` -- CREATE TABLE `admin_admin_role` ( `id` int(11) UNSIGNED NOT NULL COMMENT 'ID', `admin_id` int(11) DEFAULT NULL COMMENT '用户ID', `role_id` int(11) DEFAULT NULL COMMENT '角色ID' ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='管理-角色中间表'; -- -------------------------------------------------------- -- -- 表的结构 `admin_channel` -- CREATE TABLE `admin_channel` ( `id` int(11) UNSIGNED NOT NULL COMMENT 'id', `name` varchar(50) DEFAULT NULL COMMENT '通道名称', `type` varchar(50) DEFAULT NULL COMMENT '支付类型', `create_type` int(1) DEFAULT '1' COMMENT '创建类型', `code` varchar(50) DEFAULT NULL COMMENT '通道标识', `info` varchar(225) DEFAULT NULL COMMENT '通道介绍', `status` int(11) NOT NULL DEFAULT '1' COMMENT '通道状态', `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间', `sort` int(11) NOT NULL DEFAULT '0' COMMENT '排序', `maxcount` int(11) NOT NULL DEFAULT '10' ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='通道列表'; -- -- 转存表中的数据 `admin_channel` -- INSERT INTO `admin_channel` (`id`, `name`, `type`, `create_type`, `code`, `info`, `status`, `create_time`, `sort`, `maxcount`) VALUES (2, '支付宝个人版', 'alipay', 1, 'alipay_grmg', '支付宝个人版免挂', 1, '2022-05-19 04:28:59', 5, 10), (3, '支付宝软件版', 'alipay', 1, 'alipay_pc', '用户自行使用软件挂机', 1, '2022-05-19 04:30:03', 3, 10), (5, '微信店员版', 'wxpay', 1, 'wxpay_dy', '微信店员免挂模式', 1, '2022-05-22 17:51:43', 6, 10), (6, '云端免输入', 'wxpay', 1, 'wxpay_cloud', '微信云端免输入金额', 1, '2022-05-22 17:52:25', 11, 10), (7, '微信赞赏码', 'wxpay', 1, 'wxpay_cloudzs', '赞赏码通道', 1, '2022-05-25 22:38:48', 7, 10), (8, '微信收款单', 'wxpay', 1, 'wxpay_skd', '微信收款单通道', 1, '2022-05-25 22:39:14', 8, 10), (9, 'QQ免挂-财付通', 'qqpay', 1, 'qqpay_mg', 'QQ本地免挂通道', 1, '2022-05-30 22:52:39', 13, 10), (10, 'QQ免挂-PCQQ', 'qqpay', 1, 'qqpay_cloud', 'MYQQ软件挂机', 1, '2022-05-30 22:53:23', 12, 10), (11, '微信个人自挂', 'wxpay', 1, 'wxpay_zg', '鲲鹏框架用户自挂', 1, '2022-06-02 18:52:46', 9, 10), (12, '微信APP挂机', 'wxpay', 1, 'wxpay_app', '微信APP软件挂机', 1, '2022-06-15 04:31:24', 10, 10), (13, '支付宝APP挂机', 'alipay', 1, 'alipay_app', '支付宝APP挂机', 1, '2022-06-15 04:31:54', 0, 10), (14, '支付宝当面付', 'alipay', 1, 'alipay_dmf', '支付宝当面付接口', 1, '2022-07-02 01:57:03', 1, 10), (15, '超级无敌免挂[永不掉线]', 'alipay', 1, 'alipay_mck', '支付宝免CK无需挂机', 1, '2023-05-29 09:21:49', 14, 10), (18, 'PCQQ自挂', 'qqpay', 1, 'qqpay_zg', 'QQPC自挂', 1, '2023-06-07 06:49:59', 15, 10), (19, '拉卡拉-微信', 'wxpay', 1, 'lkl_wxpay', '拉卡拉微信收银台', 1, '2023-10-18 12:29:56', 0, 10), (20, '拉卡拉-支付宝', 'alipay', 1, 'lkl_alipay', '拉卡拉支付宝收银台', 1, '2023-10-18 12:30:41', 0, 10), (21, '微信转QQ', 'wxpay', 1, 'qqpay_wzq', '微信转QQ支付', 1, '2023-10-28 03:54:47', 0, 10); -- -------------------------------------------------------- -- -- 表的结构 `admin_config` -- CREATE TABLE `admin_config` ( `id` int(11) NOT NULL, `config_name` varchar(191) NOT NULL, `config_value` longtext ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- 转存表中的数据 `admin_config` -- INSERT INTO `admin_config` (`id`, `config_name`, `config_value`) VALUES (1, 'sitename', 'YPay'), (2, 'title', '一个专业的系统平台开发商,值得一试'), (3, 'key', 'YPay,源支付'), (4, 'desc', '一个专业的系统平台开发商,值得一试'), (5, 'icp', ''), (6, 'is_weboff', '1'), (8, 'logo', '/upload/images/20220825/cdacdbbf182b79cf9303bf4767273094.png'), (9, 'diy_js', ''), (10, 'smtp-host', ''), (11, 'SmtpSecure', 'ssl'), (12, 'smtp-port', ''), (13, 'smtp-user', ''), (14, 'smtp-pass', ''), (15, 'smstype', 'qcloud'), (16, 'alisms-accessKeyId', ''), (17, 'alisms-Secret', ''), (18, 'alisms-SignName', ''), (19, 'alisms-LoginCodeId', ''), (20, 'alisms-RegCodeId', ''), (21, 'tensms-accessKeyId', ''), (22, 'tensms-Secret', ''), (23, 'tensms-SignName', ''), (24, 'tensms-AppId', ''), (25, 'tensms-LoginCodeId', ''), (26, 'tensms-RegCodeId', ''), (27, 'smsbao-user', ''), (28, 'smsbao-pass', ''), (29, 'smsbao-SignName', ''), (30, 'file-type', '1'), (31, 'file-endpoint', ''), (32, 'file-OssName', ''), (33, 'file-accessKeyId', ''), (34, 'file-accessKeySecret', ''), (35, 'qiniu-Domain', ''), (36, 'qiniu-Bucket', ''), (37, 'qiniu-AK', ''), (38, 'qiniu-SK', ''), (39, 'min_orderprice', '0'), (40, 'max_orderprice', '1000'), (41, 'shield_key', '百度云|摆渡|云盘|点券|芸盘|萝莉|罗莉|网盘|黑号|q币|Q币|扣币|qq货币|QQ货币|花呗|baidu云|bd云|吃鸡|透视|自瞄|后座|穿墙|脚本|外挂|辅助|检测|武器|套装'), (42, 'shield_tips', '温馨提醒该商品禁止出售，如有疑问请联系客服QQ：'), (46, 'diy_clerkqr', ''), (55, 'clerk_key', ''), (63, 'clerk_id', ''), (64, 'diy_task_key', ''), (65, 'bgtype', '0'), (66, 'bg', ''), (67, 'api_bg', ''), (69, 'reg_give_price', '1'), (70, 'logincode-type', '0'), (71, 'regcode-type', '2'), (72, 'user_agreement', ''), (73, 'privacy', '<p>#</p>'), (80, 'is_reg_give_price', '0'), (85, 'demopay_name', '一个奥利奥'), (96, 'captcha-type', '1'), (97, 'tencent_CaptchaAppId', ''), (98, 'tencent_CaptchaKey', ''), (99, 'geetest_CaptchaAppId', ''), (100, 'geetest_CaptchaKey', ''), (101, 'is_aff', '0'), (102, 'aff_percentage', '0.1'), (103, 'pay_api', '/'), (104, 'aff_type', '0'), (106, 'smsbao-api', ''), (107, 'email_switch', '1'), (108, 'code_switch', '1'), (109, 'is_reg', '1'), (110, 'is_notice', '1'), (111, 'sh_notice', ''), (112, 'td_notice', ''), (113, 'index_popup', ''), (114, 'reg_popup', ''), (120, 'paid_reg', '0'), (121, 'paid_reg_price', '0.01'), (122, 'is_reg_give_vip', '0'), (123, 'reg_give_vip', '4'), (125, 'min_recharge', '0'), (126, 'max_recharge', '1000'), (128, 'retrieve-type', '0'), (129, 'diy_orderTips', '你有一个新订单!请留意网站,订单号:[out_trade_no],商品名称:[name],商品金额:[money],�