shanxia/backend/script/sql/update/add_customer_cert_images.sql

-- 新增客户证件图片字段
-- 创建时间: 2025-12-30
-- 说明: 为crm_customer表添加营业执照、经营许可证、其他证件图片存储字段

ALTER TABLE `crm_customer`
    ADD COLUMN `business_license_images` varchar(1000) DEFAULT NULL COMMENT '营业执照图片OSS ID（多个用逗号分隔）' AFTER `remark`;

ALTER TABLE `crm_customer`
    ADD COLUMN `business_permit_images` varchar(1000) DEFAULT NULL COMMENT '经营许可证图片OSS ID（多个用逗号分隔）' AFTER `business_license_images`;

ALTER TABLE `crm_customer`
    ADD COLUMN `other_cert_images` varchar(1000) DEFAULT NULL COMMENT '其他证件图片OSS ID（多个用逗号分隔）' AFTER `business_permit_images`;