shanxia2.0/backend/scripts/migrate_20261008_pl_cert_ocr_json.sql

-- 购买证 / 运输证：大模型识别结果 JSON 落库
-- MySQL 5.7 utf8mb4

ALTER TABLE `pl_purchase_cert`
  ADD COLUMN `ocr_result_json` mediumtext NULL COMMENT 'DeepSeek识别结果JSON' AFTER `attachment_urls`;

ALTER TABLE `pl_transport_cert`
  ADD COLUMN `police_tel` varchar(50) DEFAULT NULL COMMENT '公安机关联系电话' AFTER `handler_name`,
  ADD COLUMN `ocr_result_json` mediumtext NULL COMMENT 'DeepSeek识别结果JSON' AFTER `attachment_urls`;