From afbd257336933d9383c6af89a66dc1967515ea44 Mon Sep 17 00:00:00 2001
From: zj <1772600164@qq.com>
Date: Fri, 20 Mar 2026 19:14:09 +0800
Subject: [PATCH] 1
---
src/main/resources/sql/site_pay_option.sql | 16 ++++++++++++++++
1 files changed, 16 insertions(+), 0 deletions(-)
diff --git a/src/main/resources/sql/site_pay_option.sql b/src/main/resources/sql/site_pay_option.sql
new file mode 100644
index 0000000..988d8b3
--- /dev/null
+++ b/src/main/resources/sql/site_pay_option.sql
@@ -0,0 +1,16 @@
+-- 支付设置表：默认、支付1、支付2、支付3，可排序，参数随排序变动，可开关
+CREATE TABLE IF NOT EXISTS `site_pay_option` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `name` varchar(32) NOT NULL COMMENT '显示名称：默认、支付1、支付2、支付3',
+ `param` int(11) NOT NULL DEFAULT '0' COMMENT '参数 0/1/2/3，随排序变动',
+ `sort_order` int(11) NOT NULL DEFAULT '0' COMMENT '排序序号',
+ `enabled` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否开启：1开启 0关闭',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='支付设置（4项可拖拽排序、开关）';
+
+-- 初始化 4 条：默认:0 支付1:1 支付2:2 支付3:3
+INSERT INTO `site_pay_option` (`name`, `param`, `sort_order`, `enabled`) VALUES
+('默认', 0, 0, 1),
+('支付1', 1, 1, 1),
+('支付2', 2, 2, 1),
+('支付3', 3, 3, 1);
--
Gitblit v1.9.3