From cdaec80a5ffa474f69e5c36f0312be3c0abf2210 Mon Sep 17 00:00:00 2001
From: gaoluyang <2820782392@qq.com>
Date: 星期四, 05 十一月 2026 18:31:11 +0800
Subject: [PATCH] feat(crm): 投标保证金迁移到销售管理并关联销售台账
---
yudao-module-srm/src/main/resources/sql/srm_init.sql | 27 +--------------------------
1 files changed, 1 insertions(+), 26 deletions(-)
diff --git a/yudao-module-srm/src/main/resources/sql/srm_init.sql b/yudao-module-srm/src/main/resources/sql/srm_init.sql
index a7dcc50..bc5d7e0 100644
--- a/yudao-module-srm/src/main/resources/sql/srm_init.sql
+++ b/yudao-module-srm/src/main/resources/sql/srm_init.sql
@@ -205,29 +205,4 @@
KEY idx_purchase_order_id (purchase_order_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='SRM璇环杞噰璐鍗曡褰�';
--- 10. 鎶曟爣淇濊瘉閲戝彴璐�
-CREATE TABLE IF NOT EXISTS srm_bid_bond (
- id BIGINT NOT NULL AUTO_INCREMENT COMMENT '鎶曟爣淇濊瘉閲慖D',
- no VARCHAR(32) NOT NULL COMMENT '淇濊瘉閲戝崟鍙�',
- supplier_id BIGINT NOT NULL COMMENT '渚涘簲鍟咺D',
- project_name VARCHAR(255) DEFAULT NULL COMMENT '椤圭洰鍚嶇О',
- inquiry_id BIGINT DEFAULT NULL COMMENT '鍏宠仈璇环鍗旾D',
- purchase_order_id BIGINT DEFAULT NULL COMMENT '鍏宠仈閲囪喘璁㈠崟ID',
- bond_amount DECIMAL(24,6) NOT NULL DEFAULT 0 COMMENT '淇濊瘉閲戦噾棰�',
- pay_date DATE DEFAULT NULL COMMENT '缂寸撼鏃ユ湡',
- won BIT(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁涓爣',
- refund_status TINYINT NOT NULL DEFAULT 0 COMMENT '閫�鍥炵姸鎬侊細0鏈��鍥� 1閮ㄥ垎閫�鍥� 2宸查��鍥� 3鏃犻渶閫�鍥�',
- refund_amount DECIMAL(24,6) DEFAULT NULL COMMENT '閫�鍥為噾棰�',
- refund_date DATE DEFAULT NULL COMMENT '閫�鍥炴棩鏈�',
- remark VARCHAR(500) DEFAULT NULL COMMENT '澶囨敞',
- creator VARCHAR(64) DEFAULT '' COMMENT '鍒涘缓鑰�',
- create_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
- updater VARCHAR(64) DEFAULT '' COMMENT '鏇存柊鑰�',
- update_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿',
- deleted BIT(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
- PRIMARY KEY (id),
- UNIQUE KEY uk_no (no),
- KEY idx_supplier_id (supplier_id),
- KEY idx_inquiry_id (inquiry_id),
- KEY idx_refund_status (refund_status)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='SRM鎶曟爣淇濊瘉閲戝彴璐�';
+-- 10. 鎶曟爣淇濊瘉閲戝凡杩佽嚦 CRM 閿�鍞鐞嗭紙琛� crm_bid_bond锛岃 sql/mysql/20261105_crm_bid_bond.sql锛�
--
Gitblit v1.9.3