From f68d79d0ff6658795c19c2fd473fab9ff6f0640d Mon Sep 17 00:00:00 2001
From: zss <zss@example.com>
Date: 星期六, 14 三月 2026 13:53:12 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/dev_宁夏_中盛建材' into dev_宁夏_中盛建材
---
doc/宁夏-中盛建材.sql | 27 ++++++++++++++++++++++++++-
1 files changed, 26 insertions(+), 1 deletions(-)
diff --git "a/doc/\345\256\201\345\244\217-\344\270\255\347\233\233\345\273\272\346\235\220.sql" "b/doc/\345\256\201\345\244\217-\344\270\255\347\233\233\345\273\272\346\235\220.sql"
index 33e8ed8..d4e3800 100644
--- "a/doc/\345\256\201\345\244\217-\344\270\255\347\233\233\345\273\272\346\235\220.sql"
+++ "b/doc/\345\256\201\345\244\217-\344\270\255\347\233\233\345\273\272\346\235\220.sql"
@@ -175,4 +175,29 @@
ALTER TABLE `product-inventory-management-zsjc`.`production_plan`
DROP COLUMN `data_sync_type`,
- MODIFY COLUMN `data_source_type` tinyint NULL DEFAULT 1 COMMENT '鏁版嵁鏉ユ簮绫诲瀷锛�1=閽夐拤鍚屾 2=鎵嬪姩鏂板' AFTER `form_modified_time`;
\ No newline at end of file
+ MODIFY COLUMN `data_source_type` tinyint NULL DEFAULT 1 COMMENT '鏁版嵁鏉ユ簮绫诲瀷锛�1=閽夐拤鍚屾 2=鎵嬪姩鏂板' AFTER `form_modified_time`;
+
+DROP TABLE IF EXISTS `base_param`;
+CREATE TABLE `base_param`
+(
+ id BIGINT PRIMARY KEY AUTO_INCREMENT COMMENT '涓婚敭ID',
+ param_key VARCHAR(100) NOT NULL COMMENT '鍙傛暟鍞竴鏍囪瘑',
+ param_name VARCHAR(100) NOT NULL COMMENT '鍙傛暟鍚嶇О',
+ param_type TINYINT NOT NULL COMMENT '鍙傛暟绫诲瀷(1鏁板瓧 2鏂囨湰)',
+ value_mode TINYINT DEFAULT 1 COMMENT '鍊兼ā寮�(1鍗曞�� 2鍖洪棿)',
+ unit VARCHAR(50) COMMENT '鍗曚綅',
+ default_value VARCHAR(200) COMMENT '榛樿鍊�(鍗曞�煎弬鏁�)',
+ default_min DECIMAL(10, 2) COMMENT '榛樿鏈�灏忓��(鍖洪棿鍙傛暟)',
+ default_max DECIMAL(10, 2) COMMENT '榛樿鏈�澶у��(鍖洪棿鍙傛暟)',
+ is_required TINYINT DEFAULT 0 COMMENT '鏄惁蹇呭～(0鍚� 1鏄�)',
+ remark VARCHAR(255) COMMENT '澶囨敞',
+ create_user VARCHAR(64) COMMENT '鍒涘缓浜�',
+ create_time DATETIME COMMENT '鍒涘缓鏃堕棿',
+ update_user VARCHAR(64) COMMENT '淇敼浜�',
+ update_time DATETIME COMMENT '淇敼鏃堕棿',
+ tenant_id BIGINT NOT NULL COMMENT '绉熸埛ID'
+) COMMENT = '鍩虹鍙傛暟瀹氫箟琛�';
+
+ALTER TABLE `product-inventory-management-zsjc`.`customer`
+ ADD COLUMN `form_instance_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '瀹滄惌琛ㄥ崟瀹炰緥ID' AFTER `customer_type`,
+ ADD COLUMN `form_modified_time` datetime(0) NULL DEFAULT NULL COMMENT '瀹滄惌淇敼鏃堕棿' AFTER `form_instance_id`;
--
Gitblit v1.9.3