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

USE `YanZhongXYH`;

-- ----新增
INSERT INTO sys_role_menu
VALUES ('3', 1007);

-- 菜单 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', '1', '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', 'alumnus', 'amActivity/alumnus/index', 1, 0, 'C', '1', '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', '1', '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', '1', '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', '1', '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', '1', '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', '1', '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', '1', '0', 'amActivity:alumnus:audit', '',
        '', '', 'admin', SYSDATE(), '', NULL, '');


INSERT INTO sys_role_menu
VALUES ('1', 3);
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', 3);
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 ('3', 3);
INSERT INTO sys_role_menu
VALUES ('3', 2001);
INSERT INTO sys_role_menu
VALUES ('3', 2002);
INSERT INTO sys_role_menu
VALUES ('3', 2003);
INSERT INTO sys_role_menu
VALUES ('3', 2004);
INSERT INTO sys_role_menu
VALUES ('3', 2005);
INSERT INTO sys_role_menu
VALUES ('3', 2006);
INSERT INTO sys_role_menu
VALUES ('3', 2007);

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', '', 'danger', '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', '', 'success', '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', '3', 'activity', 'amActivity/activity/index', 1, 0, 'C', '1', '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', '1', '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', '1', '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', '1', '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', '1', '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', '1', '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', '1', '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', '1', '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', '1', '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', '1', '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, '活动热门', 2008, '10', '#', '', 1, 0, 'F', '1', '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', 2016);
INSERT INTO sys_role_menu
VALUES ('2', 2017);

INSERT INTO sys_role_menu
VALUES ('3', 2008);
INSERT INTO sys_role_menu
VALUES ('3', 2009);
INSERT INTO sys_role_menu
VALUES ('3', 2011);
INSERT INTO sys_role_menu
VALUES ('3', 2013);
INSERT INTO sys_role_menu
VALUES ('3', 2015);
INSERT INTO sys_role_menu
VALUES ('3', 2016);
INSERT INTO sys_role_menu
VALUES ('3', 2017);


INSERT INTO sys_dict_type
VALUES (19, '互助审核状态', 'help_audit_status', '0', 'admin', SYSDATE(), '', NULL, '互助审核状态');
INSERT INTO sys_dict_data
VALUES (55, 0, '审核中', '0', 'help_audit_status', '', 'primary', 'Y', '0', 'admin', SYSDATE(), '', NULL, '');
INSERT INTO sys_dict_data
VALUES (56, 1, '已审核', '1', 'help_audit_status', '', 'success', 'N', '0', 'admin', SYSDATE(), '', NULL, '');
INSERT INTO sys_dict_data
VALUES (57, 2, '未通过', '2', 'help_audit_status', '', 'danger', 'N', '0', 'admin', SYSDATE(), '', NULL, '');
# insert into sys_dict_data
# values (58, 2, '已关闭', '2', 'help_audit_status', '', 'danger', 'N', '0', 'admin', sysdate(), '', null, '');

INSERT INTO sys_dict_type
VALUES (20, '资讯状态', 'news_status', '0', 'admin', SYSDATE(), '', NULL, '资讯状态');
INSERT INTO sys_dict_data
VALUES (59, 0, '草稿', '0', 'news_status', '', 'info', 'Y', '0', 'admin', SYSDATE(), '', NULL, '');
INSERT INTO sys_dict_data
VALUES (60, 1, '已发布', '1', 'news_status', '', 'success', 'N', '0', 'admin', SYSDATE(), '', NULL, '');

