From fbaeeeff5704f210bc6347454c0f16d255001822 Mon Sep 17 00:00:00 2001
From: gaoluyang <2820782392@qq.com>
Date: 星期三, 04 十一月 2026 16:32:09 +0800
Subject: [PATCH] refactor(srm): 重构供应商采购域，新增询价比价与保证金管理
---
sql/mysql/finance_module_init.sql | 24 ++++++++++++++++++++++++
1 files changed, 24 insertions(+), 0 deletions(-)
diff --git a/sql/mysql/finance_module_init.sql b/sql/mysql/finance_module_init.sql
index 0975882..881d60c 100644
--- a/sql/mysql/finance_module_init.sql
+++ b/sql/mysql/finance_module_init.sql
@@ -110,7 +110,9 @@
`net_value` decimal(24,6) NOT NULL DEFAULT 0 COMMENT '鍑�鍊� = 鍘熷�� - 绱鎶樻棫',
`location` varchar(255) NULL DEFAULT '' COMMENT '瀛樻斁鍦扮偣',
`department` varchar(128) NULL DEFAULT '' COMMENT '浣跨敤閮ㄩ棬',
+ `department_id` bigint NULL DEFAULT NULL COMMENT '浣跨敤閮ㄩ棬缂栧彿',
`keeper` varchar(64) NULL DEFAULT '' COMMENT '淇濈浜�',
+ `keeper_id` bigint NULL DEFAULT NULL COMMENT '淇濈浜虹敤鎴风紪鍙�',
`status` tinyint NOT NULL DEFAULT 1 COMMENT '鐘舵�侊細1鍦ㄧ敤 2闂茬疆 3缁翠慨涓� 4宸叉姤搴�',
`remark` varchar(500) NULL DEFAULT '' COMMENT '澶囨敞',
`creator` varchar(64) NULL DEFAULT '' COMMENT '鍒涘缓鑰�',
@@ -155,6 +157,28 @@
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COMMENT = '鏃犲舰璧勪骇';
-- -------------------------------------------------------------------------------------
+-- 1.6 宸插缓琛ㄧ殑琛ュ垪锛堝吋瀹规棭鏈熻剼鏈垱寤恒�佺己灏戦儴闂�/淇濈浜虹紪鍙风殑搴擄級
+-- 璇存槑锛歁ySQL 涓嶆敮鎸� ALTER TABLE ... ADD COLUMN IF NOT EXISTS锛岀敤 information_schema 鍒ゆ柇
+-- -------------------------------------------------------------------------------------
+SET @col_exists = (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'fin_fixed_asset' AND column_name = 'department_id');
+SET @ddl = IF(@col_exists = 0,
+ 'ALTER TABLE `fin_fixed_asset` ADD COLUMN `department_id` bigint NULL DEFAULT NULL COMMENT ''浣跨敤閮ㄩ棬缂栧彿'' AFTER `department`',
+ 'SELECT 1');
+PREPARE stmt_fin_fixed_asset_department_id FROM @ddl;
+EXECUTE stmt_fin_fixed_asset_department_id;
+DEALLOCATE PREPARE stmt_fin_fixed_asset_department_id;
+
+SET @col_exists = (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'fin_fixed_asset' AND column_name = 'keeper_id');
+SET @ddl = IF(@col_exists = 0,
+ 'ALTER TABLE `fin_fixed_asset` ADD COLUMN `keeper_id` bigint NULL DEFAULT NULL COMMENT ''淇濈浜虹敤鎴风紪鍙�'' AFTER `keeper`',
+ 'SELECT 1');
+PREPARE stmt_fin_fixed_asset_keeper_id FROM @ddl;
+EXECUTE stmt_fin_fixed_asset_keeper_id;
+DEALLOCATE PREPARE stmt_fin_fixed_asset_keeper_id;
+
+-- -------------------------------------------------------------------------------------
-- 2. 瀛楀吀
-- -------------------------------------------------------------------------------------
INSERT INTO `system_dict_type` (`name`, `type`, `status`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`)
--
Gitblit v1.9.3