-- =============================================
|
-- 赋码管理 - 托盘表新增生成组标记
|
-- 批量生成袋码数据包时写入，用于任务失败/取消后清理未绑定的临时托盘
|
-- MySQL 8.4 适用（ADD COLUMN 不支持 IF NOT EXISTS，先查 information_schema）
|
-- =============================================
|
|
SET NAMES utf8mb4;
|
|
SET @exists = (SELECT COUNT(*) FROM information_schema.columns
|
WHERE table_schema = DATABASE()
|
AND table_name = 'mes_pro_pallet'
|
AND column_name = 'generate_uuid');
|
SET @sql = IF(@exists = 0,
|
'ALTER TABLE mes_pro_pallet ADD COLUMN generate_uuid VARCHAR(32) DEFAULT NULL COMMENT ''生成组 UUID（批量生成时写入，用于失败/取消清理）'' AFTER temp_code',
|
'SELECT 1');
|
PREPARE stmt FROM @sql;
|
EXECUTE stmt;
|
DEALLOCATE PREPARE stmt;
|
|
SET @indexExists = (SELECT COUNT(*) FROM information_schema.statistics
|
WHERE table_schema = DATABASE()
|
AND table_name = 'mes_pro_pallet'
|
AND index_name = 'idx_generate_uuid');
|
SET @sql = IF(@indexExists = 0,
|
'ALTER TABLE mes_pro_pallet ADD INDEX idx_generate_uuid (generate_uuid)',
|
'SELECT 1');
|
PREPARE stmt FROM @sql;
|
EXECUTE stmt;
|
DEALLOCATE PREPARE stmt;
|
