-- 工艺路线、工艺路线明细支持绑定多个产品（2026-04-14）
|
ALTER TABLE process_route
|
ADD COLUMN product_model_ids VARCHAR(1024) NULL COMMENT '多产品id，逗号分隔' AFTER product_model_id;
|
|
UPDATE process_route
|
SET product_model_ids = CAST(product_model_id AS CHAR)
|
WHERE (product_model_ids IS NULL OR product_model_ids = '')
|
AND product_model_id IS NOT NULL
|
AND product_model_id <> 0;
|
|
ALTER TABLE process_route_item
|
ADD COLUMN product_model_ids VARCHAR(1024) NULL COMMENT '多产品id，逗号分隔' AFTER product_model_id;
|
|
UPDATE process_route_item
|
SET product_model_ids = CAST(product_model_id AS CHAR)
|
WHERE (product_model_ids IS NULL OR product_model_ids = '')
|
AND product_model_id IS NOT NULL
|
AND product_model_id <> 0;
|
