//这个在mes_icons_cz060.sql后执行

- ============================================================
-- 1. 删除旧方案数据（按 id 精确删除，仅本批 cz060 图标）
-- ============================================================
DELETE FROM mes_icons WHERE id IN (
                                   'cz060_icon_100','cz060_icon_101','cz060_icon_102','cz060_icon_103','cz060_icon_104',
                                   'cz060_icon_105','cz060_icon_106','cz060_icon_107','cz060_icon_108','cz060_icon_109',
                                   'cz060_icon_110','cz060_icon_111','cz060_icon_112','cz060_icon_113','cz060_icon_114',
                                   'cz060_icon_115','cz060_icon_116','cz060_icon_117','cz060_icon_118','cz060_icon_119');

-- ============================================================
-- 2. 插入新方案 20 条（case 100~119）
-- ============================================================
INSERT INTO mes_icons (id, title, mode, remark, status, auth, create_by, create_date, update_by, update_date)
VALUES
    ('cz060_icon_100', '封板预装+点焊',     '100', 'CZ060-OP065A（PDA过站）', '0', @pda_auth, 'system', NOW(), 'system', NOW()),
    ('cz060_icon_101', '打磨',             '101', 'CZ060-OP090A（PDA过站）', '0', @pda_auth, 'system', NOW(), 'system', NOW()),
    ('cz060_icon_102', '前膨胀梁打码',      '102', 'CZ060-OP100（PDA过站）',  '0', @pda_auth, 'system', NOW(), 'system', NOW()),
    ('cz060_icon_103', '打磨',             '103', 'CZ060-OP125（PDA过站）',  '0', @pda_auth, 'system', NOW(), 'system', NOW()),
    ('cz060_icon_104', '吹铝屑+刮毛刺+清洁', '104', 'CZ060-OP140（PDA过站）',  '0', @pda_auth, 'system', NOW(), 'system', NOW()),
    ('cz060_icon_105', '人工清洁',          '105', 'CZ060-OP166（PDA过站）',  '0', @pda_auth, 'system', NOW(), 'system', NOW()),
    ('cz060_icon_106', '抽芯拉铆',          '106', 'CZ060-OP175（PDA过站）',  '0', @pda_auth, 'system', NOW(), 'system', NOW()),
    ('cz060_icon_107', '支架安装',          '107', 'CZ060-OP180（PDA过站）',  '0', @pda_auth, 'system', NOW(), 'system', NOW()),
    ('cz060_icon_108', '白件GP12',          '108', 'CZ060-OP185（PDA过站）',  '0', @pda_auth, 'system', NOW(), 'system', NOW()),
    ('cz060_icon_109', '检具',             '109', 'CZ060-OP190（PDA过站）',  '0', @pda_auth, 'system', NOW(), 'system', NOW()),
    ('cz060_icon_110', '喷粉前打包',        '110', 'CZ060-OP195（PDA过站）',  '0', @pda_auth, 'system', NOW(), 'system', NOW()),
    ('cz060_icon_111', '总成清洁',          '111', 'CZ060-OP220（PDA过站）',  '0', @pda_auth, 'system', NOW(), 'system', NOW()),
    ('cz060_icon_112', '支架、定位销安装',   '112', 'CZ060-OP225（PDA过站）',  '0', @pda_auth, 'system', NOW(), 'system', NOW()),
    ('cz060_icon_113', '贴pc条',            '113', 'CZ060-OP230（PDA过站）',  '0', @pda_auth, 'system', NOW(), 'system', NOW()),
    ('cz060_icon_114', '涂胶',             '114', 'CZ060-OP235（PDA过站）',  '0', @pda_auth, 'system', NOW(), 'system', NOW()),
    ('cz060_icon_115', '全检',             '115', 'CZ060-OP240（PDA过站）',  '0', @pda_auth, 'system', NOW(), 'system', NOW()),
    ('cz060_icon_116', 'GP12成品检验',      '116', 'CZ060-OP245（PDA过站）',  '0', @pda_auth, 'system', NOW(), 'system', NOW()),
    ('cz060_icon_117', '成品打包',          '117', 'CZ060-OP260（PDA过站）',  '0', @pda_auth, 'system', NOW(), 'system', NOW()),
    ('cz060_icon_118', '入库',             '118', 'CZ060-OP265（PDA过站）',  '0', @pda_auth, 'system', NOW(), 'system', NOW()),
    ('cz060_icon_119', '出货',             '119', 'CZ060-OP270（PDA过站）',  '0', @pda_auth, 'system', NOW(), 'system', NOW());