INSERT INTO sys_dict_type
VALUES (21, '结束状态', 'sys_close_status', '0', 'admin', SYSDATE(), '', NULL, '结束状态');
INSERT INTO sys_dict_data
VALUES (61, 0, '未结束', '0', 'sys_close_status', '', 'success', 'Y', '0', 'admin', SYSDATE(), '', NULL, '');
INSERT INTO sys_dict_data
VALUES (62, 1, '已结束', '1', 'sys_close_status', '', 'danger', '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 (2019, '互助信息管理', '3', '4', 'help', 'amActivity/help/index', 1, 0, 'C', '1', '0', 'amActivity:help',
        'heart-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 (2020, '互助查询', 2019, '1', '#', '', 1, 0, 'F', '1', '0', 'amActivity:help: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 (2021, '互助新增', 2019, '2', '#', '', 1, 0, 'F', '1', '0', 'amActivity:help: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 (2022, '互助修改', 2019, '3', '#', '', 1, 0, 'F', '1', '0', 'amActivity:help: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 (2023, '互助删除', 2019, '4', '#', '', 1, 0, 'F', '1', '0', 'amActivity:help: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 (2024, '互助审核', 2019, '5', '#', '', 1, 0, 'F', '1', '0', 'amActivity:help: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 (2025, '互助置顶', 2019, '6', '#', '', 1, 0, 'F', '1', '0', 'amActivity:help: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 (2026, '互助热门', 2019, '7', '#', '', 1, 0, 'F', '1', '0', 'amActivity:help:hot', '', '', '', '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 (2044, '结束互助', 2019, '8', '#', '', 1, 0, 'F', '1', '0', 'amActivity:help:close', '', '', '', 'admin',
        SYSDATE(), '', NULL, '');

INSERT INTO sys_role_menu
VALUES ('1', 2019);
INSERT INTO sys_role_menu
VALUES ('1', 2020);
INSERT INTO sys_role_menu
VALUES ('1', 2021);
INSERT INTO sys_role_menu
VALUES ('1', 2022);
INSERT INTO sys_role_menu
VALUES ('1', 2023);
INSERT INTO sys_role_menu
VALUES ('1', 2024);
INSERT INTO sys_role_menu
VALUES ('1', 2025);
INSERT INTO sys_role_menu
VALUES ('1', 2026);
INSERT INTO sys_role_menu
VALUES ('1', 2044);



INSERT INTO sys_role_menu
VALUES ('2', 2019);
INSERT INTO sys_role_menu
VALUES ('2', 2020);
INSERT INTO sys_role_menu
VALUES ('2', 2021);
INSERT INTO sys_role_menu
VALUES ('2', 2022);
INSERT INTO sys_role_menu
VALUES ('2', 2023);
INSERT INTO sys_role_menu
VALUES ('2', 2044);

INSERT INTO sys_role_menu
VALUES ('3', 2019);
INSERT INTO sys_role_menu
VALUES ('3', 2020);
INSERT INTO sys_role_menu
VALUES ('3', 2022);
INSERT INTO sys_role_menu
VALUES ('3', 2024);
INSERT INTO sys_role_menu
VALUES ('3', 2044);

-- 菜单 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 (2027, '资讯信息管理', '3', '2', 'news', 'amActivity/news/index', 1, 0, 'C', '1', '0', 'amActivity:news',
        'receipt',
        '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 (2028, '资讯查询', 2027, '1', '#', '', 1, 0, 'F', '1', '0', 'amActivity:news: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 (2029, '资讯新增', 2027, '2', '#', '', 1, 0, 'F', '1', '0', 'amActivity:news: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 (2030, '资讯修改', 2027, '3', '#', '', 1, 0, 'F', '1', '0', 'amActivity:news: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 (2031, '资讯删除', 2027, '4', '#', '', 1, 0, 'F', '1', '0', 'amActivity:news: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 (2032, '资讯发布', 2027, '5', '#', '', 1, 0, 'F', '1', '0', 'amActivity:news:publish', 'envelope-open',
        'btn btn-light-info', 'handlePublisht@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 (2033, '资讯置顶', 2027, '6', '#', '', 1, 0, 'F', '1', '0', 'amActivity:news: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 (2034, '资讯热门', 2027, '7', '#', '', 1, 0, 'F', '1', '0', 'amActivity:news:hot', '',
        '', '', 'admin', SYSDATE(), '', NULL, '');

