dibang-xiaoshou/docs/product_name_unify.sql

-- ============================================================
-- 产品名称统一化 SQL
-- 执行前请先备份数据库；建议在测试环境先执行并核对结果
-- ============================================================

-- 1. 32% 液碱 → 32% 烧碱
UPDATE purchase_plans       SET product = '32% 烧碱' WHERE product = '32% 液碱';
UPDATE inbound_outbound     SET product = '32% 烧碱' WHERE product = '32% 液碱';
UPDATE weighing_slips       SET cargo_name = '32% 烧碱' WHERE cargo_name = '32% 液碱';

-- 2. 氢氧化钠 32% → 32% 烧碱
UPDATE purchase_plans       SET product = '32% 烧碱' WHERE product = '氢氧化钠 32%';
UPDATE inbound_outbound     SET product = '32% 烧碱' WHERE product = '氢氧化钠 32%';
UPDATE weighing_slips       SET cargo_name = '32% 烧碱' WHERE cargo_name = '氢氧化钠 32%';

-- 3. 50%硫酸 → 工业硫酸 50%
UPDATE purchase_plans       SET product = '工业硫酸 50%' WHERE product = '50%硫酸';
UPDATE inbound_outbound     SET product = '工业硫酸 50%' WHERE product = '50%硫酸';
UPDATE weighing_slips       SET cargo_name = '工业硫酸 50%' WHERE cargo_name = '50%硫酸';

-- 4. 92%硫酸 → 工业硫酸 92.5%
UPDATE purchase_plans       SET product = '工业硫酸 92.5%' WHERE product = '92%硫酸';
UPDATE inbound_outbound     SET product = '工业硫酸 92.5%' WHERE product = '92%硫酸';
UPDATE weighing_slips       SET cargo_name = '工业硫酸 92.5%' WHERE cargo_name = '92%硫酸';

-- 5. 98%硫酸 → 工业硫酸 98%
UPDATE purchase_plans       SET product = '工业硫酸 98%' WHERE product = '98%硫酸';
UPDATE inbound_outbound     SET product = '工业硫酸 98%' WHERE product = '98%硫酸';
UPDATE weighing_slips       SET cargo_name = '工业硫酸 98%' WHERE cargo_name = '98%硫酸';

-- 6. 98% 工业硫酸 → 工业硫酸 98%
UPDATE purchase_plans       SET product = '工业硫酸 98%' WHERE product = '98% 工业硫酸';
UPDATE inbound_outbound     SET product = '工业硫酸 98%' WHERE product = '98% 工业硫酸';
UPDATE weighing_slips       SET cargo_name = '工业硫酸 98%' WHERE cargo_name = '98% 工业硫酸';

-- 7. 硫磺酸 → 硫磺酸 98%
UPDATE purchase_plans       SET product = '硫磺酸 98%' WHERE product = '硫磺酸';
UPDATE inbound_outbound     SET product = '硫磺酸 98%' WHERE product = '硫磺酸';
UPDATE weighing_slips       SET cargo_name = '硫磺酸 98%' WHERE cargo_name = '硫磺酸';

-- ============================================================
-- 可选：若货物名称表 cargos 也需与上述规则一致，可执行下面语句
-- 注意：cargos.name 有 UNIQUE 约束，若新名称已存在会冲突，需先处理重复再改
-- ============================================================
/*
UPDATE cargos SET name = '32% 烧碱' WHERE name = '32% 液碱';
UPDATE cargos SET name = '32% 烧碱' WHERE name = '氢氧化钠 32%';
UPDATE cargos SET name = '工业硫酸 50%' WHERE name = '50%硫酸';
UPDATE cargos SET name = '工业硫酸 92.5%' WHERE name = '92%硫酸';
UPDATE cargos SET name = '工业硫酸 98%' WHERE name = '98%硫酸';
UPDATE cargos SET name = '工业硫酸 98%' WHERE name = '98% 工业硫酸';
UPDATE cargos SET name = '硫磺酸 98%' WHERE name = '硫磺酸';
*/