45 lines
1.9 KiB
SQL
45 lines
1.9 KiB
SQL
-- 工艺工序页面菜单与权限初始化脚本（DM8）
|
||
-- 默认挂载在基础数据目录（parent_id = 6200），如需调整请修改 parent_id。
|
||
|
||
DELETE FROM system_menu
|
||
WHERE id IN (6207, 620701, 620702, 620703, 620704, 620705);
|
||
|
||
INSERT INTO system_menu (
|
||
id, name, permission, type, sort, parent_id,
|
||
path, icon, component, component_name,
|
||
status, visible, keep_alive, always_show,
|
||
creator, create_time, updater, update_time, deleted
|
||
) VALUES (
|
||
6207, '工艺工序', 'base:processing-infomation-operation:query', 2, 70, 6200,
|
||
'processing-infomation-operation', 'ep:operation', 'base/processinginfomationoperation/index', 'ProcessingInfomationOperation',
|
||
0, '1', '0', '1',
|
||
'admin', CURRENT_TIMESTAMP, 'admin', CURRENT_TIMESTAMP, '0'
|
||
);
|
||
|
||
INSERT INTO system_menu (
|
||
id, name, permission, type, sort, parent_id,
|
||
path, icon, component, component_name,
|
||
status, visible, keep_alive, always_show,
|
||
creator, create_time, updater, update_time, deleted
|
||
) VALUES
|
||
(620701, '工艺工序查询', 'base:processing-infomation-operation:query', 3, 1, 6207,
|
||
'', '', '', '',
|
||
0, '1', '1', '1',
|
||
'admin', CURRENT_TIMESTAMP, 'admin', CURRENT_TIMESTAMP, '0'),
|
||
(620702, '工艺工序创建', 'base:processing-infomation-operation:create', 3, 2, 6207,
|
||
'', '', '', '',
|
||
0, '1', '1', '1',
|
||
'admin', CURRENT_TIMESTAMP, 'admin', CURRENT_TIMESTAMP, '0'),
|
||
(620703, '工艺工序更新', 'base:processing-infomation-operation:update', 3, 3, 6207,
|
||
'', '', '', '',
|
||
0, '1', '1', '1',
|
||
'admin', CURRENT_TIMESTAMP, 'admin', CURRENT_TIMESTAMP, '0'),
|
||
(620704, '工艺工序删除', 'base:processing-infomation-operation:delete', 3, 4, 6207,
|
||
'', '', '', '',
|
||
0, '1', '1', '1',
|
||
'admin', CURRENT_TIMESTAMP, 'admin', CURRENT_TIMESTAMP, '0'),
|
||
(620705, '工艺工序导出', 'base:processing-infomation-operation:export', 3, 5, 6207,
|
||
'', '', '', '',
|
||
0, '1', '1', '1',
|
||
'admin', CURRENT_TIMESTAMP, 'admin', CURRENT_TIMESTAMP, '0');
|