Home Explore Help
Sign In
mi.yanzhao
/
jiaodui-saas
1
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Branch: master
Branches Tags
jiaodui-saas
/
sql
/
yb-20210820.sql

yb-20210820.sql 100 KB
Permalink History Raw

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108 
  1. /*
    2. 

  2.  Navicat Premium Data Transfer
    3. 

  3. 

  4.  Source Server         : 本机MySQL
    5. 

  5.  Source Server Type    : MySQL
    6. 

  6.  Source Server Version : 50729
    7. 

  7.  Source Host           : localhost:3306
    8. 

  8.  Source Schema         : yb
    9. 

  9. 

  10.  Target Server Type    : MySQL
    11. 

  11.  Target Server Version : 50729
    12. 

  12.  File Encoding         : 65001
    13. 

  13. 

  14.  Date: 20/08/2021 22:53:16
    15. 

  15. */
    16. 

  16. 

  17. SET NAMES utf8mb4;
    18. 

  18. SET FOREIGN_KEY_CHECKS = 0;
    19. 

  19. 

  20. -- ----------------------------
    21. 

  21. -- Table structure for gen_table
    22. 

  22. -- ----------------------------
    23. 

  23. DROP TABLE IF EXISTS `gen_table`;
    24. 

  24. CREATE TABLE `gen_table`  (
    25. 

  25.   `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '编号',
    26. 

  26.   `table_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '表名称',
    27. 

  27.   `table_comment` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '表描述',
    28. 

  28.   `sub_table_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '关联子表的表名',
    29. 

  29.   `sub_table_fk_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '子表关联的外键名',
    30. 

  30.   `class_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '实体类名称',
    31. 

  31.   `tpl_category` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'crud' COMMENT '使用的模板（crud单表操作 tree树表操作 sub主子表操作）',
    32. 

  32.   `package_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '生成包路径',
    33. 

  33.   `module_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '生成模块名',
    34. 

  34.   `business_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '生成业务名',
    35. 

  35.   `function_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '生成功能名',
    36. 

  36.   `function_author` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '生成功能作者',
    37. 

  37.   `gen_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '生成代码方式（0zip压缩包 1自定义路径）',
    38. 

  38.   `gen_path` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '/' COMMENT '生成路径（不填默认项目路径）',
    39. 

  39.   `options` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '其它生成选项',
    40. 

  40.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
    41. 

  41.   `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    42. 

  42.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
    43. 

  43.   `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
    44. 

  44.   `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
    45. 

  45.   PRIMARY KEY (`id`) USING BTREE
    46. 

  46. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '代码生成业务表' ROW_FORMAT = Dynamic;
    47. 

  47. 

  48. -- ----------------------------
    49. 

  49. 

  50. -- ----------------------------
    51. 

  51. -- Table structure for gen_table_column
    52. 

  52. -- ----------------------------
    53. 

  53. DROP TABLE IF EXISTS `gen_table_column`;
    54. 

  54. CREATE TABLE `gen_table_column`  (
    55. 

  55.   `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '编号',
    56. 

  56.   `table_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '归属表编号',
    57. 

  57.   `column_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '列名称',
    58. 

  58.   `column_comment` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '列描述',
    59. 

  59.   `column_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '列类型',
    60. 

  60.   `java_type` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'JAVA类型',
    61. 

  61.   `java_field` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'JAVA字段名',
    62. 

  62.   `is_pk` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否主键（1是）',
    63. 

  63.   `is_increment` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否自增（1是）',
    64. 

  64.   `is_required` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否必填（1是）',
    65. 

  65.   `is_insert` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否为插入字段（1是）',
    66. 

  66.   `is_edit` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否编辑字段（1是）',
    67. 

  67.   `is_list` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否列表字段（1是）',
    68. 

  68.   `is_query` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否查询字段（1是）',
    69. 

  69.   `query_type` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'EQ' COMMENT '查询方式（等于、不等于、大于、小于、范围）',
    70. 

  70.   `html_type` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '显示类型（文本框、文本域、下拉框、复选框、单选框、日期控件）',
    71. 

  71.   `dict_type` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '字典类型',
    72. 

  72.   `sort` int(11) NULL DEFAULT NULL COMMENT '排序',
    73. 

  73.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
    74. 

  74.   `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    75. 

  75.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
    76. 

  76.   `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
    77. 

  77.   PRIMARY KEY (`id`) USING BTREE
    78. 

  78. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '代码生成业务表字段' ROW_FORMAT = Dynamic;
    79. 

  79. 

  80. -- ----------------------------
    81. 

  81. -- ----------------------------
    82. 

  82. -- Table structure for platform_dept
    83. 

  83. -- ----------------------------
    84. 

  84. DROP TABLE IF EXISTS `platform_dept`;
    85. 

  85. CREATE TABLE `platform_dept`  (
    86. 

  86.   `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '部门id',
    87. 

  87.   `parent_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '父部门id',
    88. 

  88.   `ancestors` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '祖级列表',
    89. 

  89.   `dept_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '部门名称',
    90. 

  90.   `dept_type` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '部门类型',
    91. 

  91.   `order_num` int(4) NULL DEFAULT 0 COMMENT '显示顺序',
    92. 

  92.   `leader` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '负责人',
    93. 

  93.   `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '联系电话',
    94. 

  94.   `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '邮箱',
    95. 

  95.   `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '部门状态（0正常 1停用）',
    96. 

  96.   `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
    97. 

  97.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
    98. 

  98.   `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    99. 

  99.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
    100. 

  100.   `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
    101. 

  101.   PRIMARY KEY (`id`) USING BTREE
    102. 

  102. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '部门表' ROW_FORMAT = Dynamic;
    103. 

  103. 

  104. -- ----------------------------
    105. 

  105. -- Records of platform_dept
    106. 

  106. -- ----------------------------
    107. 

  107. INSERT INTO `platform_dept` VALUES ('89678424698023676', '0', '0', '圣钰平台科技', 'yb', 0, '圣钰', '15888888888', 'yb@qq.com', '0', '0', 'admin', '2021-05-26 15:36:20', '', NULL);
    108. 

  108. 

  109. -- ----------------------------
    110. 

  110. -- Table structure for platform_logininfor
    111. 

  111. -- ----------------------------
    112. 

  112. DROP TABLE IF EXISTS `platform_logininfor`;
    113. 

  113. CREATE TABLE `platform_logininfor`  (
    114. 

  114.   `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '访问ID',
    115. 

  115.   `login_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '登录账号',
    116. 

  116.   `ipaddr` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '登录IP地址',
    117. 

  117.   `login_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '登录地点',
    118. 

  118.   `browser` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '浏览器类型',
    119. 

  119.   `os` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '操作系统',
    120. 

  120.   `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '登录状态（0成功 1失败）',
    121. 

  121.   `msg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '提示消息',
    122. 

  122.   `login_time` datetime(0) NULL DEFAULT NULL COMMENT '访问时间',
    123. 

  123.   PRIMARY KEY (`id`) USING BTREE
    124. 

  124. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统访问记录' ROW_FORMAT = Dynamic;
    125. 

  125. 

  126. -- ----------------------------
    127. 

  127. -- Records of platform_logininfor
    128. 

  128. -- ----------------------------
    129. 

  129. 

  130. -- ----------------------------
    131. 

  131. -- Table structure for platform_menu
    132. 

  132. -- ----------------------------
    133. 

  133. DROP TABLE IF EXISTS `platform_menu`;
    134. 

  134. CREATE TABLE `platform_menu`  (
    135. 

  135.   `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '菜单ID',
    136. 

  136.   `menu_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '菜单名称',
    137. 

  137.   `parent_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '父菜单ID',
    138. 

  138.   `order_num` int(4) NULL DEFAULT 0 COMMENT '显示顺序',
    139. 

  139.   `url` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '#' COMMENT '请求地址',
    140. 

  140.   `target` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '打开方式（menuItem页签 menuBlank新窗口）',
    141. 

  141.   `menu_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '菜单类型（M目录 C菜单 F按钮）',
    142. 

  142.   `visible` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '菜单状态（0显示 1隐藏）',
    143. 

  143.   `is_refresh` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '1' COMMENT '是否刷新（0刷新 1不刷新）',
    144. 

  144.   `perms` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '权限标识',
    145. 

  145.   `icon` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '#' COMMENT '菜单图标',
    146. 

  146.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
    147. 

  147.   `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    148. 

  148.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
    149. 

  149.   `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
    150. 

  150.   `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '备注',
    151. 

  151.   PRIMARY KEY (`id`) USING BTREE
    152. 

  152. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '菜单权限表' ROW_FORMAT = Dynamic;
    153. 

  153. 

  154. -- ----------------------------
    155. 

  155. -- Records of platform_menu
    156. 

  156. -- ----------------------------
    157. 

  157. INSERT INTO `platform_menu` VALUES ('1', '系统管理', '0', 1, '#', '', 'M', '0', '1', '', 'fa fa-gear', 'admin', '2021-05-26 15:36:20', '', NULL, '系统管理目录');
    158. 

  158. INSERT INTO `platform_menu` VALUES ('100', '用户管理', '1', 1, '/platform/user', '', 'C', '0', '1', 'platform:user:view', 'fa fa-user-o', 'admin', '2021-05-26 15:36:20', '', NULL, '用户管理菜单');
    159. 

  159. INSERT INTO `platform_menu` VALUES ('1000', '用户查询', '100', 1, '#', '', 'F', '0', '1', 'platform:user:list', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    160. 

  160. INSERT INTO `platform_menu` VALUES ('1001', '用户新增', '100', 2, '#', '', 'F', '0', '1', 'platform:user:add', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    161. 

  161. INSERT INTO `platform_menu` VALUES ('1002', '用户修改', '100', 3, '#', '', 'F', '0', '1', 'platform:user:edit', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    162. 

  162. INSERT INTO `platform_menu` VALUES ('1003', '用户删除', '100', 4, '#', '', 'F', '0', '1', 'platform:user:remove', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    163. 

  163. INSERT INTO `platform_menu` VALUES ('1004', '用户导出', '100', 5, '#', '', 'F', '0', '1', 'platform:user:export', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    164. 

  164. INSERT INTO `platform_menu` VALUES ('1005', '用户导入', '100', 6, '#', '', 'F', '0', '1', 'platform:user:import', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    165. 

  165. INSERT INTO `platform_menu` VALUES ('1006', '重置密码', '100', 7, '#', '', 'F', '0', '1', 'platform:user:resetPwd', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    166. 

  166. INSERT INTO `platform_menu` VALUES ('1007', '角色查询', '101', 1, '#', '', 'F', '0', '1', 'platform:role:list', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    167. 

  167. INSERT INTO `platform_menu` VALUES ('1008', '角色新增', '101', 2, '#', '', 'F', '0', '1', 'platform:role:add', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    168. 

  168. INSERT INTO `platform_menu` VALUES ('1009', '角色修改', '101', 3, '#', '', 'F', '0', '1', 'platform:role:edit', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    169. 

  169. INSERT INTO `platform_menu` VALUES ('101', '角色管理', '1', 2, '/platform/role', '', 'C', '0', '1', 'platform:role:view', 'fa fa-user-secret', 'admin', '2021-05-26 15:36:20', '', NULL, '角色管理菜单');
    170. 

  170. INSERT INTO `platform_menu` VALUES ('1010', '角色删除', '101', 4, '#', '', 'F', '0', '1', 'platform:role:remove', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    171. 

  171. INSERT INTO `platform_menu` VALUES ('1011', '角色导出', '101', 5, '#', '', 'F', '0', '1', 'platform:role:export', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    172. 

  172. INSERT INTO `platform_menu` VALUES ('1012', '菜单查询', '102', 1, '#', '', 'F', '0', '1', 'platform:saasMenu:list', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    173. 

  173. INSERT INTO `platform_menu` VALUES ('1013', '菜单新增', '102', 2, '#', '', 'F', '0', '1', 'platform:saasMenu:add', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    174. 

  174. INSERT INTO `platform_menu` VALUES ('1014', '菜单修改', '102', 3, '#', '', 'F', '0', '1', 'platform:saasMenu:edit', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    175. 

  175. INSERT INTO `platform_menu` VALUES ('1015', '菜单删除', '102', 4, '#', '', 'F', '0', '1', 'platform:saasMenu:remove', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    176. 

  176. INSERT INTO `platform_menu` VALUES ('1016', '部门查询', '103', 1, '#', '', 'F', '0', '1', 'platform:dept:list', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    177. 

  177. INSERT INTO `platform_menu` VALUES ('1017', '部门新增', '103', 2, '#', '', 'F', '0', '1', 'platform:dept:add', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    178. 

  178. INSERT INTO `platform_menu` VALUES ('1018', '部门修改', '103', 3, '#', '', 'F', '0', '1', 'platform:dept:edit', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    179. 

  179. INSERT INTO `platform_menu` VALUES ('1019', '部门删除', '103', 4, '#', '', 'F', '0', '1', 'platform:dept:remove', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    180. 

  180. INSERT INTO `platform_menu` VALUES ('102', '租户菜单', '1422767818551267329', 3, '/platform/saasMenu', 'menuItem', 'C', '0', '1', 'platform:saasMenu:view', 'fa fa-th-list', 'admin', '2021-05-26 15:36:20', 'admin', '2021-08-04 11:55:11', '菜单管理菜单');
    181. 

  181. INSERT INTO `platform_menu` VALUES ('1020', '岗位查询', '104', 1, '#', '', 'F', '0', '1', 'platform:post:list', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    182. 

  182. INSERT INTO `platform_menu` VALUES ('1021', '岗位新增', '104', 2, '#', '', 'F', '0', '1', 'platform:post:add', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    183. 

  183. INSERT INTO `platform_menu` VALUES ('1022', '岗位修改', '104', 3, '#', '', 'F', '0', '1', 'platform:post:edit', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    184. 

  184. INSERT INTO `platform_menu` VALUES ('1023', '岗位删除', '104', 4, '#', '', 'F', '0', '1', 'platform:post:remove', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    185. 

  185. INSERT INTO `platform_menu` VALUES ('1024', '岗位导出', '104', 5, '#', '', 'F', '0', '1', 'platform:post:export', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    186. 

  186. INSERT INTO `platform_menu` VALUES ('1025', '字典查询', '105', 1, '#', '', 'F', '0', '1', 'platform:dict:list', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    187. 

  187. INSERT INTO `platform_menu` VALUES ('1026', '字典新增', '105', 2, '#', '', 'F', '0', '1', 'platform:dict:add', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    188. 

  188. INSERT INTO `platform_menu` VALUES ('1027', '字典修改', '105', 3, '#', '', 'F', '0', '1', 'platform:dict:edit', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    189. 

  189. INSERT INTO `platform_menu` VALUES ('1028', '字典删除', '105', 4, '#', '', 'F', '0', '1', 'platform:dict:remove', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    190. 

  190. INSERT INTO `platform_menu` VALUES ('1029', '字典导出', '105', 5, '#', '', 'F', '0', '1', 'platform:dict:export', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    191. 

  191. INSERT INTO `platform_menu` VALUES ('103', '部门管理', '1', 4, '/platform/dept', '', 'C', '0', '1', 'platform:dept:view', 'fa fa-outdent', 'admin', '2021-05-26 15:36:20', '', NULL, '部门管理菜单');
    192. 

  192. INSERT INTO `platform_menu` VALUES ('1030', '参数查询', '106', 1, '#', '', 'F', '0', '1', 'platform:config:list', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    193. 

  193. INSERT INTO `platform_menu` VALUES ('1031', '参数新增', '106', 2, '#', '', 'F', '0', '1', 'platform:config:add', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    194. 

  194. INSERT INTO `platform_menu` VALUES ('1032', '参数修改', '106', 3, '#', '', 'F', '0', '1', 'platform:config:edit', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    195. 

  195. INSERT INTO `platform_menu` VALUES ('1033', '参数删除', '106', 4, '#', '', 'F', '0', '1', 'platform:config:remove', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    196. 

  196. INSERT INTO `platform_menu` VALUES ('1034', '参数导出', '106', 5, '#', '', 'F', '0', '1', 'platform:config:export', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    197. 

  197. INSERT INTO `platform_menu` VALUES ('1035', '公告查询', '107', 1, '#', '', 'F', '0', '1', 'platform:notice:list', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    198. 

  198. INSERT INTO `platform_menu` VALUES ('1036', '公告新增', '107', 2, '#', '', 'F', '0', '1', 'platform:notice:add', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    199. 

  199. INSERT INTO `platform_menu` VALUES ('1037', '公告修改', '107', 3, '#', '', 'F', '0', '1', 'platform:notice:edit', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    200. 

  200. INSERT INTO `platform_menu` VALUES ('1038', '公告删除', '107', 4, '#', '', 'F', '0', '1', 'platform:notice:remove', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    201. 

  201. INSERT INTO `platform_menu` VALUES ('1039', '操作查询', '500', 1, '#', '', 'F', '0', '1', 'platform:monitor:operlog:list', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    202. 

  202. INSERT INTO `platform_menu` VALUES ('104', '岗位管理', '1', 5, '/platform/post', '', 'C', '0', '1', 'platform:post:view', 'fa fa-address-card-o', 'admin', '2021-05-26 15:36:20', '', NULL, '岗位管理菜单');
    203. 

  203. INSERT INTO `platform_menu` VALUES ('1040', '操作删除', '500', 2, '#', '', 'F', '0', '1', 'platform:monitor:operlog:remove', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    204. 

  204. INSERT INTO `platform_menu` VALUES ('1041', '详细信息', '500', 3, '#', '', 'F', '0', '1', 'platform:monitor:operlog:detail', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    205. 

  205. INSERT INTO `platform_menu` VALUES ('1042', '日志导出', '500', 4, '#', '', 'F', '0', '1', 'platform:monitor:operlog:export', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    206. 

  206. INSERT INTO `platform_menu` VALUES ('1043', '登录查询', '501', 1, '#', '', 'F', '0', '1', 'platform:monitor:logininfor:list', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    207. 

  207. INSERT INTO `platform_menu` VALUES ('1044', '登录删除', '501', 2, '#', '', 'F', '0', '1', 'platform:monitor:logininfor:remove', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    208. 

  208. INSERT INTO `platform_menu` VALUES ('1045', '日志导出', '501', 3, '#', '', 'F', '0', '1', 'platform:monitor:logininfor:export', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    209. 

  209. INSERT INTO `platform_menu` VALUES ('1046', '账户解锁', '501', 4, '#', '', 'F', '0', '1', 'platform:monitor:logininfor:unlock', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    210. 

  210. INSERT INTO `platform_menu` VALUES ('1047', '在线查询', '109', 1, '#', '', 'F', '0', '1', 'platform:monitor:online:list', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    211. 

  211. INSERT INTO `platform_menu` VALUES ('1048', '批量强退', '109', 2, '#', '', 'F', '0', '1', 'platform:monitor:online:batchForceLogout', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    212. 

  212. INSERT INTO `platform_menu` VALUES ('1049', '单条强退', '109', 3, '#', '', 'F', '0', '1', 'platform:monitor:online:forceLogout', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    213. 

  213. INSERT INTO `platform_menu` VALUES ('105', '字典管理', '1', 6, '/platform/dict', '', 'C', '0', '1', 'platform:dict:view', 'fa fa-bookmark-o', 'admin', '2021-05-26 15:36:20', '', NULL, '字典管理菜单');
    214. 

  214. INSERT INTO `platform_menu` VALUES ('1050', '任务查询', '110', 1, '#', '', 'F', '0', '1', 'platform:monitor:job:list', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    215. 

  215. INSERT INTO `platform_menu` VALUES ('1051', '任务新增', '110', 2, '#', '', 'F', '0', '1', 'platform:monitor:job:add', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    216. 

  216. INSERT INTO `platform_menu` VALUES ('1052', '任务修改', '110', 3, '#', '', 'F', '0', '1', 'platform:monitor:job:edit', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    217. 

  217. INSERT INTO `platform_menu` VALUES ('1053', '任务删除', '110', 4, '#', '', 'F', '0', '1', 'platform:monitor:job:remove', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    218. 

  218. INSERT INTO `platform_menu` VALUES ('1054', '状态修改', '110', 5, '#', '', 'F', '0', '1', 'platform:monitor:job:changeStatus', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    219. 

  219. INSERT INTO `platform_menu` VALUES ('1055', '任务详细', '110', 6, '#', '', 'F', '0', '1', 'platform:monitor:job:detail', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    220. 

  220. INSERT INTO `platform_menu` VALUES ('1056', '任务导出', '110', 7, '#', '', 'F', '0', '1', 'platform:monitor:job:export', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    221. 

  221. INSERT INTO `platform_menu` VALUES ('1057', '生成查询', '115', 1, '#', '', 'F', '0', '1', 'tool:gen:list', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    222. 

  222. INSERT INTO `platform_menu` VALUES ('1058', '生成修改', '115', 2, '#', '', 'F', '0', '1', 'tool:gen:edit', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    223. 

  223. INSERT INTO `platform_menu` VALUES ('1059', '生成删除', '115', 3, '#', '', 'F', '0', '1', 'tool:gen:remove', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    224. 

  224. INSERT INTO `platform_menu` VALUES ('106', '参数设置', '1', 7, '/platform/config', '', 'C', '0', '1', 'platform:config:view', 'fa fa-sun-o', 'admin', '2021-05-26 15:36:20', '', NULL, '参数设置菜单');
    225. 

  225. INSERT INTO `platform_menu` VALUES ('1060', '预览代码', '115', 4, '#', '', 'F', '0', '1', 'tool:gen:preview', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    226. 

  226. INSERT INTO `platform_menu` VALUES ('1061', '生成代码', '115', 5, '#', '', 'F', '0', '1', 'tool:gen:code', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    227. 

  227. INSERT INTO `platform_menu` VALUES ('107', '通知公告', '1', 8, '/platform/notice', '', 'C', '0', '1', 'platform:notice:view', 'fa fa-bullhorn', 'admin', '2021-05-26 15:36:20', '', NULL, '通知公告菜单');
    228. 

  228. INSERT INTO `platform_menu` VALUES ('108', '日志管理', '1', 9, '#', '', 'M', '0', '1', '', 'fa fa-pencil-square-o', 'admin', '2021-05-26 15:36:20', '', NULL, '日志管理菜单');
    229. 

  229. INSERT INTO `platform_menu` VALUES ('109', '在线用户', '2', 1, '/platform/monitor/online', '', 'C', '0', '1', 'platform:monitor:online:view', 'fa fa-user-circle', 'admin', '2021-05-26 15:36:20', '', NULL, '在线用户菜单');
    230. 

  230. INSERT INTO `platform_menu` VALUES ('110', '定时任务', '2', 2, '/platform/monitor/job', '', 'C', '0', '1', 'platform:monitor:job:view', 'fa fa-tasks', 'admin', '2021-05-26 15:36:20', '', NULL, '定时任务菜单');
    231. 

  231. INSERT INTO `platform_menu` VALUES ('111', '数据监控', '2', 3, '/platform/monitor/data', '', 'C', '0', '1', 'platform:monitor:data:view', 'fa fa-bug', 'admin', '2021-05-26 15:36:20', '', NULL, '数据监控菜单');
    232. 

  232. INSERT INTO `platform_menu` VALUES ('112', '服务监控', '2', 4, '/platform/monitor/server', '', 'C', '0', '1', 'platform:monitor:server:view', 'fa fa-server', 'admin', '2021-05-26 15:36:20', '', NULL, '服务监控菜单');
    233. 

  233. INSERT INTO `platform_menu` VALUES ('113', '缓存监控', '2', 5, '/platform/monitor/cache', '', 'C', '0', '1', 'platform:monitor:cache:view', 'fa fa-cube', 'admin', '2021-05-26 15:36:20', '', NULL, '缓存监控菜单');
    234. 

  234. INSERT INTO `platform_menu` VALUES ('114', '表单构建', '3', 1, '/tool/build', '', 'C', '0', '1', 'tool:build:view', 'fa fa-wpforms', 'admin', '2021-05-26 15:36:20', '', NULL, '表单构建菜单');
    235. 

  235. INSERT INTO `platform_menu` VALUES ('115', '代码生成', '3', 2, '/tool/gen1', '', 'C', '0', '1', 'tool:gen:view', 'fa fa-code', 'admin', '2021-05-26 15:36:20', '', NULL, '代码生成菜单');
    236. 

  236. INSERT INTO `platform_menu` VALUES ('116', '系统接口', '3', 3, '/tool/swagger', 'menuItem', 'C', '0', '1', 'tool:swagger:view', 'fa fa-gg', 'admin', '2021-05-26 15:36:20', 'admin', '2021-08-16 14:10:44', '系统接口菜单');
    237. 

  237. INSERT INTO `platform_menu` VALUES ('1422767818551267329', '租户管理', '0', 2, '', 'menuItem', 'M', '0', '1', '', 'fa fa-bank', 'admin', '2021-08-04 11:54:16', 'admin', '2021-08-04 11:54:16', '');
    238. 

  238. INSERT INTO `platform_menu` VALUES ('1423511840943562753', '租户角色', '1422767818551267329', 2, '/platform/saasRole', 'menuItem', 'C', '0', '1', 'platform:saasRole:view', 'fa fa-user-secret', 'admin', '2021-08-06 13:10:45', 'admin', '2021-08-06 13:10:45', '');
    239. 

  239. INSERT INTO `platform_menu` VALUES ('1423512072255234049', '查询', '1423511840943562753', 1, '', 'menuItem', 'F', '0', '1', 'platform:saasRole:list', '', 'admin', '2021-08-06 13:11:40', 'admin', '2021-08-06 13:11:40', '');
    240. 

  240. INSERT INTO `platform_menu` VALUES ('1423512193432870914', '新增', '1423511840943562753', 2, '', 'menuItem', 'F', '0', '1', 'platform:saasRole:add', '', 'admin', '2021-08-06 13:12:09', 'admin', '2021-08-06 13:12:09', '');
    241. 

  241. INSERT INTO `platform_menu` VALUES ('1423512294935027714', '修改', '1423511840943562753', 3, '', 'menuItem', 'F', '0', '1', 'platform:saasRole:edit', '', 'admin', '2021-08-06 13:12:33', 'admin', '2021-08-06 13:12:33', '');
    242. 

  242. INSERT INTO `platform_menu` VALUES ('1423512466557558785', '删除', '1423511840943562753', 4, '', 'menuItem', 'F', '0', '1', 'platform:saasRole:remove', '', 'admin', '2021-08-06 13:13:14', 'admin', '2021-08-06 13:13:14', '');
    243. 

  243. INSERT INTO `platform_menu` VALUES ('1423512555762016257', '导出', '1423511840943562753', 5, '', 'menuItem', 'F', '0', '1', 'platform:saasRole:export', '', 'admin', '2021-08-06 13:13:36', 'admin', '2021-08-06 13:13:36', '');
    244. 

  244. INSERT INTO `platform_menu` VALUES ('2', '系统监控', '0', 3, '#', 'menuItem', 'M', '0', '1', '', 'fa fa-video-camera', 'admin', '2021-05-26 15:36:20', 'admin', '2021-08-04 11:54:29', '系统监控目录');
    245. 

  245. INSERT INTO `platform_menu` VALUES ('2346345634563456', '租户列表', '1422767818551267329', 1, '/platform/tenant', 'menuItem', 'C', '0', '1', 'platform:tenant:view', '#', 'admin', '2021-07-03 17:35:54', 'admin', '2021-08-04 17:28:52', '租户列表菜单');
    246. 

  246. INSERT INTO `platform_menu` VALUES ('3', '系统工具', '0', 3, '#', '', 'M', '0', '1', '', 'fa fa-bars', 'admin', '2021-05-26 15:36:20', '', NULL, '系统工具目录');
    247. 

  247. INSERT INTO `platform_menu` VALUES ('4', '圣钰官网', '0', 4, 'https://gitee.com/jinzheyi/ruoyi-saas', 'menuBlank', 'C', '0', '1', '', 'fa fa-location-arrow', 'admin', '2021-05-26 15:36:20', '', NULL, '圣钰官网地址');
    248. 

  248. INSERT INTO `platform_menu` VALUES ('500', '操作日志', '108', 1, '/platform/monitor/operlog', '', 'C', '0', '1', 'platform:monitor:operlog:view', 'fa fa-address-book', 'admin', '2021-05-26 15:36:20', '', NULL, '操作日志菜单');
    249. 

  249. INSERT INTO `platform_menu` VALUES ('501', '登录日志', '108', 2, '/platform/monitor/logininfor', '', 'C', '0', '1', 'platform:monitor:logininfor:view', 'fa fa-file-image-o', 'admin', '2021-05-26 15:36:20', '', NULL, '登录日志菜单');
    250. 

  250. INSERT INTO `platform_menu` VALUES ('5674567456745673', '租户查询', '2346345634563456', 1, '#', '', 'F', '0', '1', 'platform:tenant:list', '#', 'admin', '2021-07-03 17:35:54', '', NULL, '');
    251. 

  251. INSERT INTO `platform_menu` VALUES ('5675674534743564', '租户新增', '2346345634563456', 2, '#', '', 'F', '0', '1', 'platform:tenant:add', '#', 'admin', '2021-07-03 17:35:54', '', NULL, '');
    252. 

  252. INSERT INTO `platform_menu` VALUES ('634564634567', '菜单管理', '1', 3, '/platform/menu', '', 'C', '0', '1', 'platform:saasMenu:view', 'fa fa-th-list', 'admin', '2021-05-26 15:36:20', '', NULL, '菜单管理菜单');
    253. 

  253. INSERT INTO `platform_menu` VALUES ('63456463456701', '菜单查询', '634564634567', 1, '#', '', 'F', '0', '1', 'platform:menu:list', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    254. 

  254. INSERT INTO `platform_menu` VALUES ('63456463456702', '菜单新增', '634564634567', 2, '#', '', 'F', '0', '1', 'platform:menu:add', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    255. 

  255. INSERT INTO `platform_menu` VALUES ('63456463456703', '菜单修改', '634564634567', 3, '#', '', 'F', '0', '1', 'platform:menu:edit', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    256. 

  256. INSERT INTO `platform_menu` VALUES ('63456463456704', '菜单删除', '634564634567', 4, '#', '', 'F', '0', '1', 'platform:menu:remove', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    257. 

  257. INSERT INTO `platform_menu` VALUES ('7890678967976856', '租户修改', '2346345634563456', 3, '#', '', 'F', '0', '1', 'platform:tenant:edit', '#', 'admin', '2021-07-03 17:35:54', '', NULL, '');
    258. 

  258. INSERT INTO `platform_menu` VALUES ('7967856734356235', '租户导出', '2346345634563456', 5, '#', '', 'F', '0', '1', 'platform:tenant:export', '#', 'admin', '2021-07-03 17:35:54', '', NULL, '');
    259. 

  259. 

  260. -- ----------------------------
    261. 

  261. -- Table structure for platform_notice
    262. 

  262. -- ----------------------------
    263. 

  263. DROP TABLE IF EXISTS `platform_notice`;
    264. 

  264. CREATE TABLE `platform_notice`  (
    265. 

  265.   `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '公告ID',
    266. 

  266.   `notice_title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '公告标题',
    267. 

  267.   `notice_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '公告类型（1通知 2公告）',
    268. 

  268.   `notice_content` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '公告内容',
    269. 

  269.   `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '公告状态（0正常 1关闭）',
    270. 

  270.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
    271. 

  271.   `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    272. 

  272.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
    273. 

  273.   `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
    274. 

  274.   `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
    275. 

  275.   PRIMARY KEY (`id`) USING BTREE
    276. 

  276. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '通知公告表' ROW_FORMAT = Dynamic;
    277. 

  277. 

  278. -- ----------------------------
    279. 

  279. -- Records of platform_notice
    280. 

  280. -- ----------------------------
    281. 

  281. 

  282. -- ----------------------------
    283. 

  283. -- Table structure for platform_oper_log
    284. 

  284. -- ----------------------------
    285. 

  285. DROP TABLE IF EXISTS `platform_oper_log`;
    286. 

  286. CREATE TABLE `platform_oper_log`  (
    287. 

  287.   `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '日志主键',
    288. 

  288.   `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '模块标题',
    289. 

  289.   `business_type` int(2) NULL DEFAULT 0 COMMENT '业务类型（0其它 1新增 2修改 3删除）',
    290. 

  290.   `method` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '方法名称',
    291. 

  291.   `request_method` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '请求方式',
    292. 

  292.   `operator_type` int(1) NULL DEFAULT 0 COMMENT '操作类别（0其它 1后台用户 2手机端用户）',
    293. 

  293.   `oper_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '操作人员',
    294. 

  294.   `dept_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '部门名称',
    295. 

  295.   `oper_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '请求URL',
    296. 

  296.   `oper_ip` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '主机地址',
    297. 

  297.   `oper_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '操作地点',
    298. 

  298.   `oper_param` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '请求参数',
    299. 

  299.   `json_result` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '返回参数',
    300. 

  300.   `status` int(1) NULL DEFAULT 0 COMMENT '操作状态（0正常 1异常）',
    301. 

  301.   `error_msg` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '错误消息',
    302. 

  302.   `oper_time` datetime(0) NULL DEFAULT NULL COMMENT '操作时间',
    303. 

  303.   PRIMARY KEY (`id`) USING BTREE
    304. 

  304. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '操作日志记录' ROW_FORMAT = Dynamic;
    305. 

  305. 

  306. -- ----------------------------
    307. 

  307. -- Records of platform_oper_log
    308. 

  308. -- ----------------------------
    309. 

  309. 

  310. -- ----------------------------
    311. 

  311. -- Table structure for platform_post
    312. 

  312. -- ----------------------------
    313. 

  313. DROP TABLE IF EXISTS `platform_post`;
    314. 

  314. CREATE TABLE `platform_post`  (
    315. 

  315.   `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '岗位ID',
    316. 

  316.   `post_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '岗位编码',
    317. 

  317.   `post_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '岗位名称',
    318. 

  318.   `post_sort` int(4) NOT NULL COMMENT '显示顺序',
    319. 

  319.   `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '状态（0正常 1停用）',
    320. 

  320.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
    321. 

  321.   `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    322. 

  322.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
    323. 

  323.   `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
    324. 

  324.   `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
    325. 

  325.   PRIMARY KEY (`id`) USING BTREE
    326. 

  326. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '岗位信息表' ROW_FORMAT = Dynamic;
    327. 

  327. 

  328. -- ----------------------------
    329. 

  329. -- Records of platform_post
    330. 

  330. -- ----------------------------
    331. 

  331. 

  332. -- ----------------------------
    333. 

  333. -- Table structure for platform_role
    334. 

  334. -- ----------------------------
    335. 

  335. DROP TABLE IF EXISTS `platform_role`;
    336. 

  336. CREATE TABLE `platform_role`  (
    337. 

  337.   `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色ID',
    338. 

  338.   `role_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色名称',
    339. 

  339.   `role_key` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色权限字符串',
    340. 

  340.   `role_sort` int(4) NOT NULL COMMENT '显示顺序',
    341. 

  341.   `data_scope` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '1' COMMENT '数据范围（1：全部数据权限 2：自定数据权限 3：本部门数据权限 4：本部门及以下数据权限）',
    342. 

  342.   `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色状态（0正常 1停用）',
    343. 

  343.   `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
    344. 

  344.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
    345. 

  345.   `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    346. 

  346.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
    347. 

  347.   `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
    348. 

  348.   `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
    349. 

  349.   PRIMARY KEY (`id`) USING BTREE
    350. 

  350. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '角色信息表' ROW_FORMAT = Dynamic;
    351. 

  351. 

  352. -- ----------------------------
    353. 

  353. -- Records of platform_role
    354. 

  354. -- ----------------------------
    355. 

  355. INSERT INTO `platform_role` VALUES ('674567345645676783889', '超级管理员', 'platform_admin', 1, '1', '0', '0', 'admin', '2021-05-26 15:36:20', '', NULL, '超级管理员');
    356. 

  356. 

  357. -- ----------------------------
    358. 

  358. -- Table structure for platform_role_dept
    359. 

  359. -- ----------------------------
    360. 

  360. DROP TABLE IF EXISTS `platform_role_dept`;
    361. 

  361. CREATE TABLE `platform_role_dept`  (
    362. 

  362.   `role_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色ID',
    363. 

  363.   `dept_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '部门ID',
    364. 

  364.   PRIMARY KEY (`role_id`, `dept_id`) USING BTREE
    365. 

  365. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '角色和部门关联表' ROW_FORMAT = Dynamic;
    366. 

  366. 

  367. -- ----------------------------
    368. 

  368. -- Records of platform_role_dept
    369. 

  369. -- ----------------------------
    370. 

  370. 

  371. -- ----------------------------
    372. 

  372. -- Table structure for platform_role_menu
    373. 

  373. -- ----------------------------
    374. 

  374. DROP TABLE IF EXISTS `platform_role_menu`;
    375. 

  375. CREATE TABLE `platform_role_menu`  (
    376. 

  376.   `role_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色ID',
    377. 

  377.   `menu_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '菜单ID',
    378. 

  378.   PRIMARY KEY (`role_id`, `menu_id`) USING BTREE
    379. 

  379. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '角色和菜单关联表' ROW_FORMAT = Dynamic;
    380. 

  380. 

  381. -- ----------------------------
    382. 

  382. -- Records of platform_role_menu
    383. 

  383. -- ----------------------------
    384. 

  384. 

  385. -- ----------------------------
    386. 

  386. -- Table structure for platform_tenant
    387. 

  387. -- ----------------------------
    388. 

  388. DROP TABLE IF EXISTS `platform_tenant`;
    389. 

  389. CREATE TABLE `platform_tenant`  (
    390. 

  390.   `id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'id',
    391. 

  391.   `tenant_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '租户名称',
    392. 

  392.   `tenant_no` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '租户编号',
    393. 

  393.   `logo_url` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户logo',
    394. 

  394.   `status` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '租户状态（0正常 1停用）',
    395. 

  395.   `remark` varchar(1500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
    396. 

  396.   `start_date` datetime(0) NULL DEFAULT NULL COMMENT '租户系统开始时间',
    397. 

  397.   `end_date` datetime(0) NULL DEFAULT NULL COMMENT '租户系统到期时间',
    398. 

  398.   `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建者',
    399. 

  399.   `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    400. 

  400.   `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '更新者',
    401. 

  401.   `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
    402. 

  402.   PRIMARY KEY (`id`) USING BTREE
    403. 

  403. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '租户表' ROW_FORMAT = Dynamic;
    404. 

  404. 

  405. -- ----------------------------
    406. 

  406. -- Records of platform_tenant
    407. 

  407. -- ----------------------------
    408. 

  408. INSERT INTO `platform_tenant` VALUES ('1411258341581467649', '一号租户', '0000000001', '', '0', '', '2021-08-04 00:00:00', '2050-03-07 00:00:00', 'admin', '2021-07-03 17:39:43', 'admin', '2021-08-12 20:25:33');
    409. 

  409. 

  410. -- ----------------------------
    411. 

  411. -- Table structure for platform_user
    412. 

  412. -- ----------------------------
    413. 

  413. DROP TABLE IF EXISTS `platform_user`;
    414. 

  414. CREATE TABLE `platform_user`  (
    415. 

  415.   `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户ID',
    416. 

  416.   `dept_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '部门ID',
    417. 

  417.   `login_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '登录账号',
    418. 

  418.   `user_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '用户昵称',
    419. 

  419.   `user_type` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '00' COMMENT '用户类型（00系统用户）',
    420. 

  420.   `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '用户邮箱',
    421. 

  421.   `phonenumber` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '手机号码',
    422. 

  422.   `sex` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '用户性别（0男 1女 2未知）',
    423. 

  423.   `avatar` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '头像路径',
    424. 

  424.   `password` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '密码',
    425. 

  425.   `salt` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '盐加密',
    426. 

  426.   `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '帐号状态（0正常 1停用）',
    427. 

  427.   `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
    428. 

  428.   `login_ip` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '最后登录IP',
    429. 

  429.   `login_date` datetime(0) NULL DEFAULT NULL COMMENT '最后登录时间',
    430. 

  430.   `pwd_update_date` datetime(0) NULL DEFAULT NULL COMMENT '密码最后更新时间',
    431. 

  431.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
    432. 

  432.   `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    433. 

  433.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
    434. 

  434.   `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
    435. 

  435.   `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
    436. 

  436.   PRIMARY KEY (`id`) USING BTREE
    437. 

  437. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户信息表' ROW_FORMAT = Dynamic;
    438. 

  438. 

  439. -- ----------------------------
    440. 

  440. -- Records of platform_user
    441. 

  441. -- ----------------------------
    442. 

  442. INSERT INTO `platform_user` VALUES ('54634575686785679498', '89678424698023676', 'admin', '圣钰-平台管理员', 'yb', 'ruoyi@163.com', '15888888888', '1', '', '29c67a30398638269fe600f73a054934', '111111', '0', '0', '127.0.0.1', '2021-08-20 22:49:06', '2021-05-26 15:36:20', 'admin', '2021-05-26 15:36:20', 'ruoyi-system', '2021-08-20 22:49:06', '管理员');
    443. 

  443. 

  444. -- ----------------------------
    445. 

  445. -- Table structure for platform_user_online
    446. 

  446. -- ----------------------------
    447. 

  447. DROP TABLE IF EXISTS `platform_user_online`;
    448. 

  448. CREATE TABLE `platform_user_online`  (
    449. 

  449.   `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用户会话id',
    450. 

  450.   `login_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '登录账号',
    451. 

  451.   `dept_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '部门名称',
    452. 

  452.   `ipaddr` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '登录IP地址',
    453. 

  453.   `login_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '登录地点',
    454. 

  454.   `browser` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '浏览器类型',
    455. 

  455.   `os` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '操作系统',
    456. 

  456.   `status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '在线状态on_line在线off_line离线',
    457. 

  457.   `start_timestamp` datetime(0) NULL DEFAULT NULL COMMENT 'session创建时间',
    458. 

  458.   `last_access_time` datetime(0) NULL DEFAULT NULL COMMENT 'session最后访问时间',
    459. 

  459.   `expire_time` int(5) NULL DEFAULT 0 COMMENT '超时时间，单位为分钟',
    460. 

  460.   PRIMARY KEY (`id`) USING BTREE
    461. 

  461. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '在线用户记录' ROW_FORMAT = Dynamic;
    462. 

  462. 

  463. -- ----------------------------
    464. 

  464. -- Records of platform_user_online
    465. 

  465. -- ----------------------------
    466. 

  466. 

  467. -- ----------------------------
    468. 

  468. -- Table structure for platform_user_post
    469. 

  469. -- ----------------------------
    470. 

  470. DROP TABLE IF EXISTS `platform_user_post`;
    471. 

  471. CREATE TABLE `platform_user_post`  (
    472. 

  472.   `user_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户ID',
    473. 

  473.   `post_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '岗位ID',
    474. 

  474.   PRIMARY KEY (`user_id`, `post_id`) USING BTREE
    475. 

  475. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户与岗位关联表' ROW_FORMAT = Dynamic;
    476. 

  476. 

  477. -- ----------------------------
    478. 

  478. -- Records of platform_user_post
    479. 

  479. -- ----------------------------
    480. 

  480. 

  481. -- ----------------------------
    482. 

  482. -- Table structure for platform_user_role
    483. 

  483. -- ----------------------------
    484. 

  484. DROP TABLE IF EXISTS `platform_user_role`;
    485. 

  485. CREATE TABLE `platform_user_role`  (
    486. 

  486.   `user_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户ID',
    487. 

  487.   `role_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色ID',
    488. 

  488.   PRIMARY KEY (`user_id`, `role_id`) USING BTREE
    489. 

  489. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户和角色关联表' ROW_FORMAT = Dynamic;
    490. 

  490. 

  491. -- ----------------------------
    492. 

  492. -- Records of platform_user_role
    493. 

  493. -- ----------------------------
    494. 

  494. INSERT INTO `platform_user_role` VALUES ('54634575686785679498', '674567345645676783889');
    495. 

  495. 

  496. -- ----------------------------
    497. 

  497. -- Table structure for sys_config
    498. 

  498. -- ----------------------------
    499. 

  499. DROP TABLE IF EXISTS `sys_config`;
    500. 

  500. CREATE TABLE `sys_config`  (
    501. 

  501.   `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '参数主键',
    502. 

  502.   `config_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '参数名称',
    503. 

  503.   `config_key` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '参数键名',
    504. 

  504.   `config_value` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '参数键值',
    505. 

  505.   `config_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'N' COMMENT '系统内置（Y是 N否）',
    506. 

  506.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
    507. 

  507.   `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    508. 

  508.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
    509. 

  509.   `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
    510. 

  510.   `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
    511. 

  511.   PRIMARY KEY (`id`) USING BTREE
    512. 

  512. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '参数配置表' ROW_FORMAT = Dynamic;
    513. 

  513. 

  514. -- ----------------------------
    515. 

  515. -- Records of sys_config
    516. 

  516. -- ----------------------------
    517. 

  517. INSERT INTO `sys_config` VALUES ('1', '主框架页-默认皮肤样式名称', 'sys.index.skinName', 'skin-blue', 'Y', 'admin', '2021-05-26 15:36:21', '', NULL, '蓝色 skin-blue、绿色 skin-green、紫色 skin-purple、红色 skin-red、黄色 skin-yellow');
    518. 

  518. INSERT INTO `sys_config` VALUES ('2', '用户管理-账号初始密码', 'sys.user.initPassword', '123456', 'Y', 'admin', '2021-05-26 15:36:21', '', NULL, '初始化密码 123456');
    519. 

  519. INSERT INTO `sys_config` VALUES ('3', '主框架页-侧边栏主题', 'sys.index.sideTheme', 'theme-dark', 'Y', 'admin', '2021-05-26 15:36:21', '', NULL, '深黑主题theme-dark，浅色主题theme-light，深蓝主题theme-blue');
    520. 

  520. INSERT INTO `sys_config` VALUES ('4', '账号自助-是否开启用户注册功能', 'sys.account.registerUser', 'false', 'Y', 'admin', '2021-05-26 15:36:21', '', NULL, '是否开启注册用户功能（true开启，false关闭）');
    521. 

  521. INSERT INTO `sys_config` VALUES ('5', '用户管理-密码字符范围', 'sys.account.chrtype', '0', 'Y', 'admin', '2021-05-26 15:36:21', '', NULL, '默认任意字符范围，0任意（密码可以输入任意字符），1数字（密码只能为0-9数字），2英文字母（密码只能为a-z和A-Z字母），3字母和数字（密码必须包含字母，数字）,4字母数字和特殊字符（目前支持的特殊字符包括：~!@#$%^&*()-=_+）');
    522. 

  522. INSERT INTO `sys_config` VALUES ('6', '用户管理-初始密码修改策略', 'sys.account.initPasswordModify', '0', 'Y', 'admin', '2021-05-26 15:36:21', '', NULL, '0：初始密码修改策略关闭，没有任何提示，1：提醒用户，如果未修改初始密码，则在登录时就会提醒修改密码对话框');
    523. 

  523. INSERT INTO `sys_config` VALUES ('7', '用户管理-账号密码更新周期', 'sys.account.passwordValidateDays', '0', 'Y', 'admin', '2021-05-26 15:36:21', '', NULL, '密码更新周期（填写数字，数据初始化值为0不限制，若修改必须为大于0小于365的正整数），如果超过这个周期登录系统时，则在登录时就会提醒修改密码对话框');
    524. 

  524. INSERT INTO `sys_config` VALUES ('8', '主框架页-菜单导航显示风格', 'sys.index.menuStyle', 'default', 'Y', 'admin', '2021-05-26 15:36:21', '', NULL, '菜单导航显示风格（default为左侧导航菜单，topnav为顶部导航菜单）');
    525. 

  525. INSERT INTO `sys_config` VALUES ('9', '主框架页-是否开启页脚', 'sys.index.ignoreFooter', 'true', 'Y', 'admin', '2021-05-26 15:36:21', '', NULL, '是否开启底部页脚显示（true显示，false隐藏）');
    526. 

  526. 

  527. -- ----------------------------
    528. 

  528. -- Table structure for sys_dept
    529. 

  529. -- ----------------------------
    530. 

  530. DROP TABLE IF EXISTS `sys_dept`;
    531. 

  531. CREATE TABLE `sys_dept`  (
    532. 

  532.   `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '部门id',
    533. 

  533.   `parent_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '父部门id',
    534. 

  534.   `ancestors` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '祖级列表',
    535. 

  535.   `dept_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '部门名称',
    536. 

  536.   `dept_type` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '部门类型',
    537. 

  537.   `order_num` int(4) NULL DEFAULT 0 COMMENT '显示顺序',
    538. 

  538.   `leader` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '负责人',
    539. 

  539.   `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '联系电话',
    540. 

  540.   `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '邮箱',
    541. 

  541.   `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '部门状态（0正常 1停用）',
    542. 

  542.   `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
    543. 

  543.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
    544. 

  544.   `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    545. 

  545.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
    546. 

  546.   `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
    547. 

  547.   `tenant_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '租户id',
    548. 

  548.   PRIMARY KEY (`id`) USING BTREE
    549. 

  549. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '部门表' ROW_FORMAT = Dynamic;
    550. 

  550. 

  551. -- ----------------------------
    552. 

  552. -- Records of sys_dept
    553. 

  553. -- ----------------------------
    554. 

  554. INSERT INTO `sys_dept` VALUES ('567456834562247092', '0', '0', '圣钰SaaS科技', 'yb', 0, 'admin', '15888888888', 'ruoyi@qq.com', '0', '0', 'admin', '2021-05-26 15:36:20', 'admin', '2021-08-20 22:06:29', '1411258341581467649');
    555. 

  555. 

  556. -- ----------------------------
    557. 

  557. -- Table structure for sys_dict_data
    558. 

  558. -- ----------------------------
    559. 

  559. DROP TABLE IF EXISTS `sys_dict_data`;
    560. 

  560. CREATE TABLE `sys_dict_data`  (
    561. 

  561.   `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '字典编码',
    562. 

  562.   `dict_sort` int(4) NULL DEFAULT 0 COMMENT '字典排序',
    563. 

  563.   `dict_label` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '字典标签',
    564. 

  564.   `dict_value` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '字典键值',
    565. 

  565.   `dict_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '字典类型',
    566. 

  566.   `css_class` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '样式属性（其他样式扩展）',
    567. 

  567.   `list_class` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '表格回显样式',
    568. 

  568.   `is_default` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'N' COMMENT '是否默认（Y是 N否）',
    569. 

  569.   `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '状态（0正常 1停用）',
    570. 

  570.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
    571. 

  571.   `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    572. 

  572.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
    573. 

  573.   `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
    574. 

  574.   `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
    575. 

  575.   PRIMARY KEY (`id`) USING BTREE
    576. 

  576. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '字典数据表' ROW_FORMAT = Dynamic;
    577. 

  577. 

  578. -- ----------------------------
    579. 

  579. -- Records of sys_dict_data
    580. 

  580. -- ----------------------------
    581. 

  581. INSERT INTO `sys_dict_data` VALUES ('1', 1, '男', '0', 'sys_user_sex', '', '', 'Y', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '性别男');
    582. 

  582. INSERT INTO `sys_dict_data` VALUES ('10', 1, '默认', 'DEFAULT', 'sys_job_group', '', '', 'Y', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '默认分组');
    583. 

  583. INSERT INTO `sys_dict_data` VALUES ('11', 2, '系统', 'SYSTEM', 'sys_job_group', '', '', 'N', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '系统分组');
    584. 

  584. INSERT INTO `sys_dict_data` VALUES ('12', 1, '是', 'Y', 'sys_yes_no', '', 'primary', 'Y', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '系统默认是');
    585. 

  585. INSERT INTO `sys_dict_data` VALUES ('13', 2, '否', 'N', 'sys_yes_no', '', 'danger', 'N', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '系统默认否');
    586. 

  586. INSERT INTO `sys_dict_data` VALUES ('14', 1, '通知', '1', 'sys_notice_type', '', 'warning', 'Y', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '通知');
    587. 

  587. INSERT INTO `sys_dict_data` VALUES ('15', 2, '公告', '2', 'sys_notice_type', '', 'success', 'N', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '公告');
    588. 

  588. INSERT INTO `sys_dict_data` VALUES ('16', 1, '正常', '0', 'sys_notice_status', '', 'primary', 'Y', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '正常状态');
    589. 

  589. INSERT INTO `sys_dict_data` VALUES ('17', 2, '关闭', '1', 'sys_notice_status', '', 'danger', 'N', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '关闭状态');
    590. 

  590. INSERT INTO `sys_dict_data` VALUES ('18', 99, '其他', '0', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '其他操作');
    591. 

  591. INSERT INTO `sys_dict_data` VALUES ('19', 1, '新增', '1', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '新增操作');
    592. 

  592. INSERT INTO `sys_dict_data` VALUES ('2', 2, '女', '1', 'sys_user_sex', '', '', 'N', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '性别女');
    593. 

  593. INSERT INTO `sys_dict_data` VALUES ('20', 2, '修改', '2', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '修改操作');
    594. 

  594. INSERT INTO `sys_dict_data` VALUES ('21', 3, '删除', '3', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '删除操作');
    595. 

  595. INSERT INTO `sys_dict_data` VALUES ('22', 4, '授权', '4', 'sys_oper_type', '', 'primary', 'N', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '授权操作');
    596. 

  596. INSERT INTO `sys_dict_data` VALUES ('23', 5, '导出', '5', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '导出操作');
    597. 

  597. INSERT INTO `sys_dict_data` VALUES ('24', 6, '导入', '6', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '导入操作');
    598. 

  598. INSERT INTO `sys_dict_data` VALUES ('25', 7, '强退', '7', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '强退操作');
    599. 

  599. INSERT INTO `sys_dict_data` VALUES ('26', 8, '生成代码', '8', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '生成操作');
    600. 

  600. INSERT INTO `sys_dict_data` VALUES ('27', 9, '清空数据', '9', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '清空操作');
    601. 

  601. INSERT INTO `sys_dict_data` VALUES ('28', 1, '成功', '0', 'sys_common_status', '', 'primary', 'N', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '正常状态');
    602. 

  602. INSERT INTO `sys_dict_data` VALUES ('29', 2, '失败', '1', 'sys_common_status', '', 'danger', 'N', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '停用状态');
    603. 

  603. INSERT INTO `sys_dict_data` VALUES ('3', 3, '未知', '2', 'sys_user_sex', '', '', 'N', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '性别未知');
    604. 

  604. INSERT INTO `sys_dict_data` VALUES ('4', 1, '显示', '0', 'sys_show_hide', '', 'primary', 'Y', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '显示菜单');
    605. 

  605. INSERT INTO `sys_dict_data` VALUES ('5', 2, '隐藏', '1', 'sys_show_hide', '', 'danger', 'N', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '隐藏菜单');
    606. 

  606. INSERT INTO `sys_dict_data` VALUES ('6', 1, '正常', '0', 'sys_normal_disable', '', 'primary', 'Y', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '正常状态');
    607. 

  607. INSERT INTO `sys_dict_data` VALUES ('7', 2, '停用', '1', 'sys_normal_disable', '', 'danger', 'N', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '停用状态');
    608. 

  608. INSERT INTO `sys_dict_data` VALUES ('8', 1, '正常', '0', 'sys_job_status', '', 'primary', 'Y', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '正常状态');
    609. 

  609. INSERT INTO `sys_dict_data` VALUES ('9', 2, '暂停', '1', 'sys_job_status', '', 'danger', 'N', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '停用状态');
    610. 

  610. 

  611. -- ----------------------------
    612. 

  612. -- Table structure for sys_dict_type
    613. 

  613. -- ----------------------------
    614. 

  614. DROP TABLE IF EXISTS `sys_dict_type`;
    615. 

  615. CREATE TABLE `sys_dict_type`  (
    616. 

  616.   `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '字典主键',
    617. 

  617.   `dict_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '字典名称',
    618. 

  618.   `dict_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '字典类型',
    619. 

  619.   `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '状态（0正常 1停用）',
    620. 

  620.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
    621. 

  621.   `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    622. 

  622.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
    623. 

  623.   `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
    624. 

  624.   `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
    625. 

  625.   PRIMARY KEY (`id`) USING BTREE,
    626. 

  626.   UNIQUE INDEX `dict_type`(`dict_type`) USING BTREE
    627. 

  627. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '字典类型表' ROW_FORMAT = Dynamic;
    628. 

  628. 

  629. -- ----------------------------
    630. 

  630. -- Records of sys_dict_type
    631. 

  631. -- ----------------------------
    632. 

  632. INSERT INTO `sys_dict_type` VALUES ('1', '用户性别', 'sys_user_sex', '0', 'admin', '2021-05-26 15:36:20', '', NULL, '用户性别列表');
    633. 

  633. INSERT INTO `sys_dict_type` VALUES ('10', '系统状态', 'sys_common_status', '0', 'admin', '2021-05-26 15:36:20', '', NULL, '登录状态列表');
    634. 

  634. INSERT INTO `sys_dict_type` VALUES ('1422742173800628226', '完成状态', 'accomplish_status', '0', 'admin', '2021-08-04 10:12:22', 'admin', '2021-08-04 10:12:22', '');
    635. 

  635. INSERT INTO `sys_dict_type` VALUES ('2', '菜单状态', 'sys_show_hide', '0', 'admin', '2021-05-26 15:36:20', '', NULL, '菜单状态列表');
    636. 

  636. INSERT INTO `sys_dict_type` VALUES ('3', '系统开关', 'sys_normal_disable', '0', 'admin', '2021-05-26 15:36:20', '', NULL, '系统开关列表');
    637. 

  637. INSERT INTO `sys_dict_type` VALUES ('4', '任务状态', 'sys_job_status', '0', 'admin', '2021-05-26 15:36:20', '', NULL, '任务状态列表');
    638. 

  638. INSERT INTO `sys_dict_type` VALUES ('5', '任务分组', 'sys_job_group', '0', 'admin', '2021-05-26 15:36:20', '', NULL, '任务分组列表');
    639. 

  639. INSERT INTO `sys_dict_type` VALUES ('6', '系统是否', 'sys_yes_no', '0', 'admin', '2021-05-26 15:36:20', '', NULL, '系统是否列表');
    640. 

  640. INSERT INTO `sys_dict_type` VALUES ('7', '通知类型', 'sys_notice_type', '0', 'admin', '2021-05-26 15:36:20', '', NULL, '通知类型列表');
    641. 

  641. INSERT INTO `sys_dict_type` VALUES ('8', '通知状态', 'sys_notice_status', '0', 'admin', '2021-05-26 15:36:20', '', NULL, '通知状态列表');
    642. 

  642. INSERT INTO `sys_dict_type` VALUES ('9', '操作类型', 'sys_oper_type', '0', 'admin', '2021-05-26 15:36:20', '', NULL, '操作类型列表');
    643. 

  643. 

  644. -- ----------------------------
    645. 

  645. -- Table structure for sys_job
    646. 

  646. -- ----------------------------
    647. 

  647. DROP TABLE IF EXISTS `sys_job`;
    648. 

  648. CREATE TABLE `sys_job`  (
    649. 

  649.   `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务ID',
    650. 

  650.   `job_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '任务名称',
    651. 

  651.   `job_group` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'DEFAULT' COMMENT '任务组名',
    652. 

  652.   `invoke_target` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '调用目标字符串',
    653. 

  653.   `cron_expression` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT 'cron执行表达式',
    654. 

  654.   `misfire_policy` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '3' COMMENT '计划执行错误策略（1立即执行 2执行一次 3放弃执行）',
    655. 

  655.   `concurrent` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '1' COMMENT '是否并发执行（0允许 1禁止）',
    656. 

  656.   `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '状态（0正常 1暂停）',
    657. 

  657.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
    658. 

  658.   `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    659. 

  659.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
    660. 

  660.   `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
    661. 

  661.   `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '备注信息',
    662. 

  662.   PRIMARY KEY (`id`, `job_name`, `job_group`) USING BTREE
    663. 

  663. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '定时任务调度表' ROW_FORMAT = Dynamic;
    664. 

  664. 

  665. -- ----------------------------
    666. 

  666. -- Records of sys_job
    667. 

  667. -- ----------------------------
    668. 

  668. INSERT INTO `sys_job` VALUES ('1', '系统默认（无参）', 'DEFAULT', 'ybTask.ybNoParams', '0/10 * * * * ?', '3', '1', '1', 'admin', '2021-05-26 15:36:21', '', NULL, '');
    669. 

  669. INSERT INTO `sys_job` VALUES ('2', '系统默认（有参）', 'DEFAULT', 'ybTask.ybParams(\'yb\')', '0/15 * * * * ?', '3', '1', '1', 'admin', '2021-05-26 15:36:21', '', NULL, '');
    670. 

  670. INSERT INTO `sys_job` VALUES ('3', '系统默认（多参）', 'DEFAULT', 'ybTask.ybMultipleParams(\'yb\', true, 2000L, 316.50D, 100)', '0/20 * * * * ?', '3', '1', '1', 'admin', '2021-05-26 15:36:21', '', NULL, '');
    671. 

  671. 

  672. -- ----------------------------
    673. 

  673. -- Table structure for sys_job_log
    674. 

  674. -- ----------------------------
    675. 

  675. DROP TABLE IF EXISTS `sys_job_log`;
    676. 

  676. CREATE TABLE `sys_job_log`  (
    677. 

  677.   `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务日志ID',
    678. 

  678.   `job_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务名称',
    679. 

  679.   `job_group` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务组名',
    680. 

  680.   `invoke_target` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '调用目标字符串',
    681. 

  681.   `job_message` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '日志信息',
    682. 

  682.   `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '执行状态（0正常 1失败）',
    683. 

  683.   `exception_info` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '异常信息',
    684. 

  684.   `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    685. 

  685.   PRIMARY KEY (`id`) USING BTREE
    686. 

  686. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '定时任务调度日志表' ROW_FORMAT = Dynamic;
    687. 

  687. 

  688. -- ----------------------------
    689. 

  689. -- Records of sys_job_log
    690. 

  690. -- ----------------------------
    691. 

  691. 

  692. -- ----------------------------
    693. 

  693. -- Table structure for sys_logininfor
    694. 

  694. -- ----------------------------
    695. 

  695. DROP TABLE IF EXISTS `sys_logininfor`;
    696. 

  696. CREATE TABLE `sys_logininfor`  (
    697. 

  697.   `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '访问ID',
    698. 

  698.   `login_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '登录账号',
    699. 

  699.   `ipaddr` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '登录IP地址',
    700. 

  700.   `login_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '登录地点',
    701. 

  701.   `browser` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '浏览器类型',
    702. 

  702.   `os` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '操作系统',
    703. 

  703.   `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '登录状态（0成功 1失败）',
    704. 

  704.   `msg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '提示消息',
    705. 

  705.   `login_time` datetime(0) NULL DEFAULT NULL COMMENT '访问时间',
    706. 

  706.   `tenant_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '租户id',
    707. 

  707.   PRIMARY KEY (`id`) USING BTREE
    708. 

  708. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统访问记录' ROW_FORMAT = Dynamic;
    709. 

  709. 

  710. -- ----------------------------
    711. 

  711. -- Records of sys_logininfor
    712. 

  712. -- ----------------------------
    713. 

  713. 

  714. -- ----------------------------
    715. 

  715. -- Table structure for sys_menu
    716. 

  716. -- ----------------------------
    717. 

  717. DROP TABLE IF EXISTS `sys_menu`;
    718. 

  718. CREATE TABLE `sys_menu`  (
    719. 

  719.   `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '菜单ID',
    720. 

  720.   `menu_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '菜单名称',
    721. 

  721.   `parent_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '父菜单ID',
    722. 

  722.   `order_num` int(4) NULL DEFAULT 0 COMMENT '显示顺序',
    723. 

  723.   `url` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '#' COMMENT '请求地址',
    724. 

  724.   `target` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '打开方式（menuItem页签 menuBlank新窗口）',
    725. 

  725.   `menu_c_type` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '00' COMMENT '菜单使用类型\r\n00   基本菜单（租户拥有的最基础的菜单，租户永久拥有）\r\n01   免费赠送菜单（以订单收费为0的形式赠送，收回的话直接修改订单）\r\n02   付费菜单（租户购买之后，有效期之内可以任意使用）',
    726. 

  726.   `menu_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '菜单类型（M目录 C菜单 F按钮）',
    727. 

  727.   `visible` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '菜单状态（0显示 1隐藏）',
    728. 

  728.   `is_refresh` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '1' COMMENT '是否刷新（0刷新 1不刷新）',
    729. 

  729.   `perms` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '权限标识',
    730. 

  730.   `icon` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '#' COMMENT '菜单图标',
    731. 

  731.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
    732. 

  732.   `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    733. 

  733.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
    734. 

  734.   `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
    735. 

  735.   `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '备注',
    736. 

  736.   PRIMARY KEY (`id`) USING BTREE
    737. 

  737. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '菜单权限表' ROW_FORMAT = Dynamic;
    738. 

  738. 

  739. -- ----------------------------
    740. 

  740. -- Records of sys_menu
    741. 

  741. -- ----------------------------
    742. 

  742. INSERT INTO `sys_menu` VALUES ('1', '系统管理', '0', 1, '#', '', '00', 'M', '0', '1', '', 'fa fa-gear', 'admin', '2021-05-26 15:36:20', '', NULL, '系统管理目录');
    743. 

  743. INSERT INTO `sys_menu` VALUES ('100', '用户管理', '1', 1, '/system/user', '', '00', 'C', '0', '1', 'system:user:view', 'fa fa-user-o', 'admin', '2021-05-26 15:36:20', '', NULL, '用户管理菜单');
    744. 

  744. INSERT INTO `sys_menu` VALUES ('1000', '用户查询', '100', 1, '#', '', '00', 'F', '0', '1', 'system:user:list', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    745. 

  745. INSERT INTO `sys_menu` VALUES ('1001', '用户新增', '100', 2, '#', '', '00', 'F', '0', '1', 'system:user:add', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    746. 

  746. INSERT INTO `sys_menu` VALUES ('1002', '用户修改', '100', 3, '#', '', '00', 'F', '0', '1', 'system:user:edit', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    747. 

  747. INSERT INTO `sys_menu` VALUES ('1003', '用户删除', '100', 4, '#', '', '00', 'F', '0', '1', 'system:user:remove', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    748. 

  748. INSERT INTO `sys_menu` VALUES ('1004', '用户导出', '100', 5, '#', '', '00', 'F', '0', '1', 'system:user:export', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    749. 

  749. INSERT INTO `sys_menu` VALUES ('1005', '用户导入', '100', 6, '#', '', '00', 'F', '0', '1', 'system:user:import', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    750. 

  750. INSERT INTO `sys_menu` VALUES ('1006', '重置密码', '100', 7, '#', '', '00', 'F', '0', '1', 'system:user:resetPwd', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    751. 

  751. INSERT INTO `sys_menu` VALUES ('1007', '角色查询', '101', 1, '#', '', '00', 'F', '0', '1', 'system:role:list', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    752. 

  752. INSERT INTO `sys_menu` VALUES ('1008', '角色新增', '101', 2, '#', '', '00', 'F', '0', '1', 'system:role:add', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    753. 

  753. INSERT INTO `sys_menu` VALUES ('1009', '角色修改', '101', 3, '#', '', '00', 'F', '0', '1', 'system:role:edit', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    754. 

  754. INSERT INTO `sys_menu` VALUES ('101', '内部角色', '1426117002031804417', 1, '/system/role', 'menuItem', '00', 'C', '0', '1', 'system:role:view', 'fa fa-user-secret', 'admin', '2021-05-26 15:36:20', 'admin', '2021-08-13 17:46:14', '角色管理菜单');
    755. 

  755. INSERT INTO `sys_menu` VALUES ('1010', '角色删除', '101', 4, '#', '', '00', 'F', '0', '1', 'system:role:remove', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    756. 

  756. INSERT INTO `sys_menu` VALUES ('1011', '角色导出', '101', 5, '#', '', '00', 'F', '0', '1', 'system:role:export', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    757. 

  757. INSERT INTO `sys_menu` VALUES ('1016', '部门查询', '103', 1, '#', '', '00', 'F', '0', '1', 'system:dept:list', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    758. 

  758. INSERT INTO `sys_menu` VALUES ('1017', '部门新增', '103', 2, '#', '', '00', 'F', '0', '1', 'system:dept:add', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    759. 

  759. INSERT INTO `sys_menu` VALUES ('1018', '部门修改', '103', 3, '#', '', '00', 'F', '0', '1', 'system:dept:edit', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    760. 

  760. INSERT INTO `sys_menu` VALUES ('1019', '部门删除', '103', 4, '#', '', '00', 'F', '0', '1', 'system:dept:remove', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    761. 

  761. INSERT INTO `sys_menu` VALUES ('1020', '岗位查询', '104', 1, '#', '', '00', 'F', '0', '1', 'system:post:list', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    762. 

  762. INSERT INTO `sys_menu` VALUES ('1021', '岗位新增', '104', 2, '#', '', '00', 'F', '0', '1', 'system:post:add', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    763. 

  763. INSERT INTO `sys_menu` VALUES ('1022', '岗位修改', '104', 3, '#', '', '00', 'F', '0', '1', 'system:post:edit', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    764. 

  764. INSERT INTO `sys_menu` VALUES ('1023', '岗位删除', '104', 4, '#', '', '00', 'F', '0', '1', 'system:post:remove', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    765. 

  765. INSERT INTO `sys_menu` VALUES ('1024', '岗位导出', '104', 5, '#', '', '00', 'F', '0', '1', 'system:post:export', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    766. 

  766. INSERT INTO `sys_menu` VALUES ('103', '部门管理', '1', 4, '/system/dept', '', '00', 'C', '0', '1', 'system:dept:view', 'fa fa-outdent', 'admin', '2021-05-26 15:36:20', '', NULL, '部门管理菜单');
    767. 

  767. INSERT INTO `sys_menu` VALUES ('1035', '公告查询', '107', 1, '#', '', '00', 'F', '0', '1', 'system:notice:list', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    768. 

  768. INSERT INTO `sys_menu` VALUES ('1036', '公告新增', '107', 2, '#', '', '00', 'F', '0', '1', 'system:notice:add', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    769. 

  769. INSERT INTO `sys_menu` VALUES ('1037', '公告修改', '107', 3, '#', '', '00', 'F', '0', '1', 'system:notice:edit', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    770. 

  770. INSERT INTO `sys_menu` VALUES ('1038', '公告删除', '107', 4, '#', '', '00', 'F', '0', '1', 'system:notice:remove', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    771. 

  771. INSERT INTO `sys_menu` VALUES ('1039', '操作查询', '500', 1, '#', '', '00', 'F', '0', '1', 'monitor:operlog:list', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    772. 

  772. INSERT INTO `sys_menu` VALUES ('104', '岗位管理', '1', 5, '/system/post', '', '00', 'C', '0', '1', 'system:post:view', 'fa fa-address-card-o', 'admin', '2021-05-26 15:36:20', '', NULL, '岗位管理菜单');
    773. 

  773. INSERT INTO `sys_menu` VALUES ('1040', '操作删除', '500', 2, '#', '', '00', 'F', '0', '1', 'monitor:operlog:remove', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    774. 

  774. INSERT INTO `sys_menu` VALUES ('1041', '详细信息', '500', 3, '#', '', '00', 'F', '0', '1', 'monitor:operlog:detail', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    775. 

  775. INSERT INTO `sys_menu` VALUES ('1042', '日志导出', '500', 4, '#', '', '00', 'F', '0', '1', 'monitor:operlog:export', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    776. 

  776. INSERT INTO `sys_menu` VALUES ('1043', '登录查询', '501', 1, '#', '', '00', 'F', '0', '1', 'monitor:logininfor:list', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    777. 

  777. INSERT INTO `sys_menu` VALUES ('1044', '登录删除', '501', 2, '#', '', '00', 'F', '0', '1', 'monitor:logininfor:remove', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    778. 

  778. INSERT INTO `sys_menu` VALUES ('1045', '日志导出', '501', 3, '#', '', '00', 'F', '0', '1', 'monitor:logininfor:export', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    779. 

  779. INSERT INTO `sys_menu` VALUES ('1046', '账户解锁', '501', 4, '#', '', '00', 'F', '0', '1', 'monitor:logininfor:unlock', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    780. 

  780. INSERT INTO `sys_menu` VALUES ('1047', '在线查询', '109', 1, '#', '', '00', 'F', '0', '1', 'monitor:online:list', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    781. 

  781. INSERT INTO `sys_menu` VALUES ('1048', '批量强退', '109', 2, '#', '', '00', 'F', '0', '1', 'monitor:online:batchForceLogout', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    782. 

  782. INSERT INTO `sys_menu` VALUES ('1049', '单条强退', '109', 3, '#', '', '00', 'F', '0', '1', 'monitor:online:forceLogout', '#', 'admin', '2021-05-26 15:36:20', '', NULL, '');
    783. 

  783. INSERT INTO `sys_menu` VALUES ('107', '通知公告', '1', 8, '/system/notice', '', '00', 'C', '0', '1', 'system:notice:view', 'fa fa-bullhorn', 'admin', '2021-05-26 15:36:20', '', NULL, '通知公告菜单');
    784. 

  784. INSERT INTO `sys_menu` VALUES ('108', '日志管理', '1', 10, '#', '', '00', 'M', '0', '1', '', 'fa fa-pencil-square-o', 'admin', '2021-05-26 15:36:20', '', NULL, '日志管理菜单');
    785. 

  785. INSERT INTO `sys_menu` VALUES ('109', '在线用户', '1423806481886625793', 9, '/monitor/online', 'menuItem', '00', 'C', '0', '1', 'monitor:online:view', 'fa fa-user-circle', 'admin', '2021-05-26 15:36:20', 'admin', '2021-08-07 08:42:09', '在线用户菜单');
    786. 

  786. INSERT INTO `sys_menu` VALUES ('1423806481886625793', '系统监控', '0', 2, '', 'menuItem', '00', 'M', '0', '1', '', 'fa fa-video-camera', 'admin', '2021-08-07 08:41:33', 'admin', '2021-08-07 08:41:33', '');
    787. 

  787. INSERT INTO `sys_menu` VALUES ('1426117002031804417', '角色管理', '1', 2, '', 'menuItem', '00', 'M', '0', '1', '', 'fa fa-street-view', 'admin', '2021-08-13 17:42:44', 'admin', '2021-08-13 17:42:44', '');
    788. 

  788. INSERT INTO `sys_menu` VALUES ('1426117817731657730', '平台角色', '1426117002031804417', 2, '/system/pf/role', 'menuItem', '00', 'C', '0', '1', 'system:pf:role:view', 'fa fa-users', 'admin', '2021-08-13 17:45:58', 'admin', '2021-08-13 17:45:58', '');
    789. 

  789. INSERT INTO `sys_menu` VALUES ('1426118022732460033', '查询', '1426117817731657730', 1, '', 'menuItem', '00', 'F', '0', '1', 'system:pf:role:list', '', 'admin', '2021-08-13 17:46:47', 'admin', '2021-08-13 17:46:47', '');
    790. 

  790. INSERT INTO `sys_menu` VALUES ('4', '圣钰官网', '0', 4, 'https://gitee.com/jinzheyi/ruoyi-saas', 'menuBlank', '00', 'C', '0', '1', '', 'fa fa-location-arrow', 'admin', '2021-05-26 15:36:20', '', NULL, '圣钰官网地址');
    791. 

  791. INSERT INTO `sys_menu` VALUES ('500', '操作日志', '108', 1, '/monitor/operlog', '', '00', 'C', '0', '1', 'monitor:operlog:view', 'fa fa-address-book', 'admin', '2021-05-26 15:36:20', '', NULL, '操作日志菜单');
    792. 

  792. INSERT INTO `sys_menu` VALUES ('501', '登录日志', '108', 2, '/monitor/logininfor', '', '00', 'C', '0', '1', 'monitor:logininfor:view', 'fa fa-file-image-o', 'admin', '2021-05-26 15:36:20', '', NULL, '登录日志菜单');
    793. 

  793. 

  794. -- ----------------------------
    795. 

  795. -- Table structure for sys_notice
    796. 

  796. -- ----------------------------
    797. 

  797. DROP TABLE IF EXISTS `sys_notice`;
    798. 

  798. CREATE TABLE `sys_notice`  (
    799. 

  799.   `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '公告ID',
    800. 

  800.   `notice_title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '公告标题',
    801. 

  801.   `notice_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '公告类型（1通知 2公告）',
    802. 

  802.   `notice_content` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '公告内容',
    803. 

  803.   `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '公告状态（0正常 1关闭）',
    804. 

  804.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
    805. 

  805.   `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    806. 

  806.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
    807. 

  807.   `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
    808. 

  808.   `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
    809. 

  809.   `tenant_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '租户id',
    810. 

  810.   PRIMARY KEY (`id`) USING BTREE
    811. 

  811. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '通知公告表' ROW_FORMAT = Dynamic;
    812. 

  812. 

  813. -- ----------------------------
    814. 

  814. -- Records of sys_notice
    815. 

  815. -- ----------------------------
    816. 

  816. 

  817. -- ----------------------------
    818. 

  818. -- Table structure for sys_oper_log
    819. 

  819. -- ----------------------------
    820. 

  820. DROP TABLE IF EXISTS `sys_oper_log`;
    821. 

  821. CREATE TABLE `sys_oper_log`  (
    822. 

  822.   `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '日志主键',
    823. 

  823.   `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '模块标题',
    824. 

  824.   `business_type` int(2) NULL DEFAULT 0 COMMENT '业务类型（0其它 1新增 2修改 3删除）',
    825. 

  825.   `method` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '方法名称',
    826. 

  826.   `request_method` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '请求方式',
    827. 

  827.   `operator_type` int(1) NULL DEFAULT 0 COMMENT '操作类别（0其它 1后台用户 2手机端用户）',
    828. 

  828.   `oper_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '操作人员',
    829. 

  829.   `dept_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '部门名称',
    830. 

  830.   `oper_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '请求URL',
    831. 

  831.   `oper_ip` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '主机地址',
    832. 

  832.   `oper_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '操作地点',
    833. 

  833.   `oper_param` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '请求参数',
    834. 

  834.   `json_result` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '返回参数',
    835. 

  835.   `status` int(1) NULL DEFAULT 0 COMMENT '操作状态（0正常 1异常）',
    836. 

  836.   `error_msg` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '错误消息',
    837. 

  837.   `oper_time` datetime(0) NULL DEFAULT NULL COMMENT '操作时间',
    838. 

  838.   `tenant_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '租户id',
    839. 

  839.   PRIMARY KEY (`id`) USING BTREE
    840. 

  840. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '操作日志记录' ROW_FORMAT = Dynamic;
    841. 

  841. 

  842. -- ----------------------------
    843. 

  843. -- Records of sys_oper_log
    844. 

  844. -- ----------------------------
    845. 

  845. 

  846. -- ----------------------------
    847. 

  847. -- Table structure for sys_post
    848. 

  848. -- ----------------------------
    849. 

  849. DROP TABLE IF EXISTS `sys_post`;
    850. 

  850. CREATE TABLE `sys_post`  (
    851. 

  851.   `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '岗位ID',
    852. 

  852.   `post_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '岗位编码',
    853. 

  853.   `post_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '岗位名称',
    854. 

  854.   `post_sort` int(4) NOT NULL COMMENT '显示顺序',
    855. 

  855.   `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '状态（0正常 1停用）',
    856. 

  856.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
    857. 

  857.   `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    858. 

  858.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
    859. 

  859.   `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
    860. 

  860.   `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
    861. 

  861.   `tenant_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '租户id',
    862. 

  862.   PRIMARY KEY (`id`) USING BTREE
    863. 

  863. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '岗位信息表' ROW_FORMAT = Dynamic;
    864. 

  864. 

  865. -- ----------------------------
    866. 

  866. -- Records of sys_post
    867. 

  867. -- ----------------------------
    868. 

  868. 

  869. -- ----------------------------
    870. 

  870. -- Table structure for sys_role
    871. 

  871. -- ----------------------------
    872. 

  872. DROP TABLE IF EXISTS `sys_role`;
    873. 

  873. CREATE TABLE `sys_role`  (
    874. 

  874.   `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色ID',
    875. 

  875.   `role_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色名称',
    876. 

  876.   `role_key` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色权限字符串',
    877. 

  877.   `role_sort` int(4) NOT NULL COMMENT '显示顺序',
    878. 

  878.   `data_scope` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '1' COMMENT '数据范围（1：全部数据权限 2：自定数据权限 3：本部门数据权限 4：本部门及以下数据权限）',
    879. 

  879.   `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色状态（0正常 1停用）',
    880. 

  880.   `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
    881. 

  881.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
    882. 

  882.   `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    883. 

  883.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
    884. 

  884.   `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
    885. 

  885.   `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
    886. 

  886.   `tenant_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '租户id',
    887. 

  887.   PRIMARY KEY (`id`) USING BTREE
    888. 

  888. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '角色信息表' ROW_FORMAT = Dynamic;
    889. 

  889. 

  890. -- ----------------------------
    891. 

  891. -- Records of sys_role
    892. 

  892. -- ----------------------------
    893. 

  893. INSERT INTO `sys_role` VALUES ('1424613086572085250', '董事长', '4787b203faa14f12b2bbc5611aba2157', 1, '1', '0', '0', 'admin', '2021-08-09 14:06:43', 'admin', '2021-08-09 14:06:43', '', 'platform_saas');
    894. 

  894. INSERT INTO `sys_role` VALUES ('54634567845232344567897', '租户管理员角色', 'saas_admin', 0, '1', '0', '0', 'admin', '2021-05-26 15:36:20', 'admin', '2021-08-13 17:48:15', '租户管理员角色', 'platform_saas');
    895. 

  895. 

  896. -- ----------------------------
    897. 

  897. -- Table structure for sys_role_dept
    898. 

  898. -- ----------------------------
    899. 

  899. DROP TABLE IF EXISTS `sys_role_dept`;
    900. 

  900. CREATE TABLE `sys_role_dept`  (
    901. 

  901.   `role_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色ID',
    902. 

  902.   `dept_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '部门ID',
    903. 

  903.   `tenant_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '租户id',
    904. 

  904.   PRIMARY KEY (`role_id`, `dept_id`) USING BTREE
    905. 

  905. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '角色和部门关联表' ROW_FORMAT = Dynamic;
    906. 

  906. 

  907. -- ----------------------------
    908. 

  908. -- Records of sys_role_dept
    909. 

  909. -- ----------------------------
    910. 

  910. 

  911. -- ----------------------------
    912. 

  912. -- Table structure for sys_role_menu
    913. 

  913. -- ----------------------------
    914. 

  914. DROP TABLE IF EXISTS `sys_role_menu`;
    915. 

  915. CREATE TABLE `sys_role_menu`  (
    916. 

  916.   `role_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色ID',
    917. 

  917.   `menu_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '菜单ID',
    918. 

  918.   PRIMARY KEY (`role_id`, `menu_id`) USING BTREE
    919. 

  919. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '角色和菜单关联表' ROW_FORMAT = Dynamic;
    920. 

  920. 

  921. -- ----------------------------
    922. 

  922. -- Records of sys_role_menu
    923. 

  923. -- ----------------------------
    924. 

  924. INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1');
    925. 

  925. INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '100');
    926. 

  926. INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1000');
    927. 

  927. INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1001');
    928. 

  928. INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1002');
    929. 

  929. INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1003');
    930. 

  930. INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1004');
    931. 

  931. INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1005');
    932. 

  932. INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1006');
    933. 

  933. INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1016');
    934. 

  934. INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1017');
    935. 

  935. INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1018');
    936. 

  936. INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1019');
    937. 

  937. INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1020');
    938. 

  938. INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1021');
    939. 

  939. INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1022');
    940. 

  940. INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1023');
    941. 

  941. INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1024');
    942. 

  942. INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '103');
    943. 

  943. INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1035');
    944. 

  944. INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1036');
    945. 

  945. INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1037');
    946. 

  946. INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1038');
    947. 

  947. INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1039');
    948. 

  948. INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '104');
    949. 

  949. INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1040');
    950. 

  950. INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1041');
    951. 

  951. INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1042');
    952. 

  952. INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1043');
    953. 

  953. INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1044');
    954. 

  954. INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1045');
    955. 

  955. INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1046');
    956. 

  956. INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1047');
    957. 

  957. INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1048');
    958. 

  958. INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1049');
    959. 

  959. INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '107');
    960. 

  960. INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '108');
    961. 

  961. INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '109');
    962. 

  962. INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1423806481886625793');
    963. 

  963. INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '4');
    964. 

  964. INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '500');
    965. 

  965. INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '501');
    966. 

  966. INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1');
    967. 

  967. INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '100');
    968. 

  968. INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1000');
    969. 

  969. INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1001');
    970. 

  970. INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1002');
    971. 

  971. INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1003');
    972. 

  972. INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1004');
    973. 

  973. INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1005');
    974. 

  974. INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1006');
    975. 

  975. INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1007');
    976. 

  976. INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1008');
    977. 

  977. INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1009');
    978. 

  978. INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '101');
    979. 

  979. INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1010');
    980. 

  980. INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1011');
    981. 

  981. INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1016');
    982. 

  982. INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1017');
    983. 

  983. INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1018');
    984. 

  984. INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1019');
    985. 

  985. INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1020');
    986. 

  986. INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1021');
    987. 

  987. INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1022');
    988. 

  988. INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1023');
    989. 

  989. INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1024');
    990. 

  990. INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '103');
    991. 

  991. INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1035');
    992. 

  992. INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1036');
    993. 

  993. INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1037');
    994. 

  994. INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1038');
    995. 

  995. INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1039');
    996. 

  996. INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '104');
    997. 

  997. INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1040');
    998. 

  998. INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1041');
    999. 

  999. INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1042');
    1000. 

  1000. INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1043');
    1001. 

  1001. INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1044');
    1002. 

  1002. INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1045');
    1003. 

  1003. INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1046');
    1004. 

  1004. INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1047');
    1005. 

  1005. INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1048');
    1006. 

  1006. INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1049');
    1007. 

  1007. INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '107');
    1008. 

  1008. INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '108');
    1009. 

  1009. INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '109');
    1010. 

  1010. INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1423806481886625793');
    1011. 

  1011. INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1426117002031804417');
    1012. 

  1012. INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1426117817731657730');
    1013. 

  1013. INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1426118022732460033');
    1014. 

  1014. INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '4');
    1015. 

  1015. INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '500');
    1016. 

  1016. INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '501');
    1017. 

  1017. 

  1018. -- ----------------------------
    1019. 

  1019. -- Table structure for sys_user
    1020. 

  1020. -- ----------------------------
    1021. 

  1021. DROP TABLE IF EXISTS `sys_user`;
    1022. 

  1022. CREATE TABLE `sys_user`  (
    1023. 

  1023.   `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户ID',
    1024. 

  1024.   `dept_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '部门ID',
    1025. 

  1025.   `login_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '登录账号',
    1026. 

  1026.   `user_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '用户昵称',
    1027. 

  1027.   `user_type` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '00' COMMENT '用户类型（00系统用户 01注册用户02租户超管）',
    1028. 

  1028.   `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '用户邮箱',
    1029. 

  1029.   `phonenumber` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '手机号码',
    1030. 

  1030.   `sex` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '用户性别（0男 1女 2未知）',
    1031. 

  1031.   `avatar` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '头像路径',
    1032. 

  1032.   `password` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '密码',
    1033. 

  1033.   `salt` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '盐加密',
    1034. 

  1034.   `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '帐号状态（0正常 1停用）',
    1035. 

  1035.   `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
    1036. 

  1036.   `login_ip` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '最后登录IP',
    1037. 

  1037.   `login_date` datetime(0) NULL DEFAULT NULL COMMENT '最后登录时间',
    1038. 

  1038.   `pwd_update_date` datetime(0) NULL DEFAULT NULL COMMENT '密码最后更新时间',
    1039. 

  1039.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
    1040. 

  1040.   `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    1041. 

  1041.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
    1042. 

  1042.   `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
    1043. 

  1043.   `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
    1044. 

  1044.   `tenant_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '租户id',
    1045. 

  1045.   PRIMARY KEY (`id`) USING BTREE
    1046. 

  1046. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户信息表' ROW_FORMAT = Dynamic;
    1047. 

  1047. 

  1048. -- ----------------------------
    1049. 

  1049. -- Records of sys_user
    1050. 

  1050. -- ----------------------------
    1051. 

  1051. INSERT INTO `sys_user` VALUES ('1408064610237779960', '567456834562247092', 'admin', '圣钰saas', 'yb', 'ruoyi@qq.com', '15888888888', '1', '/profile/avatar/2021/08/12/efe9fc9a-9b09-4b79-974c-401e1585c715.png', '29c67a30398638269fe600f73a054934', '111111', '0', '0', '127.0.0.1', '2021-08-20 22:35:52', '2021-05-26 15:36:20', 'admin', '2021-05-26 15:36:20', 'ruoyi-system', '2021-08-20 22:35:52', '管理员', '1411258341581467649');
    1052. 

  1052. 

  1053. -- ----------------------------
    1054. 

  1054. -- Table structure for sys_user_online
    1055. 

  1055. -- ----------------------------
    1056. 

  1056. DROP TABLE IF EXISTS `sys_user_online`;
    1057. 

  1057. CREATE TABLE `sys_user_online`  (
    1058. 

  1058.   `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用户会话id',
    1059. 

  1059.   `login_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '登录账号',
    1060. 

  1060.   `dept_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '部门名称',
    1061. 

  1061.   `ipaddr` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '登录IP地址',
    1062. 

  1062.   `login_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '登录地点',
    1063. 

  1063.   `browser` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '浏览器类型',
    1064. 

  1064.   `os` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '操作系统',
    1065. 

  1065.   `status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '在线状态on_line在线off_line离线',
    1066. 

  1066.   `start_timestamp` datetime(0) NULL DEFAULT NULL COMMENT 'session创建时间',
    1067. 

  1067.   `last_access_time` datetime(0) NULL DEFAULT NULL COMMENT 'session最后访问时间',
    1068. 

  1068.   `expire_time` int(5) NULL DEFAULT 0 COMMENT '超时时间，单位为分钟',
    1069. 

  1069.   `tenant_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '租户id',
    1070. 

  1070.   PRIMARY KEY (`id`) USING BTREE
    1071. 

  1071. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '在线用户记录' ROW_FORMAT = Dynamic;
    1072. 

  1072. 

  1073. -- ----------------------------
    1074. 

  1074. -- Records of sys_user_online
    1075. 

  1075. -- ----------------------------
    1076. 

  1076. 

  1077. -- ----------------------------
    1078. 

  1078. -- Table structure for sys_user_post
    1079. 

  1079. -- ----------------------------
    1080. 

  1080. DROP TABLE IF EXISTS `sys_user_post`;
    1081. 

  1081. CREATE TABLE `sys_user_post`  (
    1082. 

  1082.   `user_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户ID',
    1083. 

  1083.   `post_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '岗位ID',
    1084. 

  1084.   `tenant_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '租户id',
    1085. 

  1085.   PRIMARY KEY (`user_id`, `post_id`) USING BTREE
    1086. 

  1086. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户与岗位关联表' ROW_FORMAT = Dynamic;
    1087. 

  1087. 

  1088. -- ----------------------------
    1089. 

  1089. -- Records of sys_user_post
    1090. 

  1090. -- ----------------------------
    1091. 

  1091. 

  1092. -- ----------------------------
    1093. 

  1093. -- Table structure for sys_user_role
    1094. 

  1094. -- ----------------------------
    1095. 

  1095. DROP TABLE IF EXISTS `sys_user_role`;
    1096. 

  1096. CREATE TABLE `sys_user_role`  (
    1097. 

  1097.   `user_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户ID',
    1098. 

  1098.   `role_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色ID',
    1099. 

  1099.   `tenant_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '租户id',
    1100. 

  1100.   PRIMARY KEY (`user_id`, `role_id`) USING BTREE
    1101. 

  1101. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户和角色关联表' ROW_FORMAT = Dynamic;
    1102. 

  1102. 

  1103. -- ----------------------------
    1104. 

  1104. -- Records of sys_user_role
    1105. 

  1105. -- ----------------------------
    1106. 

  1106. INSERT INTO `sys_user_role` VALUES ('1408064610237779960', '54634567845232344567897', '1411258341581467649');
    1107. 

  1107. 

  1108. SET FOREIGN_KEY_CHECKS = 1;
    1109.