-- 开始初始化数据 ;
INSERT INTO sys_menu VALUES (1, 0, '系统信息维护', 'system','terminal',     '/0/1', 'M', '', '', 'Layout','','', 1, true,  false, false, 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_menu VALUES (2, 0, '定时任务维护', 'schedule', 'clock',  '/0/4', 'M', '', '', 'Layout','','', 2, false, false, false, 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_menu VALUES (3, 0, '系统工具维护', 'sys-tools', 'display', '0/3', 'M', '', '', 'Layout','','', 3, false, false, false, 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_menu VALUES (4, 0, '开发工具维护', 'dev-tools', 'display',      '/0/2', 'M', '', '', 'Layout','','', 4, false, false, false, 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);


INSERT INTO sys_menu VALUES (11,1, '系统用户管理', 'user', 'person-circle', '/0/1/11', 'C', '', 'system:user',  '/system/user/index','','', 1, false,false, false, 0, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_menu VALUES (12,1, '系统角色管理', 'role',  'person-gear', '/0/1/12', 'C', '', 'system:role', '/system/role/index','','', 2, false, false, false, 0, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_menu VALUES (13,1, '系统菜单管理', 'menu', 'list', '/0/1/13', 'C', '', 'system:menu', '/system/menu/index','','', 3,  false,false, false, 0, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_menu VALUES (14,1, '组织机构管理', 'org', 'card-list',  '/0/1/14', 'C', '', 'system:org',  '/system/org/index','','', 4, false,false, false, 0, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_menu VALUES (15,1, '系统岗位管理', 'post', 'file-person',  '/0/1/15', 'C', '', 'system:post','/system/post/index','','', 5, false, false,  false, 0, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_menu VALUES (16,1, '系统字典管理', 'dict', 'file-earmark-medical', '/0/1/16', 'C', '', 'system:dict',  '/system/dict/index', '','',6, false, false,false, 0, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_menu VALUES (17,1, '系统字典数据', 'dict-data', 'file-earmark-medical', '/0/1/17', 'C', '', 'system:dictData',  '/system/dict/data', '','',7,false, true, false, 0, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_menu VALUES (18,1, '系统接口管理', 'api', 'file-slides', '/0/1/18', 'C', '', 'system:api',  '/system/api/index','','', 8, false,false, false, 0, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_menu VALUES (19,1, '系统参数管理', 'config', 'gear', '/0/2/62', 'C', '', 'system:config',  '/system/config/index','','', 9, false,false, false, 0, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_menu VALUES (20,1, '系统参数设置', 'config-set', 'gear','/0/1/19', 'C', '', 'system:configSet',  '/system/config/set','','', 10, false,true, false, 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_menu VALUES (21,1, '系统日志管理', 'log', 'file-earmark-medical', '/0/1/18', 'M', '', '',   'ParentView','','', 11,  false,false, false, 0, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_menu VALUES (22,21, '登录日志', 'login', 'file-earmark-person', '/0/1/21/22', 'C', '', 'system:loginLog',  '/system/log/login','','', 1, false,  false,false, 0, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_menu VALUES (23,21, '操作日志', 'operation', 'file-earmark-easel', '/0/1/21/23', 'C', '', 'system:operLog', '/system/log/oper','','', 1, false, false, false, 0, 2, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);

INSERT INTO sys_menu VALUES (31,2, '定时任务','job', 'file-slides', '/0/4/51', 'C', '', 'schedule:job',  '/schedule/job/index','','', 1, false, false,false, 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_menu VALUES (32,2, '定时任务日志','job-log', 'file-earmark-medical', '/0/4/52', 'C', '', '',  '/schedule/job/log','','', 2,  false,true, false, 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);

INSERT INTO sys_menu VALUES (41,3, '服务监控', 'ServerMonitor','display', '/0/3/41', 'C', '', 'sysTools:serverMonitor',   '/tools/monitor/index','','', 1, false, false, false, 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);

INSERT INTO sys_menu VALUES (51,4, '系统接口','swagger', 'boxes', '/0/2/31', 'C', '', '', '/dev-tools/swagger/index','','', 1, false,   false,false, 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_menu VALUES (52,4, '代码生成', 'gen','exclude', '/0/2/32', 'C', '', '', '/dev-tools/gen/index','','', 2,false, false, false, 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);



INSERT INTO sys_menu VALUES (101, 11,'查询用户','#','eye','', 'F', 'GET', 'system:user:query',  '', '', '',1, false,true, false ,1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_menu VALUES (102, 11,'新增用户','#','plus-square', '', 'F', 'POST', 'system:user:add',   '', 'btn btn-light-primary','handleCreate', 2,  false,false,false, 1, 1,'2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_menu VALUES (103, 11,'修改用户','#','pencil-square', '', 'F', 'PUT', 'system:user:edit',  '', 'btn btn-light-success','handleUpdate@1', 3,  false,false,false, 1, 1,'2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_menu VALUES (104, 11,'删除用户','#','dash-square','', 'F', 'DELETE', 'system:user:remove',  '', 'btn btn-light-danger','handleDelete@0', 4,  false,false,false, 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_menu VALUES (105, 11,'密码重置','#','person-fill-lock','', 'F', 'GET', 'system:user:resetPwd',  '', '', '',5, false,true, false ,1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);

INSERT INTO sys_menu VALUES (111, 12,'查询角色','#','eye','', 'F', 'GET', 'system:role:query', '', '', '',1, false,true, false ,1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_menu VALUES (112, 12,'新增角色','#','plus-square' ,'', 'F', 'POST', 'system:role:add',   '', 'btn btn-light-primary','handleCreate', 2,  false,false,false, 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_menu VALUES (113, 12,'修改角色','#','pencil-square', '', 'F', 'PUT', 'system:role:edit',  '', 'btn btn-light-success','handleUpdate@1', 3,  false,false,false, 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_menu VALUES (114, 12,'删除角色','#','dash-square','', 'F', 'DELETE', 'system:role:remove', '', 'btn btn-light-danger', 'handleDelete@0', 4,  false,false,false, 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);

INSERT INTO sys_menu VALUES (121, 13,'查询菜单','#','eye','', 'F', 'GET', 'system:menu:query', '', '', '',1, false,true, false ,1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_menu VALUES (122, 13,'新增菜单','#','plus-square' ,'', 'F', 'POST', 'system:menu:add',   '', 'btn btn-light-primary','handleCreate', 2,  false,false,false, 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_menu VALUES (123, 13,'修改菜单','#','pencil-square', '', 'F', 'PUT', 'system:menu:edit',  '', 'btn btn-light-success','handleUpdate@1', 3,  false,false,false, 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_menu VALUES (124, 13,'删除菜单','#','dash-square','', 'F', 'DELETE', 'system:menu:remove', '', 'btn btn-light-danger', 'handleDelete@0', 4,  false,false,false, 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);

INSERT INTO sys_menu VALUES (131, 14,'查询组织机构','#','eye','', 'F', 'GET', 'system:org:query', '', '', '',1, false,true, false ,1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_menu VALUES (132, 14,'新增组织机构','#','plus-square' ,'', 'F', 'POST', 'system:org:add',   '', 'btn btn-light-primary','handleCreate', 2,  false,false,false, 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_menu VALUES (133, 14,'修改组织机构','#','pencil-square' ,'', 'F', 'PUT', 'system:org:edit',  '', 'btn btn-light-success','handleUpdate@1', 3,  false,false,false, 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_menu VALUES (134, 14,'删除组织机构','#','dash-square','', 'F', 'DELETE', 'system:org:remove', '', 'btn btn-light-danger', 'handleDelete@0', 4,  false,false,false, 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);

INSERT INTO sys_menu VALUES (141, 15,'查询岗位','#','eye','', 'F', 'GET', 'system:post:query', '', '', '',1, false,true, false ,1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_menu VALUES (142, 15,'新增岗位','#','plus-square','', 'F', 'POST', 'system:post:add',   '', 'btn btn-light-primary','handleCreate', 2,  false,false,false, 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_menu VALUES (143, 15,'修改岗位','#','pencil-square','', 'F', 'PUT', 'system:post:edit',  '', 'btn btn-light-success','handleUpdate@1', 3,  false,false,false, 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_menu VALUES (144, 15,'删除岗位','#','dash-square','', 'F', 'DELETE', 'system:post:remove', '', 'btn btn-light-danger', 'handleDelete@0', 4,  false,false,false, 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);

INSERT INTO sys_menu VALUES (151, 16,'查询字典','#','eye','', 'F', 'GET', 'system:dict:query', '', '', '',1, false,true, false ,1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_menu VALUES (152, 16,'新增字典','#','plus-square','', 'F', 'POST', 'system:dict:add',   '', 'btn btn-light-primary','handleCreate', 2,  false,false,false, 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_menu VALUES (153, 16,'修改字典','#','pencil-square','', 'F', 'PUT', 'system:dict:edit',  '', 'btn btn-light-success','handleUpdate@1', 3,  false,false,false, 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_menu VALUES (154, 16,'删除字典','#','dash-square','', 'F', 'DELETE', 'system:dict:remove', '', 'btn btn-light-danger', 'handleDelete@0', 4,  false,false,false, 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);

INSERT INTO sys_menu VALUES (161, 17,'查询数据','#','eye','', 'F', 'GET', 'system:dictData:query', '', '', '',1, false,true, false ,1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_menu VALUES (162, 17,'新增数据','#','plus-square','', 'F', 'POST', 'system:dictData:add',   '', 'btn btn-light-primary','handleCreate', 2,  false,false,false, 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_menu VALUES (163, 17,'修改数据','#','pencil-square','', 'F', 'PUT', 'system:dictData:edit',  '', 'btn btn-light-success','handleUpdate@1', 3,  false,false,false, 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_menu VALUES (164, 17,'删除数据','#','dash-square','', 'F', 'DELETE', 'system:dictData:remove', '', 'btn btn-light-danger', 'handleDelete@0', 4,  false,false,false, 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);

INSERT INTO sys_menu VALUES (171, 18,'查询接口','#','eye','', 'F', 'GET', 'system:api:query', '', '', '',1, false,true, false ,1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_menu VALUES (172, 18,'修改接口','#','pencil-square','', 'F', 'PUT', 'system:api:edit',  '', 'btn btn-light-success','handleUpdate@1', 3,  false,false,false, 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);

INSERT INTO sys_menu VALUES (181, 19,'查询配置参数','#','eye','', 'F', 'GET', 'system:config:query', '', '', '',1, false,true, false ,1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_menu VALUES (182, 19,'新增配置参数','#','plus-square','', 'F', 'POST', 'system:config:add',   '', 'btn btn-light-primary','handleCreate', 2,  false,false,false, 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_menu VALUES (183, 19,'修改配置参数数','#','pencil-square','', 'F', 'PUT', 'system:config:edit',  '', 'btn btn-light-success','handleUpdate@1', 3,  false,false,false, 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_menu VALUES (184, 19,'删除配置参数','#','dash-square','', 'F', 'DELETE', 'system:config:remove', '', 'btn btn-light-danger', 'handleDelete@0', 4,  false,false,false, 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);

INSERT INTO sys_menu VALUES (191, 22,'查询登录日志','#','eye','', 'F', 'GET', 'system:loginLog:query', '', '', '',1, false,true, false ,1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_menu VALUES (192, 22,'删除登录日志','#','dash-square','', 'F', 'DELETE', 'system:loginLog:remove', '', 'btn btn-light-danger', 'handleDelete@0', 4,  false,false,false, 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);

INSERT INTO sys_menu VALUES (196, 23,'查询操作日志','#','eye','', 'F', 'GET', 'system:operLog:query', '', '', '',1, false,true, false ,1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_menu VALUES (197, 23,'删除操作日志','#','dash-square','', 'F', 'DELETE', 'system:operLog:remove', '', 'btn btn-light-danger', 'handleDelete@0', 4,  false,false,false, 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);

INSERT INTO sys_menu VALUES (201, 31,'查询定时任务','#','eye','', 'F', 'GET', 'system:jobs:query', '', '', '',1, false,true, false ,1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_menu VALUES (202, 31,'新增任务','#','plus-square','', 'F', 'POST', 'system:jobs:add',   '', 'btn btn-light-primary','handleCreate', 2,  false,false,false, 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_menu VALUES (203, 31,'修改任务','#','pencil-square','', 'F', 'PUT', 'system:jobs:edit',  '', 'btn btn-light-success','handleUpdate@1', 3,  false,false,false, 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_menu VALUES (204, 31,'删除任务','#','dash-square','', 'F', 'DELETE', 'system:jobs:remove', '', 'btn btn-light-danger', 'handleDelete@0', 4,  false,false,false, 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_menu VALUES (205, 31,'启动任务','#','play-btn-fill','', 'F', 'POST', 'system:jobs:query', '', '', '',5, false,true, false ,1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_menu VALUES (206, 31,'停止任务','#','stop-btn-fill','', 'F', 'POST', 'system:jobs:query', '', '', '',6, false,true, false ,1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
-- INSERT INTO sys_menu VALUES (207, 31,'删除任务日志','#','dash-square','', 'F', 'DELETE', 'system:jobs-log:remove', '', 'btn btn-light-danger', 'handleDelete@0', 7,  false,false,false, 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);


INSERT INTO sys_api VALUES  (1,'','登录','/api/login','POST','SYS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (2,'','退出登录','/api/logout','POST','SYS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (3,'','获取验证码','/api/captcha','GET','SYS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (4,'','上传图片','/api/sys/upload-file','POST','SYS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (5,'','获取系统信息','/api/sys/server-monitor','GET','SYS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (11,'','获取用戶信息','/api/sys/get-info','GET','SYS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (12,'','获取用戶个人中心信息','/api/sys/profile','GET','SYS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (13,'','修改头像','/api/sys/avatar','PUT','SYS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (14,'','修改密码','/api/sys/pwd','PUT','SYS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (21,'','获取部门树','/api/sys/org-tree/:id','GET','SYS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (22,'','获取部门下拉树结构(角色)','/api/sys/role-org-tree-select/:roleId','GET','SYS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (25,'','获取菜单路由数据','/api/sys/get-router','GET','SYS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (26,'','获取菜单下拉树结构(角色)','/api/sys/role-menu-tree-select/:roleId','GET','SYS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (27,'','获取子按钮(权限名)','/api/sys/prem-menu-btn/:permission','GET','SYS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (31,'','获取字典类型下拉型树','/api/sys/dict-type-option-select','GET','SYS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (32,'','获取字典数据下拉型树','/api/sys/dict-data-option-select','GET','SYS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (35,'','获取系统配置信息','/api/sys/app-config','GET','SYS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (36,'','获取配置参数值','/api/sys/config-key/:key','GET','SYS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (37,'','获取可配置的配置参数','/api/sys/set-config','GET','SYS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (38,'','修改可配置的配置参数','/api/sys/set-config','PUT','SYS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);

INSERT INTO sys_api VALUES  (101,'','查询用戶列表','/api/sys-user','GET','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (102,'','查询用戶详情','/api/sys-user/:id','GET','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (103,'','添加用戶','/api/sys-user','POST','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (104,'','修改用戶','/api/sys-user','PUT','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (105,'','删除用戶','/api/sys-user','DELETE','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (106,'','重置密码','/api/sys-user/reset-pwd','PUT','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (107,'','修改用戶状态','/api/sys-user/change-status','PUT','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (108,'','查询用戶角色','/api/sys-user/roles/:id','GET','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);

INSERT INTO sys_menu_api VALUES (11, 101);
INSERT INTO sys_menu_api VALUES (11, 102);
INSERT INTO sys_menu_api VALUES (101, 101);
INSERT INTO sys_menu_api VALUES (101, 102);
INSERT INTO sys_menu_api VALUES (102, 103);
INSERT INTO sys_menu_api VALUES (103, 104);
INSERT INTO sys_menu_api VALUES (104, 105);
INSERT INTO sys_menu_api VALUES (103, 106);
INSERT INTO sys_menu_api VALUES (103, 107);
INSERT INTO sys_menu_api VALUES (11, 108);
INSERT INTO sys_menu_api VALUES (101, 108);

INSERT INTO sys_api VALUES  (111,'','查询角色列表','/api/sys-role','GET','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (112,'','查询角色详情','/api/sys-role/:id','GET','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (113,'','添加角色','/api/sys-role','POST','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (114,'','修改角色','/api/sys-role/:id','PUT','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (115,'','删除角色','/api/sys-role','DELETE','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (116,'','修改数据权限范围','/api/sys-role/data-scope','PUT','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (117,'','修改角色状态','/api/sys-role/change-status','PUT','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);

INSERT INTO sys_menu_api VALUES (12, 111);
INSERT INTO sys_menu_api VALUES (12, 112);
INSERT INTO sys_menu_api VALUES (111, 111);
INSERT INTO sys_menu_api VALUES (111, 112);
INSERT INTO sys_menu_api VALUES (112, 113);
INSERT INTO sys_menu_api VALUES (113, 114);
INSERT INTO sys_menu_api VALUES (114, 115);
INSERT INTO sys_menu_api VALUES (113, 116);
INSERT INTO sys_menu_api VALUES (113, 117);

INSERT INTO sys_api VALUES  (121,'','查询菜单列表','/api/sys-menu','GET','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (122,'','查询菜单详情','/api/sys-menu/:id','GET','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (123,'','添加菜单','/api/sys-menu','POST','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (124,'','修改菜单','/api/sys-menu/:id','PUT','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (125,'','删除菜单','/api/sys-menu','DELETE','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);

INSERT INTO sys_menu_api VALUES (13, 121);
INSERT INTO sys_menu_api VALUES (13, 122);
INSERT INTO sys_menu_api VALUES (121, 121);
INSERT INTO sys_menu_api VALUES (121, 122);
INSERT INTO sys_menu_api VALUES (122, 123);
INSERT INTO sys_menu_api VALUES (123, 124);
INSERT INTO sys_menu_api VALUES (124, 125);

INSERT INTO sys_api VALUES  (131,'','查询组织机构列表','/api/sys-org','GET','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (132,'','查询组织机构详情','/api/sys-org/:id','GET','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (133,'','添加组织机构','/api/sys-org','POST','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (134,'','修改组织机构','/api/sys-org/:id','PUT','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (135,'','删除组织机构','/api/sys-org','DELETE','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);

INSERT INTO sys_menu_api VALUES (14, 131);
INSERT INTO sys_menu_api VALUES (14, 132);
INSERT INTO sys_menu_api VALUES (131, 131);
INSERT INTO sys_menu_api VALUES (131, 132);
INSERT INTO sys_menu_api VALUES (132, 133);
INSERT INTO sys_menu_api VALUES (133, 134);
INSERT INTO sys_menu_api VALUES (134, 135);

INSERT INTO sys_api VALUES  (141,'','查询岗位列表','/api/sys-post','GET','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (142,'','查询岗位详情','/api/sys-post/:id','GET','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (143,'','添加岗位','/api/sys-post','POST','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (144,'','修改岗位','/api/sys-post/:id','PUT','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (145,'','删除岗位','/api/sys-post','DELETE','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);

INSERT INTO sys_menu_api VALUES (15, 141);
INSERT INTO sys_menu_api VALUES (15, 142);
INSERT INTO sys_menu_api VALUES (141, 141);
INSERT INTO sys_menu_api VALUES (141, 142);
INSERT INTO sys_menu_api VALUES (142, 143);
INSERT INTO sys_menu_api VALUES (143, 144);
INSERT INTO sys_menu_api VALUES (144, 145);

INSERT INTO sys_api VALUES  (151,'','查询字典列表','/api/sys-dict-type','GET','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (152,'','查询字典详情','/api/sys-dict-type/:id','GET','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (153,'','添加字典','/api/sys-dict-type','POST','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (154,'','修改字典','/api/sys-dict-type/:id','PUT','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (155,'','删除字典','/api/sys-dict-type','DELETE','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);

INSERT INTO sys_menu_api VALUES (16, 151);
INSERT INTO sys_menu_api VALUES (16, 152);
INSERT INTO sys_menu_api VALUES (151, 151);
INSERT INTO sys_menu_api VALUES (151, 152);
INSERT INTO sys_menu_api VALUES (152, 153);
INSERT INTO sys_menu_api VALUES (153, 154);
INSERT INTO sys_menu_api VALUES (154, 155);

INSERT INTO sys_api VALUES  (161,'','查询字典数据列表','/api/sys-dict-data','GET','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (162,'','查询字典数据详情','/api/sys-dict-data/:dictCode','GET','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (163,'','添加字典数据','/api/sys-dict-data','POST','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (164,'','修改字典数据','/api/sys-dict-data/:dictCode','PUT','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (165,'','删除字典数据','/api/sys-dict-data','DELETE','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);

INSERT INTO sys_menu_api VALUES (17, 161);
INSERT INTO sys_menu_api VALUES (17, 162);
INSERT INTO sys_menu_api VALUES (161, 161);
INSERT INTO sys_menu_api VALUES (161, 162);
INSERT INTO sys_menu_api VALUES (162, 163);
INSERT INTO sys_menu_api VALUES (163, 164);
INSERT INTO sys_menu_api VALUES (164, 165);

INSERT INTO sys_api VALUES  (171,'','查询接口列表','/api/sys-api','GET','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (172,'','查询接口详情','/api/sys-api/:id','GET','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (173,'','修改接口','/api/sys-api/:id','PUT','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);

INSERT INTO sys_menu_api VALUES (18, 171);
INSERT INTO sys_menu_api VALUES (18, 172);
INSERT INTO sys_menu_api VALUES (171, 171);
INSERT INTO sys_menu_api VALUES (171, 172);
INSERT INTO sys_menu_api VALUES (172, 173);

INSERT INTO sys_api VALUES  (181,'','查询配置参数列表','/api/sys-config','GET','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (182,'','查询配置参数详情','/api/sys-config/:id','GET','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (183,'','添加配置参数','/api/sys-config','POST','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (184,'','修改配置参数','/api/sys-config/:id','PUT','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (185,'','删除配置参数','/api/sys-config','DELETE','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);

INSERT INTO sys_menu_api VALUES (19, 181);
INSERT INTO sys_menu_api VALUES (19, 182);
INSERT INTO sys_menu_api VALUES (181, 181);
INSERT INTO sys_menu_api VALUES (181, 182);
INSERT INTO sys_menu_api VALUES (182, 183);
INSERT INTO sys_menu_api VALUES (183, 184);
INSERT INTO sys_menu_api VALUES (184, 185);

INSERT INTO sys_api VALUES  (191,'','查询登录日志列表','/api/sys-login-log','GET','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (192,'','查询登录日志详情','/api/sys-login-log/:id','GET','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (193,'','删除登录日志','/api/sys-login-log','DELETE','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);

INSERT INTO sys_menu_api VALUES (22, 191);
INSERT INTO sys_menu_api VALUES (22, 192);
INSERT INTO sys_menu_api VALUES (191, 191);
INSERT INTO sys_menu_api VALUES (191, 192);
INSERT INTO sys_menu_api VALUES (192, 193);


INSERT INTO sys_api VALUES  (196,'','查询操作日志列表','/api/sys-opera-log','GET','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (197,'','查询操作日志详情','/api/sys-opera-log/:id','GET','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (198,'','删除操作日志','/api/sys-opera-log','DELETE','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);

INSERT INTO sys_menu_api VALUES (23, 196);
INSERT INTO sys_menu_api VALUES (23, 197);
INSERT INTO sys_menu_api VALUES (196, 196);
INSERT INTO sys_menu_api VALUES (197, 197);
INSERT INTO sys_menu_api VALUES (198, 198);

INSERT INTO sys_api VALUES  (201,'','查询定时任务列表','/api/sys-job','GET','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (202,'','查询定时任务详情','/api/sys-job/:id','GET','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (203,'','添加定时任务','/api/sys-job','POST','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (204,'','修改定时任务','/api/sys-job/:id','PUT','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (205,'','删除定时任务','/api/sys-job','DELETE','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (206,'','查询系统内置任务KEYS','/api/sys-job/keys','GET','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (207,'','启动定时任务','/api/sys-job/start/:id','POST','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (208,'','停止定时任务','/api/sys-job/stop/:id','POST','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
-- INSERT INTO sys_api VALUES  (209,'','删除定时任务日志','/api/sys-job/log','DELETE','BUS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);

INSERT INTO sys_menu_api VALUES (31, 201);
INSERT INTO sys_menu_api VALUES (31, 202);
INSERT INTO sys_menu_api VALUES (201, 201);
INSERT INTO sys_menu_api VALUES (201, 202);
INSERT INTO sys_menu_api VALUES (202, 203);
INSERT INTO sys_menu_api VALUES (203, 204);
INSERT INTO sys_menu_api VALUES (204, 205);
INSERT INTO sys_menu_api VALUES (31, 206);
INSERT INTO sys_menu_api VALUES (201, 206);
INSERT INTO sys_menu_api VALUES (205, 207);
INSERT INTO sys_menu_api VALUES (206, 208);
-- INSERT INTO sys_menu_api VALUES (207, 209);

INSERT INTO sys_api VALUES  (211,'','查询表结构列表','/api/sys/gen-table','GET','SYS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (212,'','查询表结构详情','/api/sys/gen-table/:tableId','GET','SYS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (213,'','查询表结构详情（tableName）','/api/sys/gen-table/name','GET','SYS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (214,'','添加表结构','/api/sys/gen-table','POST','SYS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (215,'','修改表结构','/api/sys/gen-table','PUT','SYS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (216,'','删除表结构','/api/sys/gen-table/:tableId','DELETE','SYS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (217,'','查询数据库表列表','/api/sys/gen-db-tables','GET','SYS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (218,'','查询关系表下拉树','/api/sys/gen-db-table-tree','GET','SYS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (219,'','生成预览','/api/sys/gen-preview/:tableId','GET','SYS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (220,'','生成代码','/api/sys/gen-code/:tableId','GET','SYS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_api VALUES  (221,'','生成菜单及接口','/api/sys/gen-menu-api/:tableId','GET','SYS', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);


INSERT INTO sys_menu VALUES (207, 0, '设备信息维护', 'iot', 'pass', '/0/207', 'M', '', '', 'Layout', '', '', 0, 0, 0, 0, 1, 0, '2024-03-28 16:46:11.291', '2024-04-01 09:09:56.511', NULL);
INSERT INTO sys_menu VALUES (208, 207, '分组管理', 'group', 'app-indicator', '/0/207/208', 'C', '', 'iot:group', '/iot/group/index', '', '', 1, 0, 0, 0, 1, 1, '2024-03-28 16:46:11.764', '2024-04-01 09:09:56.511', NULL);
INSERT INTO sys_menu VALUES (209, 208, '查询分组', '#', 'eye', '/0/207/208/209', 'F', '', 'iot:group:query', '', '', '', 1, 0, 1, 0, 1, 1, '2024-03-28 16:46:11.984', '2024-04-01 09:09:56.511', NULL);
INSERT INTO sys_menu VALUES (210, 208, '新增分组', '#', 'plus-square', '/0/207/208/210', 'F', '', 'iot:group:add', '', 'btn btn-light-primary', 'handleCreate', 2, 0, 0, 0, 1, 1, '2024-03-28 16:46:12.296', '2024-04-01 09:09:56.511', NULL);
INSERT INTO sys_menu VALUES (211, 208, '修改分组', '#', 'pencil-square', '/0/207/208/211', 'F', '', 'iot:group:edit', '', 'btn btn-light-success', 'handleUpdate@1', 3, 0, 0, 0, 1, 1, '2024-03-28 16:46:12.593', '2024-04-01 09:09:56.511', NULL);
INSERT INTO sys_menu VALUES (212, 208, '删除分组', '#', 'dash-square', '/0/207/208/212', 'F', '', 'iot:group:remove', '', 'btn btn-light-danger', 'handleDelete@0', 4, 0, 0, 0, 1, 1, '2024-03-28 16:46:12.899', '2024-04-01 09:09:56.511', NULL);
INSERT INTO sys_menu VALUES (213, 207, '设备管理', 'device', 'app-indicator', '/0/207/213', 'C', '', 'iot:device', '/iot/device/index', '', '', 1, 0, 0, 0, 1, 1, '2024-03-28 16:46:17.681', '2024-04-01 09:09:56.511', NULL);
INSERT INTO sys_menu VALUES (214, 213, '查询设备网关', '#', 'eye', '/0/207/213/214', 'F', '', 'iot:device:query', '', '', '', 1, 0, 1, 0, 1, 1, '2024-03-28 16:46:17.904', '2024-04-01 09:09:56.511', NULL);
INSERT INTO sys_menu VALUES (215, 213, '新增网关', '#', 'plus-square', '/0/207/213/215', 'F', '', 'iot:device:add', '', 'btn btn-light-primary', 'handleCreate', 2, 0, 0, 0, 1, 1, '2024-03-28 16:46:18.297', '2024-04-01 09:09:56.511', NULL);
INSERT INTO sys_menu VALUES (216, 213, '修改网关', '#', 'pencil-square', '/0/207/213/216', 'F', '', 'iot:device:edit', '', 'btn btn-light-success', 'handleUpdate@1', 3, 0, 0, 0, 1, 1, '2024-03-28 16:46:18.713', '2024-04-01 09:09:56.511', NULL);
INSERT INTO sys_menu VALUES (217, 213, '删除网关', '#', 'dash-square', '/0/207/213/217', 'F', '', 'iot:device:remove', '', 'btn btn-light-danger', 'handleDelete@0', 4, 0, 0, 0, 1, 1, '2024-03-28 16:46:19.055', '2024-04-01 09:09:56.511', NULL);
INSERT INTO sys_menu VALUES (218, 213, '重新加载', '#', 'arrow-repeat', '/0/207/213/218', 'F', '', 'iot:device:refresh', '', 'btn btn-light-info', 'handleRefresh', 5, 0, 0, 0, 1, 1, '2024-03-28 16:46:19.055', '2024-04-01 09:09:56.511', NULL);

INSERT INTO sys_api VALUES (222, 'IotAdmin/app/iot/apis.(*IotGroupApi).GetPage-fm', '获取分组列表', '/api/iot-group', 'GET', 'BUS', 0, 0, '2024-03-28 16:46:11.552', '2024-04-01 09:09:56.520', NULL);
INSERT INTO sys_api VALUES (223, 'IotAdmin/app/iot/apis.(*IotGroupApi).Get-fm', '获取分组详情', '/api/iot-group/:id', 'GET', 'BUS', 0, 0, '2024-03-28 16:46:11.671', '2024-04-01 09:09:56.520', NULL);
INSERT INTO sys_api VALUES (224, 'IotAdmin/app/iot/apis.(*IotGroupApi).Insert-fm', '添加分组', '/api/iot-group', 'POST', 'BUS', 0, 0, '2024-03-28 16:46:12.207', '2024-04-01 09:09:56.520', NULL);
INSERT INTO sys_api VALUES (225, 'IotAdmin/app/iot/apis.(*IotGroupApi).Update-fm', '修改分组', '/api/iot-group/:id', 'PUT', 'BUS', 0, 0, '2024-03-28 16:46:12.497', '2024-04-01 09:09:56.520', NULL);
INSERT INTO sys_api VALUES (226, 'IotAdmin/app/iot/apis.(*IotGroupApi).Delete-fm', '删除分组', '/api/iot-group', 'DELETE', 'BUS', 0, 0, '2024-03-28 16:46:12.805', '2024-04-01 09:09:56.520', NULL);
INSERT INTO sys_api VALUES (227, 'IotAdmin/app/iot/apis.(*IotDeviceApi).GetPage-fm', '获取设备列表', '/api/iot-device', 'GET', 'BUS', 0, 0, '2024-03-28 16:46:17.477', '2024-04-01 09:09:56.520', NULL);
INSERT INTO sys_api VALUES (228, 'IotAdmin/app/iot/apis.(*IotDeviceApi).Get-fm', '获取设备详情', '/api/iot-device/:id', 'GET', 'BUS', 0, 0, '2024-03-28 16:46:17.570', '2024-04-01 09:09:56.520', NULL);
INSERT INTO sys_api VALUES (229, 'IotAdmin/app/iot/apis.(*IotDeviceApi).Insert-fm', '添加设备', '/api/iot-device', 'POST', 'BUS', 0, 0, '2024-03-28 16:46:18.204', '2024-04-01 09:09:56.520', NULL);
INSERT INTO sys_api VALUES (230, 'IotAdmin/app/iot/apis.(*IotDeviceApi).Update-fm', '修改设备', '/api/iot-device/:id', 'PUT', 'BUS', 0, 0, '2024-03-28 16:46:18.606', '2024-04-01 09:09:56.520', NULL);
INSERT INTO sys_api VALUES (231, 'IotAdmin/app/iot/apis.(*IotDeviceApi).Delete-fm', '删除设备', '/api/iot-device', 'DELETE', 'BUS', 0, 0, '2024-03-28 16:46:18.950', '2024-04-01 09:09:56.520', NULL);
INSERT INTO sys_api VALUES (232, 'IotAdmin/app/iot/apis.(*IotDeviceApi).Refresh-fm', '重新加载设备', '/api/iot-device/refresh', 'POST', 'BUS', 0, 0, '2024-03-28 16:46:18.950', '2024-04-01 09:09:56.520', NULL);
INSERT INTO sys_api VALUES (233, 'IotAdmin/app/iot/apis.(*IotDeviceApi).GetDeviceProtocols-fm', '获取表计协议列表', '/api/iot-device/device-protocol', 'GET', 'BUS', 0, 0, '2024-03-28 16:46:18.950', '2024-04-01 09:09:56.520', NULL);
INSERT INTO sys_api VALUES (234, 'IotAdmin/app/iot/apis.(*IotDeviceApi).GetReportProtocols-fm', '获取上报协议列表', '/api/iot-device/report-protocol', 'GET', 'BUS', 0, 0, '2024-03-28 16:46:18.950', '2024-04-01 09:09:56.520', NULL);

INSERT INTO sys_menu_api VALUES (208, 222);
INSERT INTO sys_menu_api VALUES (209, 222);
INSERT INTO sys_menu_api VALUES (208, 223);
INSERT INTO sys_menu_api VALUES (209, 223);
INSERT INTO sys_menu_api VALUES (210, 224);
INSERT INTO sys_menu_api VALUES (211, 225);
INSERT INTO sys_menu_api VALUES (212, 226);
INSERT INTO sys_menu_api VALUES (213, 227);
INSERT INTO sys_menu_api VALUES (214, 227);
INSERT INTO sys_menu_api VALUES (213, 228);
INSERT INTO sys_menu_api VALUES (214, 228);
INSERT INTO sys_menu_api VALUES (215, 229);
INSERT INTO sys_menu_api VALUES (216, 230);
INSERT INTO sys_menu_api VALUES (217, 231);
INSERT INTO sys_menu_api VALUES (218, 232);
INSERT INTO sys_menu_api VALUES (213, 233);
INSERT INTO sys_menu_api VALUES (214, 233);
INSERT INTO sys_menu_api VALUES (213, 234);
INSERT INTO sys_menu_api VALUES (214, 234);










INSERT INTO sys_config VALUES (1, '初始密码', 'sys_user_initPassword', '123456', 'Y', '0', '用户管理-账号初始密码:[REDACTED] 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_config VALUES (2, '系统名称', 'sys_app_name', 'go-admin管理系统', 'Y', '1', '', 1, 0, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);



INSERT INTO sys_dict_type VALUES (1, '系统开关', 'sys_normal_disable', '2', '系统开关列表', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_dict_data VALUES (1, 0, '正常', '2', 'sys_normal_disable', '', 'primary', '', '2', '', '系统正常', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_dict_data VALUES (2, 0, '停用', '1', 'sys_normal_disable', '', 'danger', '', '2', '', '系统停用', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);

INSERT INTO sys_dict_type VALUES (2, '用户性别', 'sys_user_sex', '2', '用户性别列表', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_dict_data VALUES (3, 0, '男', '0', 'sys_user_sex', '', 'primary', '', '2', '', '性别男', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_dict_data VALUES (4, 0, '女', '1', 'sys_user_sex', '', 'danger', '', '2', '', '性别女', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_dict_data VALUES (5, 0, '未知', '2', 'sys_user_sex', '', 'warning', '', '2', '', '性别未知', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);

INSERT INTO sys_dict_type VALUES (3, '菜单状态', 'sys_show_hide', '2', '菜单状态列表', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_dict_data VALUES (6, 0, '显示', '0', 'sys_show_hide', '', 'primary', '', '2', '', '显示菜单', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_dict_data VALUES (7, 0, '隐藏', '1', 'sys_show_hide', '', 'danger', '', '2', '', '隐藏菜单', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);

INSERT INTO sys_dict_type VALUES (4, '系统是否', 'sys_yes_no', '2', '系统是否列表', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_dict_data VALUES (8, 0, '是', 'Y', 'sys_yes_no', '', 'primary', '', '2', '', '系统默认是', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_dict_data VALUES (9, 0, '否', 'N', 'sys_yes_no', '', 'danger', '', '2', '', '系统默认否', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);

INSERT INTO sys_dict_type VALUES (5, '任务状态', 'sys_job_status', '2', '任务状态列表', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_dict_data VALUES (10, 0, '启用', '2', 'sys_job_status', '', 'primary', '', '2', '', '正常状态', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_dict_data VALUES (11, 0, '停用', '1', 'sys_job_status', '', 'danger', '', '2', '', '停用状态', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);

INSERT INTO sys_dict_type VALUES (6, '任务分组', 'sys_job_group', '2', '任务分组列表', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_dict_data VALUES (12, 0, '默认', 'DEFAULT', 'sys_job_group', '', 'primary', '', '2', '', '默认分组', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_dict_data VALUES (13, 0, '系统', 'SYSTEM', 'sys_job_group', '', 'success', '', '2', '', '系统分组', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);

INSERT INTO sys_dict_type VALUES (7, '通知类型', 'sys_notice_type', '2', '通知类型列表', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_dict_data VALUES (14, 0, '通知', '1', 'sys_notice_type', '', 'primary', '', '2', '', '通知', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_dict_data VALUES (15, 0, '公告', '2', 'sys_notice_type', '', 'success', '', '2', '', '公告', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);

INSERT INTO sys_dict_type VALUES (8, '系统状态', 'sys_common_status', '2', '登录状态列表', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_dict_data VALUES (16, 0, '正常', '2', 'sys_common_status', '', 'primary', '', '2', '', '正常状态', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_dict_data VALUES (17, 0, '异常', '1', 'sys_common_status', '', 'danger', '', '2', '', '异常状态', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);

INSERT INTO sys_dict_type VALUES (9, '通知状态', 'sys_notice_status', '2', '通知状态列表', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_dict_data VALUES (18, 0, '成功', '0', 'sys_notice_status', '', 'primary', '', '2', '', '成功状态', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_dict_data VALUES (19, 0, '失败', '1', 'sys_notice_status', '', 'danger', '', '2', '', '失败状态', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);

INSERT INTO sys_dict_type VALUES (10, '内容状态', 'sys_content_status', '2', '内容状态列表', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_dict_data VALUES (20, 0, '正常', '1', 'sys_content_status', '', 'primary', '', '1', '', '', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_dict_data VALUES (21, 1, '禁用', '2', 'sys_content_status', '', 'danger', '', '1', '', '', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);

INSERT INTO sys_dict_type VALUES (15, '操作类型', 'sys_oper_type', '2', '操作类型列表', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_dict_data VALUES (31, 0, '新增', '1', 'sys_oper_type', '', 'primary', '', '2', '', '新增操作', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_dict_data VALUES (32, 0, '修改', '2', 'sys_oper_type', '', 'success', '', '2', '', '修改操作', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_dict_data VALUES (33, 0, '删除', '3', 'sys_oper_type', '', 'danger', '', '2', '', '删除操作', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_dict_data VALUES (34, 0, '导出', '4', 'sys_oper_type', '', 'primary', '', '2', '', '导出操作', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_dict_data VALUES (35, 0, '导入', '5', 'sys_oper_type', '', 'primary', '', '2', '', '导入操作', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_dict_data VALUES (36, 0, '登录', '6', 'sys_oper_type', '', 'success', '', '2', '', '强退操作', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_dict_data VALUES (37, 0, '退出', '7', 'sys_oper_type', '', 'danger', '', '2', '', '清空操作', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_dict_data VALUES (38, 0, '授权', '8', 'sys_oper_type', '', 'warning', '', '2', '', '授权操作', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_dict_data VALUES (39, 0, '启动', '9', 'sys_oper_type', '', 'success', '', '2', '', '登录操作', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_dict_data VALUES (40, 0, '停止', '10', 'sys_oper_type', '', 'danger', '', '2', '', '', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_dict_data VALUES (41, 0, '生成代码', '11', 'sys_oper_type', '', 'primary', '', '2', '', '生成操作', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_dict_data VALUES (42, 0, '清空数据', '12', 'sys_oper_type', '', 'primary', '', '2', '', '获取验证码', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_dict_data VALUES (43, 0, '刷新数据', '13', 'sys_oper_type', '', 'primary', '', '2', '', '获取验证码', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);

INSERT INTO sys_dict_type VALUES (20, '设备类型', 'iot_device_type', '2', '', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_dict_data VALUES (51, 1, '网关', '1', 'iot_device_type', '', 'primary', '', '2', '', '新增操作', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_dict_data VALUES (52, 2, '表计', '2', 'iot_device_type', '', 'success', '', '2', '', '修改操作', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);

INSERT INTO sys_dict_type VALUES (21, '设备模式', 'iot_device_mode', '2', '', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_dict_data VALUES (53, 1, '下发指令查询', '1', 'iot_device_mode', '', 'primary', '', '2', '', '新增操作', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_dict_data VALUES (54, 2, '表计主动上报', '2', 'iot_device_mode', '', 'success', '', '2', '', '修改操作', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);

INSERT INTO sys_dict_type VALUES (20, '设备类型', 'iot_device_type', 2, '', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_dict_data VALUES (51, 1, '网关', '1', 'iot_device_type', '', 'primary', '', 2, '', '新增操作', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_dict_data VALUES (52, 2, '表计', '2', 'iot_device_type', '', 'success', '', 2, '', '修改操作', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);

INSERT INTO sys_dict_type VALUES (21, '设备模式', 'iot_device_mode', 2, '', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_dict_data VALUES (53, 1, '下发指令查询', '1', 'iot_device_mode', '', 'primary', '', 2, '', '新增操作', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_dict_data VALUES (54, 2, '表计主动上报', '2', 'iot_device_mode', '', 'success', '', 2, '', '修改操作', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);



INSERT INTO sys_job VALUES (1, '接口测试', 'SYSTEM', 1, '0/5 * * * * ', 'http://localhost:6071', '', 1, 1, 1, 0, 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_job VALUES (2, '函数测试', 'SYSTEM', 2, '0/5 * * * * ', 'ExamplesOne', '参数', 1, 1, 1, 0, 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);


INSERT INTO sys_post VALUES (1, '默认岗位', 'CEO', 0, '2','默认岗位', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
# INSERT INTO sys_post VALUES (2, '首席技术执行官', 'CTO', 2, '2','首席技术执行官', 1, 1,'2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
# INSERT INTO sys_post VALUES (3, '首席运营官', 'COO', 3, '2','测试工程师', 1, 1,'2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);

INSERT INTO sys_org VALUES (1, 0, '/0/1/', '物联网设备管理平台', 0, 'aituo', '13782218188', 'atuo@aituo.com', '2', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_org VALUES (2, 1, '/0/1/2/', '中科轼峰设备管理平台', 1, 'aituo', '13782218188', 'atuo@aituo.com', '2', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_org VALUES (3, 1, '/0/2/3/', '测试平台', 2, 'aituo', '13782218188', 'atuo@aituo.com', '2', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_org VALUES (4, 1, '/0/1/4/', '测试平台2', 3, 'aituo', '13782218188', 'atuo@aituo.com', '2', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_org VALUES (5, 1, '/0/1/5/', '测试平台3', 4, 'aituo', '13782218188', 'atuo@aituo.com', '1', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);

INSERT INTO sys_role VALUES (1, '超级管理员', '2', 'admin', 1, 'static', '超级管理员，不可删除修改', true, '1', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_role VALUES (2, '默认角色', '2', 'default', 2, 'static', '默认角色，不可删除修改', true, '4', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);

INSERT INTO sys_user VALUES (1, 'admin', '$2a$10$/Glr4g9Svr6O0kvjsRJCXu3f0W8/dsP3XZyVNi1019ratWpSPMyw.', 'IOT', '13818888888', 1, '', '', '1', 'admin@iot.com', 1, 1, '', '2', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_user VALUES (2, 'system', '$2a$10$os4vpm2eSBYOs2OWgaLqo.R3Ct13aUDk284fxuPDKeB2MqDlUekQa', 'SYSTEM', '13828888888', 1, '', '', '1', 'system@iot.com', 1, 1, '', '2', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
INSERT INTO sys_user VALUES (3, 'demo', '$2a$10$bKjnUdtWH1YosQxJu7TiMu606JFjuGrpwi/y0MY3TsnB5Zo9GYhkq', 'DEMO', '13838888888', 2, '', '', '1', 'demo@iot.com', 2,2, '', '2', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
-- 数据完成 ;