-- 修改固件表的文件名字段长度
ALTER TABLE `oper_firmware`
MODIFY COLUMN `firmware_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '文件名' AFTER `id`;

-- 修改运维-固件升级批次表的固件文件名字段长度
ALTER TABLE `oper_firmware_upgrade_task_batch`
  MODIFY COLUMN `firmware_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '固件文件名, 如文件名可修改，该字段弃用' AFTER `firmware_id`;

-- 产品默认密码表 oper_product_secret_conf 补充产品id信息
UPDATE dev_product dp, oper_product_secret_conf ops SET ops.product_id = dp.id  WHERE ops.def_passwd = dp.product_code;