INSERT INTO sys_role_menu
VALUES ('1', 2027);
INSERT INTO sys_role_menu
VALUES ('1', 2028);
INSERT INTO sys_role_menu
VALUES ('1', 2029);
INSERT INTO sys_role_menu
VALUES ('1', 2030);
INSERT INTO sys_role_menu
VALUES ('1', 2031);
INSERT INTO sys_role_menu
VALUES ('1', 2032);
INSERT INTO sys_role_menu
VALUES ('1', 2033);
INSERT INTO sys_role_menu
VALUES ('1', 2034);



INSERT INTO sys_role_menu
VALUES ('2', 2027);
INSERT INTO sys_role_menu
VALUES ('2', 2028);

-- 菜单 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 (2035, '评论信息管理', '3', '7', 'comment', 'amActivity/comment/index', 1, 0, 'C', '0', '0',
        'amActivity:comment',
        '#', '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 (2036, '评论查询', 2035, '1', '#', '', 1, 0, 'F', '1', '0', 'amActivity:comment: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 (2037, '评论新增', 2035, '2', '#', '', 1, 0, 'F', '1', '0', 'amActivity:comment: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 (2038, '评论修改', 2035, '3', '#', '', 1, 0, 'F', '1', '0', 'amActivity:comment: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 (2039, '评论删除', 2035, '4', '#', '', 1, 0, 'F', '1', '0', 'amActivity:comment: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 (2040, '评论审核', 2035, '5', '#', '', 1, 0, 'F', '1', '0', 'amActivity:comment:audit', '', '', '', 'admin',
        SYSDATE(), '', NULL, '');

INSERT INTO sys_role_menu
VALUES ('1', 2035);
INSERT INTO sys_role_menu
VALUES ('1', 2036);
INSERT INTO sys_role_menu
VALUES ('1', 2037);
INSERT INTO sys_role_menu
VALUES ('1', 2038);
INSERT INTO sys_role_menu
VALUES ('1', 2039);
INSERT INTO sys_role_menu
VALUES ('1', 2040);



INSERT INTO sys_role_menu
VALUES ('2', 2035);
INSERT INTO sys_role_menu
VALUES ('2', 2036);
INSERT INTO sys_role_menu
VALUES ('2', 2037);
INSERT INTO sys_role_menu
VALUES ('2', 2038);
INSERT INTO sys_role_menu
VALUES ('2', 2039);

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 (2041, '统计信息管理', '3', '8', 'statistics', 'amActivity/statistics/index', 1, 0, 'C', '0', '0',
        'amActivity:statistics', '#', 'admin', SYSDATE(), '', NULL, '统计菜单');



INSERT INTO sys_role_menu
VALUES ('1', 2041);



INSERT INTO sys_role_menu
VALUES ('2', 2041);


INSERT INTO sys_dict_type
VALUES (22, '好友申请状态', 'friend_apply_status', '0', 'admin', SYSDATE(), '', NULL, '好友申请状态');
INSERT INTO sys_dict_data
VALUES (63, 0, '申请中', '0', 'friend_apply_status', '', 'primary', 'Y', '0', 'admin', SYSDATE(), '', NULL, '');
INSERT INTO sys_dict_data
VALUES (64, 1, '已通过', '1', 'friend_apply_status', '', 'success', 'N', '0', 'admin', SYSDATE(), '', NULL, '');
INSERT INTO sys_dict_data
VALUES (65, 1, '已拒绝', '2', 'friend_apply_status', '', 'danger', 'N', '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, create_by, create_time, update_by, update_time, remark)
VALUES (2042, '好友信息管理', '3', '1', 'friends', 'amFriend/friends/index', 1, 0, 'C', '0', '0', 'amFriend:friends',
        '#', 'admin', SYSDATE(), '', NULL, '好友信息菜单');

INSERT INTO sys_role_menu
VALUES ('1', 2042);

INSERT INTO sys_role_menu
VALUES ('2', 2042);

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 (2043, '设为管理员', 2001, '6', '#', '', 1, 0, 'F', '1', '0', 'system:user:setSys', '',
        '', '', 'admin', SYSDATE(), '', NULL, '');
INSERT INTO sys_role_menu
VALUES ('1', 2043);
# 2044 已使用