From b51f6f0d5564b843aeb11f088873faa5aa2116ce Mon Sep 17 00:00:00 2001
From: Administrator <15274802129@163.com>
Date: Tue, 23 Jun 2026 22:22:54 +0800
Subject: [PATCH] feat(mall): 为订单支付流程添加订单号生成和更新功能
---
sql/mall_country_delivery.sql | 40 ++++++++++++++++++++++++++++++++++++++++
1 files changed, 40 insertions(+), 0 deletions(-)
diff --git a/sql/mall_country_delivery.sql b/sql/mall_country_delivery.sql
new file mode 100644
index 0000000..5a66763
--- /dev/null
+++ b/sql/mall_country_delivery.sql
@@ -0,0 +1,40 @@
+-- ============================================================
+-- 国家运费配置表
+-- ============================================================
+DROP TABLE IF EXISTS mall_country_delivery;
+CREATE TABLE mall_country_delivery (
+ ID BIGINT NOT NULL AUTO_INCREMENT COMMENT '主键',
+ REVISION INT DEFAULT 1 COMMENT '乐观锁',
+ CREATED_BY VARCHAR(32) DEFAULT 'system' COMMENT '创建人',
+ CREATED_TIME DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
+ UPDATED_BY VARCHAR(32) DEFAULT 'system' COMMENT '更新人',
+ UPDATED_TIME DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
+ COUNTRY_CODE VARCHAR(10) NOT NULL COMMENT '国家编码（ISO 3166-1，如 CN/US/JP）',
+ COUNTRY_NAME VARCHAR(64) NOT NULL COMMENT '国家名称（中文）',
+ SHIPPING_FEE DECIMAL(10,2) NOT NULL DEFAULT 0.00 COMMENT '运费（元）',
+ STATUS INT DEFAULT 1 COMMENT '状态：1-启用，0-禁用',
+ REMARK VARCHAR(255) COMMENT '备注',
+ PRIMARY KEY (ID),
+ UNIQUE KEY uk_country_code (COUNTRY_CODE)
+) COMMENT = '国家运费配置表';
+
+-- ----------------------------
+-- 默认数据
+-- ----------------------------
+INSERT INTO mall_country_delivery (COUNTRY_CODE, COUNTRY_NAME, SHIPPING_FEE, STATUS, REMARK) VALUES
+('CN', '中国', 0.00, 1, '国内免运费'),
+('US', '美国', 59.00, 1, NULL),
+('JP', '日本', 35.00, 1, NULL),
+('KR', '韩国', 30.00, 1, NULL),
+('GB', '英国', 50.00, 1, NULL),
+('DE', '德国', 50.00, 1, NULL),
+('FR', '法国', 50.00, 1, NULL),
+('AU', '澳大利亚', 55.00, 1, NULL),
+('CA', '加拿大', 55.00, 1, NULL),
+('SG', '新加坡', 28.00, 1, NULL);
+
+-- ============================================================
+-- 菜单注册 SQL（通过后台菜单管理页面操作，或直接执行）
+-- ============================================================
+-- INSERT INTO t_menu (MENU_NAME, URL, PERMS, ICON, TYPE, PARENT_ID, ORDER_NUM, CREATED_TIME)
+-- VALUES ('国家运费设置', 'modules/system/countryDeliveryList', 'countryDelivery:view', 'layui-icon-template-1', 0, {系统设置菜单ID}, 13, NOW());
--
Gitblit v1.9.1