-- 物料外协提前期由业务人员维护,空值表示未配置。 SET @has_outsource_lead_time := (SELECT COUNT(*) FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='mdm_item' AND COLUMN_NAME='outsource_lead_time'); SET @lead_sql := IF(@has_outsource_lead_time=0, 'ALTER TABLE mdm_item ADD COLUMN outsource_lead_time INT NULL COMMENT ''外协提前期(天)''', 'SELECT 1'); PREPARE lead_stmt FROM @lead_sql; EXECUTE lead_stmt; DEALLOCATE PREPARE lead_stmt;