From 72c0e8b2f656eebe7bef04b8763739340928d368 Mon Sep 17 00:00:00 2001 From: gaoluyang <2820782392@qq.com> Date: 星期六, 10 十月 2026 13:38:53 +0800 Subject: [PATCH] 天津-奇缘恒艺 1.录数据需求修改 --- doc/20261010_device_repair_maintenance_tenant_nullable.sql | 11 +++++++++++ sql/product-inventory-management-new-pro.sql | 4 ++-- 2 files changed, 13 insertions(+), 2 deletions(-) diff --git a/doc/20261010_device_repair_maintenance_tenant_nullable.sql b/doc/20261010_device_repair_maintenance_tenant_nullable.sql new file mode 100644 index 0000000..f947a59 --- /dev/null +++ b/doc/20261010_device_repair_maintenance_tenant_nullable.sql @@ -0,0 +1,11 @@ +-- 璁惧鎶ヤ慨/璁惧淇濆吇 tenant_id 鏀惧紑涓哄彲绌� +-- 鍘熷洜锛歵enant_id 鐢� MybatisHandler 鑷姩濉厖锛屽彇鐧诲綍鐢ㄦ埛鐨� tenantId锛� +-- 鍗曞叕鍙稿鎴凤紙鐧诲綍鏈�夊伐鍘備笖 sys_user.tenant_id 涓虹┖锛夋椂璇ュ�间负 null锛� +-- 鑰� device_repair / device_maintenance 寤鸿〃鍐欐垚浜� NOT NULL锛屽鑷存彃鍏ユ姤 +-- "Column 'tenant_id' cannot be null"銆傚悓绾ц〃 device_ledger 绛夋湰灏卞彲绌猴紝 +-- 涓旀暟鎹潈闄愯繃婊わ紙DataScopeSqlInterceptor锛変笉浣跨敤 tenant_id銆� +ALTER TABLE `device_repair` + MODIFY COLUMN `tenant_id` bigint NULL DEFAULT NULL COMMENT '绉熸埛id'; + +ALTER TABLE `device_maintenance` + MODIFY COLUMN `tenant_id` bigint NULL DEFAULT NULL COMMENT '绉熸埛id'; diff --git a/sql/product-inventory-management-new-pro.sql b/sql/product-inventory-management-new-pro.sql index 2752b38..351ef88 100644 --- a/sql/product-inventory-management-new-pro.sql +++ b/sql/product-inventory-management-new-pro.sql @@ -1037,7 +1037,7 @@ `update_time` datetime NULL DEFAULT NULL COMMENT '鏇存柊鏃堕棿', `create_user` int NOT NULL COMMENT '褰曞叆浜�', `update_user` int NOT NULL COMMENT '鏇存柊浜�', - `tenant_id` bigint NOT NULL COMMENT '绉熸埛id', + `tenant_id` bigint NULL DEFAULT NULL COMMENT '绉熸埛id', `device_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `device_model` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `maintenance_result` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '淇濆吇缁撴灉', @@ -1089,7 +1089,7 @@ `update_time` datetime NULL DEFAULT NULL COMMENT '鏇存柊鏃堕棿', `create_user` int NOT NULL COMMENT '褰曞叆浜�', `update_user` int NULL DEFAULT NULL COMMENT '鏇存柊浜�', - `tenant_id` bigint NOT NULL COMMENT '绉熸埛id', + `tenant_id` bigint NULL DEFAULT NULL COMMENT '绉熸埛id', `device_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `device_model` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `maintenance_price` decimal(10, 2) NULL DEFAULT NULL COMMENT '缁翠慨浠锋牸', -- Gitblit v1.9.3