From 5f5944161eb6c8abdfd0c49db47636385277bd36 Mon Sep 17 00:00:00 2001
From: xiangpei <xiangpei@timesnew.cn>
Date: 星期五, 12 四月 2024 16:23:06 +0800
Subject: [PATCH] sql备份
---
sql/zgyw0412.sql | 68 ++++++++++++++++++++++++---------
1 files changed, 49 insertions(+), 19 deletions(-)
diff --git a/sql/zgyw0412.sql b/sql/zgyw0412.sql
index 8562d5d..5b7083c 100644
--- a/sql/zgyw0412.sql
+++ b/sql/zgyw0412.sql
@@ -11,7 +11,7 @@
Target Server Version : 80300
File Encoding : 65001
- Date: 12/04/2024 09:18:39
+ Date: 12/04/2024 16:22:00
*/
SET NAMES utf8mb4;
@@ -677,7 +677,7 @@
`update_time` datetime NULL DEFAULT NULL COMMENT '鏇存柊鏃堕棿',
`remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '澶囨敞',
PRIMARY KEY (`dict_code`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 128 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '瀛楀吀鏁版嵁琛�' ROW_FORMAT = DYNAMIC;
+) ENGINE = InnoDB AUTO_INCREMENT = 130 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '瀛楀吀鏁版嵁琛�' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of sys_dict_data
@@ -720,7 +720,7 @@
INSERT INTO `sys_dict_data` VALUES (106, 3, '鏈堝害鑰冩牳', '2', 'platform_examine_frequency', NULL, 'default', 'N', '0', 'admin', '2024-03-07 10:26:48', 'admin', '2024-03-29 16:14:05', NULL);
INSERT INTO `sys_dict_data` VALUES (107, 4, '瀛ｅ害鑰冩牳', '3', 'platform_examine_frequency', NULL, 'default', 'N', '0', 'admin', '2024-03-07 10:26:59', 'admin', '2024-03-29 16:14:08', NULL);
INSERT INTO `sys_dict_data` VALUES (108, 1, '鐪佸巺鑰冩牳', '0', 'platform_examine_category', NULL, 'default', 'N', '0', 'admin', '2024-03-13 10:59:58', 'admin', '2024-03-29 16:14:26', NULL);
-INSERT INTO `sys_dict_data` VALUES (109, 2, '鍖哄煙鑰冩牳', '1', 'platform_examine_category', NULL, 'default', 'N', '0', 'admin', '2024-03-13 11:00:05', 'admin', '2024-03-29 16:14:49', NULL);
+INSERT INTO `sys_dict_data` VALUES (109, 2, '甯傚眬鑰冩牳', '1', 'platform_examine_category', NULL, 'default', 'N', '0', 'admin', '2024-03-13 11:00:05', 'admin', '2024-04-12 03:22:48', NULL);
INSERT INTO `sys_dict_data` VALUES (110, 0, '寰呭鏍� ', '0', 'platform_audit_state', NULL, 'primary', 'N', '0', 'admin', '2024-03-18 11:12:11', 'admin', '2024-03-18 11:12:17', NULL);
INSERT INTO `sys_dict_data` VALUES (111, 0, '閫氳繃', '1', 'platform_audit_state', NULL, 'success', 'N', '0', 'admin', '2024-03-18 11:12:33', '', NULL, NULL);
INSERT INTO `sys_dict_data` VALUES (112, 0, '鏈�氳繃', '2', 'platform_audit_state', NULL, 'danger', 'N', '0', 'admin', '2024-03-18 11:12:50', 'admin', '2024-03-18 11:12:54', NULL);
@@ -758,7 +758,7 @@
`remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '澶囨敞',
PRIMARY KEY (`dict_id`) USING BTREE,
UNIQUE INDEX `dict_type`(`dict_type` ASC) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 110 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '瀛楀吀绫诲瀷琛�' ROW_FORMAT = DYNAMIC;
+) ENGINE = InnoDB AUTO_INCREMENT = 111 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '瀛楀吀绫诲瀷琛�' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of sys_dict_type
@@ -830,7 +830,7 @@
PRIMARY KEY (`info_id`) USING BTREE,
INDEX `idx_sys_logininfor_s`(`status` ASC) USING BTREE,
INDEX `idx_sys_logininfor_lt`(`login_time` ASC) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 691 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '绯荤粺璁块棶璁板綍' ROW_FORMAT = DYNAMIC;
+) ENGINE = InnoDB AUTO_INCREMENT = 751 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '绯荤粺璁块棶璁板綍' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of sys_logininfor
@@ -1462,6 +1462,30 @@
INSERT INTO `sys_logininfor` VALUES (724, 'zgga', '127.0.0.1', '鍐呯綉IP', 'Chrome 12', 'Windows 10', '0', '鐧诲綍鎴愬姛', '2024-04-12 01:12:15');
INSERT INTO `sys_logininfor` VALUES (725, 'zgga', '127.0.0.1', '鍐呯綉IP', 'Chrome 12', 'Windows 10', '0', '閫�鍑烘垚鍔�', '2024-04-12 01:16:54');
INSERT INTO `sys_logininfor` VALUES (726, 'admin', '127.0.0.1', '鍐呯綉IP', 'Chrome 12', 'Windows 10', '0', '鐧诲綍鎴愬姛', '2024-04-12 01:17:03');
+INSERT INTO `sys_logininfor` VALUES (727, 'admin', '127.0.0.1', '鍐呯綉IP', 'Chrome 12', 'Windows 10', '0', '鐧诲綍鎴愬姛', '2024-04-12 02:56:17');
+INSERT INTO `sys_logininfor` VALUES (728, 'admin', '127.0.0.1', '鍐呯綉IP', 'Chrome 12', 'Windows 10', '0', '閫�鍑烘垚鍔�', '2024-04-12 03:01:16');
+INSERT INTO `sys_logininfor` VALUES (729, 'zgga', '127.0.0.1', '鍐呯綉IP', 'Chrome 12', 'Windows 10', '0', '鐧诲綍鎴愬姛', '2024-04-12 03:18:30');
+INSERT INTO `sys_logininfor` VALUES (730, 'zgga', '127.0.0.1', '鍐呯綉IP', 'Chrome 12', 'Windows 10', '0', '閫�鍑烘垚鍔�', '2024-04-12 03:21:25');
+INSERT INTO `sys_logininfor` VALUES (731, 'admin', '127.0.0.1', '鍐呯綉IP', 'Chrome 12', 'Windows 10', '1', '鐢ㄦ埛涓嶅瓨鍦�/瀵嗙爜閿欒', '2024-04-12 03:21:29');
+INSERT INTO `sys_logininfor` VALUES (732, 'admin', '127.0.0.1', '鍐呯綉IP', 'Chrome 12', 'Windows 10', '0', '鐧诲綍鎴愬姛', '2024-04-12 03:21:33');
+INSERT INTO `sys_logininfor` VALUES (733, 'admin', '127.0.0.1', '鍐呯綉IP', 'Chrome 12', 'Windows 10', '0', '閫�鍑烘垚鍔�', '2024-04-12 03:28:03');
+INSERT INTO `sys_logininfor` VALUES (734, 'zgga', '127.0.0.1', '鍐呯綉IP', 'Chrome 12', 'Windows 10', '0', '鐧诲綍鎴愬姛', '2024-04-12 03:28:14');
+INSERT INTO `sys_logininfor` VALUES (735, 'admin', '127.0.0.1', '鍐呯綉IP', 'Chrome 9', 'Windows 10', '0', '鐧诲綍鎴愬姛', '2024-04-12 05:47:49');
+INSERT INTO `sys_logininfor` VALUES (736, 'zgga', '127.0.0.1', '鍐呯綉IP', 'Chrome 12', 'Windows 10', '0', '閫�鍑烘垚鍔�', '2024-04-12 06:55:53');
+INSERT INTO `sys_logininfor` VALUES (737, 'admin', '127.0.0.1', '鍐呯綉IP', 'Chrome 12', 'Windows 10', '0', '鐧诲綍鎴愬姛', '2024-04-12 06:56:00');
+INSERT INTO `sys_logininfor` VALUES (738, 'admin', '127.0.0.1', '鍐呯綉IP', 'Chrome 12', 'Windows 10', '0', '閫�鍑烘垚鍔�', '2024-04-12 07:16:40');
+INSERT INTO `sys_logininfor` VALUES (739, 'admin', '127.0.0.1', '鍐呯綉IP', 'Chrome 12', 'Windows 10', '0', '鐧诲綍鎴愬姛', '2024-04-12 07:16:42');
+INSERT INTO `sys_logininfor` VALUES (740, 'admin', '127.0.0.1', '鍐呯綉IP', 'Chrome 12', 'Windows 10', '0', '閫�鍑烘垚鍔�', '2024-04-12 07:17:32');
+INSERT INTO `sys_logininfor` VALUES (741, 'zgga', '127.0.0.1', '鍐呯綉IP', 'Chrome 12', 'Windows 10', '0', '鐧诲綍鎴愬姛', '2024-04-12 07:17:42');
+INSERT INTO `sys_logininfor` VALUES (742, 'zgga', '127.0.0.1', '鍐呯綉IP', 'Chrome 12', 'Windows 10', '0', '閫�鍑烘垚鍔�', '2024-04-12 07:37:52');
+INSERT INTO `sys_logininfor` VALUES (743, 'zgga', '127.0.0.1', '鍐呯綉IP', 'Chrome 12', 'Windows 10', '0', '鐧诲綍鎴愬姛', '2024-04-12 07:38:02');
+INSERT INTO `sys_logininfor` VALUES (744, 'zgga', '127.0.0.1', '鍐呯綉IP', 'Chrome 12', 'Windows 10', '0', '閫�鍑烘垚鍔�', '2024-04-12 07:40:43');
+INSERT INTO `sys_logininfor` VALUES (745, 'zgga', '127.0.0.1', '鍐呯綉IP', 'Chrome 12', 'Windows 10', '0', '鐧诲綍鎴愬姛', '2024-04-12 07:40:48');
+INSERT INTO `sys_logininfor` VALUES (746, 'zgga', '127.0.0.1', '鍐呯綉IP', 'Chrome 12', 'Windows 10', '0', '閫�鍑烘垚鍔�', '2024-04-12 07:40:55');
+INSERT INTO `sys_logininfor` VALUES (747, 'admin', '127.0.0.1', '鍐呯綉IP', 'Chrome 12', 'Windows 10', '0', '鐧诲綍鎴愬姛', '2024-04-12 07:41:06');
+INSERT INTO `sys_logininfor` VALUES (748, 'admin', '127.0.0.1', '鍐呯綉IP', 'Chrome 12', 'Windows 10', '0', '閫�鍑烘垚鍔�', '2024-04-12 07:45:13');
+INSERT INTO `sys_logininfor` VALUES (749, 'zgga', '127.0.0.1', '鍐呯綉IP', 'Chrome 12', 'Windows 10', '0', '鐧诲綍鎴愬姛', '2024-04-12 07:45:23');
+INSERT INTO `sys_logininfor` VALUES (750, 'admin', '127.0.0.1', '鍐呯綉IP', 'Chrome 12', 'Windows 10', '0', '鐧诲綍鎴愬姛', '2024-04-12 08:14:32');
-- ----------------------------
-- Table structure for sys_menu
@@ -1567,7 +1591,7 @@
INSERT INTO `sys_menu` VALUES (2001, '杩愮淮鍗曚綅绠＄悊', 1, 2, 'unit', NULL, NULL, 1, 0, 'M', '0', '0', '', 'peoples', 'admin', '2024-03-04 10:02:48', 'admin', '2024-03-15 15:19:54', '');
INSERT INTO `sys_menu` VALUES (2002, '杩愯缁存姢', 0, 4, 'maintenance', NULL, NULL, 1, 0, 'M', '0', '1', '', 'druid', 'admin', '2024-03-04 10:05:57', 'admin', '2024-04-10 05:45:40', '');
INSERT INTO `sys_menu` VALUES (2003, '杩愯鑰冩牳', 0, 6, 'examine', NULL, NULL, 1, 0, 'M', '0', '0', '', 'documentation', 'admin', '2024-03-04 10:06:53', 'admin', '2024-03-15 14:55:07', '');
-INSERT INTO `sys_menu` VALUES (2004, '鏍哥畻绠＄悊', 2034, 3, 'calculate', NULL, NULL, 1, 0, 'M', '0', '0', '', 'money', 'admin', '2024-03-04 10:07:34', 'admin', '2024-04-11 07:52:19', '');
+INSERT INTO `sys_menu` VALUES (2004, '鏍哥畻绠＄悊', 2034, 3, 'calculate', NULL, NULL, 1, 0, 'M', '0', '1', '', 'money', 'admin', '2024-03-04 10:07:34', 'admin', '2024-04-12 07:44:39', '');
INSERT INTO `sys_menu` VALUES (2005, '瑙嗛杩愯鐩戞帶', 2000, 1, 'video', 'system/video/index', NULL, 1, 0, 'C', '0', '0', 'monitorServe:video:list', '#', 'admin', '2024-03-04 10:11:35', 'admin', '2024-03-05 10:12:33', '');
INSERT INTO `sys_menu` VALUES (2006, '浜鸿劯杩愯鐩戞帶', 2000, 2, 'face', 'system/face/index', NULL, 1, 0, 'C', '0', '0', 'monitorServe:face:list', '#', 'admin', '2024-03-04 10:12:26', 'admin', '2024-03-05 10:18:36', '');
INSERT INTO `sys_menu` VALUES (2007, '杞﹁締杩愯鐩戞帶', 2000, 3, 'car', 'system/car/index', NULL, 1, 0, 'C', '0', '0', 'monitorServe:car:list', '#', 'admin', '2024-03-04 10:13:31', 'admin', '2024-03-05 10:18:40', '');
@@ -1580,10 +1604,10 @@
INSERT INTO `sys_menu` VALUES (2016, '鐪佸巺鑰冩牳瑙勫垯', 2015, 1, 'check-rule-province', 'system/rule/province/index', NULL, 1, 0, 'C', '0', '1', 'check:rule:list', '#', 'admin', '2024-03-04 10:34:04', 'admin', '2024-04-10 05:53:32', '');
INSERT INTO `sys_menu` VALUES (2017, '鑰冩牳妯℃澘', 2003, 1, 'check-template', 'system/template/index', NULL, 1, 0, 'C', '0', '0', '', '#', 'admin', '2024-03-04 10:35:16', 'admin', '2024-04-10 07:30:46', '');
INSERT INTO `sys_menu` VALUES (2018, '鑰冩牳绠＄悊', 2003, 2, 'kaohe', '', NULL, 1, 0, 'M', '0', '1', '', '#', 'admin', '2024-03-04 10:36:24', 'admin', '2024-04-10 09:29:35', '');
-INSERT INTO `sys_menu` VALUES (2019, '鏍哥畻瑙勫垯', 2004, 0, 'rule', 'system/calculate/rule/index', NULL, 1, 0, 'C', '0', '0', 'system:calculate:rule:list', '#', 'admin', '2024-03-04 10:49:53', 'admin', '2024-04-10 05:52:02', '');
+INSERT INTO `sys_menu` VALUES (2019, '鏍哥畻瑙勫垯', 2034, 3, 'rule', 'system/calculate/rule/index', NULL, 1, 0, 'C', '0', '0', 'system:calculate:rule:list', '#', 'admin', '2024-03-04 10:49:53', 'admin', '2024-04-12 07:45:00', '');
INSERT INTO `sys_menu` VALUES (2020, '杩愮淮鑰冩牳璐ｄ换绠＄悊', 2004, 2, 'duty', 'system/calculate/duty/index', '', 1, 0, 'C', '0', '1', 'calculate:duty:list', '#', 'admin', '2024-03-04 10:50:53', 'admin', '2024-03-26 17:43:14', '');
INSERT INTO `sys_menu` VALUES (2021, '鍚堝悓鑰冩牳缁撴灉', 2034, 2, 'order', 'system/calculate/order/index', NULL, 1, 0, 'C', '0', '0', 'system:calculate:order:list', '#', 'admin', '2024-03-04 10:51:39', 'admin', '2024-04-11 07:52:24', '');
-INSERT INTO `sys_menu` VALUES (2022, '鏍哥畻璁板綍', 2004, 4, 'record', 'system/calculate/record/index', NULL, 1, 0, 'C', '0', '0', 'calculate:record:list', '#', 'admin', '2024-03-04 10:52:36', 'admin', '2024-03-21 16:03:20', '');
+INSERT INTO `sys_menu` VALUES (2022, '鏍哥畻璁板綍', 2004, 4, 'record', 'system/calculate/record/index', NULL, 1, 0, 'C', '0', '1', 'calculate:record:list', '#', 'admin', '2024-03-04 10:52:36', 'admin', '2024-04-12 07:42:12', '');
INSERT INTO `sys_menu` VALUES (2023, '鏍哥畻鎶ュ憡', 2034, 4, 'report', 'system/calculate/report/index', NULL, 1, 0, 'C', '0', '0', 'calculate:report:list', '#', 'admin', '2024-03-04 10:53:15', 'admin', '2024-04-11 07:52:32', '');
INSERT INTO `sys_menu` VALUES (2024, '鏍哥畻鎶ヨ〃', 2034, 6, 'forms', 'calculate/forms/index', NULL, 1, 0, 'C', '0', '1', 'calculate:forms:list', '#', 'admin', '2024-03-04 10:55:24', 'admin', '2024-04-11 07:51:55', '');
INSERT INTO `sys_menu` VALUES (2025, '宸ュ崟澶勭悊', 2082, 3, 'maintenance/work-order/work-order', 'system/work-order/index', NULL, 1, 0, 'C', '0', '0', 'work:order:list', '#', 'admin', '2024-03-04 10:57:36', 'admin', '2024-04-10 05:35:39', '');
@@ -1663,7 +1687,7 @@
INDEX `idx_sys_oper_log_bt`(`business_type` ASC) USING BTREE,
INDEX `idx_sys_oper_log_s`(`status` ASC) USING BTREE,
INDEX `idx_sys_oper_log_ot`(`oper_time` ASC) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 975 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鎿嶄綔鏃ュ織璁板綍' ROW_FORMAT = DYNAMIC;
+) ENGINE = InnoDB AUTO_INCREMENT = 1017 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鎿嶄綔鏃ュ織璁板綍' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of sys_oper_log
@@ -2579,6 +2603,12 @@
INSERT INTO `sys_oper_log` VALUES (1008, '鏍哥畻璁板綍', 1, 'com.ycl.platform.controller.CalculateRecordController.add()', 'POST', 1, 'admin', '鐪佸巺', '/calculate/record', '192.168.3.87', '鍐呯綉IP', '{\"date\":\"2024-04-23\",\"params\":{},\"ruleId\":1,\"score\":456,\"unitId\":3}', '{\"msg\":\"鎿嶄綔鎴愬姛\",\"code\":200}', 0, NULL, '2024-04-11 09:25:35', 100);
INSERT INTO `sys_oper_log` VALUES (1009, '鏍哥畻璁板綍', 3, 'com.ycl.platform.controller.CalculateRecordController.remove()', 'DELETE', 1, 'admin', '鐪佸巺', '/calculate/record/7,8', '192.168.3.87', '鍐呯綉IP', '{}', '{\"msg\":\"鎿嶄綔鎴愬姛\",\"code\":200}', 0, NULL, '2024-04-11 09:25:42', 100);
INSERT INTO `sys_oper_log` VALUES (1010, '鑿滃崟绠＄悊', 2, 'com.ycl.system.controller.SysMenuController.edit()', 'PUT', 1, 'admin', '鐪佸巺', '/system/menu', '127.0.0.1', '鍐呯綉IP', '{\"children\":[],\"component\":\"monitor/job/index\",\"createTime\":\"2024-04-01 16:33:28\",\"icon\":\"lock\",\"isCache\":\"0\",\"isFrame\":\"1\",\"menuId\":2081,\"menuName\":\"瀹氭椂浠诲姟\",\"menuType\":\"C\",\"orderNum\":1,\"params\":{},\"parentId\":2,\"path\":\"jobs\",\"perms\":\"job:list\",\"status\":\"0\",\"updateBy\":\"admin\",\"visible\":\"0\"}', '{\"msg\":\"鎿嶄綔鎴愬姛\",\"code\":200}', 0, NULL, '2024-04-12 01:17:47', 167);
+INSERT INTO `sys_oper_log` VALUES (1011, '瀛楀吀鏁版嵁', 2, 'com.ycl.system.controller.SysDictDataController.edit()', 'PUT', 1, 'admin', '鐪佸巺', '/system/dict/data', '127.0.0.1', '鍐呯綉IP', '{\"createBy\":\"admin\",\"createTime\":\"2024-03-13 11:00:05\",\"default\":false,\"dictCode\":109,\"dictLabel\":\"甯傚眬鑰冩牳\",\"dictSort\":2,\"dictType\":\"platform_examine_category\",\"dictValue\":\"1\",\"isDefault\":\"N\",\"listClass\":\"default\",\"params\":{},\"status\":\"0\",\"updateBy\":\"admin\"}', '{\"msg\":\"鎿嶄綔鎴愬姛\",\"code\":200}', 0, NULL, '2024-04-12 03:22:48', 341);
+INSERT INTO `sys_oper_log` VALUES (1012, '鑿滃崟绠＄悊', 2, 'com.ycl.system.controller.SysMenuController.edit()', 'PUT', 1, 'admin', '鐪佸巺', '/system/menu', '127.0.0.1', '鍐呯綉IP', '{\"children\":[],\"component\":\"system/calculate/record/index\",\"createTime\":\"2024-03-04 10:52:36\",\"icon\":\"#\",\"isCache\":\"0\",\"isFrame\":\"1\",\"menuId\":2022,\"menuName\":\"鏍哥畻璁板綍\",\"menuType\":\"C\",\"orderNum\":4,\"params\":{},\"parentId\":2004,\"path\":\"record\",\"perms\":\"calculate:record:list\",\"status\":\"1\",\"updateBy\":\"admin\",\"visible\":\"0\"}', '{\"msg\":\"鎿嶄綔鎴愬姛\",\"code\":200}', 0, NULL, '2024-04-12 07:42:12', 213);
+INSERT INTO `sys_oper_log` VALUES (1013, '鑿滃崟绠＄悊', 2, 'com.ycl.system.controller.SysMenuController.edit()', 'PUT', 1, 'admin', '鐪佸巺', '/system/menu', '127.0.0.1', '鍐呯綉IP', '{\"children\":[],\"component\":\"system/calculate/rule/index\",\"createTime\":\"2024-03-04 10:49:53\",\"icon\":\"#\",\"isCache\":\"0\",\"isFrame\":\"1\",\"menuId\":2019,\"menuName\":\"鏍哥畻瑙勫垯\",\"menuType\":\"C\",\"orderNum\":0,\"params\":{},\"parentId\":0,\"path\":\"rule\",\"perms\":\"system:calculate:rule:list\",\"status\":\"0\",\"updateBy\":\"admin\",\"visible\":\"0\"}', '{\"msg\":\"鎿嶄綔鎴愬姛\",\"code\":200}', 0, NULL, '2024-04-12 07:42:24', 143);
+INSERT INTO `sys_oper_log` VALUES (1014, '鑿滃崟绠＄悊', 2, 'com.ycl.system.controller.SysMenuController.edit()', 'PUT', 1, 'admin', '鐪佸巺', '/system/menu', '127.0.0.1', '鍐呯綉IP', '{\"children\":[],\"component\":\"system/calculate/rule/index\",\"createTime\":\"2024-03-04 10:49:53\",\"icon\":\"#\",\"isCache\":\"0\",\"isFrame\":\"1\",\"menuId\":2019,\"menuName\":\"鏍哥畻瑙勫垯\",\"menuType\":\"C\",\"orderNum\":0,\"params\":{},\"parentId\":2034,\"path\":\"rule\",\"perms\":\"system:calculate:rule:list\",\"status\":\"0\",\"updateBy\":\"admin\",\"visible\":\"0\"}', '{\"msg\":\"鎿嶄綔鎴愬姛\",\"code\":200}', 0, NULL, '2024-04-12 07:44:22', 163);
+INSERT INTO `sys_oper_log` VALUES (1015, '鑿滃崟绠＄悊', 2, 'com.ycl.system.controller.SysMenuController.edit()', 'PUT', 1, 'admin', '鐪佸巺', '/system/menu', '127.0.0.1', '鍐呯綉IP', '{\"children\":[],\"createTime\":\"2024-03-04 10:07:34\",\"icon\":\"money\",\"isCache\":\"0\",\"isFrame\":\"1\",\"menuId\":2004,\"menuName\":\"鏍哥畻绠＄悊\",\"menuType\":\"M\",\"orderNum\":3,\"params\":{},\"parentId\":2034,\"path\":\"calculate\",\"perms\":\"\",\"status\":\"1\",\"updateBy\":\"admin\",\"visible\":\"0\"}', '{\"msg\":\"鎿嶄綔鎴愬姛\",\"code\":200}', 0, NULL, '2024-04-12 07:44:39', 142);
+INSERT INTO `sys_oper_log` VALUES (1016, '鑿滃崟绠＄悊', 2, 'com.ycl.system.controller.SysMenuController.edit()', 'PUT', 1, 'admin', '鐪佸巺', '/system/menu', '127.0.0.1', '鍐呯綉IP', '{\"children\":[],\"component\":\"system/calculate/rule/index\",\"createTime\":\"2024-03-04 10:49:53\",\"icon\":\"#\",\"isCache\":\"0\",\"isFrame\":\"1\",\"menuId\":2019,\"menuName\":\"鏍哥畻瑙勫垯\",\"menuType\":\"C\",\"orderNum\":3,\"params\":{},\"parentId\":2034,\"path\":\"rule\",\"perms\":\"system:calculate:rule:list\",\"status\":\"0\",\"updateBy\":\"admin\",\"visible\":\"0\"}', '{\"msg\":\"鎿嶄綔鎴愬姛\",\"code\":200}', 0, NULL, '2024-04-12 07:45:00', 145);
-- ----------------------------
-- Table structure for sys_post
@@ -2948,13 +2978,13 @@
`remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '澶囨敞',
`first_login` tinyint NULL DEFAULT 0 COMMENT '鏄惁绗竴娆＄櫥闄�,0涓洪娆＄櫥褰曢渶瑕佹洿鏀瑰瘑鐮�',
PRIMARY KEY (`user_id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 104 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鐢ㄦ埛淇℃伅琛�' ROW_FORMAT = DYNAMIC;
+) ENGINE = InnoDB AUTO_INCREMENT = 112 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鐢ㄦ埛淇℃伅琛�' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of sys_user
-- ----------------------------
-INSERT INTO `sys_user` VALUES (1, 100, 'admin', '瓒呯', '00', 'ry@163.com', '15888888888', '1', '', '$2a$10$xHdnEgPAOwtRZhqqJi87I.UH/TY6kl09gpePBCQP8jN5fBlyMJe8m', '0', '0', '127.0.0.1', '2024-04-12 09:17:04', 'admin', '2024-02-04 16:27:33', '', '2024-03-11 10:03:49', '绠＄悊鍛�', 1);
-INSERT INTO `sys_user` VALUES (100, 207, 'zgga', '鑷础甯傚眬鍏畨', '00', '', '', '0', '', '$2a$10$T.OMRlqYt2srhxkYxOqQcOrsL.mlvwKGw7TYjdnNKwxzLqzREJu66', '0', '0', '127.0.0.1', '2024-04-12 09:12:16', 'admin', '2024-03-07 16:23:27', 'admin', '2024-03-11 14:34:06', NULL, 1);
+INSERT INTO `sys_user` VALUES (1, 100, 'admin', '瓒呯', '00', 'ry@163.com', '15888888888', '1', '', '$2a$10$xHdnEgPAOwtRZhqqJi87I.UH/TY6kl09gpePBCQP8jN5fBlyMJe8m', '0', '0', '127.0.0.1', '2024-04-12 16:14:32', 'admin', '2024-02-04 16:27:33', '', '2024-03-11 10:03:49', '绠＄悊鍛�', 1);
+INSERT INTO `sys_user` VALUES (100, 207, 'zgga', '鑷础甯傚眬鍏畨', '00', '', '', '0', '', '$2a$10$T.OMRlqYt2srhxkYxOqQcOrsL.mlvwKGw7TYjdnNKwxzLqzREJu66', '0', '0', '127.0.0.1', '2024-04-12 15:45:24', 'admin', '2024-03-07 16:23:27', 'admin', '2024-03-11 14:34:06', NULL, 1);
INSERT INTO `sys_user` VALUES (101, 101, 'zgfsga', '鑷础瀵岄『璀﹀畼', '00', '', '', '0', '', '$2a$10$lFOzvNQz9u/VSptoqvwr6.rzkEfcI.z9R9orXulsgwqc.4.VzXLLK', '0', '0', '127.0.0.1', '2024-03-26 17:08:14', 'admin', '2024-03-18 10:18:20', 'admin', NULL, NULL, 1);
INSERT INTO `sys_user` VALUES (102, 209, 'zgyw', 'zgyw', '00', '', '13345678910', '0', '', '$2a$10$D9.9k.7OsWKaL.eEqShN8e5Gl2u8uasxyINPlIugZrGNlEHN7bSDi', '0', '0', '127.0.0.1', '2024-04-11 16:38:15', 'admin', '2024-03-18 10:22:15', 'admin', NULL, NULL, 1);
INSERT INTO `sys_user` VALUES (103, NULL, 'yw_138', '鍒樺皬灏�', '00', '', '', '0', '', '$2a$10$yAHDHeMU1SB/3k.LZ.u9t.D.4I1ZVLbfctLqIr0wXHxE4jjUGaH2y', '0', '0', '', NULL, '', '2024-04-08 03:10:33', '', NULL, NULL, 0);
@@ -3009,7 +3039,7 @@
`deduct_amount` decimal(10, 4) NULL DEFAULT NULL COMMENT '鎵ｅ噺鏈嶅姟璐�',
`score` decimal(10, 4) NULL DEFAULT NULL COMMENT '鑰冩牳鍒嗘暟',
PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '鏍哥畻璁板綍' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '鏍哥畻璁板綍' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of t_calculate_record
@@ -3251,7 +3281,7 @@
-- ----------------------------
-- Records of t_check_template
-- ----------------------------
-INSERT INTO `t_check_template` VALUES (1, '鍖哄幙鑰冩牳娴嬭瘯妯℃澘', 1, '*', 1, '0', '[101,102,201,202,203,210,211]', '2024-04-07 11:36:27', '2024-04-07 11:36:27', 1, 'admin', 1, 'admin', '0');
+INSERT INTO `t_check_template` VALUES (1, '甯傚眬鑰冩牳娴嬭瘯妯℃澘', 1, '*', 1, '0', '[101,102,201,202,203,210,211]', '2024-04-07 11:36:27', '2024-04-07 11:36:27', 1, 'admin', 1, 'admin', '0');
-- ----------------------------
-- Table structure for t_check_template_rule
@@ -3559,7 +3589,7 @@
`recovery_time` datetime NULL DEFAULT NULL COMMENT '寮傚父鎭㈠鏃堕棿',
`dept_id` bigint NULL DEFAULT NULL COMMENT '涓婃姤閮ㄩ棬',
PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 22 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '璁惧璧勪骇琛�' ROW_FORMAT = DYNAMIC;
+) ENGINE = InnoDB AUTO_INCREMENT = 5409 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '璁惧璧勪骇琛�' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of t_monitor
@@ -9268,7 +9298,7 @@
`remark` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '澶囨敞',
`user_id` int NOT NULL,
PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '杩愮淮浜哄憳' ROW_FORMAT = DYNAMIC;
+) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '杩愮淮浜哄憳' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of t_yw_people
@@ -9317,12 +9347,12 @@
`id` int NOT NULL AUTO_INCREMENT COMMENT '涓婚敭',
`monitor_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '璁惧绫诲瀷锛�1浜鸿劯 2杞﹁締 3瑙嗛',
`timeout` int NULL DEFAULT NULL COMMENT '瓒呮椂澶╂暟',
- `indicator` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鎸囨爣json',
+ `indicator` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鎸囨爣json',
`create_time` datetime NULL DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
`update_time` datetime NULL DEFAULT NULL COMMENT '淇敼鏃堕棿',
`deleted` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '閫昏緫鍒犻櫎锛�0鏈垹闄� 1鍒犻櫎',
PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '杩愮淮闃堝��' ROW_FORMAT = DYNAMIC;
+) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '宸ュ崟闃堝��' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of t_yw_threshold
@@ -9347,7 +9377,7 @@
`update_time` datetime NULL DEFAULT NULL COMMENT '淇敼鏃堕棿',
`deleted` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '閫昏緫鍒犻櫎锛�0鏈垹闄� 1鍒犻櫎',
PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '杩愮淮鍗曚綅' ROW_FORMAT = DYNAMIC;
+) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '杩愮淮鍗曚綅' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of t_yw_unit
--
Gitblit v1.8.0