From e39dda2f25df9680e66c9e0dd3a606149e21bcc5 Mon Sep 17 00:00:00 2001 From: rk <94314517@qq.com> Date: 星期三, 22 四月 2026 20:06:37 +0800 Subject: [PATCH] 代码生成 --- server/services/db/db_change.sql | 40 ++++++++++++++++++++++++++++++++++++++++ 1 files changed, 40 insertions(+), 0 deletions(-) diff --git a/server/services/db/db_change.sql b/server/services/db/db_change.sql index 96b2a07..de96424 100644 --- a/server/services/db/db_change.sql +++ b/server/services/db/db_change.sql @@ -5,6 +5,46 @@ -- ============================================================ +-- 2026/04/22 璁㈠崟閫�娆捐〃鏂板閫�娆惧墠璁㈠崟鐘舵�佸瓧娈� +-- ============================================================ +ALTER TABLE `orders_refund` ADD COLUMN `BEFORE_STATUS` INT NULL DEFAULT NULL COMMENT '閫�娆惧墠璁㈠崟鐘舵��' AFTER `STATUS`; + + +-- ============================================================ +-- 2026/04/22 璁㈠崟閫�娆捐〃鏂板閫�娆鹃噾棰濆瓧娈� +-- ============================================================ +ALTER TABLE `orders_refund` ADD COLUMN `REFUND_AMOUNT` BIGINT NULL DEFAULT NULL COMMENT '閫�娆鹃噾棰濓紙鍒嗭級' AFTER `REFUND_REMARK`; + + +-- ============================================================ +-- 2026/04/22 鏂板璁㈠崟鑷姩缁撶畻瀹氭椂浠诲姟 +-- ============================================================ +INSERT INTO `SYSTEM_JOB` VALUES (4, '璁㈠崟鑷姩缁撶畻', '鏍规嵁杩愯惀閰嶇疆SETTLEMENT_DATE锛屽皢宸插畬鎴愮殑寰呯粨绠楄鍗曡繘琛岀粨绠�', 'settleOrdersJob', NULL, NULL, 1, 0, 1, 1, '0 0 2 * * ?', '', 0, NULL, 0, 1, NOW(), NULL, NULL, 0); + + +-- ============================================================ +-- 2026/04/22 杩愯惀閰嶇疆鏂板鏃犱汉鎶㈠崟閫氱煡鏃堕棿鍜岄�氱煡浜哄憳 +-- ============================================================ +INSERT INTO `SYSTEM_DICT_DATA` (`DICT_ID`, `CODE`, `LABEL`, `SORT`, `DISABLED`, `CREATE_USER`, `CREATE_TIME`, `DELETED`) VALUES (105, '30', 'NO_GRAB_NOTIFY_TIME', 0, 0, 1, NOW(), 0); +INSERT INTO `SYSTEM_DICT_DATA` (`DICT_ID`, `CODE`, `LABEL`, `SORT`, `DISABLED`, `CREATE_USER`, `CREATE_TIME`, `DELETED`) VALUES (105, '', 'NO_GRAB_NOTIFY_USERS', 0, 0, 1, NOW(), 0); + + +-- ============================================================ +-- 2026/04/22 璁㈠崟琛ㄥ鍔犳棤浜烘帴鍗曟槸鍚﹀凡鐭俊閫氱煡骞冲彴瀛楁 +-- ============================================================ +ALTER TABLE `orders` ADD COLUMN `PLATFORM_SMS_NOTIFIED` INT DEFAULT 0 COMMENT '鏃犱汉鎺ュ崟鏄惁宸茬煭淇￠�氱煡骞冲彴锛�0=鍚︼紱1=鏄�' AFTER `OUT_TRADE_NO`; +ALTER TABLE `orders` ADD COLUMN `PLATFORM_SMS_NOTIFIED_TIME` DATETIME DEFAULT NULL COMMENT '鏃犱汉鎺ュ崟宸茬煭淇￠�氱煡骞冲彴鏃堕棿' AFTER `PLATFORM_SMS_NOTIFIED`; + + +-- ============================================================ +-- 2026/04/22 鏂板璁㈠崟鐩稿叧瀹氭椂浠诲姟锛堜笁涓嫭绔嬩换鍔★級 +-- ============================================================ +INSERT INTO `SYSTEM_JOB` VALUES (3, '瓒呮椂鍙栨秷璁㈠崟', '鏍规嵁杩愯惀閰嶇疆AUTO_CANCEL_TIME锛堝垎閽燂級锛屽彇娑堣秴鏃舵湭鏀粯璁㈠崟', 'cancelTimeoutOrderJob', NULL, NULL, 1, 0, 1, 1, '0 */1 * * * ?', '', 0, NULL, 0, 1, NOW(), NULL, NULL, 0); +INSERT INTO `SYSTEM_JOB` VALUES (5, '鏃犱汉鎶㈠崟閫氱煡', '鏍规嵁杩愯惀閰嶇疆NO_GRAB_NOTIFY_TIME锛堝垎閽燂級锛屽宸插瘎瀛樹笖鏃犱汉鎶㈠崟鐨勮鍗曞彂閫佺煭淇￠�氱煡骞冲彴浜哄憳', 'noGrabNotifyJob', NULL, NULL, 1, 0, 1, 1, '0 */1 * * * ?', '', 0, NULL, 0, 1, NOW(), NULL, NULL, 0); +INSERT INTO `SYSTEM_JOB` VALUES (6, '鑷姩瀹屾垚璁㈠崟', '鏍规嵁杩愯惀閰嶇疆AUTO_CONFIRM_RECEIPT锛堝ぉ锛夛紝鑷姩瀹屾垚瓒呮椂鏈‘璁ょ殑宸查�佽揪璁㈠崟', 'autoCompleteOrderJob', NULL, NULL, 1, 0, 1, 1, '0 0 */1 * * ?', '', 0, NULL, 0, 1, NOW(), NULL, NULL, 0); + + +-- ============================================================ -- 2026/04/22 鎻愮幇璁板綍琛ㄥ鍔犳敮浠樺疂瀹炲悕濮撳悕瀛楁 -- ============================================================ ALTER TABLE `withdrawal_orders` ADD COLUMN `ALI_NAME` VARCHAR(50) DEFAULT NULL COMMENT '鏀粯瀹濆疄鍚嶅鍚�' AFTER `ALI_ACCOUNT`; -- Gitblit v1.9.3