sanya-data-management-back/sql/pgsql/0_init.sql

-- 驾驶舱数据管理
-- delete from base.sys_menu where menu_id=3000;
-- delete from base.sys_menu where menu_id=3001;
-- delete from base.sys_menu where menu_id=3002;
-- delete from base.sys_menu where menu_id=3003;
-- delete from base.sys_menu where menu_id=3004;
-- delete from base.sys_menu where menu_id=3005;

-- 菜单 SQL
insert into base.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(3000,'驾驶舱数据管理', '1065', '9', 'sql', 'system/jsc/data/index', 1, 0, 'C', '0', '0', 'system:jsc:data:list', 'edit', 'admin', now(), '', null, '驾驶舱数据管理菜单');

-- 按钮 SQL
insert into base.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(3001,'数据查询', 3000, '1',  '#', '', 1, 0, 'F', '0', '0', 'system:jsc:data:query',        '#', 'admin', now(), '', null, '');

insert into base.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(3002,'数据新增', 3000, '2',  '#', '', 1, 0, 'F', '0', '0', 'system:jsc:data:add',          '#', 'admin', now(), '', null, '');

insert into base.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(3003,'数据修改', 3000, '3',  '#', '', 1, 0, 'F', '0', '0', 'system:jsc:data:edit',         '#', 'admin', now(), '', null, '');

insert into base.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(3004,'数据删除', 3000, '4',  '#', '', 1, 0, 'F', '0', '0', 'system:jsc:data:remove',       '#', 'admin', now(), '', null, '');

insert into base.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(3005,'数据导出', 3000, '5',  '#', '', 1, 0, 'F', '0', '0', 'system:jsc:data:export',       '#', 'admin', now(), '', null, '');