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, btn_class, btn_script, create_by, create_time, update_by, update_time,
                      remark)
values (3, '校友活动管理', 0, '0', 'amActivity', '', 1, 0, 'M', '0', '0', '', 'x-diamond-fill',
        '', '', '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 (2001, '校友管理', '3', '1', 'amActivity', 'system/amActivity/index', 1, 0, 'C', '0', '0',
        'amActivity:alumnus',
        'people-fill',
        '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', 'amActivity: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', 'amActivity: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', 'amActivity: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', 'amActivity: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', 'amActivity: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', 'amActivity:alumnus:audit', '',
        '', '', '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);

insert into sys_dict_type
values (16, '活动审核状态', 'activity_audit_status', '0', 'admin', sysdate(), '', null, '活动审核状态');
insert into sys_dict_data
values (46, 0, '申请中', '0', 'activity_audit_status', '', 'info', 'Y', '0', 'admin', sysdate(), '', null, '');
insert into sys_dict_data
values (47, 0, '报名中', '1', 'activity_audit_status', '', 'primary', 'N', '0', 'admin', sysdate(), '', null, '');
insert into sys_dict_data
values (48, 0, '未通过', '2', 'activity_audit_status', '', 'warning', 'N', '0', 'admin', sysdate(), '', null, '');
insert into sys_dict_data
values (49, 0, '已结束', '3', 'activity_audit_status', '', 'danger', 'N', '0', 'admin', sysdate(), '', null, '');

insert into sys_dict_type
values (17, '活动报名状态', 'activity_apply_status', '0', 'admin', sysdate(), '', null, '活动报名状态');
insert into sys_dict_data
values (50, 0, '报名中', '0', 'activity_apply_status', '', 'primary', 'Y', '0', 'admin', sysdate(), '', null, '');
insert into sys_dict_data
values (51, 1, '报名成功', '1', 'activity_apply_status', '', 'warning', 'N', '0', 'admin', sysdate(), '', null, '');
insert into sys_dict_data
values (52, 2, '报名失败', '2', 'activity_apply_status', '', 'danger', 'N', '0', 'admin', sysdate(), '', null, '');

insert into sys_dict_type
values (18, '活动付费状态', 'activity_cost_status', '0', 'admin', sysdate(), '', null, '活动报名状态');
insert into sys_dict_data
values (53, 0, '未付费', '0', 'activity_cost_status', '', 'info', 'Y', '0', 'admin', sysdate(), '', null, '');
insert into sys_dict_data
values (54, 1, '已付费', '1', 'activity_cost_status', '', 'success', 'N', '0', '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 (2008, '活动管理', '3', '2', 'activity', 'amActivity/activity/index', 1, 0, 'C', '0', '0',
        'amActivity:activity', 'boxes', '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 (2009, '活动查询', 2008, '1', '#', '', 1, 0, 'F', '0', '0', 'amActivity:activity: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 (2010, '活动新增', 2008, '2', '#', '', 1, 0, 'F', '0', '0', 'amActivity:activity: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 (2011, '活动修改', 2008, '3', '#', '', 1, 0, 'F', '0', '0', 'amActivity:activity: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 (2012, '活动删除', 2008, '4', '#', '', 1, 0, 'F', '0', '0', 'amActivity:activity: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 (2013, '活动审核', 2008, '5', '#', '', 1, 0, 'F', '0', '0', 'amActivity:activity:audit', '', '', '', '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 (2014, '活动置顶', 2008, '6', '#', '', 1, 0, 'F', '0', '0', 'amActivity:activity:top', '', '', '', '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 (2015, '结束活动', 2008, '7', '#', '', 1, 0, 'F', '0', '0', 'amActivity:activity:close', '', '', '', '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 (2016, '活动报名审核', 2008, '8', '#', '', 1, 0, 'F', '0', '0', 'amActivity:activity:apply', '', '', '', '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 (2017, '活动付费审核', 2008, '9', '#', '', 1, 0, 'F', '0', '0', 'amActivity:activity:cost', '', '', '', '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 (2018, '活动HOT', 2008, '10', '#', '', 1, 0, 'F', '0', '0', 'amActivity:activity:hot', '', '', '', 'admin',
        sysdate(), '', null, '');


insert into sys_role_menu
values ('1', 2008);
insert into sys_role_menu
values ('1', 2009);
insert into sys_role_menu
values ('1', 2010);
insert into sys_role_menu
values ('1', 2011);
insert into sys_role_menu
values ('1', 2012);
insert into sys_role_menu
values ('1', 2013);
insert into sys_role_menu
values ('1', 2014);
insert into sys_role_menu
values ('1', 2015);
insert into sys_role_menu
values ('1', 2016);
insert into sys_role_menu
values ('1', 2017);
insert into sys_role_menu
values ('1', 2018);

insert into sys_role_menu
values ('2', 2008);
insert into sys_role_menu
values ('2', 2009);
insert into sys_role_menu
values ('2', 2010);
insert into sys_role_menu
values ('2', 2011);
insert into sys_role_menu
values ('2', 2012);
insert into sys_role_menu
values ('2', 2013);
insert into sys_role_menu
values ('2', 2014);
insert into sys_role_menu
values ('2', 2015);
insert into sys_role_menu
values ('2', 2016);
insert into sys_role_menu
values ('2', 2017);
insert into sys_role_menu
values ('2', 2018);

insert into sys_role_menu
values ('3', 2008);
insert into sys_role_menu
values ('3', 2009);
insert into sys_role_menu
values ('3', 2010);
insert into sys_role_menu
values ('3', 2011);
insert into sys_role_menu
values ('3', 2016);
insert into sys_role_menu
values ('3', 2017);