FinanceSystem/script/sql/ykn/serviceFeeMenu.sql

20 lines
2.3 KiB
MySQL
Raw Permalink Normal View History

2024-06-20 16:57:16 +08:00
-- 菜单 SQL
insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values(1802311106792525826, '劳务费', '1802308284881571841', '1', 'serviceFee', 'finance/serviceFee/index', 1, 0, 'C', '0', '0', 'finance:serviceFee:list', '#', 'admin', sysdate(), '', null, '劳务费菜单');
-- 按钮 SQL
insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values(1802311106792525827, '劳务费查询', 1802311106792525826, '1', '#', '', 1, 0, 'F', '0', '0', 'finance:serviceFee:query', '#', 'admin', sysdate(), '', null, '');
insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values(1802311106792525828, '劳务费新增', 1802311106792525826, '2', '#', '', 1, 0, 'F', '0', '0', 'finance:serviceFee:add', '#', 'admin', sysdate(), '', null, '');
insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values(1802311106792525829, '劳务费修改', 1802311106792525826, '3', '#', '', 1, 0, 'F', '0', '0', 'finance:serviceFee:edit', '#', 'admin', sysdate(), '', null, '');
insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values(1802311106792525830, '劳务费删除', 1802311106792525826, '4', '#', '', 1, 0, 'F', '0', '0', 'finance:serviceFee:remove', '#', 'admin', sysdate(), '', null, '');
insert into sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values(1802311106792525831, '劳务费导出', 1802311106792525826, '5', '#', '', 1, 0, 'F', '0', '0', 'finance:serviceFee:export', '#', 'admin', sysdate(), '', null, '');