mescloud/db/mysql/add_mes_device_state_stop.sql

-- 设备运行状态字典增加：7 = 停机（工位退出/收班）
INSERT INTO js_sys_dict_data (
	dict_code,
	parent_code,
	parent_codes,
	tree_sort,
	tree_sorts,
	tree_leaf,
	tree_level,
	tree_names,
	dict_label,
	dict_value,
	dict_icon,
	dict_type,
	is_sys,
	description,
	css_style,
	css_class,
	status,
	create_by,
	create_date,
	update_by,
	update_date,
	remarks,
	corp_code,
	corp_name
)
SELECT
	'mes_device_state_7',
	'0',
	'0,',
	210,
	'0000000210,',
	'1',
	0,
	'停机',
	'停机',
	'7',
	'',
	'mes_device_state',
	'1',
	'工位退出/收班',
	'',
	'',
	'0',
	'system',
	NOW(),
	'system',
	NOW(),
	'',
	'0',
	'JeeSite'
FROM DUAL
WHERE NOT EXISTS (
	SELECT 1 FROM js_sys_dict_data WHERE dict_type = 'mes_device_state' AND dict_value = '7'
);