YzXyh_v3/SERVER/YanZhongXYH/script/sql/Add.sql

-- ----新增
-- 菜单 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 (2001, '校友', '1', '1', 'alumnus', 'system/alumnus/index', 1, 0, 'C', '0', '0', 'system:alumnus', '#', '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, btn_class, btn_script, create_by, create_time, update_by, update_time,
                      remark)
values (2002, '校友查询', 2001, '1', '#', '', 1, 0, 'F', '0', '0', 'system:alumnus:query', 'eye', '', '', '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, btn_class, btn_script, create_by, create_time, update_by, update_time,
                      remark)
values (2003, '校友新增', 2001, '2', '#', '', 1, 0, 'F', '0', '0', 'system:alumnus:add', 'plus-square',
        'btn btn-light-primary', 'handleCreate', '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, btn_class, btn_script, create_by, create_time, update_by, update_time,
                      remark)
values (2004, '校友修改', 2001, '3', '#', '', 1, 0, 'F', '0', '0', 'system:alumnus:edit', 'pencil-square',
        'btn btn-light-success', 'handleUpdate@1', '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, btn_class, btn_script, create_by, create_time, update_by, update_time,
                      remark)
values (2005, '校友删除', 2001, '4', '#', '', 1, 0, 'F', '0', '0', 'system:alumnus:remove', 'dash-square',
        'btn btn-light-danger', 'handleDelete@0', '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, btn_class, btn_script, create_by, create_time, update_by, update_time,
                      remark)
values (2006, '校友导出', 2001, '5', '#', '', 1, 0, 'F', '0', '0', 'system:alumnus:export', 'cloud-download',
        'btn btn-light-info', 'handleExport', '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, btn_class, btn_script, create_by, create_time, update_by, update_time,
                      remark)
values (2007, '校友审核', 2001, '5', '#', '', 1, 0, 'F', '0', '0', 'system:alumnus:audit', 'cloud-download',
        'btn btn-light-info', 'handleAudit', 'admin', sysdate(), '', null, '');

insert into sys_role_menu
values ('1', 2001);
insert into sys_role_menu
values ('1', 2002);
insert into sys_role_menu
values ('1', 2003);
insert into sys_role_menu
values ('1', 2004);
insert into sys_role_menu
values ('1', 2005);
insert into sys_role_menu
values ('1', 2006);
insert into sys_role_menu
values ('1', 2007);

insert into sys_role_menu
values ('2', 2001);
insert into sys_role_menu
values ('2', 2002);
insert into sys_role_menu
values ('2', 2003);
insert into sys_role_menu
values ('2', 2004);
insert into sys_role_menu
values ('2', 2005);
insert into sys_role_menu
values ('2', 2006);
insert into sys_role_menu
values ('2', 2007);

insert into sys_role_menu
values ('3', 2003);
insert into sys_role_menu
values ('3', 2004);