-- asr_bas_station 增加出库任务上限配置
|
-- 用途：按最终出库站限制堆垛机可同时放行的在途出库任务数
|
-- 适用数据库：MySQL
|
|
SET @current_db := DATABASE();
|
|
SET @out_task_limit_exists := (
|
SELECT COUNT(1)
|
FROM information_schema.COLUMNS
|
WHERE TABLE_SCHEMA = @current_db
|
AND TABLE_NAME = 'asr_bas_station'
|
AND COLUMN_NAME = 'out_task_limit'
|
);
|
|
SET @add_out_task_limit_sql := IF(
|
@out_task_limit_exists = 0,
|
'ALTER TABLE asr_bas_station ADD COLUMN out_task_limit INT NULL COMMENT ''出库任务上限，<0或NULL表示不限制，0表示禁止新出库'' AFTER station_alias',
|
'SELECT ''column out_task_limit already exists'' '
|
);
|
PREPARE stmt_out_task_limit FROM @add_out_task_limit_sql;
|
EXECUTE stmt_out_task_limit;
|
DEALLOCATE PREPARE stmt_out_task_limit;
|
|
SHOW COLUMNS FROM asr_bas_station LIKE 'out_task_limit';
|
