-- 生产报工/产出/入库幂等约束：避免接口重试或并发审批生成重复单据。
|
-- MySQL 唯一索引允许多条 NULL，因此不影响没有 feedback_id 的历史数据。
|
|
SET @has_feedback_unique := (
|
SELECT COUNT(*) FROM information_schema.statistics
|
WHERE table_schema = DATABASE()
|
AND table_name = 'mes_wm_product_produce'
|
AND index_name = 'uk_product_produce_feedback'
|
);
|
SET @feedback_sql := IF(
|
@has_feedback_unique = 0,
|
'ALTER TABLE `mes_wm_product_produce` ADD UNIQUE KEY `uk_product_produce_feedback` (`feedback_id`)',
|
'SELECT 1'
|
);
|
PREPARE feedback_stmt FROM @feedback_sql;
|
EXECUTE feedback_stmt;
|
DEALLOCATE PREPARE feedback_stmt;
|
|
SET @has_receipt_code_unique := (
|
SELECT COUNT(*) FROM information_schema.statistics
|
WHERE table_schema = DATABASE()
|
AND table_name = 'mes_wm_product_receipt'
|
AND index_name = 'uk_product_receipt_code'
|
);
|
SET @receipt_sql := IF(
|
@has_receipt_code_unique = 0,
|
'ALTER TABLE `mes_wm_product_receipt` ADD UNIQUE KEY `uk_product_receipt_code` (`code`)',
|
'SELECT 1'
|
);
|
PREPARE receipt_stmt FROM @receipt_sql;
|
EXECUTE receipt_stmt;
|
DEALLOCATE PREPARE receipt_stmt;
|
