Acasă Explorează Ajutor
Înregistrare Autentificare
GIN
/
simple-template
1
0
Bifurcare 0
Fisiere Probleme 0 Trageți solicitările 0 Wiki
Ramură: main
Ramuri Etichete
simple-template
/
backend
/
sql
/
agileboot-20230814.sql

agileboot-20230814.sql 49 KB
Permalink Istoric Crud

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362 
  1. create table sys_config
    2. 

  2. (
    3. 

  3.     config_id       int auto_increment comment '参数主键'
    4. 

  4.         primary key,
    5. 

  5.     config_name     varchar(128)  default '' not null comment '配置名称',
    6. 

  6.     config_key      varchar(128)  default '' not null comment '配置键名',
    7. 

  7.     config_options  varchar(1024) default '' not null comment '可选的选项',
    8. 

  8.     config_value    varchar(256)  default '' not null comment '配置值',
    9. 

  9.     is_allow_change tinyint(1)               not null comment '是否允许修改',
    10. 

  10.     creator_id      bigint                   null comment '创建者ID',
    11. 

  11.     updater_id      bigint                   null comment '更新者ID',
    12. 

  12.     update_time     datetime                 null comment '更新时间',
    13. 

  13.     create_time     datetime                 null comment '创建时间',
    14. 

  14.     remark          varchar(128)             null comment '备注',
    15. 

  15.     deleted         tinyint(1)    default 0  not null comment '逻辑删除',
    16. 

  16.     constraint config_key_uniq_idx
    17. 

  17.         unique (config_key)
    18. 

  18. )
    19. 

  19.     comment '参数配置表';
    20. 

  20. 

  21. INSERT INTO  sys_config (config_id, config_name, config_key, config_options, config_value, is_allow_change, creator_id, updater_id, update_time, create_time, remark, deleted) VALUES (1, '主框架页-默认皮肤样式名称', 'sys.index.skinName', '["skin-blue","skin-green","skin-purple","skin-red","skin-yellow"]', 'skin-blue', 1, null, null, '2022-08-28 22:12:19', '2022-05-21 08:30:55', '蓝色 skin-blue、绿色 skin-green、紫色 skin-purple、红色 skin-red、黄色 skin-yellow', 0);
    22. 

  22. INSERT INTO  sys_config (config_id, config_name, config_key, config_options, config_value, is_allow_change, creator_id, updater_id, update_time, create_time, remark, deleted) VALUES (2, '用户管理-账号初始密码', 'sys.user.initPassword', '', '123456', 1, null, 1, '2023-07-20 14:42:08', '2022-05-21 08:30:55', '初始化密码 123456', 0);
    23. 

  23. INSERT INTO  sys_config (config_id, config_name, config_key, config_options, config_value, is_allow_change, creator_id, updater_id, update_time, create_time, remark, deleted) VALUES (3, '主框架页-侧边栏主题', 'sys.index.sideTheme', '["theme-dark","theme-light"]', 'theme-dark', 1, null, null, '2022-08-28 22:12:15', '2022-08-20 08:30:55', '深色主题theme-dark，浅色主题theme-light', 0);
    24. 

  24. INSERT INTO  sys_config (config_id, config_name, config_key, config_options, config_value, is_allow_change, creator_id, updater_id, update_time, create_time, remark, deleted) VALUES (4, '账号自助-验证码开关', 'sys.account.captchaOnOff', '["true","false"]', 'false', 0, null, 1, '2023-07-20 14:39:36', '2022-05-21 08:30:55', '是否开启验证码功能（true开启，false关闭）', 0);
    25. 

  25. INSERT INTO  sys_config (config_id, config_name, config_key, config_options, config_value, is_allow_change, creator_id, updater_id, update_time, create_time, remark, deleted) VALUES (5, '账号自助-是否开启用户注册功能', 'sys.account.registerUser', '["true","false"]', 'true', 0, null, 1, '2022-10-05 22:18:57', '2022-05-21 08:30:55', '是否开启注册用户功能（true开启，false关闭）', 0);
    26. 

  26. 

  27. create table sys_dept
    28. 

  28. (
    29. 

  29.     dept_id     bigint auto_increment comment '部门id'
    30. 

  30.         primary key,
    31. 

  31.     parent_id   bigint      default 0  not null comment '父部门id',
    32. 

  32.     ancestors   text                   not null comment '祖级列表',
    33. 

  33.     dept_name   varchar(64) default '' not null comment '部门名称',
    34. 

  34.     order_num   int         default 0  not null comment '显示顺序',
    35. 

  35.     leader_id   bigint                 null,
    36. 

  36.     leader_name varchar(64)            null comment '负责人',
    37. 

  37.     phone       varchar(16)            null comment '联系电话',
    38. 

  38.     email       varchar(128)           null comment '邮箱',
    39. 

  39.     status      smallint    default 0  not null comment '部门状态（0停用 1启用）',
    40. 

  40.     creator_id  bigint                 null comment '创建者ID',
    41. 

  41.     create_time datetime               null comment '创建时间',
    42. 

  42.     updater_id  bigint                 null comment '更新者ID',
    43. 

  43.     update_time datetime               null comment '更新时间',
    44. 

  44.     deleted     tinyint(1)  default 0  not null comment '逻辑删除'
    45. 

  45. )
    46. 

  46.     comment '部门表';
    47. 

  47. 

  48. INSERT INTO  sys_dept (dept_id, parent_id, ancestors, dept_name, order_num, leader_id, leader_name, phone, email, status, creator_id, create_time, updater_id, update_time, deleted) VALUES (1, 0, '0', 'AgileBoot科技', 0, null, 'valarchie', '15888888888', 'valarchie@163.com', 1, null, '2022-05-21 08:30:54', null, null, 0);
    49. 

  49. INSERT INTO  sys_dept (dept_id, parent_id, ancestors, dept_name, order_num, leader_id, leader_name, phone, email, status, creator_id, create_time, updater_id, update_time, deleted) VALUES (2, 1, '0,1', '深圳总公司', 1, null, 'valarchie', '15888888888', 'valarchie@163.com', 1, null, '2022-05-21 08:30:54', null, null, 0);
    50. 

  50. INSERT INTO  sys_dept (dept_id, parent_id, ancestors, dept_name, order_num, leader_id, leader_name, phone, email, status, creator_id, create_time, updater_id, update_time, deleted) VALUES (3, 1, '0,1', '长沙分公司', 2, null, 'valarchie', '15888888888', 'valarchie@163.com', 1, null, '2022-05-21 08:30:54', null, null, 0);
    51. 

  51. INSERT INTO  sys_dept (dept_id, parent_id, ancestors, dept_name, order_num, leader_id, leader_name, phone, email, status, creator_id, create_time, updater_id, update_time, deleted) VALUES (4, 2, '0,1,2', '研发部门', 1, null, 'valarchie', '15888888888', 'valarchie@163.com', 1, null, '2022-05-21 08:30:54', null, null, 0);
    52. 

  52. INSERT INTO  sys_dept (dept_id, parent_id, ancestors, dept_name, order_num, leader_id, leader_name, phone, email, status, creator_id, create_time, updater_id, update_time, deleted) VALUES (5, 2, '0,1,2', '市场部门', 2, null, 'valarchie', '15888888888', 'valarchie@163.com', 0, null, '2022-05-21 08:30:54', 1, '2023-07-20 22:46:41', 0);
    53. 

  53. INSERT INTO  sys_dept (dept_id, parent_id, ancestors, dept_name, order_num, leader_id, leader_name, phone, email, status, creator_id, create_time, updater_id, update_time, deleted) VALUES (6, 2, '0,1,2', '测试部门', 3, null, 'valarchie', '15888888888', 'valarchie@163.com', 1, null, '2022-05-21 08:30:54', null, null, 0);
    54. 

  54. INSERT INTO  sys_dept (dept_id, parent_id, ancestors, dept_name, order_num, leader_id, leader_name, phone, email, status, creator_id, create_time, updater_id, update_time, deleted) VALUES (7, 2, '0,1,2', '财务部门', 4, null, 'valarchie', '15888888888', 'valarchie@163.com', 1, null, '2022-05-21 08:30:54', null, null, 0);
    55. 

  55. INSERT INTO  sys_dept (dept_id, parent_id, ancestors, dept_name, order_num, leader_id, leader_name, phone, email, status, creator_id, create_time, updater_id, update_time, deleted) VALUES (8, 2, '0,1,2', '运维部门', 5, null, 'valarchie', '15888888888', 'valarchie@163.com', 1, null, '2022-05-21 08:30:54', null, null, 0);
    56. 

  56. INSERT INTO  sys_dept (dept_id, parent_id, ancestors, dept_name, order_num, leader_id, leader_name, phone, email, status, creator_id, create_time, updater_id, update_time, deleted) VALUES (9, 3, '0,1,3', '市场部!', 1, null, 'valarchie!!', '15888188888', 'valarc1hie@163.com', 0, null, '2022-05-21 08:30:54', 1, '2023-07-20 22:33:31', 0);
    57. 

  57. INSERT INTO  sys_dept (dept_id, parent_id, ancestors, dept_name, order_num, leader_id, leader_name, phone, email, status, creator_id, create_time, updater_id, update_time, deleted) VALUES (10, 3, '0,1,3', '财务部门', 2, null, 'valarchie', '15888888888', 'valarchie@163.com', 0, null, '2022-05-21 08:30:54', null, null, 0);
    58. 

  58. 

  59. create table sys_login_info
    60. 

  60. (
    61. 

  61.     info_id          bigint auto_increment comment '访问ID'
    62. 

  62.         primary key,
    63. 

  63.     username         varchar(50)  default '' not null comment '用户账号',
    64. 

  64.     ip_address       varchar(128) default '' not null comment '登录IP地址',
    65. 

  65.     login_location   varchar(255) default '' not null comment '登录地点',
    66. 

  66.     browser          varchar(50)  default '' not null comment '浏览器类型',
    67. 

  67.     operation_system varchar(50)  default '' not null comment '操作系统',
    68. 

  68.     status           smallint     default 0  not null comment '登录状态（1成功 0失败）',
    69. 

  69.     msg              varchar(255) default '' not null comment '提示消息',
    70. 

  70.     login_time       datetime                null comment '访问时间',
    71. 

  71.     deleted          tinyint(1)   default 0  not null comment '逻辑删除'
    72. 

  72. )
    73. 

  73.     comment '系统访问记录';
    74. 

  74. 

  75. INSERT INTO  sys_login_info (info_id, username, ip_address, login_location, browser, operation_system, status, msg, login_time, deleted) VALUES (415, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Mac OS X', 1, '登录成功', '2023-06-29 22:49:37', 0);
    76. 

  76. INSERT INTO  sys_login_info (info_id, username, ip_address, login_location, browser, operation_system, status, msg, login_time, deleted) VALUES (416, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Mac OS X', 1, '登录成功', '2023-07-02 22:12:30', 0);
    77. 

  77. INSERT INTO  sys_login_info (info_id, username, ip_address, login_location, browser, operation_system, status, msg, login_time, deleted) VALUES (417, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Mac OS X', 0, '验证码过期', '2023-07-02 22:16:06', 0);
    78. 

  78. 

  79. create table sys_menu
    80. 

  80. (
    81. 

  81.     menu_id     bigint auto_increment comment '菜单ID'
    82. 

  82.         primary key,
    83. 

  83.     menu_name   varchar(64)                not null comment '菜单名称',
    84. 

  84.     menu_type   smallint      default 0    not null comment '菜单的类型(1为普通菜单2为目录3为内嵌iFrame4为外链跳转)',
    85. 

  85.     router_name varchar(255)  default ''   not null comment '路由名称（需保持和前端对应的vue文件中的name保持一致defineOptions方法中设置的name）',
    86. 

  86.     parent_id   bigint        default 0    not null comment '父菜单ID',
    87. 

  87.     path        varchar(255)               null comment '组件路径（对应前端项目view文件夹中的路径）',
    88. 

  88.     is_button   tinyint(1)    default 0    not null comment '是否按钮',
    89. 

  89.     permission  varchar(128)               null comment '权限标识',
    90. 

  90.     meta_info   varchar(1024) default '{}' not null comment '路由元信息（前端根据这个信息进行逻辑处理）',
    91. 

  91.     status      smallint      default 0    not null comment '菜单状态（1启用 0停用）',
    92. 

  92.     remark      varchar(256)  default ''   null comment '备注',
    93. 

  93.     creator_id  bigint                     null comment '创建者ID',
    94. 

  94.     create_time datetime                   null comment '创建时间',
    95. 

  95.     updater_id  bigint                     null comment '更新者ID',
    96. 

  96.     update_time datetime                   null comment '更新时间',
    97. 

  97.     deleted     tinyint(1)    default 0    not null comment '逻辑删除'
    98. 

  98. )
    99. 

  99.     comment '菜单权限表';
    100. 

  100. 

  101. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (1, '系统管理', 2, '', 0, '/system', 0, '', '{"title":"系统管理","icon":"ep:management","showParent":true,"rank":1}', 1, '系统管理目录', 0, '2022-05-21 08:30:54', 1, '2023-08-14 23:08:50', 0);
    102. 

  102. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (2, '系统监控', 2, '', 0, '/monitor', 0, '', '{"title":"系统监控","icon":"ep:monitor","showParent":true,"rank":3}', 1, '系统监控目录', 0, '2022-05-21 08:30:54', 1, '2023-08-14 23:09:15', 0);
    103. 

  103. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (3, '系统工具', 2, '', 0, '/tool', 0, '', '{"title":"系统工具","icon":"ep:tools","showParent":true,"rank":2}', 1, '系统工具目录', 0, '2022-05-21 08:30:54', 1, '2023-08-14 23:09:03', 0);
    104. 

  104. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (4, 'AgileBoot官网', 3, 'AgileBootguanwangIframeRouter', 0, '/AgileBootguanwangIframeLink', 0, '', '{"title":"AgileBoot官网","icon":"ep:link","showParent":true,"frameSrc":"https://element-plus.org/zh-CN/","rank":8}', 1, 'Agileboot官网地址', 0, '2022-05-21 08:30:54', 1, '2023-08-14 23:09:40', 0);
    105. 

  105. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (5, '用户管理', 1, 'SystemUser', 1, '/system/user/index', 0, 'system:user:list', '{"title":"用户管理","icon":"ep:user-filled","showParent":true}', 1, '用户管理菜单', 0, '2022-05-21 08:30:54', 1, '2023-08-14 23:16:13', 0);
    106. 

  106. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (6, '角色管理', 1, 'SystemRole', 1, '/system/role/index', 0, 'system:role:list', '{"title":"角色管理","icon":"ep:user","showParent":true}', 1, '角色管理菜单', 0, '2022-05-21 08:30:54', 1, '2023-08-14 23:16:23', 0);
    107. 

  107. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (7, '菜单管理', 1, 'MenuManagement', 1, '/system/menu/index', 0, 'system:menu:list', '{"title":"菜单管理","icon":"ep:menu","showParent":true}', 1, '菜单管理菜单', 0, '2022-05-21 08:30:54', 1, '2023-08-14 23:15:41', 0);
    108. 

  108. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (8, '部门管理', 1, 'Department', 1, '/system/dept/index', 0, 'system:dept:list', '{"title":"部门管理","icon":"fa-solid:code-branch","showParent":true}', 1, '部门管理菜单', 0, '2022-05-21 08:30:54', 1, '2023-08-14 23:15:35', 0);
    109. 

  109. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (9, '岗位管理', 1, 'Post', 1, '/system/post/index', 0, 'system:post:list', '{"title":"岗位管理","icon":"ep:postcard","showParent":true}', 1, '岗位管理菜单', 0, '2022-05-21 08:30:54', 1, '2023-08-14 23:15:11', 0);
    110. 

  110. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (10, '参数设置', 1, 'Config', 1, '/system/config/index', 0, 'system:config:list', '{"title":"参数设置","icon":"ep:setting","showParent":true}', 1, '参数设置菜单', 0, '2022-05-21 08:30:54', 1, '2023-08-14 23:15:03', 0);
    111. 

  111. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (11, '通知公告', 1, 'SystemNotice', 1, '/system/notice/index', 0, 'system:notice:list', '{"title":"通知公告","icon":"ep:notification","showParent":true}', 1, '通知公告菜单', 0, '2022-05-21 08:30:54', 1, '2023-08-14 23:14:56', 0);
    112. 

  112. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (12, '日志管理', 1, 'LogManagement', 1, '/system/logd', 0, '', '{"title":"日志管理","icon":"ep:document","showParent":true}', 1, '日志管理菜单', 0, '2022-05-21 08:30:54', 1, '2023-08-14 23:14:47', 0);
    113. 

  113. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (13, '在线用户', 1, 'OnlineUser', 2, '/system/monitor/onlineUser/index', 0, 'monitor:online:list', '{"title":"在线用户","icon":"fa-solid:users","showParent":true}', 1, '在线用户菜单', 0, '2022-05-21 08:30:54', 1, '2023-08-14 23:13:13', 0);
    114. 

  114. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (14, '数据监控', 1, 'DataMonitor', 2, '/system/monitor/druid/index', 0, 'monitor:druid:list', '{"title":"数据监控","icon":"fa:database","showParent":true,"frameSrc":"/druid/login.html","isFrameSrcInternal":true}', 1, '数据监控菜单', 0, '2022-05-21 08:30:54', 1, '2023-08-14 23:13:25', 0);
    115. 

  115. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (15, '服务监控', 1, 'ServerInfo', 2, '/system/monitor/server/index', 0, 'monitor:server:list', '{"title":"服务监控","icon":"fa:server","showParent":true}', 1, '服务监控菜单', 0, '2022-05-21 08:30:54', 1, '2023-08-14 23:13:34', 0);
    116. 

  116. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (16, '缓存监控', 1, 'CacheInfo', 2, '/system/monitor/cache/index', 0, 'monitor:cache:list', '{"title":"缓存监控","icon":"ep:reading","showParent":true}', 1, '缓存监控菜单', 0, '2022-05-21 08:30:54', 1, '2023-08-14 23:12:59', 0);
    117. 

  117. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (17, '系统接口', 1, 'SystemAPI', 3, '/tool/swagger/index', 0, 'tool:swagger:list', '{"title":"系统接口","icon":"ep:document-remove","showParent":true,"frameSrc":"/swagger-ui/index.html","isFrameSrcInternal":true}', 1, '系统接口菜单', 0, '2022-05-21 08:30:54', 1, '2023-08-14 23:14:01', 0);
    118. 

  118. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (18, '操作日志', 1, 'OperationLog', 12, '/system/log/operationLog/index', 0, 'monitor:operlog:list', '{"title":"操作日志"}', 1, '操作日志菜单', 0, '2022-05-21 08:30:54', null, null, 0);
    119. 

  119. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (19, '登录日志', 1, 'LoginLog', 12, '/system/log/loginLog/index', 0, 'monitor:logininfor:list', '{"title":"登录日志"}', 1, '登录日志菜单', 0, '2022-05-21 08:30:54', null, null, 0);
    120. 

  120. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (20, '用户查询', 0, ' ', 5, '', 1, 'system:user:query', '{"title":"用户查询"}', 1, '', 0, '2022-05-21 08:30:54', null, null, 0);
    121. 

  121. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (21, '用户新增', 0, ' ', 5, '', 1, 'system:user:add', '{"title":"用户新增"}', 1, '', 0, '2022-05-21 08:30:54', null, null, 0);
    122. 

  122. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (22, '用户修改', 0, ' ', 5, '', 1, 'system:user:edit', '{"title":"用户修改"}', 1, '', 0, '2022-05-21 08:30:54', null, null, 0);
    123. 

  123. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (23, '用户删除', 0, ' ', 5, '', 1, 'system:user:remove', '{"title":"用户删除"}', 1, '', 0, '2022-05-21 08:30:54', null, null, 0);
    124. 

  124. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (24, '用户导出', 0, ' ', 5, '', 1, 'system:user:export', '{"title":"用户导出"}', 1, '', 0, '2022-05-21 08:30:54', null, null, 0);
    125. 

  125. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (25, '用户导入', 0, ' ', 5, '', 1, 'system:user:import', '{"title":"用户导入"}', 1, '', 0, '2022-05-21 08:30:54', null, null, 0);
    126. 

  126. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (26, '重置密码', 0, ' ', 5, '', 1, 'system:user:resetPwd', '{"title":"重置密码"}', 1, '', 0, '2022-05-21 08:30:54', null, null, 0);
    127. 

  127. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (27, '角色查询', 0, ' ', 6, '', 1, 'system:role:query', '{"title":"角色查询"}', 1, '', 0, '2022-05-21 08:30:54', null, null, 0);
    128. 

  128. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (28, '角色新增', 0, ' ', 6, '', 1, 'system:role:add', '{"title":"角色新增"}', 1, '', 0, '2022-05-21 08:30:54', null, null, 0);
    129. 

  129. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (29, '角色修改', 0, ' ', 6, '', 1, 'system:role:edit', '{"title":"角色修改"}', 1, '', 0, '2022-05-21 08:30:54', null, null, 0);
    130. 

  130. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (30, '角色删除', 0, ' ', 6, '', 1, 'system:role:remove', '{"title":"角色删除"}', 1, '', 0, '2022-05-21 08:30:54', null, null, 0);
    131. 

  131. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (31, '角色导出', 0, ' ', 6, '', 1, 'system:role:export', '{"title":"角色导出"}', 1, '', 0, '2022-05-21 08:30:54', null, null, 0);
    132. 

  132. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (32, '菜单查询', 0, ' ', 7, '', 1, 'system:menu:query', '{"title":"菜单查询"}', 1, '', 0, '2022-05-21 08:30:54', null, null, 0);
    133. 

  133. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (33, '菜单新增', 0, ' ', 7, '', 1, 'system:menu:add', '{"title":"菜单新增"}', 1, '', 0, '2022-05-21 08:30:54', null, null, 0);
    134. 

  134. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (34, '菜单修改', 0, ' ', 7, '', 1, 'system:menu:edit', '{"title":"菜单修改"}', 1, '', 0, '2022-05-21 08:30:54', null, null, 0);
    135. 

  135. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (35, '菜单删除', 0, ' ', 7, '', 1, 'system:menu:remove', '{"title":"菜单删除"}', 1, '', 0, '2022-05-21 08:30:54', null, null, 0);
    136. 

  136. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (36, '部门查询', 0, ' ', 8, '', 1, 'system:dept:query', '{"title":"部门查询"}', 1, '', 0, '2022-05-21 08:30:54', null, null, 0);
    137. 

  137. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (37, '部门新增', 0, ' ', 8, '', 1, 'system:dept:add', '{"title":"部门新增"}', 1, '', 0, '2022-05-21 08:30:54', null, null, 0);
    138. 

  138. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (38, '部门修改', 0, ' ', 8, '', 1, 'system:dept:edit', '{"title":"部门修改"}', 1, '', 0, '2022-05-21 08:30:54', null, null, 0);
    139. 

  139. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (39, '部门删除', 0, ' ', 8, '', 1, 'system:dept:remove', '{"title":"部门删除"}', 1, '', 0, '2022-05-21 08:30:54', null, null, 0);
    140. 

  140. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (40, '岗位查询', 0, ' ', 9, '', 1, 'system:post:query', '{"title":"岗位查询"}', 1, '', 0, '2022-05-21 08:30:54', null, null, 0);
    141. 

  141. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (41, '岗位新增', 0, ' ', 9, '', 1, 'system:post:add', '{"title":"岗位新增"}', 1, '', 0, '2022-05-21 08:30:54', null, null, 0);
    142. 

  142. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (42, '岗位修改', 0, ' ', 9, '', 1, 'system:post:edit', '{"title":"岗位修改"}', 1, '', 0, '2022-05-21 08:30:54', null, null, 0);
    143. 

  143. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (43, '岗位删除', 0, ' ', 9, '', 1, 'system:post:remove', '{"title":"岗位删除"}', 1, '', 0, '2022-05-21 08:30:54', null, null, 0);
    144. 

  144. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (44, '岗位导出', 0, ' ', 9, '', 1, 'system:post:export', '{"title":"岗位导出"}', 1, '', 0, '2022-05-21 08:30:54', null, null, 0);
    145. 

  145. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (45, '参数查询', 0, ' ', 10, '', 1, 'system:config:query', '{"title":"参数查询"}', 1, '', 0, '2022-05-21 08:30:54', null, null, 0);
    146. 

  146. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (46, '参数新增', 0, ' ', 10, '', 1, 'system:config:add', '{"title":"参数新增"}', 1, '', 0, '2022-05-21 08:30:54', null, null, 0);
    147. 

  147. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (47, '参数修改', 0, ' ', 10, '', 1, 'system:config:edit', '{"title":"参数修改"}', 1, '', 0, '2022-05-21 08:30:54', null, null, 0);
    148. 

  148. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (48, '参数删除', 0, ' ', 10, '', 1, 'system:config:remove', '{"title":"参数删除"}', 1, '', 0, '2022-05-21 08:30:54', null, null, 0);
    149. 

  149. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (49, '参数导出', 0, ' ', 10, '', 1, 'system:config:export', '{"title":"参数导出"}', 1, '', 0, '2022-05-21 08:30:54', null, null, 0);
    150. 

  150. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (50, '公告查询', 0, ' ', 11, '', 1, 'system:notice:query', '{"title":"公告查询"}', 1, '', 0, '2022-05-21 08:30:54', null, null, 0);
    151. 

  151. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (51, '公告新增', 0, ' ', 11, '', 1, 'system:notice:add', '{"title":"公告新增"}', 1, '', 0, '2022-05-21 08:30:54', null, null, 0);
    152. 

  152. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (52, '公告修改', 0, ' ', 11, '', 1, 'system:notice:edit', '{"title":"公告修改"}', 1, '', 0, '2022-05-21 08:30:54', null, null, 0);
    153. 

  153. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (53, '公告删除', 0, ' ', 11, '', 1, 'system:notice:remove', '{"title":"公告删除"}', 1, '', 0, '2022-05-21 08:30:54', null, null, 0);
    154. 

  154. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (54, '操作查询', 0, ' ', 18, '', 1, 'monitor:operlog:query', '{"title":"操作查询"}', 1, '', 0, '2022-05-21 08:30:54', null, null, 0);
    155. 

  155. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (55, '操作删除', 0, ' ', 18, '', 1, 'monitor:operlog:remove', '{"title":"操作删除"}', 1, '', 0, '2022-05-21 08:30:54', null, null, 0);
    156. 

  156. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (56, '日志导出', 0, ' ', 18, '', 1, 'monitor:operlog:export', '{"title":"日志导出"}', 1, '', 0, '2022-05-21 08:30:54', null, null, 0);
    157. 

  157. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (57, '登录查询', 0, ' ', 19, '', 1, 'monitor:logininfor:query', '{"title":"登录查询"}', 1, '', 0, '2022-05-21 08:30:54', null, null, 0);
    158. 

  158. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (58, '登录删除', 0, ' ', 19, '', 1, 'monitor:logininfor:remove', '{"title":"登录删除"}', 1, '', 0, '2022-05-21 08:30:54', null, null, 0);
    159. 

  159. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (59, '日志导出', 0, ' ', 19, '', 1, 'monitor:logininfor:export', '{"title":"日志导出","rank":22}', 1, '', 0, '2022-05-21 08:30:54', 1, '2023-07-22 17:02:28', 0);
    160. 

  160. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (60, '在线查询', 0, ' ', 13, '', 1, 'monitor:online:query', '{"title":"在线查询"}', 1, '', 0, '2022-05-21 08:30:54', null, null, 0);
    161. 

  161. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (61, '批量强退', 0, ' ', 13, '', 1, 'monitor:online:batchLogout', '{"title":"批量强退"}', 1, '', 0, '2022-05-21 08:30:54', null, null, 0);
    162. 

  162. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (62, '单条强退', 0, ' ', 13, '', 1, 'monitor:online:forceLogout', '{"title":"单条强退"}', 1, '', 0, '2022-05-21 08:30:54', null, null, 0);
    163. 

  163. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (63, 'AgileBoot Github地址', 4, 'https://github.com/valarchie/AgileBoot-Back-End', 0, '/external', 0, '', '{"title":"AgileBoot Github地址","icon":"fa-solid:external-link-alt","showParent":true,"rank":9}', 1, 'Agileboot github地址', 0, '2022-05-21 08:30:54', 1, '2023-08-14 23:12:13', 0);
    164. 

  164. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (64, '首页', 2, '', 0, '/global', 0, '121212', '{"title":"首页","showParent":true,"rank":3}', 1, '', 1, '2023-07-24 22:36:03', 1, '2023-07-24 22:38:37', 1);
    165. 

  165. INSERT INTO  sys_menu (menu_id, menu_name, menu_type, router_name, parent_id, path, is_button, permission, meta_info, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (65, '个人中心', 1, 'PersonalCenter', 2053, '/system/user/profile', 0, '434sdf', '{"title":"个人中心","showParent":true,"rank":3}', 1, '', 1, '2023-07-24 22:36:55', null, null, 1);
    166. 

  166. 

  167. create table sys_notice
    168. 

  168. (
    169. 

  169.     notice_id      int auto_increment comment '公告ID'
    170. 

  170.         primary key,
    171. 

  171.     notice_title   varchar(64)             not null comment '公告标题',
    172. 

  172.     notice_type    smallint                not null comment '公告类型（1通知 2公告）',
    173. 

  173.     notice_content text                    null comment '公告内容',
    174. 

  174.     status         smallint     default 0  not null comment '公告状态（1正常 0关闭）',
    175. 

  175.     creator_id     bigint                  not null comment '创建者ID',
    176. 

  176.     create_time    datetime                null comment '创建时间',
    177. 

  177.     updater_id     bigint                  null comment '更新者ID',
    178. 

  178.     update_time    datetime                null comment '更新时间',
    179. 

  179.     remark         varchar(255) default '' not null comment '备注',
    180. 

  180.     deleted        tinyint(1)   default 0  not null comment '逻辑删除'
    181. 

  181. )
    182. 

  182.     comment '通知公告表';
    183. 

  183. 

  184. INSERT INTO  sys_notice (notice_id, notice_title, notice_type, notice_content, status, creator_id, create_time, updater_id, update_time, remark, deleted) VALUES (1, '温馨提醒：2018-07-01 AgileBoot新版本发布啦', 2, '新版本内容~~~~~~~~~~', 1, 1, '2022-05-21 08:30:55', 1, '2022-08-29 20:12:37', '管理员', 0);
    185. 

  185. INSERT INTO  sys_notice (notice_id, notice_title, notice_type, notice_content, status, creator_id, create_time, updater_id, update_time, remark, deleted) VALUES (2, '维护通知：2018-07-01 AgileBoot系统凌晨维护', 1, '维护内容', 1, 1, '2022-05-21 08:30:55', null, null, '管理员', 0);
    186. 

  186. 

  187. create table sys_operation_log
    188. 

  188. (
    189. 

  189.     operation_id      bigint auto_increment comment '日志主键'
    190. 

  190.         primary key,
    191. 

  191.     business_type     smallint      default 0  not null comment '业务类型（0其它 1新增 2修改 3删除）',
    192. 

  192.     request_method    smallint      default 0  not null comment '请求方式',
    193. 

  193.     request_module    varchar(64)   default '' not null comment '请求模块',
    194. 

  194.     request_url       varchar(256)  default '' not null comment '请求URL',
    195. 

  195.     called_method     varchar(128)  default '' not null comment '调用方法',
    196. 

  196.     operator_type     smallint      default 0  not null comment '操作类别（0其它 1后台用户 2手机端用户）',
    197. 

  197.     user_id           bigint        default 0  null comment '用户ID',
    198. 

  198.     username          varchar(32)   default '' null comment '操作人员',
    199. 

  199.     operator_ip       varchar(128)  default '' null comment '操作人员ip',
    200. 

  200.     operator_location varchar(256)  default '' null comment '操作地点',
    201. 

  201.     dept_id           bigint        default 0  null comment '部门ID',
    202. 

  202.     dept_name         varchar(64)              null comment '部门名称',
    203. 

  203.     operation_param   varchar(2048) default '' null comment '请求参数',
    204. 

  204.     operation_result  varchar(2048) default '' null comment '返回参数',
    205. 

  205.     status            smallint      default 1  not null comment '操作状态（1正常 0异常）',
    206. 

  206.     error_stack       varchar(2048) default '' null comment '错误消息',
    207. 

  207.     operation_time    datetime                 not null comment '操作时间',
    208. 

  208.     deleted           tinyint(1)    default 0  not null comment '逻辑删除'
    209. 

  209. )
    210. 

  210.     comment '操作日志记录';
    211. 

  211. 

  212. INSERT INTO  sys_operation_log (operation_id, business_type, request_method, request_module, request_url, called_method, operator_type, user_id, username, operator_ip, operator_location, dept_id, dept_name, operation_param, operation_result, status, error_stack, operation_time, deleted) VALUES (561, 1, 2, '菜单管理', '/system/menus', 'com.agileboot.admin.controller.system.SysMenuController.add()', 1, 0, 'admin', '127.0.0.1', '内网IP', 0, null, '{"menuName":"","permission":"","parentId":2035,"path":"","isButton":false,"routerName":"","meta":{"showParent":true,"rank":0},"status":1},', '', 1, '', '2023-07-22 17:06:57', 0);
    213. 

  213. 

  214. create table sys_post
    215. 

  215. (
    216. 

  216.     post_id     bigint auto_increment comment '岗位ID'
    217. 

  217.         primary key,
    218. 

  218.     post_code   varchar(64)          not null comment '岗位编码',
    219. 

  219.     post_name   varchar(64)          not null comment '岗位名称',
    220. 

  220.     post_sort   int                  not null comment '显示顺序',
    221. 

  221.     status      smallint             not null comment '状态（1正常 0停用）',
    222. 

  222.     remark      varchar(512)         null comment '备注',
    223. 

  223.     creator_id  bigint               null,
    224. 

  224.     create_time datetime             null comment '创建时间',
    225. 

  225.     updater_id  bigint               null,
    226. 

  226.     update_time datetime             null comment '更新时间',
    227. 

  227.     deleted     tinyint(1) default 0 not null comment '逻辑删除'
    228. 

  228. )
    229. 

  229.     comment '岗位信息表';
    230. 

  230. 

  231. INSERT INTO  sys_post (post_id, post_code, post_name, post_sort, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (1, 'ceo', '董事长', 1, 1, '', null, '2022-05-21 08:30:54', null, null, 0);
    232. 

  232. INSERT INTO  sys_post (post_id, post_code, post_name, post_sort, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (2, 'se', '项目经理', 2, 1, '', null, '2022-05-21 08:30:54', null, null, 0);
    233. 

  233. INSERT INTO  sys_post (post_id, post_code, post_name, post_sort, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (3, 'hr', '人力资源', 3, 1, '', null, '2022-05-21 08:30:54', null, null, 0);
    234. 

  234. INSERT INTO  sys_post (post_id, post_code, post_name, post_sort, status, remark, creator_id, create_time, updater_id, update_time, deleted) VALUES (4, 'user', '普通员工', 5, 0, '', null, '2022-05-21 08:30:54', null, null, 0);
    235. 

  235. 

  236. create table sys_role
    237. 

  237. (
    238. 

  238.     role_id     bigint auto_increment comment '角色ID'
    239. 

  239.         primary key,
    240. 

  240.     role_name   varchar(32)              not null comment '角色名称',
    241. 

  241.     role_key    varchar(128)             not null comment '角色权限字符串',
    242. 

  242.     role_sort   int                      not null comment '显示顺序',
    243. 

  243.     data_scope  smallint      default 1  null comment '数据范围（1：全部数据权限 2：自定数据权限 3: 本部门数据权限 4: 本部门及以下数据权限 5: 本人权限）',
    244. 

  244.     dept_id_set varchar(1024) default '' null comment '角色所拥有的部门数据权限',
    245. 

  245.     status      smallint                 not null comment '角色状态（1正常 0停用）',
    246. 

  246.     creator_id  bigint                   null comment '创建者ID',
    247. 

  247.     create_time datetime                 null comment '创建时间',
    248. 

  248.     updater_id  bigint                   null comment '更新者ID',
    249. 

  249.     update_time datetime                 null comment '更新时间',
    250. 

  250.     remark      varchar(512)             null comment '备注',
    251. 

  251.     deleted     tinyint(1)    default 0  not null comment '删除标志（0代表存在 1代表删除）'
    252. 

  252. )
    253. 

  253.     comment '角色信息表';
    254. 

  254. 

  255. INSERT INTO  sys_role (role_id, role_name, role_key, role_sort, data_scope, dept_id_set, status, creator_id, create_time, updater_id, update_time, remark, deleted) VALUES (1, '超级管理员', 'admin', 1, 1, '', 1, null, '2022-05-21 08:30:54', null, null, '超级管理员', 0);
    256. 

  256. INSERT INTO  sys_role (role_id, role_name, role_key, role_sort, data_scope, dept_id_set, status, creator_id, create_time, updater_id, update_time, remark, deleted) VALUES (2, '普通角色', 'common', 3, 2, '', 1, null, '2022-05-21 08:30:54', null, null, '普通角色', 0);
    257. 

  257. INSERT INTO  sys_role (role_id, role_name, role_key, role_sort, data_scope, dept_id_set, status, creator_id, create_time, updater_id, update_time, remark, deleted) VALUES (3, '闲置角色', 'unused', 4, 2, '', 0, null, '2022-05-21 08:30:54', null, null, '未使用的角色', 0);
    258. 

  258. 

  259. create table sys_role_menu
    260. 

  260. (
    261. 

  261.     role_id bigint not null comment '角色ID',
    262. 

  262.     menu_id bigint not null comment '菜单ID',
    263. 

  263.     primary key (role_id, menu_id)
    264. 

  264. )
    265. 

  265.     comment '角色和菜单关联表';
    266. 

  266. 

  267. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 1);
    268. 

  268. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 2);
    269. 

  269. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 3);
    270. 

  270. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 4);
    271. 

  271. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 5);
    272. 

  272. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 6);
    273. 

  273. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 7);
    274. 

  274. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 8);
    275. 

  275. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 9);
    276. 

  276. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 10);
    277. 

  277. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 11);
    278. 

  278. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 12);
    279. 

  279. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 13);
    280. 

  280. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 14);
    281. 

  281. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 15);
    282. 

  282. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 16);
    283. 

  283. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 17);
    284. 

  284. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 18);
    285. 

  285. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 19);
    286. 

  286. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 20);
    287. 

  287. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 21);
    288. 

  288. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 22);
    289. 

  289. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 23);
    290. 

  290. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 24);
    291. 

  291. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 25);
    292. 

  292. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 26);
    293. 

  293. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 27);
    294. 

  294. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 28);
    295. 

  295. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 29);
    296. 

  296. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 30);
    297. 

  297. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 31);
    298. 

  298. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 32);
    299. 

  299. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 33);
    300. 

  300. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 34);
    301. 

  301. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 35);
    302. 

  302. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 36);
    303. 

  303. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 37);
    304. 

  304. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 38);
    305. 

  305. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 39);
    306. 

  306. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 40);
    307. 

  307. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 41);
    308. 

  308. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 42);
    309. 

  309. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 43);
    310. 

  310. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 44);
    311. 

  311. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 45);
    312. 

  312. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 46);
    313. 

  313. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 47);
    314. 

  314. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 48);
    315. 

  315. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 49);
    316. 

  316. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 50);
    317. 

  317. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 51);
    318. 

  318. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 52);
    319. 

  319. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 53);
    320. 

  320. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 54);
    321. 

  321. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 55);
    322. 

  322. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 56);
    323. 

  323. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 57);
    324. 

  324. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 58);
    325. 

  325. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 59);
    326. 

  326. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 60);
    327. 

  327. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (2, 61);
    328. 

  328. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (3, 1);
    329. 

  329. INSERT INTO  sys_role_menu (role_id, menu_id) VALUES (111, 1);
    330. 

  330. 

  331. create table sys_user
    332. 

  332. (
    333. 

  333.     user_id      bigint auto_increment comment '用户ID'
    334. 

  334.         primary key,
    335. 

  335.     post_id      bigint                  null comment '职位id',
    336. 

  336.     role_id      bigint                  null comment '角色id',
    337. 

  337.     dept_id      bigint                  null comment '部门ID',
    338. 

  338.     username     varchar(64)             not null comment '用户账号',
    339. 

  339.     nickname     varchar(32)             not null comment '用户昵称',
    340. 

  340.     user_type    smallint     default 0  null comment '用户类型（00系统用户）',
    341. 

  341.     email        varchar(128) default '' null comment '用户邮箱',
    342. 

  342.     phone_number varchar(18)  default '' null comment '手机号码',
    343. 

  343.     sex          smallint     default 0  null comment '用户性别（0男 1女 2未知）',
    344. 

  344.     avatar       varchar(512) default '' null comment '头像地址',
    345. 

  345.     password     varchar(128) default '' not null comment '密码',
    346. 

  346.     status       smallint     default 0  not null comment '帐号状态（1正常 2停用 3冻结）',
    347. 

  347.     login_ip     varchar(128) default '' null comment '最后登录IP',
    348. 

  348.     login_date   datetime                null comment '最后登录时间',
    349. 

  349.     is_admin     tinyint(1)   default 0  not null comment '超级管理员标志（1是，0否）',
    350. 

  350.     creator_id   bigint                  null comment '更新者ID',
    351. 

  351.     create_time  datetime                null comment '创建时间',
    352. 

  352.     updater_id   bigint                  null comment '更新者ID',
    353. 

  353.     update_time  datetime                null comment '更新时间',
    354. 

  354.     remark       varchar(512)            null comment '备注',
    355. 

  355.     deleted      tinyint(1)   default 0  not null comment '删除标志（0代表存在 1代表删除）'
    356. 

  356. )
    357. 

  357.     comment '用户信息表';
    358. 

  358. 

  359. INSERT INTO  sys_user (user_id, post_id, role_id, dept_id, username, nickname, user_type, email, phone_number, sex, avatar, password, status, login_ip, login_date, is_admin, creator_id, create_time, updater_id, update_time, remark, deleted) VALUES (1, 1, 1, 4, 'admin', 'valarchie1', 0, 'agileboot@163.com', '15888888883', 0, '/profile/avatar/20230725164110_blob_6b7a989b1cdd4dd396665d2cfd2addc5.png', '$2a$10$o55UFZAtyWnDpRV6dvQe8.c/MjlFacC49ASj2usNXm9BY74SYI/uG', 1, '127.0.0.1', '2023-08-14 23:07:03', 1, null, '2022-05-21 08:30:54', 1, '2023-08-14 23:07:03', '管理员', 0);
    360. 

  360. INSERT INTO  sys_user (user_id, post_id, role_id, dept_id, username, nickname, user_type, email, phone_number, sex, avatar, password, status, login_ip, login_date, is_admin, creator_id, create_time, updater_id, update_time, remark, deleted) VALUES (2, 2, 2, 5, 'ag1', 'valarchie2', 0, 'agileboot1@qq.com', '15666666666', 1, '/profile/avatar/20230725114818_avatar_b5bf400732bb43369b4df58802049b22.png', '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', 1, '127.0.0.1', '2022-05-21 08:30:54', 0, null, '2022-05-21 08:30:54', null, null, '测试员1', 0);
    361. 

  361. INSERT INTO  sys_user (user_id, post_id, role_id, dept_id, username, nickname, user_type, email, phone_number, sex, avatar, password, status, login_ip, login_date, is_admin, creator_id, create_time, updater_id, update_time, remark, deleted) VALUES (3, 2, 0, 5, 'ag2', 'valarchie3', 0, 'agileboot2@qq.com', '15666666667', 1, '/profile/avatar/20230725114818_avatar_b5bf400732bb43369b4df58802049b22.png', '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', 1, '127.0.0.1', '2022-05-21 08:30:54', 0, null, '2022-05-21 08:30:54', null, null, '测试员2', 0);
    362. 

  362.