Home Explore Help
Register Sign In
hospital-accompaniment
/
hospital-accompaniment-admin
Watch 2
Star 0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Tree: adea66b4c9
Branches Tags
hospital-acc...
/
script
/
sql
/
ry-vue-plus-2022-03-22.sql

ry-vue-plus-2022-03-22.sql 142 KB
History Raw

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202 
  1. /*
    2. 

  2.  Navicat Premium Data Transfer
    3. 

  3. 

  4.  Source Server         : 192.168.0.119-mysql8.0-3308
    5. 

  5.  Source Server Type    : MySQL
    6. 

  6.  Source Server Version : 80027
    7. 

  7.  Source Host           : 192.168.0.119:3308
    8. 

  8.  Source Schema         : ry-vue-plus
    9. 

  9. 

  10.  Target Server Type    : MySQL
    11. 

  11.  Target Server Version : 80027
    12. 

  12.  File Encoding         : 65001
    13. 

  13. 

  14.  Date: 22/03/2022 15:41:09
    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.   `table_id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '编号',
    26. 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  40.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_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_0900_ai_ci NULL DEFAULT '' COMMENT '更新者',
    43. 

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

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

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

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

  47. 

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

  49. -- Records of gen_table
    50. 

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

  51. INSERT INTO `gen_table` VALUES (9, 'test_api', '测试', NULL, NULL, 'TestApi', 'crud', 'com.ruoyi.demo', 'system', 'api', '测试', 'ruoyi', '1', 'E:\\git_workspace\\basic-code\\basic_system_plus_admin_code\\ruoyi-demo\\src', '{\"treeCode\":null,\"treeName\":null,\"treeParentCode\":null,\"parentMenuId\":null}', 'admin', '2022-03-18 16:54:13', 'admin', '2022-03-18 18:25:56', NULL);
    52. 

  52. 

  53. -- ----------------------------
    54. 

  54. -- Table structure for gen_table_column
    55. 

  55. -- ----------------------------
    56. 

  56. DROP TABLE IF EXISTS `gen_table_column`;
    57. 

  57. CREATE TABLE `gen_table_column`  (
    58. 

  58.   `column_id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '编号',
    59. 

  59.   `table_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '归属表编号',
    60. 

  60.   `column_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '列名称',
    61. 

  61.   `column_comment` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '列描述',
    62. 

  62.   `column_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '列类型',
    63. 

  63.   `java_type` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'JAVA类型',
    64. 

  64.   `java_field` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'JAVA字段名',
    65. 

  65.   `is_pk` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '是否主键（1是）',
    66. 

  66.   `is_increment` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '是否自增（1是）',
    67. 

  67.   `is_required` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '是否必填（1是）',
    68. 

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

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

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

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

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

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

  74.   `dict_type` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '字典类型',
    75. 

  75.   `sort` int(0) NULL DEFAULT NULL COMMENT '排序',
    76. 

  76.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '创建者',
    77. 

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

  78.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '更新者',
    79. 

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

  80.   PRIMARY KEY (`column_id`) USING BTREE
    81. 

  81. ) ENGINE = InnoDB AUTO_INCREMENT = 59 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '代码生成业务表字段' ROW_FORMAT = Dynamic;
    82. 

  82. 

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

  84. -- Records of gen_table_column
    85. 

  85. -- ----------------------------
    86. 

  86. INSERT INTO `gen_table_column` VALUES (53, '9', 'id', '主键', 'bigint', 'Long', 'id', '1', '1', '1', NULL, '1', '1', NULL, 'EQ', 'input', '', 1, 'admin', '2022-03-18 17:08:44', 'admin', '2022-03-18 18:25:56');
    87. 

  87. INSERT INTO `gen_table_column` VALUES (54, '9', 'name', '名称', 'varchar(1000)', 'String', 'name', '0', '0', '1', '1', '1', '1', '1', 'LIKE', 'textarea', '', 2, 'admin', '2022-03-18 17:08:44', 'admin', '2022-03-18 18:25:56');
    88. 

  88. INSERT INTO `gen_table_column` VALUES (55, '9', 'time', '', 'datetime', 'Date', 'time', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'datetime', '', 3, 'admin', '2022-03-18 17:08:44', 'admin', '2022-03-18 18:25:56');
    89. 

  89. INSERT INTO `gen_table_column` VALUES (56, '9', 'sex', '性别', 'char(1)', 'String', 'sex', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'select', 'sys_user_sex', 4, 'admin', '2022-03-18 17:08:44', 'admin', '2022-03-18 18:25:56');
    90. 

  90. INSERT INTO `gen_table_column` VALUES (57, '9', 'age', '年龄', 'int', 'Integer', 'age', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'input', 'sys_user_sex', 5, 'admin', '2022-03-18 17:08:44', 'admin', '2022-03-18 18:25:56');
    91. 

  91. INSERT INTO `gen_table_column` VALUES (58, '9', 'create_time', '创建时间', 'datetime', 'Date', 'createTime', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', 'datetime', '', 6, 'admin', '2022-03-18 17:08:44', 'admin', '2022-03-18 18:25:56');
    92. 

  92. 

  93. -- ----------------------------
    94. 

  94. -- Table structure for sys_config
    95. 

  95. -- ----------------------------
    96. 

  96. DROP TABLE IF EXISTS `sys_config`;
    97. 

  97. CREATE TABLE `sys_config`  (
    98. 

  98.   `config_id` int(0) NOT NULL AUTO_INCREMENT COMMENT '参数主键',
    99. 

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

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

  101.   `config_value` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '参数键值',
    102. 

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

  103.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '创建者',
    104. 

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

  105.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '更新者',
    106. 

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

  107.   `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
    108. 

  108.   PRIMARY KEY (`config_id`) USING BTREE
    109. 

  109. ) ENGINE = InnoDB AUTO_INCREMENT = 100 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '参数配置表' ROW_FORMAT = Dynamic;
    110. 

  110. 

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

  112. -- Records of sys_config
    113. 

  113. -- ----------------------------
    114. 

  114. INSERT INTO `sys_config` VALUES (1, '主框架页-默认皮肤样式名称', 'sys.index.skinName', 'skin-blue', 'Y', 'admin', '2022-03-02 08:14:52', '', NULL, '蓝色 skin-blue、绿色 skin-green、紫色 skin-purple、红色 skin-red、黄色 skin-yellow');
    115. 

  115. INSERT INTO `sys_config` VALUES (2, '用户管理-账号初始密码', 'sys.user.initPassword', '123456', 'Y', 'admin', '2022-03-02 08:14:52', '', NULL, '初始化密码 123456');
    116. 

  116. INSERT INTO `sys_config` VALUES (3, '主框架页-侧边栏主题', 'sys.index.sideTheme', 'theme-dark', 'Y', 'admin', '2022-03-02 08:14:52', '', NULL, '深色主题theme-dark，浅色主题theme-light');
    117. 

  117. INSERT INTO `sys_config` VALUES (4, '账号自助-验证码开关', 'sys.account.captchaOnOff', 'true', 'Y', 'admin', '2022-03-02 08:14:52', '', NULL, '是否开启验证码功能（true开启，false关闭）');
    118. 

  118. INSERT INTO `sys_config` VALUES (5, '账号自助-是否开启用户注册功能', 'sys.account.registerUser', 'false', 'Y', 'admin', '2022-03-02 08:14:52', '', NULL, '是否开启注册用户功能（true开启，false关闭）');
    119. 

  119. INSERT INTO `sys_config` VALUES (11, 'OSS预览列表资源开关', 'sys.oss.previewListResource', 'true', 'Y', 'admin', '2022-03-02 08:14:52', '', NULL, 'true:开启, false:关闭');
    120. 

  120. 

  121. -- ----------------------------
    122. 

  122. -- Table structure for sys_dept
    123. 

  123. -- ----------------------------
    124. 

  124. DROP TABLE IF EXISTS `sys_dept`;
    125. 

  125. CREATE TABLE `sys_dept`  (
    126. 

  126.   `dept_id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '部门id',
    127. 

  127.   `parent_id` bigint(0) NULL DEFAULT 0 COMMENT '父部门id',
    128. 

  128.   `ancestors` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '祖级列表',
    129. 

  129.   `dept_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '部门名称',
    130. 

  130.   `order_num` int(0) NULL DEFAULT 0 COMMENT '显示顺序',
    131. 

  131.   `leader` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '负责人',
    132. 

  132.   `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '联系电话',
    133. 

  133.   `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '邮箱',
    134. 

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

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

  136.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '创建者',
    137. 

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

  138.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '更新者',
    139. 

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

  140.   PRIMARY KEY (`dept_id`) USING BTREE
    141. 

  141. ) ENGINE = InnoDB AUTO_INCREMENT = 200 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '部门表' ROW_FORMAT = Dynamic;
    142. 

  142. 

  143. -- ----------------------------
    144. 

  144. -- Records of sys_dept
    145. 

  145. -- ----------------------------
    146. 

  146. INSERT INTO `sys_dept` VALUES (100, 0, '0', '若依科技', 0, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-03-02 08:14:44', '', NULL);
    147. 

  147. INSERT INTO `sys_dept` VALUES (101, 100, '0,100', '深圳总公司', 1, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-03-02 08:14:44', '', NULL);
    148. 

  148. INSERT INTO `sys_dept` VALUES (102, 100, '0,100', '长沙分公司', 2, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-03-02 08:14:44', '', NULL);
    149. 

  149. INSERT INTO `sys_dept` VALUES (103, 101, '0,100,101', '研发部门', 1, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-03-02 08:14:44', '', NULL);
    150. 

  150. INSERT INTO `sys_dept` VALUES (104, 101, '0,100,101', '市场部门', 2, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-03-02 08:14:44', '', NULL);
    151. 

  151. INSERT INTO `sys_dept` VALUES (105, 101, '0,100,101', '测试部门', 3, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-03-02 08:14:44', '', NULL);
    152. 

  152. INSERT INTO `sys_dept` VALUES (106, 101, '0,100,101', '财务部门', 4, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-03-02 08:14:44', '', NULL);
    153. 

  153. INSERT INTO `sys_dept` VALUES (107, 101, '0,100,101', '运维部门', 5, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-03-02 08:14:44', '', NULL);
    154. 

  154. INSERT INTO `sys_dept` VALUES (108, 102, '0,100,102', '市场部门', 1, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-03-02 08:14:44', '', NULL);
    155. 

  155. INSERT INTO `sys_dept` VALUES (109, 102, '0,100,102', '财务部门', 2, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-03-02 08:14:44', '', NULL);
    156. 

  156. 

  157. -- ----------------------------
    158. 

  158. -- Table structure for sys_dict_data
    159. 

  159. -- ----------------------------
    160. 

  160. DROP TABLE IF EXISTS `sys_dict_data`;
    161. 

  161. CREATE TABLE `sys_dict_data`  (
    162. 

  162.   `dict_code` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '字典编码',
    163. 

  163.   `dict_sort` int(0) NULL DEFAULT 0 COMMENT '字典排序',
    164. 

  164.   `dict_label` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '字典标签',
    165. 

  165.   `dict_value` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '字典键值',
    166. 

  166.   `dict_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '字典类型',
    167. 

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

  168.   `list_class` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '表格回显样式',
    169. 

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

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

  171.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '创建者',
    172. 

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

  173.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '更新者',
    174. 

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

  175.   `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
    176. 

  176.   PRIMARY KEY (`dict_code`) USING BTREE
    177. 

  177. ) ENGINE = InnoDB AUTO_INCREMENT = 100 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '字典数据表' ROW_FORMAT = Dynamic;
    178. 

  178. 

  179. -- ----------------------------
    180. 

  180. -- Records of sys_dict_data
    181. 

  181. -- ----------------------------
    182. 

  182. INSERT INTO `sys_dict_data` VALUES (1, 1, '男', '0', 'sys_user_sex', '', '', 'Y', '0', 'admin', '2022-03-02 08:14:52', '', NULL, '性别男');
    183. 

  183. INSERT INTO `sys_dict_data` VALUES (2, 2, '女', '1', 'sys_user_sex', '', '', 'N', '0', 'admin', '2022-03-02 08:14:52', '', NULL, '性别女');
    184. 

  184. INSERT INTO `sys_dict_data` VALUES (3, 3, '未知', '2', 'sys_user_sex', '', '', 'N', '0', 'admin', '2022-03-02 08:14:52', '', NULL, '性别未知');
    185. 

  185. INSERT INTO `sys_dict_data` VALUES (4, 1, '显示', '0', 'sys_show_hide', '', 'primary', 'Y', '0', 'admin', '2022-03-02 08:14:52', '', NULL, '显示菜单');
    186. 

  186. INSERT INTO `sys_dict_data` VALUES (5, 2, '隐藏', '1', 'sys_show_hide', '', 'danger', 'N', '0', 'admin', '2022-03-02 08:14:52', '', NULL, '隐藏菜单');
    187. 

  187. INSERT INTO `sys_dict_data` VALUES (6, 1, '正常', '0', 'sys_normal_disable', '', 'primary', 'Y', '0', 'admin', '2022-03-02 08:14:52', '', NULL, '正常状态');
    188. 

  188. INSERT INTO `sys_dict_data` VALUES (7, 2, '停用', '1', 'sys_normal_disable', '', 'danger', 'N', '0', 'admin', '2022-03-02 08:14:52', '', NULL, '停用状态');
    189. 

  189. INSERT INTO `sys_dict_data` VALUES (12, 1, '是', 'Y', 'sys_yes_no', '', 'primary', 'Y', '0', 'admin', '2022-03-02 08:14:52', '', NULL, '系统默认是');
    190. 

  190. INSERT INTO `sys_dict_data` VALUES (13, 2, '否', 'N', 'sys_yes_no', '', 'danger', 'N', '0', 'admin', '2022-03-02 08:14:52', '', NULL, '系统默认否');
    191. 

  191. INSERT INTO `sys_dict_data` VALUES (14, 1, '通知', '1', 'sys_notice_type', '', 'warning', 'Y', '0', 'admin', '2022-03-02 08:14:52', '', NULL, '通知');
    192. 

  192. INSERT INTO `sys_dict_data` VALUES (15, 2, '公告', '2', 'sys_notice_type', '', 'success', 'N', '0', 'admin', '2022-03-02 08:14:52', '', NULL, '公告');
    193. 

  193. INSERT INTO `sys_dict_data` VALUES (16, 1, '正常', '0', 'sys_notice_status', '', 'primary', 'Y', '0', 'admin', '2022-03-02 08:14:52', '', NULL, '正常状态');
    194. 

  194. INSERT INTO `sys_dict_data` VALUES (17, 2, '关闭', '1', 'sys_notice_status', '', 'danger', 'N', '0', 'admin', '2022-03-02 08:14:52', '', NULL, '关闭状态');
    195. 

  195. INSERT INTO `sys_dict_data` VALUES (18, 1, '新增', '1', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2022-03-02 08:14:52', '', NULL, '新增操作');
    196. 

  196. INSERT INTO `sys_dict_data` VALUES (19, 2, '修改', '2', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2022-03-02 08:14:52', '', NULL, '修改操作');
    197. 

  197. INSERT INTO `sys_dict_data` VALUES (20, 3, '删除', '3', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2022-03-02 08:14:52', '', NULL, '删除操作');
    198. 

  198. INSERT INTO `sys_dict_data` VALUES (21, 4, '授权', '4', 'sys_oper_type', '', 'primary', 'N', '0', 'admin', '2022-03-02 08:14:52', '', NULL, '授权操作');
    199. 

  199. INSERT INTO `sys_dict_data` VALUES (22, 5, '导出', '5', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2022-03-02 08:14:52', '', NULL, '导出操作');
    200. 

  200. INSERT INTO `sys_dict_data` VALUES (23, 6, '导入', '6', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2022-03-02 08:14:52', '', NULL, '导入操作');
    201. 

  201. INSERT INTO `sys_dict_data` VALUES (24, 7, '强退', '7', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2022-03-02 08:14:52', '', NULL, '强退操作');
    202. 

  202. INSERT INTO `sys_dict_data` VALUES (25, 8, '生成代码', '8', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2022-03-02 08:14:52', '', NULL, '生成操作');
    203. 

  203. INSERT INTO `sys_dict_data` VALUES (26, 9, '清空数据', '9', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2022-03-02 08:14:52', '', NULL, '清空操作');
    204. 

  204. INSERT INTO `sys_dict_data` VALUES (27, 1, '成功', '0', 'sys_common_status', '', 'primary', 'N', '0', 'admin', '2022-03-02 08:14:52', '', NULL, '正常状态');
    205. 

  205. INSERT INTO `sys_dict_data` VALUES (28, 2, '失败', '1', 'sys_common_status', '', 'danger', 'N', '0', 'admin', '2022-03-02 08:14:52', '', NULL, '停用状态');
    206. 

  206. 

  207. -- ----------------------------
    208. 

  208. -- Table structure for sys_dict_type
    209. 

  209. -- ----------------------------
    210. 

  210. DROP TABLE IF EXISTS `sys_dict_type`;
    211. 

  211. CREATE TABLE `sys_dict_type`  (
    212. 

  212.   `dict_id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '字典主键',
    213. 

  213.   `dict_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '字典名称',
    214. 

  214.   `dict_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '字典类型',
    215. 

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

  216.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '创建者',
    217. 

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

  218.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '更新者',
    219. 

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

  220.   `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
    221. 

  221.   PRIMARY KEY (`dict_id`) USING BTREE,
    222. 

  222.   UNIQUE INDEX `dict_type`(`dict_type`) USING BTREE
    223. 

  223. ) ENGINE = InnoDB AUTO_INCREMENT = 100 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '字典类型表' ROW_FORMAT = Dynamic;
    224. 

  224. 

  225. -- ----------------------------
    226. 

  226. -- Records of sys_dict_type
    227. 

  227. -- ----------------------------
    228. 

  228. INSERT INTO `sys_dict_type` VALUES (1, '用户性别', 'sys_user_sex', '0', 'admin', '2022-03-02 08:14:51', '', NULL, '用户性别列表');
    229. 

  229. INSERT INTO `sys_dict_type` VALUES (2, '菜单状态', 'sys_show_hide', '0', 'admin', '2022-03-02 08:14:51', '', NULL, '菜单状态列表');
    230. 

  230. INSERT INTO `sys_dict_type` VALUES (3, '系统开关', 'sys_normal_disable', '0', 'admin', '2022-03-02 08:14:51', '', NULL, '系统开关列表');
    231. 

  231. INSERT INTO `sys_dict_type` VALUES (6, '系统是否', 'sys_yes_no', '0', 'admin', '2022-03-02 08:14:51', '', NULL, '系统是否列表');
    232. 

  232. INSERT INTO `sys_dict_type` VALUES (7, '通知类型', 'sys_notice_type', '0', 'admin', '2022-03-02 08:14:51', '', NULL, '通知类型列表');
    233. 

  233. INSERT INTO `sys_dict_type` VALUES (8, '通知状态', 'sys_notice_status', '0', 'admin', '2022-03-02 08:14:51', '', NULL, '通知状态列表');
    234. 

  234. INSERT INTO `sys_dict_type` VALUES (9, '操作类型', 'sys_oper_type', '0', 'admin', '2022-03-02 08:14:51', '', NULL, '操作类型列表');
    235. 

  235. INSERT INTO `sys_dict_type` VALUES (10, '系统状态', 'sys_common_status', '0', 'admin', '2022-03-02 08:14:51', '', NULL, '登录状态列表');
    236. 

  236. 

  237. -- ----------------------------
    238. 

  238. -- Table structure for sys_logininfor
    239. 

  239. -- ----------------------------
    240. 

  240. DROP TABLE IF EXISTS `sys_logininfor`;
    241. 

  241. CREATE TABLE `sys_logininfor`  (
    242. 

  242.   `info_id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '访问ID',
    243. 

  243.   `user_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '用户账号',
    244. 

  244.   `ipaddr` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '登录IP地址',
    245. 

  245.   `login_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '登录地点',
    246. 

  246.   `browser` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '浏览器类型',
    247. 

  247.   `os` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '操作系统',
    248. 

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

  249.   `msg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '提示消息',
    250. 

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

  251.   PRIMARY KEY (`info_id`) USING BTREE
    252. 

  252. ) ENGINE = InnoDB AUTO_INCREMENT = 110 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '系统访问记录' ROW_FORMAT = Dynamic;
    253. 

  253. 

  254. -- ----------------------------
    255. 

  255. -- Records of sys_logininfor
    256. 

  256. -- ----------------------------
    257. 

  257. INSERT INTO `sys_logininfor` VALUES (100, 'admin', '127.0.0.1', '内网IP', 'Chrome', 'Windows 10 or Windows Server 2016', '1', '验证码错误', '2022-03-02 16:26:30');
    258. 

  258. INSERT INTO `sys_logininfor` VALUES (101, 'admin', '127.0.0.1', '内网IP', 'Chrome', 'Windows 10 or Windows Server 2016', '0', '登录成功', '2022-03-02 16:26:34');
    259. 

  259. INSERT INTO `sys_logininfor` VALUES (102, 'admin', '127.0.0.1', '内网IP', 'Chrome', 'Windows 10 or Windows Server 2016', '1', '验证码错误', '2022-03-03 10:28:34');
    260. 

  260. INSERT INTO `sys_logininfor` VALUES (103, 'admin', '127.0.0.1', '内网IP', 'Chrome', 'Windows 10 or Windows Server 2016', '0', '登录成功', '2022-03-03 10:28:39');
    261. 

  261. INSERT INTO `sys_logininfor` VALUES (104, 'admin', '127.0.0.1', '内网IP', 'Chrome', 'Windows 10 or Windows Server 2016', '0', '登录成功', '2022-03-03 18:35:07');
    262. 

  262. INSERT INTO `sys_logininfor` VALUES (105, 'admin', '127.0.0.1', '内网IP', 'Chrome', 'Windows 10 or Windows Server 2016', '0', '登录成功', '2022-03-04 09:08:15');
    263. 

  263. INSERT INTO `sys_logininfor` VALUES (106, 'admin', '127.0.0.1', '内网IP', 'Chrome', 'Windows 10 or Windows Server 2016', '0', '登录成功', '2022-03-04 11:50:04');
    264. 

  264. INSERT INTO `sys_logininfor` VALUES (107, 'admin', '127.0.0.1', '内网IP', 'Chrome', 'Windows 10 or Windows Server 2016', '0', '登录成功', '2022-03-04 15:57:35');
    265. 

  265. INSERT INTO `sys_logininfor` VALUES (108, 'admin', '127.0.0.1', '内网IP', 'Chrome', 'Windows 10 or Windows Server 2016', '0', '登录成功', '2022-03-18 16:52:18');
    266. 

  266. INSERT INTO `sys_logininfor` VALUES (109, 'admin', '127.0.0.1', '内网IP', 'Chrome', 'Windows 10 or Windows Server 2016', '0', '登录成功', '2022-03-18 18:24:13');
    267. 

  267. 

  268. -- ----------------------------
    269. 

  269. -- Table structure for sys_menu
    270. 

  270. -- ----------------------------
    271. 

  271. DROP TABLE IF EXISTS `sys_menu`;
    272. 

  272. CREATE TABLE `sys_menu`  (
    273. 

  273.   `menu_id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '菜单ID',
    274. 

  274.   `menu_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '菜单名称',
    275. 

  275.   `parent_id` bigint(0) NULL DEFAULT 0 COMMENT '父菜单ID',
    276. 

  276.   `order_num` int(0) NULL DEFAULT 0 COMMENT '显示顺序',
    277. 

  277.   `path` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '路由地址',
    278. 

  278.   `component` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '组件路径',
    279. 

  279.   `query` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '路由参数',
    280. 

  280.   `is_frame` int(0) NULL DEFAULT 1 COMMENT '是否为外链（0是 1否）',
    281. 

  281.   `is_cache` int(0) NULL DEFAULT 0 COMMENT '是否缓存（0缓存 1不缓存）',
    282. 

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

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

  284.   `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '0' COMMENT '菜单状态（0正常 1停用）',
    285. 

  285.   `perms` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '权限标识',
    286. 

  286.   `icon` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '#' COMMENT '菜单图标',
    287. 

  287.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '创建者',
    288. 

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

  289.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '更新者',
    290. 

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

  291.   `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '备注',
    292. 

  292.   PRIMARY KEY (`menu_id`) USING BTREE
    293. 

  293. ) ENGINE = InnoDB AUTO_INCREMENT = 2000 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '菜单权限表' ROW_FORMAT = Dynamic;
    294. 

  294. 

  295. -- ----------------------------
    296. 

  296. -- Records of sys_menu
    297. 

  297. -- ----------------------------
    298. 

  298. INSERT INTO `sys_menu` VALUES (1, '系统管理', 0, 1, 'system', NULL, '', 1, 0, 'M', '0', '0', '', 'system', 'admin', '2022-03-02 08:14:48', '', NULL, '系统管理目录');
    299. 

  299. INSERT INTO `sys_menu` VALUES (2, '系统监控', 0, 2, 'monitor', NULL, '', 1, 0, 'M', '0', '0', '', 'monitor', 'admin', '2022-03-02 08:14:48', '', NULL, '系统监控目录');
    300. 

  300. INSERT INTO `sys_menu` VALUES (3, '系统工具', 0, 3, 'tool', NULL, '', 1, 0, 'M', '0', '0', '', 'tool', 'admin', '2022-03-02 08:14:48', '', NULL, '系统工具目录');
    301. 

  301. INSERT INTO `sys_menu` VALUES (4, 'PLUS官网', 0, 4, 'https://gitee.com/JavaLionLi/RuoYi-Vue-Plus', NULL, '', 0, 0, 'M', '0', '0', '', 'guide', 'admin', '2022-03-02 08:14:48', '', NULL, 'RuoYi-Vue-Plus官网地址');
    302. 

  302. INSERT INTO `sys_menu` VALUES (5, '测试菜单', 0, 5, 'demo', NULL, NULL, 1, 0, 'M', '0', '0', NULL, 'star', 'admin', '2021-05-30 00:34:26', NULL, NULL, '');
    303. 

  303. INSERT INTO `sys_menu` VALUES (100, '用户管理', 1, 1, 'user', 'system/user/index', '', 1, 0, 'C', '0', '0', 'system:user:list', 'user', 'admin', '2022-03-02 08:14:48', '', NULL, '用户管理菜单');
    304. 

  304. INSERT INTO `sys_menu` VALUES (101, '角色管理', 1, 2, 'role', 'system/role/index', '', 1, 0, 'C', '0', '0', 'system:role:list', 'peoples', 'admin', '2022-03-02 08:14:48', '', NULL, '角色管理菜单');
    305. 

  305. INSERT INTO `sys_menu` VALUES (102, '菜单管理', 1, 3, 'menu', 'system/menu/index', '', 1, 0, 'C', '0', '0', 'system:menu:list', 'tree-table', 'admin', '2022-03-02 08:14:48', '', NULL, '菜单管理菜单');
    306. 

  306. INSERT INTO `sys_menu` VALUES (103, '部门管理', 1, 4, 'dept', 'system/dept/index', '', 1, 0, 'C', '0', '0', 'system:dept:list', 'tree', 'admin', '2022-03-02 08:14:48', '', NULL, '部门管理菜单');
    307. 

  307. INSERT INTO `sys_menu` VALUES (104, '岗位管理', 1, 5, 'post', 'system/post/index', '', 1, 0, 'C', '0', '0', 'system:post:list', 'post', 'admin', '2022-03-02 08:14:48', '', NULL, '岗位管理菜单');
    308. 

  308. INSERT INTO `sys_menu` VALUES (105, '字典管理', 1, 6, 'dict', 'system/dict/index', '', 1, 0, 'C', '0', '0', 'system:dict:list', 'dict', 'admin', '2022-03-02 08:14:48', '', NULL, '字典管理菜单');
    309. 

  309. INSERT INTO `sys_menu` VALUES (106, '参数设置', 1, 7, 'config', 'system/config/index', '', 1, 0, 'C', '0', '0', 'system:config:list', 'edit', 'admin', '2022-03-02 08:14:48', '', NULL, '参数设置菜单');
    310. 

  310. INSERT INTO `sys_menu` VALUES (107, '通知公告', 1, 8, 'notice', 'system/notice/index', '', 1, 0, 'C', '0', '0', 'system:notice:list', 'message', 'admin', '2022-03-02 08:14:48', '', NULL, '通知公告菜单');
    311. 

  311. INSERT INTO `sys_menu` VALUES (108, '日志管理', 1, 9, 'log', '', '', 1, 0, 'M', '0', '0', '', 'log', 'admin', '2022-03-02 08:14:48', '', NULL, '日志管理菜单');
    312. 

  312. INSERT INTO `sys_menu` VALUES (109, '在线用户', 2, 1, 'online', 'monitor/online/index', '', 1, 0, 'C', '0', '0', 'monitor:online:list', 'online', 'admin', '2022-03-02 08:14:48', '', NULL, '在线用户菜单');
    313. 

  313. INSERT INTO `sys_menu` VALUES (111, '数据监控', 2, 3, 'druid', 'monitor/druid/index', '', 1, 0, 'C', '0', '0', 'monitor:druid:list', 'druid', 'admin', '2022-03-02 08:14:48', '', NULL, '数据监控菜单');
    314. 

  314. INSERT INTO `sys_menu` VALUES (113, '缓存监控', 2, 5, 'cache', 'monitor/cache/index', '', 1, 0, 'C', '0', '0', 'monitor:cache:list', 'redis', 'admin', '2022-03-02 08:14:48', '', NULL, '缓存监控菜单');
    315. 

  315. INSERT INTO `sys_menu` VALUES (114, '表单构建', 3, 1, 'build', 'tool/build/index', '', 1, 0, 'C', '0', '0', 'tool:build:list', 'build', 'admin', '2022-03-02 08:14:48', '', NULL, '表单构建菜单');
    316. 

  316. INSERT INTO `sys_menu` VALUES (115, '代码生成', 3, 2, 'gen', 'tool/gen/index', '', 1, 0, 'C', '0', '0', 'tool:gen:list', 'code', 'admin', '2022-03-02 08:14:48', '', NULL, '代码生成菜单');
    317. 

  317. INSERT INTO `sys_menu` VALUES (116, '系统接口', 3, 3, 'swagger', 'tool/swagger/index', '', 1, 0, 'C', '0', '0', 'tool:swagger:list', 'swagger', 'admin', '2022-03-02 08:14:48', '', NULL, '系统接口菜单');
    318. 

  318. INSERT INTO `sys_menu` VALUES (117, 'Admin监控', 2, 5, 'Admin', 'monitor/admin/index', '', 1, 0, 'C', '0', '0', 'monitor:admin:list', 'dashboard', 'admin', '2022-03-02 08:14:48', '', NULL, 'Admin监控菜单');
    319. 

  319. INSERT INTO `sys_menu` VALUES (118, '文件管理', 1, 10, 'oss', 'system/oss/index', '', 1, 0, 'C', '0', '0', 'system:oss:list', 'upload', 'admin', '2022-03-02 08:14:48', '', NULL, '文件管理菜单');
    320. 

  320. INSERT INTO `sys_menu` VALUES (120, '任务调度中心', 2, 5, 'XxlJob', 'monitor/xxljob/index', '', 1, 0, 'C', '0', '0', 'monitor:xxljob:list', 'job', 'admin', '2022-03-02 08:14:48', '', NULL, 'Xxl-Job控制台菜单');
    321. 

  321. INSERT INTO `sys_menu` VALUES (500, '操作日志', 108, 1, 'operlog', 'monitor/operlog/index', '', 1, 0, 'C', '0', '0', 'monitor:operlog:list', 'form', 'admin', '2022-03-02 08:14:48', '', NULL, '操作日志菜单');
    322. 

  322. INSERT INTO `sys_menu` VALUES (501, '登录日志', 108, 2, 'logininfor', 'monitor/logininfor/index', '', 1, 0, 'C', '0', '0', 'monitor:logininfor:list', 'logininfor', 'admin', '2022-03-02 08:14:48', '', NULL, '登录日志菜单');
    323. 

  323. INSERT INTO `sys_menu` VALUES (1001, '用户查询', 100, 1, '', '', '', 1, 0, 'F', '0', '0', 'system:user:query', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    324. 

  324. INSERT INTO `sys_menu` VALUES (1002, '用户新增', 100, 2, '', '', '', 1, 0, 'F', '0', '0', 'system:user:add', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    325. 

  325. INSERT INTO `sys_menu` VALUES (1003, '用户修改', 100, 3, '', '', '', 1, 0, 'F', '0', '0', 'system:user:edit', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    326. 

  326. INSERT INTO `sys_menu` VALUES (1004, '用户删除', 100, 4, '', '', '', 1, 0, 'F', '0', '0', 'system:user:remove', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    327. 

  327. INSERT INTO `sys_menu` VALUES (1005, '用户导出', 100, 5, '', '', '', 1, 0, 'F', '0', '0', 'system:user:export', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    328. 

  328. INSERT INTO `sys_menu` VALUES (1006, '用户导入', 100, 6, '', '', '', 1, 0, 'F', '0', '0', 'system:user:import', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    329. 

  329. INSERT INTO `sys_menu` VALUES (1007, '重置密码', 100, 7, '', '', '', 1, 0, 'F', '0', '0', 'system:user:resetPwd', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    330. 

  330. INSERT INTO `sys_menu` VALUES (1008, '角色查询', 101, 1, '', '', '', 1, 0, 'F', '0', '0', 'system:role:query', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    331. 

  331. INSERT INTO `sys_menu` VALUES (1009, '角色新增', 101, 2, '', '', '', 1, 0, 'F', '0', '0', 'system:role:add', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    332. 

  332. INSERT INTO `sys_menu` VALUES (1010, '角色修改', 101, 3, '', '', '', 1, 0, 'F', '0', '0', 'system:role:edit', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    333. 

  333. INSERT INTO `sys_menu` VALUES (1011, '角色删除', 101, 4, '', '', '', 1, 0, 'F', '0', '0', 'system:role:remove', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    334. 

  334. INSERT INTO `sys_menu` VALUES (1012, '角色导出', 101, 5, '', '', '', 1, 0, 'F', '0', '0', 'system:role:export', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    335. 

  335. INSERT INTO `sys_menu` VALUES (1013, '菜单查询', 102, 1, '', '', '', 1, 0, 'F', '0', '0', 'system:menu:query', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    336. 

  336. INSERT INTO `sys_menu` VALUES (1014, '菜单新增', 102, 2, '', '', '', 1, 0, 'F', '0', '0', 'system:menu:add', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    337. 

  337. INSERT INTO `sys_menu` VALUES (1015, '菜单修改', 102, 3, '', '', '', 1, 0, 'F', '0', '0', 'system:menu:edit', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    338. 

  338. INSERT INTO `sys_menu` VALUES (1016, '菜单删除', 102, 4, '', '', '', 1, 0, 'F', '0', '0', 'system:menu:remove', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    339. 

  339. INSERT INTO `sys_menu` VALUES (1017, '部门查询', 103, 1, '', '', '', 1, 0, 'F', '0', '0', 'system:dept:query', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    340. 

  340. INSERT INTO `sys_menu` VALUES (1018, '部门新增', 103, 2, '', '', '', 1, 0, 'F', '0', '0', 'system:dept:add', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    341. 

  341. INSERT INTO `sys_menu` VALUES (1019, '部门修改', 103, 3, '', '', '', 1, 0, 'F', '0', '0', 'system:dept:edit', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    342. 

  342. INSERT INTO `sys_menu` VALUES (1020, '部门删除', 103, 4, '', '', '', 1, 0, 'F', '0', '0', 'system:dept:remove', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    343. 

  343. INSERT INTO `sys_menu` VALUES (1021, '岗位查询', 104, 1, '', '', '', 1, 0, 'F', '0', '0', 'system:post:query', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    344. 

  344. INSERT INTO `sys_menu` VALUES (1022, '岗位新增', 104, 2, '', '', '', 1, 0, 'F', '0', '0', 'system:post:add', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    345. 

  345. INSERT INTO `sys_menu` VALUES (1023, '岗位修改', 104, 3, '', '', '', 1, 0, 'F', '0', '0', 'system:post:edit', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    346. 

  346. INSERT INTO `sys_menu` VALUES (1024, '岗位删除', 104, 4, '', '', '', 1, 0, 'F', '0', '0', 'system:post:remove', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    347. 

  347. INSERT INTO `sys_menu` VALUES (1025, '岗位导出', 104, 5, '', '', '', 1, 0, 'F', '0', '0', 'system:post:export', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    348. 

  348. INSERT INTO `sys_menu` VALUES (1026, '字典查询', 105, 1, '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:query', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    349. 

  349. INSERT INTO `sys_menu` VALUES (1027, '字典新增', 105, 2, '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:add', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    350. 

  350. INSERT INTO `sys_menu` VALUES (1028, '字典修改', 105, 3, '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:edit', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    351. 

  351. INSERT INTO `sys_menu` VALUES (1029, '字典删除', 105, 4, '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:remove', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    352. 

  352. INSERT INTO `sys_menu` VALUES (1030, '字典导出', 105, 5, '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:export', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    353. 

  353. INSERT INTO `sys_menu` VALUES (1031, '参数查询', 106, 1, '#', '', '', 1, 0, 'F', '0', '0', 'system:config:query', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    354. 

  354. INSERT INTO `sys_menu` VALUES (1032, '参数新增', 106, 2, '#', '', '', 1, 0, 'F', '0', '0', 'system:config:add', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    355. 

  355. INSERT INTO `sys_menu` VALUES (1033, '参数修改', 106, 3, '#', '', '', 1, 0, 'F', '0', '0', 'system:config:edit', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    356. 

  356. INSERT INTO `sys_menu` VALUES (1034, '参数删除', 106, 4, '#', '', '', 1, 0, 'F', '0', '0', 'system:config:remove', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    357. 

  357. INSERT INTO `sys_menu` VALUES (1035, '参数导出', 106, 5, '#', '', '', 1, 0, 'F', '0', '0', 'system:config:export', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    358. 

  358. INSERT INTO `sys_menu` VALUES (1036, '公告查询', 107, 1, '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:query', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    359. 

  359. INSERT INTO `sys_menu` VALUES (1037, '公告新增', 107, 2, '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:add', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    360. 

  360. INSERT INTO `sys_menu` VALUES (1038, '公告修改', 107, 3, '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:edit', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    361. 

  361. INSERT INTO `sys_menu` VALUES (1039, '公告删除', 107, 4, '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:remove', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    362. 

  362. INSERT INTO `sys_menu` VALUES (1040, '操作查询', 500, 1, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:operlog:query', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    363. 

  363. INSERT INTO `sys_menu` VALUES (1041, '操作删除', 500, 2, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:operlog:remove', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    364. 

  364. INSERT INTO `sys_menu` VALUES (1042, '日志导出', 500, 4, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:operlog:export', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    365. 

  365. INSERT INTO `sys_menu` VALUES (1043, '登录查询', 501, 1, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:query', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    366. 

  366. INSERT INTO `sys_menu` VALUES (1044, '登录删除', 501, 2, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:remove', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    367. 

  367. INSERT INTO `sys_menu` VALUES (1045, '日志导出', 501, 3, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:export', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    368. 

  368. INSERT INTO `sys_menu` VALUES (1046, '在线查询', 109, 1, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:online:query', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    369. 

  369. INSERT INTO `sys_menu` VALUES (1047, '批量强退', 109, 2, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:online:batchLogout', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    370. 

  370. INSERT INTO `sys_menu` VALUES (1048, '单条强退', 109, 3, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:online:forceLogout', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    371. 

  371. INSERT INTO `sys_menu` VALUES (1055, '生成查询', 115, 1, '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:query', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    372. 

  372. INSERT INTO `sys_menu` VALUES (1056, '生成修改', 115, 2, '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:edit', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    373. 

  373. INSERT INTO `sys_menu` VALUES (1057, '生成删除', 115, 3, '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:remove', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    374. 

  374. INSERT INTO `sys_menu` VALUES (1058, '导入代码', 115, 2, '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:import', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    375. 

  375. INSERT INTO `sys_menu` VALUES (1059, '预览代码', 115, 4, '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:preview', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    376. 

  376. INSERT INTO `sys_menu` VALUES (1060, '生成代码', 115, 5, '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:code', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    377. 

  377. INSERT INTO `sys_menu` VALUES (1500, '测试单表', 5, 1, 'demo', 'demo/demo/index', NULL, 1, 0, 'C', '0', '0', 'demo:demo:list', '#', 'admin', '2021-05-30 00:39:23', '', NULL, '测试单表菜单');
    378. 

  378. INSERT INTO `sys_menu` VALUES (1501, '测试单表查询', 1500, 1, '#', '', NULL, 1, 0, 'F', '0', '0', 'demo:demo:query', '#', 'admin', '2021-05-30 00:39:23', '', NULL, '');
    379. 

  379. INSERT INTO `sys_menu` VALUES (1502, '测试单表新增', 1500, 2, '#', '', NULL, 1, 0, 'F', '0', '0', 'demo:demo:add', '#', 'admin', '2021-05-30 00:39:23', '', NULL, '');
    380. 

  380. INSERT INTO `sys_menu` VALUES (1503, '测试单表修改', 1500, 3, '#', '', NULL, 1, 0, 'F', '0', '0', 'demo:demo:edit', '#', 'admin', '2021-05-30 00:39:23', '', NULL, '');
    381. 

  381. INSERT INTO `sys_menu` VALUES (1504, '测试单表删除', 1500, 4, '#', '', NULL, 1, 0, 'F', '0', '0', 'demo:demo:remove', '#', 'admin', '2021-05-30 00:39:23', '', NULL, '');
    382. 

  382. INSERT INTO `sys_menu` VALUES (1505, '测试单表导出', 1500, 5, '#', '', NULL, 1, 0, 'F', '0', '0', 'demo:demo:export', '#', 'admin', '2021-05-30 00:39:23', '', NULL, '');
    383. 

  383. INSERT INTO `sys_menu` VALUES (1506, '测试树表', 5, 1, 'tree', 'demo/tree/index', NULL, 1, 0, 'C', '0', '0', 'demo:tree:list', '#', 'admin', '2021-05-30 00:39:30', '', NULL, '测试树表菜单');
    384. 

  384. INSERT INTO `sys_menu` VALUES (1507, '测试树表查询', 1506, 1, '#', '', NULL, 1, 0, 'F', '0', '0', 'demo:tree:query', '#', 'admin', '2021-05-30 00:39:30', '', NULL, '');
    385. 

  385. INSERT INTO `sys_menu` VALUES (1508, '测试树表新增', 1506, 2, '#', '', NULL, 1, 0, 'F', '0', '0', 'demo:tree:add', '#', 'admin', '2021-05-30 00:39:30', '', NULL, '');
    386. 

  386. INSERT INTO `sys_menu` VALUES (1509, '测试树表修改', 1506, 3, '#', '', NULL, 1, 0, 'F', '0', '0', 'demo:tree:edit', '#', 'admin', '2021-05-30 00:39:30', '', NULL, '');
    387. 

  387. INSERT INTO `sys_menu` VALUES (1510, '测试树表删除', 1506, 4, '#', '', NULL, 1, 0, 'F', '0', '0', 'demo:tree:remove', '#', 'admin', '2021-05-30 00:39:30', '', NULL, '');
    388. 

  388. INSERT INTO `sys_menu` VALUES (1511, '测试树表导出', 1506, 5, '#', '', NULL, 1, 0, 'F', '0', '0', 'demo:tree:export', '#', 'admin', '2021-05-30 00:39:30', '', NULL, '');
    389. 

  389. INSERT INTO `sys_menu` VALUES (1600, '文件查询', 118, 1, '#', '', '', 1, 0, 'F', '0', '0', 'system:oss:query', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    390. 

  390. INSERT INTO `sys_menu` VALUES (1601, '文件上传', 118, 2, '#', '', '', 1, 0, 'F', '0', '0', 'system:oss:upload', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    391. 

  391. INSERT INTO `sys_menu` VALUES (1602, '文件下载', 118, 3, '#', '', '', 1, 0, 'F', '0', '0', 'system:oss:download', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    392. 

  392. INSERT INTO `sys_menu` VALUES (1603, '文件删除', 118, 4, '#', '', '', 1, 0, 'F', '0', '0', 'system:oss:remove', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    393. 

  393. INSERT INTO `sys_menu` VALUES (1604, '配置添加', 118, 5, '#', '', '', 1, 0, 'F', '0', '0', 'system:oss:add', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    394. 

  394. INSERT INTO `sys_menu` VALUES (1605, '配置编辑', 118, 6, '#', '', '', 1, 0, 'F', '0', '0', 'system:oss:edit', '#', 'admin', '2022-03-02 08:14:48', '', NULL, '');
    395. 

  395. 

  396. -- ----------------------------
    397. 

  397. -- Table structure for sys_notice
    398. 

  398. -- ----------------------------
    399. 

  399. DROP TABLE IF EXISTS `sys_notice`;
    400. 

  400. CREATE TABLE `sys_notice`  (
    401. 

  401.   `notice_id` int(0) NOT NULL AUTO_INCREMENT COMMENT '公告ID',
    402. 

  402.   `notice_title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '公告标题',
    403. 

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

  404.   `notice_content` longblob NULL COMMENT '公告内容',
    405. 

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

  406.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '创建者',
    407. 

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

  408.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '更新者',
    409. 

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

  410.   `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
    411. 

  411.   PRIMARY KEY (`notice_id`) USING BTREE
    412. 

  412. ) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '通知公告表' ROW_FORMAT = Dynamic;
    413. 

  413. 

  414. -- ----------------------------
    415. 

  415. -- Records of sys_notice
    416. 

  416. -- ----------------------------
    417. 

  417. INSERT INTO `sys_notice` VALUES (1, '温馨提醒：2018-07-01 新版本发布啦', '2', 0xE696B0E78988E69CACE58685E5AEB9, '0', 'admin', '2022-03-02 08:14:53', '', NULL, '管理员');
    418. 

  418. INSERT INTO `sys_notice` VALUES (2, '维护通知：2018-07-01 系统凌晨维护', '1', 0xE7BBB4E68AA4E58685E5AEB9, '0', 'admin', '2022-03-02 08:14:53', '', NULL, '管理员');
    419. 

  419. 

  420. -- ----------------------------
    421. 

  421. -- Table structure for sys_oper_log
    422. 

  422. -- ----------------------------
    423. 

  423. DROP TABLE IF EXISTS `sys_oper_log`;
    424. 

  424. CREATE TABLE `sys_oper_log`  (
    425. 

  425.   `oper_id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '日志主键',
    426. 

  426.   `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '模块标题',
    427. 

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

  428.   `method` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '方法名称',
    429. 

  429.   `request_method` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '请求方式',
    430. 

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

  431.   `oper_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '操作人员',
    432. 

  432.   `dept_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '部门名称',
    433. 

  433.   `oper_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '请求URL',
    434. 

  434.   `oper_ip` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '主机地址',
    435. 

  435.   `oper_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '操作地点',
    436. 

  436.   `oper_param` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '请求参数',
    437. 

  437.   `json_result` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '返回参数',
    438. 

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

  439.   `error_msg` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '错误消息',
    440. 

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

  441.   PRIMARY KEY (`oper_id`) USING BTREE
    442. 

  442. ) ENGINE = InnoDB AUTO_INCREMENT = 156 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '操作日志记录' ROW_FORMAT = Dynamic;
    443. 

  443. 

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

  445. -- Records of sys_oper_log
    446. 

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

  447. INSERT INTO `sys_oper_log` VALUES (100, '代码生成', 6, 'com.ruoyi.generator.controller.GenController.importTableSave()', 'POST', 1, 'admin', '', '/tool/gen/importTable', '127.0.0.1', '内网IP', '\"test_api\"', '{\"code\":200,\"msg\":\"操作成功\",\"data\":null}', 0, '', '2022-03-02 16:47:54');
    448. 

  448. INSERT INTO `sys_oper_log` VALUES (101, '代码生成', 2, 'com.ruoyi.generator.controller.GenController.editSave()', 'PUT', 1, 'admin', '', '/tool/gen', '127.0.0.1', '内网IP', '{\"searchValue\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":\"admin\",\"updateTime\":\"2022-03-02 16:48:35\",\"params\":{\"treeCode\":null,\"treeName\":null,\"treeParentCode\":null,\"parentMenuId\":null},\"tableId\":1,\"tableName\":\"test_api\",\"tableComment\":\"测试\",\"subTableName\":null,\"subTableFkName\":null,\"className\":\"TestApi\",\"tplCategory\":\"crud\",\"packageName\":\"com.ruoyi.generator\",\"moduleName\":\"generator\",\"businessName\":\"test\",\"functionName\":\"测试\",\"functionAuthor\":\"ruoyi\",\"genType\":\"1\",\"genPath\":\"E:\\\\git_workspace\\\\basic-code\\\\basic_system_plus_admin_code\\\\ruoyi-generator\\\\src\",\"pkColumn\":null,\"subTable\":null,\"columns\":[{\"searchValue\":null,\"createBy\":\"admin\",\"createTime\":\"2022-03-02 16:47:54\",\"updateBy\":\"admin\",\"updateTime\":\"2022-03-02 16:48:35\",\"params\":{},\"columnId\":1,\"tableId\":1,\"columnName\":\"id\",\"columnComment\":\"主键\",\"columnType\":\"bigint\",\"javaType\":\"Long\",\"javaField\":\"id\",\"isPk\":\"1\",\"isIncrement\":\"1\",\"isRequired\":\"1\",\"isInsert\":null,\"isEdit\":\"1\",\"isList\":\"1\",\"isQuery\":null,\"queryType\":\"EQ\",\"htmlType\":\"input\",\"dictType\":\"\",\"sort\":1,\"required\":true,\"list\":true,\"insert\":false,\"usableColumn\":false,\"superColumn\":false,\"pk\":true,\"edit\":true,\"query\":false,\"capJavaField\":\"id\",\"increment\":true},{\"searchValue\":null,\"createBy\":\"admin\",\"createTime\":\"2022-03-02 16:47:54\",\"updateBy\":\"admin\",\"updateTime\":\"2022-03-02 16:48:35\",\"params\":{},\"columnId\":2,\"tableId\":1,\"columnName\":\"name\",\"columnComment\":\"名称\",\"columnType\":\"varchar(1000)\",\"javaType\":\"String\",\"javaField\":\"name\",\"isPk\":\"0\",\"isIncrement\":\"0\",\"isRequired\":\"1\",\"isInsert\":\"1\",\"isEdit\":\"1\",\"isList\":\"1\",\"isQuery\":\"1\",\"queryType\":\"LIKE\",\"htmlType\":\"textarea\",\"dictType\":\"\",\"sort\":2,\"required\":true,\"list\":true,\"insert\":true,\"usableColumn\":false,\"superColumn\":false,\"pk\":false,\"edit\":true,\"query\":true,\"capJavaField\":\"name\",\"increment\":false},{\"searchValue\":null,\"createBy\":\"admin\",\"createTime\":\"2022-03-02 16:47:54\",\"updateBy\":\"admin\",\"updateTime\":\"2022-03-02 16:48:35\",\"params\":{},\"columnId\":3,\"tableId\":1,\"columnName\":\"time\",\"columnComment\":\"\",\"col', '{\"code\":200,\"msg\":\"操作成功\",\"data\":null}', 0, '', '2022-03-02 16:48:35');
    449. 

  449. INSERT INTO `sys_oper_log` VALUES (102, '代码生成', 8, 'com.ruoyi.generator.controller.GenController.genCode()', 'GET', 1, 'admin', '', '/tool/gen/genCode/test_api', '127.0.0.1', '内网IP', '{tableName=test_api}', '{\"code\":200,\"msg\":\"操作成功\",\"data\":null}', 0, '', '2022-03-02 16:48:38');
    450. 

  450. INSERT INTO `sys_oper_log` VALUES (103, '代码生成', 6, 'com.ruoyi.generator.controller.GenController.importTableSave()', 'POST', 1, 'admin', '', '/tool/gen/importTable', '127.0.0.1', '内网IP', '\"tb_user,tb_user_third_identity\"', '{\"code\":200,\"msg\":\"操作成功\",\"data\":null}', 0, '', '2022-03-03 18:35:24');
    451. 

  451. INSERT INTO `sys_oper_log` VALUES (104, '代码生成', 2, 'com.ruoyi.generator.controller.GenController.editSave()', 'PUT', 1, 'admin', '', '/tool/gen', '127.0.0.1', '内网IP', '{\"searchValue\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":\"admin\",\"updateTime\":\"2022-03-03 18:35:52\",\"params\":{\"treeCode\":null,\"treeName\":null,\"treeParentCode\":null,\"parentMenuId\":null},\"tableId\":2,\"tableName\":\"tb_user\",\"tableComment\":\"小程序用户管理\",\"subTableName\":null,\"subTableFkName\":null,\"className\":\"TbUser\",\"tplCategory\":\"crud\",\"packageName\":\"com.ruoyi.user\",\"moduleName\":\"api\",\"businessName\":\"user\",\"functionName\":\"小程序用户管理\",\"functionAuthor\":\"ruoyi\",\"genType\":\"1\",\"genPath\":\"E:\\\\git_workspace\\\\basic-code\\\\basic_system_plus_admin_code\\\\ruoyi-user\\\\src\",\"pkColumn\":null,\"subTable\":null,\"columns\":[{\"searchValue\":null,\"createBy\":\"admin\",\"createTime\":\"2022-03-03 18:35:23\",\"updateBy\":\"admin\",\"updateTime\":\"2022-03-03 18:35:52\",\"params\":{},\"columnId\":6,\"tableId\":2,\"columnName\":\"id\",\"columnComment\":\"\",\"columnType\":\"bigint\",\"javaType\":\"Long\",\"javaField\":\"id\",\"isPk\":\"1\",\"isIncrement\":\"1\",\"isRequired\":\"1\",\"isInsert\":null,\"isEdit\":\"1\",\"isList\":\"1\",\"isQuery\":null,\"queryType\":\"EQ\",\"htmlType\":\"input\",\"dictType\":\"\",\"sort\":1,\"required\":true,\"list\":true,\"pk\":true,\"edit\":true,\"insert\":false,\"superColumn\":false,\"usableColumn\":false,\"query\":false,\"capJavaField\":\"id\",\"increment\":true},{\"searchValue\":null,\"createBy\":\"admin\",\"createTime\":\"2022-03-03 18:35:23\",\"updateBy\":\"admin\",\"updateTime\":\"2022-03-03 18:35:52\",\"params\":{},\"columnId\":7,\"tableId\":2,\"columnName\":\"mobile\",\"columnComment\":\"手机号\",\"columnType\":\"varchar(20)\",\"javaType\":\"String\",\"javaField\":\"mobile\",\"isPk\":\"0\",\"isIncrement\":\"0\",\"isRequired\":\"1\",\"isInsert\":\"1\",\"isEdit\":\"1\",\"isList\":\"1\",\"isQuery\":\"1\",\"queryType\":\"EQ\",\"htmlType\":\"input\",\"dictType\":\"\",\"sort\":2,\"required\":true,\"list\":true,\"pk\":false,\"edit\":true,\"insert\":true,\"superColumn\":false,\"usableColumn\":false,\"query\":true,\"capJavaField\":\"mobile\",\"increment\":false},{\"searchValue\":null,\"createBy\":\"admin\",\"createTime\":\"2022-03-03 18:35:23\",\"updateBy\":\"admin\",\"updateTime\":\"2022-03-03 18:35:52\",\"params\":{},\"columnId\":8,\"tableId\":2,\"columnName\":\"nickname\",\"columnComment\":\"昵称\",\"columnT', '{\"code\":200,\"msg\":\"操作成功\",\"data\":null}', 0, '', '2022-03-03 18:35:53');
    452. 

  452. INSERT INTO `sys_oper_log` VALUES (105, '代码生成', 2, 'com.ruoyi.generator.controller.GenController.editSave()', 'PUT', 1, 'admin', '', '/tool/gen', '127.0.0.1', '内网IP', '{\"searchValue\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":\"admin\",\"updateTime\":\"2022-03-03 18:36:12\",\"params\":{\"treeCode\":null,\"treeName\":null,\"treeParentCode\":null,\"parentMenuId\":null},\"tableId\":3,\"tableName\":\"tb_user_third_identity\",\"tableComment\":\"小程序用户在第三方平台中的身份（如果在小程序中的openid）\",\"subTableName\":null,\"subTableFkName\":null,\"className\":\"TbUserThirdIdentity\",\"tplCategory\":\"crud\",\"packageName\":\"com.ruoyi.user\",\"moduleName\":\"api\",\"businessName\":\"userThirdIdentity\",\"functionName\":\"小程序用户在第三方平台中的身份（如果在小程序中的openid）\",\"functionAuthor\":\"ruoyi\",\"genType\":\"1\",\"genPath\":\"E:\\\\git_workspace\\\\basic-code\\\\basic_system_plus_admin_code\\\\ruoyi-user\\\\src\",\"pkColumn\":null,\"subTable\":null,\"columns\":[{\"searchValue\":null,\"createBy\":\"admin\",\"createTime\":\"2022-03-03 18:35:23\",\"updateBy\":\"admin\",\"updateTime\":\"2022-03-03 18:36:12\",\"params\":{},\"columnId\":18,\"tableId\":3,\"columnName\":\"id\",\"columnComment\":\"\",\"columnType\":\"bigint\",\"javaType\":\"Long\",\"javaField\":\"id\",\"isPk\":\"1\",\"isIncrement\":\"1\",\"isRequired\":\"1\",\"isInsert\":null,\"isEdit\":\"1\",\"isList\":\"1\",\"isQuery\":null,\"queryType\":\"EQ\",\"htmlType\":\"input\",\"dictType\":\"\",\"sort\":1,\"required\":true,\"list\":true,\"pk\":true,\"edit\":true,\"insert\":false,\"superColumn\":false,\"usableColumn\":false,\"query\":false,\"capJavaField\":\"id\",\"increment\":true},{\"searchValue\":null,\"createBy\":\"admin\",\"createTime\":\"2022-03-03 18:35:23\",\"updateBy\":\"admin\",\"updateTime\":\"2022-03-03 18:36:12\",\"params\":{},\"columnId\":19,\"tableId\":3,\"columnName\":\"identity_code\",\"columnComment\":\"identity_code(如果是微信就是open_id的值，其它也是)\",\"columnType\":\"varchar(50)\",\"javaType\":\"String\",\"javaField\":\"identityCode\",\"isPk\":\"0\",\"isIncrement\":\"0\",\"isRequired\":\"1\",\"isInsert\":\"1\",\"isEdit\":\"1\",\"isList\":\"1\",\"isQuery\":\"1\",\"queryType\":\"EQ\",\"htmlType\":\"input\",\"dictType\":\"\",\"sort\":2,\"required\":true,\"list\":true,\"pk\":false,\"edit\":true,\"insert\":true,\"superColumn\":false,\"usableColumn\":false,\"query\":true,\"capJavaField\":\"identityCode\",\"increment\":false},{\"searchValue\":null,\"createBy\":\"admin\",\"createTime\":\"2022-03-03 18:35:23\",\"', '{\"code\":200,\"msg\":\"操作成功\",\"data\":null}', 0, '', '2022-03-03 18:36:13');
    453. 

  453. INSERT INTO `sys_oper_log` VALUES (106, '代码生成', 8, 'com.ruoyi.generator.controller.GenController.genCode()', 'GET', 1, 'admin', '', '/tool/gen/genCode/tb_user', '127.0.0.1', '内网IP', '{tableName=tb_user}', '{\"code\":200,\"msg\":\"操作成功\",\"data\":null}', 0, '', '2022-03-03 18:36:15');
    454. 

  454. INSERT INTO `sys_oper_log` VALUES (107, '代码生成', 2, 'com.ruoyi.generator.controller.GenController.editSave()', 'PUT', 1, 'admin', '', '/tool/gen', '127.0.0.1', '内网IP', '{\"searchValue\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":\"admin\",\"updateTime\":\"2022-03-03 18:38:28\",\"params\":{\"treeCode\":null,\"treeName\":null,\"treeParentCode\":null,\"parentMenuId\":null},\"tableId\":2,\"tableName\":\"tb_user\",\"tableComment\":\"小程序用户管理\",\"subTableName\":null,\"subTableFkName\":null,\"className\":\"User\",\"tplCategory\":\"crud\",\"packageName\":\"com.ruoyi.user\",\"moduleName\":\"api\",\"businessName\":\"user\",\"functionName\":\"小程序用户管理\",\"functionAuthor\":\"wuchao\",\"genType\":\"1\",\"genPath\":\"E:\\\\git_workspace\\\\basic-code\\\\basic_system_plus_admin_code\\\\ruoyi-user\\\\src\",\"pkColumn\":null,\"subTable\":null,\"columns\":[{\"searchValue\":null,\"createBy\":\"admin\",\"createTime\":\"2022-03-03 18:35:23\",\"updateBy\":\"admin\",\"updateTime\":\"2022-03-03 18:38:28\",\"params\":{},\"columnId\":6,\"tableId\":2,\"columnName\":\"id\",\"columnComment\":\"\",\"columnType\":\"bigint\",\"javaType\":\"Long\",\"javaField\":\"id\",\"isPk\":\"1\",\"isIncrement\":\"1\",\"isRequired\":\"1\",\"isInsert\":null,\"isEdit\":\"1\",\"isList\":\"1\",\"isQuery\":null,\"queryType\":\"EQ\",\"htmlType\":\"input\",\"dictType\":\"\",\"sort\":1,\"required\":true,\"list\":true,\"pk\":true,\"edit\":true,\"insert\":false,\"superColumn\":false,\"usableColumn\":false,\"query\":false,\"capJavaField\":\"id\",\"increment\":true},{\"searchValue\":null,\"createBy\":\"admin\",\"createTime\":\"2022-03-03 18:35:23\",\"updateBy\":\"admin\",\"updateTime\":\"2022-03-03 18:38:28\",\"params\":{},\"columnId\":7,\"tableId\":2,\"columnName\":\"mobile\",\"columnComment\":\"手机号\",\"columnType\":\"varchar(20)\",\"javaType\":\"String\",\"javaField\":\"mobile\",\"isPk\":\"0\",\"isIncrement\":\"0\",\"isRequired\":\"1\",\"isInsert\":\"1\",\"isEdit\":\"1\",\"isList\":\"1\",\"isQuery\":\"1\",\"queryType\":\"EQ\",\"htmlType\":\"input\",\"dictType\":\"\",\"sort\":2,\"required\":true,\"list\":true,\"pk\":false,\"edit\":true,\"insert\":true,\"superColumn\":false,\"usableColumn\":false,\"query\":true,\"capJavaField\":\"mobile\",\"increment\":false},{\"searchValue\":null,\"createBy\":\"admin\",\"createTime\":\"2022-03-03 18:35:23\",\"updateBy\":\"admin\",\"updateTime\":\"2022-03-03 18:38:28\",\"params\":{},\"columnId\":8,\"tableId\":2,\"columnName\":\"nickname\",\"columnComment\":\"昵称\",\"columnTy', '{\"code\":200,\"msg\":\"操作成功\",\"data\":null}', 0, '', '2022-03-03 18:38:29');
    455. 

  455. INSERT INTO `sys_oper_log` VALUES (108, '代码生成', 2, 'com.ruoyi.generator.controller.GenController.editSave()', 'PUT', 1, 'admin', '', '/tool/gen', '127.0.0.1', '内网IP', '{\"searchValue\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":\"admin\",\"updateTime\":\"2022-03-03 18:38:46\",\"params\":{\"treeCode\":null,\"treeName\":null,\"treeParentCode\":null,\"parentMenuId\":null},\"tableId\":2,\"tableName\":\"tb_user\",\"tableComment\":\"小程序用户管理\",\"subTableName\":null,\"subTableFkName\":null,\"className\":\"User\",\"tplCategory\":\"crud\",\"packageName\":\"com.ruoyi.user\",\"moduleName\":\"api\",\"businessName\":\"user\",\"functionName\":\"小程序用户管理\",\"functionAuthor\":\"wuchao\",\"genType\":\"1\",\"genPath\":\"E:\\\\git_workspace\\\\basic-code\\\\basic_system_plus_admin_code\\\\ruoyi-user\\\\src\",\"pkColumn\":null,\"subTable\":null,\"columns\":[{\"searchValue\":null,\"createBy\":\"admin\",\"createTime\":\"2022-03-03 18:35:23\",\"updateBy\":\"admin\",\"updateTime\":\"2022-03-03 18:38:46\",\"params\":{},\"columnId\":6,\"tableId\":2,\"columnName\":\"id\",\"columnComment\":\"\",\"columnType\":\"bigint\",\"javaType\":\"Long\",\"javaField\":\"id\",\"isPk\":\"1\",\"isIncrement\":\"1\",\"isRequired\":\"1\",\"isInsert\":null,\"isEdit\":\"1\",\"isList\":\"1\",\"isQuery\":null,\"queryType\":\"EQ\",\"htmlType\":\"input\",\"dictType\":\"\",\"sort\":1,\"required\":true,\"list\":true,\"pk\":true,\"edit\":true,\"insert\":false,\"superColumn\":false,\"usableColumn\":false,\"query\":false,\"capJavaField\":\"id\",\"increment\":true},{\"searchValue\":null,\"createBy\":\"admin\",\"createTime\":\"2022-03-03 18:35:23\",\"updateBy\":\"admin\",\"updateTime\":\"2022-03-03 18:38:46\",\"params\":{},\"columnId\":7,\"tableId\":2,\"columnName\":\"mobile\",\"columnComment\":\"手机号\",\"columnType\":\"varchar(20)\",\"javaType\":\"String\",\"javaField\":\"mobile\",\"isPk\":\"0\",\"isIncrement\":\"0\",\"isRequired\":\"1\",\"isInsert\":\"1\",\"isEdit\":\"1\",\"isList\":\"1\",\"isQuery\":\"1\",\"queryType\":\"EQ\",\"htmlType\":\"input\",\"dictType\":\"\",\"sort\":2,\"required\":true,\"list\":true,\"pk\":false,\"edit\":true,\"insert\":true,\"superColumn\":false,\"usableColumn\":false,\"query\":true,\"capJavaField\":\"mobile\",\"increment\":false},{\"searchValue\":null,\"createBy\":\"admin\",\"createTime\":\"2022-03-03 18:35:23\",\"updateBy\":\"admin\",\"updateTime\":\"2022-03-03 18:38:46\",\"params\":{},\"columnId\":8,\"tableId\":2,\"columnName\":\"nickname\",\"columnComment\":\"昵称\",\"columnTy', '{\"code\":200,\"msg\":\"操作成功\",\"data\":null}', 0, '', '2022-03-03 18:38:47');
    456. 

  456. INSERT INTO `sys_oper_log` VALUES (109, '代码生成', 8, 'com.ruoyi.generator.controller.GenController.genCode()', 'GET', 1, 'admin', '', '/tool/gen/genCode/tb_user', '127.0.0.1', '内网IP', '{tableName=tb_user}', '{\"code\":200,\"msg\":\"操作成功\",\"data\":null}', 0, '', '2022-03-03 18:38:49');
    457. 

  457. INSERT INTO `sys_oper_log` VALUES (110, '代码生成', 2, 'com.ruoyi.generator.controller.GenController.editSave()', 'PUT', 1, 'admin', '', '/tool/gen', '127.0.0.1', '内网IP', '{\"searchValue\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":\"admin\",\"updateTime\":\"2022-03-03 18:55:20\",\"params\":{\"treeCode\":null,\"treeName\":null,\"treeParentCode\":null,\"parentMenuId\":null},\"tableId\":3,\"tableName\":\"tb_user_third_identity\",\"tableComment\":\"小程序用户在第三方平台中的身份（如果在小程序中的openid）\",\"subTableName\":null,\"subTableFkName\":null,\"className\":\"UserThirdIdentity\",\"tplCategory\":\"crud\",\"packageName\":\"com.ruoyi.user\",\"moduleName\":\"user\",\"businessName\":\"userThirdIdentity\",\"functionName\":\"小程序用户在第三方平台中的身份（如果在小程序中的openid）\",\"functionAuthor\":\"ruoyi\",\"genType\":\"1\",\"genPath\":\"E:\\\\git_workspace\\\\basic-code\\\\basic_system_plus_admin_code\\\\ruoyi-user\\\\src\",\"pkColumn\":null,\"subTable\":null,\"columns\":[{\"searchValue\":null,\"createBy\":\"admin\",\"createTime\":\"2022-03-03 18:35:23\",\"updateBy\":\"admin\",\"updateTime\":\"2022-03-03 18:55:20\",\"params\":{},\"columnId\":18,\"tableId\":3,\"columnName\":\"id\",\"columnComment\":\"\",\"columnType\":\"bigint\",\"javaType\":\"Long\",\"javaField\":\"id\",\"isPk\":\"1\",\"isIncrement\":\"1\",\"isRequired\":\"1\",\"isInsert\":null,\"isEdit\":\"1\",\"isList\":\"1\",\"isQuery\":null,\"queryType\":\"EQ\",\"htmlType\":\"input\",\"dictType\":\"\",\"sort\":1,\"required\":true,\"list\":true,\"pk\":true,\"edit\":true,\"insert\":false,\"superColumn\":false,\"usableColumn\":false,\"query\":false,\"capJavaField\":\"id\",\"increment\":true},{\"searchValue\":null,\"createBy\":\"admin\",\"createTime\":\"2022-03-03 18:35:23\",\"updateBy\":\"admin\",\"updateTime\":\"2022-03-03 18:55:20\",\"params\":{},\"columnId\":19,\"tableId\":3,\"columnName\":\"identity_code\",\"columnComment\":\"identity_code(如果是微信就是open_id的值，其它也是)\",\"columnType\":\"varchar(50)\",\"javaType\":\"String\",\"javaField\":\"identityCode\",\"isPk\":\"0\",\"isIncrement\":\"0\",\"isRequired\":\"1\",\"isInsert\":\"1\",\"isEdit\":\"1\",\"isList\":\"1\",\"isQuery\":\"1\",\"queryType\":\"EQ\",\"htmlType\":\"input\",\"dictType\":\"\",\"sort\":2,\"required\":true,\"list\":true,\"pk\":false,\"edit\":true,\"insert\":true,\"superColumn\":false,\"usableColumn\":false,\"query\":true,\"capJavaField\":\"identityCode\",\"increment\":false},{\"searchValue\":null,\"createBy\":\"admin\",\"createTime\":\"2022-03-03 18:35:23\",\"u', '{\"code\":200,\"msg\":\"操作成功\",\"data\":null}', 0, '', '2022-03-03 18:55:21');
    458. 

  458. INSERT INTO `sys_oper_log` VALUES (111, '代码生成', 2, 'com.ruoyi.generator.controller.GenController.editSave()', 'PUT', 1, 'admin', '', '/tool/gen', '127.0.0.1', '内网IP', '{\"searchValue\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":\"admin\",\"updateTime\":\"2022-03-03 18:55:29\",\"params\":{\"treeCode\":null,\"treeName\":null,\"treeParentCode\":null,\"parentMenuId\":null},\"tableId\":3,\"tableName\":\"tb_user_third_identity\",\"tableComment\":\"小程序用户在第三方平台中的身份（如果在小程序中的openid）\",\"subTableName\":null,\"subTableFkName\":null,\"className\":\"UserThirdIdentity\",\"tplCategory\":\"crud\",\"packageName\":\"com.ruoyi.user\",\"moduleName\":\"user\",\"businessName\":\"thirdIdentity\",\"functionName\":\"小程序用户在第三方平台中的身份（如果在小程序中的openid）\",\"functionAuthor\":\"ruoyi\",\"genType\":\"1\",\"genPath\":\"E:\\\\git_workspace\\\\basic-code\\\\basic_system_plus_admin_code\\\\ruoyi-user\\\\src\",\"pkColumn\":null,\"subTable\":null,\"columns\":[{\"searchValue\":null,\"createBy\":\"admin\",\"createTime\":\"2022-03-03 18:35:23\",\"updateBy\":\"admin\",\"updateTime\":\"2022-03-03 18:55:29\",\"params\":{},\"columnId\":18,\"tableId\":3,\"columnName\":\"id\",\"columnComment\":\"\",\"columnType\":\"bigint\",\"javaType\":\"Long\",\"javaField\":\"id\",\"isPk\":\"1\",\"isIncrement\":\"1\",\"isRequired\":\"1\",\"isInsert\":null,\"isEdit\":\"1\",\"isList\":\"1\",\"isQuery\":null,\"queryType\":\"EQ\",\"htmlType\":\"input\",\"dictType\":\"\",\"sort\":1,\"required\":true,\"list\":true,\"pk\":true,\"edit\":true,\"insert\":false,\"superColumn\":false,\"usableColumn\":false,\"query\":false,\"capJavaField\":\"id\",\"increment\":true},{\"searchValue\":null,\"createBy\":\"admin\",\"createTime\":\"2022-03-03 18:35:23\",\"updateBy\":\"admin\",\"updateTime\":\"2022-03-03 18:55:29\",\"params\":{},\"columnId\":19,\"tableId\":3,\"columnName\":\"identity_code\",\"columnComment\":\"identity_code(如果是微信就是open_id的值，其它也是)\",\"columnType\":\"varchar(50)\",\"javaType\":\"String\",\"javaField\":\"identityCode\",\"isPk\":\"0\",\"isIncrement\":\"0\",\"isRequired\":\"1\",\"isInsert\":\"1\",\"isEdit\":\"1\",\"isList\":\"1\",\"isQuery\":\"1\",\"queryType\":\"EQ\",\"htmlType\":\"input\",\"dictType\":\"\",\"sort\":2,\"required\":true,\"list\":true,\"pk\":false,\"edit\":true,\"insert\":true,\"superColumn\":false,\"usableColumn\":false,\"query\":true,\"capJavaField\":\"identityCode\",\"increment\":false},{\"searchValue\":null,\"createBy\":\"admin\",\"createTime\":\"2022-03-03 18:35:23\",\"updat', '{\"code\":200,\"msg\":\"操作成功\",\"data\":null}', 0, '', '2022-03-03 18:55:29');
    459. 

  459. INSERT INTO `sys_oper_log` VALUES (112, '代码生成', 8, 'com.ruoyi.generator.controller.GenController.genCode()', 'GET', 1, 'admin', '', '/tool/gen/genCode/tb_user_third_identity', '127.0.0.1', '内网IP', '{tableName=tb_user_third_identity}', '{\"code\":200,\"msg\":\"操作成功\",\"data\":null}', 0, '', '2022-03-03 18:55:31');
    460. 

  460. INSERT INTO `sys_oper_log` VALUES (113, '代码生成', 8, 'com.ruoyi.generator.controller.GenController.genCode()', 'GET', 1, 'admin', '', '/tool/gen/genCode/test_api', '127.0.0.1', '内网IP', '{tableName=test_api}', '{\"code\":200,\"msg\":\"操作成功\",\"data\":null}', 0, '', '2022-03-04 09:09:39');
    461. 

  461. INSERT INTO `sys_oper_log` VALUES (114, '代码生成', 8, 'com.ruoyi.generator.controller.GenController.genCode()', 'GET', 1, 'admin', '', '/tool/gen/genCode/test_api', '127.0.0.1', '内网IP', '{tableName=test_api}', '{\"code\":200,\"msg\":\"操作成功\",\"data\":null}', 0, '', '2022-03-04 09:09:39');
    462. 

  462. INSERT INTO `sys_oper_log` VALUES (115, '代码生成', 2, 'com.ruoyi.generator.controller.GenController.editSave()', 'PUT', 1, 'admin', '', '/tool/gen', '127.0.0.1', '内网IP', '{\"searchValue\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":\"admin\",\"updateTime\":\"2022-03-04 09:10:43\",\"params\":{\"treeCode\":null,\"treeName\":null,\"treeParentCode\":null,\"parentMenuId\":null},\"tableId\":1,\"tableName\":\"test_api\",\"tableComment\":\"测试\",\"subTableName\":null,\"subTableFkName\":null,\"className\":\"TestApi\",\"tplCategory\":\"crud\",\"packageName\":\"com.ruoyi.generator\",\"moduleName\":\"generator\",\"businessName\":\"test\",\"functionName\":\"测试\",\"functionAuthor\":\"ruoyi\",\"genType\":\"1\",\"genPath\":\"E:\\\\git_workspace\\\\basic-code\\\\basic_system_plus_admin_code\\\\ruoyi-demo\\\\src\",\"pkColumn\":null,\"subTable\":null,\"columns\":[{\"searchValue\":null,\"createBy\":\"admin\",\"createTime\":\"2022-03-02 16:47:54\",\"updateBy\":\"admin\",\"updateTime\":\"2022-03-04 09:10:43\",\"params\":{},\"columnId\":1,\"tableId\":1,\"columnName\":\"id\",\"columnComment\":\"主键\",\"columnType\":\"bigint\",\"javaType\":\"Long\",\"javaField\":\"id\",\"isPk\":\"1\",\"isIncrement\":\"1\",\"isRequired\":\"1\",\"isInsert\":null,\"isEdit\":\"1\",\"isList\":\"1\",\"isQuery\":null,\"queryType\":\"EQ\",\"htmlType\":\"input\",\"dictType\":\"\",\"sort\":1,\"list\":true,\"required\":true,\"pk\":true,\"superColumn\":false,\"insert\":false,\"edit\":true,\"usableColumn\":false,\"query\":false,\"capJavaField\":\"id\",\"increment\":true},{\"searchValue\":null,\"createBy\":\"admin\",\"createTime\":\"2022-03-02 16:47:54\",\"updateBy\":\"admin\",\"updateTime\":\"2022-03-04 09:10:43\",\"params\":{},\"columnId\":2,\"tableId\":1,\"columnName\":\"name\",\"columnComment\":\"名称\",\"columnType\":\"varchar(1000)\",\"javaType\":\"String\",\"javaField\":\"name\",\"isPk\":\"0\",\"isIncrement\":\"0\",\"isRequired\":\"1\",\"isInsert\":\"1\",\"isEdit\":\"1\",\"isList\":\"1\",\"isQuery\":\"1\",\"queryType\":\"LIKE\",\"htmlType\":\"textarea\",\"dictType\":\"\",\"sort\":2,\"list\":true,\"required\":true,\"pk\":false,\"superColumn\":false,\"insert\":true,\"edit\":true,\"usableColumn\":false,\"query\":true,\"capJavaField\":\"name\",\"increment\":false},{\"searchValue\":null,\"createBy\":\"admin\",\"createTime\":\"2022-03-02 16:47:54\",\"updateBy\":\"admin\",\"updateTime\":\"2022-03-04 09:10:43\",\"params\":{},\"columnId\":3,\"tableId\":1,\"columnName\":\"time\",\"columnComment\":\"\",\"columnTy', '{\"code\":200,\"msg\":\"操作成功\",\"data\":null}', 0, '', '2022-03-04 09:10:44');
    463. 

  463. INSERT INTO `sys_oper_log` VALUES (116, '代码生成', 2, 'com.ruoyi.generator.controller.GenController.synchDb()', 'GET', 1, 'admin', '', '/tool/gen/synchDb/test_api', '127.0.0.1', '内网IP', '{tableName=test_api}', '{\"code\":200,\"msg\":\"操作成功\",\"data\":null}', 0, '', '2022-03-04 09:10:48');
    464. 

  464. INSERT INTO `sys_oper_log` VALUES (117, '代码生成', 2, 'com.ruoyi.generator.controller.GenController.editSave()', 'PUT', 1, 'admin', '', '/tool/gen', '127.0.0.1', '内网IP', '{\"searchValue\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":\"admin\",\"updateTime\":\"2022-03-04 09:11:41\",\"params\":{\"treeCode\":null,\"treeName\":null,\"treeParentCode\":null,\"parentMenuId\":null},\"tableId\":1,\"tableName\":\"test_api\",\"tableComment\":\"测试\",\"subTableName\":null,\"subTableFkName\":null,\"className\":\"TestApi\",\"tplCategory\":\"crud\",\"packageName\":\"com.ruoyi.demo\",\"moduleName\":\"demo\",\"businessName\":\"test\",\"functionName\":\"测试\",\"functionAuthor\":\"w\",\"genType\":\"1\",\"genPath\":\"E:\\\\git_workspace\\\\basic-code\\\\basic_system_plus_admin_code\\\\ruoyi-demo\\\\src\",\"pkColumn\":null,\"subTable\":null,\"columns\":[{\"searchValue\":null,\"createBy\":\"admin\",\"createTime\":\"2022-03-02 16:47:54\",\"updateBy\":\"admin\",\"updateTime\":\"2022-03-04 09:11:41\",\"params\":{},\"columnId\":1,\"tableId\":1,\"columnName\":\"id\",\"columnComment\":\"主键\",\"columnType\":\"bigint\",\"javaType\":\"Long\",\"javaField\":\"id\",\"isPk\":\"1\",\"isIncrement\":\"1\",\"isRequired\":\"1\",\"isInsert\":null,\"isEdit\":\"1\",\"isList\":\"1\",\"isQuery\":null,\"queryType\":\"EQ\",\"htmlType\":\"input\",\"dictType\":\"\",\"sort\":1,\"list\":true,\"required\":true,\"pk\":true,\"superColumn\":false,\"insert\":false,\"edit\":true,\"usableColumn\":false,\"query\":false,\"capJavaField\":\"id\",\"increment\":true},{\"searchValue\":null,\"createBy\":\"admin\",\"createTime\":\"2022-03-02 16:47:54\",\"updateBy\":\"admin\",\"updateTime\":\"2022-03-04 09:11:41\",\"params\":{},\"columnId\":2,\"tableId\":1,\"columnName\":\"name\",\"columnComment\":\"名称\",\"columnType\":\"varchar(1000)\",\"javaType\":\"String\",\"javaField\":\"name\",\"isPk\":\"0\",\"isIncrement\":\"0\",\"isRequired\":\"1\",\"isInsert\":\"1\",\"isEdit\":\"1\",\"isList\":\"1\",\"isQuery\":\"1\",\"queryType\":\"LIKE\",\"htmlType\":\"textarea\",\"dictType\":\"\",\"sort\":2,\"list\":true,\"required\":true,\"pk\":false,\"superColumn\":false,\"insert\":true,\"edit\":true,\"usableColumn\":false,\"query\":true,\"capJavaField\":\"name\",\"increment\":false},{\"searchValue\":null,\"createBy\":\"admin\",\"createTime\":\"2022-03-02 16:47:54\",\"updateBy\":\"admin\",\"updateTime\":\"2022-03-04 09:11:41\",\"params\":{},\"columnId\":3,\"tableId\":1,\"columnName\":\"time\",\"columnComment\":\"\",\"columnType\":\"datetime\"', '{\"code\":200,\"msg\":\"操作成功\",\"data\":null}', 0, '', '2022-03-04 09:11:42');
    465. 

  465. INSERT INTO `sys_oper_log` VALUES (118, '代码生成', 8, 'com.ruoyi.generator.controller.GenController.genCode()', 'GET', 1, 'admin', '', '/tool/gen/genCode/test_api', '127.0.0.1', '内网IP', '{tableName=test_api}', '{\"code\":200,\"msg\":\"操作成功\",\"data\":null}', 0, '', '2022-03-04 09:11:44');
    466. 

  466. INSERT INTO `sys_oper_log` VALUES (119, '代码生成', 2, 'com.ruoyi.generator.controller.GenController.synchDb()', 'GET', 1, 'admin', '', '/tool/gen/synchDb/test_api', '127.0.0.1', '内网IP', '{tableName=test_api}', '{\"code\":200,\"msg\":\"操作成功\",\"data\":null}', 0, '', '2022-03-18 16:54:20');
    467. 

  467. INSERT INTO `sys_oper_log` VALUES (120, '代码生成', 3, 'com.ruoyi.generator.controller.GenController.remove()', 'DELETE', 1, 'admin', '', '/tool/gen/1', '127.0.0.1', '内网IP', '{tableIds=1}', '{\"code\":200,\"msg\":\"操作成功\",\"data\":null}', 0, '', '2022-03-18 16:57:16');
    468. 

  468. INSERT INTO `sys_oper_log` VALUES (121, '代码生成', 3, 'com.ruoyi.generator.controller.GenController.remove()', 'DELETE', 1, 'admin', '', '/tool/gen/2', '127.0.0.1', '内网IP', '{tableIds=2}', '{\"code\":200,\"msg\":\"操作成功\",\"data\":null}', 0, '', '2022-03-18 16:57:19');
    469. 

  469. INSERT INTO `sys_oper_log` VALUES (122, '代码生成', 3, 'com.ruoyi.generator.controller.GenController.remove()', 'DELETE', 1, 'admin', '', '/tool/gen/3', '127.0.0.1', '内网IP', '{tableIds=3}', '{\"code\":200,\"msg\":\"操作成功\",\"data\":null}', 0, '', '2022-03-18 16:57:24');
    470. 

  470. INSERT INTO `sys_oper_log` VALUES (123, '代码生成', 3, 'com.ruoyi.generator.controller.GenController.remove()', 'DELETE', 1, 'admin', '', '/tool/gen/4', '127.0.0.1', '内网IP', '{tableIds=4}', '{\"code\":200,\"msg\":\"操作成功\",\"data\":null}', 0, '', '2022-03-18 17:05:30');
    471. 

  471. INSERT INTO `sys_oper_log` VALUES (124, '代码生成', 6, 'com.ruoyi.generator.controller.GenController.importTableSave()', 'POST', 1, 'admin', '', '/tool/gen/importTable', '127.0.0.1', '内网IP', '\"test_api\"', '{\"code\":200,\"msg\":\"操作成功\",\"data\":null}', 0, '', '2022-03-18 17:05:56');
    472. 

  472. INSERT INTO `sys_oper_log` VALUES (125, '代码生成', 3, 'com.ruoyi.generator.controller.GenController.remove()', 'DELETE', 1, 'admin', '', '/tool/gen/5', '127.0.0.1', '内网IP', '{tableIds=5}', '{\"code\":200,\"msg\":\"操作成功\",\"data\":null}', 0, '', '2022-03-18 17:06:26');
    473. 

  473. INSERT INTO `sys_oper_log` VALUES (126, '代码生成', 6, 'com.ruoyi.generator.controller.GenController.importTableSave()', 'POST', 1, 'admin', '', '/tool/gen/importTable', '127.0.0.1', '内网IP', '\"test_api\"', '{\"code\":200,\"msg\":\"操作成功\",\"data\":null}', 0, '', '2022-03-18 17:06:28');
    474. 

  474. INSERT INTO `sys_oper_log` VALUES (127, '代码生成', 3, 'com.ruoyi.generator.controller.GenController.remove()', 'DELETE', 1, 'admin', '', '/tool/gen/6', '127.0.0.1', '内网IP', '{tableIds=6}', '{\"code\":200,\"msg\":\"操作成功\",\"data\":null}', 0, '', '2022-03-18 17:06:38');
    475. 

  475. INSERT INTO `sys_oper_log` VALUES (128, '代码生成', 6, 'com.ruoyi.generator.controller.GenController.importTableSave()', 'POST', 1, 'admin', '', '/tool/gen/importTable', '127.0.0.1', '内网IP', '\"test_api\"', '{\"code\":200,\"msg\":\"操作成功\",\"data\":null}', 0, '', '2022-03-18 17:07:13');
    476. 

  476. INSERT INTO `sys_oper_log` VALUES (129, '代码生成', 3, 'com.ruoyi.generator.controller.GenController.remove()', 'DELETE', 1, 'admin', '', '/tool/gen/7', '127.0.0.1', '内网IP', '{tableIds=7}', '{\"code\":200,\"msg\":\"操作成功\",\"data\":null}', 0, '', '2022-03-18 17:07:40');
    477. 

  477. INSERT INTO `sys_oper_log` VALUES (130, '代码生成', 6, 'com.ruoyi.generator.controller.GenController.importTableSave()', 'POST', 1, 'admin', '', '/tool/gen/importTable', '127.0.0.1', '内网IP', '\"test_api\"', '{\"code\":200,\"msg\":\"操作成功\",\"data\":null}', 0, '', '2022-03-18 17:07:44');
    478. 

  478. INSERT INTO `sys_oper_log` VALUES (131, '代码生成', 3, 'com.ruoyi.generator.controller.GenController.remove()', 'DELETE', 1, 'admin', '', '/tool/gen/8', '127.0.0.1', '内网IP', '{tableIds=8}', '{\"code\":200,\"msg\":\"操作成功\",\"data\":null}', 0, '', '2022-03-18 17:08:41');
    479. 

  479. INSERT INTO `sys_oper_log` VALUES (132, '代码生成', 6, 'com.ruoyi.generator.controller.GenController.importTableSave()', 'POST', 1, 'admin', '', '/tool/gen/importTable', '127.0.0.1', '内网IP', '\"test_api\"', '{\"code\":200,\"msg\":\"操作成功\",\"data\":null}', 0, '', '2022-03-18 17:08:44');
    480. 

  480. INSERT INTO `sys_oper_log` VALUES (133, '代码生成', 2, 'com.ruoyi.generator.controller.GenController.synchDb()', 'GET', 1, 'admin', '', '/tool/gen/synchDb/test_api', '127.0.0.1', '内网IP', '{tableName=test_api}', '{\"code\":200,\"msg\":\"操作成功\",\"data\":null}', 0, '', '2022-03-18 17:34:52');
    481. 

  481. INSERT INTO `sys_oper_log` VALUES (134, '代码生成', 2, 'com.ruoyi.generator.controller.GenController.editSave()', 'PUT', 1, 'admin', '', '/tool/gen', '127.0.0.1', '内网IP', '{\"searchValue\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":\"admin\",\"updateTime\":\"2022-03-18 17:34:58\",\"params\":{\"treeCode\":null,\"treeName\":null,\"treeParentCode\":null,\"parentMenuId\":null},\"tableId\":9,\"tableName\":\"test_api\",\"tableComment\":\"测试\",\"subTableName\":null,\"subTableFkName\":null,\"className\":\"TestApi\",\"tplCategory\":\"crud\",\"packageName\":\"com.ruoyi.system\",\"moduleName\":\"system\",\"businessName\":\"api\",\"functionName\":\"测试\",\"functionAuthor\":\"ruoyi\",\"genType\":\"1\",\"genPath\":\"E:\\\\git_workspace\\\\basic-code\\\\basic_system_plus_admin_code\\\\ruoyi-demo\\\\src\",\"pkColumn\":null,\"subTable\":null,\"columns\":[{\"searchValue\":null,\"createBy\":\"admin\",\"createTime\":\"2022-03-18 17:08:44\",\"updateBy\":\"admin\",\"updateTime\":\"2022-03-18 17:34:58\",\"params\":{},\"columnId\":53,\"tableId\":9,\"columnName\":\"id\",\"columnComment\":\"主键\",\"columnType\":\"bigint\",\"javaType\":\"Long\",\"javaField\":\"id\",\"isPk\":\"1\",\"isIncrement\":\"1\",\"isRequired\":\"1\",\"isInsert\":null,\"isEdit\":\"1\",\"isList\":\"1\",\"isQuery\":null,\"queryType\":\"EQ\",\"htmlType\":\"input\",\"dictType\":\"\",\"sort\":1,\"query\":false,\"increment\":true,\"capJavaField\":\"id\",\"list\":true,\"required\":true,\"superColumn\":false,\"edit\":true,\"insert\":false,\"pk\":true,\"usableColumn\":false},{\"searchValue\":null,\"createBy\":\"admin\",\"createTime\":\"2022-03-18 17:08:44\",\"updateBy\":\"admin\",\"updateTime\":\"2022-03-18 17:34:58\",\"params\":{},\"columnId\":54,\"tableId\":9,\"columnName\":\"name\",\"columnComment\":\"名称\",\"columnType\":\"varchar(1000)\",\"javaType\":\"String\",\"javaField\":\"name\",\"isPk\":\"0\",\"isIncrement\":\"0\",\"isRequired\":\"1\",\"isInsert\":\"1\",\"isEdit\":\"1\",\"isList\":\"1\",\"isQuery\":\"1\",\"queryType\":\"LIKE\",\"htmlType\":\"textarea\",\"dictType\":\"\",\"sort\":2,\"query\":true,\"increment\":false,\"capJavaField\":\"name\",\"list\":true,\"required\":true,\"superColumn\":false,\"edit\":true,\"insert\":true,\"pk\":false,\"usableColumn\":false},{\"searchValue\":null,\"createBy\":\"admin\",\"createTime\":\"2022-03-18 17:08:44\",\"updateBy\":\"admin\",\"updateTime\":\"2022-03-18 17:34:58\",\"params\":{},\"columnId\":55,\"tableId\":9,\"columnName\":\"time\",\"columnComment\":\"\",\"columnType\":', '{\"code\":200,\"msg\":\"操作成功\",\"data\":null}', 0, '', '2022-03-18 17:34:59');
    482. 

  482. INSERT INTO `sys_oper_log` VALUES (135, '代码生成', 2, 'com.ruoyi.generator.controller.GenController.editSave()', 'PUT', 1, 'admin', '', '/tool/gen', '127.0.0.1', '内网IP', '{\"searchValue\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":\"admin\",\"updateTime\":\"2022-03-18 17:35:21\",\"params\":{\"treeCode\":null,\"treeName\":null,\"treeParentCode\":null,\"parentMenuId\":null},\"tableId\":9,\"tableName\":\"test_api\",\"tableComment\":\"测试\",\"subTableName\":null,\"subTableFkName\":null,\"className\":\"TestApi\",\"tplCategory\":\"crud\",\"packageName\":\"com.ruoyi.demo\",\"moduleName\":\"system\",\"businessName\":\"api\",\"functionName\":\"测试\",\"functionAuthor\":\"ruoyi\",\"genType\":\"1\",\"genPath\":\"E:\\\\git_workspace\\\\basic-code\\\\basic_system_plus_admin_code\\\\ruoyi-demo\\\\src\",\"pkColumn\":null,\"subTable\":null,\"columns\":[{\"searchValue\":null,\"createBy\":\"admin\",\"createTime\":\"2022-03-18 17:08:44\",\"updateBy\":\"admin\",\"updateTime\":\"2022-03-18 17:35:21\",\"params\":{},\"columnId\":53,\"tableId\":9,\"columnName\":\"id\",\"columnComment\":\"主键\",\"columnType\":\"bigint\",\"javaType\":\"Long\",\"javaField\":\"id\",\"isPk\":\"1\",\"isIncrement\":\"1\",\"isRequired\":\"1\",\"isInsert\":null,\"isEdit\":\"1\",\"isList\":\"1\",\"isQuery\":null,\"queryType\":\"EQ\",\"htmlType\":\"input\",\"dictType\":\"\",\"sort\":1,\"query\":false,\"increment\":true,\"capJavaField\":\"id\",\"list\":true,\"required\":true,\"superColumn\":false,\"edit\":true,\"insert\":false,\"pk\":true,\"usableColumn\":false},{\"searchValue\":null,\"createBy\":\"admin\",\"createTime\":\"2022-03-18 17:08:44\",\"updateBy\":\"admin\",\"updateTime\":\"2022-03-18 17:35:21\",\"params\":{},\"columnId\":54,\"tableId\":9,\"columnName\":\"name\",\"columnComment\":\"名称\",\"columnType\":\"varchar(1000)\",\"javaType\":\"String\",\"javaField\":\"name\",\"isPk\":\"0\",\"isIncrement\":\"0\",\"isRequired\":\"1\",\"isInsert\":\"1\",\"isEdit\":\"1\",\"isList\":\"1\",\"isQuery\":\"1\",\"queryType\":\"LIKE\",\"htmlType\":\"textarea\",\"dictType\":\"\",\"sort\":2,\"query\":true,\"increment\":false,\"capJavaField\":\"name\",\"list\":true,\"required\":true,\"superColumn\":false,\"edit\":true,\"insert\":true,\"pk\":false,\"usableColumn\":false},{\"searchValue\":null,\"createBy\":\"admin\",\"createTime\":\"2022-03-18 17:08:44\",\"updateBy\":\"admin\",\"updateTime\":\"2022-03-18 17:35:21\",\"params\":{},\"columnId\":55,\"tableId\":9,\"columnName\":\"time\",\"columnComment\":\"\",\"columnType\":\"d', '{\"code\":200,\"msg\":\"操作成功\",\"data\":null}', 0, '', '2022-03-18 17:35:22');
    483. 

  483. INSERT INTO `sys_oper_log` VALUES (136, '代码生成', 2, 'com.ruoyi.generator.controller.GenController.editSave()', 'PUT', 1, 'admin', '', '/tool/gen', '127.0.0.1', '内网IP', '{\"searchValue\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":\"admin\",\"updateTime\":\"2022-03-18 17:36:46\",\"params\":{\"treeCode\":null,\"treeName\":null,\"treeParentCode\":null,\"parentMenuId\":null},\"tableId\":9,\"tableName\":\"test_api\",\"tableComment\":\"测试\",\"subTableName\":null,\"subTableFkName\":null,\"className\":\"TestApi\",\"tplCategory\":\"crud\",\"packageName\":\"com.ruoyi.demo\",\"moduleName\":\"system\",\"businessName\":\"api\",\"functionName\":\"测试\",\"functionAuthor\":\"ruoyi\",\"genType\":\"1\",\"genPath\":\"E:\\\\git_workspace\\\\basic-code\\\\basic_system_plus_admin_code\\\\ruoyi-demo\\\\src\",\"pkColumn\":null,\"subTable\":null,\"columns\":[{\"searchValue\":null,\"createBy\":\"admin\",\"createTime\":\"2022-03-18 17:08:44\",\"updateBy\":\"admin\",\"updateTime\":\"2022-03-18 17:36:46\",\"params\":{},\"columnId\":53,\"tableId\":9,\"columnName\":\"id\",\"columnComment\":\"主键\",\"columnType\":\"bigint\",\"javaType\":\"Long\",\"javaField\":\"id\",\"isPk\":\"1\",\"isIncrement\":\"1\",\"isRequired\":\"1\",\"isInsert\":null,\"isEdit\":\"1\",\"isList\":\"1\",\"isQuery\":null,\"queryType\":\"EQ\",\"htmlType\":\"input\",\"dictType\":\"\",\"sort\":1,\"query\":false,\"increment\":true,\"capJavaField\":\"id\",\"list\":true,\"required\":true,\"superColumn\":false,\"edit\":true,\"insert\":false,\"pk\":true,\"usableColumn\":false},{\"searchValue\":null,\"createBy\":\"admin\",\"createTime\":\"2022-03-18 17:08:44\",\"updateBy\":\"admin\",\"updateTime\":\"2022-03-18 17:36:46\",\"params\":{},\"columnId\":54,\"tableId\":9,\"columnName\":\"name\",\"columnComment\":\"名称\",\"columnType\":\"varchar(1000)\",\"javaType\":\"String\",\"javaField\":\"name\",\"isPk\":\"0\",\"isIncrement\":\"0\",\"isRequired\":\"1\",\"isInsert\":\"1\",\"isEdit\":\"1\",\"isList\":\"1\",\"isQuery\":\"1\",\"queryType\":\"LIKE\",\"htmlType\":\"textarea\",\"dictType\":\"\",\"sort\":2,\"query\":true,\"increment\":false,\"capJavaField\":\"name\",\"list\":true,\"required\":true,\"superColumn\":false,\"edit\":true,\"insert\":true,\"pk\":false,\"usableColumn\":false},{\"searchValue\":null,\"createBy\":\"admin\",\"createTime\":\"2022-03-18 17:08:44\",\"updateBy\":\"admin\",\"updateTime\":\"2022-03-18 17:36:46\",\"params\":{},\"columnId\":55,\"tableId\":9,\"columnName\":\"time\",\"columnComment\":\"\",\"columnType\":\"d', '{\"code\":200,\"msg\":\"操作成功\",\"data\":null}', 0, '', '2022-03-18 17:36:46');
    484. 

  484. INSERT INTO `sys_oper_log` VALUES (137, '代码生成', 2, 'com.ruoyi.generator.controller.GenController.editSave()', 'PUT', 1, 'admin', '', '/tool/gen', '127.0.0.1', '内网IP', '{\"searchValue\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":\"admin\",\"updateTime\":\"2022-03-18 17:36:57\",\"params\":{\"treeCode\":null,\"treeName\":null,\"treeParentCode\":null,\"parentMenuId\":null},\"tableId\":9,\"tableName\":\"test_api\",\"tableComment\":\"测试\",\"subTableName\":null,\"subTableFkName\":null,\"className\":\"TestApi\",\"tplCategory\":\"crud\",\"packageName\":\"com.ruoyi.demo\",\"moduleName\":\"system\",\"businessName\":\"api\",\"functionName\":\"测试\",\"functionAuthor\":\"ruoyi\",\"genType\":\"1\",\"genPath\":\"E:\\\\git_workspace\\\\basic-code\\\\basic_system_plus_admin_code\\\\ruoyi-demo\\\\src\",\"pkColumn\":null,\"subTable\":null,\"columns\":[{\"searchValue\":null,\"createBy\":\"admin\",\"createTime\":\"2022-03-18 17:08:44\",\"updateBy\":\"admin\",\"updateTime\":\"2022-03-18 17:36:57\",\"params\":{},\"columnId\":53,\"tableId\":9,\"columnName\":\"id\",\"columnComment\":\"主键\",\"columnType\":\"bigint\",\"javaType\":\"Long\",\"javaField\":\"id\",\"isPk\":\"1\",\"isIncrement\":\"1\",\"isRequired\":\"1\",\"isInsert\":null,\"isEdit\":\"1\",\"isList\":\"1\",\"isQuery\":null,\"queryType\":\"EQ\",\"htmlType\":\"input\",\"dictType\":\"\",\"sort\":1,\"query\":false,\"increment\":true,\"capJavaField\":\"id\",\"list\":true,\"required\":true,\"superColumn\":false,\"edit\":true,\"insert\":false,\"pk\":true,\"usableColumn\":false},{\"searchValue\":null,\"createBy\":\"admin\",\"createTime\":\"2022-03-18 17:08:44\",\"updateBy\":\"admin\",\"updateTime\":\"2022-03-18 17:36:57\",\"params\":{},\"columnId\":54,\"tableId\":9,\"columnName\":\"name\",\"columnComment\":\"名称\",\"columnType\":\"varchar(1000)\",\"javaType\":\"String\",\"javaField\":\"name\",\"isPk\":\"0\",\"isIncrement\":\"0\",\"isRequired\":\"1\",\"isInsert\":\"1\",\"isEdit\":\"1\",\"isList\":\"1\",\"isQuery\":\"1\",\"queryType\":\"LIKE\",\"htmlType\":\"textarea\",\"dictType\":\"\",\"sort\":2,\"query\":true,\"increment\":false,\"capJavaField\":\"name\",\"list\":true,\"required\":true,\"superColumn\":false,\"edit\":true,\"insert\":true,\"pk\":false,\"usableColumn\":false},{\"searchValue\":null,\"createBy\":\"admin\",\"createTime\":\"2022-03-18 17:08:44\",\"updateBy\":\"admin\",\"updateTime\":\"2022-03-18 17:36:57\",\"params\":{},\"columnId\":55,\"tableId\":9,\"columnName\":\"time\",\"columnComment\":\"\",\"columnType\":\"d', '{\"code\":200,\"msg\":\"操作成功\",\"data\":null}', 0, '', '2022-03-18 17:36:57');
    485. 

  485. INSERT INTO `sys_oper_log` VALUES (138, '代码生成', 8, 'com.ruoyi.generator.controller.GenController.genCode()', 'GET', 1, 'admin', '', '/tool/gen/genCode/test_api', '127.0.0.1', '内网IP', '{tableName=test_api}', '{\"code\":200,\"msg\":\"操作成功\",\"data\":null}', 0, '', '2022-03-18 17:37:00');
    486. 

  486. INSERT INTO `sys_oper_log` VALUES (139, '代码生成', 2, 'com.ruoyi.generator.controller.GenController.editSave()', 'PUT', 1, 'admin', '', '/tool/gen', '127.0.0.1', '内网IP', '{\"searchValue\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":\"admin\",\"updateTime\":\"2022-03-18 18:25:55\",\"params\":{\"treeCode\":null,\"treeName\":null,\"treeParentCode\":null,\"parentMenuId\":null},\"tableId\":9,\"tableName\":\"test_api\",\"tableComment\":\"测试\",\"subTableName\":null,\"subTableFkName\":null,\"className\":\"TestApi\",\"tplCategory\":\"crud\",\"packageName\":\"com.ruoyi.demo\",\"moduleName\":\"system\",\"businessName\":\"api\",\"functionName\":\"测试\",\"functionAuthor\":\"ruoyi\",\"genType\":\"1\",\"genPath\":\"E:\\\\git_workspace\\\\basic-code\\\\basic_system_plus_admin_code\\\\ruoyi-demo\\\\src\",\"pkColumn\":null,\"subTable\":null,\"columns\":[{\"searchValue\":null,\"createBy\":\"admin\",\"createTime\":\"2022-03-18 17:08:44\",\"updateBy\":\"admin\",\"updateTime\":\"2022-03-18 18:25:55\",\"params\":{},\"columnId\":53,\"tableId\":9,\"columnName\":\"id\",\"columnComment\":\"主键\",\"columnType\":\"bigint\",\"javaType\":\"Long\",\"javaField\":\"id\",\"isPk\":\"1\",\"isIncrement\":\"1\",\"isRequired\":\"1\",\"isInsert\":null,\"isEdit\":\"1\",\"isList\":\"1\",\"isQuery\":null,\"queryType\":\"EQ\",\"htmlType\":\"input\",\"dictType\":\"\",\"sort\":1,\"required\":true,\"list\":true,\"pk\":true,\"superColumn\":false,\"insert\":false,\"edit\":true,\"usableColumn\":false,\"capJavaField\":\"id\",\"increment\":true,\"query\":false},{\"searchValue\":null,\"createBy\":\"admin\",\"createTime\":\"2022-03-18 17:08:44\",\"updateBy\":\"admin\",\"updateTime\":\"2022-03-18 18:25:55\",\"params\":{},\"columnId\":54,\"tableId\":9,\"columnName\":\"name\",\"columnComment\":\"名称\",\"columnType\":\"varchar(1000)\",\"javaType\":\"String\",\"javaField\":\"name\",\"isPk\":\"0\",\"isIncrement\":\"0\",\"isRequired\":\"1\",\"isInsert\":\"1\",\"isEdit\":\"1\",\"isList\":\"1\",\"isQuery\":\"1\",\"queryType\":\"LIKE\",\"htmlType\":\"textarea\",\"dictType\":\"\",\"sort\":2,\"required\":true,\"list\":true,\"pk\":false,\"superColumn\":false,\"insert\":true,\"edit\":true,\"usableColumn\":false,\"capJavaField\":\"name\",\"increment\":false,\"query\":true},{\"searchValue\":null,\"createBy\":\"admin\",\"createTime\":\"2022-03-18 17:08:44\",\"updateBy\":\"admin\",\"updateTime\":\"2022-03-18 18:25:55\",\"params\":{},\"columnId\":55,\"tableId\":9,\"columnName\":\"time\",\"columnComment\":\"\",\"columnType\":\"d', '{\"code\":200,\"msg\":\"操作成功\",\"data\":null}', 0, '', '2022-03-18 18:25:56');
    487. 

  487. INSERT INTO `sys_oper_log` VALUES (140, '代码生成', 8, 'com.ruoyi.generator.controller.GenController.genCode()', 'GET', 1, 'admin', '', '/tool/gen/genCode/test_api', '127.0.0.1', '内网IP', '{tableName=test_api}', '{\"code\":200,\"msg\":\"操作成功\",\"data\":null}', 0, '', '2022-03-18 18:25:59');
    488. 

  488. INSERT INTO `sys_oper_log` VALUES (141, 'OSS对象存储', 1, 'com.ruoyi.web.controller.system.SysOssController.upload()', 'POST', 1, 'admin', '', '/system/oss/upload', '127.0.0.1', '内网IP', '', '{\"code\":200,\"msg\":\"操作成功\",\"data\":{\"url\":\"http://192.168.0.119:9000/online-learning-platform/2022/03/19/d7933b9109c743c0820d72297496573c.bmp\",\"fileName\":\"2022/03/19/d7933b9109c743c0820d72297496573c.bmp\"}}', 0, '', '2022-03-19 17:42:18');
    489. 

  489. INSERT INTO `sys_oper_log` VALUES (142, 'OSS对象存储', 1, 'com.ruoyi.web.controller.system.SysOssController.localUpload()', 'POST', 1, 'admin', '', '/system/oss/local-upload', '127.0.0.1', '内网IP', '', '', 1, '文件上传失败！', '2022-03-19 18:06:49');
    490. 

  490. INSERT INTO `sys_oper_log` VALUES (143, 'OSS对象存储', 1, 'com.ruoyi.web.controller.system.SysOssController.localUpload()', 'POST', 1, 'admin', '', '/system/oss/local-upload', '127.0.0.1', '内网IP', '', '', 1, '文件上传失败！', '2022-03-19 18:16:05');
    491. 

  491. INSERT INTO `sys_oper_log` VALUES (144, 'OSS对象存储', 1, 'com.ruoyi.web.controller.system.SysOssController.localUpload()', 'POST', 1, 'admin', '', '/system/oss/local-upload', '127.0.0.1', '内网IP', '', '', 1, '文件上传失败！', '2022-03-19 18:17:05');
    492. 

  492. INSERT INTO `sys_oper_log` VALUES (145, 'OSS对象存储', 1, 'com.ruoyi.web.controller.system.SysOssController.localUpload()', 'POST', 1, 'admin', '', '/system/oss/local-upload', '127.0.0.1', '内网IP', '', '', 1, '文件上传失败！', '2022-03-19 18:22:33');
    493. 

  493. INSERT INTO `sys_oper_log` VALUES (146, 'OSS对象存储', 1, 'com.ruoyi.web.controller.system.SysOssController.localUpload()', 'POST', 1, 'admin', '', '/system/oss/local-upload', '127.0.0.1', '内网IP', '', '{\"code\":200,\"msg\":\"操作成功\",\"data\":{\"url\":\"D:\\\\workspase\\\\songlanyun\\\\ruoyi\\\\ruoyi\\\\basic_system_plus_admin_code\\\\upload\\\\6fd295bb165d474299b2b439e9d625dc.bmp\",\"fileName\":\"6fd295bb165d474299b2b439e9d625dc.bmp\"}}', 0, '', '2022-03-19 18:28:34');
    494. 

  494. INSERT INTO `sys_oper_log` VALUES (147, 'OSS对象存储', 1, 'com.ruoyi.web.controller.system.SysOssController.localUpload()', 'POST', 1, 'admin', '', '/system/oss/local-upload', '127.0.0.1', '内网IP', '', '{\"code\":200,\"msg\":\"操作成功\",\"data\":{\"url\":\"D:\\\\workspase\\\\songlanyun\\\\ruoyi\\\\ruoyi\\\\basic_system_plus_admin_code\\\\upload\\\\bb8f81cd4c50468abbba4964e14988e5.bmp\",\"fileName\":\"bb8f81cd4c50468abbba4964e14988e5.bmp\"}}', 0, '', '2022-03-19 18:31:20');
    495. 

  495. INSERT INTO `sys_oper_log` VALUES (148, 'OSS对象存储', 1, 'com.ruoyi.web.controller.system.SysOssController.localUpload()', 'POST', 1, 'admin', '', '/system/oss/local-upload', '127.0.0.1', '内网IP', '', '', 1, '文件上传失败！', '2022-03-19 18:53:06');
    496. 

  496. INSERT INTO `sys_oper_log` VALUES (149, 'OSS对象存储', 1, 'com.ruoyi.web.controller.system.SysOssController.localUpload()', 'POST', 1, 'admin', '', '/system/oss/local-upload', '127.0.0.1', '内网IP', '', '{\"code\":200,\"msg\":\"操作成功\",\"data\":{\"url\":\"D:\\\\workspase\\\\songlanyun\\\\ruoyi\\\\ruoyi\\\\basic_system_plus_admin_code\\\\upload\\\\22fff457a8014545ab274c3c77e7d78f.bmp\",\"fileName\":\"22fff457a8014545ab274c3c77e7d78f.bmp\"}}', 0, '', '2022-03-19 19:03:27');
    497. 

  497. INSERT INTO `sys_oper_log` VALUES (150, 'OSS对象存储', 1, 'com.ruoyi.web.controller.system.SysOssController.localUpload()', 'POST', 1, 'admin', '', '/system/oss/local-upload', '127.0.0.1', '内网IP', '', '{\"code\":200,\"msg\":\"操作成功\",\"data\":{\"url\":\"D:\\\\workspase\\\\songlanyun\\\\ruoyi\\\\ruoyi\\\\basic_system_plus_admin_code\\\\upload\\\\fc6e304f0eed4c3b821d60c8c25a16e6.txt\",\"fileName\":\"fc6e304f0eed4c3b821d60c8c25a16e6.txt\"}}', 0, '', '2022-03-19 19:07:02');
    498. 

  498. INSERT INTO `sys_oper_log` VALUES (151, 'OSS对象存储', 1, 'com.ruoyi.web.controller.system.SysOssController.localUpload()', 'POST', 1, 'admin', '', '/system/oss/local-upload', '127.0.0.1', '内网IP', '', '{\"code\":200,\"msg\":\"操作成功\",\"data\":{\"url\":\"D:\\\\workspase\\\\songlanyun\\\\ruoyi\\\\ruoyi\\\\basic_system_plus_admin_code\\\\upload\\\\948da8cbdab347b586b38da92184b785.rar\",\"fileName\":\"948da8cbdab347b586b38da92184b785.rar\"}}', 0, '', '2022-03-19 19:08:02');
    499. 

  499. INSERT INTO `sys_oper_log` VALUES (152, 'OSS对象存储', 1, 'com.ruoyi.web.controller.system.SysOssController.localUpload()', 'POST', 1, 'admin', '', '/system/oss/local-upload', '127.0.0.1', '内网IP', '', '{\"code\":200,\"msg\":\"操作成功\",\"data\":{\"url\":\"D:\\\\workspase\\\\songlanyun\\\\ruoyi\\\\ruoyi\\\\basic_system_plus_admin_code\\\\upload\\\\856283004d634e59930f36b046ec5b3e.txt\",\"fileName\":\"856283004d634e59930f36b046ec5b3e.txt\"}}', 0, '', '2022-03-19 19:16:34');
    500. 

  500. INSERT INTO `sys_oper_log` VALUES (153, 'OSS对象存储', 1, 'com.ruoyi.web.controller.system.SysOssController.localUpload()', 'POST', 1, 'admin', '', '/system/oss/local-upload', '127.0.0.1', '内网IP', '', '{\"code\":200,\"msg\":\"操作成功\",\"data\":{\"url\":\"D:\\\\workspase\\\\songlanyun\\\\ruoyi\\\\ruoyi\\\\basic_system_plus_admin_code\\\\upload\\\\5f96efc7b42b44748484908178d5a265.txt\",\"fileName\":\"5f96efc7b42b44748484908178d5a265.txt\"}}', 0, '', '2022-03-19 19:17:14');
    501. 

  501. INSERT INTO `sys_oper_log` VALUES (154, 'OSS对象存储', 1, 'com.ruoyi.web.controller.system.SysOssController.localUpload()', 'POST', 1, 'admin', '', '/system/oss/local-upload', '127.0.0.1', '内网IP', '', '', 1, '文件上传失败！', '2022-03-19 19:24:28');
    502. 

  502. INSERT INTO `sys_oper_log` VALUES (155, 'OSS对象存储', 1, 'com.ruoyi.web.controller.system.SysOssController.localUpload()', 'POST', 1, 'admin', '', '/system/oss/local-upload', '127.0.0.1', '内网IP', '', '{\"code\":200,\"msg\":\"操作成功\",\"data\":{\"url\":\"D:\\\\workspase\\\\songlanyun\\\\ruoyi\\\\ruoyi\\\\basic_system_plus_admin_code\\\\upload\\\\3ef7c112a8684710bcfd32ff5390d98f.rar\",\"fileName\":\"3ef7c112a8684710bcfd32ff5390d98f.rar\"}}', 0, '', '2022-03-19 19:25:09');
    503. 

  503. 

  504. -- ----------------------------
    505. 

  505. -- Table structure for sys_oss
    506. 

  506. -- ----------------------------
    507. 

  507. DROP TABLE IF EXISTS `sys_oss`;
    508. 

  508. CREATE TABLE `sys_oss`  (
    509. 

  509.   `oss_id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '对象存储主键',
    510. 

  510.   `file_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '文件名',
    511. 

  511.   `original_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '原名',
    512. 

  512.   `file_suffix` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '文件后缀名',
    513. 

  513.   `url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'URL地址',
    514. 

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

  515.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '上传人',
    516. 

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

  517.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '更新人',
    518. 

  518.   `service` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'minio' COMMENT '服务商',
    519. 

  519.   PRIMARY KEY (`oss_id`) USING BTREE
    520. 

  520. ) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'OSS对象存储表' ROW_FORMAT = Dynamic;
    521. 

  521. 

  522. -- ----------------------------
    523. 

  523. -- Records of sys_oss
    524. 

  524. -- ----------------------------
    525. 

  525. INSERT INTO `sys_oss` VALUES (1, '2022/03/19/d7933b9109c743c0820d72297496573c.bmp', '1.bmp', '.bmp', 'http://192.168.0.119:9000/online-learning-platform/2022/03/19/d7933b9109c743c0820d72297496573c.bmp', '2022-03-19 17:42:18', 'admin', '2022-03-19 17:42:18', 'admin', 'minio');
    526. 

  526. INSERT INTO `sys_oss` VALUES (2, '6fd295bb165d474299b2b439e9d625dc.bmp', '1.bmp', 'bmp', 'D:\\workspase\\songlanyun\\ruoyi\\ruoyi\\basic_system_plus_admin_code\\upload\\6fd295bb165d474299b2b439e9d625dc.bmp', '2022-03-19 18:28:34', 'admin', '2022-03-19 18:28:34', 'admin', '本地上传');
    527. 

  527. INSERT INTO `sys_oss` VALUES (3, 'bb8f81cd4c50468abbba4964e14988e5.bmp', '2.bmp', 'bmp', 'D:\\workspase\\songlanyun\\ruoyi\\ruoyi\\basic_system_plus_admin_code\\upload\\bb8f81cd4c50468abbba4964e14988e5.bmp', '2022-03-19 18:31:20', 'admin', '2022-03-19 18:31:20', 'admin', '本地上传');
    528. 

  528. INSERT INTO `sys_oss` VALUES (4, '22fff457a8014545ab274c3c77e7d78f.bmp', '1.bmp', 'bmp', 'D:\\workspase\\songlanyun\\ruoyi\\ruoyi\\basic_system_plus_admin_code\\upload\\22fff457a8014545ab274c3c77e7d78f.bmp', '2022-03-19 19:03:27', 'admin', '2022-03-19 19:03:27', 'admin', '本地上传');
    529. 

  529. INSERT INTO `sys_oss` VALUES (5, 'fc6e304f0eed4c3b821d60c8c25a16e6.txt', '1.txt', 'txt', 'D:\\workspase\\songlanyun\\ruoyi\\ruoyi\\basic_system_plus_admin_code\\upload\\fc6e304f0eed4c3b821d60c8c25a16e6.txt', '2022-03-19 19:07:02', 'admin', '2022-03-19 19:07:02', 'admin', '本地上传');
    530. 

  530. INSERT INTO `sys_oss` VALUES (6, '948da8cbdab347b586b38da92184b785.rar', '2.rar', 'rar', 'D:\\workspase\\songlanyun\\ruoyi\\ruoyi\\basic_system_plus_admin_code\\upload\\948da8cbdab347b586b38da92184b785.rar', '2022-03-19 19:08:01', 'admin', '2022-03-19 19:08:01', 'admin', '本地上传');
    531. 

  531. INSERT INTO `sys_oss` VALUES (7, '856283004d634e59930f36b046ec5b3e.txt', '1.txt', 'txt', 'D:\\workspase\\songlanyun\\ruoyi\\ruoyi\\basic_system_plus_admin_code\\upload\\856283004d634e59930f36b046ec5b3e.txt', '2022-03-19 19:16:34', 'admin', '2022-03-19 19:16:34', 'admin', '本地上传');
    532. 

  532. INSERT INTO `sys_oss` VALUES (8, '5f96efc7b42b44748484908178d5a265.txt', '1.txt', 'txt', 'D:\\workspase\\songlanyun\\ruoyi\\ruoyi\\basic_system_plus_admin_code\\upload\\5f96efc7b42b44748484908178d5a265.txt', '2022-03-19 19:17:14', 'admin', '2022-03-19 19:17:14', 'admin', '本地上传');
    533. 

  533. INSERT INTO `sys_oss` VALUES (9, '3ef7c112a8684710bcfd32ff5390d98f.rar', '2.rar', 'rar', 'D:\\workspase\\songlanyun\\ruoyi\\ruoyi\\basic_system_plus_admin_code\\upload\\3ef7c112a8684710bcfd32ff5390d98f.rar', '2022-03-19 19:25:09', 'admin', '2022-03-19 19:25:09', 'admin', '本地上传');
    534. 

  534. 

  535. -- ----------------------------
    536. 

  536. -- Table structure for sys_oss_config
    537. 

  537. -- ----------------------------
    538. 

  538. DROP TABLE IF EXISTS `sys_oss_config`;
    539. 

  539. CREATE TABLE `sys_oss_config`  (
    540. 

  540.   `oss_config_id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '主建',
    541. 

  541.   `config_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '配置key',
    542. 

  542.   `access_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT 'accessKey',
    543. 

  543.   `secret_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '秘钥',
    544. 

  544.   `bucket_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '桶名称',
    545. 

  545.   `prefix` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '前缀',
    546. 

  546.   `endpoint` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '访问站点',
    547. 

  547.   `is_https` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'N' COMMENT '是否https（Y=是,N=否）',
    548. 

  548.   `region` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '域',
    549. 

  549.   `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '1' COMMENT '状态（0=正常,1=停用）',
    550. 

  550.   `ext1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '扩展字段',
    551. 

  551.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '创建者',
    552. 

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

  553.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '更新者',
    554. 

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

  555.   `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
    556. 

  556.   PRIMARY KEY (`oss_config_id`) USING BTREE
    557. 

  557. ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '对象存储配置表' ROW_FORMAT = Dynamic;
    558. 

  558. 

  559. -- ----------------------------
    560. 

  560. -- Records of sys_oss_config
    561. 

  561. -- ----------------------------
    562. 

  562. INSERT INTO `sys_oss_config` VALUES (1, 'minio', 'ruoyi', 'ruoyi123', 'ruoyi', '', 'http://localhost:9000', 'N', '', '0', '', 'admin', '2022-03-02 08:14:55', 'admin', '2022-03-02 08:14:55', NULL);
    563. 

  563. INSERT INTO `sys_oss_config` VALUES (2, 'qiniu', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi', '', 'http://XXX.XXXX.com', 'N', 'z0', '1', '', 'admin', '2022-03-02 08:14:55', 'admin', '2022-03-02 08:14:55', NULL);
    564. 

  564. INSERT INTO `sys_oss_config` VALUES (3, 'aliyun', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi', '', 'http://oss-cn-beijing.aliyuncs.com', 'N', '', '1', '', 'admin', '2022-03-02 08:14:55', 'admin', '2022-03-02 08:14:55', NULL);
    565. 

  565. INSERT INTO `sys_oss_config` VALUES (4, 'qcloud', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi-1250000000', '', 'http://cos.ap-beijing.myqcloud.com', 'N', 'ap-beijing', '1', '', 'admin', '2022-03-02 08:14:55', 'admin', '2022-03-02 08:14:55', NULL);
    566. 

  566. 

  567. -- ----------------------------
    568. 

  568. -- Table structure for sys_post
    569. 

  569. -- ----------------------------
    570. 

  570. DROP TABLE IF EXISTS `sys_post`;
    571. 

  571. CREATE TABLE `sys_post`  (
    572. 

  572.   `post_id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '岗位ID',
    573. 

  573.   `post_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '岗位编码',
    574. 

  574.   `post_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '岗位名称',
    575. 

  575.   `post_sort` int(0) NOT NULL COMMENT '显示顺序',
    576. 

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

  577.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '创建者',
    578. 

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

  579.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '更新者',
    580. 

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

  581.   `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
    582. 

  582.   PRIMARY KEY (`post_id`) USING BTREE
    583. 

  583. ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '岗位信息表' ROW_FORMAT = Dynamic;
    584. 

  584. 

  585. -- ----------------------------
    586. 

  586. -- Records of sys_post
    587. 

  587. -- ----------------------------
    588. 

  588. INSERT INTO `sys_post` VALUES (1, 'ceo', '董事长', 1, '0', 'admin', '2022-03-02 08:14:47', '', NULL, '');
    589. 

  589. INSERT INTO `sys_post` VALUES (2, 'se', '项目经理', 2, '0', 'admin', '2022-03-02 08:14:47', '', NULL, '');
    590. 

  590. INSERT INTO `sys_post` VALUES (3, 'hr', '人力资源', 3, '0', 'admin', '2022-03-02 08:14:47', '', NULL, '');
    591. 

  591. INSERT INTO `sys_post` VALUES (4, 'user', '普通员工', 4, '0', 'admin', '2022-03-02 08:14:47', '', NULL, '');
    592. 

  592. 

  593. -- ----------------------------
    594. 

  594. -- Table structure for sys_role
    595. 

  595. -- ----------------------------
    596. 

  596. DROP TABLE IF EXISTS `sys_role`;
    597. 

  597. CREATE TABLE `sys_role`  (
    598. 

  598.   `role_id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '角色ID',
    599. 

  599.   `role_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '角色名称',
    600. 

  600.   `role_key` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '角色权限字符串',
    601. 

  601.   `role_sort` int(0) NOT NULL COMMENT '显示顺序',
    602. 

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

  603.   `menu_check_strictly` tinyint(1) NULL DEFAULT 1 COMMENT '菜单树选择项是否关联显示',
    604. 

  604.   `dept_check_strictly` tinyint(1) NULL DEFAULT 1 COMMENT '部门树选择项是否关联显示',
    605. 

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

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

  607.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '创建者',
    608. 

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

  609.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '更新者',
    610. 

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

  611.   `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
    612. 

  612.   PRIMARY KEY (`role_id`) USING BTREE
    613. 

  613. ) ENGINE = InnoDB AUTO_INCREMENT = 100 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '角色信息表' ROW_FORMAT = Dynamic;
    614. 

  614. 

  615. -- ----------------------------
    616. 

  616. -- Records of sys_role
    617. 

  617. -- ----------------------------
    618. 

  618. INSERT INTO `sys_role` VALUES (1, '超级管理员', 'admin', 1, '1', 1, 1, '0', '0', 'admin', '2022-03-02 08:14:47', '', NULL, '超级管理员');
    619. 

  619. INSERT INTO `sys_role` VALUES (2, '普通角色', 'common', 2, '2', 1, 1, '0', '0', 'admin', '2022-03-02 08:14:47', '', NULL, '普通角色');
    620. 

  620. INSERT INTO `sys_role` VALUES (3, '本部门及以下', 'test1', 3, '4', 1, 1, '0', '0', 'admin', '2021-05-08 22:31:37', 'admin', '2021-05-08 22:32:03', NULL);
    621. 

  621. INSERT INTO `sys_role` VALUES (4, '仅本人', 'test2', 4, '5', 1, 1, '0', '0', 'admin', '2021-05-30 01:14:52', 'admin', '2021-05-30 01:18:38', NULL);
    622. 

  622. 

  623. -- ----------------------------
    624. 

  624. -- Table structure for sys_role_dept
    625. 

  625. -- ----------------------------
    626. 

  626. DROP TABLE IF EXISTS `sys_role_dept`;
    627. 

  627. CREATE TABLE `sys_role_dept`  (
    628. 

  628.   `role_id` bigint(0) NOT NULL COMMENT '角色ID',
    629. 

  629.   `dept_id` bigint(0) NOT NULL COMMENT '部门ID',
    630. 

  630.   PRIMARY KEY (`role_id`, `dept_id`) USING BTREE
    631. 

  631. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '角色和部门关联表' ROW_FORMAT = Dynamic;
    632. 

  632. 

  633. -- ----------------------------
    634. 

  634. -- Records of sys_role_dept
    635. 

  635. -- ----------------------------
    636. 

  636. INSERT INTO `sys_role_dept` VALUES (2, 100);
    637. 

  637. INSERT INTO `sys_role_dept` VALUES (2, 101);
    638. 

  638. INSERT INTO `sys_role_dept` VALUES (2, 105);
    639. 

  639. 

  640. -- ----------------------------
    641. 

  641. -- Table structure for sys_role_menu
    642. 

  642. -- ----------------------------
    643. 

  643. DROP TABLE IF EXISTS `sys_role_menu`;
    644. 

  644. CREATE TABLE `sys_role_menu`  (
    645. 

  645.   `role_id` bigint(0) NOT NULL COMMENT '角色ID',
    646. 

  646.   `menu_id` bigint(0) NOT NULL COMMENT '菜单ID',
    647. 

  647.   PRIMARY KEY (`role_id`, `menu_id`) USING BTREE
    648. 

  648. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '角色和菜单关联表' ROW_FORMAT = Dynamic;
    649. 

  649. 

  650. -- ----------------------------
    651. 

  651. -- Records of sys_role_menu
    652. 

  652. -- ----------------------------
    653. 

  653. INSERT INTO `sys_role_menu` VALUES (2, 1);
    654. 

  654. INSERT INTO `sys_role_menu` VALUES (2, 2);
    655. 

  655. INSERT INTO `sys_role_menu` VALUES (2, 3);
    656. 

  656. INSERT INTO `sys_role_menu` VALUES (2, 4);
    657. 

  657. INSERT INTO `sys_role_menu` VALUES (2, 100);
    658. 

  658. INSERT INTO `sys_role_menu` VALUES (2, 101);
    659. 

  659. INSERT INTO `sys_role_menu` VALUES (2, 102);
    660. 

  660. INSERT INTO `sys_role_menu` VALUES (2, 103);
    661. 

  661. INSERT INTO `sys_role_menu` VALUES (2, 104);
    662. 

  662. INSERT INTO `sys_role_menu` VALUES (2, 105);
    663. 

  663. INSERT INTO `sys_role_menu` VALUES (2, 106);
    664. 

  664. INSERT INTO `sys_role_menu` VALUES (2, 107);
    665. 

  665. INSERT INTO `sys_role_menu` VALUES (2, 108);
    666. 

  666. INSERT INTO `sys_role_menu` VALUES (2, 109);
    667. 

  667. INSERT INTO `sys_role_menu` VALUES (2, 110);
    668. 

  668. INSERT INTO `sys_role_menu` VALUES (2, 111);
    669. 

  669. INSERT INTO `sys_role_menu` VALUES (2, 112);
    670. 

  670. INSERT INTO `sys_role_menu` VALUES (2, 113);
    671. 

  671. INSERT INTO `sys_role_menu` VALUES (2, 114);
    672. 

  672. INSERT INTO `sys_role_menu` VALUES (2, 115);
    673. 

  673. INSERT INTO `sys_role_menu` VALUES (2, 116);
    674. 

  674. INSERT INTO `sys_role_menu` VALUES (2, 500);
    675. 

  675. INSERT INTO `sys_role_menu` VALUES (2, 501);
    676. 

  676. INSERT INTO `sys_role_menu` VALUES (2, 1000);
    677. 

  677. INSERT INTO `sys_role_menu` VALUES (2, 1001);
    678. 

  678. INSERT INTO `sys_role_menu` VALUES (2, 1002);
    679. 

  679. INSERT INTO `sys_role_menu` VALUES (2, 1003);
    680. 

  680. INSERT INTO `sys_role_menu` VALUES (2, 1004);
    681. 

  681. INSERT INTO `sys_role_menu` VALUES (2, 1005);
    682. 

  682. INSERT INTO `sys_role_menu` VALUES (2, 1006);
    683. 

  683. INSERT INTO `sys_role_menu` VALUES (2, 1007);
    684. 

  684. INSERT INTO `sys_role_menu` VALUES (2, 1008);
    685. 

  685. INSERT INTO `sys_role_menu` VALUES (2, 1009);
    686. 

  686. INSERT INTO `sys_role_menu` VALUES (2, 1010);
    687. 

  687. INSERT INTO `sys_role_menu` VALUES (2, 1011);
    688. 

  688. INSERT INTO `sys_role_menu` VALUES (2, 1012);
    689. 

  689. INSERT INTO `sys_role_menu` VALUES (2, 1013);
    690. 

  690. INSERT INTO `sys_role_menu` VALUES (2, 1014);
    691. 

  691. INSERT INTO `sys_role_menu` VALUES (2, 1015);
    692. 

  692. INSERT INTO `sys_role_menu` VALUES (2, 1016);
    693. 

  693. INSERT INTO `sys_role_menu` VALUES (2, 1017);
    694. 

  694. INSERT INTO `sys_role_menu` VALUES (2, 1018);
    695. 

  695. INSERT INTO `sys_role_menu` VALUES (2, 1019);
    696. 

  696. INSERT INTO `sys_role_menu` VALUES (2, 1020);
    697. 

  697. INSERT INTO `sys_role_menu` VALUES (2, 1021);
    698. 

  698. INSERT INTO `sys_role_menu` VALUES (2, 1022);
    699. 

  699. INSERT INTO `sys_role_menu` VALUES (2, 1023);
    700. 

  700. INSERT INTO `sys_role_menu` VALUES (2, 1024);
    701. 

  701. INSERT INTO `sys_role_menu` VALUES (2, 1025);
    702. 

  702. INSERT INTO `sys_role_menu` VALUES (2, 1026);
    703. 

  703. INSERT INTO `sys_role_menu` VALUES (2, 1027);
    704. 

  704. INSERT INTO `sys_role_menu` VALUES (2, 1028);
    705. 

  705. INSERT INTO `sys_role_menu` VALUES (2, 1029);
    706. 

  706. INSERT INTO `sys_role_menu` VALUES (2, 1030);
    707. 

  707. INSERT INTO `sys_role_menu` VALUES (2, 1031);
    708. 

  708. INSERT INTO `sys_role_menu` VALUES (2, 1032);
    709. 

  709. INSERT INTO `sys_role_menu` VALUES (2, 1033);
    710. 

  710. INSERT INTO `sys_role_menu` VALUES (2, 1034);
    711. 

  711. INSERT INTO `sys_role_menu` VALUES (2, 1035);
    712. 

  712. INSERT INTO `sys_role_menu` VALUES (2, 1036);
    713. 

  713. INSERT INTO `sys_role_menu` VALUES (2, 1037);
    714. 

  714. INSERT INTO `sys_role_menu` VALUES (2, 1038);
    715. 

  715. INSERT INTO `sys_role_menu` VALUES (2, 1039);
    716. 

  716. INSERT INTO `sys_role_menu` VALUES (2, 1040);
    717. 

  717. INSERT INTO `sys_role_menu` VALUES (2, 1041);
    718. 

  718. INSERT INTO `sys_role_menu` VALUES (2, 1042);
    719. 

  719. INSERT INTO `sys_role_menu` VALUES (2, 1043);
    720. 

  720. INSERT INTO `sys_role_menu` VALUES (2, 1044);
    721. 

  721. INSERT INTO `sys_role_menu` VALUES (2, 1045);
    722. 

  722. INSERT INTO `sys_role_menu` VALUES (2, 1046);
    723. 

  723. INSERT INTO `sys_role_menu` VALUES (2, 1047);
    724. 

  724. INSERT INTO `sys_role_menu` VALUES (2, 1048);
    725. 

  725. INSERT INTO `sys_role_menu` VALUES (2, 1055);
    726. 

  726. INSERT INTO `sys_role_menu` VALUES (2, 1056);
    727. 

  727. INSERT INTO `sys_role_menu` VALUES (2, 1057);
    728. 

  728. INSERT INTO `sys_role_menu` VALUES (2, 1058);
    729. 

  729. INSERT INTO `sys_role_menu` VALUES (2, 1059);
    730. 

  730. INSERT INTO `sys_role_menu` VALUES (2, 1060);
    731. 

  731. INSERT INTO `sys_role_menu` VALUES (3, 1);
    732. 

  732. INSERT INTO `sys_role_menu` VALUES (3, 5);
    733. 

  733. INSERT INTO `sys_role_menu` VALUES (3, 100);
    734. 

  734. INSERT INTO `sys_role_menu` VALUES (3, 101);
    735. 

  735. INSERT INTO `sys_role_menu` VALUES (3, 102);
    736. 

  736. INSERT INTO `sys_role_menu` VALUES (3, 103);
    737. 

  737. INSERT INTO `sys_role_menu` VALUES (3, 104);
    738. 

  738. INSERT INTO `sys_role_menu` VALUES (3, 105);
    739. 

  739. INSERT INTO `sys_role_menu` VALUES (3, 106);
    740. 

  740. INSERT INTO `sys_role_menu` VALUES (3, 107);
    741. 

  741. INSERT INTO `sys_role_menu` VALUES (3, 108);
    742. 

  742. INSERT INTO `sys_role_menu` VALUES (3, 500);
    743. 

  743. INSERT INTO `sys_role_menu` VALUES (3, 501);
    744. 

  744. INSERT INTO `sys_role_menu` VALUES (3, 1001);
    745. 

  745. INSERT INTO `sys_role_menu` VALUES (3, 1002);
    746. 

  746. INSERT INTO `sys_role_menu` VALUES (3, 1003);
    747. 

  747. INSERT INTO `sys_role_menu` VALUES (3, 1004);
    748. 

  748. INSERT INTO `sys_role_menu` VALUES (3, 1005);
    749. 

  749. INSERT INTO `sys_role_menu` VALUES (3, 1006);
    750. 

  750. INSERT INTO `sys_role_menu` VALUES (3, 1007);
    751. 

  751. INSERT INTO `sys_role_menu` VALUES (3, 1008);
    752. 

  752. INSERT INTO `sys_role_menu` VALUES (3, 1009);
    753. 

  753. INSERT INTO `sys_role_menu` VALUES (3, 1010);
    754. 

  754. INSERT INTO `sys_role_menu` VALUES (3, 1011);
    755. 

  755. INSERT INTO `sys_role_menu` VALUES (3, 1012);
    756. 

  756. INSERT INTO `sys_role_menu` VALUES (3, 1013);
    757. 

  757. INSERT INTO `sys_role_menu` VALUES (3, 1014);
    758. 

  758. INSERT INTO `sys_role_menu` VALUES (3, 1015);
    759. 

  759. INSERT INTO `sys_role_menu` VALUES (3, 1016);
    760. 

  760. INSERT INTO `sys_role_menu` VALUES (3, 1017);
    761. 

  761. INSERT INTO `sys_role_menu` VALUES (3, 1018);
    762. 

  762. INSERT INTO `sys_role_menu` VALUES (3, 1019);
    763. 

  763. INSERT INTO `sys_role_menu` VALUES (3, 1020);
    764. 

  764. INSERT INTO `sys_role_menu` VALUES (3, 1021);
    765. 

  765. INSERT INTO `sys_role_menu` VALUES (3, 1022);
    766. 

  766. INSERT INTO `sys_role_menu` VALUES (3, 1023);
    767. 

  767. INSERT INTO `sys_role_menu` VALUES (3, 1024);
    768. 

  768. INSERT INTO `sys_role_menu` VALUES (3, 1025);
    769. 

  769. INSERT INTO `sys_role_menu` VALUES (3, 1026);
    770. 

  770. INSERT INTO `sys_role_menu` VALUES (3, 1027);
    771. 

  771. INSERT INTO `sys_role_menu` VALUES (3, 1028);
    772. 

  772. INSERT INTO `sys_role_menu` VALUES (3, 1029);
    773. 

  773. INSERT INTO `sys_role_menu` VALUES (3, 1030);
    774. 

  774. INSERT INTO `sys_role_menu` VALUES (3, 1031);
    775. 

  775. INSERT INTO `sys_role_menu` VALUES (3, 1032);
    776. 

  776. INSERT INTO `sys_role_menu` VALUES (3, 1033);
    777. 

  777. INSERT INTO `sys_role_menu` VALUES (3, 1034);
    778. 

  778. INSERT INTO `sys_role_menu` VALUES (3, 1035);
    779. 

  779. INSERT INTO `sys_role_menu` VALUES (3, 1036);
    780. 

  780. INSERT INTO `sys_role_menu` VALUES (3, 1037);
    781. 

  781. INSERT INTO `sys_role_menu` VALUES (3, 1038);
    782. 

  782. INSERT INTO `sys_role_menu` VALUES (3, 1039);
    783. 

  783. INSERT INTO `sys_role_menu` VALUES (3, 1040);
    784. 

  784. INSERT INTO `sys_role_menu` VALUES (3, 1041);
    785. 

  785. INSERT INTO `sys_role_menu` VALUES (3, 1042);
    786. 

  786. INSERT INTO `sys_role_menu` VALUES (3, 1043);
    787. 

  787. INSERT INTO `sys_role_menu` VALUES (3, 1044);
    788. 

  788. INSERT INTO `sys_role_menu` VALUES (3, 1045);
    789. 

  789. INSERT INTO `sys_role_menu` VALUES (3, 1500);
    790. 

  790. INSERT INTO `sys_role_menu` VALUES (3, 1501);
    791. 

  791. INSERT INTO `sys_role_menu` VALUES (3, 1502);
    792. 

  792. INSERT INTO `sys_role_menu` VALUES (3, 1503);
    793. 

  793. INSERT INTO `sys_role_menu` VALUES (3, 1504);
    794. 

  794. INSERT INTO `sys_role_menu` VALUES (3, 1505);
    795. 

  795. INSERT INTO `sys_role_menu` VALUES (3, 1506);
    796. 

  796. INSERT INTO `sys_role_menu` VALUES (3, 1507);
    797. 

  797. INSERT INTO `sys_role_menu` VALUES (3, 1508);
    798. 

  798. INSERT INTO `sys_role_menu` VALUES (3, 1509);
    799. 

  799. INSERT INTO `sys_role_menu` VALUES (3, 1510);
    800. 

  800. INSERT INTO `sys_role_menu` VALUES (3, 1511);
    801. 

  801. INSERT INTO `sys_role_menu` VALUES (4, 5);
    802. 

  802. INSERT INTO `sys_role_menu` VALUES (4, 1500);
    803. 

  803. INSERT INTO `sys_role_menu` VALUES (4, 1501);
    804. 

  804. INSERT INTO `sys_role_menu` VALUES (4, 1502);
    805. 

  805. INSERT INTO `sys_role_menu` VALUES (4, 1503);
    806. 

  806. INSERT INTO `sys_role_menu` VALUES (4, 1504);
    807. 

  807. INSERT INTO `sys_role_menu` VALUES (4, 1505);
    808. 

  808. INSERT INTO `sys_role_menu` VALUES (4, 1506);
    809. 

  809. INSERT INTO `sys_role_menu` VALUES (4, 1507);
    810. 

  810. INSERT INTO `sys_role_menu` VALUES (4, 1508);
    811. 

  811. INSERT INTO `sys_role_menu` VALUES (4, 1509);
    812. 

  812. INSERT INTO `sys_role_menu` VALUES (4, 1510);
    813. 

  813. INSERT INTO `sys_role_menu` VALUES (4, 1511);
    814. 

  814. 

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

  816. -- Table structure for sys_user
    817. 

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

  818. DROP TABLE IF EXISTS `sys_user`;
    819. 

  819. CREATE TABLE `sys_user`  (
    820. 

  820.   `user_id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
    821. 

  821.   `dept_id` bigint(0) NULL DEFAULT NULL COMMENT '部门ID',
    822. 

  822.   `user_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户账号',
    823. 

  823.   `nick_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户昵称',
    824. 

  824.   `user_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'sys_user' COMMENT '用户类型（sys_user系统用户）',
    825. 

  825.   `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '用户邮箱',
    826. 

  826.   `phonenumber` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '手机号码',
    827. 

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

  828.   `avatar` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '头像地址',
    829. 

  829.   `password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '密码',
    830. 

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

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

  832.   `login_ip` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '最后登录IP',
    833. 

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

  834.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '创建者',
    835. 

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

  836.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '更新者',
    837. 

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

  838.   `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
    839. 

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

  840. ) ENGINE = InnoDB AUTO_INCREMENT = 100 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '用户信息表' ROW_FORMAT = Dynamic;
    841. 

  841. 

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

  843. -- Records of sys_user
    844. 

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

  845. INSERT INTO `sys_user` VALUES (1, 103, 'admin', '疯狂的狮子Li', 'sys_user', 'crazyLionLi@163.com', '15888888888', '1', '', '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', '0', '0', '127.0.0.1', '2022-03-18 18:24:13', 'admin', '2022-03-02 08:14:46', 'admin', '2022-03-18 18:24:13', '管理员');
    846. 

  846. INSERT INTO `sys_user` VALUES (2, 105, 'lionli', '疯狂的狮子Li', 'sys_user', 'crazyLionLi@qq.com', '15666666666', '1', '', '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', '0', '0', '127.0.0.1', '2022-03-02 08:14:46', 'admin', '2022-03-02 08:14:46', '', NULL, '测试员');
    847. 

  847. INSERT INTO `sys_user` VALUES (3, 108, 'test', '本部门及以下 密码666666', 'sys_user', '', '', '0', '', '$2a$10$b8yUzN0C71sbz.PhNOCgJe.Tu1yWC3RNrTyjSQ8p1W0.aaUXUJ.Ne', '0', '0', '127.0.0.1', '2022-03-02 08:26:25', 'admin', '2022-03-02 08:26:25', 'test', '2022-03-02 08:26:25', NULL);
    848. 

  848. INSERT INTO `sys_user` VALUES (4, 102, 'test1', '仅本人 密码666666', 'sys_user', '', '', '0', '', '$2a$10$b8yUzN0C71sbz.PhNOCgJe.Tu1yWC3RNrTyjSQ8p1W0.aaUXUJ.Ne', '0', '0', '127.0.0.1', '2022-03-02 08:26:25', 'admin', '2022-03-02 08:26:25', 'test1', '2022-03-02 08:26:25', NULL);
    849. 

  849. 

  850. -- ----------------------------
    851. 

  851. -- Table structure for sys_user_post
    852. 

  852. -- ----------------------------
    853. 

  853. DROP TABLE IF EXISTS `sys_user_post`;
    854. 

  854. CREATE TABLE `sys_user_post`  (
    855. 

  855.   `user_id` bigint(0) NOT NULL COMMENT '用户ID',
    856. 

  856.   `post_id` bigint(0) NOT NULL COMMENT '岗位ID',
    857. 

  857.   PRIMARY KEY (`user_id`, `post_id`) USING BTREE
    858. 

  858. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '用户与岗位关联表' ROW_FORMAT = Dynamic;
    859. 

  859. 

  860. -- ----------------------------
    861. 

  861. -- Records of sys_user_post
    862. 

  862. -- ----------------------------
    863. 

  863. INSERT INTO `sys_user_post` VALUES (1, 1);
    864. 

  864. INSERT INTO `sys_user_post` VALUES (2, 2);
    865. 

  865. 

  866. -- ----------------------------
    867. 

  867. -- Table structure for sys_user_role
    868. 

  868. -- ----------------------------
    869. 

  869. DROP TABLE IF EXISTS `sys_user_role`;
    870. 

  870. CREATE TABLE `sys_user_role`  (
    871. 

  871.   `user_id` bigint(0) NOT NULL COMMENT '用户ID',
    872. 

  872.   `role_id` bigint(0) NOT NULL COMMENT '角色ID',
    873. 

  873.   PRIMARY KEY (`user_id`, `role_id`) USING BTREE
    874. 

  874. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '用户和角色关联表' ROW_FORMAT = Dynamic;
    875. 

  875. 

  876. -- ----------------------------
    877. 

  877. -- Records of sys_user_role
    878. 

  878. -- ----------------------------
    879. 

  879. INSERT INTO `sys_user_role` VALUES (1, 1);
    880. 

  880. INSERT INTO `sys_user_role` VALUES (2, 2);
    881. 

  881. INSERT INTO `sys_user_role` VALUES (3, 3);
    882. 

  882. INSERT INTO `sys_user_role` VALUES (4, 4);
    883. 

  883. 

  884. -- ----------------------------
    885. 

  885. -- Table structure for tb_user
    886. 

  886. -- ----------------------------
    887. 

  887. DROP TABLE IF EXISTS `tb_user`;
    888. 

  888. CREATE TABLE `tb_user`  (
    889. 

  889.   `id` bigint(0) NOT NULL AUTO_INCREMENT,
    890. 

  890.   `mobile` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '手机号',
    891. 

  891.   `nickname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '昵称',
    892. 

  892.   `head_photo` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '头像',
    893. 

  893.   `age` int(0) NULL DEFAULT NULL COMMENT '年龄',
    894. 

  894.   `gender` tinyint(1) NOT NULL DEFAULT 0 COMMENT '性别\r\n* 0：未知、\r\n* 1：男、\r\n* 2：女',
    895. 

  895.   `real_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '真实姓名',
    896. 

  896.   `birthday` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '生日',
    897. 

  897.   `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态（0：禁用，1：启用）',
    898. 

  898.   `last_login_time` datetime(0) NULL DEFAULT NULL COMMENT '最后一次登录时间',
    899. 

  899.   `create_time` datetime(0) NULL DEFAULT NULL,
    900. 

  900.   `update_time` datetime(0) NULL DEFAULT NULL,
    901. 

  901.   PRIMARY KEY (`id`) USING BTREE
    902. 

  902. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '小程序用户管理' ROW_FORMAT = Dynamic;
    903. 

  903. 

  904. -- ----------------------------
    905. 

  905. -- Records of tb_user
    906. 

  906. -- ----------------------------
    907. 

  907. 

  908. -- ----------------------------
    909. 

  909. -- Table structure for tb_user_third_identity
    910. 

  910. -- ----------------------------
    911. 

  911. DROP TABLE IF EXISTS `tb_user_third_identity`;
    912. 

  912. CREATE TABLE `tb_user_third_identity`  (
    913. 

  913.   `id` bigint(0) NOT NULL AUTO_INCREMENT,
    914. 

  914.   `identity_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'identity_code(如果是微信就是open_id的值，其它也是)',
    915. 

  915.   `third_type` tinyint(0) NOT NULL DEFAULT 0 COMMENT '第三方身份（微信小程序0，支付宝小程序1）',
    916. 

  916.   `user_id` bigint(0) NOT NULL,
    917. 

  917.   PRIMARY KEY (`id`) USING BTREE,
    918. 

  918.   INDEX `user_id`(`user_id`) USING BTREE,
    919. 

  919.   INDEX `identity_code`(`identity_code`, `third_type`) USING BTREE
    920. 

  920. ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '小程序用户在第三方平台中的身份（如果在小程序中的openid）' ROW_FORMAT = Dynamic;
    921. 

  921. 

  922. -- ----------------------------
    923. 

  923. -- Records of tb_user_third_identity
    924. 

  924. -- ----------------------------
    925. 

  925. 

  926. -- ----------------------------
    927. 

  927. -- Table structure for test_api
    928. 

  928. -- ----------------------------
    929. 

  929. DROP TABLE IF EXISTS `test_api`;
    930. 

  930. CREATE TABLE `test_api`  (
    931. 

  931.   `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
    932. 

  932.   `name` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '名称',
    933. 

  933.   `time` datetime(0) NULL DEFAULT NULL,
    934. 

  934.   `sex` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '性别',
    935. 

  935.   `age` int(0) NULL DEFAULT NULL COMMENT '年龄',
    936. 

  936.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '创建者',
    937. 

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

  938.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '更新者',
    939. 

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

  940.   PRIMARY KEY (`id`) USING BTREE
    941. 

  941. ) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '测试' ROW_FORMAT = Dynamic;
    942. 

  942. 

  943. -- ----------------------------
    944. 

  944. -- Records of test_api
    945. 

  945. -- ----------------------------
    946. 

  946. INSERT INTO `test_api` VALUES (9, '1', '2022-03-18 18:31:13', '1', 1, '', NULL, '', NULL);
    947. 

  947. 

  948. -- ----------------------------
    949. 

  949. -- Table structure for test_demo
    950. 

  950. -- ----------------------------
    951. 

  951. DROP TABLE IF EXISTS `test_demo`;
    952. 

  952. CREATE TABLE `test_demo`  (
    953. 

  953.   `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
    954. 

  954.   `dept_id` int(0) NULL DEFAULT NULL COMMENT '部门id',
    955. 

  955.   `user_id` int(0) NULL DEFAULT NULL COMMENT '用户id',
    956. 

  956.   `order_num` int(0) NULL DEFAULT 0 COMMENT '排序号',
    957. 

  957.   `test_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'key键',
    958. 

  958.   `value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '值',
    959. 

  959.   `version` int(0) NULL DEFAULT 0 COMMENT '版本',
    960. 

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

  961.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人',
    962. 

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

  963.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人',
    964. 

  964.   `del_flag` int(0) NULL DEFAULT 0 COMMENT '删除标志',
    965. 

  965.   PRIMARY KEY (`id`) USING BTREE
    966. 

  966. ) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '测试单表' ROW_FORMAT = Dynamic;
    967. 

  967. 

  968. -- ----------------------------
    969. 

  969. -- Records of test_demo
    970. 

  970. -- ----------------------------
    971. 

  971. INSERT INTO `test_demo` VALUES (1, 102, 4, 1, '测试数据权限', '测试', 0, '2021-06-01 10:00:00', 'admin', NULL, NULL, 0);
    972. 

  972. INSERT INTO `test_demo` VALUES (2, 102, 3, 2, '子节点1', '111', 0, '2021-06-01 10:00:00', 'admin', NULL, NULL, 0);
    973. 

  973. INSERT INTO `test_demo` VALUES (3, 102, 3, 3, '子节点2', '222', 0, '2021-06-01 10:00:00', 'admin', NULL, NULL, 0);
    974. 

  974. INSERT INTO `test_demo` VALUES (4, 108, 4, 4, '测试数据', 'demo', 0, '2021-06-01 10:00:00', 'admin', NULL, NULL, 0);
    975. 

  975. INSERT INTO `test_demo` VALUES (5, 108, 3, 13, '子节点11', '1111', 0, '2021-06-01 10:00:00', 'admin', NULL, NULL, 0);
    976. 

  976. INSERT INTO `test_demo` VALUES (6, 108, 3, 12, '子节点22', '2222', 0, '2021-06-01 10:00:00', 'admin', NULL, NULL, 0);
    977. 

  977. INSERT INTO `test_demo` VALUES (7, 108, 3, 11, '子节点33', '3333', 0, '2021-06-01 10:00:00', 'admin', NULL, NULL, 0);
    978. 

  978. INSERT INTO `test_demo` VALUES (8, 108, 3, 10, '子节点44', '4444', 0, '2021-06-01 10:00:00', 'admin', NULL, NULL, 0);
    979. 

  979. INSERT INTO `test_demo` VALUES (9, 108, 3, 9, '子节点55', '5555', 0, '2021-06-01 10:00:00', 'admin', NULL, NULL, 0);
    980. 

  980. INSERT INTO `test_demo` VALUES (10, 108, 3, 8, '子节点66', '6666', 0, '2021-06-01 10:00:00', 'admin', NULL, NULL, 0);
    981. 

  981. INSERT INTO `test_demo` VALUES (11, 108, 3, 7, '子节点77', '7777', 0, '2021-06-01 10:00:00', 'admin', NULL, NULL, 0);
    982. 

  982. INSERT INTO `test_demo` VALUES (12, 108, 3, 6, '子节点88', '8888', 0, '2021-06-01 10:00:00', 'admin', NULL, NULL, 0);
    983. 

  983. INSERT INTO `test_demo` VALUES (13, 108, 3, 5, '子节点99', '9999', 0, '2021-06-01 10:00:00', 'admin', NULL, NULL, 0);
    984. 

  984. 

  985. -- ----------------------------
    986. 

  986. -- Table structure for test_tree
    987. 

  987. -- ----------------------------
    988. 

  988. DROP TABLE IF EXISTS `test_tree`;
    989. 

  989. CREATE TABLE `test_tree`  (
    990. 

  990.   `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
    991. 

  991.   `parent_id` int(0) NULL DEFAULT 0 COMMENT '父id',
    992. 

  992.   `dept_id` int(0) NULL DEFAULT NULL COMMENT '部门id',
    993. 

  993.   `user_id` int(0) NULL DEFAULT NULL COMMENT '用户id',
    994. 

  994.   `tree_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '值',
    995. 

  995.   `version` int(0) NULL DEFAULT 0 COMMENT '版本',
    996. 

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

  997.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人',
    998. 

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

  999.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人',
    1000. 

  1000.   `del_flag` int(0) NULL DEFAULT 0 COMMENT '删除标志',
    1001. 

  1001.   PRIMARY KEY (`id`) USING BTREE
    1002. 

  1002. ) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '测试树表' ROW_FORMAT = Dynamic;
    1003. 

  1003. 

  1004. -- ----------------------------
    1005. 

  1005. -- Records of test_tree
    1006. 

  1006. -- ----------------------------
    1007. 

  1007. INSERT INTO `test_tree` VALUES (1, 0, 102, 4, '测试数据权限', 0, '2021-06-01 10:00:00', 'admin', NULL, NULL, 0);
    1008. 

  1008. INSERT INTO `test_tree` VALUES (2, 1, 102, 3, '子节点1', 0, '2021-06-01 10:00:00', 'admin', NULL, NULL, 0);
    1009. 

  1009. INSERT INTO `test_tree` VALUES (3, 2, 102, 3, '子节点2', 0, '2021-06-01 10:00:00', 'admin', NULL, NULL, 0);
    1010. 

  1010. INSERT INTO `test_tree` VALUES (4, 0, 108, 4, '测试树1', 0, '2021-06-01 10:00:00', 'admin', NULL, NULL, 0);
    1011. 

  1011. INSERT INTO `test_tree` VALUES (5, 4, 108, 3, '子节点11', 0, '2021-06-01 10:00:00', 'admin', NULL, NULL, 0);
    1012. 

  1012. INSERT INTO `test_tree` VALUES (6, 4, 108, 3, '子节点22', 0, '2021-06-01 10:00:00', 'admin', NULL, NULL, 0);
    1013. 

  1013. INSERT INTO `test_tree` VALUES (7, 4, 108, 3, '子节点33', 0, '2021-06-01 10:00:00', 'admin', NULL, NULL, 0);
    1014. 

  1014. INSERT INTO `test_tree` VALUES (8, 5, 108, 3, '子节点44', 0, '2021-06-01 10:00:00', 'admin', NULL, NULL, 0);
    1015. 

  1015. INSERT INTO `test_tree` VALUES (9, 6, 108, 3, '子节点55', 0, '2021-06-01 10:00:00', 'admin', NULL, NULL, 0);
    1016. 

  1016. INSERT INTO `test_tree` VALUES (10, 7, 108, 3, '子节点66', 0, '2021-06-01 10:00:00', 'admin', NULL, NULL, 0);
    1017. 

  1017. INSERT INTO `test_tree` VALUES (11, 7, 108, 3, '子节点77', 0, '2021-06-01 10:00:00', 'admin', NULL, NULL, 0);
    1018. 

  1018. INSERT INTO `test_tree` VALUES (12, 10, 108, 3, '子节点88', 0, '2021-06-01 10:00:00', 'admin', NULL, NULL, 0);
    1019. 

  1019. INSERT INTO `test_tree` VALUES (13, 10, 108, 3, '子节点99', 0, '2021-06-01 10:00:00', 'admin', NULL, NULL, 0);
    1020. 

  1020. 

  1021. -- ----------------------------
    1022. 

  1022. -- Table structure for xxl_job_group
    1023. 

  1023. -- ----------------------------
    1024. 

  1024. DROP TABLE IF EXISTS `xxl_job_group`;
    1025. 

  1025. CREATE TABLE `xxl_job_group`  (
    1026. 

  1026.   `id` int(0) NOT NULL AUTO_INCREMENT,
    1027. 

  1027.   `app_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '执行器AppName',
    1028. 

  1028.   `title` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '执行器名称',
    1029. 

  1029.   `address_type` tinyint(0) NOT NULL DEFAULT 0 COMMENT '执行器地址类型：0=自动注册、1=手动录入',
    1030. 

  1030.   `address_list` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '执行器地址列表，多地址逗号分隔',
    1031. 

  1031.   `update_time` datetime(0) NULL DEFAULT NULL,
    1032. 

  1032.   PRIMARY KEY (`id`) USING BTREE
    1033. 

  1033. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
    1034. 

  1034. 

  1035. -- ----------------------------
    1036. 

  1036. -- Records of xxl_job_group
    1037. 

  1037. -- ----------------------------
    1038. 

  1038. INSERT INTO `xxl_job_group` VALUES (1, 'xxl-job-executor', '示例执行器', 0, 'http://192.168.0.152:9101/', '2022-03-04 20:08:48');
    1039. 

  1039. 

  1040. -- ----------------------------
    1041. 

  1041. -- Table structure for xxl_job_info
    1042. 

  1042. -- ----------------------------
    1043. 

  1043. DROP TABLE IF EXISTS `xxl_job_info`;
    1044. 

  1044. CREATE TABLE `xxl_job_info`  (
    1045. 

  1045.   `id` int(0) NOT NULL AUTO_INCREMENT,
    1046. 

  1046.   `job_group` int(0) NOT NULL COMMENT '执行器主键ID',
    1047. 

  1047.   `job_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
    1048. 

  1048.   `add_time` datetime(0) NULL DEFAULT NULL,
    1049. 

  1049.   `update_time` datetime(0) NULL DEFAULT NULL,
    1050. 

  1050.   `author` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '作者',
    1051. 

  1051.   `alarm_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '报警邮件',
    1052. 

  1052.   `schedule_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'NONE' COMMENT '调度类型',
    1053. 

  1053.   `schedule_conf` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '调度配置，值含义取决于调度类型',
    1054. 

  1054.   `misfire_strategy` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'DO_NOTHING' COMMENT '调度过期策略',
    1055. 

  1055.   `executor_route_strategy` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '执行器路由策略',
    1056. 

  1056.   `executor_handler` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '执行器任务handler',
    1057. 

  1057.   `executor_param` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '执行器任务参数',
    1058. 

  1058.   `executor_block_strategy` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '阻塞处理策略',
    1059. 

  1059.   `executor_timeout` int(0) NOT NULL DEFAULT 0 COMMENT '任务执行超时时间，单位秒',
    1060. 

  1060.   `executor_fail_retry_count` int(0) NOT NULL DEFAULT 0 COMMENT '失败重试次数',
    1061. 

  1061.   `glue_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'GLUE类型',
    1062. 

  1062.   `glue_source` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT 'GLUE源代码',
    1063. 

  1063.   `glue_remark` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'GLUE备注',
    1064. 

  1064.   `glue_updatetime` datetime(0) NULL DEFAULT NULL COMMENT 'GLUE更新时间',
    1065. 

  1065.   `child_jobid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '子任务ID，多个逗号分隔',
    1066. 

  1066.   `trigger_status` tinyint(0) NOT NULL DEFAULT 0 COMMENT '调度状态：0-停止，1-运行',
    1067. 

  1067.   `trigger_last_time` bigint(0) NOT NULL DEFAULT 0 COMMENT '上次调度时间',
    1068. 

  1068.   `trigger_next_time` bigint(0) NOT NULL DEFAULT 0 COMMENT '下次调度时间',
    1069. 

  1069.   PRIMARY KEY (`id`) USING BTREE
    1070. 

  1070. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
    1071. 

  1071. 

  1072. -- ----------------------------
    1073. 

  1073. -- Records of xxl_job_info
    1074. 

  1074. -- ----------------------------
    1075. 

  1075. INSERT INTO `xxl_job_info` VALUES (1, 1, '测试任务1', '2018-11-03 22:21:31', '2018-11-03 22:21:31', 'XXL', '', 'CRON', '0 0 0 * * ? *', 'DO_NOTHING', 'FIRST', 'demoJobHandler', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2018-11-03 22:21:31', '', 0, 0, 0);
    1076. 

  1076. 

  1077. -- ----------------------------
    1078. 

  1078. -- Table structure for xxl_job_lock
    1079. 

  1079. -- ----------------------------
    1080. 

  1080. DROP TABLE IF EXISTS `xxl_job_lock`;
    1081. 

  1081. CREATE TABLE `xxl_job_lock`  (
    1082. 

  1082.   `lock_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '锁名称',
    1083. 

  1083.   PRIMARY KEY (`lock_name`) USING BTREE
    1084. 

  1084. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
    1085. 

  1085. 

  1086. -- ----------------------------
    1087. 

  1087. -- Records of xxl_job_lock
    1088. 

  1088. -- ----------------------------
    1089. 

  1089. INSERT INTO `xxl_job_lock` VALUES ('schedule_lock');
    1090. 

  1090. 

  1091. -- ----------------------------
    1092. 

  1092. -- Table structure for xxl_job_log
    1093. 

  1093. -- ----------------------------
    1094. 

  1094. DROP TABLE IF EXISTS `xxl_job_log`;
    1095. 

  1095. CREATE TABLE `xxl_job_log`  (
    1096. 

  1096.   `id` bigint(0) NOT NULL AUTO_INCREMENT,
    1097. 

  1097.   `job_group` int(0) NOT NULL COMMENT '执行器主键ID',
    1098. 

  1098.   `job_id` int(0) NOT NULL COMMENT '任务，主键ID',
    1099. 

  1099.   `executor_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '执行器地址，本次执行的地址',
    1100. 

  1100.   `executor_handler` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '执行器任务handler',
    1101. 

  1101.   `executor_param` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '执行器任务参数',
    1102. 

  1102.   `executor_sharding_param` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '执行器任务分片参数，格式如 1/2',
    1103. 

  1103.   `executor_fail_retry_count` int(0) NOT NULL DEFAULT 0 COMMENT '失败重试次数',
    1104. 

  1104.   `trigger_time` datetime(0) NULL DEFAULT NULL COMMENT '调度-时间',
    1105. 

  1105.   `trigger_code` int(0) NOT NULL COMMENT '调度-结果',
    1106. 

  1106.   `trigger_msg` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '调度-日志',
    1107. 

  1107.   `handle_time` datetime(0) NULL DEFAULT NULL COMMENT '执行-时间',
    1108. 

  1108.   `handle_code` int(0) NOT NULL COMMENT '执行-状态',
    1109. 

  1109.   `handle_msg` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '执行-日志',
    1110. 

  1110.   `alarm_status` tinyint(0) NOT NULL DEFAULT 0 COMMENT '告警状态：0-默认、1-无需告警、2-告警成功、3-告警失败',
    1111. 

  1111.   PRIMARY KEY (`id`) USING BTREE,
    1112. 

  1112.   INDEX `I_trigger_time`(`trigger_time`) USING BTREE,
    1113. 

  1113.   INDEX `I_handle_code`(`handle_code`) USING BTREE
    1114. 

  1114. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
    1115. 

  1115. 

  1116. -- ----------------------------
    1117. 

  1117. -- Records of xxl_job_log
    1118. 

  1118. -- ----------------------------
    1119. 

  1119. 

  1120. -- ----------------------------
    1121. 

  1121. -- Table structure for xxl_job_log_report
    1122. 

  1122. -- ----------------------------
    1123. 

  1123. DROP TABLE IF EXISTS `xxl_job_log_report`;
    1124. 

  1124. CREATE TABLE `xxl_job_log_report`  (
    1125. 

  1125.   `id` int(0) NOT NULL AUTO_INCREMENT,
    1126. 

  1126.   `trigger_day` datetime(0) NULL DEFAULT NULL COMMENT '调度-时间',
    1127. 

  1127.   `running_count` int(0) NOT NULL DEFAULT 0 COMMENT '运行中-日志数量',
    1128. 

  1128.   `suc_count` int(0) NOT NULL DEFAULT 0 COMMENT '执行成功-日志数量',
    1129. 

  1129.   `fail_count` int(0) NOT NULL DEFAULT 0 COMMENT '执行失败-日志数量',
    1130. 

  1130.   `update_time` datetime(0) NULL DEFAULT NULL,
    1131. 

  1131.   PRIMARY KEY (`id`) USING BTREE,
    1132. 

  1132.   UNIQUE INDEX `i_trigger_day`(`trigger_day`) USING BTREE
    1133. 

  1133. ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
    1134. 

  1134. 

  1135. -- ----------------------------
    1136. 

  1136. -- Records of xxl_job_log_report
    1137. 

  1137. -- ----------------------------
    1138. 

  1138. INSERT INTO `xxl_job_log_report` VALUES (1, '2022-03-02 00:00:00', 0, 0, 0, NULL);
    1139. 

  1139. INSERT INTO `xxl_job_log_report` VALUES (2, '2022-03-01 00:00:00', 0, 0, 0, NULL);
    1140. 

  1140. INSERT INTO `xxl_job_log_report` VALUES (3, '2022-02-28 00:00:00', 0, 0, 0, NULL);
    1141. 

  1141. INSERT INTO `xxl_job_log_report` VALUES (4, '2022-03-03 00:00:00', 0, 0, 0, NULL);
    1142. 

  1142. INSERT INTO `xxl_job_log_report` VALUES (5, '2022-03-04 00:00:00', 0, 0, 0, NULL);
    1143. 

  1143. 

  1144. -- ----------------------------
    1145. 

  1145. -- Table structure for xxl_job_logglue
    1146. 

  1146. -- ----------------------------
    1147. 

  1147. DROP TABLE IF EXISTS `xxl_job_logglue`;
    1148. 

  1148. CREATE TABLE `xxl_job_logglue`  (
    1149. 

  1149.   `id` int(0) NOT NULL AUTO_INCREMENT,
    1150. 

  1150.   `job_id` int(0) NOT NULL COMMENT '任务，主键ID',
    1151. 

  1151.   `glue_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'GLUE类型',
    1152. 

  1152.   `glue_source` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT 'GLUE源代码',
    1153. 

  1153.   `glue_remark` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'GLUE备注',
    1154. 

  1154.   `add_time` datetime(0) NULL DEFAULT NULL,
    1155. 

  1155.   `update_time` datetime(0) NULL DEFAULT NULL,
    1156. 

  1156.   PRIMARY KEY (`id`) USING BTREE
    1157. 

  1157. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
    1158. 

  1158. 

  1159. -- ----------------------------
    1160. 

  1160. -- Records of xxl_job_logglue
    1161. 

  1161. -- ----------------------------
    1162. 

  1162. 

  1163. -- ----------------------------
    1164. 

  1164. -- Table structure for xxl_job_registry
    1165. 

  1165. -- ----------------------------
    1166. 

  1166. DROP TABLE IF EXISTS `xxl_job_registry`;
    1167. 

  1167. CREATE TABLE `xxl_job_registry`  (
    1168. 

  1168.   `id` int(0) NOT NULL AUTO_INCREMENT,
    1169. 

  1169.   `registry_group` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
    1170. 

  1170.   `registry_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
    1171. 

  1171.   `registry_value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
    1172. 

  1172.   `update_time` datetime(0) NULL DEFAULT NULL,
    1173. 

  1173.   PRIMARY KEY (`id`) USING BTREE,
    1174. 

  1174.   INDEX `i_g_k_v`(`registry_group`, `registry_key`, `registry_value`) USING BTREE
    1175. 

  1175. ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
    1176. 

  1176. 

  1177. -- ----------------------------
    1178. 

  1178. -- Records of xxl_job_registry
    1179. 

  1179. -- ----------------------------
    1180. 

  1180. INSERT INTO `xxl_job_registry` VALUES (3, 'EXECUTOR', 'xxl-job-executor', 'http://192.168.0.152:9101/', '2022-03-04 20:09:01');
    1181. 

  1181. 

  1182. -- ----------------------------
    1183. 

  1183. -- Table structure for xxl_job_user
    1184. 

  1184. -- ----------------------------
    1185. 

  1185. DROP TABLE IF EXISTS `xxl_job_user`;
    1186. 

  1186. CREATE TABLE `xxl_job_user`  (
    1187. 

  1187.   `id` int(0) NOT NULL AUTO_INCREMENT,
    1188. 

  1188.   `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '账号',
    1189. 

  1189.   `password` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '密码',
    1190. 

  1190.   `role` tinyint(0) NOT NULL COMMENT '角色：0-普通用户、1-管理员',
    1191. 

  1191.   `permission` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '权限：执行器ID列表，多个逗号分割',
    1192. 

  1192.   PRIMARY KEY (`id`) USING BTREE,
    1193. 

  1193.   UNIQUE INDEX `i_username`(`username`) USING BTREE
    1194. 

  1194. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
    1195. 

  1195. 

  1196. -- ----------------------------
    1197. 

  1197. -- Records of xxl_job_user
    1198. 

  1198. -- ----------------------------
    1199. 

  1199. INSERT INTO `xxl_job_user` VALUES (1, 'admin', 'e10adc3949ba59abbe56e057f20f883e', 1, NULL);
    1200. 

  1200. 

  1201. SET FOREIGN_KEY_CHECKS = 1;
    1202. 

  1202.