From 0fadd10ea101fbc18d89ba33df0b9a03df9f82d1 Mon Sep 17 00:00:00 2001 From: tuqin <tuqin@tuqin.cn> Date: 星期二, 27 十月 2026 15:52:59 +0800 Subject: [PATCH] docs(环保门禁): DDL 补充巡检大字段扩容——report_path/ai_analysis/uav_data 由 text 改 mediumtext(16MB)，修复生成报告报 Data too long --- doc/sql/hbmjxt_ddl.sql | 14 ++++++++++++-- 1 files changed, 12 insertions(+), 2 deletions(-) diff --git a/doc/sql/hbmjxt_ddl.sql b/doc/sql/hbmjxt_ddl.sql index e148353..c9cd779 100644 --- a/doc/sql/hbmjxt_ddl.sql +++ b/doc/sql/hbmjxt_ddl.sql @@ -39,9 +39,19 @@ ADD COLUMN scene_photo VARCHAR(500) NULL COMMENT '杞﹁締鍏ㄦ櫙鐓х墖' AFTER license_photo; -- ------------------------------------------------------------ --- 3. 渚濊禆鐨勬棦鏈夎〃锛堝嬁鍒狅紝宸℃/闂ㄧ/杩滅▼鐩戞帶/璁惧鏁呴殰鍧囦緷璧栵級 +-- 3. 宸℃澶ф枃鏈瓧娈垫墿瀹癸細text(64KB) -> mediumtext(16MB) +-- 鍘熷洜锛歳eport_path 瀛樼殑鏄姤鍛婂叏鏂� HTML锛宎i_analysis/uav_data 瀛樿澶囧洖浼� JSON锛� +-- 鏁版嵁閲忓ぇ鏃朵細鎶� "Data too long for column 'report_path'" -- ------------------------------------------------------------ --- env_inspection 鏅鸿兘宸℃鍙拌处锛堝惈 ai_analysis / uav_data锛� +ALTER TABLE env_inspection + MODIFY COLUMN report_path MEDIUMTEXT COMMENT '鑷姩鐢熸垚宸℃鎶ュ憡(HTML鍐呭)', + MODIFY COLUMN ai_analysis MEDIUMTEXT COMMENT 'AI瑙嗛鍒嗘瀽缁撴灉(JSON)', + MODIFY COLUMN uav_data MEDIUMTEXT COMMENT '鏃犱汉鏈�/鏈哄櫒浜哄洖浼犳暟鎹�(JSON)'; + +-- ------------------------------------------------------------ +-- 4. 渚濊禆鐨勬棦鏈夎〃锛堝嬁鍒狅紝宸℃/闂ㄧ/杩滅▼鐩戞帶/璁惧鏁呴殰鍧囦緷璧栵級 +-- ------------------------------------------------------------ +-- env_inspection 鏅鸿兘宸℃鍙拌处锛堝惈 ai_analysis / uav_data / report_path锛� -- env_access_vehicle 闂ㄧ杞﹁締锛坴ehicle_type 1杩涘嚭鍘� / 2鍘傚唴 / 3闈為亾璺級 -- env_device_command 璁惧杩滅▼鎺у埗鎸囦护 -- device_defect_record 璁惧鏁呴殰璁板綍锛堥棬绂佺鐞�-璁惧鏁呴殰 + 杩滅▼鐩戞帶-寮傚父鎶ヨ 鍏卞悓鏁版嵁婧愶級 -- Gitblit v1.9.3