From 4f6f15b818704079ff2e4e4719b798f48d68a335 Mon Sep 17 00:00:00 2001
From: liujie <1793218484@qq.com>
Date: 星期五, 11 九月 2026 13:52:19 +0800
Subject: [PATCH] update
---
backend/db/schema.sql | 23 ++++++++++++++++++++++-
1 files changed, 22 insertions(+), 1 deletions(-)
diff --git a/backend/db/schema.sql b/backend/db/schema.sql
index cb0fb14..1dd55d4 100644
--- a/backend/db/schema.sql
+++ b/backend/db/schema.sql
@@ -122,6 +122,7 @@
`current_month_order_count` BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '本月接单数',
`rating` DECIMAL(3,2) NOT NULL DEFAULT 0.00 COMMENT '平均评分，范围0到5',
`auto_disable_whitelisted` TINYINT NOT NULL DEFAULT 0 COMMENT '自动禁用白名单：0否，1是',
+ `premium_enabled` TINYINT NOT NULL DEFAULT 0 COMMENT '精讲接单权限：0否，1是',
`auto_disabled` TINYINT NOT NULL DEFAULT 0 COMMENT '是否由自动禁用规则停用：0否，1是',
`wechat_open_id` VARCHAR(128) DEFAULT NULL COMMENT '导游收款微信 openID',
`balance` DECIMAL(12,2) NOT NULL DEFAULT 0.00 COMMENT '导游可提现余额',
@@ -211,6 +212,7 @@
`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '景区主键',
`scenic_code` VARCHAR(32) NOT NULL COMMENT '景区业务编号',
`scenic_name` VARCHAR(128) NOT NULL COMMENT '景区名称',
+ `grade` VARCHAR(16) NOT NULL DEFAULT '' COMMENT '景区等级，例如5A、4A',
`city_id` BIGINT UNSIGNED NOT NULL COMMENT '所属运营城市ID',
`status` TINYINT NOT NULL DEFAULT 1 COMMENT '状态：0禁用，1启用',
`first_order_lead_minutes` INT UNSIGNED NOT NULL DEFAULT 15 COMMENT '第一单开启讲解提前时间，单位分钟',
@@ -245,6 +247,7 @@
`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '汇合点主键',
`scenic_spot_id` BIGINT UNSIGNED NOT NULL COMMENT '景区ID',
`point_name` VARCHAR(128) NOT NULL COMMENT '汇合点名称',
+ `address` VARCHAR(500) DEFAULT NULL COMMENT '地图定位的具体地址',
`longitude` DECIMAL(10,6) NOT NULL COMMENT '经度',
`latitude` DECIMAL(10,6) NOT NULL COMMENT '纬度',
`status` TINYINT NOT NULL DEFAULT 1 COMMENT '状态：0禁用，1启用',
@@ -291,7 +294,7 @@
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='平台协议设置表';
INSERT INTO `agreement_setting` (`agreement_code`, `title`, `content`, `sort_order`)
-VALUES ('VISITOR_USER_AGREEMENT', '用户协议-游客', '', 1),
+VALUES ('VISITOR_USER_AGREEMENT', '服务条款-游客', '', 1),
('GUIDE_USER_AGREEMENT', '用户协议-导游', '', 2),
('VISITOR_PRIVACY_PERMISSION', '隐私与权限-游客', '', 3),
('EXPLANATION_SERVICE_NOTICE', '纯讲解服务须知协议', '', 4),
@@ -363,6 +366,23 @@
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_refund` (
+ `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Refund record primary key',
+ `order_id` BIGINT UNSIGNED NOT NULL COMMENT 'Tour order primary key',
+ `refund_order_no` VARCHAR(64) NOT NULL COMMENT 'Refund request sequence',
+ `refund_amount` DECIMAL(10,2) NOT NULL COMMENT 'Amount of this refund request',
+ `refund_status` VARCHAR(32) NOT NULL DEFAULT 'REFUNDING' COMMENT 'NONE, REFUNDING, PARTIAL, REFUNDED or REFUND_FAILED',
+ `refund_time` DATETIME DEFAULT NULL COMMENT 'Successful refund time',
+ `refund_method` VARCHAR(32) DEFAULT NULL COMMENT 'Refund payment method',
+ `deleted` TINYINT NOT NULL DEFAULT 0 COMMENT 'Logic delete flag',
+ `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_tour_order_refund_no` (`refund_order_no`),
+ KEY `idx_tour_order_refund_order` (`order_id`, `created_at`),
+ CONSTRAINT `fk_tour_order_refund_order` FOREIGN KEY (`order_id`) REFERENCES `tour_order` (`id`) ON DELETE RESTRICT
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Refund request history for tour orders';
+
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',
@@ -396,6 +416,7 @@
`scenic_name` VARCHAR(128) DEFAULT NULL COMMENT '订单景区名称快照',
`score` DECIMAL(2,1) NOT NULL COMMENT '评价分数，范围1到5',
`content` VARCHAR(1000) DEFAULT NULL COMMENT '评价内容',
+ `image_urls` TEXT DEFAULT NULL COMMENT '评价图片URL JSON',
`reviewed_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '评价时间',
`status` TINYINT NOT NULL DEFAULT 1 COMMENT '评价状态：0隐藏，1显示',
`deleted` TINYINT NOT NULL DEFAULT 0 COMMENT '逻辑删除标记：0正常，1删除',
--
Gitblit v1.7.1