Página inicial Explorar Ajuda
Registrar Entrar
VBDSM
/
IOT
2
0
Fork 0
Arquivos Issues 0 Pull Requests 0 Wiki
Tree: 7be66e512c
Branches Tags
IOT
/
SERVER
/
IotAdmin
/
config
/
sql
/
db.sql

db.sql 46 KB
Histórico Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400 
  1. -- 开始初始化数据 ;
    2. 

  2. 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);
    3. 

  3. 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);
    4. 

  4. 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);
    5. 

  5. 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);
    6. 

  6. 

  7. 

  8. 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);
    9. 

  9. 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);
    10. 

  10. 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);
    11. 

  11. 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);
    12. 

  12. 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);
    13. 

  13. 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);
    14. 

  14. 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);
    15. 

  15. 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);
    16. 

  16. 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);
    17. 

  17. 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);
    18. 

  18. 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);
    19. 

  19. 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);
    20. 

  20. 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);
    21. 

  21. 

  22. 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);
    23. 

  23. 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);
    24. 

  24. 

  25. 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);
    26. 

  26. 

  27. 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);
    28. 

  28. 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);
    29. 

  29. 

  30. 

  31. 

  32. 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);
    33. 

  33. 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);
    34. 

  34. 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);
    35. 

  35. 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);
    36. 

  36. 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);
    37. 

  37. 

  38. 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);
    39. 

  39. 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);
    40. 

  40. 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);
    41. 

  41. 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);
    42. 

  42. 

  43. 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);
    44. 

  44. 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);
    45. 

  45. 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);
    46. 

  46. 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);
    47. 

  47. 

  48. 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);
    49. 

  49. 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);
    50. 

  50. 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);
    51. 

  51. 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);
    52. 

  52. 

  53. 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);
    54. 

  54. 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);
    55. 

  55. 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);
    56. 

  56. 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);
    57. 

  57. 

  58. 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);
    59. 

  59. 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);
    60. 

  60. 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);
    61. 

  61. 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);
    62. 

  62. 

  63. 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);
    64. 

  64. 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);
    65. 

  65. 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);
    66. 

  66. 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);
    67. 

  67. 

  68. 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);
    69. 

  69. 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);
    70. 

  70. 

  71. 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);
    72. 

  72. 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);
    73. 

  73. 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);
    74. 

  74. 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);
    75. 

  75. 

  76. 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);
    77. 

  77. 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);
    78. 

  78. 

  79. 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);
    80. 

  80. 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);
    81. 

  81. 

  82. 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);
    83. 

  83. 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);
    84. 

  84. 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);
    85. 

  85. 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);
    86. 

  86. 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);
    87. 

  87. 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);
    88. 

  88. -- 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);
    89. 

  89. 

  90. 

  91. 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);
    92. 

  92. 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);
    93. 

  93. 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);
    94. 

  94. 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);
    95. 

  95. 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);
    96. 

  96. 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);
    97. 

  97. 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);
    98. 

  98. 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);
    99. 

  99. 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);
    100. 

  100. 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);
    101. 

  101. 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);
    102. 

  102. 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);
    103. 

  103. 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);
    104. 

  104. 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);
    105. 

  105. 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);
    106. 

  106. 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);
    107. 

  107. 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);
    108. 

  108. 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);
    109. 

  109. 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);
    110. 

  110. 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);
    111. 

  111. 

  112. 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);
    113. 

  113. 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);
    114. 

  114. 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);
    115. 

  115. 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);
    116. 

  116. 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);
    117. 

  117. 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);
    118. 

  118. 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);
    119. 

  119. 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);
    120. 

  120. 

  121. INSERT INTO sys_menu_api VALUES (11, 101);
    122. 

  122. INSERT INTO sys_menu_api VALUES (11, 102);
    123. 

  123. INSERT INTO sys_menu_api VALUES (101, 101);
    124. 

  124. INSERT INTO sys_menu_api VALUES (101, 102);
    125. 

  125. INSERT INTO sys_menu_api VALUES (102, 103);
    126. 

  126. INSERT INTO sys_menu_api VALUES (103, 104);
    127. 

  127. INSERT INTO sys_menu_api VALUES (104, 105);
    128. 

  128. INSERT INTO sys_menu_api VALUES (103, 106);
    129. 

  129. INSERT INTO sys_menu_api VALUES (103, 107);
    130. 

  130. INSERT INTO sys_menu_api VALUES (11, 108);
    131. 

  131. INSERT INTO sys_menu_api VALUES (101, 108);
    132. 

  132. 

  133. 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);
    134. 

  134. 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);
    135. 

  135. 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);
    136. 

  136. 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);
    137. 

  137. 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);
    138. 

  138. 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);
    139. 

  139. 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);
    140. 

  140. 

  141. INSERT INTO sys_menu_api VALUES (12, 111);
    142. 

  142. INSERT INTO sys_menu_api VALUES (12, 112);
    143. 

  143. INSERT INTO sys_menu_api VALUES (111, 111);
    144. 

  144. INSERT INTO sys_menu_api VALUES (111, 112);
    145. 

  145. INSERT INTO sys_menu_api VALUES (112, 113);
    146. 

  146. INSERT INTO sys_menu_api VALUES (113, 114);
    147. 

  147. INSERT INTO sys_menu_api VALUES (114, 115);
    148. 

  148. INSERT INTO sys_menu_api VALUES (113, 116);
    149. 

  149. INSERT INTO sys_menu_api VALUES (113, 117);
    150. 

  150. 

  151. 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);
    152. 

  152. 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);
    153. 

  153. 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);
    154. 

  154. 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);
    155. 

  155. 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);
    156. 

  156. 

  157. INSERT INTO sys_menu_api VALUES (13, 121);
    158. 

  158. INSERT INTO sys_menu_api VALUES (13, 122);
    159. 

  159. INSERT INTO sys_menu_api VALUES (121, 121);
    160. 

  160. INSERT INTO sys_menu_api VALUES (121, 122);
    161. 

  161. INSERT INTO sys_menu_api VALUES (122, 123);
    162. 

  162. INSERT INTO sys_menu_api VALUES (123, 124);
    163. 

  163. INSERT INTO sys_menu_api VALUES (124, 125);
    164. 

  164. 

  165. 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);
    166. 

  166. 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);
    167. 

  167. 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);
    168. 

  168. 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);
    169. 

  169. 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);
    170. 

  170. 

  171. INSERT INTO sys_menu_api VALUES (14, 131);
    172. 

  172. INSERT INTO sys_menu_api VALUES (14, 132);
    173. 

  173. INSERT INTO sys_menu_api VALUES (131, 131);
    174. 

  174. INSERT INTO sys_menu_api VALUES (131, 132);
    175. 

  175. INSERT INTO sys_menu_api VALUES (132, 133);
    176. 

  176. INSERT INTO sys_menu_api VALUES (133, 134);
    177. 

  177. INSERT INTO sys_menu_api VALUES (134, 135);
    178. 

  178. 

  179. 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);
    180. 

  180. 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);
    181. 

  181. 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);
    182. 

  182. 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);
    183. 

  183. 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);
    184. 

  184. 

  185. INSERT INTO sys_menu_api VALUES (15, 141);
    186. 

  186. INSERT INTO sys_menu_api VALUES (15, 142);
    187. 

  187. INSERT INTO sys_menu_api VALUES (141, 141);
    188. 

  188. INSERT INTO sys_menu_api VALUES (141, 142);
    189. 

  189. INSERT INTO sys_menu_api VALUES (142, 143);
    190. 

  190. INSERT INTO sys_menu_api VALUES (143, 144);
    191. 

  191. INSERT INTO sys_menu_api VALUES (144, 145);
    192. 

  192. 

  193. 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);
    194. 

  194. 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);
    195. 

  195. 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);
    196. 

  196. 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);
    197. 

  197. 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);
    198. 

  198. 

  199. INSERT INTO sys_menu_api VALUES (16, 151);
    200. 

  200. INSERT INTO sys_menu_api VALUES (16, 152);
    201. 

  201. INSERT INTO sys_menu_api VALUES (151, 151);
    202. 

  202. INSERT INTO sys_menu_api VALUES (151, 152);
    203. 

  203. INSERT INTO sys_menu_api VALUES (152, 153);
    204. 

  204. INSERT INTO sys_menu_api VALUES (153, 154);
    205. 

  205. INSERT INTO sys_menu_api VALUES (154, 155);
    206. 

  206. 

  207. 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);
    208. 

  208. 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);
    209. 

  209. 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);
    210. 

  210. 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);
    211. 

  211. 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);
    212. 

  212. 

  213. INSERT INTO sys_menu_api VALUES (17, 161);
    214. 

  214. INSERT INTO sys_menu_api VALUES (17, 162);
    215. 

  215. INSERT INTO sys_menu_api VALUES (161, 161);
    216. 

  216. INSERT INTO sys_menu_api VALUES (161, 162);
    217. 

  217. INSERT INTO sys_menu_api VALUES (162, 163);
    218. 

  218. INSERT INTO sys_menu_api VALUES (163, 164);
    219. 

  219. INSERT INTO sys_menu_api VALUES (164, 165);
    220. 

  220. 

  221. 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);
    222. 

  222. 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);
    223. 

  223. 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);
    224. 

  224. 

  225. INSERT INTO sys_menu_api VALUES (18, 171);
    226. 

  226. INSERT INTO sys_menu_api VALUES (18, 172);
    227. 

  227. INSERT INTO sys_menu_api VALUES (171, 171);
    228. 

  228. INSERT INTO sys_menu_api VALUES (171, 172);
    229. 

  229. INSERT INTO sys_menu_api VALUES (172, 173);
    230. 

  230. 

  231. 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);
    232. 

  232. 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);
    233. 

  233. 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);
    234. 

  234. 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);
    235. 

  235. 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);
    236. 

  236. 

  237. INSERT INTO sys_menu_api VALUES (19, 181);
    238. 

  238. INSERT INTO sys_menu_api VALUES (19, 182);
    239. 

  239. INSERT INTO sys_menu_api VALUES (181, 181);
    240. 

  240. INSERT INTO sys_menu_api VALUES (181, 182);
    241. 

  241. INSERT INTO sys_menu_api VALUES (182, 183);
    242. 

  242. INSERT INTO sys_menu_api VALUES (183, 184);
    243. 

  243. INSERT INTO sys_menu_api VALUES (184, 185);
    244. 

  244. 

  245. 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);
    246. 

  246. 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);
    247. 

  247. 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);
    248. 

  248. 

  249. INSERT INTO sys_menu_api VALUES (22, 191);
    250. 

  250. INSERT INTO sys_menu_api VALUES (22, 192);
    251. 

  251. INSERT INTO sys_menu_api VALUES (191, 191);
    252. 

  252. INSERT INTO sys_menu_api VALUES (191, 192);
    253. 

  253. INSERT INTO sys_menu_api VALUES (192, 193);
    254. 

  254. 

  255. 

  256. 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);
    257. 

  257. 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);
    258. 

  258. 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);
    259. 

  259. 

  260. INSERT INTO sys_menu_api VALUES (23, 196);
    261. 

  261. INSERT INTO sys_menu_api VALUES (23, 197);
    262. 

  262. INSERT INTO sys_menu_api VALUES (196, 196);
    263. 

  263. INSERT INTO sys_menu_api VALUES (197, 197);
    264. 

  264. INSERT INTO sys_menu_api VALUES (198, 198);
    265. 

  265. 

  266. 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);
    267. 

  267. 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);
    268. 

  268. 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);
    269. 

  269. 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);
    270. 

  270. 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);
    271. 

  271. 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);
    272. 

  272. 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);
    273. 

  273. 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);
    274. 

  274. -- 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);
    275. 

  275. 

  276. INSERT INTO sys_menu_api VALUES (31, 201);
    277. 

  277. INSERT INTO sys_menu_api VALUES (31, 202);
    278. 

  278. INSERT INTO sys_menu_api VALUES (201, 201);
    279. 

  279. INSERT INTO sys_menu_api VALUES (201, 202);
    280. 

  280. INSERT INTO sys_menu_api VALUES (202, 203);
    281. 

  281. INSERT INTO sys_menu_api VALUES (203, 204);
    282. 

  282. INSERT INTO sys_menu_api VALUES (204, 205);
    283. 

  283. INSERT INTO sys_menu_api VALUES (31, 206);
    284. 

  284. INSERT INTO sys_menu_api VALUES (201, 206);
    285. 

  285. INSERT INTO sys_menu_api VALUES (205, 207);
    286. 

  286. INSERT INTO sys_menu_api VALUES (206, 208);
    287. 

  287. -- INSERT INTO sys_menu_api VALUES (207, 209);
    288. 

  288. 

  289. 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);
    290. 

  290. 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);
    291. 

  291. 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);
    292. 

  292. 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);
    293. 

  293. 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);
    294. 

  294. 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);
    295. 

  295. 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);
    296. 

  296. 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);
    297. 

  297. 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);
    298. 

  298. 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);
    299. 

  299. 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);
    300. 

  300. 

  301. 

  302. 

  303. 

  304. 

  305. 

  306. 

  307. 

  308. 

  309. 

  310. 

  311. INSERT INTO sys_config VALUES (1, '初始密码', 'sys_user_initPassword', '123456', 'Y', '0', '用户管理-账号初始密码:123456', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
    312. 

  312. 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);
    313. 

  313. 

  314. 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);
    315. 

  315. 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);
    316. 

  316. INSERT INTO sys_org VALUES (3, 1, '/0/1/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);
    317. 

  317. INSERT INTO sys_org VALUES (4, 1, '/0/1/4/', '客服部', 3, 'aituo', '13782218188', 'atuo@aituo.com', '2', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
    318. 

  318. INSERT INTO sys_org VALUES (5, 1, '/0/1/5/', '人力资源', 4, 'aituo', '13782218188', 'atuo@aituo.com', '1', 1, 1, '2024-03-14 00:00:00.000', '2024-03-14 00:00:00.000', NULL);
    319. 

  319. 

  320. 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);
    321. 

  321. 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);
    322. 

  322. 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);
    323. 

  323. 

  324. 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);
    325. 

  325. 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);
    326. 

  326. 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);
    327. 

  327. 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);
    328. 

  328. 

  329. 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);
    330. 

  330. 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);
    331. 

  331. 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);
    332. 

  332. 

  333. 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);
    334. 

  334. 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);
    335. 

  335. 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);
    336. 

  336. 

  337. 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);
    338. 

  338. 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);
    339. 

  339. 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);
    340. 

  340. 

  341. 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);
    342. 

  342. 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);
    343. 

  343. 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);
    344. 

  344. 

  345. 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);
    346. 

  346. 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);
    347. 

  347. 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);
    348. 

  348. 

  349. 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);
    350. 

  350. 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);
    351. 

  351. 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);
    352. 

  352. 

  353. 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);
    354. 

  354. 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);
    355. 

  355. 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);
    356. 

  356. 

  357. 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);
    358. 

  358. 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);
    359. 

  359. 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);
    360. 

  360. 

  361. 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);
    362. 

  362. 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);
    363. 

  363. 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);
    364. 

  364. 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);
    365. 

  365. 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);
    366. 

  366. 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);
    367. 

  367. 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);
    368. 

  368. 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);
    369. 

  369. 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);
    370. 

  370. 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);
    371. 

  371. 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);
    372. 

  372. 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);
    373. 

  373. 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);
    374. 

  374. 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);
    375. 

  375. 

  376. 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);
    377. 

  377. 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);
    378. 

  378. 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);
    379. 

  379. 

  380. 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);
    381. 

  381. 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);
    382. 

  382. 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);
    383. 

  383. 

  384. 

  385. 

  386. 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);
    387. 

  387. 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);
    388. 

  388. 

  389. 

  390. 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);
    391. 

  391. 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);
    392. 

  392. 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);
    393. 

  393. 

  394. 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);
    395. 

  395. 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);
    396. 

  396. 

  397. 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);
    398. 

  398. 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);
    399. 

  399. 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);
    400. 

  400. -- 数据完成 ;
    401.