-- ============================================================ -- 电力数转增强 - 第三阶段(仓储物流)数据库变更 -- 适用:MySQL 8.4+ -- 说明:仓库/库区类型 + 废旧物资/设备出入库类型(幂等) -- 注意:本脚本不包含 tenant_id(项目未启用多租户) -- ============================================================ -- ---------- 1. 仓库/库区类型列 ---------- SET @col = (SELECT COUNT(*) FROM information_schema.columns WHERE table_schema = DATABASE() AND table_name = 'mes_wm_warehouse' AND column_name = 'type'); SET @sql = IF(@col = 0, 'ALTER TABLE mes_wm_warehouse ADD COLUMN type INT NULL COMMENT ''仓库类型(字典 mes_wm_warehouse_type)'' AFTER name', 'SELECT 1'); PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; SET @col = (SELECT COUNT(*) FROM information_schema.columns WHERE table_schema = DATABASE() AND table_name = 'mes_wm_warehouse_area' AND column_name = 'type'); SET @sql = IF(@col = 0, 'ALTER TABLE mes_wm_warehouse_area ADD COLUMN type INT NULL COMMENT ''库区类型(字典 mes_wm_warehouse_type)'' AFTER name', 'SELECT 1'); PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; -- ---------- 2. 字典:仓库/库区类型 ---------- INSERT INTO `system_dict_type` (`name`, `type`, `status`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `deleted_time`) VALUES ('MES 仓库/库区类型', 'mes_wm_warehouse_type', 0, 'MES 仓库/库区类型(1=普通仓库,2=设备仓,3=备件仓,4=耗材仓,5=危化品仓)', '1', NOW(), '1', NOW(), b'0', NULL) ON DUPLICATE KEY UPDATE `name` = VALUES(`name`); INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (1, '普通仓库', '1', 'mes_wm_warehouse_type', 0, 'default', '', '通用物资仓库', '1', NOW(), '1', NOW(), b'0'), (2, '设备仓', '2', 'mes_wm_warehouse_type', 0, 'primary', '', '电力设备仓储', '1', NOW(), '1', NOW(), b'0'), (3, '备件仓', '3', 'mes_wm_warehouse_type', 0, 'warning', '', '备品备件仓储', '1', NOW(), '1', NOW(), b'0'), (4, '耗材仓', '4', 'mes_wm_warehouse_type', 0, 'info', '', '日常耗材仓储', '1', NOW(), '1', NOW(), b'0'), (5, '危化品仓', '5', 'mes_wm_warehouse_type', 0, 'danger', '', '危险化学品专用仓储', '1', NOW(), '1', NOW(), b'0') ON DUPLICATE KEY UPDATE `label` = VALUES(`label`), `sort` = VALUES(`sort`); -- ---------- 3. 字典:废旧物资/设备出入库类型 ---------- INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (3, '废旧物资出库', '3', 'mes_wm_misc_issue_type', 0, 'warning', '', '废旧物资出库', '1', NOW(), '1', NOW(), b'0'), (4, '设备出库', '4', 'mes_wm_misc_issue_type', 0, 'primary', '', '电力设备出库', '1', NOW(), '1', NOW(), b'0') ON DUPLICATE KEY UPDATE `label` = VALUES(`label`), `sort` = VALUES(`sort`); INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (2, '设备入库', '2', 'mes_wm_misc_receipt_type', 0, 'primary', '', '电力设备入库', '1', NOW(), '1', NOW(), b'0'), (3, '废旧物资入库', '3', 'mes_wm_misc_receipt_type', 0, 'warning', '', '废旧物资入库', '1', NOW(), '1', NOW(), b'0') ON DUPLICATE KEY UPDATE `label` = VALUES(`label`), `sort` = VALUES(`sort`);