From a1dfce6c7266bf922ab913a922219a554f71ade2 Mon Sep 17 00:00:00 2001
From: gaoluyang <2820782392@qq.com>
Date: 星期一, 12 十月 2026 18:27:00 +0800
Subject: [PATCH] 宁夏万通需求:CRM 开票新增时客户、合同改为非必填

---
 docs/sql/config_export_all_20260928.sql |    4 ++--
 1 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/docs/sql/config_export_all_20260928.sql b/docs/sql/config_export_all_20260928.sql
index 30be983..993a853 100644
--- a/docs/sql/config_export_all_20260928.sql
+++ b/docs/sql/config_export_all_20260928.sql
@@ -2508,8 +2508,8 @@
 CREATE TABLE `crm_invoice` (
   `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'ID',
   `no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '寮�绁ㄧ紪鍙�',
-  `customer_id` bigint NOT NULL COMMENT '瀹㈡埛缂栧彿',
-  `contract_id` bigint NOT NULL COMMENT '鍚堝悓缂栧彿',
+  `customer_id` bigint DEFAULT NULL COMMENT '瀹㈡埛缂栧彿',
+  `contract_id` bigint DEFAULT NULL COMMENT '鍚堝悓缂栧彿',
   `owner_user_id` bigint NOT NULL COMMENT '璐熻矗浜虹紪鍙�',
   `invoice_type` int NOT NULL COMMENT '鍙戠エ绫诲瀷锛堝瓧鍏� crm_invoice_type锛�',
   `invoice_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '鍙戠エ鍙风爜',

--
Gitblit v1.9.3