Эхлэл Бүгдийг харах Тусламж
Бүртгүүлэх Нэвтрэх
allen
/
pdaaphm
1
0
Салаа 0
Файлууд Асуудлууд 0 Хуулах хүсэлтүүд 0 Мэдлэгийн сан
Салаа: master
Салаанууд Тагууд
pdaaphm
/
sql
/
pdaaphm.sql

pdaaphm.sql 168 KB
Байнгын холболт Түүх Анхны өгөгдөл

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194 
  1. /*
    2. 

  2.  Navicat Premium Data Transfer
    3. 

  3. 

  4.  Source Server         : 47.108.150.237
    5. 

  5.  Source Server Type    : MySQL
    6. 

  6.  Source Server Version : 80027
    7. 

  7.  Source Host           : 47.108.150.237:3306
    8. 

  8.  Source Schema         : pdaaphm
    9. 

  9. 

  10.  Target Server Type    : MySQL
    11. 

  11.  Target Server Version : 80027
    12. 

  12.  File Encoding         : 65001
    13. 

  13. 

  14.  Date: 05/06/2024 21:09:03
    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 NOT NULL AUTO_INCREMENT COMMENT '编号',
    26. 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  46. ) ENGINE = InnoDB AUTO_INCREMENT = 31 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '代码生成业务表' ROW_FORMAT = Dynamic;
    47. 

  47. 

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

  49. -- Records of gen_table
    50. 

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

  51. INSERT INTO `gen_table` VALUES (21, 't_algorithm', '算法表', NULL, NULL, 'TAlgorithm', 'crud', 'com.pdaaphm.biz', 'algoManager', 'algorithm3', '故障预测', 'ruoyi', '0', '/', '{\"parentMenuId\":\"2000\"}', 'admin', '2024-06-04 09:01:27', '', '2024-06-05 12:33:28', NULL);
    52. 

  52. INSERT INTO `gen_table` VALUES (22, 't_algorithm_io_field', '算法输入输出字段表', NULL, NULL, 'TAlgorithmIoField', 'crud', 'com.pdaaphm.biz', 'conf', 'field', '算法输入输出字段', 'ruoyi', '0', '/', '{\"parentMenuId\":2001}', 'admin', '2024-06-04 09:01:30', '', '2024-06-04 11:36:07', NULL);
    53. 

  53. INSERT INTO `gen_table` VALUES (23, 't_algorithm_sub_type', '算法子类型表', NULL, NULL, 'TAlgorithmSubType', 'crud', 'com.pdaaphm.biz', 'conf', 'subType', '算法子类型', 'ruoyi', '0', '/', '{\"parentMenuId\":2001}', 'admin', '2024-06-04 09:01:32', '', '2024-06-04 10:40:01', NULL);
    54. 

  54. INSERT INTO `gen_table` VALUES (24, 't_file', '文件表', NULL, NULL, 'TFile', 'crud', 'com.pdaaphm.biz', 'algoManager', 'file', '数据管理', 'ruoyi', '0', '/', '{\"parentMenuId\":\"2000\"}', 'admin', '2024-06-04 09:01:35', '', '2024-06-05 08:37:35', NULL);
    55. 

  55. INSERT INTO `gen_table` VALUES (25, 't_sub_algorithm', '算法子表', NULL, NULL, 'TSubAlgorithm', 'crud', 'com.pdaaphm.biz', 'biz', 'algorithm', '算法子', 'ruoyi', '0', '/', NULL, 'admin', '2024-06-04 09:01:37', '', NULL, NULL);
    56. 

  56. 

  57. -- ----------------------------
    58. 

  58. -- Table structure for gen_table_column
    59. 

  59. -- ----------------------------
    60. 

  60. DROP TABLE IF EXISTS `gen_table_column`;
    61. 

  61. CREATE TABLE `gen_table_column`  (
    62. 

  62.                                      `column_id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
    63. 

  63.                                      `table_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '归属表编号',
    64. 

  64.                                      `column_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '列名称',
    65. 

  65.                                      `column_comment` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '列描述',
    66. 

  66.                                      `column_type` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '列类型',
    67. 

  67.                                      `java_type` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT 'JAVA类型',
    68. 

  68.                                      `java_field` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT 'JAVA字段名',
    69. 

  69.                                      `is_pk` char(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '是否主键（1是）',
    70. 

  70.                                      `is_increment` char(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '是否自增（1是）',
    71. 

  71.                                      `is_required` char(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '是否必填（1是）',
    72. 

  72.                                      `is_insert` char(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '是否为插入字段（1是）',
    73. 

  73.                                      `is_edit` char(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '是否编辑字段（1是）',
    74. 

  74.                                      `is_list` char(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '是否列表字段（1是）',
    75. 

  75.                                      `is_query` char(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '是否查询字段（1是）',
    76. 

  76.                                      `query_type` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT 'EQ' COMMENT '查询方式（等于、不等于、大于、小于、范围）',
    77. 

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

  78.                                      `dict_type` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '字典类型',
    79. 

  79.                                      `sort` int NULL DEFAULT NULL COMMENT '排序',
    80. 

  80.                                      `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '创建者',
    81. 

  81.                                      `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    82. 

  82.                                      `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '更新者',
    83. 

  83.                                      `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
    84. 

  84.                                      PRIMARY KEY (`column_id`) USING BTREE
    85. 

  85. ) ENGINE = InnoDB AUTO_INCREMENT = 301 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '代码生成业务表字段' ROW_FORMAT = Dynamic;
    86. 

  86. 

  87. -- ----------------------------
    88. 

  88. -- Records of gen_table_column
    89. 

  89. -- ----------------------------
    90. 

  90. INSERT INTO `gen_table_column` VALUES (201, '21', 'id', '编号', 'bigint', 'Long', 'id', '1', '1', NULL, '1', NULL, NULL, NULL, 'EQ', 'input', '', 1, 'admin', '2024-06-04 09:01:27', '', '2024-06-05 12:33:28');
    91. 

  91. INSERT INTO `gen_table_column` VALUES (202, '21', 'type', '算法类型', 'varchar(10)', 'String', 'type', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'select', '', 2, 'admin', '2024-06-04 09:01:28', '', '2024-06-05 12:33:28');
    92. 

  92. INSERT INTO `gen_table_column` VALUES (203, '21', 'sub_type_id', '子类型id', 'bigint', 'Long', 'subTypeId', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'input', '', 3, 'admin', '2024-06-04 09:01:28', '', '2024-06-05 12:33:28');
    93. 

  93. INSERT INTO `gen_table_column` VALUES (204, '21', 'name', '名称', 'varchar(200)', 'String', 'name', '0', '0', NULL, '1', '1', '1', '1', 'LIKE', 'input', '', 4, 'admin', '2024-06-04 09:01:28', '', '2024-06-05 12:33:28');
    94. 

  94. INSERT INTO `gen_table_column` VALUES (205, '21', 'start_time', '开始时间', 'datetime', 'Date', 'startTime', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'datetime', '', 5, 'admin', '2024-06-04 09:01:28', '', '2024-06-05 12:33:28');
    95. 

  95. INSERT INTO `gen_table_column` VALUES (206, '21', 'completed_time', '完成时间', 'datetime', 'Date', 'completedTime', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'datetime', '', 6, 'admin', '2024-06-04 09:01:28', '', '2024-06-05 12:33:28');
    96. 

  96. INSERT INTO `gen_table_column` VALUES (207, '21', 'cost_second', '耗时(s)', 'int', 'Long', 'costSecond', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'input', '', 7, 'admin', '2024-06-04 09:01:29', '', '2024-06-05 12:33:28');
    97. 

  97. INSERT INTO `gen_table_column` VALUES (208, '21', 'create_by', '创建者', 'varchar(64)', 'String', 'createBy', '0', '0', NULL, '1', NULL, NULL, NULL, 'EQ', 'input', '', 8, 'admin', '2024-06-04 09:01:29', '', '2024-06-05 12:33:29');
    98. 

  98. INSERT INTO `gen_table_column` VALUES (209, '21', 'create_time', '创建时间', 'datetime', 'Date', 'createTime', '0', '0', NULL, '1', NULL, NULL, NULL, 'EQ', 'datetime', '', 9, 'admin', '2024-06-04 09:01:29', '', '2024-06-05 12:33:29');
    99. 

  99. INSERT INTO `gen_table_column` VALUES (210, '21', 'update_by', '更新者', 'varchar(64)', 'String', 'updateBy', '0', '0', NULL, '1', '1', NULL, NULL, 'EQ', 'input', '', 10, 'admin', '2024-06-04 09:01:29', '', '2024-06-05 12:33:29');
    100. 

  100. INSERT INTO `gen_table_column` VALUES (211, '21', 'update_time', '更新时间', 'datetime', 'Date', 'updateTime', '0', '0', NULL, '1', '1', NULL, NULL, 'EQ', 'datetime', '', 11, 'admin', '2024-06-04 09:01:29', '', '2024-06-05 12:33:29');
    101. 

  101. INSERT INTO `gen_table_column` VALUES (212, '21', 'remark', '备注', 'varchar(500)', 'String', 'remark', '0', '0', NULL, '1', '1', '1', NULL, 'EQ', 'textarea', '', 12, 'admin', '2024-06-04 09:01:29', '', '2024-06-05 12:33:29');
    102. 

  102. INSERT INTO `gen_table_column` VALUES (213, '22', 'id', '编号', 'bigint', 'Long', 'id', '1', '1', NULL, '1', NULL, NULL, NULL, 'EQ', 'input', '', 1, 'admin', '2024-06-04 09:01:30', '', '2024-06-04 11:36:07');
    103. 

  103. INSERT INTO `gen_table_column` VALUES (214, '22', 'algorithm_sub_id', '算法子类型编号', 'bigint', 'Long', 'algorithmSubId', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'input', '', 2, 'admin', '2024-06-04 09:01:30', '', '2024-06-04 11:36:07');
    104. 

  104. INSERT INTO `gen_table_column` VALUES (215, '22', 'type', '输入/输出', 'varchar(10)', 'String', 'type', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'select', '', 3, 'admin', '2024-06-04 09:01:30', '', '2024-06-04 11:36:07');
    105. 

  105. INSERT INTO `gen_table_column` VALUES (216, '22', 'name', '名称', 'varchar(200)', 'String', 'name', '0', '0', NULL, '1', '1', '1', '1', 'LIKE', 'input', '', 4, 'admin', '2024-06-04 09:01:31', '', '2024-06-04 11:36:07');
    106. 

  106. INSERT INTO `gen_table_column` VALUES (217, '22', 'index', '排序', 'int', 'Long', 'index', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'input', '', 5, 'admin', '2024-06-04 09:01:31', '', '2024-06-04 11:36:07');
    107. 

  107. INSERT INTO `gen_table_column` VALUES (218, '22', 'create_by', '创建者', 'varchar(64)', 'String', 'createBy', '0', '0', NULL, '1', NULL, NULL, NULL, 'EQ', 'input', '', 6, 'admin', '2024-06-04 09:01:31', '', '2024-06-04 11:36:07');
    108. 

  108. INSERT INTO `gen_table_column` VALUES (219, '22', 'create_time', '创建时间', 'datetime', 'Date', 'createTime', '0', '0', NULL, '1', NULL, NULL, NULL, 'EQ', 'datetime', '', 7, 'admin', '2024-06-04 09:01:31', '', '2024-06-04 11:36:07');
    109. 

  109. INSERT INTO `gen_table_column` VALUES (220, '22', 'update_by', '更新者', 'varchar(64)', 'String', 'updateBy', '0', '0', NULL, '1', '1', NULL, NULL, 'EQ', 'input', '', 8, 'admin', '2024-06-04 09:01:32', '', '2024-06-04 11:36:07');
    110. 

  110. INSERT INTO `gen_table_column` VALUES (221, '22', 'update_time', '更新时间', 'datetime', 'Date', 'updateTime', '0', '0', NULL, '1', '1', NULL, NULL, 'EQ', 'datetime', '', 9, 'admin', '2024-06-04 09:01:32', '', '2024-06-04 11:36:07');
    111. 

  111. INSERT INTO `gen_table_column` VALUES (222, '22', 'remark', '备注', 'varchar(500)', 'String', 'remark', '0', '0', NULL, '1', '1', '1', NULL, 'EQ', 'textarea', '', 10, 'admin', '2024-06-04 09:01:32', '', '2024-06-04 11:36:07');
    112. 

  112. INSERT INTO `gen_table_column` VALUES (223, '23', 'id', '编号', 'bigint', 'Long', 'id', '1', '1', NULL, '1', NULL, NULL, NULL, 'EQ', 'input', '', 1, 'admin', '2024-06-04 09:01:32', '', '2024-06-04 10:40:02');
    113. 

  113. INSERT INTO `gen_table_column` VALUES (224, '23', 'type', '类型', 'varchar(10)', 'String', 'type', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'select', '', 2, 'admin', '2024-06-04 09:01:33', '', '2024-06-04 10:40:02');
    114. 

  114. INSERT INTO `gen_table_column` VALUES (225, '23', 'name', '算法子名称', 'varchar(200)', 'String', 'name', '0', '0', NULL, '1', '1', '1', '1', 'LIKE', 'input', '', 3, 'admin', '2024-06-04 09:01:33', '', '2024-06-04 10:40:02');
    115. 

  115. INSERT INTO `gen_table_column` VALUES (226, '23', 'url', '算法url', 'varchar(255)', 'String', 'url', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'input', '', 4, 'admin', '2024-06-04 09:01:33', '', '2024-06-04 10:40:02');
    116. 

  116. INSERT INTO `gen_table_column` VALUES (227, '23', 'run_type', '运行类型', 'varchar(255)', 'String', 'runType', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'select', '', 5, 'admin', '2024-06-04 09:01:33', '', '2024-06-04 10:40:03');
    117. 

  117. INSERT INTO `gen_table_column` VALUES (228, '23', 'create_by', '创建者', 'varchar(64)', 'String', 'createBy', '0', '0', NULL, '1', NULL, NULL, NULL, 'EQ', 'input', '', 6, 'admin', '2024-06-04 09:01:34', '', '2024-06-04 10:40:03');
    118. 

  118. INSERT INTO `gen_table_column` VALUES (229, '23', 'create_time', '创建时间', 'datetime', 'Date', 'createTime', '0', '0', NULL, '1', NULL, NULL, NULL, 'EQ', 'datetime', '', 7, 'admin', '2024-06-04 09:01:34', '', '2024-06-04 10:40:03');
    119. 

  119. INSERT INTO `gen_table_column` VALUES (230, '23', 'update_by', '更新者', 'varchar(64)', 'String', 'updateBy', '0', '0', NULL, '1', '1', NULL, NULL, 'EQ', 'input', '', 8, 'admin', '2024-06-04 09:01:34', '', '2024-06-04 10:40:04');
    120. 

  120. INSERT INTO `gen_table_column` VALUES (231, '23', 'update_time', '更新时间', 'datetime', 'Date', 'updateTime', '0', '0', NULL, '1', '1', NULL, NULL, 'EQ', 'datetime', '', 9, 'admin', '2024-06-04 09:01:34', '', '2024-06-04 10:40:04');
    121. 

  121. INSERT INTO `gen_table_column` VALUES (232, '23', 'remark', '备注', 'varchar(500)', 'String', 'remark', '0', '0', NULL, '1', '1', '1', NULL, 'EQ', 'textarea', '', 10, 'admin', '2024-06-04 09:01:34', '', '2024-06-04 10:40:04');
    122. 

  122. INSERT INTO `gen_table_column` VALUES (233, '24', 'id', '编号', 'bigint', 'Long', 'id', '1', '1', NULL, '1', NULL, NULL, NULL, 'EQ', 'input', '', 1, 'admin', '2024-06-04 09:01:35', '', '2024-06-05 08:37:35');
    123. 

  123. INSERT INTO `gen_table_column` VALUES (234, '24', 'name', '文档名称', 'varchar(200)', 'String', 'name', '0', '0', NULL, '1', '1', '1', '1', 'LIKE', 'input', '', 2, 'admin', '2024-06-04 09:01:36', '', '2024-06-05 08:37:35');
    124. 

  124. INSERT INTO `gen_table_column` VALUES (235, '24', 'path', '文档路径', 'varchar(255)', 'String', 'path', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'input', '', 3, 'admin', '2024-06-04 09:01:36', '', '2024-06-05 08:37:35');
    125. 

  125. INSERT INTO `gen_table_column` VALUES (236, '24', 'type', '类型', 'varchar(10)', 'String', 'type', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'select', '', 4, 'admin', '2024-06-04 09:01:36', '', '2024-06-05 08:37:36');
    126. 

  126. INSERT INTO `gen_table_column` VALUES (237, '24', 'create_by', '创建者', 'varchar(64)', 'String', 'createBy', '0', '0', NULL, '1', NULL, NULL, NULL, 'EQ', 'input', '', 5, 'admin', '2024-06-04 09:01:36', '', '2024-06-05 08:37:36');
    127. 

  127. INSERT INTO `gen_table_column` VALUES (238, '24', 'create_time', '创建时间', 'datetime', 'Date', 'createTime', '0', '0', NULL, '1', NULL, NULL, NULL, 'EQ', 'datetime', '', 6, 'admin', '2024-06-04 09:01:37', '', '2024-06-05 08:37:36');
    128. 

  128. INSERT INTO `gen_table_column` VALUES (239, '24', 'update_by', '更新者', 'varchar(64)', 'String', 'updateBy', '0', '0', NULL, '1', '1', NULL, NULL, 'EQ', 'input', '', 7, 'admin', '2024-06-04 09:01:37', '', '2024-06-05 08:37:36');
    129. 

  129. INSERT INTO `gen_table_column` VALUES (240, '24', 'update_time', '更新时间', 'datetime', 'Date', 'updateTime', '0', '0', NULL, '1', '1', NULL, NULL, 'EQ', 'datetime', '', 8, 'admin', '2024-06-04 09:01:37', '', '2024-06-05 08:37:36');
    130. 

  130. INSERT INTO `gen_table_column` VALUES (241, '24', 'remark', '备注', 'varchar(500)', 'String', 'remark', '0', '0', NULL, '1', '1', '1', NULL, 'EQ', 'textarea', '', 9, 'admin', '2024-06-04 09:01:37', '', '2024-06-05 08:37:36');
    131. 

  131. INSERT INTO `gen_table_column` VALUES (242, '25', 'id', '编号', 'bigint', 'Long', 'id', '1', '1', NULL, '1', NULL, NULL, NULL, 'EQ', 'input', '', 1, 'admin', '2024-06-04 09:01:38', '', NULL);
    132. 

  132. INSERT INTO `gen_table_column` VALUES (243, '25', 'algorithm_id', '主表id', 'bigint', 'Long', 'algorithmId', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'input', '', 2, 'admin', '2024-06-04 09:01:38', '', NULL);
    133. 

  133. INSERT INTO `gen_table_column` VALUES (244, '25', 'field_id', '字段id', 'bigint', 'Long', 'fieldId', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'input', '', 3, 'admin', '2024-06-04 09:01:38', '', NULL);
    134. 

  134. INSERT INTO `gen_table_column` VALUES (245, '25', 'upload_id', '文件id', 'bigint', 'Long', 'uploadId', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'input', '', 4, 'admin', '2024-06-04 09:01:39', '', NULL);
    135. 

  135. INSERT INTO `gen_table_column` VALUES (246, '25', 'create_by', '创建者', 'varchar(64)', 'String', 'createBy', '0', '0', NULL, '1', NULL, NULL, NULL, 'EQ', 'input', '', 5, 'admin', '2024-06-04 09:01:39', '', NULL);
    136. 

  136. INSERT INTO `gen_table_column` VALUES (247, '25', 'create_time', '创建时间', 'datetime', 'Date', 'createTime', '0', '0', NULL, '1', NULL, NULL, NULL, 'EQ', 'datetime', '', 6, 'admin', '2024-06-04 09:01:39', '', NULL);
    137. 

  137. INSERT INTO `gen_table_column` VALUES (248, '25', 'update_by', '更新者', 'varchar(64)', 'String', 'updateBy', '0', '0', NULL, '1', '1', NULL, NULL, 'EQ', 'input', '', 7, 'admin', '2024-06-04 09:01:39', '', NULL);
    138. 

  138. INSERT INTO `gen_table_column` VALUES (249, '25', 'update_time', '更新时间', 'datetime', 'Date', 'updateTime', '0', '0', NULL, '1', '1', NULL, NULL, 'EQ', 'datetime', '', 8, 'admin', '2024-06-04 09:01:39', '', NULL);
    139. 

  139. INSERT INTO `gen_table_column` VALUES (250, '25', 'remark', '备注', 'varchar(500)', 'String', 'remark', '0', '0', NULL, '1', '1', '1', NULL, 'EQ', 'textarea', '', 9, 'admin', '2024-06-04 09:01:39', '', NULL);
    140. 

  140. 

  141. -- ----------------------------
    142. 

  142. -- Table structure for sys_config
    143. 

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

  144. DROP TABLE IF EXISTS `sys_config`;
    145. 

  145. CREATE TABLE `sys_config`  (
    146. 

  146.                                `config_id` int NOT NULL AUTO_INCREMENT COMMENT '参数主键',
    147. 

  147.                                `config_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '参数名称',
    148. 

  148.                                `config_key` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '参数键名',
    149. 

  149.                                `config_value` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '参数键值',
    150. 

  150.                                `config_type` char(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT 'N' COMMENT '系统内置（Y是 N否）',
    151. 

  151.                                `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '创建者',
    152. 

  152.                                `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    153. 

  153.                                `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '更新者',
    154. 

  154.                                `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
    155. 

  155.                                `remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '备注',
    156. 

  156.                                PRIMARY KEY (`config_id`) USING BTREE
    157. 

  157. ) ENGINE = InnoDB AUTO_INCREMENT = 100 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '参数配置表' ROW_FORMAT = Dynamic;
    158. 

  158. 

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

  160. -- Records of sys_config
    161. 

  161. -- ----------------------------
    162. 

  162. INSERT INTO `sys_config` VALUES (1, '主框架页-默认皮肤样式名称', 'sys.index.skinName', 'skin-blue', 'Y', 'admin', '2024-06-04 08:38:48', '', NULL, '蓝色 skin-blue、绿色 skin-green、紫色 skin-purple、红色 skin-red、黄色 skin-yellow');
    163. 

  163. INSERT INTO `sys_config` VALUES (2, '用户管理-账号初始密码', 'sys.user.initPassword', '123456', 'Y', 'admin', '2024-06-04 08:38:48', '', NULL, '初始化密码 123456');
    164. 

  164. INSERT INTO `sys_config` VALUES (3, '主框架页-侧边栏主题', 'sys.index.sideTheme', 'theme-dark', 'Y', 'admin', '2024-06-04 08:38:48', '', NULL, '深色主题theme-dark，浅色主题theme-light');
    165. 

  165. INSERT INTO `sys_config` VALUES (4, '账号自助-验证码开关', 'sys.account.captchaEnabled', 'true', 'Y', 'admin', '2024-06-04 08:38:48', '', NULL, '是否开启验证码功能（true开启，false关闭）');
    166. 

  166. INSERT INTO `sys_config` VALUES (5, '账号自助-是否开启用户注册功能', 'sys.account.registerUser', 'false', 'Y', 'admin', '2024-06-04 08:38:48', '', NULL, '是否开启注册用户功能（true开启，false关闭）');
    167. 

  167. INSERT INTO `sys_config` VALUES (6, '用户登录-黑名单列表', 'sys.login.blackIPList', '', 'Y', 'admin', '2024-06-04 08:38:48', '', NULL, '设置登录IP黑名单限制，多个匹配项以;分隔，支持匹配（*通配、网段）');
    168. 

  168. 

  169. -- ----------------------------
    170. 

  170. -- Table structure for sys_dept
    171. 

  171. -- ----------------------------
    172. 

  172. DROP TABLE IF EXISTS `sys_dept`;
    173. 

  173. CREATE TABLE `sys_dept`  (
    174. 

  174.                              `dept_id` bigint NOT NULL AUTO_INCREMENT COMMENT '部门id',
    175. 

  175.                              `parent_id` bigint NULL DEFAULT 0 COMMENT '父部门id',
    176. 

  176.                              `ancestors` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '祖级列表',
    177. 

  177.                              `dept_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '部门名称',
    178. 

  178.                              `order_num` int NULL DEFAULT 0 COMMENT '显示顺序',
    179. 

  179.                              `leader` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '负责人',
    180. 

  180.                              `phone` varchar(11) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '联系电话',
    181. 

  181.                              `email` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '邮箱',
    182. 

  182.                              `status` char(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '0' COMMENT '部门状态（0正常 1停用）',
    183. 

  183.                              `del_flag` char(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
    184. 

  184.                              `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '创建者',
    185. 

  185.                              `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    186. 

  186.                              `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '更新者',
    187. 

  187.                              `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
    188. 

  188.                              PRIMARY KEY (`dept_id`) USING BTREE
    189. 

  189. ) ENGINE = InnoDB AUTO_INCREMENT = 200 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '部门表' ROW_FORMAT = Dynamic;
    190. 

  190. 

  191. -- ----------------------------
    192. 

  192. -- Records of sys_dept
    193. 

  193. -- ----------------------------
    194. 

  194. INSERT INTO `sys_dept` VALUES (100, 0, '0', '空军工程大学', 0, 'admin', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2024-06-04 08:38:43', '', NULL);
    195. 

  195. INSERT INTO `sys_dept` VALUES (101, 100, '0,100', '工院', 1, 'admin', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2024-06-04 08:38:43', '', NULL);
    196. 

  196. INSERT INTO `sys_dept` VALUES (102, 100, '0,100', '航空航天工程学院', 2, 'admin', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2024-06-04 08:38:43', '', NULL);
    197. 

  197. INSERT INTO `sys_dept` VALUES (103, 101, '0,100,101', '一部', 1, 'admin', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2024-06-04 08:38:43', '', NULL);
    198. 

  198. INSERT INTO `sys_dept` VALUES (104, 101, '0,100,101', '二部', 2, 'admin', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2024-06-04 08:38:43', '', NULL);
    199. 

  199. INSERT INTO `sys_dept` VALUES (105, 101, '0,100,101', '三部', 3, 'admin', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2024-06-04 08:38:43', '', NULL);
    200. 

  200. 

  201. -- ----------------------------
    202. 

  202. -- Table structure for sys_dict_data
    203. 

  203. -- ----------------------------
    204. 

  204. DROP TABLE IF EXISTS `sys_dict_data`;
    205. 

  205. CREATE TABLE `sys_dict_data`  (
    206. 

  206.                                   `dict_code` bigint NOT NULL AUTO_INCREMENT COMMENT '字典编码',
    207. 

  207.                                   `dict_sort` int NULL DEFAULT 0 COMMENT '字典排序',
    208. 

  208.                                   `dict_label` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '字典标签',
    209. 

  209.                                   `dict_value` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '字典键值',
    210. 

  210.                                   `dict_type` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '字典类型',
    211. 

  211.                                   `css_class` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '样式属性（其他样式扩展）',
    212. 

  212.                                   `list_class` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '表格回显样式',
    213. 

  213.                                   `is_default` char(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT 'N' COMMENT '是否默认（Y是 N否）',
    214. 

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

  215.                                   `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '创建者',
    216. 

  216.                                   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    217. 

  217.                                   `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '更新者',
    218. 

  218.                                   `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
    219. 

  219.                                   `remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '备注',
    220. 

  220.                                   PRIMARY KEY (`dict_code`) USING BTREE
    221. 

  221. ) ENGINE = InnoDB AUTO_INCREMENT = 100 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '字典数据表' ROW_FORMAT = Dynamic;
    222. 

  222. 

  223. -- ----------------------------
    224. 

  224. -- Records of sys_dict_data
    225. 

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

  226. INSERT INTO `sys_dict_data` VALUES (1, 1, '男', '0', 'sys_user_sex', '', '', 'Y', '0', 'admin', '2024-06-04 08:38:48', '', NULL, '性别男');
    227. 

  227. INSERT INTO `sys_dict_data` VALUES (2, 2, '女', '1', 'sys_user_sex', '', '', 'N', '0', 'admin', '2024-06-04 08:38:48', '', NULL, '性别女');
    228. 

  228. INSERT INTO `sys_dict_data` VALUES (3, 3, '未知', '2', 'sys_user_sex', '', '', 'N', '0', 'admin', '2024-06-04 08:38:48', '', NULL, '性别未知');
    229. 

  229. INSERT INTO `sys_dict_data` VALUES (4, 1, '显示', '0', 'sys_show_hide', '', 'primary', 'Y', '0', 'admin', '2024-06-04 08:38:48', '', NULL, '显示菜单');
    230. 

  230. INSERT INTO `sys_dict_data` VALUES (5, 2, '隐藏', '1', 'sys_show_hide', '', 'danger', 'N', '0', 'admin', '2024-06-04 08:38:48', '', NULL, '隐藏菜单');
    231. 

  231. INSERT INTO `sys_dict_data` VALUES (6, 1, '正常', '0', 'sys_normal_disable', '', 'primary', 'Y', '0', 'admin', '2024-06-04 08:38:48', '', NULL, '正常状态');
    232. 

  232. INSERT INTO `sys_dict_data` VALUES (7, 2, '停用', '1', 'sys_normal_disable', '', 'danger', 'N', '0', 'admin', '2024-06-04 08:38:48', '', NULL, '停用状态');
    233. 

  233. INSERT INTO `sys_dict_data` VALUES (8, 1, '正常', '0', 'sys_job_status', '', 'primary', 'Y', '0', 'admin', '2024-06-04 08:38:48', '', NULL, '正常状态');
    234. 

  234. INSERT INTO `sys_dict_data` VALUES (9, 2, '暂停', '1', 'sys_job_status', '', 'danger', 'N', '0', 'admin', '2024-06-04 08:38:48', '', NULL, '停用状态');
    235. 

  235. INSERT INTO `sys_dict_data` VALUES (10, 1, '默认', 'DEFAULT', 'sys_job_group', '', '', 'Y', '0', 'admin', '2024-06-04 08:38:48', '', NULL, '默认分组');
    236. 

  236. INSERT INTO `sys_dict_data` VALUES (11, 2, '系统', 'SYSTEM', 'sys_job_group', '', '', 'N', '0', 'admin', '2024-06-04 08:38:48', '', NULL, '系统分组');
    237. 

  237. INSERT INTO `sys_dict_data` VALUES (12, 1, '是', 'Y', 'sys_yes_no', '', 'primary', 'Y', '0', 'admin', '2024-06-04 08:38:48', '', NULL, '系统默认是');
    238. 

  238. INSERT INTO `sys_dict_data` VALUES (13, 2, '否', 'N', 'sys_yes_no', '', 'danger', 'N', '0', 'admin', '2024-06-04 08:38:48', '', NULL, '系统默认否');
    239. 

  239. INSERT INTO `sys_dict_data` VALUES (14, 1, '通知', '1', 'sys_notice_type', '', 'warning', 'Y', '0', 'admin', '2024-06-04 08:38:48', '', NULL, '通知');
    240. 

  240. INSERT INTO `sys_dict_data` VALUES (15, 2, '公告', '2', 'sys_notice_type', '', 'success', 'N', '0', 'admin', '2024-06-04 08:38:48', '', NULL, '公告');
    241. 

  241. INSERT INTO `sys_dict_data` VALUES (16, 1, '正常', '0', 'sys_notice_status', '', 'primary', 'Y', '0', 'admin', '2024-06-04 08:38:48', '', NULL, '正常状态');
    242. 

  242. INSERT INTO `sys_dict_data` VALUES (17, 2, '关闭', '1', 'sys_notice_status', '', 'danger', 'N', '0', 'admin', '2024-06-04 08:38:48', '', NULL, '关闭状态');
    243. 

  243. INSERT INTO `sys_dict_data` VALUES (18, 99, '其他', '0', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2024-06-04 08:38:48', '', NULL, '其他操作');
    244. 

  244. INSERT INTO `sys_dict_data` VALUES (19, 1, '新增', '1', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2024-06-04 08:38:48', '', NULL, '新增操作');
    245. 

  245. INSERT INTO `sys_dict_data` VALUES (20, 2, '修改', '2', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2024-06-04 08:38:48', '', NULL, '修改操作');
    246. 

  246. INSERT INTO `sys_dict_data` VALUES (21, 3, '删除', '3', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2024-06-04 08:38:48', '', NULL, '删除操作');
    247. 

  247. INSERT INTO `sys_dict_data` VALUES (22, 4, '授权', '4', 'sys_oper_type', '', 'primary', 'N', '0', 'admin', '2024-06-04 08:38:48', '', NULL, '授权操作');
    248. 

  248. INSERT INTO `sys_dict_data` VALUES (23, 5, '导出', '5', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2024-06-04 08:38:48', '', NULL, '导出操作');
    249. 

  249. INSERT INTO `sys_dict_data` VALUES (24, 6, '导入', '6', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2024-06-04 08:38:48', '', NULL, '导入操作');
    250. 

  250. INSERT INTO `sys_dict_data` VALUES (25, 7, '强退', '7', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2024-06-04 08:38:48', '', NULL, '强退操作');
    251. 

  251. INSERT INTO `sys_dict_data` VALUES (26, 8, '生成代码', '8', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2024-06-04 08:38:48', '', NULL, '生成操作');
    252. 

  252. INSERT INTO `sys_dict_data` VALUES (27, 9, '清空数据', '9', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2024-06-04 08:38:48', '', NULL, '清空操作');
    253. 

  253. INSERT INTO `sys_dict_data` VALUES (28, 1, '成功', '0', 'sys_common_status', '', 'primary', 'N', '0', 'admin', '2024-06-04 08:38:48', '', NULL, '正常状态');
    254. 

  254. INSERT INTO `sys_dict_data` VALUES (29, 2, '失败', '1', 'sys_common_status', '', 'danger', 'N', '0', 'admin', '2024-06-04 08:38:48', '', NULL, '停用状态');
    255. 

  255. 

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

  257. -- Table structure for sys_dict_type
    258. 

  258. -- ----------------------------
    259. 

  259. DROP TABLE IF EXISTS `sys_dict_type`;
    260. 

  260. CREATE TABLE `sys_dict_type`  (
    261. 

  261.                                   `dict_id` bigint NOT NULL AUTO_INCREMENT COMMENT '字典主键',
    262. 

  262.                                   `dict_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '字典名称',
    263. 

  263.                                   `dict_type` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '字典类型',
    264. 

  264.                                   `status` char(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '0' COMMENT '状态（0正常 1停用）',
    265. 

  265.                                   `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '创建者',
    266. 

  266.                                   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    267. 

  267.                                   `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '更新者',
    268. 

  268.                                   `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
    269. 

  269.                                   `remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '备注',
    270. 

  270.                                   PRIMARY KEY (`dict_id`) USING BTREE,
    271. 

  271.                                   UNIQUE INDEX `dict_type`(`dict_type` ASC) USING BTREE
    272. 

  272. ) ENGINE = InnoDB AUTO_INCREMENT = 100 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '字典类型表' ROW_FORMAT = Dynamic;
    273. 

  273. 

  274. -- ----------------------------
    275. 

  275. -- Records of sys_dict_type
    276. 

  276. -- ----------------------------
    277. 

  277. INSERT INTO `sys_dict_type` VALUES (1, '用户性别', 'sys_user_sex', '0', 'admin', '2024-06-04 08:38:47', '', NULL, '用户性别列表');
    278. 

  278. INSERT INTO `sys_dict_type` VALUES (2, '菜单状态', 'sys_show_hide', '0', 'admin', '2024-06-04 08:38:47', '', NULL, '菜单状态列表');
    279. 

  279. INSERT INTO `sys_dict_type` VALUES (3, '系统开关', 'sys_normal_disable', '0', 'admin', '2024-06-04 08:38:47', '', NULL, '系统开关列表');
    280. 

  280. INSERT INTO `sys_dict_type` VALUES (4, '任务状态', 'sys_job_status', '0', 'admin', '2024-06-04 08:38:47', '', NULL, '任务状态列表');
    281. 

  281. INSERT INTO `sys_dict_type` VALUES (5, '任务分组', 'sys_job_group', '0', 'admin', '2024-06-04 08:38:47', '', NULL, '任务分组列表');
    282. 

  282. INSERT INTO `sys_dict_type` VALUES (6, '系统是否', 'sys_yes_no', '0', 'admin', '2024-06-04 08:38:47', '', NULL, '系统是否列表');
    283. 

  283. INSERT INTO `sys_dict_type` VALUES (7, '通知类型', 'sys_notice_type', '0', 'admin', '2024-06-04 08:38:47', '', NULL, '通知类型列表');
    284. 

  284. INSERT INTO `sys_dict_type` VALUES (8, '通知状态', 'sys_notice_status', '0', 'admin', '2024-06-04 08:38:47', '', NULL, '通知状态列表');
    285. 

  285. INSERT INTO `sys_dict_type` VALUES (9, '操作类型', 'sys_oper_type', '0', 'admin', '2024-06-04 08:38:47', '', NULL, '操作类型列表');
    286. 

  286. INSERT INTO `sys_dict_type` VALUES (10, '系统状态', 'sys_common_status', '0', 'admin', '2024-06-04 08:38:48', '', NULL, '登录状态列表');
    287. 

  287. 

  288. -- ----------------------------
    289. 

  289. -- Table structure for sys_job
    290. 

  290. -- ----------------------------
    291. 

  291. DROP TABLE IF EXISTS `sys_job`;
    292. 

  292. CREATE TABLE `sys_job`  (
    293. 

  293.                             `job_id` bigint NOT NULL AUTO_INCREMENT COMMENT '任务ID',
    294. 

  294.                             `job_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '任务名称',
    295. 

  295.                             `job_group` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'DEFAULT' COMMENT '任务组名',
    296. 

  296.                             `invoke_target` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '调用目标字符串',
    297. 

  297.                             `cron_expression` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT 'cron执行表达式',
    298. 

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

  299.                             `concurrent` char(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '1' COMMENT '是否并发执行（0允许 1禁止）',
    300. 

  300.                             `status` char(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '0' COMMENT '状态（0正常 1暂停）',
    301. 

  301.                             `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '创建者',
    302. 

  302.                             `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    303. 

  303.                             `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '更新者',
    304. 

  304.                             `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
    305. 

  305.                             `remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '备注信息',
    306. 

  306.                             PRIMARY KEY (`job_id`, `job_name`, `job_group`) USING BTREE
    307. 

  307. ) ENGINE = InnoDB AUTO_INCREMENT = 100 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '定时任务调度表' ROW_FORMAT = Dynamic;
    308. 

  308. 

  309. -- ----------------------------
    310. 

  310. -- Records of sys_job
    311. 

  311. -- ----------------------------
    312. 

  312. INSERT INTO `sys_job` VALUES (1, '系统默认（无参）', 'DEFAULT', 'ryTask.ryNoParams', '0/10 * * * * ?', '3', '1', '1', 'admin', '2024-06-04 08:38:48', '', NULL, '');
    313. 

  313. INSERT INTO `sys_job` VALUES (2, '系统默认（有参）', 'DEFAULT', 'ryTask.ryParams(\'ry\')', '0/15 * * * * ?', '3', '1', '1', 'admin', '2024-06-04 08:38:48', '', NULL, '');
    314. 

  314. INSERT INTO `sys_job` VALUES (3, '系统默认（多参）', 'DEFAULT', 'ryTask.ryMultipleParams(\'ry\', true, 2000L, 316.50D, 100)', '0/20 * * * * ?', '3', '1', '1', 'admin', '2024-06-04 08:38:49', '', NULL, '');
    315. 

  315. 

  316. -- ----------------------------
    317. 

  317. -- Table structure for sys_job_log
    318. 

  318. -- ----------------------------
    319. 

  319. DROP TABLE IF EXISTS `sys_job_log`;
    320. 

  320. CREATE TABLE `sys_job_log`  (
    321. 

  321.                                 `job_log_id` bigint NOT NULL AUTO_INCREMENT COMMENT '任务日志ID',
    322. 

  322.                                 `job_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '任务名称',
    323. 

  323.                                 `job_group` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '任务组名',
    324. 

  324.                                 `invoke_target` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '调用目标字符串',
    325. 

  325.                                 `job_message` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '日志信息',
    326. 

  326.                                 `status` char(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '0' COMMENT '执行状态（0正常 1失败）',
    327. 

  327.                                 `exception_info` varchar(2000) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '异常信息',
    328. 

  328.                                 `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    329. 

  329.                                 PRIMARY KEY (`job_log_id`) USING BTREE
    330. 

  330. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '定时任务调度日志表' ROW_FORMAT = Dynamic;
    331. 

  331. 

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

  333. -- Records of sys_job_log
    334. 

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

  335. 

  336. -- ----------------------------
    337. 

  337. -- Table structure for sys_logininfor
    338. 

  338. -- ----------------------------
    339. 

  339. DROP TABLE IF EXISTS `sys_logininfor`;
    340. 

  340. CREATE TABLE `sys_logininfor`  (
    341. 

  341.                                    `info_id` bigint NOT NULL AUTO_INCREMENT COMMENT '访问ID',
    342. 

  342.                                    `user_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '用户账号',
    343. 

  343.                                    `ipaddr` varchar(128) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '登录IP地址',
    344. 

  344.                                    `login_location` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '登录地点',
    345. 

  345.                                    `browser` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '浏览器类型',
    346. 

  346.                                    `os` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '操作系统',
    347. 

  347.                                    `status` char(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '0' COMMENT '登录状态（0成功 1失败）',
    348. 

  348.                                    `msg` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '提示消息',
    349. 

  349.                                    `login_time` datetime NULL DEFAULT NULL COMMENT '访问时间',
    350. 

  350.                                    PRIMARY KEY (`info_id`) USING BTREE,
    351. 

  351.                                    INDEX `idx_sys_logininfor_s`(`status` ASC) USING BTREE,
    352. 

  352.                                    INDEX `idx_sys_logininfor_lt`(`login_time` ASC) USING BTREE
    353. 

  353. ) ENGINE = InnoDB AUTO_INCREMENT = 104 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '系统访问记录' ROW_FORMAT = Dynamic;
    354. 

  354. 

  355. -- ----------------------------
    356. 

  356. -- Records of sys_logininfor
    357. 

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

  358. INSERT INTO `sys_logininfor` VALUES (100, 'admin', '127.0.0.1', '内网IP', 'Chrome 12', 'Windows 10', '0', '登录成功', '2024-06-04 08:39:40');
    359. 

  359. INSERT INTO `sys_logininfor` VALUES (101, 'admin', '127.0.0.1', '内网IP', 'Chrome 12', 'Windows 10', '0', '登录成功', '2024-06-04 10:20:46');
    360. 

  360. INSERT INTO `sys_logininfor` VALUES (102, 'admin', '127.0.0.1', '内网IP', 'Chrome 12', 'Windows 10', '0', '登录成功', '2024-06-04 11:35:25');
    361. 

  361. INSERT INTO `sys_logininfor` VALUES (103, 'admin', '127.0.0.1', '内网IP', 'Chrome 12', 'Windows 10', '0', '登录成功', '2024-06-05 08:15:13');
    362. 

  362. INSERT INTO `sys_logininfor` VALUES (104, 'admin', '127.0.0.1', '内网IP', 'Chrome 12', 'Windows 10', '0', '登录成功', '2024-06-05 10:28:31');
    363. 

  363. INSERT INTO `sys_logininfor` VALUES (105, 'admin', '127.0.0.1', '内网IP', 'Chrome 12', 'Windows 10', '0', '登录成功', '2024-06-05 12:22:25');
    364. 

  364. 

  365. -- ----------------------------
    366. 

  366. -- Table structure for sys_menu
    367. 

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

  368. DROP TABLE IF EXISTS `sys_menu`;
    369. 

  369. CREATE TABLE `sys_menu`  (
    370. 

  370.                              `menu_id` bigint NOT NULL AUTO_INCREMENT COMMENT '菜单ID',
    371. 

  371.                              `menu_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '菜单名称',
    372. 

  372.                              `parent_id` bigint NULL DEFAULT 0 COMMENT '父菜单ID',
    373. 

  373.                              `order_num` int NULL DEFAULT 0 COMMENT '显示顺序',
    374. 

  374.                              `path` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '路由地址',
    375. 

  375.                              `component` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '组件路径',
    376. 

  376.                              `query` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '路由参数',
    377. 

  377.                              `is_frame` int NULL DEFAULT 1 COMMENT '是否为外链（0是 1否）',
    378. 

  378.                              `is_cache` int NULL DEFAULT 0 COMMENT '是否缓存（0缓存 1不缓存）',
    379. 

  379.                              `menu_type` char(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '菜单类型（M目录 C菜单 F按钮）',
    380. 

  380.                              `visible` char(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '0' COMMENT '菜单状态（0显示 1隐藏）',
    381. 

  381.                              `status` char(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '0' COMMENT '菜单状态（0正常 1停用）',
    382. 

  382.                              `perms` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '权限标识',
    383. 

  383.                              `icon` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '#' COMMENT '菜单图标',
    384. 

  384.                              `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '创建者',
    385. 

  385.                              `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    386. 

  386.                              `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '更新者',
    387. 

  387.                              `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
    388. 

  388.                              `remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '备注',
    389. 

  389.                              PRIMARY KEY (`menu_id`) USING BTREE
    390. 

  390. ) ENGINE = InnoDB AUTO_INCREMENT = 2020 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '菜单权限表' ROW_FORMAT = Dynamic;
    391. 

  391. 

  392. -- ----------------------------
    393. 

  393. -- Records of sys_menu
    394. 

  394. -- ----------------------------
    395. 

  395. INSERT INTO `sys_menu` VALUES (1, '系统管理', 0, 4, 'system', NULL, '', 1, 0, 'M', '0', '0', '', 'system', 'admin', '2024-06-04 08:38:43', 'admin', '2024-06-04 10:27:35', '系统管理目录');
    396. 

  396. INSERT INTO `sys_menu` VALUES (2, '系统监控', 0, 2, 'monitor', NULL, '', 1, 0, 'M', '0', '0', '', 'monitor', 'admin', '2024-06-04 08:38:44', '', NULL, '系统监控目录');
    397. 

  397. INSERT INTO `sys_menu` VALUES (3, '系统工具', 0, 3, 'tool', NULL, '', 1, 0, 'M', '0', '0', '', 'tool', 'admin', '2024-06-04 08:38:44', '', NULL, '系统工具目录');
    398. 

  398. INSERT INTO `sys_menu` VALUES (100, '用户管理', 1, 1, 'user', 'system/user/index', '', 1, 0, 'C', '0', '0', 'system:user:list', 'user', 'admin', '2024-06-04 08:38:44', '', NULL, '用户管理菜单');
    399. 

  399. INSERT INTO `sys_menu` VALUES (101, '角色管理', 1, 2, 'role', 'system/role/index', '', 1, 0, 'C', '0', '0', 'system:role:list', 'peoples', 'admin', '2024-06-04 08:38:44', '', NULL, '角色管理菜单');
    400. 

  400. INSERT INTO `sys_menu` VALUES (102, '菜单管理', 1, 3, 'menu', 'system/menu/index', '', 1, 0, 'C', '0', '0', 'system:menu:list', 'tree-table', 'admin', '2024-06-04 08:38:44', '', NULL, '菜单管理菜单');
    401. 

  401. INSERT INTO `sys_menu` VALUES (103, '部门管理', 1, 4, 'dept', 'system/dept/index', '', 1, 0, 'C', '0', '0', 'system:dept:list', 'tree', 'admin', '2024-06-04 08:38:44', '', NULL, '部门管理菜单');
    402. 

  402. INSERT INTO `sys_menu` VALUES (104, '岗位管理', 1, 5, 'post', 'system/post/index', '', 1, 0, 'C', '0', '0', 'system:post:list', 'post', 'admin', '2024-06-04 08:38:44', '', NULL, '岗位管理菜单');
    403. 

  403. INSERT INTO `sys_menu` VALUES (105, '字典管理', 1, 6, 'dict', 'system/dict/index', '', 1, 0, 'C', '0', '0', 'system:dict:list', 'dict', 'admin', '2024-06-04 08:38:44', '', NULL, '字典管理菜单');
    404. 

  404. INSERT INTO `sys_menu` VALUES (106, '参数设置', 1, 7, 'config', 'system/config/index', '', 1, 0, 'C', '0', '0', 'system:config:list', 'edit', 'admin', '2024-06-04 08:38:44', '', NULL, '参数设置菜单');
    405. 

  405. INSERT INTO `sys_menu` VALUES (107, '通知公告', 1, 8, 'notice', 'system/notice/index', '', 1, 0, 'C', '0', '0', 'system:notice:list', 'message', 'admin', '2024-06-04 08:38:44', '', NULL, '通知公告菜单');
    406. 

  406. INSERT INTO `sys_menu` VALUES (108, '日志管理', 1, 9, 'log', '', '', 1, 0, 'M', '0', '0', '', 'log', 'admin', '2024-06-04 08:38:44', '', NULL, '日志管理菜单');
    407. 

  407. INSERT INTO `sys_menu` VALUES (109, '在线用户', 2, 1, 'online', 'monitor/online/index', '', 1, 0, 'C', '0', '0', 'monitor:online:list', 'online', 'admin', '2024-06-04 08:38:44', '', NULL, '在线用户菜单');
    408. 

  408. INSERT INTO `sys_menu` VALUES (110, '定时任务', 2, 2, 'job', 'monitor/job/index', '', 1, 0, 'C', '0', '0', 'monitor:job:list', 'job', 'admin', '2024-06-04 08:38:44', '', NULL, '定时任务菜单');
    409. 

  409. INSERT INTO `sys_menu` VALUES (111, '数据监控', 2, 3, 'druid', 'monitor/druid/index', '', 1, 0, 'C', '0', '0', 'monitor:druid:list', 'druid', 'admin', '2024-06-04 08:38:44', '', NULL, '数据监控菜单');
    410. 

  410. INSERT INTO `sys_menu` VALUES (112, '服务监控', 2, 4, 'server', 'monitor/server/index', '', 1, 0, 'C', '0', '0', 'monitor:server:list', 'server', 'admin', '2024-06-04 08:38:44', '', NULL, '服务监控菜单');
    411. 

  411. INSERT INTO `sys_menu` VALUES (113, '缓存监控', 2, 5, 'cache', 'monitor/cache/index', '', 1, 0, 'C', '0', '0', 'monitor:cache:list', 'redis', 'admin', '2024-06-04 08:38:44', '', NULL, '缓存监控菜单');
    412. 

  412. INSERT INTO `sys_menu` VALUES (114, '缓存列表', 2, 6, 'cacheList', 'monitor/cache/list', '', 1, 0, 'C', '0', '0', 'monitor:cache:list', 'redis-list', 'admin', '2024-06-04 08:38:44', '', NULL, '缓存列表菜单');
    413. 

  413. INSERT INTO `sys_menu` VALUES (115, '表单构建', 3, 1, 'build', 'tool/build/index', '', 1, 0, 'C', '0', '0', 'tool:build:list', 'build', 'admin', '2024-06-04 08:38:44', '', NULL, '表单构建菜单');
    414. 

  414. INSERT INTO `sys_menu` VALUES (116, '代码生成', 3, 2, 'gen', 'tool/gen/index', '', 1, 0, 'C', '0', '0', 'tool:gen:list', 'code', 'admin', '2024-06-04 08:38:44', '', NULL, '代码生成菜单');
    415. 

  415. INSERT INTO `sys_menu` VALUES (117, '系统接口', 3, 3, 'swagger', 'tool/swagger/index', '', 1, 0, 'C', '0', '0', 'tool:swagger:list', 'swagger', 'admin', '2024-06-04 08:38:44', '', NULL, '系统接口菜单');
    416. 

  416. INSERT INTO `sys_menu` VALUES (500, '操作日志', 108, 1, 'operlog', 'monitor/operlog/index', '', 1, 0, 'C', '0', '0', 'monitor:operlog:list', 'form', 'admin', '2024-06-04 08:38:44', '', NULL, '操作日志菜单');
    417. 

  417. INSERT INTO `sys_menu` VALUES (501, '登录日志', 108, 2, 'logininfor', 'monitor/logininfor/index', '', 1, 0, 'C', '0', '0', 'monitor:logininfor:list', 'logininfor', 'admin', '2024-06-04 08:38:44', '', NULL, '登录日志菜单');
    418. 

  418. INSERT INTO `sys_menu` VALUES (1000, '用户查询', 100, 1, '', '', '', 1, 0, 'F', '0', '0', 'system:user:query', '#', 'admin', '2024-06-04 08:38:44', '', NULL, '');
    419. 

  419. INSERT INTO `sys_menu` VALUES (1001, '用户新增', 100, 2, '', '', '', 1, 0, 'F', '0', '0', 'system:user:add', '#', 'admin', '2024-06-04 08:38:44', '', NULL, '');
    420. 

  420. INSERT INTO `sys_menu` VALUES (1002, '用户修改', 100, 3, '', '', '', 1, 0, 'F', '0', '0', 'system:user:edit', '#', 'admin', '2024-06-04 08:38:44', '', NULL, '');
    421. 

  421. INSERT INTO `sys_menu` VALUES (1003, '用户删除', 100, 4, '', '', '', 1, 0, 'F', '0', '0', 'system:user:remove', '#', 'admin', '2024-06-04 08:38:44', '', NULL, '');
    422. 

  422. INSERT INTO `sys_menu` VALUES (1004, '用户导出', 100, 5, '', '', '', 1, 0, 'F', '0', '0', 'system:user:export', '#', 'admin', '2024-06-04 08:38:44', '', NULL, '');
    423. 

  423. INSERT INTO `sys_menu` VALUES (1005, '用户导入', 100, 6, '', '', '', 1, 0, 'F', '0', '0', 'system:user:import', '#', 'admin', '2024-06-04 08:38:44', '', NULL, '');
    424. 

  424. INSERT INTO `sys_menu` VALUES (1006, '重置密码', 100, 7, '', '', '', 1, 0, 'F', '0', '0', 'system:user:resetPwd', '#', 'admin', '2024-06-04 08:38:44', '', NULL, '');
    425. 

  425. INSERT INTO `sys_menu` VALUES (1007, '角色查询', 101, 1, '', '', '', 1, 0, 'F', '0', '0', 'system:role:query', '#', 'admin', '2024-06-04 08:38:44', '', NULL, '');
    426. 

  426. INSERT INTO `sys_menu` VALUES (1008, '角色新增', 101, 2, '', '', '', 1, 0, 'F', '0', '0', 'system:role:add', '#', 'admin', '2024-06-04 08:38:44', '', NULL, '');
    427. 

  427. INSERT INTO `sys_menu` VALUES (1009, '角色修改', 101, 3, '', '', '', 1, 0, 'F', '0', '0', 'system:role:edit', '#', 'admin', '2024-06-04 08:38:44', '', NULL, '');
    428. 

  428. INSERT INTO `sys_menu` VALUES (1010, '角色删除', 101, 4, '', '', '', 1, 0, 'F', '0', '0', 'system:role:remove', '#', 'admin', '2024-06-04 08:38:44', '', NULL, '');
    429. 

  429. INSERT INTO `sys_menu` VALUES (1011, '角色导出', 101, 5, '', '', '', 1, 0, 'F', '0', '0', 'system:role:export', '#', 'admin', '2024-06-04 08:38:44', '', NULL, '');
    430. 

  430. INSERT INTO `sys_menu` VALUES (1012, '菜单查询', 102, 1, '', '', '', 1, 0, 'F', '0', '0', 'system:menu:query', '#', 'admin', '2024-06-04 08:38:44', '', NULL, '');
    431. 

  431. INSERT INTO `sys_menu` VALUES (1013, '菜单新增', 102, 2, '', '', '', 1, 0, 'F', '0', '0', 'system:menu:add', '#', 'admin', '2024-06-04 08:38:44', '', NULL, '');
    432. 

  432. INSERT INTO `sys_menu` VALUES (1014, '菜单修改', 102, 3, '', '', '', 1, 0, 'F', '0', '0', 'system:menu:edit', '#', 'admin', '2024-06-04 08:38:44', '', NULL, '');
    433. 

  433. INSERT INTO `sys_menu` VALUES (1015, '菜单删除', 102, 4, '', '', '', 1, 0, 'F', '0', '0', 'system:menu:remove', '#', 'admin', '2024-06-04 08:38:44', '', NULL, '');
    434. 

  434. INSERT INTO `sys_menu` VALUES (1016, '部门查询', 103, 1, '', '', '', 1, 0, 'F', '0', '0', 'system:dept:query', '#', 'admin', '2024-06-04 08:38:44', '', NULL, '');
    435. 

  435. INSERT INTO `sys_menu` VALUES (1017, '部门新增', 103, 2, '', '', '', 1, 0, 'F', '0', '0', 'system:dept:add', '#', 'admin', '2024-06-04 08:38:44', '', NULL, '');
    436. 

  436. INSERT INTO `sys_menu` VALUES (1018, '部门修改', 103, 3, '', '', '', 1, 0, 'F', '0', '0', 'system:dept:edit', '#', 'admin', '2024-06-04 08:38:44', '', NULL, '');
    437. 

  437. INSERT INTO `sys_menu` VALUES (1019, '部门删除', 103, 4, '', '', '', 1, 0, 'F', '0', '0', 'system:dept:remove', '#', 'admin', '2024-06-04 08:38:44', '', NULL, '');
    438. 

  438. INSERT INTO `sys_menu` VALUES (1020, '岗位查询', 104, 1, '', '', '', 1, 0, 'F', '0', '0', 'system:post:query', '#', 'admin', '2024-06-04 08:38:44', '', NULL, '');
    439. 

  439. INSERT INTO `sys_menu` VALUES (1021, '岗位新增', 104, 2, '', '', '', 1, 0, 'F', '0', '0', 'system:post:add', '#', 'admin', '2024-06-04 08:38:44', '', NULL, '');
    440. 

  440. INSERT INTO `sys_menu` VALUES (1022, '岗位修改', 104, 3, '', '', '', 1, 0, 'F', '0', '0', 'system:post:edit', '#', 'admin', '2024-06-04 08:38:44', '', NULL, '');
    441. 

  441. INSERT INTO `sys_menu` VALUES (1023, '岗位删除', 104, 4, '', '', '', 1, 0, 'F', '0', '0', 'system:post:remove', '#', 'admin', '2024-06-04 08:38:44', '', NULL, '');
    442. 

  442. INSERT INTO `sys_menu` VALUES (1024, '岗位导出', 104, 5, '', '', '', 1, 0, 'F', '0', '0', 'system:post:export', '#', 'admin', '2024-06-04 08:38:44', '', NULL, '');
    443. 

  443. INSERT INTO `sys_menu` VALUES (1025, '字典查询', 105, 1, '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:query', '#', 'admin', '2024-06-04 08:38:44', '', NULL, '');
    444. 

  444. INSERT INTO `sys_menu` VALUES (1026, '字典新增', 105, 2, '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:add', '#', 'admin', '2024-06-04 08:38:44', '', NULL, '');
    445. 

  445. INSERT INTO `sys_menu` VALUES (1027, '字典修改', 105, 3, '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:edit', '#', 'admin', '2024-06-04 08:38:44', '', NULL, '');
    446. 

  446. INSERT INTO `sys_menu` VALUES (1028, '字典删除', 105, 4, '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:remove', '#', 'admin', '2024-06-04 08:38:44', '', NULL, '');
    447. 

  447. INSERT INTO `sys_menu` VALUES (1029, '字典导出', 105, 5, '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:export', '#', 'admin', '2024-06-04 08:38:45', '', NULL, '');
    448. 

  448. INSERT INTO `sys_menu` VALUES (1030, '参数查询', 106, 1, '#', '', '', 1, 0, 'F', '0', '0', 'system:config:query', '#', 'admin', '2024-06-04 08:38:45', '', NULL, '');
    449. 

  449. INSERT INTO `sys_menu` VALUES (1031, '参数新增', 106, 2, '#', '', '', 1, 0, 'F', '0', '0', 'system:config:add', '#', 'admin', '2024-06-04 08:38:45', '', NULL, '');
    450. 

  450. INSERT INTO `sys_menu` VALUES (1032, '参数修改', 106, 3, '#', '', '', 1, 0, 'F', '0', '0', 'system:config:edit', '#', 'admin', '2024-06-04 08:38:45', '', NULL, '');
    451. 

  451. INSERT INTO `sys_menu` VALUES (1033, '参数删除', 106, 4, '#', '', '', 1, 0, 'F', '0', '0', 'system:config:remove', '#', 'admin', '2024-06-04 08:38:45', '', NULL, '');
    452. 

  452. INSERT INTO `sys_menu` VALUES (1034, '参数导出', 106, 5, '#', '', '', 1, 0, 'F', '0', '0', 'system:config:export', '#', 'admin', '2024-06-04 08:38:45', '', NULL, '');
    453. 

  453. INSERT INTO `sys_menu` VALUES (1035, '公告查询', 107, 1, '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:query', '#', 'admin', '2024-06-04 08:38:45', '', NULL, '');
    454. 

  454. INSERT INTO `sys_menu` VALUES (1036, '公告新增', 107, 2, '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:add', '#', 'admin', '2024-06-04 08:38:45', '', NULL, '');
    455. 

  455. INSERT INTO `sys_menu` VALUES (1037, '公告修改', 107, 3, '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:edit', '#', 'admin', '2024-06-04 08:38:45', '', NULL, '');
    456. 

  456. INSERT INTO `sys_menu` VALUES (1038, '公告删除', 107, 4, '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:remove', '#', 'admin', '2024-06-04 08:38:45', '', NULL, '');
    457. 

  457. INSERT INTO `sys_menu` VALUES (1039, '操作查询', 500, 1, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:operlog:query', '#', 'admin', '2024-06-04 08:38:45', '', NULL, '');
    458. 

  458. INSERT INTO `sys_menu` VALUES (1040, '操作删除', 500, 2, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:operlog:remove', '#', 'admin', '2024-06-04 08:38:45', '', NULL, '');
    459. 

  459. INSERT INTO `sys_menu` VALUES (1041, '日志导出', 500, 3, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:operlog:export', '#', 'admin', '2024-06-04 08:38:45', '', NULL, '');
    460. 

  460. INSERT INTO `sys_menu` VALUES (1042, '登录查询', 501, 1, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:query', '#', 'admin', '2024-06-04 08:38:45', '', NULL, '');
    461. 

  461. INSERT INTO `sys_menu` VALUES (1043, '登录删除', 501, 2, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:remove', '#', 'admin', '2024-06-04 08:38:45', '', NULL, '');
    462. 

  462. INSERT INTO `sys_menu` VALUES (1044, '日志导出', 501, 3, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:export', '#', 'admin', '2024-06-04 08:38:45', '', NULL, '');
    463. 

  463. INSERT INTO `sys_menu` VALUES (1045, '账户解锁', 501, 4, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:unlock', '#', 'admin', '2024-06-04 08:38:45', '', NULL, '');
    464. 

  464. INSERT INTO `sys_menu` VALUES (1046, '在线查询', 109, 1, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:online:query', '#', 'admin', '2024-06-04 08:38:45', '', NULL, '');
    465. 

  465. INSERT INTO `sys_menu` VALUES (1047, '批量强退', 109, 2, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:online:batchLogout', '#', 'admin', '2024-06-04 08:38:45', '', NULL, '');
    466. 

  466. INSERT INTO `sys_menu` VALUES (1048, '单条强退', 109, 3, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:online:forceLogout', '#', 'admin', '2024-06-04 08:38:45', '', NULL, '');
    467. 

  467. INSERT INTO `sys_menu` VALUES (1049, '任务查询', 110, 1, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:query', '#', 'admin', '2024-06-04 08:38:45', '', NULL, '');
    468. 

  468. INSERT INTO `sys_menu` VALUES (1050, '任务新增', 110, 2, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:add', '#', 'admin', '2024-06-04 08:38:45', '', NULL, '');
    469. 

  469. INSERT INTO `sys_menu` VALUES (1051, '任务修改', 110, 3, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:edit', '#', 'admin', '2024-06-04 08:38:45', '', NULL, '');
    470. 

  470. INSERT INTO `sys_menu` VALUES (1052, '任务删除', 110, 4, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:remove', '#', 'admin', '2024-06-04 08:38:45', '', NULL, '');
    471. 

  471. INSERT INTO `sys_menu` VALUES (1053, '状态修改', 110, 5, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:changeStatus', '#', 'admin', '2024-06-04 08:38:45', '', NULL, '');
    472. 

  472. INSERT INTO `sys_menu` VALUES (1054, '任务导出', 110, 6, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:export', '#', 'admin', '2024-06-04 08:38:45', '', NULL, '');
    473. 

  473. INSERT INTO `sys_menu` VALUES (1055, '生成查询', 116, 1, '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:query', '#', 'admin', '2024-06-04 08:38:45', '', NULL, '');
    474. 

  474. INSERT INTO `sys_menu` VALUES (1056, '生成修改', 116, 2, '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:edit', '#', 'admin', '2024-06-04 08:38:45', '', NULL, '');
    475. 

  475. INSERT INTO `sys_menu` VALUES (1057, '生成删除', 116, 3, '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:remove', '#', 'admin', '2024-06-04 08:38:45', '', NULL, '');
    476. 

  476. INSERT INTO `sys_menu` VALUES (1058, '导入代码', 116, 4, '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:import', '#', 'admin', '2024-06-04 08:38:45', '', NULL, '');
    477. 

  477. INSERT INTO `sys_menu` VALUES (1059, '预览代码', 116, 5, '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:preview', '#', 'admin', '2024-06-04 08:38:45', '', NULL, '');
    478. 

  478. INSERT INTO `sys_menu` VALUES (1060, '生成代码', 116, 6, '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:code', '#', 'admin', '2024-06-04 08:38:45', '', NULL, '');
    479. 

  479. INSERT INTO `sys_menu` VALUES (2000, '算法管理', 0, 0, 'algoManager', NULL, NULL, 1, 0, 'M', '0', '0', NULL, 'monitor', 'admin', '2024-06-04 10:26:36', '', NULL, '');
    480. 

  480. INSERT INTO `sys_menu` VALUES (2001, '算法配置', 0, 1, 'conf', NULL, NULL, 1, 0, 'M', '0', '0', NULL, 'redis-list', 'admin', '2024-06-04 10:28:10', '', NULL, '');
    481. 

  481. INSERT INTO `sys_menu` VALUES (2002, '数据处理', 2000, 1, 'algorithm', 'algoManager/algorithm/index', NULL, 1, 0, 'C', '0', '0', 'algoManager:algorithm:list', '#', 'admin', '2024-06-04 10:34:33', 'admin', '2024-06-05 08:19:26', '算法菜单');
    482. 

  482. INSERT INTO `sys_menu` VALUES (2003, '算法查询', 2002, 1, '#', '', NULL, 1, 0, 'F', '0', '0', 'algoManager:algorithm:query', '#', 'admin', '2024-06-04 10:34:33', '', NULL, '');
    483. 

  483. INSERT INTO `sys_menu` VALUES (2004, '算法新增', 2002, 2, '#', '', NULL, 1, 0, 'F', '0', '0', 'algoManager:algorithm:add', '#', 'admin', '2024-06-04 10:34:33', '', NULL, '');
    484. 

  484. INSERT INTO `sys_menu` VALUES (2005, '算法修改', 2002, 3, '#', '', NULL, 1, 0, 'F', '0', '0', 'algoManager:algorithm:edit', '#', 'admin', '2024-06-04 10:34:33', '', NULL, '');
    485. 

  485. INSERT INTO `sys_menu` VALUES (2006, '算法删除', 2002, 4, '#', '', NULL, 1, 0, 'F', '0', '0', 'algoManager:algorithm:remove', '#', 'admin', '2024-06-04 10:34:33', '', NULL, '');
    486. 

  486. INSERT INTO `sys_menu` VALUES (2007, '算法导出', 2002, 5, '#', '', NULL, 1, 0, 'F', '0', '0', 'algoManager:algorithm:export', '#', 'admin', '2024-06-04 10:34:34', '', NULL, '');
    487. 

  487. INSERT INTO `sys_menu` VALUES (2008, '算法输入输出字段', 2001, 2, 'field', 'conf/field/index', NULL, 1, 0, 'C', '0', '0', 'conf:field:list', '#', 'admin', '2024-06-04 11:40:27', 'admin', '2024-06-05 12:36:57', '算法输入输出字段菜单');
    488. 

  488. INSERT INTO `sys_menu` VALUES (2009, '算法输入输出字段查询', 2008, 1, '#', '', NULL, 1, 0, 'F', '0', '0', 'conf:field:query', '#', 'admin', '2024-06-04 11:40:27', '', NULL, '');
    489. 

  489. INSERT INTO `sys_menu` VALUES (2010, '算法输入输出字段新增', 2008, 2, '#', '', NULL, 1, 0, 'F', '0', '0', 'conf:field:add', '#', 'admin', '2024-06-04 11:40:27', '', NULL, '');
    490. 

  490. INSERT INTO `sys_menu` VALUES (2011, '算法输入输出字段修改', 2008, 3, '#', '', NULL, 1, 0, 'F', '0', '0', 'conf:field:edit', '#', 'admin', '2024-06-04 11:40:27', '', NULL, '');
    491. 

  491. INSERT INTO `sys_menu` VALUES (2012, '算法输入输出字段删除', 2008, 4, '#', '', NULL, 1, 0, 'F', '0', '0', 'conf:field:remove', '#', 'admin', '2024-06-04 11:40:27', '', NULL, '');
    492. 

  492. INSERT INTO `sys_menu` VALUES (2013, '算法输入输出字段导出', 2008, 5, '#', '', NULL, 1, 0, 'F', '0', '0', 'conf:field:export', '#', 'admin', '2024-06-04 11:40:27', '', NULL, '');
    493. 

  493. INSERT INTO `sys_menu` VALUES (2014, '算法子类型', 2001, 1, 'subType', 'conf/subType/index', NULL, 1, 0, 'C', '0', '0', 'conf:subType:list', '#', 'admin', '2024-06-04 11:41:03', '', NULL, '算法子类型菜单');
    494. 

  494. INSERT INTO `sys_menu` VALUES (2015, '算法子类型查询', 2014, 1, '#', '', NULL, 1, 0, 'F', '0', '0', 'conf:subType:query', '#', 'admin', '2024-06-04 11:41:03', '', NULL, '');
    495. 

  495. INSERT INTO `sys_menu` VALUES (2016, '算法子类型新增', 2014, 2, '#', '', NULL, 1, 0, 'F', '0', '0', 'conf:subType:add', '#', 'admin', '2024-06-04 11:41:03', '', NULL, '');
    496. 

  496. INSERT INTO `sys_menu` VALUES (2017, '算法子类型修改', 2014, 3, '#', '', NULL, 1, 0, 'F', '0', '0', 'conf:subType:edit', '#', 'admin', '2024-06-04 11:41:03', '', NULL, '');
    497. 

  497. INSERT INTO `sys_menu` VALUES (2018, '算法子类型删除', 2014, 4, '#', '', NULL, 1, 0, 'F', '0', '0', 'conf:subType:remove', '#', 'admin', '2024-06-04 11:41:03', '', NULL, '');
    498. 

  498. INSERT INTO `sys_menu` VALUES (2019, '算法子类型导出', 2014, 5, '#', '', NULL, 1, 0, 'F', '0', '0', 'conf:subType:export', '#', 'admin', '2024-06-04 11:41:03', '', NULL, '');
    499. 

  499. INSERT INTO `sys_menu` VALUES (2020, '数据管理', 2000, 4, 'file', 'algoManager/file/index', NULL, 1, 0, 'C', '0', '0', 'algoManager:file:list', '#', 'admin', '2024-06-05 09:02:16', 'admin', '2024-06-05 12:32:00', '数据管理菜单');
    500. 

  500. INSERT INTO `sys_menu` VALUES (2021, '数据管理查询', 2020, 1, '#', '', NULL, 1, 0, 'F', '0', '0', 'algoManager:file:query', '#', 'admin', '2024-06-05 09:02:17', '', NULL, '');
    501. 

  501. INSERT INTO `sys_menu` VALUES (2022, '数据管理新增', 2020, 2, '#', '', NULL, 1, 0, 'F', '0', '0', 'algoManager:file:add', '#', 'admin', '2024-06-05 09:02:17', '', NULL, '');
    502. 

  502. INSERT INTO `sys_menu` VALUES (2023, '数据管理修改', 2020, 3, '#', '', NULL, 1, 0, 'F', '0', '0', 'algoManager:file:edit', '#', 'admin', '2024-06-05 09:02:17', '', NULL, '');
    503. 

  503. INSERT INTO `sys_menu` VALUES (2024, '数据管理删除', 2020, 4, '#', '', NULL, 1, 0, 'F', '0', '0', 'algoManager:file:remove', '#', 'admin', '2024-06-05 09:02:17', '', NULL, '');
    504. 

  504. INSERT INTO `sys_menu` VALUES (2025, '数据管理导出', 2020, 5, '#', '', NULL, 1, 0, 'F', '0', '0', 'algoManager:file:export', '#', 'admin', '2024-06-05 09:02:17', '', NULL, '');
    505. 

  505. INSERT INTO `sys_menu` VALUES (2026, '特征提取', 2000, 2, 'algorithm2', 'algoManager/algorithm2/index', NULL, 1, 0, 'C', '0', '0', 'algoManager:algorithm2:list', '#', 'admin', '2024-06-05 12:31:24', 'admin', '2024-06-05 12:31:51', '特征提取菜单');
    506. 

  506. INSERT INTO `sys_menu` VALUES (2027, '特征提取查询', 2026, 1, '#', '', NULL, 1, 0, 'F', '0', '0', 'algoManager:algorithm2:query', '#', 'admin', '2024-06-05 12:31:24', '', NULL, '');
    507. 

  507. INSERT INTO `sys_menu` VALUES (2028, '特征提取新增', 2026, 2, '#', '', NULL, 1, 0, 'F', '0', '0', 'algoManager:algorithm2:add', '#', 'admin', '2024-06-05 12:31:24', '', NULL, '');
    508. 

  508. INSERT INTO `sys_menu` VALUES (2029, '特征提取修改', 2026, 3, '#', '', NULL, 1, 0, 'F', '0', '0', 'algoManager:algorithm2:edit', '#', 'admin', '2024-06-05 12:31:24', '', NULL, '');
    509. 

  509. INSERT INTO `sys_menu` VALUES (2030, '特征提取删除', 2026, 4, '#', '', NULL, 1, 0, 'F', '0', '0', 'algoManager:algorithm2:remove', '#', 'admin', '2024-06-05 12:31:24', '', NULL, '');
    510. 

  510. INSERT INTO `sys_menu` VALUES (2031, '特征提取导出', 2026, 5, '#', '', NULL, 1, 0, 'F', '0', '0', 'algoManager:algorithm2:export', '#', 'admin', '2024-06-05 12:31:24', '', NULL, '');
    511. 

  511. INSERT INTO `sys_menu` VALUES (2032, '故障预测', 2000, 3, 'algorithm3', 'algoManager/algorithm3/index', NULL, 1, 0, 'C', '0', '0', 'algoManager:algorithm3:list', '#', 'admin', '2024-06-05 12:35:06', 'admin', '2024-06-05 12:35:25', '故障预测菜单');
    512. 

  512. INSERT INTO `sys_menu` VALUES (2033, '故障预测查询', 2032, 1, '#', '', NULL, 1, 0, 'F', '0', '0', 'algoManager:algorithm3:query', '#', 'admin', '2024-06-05 12:35:06', '', NULL, '');
    513. 

  513. INSERT INTO `sys_menu` VALUES (2034, '故障预测新增', 2032, 2, '#', '', NULL, 1, 0, 'F', '0', '0', 'algoManager:algorithm3:add', '#', 'admin', '2024-06-05 12:35:06', '', NULL, '');
    514. 

  514. INSERT INTO `sys_menu` VALUES (2035, '故障预测修改', 2032, 3, '#', '', NULL, 1, 0, 'F', '0', '0', 'algoManager:algorithm3:edit', '#', 'admin', '2024-06-05 12:35:06', '', NULL, '');
    515. 

  515. INSERT INTO `sys_menu` VALUES (2036, '故障预测删除', 2032, 4, '#', '', NULL, 1, 0, 'F', '0', '0', 'algoManager:algorithm3:remove', '#', 'admin', '2024-06-05 12:35:06', '', NULL, '');
    516. 

  516. INSERT INTO `sys_menu` VALUES (2037, '故障预测导出', 2032, 5, '#', '', NULL, 1, 0, 'F', '0', '0', 'algoManager:algorithm3:export', '#', 'admin', '2024-06-05 12:35:06', '', NULL, '');
    517. 

  517. 

  518. -- ----------------------------
    519. 

  519. -- Table structure for sys_notice
    520. 

  520. -- ----------------------------
    521. 

  521. DROP TABLE IF EXISTS `sys_notice`;
    522. 

  522. CREATE TABLE `sys_notice`  (
    523. 

  523.                                `notice_id` int NOT NULL AUTO_INCREMENT COMMENT '公告ID',
    524. 

  524.                                `notice_title` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '公告标题',
    525. 

  525.                                `notice_type` char(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '公告类型（1通知 2公告）',
    526. 

  526.                                `notice_content` longblob NULL COMMENT '公告内容',
    527. 

  527.                                `status` char(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '0' COMMENT '公告状态（0正常 1关闭）',
    528. 

  528.                                `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '创建者',
    529. 

  529.                                `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    530. 

  530.                                `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '更新者',
    531. 

  531.                                `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
    532. 

  532.                                `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '备注',
    533. 

  533.                                PRIMARY KEY (`notice_id`) USING BTREE
    534. 

  534. ) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '通知公告表' ROW_FORMAT = Dynamic;
    535. 

  535. 

  536. -- ----------------------------
    537. 

  537. -- Records of sys_notice
    538. 

  538. -- ----------------------------
    539. 

  539. INSERT INTO `sys_notice` VALUES (1, '温馨提醒：2018-07-01 新版本发布啦', '2', 0xE696B0E78988E69CACE58685E5AEB9, '0', 'admin', '2024-06-04 08:38:49', '', NULL, '管理员');
    540. 

  540. INSERT INTO `sys_notice` VALUES (2, '维护通知：2018-07-01 系统凌晨维护', '1', 0xE7BBB4E68AA4E58685E5AEB9, '0', 'admin', '2024-06-04 08:38:49', '', NULL, '管理员');
    541. 

  541. 

  542. -- ----------------------------
    543. 

  543. -- Table structure for sys_oper_log
    544. 

  544. -- ----------------------------
    545. 

  545. DROP TABLE IF EXISTS `sys_oper_log`;
    546. 

  546. CREATE TABLE `sys_oper_log`  (
    547. 

  547.                                  `oper_id` bigint NOT NULL AUTO_INCREMENT COMMENT '日志主键',
    548. 

  548.                                  `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '模块标题',
    549. 

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

  550.                                  `method` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '方法名称',
    551. 

  551.                                  `request_method` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '请求方式',
    552. 

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

  553.                                  `oper_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '操作人员',
    554. 

  554.                                  `dept_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '部门名称',
    555. 

  555.                                  `oper_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '请求URL',
    556. 

  556.                                  `oper_ip` varchar(128) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '主机地址',
    557. 

  557.                                  `oper_location` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '操作地点',
    558. 

  558.                                  `oper_param` varchar(2000) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '请求参数',
    559. 

  559.                                  `json_result` varchar(2000) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '返回参数',
    560. 

  560.                                  `status` int NULL DEFAULT 0 COMMENT '操作状态（0正常 1异常）',
    561. 

  561.                                  `error_msg` varchar(2000) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '错误消息',
    562. 

  562.                                  `oper_time` datetime NULL DEFAULT NULL COMMENT '操作时间',
    563. 

  563.                                  `cost_time` bigint NULL DEFAULT 0 COMMENT '消耗时间',
    564. 

  564.                                  PRIMARY KEY (`oper_id`) USING BTREE,
    565. 

  565.                                  INDEX `idx_sys_oper_log_bt`(`business_type` ASC) USING BTREE,
    566. 

  566.                                  INDEX `idx_sys_oper_log_s`(`status` ASC) USING BTREE,
    567. 

  567.                                  INDEX `idx_sys_oper_log_ot`(`oper_time` ASC) USING BTREE
    568. 

  568. ) ENGINE = InnoDB AUTO_INCREMENT = 129 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '操作日志记录' ROW_FORMAT = Dynamic;
    569. 

  569. 

  570. -- ----------------------------
    571. 

  571. -- Records of sys_oper_log
    572. 

  572. -- ----------------------------
    573. 

  573. INSERT INTO `sys_oper_log` VALUES (100, '代码生成', 6, 'com.pdaaphm.generator.controller.GenController.importTableSave()', 'POST', 1, 'admin', NULL, '/tool/gen/importTable', '127.0.0.1', '内网IP', '{\"tables\":\"t_sub_algorithm,t_algorithm,t_algorithm_io_field,t_algorithm_sub_type,t_file\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-04 09:00:58', 12455);
    574. 

  574. INSERT INTO `sys_oper_log` VALUES (101, '代码生成', 6, 'com.pdaaphm.generator.controller.GenController.importTableSave()', 'POST', 1, 'admin', NULL, '/tool/gen/importTable', '127.0.0.1', '内网IP', '{\"tables\":\"t_sub_algorithm,t_algorithm,t_algorithm_io_field,t_algorithm_sub_type,t_file\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-04 09:01:01', 13293);
    575. 

  575. INSERT INTO `sys_oper_log` VALUES (102, '代码生成', 6, 'com.pdaaphm.generator.controller.GenController.importTableSave()', 'POST', 1, 'admin', NULL, '/tool/gen/importTable', '127.0.0.1', '内网IP', '{\"tables\":\"t_sub_algorithm,t_algorithm,t_algorithm_io_field,t_algorithm_sub_type,t_file\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-04 09:01:02', 12451);
    576. 

  576. INSERT INTO `sys_oper_log` VALUES (103, '代码生成', 6, 'com.pdaaphm.generator.controller.GenController.importTableSave()', 'POST', 1, 'admin', NULL, '/tool/gen/importTable', '127.0.0.1', '内网IP', '{\"tables\":\"t_sub_algorithm,t_algorithm,t_algorithm_io_field,t_algorithm_sub_type,t_file\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-04 09:01:05', 12109);
    577. 

  577. INSERT INTO `sys_oper_log` VALUES (104, '代码生成', 3, 'com.pdaaphm.generator.controller.GenController.remove()', 'DELETE', 1, 'admin', NULL, '/tool/gen/11,12,13,14,15,16,17,18,19,20', '127.0.0.1', '内网IP', '{}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-04 09:01:11', 645);
    578. 

  578. INSERT INTO `sys_oper_log` VALUES (105, '代码生成', 3, 'com.pdaaphm.generator.controller.GenController.remove()', 'DELETE', 1, 'admin', NULL, '/tool/gen/1,2,3,4,5,6,7,8,9,10', '127.0.0.1', '内网IP', '{}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-04 09:01:21', 753);
    579. 

  579. INSERT INTO `sys_oper_log` VALUES (106, '代码生成', 6, 'com.pdaaphm.generator.controller.GenController.importTableSave()', 'POST', 1, 'admin', NULL, '/tool/gen/importTable', '127.0.0.1', '内网IP', '{\"tables\":\"t_sub_algorithm,t_algorithm,t_algorithm_io_field,t_algorithm_sub_type,t_file\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-04 09:01:40', 13118);
    580. 

  580. INSERT INTO `sys_oper_log` VALUES (107, '代码生成', 6, 'com.pdaaphm.generator.controller.GenController.importTableSave()', 'POST', 1, 'admin', NULL, '/tool/gen/importTable', '127.0.0.1', '内网IP', '{\"tables\":\"t_sub_algorithm,t_algorithm,t_algorithm_io_field,t_algorithm_sub_type,t_file\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-04 09:01:57', 13077);
    581. 

  581. INSERT INTO `sys_oper_log` VALUES (108, '代码生成', 3, 'com.pdaaphm.generator.controller.GenController.remove()', 'DELETE', 1, 'admin', NULL, '/tool/gen/30,29,28,27,26', '127.0.0.1', '内网IP', '{}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-04 09:02:36', 738);
    582. 

  582. INSERT INTO `sys_oper_log` VALUES (109, '菜单管理', 1, 'com.pdaaphm.web.controller.system.SysMenuController.add()', 'POST', 1, 'admin', NULL, '/system/menu', '127.0.0.1', '内网IP', '{\"children\":[],\"createBy\":\"admin\",\"icon\":\"monitor\",\"isCache\":\"0\",\"isFrame\":\"1\",\"menuName\":\"算法管理\",\"menuType\":\"M\",\"orderNum\":0,\"params\":{},\"parentId\":0,\"path\":\"algoManager\",\"status\":\"0\",\"visible\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-04 10:26:37', 488);
    583. 

  583. INSERT INTO `sys_oper_log` VALUES (110, '菜单管理', 2, 'com.pdaaphm.web.controller.system.SysMenuController.edit()', 'PUT', 1, 'admin', NULL, '/system/menu', '127.0.0.1', '内网IP', '{\"children\":[],\"createTime\":\"2024-06-04 08:38:43\",\"icon\":\"system\",\"isCache\":\"0\",\"isFrame\":\"1\",\"menuId\":1,\"menuName\":\"系统管理\",\"menuType\":\"M\",\"orderNum\":2,\"params\":{},\"parentId\":0,\"path\":\"system\",\"perms\":\"\",\"query\":\"\",\"status\":\"0\",\"updateBy\":\"admin\",\"visible\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-04 10:27:27', 540);
    584. 

  584. INSERT INTO `sys_oper_log` VALUES (111, '菜单管理', 2, 'com.pdaaphm.web.controller.system.SysMenuController.edit()', 'PUT', 1, 'admin', NULL, '/system/menu', '127.0.0.1', '内网IP', '{\"children\":[],\"createTime\":\"2024-06-04 08:38:43\",\"icon\":\"system\",\"isCache\":\"0\",\"isFrame\":\"1\",\"menuId\":1,\"menuName\":\"系统管理\",\"menuType\":\"M\",\"orderNum\":3,\"params\":{},\"parentId\":0,\"path\":\"system\",\"perms\":\"\",\"query\":\"\",\"status\":\"0\",\"updateBy\":\"admin\",\"visible\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-04 10:27:31', 863);
    585. 

  585. INSERT INTO `sys_oper_log` VALUES (112, '菜单管理', 2, 'com.pdaaphm.web.controller.system.SysMenuController.edit()', 'PUT', 1, 'admin', NULL, '/system/menu', '127.0.0.1', '内网IP', '{\"children\":[],\"createTime\":\"2024-06-04 08:38:43\",\"icon\":\"system\",\"isCache\":\"0\",\"isFrame\":\"1\",\"menuId\":1,\"menuName\":\"系统管理\",\"menuType\":\"M\",\"orderNum\":4,\"params\":{},\"parentId\":0,\"path\":\"system\",\"perms\":\"\",\"query\":\"\",\"status\":\"0\",\"updateBy\":\"admin\",\"visible\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-04 10:27:35', 448);
    586. 

  586. INSERT INTO `sys_oper_log` VALUES (113, '菜单管理', 1, 'com.pdaaphm.web.controller.system.SysMenuController.add()', 'POST', 1, 'admin', NULL, '/system/menu', '127.0.0.1', '内网IP', '{\"children\":[],\"createBy\":\"admin\",\"icon\":\"redis-list\",\"isCache\":\"0\",\"isFrame\":\"1\",\"menuName\":\"算法配置\",\"menuType\":\"M\",\"orderNum\":1,\"params\":{},\"parentId\":0,\"path\":\"conf\",\"status\":\"0\",\"visible\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-04 10:28:10', 378);
    587. 

  587. INSERT INTO `sys_oper_log` VALUES (114, '代码生成', 2, 'com.pdaaphm.generator.controller.GenController.editSave()', 'PUT', 1, 'admin', NULL, '/tool/gen', '127.0.0.1', '内网IP', '{\"businessName\":\"algorithm\",\"className\":\"TAlgorithm\",\"columns\":[{\"capJavaField\":\"Id\",\"columnComment\":\"编号\",\"columnId\":201,\"columnName\":\"id\",\"columnType\":\"bigint\",\"createBy\":\"admin\",\"createTime\":\"2024-06-04 09:01:27\",\"dictType\":\"\",\"edit\":false,\"htmlType\":\"input\",\"increment\":true,\"insert\":true,\"isIncrement\":\"1\",\"isInsert\":\"1\",\"isPk\":\"1\",\"javaField\":\"id\",\"javaType\":\"Long\",\"list\":false,\"params\":{},\"pk\":true,\"query\":false,\"queryType\":\"EQ\",\"required\":false,\"sort\":1,\"superColumn\":false,\"tableId\":21,\"updateBy\":\"\",\"usableColumn\":false},{\"capJavaField\":\"Type\",\"columnComment\":\"算法类型\",\"columnId\":202,\"columnName\":\"type\",\"columnType\":\"varchar(10)\",\"createBy\":\"admin\",\"createTime\":\"2024-06-04 09:01:28\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"select\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"javaField\":\"type\",\"javaType\":\"String\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"EQ\",\"required\":false,\"sort\":2,\"superColumn\":false,\"tableId\":21,\"updateBy\":\"\",\"usableColumn\":false},{\"capJavaField\":\"SubTypeId\",\"columnComment\":\"子类型id\",\"columnId\":203,\"columnName\":\"sub_type_id\",\"columnType\":\"bigint\",\"createBy\":\"admin\",\"createTime\":\"2024-06-04 09:01:28\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"isRequired\":\"1\",\"javaField\":\"subTypeId\",\"javaType\":\"Long\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"EQ\",\"required\":true,\"sort\":3,\"superColumn\":false,\"tableId\":21,\"updateBy\":\"\",\"usableColumn\":false},{\"capJavaField\":\"Name\",\"columnComment\":\"名称\",\"columnId\":204,\"columnName\":\"name\",\"columnType\":\"varchar(200)\",\"createBy\":\"admin\",\"createTime\":\"2024-06-04 09:01:28\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"javaField\":\"name\",\"javaType\":\"String\",\"list\":true,\"params\":{},\"pk\":false,', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-04 10:31:26', 5637);
    588. 

  588. INSERT INTO `sys_oper_log` VALUES (115, '代码生成', 8, 'com.pdaaphm.generator.controller.GenController.batchGenCode()', 'GET', 1, 'admin', NULL, '/tool/gen/batchGenCode', '127.0.0.1', '内网IP', '{\"tables\":\"t_algorithm\"}', NULL, 0, NULL, '2024-06-04 10:32:09', 146);
    589. 

  589. INSERT INTO `sys_oper_log` VALUES (116, '代码生成', 8, 'com.pdaaphm.generator.controller.GenController.batchGenCode()', 'GET', 1, 'admin', NULL, '/tool/gen/batchGenCode', '127.0.0.1', '内网IP', '{\"tables\":\"t_algorithm\"}', NULL, 0, NULL, '2024-06-04 10:32:12', 160);
    590. 

  590. INSERT INTO `sys_oper_log` VALUES (117, '代码生成', 2, 'com.pdaaphm.generator.controller.GenController.editSave()', 'PUT', 1, 'admin', NULL, '/tool/gen', '127.0.0.1', '内网IP', '{\"businessName\":\"subType\",\"className\":\"TAlgorithmSubType\",\"columns\":[{\"capJavaField\":\"Id\",\"columnComment\":\"编号\",\"columnId\":223,\"columnName\":\"id\",\"columnType\":\"bigint\",\"createBy\":\"admin\",\"createTime\":\"2024-06-04 09:01:32\",\"dictType\":\"\",\"edit\":false,\"htmlType\":\"input\",\"increment\":true,\"insert\":true,\"isIncrement\":\"1\",\"isInsert\":\"1\",\"isPk\":\"1\",\"javaField\":\"id\",\"javaType\":\"Long\",\"list\":false,\"params\":{},\"pk\":true,\"query\":false,\"queryType\":\"EQ\",\"required\":false,\"sort\":1,\"superColumn\":false,\"tableId\":23,\"updateBy\":\"\",\"usableColumn\":false},{\"capJavaField\":\"Type\",\"columnComment\":\"类型\",\"columnId\":224,\"columnName\":\"type\",\"columnType\":\"varchar(10)\",\"createBy\":\"admin\",\"createTime\":\"2024-06-04 09:01:33\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"select\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"javaField\":\"type\",\"javaType\":\"String\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"EQ\",\"required\":false,\"sort\":2,\"superColumn\":false,\"tableId\":23,\"updateBy\":\"\",\"usableColumn\":false},{\"capJavaField\":\"Name\",\"columnComment\":\"算法子名称\",\"columnId\":225,\"columnName\":\"name\",\"columnType\":\"varchar(200)\",\"createBy\":\"admin\",\"createTime\":\"2024-06-04 09:01:33\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"javaField\":\"name\",\"javaType\":\"String\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"LIKE\",\"required\":false,\"sort\":3,\"superColumn\":false,\"tableId\":23,\"updateBy\":\"\",\"usableColumn\":false},{\"capJavaField\":\"Url\",\"columnComment\":\"算法url\",\"columnId\":226,\"columnName\":\"url\",\"columnType\":\"varchar(255)\",\"createBy\":\"admin\",\"createTime\":\"2024-06-04 09:01:33\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"javaField\":\"url\",\"javaType\":\"String\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryT', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-04 10:40:05', 3904);
    591. 

  591. INSERT INTO `sys_oper_log` VALUES (118, '代码生成', 2, 'com.pdaaphm.generator.controller.GenController.editSave()', 'PUT', 1, 'admin', NULL, '/tool/gen', '127.0.0.1', '内网IP', '{\"businessName\":\"field\",\"className\":\"TAlgorithmIoField\",\"columns\":[{\"capJavaField\":\"Id\",\"columnComment\":\"编号\",\"columnId\":213,\"columnName\":\"id\",\"columnType\":\"bigint\",\"createBy\":\"admin\",\"createTime\":\"2024-06-04 09:01:30\",\"dictType\":\"\",\"edit\":false,\"htmlType\":\"input\",\"increment\":true,\"insert\":true,\"isIncrement\":\"1\",\"isInsert\":\"1\",\"isPk\":\"1\",\"javaField\":\"id\",\"javaType\":\"Long\",\"list\":false,\"params\":{},\"pk\":true,\"query\":false,\"queryType\":\"EQ\",\"required\":false,\"sort\":1,\"superColumn\":false,\"tableId\":22,\"updateBy\":\"\",\"usableColumn\":false},{\"capJavaField\":\"AlgorithmSubId\",\"columnComment\":\"算法子类型编号\",\"columnId\":214,\"columnName\":\"algorithm_sub_id\",\"columnType\":\"bigint\",\"createBy\":\"admin\",\"createTime\":\"2024-06-04 09:01:30\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"isRequired\":\"1\",\"javaField\":\"algorithmSubId\",\"javaType\":\"Long\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"EQ\",\"required\":true,\"sort\":2,\"superColumn\":false,\"tableId\":22,\"updateBy\":\"\",\"usableColumn\":false},{\"capJavaField\":\"Type\",\"columnComment\":\"输入/输出\",\"columnId\":215,\"columnName\":\"type\",\"columnType\":\"varchar(10)\",\"createBy\":\"admin\",\"createTime\":\"2024-06-04 09:01:30\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"select\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"javaField\":\"type\",\"javaType\":\"String\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"EQ\",\"required\":false,\"sort\":3,\"superColumn\":false,\"tableId\":22,\"updateBy\":\"\",\"usableColumn\":false},{\"capJavaField\":\"Name\",\"columnComment\":\"名称\",\"columnId\":216,\"columnName\":\"name\",\"columnType\":\"varchar(200)\",\"createBy\":\"admin\",\"createTime\":\"2024-06-04 09:01:31\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"javaField\":\"name\",\"javaType\":\"String\",\"list\":true,\"p', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-04 11:36:07', 433);
    592. 

  592. INSERT INTO `sys_oper_log` VALUES (119, '代码生成', 8, 'com.pdaaphm.generator.controller.GenController.batchGenCode()', 'GET', 1, 'admin', NULL, '/tool/gen/batchGenCode', '127.0.0.1', '内网IP', '{\"tables\":\"t_algorithm_io_field\"}', NULL, 0, NULL, '2024-06-04 11:36:25', 103);
    593. 

  593. INSERT INTO `sys_oper_log` VALUES (120, '代码生成', 8, 'com.pdaaphm.generator.controller.GenController.batchGenCode()', 'GET', 1, 'admin', NULL, '/tool/gen/batchGenCode', '127.0.0.1', '内网IP', '{\"tables\":\"t_algorithm_io_field\"}', NULL, 0, NULL, '2024-06-04 11:36:26', 39);
    594. 

  594. INSERT INTO `sys_oper_log` VALUES (121, '代码生成', 8, 'com.pdaaphm.generator.controller.GenController.batchGenCode()', 'GET', 1, 'admin', NULL, '/tool/gen/batchGenCode', '127.0.0.1', '内网IP', '{\"tables\":\"t_algorithm_sub_type\"}', NULL, 0, NULL, '2024-06-04 11:36:30', 42);
    595. 

  595. INSERT INTO `sys_oper_log` VALUES (122, '代码生成', 8, 'com.pdaaphm.generator.controller.GenController.batchGenCode()', 'GET', 1, 'admin', NULL, '/tool/gen/batchGenCode', '127.0.0.1', '内网IP', '{\"tables\":\"t_algorithm_sub_type\"}', NULL, 0, NULL, '2024-06-04 11:37:28', 141);
    596. 

  596. INSERT INTO `sys_oper_log` VALUES (123, '代码生成', 8, 'com.pdaaphm.generator.controller.GenController.batchGenCode()', 'GET', 1, 'admin', NULL, '/tool/gen/batchGenCode', '127.0.0.1', '内网IP', '{\"tables\":\"t_algorithm_io_field\"}', NULL, 0, NULL, '2024-06-04 11:39:35', 53);
    597. 

  597. INSERT INTO `sys_oper_log` VALUES (124, '代码生成', 8, 'com.pdaaphm.generator.controller.GenController.batchGenCode()', 'GET', 1, 'admin', NULL, '/tool/gen/batchGenCode', '127.0.0.1', '内网IP', '{\"tables\":\"t_algorithm_sub_type\"}', NULL, 0, NULL, '2024-06-04 11:39:49', 37);
    598. 

  598. INSERT INTO `sys_oper_log` VALUES (125, '菜单管理', 2, 'com.pdaaphm.web.controller.system.SysMenuController.edit()', 'PUT', 1, 'admin', NULL, '/system/menu', '127.0.0.1', '内网IP', '{\"children\":[],\"component\":\"algoManager/algorithm/index\",\"createTime\":\"2024-06-04 10:34:33\",\"icon\":\"#\",\"isCache\":\"0\",\"isFrame\":\"1\",\"menuId\":2002,\"menuName\":\"数据处理\",\"menuType\":\"C\",\"orderNum\":1,\"params\":{},\"parentId\":2000,\"path\":\"algorithm\",\"perms\":\"algoManager:algorithm:list\",\"status\":\"0\",\"updateBy\":\"admin\",\"visible\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 08:19:26', 309);
    599. 

  599. INSERT INTO `sys_oper_log` VALUES (126, '代码生成', 2, 'com.pdaaphm.generator.controller.GenController.editSave()', 'PUT', 1, 'admin', NULL, '/tool/gen', '127.0.0.1', '内网IP', '{\"businessName\":\"file\",\"className\":\"TFile\",\"columns\":[{\"capJavaField\":\"Id\",\"columnComment\":\"编号\",\"columnId\":233,\"columnName\":\"id\",\"columnType\":\"bigint\",\"createBy\":\"admin\",\"createTime\":\"2024-06-04 09:01:35\",\"dictType\":\"\",\"edit\":false,\"htmlType\":\"input\",\"increment\":true,\"insert\":true,\"isIncrement\":\"1\",\"isInsert\":\"1\",\"isPk\":\"1\",\"javaField\":\"id\",\"javaType\":\"Long\",\"list\":false,\"params\":{},\"pk\":true,\"query\":false,\"queryType\":\"EQ\",\"required\":false,\"sort\":1,\"superColumn\":false,\"tableId\":24,\"updateBy\":\"\",\"usableColumn\":false},{\"capJavaField\":\"Name\",\"columnComment\":\"文档名称\",\"columnId\":234,\"columnName\":\"name\",\"columnType\":\"varchar(200)\",\"createBy\":\"admin\",\"createTime\":\"2024-06-04 09:01:36\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"javaField\":\"name\",\"javaType\":\"String\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"LIKE\",\"required\":false,\"sort\":2,\"superColumn\":false,\"tableId\":24,\"updateBy\":\"\",\"usableColumn\":false},{\"capJavaField\":\"Path\",\"columnComment\":\"文档路径\",\"columnId\":235,\"columnName\":\"path\",\"columnType\":\"varchar(255)\",\"createBy\":\"admin\",\"createTime\":\"2024-06-04 09:01:36\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"javaField\":\"path\",\"javaType\":\"String\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"EQ\",\"required\":false,\"sort\":3,\"superColumn\":false,\"tableId\":24,\"updateBy\":\"\",\"usableColumn\":false},{\"capJavaField\":\"Type\",\"columnComment\":\"类型\",\"columnId\":236,\"columnName\":\"type\",\"columnType\":\"varchar(10)\",\"createBy\":\"admin\",\"createTime\":\"2024-06-04 09:01:36\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"select\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"javaField\":\"type\",\"javaType\":\"String\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"EQ\",\"req', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 08:36:50', 2064);
    600. 

  600. INSERT INTO `sys_oper_log` VALUES (127, '代码生成', 2, 'com.pdaaphm.generator.controller.GenController.editSave()', 'PUT', 1, 'admin', NULL, '/tool/gen', '127.0.0.1', '内网IP', '{\"businessName\":\"file\",\"className\":\"TFile\",\"columns\":[{\"capJavaField\":\"Id\",\"columnComment\":\"编号\",\"columnId\":233,\"columnName\":\"id\",\"columnType\":\"bigint\",\"createBy\":\"admin\",\"createTime\":\"2024-06-04 09:01:35\",\"dictType\":\"\",\"edit\":false,\"htmlType\":\"input\",\"increment\":true,\"insert\":true,\"isIncrement\":\"1\",\"isInsert\":\"1\",\"isPk\":\"1\",\"javaField\":\"id\",\"javaType\":\"Long\",\"list\":false,\"params\":{},\"pk\":true,\"query\":false,\"queryType\":\"EQ\",\"required\":false,\"sort\":1,\"superColumn\":false,\"tableId\":24,\"updateBy\":\"\",\"updateTime\":\"2024-06-05 08:36:48\",\"usableColumn\":false},{\"capJavaField\":\"Name\",\"columnComment\":\"文档名称\",\"columnId\":234,\"columnName\":\"name\",\"columnType\":\"varchar(200)\",\"createBy\":\"admin\",\"createTime\":\"2024-06-04 09:01:36\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"javaField\":\"name\",\"javaType\":\"String\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"LIKE\",\"required\":false,\"sort\":2,\"superColumn\":false,\"tableId\":24,\"updateBy\":\"\",\"updateTime\":\"2024-06-05 08:36:48\",\"usableColumn\":false},{\"capJavaField\":\"Path\",\"columnComment\":\"文档路径\",\"columnId\":235,\"columnName\":\"path\",\"columnType\":\"varchar(255)\",\"createBy\":\"admin\",\"createTime\":\"2024-06-04 09:01:36\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"javaField\":\"path\",\"javaType\":\"String\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"EQ\",\"required\":false,\"sort\":3,\"superColumn\":false,\"tableId\":24,\"updateBy\":\"\",\"updateTime\":\"2024-06-05 08:36:49\",\"usableColumn\":false},{\"capJavaField\":\"Type\",\"columnComment\":\"类型\",\"columnId\":236,\"columnName\":\"type\",\"columnType\":\"varchar(10)\",\"createBy\":\"admin\",\"createTime\":\"2024-06-04 09:01:36\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"select\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"ja', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 08:37:37', 1734);
    601. 

  601. INSERT INTO `sys_oper_log` VALUES (128, '代码生成', 8, 'com.pdaaphm.generator.controller.GenController.batchGenCode()', 'GET', 1, 'admin', NULL, '/tool/gen/batchGenCode', '127.0.0.1', '内网IP', '{\"tables\":\"t_file\"}', NULL, 0, NULL, '2024-06-05 08:57:31', 1141);
    602. 

  602. INSERT INTO `sys_oper_log` VALUES (129, '文件', 1, 'com.pdaaphm.biz.controller.FileController.add()', 'POST', 1, 'admin', NULL, '/algoManager/file', '127.0.0.1', '内网IP', '{\"createTime\":\"2024-06-05 17:07:03\",\"dataType\":\"0\",\"name\":\"input1.mat\",\"params\":{},\"path\":\"/profile/upload/2024/06/05/input1_20240605170646A001.mat\",\"type\":\"1\"}', NULL, 1, '\r\n### Error updating database.  Cause: java.sql.SQLSyntaxErrorException: Unknown column \'data_type\' in \'field list\'\r\n### The error may exist in file [D:\\IdeaProjects\\pdaaphm\\pdaaphm-admin\\target\\classes\\mapper\\algoManager\\FileMapper.xml]\r\n### The error may involve com.pdaaphm.biz.mapper.FileMapper.insertFile-Inline\r\n### The error occurred while setting parameters\r\n### SQL: insert into t_file          ( `name`,             `path`,             `type`,             `data_type`,                          create_time )           values ( ?,             ?,             ?,             ?,                          ? )\r\n### Cause: java.sql.SQLSyntaxErrorException: Unknown column \'data_type\' in \'field list\'\n; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Unknown column \'data_type\' in \'field list\'', '2024-06-05 09:07:05', 218);
    603. 

  603. INSERT INTO `sys_oper_log` VALUES (130, '文件', 1, 'com.pdaaphm.biz.controller.FileController.add()', 'POST', 1, 'admin', NULL, '/algoManager/file', '127.0.0.1', '内网IP', '{\"createTime\":\"2024-06-05 17:20:56\",\"dataType\":\"0\",\"id\":1,\"name\":\"input1.mat\",\"params\":{},\"path\":\"/profile/upload/2024/06/05/input1_20240605170646A001.mat\",\"type\":\"1\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 09:20:59', 1641);
    604. 

  604. INSERT INTO `sys_oper_log` VALUES (131, '算法子类型', 1, 'com.pdaaphm.biz.controller.AlgorithmSubTypeController.add()', 'POST', 1, 'admin', NULL, '/conf/subType', '127.0.0.1', '内网IP', '{\"createTime\":\"2024-06-05 17:22:42\",\"dataType\":\"0\",\"name\":\"GWO-SVM\",\"params\":{},\"runType\":\"2\",\"type\":\"5\",\"url\":\"D:\\\\pdaaphm\\\\matlabexe\\\\GWO_SVM_exmp.exe\"}', NULL, 1, '\r\n### Error updating database.  Cause: java.sql.SQLSyntaxErrorException: Unknown column \'data_type\' in \'field list\'\r\n### The error may exist in file [D:\\IdeaProjects\\pdaaphm\\pdaaphm-admin\\target\\classes\\mapper\\conf\\AlgorithmSubTypeMapper.xml]\r\n### The error may involve com.pdaaphm.biz.mapper.AlgorithmSubTypeMapper.insertAlgorithmSubType-Inline\r\n### The error occurred while setting parameters\r\n### SQL: insert into t_algorithm_sub_type          ( `type`,             `name`,             url,             run_type,             data_type,                          create_time )           values ( ?,             ?,             ?,             ?,             ?,                          ? )\r\n### Cause: java.sql.SQLSyntaxErrorException: Unknown column \'data_type\' in \'field list\'\n; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Unknown column \'data_type\' in \'field list\'', '2024-06-05 09:22:42', 42);
    605. 

  605. INSERT INTO `sys_oper_log` VALUES (132, '算法子类型', 1, 'com.pdaaphm.biz.controller.AlgorithmSubTypeController.add()', 'POST', 1, 'admin', NULL, '/conf/subType', '127.0.0.1', '内网IP', '{\"createTime\":\"2024-06-05 17:25:29\",\"dataType\":\"0\",\"id\":1,\"name\":\"GWO-SVM\",\"params\":{},\"runType\":\"2\",\"type\":\"5\",\"url\":\"D:\\\\pdaaphm\\\\matlabexe\\\\GWO_SVM_exmp.exe\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 09:25:29', 59);
    606. 

  606. INSERT INTO `sys_oper_log` VALUES (133, '算法输入输出字段', 1, 'com.pdaaphm.biz.controller.AlgorithmIoFieldController.add()', 'POST', 1, 'admin', NULL, '/conf/field', '127.0.0.1', '内网IP', '{\"algorithmSubId\":1,\"createTime\":\"2024-06-05 17:26:13\",\"index\":1,\"matlabIoPath\":\"D:\\\\pdaaphm\\\\data\\\\matlab\\\\GWO_SVM_exmp\",\"name\":\"input1\",\"params\":{},\"type\":\"1\"}', NULL, 1, '\r\n### Error updating database.  Cause: java.sql.SQLSyntaxErrorException: Unknown column \'matlab_io_path\' in \'field list\'\r\n### The error may exist in file [D:\\IdeaProjects\\pdaaphm\\pdaaphm-admin\\target\\classes\\mapper\\conf\\AlgorithmIoFieldMapper.xml]\r\n### The error may involve com.pdaaphm.biz.mapper.AlgorithmIoFieldMapper.insertAlgorithmIoField-Inline\r\n### The error occurred while setting parameters\r\n### SQL: insert into t_algorithm_io_field          ( algorithm_sub_id,             `type`,             `name`,             `index`,             matlab_io_path,                          create_time )           values ( ?,             ?,             ?,             ?,             ?,                          ? )\r\n### Cause: java.sql.SQLSyntaxErrorException: Unknown column \'matlab_io_path\' in \'field list\'\n; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Unknown column \'matlab_io_path\' in \'field list\'', '2024-06-05 09:26:13', 39);
    607. 

  607. INSERT INTO `sys_oper_log` VALUES (134, '算法输入输出字段', 1, 'com.pdaaphm.biz.controller.AlgorithmIoFieldController.add()', 'POST', 1, 'admin', NULL, '/conf/field', '127.0.0.1', '内网IP', '{\"algorithmSubId\":1,\"createTime\":\"2024-06-05 17:31:00\",\"id\":1,\"index\":1,\"matlabIoPath\":\"D:\\\\pdaaphm\\\\data\\\\matlab\\\\GWO_SVM_exmp\",\"name\":\"input1\",\"params\":{},\"type\":\"1\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 09:31:01', 59);
    608. 

  608. INSERT INTO `sys_oper_log` VALUES (135, '算法输入输出字段', 1, 'com.pdaaphm.biz.controller.AlgorithmIoFieldController.add()', 'POST', 1, 'admin', NULL, '/conf/field', '127.0.0.1', '内网IP', '{\"algorithmSubId\":1,\"createTime\":\"2024-06-05 17:32:49\",\"id\":2,\"index\":1,\"matlabIoPath\":\"D:\\\\pdaaphm\\\\data\\\\matlab\\\\GWO_SVM_exmp\",\"name\":\"output1\",\"params\":{},\"type\":\"2\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 09:32:49', 40);
    609. 

  609. INSERT INTO `sys_oper_log` VALUES (136, '算法输入输出字段', 1, 'com.pdaaphm.biz.controller.AlgorithmIoFieldController.add()', 'POST', 1, 'admin', NULL, '/conf/field', '127.0.0.1', '内网IP', '{\"algorithmSubId\":1,\"createTime\":\"2024-06-05 17:33:01\",\"id\":3,\"index\":2,\"matlabIoPath\":\"D:\\\\pdaaphm\\\\data\\\\matlab\\\\GWO_SVM_exmp\",\"name\":\"\",\"params\":{},\"type\":\"2\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 09:33:01', 40);
    610. 

  610. INSERT INTO `sys_oper_log` VALUES (137, '算法输入输出字段', 2, 'com.pdaaphm.biz.controller.AlgorithmIoFieldController.edit()', 'PUT', 1, 'admin', NULL, '/conf/field', '127.0.0.1', '内网IP', '{\"algoSubName\":\"GWO-SVM\",\"algorithmSubId\":1,\"createBy\":\"\",\"createTime\":\"2024-06-05 17:33:01\",\"id\":3,\"index\":2,\"matlabIoPath\":\"D:\\\\pdaaphm\\\\data\\\\matlab\\\\GWO_SVM_exmp\",\"name\":\"output2\",\"params\":{},\"type\":\"2\",\"updateBy\":\"\",\"updateTime\":\"2024-06-05 17:33:08\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 09:33:08', 42);
    611. 

  611. INSERT INTO `sys_oper_log` VALUES (138, '算法', 1, 'com.pdaaphm.biz.controller.AlgorithmController.addDto()', 'POST', 1, 'admin', NULL, '/algoManager/algorithm/addOrUpdateDto', '127.0.0.1', '内网IP', '{\"ioSubList\":[{\"fieldId\":1,\"name\":\"input1\",\"type\":\"1\",\"uploadId\":1},{\"fieldId\":2,\"name\":\"output1\",\"type\":\"2\"},{\"fieldId\":3,\"name\":\"output2\",\"type\":\"2\"}],\"name\":\"GWO-SVM-test1\",\"subTypeId\":1,\"type\":\"5\"}', NULL, 1, '\r\n### Error updating database.  Cause: java.sql.SQLSyntaxErrorException: Unknown column \'status\' in \'field list\'\r\n### The error may exist in file [D:\\IdeaProjects\\pdaaphm\\pdaaphm-admin\\target\\classes\\mapper\\algoManager\\AlgorithmMapper.xml]\r\n### The error may involve com.pdaaphm.biz.mapper.AlgorithmMapper.insertAlgorithm-Inline\r\n### The error occurred while setting parameters\r\n### SQL: insert into t_algorithm          ( `type`,             sub_type_id,             `name`,             status,                                                                              create_time )           values ( ?,             ?,             ?,             ?,                                                                              ? )\r\n### Cause: java.sql.SQLSyntaxErrorException: Unknown column \'status\' in \'field list\'\n; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Unknown column \'status\' in \'field list\'', '2024-06-05 09:33:44', 53);
    612. 

  612. INSERT INTO `sys_oper_log` VALUES (139, '算法', 1, 'com.pdaaphm.biz.controller.AlgorithmController.addDto()', 'POST', 1, 'admin', NULL, '/algoManager/algorithm/addOrUpdateDto', '127.0.0.1', '内网IP', '{\"ioSubList\":[{\"fieldId\":1,\"name\":\"input1\",\"type\":\"1\",\"uploadId\":1},{\"fieldId\":2,\"name\":\"output1\",\"type\":\"2\"},{\"fieldId\":3,\"name\":\"output2\",\"type\":\"2\"}],\"name\":\"GWO-SVM-test1\",\"subTypeId\":1,\"type\":\"5\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 09:37:09', 187);
    613. 

  613. INSERT INTO `sys_oper_log` VALUES (140, '算法', 2, 'com.pdaaphm.biz.controller.AlgorithmController.runAlgorithms()', 'GET', 1, 'admin', NULL, '/algoManager/algorithm/runAlgorithms/1', '127.0.0.1', '内网IP', '{}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 09:37:19', 4);
    614. 

  614. INSERT INTO `sys_oper_log` VALUES (141, '算法', 2, 'com.pdaaphm.biz.controller.AlgorithmController.runAlgorithms()', 'GET', 1, 'admin', NULL, '/algoManager/algorithm/runAlgorithms/1', '127.0.0.1', '内网IP', '{}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 09:38:21', 0);
    615. 

  615. INSERT INTO `sys_oper_log` VALUES (142, '代码生成', 8, 'com.pdaaphm.generator.controller.GenController.batchGenCode()', 'GET', 1, 'admin', NULL, '/tool/gen/batchGenCode', '127.0.0.1', '内网IP', '{\"tables\":\"t_algorithm\"}', NULL, 0, NULL, '2024-06-05 12:25:15', 47);
    616. 

  616. INSERT INTO `sys_oper_log` VALUES (143, '代码生成', 2, 'com.pdaaphm.generator.controller.GenController.editSave()', 'PUT', 1, 'admin', NULL, '/tool/gen', '127.0.0.1', '内网IP', '{\"businessName\":\"algorithm2\",\"className\":\"TAlgorithm\",\"columns\":[{\"capJavaField\":\"Id\",\"columnComment\":\"编号\",\"columnId\":201,\"columnName\":\"id\",\"columnType\":\"bigint\",\"createBy\":\"admin\",\"createTime\":\"2024-06-04 09:01:27\",\"dictType\":\"\",\"edit\":false,\"htmlType\":\"input\",\"increment\":true,\"insert\":true,\"isIncrement\":\"1\",\"isInsert\":\"1\",\"isPk\":\"1\",\"javaField\":\"id\",\"javaType\":\"Long\",\"list\":false,\"params\":{},\"pk\":true,\"query\":false,\"queryType\":\"EQ\",\"required\":false,\"sort\":1,\"superColumn\":false,\"tableId\":21,\"updateBy\":\"\",\"updateTime\":\"2024-06-04 10:31:21\",\"usableColumn\":false},{\"capJavaField\":\"Type\",\"columnComment\":\"算法类型\",\"columnId\":202,\"columnName\":\"type\",\"columnType\":\"varchar(10)\",\"createBy\":\"admin\",\"createTime\":\"2024-06-04 09:01:28\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"select\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"javaField\":\"type\",\"javaType\":\"String\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"EQ\",\"required\":false,\"sort\":2,\"superColumn\":false,\"tableId\":21,\"updateBy\":\"\",\"updateTime\":\"2024-06-04 10:31:21\",\"usableColumn\":false},{\"capJavaField\":\"SubTypeId\",\"columnComment\":\"子类型id\",\"columnId\":203,\"columnName\":\"sub_type_id\",\"columnType\":\"bigint\",\"createBy\":\"admin\",\"createTime\":\"2024-06-04 09:01:28\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"isRequired\":\"1\",\"javaField\":\"subTypeId\",\"javaType\":\"Long\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"EQ\",\"required\":true,\"sort\":3,\"superColumn\":false,\"tableId\":21,\"updateBy\":\"\",\"updateTime\":\"2024-06-04 10:31:21\",\"usableColumn\":false},{\"capJavaField\":\"Name\",\"columnComment\":\"名称\",\"columnId\":204,\"columnName\":\"name\",\"columnType\":\"varchar(200)\",\"createBy\":\"admin\",\"createTime\":\"2024-06-04 09:01:28\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isLis', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 12:29:54', 543);
    617. 

  617. INSERT INTO `sys_oper_log` VALUES (144, '代码生成', 8, 'com.pdaaphm.generator.controller.GenController.batchGenCode()', 'GET', 1, 'admin', NULL, '/tool/gen/batchGenCode', '127.0.0.1', '内网IP', '{\"tables\":\"t_algorithm\"}', NULL, 0, NULL, '2024-06-05 12:30:07', 44);
    618. 

  618. INSERT INTO `sys_oper_log` VALUES (145, '菜单管理', 2, 'com.pdaaphm.web.controller.system.SysMenuController.edit()', 'PUT', 1, 'admin', NULL, '/system/menu', '127.0.0.1', '内网IP', '{\"children\":[],\"component\":\"algoManager/algorithm2/index\",\"createTime\":\"2024-06-05 12:31:24\",\"icon\":\"#\",\"isCache\":\"0\",\"isFrame\":\"1\",\"menuId\":2026,\"menuName\":\"特征提取\",\"menuType\":\"C\",\"orderNum\":2,\"params\":{},\"parentId\":2000,\"path\":\"algorithm2\",\"perms\":\"algoManager:algorithm2:list\",\"status\":\"0\",\"updateBy\":\"admin\",\"visible\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 12:31:52', 58);
    619. 

  619. INSERT INTO `sys_oper_log` VALUES (146, '菜单管理', 2, 'com.pdaaphm.web.controller.system.SysMenuController.edit()', 'PUT', 1, 'admin', NULL, '/system/menu', '127.0.0.1', '内网IP', '{\"children\":[],\"component\":\"algoManager/file/index\",\"createTime\":\"2024-06-05 09:02:16\",\"icon\":\"#\",\"isCache\":\"0\",\"isFrame\":\"1\",\"menuId\":2020,\"menuName\":\"数据管理\",\"menuType\":\"C\",\"orderNum\":3,\"params\":{},\"parentId\":2000,\"path\":\"file\",\"perms\":\"algoManager:file:list\",\"status\":\"0\",\"updateBy\":\"admin\",\"visible\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 12:31:55', 74);
    620. 

  620. INSERT INTO `sys_oper_log` VALUES (147, '菜单管理', 2, 'com.pdaaphm.web.controller.system.SysMenuController.edit()', 'PUT', 1, 'admin', NULL, '/system/menu', '127.0.0.1', '内网IP', '{\"children\":[],\"component\":\"algoManager/file/index\",\"createTime\":\"2024-06-05 09:02:16\",\"icon\":\"#\",\"isCache\":\"0\",\"isFrame\":\"1\",\"menuId\":2020,\"menuName\":\"数据管理\",\"menuType\":\"C\",\"orderNum\":4,\"params\":{},\"parentId\":2000,\"path\":\"file\",\"perms\":\"algoManager:file:list\",\"status\":\"0\",\"updateBy\":\"admin\",\"visible\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 12:32:00', 57);
    621. 

  621. INSERT INTO `sys_oper_log` VALUES (148, '代码生成', 2, 'com.pdaaphm.generator.controller.GenController.editSave()', 'PUT', 1, 'admin', NULL, '/tool/gen', '127.0.0.1', '内网IP', '{\"businessName\":\"algorithm3\",\"className\":\"TAlgorithm\",\"columns\":[{\"capJavaField\":\"Id\",\"columnComment\":\"编号\",\"columnId\":201,\"columnName\":\"id\",\"columnType\":\"bigint\",\"createBy\":\"admin\",\"createTime\":\"2024-06-04 09:01:27\",\"dictType\":\"\",\"edit\":false,\"htmlType\":\"input\",\"increment\":true,\"insert\":true,\"isIncrement\":\"1\",\"isInsert\":\"1\",\"isPk\":\"1\",\"javaField\":\"id\",\"javaType\":\"Long\",\"list\":false,\"params\":{},\"pk\":true,\"query\":false,\"queryType\":\"EQ\",\"required\":false,\"sort\":1,\"superColumn\":false,\"tableId\":21,\"updateBy\":\"\",\"updateTime\":\"2024-06-05 12:29:53\",\"usableColumn\":false},{\"capJavaField\":\"Type\",\"columnComment\":\"算法类型\",\"columnId\":202,\"columnName\":\"type\",\"columnType\":\"varchar(10)\",\"createBy\":\"admin\",\"createTime\":\"2024-06-04 09:01:28\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"select\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"javaField\":\"type\",\"javaType\":\"String\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"EQ\",\"required\":false,\"sort\":2,\"superColumn\":false,\"tableId\":21,\"updateBy\":\"\",\"updateTime\":\"2024-06-05 12:29:53\",\"usableColumn\":false},{\"capJavaField\":\"SubTypeId\",\"columnComment\":\"子类型id\",\"columnId\":203,\"columnName\":\"sub_type_id\",\"columnType\":\"bigint\",\"createBy\":\"admin\",\"createTime\":\"2024-06-04 09:01:28\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isList\":\"1\",\"isPk\":\"0\",\"isQuery\":\"1\",\"isRequired\":\"1\",\"javaField\":\"subTypeId\",\"javaType\":\"Long\",\"list\":true,\"params\":{},\"pk\":false,\"query\":true,\"queryType\":\"EQ\",\"required\":true,\"sort\":3,\"superColumn\":false,\"tableId\":21,\"updateBy\":\"\",\"updateTime\":\"2024-06-05 12:29:53\",\"usableColumn\":false},{\"capJavaField\":\"Name\",\"columnComment\":\"名称\",\"columnId\":204,\"columnName\":\"name\",\"columnType\":\"varchar(200)\",\"createBy\":\"admin\",\"createTime\":\"2024-06-04 09:01:28\",\"dictType\":\"\",\"edit\":true,\"htmlType\":\"input\",\"increment\":false,\"insert\":true,\"isEdit\":\"1\",\"isIncrement\":\"0\",\"isInsert\":\"1\",\"isLis', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 12:33:29', 539);
    622. 

  622. INSERT INTO `sys_oper_log` VALUES (149, '代码生成', 8, 'com.pdaaphm.generator.controller.GenController.batchGenCode()', 'GET', 1, 'admin', NULL, '/tool/gen/batchGenCode', '127.0.0.1', '内网IP', '{\"tables\":\"t_algorithm\"}', NULL, 0, NULL, '2024-06-05 12:33:33', 43);
    623. 

  623. INSERT INTO `sys_oper_log` VALUES (150, '菜单管理', 2, 'com.pdaaphm.web.controller.system.SysMenuController.edit()', 'PUT', 1, 'admin', NULL, '/system/menu', '127.0.0.1', '内网IP', '{\"children\":[],\"component\":\"algoManager/algorithm3/index\",\"createTime\":\"2024-06-05 12:35:06\",\"icon\":\"#\",\"isCache\":\"0\",\"isFrame\":\"1\",\"menuId\":2032,\"menuName\":\"故障预测\",\"menuType\":\"C\",\"orderNum\":3,\"params\":{},\"parentId\":2000,\"path\":\"algorithm3\",\"perms\":\"algoManager:algorithm3:list\",\"status\":\"0\",\"updateBy\":\"admin\",\"visible\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 12:35:25', 59);
    624. 

  624. INSERT INTO `sys_oper_log` VALUES (151, '菜单管理', 2, 'com.pdaaphm.web.controller.system.SysMenuController.edit()', 'PUT', 1, 'admin', NULL, '/system/menu', '127.0.0.1', '内网IP', '{\"children\":[],\"component\":\"conf/field/index\",\"createTime\":\"2024-06-04 11:40:27\",\"icon\":\"#\",\"isCache\":\"0\",\"isFrame\":\"1\",\"menuId\":2008,\"menuName\":\"算法输入输出字段\",\"menuType\":\"C\",\"orderNum\":2,\"params\":{},\"parentId\":2001,\"path\":\"field\",\"perms\":\"conf:field:list\",\"status\":\"0\",\"updateBy\":\"admin\",\"visible\":\"0\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 12:36:57', 60);
    625. 

  625. INSERT INTO `sys_oper_log` VALUES (152, '算法子类型', 1, 'com.pdaaphm.biz.controller.AlgorithmSubTypeController.add()', 'POST', 1, 'admin', NULL, '/conf/subType', '127.0.0.1', '内网IP', '{\"createTime\":\"2024-06-05 20:37:59\",\"dataType\":\"4\",\"id\":2,\"name\":\"BP燃油泵退化数据HI\",\"params\":{},\"runType\":\"1\",\"type\":\"2\",\"url\":\"http://127.0.0.1:10006\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 12:37:59', 40);
    626. 

  626. INSERT INTO `sys_oper_log` VALUES (153, '算法子类型', 3, 'com.pdaaphm.biz.controller.AlgorithmSubTypeController.remove()', 'DELETE', 1, 'admin', NULL, '/conf/subType/2', '127.0.0.1', '内网IP', '{}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 12:39:56', 115);
    627. 

  627. INSERT INTO `sys_oper_log` VALUES (154, '算法子类型', 1, 'com.pdaaphm.biz.controller.AlgorithmSubTypeController.add()', 'POST', 1, 'admin', NULL, '/conf/subType', '127.0.0.1', '内网IP', '{\"createTime\":\"2024-06-05 20:40:12\",\"dataType\":\"4\",\"id\":3,\"name\":\"纯数据驱动【多项式】_FUNmain\",\"params\":{},\"runType\":\"2\",\"type\":\"2\",\"url\":\"D:\\\\pdaaphm\\\\matlabexe\\\\FUNmain.exe\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 12:40:12', 40);
    628. 

  628. INSERT INTO `sys_oper_log` VALUES (155, '算法输入输出字段', 1, 'com.pdaaphm.biz.controller.AlgorithmIoFieldController.add()', 'POST', 1, 'admin', NULL, '/conf/field', '127.0.0.1', '内网IP', '{\"algorithmSubId\":3,\"createTime\":\"2024-06-05 20:40:45\",\"id\":4,\"index\":1,\"matlabIoPath\":\"D:\\\\pdaaphm\\\\data\\\\matlab\\\\FUNmain\",\"name\":\"input1\",\"params\":{},\"type\":\"1\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 12:40:45', 43);
    629. 

  629. INSERT INTO `sys_oper_log` VALUES (156, '算法输入输出字段', 1, 'com.pdaaphm.biz.controller.AlgorithmIoFieldController.add()', 'POST', 1, 'admin', NULL, '/conf/field', '127.0.0.1', '内网IP', '{\"algorithmSubId\":3,\"createTime\":\"2024-06-05 20:40:59\",\"id\":5,\"index\":1,\"matlabIoPath\":\"D:\\\\pdaaphm\\\\data\\\\matlab\\\\FUNmain\",\"name\":\"output1\",\"params\":{},\"type\":\"2\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 12:40:58', 41);
    630. 

  630. INSERT INTO `sys_oper_log` VALUES (157, '算法输入输出字段', 1, 'com.pdaaphm.biz.controller.AlgorithmIoFieldController.add()', 'POST', 1, 'admin', NULL, '/conf/field', '127.0.0.1', '内网IP', '{\"algorithmSubId\":3,\"createTime\":\"2024-06-05 20:41:11\",\"id\":6,\"index\":2,\"matlabIoPath\":\"D:\\\\pdaaphm\\\\data\\\\matlab\\\\FUNmain\",\"name\":\"output2\",\"params\":{},\"type\":\"2\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 12:41:10', 41);
    631. 

  631. INSERT INTO `sys_oper_log` VALUES (158, '算法输入输出字段', 1, 'com.pdaaphm.biz.controller.AlgorithmIoFieldController.add()', 'POST', 1, 'admin', NULL, '/conf/field', '127.0.0.1', '内网IP', '{\"algorithmSubId\":3,\"createTime\":\"2024-06-05 20:41:21\",\"id\":7,\"index\":3,\"matlabIoPath\":\"D:\\\\pdaaphm\\\\data\\\\matlab\\\\FUNmain\",\"name\":\"output3\",\"params\":{},\"type\":\"2\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 12:41:21', 42);
    632. 

  632. INSERT INTO `sys_oper_log` VALUES (159, '文件', 1, 'com.pdaaphm.biz.controller.FileController.add()', 'POST', 1, 'admin', NULL, '/algoManager/file', '127.0.0.1', '内网IP', '{\"createTime\":\"2024-06-05 20:42:03\",\"dataType\":\"4\",\"id\":6,\"name\":\"input1.mat\",\"params\":{},\"path\":\"/profile/upload/2024/06/05/input1_20240605204202A006.mat\",\"type\":\"1\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 12:42:03', 40);
    633. 

  633. INSERT INTO `sys_oper_log` VALUES (160, '文件', 2, 'com.pdaaphm.biz.controller.FileController.edit()', 'PUT', 1, 'admin', NULL, '/algoManager/file', '127.0.0.1', '内网IP', '{\"createBy\":\"\",\"createTime\":\"2024-06-05 17:20:56\",\"dataType\":\"0\",\"id\":1,\"name\":\"FUNmain_input1.mat\",\"params\":{},\"path\":\"/profile/upload/2024/06/05/input1_20240605170646A001.mat\",\"type\":\"1\",\"updateBy\":\"\",\"updateTime\":\"2024-06-05 20:42:19\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 12:42:18', 40);
    634. 

  634. INSERT INTO `sys_oper_log` VALUES (161, '文件', 2, 'com.pdaaphm.biz.controller.FileController.edit()', 'PUT', 1, 'admin', NULL, '/algoManager/file', '127.0.0.1', '内网IP', '{\"createBy\":\"\",\"createTime\":\"2024-06-05 20:42:03\",\"dataType\":\"4\",\"id\":6,\"name\":\"GWO-SVM_input1.mat\",\"params\":{},\"path\":\"/profile/upload/2024/06/05/input1_20240605204202A006.mat\",\"type\":\"1\",\"updateBy\":\"\",\"updateTime\":\"2024-06-05 20:42:35\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 12:42:35', 39);
    635. 

  635. INSERT INTO `sys_oper_log` VALUES (162, '文件', 2, 'com.pdaaphm.biz.controller.FileController.edit()', 'PUT', 1, 'admin', NULL, '/algoManager/file', '127.0.0.1', '内网IP', '{\"createBy\":\"\",\"createTime\":\"2024-06-05 20:42:03\",\"dataType\":\"0\",\"id\":6,\"name\":\"GWO-SVM_input1.mat\",\"params\":{},\"path\":\"/profile/upload/2024/06/05/input1_20240605204202A006.mat\",\"type\":\"1\",\"updateBy\":\"\",\"updateTime\":\"2024-06-05 20:43:29\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 12:43:29', 42);
    636. 

  636. INSERT INTO `sys_oper_log` VALUES (163, '文件', 2, 'com.pdaaphm.biz.controller.FileController.edit()', 'PUT', 1, 'admin', NULL, '/algoManager/file', '127.0.0.1', '内网IP', '{\"createBy\":\"\",\"createTime\":\"2024-06-05 17:20:56\",\"dataType\":\"4\",\"id\":1,\"name\":\"FUNmain_input1.mat\",\"params\":{},\"path\":\"/profile/upload/2024/06/05/input1_20240605170646A001.mat\",\"type\":\"1\",\"updateBy\":\"\",\"updateTime\":\"2024-06-05 20:43:34\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 12:43:34', 41);
    637. 

  637. INSERT INTO `sys_oper_log` VALUES (164, '算法', 1, 'com.pdaaphm.biz.controller.AlgorithmController.addDto()', 'POST', 1, 'admin', NULL, '/algoManager/algorithm/addOrUpdateDto', '127.0.0.1', '内网IP', '{\"ioSubList\":[{\"fieldId\":4,\"name\":\"input1\",\"type\":\"1\",\"uploadId\":1},{\"fieldId\":5,\"name\":\"output1\",\"type\":\"2\"},{\"fieldId\":6,\"name\":\"output2\",\"type\":\"2\"},{\"fieldId\":7,\"name\":\"output3\",\"type\":\"2\"}],\"name\":\"FUNmain1\",\"subTypeId\":3,\"type\":\"2\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 12:43:57', 199);
    638. 

  638. INSERT INTO `sys_oper_log` VALUES (165, '算法', 2, 'com.pdaaphm.biz.controller.AlgorithmController.runAlgorithms()', 'GET', 1, 'admin', NULL, '/algoManager/algorithm/runAlgorithms/2', '127.0.0.1', '内网IP', '{}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 12:44:06', 0);
    639. 

  639. INSERT INTO `sys_oper_log` VALUES (166, '算法', 2, 'com.pdaaphm.biz.controller.AlgorithmController.runAlgorithms()', 'GET', 1, 'admin', NULL, '/algoManager/algorithm/runAlgorithms/1', '127.0.0.1', '内网IP', '{}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 12:45:38', 0);
    640. 

  640. INSERT INTO `sys_oper_log` VALUES (167, '文件', 1, 'com.pdaaphm.biz.controller.FileController.add()', 'POST', 1, 'admin', NULL, '/algoManager/file', '127.0.0.1', '内网IP', '{\"createTime\":\"2024-06-05 20:49:26\",\"dataType\":\"4\",\"id\":12,\"name\":\"氧浓器氧分压变化数据.csv\",\"params\":{},\"path\":\"/profile/upload/2024/06/05/氧浓器氧分压变化数据_20240605204924A012.csv\",\"type\":\"1\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 12:49:26', 40);
    641. 

  641. INSERT INTO `sys_oper_log` VALUES (168, '算法子类型', 1, 'com.pdaaphm.biz.controller.AlgorithmSubTypeController.add()', 'POST', 1, 'admin', NULL, '/conf/subType', '127.0.0.1', '内网IP', '{\"createTime\":\"2024-06-05 20:49:51\",\"dataType\":\"4\",\"id\":4,\"name\":\"turn-fine迁移学习寿命预测(氧分压信号预测)\",\"params\":{},\"runType\":\"1\",\"type\":\"4\",\"url\":\"http://127.0.0.1:10005\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 12:49:51', 42);
    642. 

  642. INSERT INTO `sys_oper_log` VALUES (169, '算法输入输出字段', 1, 'com.pdaaphm.biz.controller.AlgorithmIoFieldController.add()', 'POST', 1, 'admin', NULL, '/conf/field', '127.0.0.1', '内网IP', '{\"algorithmSubId\":4,\"createTime\":\"2024-06-05 20:50:41\",\"id\":8,\"index\":1,\"name\":\"input1\",\"params\":{},\"type\":\"1\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 12:50:40', 38);
    643. 

  643. INSERT INTO `sys_oper_log` VALUES (170, '算法输入输出字段', 1, 'com.pdaaphm.biz.controller.AlgorithmIoFieldController.add()', 'POST', 1, 'admin', NULL, '/conf/field', '127.0.0.1', '内网IP', '{\"algorithmSubId\":4,\"createTime\":\"2024-06-05 20:50:54\",\"id\":9,\"index\":1,\"name\":\"output1\",\"params\":{},\"type\":\"2\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 12:50:53', 39);
    644. 

  644. INSERT INTO `sys_oper_log` VALUES (171, '算法', 1, 'com.pdaaphm.biz.controller.AlgorithmController.addDto()', 'POST', 1, 'admin', NULL, '/algoManager/algorithm/addOrUpdateDto', '127.0.0.1', '内网IP', '{\"ioSubList\":[{\"fieldId\":8,\"name\":\"input1\",\"type\":\"1\",\"uploadId\":12},{\"fieldId\":9,\"name\":\"output1\",\"type\":\"2\"}],\"name\":\"turn-fine1\",\"subTypeId\":4,\"type\":\"4\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 12:51:22', 121);
    645. 

  645. INSERT INTO `sys_oper_log` VALUES (172, '算法', 2, 'com.pdaaphm.biz.controller.AlgorithmController.runAlgorithms()', 'GET', 1, 'admin', NULL, '/algoManager/algorithm/runAlgorithms/3', '127.0.0.1', '内网IP', '{}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 12:51:28', 0);
    646. 

  646. INSERT INTO `sys_oper_log` VALUES (173, '算法', 2, 'com.pdaaphm.biz.controller.AlgorithmController.runAlgorithms()', 'GET', 1, 'admin', NULL, '/algoManager/algorithm/runAlgorithms/3', '127.0.0.1', '内网IP', '{}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 12:52:19', 0);
    647. 

  647. INSERT INTO `sys_oper_log` VALUES (174, '算法', 2, 'com.pdaaphm.biz.controller.AlgorithmController.runAlgorithms()', 'GET', 1, 'admin', NULL, '/algoManager/algorithm/runAlgorithms/3', '127.0.0.1', '内网IP', '{}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 12:56:32', 0);
    648. 

  648. INSERT INTO `sys_oper_log` VALUES (175, '算法', 3, 'com.pdaaphm.biz.controller.AlgorithmController.remove()', 'DELETE', 1, 'admin', NULL, '/algoManager/algorithm/3', '127.0.0.1', '内网IP', '{}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 12:57:28', 40);
    649. 

  649. INSERT INTO `sys_oper_log` VALUES (176, '算法', 1, 'com.pdaaphm.biz.controller.AlgorithmController.addDto()', 'POST', 1, 'admin', NULL, '/algoManager/algorithm/addOrUpdateDto', '127.0.0.1', '内网IP', '{\"ioSubList\":[{\"fieldId\":8,\"name\":\"input1\",\"type\":\"1\",\"uploadId\":12},{\"fieldId\":9,\"name\":\"output1\",\"type\":\"2\"}],\"name\":\"turn-fine1\",\"subTypeId\":4,\"type\":\"4\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 12:57:56', 122);
    650. 

  650. INSERT INTO `sys_oper_log` VALUES (177, '算法', 2, 'com.pdaaphm.biz.controller.AlgorithmController.runAlgorithms()', 'GET', 1, 'admin', NULL, '/algoManager/algorithm/runAlgorithms/4', '127.0.0.1', '内网IP', '{}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 12:58:02', 1);
    651. 

  651. INSERT INTO `sys_oper_log` VALUES (178, '算法', 3, 'com.pdaaphm.biz.controller.AlgorithmController.remove()', 'DELETE', 1, 'admin', NULL, '/algoManager/algorithm/1', '127.0.0.1', '内网IP', '{}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 12:59:42', 39);
    652. 

  652. INSERT INTO `sys_oper_log` VALUES (179, '算法', 1, 'com.pdaaphm.biz.controller.AlgorithmController.addDto()', 'POST', 1, 'admin', NULL, '/algoManager/algorithm/addOrUpdateDto', '127.0.0.1', '内网IP', '{\"ioSubList\":[{\"fieldId\":1,\"name\":\"input1\",\"type\":\"1\",\"uploadId\":6},{\"fieldId\":2,\"name\":\"output1\",\"type\":\"2\"},{\"fieldId\":3,\"name\":\"output2\",\"type\":\"2\"}],\"name\":\"GWO-SVM1\",\"subTypeId\":1,\"type\":\"5\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 13:00:24', 163);
    653. 

  653. INSERT INTO `sys_oper_log` VALUES (180, '算法', 2, 'com.pdaaphm.biz.controller.AlgorithmController.runAlgorithms()', 'GET', 1, 'admin', NULL, '/algoManager/algorithm/runAlgorithms/5', '127.0.0.1', '内网IP', '{}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 13:00:29', 1);
    654. 

  654. INSERT INTO `sys_oper_log` VALUES (181, '文件', 1, 'com.pdaaphm.biz.controller.FileController.add()', 'POST', 1, 'admin', NULL, '/algoManager/file', '127.0.0.1', '内网IP', '{\"createTime\":\"2024-06-05 21:02:53\",\"dataType\":\"0\",\"id\":16,\"name\":\"GWO-SVR_input1\",\"params\":{},\"path\":\"/profile/upload/2024/06/05/input1_20240605210252A019.mat\",\"type\":\"1\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 13:02:53', 40);
    655. 

  655. INSERT INTO `sys_oper_log` VALUES (182, '算法子类型', 1, 'com.pdaaphm.biz.controller.AlgorithmSubTypeController.add()', 'POST', 1, 'admin', NULL, '/conf/subType', '127.0.0.1', '内网IP', '{\"createTime\":\"2024-06-05 21:04:24\",\"dataType\":\"0\",\"id\":5,\"name\":\"GWO-SVR\",\"params\":{},\"runType\":\"2\",\"type\":\"6\",\"url\":\"D:\\\\pdaaphm\\\\matlabexe\\\\GWO_SVR_exmp.exe\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 13:04:24', 59);
    656. 

  656. INSERT INTO `sys_oper_log` VALUES (183, '算法输入输出字段', 1, 'com.pdaaphm.biz.controller.AlgorithmIoFieldController.add()', 'POST', 1, 'admin', NULL, '/conf/field', '127.0.0.1', '内网IP', '{\"algorithmSubId\":5,\"createTime\":\"2024-06-05 21:04:39\",\"id\":10,\"index\":1,\"matlabIoPath\":\"D:\\\\pdaaphm\\\\data\\\\matlab\\\\GWO_SVR_exmp\",\"name\":\"input1\",\"params\":{},\"type\":\"1\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 13:04:39', 40);
    657. 

  657. INSERT INTO `sys_oper_log` VALUES (184, '算法输入输出字段', 1, 'com.pdaaphm.biz.controller.AlgorithmIoFieldController.add()', 'POST', 1, 'admin', NULL, '/conf/field', '127.0.0.1', '内网IP', '{\"algorithmSubId\":5,\"createTime\":\"2024-06-05 21:04:53\",\"id\":11,\"index\":1,\"matlabIoPath\":\"D:\\\\pdaaphm\\\\data\\\\matlab\\\\GWO_SVR_exmp\",\"name\":\"output1\",\"params\":{},\"type\":\"2\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 13:04:53', 39);
    658. 

  658. INSERT INTO `sys_oper_log` VALUES (185, '算法输入输出字段', 1, 'com.pdaaphm.biz.controller.AlgorithmIoFieldController.add()', 'POST', 1, 'admin', NULL, '/conf/field', '127.0.0.1', '内网IP', '{\"algorithmSubId\":5,\"createTime\":\"2024-06-05 21:05:07\",\"id\":12,\"index\":2,\"matlabIoPath\":\"D:\\\\pdaaphm\\\\data\\\\matlab\\\\GWO_SVR_exmp\",\"name\":\"output2\",\"params\":{},\"type\":\"2\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 13:05:07', 39);
    659. 

  659. INSERT INTO `sys_oper_log` VALUES (186, '算法输入输出字段', 1, 'com.pdaaphm.biz.controller.AlgorithmIoFieldController.add()', 'POST', 1, 'admin', NULL, '/conf/field', '127.0.0.1', '内网IP', '{\"algorithmSubId\":5,\"createTime\":\"2024-06-05 21:05:15\",\"id\":13,\"index\":3,\"matlabIoPath\":\"D:\\\\pdaaphm\\\\data\\\\matlab\\\\GWO_SVR_exmp\",\"name\":\"output3\",\"params\":{},\"type\":\"2\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 13:05:15', 39);
    660. 

  660. INSERT INTO `sys_oper_log` VALUES (187, '算法', 1, 'com.pdaaphm.biz.controller.AlgorithmController.addDto()', 'POST', 1, 'admin', NULL, '/algoManager/algorithm/addOrUpdateDto', '127.0.0.1', '内网IP', '{\"ioSubList\":[{\"fieldId\":10,\"name\":\"input1\",\"type\":\"1\",\"uploadId\":16},{\"fieldId\":11,\"name\":\"output1\",\"type\":\"2\"},{\"fieldId\":12,\"name\":\"output2\",\"type\":\"2\"},{\"fieldId\":13,\"name\":\"output3\",\"type\":\"2\"}],\"name\":\"GWO-SVR1\",\"subTypeId\":5,\"type\":\"6\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 13:06:10', 201);
    661. 

  661. INSERT INTO `sys_oper_log` VALUES (188, '算法', 2, 'com.pdaaphm.biz.controller.AlgorithmController.runAlgorithms()', 'GET', 1, 'admin', NULL, '/algoManager/algorithm/runAlgorithms/6', '127.0.0.1', '内网IP', '{}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2024-06-05 13:06:15', 1);
    662. 

  662. 

  663. -- ----------------------------
    664. 

  664. -- Table structure for sys_post
    665. 

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

  666. DROP TABLE IF EXISTS `sys_post`;
    667. 

  667. CREATE TABLE `sys_post`  (
    668. 

  668.                              `post_id` bigint NOT NULL AUTO_INCREMENT COMMENT '岗位ID',
    669. 

  669.                              `post_code` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '岗位编码',
    670. 

  670.                              `post_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '岗位名称',
    671. 

  671.                              `post_sort` int NOT NULL COMMENT '显示顺序',
    672. 

  672.                              `status` char(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '状态（0正常 1停用）',
    673. 

  673.                              `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '创建者',
    674. 

  674.                              `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    675. 

  675.                              `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '更新者',
    676. 

  676.                              `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
    677. 

  677.                              `remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '备注',
    678. 

  678.                              PRIMARY KEY (`post_id`) USING BTREE
    679. 

  679. ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '岗位信息表' ROW_FORMAT = Dynamic;
    680. 

  680. 

  681. -- ----------------------------
    682. 

  682. -- Records of sys_post
    683. 

  683. -- ----------------------------
    684. 

  684. INSERT INTO `sys_post` VALUES (1, 'ceo', '董事长', 1, '0', 'admin', '2024-06-04 08:38:43', '', NULL, '');
    685. 

  685. INSERT INTO `sys_post` VALUES (2, 'se', '项目经理', 2, '0', 'admin', '2024-06-04 08:38:43', '', NULL, '');
    686. 

  686. INSERT INTO `sys_post` VALUES (3, 'hr', '人力资源', 3, '0', 'admin', '2024-06-04 08:38:43', '', NULL, '');
    687. 

  687. INSERT INTO `sys_post` VALUES (4, 'user', '普通员工', 4, '0', 'admin', '2024-06-04 08:38:43', '', NULL, '');
    688. 

  688. 

  689. -- ----------------------------
    690. 

  690. -- Table structure for sys_role
    691. 

  691. -- ----------------------------
    692. 

  692. DROP TABLE IF EXISTS `sys_role`;
    693. 

  693. CREATE TABLE `sys_role`  (
    694. 

  694.                              `role_id` bigint NOT NULL AUTO_INCREMENT COMMENT '角色ID',
    695. 

  695.                              `role_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '角色名称',
    696. 

  696.                              `role_key` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '角色权限字符串',
    697. 

  697.                              `role_sort` int NOT NULL COMMENT '显示顺序',
    698. 

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

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

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

  701.                              `status` char(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '角色状态（0正常 1停用）',
    702. 

  702.                              `del_flag` char(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
    703. 

  703.                              `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '创建者',
    704. 

  704.                              `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    705. 

  705.                              `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '更新者',
    706. 

  706.                              `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
    707. 

  707.                              `remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '备注',
    708. 

  708.                              PRIMARY KEY (`role_id`) USING BTREE
    709. 

  709. ) ENGINE = InnoDB AUTO_INCREMENT = 100 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '角色信息表' ROW_FORMAT = Dynamic;
    710. 

  710. 

  711. -- ----------------------------
    712. 

  712. -- Records of sys_role
    713. 

  713. -- ----------------------------
    714. 

  714. INSERT INTO `sys_role` VALUES (1, '超级管理员', 'admin', 1, '1', 1, 1, '0', '0', 'admin', '2024-06-04 08:38:43', '', NULL, '超级管理员');
    715. 

  715. INSERT INTO `sys_role` VALUES (2, '普通角色', 'common', 2, '2', 1, 1, '0', '0', 'admin', '2024-06-04 08:38:43', '', NULL, '普通角色');
    716. 

  716. 

  717. -- ----------------------------
    718. 

  718. -- Table structure for sys_role_dept
    719. 

  719. -- ----------------------------
    720. 

  720. DROP TABLE IF EXISTS `sys_role_dept`;
    721. 

  721. CREATE TABLE `sys_role_dept`  (
    722. 

  722.                                   `role_id` bigint NOT NULL COMMENT '角色ID',
    723. 

  723.                                   `dept_id` bigint NOT NULL COMMENT '部门ID',
    724. 

  724.                                   PRIMARY KEY (`role_id`, `dept_id`) USING BTREE
    725. 

  725. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '角色和部门关联表' ROW_FORMAT = Dynamic;
    726. 

  726. 

  727. -- ----------------------------
    728. 

  728. -- Records of sys_role_dept
    729. 

  729. -- ----------------------------
    730. 

  730. INSERT INTO `sys_role_dept` VALUES (2, 100);
    731. 

  731. INSERT INTO `sys_role_dept` VALUES (2, 101);
    732. 

  732. INSERT INTO `sys_role_dept` VALUES (2, 105);
    733. 

  733. 

  734. -- ----------------------------
    735. 

  735. -- Table structure for sys_role_menu
    736. 

  736. -- ----------------------------
    737. 

  737. DROP TABLE IF EXISTS `sys_role_menu`;
    738. 

  738. CREATE TABLE `sys_role_menu`  (
    739. 

  739.                                   `role_id` bigint NOT NULL COMMENT '角色ID',
    740. 

  740.                                   `menu_id` bigint NOT NULL COMMENT '菜单ID',
    741. 

  741.                                   PRIMARY KEY (`role_id`, `menu_id`) USING BTREE
    742. 

  742. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '角色和菜单关联表' ROW_FORMAT = Dynamic;
    743. 

  743. 

  744. -- ----------------------------
    745. 

  745. -- Records of sys_role_menu
    746. 

  746. -- ----------------------------
    747. 

  747. INSERT INTO `sys_role_menu` VALUES (2, 1);
    748. 

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

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

  750. INSERT INTO `sys_role_menu` VALUES (2, 4);
    751. 

  751. INSERT INTO `sys_role_menu` VALUES (2, 100);
    752. 

  752. INSERT INTO `sys_role_menu` VALUES (2, 101);
    753. 

  753. INSERT INTO `sys_role_menu` VALUES (2, 102);
    754. 

  754. INSERT INTO `sys_role_menu` VALUES (2, 103);
    755. 

  755. INSERT INTO `sys_role_menu` VALUES (2, 104);
    756. 

  756. INSERT INTO `sys_role_menu` VALUES (2, 105);
    757. 

  757. INSERT INTO `sys_role_menu` VALUES (2, 106);
    758. 

  758. INSERT INTO `sys_role_menu` VALUES (2, 107);
    759. 

  759. INSERT INTO `sys_role_menu` VALUES (2, 108);
    760. 

  760. INSERT INTO `sys_role_menu` VALUES (2, 109);
    761. 

  761. INSERT INTO `sys_role_menu` VALUES (2, 110);
    762. 

  762. INSERT INTO `sys_role_menu` VALUES (2, 111);
    763. 

  763. INSERT INTO `sys_role_menu` VALUES (2, 112);
    764. 

  764. INSERT INTO `sys_role_menu` VALUES (2, 113);
    765. 

  765. INSERT INTO `sys_role_menu` VALUES (2, 114);
    766. 

  766. INSERT INTO `sys_role_menu` VALUES (2, 115);
    767. 

  767. INSERT INTO `sys_role_menu` VALUES (2, 116);
    768. 

  768. INSERT INTO `sys_role_menu` VALUES (2, 117);
    769. 

  769. INSERT INTO `sys_role_menu` VALUES (2, 500);
    770. 

  770. INSERT INTO `sys_role_menu` VALUES (2, 501);
    771. 

  771. INSERT INTO `sys_role_menu` VALUES (2, 1000);
    772. 

  772. INSERT INTO `sys_role_menu` VALUES (2, 1001);
    773. 

  773. INSERT INTO `sys_role_menu` VALUES (2, 1002);
    774. 

  774. INSERT INTO `sys_role_menu` VALUES (2, 1003);
    775. 

  775. INSERT INTO `sys_role_menu` VALUES (2, 1004);
    776. 

  776. INSERT INTO `sys_role_menu` VALUES (2, 1005);
    777. 

  777. INSERT INTO `sys_role_menu` VALUES (2, 1006);
    778. 

  778. INSERT INTO `sys_role_menu` VALUES (2, 1007);
    779. 

  779. INSERT INTO `sys_role_menu` VALUES (2, 1008);
    780. 

  780. INSERT INTO `sys_role_menu` VALUES (2, 1009);
    781. 

  781. INSERT INTO `sys_role_menu` VALUES (2, 1010);
    782. 

  782. INSERT INTO `sys_role_menu` VALUES (2, 1011);
    783. 

  783. INSERT INTO `sys_role_menu` VALUES (2, 1012);
    784. 

  784. INSERT INTO `sys_role_menu` VALUES (2, 1013);
    785. 

  785. INSERT INTO `sys_role_menu` VALUES (2, 1014);
    786. 

  786. INSERT INTO `sys_role_menu` VALUES (2, 1015);
    787. 

  787. INSERT INTO `sys_role_menu` VALUES (2, 1016);
    788. 

  788. INSERT INTO `sys_role_menu` VALUES (2, 1017);
    789. 

  789. INSERT INTO `sys_role_menu` VALUES (2, 1018);
    790. 

  790. INSERT INTO `sys_role_menu` VALUES (2, 1019);
    791. 

  791. INSERT INTO `sys_role_menu` VALUES (2, 1020);
    792. 

  792. INSERT INTO `sys_role_menu` VALUES (2, 1021);
    793. 

  793. INSERT INTO `sys_role_menu` VALUES (2, 1022);
    794. 

  794. INSERT INTO `sys_role_menu` VALUES (2, 1023);
    795. 

  795. INSERT INTO `sys_role_menu` VALUES (2, 1024);
    796. 

  796. INSERT INTO `sys_role_menu` VALUES (2, 1025);
    797. 

  797. INSERT INTO `sys_role_menu` VALUES (2, 1026);
    798. 

  798. INSERT INTO `sys_role_menu` VALUES (2, 1027);
    799. 

  799. INSERT INTO `sys_role_menu` VALUES (2, 1028);
    800. 

  800. INSERT INTO `sys_role_menu` VALUES (2, 1029);
    801. 

  801. INSERT INTO `sys_role_menu` VALUES (2, 1030);
    802. 

  802. INSERT INTO `sys_role_menu` VALUES (2, 1031);
    803. 

  803. INSERT INTO `sys_role_menu` VALUES (2, 1032);
    804. 

  804. INSERT INTO `sys_role_menu` VALUES (2, 1033);
    805. 

  805. INSERT INTO `sys_role_menu` VALUES (2, 1034);
    806. 

  806. INSERT INTO `sys_role_menu` VALUES (2, 1035);
    807. 

  807. INSERT INTO `sys_role_menu` VALUES (2, 1036);
    808. 

  808. INSERT INTO `sys_role_menu` VALUES (2, 1037);
    809. 

  809. INSERT INTO `sys_role_menu` VALUES (2, 1038);
    810. 

  810. INSERT INTO `sys_role_menu` VALUES (2, 1039);
    811. 

  811. INSERT INTO `sys_role_menu` VALUES (2, 1040);
    812. 

  812. INSERT INTO `sys_role_menu` VALUES (2, 1041);
    813. 

  813. INSERT INTO `sys_role_menu` VALUES (2, 1042);
    814. 

  814. INSERT INTO `sys_role_menu` VALUES (2, 1043);
    815. 

  815. INSERT INTO `sys_role_menu` VALUES (2, 1044);
    816. 

  816. INSERT INTO `sys_role_menu` VALUES (2, 1045);
    817. 

  817. INSERT INTO `sys_role_menu` VALUES (2, 1046);
    818. 

  818. INSERT INTO `sys_role_menu` VALUES (2, 1047);
    819. 

  819. INSERT INTO `sys_role_menu` VALUES (2, 1048);
    820. 

  820. INSERT INTO `sys_role_menu` VALUES (2, 1049);
    821. 

  821. INSERT INTO `sys_role_menu` VALUES (2, 1050);
    822. 

  822. INSERT INTO `sys_role_menu` VALUES (2, 1051);
    823. 

  823. INSERT INTO `sys_role_menu` VALUES (2, 1052);
    824. 

  824. INSERT INTO `sys_role_menu` VALUES (2, 1053);
    825. 

  825. INSERT INTO `sys_role_menu` VALUES (2, 1054);
    826. 

  826. INSERT INTO `sys_role_menu` VALUES (2, 1055);
    827. 

  827. INSERT INTO `sys_role_menu` VALUES (2, 1056);
    828. 

  828. INSERT INTO `sys_role_menu` VALUES (2, 1057);
    829. 

  829. INSERT INTO `sys_role_menu` VALUES (2, 1058);
    830. 

  830. INSERT INTO `sys_role_menu` VALUES (2, 1059);
    831. 

  831. INSERT INTO `sys_role_menu` VALUES (2, 1060);
    832. 

  832. 

  833. -- ----------------------------
    834. 

  834. -- Table structure for sys_user
    835. 

  835. -- ----------------------------
    836. 

  836. DROP TABLE IF EXISTS `sys_user`;
    837. 

  837. CREATE TABLE `sys_user`  (
    838. 

  838.                              `user_id` bigint NOT NULL AUTO_INCREMENT COMMENT '用户ID',
    839. 

  839.                              `dept_id` bigint NULL DEFAULT NULL COMMENT '部门ID',
    840. 

  840.                              `user_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '用户账号',
    841. 

  841.                              `nick_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '用户昵称',
    842. 

  842.                              `user_type` varchar(2) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '00' COMMENT '用户类型（00系统用户）',
    843. 

  843.                              `email` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '用户邮箱',
    844. 

  844.                              `phonenumber` varchar(11) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '手机号码',
    845. 

  845.                              `sex` char(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '0' COMMENT '用户性别（0男 1女 2未知）',
    846. 

  846.                              `avatar` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '头像地址',
    847. 

  847.                              `password` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '密码',
    848. 

  848.                              `status` char(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '0' COMMENT '帐号状态（0正常 1停用）',
    849. 

  849.                              `del_flag` char(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
    850. 

  850.                              `login_ip` varchar(128) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '最后登录IP',
    851. 

  851.                              `login_date` datetime NULL DEFAULT NULL COMMENT '最后登录时间',
    852. 

  852.                              `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '创建者',
    853. 

  853.                              `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    854. 

  854.                              `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '更新者',
    855. 

  855.                              `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
    856. 

  856.                              `remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '备注',
    857. 

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

  858. ) ENGINE = InnoDB AUTO_INCREMENT = 100 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '用户信息表' ROW_FORMAT = Dynamic;
    859. 

  859. 

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

  861. -- Records of sys_user
    862. 

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

  863. INSERT INTO `sys_user` VALUES (1, 103, 'admin', 'admin', '00', 'ry@163.com', '15888888888', '1', '', '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', '0', '0', '127.0.0.1', '2024-06-05 20:22:26', 'admin', '2024-06-04 08:38:43', '', '2024-06-05 12:22:25', '管理员');
    864. 

  864. 

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

  866. -- Table structure for sys_user_post
    867. 

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

  868. DROP TABLE IF EXISTS `sys_user_post`;
    869. 

  869. CREATE TABLE `sys_user_post`  (
    870. 

  870.                                   `user_id` bigint NOT NULL COMMENT '用户ID',
    871. 

  871.                                   `post_id` bigint NOT NULL COMMENT '岗位ID',
    872. 

  872.                                   PRIMARY KEY (`user_id`, `post_id`) USING BTREE
    873. 

  873. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '用户与岗位关联表' ROW_FORMAT = Dynamic;
    874. 

  874. 

  875. -- ----------------------------
    876. 

  876. -- Records of sys_user_post
    877. 

  877. -- ----------------------------
    878. 

  878. INSERT INTO `sys_user_post` VALUES (1, 1);
    879. 

  879. INSERT INTO `sys_user_post` VALUES (2, 2);
    880. 

  880. 

  881. -- ----------------------------
    882. 

  882. -- Table structure for sys_user_role
    883. 

  883. -- ----------------------------
    884. 

  884. DROP TABLE IF EXISTS `sys_user_role`;
    885. 

  885. CREATE TABLE `sys_user_role`  (
    886. 

  886.                                   `user_id` bigint NOT NULL COMMENT '用户ID',
    887. 

  887.                                   `role_id` bigint NOT NULL COMMENT '角色ID',
    888. 

  888.                                   PRIMARY KEY (`user_id`, `role_id`) USING BTREE
    889. 

  889. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '用户和角色关联表' ROW_FORMAT = Dynamic;
    890. 

  890. 

  891. -- ----------------------------
    892. 

  892. -- Records of sys_user_role
    893. 

  893. -- ----------------------------
    894. 

  894. INSERT INTO `sys_user_role` VALUES (1, 1);
    895. 

  895. INSERT INTO `sys_user_role` VALUES (2, 2);
    896. 

  896. 

  897. -- ----------------------------
    898. 

  898. -- Table structure for t_algorithm
    899. 

  899. -- ----------------------------
    900. 

  900. DROP TABLE IF EXISTS `t_algorithm`;
    901. 

  901. CREATE TABLE `t_algorithm`  (
    902. 

  902.                                 `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
    903. 

  903.                                 `type` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '算法类型',
    904. 

  904.                                 `sub_type_id` bigint NOT NULL COMMENT '子类型id',
    905. 

  905.                                 `name` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '名称',
    906. 

  906.                                 `status` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '算法运行状态',
    907. 

  907.                                 `error` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '算法错误原因',
    908. 

  908.                                 `sub_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '算法子类型名称',
    909. 

  909.                                 `start_time` datetime NULL DEFAULT NULL COMMENT '开始时间',
    910. 

  910.                                 `completed_time` datetime NULL DEFAULT NULL COMMENT '完成时间',
    911. 

  911.                                 `cost_second` int NULL DEFAULT NULL COMMENT '耗时(s)',
    912. 

  912.                                 `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '创建者',
    913. 

  913.                                 `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    914. 

  914.                                 `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '更新者',
    915. 

  915.                                 `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
    916. 

  916.                                 `remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '备注',
    917. 

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

  918. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '算法表' ROW_FORMAT = Dynamic;
    919. 

  919. 

  920. -- ----------------------------
    921. 

  921. -- Records of t_algorithm
    922. 

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

  923. INSERT INTO `t_algorithm` VALUES (2, '2', 3, 'FUNmain1', '2', NULL, NULL, '2024-06-05 20:44:07', '2024-06-05 20:44:25', 18, '', '2024-06-05 20:43:58', '', NULL, NULL);
    924. 

  924. INSERT INTO `t_algorithm` VALUES (4, '4', 4, 'turn-fine1', '2', NULL, NULL, '2024-06-05 20:58:03', '2024-06-05 20:58:39', 36, '', '2024-06-05 20:57:57', '', NULL, NULL);
    925. 

  925. INSERT INTO `t_algorithm` VALUES (5, '5', 1, 'GWO-SVM1', '2', NULL, NULL, '2024-06-05 21:00:30', '2024-06-05 21:00:37', 7, '', '2024-06-05 21:00:25', '', NULL, NULL);
    926. 

  926. INSERT INTO `t_algorithm` VALUES (6, '6', 5, 'GWO-SVR1', '2', NULL, NULL, '2024-06-05 21:06:16', '2024-06-05 21:06:30', 14, '', '2024-06-05 21:06:11', '', NULL, NULL);
    927. 

  927. 

  928. -- ----------------------------
    929. 

  929. -- Table structure for t_algorithm_io_field
    930. 

  930. -- ----------------------------
    931. 

  931. DROP TABLE IF EXISTS `t_algorithm_io_field`;
    932. 

  932. CREATE TABLE `t_algorithm_io_field`  (
    933. 

  933.                                          `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
    934. 

  934.                                          `algorithm_sub_id` bigint NOT NULL COMMENT '算法子类型编号',
    935. 

  935.                                          `type` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '输入/输出',
    936. 

  936.                                          `name` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '名称',
    937. 

  937.                                          `index` int NULL DEFAULT 0 COMMENT '排序',
    938. 

  938.                                          `sub_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '算法子类型名称',
    939. 

  939.                                          `matlab_io_path` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT 'matlab文件独有的输入输入路径',
    940. 

  940.                                          `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '创建者',
    941. 

  941.                                          `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    942. 

  942.                                          `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '更新者',
    943. 

  943.                                          `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
    944. 

  944.                                          `remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '备注',
    945. 

  945.                                          PRIMARY KEY (`id`) USING BTREE
    946. 

  946. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '算法输入输出字段表' ROW_FORMAT = Dynamic;
    947. 

  947. 

  948. -- ----------------------------
    949. 

  949. -- Records of t_algorithm_io_field
    950. 

  950. -- ----------------------------
    951. 

  951. INSERT INTO `t_algorithm_io_field` VALUES (1, 1, '1', 'input1', 1, NULL, 'D:\\pdaaphm\\data\\matlab\\GWO_SVM_exmp', '', '2024-06-05 17:31:01', '', NULL, NULL);
    952. 

  952. INSERT INTO `t_algorithm_io_field` VALUES (2, 1, '2', 'output1', 1, NULL, 'D:\\pdaaphm\\data\\matlab\\GWO_SVM_exmp', '', '2024-06-05 17:32:49', '', NULL, NULL);
    953. 

  953. INSERT INTO `t_algorithm_io_field` VALUES (3, 1, '2', 'output2', 2, NULL, 'D:\\pdaaphm\\data\\matlab\\GWO_SVM_exmp', '', '2024-06-05 17:33:01', '', '2024-06-05 17:33:09', NULL);
    954. 

  954. INSERT INTO `t_algorithm_io_field` VALUES (4, 3, '1', 'input1', 1, NULL, 'D:\\pdaaphm\\data\\matlab\\FUNmain', '', '2024-06-05 20:40:46', '', NULL, NULL);
    955. 

  955. INSERT INTO `t_algorithm_io_field` VALUES (5, 3, '2', 'output1', 1, NULL, 'D:\\pdaaphm\\data\\matlab\\FUNmain', '', '2024-06-05 20:40:59', '', NULL, NULL);
    956. 

  956. INSERT INTO `t_algorithm_io_field` VALUES (6, 3, '2', 'output2', 2, NULL, 'D:\\pdaaphm\\data\\matlab\\FUNmain', '', '2024-06-05 20:41:11', '', NULL, NULL);
    957. 

  957. INSERT INTO `t_algorithm_io_field` VALUES (7, 3, '2', 'output3', 3, NULL, 'D:\\pdaaphm\\data\\matlab\\FUNmain', '', '2024-06-05 20:41:21', '', NULL, NULL);
    958. 

  958. INSERT INTO `t_algorithm_io_field` VALUES (8, 4, '1', 'input1', 1, NULL, NULL, '', '2024-06-05 20:50:41', '', NULL, NULL);
    959. 

  959. INSERT INTO `t_algorithm_io_field` VALUES (9, 4, '2', 'output1', 1, NULL, NULL, '', '2024-06-05 20:50:54', '', NULL, NULL);
    960. 

  960. INSERT INTO `t_algorithm_io_field` VALUES (10, 5, '1', 'input1', 1, NULL, 'D:\\pdaaphm\\data\\matlab\\GWO_SVR_exmp', '', '2024-06-05 21:04:39', '', NULL, NULL);
    961. 

  961. INSERT INTO `t_algorithm_io_field` VALUES (11, 5, '2', 'output1', 1, NULL, 'D:\\pdaaphm\\data\\matlab\\GWO_SVR_exmp', '', '2024-06-05 21:04:54', '', NULL, NULL);
    962. 

  962. INSERT INTO `t_algorithm_io_field` VALUES (12, 5, '2', 'output2', 2, NULL, 'D:\\pdaaphm\\data\\matlab\\GWO_SVR_exmp', '', '2024-06-05 21:05:08', '', NULL, NULL);
    963. 

  963. INSERT INTO `t_algorithm_io_field` VALUES (13, 5, '2', 'output3', 3, NULL, 'D:\\pdaaphm\\data\\matlab\\GWO_SVR_exmp', '', '2024-06-05 21:05:16', '', NULL, NULL);
    964. 

  964. 

  965. -- ----------------------------
    966. 

  966. -- Table structure for t_algorithm_sub_type
    967. 

  967. -- ----------------------------
    968. 

  968. DROP TABLE IF EXISTS `t_algorithm_sub_type`;
    969. 

  969. CREATE TABLE `t_algorithm_sub_type`  (
    970. 

  970.                                          `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
    971. 

  971.                                          `type` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '类型',
    972. 

  972.                                          `name` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '算法子名称',
    973. 

  973.                                          `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '算法url',
    974. 

  974.                                          `run_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '运行类型',
    975. 

  975.                                          `data_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '数据类型',
    976. 

  976.                                          `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '创建者',
    977. 

  977.                                          `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    978. 

  978.                                          `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '更新者',
    979. 

  979.                                          `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
    980. 

  980.                                          `remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '备注',
    981. 

  981.                                          PRIMARY KEY (`id`) USING BTREE
    982. 

  982. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '算法子类型表' ROW_FORMAT = Dynamic;
    983. 

  983. 

  984. -- ----------------------------
    985. 

  985. -- Records of t_algorithm_sub_type
    986. 

  986. -- ----------------------------
    987. 

  987. INSERT INTO `t_algorithm_sub_type` VALUES (1, '5', 'GWO-SVM', 'D:\\pdaaphm\\matlabexe\\GWO_SVM_exmp.exe', '2', '0', '', '2024-06-05 17:25:29', '', NULL, NULL);
    988. 

  988. INSERT INTO `t_algorithm_sub_type` VALUES (3, '2', '纯数据驱动【多项式】_FUNmain', 'D:\\pdaaphm\\matlabexe\\FUNmain.exe', '2', '4', '', '2024-06-05 20:40:12', '', NULL, NULL);
    989. 

  989. INSERT INTO `t_algorithm_sub_type` VALUES (4, '4', 'turn-fine迁移学习寿命预测(氧分压信号预测)', 'http://127.0.0.1:10005', '1', '4', '', '2024-06-05 20:49:52', '', NULL, NULL);
    990. 

  990. INSERT INTO `t_algorithm_sub_type` VALUES (5, '6', 'GWO-SVR', 'D:\\pdaaphm\\matlabexe\\GWO_SVR_exmp.exe', '2', '0', '', '2024-06-05 21:04:25', '', NULL, NULL);
    991. 

  991. 

  992. -- ----------------------------
    993. 

  993. -- Table structure for t_file
    994. 

  994. -- ----------------------------
    995. 

  995. DROP TABLE IF EXISTS `t_file`;
    996. 

  996. CREATE TABLE `t_file`  (
    997. 

  997.                            `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
    998. 

  998.                            `name` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '文档名称',
    999. 

  999.                            `path` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '文档路径',
    1000. 

  1000.                            `type` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '类型',
    1001. 

  1001.                            `data_type` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '数据类型',
    1002. 

  1002.                            `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '创建者',
    1003. 

  1003.                            `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    1004. 

  1004.                            `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '更新者',
    1005. 

  1005.                            `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
    1006. 

  1006.                            `remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '备注',
    1007. 

  1007.                            PRIMARY KEY (`id`) USING BTREE
    1008. 

  1008. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '文件表' ROW_FORMAT = Dynamic;
    1009. 

  1009. 

  1010. -- ----------------------------
    1011. 

  1011. -- Records of t_file
    1012. 

  1012. -- ----------------------------
    1013. 

  1013. INSERT INTO `t_file` VALUES (1, 'FUNmain_input1.mat', '/profile/upload/2024/06/05/input1_20240605170646A001.mat', '1', '4', '', '2024-06-05 17:20:56', '', '2024-06-05 20:43:34', NULL);
    1014. 

  1014. INSERT INTO `t_file` VALUES (2, 'result1_20240605173719A002.txt', '/resultPath/result/2024/06/05/result1_20240605173719A002.txt', '2', NULL, '', '2024-06-05 17:37:52', '', NULL, NULL);
    1015. 

  1015. INSERT INTO `t_file` VALUES (3, 'result2_20240605173719A003.jpg', '/resultPath/result/2024/06/05/result2_20240605173719A003.jpg', '2', NULL, '', '2024-06-05 17:37:53', '', NULL, NULL);
    1016. 

  1016. INSERT INTO `t_file` VALUES (4, 'result1_20240605173821A004.txt', '/resultPath/result/2024/06/05/result1_20240605173821A004.txt', '2', NULL, '', '2024-06-05 17:38:28', '', NULL, NULL);
    1017. 

  1017. INSERT INTO `t_file` VALUES (5, 'result2_20240605173821A005.jpg', '/resultPath/result/2024/06/05/result2_20240605173821A005.jpg', '2', NULL, '', '2024-06-05 17:38:28', '', NULL, NULL);
    1018. 

  1018. INSERT INTO `t_file` VALUES (6, 'GWO-SVM_input1.mat', '/profile/upload/2024/06/05/input1_20240605204202A006.mat', '1', '0', '', '2024-06-05 20:42:03', '', '2024-06-05 20:43:29', NULL);
    1019. 

  1019. INSERT INTO `t_file` VALUES (7, 'result1_20240605204406A007.txt', '/resultPath/result/2024/06/05/result1_20240605204406A007.txt', '2', NULL, '', '2024-06-05 20:44:25', '', NULL, NULL);
    1020. 

  1020. INSERT INTO `t_file` VALUES (8, 'result2_20240605204406A008.jpg', '/resultPath/result/2024/06/05/result2_20240605204406A008.jpg', '2', NULL, '', '2024-06-05 20:44:25', '', NULL, NULL);
    1021. 

  1021. INSERT INTO `t_file` VALUES (9, 'result3_20240605204406A009.jpg', '/resultPath/result/2024/06/05/result3_20240605204406A009.jpg', '2', NULL, '', '2024-06-05 20:44:25', '', NULL, NULL);
    1022. 

  1022. INSERT INTO `t_file` VALUES (10, 'result1_20240605204538A010.txt', '/resultPath/result/2024/06/05/result1_20240605204538A010.txt', '2', NULL, '', '2024-06-05 20:45:45', '', NULL, NULL);
    1023. 

  1023. INSERT INTO `t_file` VALUES (11, 'result2_20240605204538A011.jpg', '/resultPath/result/2024/06/05/result2_20240605204538A011.jpg', '2', NULL, '', '2024-06-05 20:45:45', '', NULL, NULL);
    1024. 

  1024. INSERT INTO `t_file` VALUES (12, '氧浓器氧分压变化数据.csv', '/profile/upload/2024/06/05/氧浓器氧分压变化数据_20240605204924A012.csv', '1', '4', '', '2024-06-05 20:49:27', '', NULL, NULL);
    1025. 

  1025. INSERT INTO `t_file` VALUES (13, 'result1_20240605205802A016.jpg', '/resultPath/result/2024/06/05/result1_20240605205802A016.jpg', '2', NULL, '', '2024-06-05 20:58:39', '', NULL, NULL);
    1026. 

  1026. INSERT INTO `t_file` VALUES (14, 'result1_20240605210030A017.txt', '/resultPath/result/2024/06/05/result1_20240605210030A017.txt', '2', NULL, '', '2024-06-05 21:00:37', '', NULL, NULL);
    1027. 

  1027. INSERT INTO `t_file` VALUES (15, 'result2_20240605210030A018.jpg', '/resultPath/result/2024/06/05/result2_20240605210030A018.jpg', '2', NULL, '', '2024-06-05 21:00:37', '', NULL, NULL);
    1028. 

  1028. INSERT INTO `t_file` VALUES (16, 'GWO-SVR_input1', '/profile/upload/2024/06/05/input1_20240605210252A019.mat', '1', '0', '', '2024-06-05 21:02:54', '', NULL, NULL);
    1029. 

  1029. INSERT INTO `t_file` VALUES (17, 'result1_20240605210616A020.txt', '/resultPath/result/2024/06/05/result1_20240605210616A020.txt', '2', NULL, '', '2024-06-05 21:06:30', '', NULL, NULL);
    1030. 

  1030. INSERT INTO `t_file` VALUES (18, 'result2_20240605210616A021.jpg', '/resultPath/result/2024/06/05/result2_20240605210616A021.jpg', '2', NULL, '', '2024-06-05 21:06:30', '', NULL, NULL);
    1031. 

  1031. INSERT INTO `t_file` VALUES (19, 'result3_20240605210616A022.jpg', '/resultPath/result/2024/06/05/result3_20240605210616A022.jpg', '2', NULL, '', '2024-06-05 21:06:30', '', NULL, NULL);
    1032. 

  1032. 

  1033. -- ----------------------------
    1034. 

  1034. -- Table structure for t_sub_algorithm
    1035. 

  1035. -- ----------------------------
    1036. 

  1036. DROP TABLE IF EXISTS `t_sub_algorithm`;
    1037. 

  1037. CREATE TABLE `t_sub_algorithm`  (
    1038. 

  1038.                                     `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
    1039. 

  1039.                                     `algorithm_id` bigint NOT NULL COMMENT '主表id',
    1040. 

  1040.                                     `field_id` bigint NOT NULL COMMENT '字段id',
    1041. 

  1041.                                     `upload_id` bigint NULL DEFAULT NULL COMMENT '文件id',
    1042. 

  1042.                                     `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '创建者',
    1043. 

  1043.                                     `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    1044. 

  1044.                                     `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '更新者',
    1045. 

  1045.                                     `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
    1046. 

  1046.                                     `remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '备注',
    1047. 

  1047.                                     PRIMARY KEY (`id`) USING BTREE
    1048. 

  1048. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '算法子表' ROW_FORMAT = Dynamic;
    1049. 

  1049. 

  1050. -- ----------------------------
    1051. 

  1051. -- Records of t_sub_algorithm
    1052. 

  1052. -- ----------------------------
    1053. 

  1053. INSERT INTO `t_sub_algorithm` VALUES (1, 1, 1, 1, '', NULL, '', NULL, NULL);
    1054. 

  1054. INSERT INTO `t_sub_algorithm` VALUES (2, 1, 2, 10, '', '2024-06-05 20:45:45', '', NULL, NULL);
    1055. 

  1055. INSERT INTO `t_sub_algorithm` VALUES (3, 1, 3, 11, '', '2024-06-05 20:45:45', '', NULL, NULL);
    1056. 

  1056. INSERT INTO `t_sub_algorithm` VALUES (4, 2, 4, 1, '', NULL, '', NULL, NULL);
    1057. 

  1057. INSERT INTO `t_sub_algorithm` VALUES (5, 2, 5, 7, '', '2024-06-05 20:44:25', '', NULL, NULL);
    1058. 

  1058. INSERT INTO `t_sub_algorithm` VALUES (6, 2, 6, 8, '', '2024-06-05 20:44:25', '', NULL, NULL);
    1059. 

  1059. INSERT INTO `t_sub_algorithm` VALUES (7, 2, 7, 9, '', '2024-06-05 20:44:25', '', NULL, NULL);
    1060. 

  1060. INSERT INTO `t_sub_algorithm` VALUES (8, 3, 8, 12, '', NULL, '', NULL, NULL);
    1061. 

  1061. INSERT INTO `t_sub_algorithm` VALUES (9, 3, 9, NULL, '', NULL, '', NULL, NULL);
    1062. 

  1062. INSERT INTO `t_sub_algorithm` VALUES (10, 4, 8, 12, '', NULL, '', NULL, NULL);
    1063. 

  1063. INSERT INTO `t_sub_algorithm` VALUES (11, 4, 9, 13, '', '2024-06-05 20:58:39', '', NULL, NULL);
    1064. 

  1064. INSERT INTO `t_sub_algorithm` VALUES (12, 5, 1, 6, '', NULL, '', NULL, NULL);
    1065. 

  1065. INSERT INTO `t_sub_algorithm` VALUES (13, 5, 2, 14, '', '2024-06-05 21:00:37', '', NULL, NULL);
    1066. 

  1066. INSERT INTO `t_sub_algorithm` VALUES (14, 5, 3, 15, '', '2024-06-05 21:00:37', '', NULL, NULL);
    1067. 

  1067. INSERT INTO `t_sub_algorithm` VALUES (15, 6, 10, 16, '', NULL, '', NULL, NULL);
    1068. 

  1068. INSERT INTO `t_sub_algorithm` VALUES (16, 6, 11, 17, '', '2024-06-05 21:06:30', '', NULL, NULL);
    1069. 

  1069. INSERT INTO `t_sub_algorithm` VALUES (17, 6, 12, 18, '', '2024-06-05 21:06:30', '', NULL, NULL);
    1070. 

  1070. INSERT INTO `t_sub_algorithm` VALUES (18, 6, 13, 19, '', '2024-06-05 21:06:30', '', NULL, NULL);
    1071. 

  1071. 

  1072. SET FOREIGN_KEY_CHECKS = 1;
    1073. 

  1073. 

  1074. DROP TABLE
    1075. 

  1075. IF
    1076. 

  1076. 	EXISTS t_data;
    1077. 

  1077. CREATE TABLE t_data (
    1078. 

  1078. 	id BIGINT ( 20 ) NOT NULL auto_increment COMMENT '编号',
    1079. 

  1079. 	data_name VARCHAR ( 255 ) COMMENT '数据名称',
    1080. 

  1080. 	data_type VARCHAR ( 64 ) COMMENT '数据类型（1原始，2补全结果，3扩充结果，4特称提取结果，5退化评估结果，6故障预测结果）',
    1081. 

  1081. 	data_path VARCHAR ( 255 ) COMMENT '数据路径',
    1082. 

  1082. 	image_path VARCHAR ( 255 ) COMMENT '图片路径',
    1083. 

  1083. 	create_by VARCHAR ( 64 ) DEFAULT '' COMMENT '创建者',
    1084. 

  1084. 	create_time datetime COMMENT '创建时间',
    1085. 

  1085. 	update_by VARCHAR ( 64 ) DEFAULT '' COMMENT '更新者',
    1086. 

  1086. 	update_time datetime COMMENT '更新时间',
    1087. 

  1087. 	remark VARCHAR ( 500 ) DEFAULT NULL COMMENT '备注',
    1088. 

  1088. PRIMARY KEY ( id )
    1089. 

  1089. ) ENGINE = INNODB COMMENT = '数据存储表';
    1090. 

  1090. 

  1091. DROP TABLE
    1092. 

  1092. IF
    1093. 

  1093. 	EXISTS t_data_process;
    1094. 

  1094. CREATE TABLE t_data_process (
    1095. 

  1095. 	id BIGINT ( 20 ) NOT NULL auto_increment COMMENT '编号',
    1096. 

  1096. 	process_type VARCHAR ( 64 ) DEFAULT '' COMMENT '数据类型（1补全，2扩充，3特称提取，4退化评估，5故障预测）',
    1097. 

  1097. 	process_alg_id BIGINT ( 20 ) NOT NULL COMMENT '处理的算法id',
    1098. 

  1098. 	processed_data_id BIGINT ( 20 ) NOT NULL COMMENT '被处理数据id',
    1099. 

  1099. 	result_data_id BIGINT ( 20 ) COMMENT '处理结果数据id',
    1100. 

  1100. 	process_status VARCHAR ( 64 ) DEFAULT '' COMMENT '状态（1待处理，2处理中，3已完成，4失败）',
    1101. 

  1101. 	start_time datetime COMMENT '开始时间',
    1102. 

  1102. 	end_time datetime COMMENT '结束时间',
    1103. 

  1103. 	log text COMMENT '日志',
    1104. 

  1104. 	create_by VARCHAR ( 64 ) DEFAULT '' COMMENT '创建者',
    1105. 

  1105. 	create_time datetime COMMENT '创建时间',
    1106. 

  1106. 	update_by VARCHAR ( 64 ) DEFAULT '' COMMENT '更新者',
    1107. 

  1107. 	update_time datetime COMMENT '更新时间',
    1108. 

  1108. 	remark VARCHAR ( 500 ) DEFAULT NULL COMMENT '备注',
    1109. 

  1109. PRIMARY KEY ( id )
    1110. 

  1110. ) ENGINE = INNODB COMMENT = '数据处理表';
    1111. 

  1111. 

  1112. DROP TABLE
    1113. 

  1113. IF
    1114. 

  1114. 	EXISTS t_alg_config;
    1115. 

  1115. CREATE TABLE t_alg_config (
    1116. 

  1116. 	id BIGINT ( 20 ) NOT NULL auto_increment COMMENT '编号',
    1117. 

  1117. 	alg_name VARCHAR ( 64 ) DEFAULT '' COMMENT '算法名称',
    1118. 

  1118. 	alg_type VARCHAR ( 64 ) DEFAULT '' COMMENT '算发类型（1补全，2扩充，3特称提取，4退化评估，5故障预测）',
    1119. 

  1119. 	alg_url VARCHAR ( 255 ) NOT NULL COMMENT '处理的算法',
    1120. 

  1120. 	create_by VARCHAR ( 64 ) DEFAULT '' COMMENT '创建者',
    1121. 

  1121. 	create_time datetime COMMENT '创建时间',
    1122. 

  1122. 	update_by VARCHAR ( 64 ) DEFAULT '' COMMENT '更新者',
    1123. 

  1123. 	update_time datetime COMMENT '更新时间',
    1124. 

  1124. 	remark VARCHAR ( 500 ) DEFAULT NULL COMMENT '备注',
    1125. 

  1125. PRIMARY KEY ( id )
    1126. 

  1126. ) ENGINE = INNODB COMMENT = '算法配置表';
    1127. 

  1127. -- 菜单 SQL
    1128. 

  1128. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    1129. 

  1129. values('数据处理', '3', '1', 'process', 'system/process/index', 1, 0, 'C', '0', '0', 'system:process:list', '#', 'admin', sysdate(), '', null, '数据处理菜单');
    1130. 

  1130. 

  1131. -- 按钮父菜单ID
    1132. 

  1132. SELECT @parentId := LAST_INSERT_ID();
    1133. 

  1133. 

  1134. -- 按钮 SQL
    1135. 

  1135. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    1136. 

  1136. values('数据处理查询', @parentId, '1',  '#', '', 1, 0, 'F', '0', '0', 'system:process:query',        '#', 'admin', sysdate(), '', null, '');
    1137. 

  1137. 

  1138. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    1139. 

  1139. values('数据处理新增', @parentId, '2',  '#', '', 1, 0, 'F', '0', '0', 'system:process:add',          '#', 'admin', sysdate(), '', null, '');
    1140. 

  1140. 

  1141. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    1142. 

  1142. values('数据处理修改', @parentId, '3',  '#', '', 1, 0, 'F', '0', '0', 'system:process:edit',         '#', 'admin', sysdate(), '', null, '');
    1143. 

  1143. 

  1144. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    1145. 

  1145. values('数据处理删除', @parentId, '4',  '#', '', 1, 0, 'F', '0', '0', 'system:process:remove',       '#', 'admin', sysdate(), '', null, '');
    1146. 

  1146. 

  1147. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    1148. 

  1148. values('数据处理导出', @parentId, '5',  '#', '', 1, 0, 'F', '0', '0', 'system:process:export',       '#', 'admin', sysdate(), '', null, '');
    1149. 

  1149. 

  1150. -- 菜单 SQL
    1151. 

  1151. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    1152. 

  1152. values('数据管理', '2000', '1', 'data', 'system/data/index', 1, 0, 'C', '0', '0', 'system:data:list', '#', 'admin', sysdate(), '', null, '数据管理菜单');
    1153. 

  1153. 

  1154. -- 按钮父菜单ID
    1155. 

  1155. SELECT @parentId := LAST_INSERT_ID();
    1156. 

  1156. 

  1157. -- 按钮 SQL
    1158. 

  1158. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    1159. 

  1159. values('数据管理查询', @parentId, '1',  '#', '', 1, 0, 'F', '0', '0', 'system:data:query',        '#', 'admin', sysdate(), '', null, '');
    1160. 

  1160. 

  1161. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    1162. 

  1162. values('数据管理新增', @parentId, '2',  '#', '', 1, 0, 'F', '0', '0', 'system:data:add',          '#', 'admin', sysdate(), '', null, '');
    1163. 

  1163. 

  1164. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    1165. 

  1165. values('数据管理修改', @parentId, '3',  '#', '', 1, 0, 'F', '0', '0', 'system:data:edit',         '#', 'admin', sysdate(), '', null, '');
    1166. 

  1166. 

  1167. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    1168. 

  1168. values('数据管理删除', @parentId, '4',  '#', '', 1, 0, 'F', '0', '0', 'system:data:remove',       '#', 'admin', sysdate(), '', null, '');
    1169. 

  1169. 

  1170. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    1171. 

  1171. values('数据管理导出', @parentId, '5',  '#', '', 1, 0, 'F', '0', '0', 'system:data:export',       '#', 'admin', sysdate(), '', null, '');
    1172. 

  1172. 

  1173. -- 菜单 SQL
    1174. 

  1174. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    1175. 

  1175. values('算法配置', '2001', '1', 'algConfig', 'system/algConfig/index', 1, 0, 'C', '0', '0', 'system:algConfig:list', '#', 'admin', sysdate(), '', null, '算法配置菜单');
    1176. 

  1176. 

  1177. -- 按钮父菜单ID
    1178. 

  1178. SELECT @parentId := LAST_INSERT_ID();
    1179. 

  1179. 

  1180. -- 按钮 SQL
    1181. 

  1181. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    1182. 

  1182. values('算法配置查询', @parentId, '1',  '#', '', 1, 0, 'F', '0', '0', 'system:algConfig:query',        '#', 'admin', sysdate(), '', null, '');
    1183. 

  1183. 

  1184. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    1185. 

  1185. values('算法配置新增', @parentId, '2',  '#', '', 1, 0, 'F', '0', '0', 'system:algConfig:add',          '#', 'admin', sysdate(), '', null, '');
    1186. 

  1186. 

  1187. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    1188. 

  1188. values('算法配置修改', @parentId, '3',  '#', '', 1, 0, 'F', '0', '0', 'system:algConfig:edit',         '#', 'admin', sysdate(), '', null, '');
    1189. 

  1189. 

  1190. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    1191. 

  1191. values('算法配置删除', @parentId, '4',  '#', '', 1, 0, 'F', '0', '0', 'system:algConfig:remove',       '#', 'admin', sysdate(), '', null, '');
    1192. 

  1192. 

  1193. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    1194. 

  1194. values('算法配置导出', @parentId, '5',  '#', '', 1, 0, 'F', '0', '0', 'system:algConfig:export',       '#', 'admin', sysdate(), '', null, '');
    1195.