mescloud/db/mysql/add_mes_device_oee_screen.sql

INSERT INTO mes_screen_config (
	id,
	screen_name,
	screen_code,
	screen_url,
	screen_type,
	play_duration,
	sort_order,
	is_enabled,
	remarks,
	create_by,
	create_date,
	update_by,
	update_date
)
SELECT
	'mes_device_oee_screen',
	'设备综合效率管理',
	'MES_DEVICE_OEE',
	'/js/a/mes/mesDevice/oeeScreen',
	'设备管理',
	60,
	50,
	'1',
	'基于设备状态记录计算开动率；当前数据不包含完整OEE所需的产量、良品、节拍字段',
	'system',
	NOW(),
	'system',
	NOW()
WHERE NOT EXISTS (
	SELECT 1 FROM mes_screen_config WHERE screen_code = 'MES_DEVICE_OEE'
);