lc_finance/lc_finance.sql

/*
 Navicat Premium Data Transfer

 Source Server         : lc
 Source Server Type    : MySQL
 Source Server Version : 50735 (5.7.35)
 Source Host           : localhost:3306
 Source Schema         : lc_finance

 Target Server Type    : MySQL
 Target Server Version : 50735 (5.7.35)
 File Encoding         : 65001

 Date: 06/06/2024 09:37:10
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for casbin_rule
-- ----------------------------
DROP TABLE IF EXISTS `casbin_rule`;
CREATE TABLE `casbin_rule`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `ptype` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `v0` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `v1` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `v2` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `v3` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `v4` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `v5` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `idx_casbin_rule`(`ptype`, `v0`, `v1`, `v2`, `v3`, `v4`, `v5`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 380 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of casbin_rule
-- ----------------------------
INSERT INTO `casbin_rule` VALUES (2, 'p', '888', '/api/createApi', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (5, 'p', '888', '/api/deleteApi', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (8, 'p', '888', '/api/deleteApisByIds', 'DELETE', '', '', '');
INSERT INTO `casbin_rule` VALUES (7, 'p', '888', '/api/getAllApis', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (4, 'p', '888', '/api/getApiById', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (3, 'p', '888', '/api/getApiList', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (6, 'p', '888', '/api/updateApi', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (9, 'p', '888', '/authority/copyAuthority', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (11, 'p', '888', '/authority/createAuthority', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (12, 'p', '888', '/authority/deleteAuthority', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (13, 'p', '888', '/authority/getAuthorityList', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (14, 'p', '888', '/authority/setDataAuthority', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (10, 'p', '888', '/authority/updateAuthority', 'PUT', '', '', '');
INSERT INTO `casbin_rule` VALUES (89, 'p', '888', '/authorityBtn/canRemoveAuthorityBtn', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (88, 'p', '888', '/authorityBtn/getAuthorityBtn', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (87, 'p', '888', '/authorityBtn/setAuthorityBtn', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (61, 'p', '888', '/autoCode/createPackage', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (64, 'p', '888', '/autoCode/createPlug', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (58, 'p', '888', '/autoCode/createTemp', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (63, 'p', '888', '/autoCode/delPackage', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (59, 'p', '888', '/autoCode/delSysHistory', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (56, 'p', '888', '/autoCode/getColumn', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (52, 'p', '888', '/autoCode/getDB', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (53, 'p', '888', '/autoCode/getMeta', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (62, 'p', '888', '/autoCode/getPackage', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (60, 'p', '888', '/autoCode/getSysHistory', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (55, 'p', '888', '/autoCode/getTables', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (65, 'p', '888', '/autoCode/installPlugin', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (54, 'p', '888', '/autoCode/preview', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (66, 'p', '888', '/autoCode/pubPlug', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (57, 'p', '888', '/autoCode/rollback', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (42, 'p', '888', '/casbin/getPolicyPathByAuthorityId', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (41, 'p', '888', '/casbin/updateCasbin', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (50, 'p', '888', '/customer/customer', 'DELETE', '', '', '');
INSERT INTO `casbin_rule` VALUES (47, 'p', '888', '/customer/customer', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (49, 'p', '888', '/customer/customer', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (48, 'p', '888', '/customer/customer', 'PUT', '', '', '');
INSERT INTO `casbin_rule` VALUES (51, 'p', '888', '/customer/customerList', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (83, 'p', '888', '/email/emailTest', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (35, 'p', '888', '/fileUploadAndDownload/breakpointContinue', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (34, 'p', '888', '/fileUploadAndDownload/breakpointContinueFinish', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (38, 'p', '888', '/fileUploadAndDownload/deleteFile', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (39, 'p', '888', '/fileUploadAndDownload/editFileName', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (33, 'p', '888', '/fileUploadAndDownload/findFile', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (40, 'p', '888', '/fileUploadAndDownload/getFileList', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (36, 'p', '888', '/fileUploadAndDownload/removeChunk', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (37, 'p', '888', '/fileUploadAndDownload/upload', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (43, 'p', '888', '/jwt/jsonInBlacklist', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (17, 'p', '888', '/menu/addBaseMenu', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (19, 'p', '888', '/menu/addMenuAuthority', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (21, 'p', '888', '/menu/deleteBaseMenu', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (23, 'p', '888', '/menu/getBaseMenuById', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (18, 'p', '888', '/menu/getBaseMenuTree', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (15, 'p', '888', '/menu/getMenu', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (20, 'p', '888', '/menu/getMenuAuthority', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (16, 'p', '888', '/menu/getMenuList', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (22, 'p', '888', '/menu/updateBaseMenu', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (85, 'p', '888', '/simpleUploader/checkFileMd5', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (86, 'p', '888', '/simpleUploader/mergeFileMd5', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (84, 'p', '888', '/simpleUploader/upload', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (75, 'p', '888', '/sysDictionary/createSysDictionary', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (76, 'p', '888', '/sysDictionary/deleteSysDictionary', 'DELETE', '', '', '');
INSERT INTO `casbin_rule` VALUES (72, 'p', '888', '/sysDictionary/findSysDictionary', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (74, 'p', '888', '/sysDictionary/getSysDictionaryList', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (73, 'p', '888', '/sysDictionary/updateSysDictionary', 'PUT', '', '', '');
INSERT INTO `casbin_rule` VALUES (69, 'p', '888', '/sysDictionaryDetail/createSysDictionaryDetail', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (71, 'p', '888', '/sysDictionaryDetail/deleteSysDictionaryDetail', 'DELETE', '', '', '');
INSERT INTO `casbin_rule` VALUES (67, 'p', '888', '/sysDictionaryDetail/findSysDictionaryDetail', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (70, 'p', '888', '/sysDictionaryDetail/getSysDictionaryDetailList', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (68, 'p', '888', '/sysDictionaryDetail/updateSysDictionaryDetail', 'PUT', '', '', '');
INSERT INTO `casbin_rule` VALUES (90, 'p', '888', '/sysExportTemplate/createSysExportTemplate', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (91, 'p', '888', '/sysExportTemplate/deleteSysExportTemplate', 'DELETE', '', '', '');
INSERT INTO `casbin_rule` VALUES (92, 'p', '888', '/sysExportTemplate/deleteSysExportTemplateByIds', 'DELETE', '', '', '');
INSERT INTO `casbin_rule` VALUES (96, 'p', '888', '/sysExportTemplate/exportExcel', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (97, 'p', '888', '/sysExportTemplate/exportTemplate', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (94, 'p', '888', '/sysExportTemplate/findSysExportTemplate', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (95, 'p', '888', '/sysExportTemplate/getSysExportTemplateList', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (98, 'p', '888', '/sysExportTemplate/importExcel', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (93, 'p', '888', '/sysExportTemplate/updateSysExportTemplate', 'PUT', '', '', '');
INSERT INTO `casbin_rule` VALUES (79, 'p', '888', '/sysOperationRecord/createSysOperationRecord', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (81, 'p', '888', '/sysOperationRecord/deleteSysOperationRecord', 'DELETE', '', '', '');
INSERT INTO `casbin_rule` VALUES (82, 'p', '888', '/sysOperationRecord/deleteSysOperationRecordByIds', 'DELETE', '', '', '');
INSERT INTO `casbin_rule` VALUES (77, 'p', '888', '/sysOperationRecord/findSysOperationRecord', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (80, 'p', '888', '/sysOperationRecord/getSysOperationRecordList', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (78, 'p', '888', '/sysOperationRecord/updateSysOperationRecord', 'PUT', '', '', '');
INSERT INTO `casbin_rule` VALUES (46, 'p', '888', '/system/getServerInfo', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (44, 'p', '888', '/system/getSystemConfig', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (45, 'p', '888', '/system/setSystemConfig', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (1, 'p', '888', '/user/admin_register', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (29, 'p', '888', '/user/changePassword', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (28, 'p', '888', '/user/deleteUser', 'DELETE', '', '', '');
INSERT INTO `casbin_rule` VALUES (24, 'p', '888', '/user/getUserInfo', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (27, 'p', '888', '/user/getUserList', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (32, 'p', '888', '/user/resetPassword', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (26, 'p', '888', '/user/setSelfInfo', 'PUT', '', '', '');
INSERT INTO `casbin_rule` VALUES (31, 'p', '888', '/user/setUserAuthorities', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (30, 'p', '888', '/user/setUserAuthority', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (25, 'p', '888', '/user/setUserInfo', 'PUT', '', '', '');
INSERT INTO `casbin_rule` VALUES (293, 'p', '9527', '/api/createApi', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (294, 'p', '9527', '/api/deleteApi', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (299, 'p', '9527', '/api/deleteApisByIds', 'DELETE', '', '', '');
INSERT INTO `casbin_rule` VALUES (297, 'p', '9527', '/api/getAllApis', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (298, 'p', '9527', '/api/getApiById', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (296, 'p', '9527', '/api/getApiList', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (295, 'p', '9527', '/api/updateApi', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (300, 'p', '9527', '/authority/copyAuthority', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (301, 'p', '9527', '/authority/createAuthority', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (302, 'p', '9527', '/authority/deleteAuthority', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (304, 'p', '9527', '/authority/getAuthorityList', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (305, 'p', '9527', '/authority/setDataAuthority', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (303, 'p', '9527', '/authority/updateAuthority', 'PUT', '', '', '');
INSERT INTO `casbin_rule` VALUES (370, 'p', '9527', '/authorityBtn/canRemoveAuthorityBtn', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (369, 'p', '9527', '/authorityBtn/getAuthorityBtn', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (368, 'p', '9527', '/authorityBtn/setAuthorityBtn', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (341, 'p', '9527', '/autoCode/createPackage', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (338, 'p', '9527', '/autoCode/createPlug', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (335, 'p', '9527', '/autoCode/createTemp', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (343, 'p', '9527', '/autoCode/delPackage', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (347, 'p', '9527', '/autoCode/delSysHistory', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (337, 'p', '9527', '/autoCode/getColumn', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (333, 'p', '9527', '/autoCode/getDB', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (344, 'p', '9527', '/autoCode/getMeta', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (342, 'p', '9527', '/autoCode/getPackage', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (346, 'p', '9527', '/autoCode/getSysHistory', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (334, 'p', '9527', '/autoCode/getTables', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (339, 'p', '9527', '/autoCode/installPlugin', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (336, 'p', '9527', '/autoCode/preview', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (340, 'p', '9527', '/autoCode/pubPlug', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (345, 'p', '9527', '/autoCode/rollback', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (307, 'p', '9527', '/casbin/getPolicyPathByAuthorityId', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (306, 'p', '9527', '/casbin/updateCasbin', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (330, 'p', '9527', '/customer/customer', 'DELETE', '', '', '');
INSERT INTO `casbin_rule` VALUES (331, 'p', '9527', '/customer/customer', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (329, 'p', '9527', '/customer/customer', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (328, 'p', '9527', '/customer/customer', 'PUT', '', '', '');
INSERT INTO `casbin_rule` VALUES (332, 'p', '9527', '/customer/customerList', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (367, 'p', '9527', '/email/emailSend', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (366, 'p', '9527', '/email/emailTest', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (318, 'p', '9527', '/fileUploadAndDownload/breakpointContinue', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (319, 'p', '9527', '/fileUploadAndDownload/breakpointContinueFinish', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (322, 'p', '9527', '/fileUploadAndDownload/deleteFile', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (323, 'p', '9527', '/fileUploadAndDownload/editFileName', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (317, 'p', '9527', '/fileUploadAndDownload/findFile', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (324, 'p', '9527', '/fileUploadAndDownload/getFileList', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (320, 'p', '9527', '/fileUploadAndDownload/removeChunk', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (321, 'p', '9527', '/fileUploadAndDownload/upload', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (282, 'p', '9527', '/jwt/jsonInBlacklist', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (308, 'p', '9527', '/menu/addBaseMenu', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (316, 'p', '9527', '/menu/addMenuAuthority', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (310, 'p', '9527', '/menu/deleteBaseMenu', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (312, 'p', '9527', '/menu/getBaseMenuById', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (314, 'p', '9527', '/menu/getBaseMenuTree', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (309, 'p', '9527', '/menu/getMenu', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (315, 'p', '9527', '/menu/getMenuAuthority', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (313, 'p', '9527', '/menu/getMenuList', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (311, 'p', '9527', '/menu/updateBaseMenu', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (364, 'p', '9527', '/simpleUploader/checkFileMd5', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (365, 'p', '9527', '/simpleUploader/mergeFileMd5', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (363, 'p', '9527', '/simpleUploader/upload', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (353, 'p', '9527', '/sysDictionary/createSysDictionary', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (354, 'p', '9527', '/sysDictionary/deleteSysDictionary', 'DELETE', '', '', '');
INSERT INTO `casbin_rule` VALUES (356, 'p', '9527', '/sysDictionary/findSysDictionary', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (357, 'p', '9527', '/sysDictionary/getSysDictionaryList', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (355, 'p', '9527', '/sysDictionary/updateSysDictionary', 'PUT', '', '', '');
INSERT INTO `casbin_rule` VALUES (349, 'p', '9527', '/sysDictionaryDetail/createSysDictionaryDetail', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (350, 'p', '9527', '/sysDictionaryDetail/deleteSysDictionaryDetail', 'DELETE', '', '', '');
INSERT INTO `casbin_rule` VALUES (351, 'p', '9527', '/sysDictionaryDetail/findSysDictionaryDetail', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (352, 'p', '9527', '/sysDictionaryDetail/getSysDictionaryDetailList', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (348, 'p', '9527', '/sysDictionaryDetail/updateSysDictionaryDetail', 'PUT', '', '', '');
INSERT INTO `casbin_rule` VALUES (371, 'p', '9527', '/sysExportTemplate/createSysExportTemplate', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (372, 'p', '9527', '/sysExportTemplate/deleteSysExportTemplate', 'DELETE', '', '', '');
INSERT INTO `casbin_rule` VALUES (373, 'p', '9527', '/sysExportTemplate/deleteSysExportTemplateByIds', 'DELETE', '', '', '');
INSERT INTO `casbin_rule` VALUES (377, 'p', '9527', '/sysExportTemplate/exportExcel', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (378, 'p', '9527', '/sysExportTemplate/exportTemplate', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (375, 'p', '9527', '/sysExportTemplate/findSysExportTemplate', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (376, 'p', '9527', '/sysExportTemplate/getSysExportTemplateList', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (379, 'p', '9527', '/sysExportTemplate/importExcel', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (374, 'p', '9527', '/sysExportTemplate/updateSysExportTemplate', 'PUT', '', '', '');
INSERT INTO `casbin_rule` VALUES (358, 'p', '9527', '/sysOperationRecord/createSysOperationRecord', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (361, 'p', '9527', '/sysOperationRecord/deleteSysOperationRecord', 'DELETE', '', '', '');
INSERT INTO `casbin_rule` VALUES (362, 'p', '9527', '/sysOperationRecord/deleteSysOperationRecordByIds', 'DELETE', '', '', '');
INSERT INTO `casbin_rule` VALUES (359, 'p', '9527', '/sysOperationRecord/findSysOperationRecord', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (360, 'p', '9527', '/sysOperationRecord/getSysOperationRecordList', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (325, 'p', '9527', '/system/getServerInfo', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (326, 'p', '9527', '/system/getSystemConfig', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (327, 'p', '9527', '/system/setSystemConfig', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (284, 'p', '9527', '/user/admin_register', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (290, 'p', '9527', '/user/changePassword', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (283, 'p', '9527', '/user/deleteUser', 'DELETE', '', '', '');
INSERT INTO `casbin_rule` VALUES (288, 'p', '9527', '/user/getUserInfo', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (285, 'p', '9527', '/user/getUserList', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (292, 'p', '9527', '/user/resetPassword', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (287, 'p', '9527', '/user/setSelfInfo', 'PUT', '', '', '');
INSERT INTO `casbin_rule` VALUES (289, 'p', '9527', '/user/setUserAuthorities', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (291, 'p', '9527', '/user/setUserAuthority', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (286, 'p', '9527', '/user/setUserInfo', 'PUT', '', '', '');
INSERT INTO `casbin_rule` VALUES (138, 'p', '9528', '/api/createApi', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (141, 'p', '9528', '/api/deleteApi', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (143, 'p', '9528', '/api/getAllApis', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (140, 'p', '9528', '/api/getApiById', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (139, 'p', '9528', '/api/getApiList', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (142, 'p', '9528', '/api/updateApi', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (144, 'p', '9528', '/authority/createAuthority', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (145, 'p', '9528', '/authority/deleteAuthority', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (146, 'p', '9528', '/authority/getAuthorityList', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (147, 'p', '9528', '/authority/setDataAuthority', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (174, 'p', '9528', '/autoCode/createTemp', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (165, 'p', '9528', '/casbin/getPolicyPathByAuthorityId', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (164, 'p', '9528', '/casbin/updateCasbin', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (172, 'p', '9528', '/customer/customer', 'DELETE', '', '', '');
INSERT INTO `casbin_rule` VALUES (170, 'p', '9528', '/customer/customer', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (171, 'p', '9528', '/customer/customer', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (169, 'p', '9528', '/customer/customer', 'PUT', '', '', '');
INSERT INTO `casbin_rule` VALUES (173, 'p', '9528', '/customer/customerList', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (162, 'p', '9528', '/fileUploadAndDownload/deleteFile', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (163, 'p', '9528', '/fileUploadAndDownload/editFileName', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (161, 'p', '9528', '/fileUploadAndDownload/getFileList', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (160, 'p', '9528', '/fileUploadAndDownload/upload', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (166, 'p', '9528', '/jwt/jsonInBlacklist', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (150, 'p', '9528', '/menu/addBaseMenu', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (152, 'p', '9528', '/menu/addMenuAuthority', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (154, 'p', '9528', '/menu/deleteBaseMenu', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (156, 'p', '9528', '/menu/getBaseMenuById', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (151, 'p', '9528', '/menu/getBaseMenuTree', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (148, 'p', '9528', '/menu/getMenu', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (153, 'p', '9528', '/menu/getMenuAuthority', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (149, 'p', '9528', '/menu/getMenuList', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (155, 'p', '9528', '/menu/updateBaseMenu', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (167, 'p', '9528', '/system/getSystemConfig', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (168, 'p', '9528', '/system/setSystemConfig', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (137, 'p', '9528', '/user/admin_register', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (157, 'p', '9528', '/user/changePassword', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (175, 'p', '9528', '/user/getUserInfo', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (158, 'p', '9528', '/user/getUserList', 'POST', '', '', '');
INSERT INTO `casbin_rule` VALUES (159, 'p', '9528', '/user/setUserAuthority', 'POST', '', '', '');

-- ----------------------------
-- Table structure for exa_customers
-- ----------------------------
DROP TABLE IF EXISTS `exa_customers`;
CREATE TABLE `exa_customers`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `created_at` datetime(3) NULL DEFAULT NULL,
  `updated_at` datetime(3) NULL DEFAULT NULL,
  `deleted_at` datetime(3) NULL DEFAULT NULL,
  `customer_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '客户名',
  `customer_phone_data` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '客户手机号',
  `sys_user_id` bigint(20) UNSIGNED NULL DEFAULT NULL COMMENT '管理ID',
  `sys_user_authority_id` bigint(20) UNSIGNED NULL DEFAULT NULL COMMENT '管理角色ID',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_exa_customers_deleted_at`(`deleted_at`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of exa_customers
-- ----------------------------
INSERT INTO `exa_customers` VALUES (1, '2024-05-05 09:45:46.957', '2024-05-05 09:45:46.957', NULL, '程潜', '17365743261', 1, 888);

-- ----------------------------
-- Table structure for exa_file_chunks
-- ----------------------------
DROP TABLE IF EXISTS `exa_file_chunks`;
CREATE TABLE `exa_file_chunks`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `created_at` datetime(3) NULL DEFAULT NULL,
  `updated_at` datetime(3) NULL DEFAULT NULL,
  `deleted_at` datetime(3) NULL DEFAULT NULL,
  `exa_file_id` bigint(20) UNSIGNED NULL DEFAULT NULL,
  `file_chunk_number` bigint(20) NULL DEFAULT NULL,
  `file_chunk_path` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_exa_file_chunks_deleted_at`(`deleted_at`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of exa_file_chunks
-- ----------------------------

-- ----------------------------
-- Table structure for exa_file_upload_and_downloads
-- ----------------------------
DROP TABLE IF EXISTS `exa_file_upload_and_downloads`;
CREATE TABLE `exa_file_upload_and_downloads`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `created_at` datetime(3) NULL DEFAULT NULL,
  `updated_at` datetime(3) NULL DEFAULT NULL,
  `deleted_at` datetime(3) NULL DEFAULT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件名',
  `url` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件地址',
  `tag` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件标签',
  `key` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '编号',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_exa_file_upload_and_downloads_deleted_at`(`deleted_at`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of exa_file_upload_and_downloads
-- ----------------------------
INSERT INTO `exa_file_upload_and_downloads` VALUES (1, '2024-05-05 09:33:23.426', '2024-05-05 09:33:23.426', NULL, '10.png', 'https://qmplusimg.henrongyi.top/gvalogo.png', 'png', '158787308910.png');
INSERT INTO `exa_file_upload_and_downloads` VALUES (2, '2024-05-05 09:33:23.426', '2024-05-05 09:33:23.426', NULL, 'logo.png', 'https://qmplusimg.henrongyi.top/1576554439myAvatar.png', 'png', '1587973709logo.png');
INSERT INTO `exa_file_upload_and_downloads` VALUES (3, '2024-05-05 11:55:11.321', '2024-05-05 11:55:11.321', NULL, '帅.jpg', 'uploads/file/c67b3af7ed83579cc083089fc0bbefd0_20240505115511.jpg', 'jpg', 'c67b3af7ed83579cc083089fc0bbefd0_20240505115511.jpg');

-- ----------------------------
-- Table structure for exa_files
-- ----------------------------
DROP TABLE IF EXISTS `exa_files`;
CREATE TABLE `exa_files`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `created_at` datetime(3) NULL DEFAULT NULL,
  `updated_at` datetime(3) NULL DEFAULT NULL,
  `deleted_at` datetime(3) NULL DEFAULT NULL,
  `file_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `file_md5` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `file_path` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `chunk_total` bigint(20) NULL DEFAULT NULL,
  `is_finish` tinyint(1) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_exa_files_deleted_at`(`deleted_at`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of exa_files
-- ----------------------------

-- ----------------------------
-- Table structure for jwt_blacklists
-- ----------------------------
DROP TABLE IF EXISTS `jwt_blacklists`;
CREATE TABLE `jwt_blacklists`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `created_at` datetime(3) NULL DEFAULT NULL,
  `updated_at` datetime(3) NULL DEFAULT NULL,
  `deleted_at` datetime(3) NULL DEFAULT NULL,
  `jwt` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT 'jwt',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_jwt_blacklists_deleted_at`(`deleted_at`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of jwt_blacklists
-- ----------------------------
INSERT INTO `jwt_blacklists` VALUES (1, '2024-05-06 09:24:34.187', '2024-05-06 09:24:34.187', NULL, 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJVVUlEIjoiMDdjOTE0OWMtNmE5YS00MTI2LThkOGEtZGQxMWM3YjkxNGExIiwiSUQiOjEsIlVzZXJuYW1lIjoiYWRtaW4iLCJOaWNrTmFtZSI6Ik1yLuWlh-a3vCIsIkF1dGhvcml0eUlkIjo4ODgsIkJ1ZmZlclRpbWUiOjg2NDAwLCJpc3MiOiJxbVBsdXMiLCJhdWQiOlsiR1ZBIl0sImV4cCI6MTcxNTQ3NzY1MiwibmJmIjoxNzE0ODcyODUyfQ._mnvL5T0luZ3XeXRaijYEjjzW1yT2CK_FPfhTJ7wvL8');
INSERT INTO `jwt_blacklists` VALUES (2, '2024-05-06 09:42:41.340', '2024-05-06 09:42:41.340', NULL, 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJVVUlEIjoiMDdjOTE0OWMtNmE5YS00MTI2LThkOGEtZGQxMWM3YjkxNGExIiwiSUQiOjEsIlVzZXJuYW1lIjoiYWRtaW4iLCJOaWNrTmFtZSI6Ik1yLuWlh-a3vCIsIkF1dGhvcml0eUlkIjo4ODgsIkJ1ZmZlclRpbWUiOjg2NDAwLCJpc3MiOiJxbVBsdXMiLCJhdWQiOlsiR1ZBIl0sImV4cCI6MTcxNTU2NDQ2NywibmJmIjoxNzE0OTU5NjY3fQ.S1AKoi1d6PQal19tga2wWEFYKvcWsq_r2peHU1R-UkA');
INSERT INTO `jwt_blacklists` VALUES (3, '2024-05-06 09:47:46.905', '2024-05-06 09:47:46.905', NULL, 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJVVUlEIjoiMDdjOTE0OWMtNmE5YS00MTI2LThkOGEtZGQxMWM3YjkxNGExIiwiSUQiOjEsIlVzZXJuYW1lIjoiYWRtaW4iLCJOaWNrTmFtZSI6Ik1yLuWlh-a3vCIsIkF1dGhvcml0eUlkIjo4ODgsIkJ1ZmZlclRpbWUiOjg2NDAwLCJpc3MiOiJxbVBsdXMiLCJhdWQiOlsiR1ZBIl0sImV4cCI6MTcxNTU2NDY0MywibmJmIjoxNzE0OTU5ODQzfQ.8LKg-r_Vq50d3VG_TqU5ba3DmWtaUZALfiEgKmZp_5Y');
INSERT INTO `jwt_blacklists` VALUES (4, '2024-05-06 09:48:47.015', '2024-05-06 09:48:47.015', NULL, 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJVVUlEIjoiMDdjOTE0OWMtNmE5YS00MTI2LThkOGEtZGQxMWM3YjkxNGExIiwiSUQiOjEsIlVzZXJuYW1lIjoiYWRtaW4iLCJOaWNrTmFtZSI6Ik1yLuWlh-a3vCIsIkF1dGhvcml0eUlkIjo4ODgsIkJ1ZmZlclRpbWUiOjg2NDAwLCJpc3MiOiJxbVBsdXMiLCJhdWQiOlsiR1ZBIl0sImV4cCI6MTcxNTU2NDg5NSwibmJmIjoxNzE0OTYwMDk1fQ.3g8Ww_IpL-7xRtpEcI2sJGELzjPO3bVtDHRXOgaeFHg');
INSERT INTO `jwt_blacklists` VALUES (5, '2024-05-06 14:56:32.186', '2024-05-06 14:56:32.186', NULL, 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJVVUlEIjoiMGE1ZGI5MTgtYzNjYy00MDM0LWEzMmEtNmMxNWYzN2U3OGNiIiwiSUQiOjMsIlVzZXJuYW1lIjoieHV3ZW5oYW8iLCJOaWNrTmFtZSI6IuiuuOaWh-a1qSIsIkF1dGhvcml0eUlkIjo5NTI3LCJCdWZmZXJUaW1lIjo4NjQwMCwiaXNzIjoicW1QbHVzIiwiYXVkIjpbIkdWQSJdLCJleHAiOjE3MTU1NjQ5NDMsIm5iZiI6MTcxNDk2MDE0M30.k4AiYQGyEBNXklDBFzWPI78MV6Li4LCjLwPfkk_xCdo');
INSERT INTO `jwt_blacklists` VALUES (6, '2024-05-06 15:35:47.345', '2024-05-06 15:35:47.345', NULL, 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJVVUlEIjoiMGE1ZGI5MTgtYzNjYy00MDM0LWEzMmEtNmMxNWYzN2U3OGNiIiwiSUQiOjMsIlVzZXJuYW1lIjoieHV3ZW5oYW8iLCJOaWNrTmFtZSI6IuiuuOaWh-a1qSIsIkF1dGhvcml0eUlkIjo5NTI3LCJCdWZmZXJUaW1lIjo4NjQwMCwiaXNzIjoicW1QbHVzIiwiYXVkIjpbIkdWQSJdLCJleHAiOjE3MTU1ODUzNDQsIm5iZiI6MTcxNDk4MDU0NH0.ovtp28QIoAL7ig8jkJyor_kOjhV2pHw9mdr8hy61yiU');
INSERT INTO `jwt_blacklists` VALUES (7, '2024-05-06 16:43:04.429', '2024-05-06 16:43:04.429', NULL, 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJVVUlEIjoiMDdjOTE0OWMtNmE5YS00MTI2LThkOGEtZGQxMWM3YjkxNGExIiwiSUQiOjEsIlVzZXJuYW1lIjoiYWRtaW4iLCJOaWNrTmFtZSI6Ik1yLuWlh-a3vCIsIkF1dGhvcml0eUlkIjo4ODgsIkJ1ZmZlclRpbWUiOjg2NDAwLCJpc3MiOiJxbVBsdXMiLCJhdWQiOlsiR1ZBIl0sImV4cCI6MTcxNTU4NjA3MSwibmJmIjoxNzE0OTgxMjcxfQ.SjqOBu-1S1na0MrSeMx8lC5-KAA8Y9Im4_tMt3aQ9tk');
INSERT INTO `jwt_blacklists` VALUES (8, '2024-05-06 16:55:19.315', '2024-05-06 16:55:19.315', NULL, 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJVVUlEIjoiMGE1ZGI5MTgtYzNjYy00MDM0LWEzMmEtNmMxNWYzN2U3OGNiIiwiSUQiOjMsIlVzZXJuYW1lIjoieHV3ZW5oYW8iLCJOaWNrTmFtZSI6IuiuuOaWh-a1qSIsIkF1dGhvcml0eUlkIjo5NTI3LCJCdWZmZXJUaW1lIjo4NjQwMCwiaXNzIjoicW1QbHVzIiwiYXVkIjpbIkdWQSJdLCJleHAiOjE3MTU1ODk4MTUsIm5iZiI6MTcxNDk4NTAxNX0.jfQAQCmZOQw9kBvZlP_idaKfD_Wo5RtEkBio8JTl2uk');
INSERT INTO `jwt_blacklists` VALUES (9, '2024-05-06 17:22:34.601', '2024-05-06 17:22:34.601', NULL, 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJVVUlEIjoiMDdjOTE0OWMtNmE5YS00MTI2LThkOGEtZGQxMWM3YjkxNGExIiwiSUQiOjEsIlVzZXJuYW1lIjoiYWRtaW4iLCJOaWNrTmFtZSI6Ik1yLuWlh-a3vCIsIkF1dGhvcml0eUlkIjo4ODgsIkJ1ZmZlclRpbWUiOjg2NDAwLCJpc3MiOiJxbVBsdXMiLCJhdWQiOlsiR1ZBIl0sImV4cCI6MTcxNTU5MDc4NywibmJmIjoxNzE0OTg1OTg3fQ.4RQsG6-P3RFbWm5Bn35U5qerKtU947rc_aIqstxlQaI');

-- ----------------------------
-- Table structure for sys_apis
-- ----------------------------
DROP TABLE IF EXISTS `sys_apis`;
CREATE TABLE `sys_apis`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `created_at` datetime(3) NULL DEFAULT NULL,
  `updated_at` datetime(3) NULL DEFAULT NULL,
  `deleted_at` datetime(3) NULL DEFAULT NULL,
  `path` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'api路径',
  `description` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'api中文描述',
  `api_group` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'api组',
  `method` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'POST' COMMENT '方法',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_sys_apis_deleted_at`(`deleted_at`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 99 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_apis
-- ----------------------------
INSERT INTO `sys_apis` VALUES (1, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/jwt/jsonInBlacklist', 'jwt加入黑名单(退出，必选)', 'jwt', 'POST');
INSERT INTO `sys_apis` VALUES (2, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/user/deleteUser', '删除用户', '系统用户', 'DELETE');
INSERT INTO `sys_apis` VALUES (3, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/user/admin_register', '用户注册', '系统用户', 'POST');
INSERT INTO `sys_apis` VALUES (4, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/user/getUserList', '获取用户列表', '系统用户', 'POST');
INSERT INTO `sys_apis` VALUES (5, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/user/setUserInfo', '设置用户信息', '系统用户', 'PUT');
INSERT INTO `sys_apis` VALUES (6, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/user/setSelfInfo', '设置自身信息(必选)', '系统用户', 'PUT');
INSERT INTO `sys_apis` VALUES (7, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/user/getUserInfo', '获取自身信息(必选)', '系统用户', 'GET');
INSERT INTO `sys_apis` VALUES (8, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/user/setUserAuthorities', '设置权限组', '系统用户', 'POST');
INSERT INTO `sys_apis` VALUES (9, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/user/changePassword', '修改密码（建议选择)', '系统用户', 'POST');
INSERT INTO `sys_apis` VALUES (10, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/user/setUserAuthority', '修改用户角色(必选)', '系统用户', 'POST');
INSERT INTO `sys_apis` VALUES (11, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/user/resetPassword', '重置用户密码', '系统用户', 'POST');
INSERT INTO `sys_apis` VALUES (12, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/api/createApi', '创建api', 'api', 'POST');
INSERT INTO `sys_apis` VALUES (13, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/api/deleteApi', '删除Api', 'api', 'POST');
INSERT INTO `sys_apis` VALUES (14, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/api/updateApi', '更新Api', 'api', 'POST');
INSERT INTO `sys_apis` VALUES (15, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/api/getApiList', '获取api列表', 'api', 'POST');
INSERT INTO `sys_apis` VALUES (16, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/api/getAllApis', '获取所有api', 'api', 'POST');
INSERT INTO `sys_apis` VALUES (17, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/api/getApiById', '获取api详细信息', 'api', 'POST');
INSERT INTO `sys_apis` VALUES (18, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/api/deleteApisByIds', '批量删除api', 'api', 'DELETE');
INSERT INTO `sys_apis` VALUES (19, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/authority/copyAuthority', '拷贝角色', '角色', 'POST');
INSERT INTO `sys_apis` VALUES (20, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/authority/createAuthority', '创建角色', '角色', 'POST');
INSERT INTO `sys_apis` VALUES (21, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/authority/deleteAuthority', '删除角色', '角色', 'POST');
INSERT INTO `sys_apis` VALUES (22, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/authority/updateAuthority', '更新角色信息', '角色', 'PUT');
INSERT INTO `sys_apis` VALUES (23, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/authority/getAuthorityList', '获取角色列表', '角色', 'POST');
INSERT INTO `sys_apis` VALUES (24, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/authority/setDataAuthority', '设置角色资源权限', '角色', 'POST');
INSERT INTO `sys_apis` VALUES (25, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/casbin/updateCasbin', '更改角色api权限', 'casbin', 'POST');
INSERT INTO `sys_apis` VALUES (26, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/casbin/getPolicyPathByAuthorityId', '获取权限列表', 'casbin', 'POST');
INSERT INTO `sys_apis` VALUES (27, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/menu/addBaseMenu', '新增菜单', '菜单', 'POST');
INSERT INTO `sys_apis` VALUES (28, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/menu/getMenu', '获取菜单树(必选)', '菜单', 'POST');
INSERT INTO `sys_apis` VALUES (29, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/menu/deleteBaseMenu', '删除菜单', '菜单', 'POST');
INSERT INTO `sys_apis` VALUES (30, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/menu/updateBaseMenu', '更新菜单', '菜单', 'POST');
INSERT INTO `sys_apis` VALUES (31, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/menu/getBaseMenuById', '根据id获取菜单', '菜单', 'POST');
INSERT INTO `sys_apis` VALUES (32, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/menu/getMenuList', '分页获取基础menu列表', '菜单', 'POST');
INSERT INTO `sys_apis` VALUES (33, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/menu/getBaseMenuTree', '获取用户动态路由', '菜单', 'POST');
INSERT INTO `sys_apis` VALUES (34, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/menu/getMenuAuthority', '获取指定角色menu', '菜单', 'POST');
INSERT INTO `sys_apis` VALUES (35, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/menu/addMenuAuthority', '增加menu和角色关联关系', '菜单', 'POST');
INSERT INTO `sys_apis` VALUES (36, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/fileUploadAndDownload/findFile', '寻找目标文件（秒传）', '分片上传', 'GET');
INSERT INTO `sys_apis` VALUES (37, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/fileUploadAndDownload/breakpointContinue', '断点续传', '分片上传', 'POST');
INSERT INTO `sys_apis` VALUES (38, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/fileUploadAndDownload/breakpointContinueFinish', '断点续传完成', '分片上传', 'POST');
INSERT INTO `sys_apis` VALUES (39, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/fileUploadAndDownload/removeChunk', '上传完成移除文件', '分片上传', 'POST');
INSERT INTO `sys_apis` VALUES (40, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/fileUploadAndDownload/upload', '文件上传示例', '文件上传与下载', 'POST');
INSERT INTO `sys_apis` VALUES (41, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/fileUploadAndDownload/deleteFile', '删除文件', '文件上传与下载', 'POST');
INSERT INTO `sys_apis` VALUES (42, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/fileUploadAndDownload/editFileName', '文件名或者备注编辑', '文件上传与下载', 'POST');
INSERT INTO `sys_apis` VALUES (43, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/fileUploadAndDownload/getFileList', '获取上传文件列表', '文件上传与下载', 'POST');
INSERT INTO `sys_apis` VALUES (44, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/system/getServerInfo', '获取服务器信息', '系统服务', 'POST');
INSERT INTO `sys_apis` VALUES (45, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/system/getSystemConfig', '获取配置文件内容', '系统服务', 'POST');
INSERT INTO `sys_apis` VALUES (46, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/system/setSystemConfig', '设置配置文件内容', '系统服务', 'POST');
INSERT INTO `sys_apis` VALUES (47, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/customer/customer', '更新客户', '客户', 'PUT');
INSERT INTO `sys_apis` VALUES (48, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/customer/customer', '创建客户', '客户', 'POST');
INSERT INTO `sys_apis` VALUES (49, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/customer/customer', '删除客户', '客户', 'DELETE');
INSERT INTO `sys_apis` VALUES (50, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/customer/customer', '获取单一客户', '客户', 'GET');
INSERT INTO `sys_apis` VALUES (51, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/customer/customerList', '获取客户列表', '客户', 'GET');
INSERT INTO `sys_apis` VALUES (52, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/autoCode/getDB', '获取所有数据库', '代码生成器', 'GET');
INSERT INTO `sys_apis` VALUES (53, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/autoCode/getTables', '获取数据库表', '代码生成器', 'GET');
INSERT INTO `sys_apis` VALUES (54, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/autoCode/createTemp', '自动化代码', '代码生成器', 'POST');
INSERT INTO `sys_apis` VALUES (55, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/autoCode/preview', '预览自动化代码', '代码生成器', 'POST');
INSERT INTO `sys_apis` VALUES (56, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/autoCode/getColumn', '获取所选table的所有字段', '代码生成器', 'GET');
INSERT INTO `sys_apis` VALUES (57, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/autoCode/createPlug', '自动创建插件包', '代码生成器', 'POST');
INSERT INTO `sys_apis` VALUES (58, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/autoCode/installPlugin', '安装插件', '代码生成器', 'POST');
INSERT INTO `sys_apis` VALUES (59, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/autoCode/pubPlug', '打包插件', '代码生成器', 'POST');
INSERT INTO `sys_apis` VALUES (60, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/autoCode/createPackage', '生成包(package)', '包（pkg）生成器', 'POST');
INSERT INTO `sys_apis` VALUES (61, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/autoCode/getPackage', '获取所有包(package)', '包（pkg）生成器', 'POST');
INSERT INTO `sys_apis` VALUES (62, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/autoCode/delPackage', '删除包(package)', '包（pkg）生成器', 'POST');
INSERT INTO `sys_apis` VALUES (63, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/autoCode/getMeta', '获取meta信息', '代码生成器历史', 'POST');
INSERT INTO `sys_apis` VALUES (64, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/autoCode/rollback', '回滚自动生成代码', '代码生成器历史', 'POST');
INSERT INTO `sys_apis` VALUES (65, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/autoCode/getSysHistory', '查询回滚记录', '代码生成器历史', 'POST');
INSERT INTO `sys_apis` VALUES (66, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/autoCode/delSysHistory', '删除回滚记录', '代码生成器历史', 'POST');
INSERT INTO `sys_apis` VALUES (67, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/sysDictionaryDetail/updateSysDictionaryDetail', '更新字典内容', '系统字典详情', 'PUT');
INSERT INTO `sys_apis` VALUES (68, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/sysDictionaryDetail/createSysDictionaryDetail', '新增字典内容', '系统字典详情', 'POST');
INSERT INTO `sys_apis` VALUES (69, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/sysDictionaryDetail/deleteSysDictionaryDetail', '删除字典内容', '系统字典详情', 'DELETE');
INSERT INTO `sys_apis` VALUES (70, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/sysDictionaryDetail/findSysDictionaryDetail', '根据ID获取字典内容', '系统字典详情', 'GET');
INSERT INTO `sys_apis` VALUES (71, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/sysDictionaryDetail/getSysDictionaryDetailList', '获取字典内容列表', '系统字典详情', 'GET');
INSERT INTO `sys_apis` VALUES (72, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/sysDictionary/createSysDictionary', '新增字典', '系统字典', 'POST');
INSERT INTO `sys_apis` VALUES (73, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/sysDictionary/deleteSysDictionary', '删除字典', '系统字典', 'DELETE');
INSERT INTO `sys_apis` VALUES (74, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/sysDictionary/updateSysDictionary', '更新字典', '系统字典', 'PUT');
INSERT INTO `sys_apis` VALUES (75, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/sysDictionary/findSysDictionary', '根据ID获取字典', '系统字典', 'GET');
INSERT INTO `sys_apis` VALUES (76, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/sysDictionary/getSysDictionaryList', '获取字典列表', '系统字典', 'GET');
INSERT INTO `sys_apis` VALUES (77, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/sysOperationRecord/createSysOperationRecord', '新增操作记录', '操作记录', 'POST');
INSERT INTO `sys_apis` VALUES (78, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/sysOperationRecord/findSysOperationRecord', '根据ID获取操作记录', '操作记录', 'GET');
INSERT INTO `sys_apis` VALUES (79, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/sysOperationRecord/getSysOperationRecordList', '获取操作记录列表', '操作记录', 'GET');
INSERT INTO `sys_apis` VALUES (80, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/sysOperationRecord/deleteSysOperationRecord', '删除操作记录', '操作记录', 'DELETE');
INSERT INTO `sys_apis` VALUES (81, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/sysOperationRecord/deleteSysOperationRecordByIds', '批量删除操作历史', '操作记录', 'DELETE');
INSERT INTO `sys_apis` VALUES (82, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/simpleUploader/upload', '插件版分片上传', '断点续传(插件版)', 'POST');
INSERT INTO `sys_apis` VALUES (83, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/simpleUploader/checkFileMd5', '文件完整度验证', '断点续传(插件版)', 'GET');
INSERT INTO `sys_apis` VALUES (84, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/simpleUploader/mergeFileMd5', '上传完成合并文件', '断点续传(插件版)', 'GET');
INSERT INTO `sys_apis` VALUES (85, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/email/emailTest', '发送测试邮件', 'email', 'POST');
INSERT INTO `sys_apis` VALUES (86, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/email/emailSend', '发送邮件示例', 'email', 'POST');
INSERT INTO `sys_apis` VALUES (87, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/authorityBtn/setAuthorityBtn', '设置按钮权限', '按钮权限', 'POST');
INSERT INTO `sys_apis` VALUES (88, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/authorityBtn/getAuthorityBtn', '获取已有按钮权限', '按钮权限', 'POST');
INSERT INTO `sys_apis` VALUES (89, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/authorityBtn/canRemoveAuthorityBtn', '删除按钮', '按钮权限', 'POST');
INSERT INTO `sys_apis` VALUES (90, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/sysExportTemplate/createSysExportTemplate', '新增导出模板', '表格模板', 'POST');
INSERT INTO `sys_apis` VALUES (91, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/sysExportTemplate/deleteSysExportTemplate', '删除导出模板', '表格模板', 'DELETE');
INSERT INTO `sys_apis` VALUES (92, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/sysExportTemplate/deleteSysExportTemplateByIds', '批量删除导出模板', '表格模板', 'DELETE');
INSERT INTO `sys_apis` VALUES (93, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/sysExportTemplate/updateSysExportTemplate', '更新导出模板', '表格模板', 'PUT');
INSERT INTO `sys_apis` VALUES (94, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/sysExportTemplate/findSysExportTemplate', '根据ID获取导出模板', '表格模板', 'GET');
INSERT INTO `sys_apis` VALUES (95, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/sysExportTemplate/getSysExportTemplateList', '获取导出模板列表', '表格模板', 'GET');
INSERT INTO `sys_apis` VALUES (96, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/sysExportTemplate/exportExcel', '导出Excel', '表格模板', 'GET');
INSERT INTO `sys_apis` VALUES (97, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/sysExportTemplate/exportTemplate', '下载模板', '表格模板', 'GET');
INSERT INTO `sys_apis` VALUES (98, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', NULL, '/sysExportTemplate/importExcel', '导入Excel', '表格模板', 'POST');

-- ----------------------------
-- Table structure for sys_authorities
-- ----------------------------
DROP TABLE IF EXISTS `sys_authorities`;
CREATE TABLE `sys_authorities`  (
  `created_at` datetime(3) NULL DEFAULT NULL,
  `updated_at` datetime(3) NULL DEFAULT NULL,
  `deleted_at` datetime(3) NULL DEFAULT NULL,
  `authority_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '角色ID',
  `authority_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '角色名',
  `parent_id` bigint(20) UNSIGNED NULL DEFAULT NULL COMMENT '父角色ID',
  `default_router` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'dashboard' COMMENT '默认菜单',
  PRIMARY KEY (`authority_id`) USING BTREE,
  UNIQUE INDEX `uni_sys_authorities_authority_id`(`authority_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9529 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_authorities
-- ----------------------------
INSERT INTO `sys_authorities` VALUES ('2024-05-05 09:33:22.509', '2024-05-05 11:53:19.641', NULL, 888, '管理员', 0, 'dashboard');
INSERT INTO `sys_authorities` VALUES ('2024-05-05 11:51:56.190', '2024-05-05 11:53:13.609', NULL, 9527, '开发', 0, 'dashboard');
INSERT INTO `sys_authorities` VALUES ('2024-05-05 09:33:22.509', '2024-05-05 09:33:23.309', NULL, 9528, '测试角色', 0, 'dashboard');

-- ----------------------------
-- Table structure for sys_authority_btns
-- ----------------------------
DROP TABLE IF EXISTS `sys_authority_btns`;
CREATE TABLE `sys_authority_btns`  (
  `authority_id` bigint(20) UNSIGNED NULL DEFAULT NULL COMMENT '角色ID',
  `sys_menu_id` bigint(20) UNSIGNED NULL DEFAULT NULL COMMENT '菜单ID',
  `sys_base_menu_btn_id` bigint(20) UNSIGNED NULL DEFAULT NULL COMMENT '菜单按钮ID'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_authority_btns
-- ----------------------------

-- ----------------------------
-- Table structure for sys_authority_menus
-- ----------------------------
DROP TABLE IF EXISTS `sys_authority_menus`;
CREATE TABLE `sys_authority_menus`  (
  `sys_base_menu_id` bigint(20) UNSIGNED NOT NULL,
  `sys_authority_authority_id` bigint(20) UNSIGNED NOT NULL COMMENT '角色ID',
  PRIMARY KEY (`sys_base_menu_id`, `sys_authority_authority_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_authority_menus
-- ----------------------------
INSERT INTO `sys_authority_menus` VALUES (1, 888);
INSERT INTO `sys_authority_menus` VALUES (1, 9527);
INSERT INTO `sys_authority_menus` VALUES (1, 9528);
INSERT INTO `sys_authority_menus` VALUES (3, 888);
INSERT INTO `sys_authority_menus` VALUES (3, 9527);
INSERT INTO `sys_authority_menus` VALUES (4, 888);
INSERT INTO `sys_authority_menus` VALUES (4, 9527);
INSERT INTO `sys_authority_menus` VALUES (5, 888);
INSERT INTO `sys_authority_menus` VALUES (5, 9527);
INSERT INTO `sys_authority_menus` VALUES (6, 888);
INSERT INTO `sys_authority_menus` VALUES (6, 9527);
INSERT INTO `sys_authority_menus` VALUES (7, 888);
INSERT INTO `sys_authority_menus` VALUES (7, 9527);
INSERT INTO `sys_authority_menus` VALUES (8, 888);
INSERT INTO `sys_authority_menus` VALUES (8, 9527);
INSERT INTO `sys_authority_menus` VALUES (8, 9528);
INSERT INTO `sys_authority_menus` VALUES (9, 888);
INSERT INTO `sys_authority_menus` VALUES (9, 9527);
INSERT INTO `sys_authority_menus` VALUES (10, 888);
INSERT INTO `sys_authority_menus` VALUES (10, 9527);
INSERT INTO `sys_authority_menus` VALUES (15, 888);
INSERT INTO `sys_authority_menus` VALUES (15, 9527);
INSERT INTO `sys_authority_menus` VALUES (16, 888);
INSERT INTO `sys_authority_menus` VALUES (16, 9527);
INSERT INTO `sys_authority_menus` VALUES (17, 888);
INSERT INTO `sys_authority_menus` VALUES (17, 9527);
INSERT INTO `sys_authority_menus` VALUES (18, 888);
INSERT INTO `sys_authority_menus` VALUES (18, 9527);
INSERT INTO `sys_authority_menus` VALUES (19, 888);
INSERT INTO `sys_authority_menus` VALUES (19, 9527);
INSERT INTO `sys_authority_menus` VALUES (20, 888);
INSERT INTO `sys_authority_menus` VALUES (20, 9527);
INSERT INTO `sys_authority_menus` VALUES (21, 888);
INSERT INTO `sys_authority_menus` VALUES (21, 9527);
INSERT INTO `sys_authority_menus` VALUES (30, 888);
INSERT INTO `sys_authority_menus` VALUES (30, 9527);

-- ----------------------------
-- Table structure for sys_auto_code_histories
-- ----------------------------
DROP TABLE IF EXISTS `sys_auto_code_histories`;
CREATE TABLE `sys_auto_code_histories`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `created_at` datetime(3) NULL DEFAULT NULL,
  `updated_at` datetime(3) NULL DEFAULT NULL,
  `deleted_at` datetime(3) NULL DEFAULT NULL,
  `package` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `business_db` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `table_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `menu_id` bigint(20) UNSIGNED NULL DEFAULT NULL,
  `request_meta` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `auto_code_path` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `injection_meta` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `struct_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `struct_cn_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `api_ids` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `flag` bigint(20) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_sys_auto_code_histories_deleted_at`(`deleted_at`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_auto_code_histories
-- ----------------------------

-- ----------------------------
-- Table structure for sys_auto_codes
-- ----------------------------
DROP TABLE IF EXISTS `sys_auto_codes`;
CREATE TABLE `sys_auto_codes`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `created_at` datetime(3) NULL DEFAULT NULL,
  `updated_at` datetime(3) NULL DEFAULT NULL,
  `deleted_at` datetime(3) NULL DEFAULT NULL,
  `package_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '包名',
  `label` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '展示名',
  `desc` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '描述',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_sys_auto_codes_deleted_at`(`deleted_at`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_auto_codes
-- ----------------------------

-- ----------------------------
-- Table structure for sys_base_menu_btns
-- ----------------------------
DROP TABLE IF EXISTS `sys_base_menu_btns`;
CREATE TABLE `sys_base_menu_btns`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `created_at` datetime(3) NULL DEFAULT NULL,
  `updated_at` datetime(3) NULL DEFAULT NULL,
  `deleted_at` datetime(3) NULL DEFAULT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '按钮关键key',
  `desc` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `sys_base_menu_id` bigint(20) UNSIGNED NULL DEFAULT NULL COMMENT '菜单ID',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_sys_base_menu_btns_deleted_at`(`deleted_at`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_base_menu_btns
-- ----------------------------

-- ----------------------------
-- Table structure for sys_base_menu_parameters
-- ----------------------------
DROP TABLE IF EXISTS `sys_base_menu_parameters`;
CREATE TABLE `sys_base_menu_parameters`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `created_at` datetime(3) NULL DEFAULT NULL,
  `updated_at` datetime(3) NULL DEFAULT NULL,
  `deleted_at` datetime(3) NULL DEFAULT NULL,
  `sys_base_menu_id` bigint(20) UNSIGNED NULL DEFAULT NULL,
  `type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '地址栏携带参数为params还是query',
  `key` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '地址栏携带参数的key',
  `value` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '地址栏携带参数的值',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_sys_base_menu_parameters_deleted_at`(`deleted_at`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_base_menu_parameters
-- ----------------------------

-- ----------------------------
-- Table structure for sys_base_menus
-- ----------------------------
DROP TABLE IF EXISTS `sys_base_menus`;
CREATE TABLE `sys_base_menus`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `created_at` datetime(3) NULL DEFAULT NULL,
  `updated_at` datetime(3) NULL DEFAULT NULL,
  `deleted_at` datetime(3) NULL DEFAULT NULL,
  `menu_level` bigint(20) UNSIGNED NULL DEFAULT NULL,
  `parent_id` bigint(20) UNSIGNED NULL DEFAULT NULL COMMENT '父菜单ID',
  `path` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '路由path',
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '路由name',
  `hidden` tinyint(1) NULL DEFAULT NULL COMMENT '是否在列表隐藏',
  `component` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '对应前端文件路径',
  `sort` bigint(20) NULL DEFAULT NULL COMMENT '排序标记',
  `active_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '附加属性',
  `keep_alive` tinyint(1) NULL DEFAULT NULL COMMENT '附加属性',
  `default_menu` tinyint(1) NULL DEFAULT NULL COMMENT '附加属性',
  `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '附加属性',
  `icon` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '附加属性',
  `close_tab` tinyint(1) NULL DEFAULT NULL COMMENT '附加属性',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_sys_base_menus_deleted_at`(`deleted_at`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 31 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_base_menus
-- ----------------------------
INSERT INTO `sys_base_menus` VALUES (1, '2024-05-05 09:33:22.942', '2024-05-05 09:33:22.942', NULL, 0, 0, 'dashboard', 'dashboard', 0, 'view/dashboard/index.vue', 1, '', 0, 0, '仪表盘', 'odometer', 0);
INSERT INTO `sys_base_menus` VALUES (2, '2024-05-05 09:33:22.942', '2024-05-05 09:33:22.942', '2024-05-06 16:04:20.447', 0, 0, 'about', 'about', 0, 'view/about/index.vue', 9, '', 0, 0, '关于我们', 'info-filled', 0);
INSERT INTO `sys_base_menus` VALUES (3, '2024-05-05 09:33:22.942', '2024-05-05 09:33:22.942', NULL, 0, 0, 'admin', 'superAdmin', 0, 'view/superAdmin/index.vue', 3, '', 0, 0, '超级管理员', 'user', 0);
INSERT INTO `sys_base_menus` VALUES (4, '2024-05-05 09:33:22.942', '2024-05-05 09:33:22.942', NULL, 0, 3, 'authority', 'authority', 0, 'view/superAdmin/authority/authority.vue', 1, '', 0, 0, '角色管理', 'avatar', 0);
INSERT INTO `sys_base_menus` VALUES (5, '2024-05-05 09:33:22.942', '2024-05-05 09:33:22.942', NULL, 0, 3, 'menu', 'menu', 0, 'view/superAdmin/menu/menu.vue', 2, '', 1, 0, '菜单管理', 'tickets', 0);
INSERT INTO `sys_base_menus` VALUES (6, '2024-05-05 09:33:22.942', '2024-05-05 09:33:22.942', NULL, 0, 3, 'api', 'api', 0, 'view/superAdmin/api/api.vue', 3, '', 1, 0, 'api管理', 'platform', 0);
INSERT INTO `sys_base_menus` VALUES (7, '2024-05-05 09:33:22.942', '2024-05-05 09:33:22.942', NULL, 0, 3, 'user', 'user', 0, 'view/superAdmin/user/user.vue', 4, '', 0, 0, '用户管理', 'coordinate', 0);
INSERT INTO `sys_base_menus` VALUES (8, '2024-05-05 09:33:22.942', '2024-05-05 09:33:22.942', NULL, 0, 3, 'dictionary', 'dictionary', 0, 'view/superAdmin/dictionary/sysDictionary.vue', 5, '', 0, 0, '字典管理', 'notebook', 0);
INSERT INTO `sys_base_menus` VALUES (9, '2024-05-05 09:33:22.942', '2024-05-05 09:33:22.942', NULL, 0, 3, 'operation', 'operation', 0, 'view/superAdmin/operation/sysOperationRecord.vue', 6, '', 0, 0, '操作历史', 'pie-chart', 0);
INSERT INTO `sys_base_menus` VALUES (10, '2024-05-05 09:33:22.942', '2024-05-05 09:33:22.942', NULL, 0, 0, 'person', 'person', 1, 'view/person/person.vue', 4, '', 0, 0, '个人信息', 'message', 0);
INSERT INTO `sys_base_menus` VALUES (11, '2024-05-05 09:33:22.942', '2024-05-05 09:33:22.942', '2024-05-06 16:05:05.687', 0, 0, 'example', 'example', 0, 'view/example/index.vue', 7, '', 0, 0, '示例文件', 'management', 0);
INSERT INTO `sys_base_menus` VALUES (12, '2024-05-05 09:33:22.942', '2024-05-05 09:33:22.942', '2024-05-06 16:04:59.431', 0, 11, 'upload', 'upload', 0, 'view/example/upload/upload.vue', 5, '', 0, 0, '媒体库（上传下载）', 'upload', 0);
INSERT INTO `sys_base_menus` VALUES (13, '2024-05-05 09:33:22.942', '2024-05-05 09:33:22.942', '2024-05-06 16:05:01.431', 0, 11, 'breakpoint', 'breakpoint', 0, 'view/example/breakpoint/breakpoint.vue', 6, '', 0, 0, '断点续传', 'upload-filled', 0);
INSERT INTO `sys_base_menus` VALUES (14, '2024-05-05 09:33:22.942', '2024-05-05 09:33:22.942', '2024-05-06 16:05:03.158', 0, 11, 'customer', 'customer', 0, 'view/example/customer/customer.vue', 7, '', 0, 0, '客户列表（资源示例）', 'avatar', 0);
INSERT INTO `sys_base_menus` VALUES (15, '2024-05-05 09:33:22.942', '2024-05-05 09:33:22.942', NULL, 0, 0, 'systemTools', 'systemTools', 0, 'view/systemTools/index.vue', 5, '', 0, 0, '系统工具', 'tools', 0);
INSERT INTO `sys_base_menus` VALUES (16, '2024-05-05 09:33:22.942', '2024-05-05 09:33:22.942', NULL, 0, 15, 'autoCode', 'autoCode', 0, 'view/systemTools/autoCode/index.vue', 1, '', 1, 0, '代码生成器', 'cpu', 0);
INSERT INTO `sys_base_menus` VALUES (17, '2024-05-05 09:33:22.942', '2024-05-05 09:33:22.942', NULL, 0, 15, 'formCreate', 'formCreate', 0, 'view/systemTools/formCreate/index.vue', 2, '', 1, 0, '表单生成器', 'magic-stick', 0);
INSERT INTO `sys_base_menus` VALUES (18, '2024-05-05 09:33:22.942', '2024-05-05 09:33:22.942', NULL, 0, 15, 'system', 'system', 0, 'view/systemTools/system/system.vue', 3, '', 0, 0, '系统配置', 'operation', 0);
INSERT INTO `sys_base_menus` VALUES (19, '2024-05-05 09:33:22.942', '2024-05-05 09:33:22.942', NULL, 0, 15, 'autoCodeAdmin', 'autoCodeAdmin', 0, 'view/systemTools/autoCodeAdmin/index.vue', 1, '', 0, 0, '自动化代码管理', 'magic-stick', 0);
INSERT INTO `sys_base_menus` VALUES (20, '2024-05-05 09:33:22.942', '2024-05-05 09:33:22.942', NULL, 0, 15, 'autoCodeEdit/:id', 'autoCodeEdit', 1, 'view/systemTools/autoCode/index.vue', 0, '', 0, 0, '自动化代码-${id}', 'magic-stick', 0);
INSERT INTO `sys_base_menus` VALUES (21, '2024-05-05 09:33:22.942', '2024-05-05 09:33:22.942', NULL, 0, 15, 'autoPkg', 'autoPkg', 0, 'view/systemTools/autoPkg/autoPkg.vue', 0, '', 0, 0, '自动化package', 'folder', 0);
INSERT INTO `sys_base_menus` VALUES (22, '2024-05-05 09:33:22.942', '2024-05-05 09:33:22.942', '2024-05-06 16:04:15.452', 0, 0, 'https://www.gin-vue-admin.com', 'https://www.gin-vue-admin.com', 0, '/', 0, '', 0, 0, '官方网站', 'customer-gva', 0);
INSERT INTO `sys_base_menus` VALUES (23, '2024-05-05 09:33:22.942', '2024-05-05 09:33:22.942', '2024-05-06 16:19:08.567', 0, 0, 'state', 'state', 0, 'view/system/state.vue', 8, '', 0, 0, '服务器状态', 'cloudy', 0);
INSERT INTO `sys_base_menus` VALUES (24, '2024-05-05 09:33:22.942', '2024-05-05 09:33:22.942', '2024-05-06 16:04:54.447', 0, 0, 'plugin', 'plugin', 0, 'view/routerHolder.vue', 6, '', 0, 0, '插件系统', 'cherry', 0);
INSERT INTO `sys_base_menus` VALUES (25, '2024-05-05 09:33:22.942', '2024-05-05 09:33:22.942', '2024-05-06 16:04:41.831', 0, 24, 'https://plugin.gin-vue-admin.com/', 'https://plugin.gin-vue-admin.com/', 0, 'https://plugin.gin-vue-admin.com/', 0, '', 0, 0, '插件市场', 'shop', 0);
INSERT INTO `sys_base_menus` VALUES (26, '2024-05-05 09:33:22.942', '2024-05-05 09:33:22.942', '2024-05-06 16:04:43.863', 0, 24, 'installPlugin', 'installPlugin', 0, 'view/systemTools/installPlugin/index.vue', 1, '', 0, 0, '插件安装', 'box', 0);
INSERT INTO `sys_base_menus` VALUES (27, '2024-05-05 09:33:22.942', '2024-05-05 09:33:22.942', '2024-05-06 16:04:46.118', 0, 24, 'autoPlug', 'autoPlug', 0, 'view/systemTools/autoPlug/autoPlug.vue', 2, '', 0, 0, '插件模板', 'folder', 0);
INSERT INTO `sys_base_menus` VALUES (28, '2024-05-05 09:33:22.942', '2024-05-05 09:33:22.942', '2024-05-06 16:04:48.575', 0, 24, 'pubPlug', 'pubPlug', 0, 'view/systemTools/pubPlug/pubPlug.vue', 3, '', 0, 0, '打包插件', 'files', 0);
INSERT INTO `sys_base_menus` VALUES (29, '2024-05-05 09:33:22.942', '2024-05-05 09:33:22.942', '2024-05-06 16:04:50.983', 0, 24, 'plugin-email', 'plugin-email', 0, 'plugin/email/view/index.vue', 4, '', 0, 0, '邮件插件', 'message', 0);
INSERT INTO `sys_base_menus` VALUES (30, '2024-05-05 09:33:22.942', '2024-05-05 09:33:22.942', NULL, 0, 15, 'exportTemplate', 'exportTemplate', 0, 'view/systemTools/exportTemplate/exportTemplate.vue', 10, '', 0, 0, '表格模板', 'reading', 0);

-- ----------------------------
-- Table structure for sys_data_authority_id
-- ----------------------------
DROP TABLE IF EXISTS `sys_data_authority_id`;
CREATE TABLE `sys_data_authority_id`  (
  `sys_authority_authority_id` bigint(20) UNSIGNED NOT NULL COMMENT '角色ID',
  `data_authority_id_authority_id` bigint(20) UNSIGNED NOT NULL COMMENT '角色ID',
  PRIMARY KEY (`sys_authority_authority_id`, `data_authority_id_authority_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_data_authority_id
-- ----------------------------
INSERT INTO `sys_data_authority_id` VALUES (888, 888);
INSERT INTO `sys_data_authority_id` VALUES (888, 9528);
INSERT INTO `sys_data_authority_id` VALUES (9527, 888);
INSERT INTO `sys_data_authority_id` VALUES (9527, 9527);
INSERT INTO `sys_data_authority_id` VALUES (9527, 9528);
INSERT INTO `sys_data_authority_id` VALUES (9528, 8881);
INSERT INTO `sys_data_authority_id` VALUES (9528, 9528);

-- ----------------------------
-- Table structure for sys_dictionaries
-- ----------------------------
DROP TABLE IF EXISTS `sys_dictionaries`;
CREATE TABLE `sys_dictionaries`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `created_at` datetime(3) NULL DEFAULT NULL,
  `updated_at` datetime(3) NULL DEFAULT NULL,
  `deleted_at` datetime(3) NULL DEFAULT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '字典名（中）',
  `type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '字典名（英）',
  `status` tinyint(1) NULL DEFAULT NULL COMMENT '状态',
  `desc` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '描述',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_sys_dictionaries_deleted_at`(`deleted_at`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_dictionaries
-- ----------------------------
INSERT INTO `sys_dictionaries` VALUES (1, '2024-05-05 09:33:22.617', '2024-05-05 09:33:22.700', NULL, '性别', 'gender', 1, '性别字典');
INSERT INTO `sys_dictionaries` VALUES (2, '2024-05-05 09:33:22.617', '2024-05-05 09:33:22.725', NULL, '数据库int类型', 'int', 1, 'int类型对应的数据库类型');
INSERT INTO `sys_dictionaries` VALUES (3, '2024-05-05 09:33:22.617', '2024-05-05 09:33:22.775', NULL, '数据库时间日期类型', 'time.Time', 1, '数据库时间日期类型');
INSERT INTO `sys_dictionaries` VALUES (4, '2024-05-05 09:33:22.617', '2024-05-05 09:33:22.842', NULL, '数据库浮点型', 'float64', 1, '数据库浮点型');
INSERT INTO `sys_dictionaries` VALUES (5, '2024-05-05 09:33:22.617', '2024-05-05 09:33:22.866', NULL, '数据库字符串', 'string', 1, '数据库字符串');
INSERT INTO `sys_dictionaries` VALUES (6, '2024-05-05 09:33:22.617', '2024-05-05 09:33:22.892', NULL, '数据库bool类型', 'bool', 1, '数据库bool类型');

-- ----------------------------
-- Table structure for sys_dictionary_details
-- ----------------------------
DROP TABLE IF EXISTS `sys_dictionary_details`;
CREATE TABLE `sys_dictionary_details`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `created_at` datetime(3) NULL DEFAULT NULL,
  `updated_at` datetime(3) NULL DEFAULT NULL,
  `deleted_at` datetime(3) NULL DEFAULT NULL,
  `label` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '展示值',
  `value` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '字典值',
  `extend` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '扩展值',
  `status` tinyint(1) NULL DEFAULT NULL COMMENT '启用状态',
  `sort` bigint(20) NULL DEFAULT NULL COMMENT '排序标记',
  `sys_dictionary_id` bigint(20) UNSIGNED NULL DEFAULT NULL COMMENT '关联标记',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_sys_dictionary_details_deleted_at`(`deleted_at`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 34 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_dictionary_details
-- ----------------------------
INSERT INTO `sys_dictionary_details` VALUES (1, '2024-05-05 09:33:22.700', '2024-05-05 09:33:22.700', NULL, '男', '1', '', 1, 1, 1);
INSERT INTO `sys_dictionary_details` VALUES (2, '2024-05-05 09:33:22.700', '2024-05-05 09:33:22.700', NULL, '女', '2', '', 1, 2, 1);
INSERT INTO `sys_dictionary_details` VALUES (3, '2024-05-05 09:33:22.725', '2024-05-05 09:33:22.725', NULL, 'smallint', '1', 'mysql', 1, 1, 2);
INSERT INTO `sys_dictionary_details` VALUES (4, '2024-05-05 09:33:22.725', '2024-05-05 09:33:22.725', NULL, 'mediumint', '2', 'mysql', 1, 2, 2);
INSERT INTO `sys_dictionary_details` VALUES (5, '2024-05-05 09:33:22.725', '2024-05-05 09:33:22.725', NULL, 'int', '3', 'mysql', 1, 3, 2);
INSERT INTO `sys_dictionary_details` VALUES (6, '2024-05-05 09:33:22.725', '2024-05-05 09:33:22.725', NULL, 'bigint', '4', 'mysql', 1, 4, 2);
INSERT INTO `sys_dictionary_details` VALUES (7, '2024-05-05 09:33:22.725', '2024-05-05 09:33:22.725', NULL, 'int2', '5', 'pgsql', 1, 5, 2);
INSERT INTO `sys_dictionary_details` VALUES (8, '2024-05-05 09:33:22.725', '2024-05-05 09:33:22.725', NULL, 'int4', '6', 'pgsql', 1, 6, 2);
INSERT INTO `sys_dictionary_details` VALUES (9, '2024-05-05 09:33:22.725', '2024-05-05 09:33:22.725', NULL, 'int6', '7', 'pgsql', 1, 7, 2);
INSERT INTO `sys_dictionary_details` VALUES (10, '2024-05-05 09:33:22.725', '2024-05-05 09:33:22.725', NULL, 'int8', '8', 'pgsql', 1, 8, 2);
INSERT INTO `sys_dictionary_details` VALUES (11, '2024-05-05 09:33:22.776', '2024-05-05 09:33:22.776', NULL, 'date', '', '', 1, 0, 3);
INSERT INTO `sys_dictionary_details` VALUES (12, '2024-05-05 09:33:22.776', '2024-05-05 09:33:22.776', NULL, 'time', '1', 'mysql', 1, 1, 3);
INSERT INTO `sys_dictionary_details` VALUES (13, '2024-05-05 09:33:22.776', '2024-05-05 09:33:22.776', NULL, 'year', '2', 'mysql', 1, 2, 3);
INSERT INTO `sys_dictionary_details` VALUES (14, '2024-05-05 09:33:22.776', '2024-05-05 09:33:22.776', NULL, 'datetime', '3', 'mysql', 1, 3, 3);
INSERT INTO `sys_dictionary_details` VALUES (15, '2024-05-05 09:33:22.776', '2024-05-05 09:33:22.776', NULL, 'timestamp', '5', 'mysql', 1, 5, 3);
INSERT INTO `sys_dictionary_details` VALUES (16, '2024-05-05 09:33:22.776', '2024-05-05 09:33:22.776', NULL, 'timestamptz', '6', 'pgsql', 1, 5, 3);
INSERT INTO `sys_dictionary_details` VALUES (17, '2024-05-05 09:33:22.842', '2024-05-05 09:33:22.842', NULL, 'float', '', '', 1, 0, 4);
INSERT INTO `sys_dictionary_details` VALUES (18, '2024-05-05 09:33:22.842', '2024-05-05 09:33:22.842', NULL, 'double', '1', 'mysql', 1, 1, 4);
INSERT INTO `sys_dictionary_details` VALUES (19, '2024-05-05 09:33:22.842', '2024-05-05 09:33:22.842', NULL, 'decimal', '2', 'mysql', 1, 2, 4);
INSERT INTO `sys_dictionary_details` VALUES (20, '2024-05-05 09:33:22.842', '2024-05-05 09:33:22.842', NULL, 'numeric', '3', 'pgsql', 1, 3, 4);
INSERT INTO `sys_dictionary_details` VALUES (21, '2024-05-05 09:33:22.842', '2024-05-05 09:33:22.842', NULL, 'smallserial', '4', 'pgsql', 1, 4, 4);
INSERT INTO `sys_dictionary_details` VALUES (22, '2024-05-05 09:33:22.866', '2024-05-05 09:33:22.866', NULL, 'char', '', '', 1, 0, 5);
INSERT INTO `sys_dictionary_details` VALUES (23, '2024-05-05 09:33:22.866', '2024-05-05 09:33:22.866', NULL, 'varchar', '1', 'mysql', 1, 1, 5);
INSERT INTO `sys_dictionary_details` VALUES (24, '2024-05-05 09:33:22.866', '2024-05-05 09:33:22.866', NULL, 'tinyblob', '2', 'mysql', 1, 2, 5);
INSERT INTO `sys_dictionary_details` VALUES (25, '2024-05-05 09:33:22.866', '2024-05-05 09:33:22.866', NULL, 'tinytext', '3', 'mysql', 1, 3, 5);
INSERT INTO `sys_dictionary_details` VALUES (26, '2024-05-05 09:33:22.866', '2024-05-05 09:33:22.866', NULL, 'text', '4', 'mysql', 1, 4, 5);
INSERT INTO `sys_dictionary_details` VALUES (27, '2024-05-05 09:33:22.866', '2024-05-05 09:33:22.866', NULL, 'blob', '5', 'mysql', 1, 5, 5);
INSERT INTO `sys_dictionary_details` VALUES (28, '2024-05-05 09:33:22.866', '2024-05-05 09:33:22.866', NULL, 'mediumblob', '6', 'mysql', 1, 6, 5);
INSERT INTO `sys_dictionary_details` VALUES (29, '2024-05-05 09:33:22.866', '2024-05-05 09:33:22.866', NULL, 'mediumtext', '7', 'mysql', 1, 7, 5);
INSERT INTO `sys_dictionary_details` VALUES (30, '2024-05-05 09:33:22.866', '2024-05-05 09:33:22.866', NULL, 'longblob', '8', 'mysql', 1, 8, 5);
INSERT INTO `sys_dictionary_details` VALUES (31, '2024-05-05 09:33:22.866', '2024-05-05 09:33:22.866', NULL, 'longtext', '9', 'mysql', 1, 9, 5);
INSERT INTO `sys_dictionary_details` VALUES (32, '2024-05-05 09:33:22.892', '2024-05-05 09:33:22.892', NULL, 'tinyint', '1', 'mysql', 1, 0, 6);
INSERT INTO `sys_dictionary_details` VALUES (33, '2024-05-05 09:33:22.892', '2024-05-05 09:33:22.892', NULL, 'bool', '2', 'pgsql', 1, 0, 6);

-- ----------------------------
-- Table structure for sys_export_template_condition
-- ----------------------------
DROP TABLE IF EXISTS `sys_export_template_condition`;
CREATE TABLE `sys_export_template_condition`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `created_at` datetime(3) NULL DEFAULT NULL,
  `updated_at` datetime(3) NULL DEFAULT NULL,
  `deleted_at` datetime(3) NULL DEFAULT NULL,
  `template_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '模板标识',
  `from` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '条件取的key',
  `column` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '作为查询条件的字段',
  `operator` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '操作符',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_sys_export_template_condition_deleted_at`(`deleted_at`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_export_template_condition
-- ----------------------------

-- ----------------------------
-- Table structure for sys_export_template_join
-- ----------------------------
DROP TABLE IF EXISTS `sys_export_template_join`;
CREATE TABLE `sys_export_template_join`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `created_at` datetime(3) NULL DEFAULT NULL,
  `updated_at` datetime(3) NULL DEFAULT NULL,
  `deleted_at` datetime(3) NULL DEFAULT NULL,
  `template_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '模板标识',
  `joins` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '关联',
  `table` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '关联表',
  `on` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '关联条件',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_sys_export_template_join_deleted_at`(`deleted_at`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_export_template_join
-- ----------------------------

-- ----------------------------
-- Table structure for sys_export_templates
-- ----------------------------
DROP TABLE IF EXISTS `sys_export_templates`;
CREATE TABLE `sys_export_templates`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `created_at` datetime(3) NULL DEFAULT NULL,
  `updated_at` datetime(3) NULL DEFAULT NULL,
  `deleted_at` datetime(3) NULL DEFAULT NULL,
  `db_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '数据库名称',
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '模板名称',
  `table_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '表名称',
  `template_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '模板标识',
  `template_info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `limit` bigint(20) NULL DEFAULT NULL COMMENT '导出限制',
  `order` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '排序',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_sys_export_templates_deleted_at`(`deleted_at`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_export_templates
-- ----------------------------
INSERT INTO `sys_export_templates` VALUES (1, '2024-05-05 09:33:23.234', '2024-05-05 09:33:23.234', NULL, '', 'api', 'sys_apis', 'api', '{\n\"path\":\"路径\",\n\"method\":\"方法（大写）\",\n\"description\":\"方法介绍\",\n\"api_group\":\"方法分组\"\n}', 0, '');

-- ----------------------------
-- Table structure for sys_operation_records
-- ----------------------------
DROP TABLE IF EXISTS `sys_operation_records`;
CREATE TABLE `sys_operation_records`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `created_at` datetime(3) NULL DEFAULT NULL,
  `updated_at` datetime(3) NULL DEFAULT NULL,
  `deleted_at` datetime(3) NULL DEFAULT NULL,
  `ip` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '请求ip',
  `method` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '请求方法',
  `path` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '请求路径',
  `status` bigint(20) NULL DEFAULT NULL COMMENT '请求状态',
  `latency` bigint(20) NULL DEFAULT NULL COMMENT '延迟',
  `agent` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '代理',
  `error_message` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '错误信息',
  `body` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '请求Body',
  `resp` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '响应Body',
  `user_id` bigint(20) UNSIGNED NULL DEFAULT NULL COMMENT '用户id',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_sys_operation_records_deleted_at`(`deleted_at`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 78 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_operation_records
-- ----------------------------
INSERT INTO `sys_operation_records` VALUES (1, '2024-05-05 09:36:07.887', '2024-05-05 09:36:07.887', NULL, '127.0.0.1', 'POST', '/user/setUserAuthority', 200, 26946600, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '{\"authorityId\":8881}', '{\"code\":0,\"data\":{},\"msg\":\"修改成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (2, '2024-05-05 09:36:12.456', '2024-05-05 09:36:12.456', NULL, '127.0.0.1', 'POST', '/user/setUserAuthority', 200, 27925300, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '{\"authorityId\":9528}', '{\"code\":0,\"data\":{},\"msg\":\"修改成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (3, '2024-05-05 09:36:21.084', '2024-05-05 09:36:21.084', NULL, '127.0.0.1', 'POST', '/user/setUserAuthority', 200, 22994300, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '{\"authorityId\":888}', '{\"code\":0,\"data\":{},\"msg\":\"修改成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (4, '2024-05-05 09:45:47.004', '2024-05-05 09:45:47.004', NULL, '127.0.0.1', 'POST', '/customer/customer', 200, 45384100, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '{\"customerName\":\"程潜\",\"customerPhoneData\":\"17365743261\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (5, '2024-05-05 09:46:00.347', '2024-05-05 09:46:00.347', NULL, '127.0.0.1', 'POST', '/system/getServerInfo', 200, 249332800, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '', '{\"code\":0,\"data\":{\"server\":{\"os\":{\"goos\":\"windows\",\"numCpu\":12,\"compiler\":\"gc\",\"goVersion\":\"go1.22.0\",\"numGoroutine\":10},\"cpu\":{\"cpus\":[0,0,0,0,0,7.6923076923076925,0,0,7.6923076923076925,0,0,0],\"cores\":6},\"ram\":{\"usedMb\":10405,\"totalMb\":16315,\"usedPercent\":63},\"disk\":{\"usedMb\":37043,\"usedGb\":36,\"totalMb\":953866,\"totalGb\":931,\"usedPercent\":3}}},\"msg\":\"获取成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (6, '2024-05-05 09:46:10.312', '2024-05-05 09:46:10.312', NULL, '127.0.0.1', 'POST', '/system/getServerInfo', 200, 215445300, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '', '{\"code\":0,\"data\":{\"server\":{\"os\":{\"goos\":\"windows\",\"numCpu\":12,\"compiler\":\"gc\",\"goVersion\":\"go1.22.0\",\"numGoroutine\":10},\"cpu\":{\"cpus\":[0,0,0,0,0,0,0,0,0,0,0,0],\"cores\":6},\"ram\":{\"usedMb\":10388,\"totalMb\":16315,\"usedPercent\":63},\"disk\":{\"usedMb\":37043,\"usedGb\":36,\"totalMb\":953866,\"totalGb\":931,\"usedPercent\":3}}},\"msg\":\"获取成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (7, '2024-05-05 09:46:20.320', '2024-05-05 09:46:20.320', NULL, '127.0.0.1', 'POST', '/system/getServerInfo', 200, 219807100, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '', '{\"code\":0,\"data\":{\"server\":{\"os\":{\"goos\":\"windows\",\"numCpu\":12,\"compiler\":\"gc\",\"goVersion\":\"go1.22.0\",\"numGoroutine\":10},\"cpu\":{\"cpus\":[0,0,0,0,0,0,0,0,0,0,0,0],\"cores\":6},\"ram\":{\"usedMb\":10385,\"totalMb\":16315,\"usedPercent\":63},\"disk\":{\"usedMb\":37043,\"usedGb\":36,\"totalMb\":953866,\"totalGb\":931,\"usedPercent\":3}}},\"msg\":\"获取成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (8, '2024-05-05 09:46:30.329', '2024-05-05 09:46:30.329', NULL, '127.0.0.1', 'POST', '/system/getServerInfo', 200, 217773500, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '', '{\"code\":0,\"data\":{\"server\":{\"os\":{\"goos\":\"windows\",\"numCpu\":12,\"compiler\":\"gc\",\"goVersion\":\"go1.22.0\",\"numGoroutine\":10},\"cpu\":{\"cpus\":[0,0,0,0,0,0,0,0,0,0,0,0],\"cores\":6},\"ram\":{\"usedMb\":10382,\"totalMb\":16315,\"usedPercent\":63},\"disk\":{\"usedMb\":37043,\"usedGb\":36,\"totalMb\":953866,\"totalGb\":931,\"usedPercent\":3}}},\"msg\":\"获取成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (9, '2024-05-05 09:46:40.317', '2024-05-05 09:46:40.317', NULL, '127.0.0.1', 'POST', '/system/getServerInfo', 200, 220119800, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '', '{\"code\":0,\"data\":{\"server\":{\"os\":{\"goos\":\"windows\",\"numCpu\":12,\"compiler\":\"gc\",\"goVersion\":\"go1.22.0\",\"numGoroutine\":10},\"cpu\":{\"cpus\":[0,0,0,0,0,0,0,0,0,0,0,0],\"cores\":6},\"ram\":{\"usedMb\":10383,\"totalMb\":16315,\"usedPercent\":63},\"disk\":{\"usedMb\":37043,\"usedGb\":36,\"totalMb\":953866,\"totalGb\":931,\"usedPercent\":3}}},\"msg\":\"获取成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (10, '2024-05-05 09:46:43.152', '2024-05-05 09:46:43.152', NULL, '127.0.0.1', 'POST', '/system/getServerInfo', 200, 219301600, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '', '{\"code\":0,\"data\":{\"server\":{\"os\":{\"goos\":\"windows\",\"numCpu\":12,\"compiler\":\"gc\",\"goVersion\":\"go1.22.0\",\"numGoroutine\":10},\"cpu\":{\"cpus\":[0,0,7.6923076923076925,0,7.6923076923076925,0,0,0,0,0,0,0],\"cores\":6},\"ram\":{\"usedMb\":10401,\"totalMb\":16315,\"usedPercent\":63},\"disk\":{\"usedMb\":37043,\"usedGb\":36,\"totalMb\":953866,\"totalGb\":931,\"usedPercent\":3}}},\"msg\":\"获取成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (11, '2024-05-05 09:47:37.573', '2024-05-05 09:47:37.573', NULL, '127.0.0.1', 'POST', '/email/emailTest', 200, 2212377900, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '', '{\"code\":7,\"data\":{},\"msg\":\"发送失败\"}', 1);
INSERT INTO `sys_operation_records` VALUES (12, '2024-05-05 11:50:36.277', '2024-05-05 11:50:36.277', NULL, '127.0.0.1', 'PUT', '/authority/updateAuthority', 200, 51173100, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '{\"authorityId\":888,\"authorityName\":\"管理员\",\"parentId\":0}', '{\"code\":0,\"data\":{\"authority\":{\"CreatedAt\":\"0001-01-01T00:00:00Z\",\"UpdatedAt\":\"0001-01-01T00:00:00Z\",\"DeletedAt\":null,\"authorityId\":888,\"authorityName\":\"管理员\",\"parentId\":0,\"dataAuthorityId\":null,\"children\":null,\"menus\":null,\"defaultRouter\":\"\"}},\"msg\":\"更新成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (13, '2024-05-05 11:50:46.309', '2024-05-05 11:50:46.309', NULL, '127.0.0.1', 'POST', '/authority/deleteAuthority', 200, 2318600, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '{\"authorityId\":8881}', '{\"code\":7,\"data\":{},\"msg\":\"删除失败此角色有用户正在使用禁止删除\"}', 1);
INSERT INTO `sys_operation_records` VALUES (14, '2024-05-05 11:50:52.566', '2024-05-05 11:50:52.566', NULL, '127.0.0.1', 'POST', '/user/setUserAuthority', 200, 28939500, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '{\"authorityId\":8881}', '{\"code\":0,\"data\":{},\"msg\":\"修改成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (15, '2024-05-05 11:50:59.160', '2024-05-05 11:50:59.160', NULL, '127.0.0.1', 'POST', '/user/setUserAuthority', 200, 22974000, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '{\"authorityId\":888}', '{\"code\":0,\"data\":{},\"msg\":\"修改成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (16, '2024-05-05 11:51:12.788', '2024-05-05 11:51:12.788', NULL, '127.0.0.1', 'POST', '/authority/deleteAuthority', 200, 2175400, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '{\"authorityId\":8881}', '{\"code\":7,\"data\":{},\"msg\":\"删除失败此角色有用户正在使用禁止删除\"}', 1);
INSERT INTO `sys_operation_records` VALUES (17, '2024-05-05 11:51:56.240', '2024-05-05 11:51:56.240', NULL, '127.0.0.1', 'POST', '/authority/createAuthority', 200, 50500600, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '{\"authorityId\":9527,\"authorityName\":\"开发\",\"parentId\":0}', '{\"code\":0,\"data\":{\"authority\":{\"CreatedAt\":\"2024-05-05T11:51:56.19+08:00\",\"UpdatedAt\":\"2024-05-05T11:51:56.191+08:00\",\"DeletedAt\":null,\"authorityId\":9527,\"authorityName\":\"开发\",\"parentId\":0,\"dataAuthorityId\":null,\"children\":null,\"menus\":[{\"ID\":1,\"CreatedAt\":\"2024-05-05T11:51:56.191+08:00\",\"UpdatedAt\":\"2024-05-05T11:51:56.191+08:00\",\"parentId\":0,\"path\":\"dashboard\",\"name\":\"dashboard\",\"hidden\":false,\"component\":\"view/dashboard/index.vue\",\"sort\":1,\"meta\":{\"activeName\":\"\",\"keepAlive\":false,\"defaultMenu\":false,\"title\":\"仪表盘\",\"icon\":\"setting\",\"closeTab\":false},\"authoritys\":null,\"children\":null,\"parameters\":null,\"menuBtn\":null}],\"defaultRouter\":\"dashboard\"}},\"msg\":\"创建成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (18, '2024-05-05 11:52:12.321', '2024-05-05 11:52:12.321', NULL, '127.0.0.1', 'POST', '/menu/addMenuAuthority', 200, 30157100, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '[超出记录长度]', '{\"code\":0,\"data\":{},\"msg\":\"添加成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (19, '2024-05-05 11:53:02.173', '2024-05-05 11:53:02.173', NULL, '127.0.0.1', 'POST', '/casbin/updateCasbin', 200, 103847500, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '[超出记录长度]', '{\"code\":0,\"data\":{},\"msg\":\"更新成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (20, '2024-05-05 11:53:03.366', '2024-05-05 11:53:03.366', NULL, '127.0.0.1', 'POST', '/casbin/updateCasbin', 200, 84249700, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '[超出记录长度]', '{\"code\":0,\"data\":{},\"msg\":\"更新成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (21, '2024-05-05 11:53:07.834', '2024-05-05 11:53:07.834', NULL, '127.0.0.1', 'POST', '/authority/setDataAuthority', 200, 25496400, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '{\"CreatedAt\":\"2024-05-05T11:51:56.19+08:00\",\"UpdatedAt\":\"2024-05-05T11:51:56.191+08:00\",\"DeletedAt\":null,\"authorityId\":9527,\"authorityName\":\"开发\",\"parentId\":0,\"dataAuthorityId\":[{\"authorityId\":888,\"authorityName\":\"管理员\"},{\"authorityId\":8881,\"authorityName\":\"普通用户子角色\"},{\"authorityId\":9527,\"authorityName\":\"开发\"},{\"authorityId\":9528,\"authorityName\":\"测试角色\"}],\"children\":[],\"menus\":null,\"defaultRouter\":\"dashboard\"}', '{\"code\":0,\"data\":{},\"msg\":\"设置成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (22, '2024-05-05 11:53:12.544', '2024-05-05 11:53:12.544', NULL, '127.0.0.1', 'POST', '/authority/setDataAuthority', 200, 48277900, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '{\"CreatedAt\":\"2024-05-05T11:51:56.19+08:00\",\"UpdatedAt\":\"2024-05-05T11:51:56.191+08:00\",\"DeletedAt\":null,\"authorityId\":9527,\"authorityName\":\"开发\",\"parentId\":0,\"dataAuthorityId\":[{\"authorityId\":888,\"authorityName\":\"管理员\"},{\"authorityId\":9527,\"authorityName\":\"开发\"},{\"authorityId\":9528,\"authorityName\":\"测试角色\"}],\"children\":[],\"menus\":null,\"defaultRouter\":\"dashboard\"}', '{\"code\":0,\"data\":{},\"msg\":\"设置成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (23, '2024-05-05 11:53:13.636', '2024-05-05 11:53:13.636', NULL, '127.0.0.1', 'POST', '/authority/setDataAuthority', 200, 28059500, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '{\"CreatedAt\":\"2024-05-05T11:51:56.19+08:00\",\"UpdatedAt\":\"2024-05-05T11:51:56.191+08:00\",\"DeletedAt\":null,\"authorityId\":9527,\"authorityName\":\"开发\",\"parentId\":0,\"dataAuthorityId\":[{\"authorityId\":888,\"authorityName\":\"管理员\"},{\"authorityId\":9527,\"authorityName\":\"开发\"},{\"authorityId\":9528,\"authorityName\":\"测试角色\"}],\"children\":[],\"menus\":null,\"defaultRouter\":\"dashboard\"}', '{\"code\":0,\"data\":{},\"msg\":\"设置成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (24, '2024-05-05 11:53:19.697', '2024-05-05 11:53:19.697', NULL, '127.0.0.1', 'POST', '/authority/setDataAuthority', 200, 56775200, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '{\"CreatedAt\":\"2024-05-05T09:33:22.509+08:00\",\"UpdatedAt\":\"2024-05-05T11:50:36.226+08:00\",\"DeletedAt\":null,\"authorityId\":888,\"authorityName\":\"管理员\",\"parentId\":0,\"dataAuthorityId\":[{\"authorityId\":888,\"authorityName\":\"管理员\"},{\"authorityId\":9528,\"authorityName\":\"测试角色\"}],\"children\":[{\"CreatedAt\":\"2024-05-05T09:33:22.509+08:00\",\"UpdatedAt\":\"2024-05-05T09:33:23.392+08:00\",\"DeletedAt\":null,\"authorityId\":8881,\"authorityName\":\"普通用户子角色\",\"parentId\":888,\"dataAuthorityId\":[],\"children\":[],\"menus\":null,\"defaultRouter\":\"dashboard\"}],\"menus\":null,\"defaultRouter\":\"dashboard\"}', '{\"code\":0,\"data\":{},\"msg\":\"设置成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (25, '2024-05-05 11:53:28.848', '2024-05-05 11:53:28.848', NULL, '127.0.0.1', 'POST', '/authority/deleteAuthority', 200, 2658000, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '{\"authorityId\":8881}', '{\"code\":7,\"data\":{},\"msg\":\"删除失败此角色有用户正在使用禁止删除\"}', 1);
INSERT INTO `sys_operation_records` VALUES (26, '2024-05-05 11:54:28.497', '2024-05-05 11:54:28.497', NULL, '127.0.0.1', 'POST', '/user/setUserAuthorities', 200, 75841900, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '{\"ID\":1,\"authorityIds\":[888,9528]}', '{\"code\":0,\"data\":{},\"msg\":\"修改成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (27, '2024-05-05 11:54:37.276', '2024-05-05 11:54:37.276', NULL, '127.0.0.1', 'POST', '/authority/deleteAuthority', 200, 43293400, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '{\"authorityId\":8881}', '{\"code\":0,\"data\":{},\"msg\":\"删除成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (28, '2024-05-05 11:56:26.441', '2024-05-05 11:56:26.441', NULL, '127.0.0.1', 'POST', '/user/admin_register', 200, 78462800, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '{\"username\":\"\",\"password\":\"lc12345\",\"nickName\":\"许文浩\",\"headerImg\":\"uploads/file/c67b3af7ed83579cc083089fc0bbefd0_20240505115511.jpg\",\"authorityId\":9527,\"authorityIds\":[9527],\"enable\":1,\"userName\":\"xuwenhao\",\"phone\":\"17365743261\",\"email\":\"sn3115614529@163.com\"}', '{\"code\":0,\"data\":{\"user\":{\"ID\":3,\"CreatedAt\":\"2024-05-05T11:56:26.417+08:00\",\"UpdatedAt\":\"2024-05-05T11:56:26.417+08:00\",\"uuid\":\"0a5db918-c3cc-4034-a32a-6c15f37e78cb\",\"userName\":\"xuwenhao\",\"nickName\":\"许文浩\",\"sideMode\":\"dark\",\"headerImg\":\"uploads/file/c67b3af7ed83579cc083089fc0bbefd0_20240505115511.jpg\",\"baseColor\":\"#fff\",\"activeColor\":\"#1890ff\",\"authorityId\":9527,\"authority\":{\"CreatedAt\":\"0001-01-01T00:00:00Z\",\"UpdatedAt\":\"0001-01-01T00:00:00Z\",\"DeletedAt\":null,\"authorityId\":0,\"authorityName\":\"\",\"parentId\":null,\"dataAuthorityId\":null,\"children\":null,\"menus\":null,\"defaultRouter\":\"\"},\"authorities\":[{\"CreatedAt\":\"2024-05-05T11:56:26.417+08:00\",\"UpdatedAt\":\"2024-05-05T11:56:26.417+08:00\",\"DeletedAt\":null,\"authorityId\":9527,\"authorityName\":\"\",\"parentId\":null,\"dataAuthorityId\":null,\"children\":null,\"menus\":null,\"defaultRouter\":\"dashboard\"}],\"phone\":\"17365743261\",\"email\":\"sn3115614529@163.com\",\"enable\":1}},\"msg\":\"注册成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (29, '2024-05-05 11:56:35.345', '2024-05-05 11:56:35.345', NULL, '127.0.0.1', 'POST', '/user/setUserAuthorities', 200, 69396900, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '{\"ID\":2,\"authorityIds\":[888]}', '{\"code\":0,\"data\":{},\"msg\":\"修改成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (30, '2024-05-05 11:56:38.529', '2024-05-05 11:56:38.529', NULL, '127.0.0.1', 'DELETE', '/user/deleteUser', 200, 54853000, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '{\"id\":2}', '{\"code\":0,\"data\":{},\"msg\":\"删除成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (31, '2024-05-05 14:02:09.392', '2024-05-05 14:02:09.392', NULL, '127.0.0.1', 'POST', '/system/getSystemConfig', 200, 509900, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '', '{\"code\":0,\"data\":{\"config\":{\"jwt\":{\"signing-key\":\"23cb7052-8c96-4acf-9136-578347b2d4c8\",\"expires-time\":\"7d\",\"buffer-time\":\"1d\",\"issuer\":\"qmPlus\"},\"zap\":{\"level\":\"info\",\"prefix\":\"[github.com/flipped-aurora/gin-vue-admin/server]\",\"format\":\"console\",\"director\":\"log\",\"encode-level\":\"LowercaseColorLevelEncoder\",\"stacktrace-key\":\"stacktrace\",\"max-age\":0,\"show-line\":true,\"log-in-console\":true},\"redis\":{\"addr\":\"127.0.0.1:6379\",\"password\":\"\",\"db\":0,\"useCluster\":false,\"clusterAddrs\":[\"172.21.0.3:7000\",\"172.21.0.4:7001\",\"172.21.0.2:7002\"]},\"mongo\":{\"coll\":\"\",\"options\":\"\",\"database\":\"\",\"username\":\"\",\"password\":\"\",\"auth-source\":\"\",\"min-pool-size\":0,\"max-pool-size\":100,\"socket-timeout-ms\":0,\"connect-timeout-ms\":0,\"is-zap\":false,\"hosts\":[{\"host\":\"\",\"port\":\"\"}]},\"email\":{\"to\":\"xxx@qq.com\",\"from\":\"xxx@163.com\",\"host\":\"smtp.163.com\",\"secret\":\"xxx\",\"nickname\":\"test\",\"port\":465,\"is-ssl\":true},\"system\":{\"db-type\":\"mysql\",\"oss-type\":\"local\",\"router-prefix\":\"\",\"addr\":8888,\"iplimit-count\":15000,\"iplimit-time\":3600,\"use-multipoint\":false,\"use-redis\":false,\"use-mongo\":false},\"captcha\":{\"key-long\":6,\"img-width\":240,\"img-height\":80,\"open-captcha\":0,\"open-captcha-timeout\":3600},\"autocode\":{\"server-model\":\"/model/%s\",\"server-router\":\"/router/%s\",\"server\":\"/server\",\"server-api\":\"/api/v1/%s\",\"server-plug\":\"/plugin/%s\",\"server-initialize\":\"/initialize\",\"root\":\"E:\\\\GoWorks\\\\src\\\\lc_finance\",\"web-table\":\"/view\",\"web\":\"/web/src\",\"server-service\":\"/service/%s\",\"server-request\":\"/model/%s/request/\",\"web-api\":\"/api\",\"web-form\":\"/view\",\"transfer-restart\":true},\"mysql\":{\"prefix\":\"\",\"port\":\"3306\",\"config\":\"charset=utf8mb4\\u0026parseTime=True\\u0026loc=Local\",\"db-name\":\"lc_finance\",\"username\":\"root\",\"password\":\"root\",\"path\":\"127.0.0.1\",\"engine\":\"\",\"log-mode\":\"error\",\"max-idle-conns\":10,\"max-open-conns\":100,\"singular\":false,\"log-zap\":false},\"mssql\":{\"prefix\":\"\",\"port\":\"\",\"config\":\"\",\"db-name\":\"\",\"username\":\"\",\"password\":\"\",\"path\":\"\",\"engine\":\"\",\"log-mode\":\"\",\"max-idle-conns\":10,\"max-open-conns\":100,\"singular\":false,\"log-zap\":false},\"pgsql\":{\"prefix\":\"\",\"port\":\"\",\"config\":\"\",\"db-name\":\"\",\"username\":\"\",\"password\":\"\",\"path\":\"\",\"engine\":\"\",\"log-mode\":\"\",\"max-idle-conns\":10,\"max-open-conns\":100,\"singular\":false,\"log-zap\":false},\"oracle\":{\"prefix\":\"\",\"port\":\"\",\"config\":\"\",\"db-name\":\"\",\"username\":\"\",\"password\":\"\",\"path\":\"\",\"engine\":\"\",\"log-mode\":\"\",\"max-idle-conns\":10,\"max-open-conns\":100,\"singular\":false,\"log-zap\":false},\"sqlite\":{\"prefix\":\"\",\"port\":\"\",\"config\":\"\",\"db-name\":\"\",\"username\":\"\",\"password\":\"\",\"path\":\"\",\"engine\":\"\",\"log-mode\":\"\",\"max-idle-conns\":10,\"max-open-conns\":100,\"singular\":false,\"log-zap\":false},\"db-list\":[{\"type\":\"\",\"alias-name\":\"\",\"prefix\":\"\",\"port\":\"\",\"config\":\"\",\"db-name\":\"\",\"username\":\"\",\"password\":\"\",\"path\":\"\",\"engine\":\"\",\"log-mode\":\"\",\"max-idle-conns\":10,\"max-open-conns\":100,\"singular\":false,\"log-zap\":false,\"disable\":true}],\"local\":{\"path\":\"uploads/file\",\"store-path\":\"uploads/file\"},\"qiniu\":{\"zone\":\"ZoneHuaDong\",\"bucket\":\"\",\"img-path\":\"\",\"access-key\":\"\",\"secret-key\":\"\",\"use-https\":false,\"use-cdn-domains\":false},\"aliyun-oss\":{\"endpoint\":\"yourEndpoint\",\"access-key-id\":\"yourAccessKeyId\",\"access-key-secret\":\"yourAccessKeySecret\",\"bucket-name\":\"yourBucketName\",\"bucket-url\":\"yourBucketUrl\",\"base-path\":\"yourBasePath\"},\"hua-wei-obs\":{\"path\":\"you-path\",\"bucket\":\"you-bucket\",\"endpoint\":\"you-endpoint\",\"access-key\":\"you-access-key\",\"secret-key\":\"you-secret-key\"},\"tencent-cos\":{\"bucket\":\"xxxxx-10005608\",\"region\":\"ap-shanghai\",\"secret-id\":\"your-secret-id\",\"secret-key\":\"your-secret-key\",\"base-url\":\"https://gin.vue.admin\",\"path-prefix\":\"github.com/flipped-aurora/gin-vue-admin/server\"},\"aws-s3\":{\"bucket\":\"xxxxx-10005608\",\"region\":\"ap-shanghai\",\"endpoint\":\"\",\"secret-id\":\"your-secret-id\",\"secret-key\":\"your-secret-key\",\"base-url\":\"https://gin.vue.admin\",\"path-prefix\":\"github.com/flipped-aurora/gin-vue-admin/server\",\"s3-force-path-style\":false,\"disable-ssl\":false},\"excel\":{\"dir\":\"./resource/excel/\"},\"cors\":{\"mode\":\"strict-whitelist\",\"whitelist\":[{\"allow-origin\":\"example1.com\",\"allow-methods\":\"POST, GET\",\"allow-headers\":\"Content-Type,AccessToken,X-CSRF-Token, Authorization, Token,X-Token,X-User-Id\",\"expose-headers\":\"Content-Length, Access-Control-Allow-Origin, Access-Control-Allow-Headers, Content-Type\",\"allow-credentials\":true},{\"allow-origin\":\"example2.com\",\"allow-methods\":\"GET, POST\",\"allow-headers\":\"content-type\",\"expose-headers\":\"Content-Length, Access-Control-Allow-Origin, Access-Control-Allow-Headers, Content-Type\",\"allow-credentials\":true}]}}},\"msg\":\"获取成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (32, '2024-05-06 09:48:38.622', '2024-05-06 09:48:38.622', NULL, '127.0.0.1', 'POST', '/user/setUserAuthorities', 200, 138903300, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '{\"ID\":1,\"authorityIds\":[888]}', '{\"code\":0,\"data\":{},\"msg\":\"修改成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (33, '2024-05-06 09:48:41.952', '2024-05-06 09:48:41.952', NULL, '127.0.0.1', 'POST', '/user/setUserAuthority', 200, 1538800, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '{\"authorityId\":9528}', '{\"code\":7,\"data\":{},\"msg\":\"该用户无此角色\"}', 1);
INSERT INTO `sys_operation_records` VALUES (34, '2024-05-06 16:04:15.486', '2024-05-06 16:04:15.486', NULL, '127.0.0.1', 'POST', '/menu/deleteBaseMenu', 200, 34906800, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '{\"ID\":22}', '{\"code\":0,\"data\":{},\"msg\":\"删除成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (35, '2024-05-06 16:04:20.477', '2024-05-06 16:04:20.477', NULL, '127.0.0.1', 'POST', '/menu/deleteBaseMenu', 200, 30453100, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '{\"ID\":2}', '{\"code\":0,\"data\":{},\"msg\":\"删除成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (36, '2024-05-06 16:04:34.615', '2024-05-06 16:04:34.615', NULL, '127.0.0.1', 'POST', '/menu/deleteBaseMenu', 200, 7639900, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '{\"ID\":24}', '{\"code\":7,\"data\":{},\"msg\":\"删除失败\"}', 1);
INSERT INTO `sys_operation_records` VALUES (37, '2024-05-06 16:04:41.860', '2024-05-06 16:04:41.860', NULL, '127.0.0.1', 'POST', '/menu/deleteBaseMenu', 200, 29515300, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '{\"ID\":25}', '{\"code\":0,\"data\":{},\"msg\":\"删除成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (38, '2024-05-06 16:04:43.903', '2024-05-06 16:04:43.903', NULL, '127.0.0.1', 'POST', '/menu/deleteBaseMenu', 200, 39913500, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '{\"ID\":26}', '{\"code\":0,\"data\":{},\"msg\":\"删除成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (39, '2024-05-06 16:04:46.170', '2024-05-06 16:04:46.170', NULL, '127.0.0.1', 'POST', '/menu/deleteBaseMenu', 200, 52858800, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '{\"ID\":27}', '{\"code\":0,\"data\":{},\"msg\":\"删除成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (40, '2024-05-06 16:04:48.605', '2024-05-06 16:04:48.605', NULL, '127.0.0.1', 'POST', '/menu/deleteBaseMenu', 200, 29469400, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '{\"ID\":28}', '{\"code\":0,\"data\":{},\"msg\":\"删除成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (41, '2024-05-06 16:04:51.005', '2024-05-06 16:04:51.005', NULL, '127.0.0.1', 'POST', '/menu/deleteBaseMenu', 200, 22494900, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '{\"ID\":29}', '{\"code\":0,\"data\":{},\"msg\":\"删除成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (42, '2024-05-06 16:04:54.473', '2024-05-06 16:04:54.473', NULL, '127.0.0.1', 'POST', '/menu/deleteBaseMenu', 200, 26996200, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '{\"ID\":24}', '{\"code\":0,\"data\":{},\"msg\":\"删除成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (43, '2024-05-06 16:04:59.459', '2024-05-06 16:04:59.459', NULL, '127.0.0.1', 'POST', '/menu/deleteBaseMenu', 200, 27458100, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '{\"ID\":12}', '{\"code\":0,\"data\":{},\"msg\":\"删除成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (44, '2024-05-06 16:05:01.484', '2024-05-06 16:05:01.484', NULL, '127.0.0.1', 'POST', '/menu/deleteBaseMenu', 200, 53387400, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '{\"ID\":13}', '{\"code\":0,\"data\":{},\"msg\":\"删除成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (45, '2024-05-06 16:05:03.185', '2024-05-06 16:05:03.185', NULL, '127.0.0.1', 'POST', '/menu/deleteBaseMenu', 200, 26927400, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '{\"ID\":14}', '{\"code\":0,\"data\":{},\"msg\":\"删除成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (46, '2024-05-06 16:05:05.711', '2024-05-06 16:05:05.711', NULL, '127.0.0.1', 'POST', '/menu/deleteBaseMenu', 200, 23703500, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '{\"ID\":11}', '{\"code\":0,\"data\":{},\"msg\":\"删除成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (47, '2024-05-06 16:06:47.917', '2024-05-06 16:06:47.917', NULL, '127.0.0.1', 'POST', '/system/getServerInfo', 200, 279835500, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '', '{\"code\":0,\"data\":{\"server\":{\"os\":{\"goos\":\"windows\",\"numCpu\":12,\"compiler\":\"gc\",\"goVersion\":\"go1.22.0\",\"numGoroutine\":9},\"cpu\":{\"cpus\":[7.142857142857142,0,0,7.142857142857142,0,13.333333333333334,7.142857142857142,0,0,7.142857142857142,7.142857142857142,0],\"cores\":6},\"ram\":{\"usedMb\":12788,\"totalMb\":16315,\"usedPercent\":78},\"disk\":{\"usedMb\":40655,\"usedGb\":39,\"totalMb\":953866,\"totalGb\":931,\"usedPercent\":4}}},\"msg\":\"获取成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (48, '2024-05-06 16:06:58.852', '2024-05-06 16:06:58.852', NULL, '127.0.0.1', 'POST', '/system/getServerInfo', 200, 230351700, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '', '{\"code\":0,\"data\":{\"server\":{\"os\":{\"goos\":\"windows\",\"numCpu\":12,\"compiler\":\"gc\",\"goVersion\":\"go1.22.0\",\"numGoroutine\":9},\"cpu\":{\"cpus\":[50,21.428571428571427,71.42857142857143,21.428571428571427,64.28571428571429,21.428571428571427,28.57142857142857,57.14285714285714,28.57142857142857,57.14285714285714,42.857142857142854,42.857142857142854],\"cores\":6},\"ram\":{\"usedMb\":12803,\"totalMb\":16315,\"usedPercent\":78},\"disk\":{\"usedMb\":40655,\"usedGb\":39,\"totalMb\":953866,\"totalGb\":931,\"usedPercent\":4}}},\"msg\":\"获取成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (49, '2024-05-06 16:07:08.833', '2024-05-06 16:07:08.833', NULL, '127.0.0.1', 'POST', '/system/getServerInfo', 200, 216730500, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '', '{\"code\":0,\"data\":{\"server\":{\"os\":{\"goos\":\"windows\",\"numCpu\":12,\"compiler\":\"gc\",\"goVersion\":\"go1.22.0\",\"numGoroutine\":9},\"cpu\":{\"cpus\":[23.076923076923077,0,7.6923076923076925,0,0,0,0,0,0,0,0,0],\"cores\":6},\"ram\":{\"usedMb\":12747,\"totalMb\":16315,\"usedPercent\":78},\"disk\":{\"usedMb\":40655,\"usedGb\":39,\"totalMb\":953866,\"totalGb\":931,\"usedPercent\":4}}},\"msg\":\"获取成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (50, '2024-05-06 16:07:18.839', '2024-05-06 16:07:18.839', NULL, '127.0.0.1', 'POST', '/system/getServerInfo', 200, 217786300, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '', '{\"code\":0,\"data\":{\"server\":{\"os\":{\"goos\":\"windows\",\"numCpu\":12,\"compiler\":\"gc\",\"goVersion\":\"go1.22.0\",\"numGoroutine\":9},\"cpu\":{\"cpus\":[0,0,30.76923076923077,0,0,0,0,0,0,0,0,0],\"cores\":6},\"ram\":{\"usedMb\":12730,\"totalMb\":16315,\"usedPercent\":78},\"disk\":{\"usedMb\":40655,\"usedGb\":39,\"totalMb\":953866,\"totalGb\":931,\"usedPercent\":4}}},\"msg\":\"获取成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (51, '2024-05-06 16:07:28.869', '2024-05-06 16:07:28.869', NULL, '127.0.0.1', 'POST', '/system/getServerInfo', 200, 246316900, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '', '{\"code\":0,\"data\":{\"server\":{\"os\":{\"goos\":\"windows\",\"numCpu\":12,\"compiler\":\"gc\",\"goVersion\":\"go1.22.0\",\"numGoroutine\":9},\"cpu\":{\"cpus\":[7.142857142857142,7.142857142857142,14.285714285714285,7.142857142857142,7.142857142857142,0,0,7.142857142857142,7.142857142857142,7.142857142857142,14.285714285714285,7.142857142857142],\"cores\":6},\"ram\":{\"usedMb\":12756,\"totalMb\":16315,\"usedPercent\":78},\"disk\":{\"usedMb\":40655,\"usedGb\":39,\"totalMb\":953866,\"totalGb\":931,\"usedPercent\":4}}},\"msg\":\"获取成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (52, '2024-05-06 16:07:38.828', '2024-05-06 16:07:38.828', NULL, '127.0.0.1', 'POST', '/system/getServerInfo', 200, 217285300, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '', '{\"code\":0,\"data\":{\"server\":{\"os\":{\"goos\":\"windows\",\"numCpu\":12,\"compiler\":\"gc\",\"goVersion\":\"go1.22.0\",\"numGoroutine\":9},\"cpu\":{\"cpus\":[15.384615384615385,0,15.384615384615385,0,0,0,0,0,0,7.6923076923076925,0,0],\"cores\":6},\"ram\":{\"usedMb\":12732,\"totalMb\":16315,\"usedPercent\":78},\"disk\":{\"usedMb\":40655,\"usedGb\":39,\"totalMb\":953866,\"totalGb\":931,\"usedPercent\":4}}},\"msg\":\"获取成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (53, '2024-05-06 16:07:48.832', '2024-05-06 16:07:48.832', NULL, '127.0.0.1', 'POST', '/system/getServerInfo', 200, 218277900, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '', '{\"code\":0,\"data\":{\"server\":{\"os\":{\"goos\":\"windows\",\"numCpu\":12,\"compiler\":\"gc\",\"goVersion\":\"go1.22.0\",\"numGoroutine\":9},\"cpu\":{\"cpus\":[0,0,0,0,0,0,0,0,0,0,0,0],\"cores\":6},\"ram\":{\"usedMb\":12740,\"totalMb\":16315,\"usedPercent\":78},\"disk\":{\"usedMb\":40655,\"usedGb\":39,\"totalMb\":953866,\"totalGb\":931,\"usedPercent\":4}}},\"msg\":\"获取成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (54, '2024-05-06 16:08:26.595', '2024-05-06 16:08:26.595', NULL, '127.0.0.1', 'POST', '/system/getServerInfo', 200, 231391700, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '', '{\"code\":0,\"data\":{\"server\":{\"os\":{\"goos\":\"windows\",\"numCpu\":12,\"compiler\":\"gc\",\"goVersion\":\"go1.22.0\",\"numGoroutine\":9},\"cpu\":{\"cpus\":[7.6923076923076925,15.384615384615385,61.53846153846154,15.384615384615385,7.6923076923076925,0,0,0,7.6923076923076925,7.6923076923076925,7.6923076923076925,7.6923076923076925],\"cores\":6},\"ram\":{\"usedMb\":12783,\"totalMb\":16315,\"usedPercent\":78},\"disk\":{\"usedMb\":40655,\"usedGb\":39,\"totalMb\":953866,\"totalGb\":931,\"usedPercent\":4}}},\"msg\":\"获取成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (55, '2024-05-06 16:08:36.852', '2024-05-06 16:08:36.852', NULL, '127.0.0.1', 'POST', '/system/getServerInfo', 200, 230907100, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '', '{\"code\":0,\"data\":{\"server\":{\"os\":{\"goos\":\"windows\",\"numCpu\":12,\"compiler\":\"gc\",\"goVersion\":\"go1.22.0\",\"numGoroutine\":9},\"cpu\":{\"cpus\":[13.333333333333334,35.714285714285715,42.857142857142854,0,21.428571428571427,14.285714285714285,14.285714285714285,21.428571428571427,0,0,14.285714285714285,7.142857142857142],\"cores\":6},\"ram\":{\"usedMb\":12711,\"totalMb\":16315,\"usedPercent\":77},\"disk\":{\"usedMb\":40655,\"usedGb\":39,\"totalMb\":953866,\"totalGb\":931,\"usedPercent\":4}}},\"msg\":\"获取成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (56, '2024-05-06 16:08:46.835', '2024-05-06 16:08:46.835', NULL, '127.0.0.1', 'POST', '/system/getServerInfo', 200, 217966800, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '', '{\"code\":0,\"data\":{\"server\":{\"os\":{\"goos\":\"windows\",\"numCpu\":12,\"compiler\":\"gc\",\"goVersion\":\"go1.22.0\",\"numGoroutine\":9},\"cpu\":{\"cpus\":[15.384615384615385,15.384615384615385,38.46153846153847,0,23.076923076923077,0,30.76923076923077,0,0,0,0,15.384615384615385],\"cores\":6},\"ram\":{\"usedMb\":12827,\"totalMb\":16315,\"usedPercent\":78},\"disk\":{\"usedMb\":40655,\"usedGb\":39,\"totalMb\":953866,\"totalGb\":931,\"usedPercent\":4}}},\"msg\":\"获取成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (57, '2024-05-06 16:08:56.853', '2024-05-06 16:08:56.853', NULL, '127.0.0.1', 'POST', '/system/getServerInfo', 200, 230425300, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '', '{\"code\":0,\"data\":{\"server\":{\"os\":{\"goos\":\"windows\",\"numCpu\":12,\"compiler\":\"gc\",\"goVersion\":\"go1.22.0\",\"numGoroutine\":9},\"cpu\":{\"cpus\":[0,21.428571428571427,64.28571428571429,14.285714285714285,42.857142857142854,0,28.57142857142857,7.142857142857142,7.142857142857142,0,14.285714285714285,0],\"cores\":6},\"ram\":{\"usedMb\":12794,\"totalMb\":16315,\"usedPercent\":78},\"disk\":{\"usedMb\":40655,\"usedGb\":39,\"totalMb\":953866,\"totalGb\":931,\"usedPercent\":4}}},\"msg\":\"获取成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (58, '2024-05-06 16:09:06.827', '2024-05-06 16:09:06.827', NULL, '127.0.0.1', 'POST', '/system/getServerInfo', 200, 218413000, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '', '{\"code\":0,\"data\":{\"server\":{\"os\":{\"goos\":\"windows\",\"numCpu\":12,\"compiler\":\"gc\",\"goVersion\":\"go1.22.0\",\"numGoroutine\":9},\"cpu\":{\"cpus\":[0,14.285714285714285,15.384615384615385,0,7.6923076923076925,0,0,0,0,15.384615384615385,0,0],\"cores\":6},\"ram\":{\"usedMb\":12870,\"totalMb\":16315,\"usedPercent\":78},\"disk\":{\"usedMb\":40655,\"usedGb\":39,\"totalMb\":953866,\"totalGb\":931,\"usedPercent\":4}}},\"msg\":\"获取成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (59, '2024-05-06 16:09:16.836', '2024-05-06 16:09:16.836', NULL, '127.0.0.1', 'POST', '/system/getServerInfo', 200, 219413000, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '', '{\"code\":0,\"data\":{\"server\":{\"os\":{\"goos\":\"windows\",\"numCpu\":12,\"compiler\":\"gc\",\"goVersion\":\"go1.22.0\",\"numGoroutine\":9},\"cpu\":{\"cpus\":[0,0,0,0,0,0,0,0,0,0,0,0],\"cores\":6},\"ram\":{\"usedMb\":12989,\"totalMb\":16315,\"usedPercent\":79},\"disk\":{\"usedMb\":40655,\"usedGb\":39,\"totalMb\":953866,\"totalGb\":931,\"usedPercent\":4}}},\"msg\":\"获取成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (60, '2024-05-06 16:09:44.856', '2024-05-06 16:09:44.856', NULL, '127.0.0.1', 'POST', '/system/getServerInfo', 200, 231907900, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '', '{\"code\":0,\"data\":{\"server\":{\"os\":{\"goos\":\"windows\",\"numCpu\":12,\"compiler\":\"gc\",\"goVersion\":\"go1.22.0\",\"numGoroutine\":9},\"cpu\":{\"cpus\":[40,14.285714285714285,57.14285714285714,0,28.57142857142857,0,14.285714285714285,0,0,57.14285714285714,7.142857142857142,14.285714285714285],\"cores\":6},\"ram\":{\"usedMb\":12939,\"totalMb\":16315,\"usedPercent\":79},\"disk\":{\"usedMb\":40655,\"usedGb\":39,\"totalMb\":953866,\"totalGb\":931,\"usedPercent\":4}}},\"msg\":\"获取成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (61, '2024-05-06 16:09:55.615', '2024-05-06 16:09:55.615', NULL, '127.0.0.1', 'POST', '/system/getServerInfo', 200, 218464300, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '', '{\"code\":0,\"data\":{\"server\":{\"os\":{\"goos\":\"windows\",\"numCpu\":12,\"compiler\":\"gc\",\"goVersion\":\"go1.22.0\",\"numGoroutine\":9},\"cpu\":{\"cpus\":[23.076923076923077,15.384615384615385,46.15384615384615,7.6923076923076925,23.076923076923077,0,30.76923076923077,15.384615384615385,38.46153846153847,15.384615384615385,53.84615384615385,0],\"cores\":6},\"ram\":{\"usedMb\":12972,\"totalMb\":16315,\"usedPercent\":79},\"disk\":{\"usedMb\":40655,\"usedGb\":39,\"totalMb\":953866,\"totalGb\":931,\"usedPercent\":4}}},\"msg\":\"获取成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (62, '2024-05-06 16:10:05.825', '2024-05-06 16:10:05.825', NULL, '127.0.0.1', 'POST', '/system/getServerInfo', 200, 216899200, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '', '{\"code\":0,\"data\":{\"server\":{\"os\":{\"goos\":\"windows\",\"numCpu\":12,\"compiler\":\"gc\",\"goVersion\":\"go1.22.0\",\"numGoroutine\":9},\"cpu\":{\"cpus\":[7.6923076923076925,0,30.76923076923077,7.6923076923076925,15.384615384615385,0,7.6923076923076925,0,0,0,7.6923076923076925,7.6923076923076925],\"cores\":6},\"ram\":{\"usedMb\":12995,\"totalMb\":16315,\"usedPercent\":79},\"disk\":{\"usedMb\":40655,\"usedGb\":39,\"totalMb\":953866,\"totalGb\":931,\"usedPercent\":4}}},\"msg\":\"获取成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (63, '2024-05-06 16:10:12.447', '2024-05-06 16:10:12.447', NULL, '127.0.0.1', 'POST', '/system/getServerInfo', 200, 226275500, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '', '{\"code\":0,\"data\":{\"server\":{\"os\":{\"goos\":\"windows\",\"numCpu\":12,\"compiler\":\"gc\",\"goVersion\":\"go1.22.0\",\"numGoroutine\":9},\"cpu\":{\"cpus\":[7.142857142857142,7.142857142857142,64.28571428571429,7.142857142857142,7.142857142857142,0,14.285714285714285,14.285714285714285,7.142857142857142,0,0,14.285714285714285],\"cores\":6},\"ram\":{\"usedMb\":13070,\"totalMb\":16315,\"usedPercent\":80},\"disk\":{\"usedMb\":40655,\"usedGb\":39,\"totalMb\":953866,\"totalGb\":931,\"usedPercent\":4}}},\"msg\":\"获取成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (64, '2024-05-06 16:10:17.445', '2024-05-06 16:10:17.445', NULL, '127.0.0.1', 'POST', '/system/getServerInfo', 200, 228438300, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '', '{\"code\":0,\"data\":{\"server\":{\"os\":{\"goos\":\"windows\",\"numCpu\":12,\"compiler\":\"gc\",\"goVersion\":\"go1.22.0\",\"numGoroutine\":9},\"cpu\":{\"cpus\":[0,7.142857142857142,64.28571428571429,0,7.142857142857142,7.142857142857142,21.428571428571427,0,7.142857142857142,0,0,0],\"cores\":6},\"ram\":{\"usedMb\":13126,\"totalMb\":16315,\"usedPercent\":80},\"disk\":{\"usedMb\":40655,\"usedGb\":39,\"totalMb\":953866,\"totalGb\":931,\"usedPercent\":4}}},\"msg\":\"获取成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (65, '2024-05-06 16:10:27.837', '2024-05-06 16:10:27.837', NULL, '127.0.0.1', 'POST', '/system/getServerInfo', 200, 216813000, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '', '{\"code\":0,\"data\":{\"server\":{\"os\":{\"goos\":\"windows\",\"numCpu\":12,\"compiler\":\"gc\",\"goVersion\":\"go1.22.0\",\"numGoroutine\":9},\"cpu\":{\"cpus\":[0,0,0,0,0,0,0,0,0,0,0,0],\"cores\":6},\"ram\":{\"usedMb\":13063,\"totalMb\":16315,\"usedPercent\":80},\"disk\":{\"usedMb\":40655,\"usedGb\":39,\"totalMb\":953866,\"totalGb\":931,\"usedPercent\":4}}},\"msg\":\"获取成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (66, '2024-05-06 16:10:37.852', '2024-05-06 16:10:37.852', NULL, '127.0.0.1', 'POST', '/system/getServerInfo', 200, 229838300, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '', '{\"code\":0,\"data\":{\"server\":{\"os\":{\"goos\":\"windows\",\"numCpu\":12,\"compiler\":\"gc\",\"goVersion\":\"go1.22.0\",\"numGoroutine\":9},\"cpu\":{\"cpus\":[50,0,21.428571428571427,7.142857142857142,7.142857142857142,0,0,0,0,14.285714285714285,7.142857142857142,0],\"cores\":6},\"ram\":{\"usedMb\":13072,\"totalMb\":16315,\"usedPercent\":80},\"disk\":{\"usedMb\":40655,\"usedGb\":39,\"totalMb\":953866,\"totalGb\":931,\"usedPercent\":4}}},\"msg\":\"获取成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (67, '2024-05-06 16:10:47.852', '2024-05-06 16:10:47.852', NULL, '127.0.0.1', 'POST', '/system/getServerInfo', 200, 231408700, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '', '{\"code\":0,\"data\":{\"server\":{\"os\":{\"goos\":\"windows\",\"numCpu\":12,\"compiler\":\"gc\",\"goVersion\":\"go1.22.0\",\"numGoroutine\":9},\"cpu\":{\"cpus\":[13.333333333333334,0,20,0,21.428571428571427,7.142857142857142,28.57142857142857,0,7.142857142857142,28.57142857142857,14.285714285714285,0],\"cores\":6},\"ram\":{\"usedMb\":13064,\"totalMb\":16315,\"usedPercent\":80},\"disk\":{\"usedMb\":40655,\"usedGb\":39,\"totalMb\":953866,\"totalGb\":931,\"usedPercent\":4}}},\"msg\":\"获取成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (68, '2024-05-06 16:10:57.825', '2024-05-06 16:10:57.825', NULL, '127.0.0.1', 'POST', '/system/getServerInfo', 200, 216348400, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '', '{\"code\":0,\"data\":{\"server\":{\"os\":{\"goos\":\"windows\",\"numCpu\":12,\"compiler\":\"gc\",\"goVersion\":\"go1.22.0\",\"numGoroutine\":9},\"cpu\":{\"cpus\":[42.857142857142854,0,23.076923076923077,0,15.384615384615385,0,0,0,0,23.076923076923077,7.6923076923076925,0],\"cores\":6},\"ram\":{\"usedMb\":13202,\"totalMb\":16315,\"usedPercent\":80},\"disk\":{\"usedMb\":40655,\"usedGb\":39,\"totalMb\":953866,\"totalGb\":931,\"usedPercent\":4}}},\"msg\":\"获取成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (69, '2024-05-06 16:11:05.680', '2024-05-06 16:11:05.680', NULL, '127.0.0.1', 'POST', '/system/getServerInfo', 200, 222475600, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '', '{\"code\":0,\"data\":{\"server\":{\"os\":{\"goos\":\"windows\",\"numCpu\":12,\"compiler\":\"gc\",\"goVersion\":\"go1.22.0\",\"numGoroutine\":9},\"cpu\":{\"cpus\":[23.076923076923077,0,84.61538461538461,23.076923076923077,28.57142857142857,0,15.384615384615385,0,0,15.384615384615385,15.384615384615385,0],\"cores\":6},\"ram\":{\"usedMb\":13268,\"totalMb\":16315,\"usedPercent\":81},\"disk\":{\"usedMb\":40655,\"usedGb\":39,\"totalMb\":953866,\"totalGb\":931,\"usedPercent\":4}}},\"msg\":\"获取成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (70, '2024-05-06 16:11:08.121', '2024-05-06 16:11:08.121', NULL, '127.0.0.1', 'POST', '/system/getServerInfo', 200, 219451300, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '', '{\"code\":0,\"data\":{\"server\":{\"os\":{\"goos\":\"windows\",\"numCpu\":12,\"compiler\":\"gc\",\"goVersion\":\"go1.22.0\",\"numGoroutine\":9},\"cpu\":{\"cpus\":[0,0,15.384615384615385,0,7.6923076923076925,7.6923076923076925,7.6923076923076925,15.384615384615385,7.6923076923076925,7.6923076923076925,23.076923076923077,7.6923076923076925],\"cores\":6},\"ram\":{\"usedMb\":13341,\"totalMb\":16315,\"usedPercent\":81},\"disk\":{\"usedMb\":40655,\"usedGb\":39,\"totalMb\":953866,\"totalGb\":931,\"usedPercent\":4}}},\"msg\":\"获取成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (71, '2024-05-06 16:11:18.124', '2024-05-06 16:11:18.124', NULL, '127.0.0.1', 'POST', '/system/getServerInfo', 200, 229751700, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '', '{\"code\":0,\"data\":{\"server\":{\"os\":{\"goos\":\"windows\",\"numCpu\":12,\"compiler\":\"gc\",\"goVersion\":\"go1.22.0\",\"numGoroutine\":9},\"cpu\":{\"cpus\":[0,28.57142857142857,71.42857142857143,0,7.142857142857142,0,0,0,7.142857142857142,57.14285714285714,0,0],\"cores\":6},\"ram\":{\"usedMb\":13369,\"totalMb\":16315,\"usedPercent\":81},\"disk\":{\"usedMb\":40655,\"usedGb\":39,\"totalMb\":953866,\"totalGb\":931,\"usedPercent\":4}}},\"msg\":\"获取成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (72, '2024-05-06 16:11:28.111', '2024-05-06 16:11:28.111', NULL, '127.0.0.1', 'POST', '/system/getServerInfo', 200, 217860000, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '', '{\"code\":0,\"data\":{\"server\":{\"os\":{\"goos\":\"windows\",\"numCpu\":12,\"compiler\":\"gc\",\"goVersion\":\"go1.22.0\",\"numGoroutine\":9},\"cpu\":{\"cpus\":[15.384615384615385,0,7.6923076923076925,0,0,7.6923076923076925,7.6923076923076925,0,0,15.384615384615385,7.6923076923076925,15.384615384615385],\"cores\":6},\"ram\":{\"usedMb\":13104,\"totalMb\":16315,\"usedPercent\":80},\"disk\":{\"usedMb\":40942,\"usedGb\":39,\"totalMb\":953866,\"totalGb\":931,\"usedPercent\":4}}},\"msg\":\"获取成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (73, '2024-05-06 16:11:38.852', '2024-05-06 16:11:38.852', NULL, '127.0.0.1', 'POST', '/system/getServerInfo', 200, 229294500, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '', '{\"code\":0,\"data\":{\"server\":{\"os\":{\"goos\":\"windows\",\"numCpu\":12,\"compiler\":\"gc\",\"goVersion\":\"go1.22.0\",\"numGoroutine\":9},\"cpu\":{\"cpus\":[7.142857142857142,0,0,0,0,7.142857142857142,0,0,0,0,0,0],\"cores\":6},\"ram\":{\"usedMb\":13012,\"totalMb\":16315,\"usedPercent\":79},\"disk\":{\"usedMb\":41711,\"usedGb\":40,\"totalMb\":953866,\"totalGb\":931,\"usedPercent\":4}}},\"msg\":\"获取成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (74, '2024-05-06 16:11:52.505', '2024-05-06 16:11:52.505', NULL, '127.0.0.1', 'POST', '/system/getSystemConfig', 200, 2552000, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '', '{\"code\":0,\"data\":{\"config\":{\"jwt\":{\"signing-key\":\"23cb7052-8c96-4acf-9136-578347b2d4c8\",\"expires-time\":\"7d\",\"buffer-time\":\"1d\",\"issuer\":\"qmPlus\"},\"zap\":{\"level\":\"info\",\"prefix\":\"[github.com/flipped-aurora/gin-vue-admin/server]\",\"format\":\"console\",\"director\":\"log\",\"encode-level\":\"LowercaseColorLevelEncoder\",\"stacktrace-key\":\"stacktrace\",\"max-age\":0,\"show-line\":true,\"log-in-console\":true},\"redis\":{\"addr\":\"127.0.0.1:6379\",\"password\":\"\",\"db\":0,\"useCluster\":false,\"clusterAddrs\":[\"172.21.0.3:7000\",\"172.21.0.4:7001\",\"172.21.0.2:7002\"]},\"mongo\":{\"coll\":\"\",\"options\":\"\",\"database\":\"\",\"username\":\"\",\"password\":\"\",\"auth-source\":\"\",\"min-pool-size\":0,\"max-pool-size\":100,\"socket-timeout-ms\":0,\"connect-timeout-ms\":0,\"is-zap\":false,\"hosts\":[{\"host\":\"\",\"port\":\"\"}]},\"email\":{\"to\":\"xxx@qq.com\",\"from\":\"xxx@163.com\",\"host\":\"smtp.163.com\",\"secret\":\"xxx\",\"nickname\":\"test\",\"port\":465,\"is-ssl\":true},\"system\":{\"db-type\":\"mysql\",\"oss-type\":\"local\",\"router-prefix\":\"\",\"addr\":8888,\"iplimit-count\":15000,\"iplimit-time\":3600,\"use-multipoint\":false,\"use-redis\":false,\"use-mongo\":false},\"captcha\":{\"key-long\":6,\"img-width\":240,\"img-height\":80,\"open-captcha\":0,\"open-captcha-timeout\":3600},\"autocode\":{\"server-model\":\"/model/%s\",\"server-router\":\"/router/%s\",\"server\":\"/server\",\"server-api\":\"/api/v1/%s\",\"server-plug\":\"/plugin/%s\",\"server-initialize\":\"/initialize\",\"root\":\"E:\\\\GoWorks\\\\src\\\\lc_finance\",\"web-table\":\"/view\",\"web\":\"/web/src\",\"server-service\":\"/service/%s\",\"server-request\":\"/model/%s/request/\",\"web-api\":\"/api\",\"web-form\":\"/view\",\"transfer-restart\":true},\"mysql\":{\"prefix\":\"\",\"port\":\"3306\",\"config\":\"charset=utf8mb4\\u0026parseTime=True\\u0026loc=Local\",\"db-name\":\"lc_finance\",\"username\":\"root\",\"password\":\"root\",\"path\":\"127.0.0.1\",\"engine\":\"\",\"log-mode\":\"error\",\"max-idle-conns\":10,\"max-open-conns\":100,\"singular\":false,\"log-zap\":false},\"mssql\":{\"prefix\":\"\",\"port\":\"\",\"config\":\"\",\"db-name\":\"\",\"username\":\"\",\"password\":\"\",\"path\":\"\",\"engine\":\"\",\"log-mode\":\"\",\"max-idle-conns\":10,\"max-open-conns\":100,\"singular\":false,\"log-zap\":false},\"pgsql\":{\"prefix\":\"\",\"port\":\"\",\"config\":\"\",\"db-name\":\"\",\"username\":\"\",\"password\":\"\",\"path\":\"\",\"engine\":\"\",\"log-mode\":\"\",\"max-idle-conns\":10,\"max-open-conns\":100,\"singular\":false,\"log-zap\":false},\"oracle\":{\"prefix\":\"\",\"port\":\"\",\"config\":\"\",\"db-name\":\"\",\"username\":\"\",\"password\":\"\",\"path\":\"\",\"engine\":\"\",\"log-mode\":\"\",\"max-idle-conns\":10,\"max-open-conns\":100,\"singular\":false,\"log-zap\":false},\"sqlite\":{\"prefix\":\"\",\"port\":\"\",\"config\":\"\",\"db-name\":\"\",\"username\":\"\",\"password\":\"\",\"path\":\"\",\"engine\":\"\",\"log-mode\":\"\",\"max-idle-conns\":10,\"max-open-conns\":100,\"singular\":false,\"log-zap\":false},\"db-list\":[{\"type\":\"\",\"alias-name\":\"\",\"prefix\":\"\",\"port\":\"\",\"config\":\"\",\"db-name\":\"\",\"username\":\"\",\"password\":\"\",\"path\":\"\",\"engine\":\"\",\"log-mode\":\"\",\"max-idle-conns\":10,\"max-open-conns\":100,\"singular\":false,\"log-zap\":false,\"disable\":true}],\"local\":{\"path\":\"uploads/file\",\"store-path\":\"uploads/file\"},\"qiniu\":{\"zone\":\"ZoneHuaDong\",\"bucket\":\"\",\"img-path\":\"\",\"access-key\":\"\",\"secret-key\":\"\",\"use-https\":false,\"use-cdn-domains\":false},\"aliyun-oss\":{\"endpoint\":\"yourEndpoint\",\"access-key-id\":\"yourAccessKeyId\",\"access-key-secret\":\"yourAccessKeySecret\",\"bucket-name\":\"yourBucketName\",\"bucket-url\":\"yourBucketUrl\",\"base-path\":\"yourBasePath\"},\"hua-wei-obs\":{\"path\":\"you-path\",\"bucket\":\"you-bucket\",\"endpoint\":\"you-endpoint\",\"access-key\":\"you-access-key\",\"secret-key\":\"you-secret-key\"},\"tencent-cos\":{\"bucket\":\"xxxxx-10005608\",\"region\":\"ap-shanghai\",\"secret-id\":\"your-secret-id\",\"secret-key\":\"your-secret-key\",\"base-url\":\"https://gin.vue.admin\",\"path-prefix\":\"github.com/flipped-aurora/gin-vue-admin/server\"},\"aws-s3\":{\"bucket\":\"xxxxx-10005608\",\"region\":\"ap-shanghai\",\"endpoint\":\"\",\"secret-id\":\"your-secret-id\",\"secret-key\":\"your-secret-key\",\"base-url\":\"https://gin.vue.admin\",\"path-prefix\":\"github.com/flipped-aurora/gin-vue-admin/server\",\"s3-force-path-style\":false,\"disable-ssl\":false},\"excel\":{\"dir\":\"./resource/excel/\"},\"cors\":{\"mode\":\"strict-whitelist\",\"whitelist\":[{\"allow-origin\":\"example1.com\",\"allow-methods\":\"POST, GET\",\"allow-headers\":\"Content-Type,AccessToken,X-CSRF-Token, Authorization, Token,X-Token,X-User-Id\",\"expose-headers\":\"Content-Length, Access-Control-Allow-Origin, Access-Control-Allow-Headers, Content-Type\",\"allow-credentials\":true},{\"allow-origin\":\"example2.com\",\"allow-methods\":\"GET, POST\",\"allow-headers\":\"content-type\",\"expose-headers\":\"Content-Length, Access-Control-Allow-Origin, Access-Control-Allow-Headers, Content-Type\",\"allow-credentials\":true}]}}},\"msg\":\"获取成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (75, '2024-05-06 16:11:55.650', '2024-05-06 16:11:55.650', NULL, '127.0.0.1', 'POST', '/system/getSystemConfig', 200, 502700, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '', '{\"code\":0,\"data\":{\"config\":{\"jwt\":{\"signing-key\":\"23cb7052-8c96-4acf-9136-578347b2d4c8\",\"expires-time\":\"7d\",\"buffer-time\":\"1d\",\"issuer\":\"qmPlus\"},\"zap\":{\"level\":\"info\",\"prefix\":\"[github.com/flipped-aurora/gin-vue-admin/server]\",\"format\":\"console\",\"director\":\"log\",\"encode-level\":\"LowercaseColorLevelEncoder\",\"stacktrace-key\":\"stacktrace\",\"max-age\":0,\"show-line\":true,\"log-in-console\":true},\"redis\":{\"addr\":\"127.0.0.1:6379\",\"password\":\"\",\"db\":0,\"useCluster\":false,\"clusterAddrs\":[\"172.21.0.3:7000\",\"172.21.0.4:7001\",\"172.21.0.2:7002\"]},\"mongo\":{\"coll\":\"\",\"options\":\"\",\"database\":\"\",\"username\":\"\",\"password\":\"\",\"auth-source\":\"\",\"min-pool-size\":0,\"max-pool-size\":100,\"socket-timeout-ms\":0,\"connect-timeout-ms\":0,\"is-zap\":false,\"hosts\":[{\"host\":\"\",\"port\":\"\"}]},\"email\":{\"to\":\"xxx@qq.com\",\"from\":\"xxx@163.com\",\"host\":\"smtp.163.com\",\"secret\":\"xxx\",\"nickname\":\"test\",\"port\":465,\"is-ssl\":true},\"system\":{\"db-type\":\"mysql\",\"oss-type\":\"local\",\"router-prefix\":\"\",\"addr\":8888,\"iplimit-count\":15000,\"iplimit-time\":3600,\"use-multipoint\":false,\"use-redis\":false,\"use-mongo\":false},\"captcha\":{\"key-long\":6,\"img-width\":240,\"img-height\":80,\"open-captcha\":0,\"open-captcha-timeout\":3600},\"autocode\":{\"server-model\":\"/model/%s\",\"server-router\":\"/router/%s\",\"server\":\"/server\",\"server-api\":\"/api/v1/%s\",\"server-plug\":\"/plugin/%s\",\"server-initialize\":\"/initialize\",\"root\":\"E:\\\\GoWorks\\\\src\\\\lc_finance\",\"web-table\":\"/view\",\"web\":\"/web/src\",\"server-service\":\"/service/%s\",\"server-request\":\"/model/%s/request/\",\"web-api\":\"/api\",\"web-form\":\"/view\",\"transfer-restart\":true},\"mysql\":{\"prefix\":\"\",\"port\":\"3306\",\"config\":\"charset=utf8mb4\\u0026parseTime=True\\u0026loc=Local\",\"db-name\":\"lc_finance\",\"username\":\"root\",\"password\":\"root\",\"path\":\"127.0.0.1\",\"engine\":\"\",\"log-mode\":\"error\",\"max-idle-conns\":10,\"max-open-conns\":100,\"singular\":false,\"log-zap\":false},\"mssql\":{\"prefix\":\"\",\"port\":\"\",\"config\":\"\",\"db-name\":\"\",\"username\":\"\",\"password\":\"\",\"path\":\"\",\"engine\":\"\",\"log-mode\":\"\",\"max-idle-conns\":10,\"max-open-conns\":100,\"singular\":false,\"log-zap\":false},\"pgsql\":{\"prefix\":\"\",\"port\":\"\",\"config\":\"\",\"db-name\":\"\",\"username\":\"\",\"password\":\"\",\"path\":\"\",\"engine\":\"\",\"log-mode\":\"\",\"max-idle-conns\":10,\"max-open-conns\":100,\"singular\":false,\"log-zap\":false},\"oracle\":{\"prefix\":\"\",\"port\":\"\",\"config\":\"\",\"db-name\":\"\",\"username\":\"\",\"password\":\"\",\"path\":\"\",\"engine\":\"\",\"log-mode\":\"\",\"max-idle-conns\":10,\"max-open-conns\":100,\"singular\":false,\"log-zap\":false},\"sqlite\":{\"prefix\":\"\",\"port\":\"\",\"config\":\"\",\"db-name\":\"\",\"username\":\"\",\"password\":\"\",\"path\":\"\",\"engine\":\"\",\"log-mode\":\"\",\"max-idle-conns\":10,\"max-open-conns\":100,\"singular\":false,\"log-zap\":false},\"db-list\":[{\"type\":\"\",\"alias-name\":\"\",\"prefix\":\"\",\"port\":\"\",\"config\":\"\",\"db-name\":\"\",\"username\":\"\",\"password\":\"\",\"path\":\"\",\"engine\":\"\",\"log-mode\":\"\",\"max-idle-conns\":10,\"max-open-conns\":100,\"singular\":false,\"log-zap\":false,\"disable\":true}],\"local\":{\"path\":\"uploads/file\",\"store-path\":\"uploads/file\"},\"qiniu\":{\"zone\":\"ZoneHuaDong\",\"bucket\":\"\",\"img-path\":\"\",\"access-key\":\"\",\"secret-key\":\"\",\"use-https\":false,\"use-cdn-domains\":false},\"aliyun-oss\":{\"endpoint\":\"yourEndpoint\",\"access-key-id\":\"yourAccessKeyId\",\"access-key-secret\":\"yourAccessKeySecret\",\"bucket-name\":\"yourBucketName\",\"bucket-url\":\"yourBucketUrl\",\"base-path\":\"yourBasePath\"},\"hua-wei-obs\":{\"path\":\"you-path\",\"bucket\":\"you-bucket\",\"endpoint\":\"you-endpoint\",\"access-key\":\"you-access-key\",\"secret-key\":\"you-secret-key\"},\"tencent-cos\":{\"bucket\":\"xxxxx-10005608\",\"region\":\"ap-shanghai\",\"secret-id\":\"your-secret-id\",\"secret-key\":\"your-secret-key\",\"base-url\":\"https://gin.vue.admin\",\"path-prefix\":\"github.com/flipped-aurora/gin-vue-admin/server\"},\"aws-s3\":{\"bucket\":\"xxxxx-10005608\",\"region\":\"ap-shanghai\",\"endpoint\":\"\",\"secret-id\":\"your-secret-id\",\"secret-key\":\"your-secret-key\",\"base-url\":\"https://gin.vue.admin\",\"path-prefix\":\"github.com/flipped-aurora/gin-vue-admin/server\",\"s3-force-path-style\":false,\"disable-ssl\":false},\"excel\":{\"dir\":\"./resource/excel/\"},\"cors\":{\"mode\":\"strict-whitelist\",\"whitelist\":[{\"allow-origin\":\"example1.com\",\"allow-methods\":\"POST, GET\",\"allow-headers\":\"Content-Type,AccessToken,X-CSRF-Token, Authorization, Token,X-Token,X-User-Id\",\"expose-headers\":\"Content-Length, Access-Control-Allow-Origin, Access-Control-Allow-Headers, Content-Type\",\"allow-credentials\":true},{\"allow-origin\":\"example2.com\",\"allow-methods\":\"GET, POST\",\"allow-headers\":\"content-type\",\"expose-headers\":\"Content-Length, Access-Control-Allow-Origin, Access-Control-Allow-Headers, Content-Type\",\"allow-credentials\":true}]}}},\"msg\":\"获取成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (76, '2024-05-06 16:18:55.237', '2024-05-06 16:18:55.237', NULL, '127.0.0.1', 'POST', '/system/getServerInfo', 200, 272304100, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '', '{\"code\":0,\"data\":{\"server\":{\"os\":{\"goos\":\"windows\",\"numCpu\":12,\"compiler\":\"gc\",\"goVersion\":\"go1.22.0\",\"numGoroutine\":14},\"cpu\":{\"cpus\":[16.666666666666664,8.333333333333332,16.666666666666664,8.333333333333332,25,0,25,8.333333333333332,8.333333333333332,0,16.666666666666664,8.333333333333332],\"cores\":6},\"ram\":{\"usedMb\":12803,\"totalMb\":16315,\"usedPercent\":78},\"disk\":{\"usedMb\":47720,\"usedGb\":46,\"totalMb\":953866,\"totalGb\":931,\"usedPercent\":5}}},\"msg\":\"获取成功\"}', 1);
INSERT INTO `sys_operation_records` VALUES (77, '2024-05-06 16:19:08.594', '2024-05-06 16:19:08.594', NULL, '127.0.0.1', 'POST', '/menu/deleteBaseMenu', 200, 27434600, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0', '', '{\"ID\":23}', '{\"code\":0,\"data\":{},\"msg\":\"删除成功\"}', 1);

-- ----------------------------
-- Table structure for sys_user_authority
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_authority`;
CREATE TABLE `sys_user_authority`  (
  `sys_user_id` bigint(20) UNSIGNED NOT NULL,
  `sys_authority_authority_id` bigint(20) UNSIGNED NOT NULL COMMENT '角色ID',
  PRIMARY KEY (`sys_user_id`, `sys_authority_authority_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_user_authority
-- ----------------------------
INSERT INTO `sys_user_authority` VALUES (1, 888);
INSERT INTO `sys_user_authority` VALUES (3, 9527);

-- ----------------------------
-- Table structure for sys_users
-- ----------------------------
DROP TABLE IF EXISTS `sys_users`;
CREATE TABLE `sys_users`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `created_at` datetime(3) NULL DEFAULT NULL,
  `updated_at` datetime(3) NULL DEFAULT NULL,
  `deleted_at` datetime(3) NULL DEFAULT NULL,
  `uuid` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户UUID',
  `username` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户登录名',
  `password` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户登录密码',
  `nick_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '系统用户' COMMENT '用户昵称',
  `side_mode` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'dark' COMMENT '用户侧边主题',
  `header_img` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'https://qmplusimg.henrongyi.top/gva_header.jpg' COMMENT '用户头像',
  `base_color` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '#fff' COMMENT '基础颜色',
  `active_color` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '#1890ff' COMMENT '活跃颜色',
  `authority_id` bigint(20) UNSIGNED NULL DEFAULT 888 COMMENT '用户角色ID',
  `phone` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户手机号',
  `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户邮箱',
  `enable` bigint(20) NULL DEFAULT 1 COMMENT '用户是否被冻结 1正常 2冻结',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_sys_users_deleted_at`(`deleted_at`) USING BTREE,
  INDEX `idx_sys_users_uuid`(`uuid`) USING BTREE,
  INDEX `idx_sys_users_username`(`username`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_users
-- ----------------------------
INSERT INTO `sys_users` VALUES (1, '2024-05-05 09:33:23.074', '2024-05-06 09:48:38.507', NULL, '07c9149c-6a9a-4126-8d8a-dd11c7b914a1', 'admin', '$2a$10$WTDQCqEQzEi/FU2UKejgGuWDK3PtHT0yb6xwY.yhx4ugjAmS6iTNa', 'Mr.奇淼', 'dark', 'https://qmplusimg.henrongyi.top/gva_header.jpg', '#fff', '#1890ff', 888, '17611111111', '333333333@qq.com', 1);
INSERT INTO `sys_users` VALUES (2, '2024-05-05 09:33:23.074', '2024-05-05 11:56:35.276', '2024-05-05 11:56:38.473', 'd426b504-bdce-4762-92ed-6aaf7fd96803', 'a303176530', '$2a$10$O.w8M4llNXMv6/EB2lBGpesOQ.s0vEENUOPgQAra8HFt3Xg0EysU2', '用户1', 'dark', 'https:///qmplusimg.henrongyi.top/1572075907logo.png', '#fff', '#1890ff', 888, '17611111111', '333333333@qq.com', 1);
INSERT INTO `sys_users` VALUES (3, '2024-05-05 11:56:26.417', '2024-05-05 11:56:26.417', NULL, '0a5db918-c3cc-4034-a32a-6c15f37e78cb', 'xuwenhao', '$2a$10$XenRWONKRfbY4f.UskoP6.ShfHI.UZijyVxR06eVBKBJj50vwsCzK', '许文浩', 'dark', 'uploads/file/c67b3af7ed83579cc083089fc0bbefd0_20240505115511.jpg', '#fff', '#1890ff', 9527, '17365743261', 'sn3115614529@163.com', 1);

SET FOREIGN_KEY_CHECKS = 1;