| 12345678910111213141516171819202122232425262728293031323334353637 |
- //这个在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());
|
