shanxia2.0/docs/sql/backups/2026-09-23-prod-package-spec-restore-20260923_183036.sql

-- Restore package_spec from prod backup 20260923_183036
-- DB: shanxia2.0 @ 121.43.228.102

UPDATE `crm_contract_product` t
JOIN `crm_contract_product_pkg_bak_20260923_183036` b ON t.`id` = b.`id`
SET t.`package_spec` = b.`package_spec`;

UPDATE `crm_quote_product` t
JOIN `crm_quote_product_pkg_bak_20260923_183036` b ON t.`id` = b.`id`
SET t.`package_spec` = b.`package_spec`;

-- Optional: revert column width (only if needed)
-- ALTER TABLE `crm_contract_product` MODIFY COLUMN `package_spec` varchar(200) DEFAULT NULL COMMENT '包装规格';
-- ALTER TABLE `crm_quote_product` MODIFY COLUMN `package_spec` varchar(200) DEFAULT NULL COMMENT '包装规格';