From 33caf2bb79bb3c561916c91ae386ec772411e2e8 Mon Sep 17 00:00:00 2001
From: rk <94314517@qq.com>
Date: 星期一, 11 五月 2026 18:21:50 +0800
Subject: [PATCH] 代码生成
---
server/services/db/db_change.sql | 37 +++++++++++++++++++++++++++++++++++++
1 files changed, 37 insertions(+), 0 deletions(-)
diff --git a/server/services/db/db_change.sql b/server/services/db/db_change.sql
index 37d5d8a..e9ce016 100644
--- a/server/services/db/db_change.sql
+++ b/server/services/db/db_change.sql
@@ -5,6 +5,43 @@
-- ============================================================
+-- 2026/05/11 鍙告満鐗堟湰绫诲瀷瀛楁
+-- ============================================================
+ALTER TABLE `driver_info` ADD COLUMN `VERSION_TYPE` INT DEFAULT 0 COMMENT '鍙告満鐗堟湰绫诲瀷锛�0=姝ｅ紡鐗堟湰锛�1=鍙樻洿鐗堟湰';
+ALTER TABLE `driver_info` ADD COLUMN `RELATION_DRIVER_ID` INT DEFAULT NULL COMMENT '鍏宠仈姝ｅ紡鐗堟湰鍙告満涓婚敭锛堝彉鏇寸増鏈娇鐢級';
+
+
+-- ============================================================
+-- 2026/05/09 闂ㄥ簵鏀剁泭姣斾緥閰嶇疆瀛楁
+-- ============================================================
+ALTER TABLE `shop_info` ADD COLUMN `REVENUE_SHARE_CONFIG` TEXT COMMENT '鏀剁泭姣斾緥閰嶇疆(JSON): remoteCompanyDeposit/remotePersonalDeposit/remoteCompanyTake/remotePersonalTake/localCompanyDeposit/localPersonalDeposit';
+
+ALTER TABLE `member` ADD COLUMN `LOGIN_SHOP_ID` INT COMMENT '宸茬櫥褰曠殑闂ㄥ簵涓婚敭';
+
+ALTER TABLE `shop_info` ADD COLUMN `VERSION_TYPE` INT DEFAULT 0 COMMENT '闂ㄥ簵鐗堟湰绫诲瀷锛�0=姝ｅ紡鐗堟湰锛�1=鍙樻洿鐗堟湰';
+ALTER TABLE `shop_info` ADD COLUMN `RELATION_SHOP_ID` INT COMMENT '鍏宠仈姝ｅ紡鐗堟湰闂ㄥ簵涓婚敭锛堝彉鏇寸増鏈娇鐢級';
+
+
+-- ============================================================
+-- 2026/05/07 鎿嶄綔鍗婂緞鏍￠獙閰嶇疆
+-- ============================================================
+INSERT INTO `system_dict_data` (`DICT_ID`, `CODE`, `LABEL`, `REMARK`, `SORT`, `DISABLED`, `CREATE_USER`, `CREATE_TIME`, `DELETED`) VALUES ((SELECT `id` FROM `system_dict` WHERE `code` = 'OPERATION_CONFIG'), '500', 'OPERATION_RADIUS', '鍏佽鎿嶄綔鍗婂緞(m)', 0, 0, 1, NOW(), 0);
+
+
+-- ============================================================
+-- 2026/05/07 鍗冲皢鍒拌揪鍙栦欢鏃堕棿閫氱煡鐩稿叧鍙樻洿
+-- ============================================================
+-- 璁㈠崟琛ㄥ鍔犲彇浠堕�氱煡鐘舵�佸瓧娈�
+ALTER TABLE `orders` ADD COLUMN `PICK_UP_NOTIFY_STATUS` INT DEFAULT 0 COMMENT '鍙栦欢鏃堕棿鍗冲皢鍒拌揪閫氱煡鐘舵�侊細0=鏈�氱煡锛�1=宸查�氱煡';
+
+-- 杩愯惀閰嶇疆锛氬嵆灏嗗埌杈惧彇浠舵椂闂存彁鍓嶉�氱煡(鍒嗛挓)
+INSERT INTO `system_dict_data` (`DICT_ID`, `CODE`, `LABEL`, `REMARK`, `SORT`, `DISABLED`, `CREATE_USER`, `CREATE_TIME`, `DELETED`) VALUES ((SELECT `id` FROM `system_dict` WHERE `code` = 'OPERATION_CONFIG'), '30', 'ARRIVAL_PICK_UP_TIME', '鍗冲皢鍒拌揪鍙栦欢鏃堕棿鎻愬墠閫氱煡(鍒嗛挓)', 0, 0, 1, NOW(), 0);
+
+-- 瀹氭椂浠诲姟锛氬嵆灏嗗埌杈惧彇浠舵椂闂撮�氱煡锛堟瘡5鍒嗛挓鎵ц涓�娆★級
+INSERT INTO `system_job` (`JOB_NAME`, `HANDLER`, `CRON`, `WITH_LOG`, `WITH_ASYNC`, `STATUS`, `REMARK`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('鍗冲皢鍒拌揪鍙栦欢鏃堕棿閫氱煡', 'arrivalPickUpNotifyJob', '0 */5 * * * ?', 1, 0, 1, '鏌ヨ鍗冲皢鍒拌揪鍙栦欢鏃堕棿鐨勮鍗曪紝鍙戦�佺煭淇￠�氱煡浼氬憳', 1, NOW(), 1, NOW(), 0);
+
+
+-- ============================================================
-- 2026/04/30 APP鐗堟湰鏂囦欢涓婁紶瀛楀吀閰嶇疆
-- ============================================================
INSERT INTO `system_dict_data` (`DICT_ID`, `CODE`, `LABEL`, `REMARK`, `SORT`, `DISABLED`, `CREATE_USER`, `CREATE_TIME`, `DELETED`) VALUES ((SELECT `id` FROM `system_dict` WHERE `code` = 'OSS'), '', 'APP_FILES', 'APP鐗堟湰鏂囦欢瀛樺偍璺緞', 0, 0, 1, NOW(), 0);
--
Gitblit v1.9.3