From 54885c7766e9f495d7b2a965cdbccd17ab986839 Mon Sep 17 00:00:00 2001 From: 云 <2163098428@qq.com> Date: 星期四, 17 九月 2026 13:23:43 +0800 Subject: [PATCH] fix(db): 修复数据库表字段中文注释乱码问题 --- docs/sql/config_export_all_20260904.sql | 58 +++++++++++++++++++++++++++++----------------------------- 1 files changed, 29 insertions(+), 29 deletions(-) diff --git a/docs/sql/config_export_all_20260904.sql b/docs/sql/config_export_all_20260904.sql index 4d9788a..d91386f 100644 --- a/docs/sql/config_export_all_20260904.sql +++ b/docs/sql/config_export_all_20260904.sql @@ -7928,11 +7928,11 @@ `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿', `code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '妫�娴嬮」缂栫爜', `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '妫�娴嬮」鍚嶇О', - `parent_id` bigint NOT NULL DEFAULT '0' COMMENT '莽藛露忙艗鈥∶β犫�∶尖�撁ヂ徛访妓�0=茅隆露莽潞搂茂录鈥�', - `item_type` tinyint NOT NULL DEFAULT '1' COMMENT '忙聺隆莽鈥郝甭幻ヅ锯�姑寂�1=氓陆鈥⒚モ�βッ┞÷姑寂�2=氓藛鈥犆烩�灻┞÷�', - `formula_text` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '氓鈥βヂ悸徝ヂ扁�⒚ぢ好︹�撯�∶ε撀妓喢︹�扳�溍ヂ嵚懊ε犅ッモ�樑犆р�澛寂捗ぢ嘎嵜ヂ忊�毭ぢ概矫∶�斆尖��', - `unit_text` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '氓聧鈥⒚ぢ铰嵜︹�撯�∶ε撀妓喢ヂ︹�� kg/m脗鲁茫鈧�/%茂录艗忙鈥扳�溍ヂ嵚懊ヂ扁�⒚ぢ好р�澛尖��', - `sort_order` int NOT NULL DEFAULT '0' COMMENT '氓聬艗莽潞搂忙沤鈥櫭ヂ郝徝ヂ徛�', + `parent_id` bigint NOT NULL DEFAULT '0' COMMENT '鐖舵寚鏍囩紪鍙凤紙0=椤剁骇锛�', + `item_type` tinyint NOT NULL DEFAULT '1' COMMENT '鏉$洰绫诲瀷锛�1=褰曞叆椤癸紝2=鍒嗙粍椤�', + `formula_text` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '鍏紡灞曠ず鏂囨湰锛堟墦鍗版姤鍛婄敤锛屼笉鍙備笌璁$畻锛�', + `unit_text` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '鍗曚綅鏂囨湰锛堝 kg/m鲁銆�/%锛屾墦鍗板睍绀虹敤锛�', + `sort_order` int NOT NULL DEFAULT '0' COMMENT '鍚岀骇鎺掑簭鍙�', `type` int DEFAULT NULL COMMENT '妫�娴嬮」绫诲瀷', `tool` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '妫�娴嬪伐鍏�', `result_type` int DEFAULT NULL COMMENT '缁撴灉鍊肩被鍨�', @@ -7971,7 +7971,7 @@ `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿', `result_id` bigint DEFAULT NULL COMMENT '鍏宠仈妫�楠岀粨鏋滅紪鍙�', `indicator_id` bigint DEFAULT NULL COMMENT '妫�娴嬫寚鏍囩紪鍙�', - `measure_no` int NOT NULL DEFAULT '1' COMMENT '忙碌鈥姑┾�÷徝︹�奥姑β∶ヂ徛访妓喢ぢ慌� 1 氓录鈧ヂр�姑寂捗┞凰溍� 1茂录鈥�', + `measure_no` int NOT NULL DEFAULT '1' COMMENT '娴嬮噺鎵规鍙凤紙浠� 1 寮�濮嬶紝榛樿 1锛�', `value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '妫�娴嬪��', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '澶囨敞', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鍒涘缓鑰�', @@ -8016,11 +8016,11 @@ `inspect_date` datetime DEFAULT NULL COMMENT '妫�娴嬫棩鏈�', `inspector_user_id` bigint DEFAULT NULL COMMENT '妫�娴嬩汉鍛樼敤鎴风紪鍙�', `status` int DEFAULT NULL COMMENT '鐘舵��', - `sampling_location` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '茅鈥♀�∶β犅访ヅ撀懊р�毬�', - `certificate_no` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '猫炉聛盲鹿娄莽录鈥撁ヂ徛�/氓聬藛忙聽录猫炉聛氓聫路', - `execute_standard` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '忙鈥奥∨捗β犫�∶モ�♀��', - `audit_user_id` bigint DEFAULT NULL COMMENT '氓陇聧忙聽赂盲潞潞莽鈥澛λ喡访尖�撁ヂ徛�', - `approve_user_id` bigint DEFAULT NULL COMMENT '氓庐隆忙聽赂盲潞潞莽鈥澛λ喡访尖�撁ヂ徛�', + `sampling_location` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '閲囨牱鍦扮偣', + `certificate_no` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '璇佷功缂栧彿/鍚堟牸璇佸彿', + `execute_standard` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '鎵ц鏍囧噯', + `audit_user_id` bigint DEFAULT NULL COMMENT '澶嶆牳浜虹敤鎴风紪鍙�', + `approve_user_id` bigint DEFAULT NULL COMMENT '瀹℃牳浜虹敤鎴风紪鍙�', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '澶囨敞', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鍒涘缓鑰�', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', @@ -8083,11 +8083,11 @@ `inspect_date` datetime DEFAULT NULL COMMENT '妫�娴嬫棩鏈�', `inspector_user_id` bigint DEFAULT NULL COMMENT '妫�娴嬩汉鍛樼敤鎴风紪鍙�', `status` int DEFAULT NULL COMMENT '鐘舵��', - `sampling_location` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '茅鈥♀�∶β犅访ヅ撀懊р�毬�', - `certificate_no` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '猫炉聛盲鹿娄莽录鈥撁ヂ徛�/氓聬藛忙聽录猫炉聛氓聫路', - `execute_standard` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '忙鈥奥∨捗β犫�∶モ�♀��', - `audit_user_id` bigint DEFAULT NULL COMMENT '氓陇聧忙聽赂盲潞潞莽鈥澛λ喡访尖�撁ヂ徛�', - `approve_user_id` bigint DEFAULT NULL COMMENT '氓庐隆忙聽赂盲潞潞莽鈥澛λ喡访尖�撁ヂ徛�', + `sampling_location` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '閲囨牱鍦扮偣', + `certificate_no` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '璇佷功缂栧彿/鍚堟牸璇佸彿', + `execute_standard` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '鎵ц鏍囧噯', + `audit_user_id` bigint DEFAULT NULL COMMENT '澶嶆牳浜虹敤鎴风紪鍙�', + `approve_user_id` bigint DEFAULT NULL COMMENT '瀹℃牳浜虹敤鎴风紪鍙�', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '澶囨敞', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鍒涘缓鑰�', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', @@ -8193,11 +8193,11 @@ `inspect_date` datetime DEFAULT NULL COMMENT '妫�娴嬫棩鏈�', `inspector_user_id` bigint DEFAULT NULL COMMENT '妫�娴嬩汉鍛樼敤鎴风紪鍙�', `status` int DEFAULT NULL COMMENT '鐘舵��', - `sampling_location` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '茅鈥♀�∶β犅访ヅ撀懊р�毬�', - `certificate_no` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '猫炉聛盲鹿娄莽录鈥撁ヂ徛�/氓聬藛忙聽录猫炉聛氓聫路', - `execute_standard` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '忙鈥奥∨捗β犫�∶モ�♀��', - `audit_user_id` bigint DEFAULT NULL COMMENT '氓陇聧忙聽赂盲潞潞莽鈥澛λ喡访尖�撁ヂ徛�', - `approve_user_id` bigint DEFAULT NULL COMMENT '氓庐隆忙聽赂盲潞潞莽鈥澛λ喡访尖�撁ヂ徛�', + `sampling_location` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '閲囨牱鍦扮偣', + `certificate_no` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '璇佷功缂栧彿/鍚堟牸璇佸彿', + `execute_standard` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '鎵ц鏍囧噯', + `audit_user_id` bigint DEFAULT NULL COMMENT '澶嶆牳浜虹敤鎴风紪鍙�', + `approve_user_id` bigint DEFAULT NULL COMMENT '瀹℃牳浜虹敤鎴风紪鍙�', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '澶囨敞', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鍒涘缓鑰�', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', @@ -8258,11 +8258,11 @@ `inspect_date` datetime DEFAULT NULL COMMENT '妫�娴嬫棩鏈�', `inspector_user_id` bigint DEFAULT NULL COMMENT '妫�娴嬩汉鍛樼敤鎴风紪鍙�', `status` int DEFAULT NULL COMMENT '鐘舵��', - `sampling_location` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '茅鈥♀�∶β犅访ヅ撀懊р�毬�', - `certificate_no` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '猫炉聛盲鹿娄莽录鈥撁ヂ徛�/氓聬藛忙聽录猫炉聛氓聫路', - `execute_standard` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '忙鈥奥∨捗β犫�∶モ�♀��', - `audit_user_id` bigint DEFAULT NULL COMMENT '氓陇聧忙聽赂盲潞潞莽鈥澛λ喡访尖�撁ヂ徛�', - `approve_user_id` bigint DEFAULT NULL COMMENT '氓庐隆忙聽赂盲潞潞莽鈥澛λ喡访尖�撁ヂ徛�', + `sampling_location` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '閲囨牱鍦扮偣', + `certificate_no` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '璇佷功缂栧彿/鍚堟牸璇佸彿', + `execute_standard` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '鎵ц鏍囧噯', + `audit_user_id` bigint DEFAULT NULL COMMENT '澶嶆牳浜虹敤鎴风紪鍙�', + `approve_user_id` bigint DEFAULT NULL COMMENT '瀹℃牳浜虹敤鎴风紪鍙�', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '澶囨敞', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鍒涘缓鑰�', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', @@ -8303,7 +8303,7 @@ `code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '鏂规缂栧彿', `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '鏂规鍚嶇О', `types` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '妫�娴嬬绫�', - `default_execute_standard` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '茅禄藴猫庐陇忙鈥奥∨捗β犫�∶モ�♀�犆妓喢ヂ︹�� GB/T6027茂录鈥�', + `default_execute_standard` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '榛樿鎵ц鏍囧噯锛堝 GB/T6027锛�', `status` int DEFAULT NULL COMMENT '鐘舵��', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '澶囨敞', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鍒涘缓鑰�', @@ -8320,8 +8320,8 @@ `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿', `template_id` bigint DEFAULT NULL COMMENT '璐ㄦ鏂规缂栧彿', `indicator_id` bigint DEFAULT NULL COMMENT '璐ㄦ鎸囨爣缂栧彿', - `sort_order` int NOT NULL DEFAULT '0' COMMENT '氓卤鈥⒚ぢ好ε解�櫭ヂ郝徝ヂ徛�', - `judge_flag` tinyint NOT NULL DEFAULT '1' COMMENT '忙藴炉氓聬娄氓聫鈥毭ぢ概矫ヂ愃喢β犅济ニ喡っヂ∶寂�1=忙藴炉茂录艗0=氓聬娄', + `sort_order` int NOT NULL DEFAULT '0' COMMENT '灞曠ず鎺掑簭鍙�', + `judge_flag` tinyint NOT NULL DEFAULT '1' COMMENT '鏄惁鍙備笌鍚堟牸鍒ゅ畾锛�1=鏄紝0=鍚�', `check_method` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '妫�娴嬫柟娉�', `standard_value` decimal(24,6) DEFAULT NULL COMMENT '鏍囧噯鍊�', `unit_measure_id` bigint DEFAULT NULL COMMENT '璁¢噺鍗曚綅缂栧彿', -- Gitblit v1.9.3