From e9e42b621afdf6ac94f5327ee843b32b10a401b4 Mon Sep 17 00:00:00 2001
From: liujie <1793218484@qq.com>
Date: 星期二, 04 八月 2026 17:45:14 +0800
Subject: [PATCH] update
---
backend/db/schema.sql | 20 ++++++++++++++++++++
1 files changed, 20 insertions(+), 0 deletions(-)
diff --git a/backend/db/schema.sql b/backend/db/schema.sql
index bbc40a4..0296cd4 100644
--- a/backend/db/schema.sql
+++ b/backend/db/schema.sql
@@ -335,6 +335,8 @@
`updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_tour_order_no` (`order_no`),
+ UNIQUE KEY `uk_tour_order_payment_order_no` (`payment_order_no`),
+ UNIQUE KEY `uk_tour_order_refund_order_no` (`refund_order_no`),
KEY `idx_tour_order_visitor` (`visitor_id`),
KEY `idx_tour_order_guide` (`guide_id`),
KEY `idx_tour_order_guide_earning` (`guide_id`, `status`, `completed_at`),
@@ -345,6 +347,24 @@
CONSTRAINT `fk_tour_order_guide` FOREIGN KEY (`guide_id`) REFERENCES `guide_user` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='游客讲解服务订单表';
+CREATE TABLE IF NOT EXISTS `tour_order_payment_attempt` (
+ `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Payment attempt primary key',
+ `order_id` BIGINT UNSIGNED NOT NULL COMMENT 'Tour order primary key',
+ `req_seq_id` VARCHAR(64) NOT NULL COMMENT 'Huifu request sequence',
+ `req_date` CHAR(8) NOT NULL COMMENT 'Huifu request date yyyyMMdd',
+ `amount` DECIMAL(10,2) NOT NULL COMMENT 'Payment attempt amount',
+ `status` VARCHAR(16) NOT NULL DEFAULT 'CREATED' COMMENT 'CREATED or SUCCEEDED',
+ `provider_transaction_id` VARCHAR(64) DEFAULT NULL COMMENT 'Huifu transaction id',
+ `paid_at` DATETIME DEFAULT NULL COMMENT 'Payment success time',
+ `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created time',
+ `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated time',
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `uk_order_payment_attempt_req_seq` (`req_seq_id`),
+ UNIQUE KEY `uk_order_payment_attempt_provider_tx` (`provider_transaction_id`),
+ KEY `idx_order_payment_attempt_order` (`order_id`, `status`),
+ CONSTRAINT `fk_order_payment_attempt_order` FOREIGN KEY (`order_id`) REFERENCES `tour_order` (`id`) ON DELETE RESTRICT
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Tour order payment attempts';
+
CREATE TABLE IF NOT EXISTS `tour_order_review` (
`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '评价主键',
`review_no` VARCHAR(32) NOT NULL COMMENT '评价业务编号',
--
Gitblit v1.7.1