/* Navicat Premium Data Transfer Source Server : lc Source Server Type : MySQL Source Server Version : 50735 (5.7.35-log) Source Host : localhost:3306 Source Schema : lc_garage Target Server Type : MySQL Target Server Version : 50735 (5.7.35-log) File Encoding : 65001 Date: 10/07/2026 08:04:08 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for booth -- ---------------------------- DROP TABLE IF EXISTS `booth`; CREATE TABLE `booth` ( `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, `booth_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `booth_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `ip_address` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `description` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `parking_lot_id` bigint(20) UNSIGNED NULL DEFAULT NULL COMMENT '所属区域ID', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `idx_booth_booth_code`(`booth_code`) USING BTREE, INDEX `idx_booth_deleted_at`(`deleted_at`) USING BTREE, INDEX `idx_booth_parking_lot_id`(`parking_lot_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of booth -- ---------------------------- INSERT INTO `booth` VALUES (1, '2026-04-16 15:42:09.837', '2026-04-17 10:31:56.802', NULL, '1', '岗亭12', '192.168.11', '', 1); INSERT INTO `booth` VALUES (2, '2026-04-17 10:32:15.458', '2026-04-17 10:32:24.538', NULL, '2', '岗亭4', '192.168.36', '', 1); INSERT INTO `booth` VALUES (3, '2026-04-17 11:23:42.188', '2026-04-17 11:23:42.188', NULL, '6', '岗亭82', '192.168.162', '', 1); INSERT INTO `booth` VALUES (4, '2026-05-11 11:32:36.174', '2026-05-11 11:32:36.174', NULL, '3213', '测试2', '192.168.1.1', '', 2); -- ---------------------------- -- Table structure for camera -- ---------------------------- DROP TABLE IF EXISTS `camera`; CREATE TABLE `camera` ( `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, `device_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `device_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `ip_address` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `port` bigint(20) NOT NULL, `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `password` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `channel` bigint(20) NULL DEFAULT 1, `status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'offline', `is_active` tinyint(1) NULL DEFAULT 1, `description` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `idx_camera_device_code`(`device_code`) USING BTREE, INDEX `idx_camera_deleted_at`(`deleted_at`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of camera -- ---------------------------- -- ---------------------------- -- 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 = 1592 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of casbin_rule -- ---------------------------- INSERT INTO `casbin_rule` VALUES (382, 'p', '618', '/base/login', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (381, 'p', '618', '/jwt/jsonInBlacklist', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (380, 'p', '618', '/menu/getMenu', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (383, 'p', '618', '/user/admin_register', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (384, 'p', '618', '/user/changePassword', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (387, 'p', '618', '/user/getUserInfo', 'GET', '', '', ''); INSERT INTO `casbin_rule` VALUES (385, 'p', '618', '/user/setUserAuthority', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (386, 'p', '618', '/user/setUserInfo', 'PUT', '', '', ''); INSERT INTO `casbin_rule` VALUES (1480, 'p', '888', '/api/createApi', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1481, 'p', '888', '/api/deleteApi', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1486, 'p', '888', '/api/deleteApisByIds', 'DELETE', '', '', ''); INSERT INTO `casbin_rule` VALUES (1484, 'p', '888', '/api/getAllApis', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1485, 'p', '888', '/api/getApiById', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1483, 'p', '888', '/api/getApiList', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1482, 'p', '888', '/api/updateApi', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1487, 'p', '888', '/authority/copyAuthority', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1488, 'p', '888', '/authority/createAuthority', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1489, 'p', '888', '/authority/deleteAuthority', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1491, 'p', '888', '/authority/getAuthorityList', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1492, 'p', '888', '/authority/setDataAuthority', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1490, 'p', '888', '/authority/updateAuthority', 'PUT', '', '', ''); INSERT INTO `casbin_rule` VALUES (1532, 'p', '888', '/authorityBtn/canRemoveAuthorityBtn', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1531, 'p', '888', '/authorityBtn/getAuthorityBtn', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1530, 'p', '888', '/authorityBtn/setAuthorityBtn', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1494, 'p', '888', '/casbin/getPolicyPathByAuthorityId', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1493, 'p', '888', '/casbin/updateCasbin', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1529, 'p', '888', '/email/emailTest', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1505, 'p', '888', '/fileUploadAndDownload/breakpointContinue', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1506, 'p', '888', '/fileUploadAndDownload/breakpointContinueFinish', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1509, 'p', '888', '/fileUploadAndDownload/deleteFile', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1510, 'p', '888', '/fileUploadAndDownload/editFileName', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1504, 'p', '888', '/fileUploadAndDownload/findFile', 'GET', '', '', ''); INSERT INTO `casbin_rule` VALUES (1511, 'p', '888', '/fileUploadAndDownload/getFileList', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1507, 'p', '888', '/fileUploadAndDownload/removeChunk', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1508, 'p', '888', '/fileUploadAndDownload/upload', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1469, 'p', '888', '/jwt/jsonInBlacklist', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1495, 'p', '888', '/menu/addBaseMenu', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1503, 'p', '888', '/menu/addMenuAuthority', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1497, 'p', '888', '/menu/deleteBaseMenu', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1499, 'p', '888', '/menu/getBaseMenuById', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1501, 'p', '888', '/menu/getBaseMenuTree', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1496, 'p', '888', '/menu/getMenu', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1502, 'p', '888', '/menu/getMenuAuthority', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1500, 'p', '888', '/menu/getMenuList', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1498, 'p', '888', '/menu/updateBaseMenu', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1539, 'p', '888', '/owner/create', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1544, 'p', '888', '/owner/delete', 'DELETE', '', '', ''); INSERT INTO `casbin_rule` VALUES (1541, 'p', '888', '/owner/get', 'GET', '', '', ''); INSERT INTO `casbin_rule` VALUES (1542, 'p', '888', '/owner/get-by-phone', 'GET', '', '', ''); INSERT INTO `casbin_rule` VALUES (1543, 'p', '888', '/owner/list', 'GET', '', '', ''); INSERT INTO `casbin_rule` VALUES (1540, 'p', '888', '/owner/update', 'PUT', '', '', ''); INSERT INTO `casbin_rule` VALUES (1533, 'p', '888', '/parking/booth/create', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1538, 'p', '888', '/parking/booth/delete', 'DELETE', '', '', ''); INSERT INTO `casbin_rule` VALUES (1535, 'p', '888', '/parking/booth/get', 'GET', '', '', ''); INSERT INTO `casbin_rule` VALUES (1536, 'p', '888', '/parking/booth/get-by-code', 'GET', '', '', ''); INSERT INTO `casbin_rule` VALUES (1537, 'p', '888', '/parking/booth/list', 'GET', '', '', ''); INSERT INTO `casbin_rule` VALUES (1534, 'p', '888', '/parking/booth/update', 'PUT', '', '', ''); INSERT INTO `casbin_rule` VALUES (1570, 'p', '888', '/parking/channel/create', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1575, 'p', '888', '/parking/channel/delete', 'DELETE', '', '', ''); INSERT INTO `casbin_rule` VALUES (1572, 'p', '888', '/parking/channel/get', 'GET', '', '', ''); INSERT INTO `casbin_rule` VALUES (1573, 'p', '888', '/parking/channel/get-by-code', 'GET', '', '', ''); INSERT INTO `casbin_rule` VALUES (1574, 'p', '888', '/parking/channel/list', 'GET', '', '', ''); INSERT INTO `casbin_rule` VALUES (1571, 'p', '888', '/parking/channel/update', 'PUT', '', '', ''); INSERT INTO `casbin_rule` VALUES (1576, 'p', '888', '/parking/device/create', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1581, 'p', '888', '/parking/device/delete', 'DELETE', '', '', ''); INSERT INTO `casbin_rule` VALUES (1578, 'p', '888', '/parking/device/get', 'GET', '', '', ''); INSERT INTO `casbin_rule` VALUES (1579, 'p', '888', '/parking/device/get-by-code', 'GET', '', '', ''); INSERT INTO `casbin_rule` VALUES (1580, 'p', '888', '/parking/device/list', 'GET', '', '', ''); INSERT INTO `casbin_rule` VALUES (1577, 'p', '888', '/parking/device/update', 'PUT', '', '', ''); INSERT INTO `casbin_rule` VALUES (1569, 'p', '888', '/parking/lot/all', 'GET', '', '', ''); INSERT INTO `casbin_rule` VALUES (1563, 'p', '888', '/parking/lot/create', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1568, 'p', '888', '/parking/lot/delete', 'DELETE', '', '', ''); INSERT INTO `casbin_rule` VALUES (1565, 'p', '888', '/parking/lot/get', 'GET', '', '', ''); INSERT INTO `casbin_rule` VALUES (1566, 'p', '888', '/parking/lot/get-by-code', 'GET', '', '', ''); INSERT INTO `casbin_rule` VALUES (1567, 'p', '888', '/parking/lot/list', 'GET', '', '', ''); INSERT INTO `casbin_rule` VALUES (1564, 'p', '888', '/parking/lot/update', 'PUT', '', '', ''); INSERT INTO `casbin_rule` VALUES (1583, 'p', '888', '/shortlist/createShortlist', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1584, 'p', '888', '/shortlist/deleteShortlist', 'DELETE', '', '', ''); INSERT INTO `casbin_rule` VALUES (1586, 'p', '888', '/shortlist/queryAllShortlists', 'GET', '', '', ''); INSERT INTO `casbin_rule` VALUES (1582, 'p', '888', '/shortlist/queryShortlistList', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1585, 'p', '888', '/shortlist/updateShortlist', 'PUT', '', '', ''); INSERT INTO `casbin_rule` VALUES (1528, 'p', '888', '/simpleUploader/checkFileMd5', 'GET', '', '', ''); INSERT INTO `casbin_rule` VALUES (1527, 'p', '888', '/simpleUploader/upload', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1517, 'p', '888', '/sysDictionary/createSysDictionary', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1518, 'p', '888', '/sysDictionary/deleteSysDictionary', 'DELETE', '', '', ''); INSERT INTO `casbin_rule` VALUES (1520, 'p', '888', '/sysDictionary/findSysDictionary', 'GET', '', '', ''); INSERT INTO `casbin_rule` VALUES (1521, 'p', '888', '/sysDictionary/getSysDictionaryList', 'GET', '', '', ''); INSERT INTO `casbin_rule` VALUES (1519, 'p', '888', '/sysDictionary/updateSysDictionary', 'PUT', '', '', ''); INSERT INTO `casbin_rule` VALUES (1513, 'p', '888', '/sysDictionaryDetail/createSysDictionaryDetail', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1514, 'p', '888', '/sysDictionaryDetail/deleteSysDictionaryDetail', 'DELETE', '', '', ''); INSERT INTO `casbin_rule` VALUES (1515, 'p', '888', '/sysDictionaryDetail/findSysDictionaryDetail', 'GET', '', '', ''); INSERT INTO `casbin_rule` VALUES (1516, 'p', '888', '/sysDictionaryDetail/getSysDictionaryDetailList', 'GET', '', '', ''); INSERT INTO `casbin_rule` VALUES (1512, 'p', '888', '/sysDictionaryDetail/updateSysDictionaryDetail', 'PUT', '', '', ''); INSERT INTO `casbin_rule` VALUES (1522, 'p', '888', '/sysOperationRecord/createSysOperationRecord', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1525, 'p', '888', '/sysOperationRecord/deleteSysOperationRecord', 'DELETE', '', '', ''); INSERT INTO `casbin_rule` VALUES (1526, 'p', '888', '/sysOperationRecord/deleteSysOperationRecordByIds', 'DELETE', '', '', ''); INSERT INTO `casbin_rule` VALUES (1523, 'p', '888', '/sysOperationRecord/findSysOperationRecord', 'GET', '', '', ''); INSERT INTO `casbin_rule` VALUES (1524, 'p', '888', '/sysOperationRecord/getSysOperationRecordList', 'GET', '', '', ''); INSERT INTO `casbin_rule` VALUES (1471, 'p', '888', '/user/admin_register', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1477, 'p', '888', '/user/changePassword', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1470, 'p', '888', '/user/deleteUser', 'DELETE', '', '', ''); INSERT INTO `casbin_rule` VALUES (1475, 'p', '888', '/user/getUserInfo', 'GET', '', '', ''); INSERT INTO `casbin_rule` VALUES (1472, 'p', '888', '/user/getUserList', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1479, 'p', '888', '/user/resetPassword', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1474, 'p', '888', '/user/setSelfInfo', 'PUT', '', '', ''); INSERT INTO `casbin_rule` VALUES (1476, 'p', '888', '/user/setUserAuthorities', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1478, 'p', '888', '/user/setUserAuthority', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1473, 'p', '888', '/user/setUserInfo', 'PUT', '', '', ''); INSERT INTO `casbin_rule` VALUES (1553, 'p', '888', '/vehicle/all', 'GET', '', '', ''); INSERT INTO `casbin_rule` VALUES (1545, 'p', '888', '/vehicle/create', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1550, 'p', '888', '/vehicle/delete', 'DELETE', '', '', ''); INSERT INTO `casbin_rule` VALUES (1551, 'p', '888', '/vehicle/entry', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1552, 'p', '888', '/vehicle/exit', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1555, 'p', '888', '/vehicle/fee-config/create', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1559, 'p', '888', '/vehicle/fee-config/delete', 'DELETE', '', '', ''); INSERT INTO `casbin_rule` VALUES (1557, 'p', '888', '/vehicle/fee-config/get', 'GET', '', '', ''); INSERT INTO `casbin_rule` VALUES (1558, 'p', '888', '/vehicle/fee-config/list', 'GET', '', '', ''); INSERT INTO `casbin_rule` VALUES (1556, 'p', '888', '/vehicle/fee-config/update', 'PUT', '', '', ''); INSERT INTO `casbin_rule` VALUES (1547, 'p', '888', '/vehicle/get', 'GET', '', '', ''); INSERT INTO `casbin_rule` VALUES (1548, 'p', '888', '/vehicle/get-by-plate', 'GET', '', '', ''); INSERT INTO `casbin_rule` VALUES (1549, 'p', '888', '/vehicle/list', 'GET', '', '', ''); INSERT INTO `casbin_rule` VALUES (1560, 'p', '888', '/vehicle/record/get', 'GET', '', '', ''); INSERT INTO `casbin_rule` VALUES (1562, 'p', '888', '/vehicle/record/list', 'GET', '', '', ''); INSERT INTO `casbin_rule` VALUES (1554, 'p', '888', '/vehicle/record/list', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1561, 'p', '888', '/vehicle/record/list-by-plate', 'GET', '', '', ''); INSERT INTO `casbin_rule` VALUES (1590, 'p', '888', '/vehicle/type/all', 'GET', '', '', ''); INSERT INTO `casbin_rule` VALUES (1587, 'p', '888', '/vehicle/type/create', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1591, 'p', '888', '/vehicle/type/delete', 'DELETE', '', '', ''); INSERT INTO `casbin_rule` VALUES (1589, 'p', '888', '/vehicle/type/list', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (1588, 'p', '888', '/vehicle/type/update', 'PUT', '', '', ''); INSERT INTO `casbin_rule` VALUES (1546, 'p', '888', '/vehicle/update', '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 (307, 'p', '9527', '/casbin/getPolicyPathByAuthorityId', 'POST', '', '', ''); INSERT INTO `casbin_rule` VALUES (306, 'p', '9527', '/casbin/updateCasbin', 'POST', '', '', ''); 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 (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 (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 (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', '', '', ''); -- ---------------------------- -- Table structure for channel -- ---------------------------- DROP TABLE IF EXISTS `channel`; CREATE TABLE `channel` ( `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, `channel_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `channel_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `direction` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `allow_temporary` tinyint(1) NOT NULL, `description` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `parking_lot_id` bigint(20) UNSIGNED NULL DEFAULT NULL, `booth_id` bigint(20) UNSIGNED NULL DEFAULT NULL COMMENT '所属岗亭ID', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `idx_channel_channel_code`(`channel_code`) USING BTREE, INDEX `idx_channel_deleted_at`(`deleted_at`) USING BTREE, INDEX `idx_channel_booth_id`(`booth_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of channel -- ---------------------------- INSERT INTO `channel` VALUES (1, '2026-05-07 08:11:14.081', '2026-05-07 08:11:14.081', NULL, '1123', '23121', 'out', 1, '', 1, 1); INSERT INTO `channel` VALUES (2, '2026-05-11 11:32:53.185', '2026-05-11 11:32:53.185', NULL, '3213123', '测试3', 'in', 0, '', 2, 4); -- ---------------------------- -- Table structure for device -- ---------------------------- DROP TABLE IF EXISTS `device`; CREATE TABLE `device` ( `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, `device_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `device_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `device_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `ip_address` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `port` bigint(20) NULL DEFAULT NULL, `status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'offline', `description` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `idx_device_device_code`(`device_code`) USING BTREE, INDEX `idx_device_deleted_at`(`deleted_at`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of device -- ---------------------------- INSERT INTO `device` VALUES (1, '2026-04-21 11:46:52.807', '2026-04-21 11:46:52.807', NULL, '200', '设备01', 'VLPR', '192.168.11', 0, 'offline', ''); INSERT INTO `device` VALUES (2, '2026-04-21 14:14:54.088', '2026-04-21 14:14:54.088', NULL, '01', '设备01', 'VLPR', '192.168.11', 0, 'offline', ''); -- ---------------------------- -- 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 = 6 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'); INSERT INTO `exa_file_upload_and_downloads` VALUES (4, '2024-06-06 09:49:12.980', '2024-06-06 09:49:12.980', NULL, 'lc_logo.jpg', 'uploads/file/70b1e321d2ec7357cb1b948f5bde35a6_20240606094912.jpg', 'jpg', '70b1e321d2ec7357cb1b948f5bde35a6_20240606094912.jpg'); INSERT INTO `exa_file_upload_and_downloads` VALUES (5, '2024-06-07 08:37:18.883', '2024-06-07 08:37:18.883', NULL, 'logo.png', 'uploads/file/96d6f2e7e1f705ab5e59c84a6dc009b2_20240607083718.png', 'png', '96d6f2e7e1f705ab5e59c84a6dc009b2_20240607083718.png'); -- ---------------------------- -- 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 fee_config -- ---------------------------- DROP TABLE IF EXISTS `fee_config`; CREATE TABLE `fee_config` ( `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, `vehicle_type_id` bigint(20) UNSIGNED NOT NULL, `start_time` bigint(20) NULL DEFAULT NULL, `start_fee` double NULL DEFAULT NULL, `unit_time` bigint(20) NULL DEFAULT NULL, `unit_fee` double NULL DEFAULT NULL, `daily_max_fee` double NULL DEFAULT NULL, `is_v_ip_free` tinyint(1) NULL DEFAULT 0, `v_ip_discount` double NULL DEFAULT 1, `description` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `idx_fee_config_vehicle_type_id`(`vehicle_type_id`) USING BTREE, INDEX `idx_fee_config_deleted_at`(`deleted_at`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of fee_config -- ---------------------------- INSERT INTO `fee_config` VALUES (1, '2026-05-09 10:09:51.198', '2026-05-09 10:09:51.198', NULL, 1, 30, 3, 30, 2, 10, 0, 1, ''); INSERT INTO `fee_config` VALUES (2, '2026-05-09 17:30:40.867', '2026-05-09 17:30:40.867', NULL, 2, 30, 2, 30, 1, 10, 0, 0.5, ''); -- ---------------------------- -- 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 = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of jwt_blacklists -- ---------------------------- -- ---------------------------- -- Table structure for owner -- ---------------------------- DROP TABLE IF EXISTS `owner`; CREATE TABLE `owner` ( `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, `owner_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `owner_surname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `owner_phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `is_vip` tinyint(1) NULL DEFAULT NULL, `vip_expire_time` datetime(3) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `idx_owner_deleted_at`(`deleted_at`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of owner -- ---------------------------- INSERT INTO `owner` VALUES (1, '2026-04-22 15:54:18.882', '2026-04-22 16:53:45.462', '2026-04-22 16:54:09.538', '唐纳德', '特朗普1', '1515', 0, '2026-04-22 00:00:00.000'); INSERT INTO `owner` VALUES (2, '2026-04-24 09:21:25.402', '2026-04-27 15:51:12.127', NULL, '唐纳德', '特朗普', '12862415841', 1, '2026-04-22 00:00:00.000'); INSERT INTO `owner` VALUES (3, '2026-04-27 16:42:23.297', '2026-04-27 16:42:23.297', NULL, '阿道夫', '希特勒', '186522433', 1, '2026-04-28 00:00:00.000'); INSERT INTO `owner` VALUES (4, '2026-05-08 09:33:25.749', '2026-05-08 09:33:25.749', '2026-05-08 11:46:55.430', '1', '1', '1', 0, '2026-05-08 00:00:00.000'); -- ---------------------------- -- Table structure for parking_lot -- ---------------------------- DROP TABLE IF EXISTS `parking_lot`; CREATE TABLE `parking_lot` ( `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, `lot_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `lot_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `capacity` bigint(20) NOT NULL, `available` bigint(20) NOT NULL, `description` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `idx_parking_lot_lot_code`(`lot_code`) USING BTREE, INDEX `idx_parking_lot_deleted_at`(`deleted_at`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of parking_lot -- ---------------------------- INSERT INTO `parking_lot` VALUES (1, '2026-05-08 08:36:49.000', '2026-05-08 08:36:52.000', NULL, '32313', '测试', 60, 1, NULL); INSERT INTO `parking_lot` VALUES (2, '2026-05-11 11:31:57.456', '2026-05-11 11:31:57.456', NULL, '423123', '测试1', 10, 10, ''); -- ---------------------------- -- Table structure for shortlist -- ---------------------------- DROP TABLE IF EXISTS `shortlist`; CREATE TABLE `shortlist` ( `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, `list_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '名单类型', `vehicle_id` bigint(20) UNSIGNED NULL DEFAULT NULL COMMENT '车辆ID', `expiration_time` datetime(3) NULL DEFAULT NULL COMMENT '过期时间', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_shortlist_deleted_at`(`deleted_at`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of shortlist -- ---------------------------- INSERT INTO `shortlist` VALUES (1, '2026-05-08 11:09:45.000', '2026-05-11 10:16:03.681', NULL, '白名单', 27, '2026-06-03 11:10:14.000'); INSERT INTO `shortlist` VALUES (2, '2026-05-11 10:33:52.920', '2026-05-11 10:33:52.920', NULL, '白名单', 25, NULL); -- ---------------------------- -- 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 = 159 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', '2024-06-07 08:58:27.536', '/system/getServerInfo', '获取服务器信息', '系统服务', 'POST'); INSERT INTO `sys_apis` VALUES (45, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', '2024-06-07 08:58:25.320', '/system/getSystemConfig', '获取配置文件内容', '系统服务', 'POST'); INSERT INTO `sys_apis` VALUES (46, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', '2024-06-07 08:58:23.480', '/system/setSystemConfig', '设置配置文件内容', '系统服务', 'POST'); INSERT INTO `sys_apis` VALUES (47, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', '2024-06-07 08:58:21.568', '/customer/customer', '更新客户', '客户', 'PUT'); INSERT INTO `sys_apis` VALUES (48, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', '2024-06-07 08:58:19.696', '/customer/customer', '创建客户', '客户', 'POST'); INSERT INTO `sys_apis` VALUES (49, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', '2024-06-07 08:58:17.648', '/customer/customer', '删除客户', '客户', 'DELETE'); INSERT INTO `sys_apis` VALUES (50, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', '2024-06-07 08:58:15.088', '/customer/customer', '获取单一客户', '客户', 'GET'); INSERT INTO `sys_apis` VALUES (51, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', '2024-06-07 08:58:12.968', '/customer/customerList', '获取客户列表', '客户', 'GET'); INSERT INTO `sys_apis` VALUES (52, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', '2024-06-07 08:58:10.960', '/autoCode/getDB', '获取所有数据库', '代码生成器', 'GET'); INSERT INTO `sys_apis` VALUES (53, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', '2024-06-07 08:58:08.768', '/autoCode/getTables', '获取数据库表', '代码生成器', 'GET'); INSERT INTO `sys_apis` VALUES (54, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', '2024-06-07 08:58:07.023', '/autoCode/createTemp', '自动化代码', '代码生成器', 'POST'); INSERT INTO `sys_apis` VALUES (55, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', '2024-06-07 08:58:05.552', '/autoCode/preview', '预览自动化代码', '代码生成器', 'POST'); INSERT INTO `sys_apis` VALUES (56, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', '2024-06-07 08:58:03.720', '/autoCode/getColumn', '获取所选table的所有字段', '代码生成器', 'GET'); INSERT INTO `sys_apis` VALUES (57, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', '2024-06-07 08:58:01.792', '/autoCode/createPlug', '自动创建插件包', '代码生成器', 'POST'); INSERT INTO `sys_apis` VALUES (58, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', '2024-06-07 08:57:59.752', '/autoCode/installPlugin', '安装插件', '代码生成器', 'POST'); INSERT INTO `sys_apis` VALUES (59, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', '2024-06-07 08:57:57.416', '/autoCode/pubPlug', '打包插件', '代码生成器', 'POST'); INSERT INTO `sys_apis` VALUES (60, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', '2024-06-07 08:57:54.920', '/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', '2024-06-07 08:57:52.320', '/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', '2024-06-07 08:57:50.296', '/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', '2024-06-07 08:57:48.048', '/autoCode/getMeta', '获取meta信息', '代码生成器历史', 'POST'); INSERT INTO `sys_apis` VALUES (64, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', '2024-06-07 08:57:46.096', '/autoCode/rollback', '回滚自动生成代码', '代码生成器历史', 'POST'); INSERT INTO `sys_apis` VALUES (65, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', '2024-06-07 08:57:44.048', '/autoCode/getSysHistory', '查询回滚记录', '代码生成器历史', 'POST'); INSERT INTO `sys_apis` VALUES (66, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', '2024-06-07 08:57:42.240', '/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', '2024-06-07 11:00:36.828', '/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', '2024-06-07 08:57:27.664', '/sysExportTemplate/createSysExportTemplate', '新增导出模板', '表格模板', 'POST'); INSERT INTO `sys_apis` VALUES (91, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', '2024-06-07 08:57:25.776', '/sysExportTemplate/deleteSysExportTemplate', '删除导出模板', '表格模板', 'DELETE'); INSERT INTO `sys_apis` VALUES (92, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', '2024-06-07 08:57:23.888', '/sysExportTemplate/deleteSysExportTemplateByIds', '批量删除导出模板', '表格模板', 'DELETE'); INSERT INTO `sys_apis` VALUES (93, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', '2024-06-07 08:57:20.816', '/sysExportTemplate/updateSysExportTemplate', '更新导出模板', '表格模板', 'PUT'); INSERT INTO `sys_apis` VALUES (94, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', '2024-06-07 08:57:18.640', '/sysExportTemplate/findSysExportTemplate', '根据ID获取导出模板', '表格模板', 'GET'); INSERT INTO `sys_apis` VALUES (95, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', '2024-06-07 08:57:15.480', '/sysExportTemplate/getSysExportTemplateList', '获取导出模板列表', '表格模板', 'GET'); INSERT INTO `sys_apis` VALUES (96, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', '2024-06-07 08:57:13.304', '/sysExportTemplate/exportExcel', '导出Excel', '表格模板', 'GET'); INSERT INTO `sys_apis` VALUES (97, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', '2024-06-07 08:57:11.168', '/sysExportTemplate/exportTemplate', '下载模板', '表格模板', 'GET'); INSERT INTO `sys_apis` VALUES (98, '2024-05-05 09:33:22.426', '2024-05-05 09:33:22.426', '2024-06-07 08:57:08.953', '/sysExportTemplate/importExcel', '导入Excel', '表格模板', 'POST'); INSERT INTO `sys_apis` VALUES (99, '2026-04-16 15:18:18.519', '2026-04-16 15:18:18.519', NULL, '/parking/booth/create', '创建岗亭', '岗亭', 'POST'); INSERT INTO `sys_apis` VALUES (100, '2026-04-16 15:18:49.830', '2026-04-16 15:18:49.830', NULL, '/parking/booth/update', '更新岗亭', '岗亭', 'PUT'); INSERT INTO `sys_apis` VALUES (101, '2026-04-16 15:19:24.249', '2026-04-16 15:19:24.249', NULL, '/parking/booth/get', '根据ID获取岗亭', '岗亭', 'GET'); INSERT INTO `sys_apis` VALUES (102, '2026-04-16 15:32:37.702', '2026-04-16 15:32:37.702', NULL, '/parking/booth/get-by-code', '根据编码获取岗亭', '岗亭', 'GET'); INSERT INTO `sys_apis` VALUES (103, '2026-04-16 15:33:13.701', '2026-04-16 15:33:13.701', NULL, '/parking/booth/list', '获取岗亭列表', '岗亭', 'GET'); INSERT INTO `sys_apis` VALUES (104, '2026-04-16 15:33:39.764', '2026-04-16 15:33:39.764', NULL, '/parking/booth/delete', '删除岗亭', '岗亭', 'DELETE'); INSERT INTO `sys_apis` VALUES (105, '2026-04-20 10:25:19.431', '2026-04-20 10:25:19.431', NULL, '/owner/create', '新增车主', '车主', 'POST'); INSERT INTO `sys_apis` VALUES (106, '2026-04-20 10:26:01.343', '2026-04-20 10:26:01.343', NULL, '/owner/update', '修改车主', '车主', 'PUT'); INSERT INTO `sys_apis` VALUES (107, '2026-04-20 10:27:25.813', '2026-04-20 10:27:25.813', NULL, '/owner/get', '根据ID获取车主信息', '车主', 'GET'); INSERT INTO `sys_apis` VALUES (108, '2026-04-20 10:27:54.605', '2026-04-20 10:27:54.605', NULL, '/owner/get-by-phone', '根据手机号获取车主信息', '车主', 'GET'); INSERT INTO `sys_apis` VALUES (109, '2026-04-20 10:28:29.941', '2026-04-20 10:28:29.941', NULL, '/owner/list', '获取车主列表', '车主', 'GET'); INSERT INTO `sys_apis` VALUES (110, '2026-04-20 10:29:05.813', '2026-04-20 10:29:05.813', NULL, '/owner/delete', '删除车主', '车主', 'DELETE'); INSERT INTO `sys_apis` VALUES (111, '2026-04-20 10:33:24.341', '2026-04-20 10:33:24.341', NULL, '/vehicle/create', '创建车辆信息', '车辆', 'POST'); INSERT INTO `sys_apis` VALUES (112, '2026-04-20 10:33:58.540', '2026-04-20 10:33:58.540', NULL, '/vehicle/update', '更新车辆信息', '车辆', 'PUT'); INSERT INTO `sys_apis` VALUES (113, '2026-04-20 10:41:23.285', '2026-04-20 10:41:23.285', NULL, '/vehicle/get', '根据ID获取车辆信息', '车辆', 'GET'); INSERT INTO `sys_apis` VALUES (114, '2026-04-20 10:42:16.772', '2026-04-20 10:42:16.772', NULL, '/vehicle/get-by-plate', '根据车牌号获取车辆信息', '车辆', 'GET'); INSERT INTO `sys_apis` VALUES (115, '2026-04-20 10:42:44.019', '2026-04-20 10:42:44.019', NULL, '/vehicle/list', '获取车辆列表', '车辆', 'GET'); INSERT INTO `sys_apis` VALUES (116, '2026-04-20 10:45:13.756', '2026-04-20 10:45:13.756', NULL, '/vehicle/delete', '删除车辆', '车辆', 'DELETE'); INSERT INTO `sys_apis` VALUES (117, '2026-04-20 10:47:41.204', '2026-04-20 10:47:41.204', NULL, '/vehicle/entry', '车辆入场', '车辆', 'POST'); INSERT INTO `sys_apis` VALUES (118, '2026-04-20 10:48:22.979', '2026-04-20 10:48:22.979', NULL, '/vehicle/exit', '车辆出场', '车辆', 'POST'); INSERT INTO `sys_apis` VALUES (119, '2026-04-20 10:50:49.843', '2026-04-20 10:50:49.843', NULL, '/vehicle/fee-config/create', '创建收费配置', '收费', 'POST'); INSERT INTO `sys_apis` VALUES (120, '2026-04-20 11:03:04.370', '2026-04-20 11:03:04.370', NULL, '/vehicle/fee-config/update', '更新收费配置', '收费', 'PUT'); INSERT INTO `sys_apis` VALUES (121, '2026-04-20 11:03:37.962', '2026-04-20 11:03:37.962', NULL, '/vehicle/fee-config/get', '根据ID获取收费配置', '收费', 'GET'); INSERT INTO `sys_apis` VALUES (122, '2026-04-20 11:04:14.194', '2026-04-20 11:04:14.194', NULL, '/vehicle/fee-config/list', '获取收费配置列表', '收费', 'GET'); INSERT INTO `sys_apis` VALUES (123, '2026-04-20 11:15:42.225', '2026-04-20 11:15:42.225', NULL, '/vehicle/fee-config/delete', '删除收费配置', '收费', 'DELETE'); INSERT INTO `sys_apis` VALUES (124, '2026-04-20 11:18:18.329', '2026-04-20 11:18:18.329', NULL, '/vehicle/record/get', '根据ID获取车辆记录', '收费', 'GET'); INSERT INTO `sys_apis` VALUES (125, '2026-04-20 11:18:41.648', '2026-04-20 11:18:41.648', NULL, '/vehicle/record/list-by-plate', '根据车牌号获取车辆记录列表', '收费', 'GET'); INSERT INTO `sys_apis` VALUES (126, '2026-04-20 11:19:07.613', '2026-04-20 11:19:07.613', NULL, '/vehicle/record/list', '获取所有车辆记录列表', '收费', 'GET'); INSERT INTO `sys_apis` VALUES (127, '2026-04-20 11:26:22.624', '2026-04-20 11:26:22.624', NULL, '/parking/lot/create', '创建停车区域', '停车', 'POST'); INSERT INTO `sys_apis` VALUES (128, '2026-04-20 11:29:04.200', '2026-04-20 11:29:04.200', NULL, '/parking/lot/update', '更新停车区域', '停车', 'PUT'); INSERT INTO `sys_apis` VALUES (129, '2026-04-20 11:29:31.727', '2026-04-20 11:29:31.727', NULL, '/parking/lot/get', '根据ID获取停车区域', '停车', 'GET'); INSERT INTO `sys_apis` VALUES (130, '2026-04-20 11:29:54.176', '2026-04-20 11:29:54.176', NULL, '/parking/lot/get-by-code', '根据编码获取停车区域', '停车', 'GET'); INSERT INTO `sys_apis` VALUES (131, '2026-04-20 11:30:57.127', '2026-04-20 11:30:57.127', NULL, '/parking/lot/list', '获取停车区域列表', '停车', 'GET'); INSERT INTO `sys_apis` VALUES (132, '2026-04-20 11:31:45.983', '2026-04-20 11:31:45.983', NULL, '/parking/lot/delete', '删除停车区域', '停车', 'DELETE'); INSERT INTO `sys_apis` VALUES (133, '2026-04-20 11:32:23.215', '2026-04-20 11:32:23.215', NULL, '/parking/channel/create', '创建通道', '通道', 'POST'); INSERT INTO `sys_apis` VALUES (134, '2026-04-20 11:34:53.951', '2026-04-20 11:34:53.951', NULL, '/parking/channel/update', '更新通道', '通道', 'PUT'); INSERT INTO `sys_apis` VALUES (135, '2026-04-20 11:35:22.039', '2026-04-20 11:35:22.039', NULL, '/parking/channel/get', '根据ID获取通道', '通道', 'GET'); INSERT INTO `sys_apis` VALUES (136, '2026-04-20 11:37:11.959', '2026-04-20 11:37:11.959', NULL, '/parking/channel/get-by-code', '根据编码获取通道', '通道', 'GET'); INSERT INTO `sys_apis` VALUES (137, '2026-04-20 11:37:58.111', '2026-04-20 11:37:58.111', NULL, '/parking/channel/list', '获取通道列表', '通道', 'GET'); INSERT INTO `sys_apis` VALUES (138, '2026-04-20 11:38:18.134', '2026-04-20 11:38:18.134', NULL, '/parking/channel/delete', '删除通道', '通道', 'DELETE'); INSERT INTO `sys_apis` VALUES (139, '2026-04-20 11:40:39.791', '2026-04-20 11:40:39.791', NULL, '/parking/device/create', '创建设备', '设备', 'POST'); INSERT INTO `sys_apis` VALUES (140, '2026-04-20 11:41:06.182', '2026-04-20 11:41:06.182', NULL, '/parking/device/update', '更新设备', '设备', 'PUT'); INSERT INTO `sys_apis` VALUES (141, '2026-04-20 11:41:31.887', '2026-04-20 11:41:31.887', NULL, '/parking/device/get', '根据ID获取设备', '设备', 'GET'); INSERT INTO `sys_apis` VALUES (142, '2026-04-20 11:41:53.902', '2026-04-20 11:41:53.902', NULL, '/parking/device/get-by-code', '根据编码获取设备', '设备', 'GET'); INSERT INTO `sys_apis` VALUES (143, '2026-04-20 11:42:16.454', '2026-04-20 11:42:16.454', NULL, '/parking/device/list', '获取设备列表', '设备', 'GET'); INSERT INTO `sys_apis` VALUES (144, '2026-04-20 11:42:45.782', '2026-04-20 11:42:45.782', NULL, '/parking/device/delete', '删除设备', '设备', 'DELETE'); INSERT INTO `sys_apis` VALUES (145, '2026-05-08 10:23:37.915', '2026-05-08 10:23:37.915', NULL, '/parking/lot/all', '查询所有停车区域', '停车', 'GET'); INSERT INTO `sys_apis` VALUES (146, '2026-05-08 11:08:10.736', '2026-05-08 11:08:10.736', '2026-05-08 14:25:02.073', '/shortlist/queryShortlistList', '查询黑白名单', '黑白名单', 'GET'); INSERT INTO `sys_apis` VALUES (147, '2026-05-08 14:25:20.906', '2026-05-08 14:25:20.906', NULL, '/shortlist/queryShortlistList', '获取黑白名单', '黑白名单', 'POST'); INSERT INTO `sys_apis` VALUES (148, '2026-05-08 14:51:02.822', '2026-05-08 14:51:02.822', NULL, '/vehicle/all', '获取全部车辆', '车辆', 'GET'); INSERT INTO `sys_apis` VALUES (149, '2026-05-08 15:54:59.468', '2026-05-08 15:54:59.468', NULL, '/vehicle/record/list', '查询车辆记录列表', '车辆', 'POST'); INSERT INTO `sys_apis` VALUES (150, '2026-05-08 17:28:34.047', '2026-05-08 17:28:34.047', NULL, '/vehicle/type/create', '新增车辆类型', '车辆类型', 'POST'); INSERT INTO `sys_apis` VALUES (151, '2026-05-08 17:28:56.219', '2026-05-08 17:28:56.219', NULL, '/vehicle/type/update', '修改车辆类型', '车辆类型', 'PUT'); INSERT INTO `sys_apis` VALUES (152, '2026-05-08 17:29:23.402', '2026-05-08 17:29:23.402', NULL, '/vehicle/type/list', '查询车辆类型列表', '车辆类型', 'POST'); INSERT INTO `sys_apis` VALUES (153, '2026-05-08 17:30:00.828', '2026-05-08 17:30:00.828', NULL, '/vehicle/type/all', '查询所有车辆类型', '车辆类型', 'GET'); INSERT INTO `sys_apis` VALUES (154, '2026-05-09 17:24:42.801', '2026-05-09 17:24:42.801', NULL, '/shortlist/createShortlist', '新增黑白名单', '黑白名单', 'POST'); INSERT INTO `sys_apis` VALUES (155, '2026-05-09 17:25:02.586', '2026-05-09 17:25:02.586', NULL, '/shortlist/deleteShortlist', '删除黑白名单', '黑白名单', 'DELETE'); INSERT INTO `sys_apis` VALUES (156, '2026-05-09 17:26:21.732', '2026-05-09 17:26:21.732', NULL, '/shortlist/updateShortlist', '修改黑白名单', '黑白名单', 'PUT'); INSERT INTO `sys_apis` VALUES (157, '2026-05-09 17:26:56.866', '2026-05-09 17:26:56.866', NULL, '/shortlist/queryAllShortlists', '查询所有黑白名单', '黑白名单', 'GET'); INSERT INTO `sys_apis` VALUES (158, '2026-05-09 17:28:08.965', '2026-05-09 17:28:08.965', NULL, '/vehicle/type/delete', '删除车辆类型', '车辆类型', 'DELETE'); -- ---------------------------- -- 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 = 9528 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of sys_authorities -- ---------------------------- INSERT INTO `sys_authorities` VALUES ('2024-06-07 09:38:21.632', '2024-06-07 09:38:31.580', NULL, 618, '普通用户', 0, 'dashboard'); INSERT INTO `sys_authorities` VALUES ('2024-05-05 09:33:22.509', '2026-04-24 10:22:55.673', NULL, 888, '管理员', 0, 'dashboard'); INSERT INTO `sys_authorities` VALUES ('2024-05-05 11:51:56.190', '2024-06-06 09:48:36.548', NULL, 9527, '开发', 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, 618); INSERT INTO `sys_authority_menus` VALUES (1, 888); INSERT INTO `sys_authority_menus` VALUES (1, 9527); 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 (9, 888); INSERT INTO `sys_authority_menus` VALUES (9, 9527); INSERT INTO `sys_authority_menus` VALUES (10, 618); INSERT INTO `sys_authority_menus` VALUES (10, 888); INSERT INTO `sys_authority_menus` VALUES (10, 9527); INSERT INTO `sys_authority_menus` VALUES (31, 888); INSERT INTO `sys_authority_menus` VALUES (32, 888); INSERT INTO `sys_authority_menus` VALUES (33, 888); INSERT INTO `sys_authority_menus` VALUES (34, 888); INSERT INTO `sys_authority_menus` VALUES (35, 888); INSERT INTO `sys_authority_menus` VALUES (36, 888); INSERT INTO `sys_authority_menus` VALUES (37, 888); INSERT INTO `sys_authority_menus` VALUES (38, 888); INSERT INTO `sys_authority_menus` VALUES (39, 888); INSERT INTO `sys_authority_menus` VALUES (40, 888); INSERT INTO `sys_authority_menus` VALUES (41, 888); -- ---------------------------- -- 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 = 42 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', '2024-06-07 08:32:04.387', 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', '2024-06-07 08:31:53.667', 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', '2024-06-07 08:31:57.611', 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', '2024-06-07 08:31:59.635', 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', '2024-06-07 08:31:55.627', 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', '2024-06-07 08:31:43.902', 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', '2024-06-07 08:31:46.635', 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', '2024-06-07 08:32:01.883', 0, 15, 'exportTemplate', 'exportTemplate', 0, 'view/systemTools/exportTemplate/exportTemplate.vue', 10, '', 0, 0, '表格模板', 'reading', 0); INSERT INTO `sys_base_menus` VALUES (31, '2026-04-15 11:27:15.397', '2026-04-15 11:27:15.397', NULL, 0, 0, 'parking', 'parking', 0, 'view/parking', 0, '', 0, 0, '停车场管理', 'van', 0); INSERT INTO `sys_base_menus` VALUES (32, '2026-04-15 11:29:16.100', '2026-04-15 11:29:56.196', NULL, 0, 31, 'parkingInfo', 'parkingInfo', 0, 'view/parking/parkingInfo.vue', 0, '', 0, 0, '停车信息管理', 'van', 0); INSERT INTO `sys_base_menus` VALUES (33, '2026-04-15 11:32:11.827', '2026-04-15 11:42:00.611', NULL, 0, 31, 'carOwner', 'carOwner', 0, 'view/parking/carOwner.vue', 0, '', 0, 0, '车主管理', 'stamp', 0); INSERT INTO `sys_base_menus` VALUES (34, '2026-04-15 11:41:53.116', '2026-04-15 11:41:53.116', NULL, 0, 31, 'roster', 'roster', 0, 'view/parking/roster.vue', 0, '', 0, 0, '黑白名单', 'document', 0); INSERT INTO `sys_base_menus` VALUES (35, '2026-04-15 11:44:41.661', '2026-04-15 11:44:41.661', NULL, 0, 0, 'report', 'report', 0, 'view/report', 0, '', 0, 0, '报表信息查询', 'data-analysis', 0); INSERT INTO `sys_base_menus` VALUES (36, '2026-04-15 11:46:09.341', '2026-04-15 11:46:09.341', NULL, 0, 35, 'enter', 'enter', 0, 'view/report/enter.vue', 0, '', 0, 0, '进出记录', 'sort', 0); INSERT INTO `sys_base_menus` VALUES (37, '2026-04-15 11:47:10.732', '2026-04-15 11:47:10.732', NULL, 0, 35, 'sheet', 'sheet', 0, 'view/report/sheet.vue', 0, '', 0, 0, '异常报表', 'document-copy', 0); INSERT INTO `sys_base_menus` VALUES (38, '2026-04-15 11:48:35.115', '2026-04-15 11:50:11.341', NULL, 0, 0, 'statistics', 'statistics', 0, 'view/statistics', 0, '', 0, 0, '统计信息查询', 'chat-line-round', 0); INSERT INTO `sys_base_menus` VALUES (39, '2026-04-15 11:49:36.403', '2026-04-15 11:49:36.403', NULL, 0, 38, 'vehicle', 'vehicle', 0, 'view/statistics/vehicle.vue', 0, '', 0, 0, '在场车辆统计', 'van', 0); INSERT INTO `sys_base_menus` VALUES (40, '2026-04-23 09:24:54.498', '2026-04-23 09:24:54.498', NULL, 0, 31, 'carInfo', 'carInfo', 0, 'view/parking/carInfo.vue', 0, '', 0, 0, '车辆信息', 'notebook', 0); INSERT INTO `sys_base_menus` VALUES (41, '2026-04-24 10:15:11.661', '2026-04-24 10:18:18.482', NULL, 0, 31, 'pricing', 'pricing', 0, 'view/parking/pricing.vue', 0, '', 0, 0, '收费配置', 'office-building', 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 (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); -- ---------------------------- -- 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 = 8 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-06-07 17:04:28.894', NULL, '性别', 'sex', 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类型'); INSERT INTO `sys_dictionaries` VALUES (7, '2024-06-07 16:55:48.644', '2024-06-07 16:57:35.618', '2024-06-07 16:58:02.363', '好厉害', 'haodiao1', 1, '描述'); -- ---------------------------- -- 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 = 35 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); INSERT INTO `sys_dictionary_details` VALUES (34, '2024-06-07 16:56:06.295', '2024-06-07 16:57:17.888', '2024-06-07 16:58:02.405', '厉害', '12', '', 1, 2, 7); -- ---------------------------- -- 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 = 289 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of sys_operation_records -- ---------------------------- INSERT INTO `sys_operation_records` VALUES (181, '2026-04-15 11:27:15.399', '2026-04-15 11:27:15.399', NULL, '127.0.0.1', 'POST', '/menu/addBaseMenu', 200, 3551400, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"ID\":0,\"path\":\"parking\",\"name\":\"parking\",\"hidden\":false,\"parentId\":0,\"component\":\"view/parking\",\"meta\":{\"activeName\":\"\",\"title\":\"停车场管理\",\"icon\":\"van\",\"defaultMenu\":false,\"closeTab\":false,\"keepAlive\":false},\"parameters\":[],\"menuBtn\":[]}', '{\"code\":0,\"data\":{},\"msg\":\"添加成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (182, '2026-04-15 11:29:16.106', '2026-04-15 11:29:16.106', NULL, '127.0.0.1', 'POST', '/menu/addBaseMenu', 200, 7044200, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"ID\":0,\"path\":\"parkingInfo\",\"name\":\"parkingInfo\",\"hidden\":false,\"parentId\":31,\"component\":\"view/parkingInfo/parkingInfo.vue\",\"meta\":{\"title\":\"停车信息管理\",\"icon\":\"van\",\"defaultMenu\":false,\"closeTab\":false,\"keepAlive\":false}}', '{\"code\":0,\"data\":{},\"msg\":\"添加成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (183, '2026-04-15 11:29:56.198', '2026-04-15 11:29:56.198', NULL, '127.0.0.1', 'POST', '/menu/updateBaseMenu', 200, 3622700, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"ID\":32,\"CreatedAt\":\"2026-04-15T11:29:16.1+08:00\",\"UpdatedAt\":\"2026-04-15T11:29:16.1+08:00\",\"parentId\":31,\"path\":\"parkingInfo\",\"name\":\"parkingInfo\",\"hidden\":false,\"component\":\"view/parking/parkingInfo.vue\",\"sort\":0,\"meta\":{\"activeName\":\"\",\"keepAlive\":false,\"defaultMenu\":false,\"title\":\"停车信息管理\",\"icon\":\"van\",\"closeTab\":false},\"authoritys\":null,\"children\":null,\"parameters\":[],\"menuBtn\":[]}', '{\"code\":0,\"data\":{},\"msg\":\"更新成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (184, '2026-04-15 11:32:11.831', '2026-04-15 11:32:11.831', NULL, '127.0.0.1', 'POST', '/menu/addBaseMenu', 200, 5191400, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"ID\":0,\"path\":\"carOwner\",\"name\":\"carOwner\",\"hidden\":false,\"parentId\":31,\"component\":\"view/parking/carOwner\",\"meta\":{\"title\":\"车主管理\",\"icon\":\"stamp\",\"defaultMenu\":false,\"closeTab\":false,\"keepAlive\":false}}', '{\"code\":0,\"data\":{},\"msg\":\"添加成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (185, '2026-04-15 11:41:53.120', '2026-04-15 11:41:53.120', NULL, '127.0.0.1', 'POST', '/menu/addBaseMenu', 200, 5326500, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"ID\":0,\"path\":\"roster\",\"name\":\"roster\",\"hidden\":false,\"parentId\":31,\"component\":\"view/parking/roster.vue\",\"meta\":{\"title\":\"黑白名单\",\"icon\":\"document\",\"defaultMenu\":false,\"closeTab\":false,\"keepAlive\":false}}', '{\"code\":0,\"data\":{},\"msg\":\"添加成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (186, '2026-04-15 11:42:00.613', '2026-04-15 11:42:00.613', NULL, '127.0.0.1', 'POST', '/menu/updateBaseMenu', 200, 2948600, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"ID\":33,\"CreatedAt\":\"2026-04-15T11:32:11.827+08:00\",\"UpdatedAt\":\"2026-04-15T11:32:11.827+08:00\",\"parentId\":31,\"path\":\"carOwner\",\"name\":\"carOwner\",\"hidden\":false,\"component\":\"view/parking/carOwner.vue\",\"sort\":0,\"meta\":{\"activeName\":\"\",\"keepAlive\":false,\"defaultMenu\":false,\"title\":\"车主管理\",\"icon\":\"stamp\",\"closeTab\":false},\"authoritys\":null,\"children\":null,\"parameters\":[],\"menuBtn\":[]}', '{\"code\":0,\"data\":{},\"msg\":\"更新成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (187, '2026-04-15 11:42:13.697', '2026-04-15 11:42:13.697', NULL, '127.0.0.1', 'POST', '/menu/addMenuAuthority', 200, 6173800, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '[超出记录长度]', '{\"code\":0,\"data\":{},\"msg\":\"添加成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (188, '2026-04-15 11:44:41.666', '2026-04-15 11:44:41.666', NULL, '127.0.0.1', 'POST', '/menu/addBaseMenu', 200, 5393000, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"ID\":0,\"path\":\"report\",\"name\":\"report\",\"hidden\":false,\"parentId\":0,\"component\":\"view/report\",\"meta\":{\"activeName\":\"\",\"title\":\"报表信息查询\",\"icon\":\"data-analysis\",\"defaultMenu\":false,\"closeTab\":false,\"keepAlive\":false},\"parameters\":[],\"menuBtn\":[]}', '{\"code\":0,\"data\":{},\"msg\":\"添加成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (189, '2026-04-15 11:46:09.343', '2026-04-15 11:46:09.343', NULL, '127.0.0.1', 'POST', '/menu/addBaseMenu', 200, 3675900, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"ID\":0,\"path\":\"enter\",\"name\":\"enter\",\"hidden\":false,\"parentId\":35,\"component\":\"view/report/enter.vue\",\"meta\":{\"title\":\"进出记录\",\"icon\":\"sort\",\"defaultMenu\":false,\"closeTab\":false,\"keepAlive\":false}}', '{\"code\":0,\"data\":{},\"msg\":\"添加成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (190, '2026-04-15 11:47:10.735', '2026-04-15 11:47:10.735', NULL, '127.0.0.1', 'POST', '/menu/addBaseMenu', 200, 3960900, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"ID\":0,\"path\":\"sheet\",\"name\":\"sheet\",\"hidden\":false,\"parentId\":35,\"component\":\"view/report/sheet.vue\",\"meta\":{\"title\":\"异常报表\",\"icon\":\"document-copy\",\"defaultMenu\":false,\"closeTab\":false,\"keepAlive\":false}}', '{\"code\":0,\"data\":{},\"msg\":\"添加成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (191, '2026-04-15 11:48:35.118', '2026-04-15 11:48:35.118', NULL, '127.0.0.1', 'POST', '/menu/addBaseMenu', 200, 3758500, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"ID\":0,\"path\":\"statistics\",\"name\":\"statistics\",\"hidden\":false,\"parentId\":0,\"component\":\"view/statistics\",\"meta\":{\"title\":\"统计信息查询\",\"icon\":\"\",\"defaultMenu\":false,\"closeTab\":false,\"keepAlive\":false}}', '{\"code\":0,\"data\":{},\"msg\":\"添加成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (192, '2026-04-15 11:49:36.405', '2026-04-15 11:49:36.405', NULL, '127.0.0.1', 'POST', '/menu/addBaseMenu', 200, 2996400, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"ID\":0,\"path\":\"vehicle\",\"name\":\"vehicle\",\"hidden\":false,\"parentId\":38,\"component\":\"view/statistics/vehicle.vue\",\"meta\":{\"title\":\"在场车辆统计\",\"icon\":\"van\",\"defaultMenu\":false,\"closeTab\":false,\"keepAlive\":false}}', '{\"code\":0,\"data\":{},\"msg\":\"添加成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (193, '2026-04-15 11:49:47.057', '2026-04-15 11:49:47.057', NULL, '127.0.0.1', 'POST', '/menu/addMenuAuthority', 200, 5398300, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '[超出记录长度]', '{\"code\":0,\"data\":{},\"msg\":\"添加成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (194, '2026-04-15 11:50:11.344', '2026-04-15 11:50:11.344', NULL, '127.0.0.1', 'POST', '/menu/updateBaseMenu', 200, 3245500, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"ID\":38,\"CreatedAt\":\"2026-04-15T11:48:35.115+08:00\",\"UpdatedAt\":\"2026-04-15T11:48:35.115+08:00\",\"parentId\":0,\"path\":\"statistics\",\"name\":\"statistics\",\"hidden\":false,\"component\":\"view/statistics\",\"sort\":0,\"meta\":{\"activeName\":\"\",\"keepAlive\":false,\"defaultMenu\":false,\"title\":\"统计信息查询\",\"icon\":\"chat-line-round\",\"closeTab\":false},\"authoritys\":null,\"children\":null,\"parameters\":[],\"menuBtn\":[]}', '{\"code\":0,\"data\":{},\"msg\":\"更新成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (195, '2026-04-16 15:18:18.654', '2026-04-16 15:18:18.654', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 143096400, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/parking/booth/create\",\"apiGroup\":\"岗亭\",\"method\":\"POST\",\"description\":\"创建岗亭\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (196, '2026-04-16 15:18:49.833', '2026-04-16 15:18:49.833', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 3431700, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/parking/booth/update\",\"apiGroup\":\"岗亭\",\"method\":\"PUT\",\"description\":\"更新岗亭\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (197, '2026-04-16 15:19:24.251', '2026-04-16 15:19:24.251', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 3405800, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/parking/booth/get\",\"apiGroup\":\"岗亭\",\"method\":\"GET\",\"description\":\"根据ID获取岗亭\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (198, '2026-04-16 15:32:37.706', '2026-04-16 15:32:37.706', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 4854400, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/parking/booth/get-by-code\",\"apiGroup\":\"岗亭\",\"method\":\"GET\",\"description\":\"根据编码获取岗亭\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (199, '2026-04-16 15:33:13.705', '2026-04-16 15:33:13.705', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 5362100, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/parking/booth/list\",\"apiGroup\":\"岗亭\",\"method\":\"GET\",\"description\":\"获取岗亭列表\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (200, '2026-04-16 15:33:39.767', '2026-04-16 15:33:39.767', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 4486500, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/parking/booth/delete\",\"apiGroup\":\"岗亭\",\"method\":\"DELETE\",\"description\":\"删除岗亭\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (201, '2026-04-16 15:41:51.001', '2026-04-16 15:41:51.001', NULL, '127.0.0.1', 'POST', '/casbin/updateCasbin', 200, 45363400, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '[超出记录长度]', '{\"code\":0,\"data\":{},\"msg\":\"更新成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (202, '2026-04-20 10:25:19.435', '2026-04-20 10:25:19.435', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 5216800, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/owner/create\",\"apiGroup\":\"车主\",\"method\":\"POST\",\"description\":\"新增车主\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (203, '2026-04-20 10:26:01.346', '2026-04-20 10:26:01.346', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 3670400, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/owner/update\",\"apiGroup\":\"车主\",\"method\":\"PUT\",\"description\":\"修改车主\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (204, '2026-04-20 10:27:25.817', '2026-04-20 10:27:25.817', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 5425000, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/owner/get\",\"apiGroup\":\"车主\",\"method\":\"GET\",\"description\":\"根据ID获取车主信息\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (205, '2026-04-20 10:27:54.608', '2026-04-20 10:27:54.608', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 3921200, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/owner/get-by-phone\",\"apiGroup\":\"车主\",\"method\":\"GET\",\"description\":\"根据手机号获取车主信息\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (206, '2026-04-20 10:28:29.945', '2026-04-20 10:28:29.945', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 4615500, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/owner/list\",\"apiGroup\":\"车主\",\"method\":\"GET\",\"description\":\"获取车主列表\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (207, '2026-04-20 10:29:05.815', '2026-04-20 10:29:05.815', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 2965200, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/owner/delete\",\"apiGroup\":\"车主\",\"method\":\"DELETE\",\"description\":\"删除车主\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (208, '2026-04-20 10:33:24.344', '2026-04-20 10:33:24.344', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 3885700, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/vehicle/create\",\"apiGroup\":\"车辆\",\"method\":\"POST\",\"description\":\"创建车辆信息\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (209, '2026-04-20 10:33:58.544', '2026-04-20 10:33:58.544', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 4808200, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/vehicle/update\",\"apiGroup\":\"车辆\",\"method\":\"PUT\",\"description\":\"更新车辆信息\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (210, '2026-04-20 10:41:23.287', '2026-04-20 10:41:23.287', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 3738300, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/vehicle/get\",\"apiGroup\":\"车辆\",\"method\":\"GET\",\"description\":\"根据ID获取车辆信息\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (211, '2026-04-20 10:42:16.774', '2026-04-20 10:42:16.774', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 3739000, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/vehicle/get-by-plate\",\"apiGroup\":\"车辆\",\"method\":\"GET\",\"description\":\"根据车牌号获取车辆信息\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (212, '2026-04-20 10:42:44.023', '2026-04-20 10:42:44.023', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 4908300, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/vehicle/list\",\"apiGroup\":\"车辆\",\"method\":\"GET\",\"description\":\"获取车辆列表\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (213, '2026-04-20 10:45:13.758', '2026-04-20 10:45:13.758', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 2653000, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/vehicle/delete\",\"apiGroup\":\"车辆\",\"method\":\"DELETE\",\"description\":\"删除车辆\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (214, '2026-04-20 10:47:41.206', '2026-04-20 10:47:41.206', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 3077800, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/vehicle/entry\",\"apiGroup\":\"车辆\",\"method\":\"POST\",\"description\":\"车辆入场\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (215, '2026-04-20 10:48:22.982', '2026-04-20 10:48:22.982', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 4309400, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/vehicle/exit\",\"apiGroup\":\"车辆\",\"method\":\"POST\",\"description\":\"车辆出场\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (216, '2026-04-20 10:50:49.844', '2026-04-20 10:50:49.844', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 2530900, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/vehicle/fee-config/create\",\"apiGroup\":\"收费\",\"method\":\"POST\",\"description\":\"创建收费配置\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (217, '2026-04-20 11:03:04.373', '2026-04-20 11:03:04.373', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 4295800, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/vehicle/fee-config/update\",\"apiGroup\":\"收费\",\"method\":\"PUT\",\"description\":\"更新收费配置\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (218, '2026-04-20 11:03:37.966', '2026-04-20 11:03:37.966', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 4371000, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/vehicle/fee-config/get\",\"apiGroup\":\"收费\",\"method\":\"GET\",\"description\":\"根据ID获取收费配置\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (219, '2026-04-20 11:04:14.196', '2026-04-20 11:04:14.196', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 1994500, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/vehicle/fee-config/list\",\"apiGroup\":\"收费\",\"method\":\"GET\",\"description\":\"获取收费配置列表\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (220, '2026-04-20 11:15:42.230', '2026-04-20 11:15:42.230', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 5532100, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/vehicle/fee-config/delete\",\"apiGroup\":\"收费\",\"method\":\"DELETE\",\"description\":\"删除收费配置\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (221, '2026-04-20 11:18:18.331', '2026-04-20 11:18:18.331', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 3839600, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/vehicle/record/get\",\"apiGroup\":\"收费\",\"method\":\"GET\",\"description\":\"根据ID获取车辆记录\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (222, '2026-04-20 11:18:41.651', '2026-04-20 11:18:41.651', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 4557200, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/vehicle/record/list-by-plate\",\"apiGroup\":\"收费\",\"method\":\"GET\",\"description\":\"根据车牌号获取车辆记录列表\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (223, '2026-04-20 11:19:07.617', '2026-04-20 11:19:07.617', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 5347200, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/vehicle/record/list\",\"apiGroup\":\"收费\",\"method\":\"GET\",\"description\":\"获取所有车辆记录列表\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (224, '2026-04-20 11:26:22.628', '2026-04-20 11:26:22.628', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 4948300, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/parking/lot/create\",\"apiGroup\":\"停车\",\"method\":\"POST\",\"description\":\"创建停车区域\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (225, '2026-04-20 11:29:04.203', '2026-04-20 11:29:04.203', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 4363200, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/parking/lot/update\",\"apiGroup\":\"停车\",\"method\":\"PUT\",\"description\":\"更新停车区域\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (226, '2026-04-20 11:29:31.731', '2026-04-20 11:29:31.731', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 5058000, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/parking/lot/get\",\"apiGroup\":\"停车\",\"method\":\"GET\",\"description\":\"根据ID获取停车区域\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (227, '2026-04-20 11:29:54.178', '2026-04-20 11:29:54.178', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 2818500, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/parking/lot/get-by-code\",\"apiGroup\":\"停车\",\"method\":\"GET\",\"description\":\"根据编码获取停车区域\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (228, '2026-04-20 11:30:57.129', '2026-04-20 11:30:57.129', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 2991600, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/parking/lot/list\",\"apiGroup\":\"停车\",\"method\":\"GET\",\"description\":\"获取停车区域列表\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (229, '2026-04-20 11:31:45.986', '2026-04-20 11:31:45.986', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 4384800, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/parking/lot/delete\",\"apiGroup\":\"停车\",\"method\":\"DELETE\",\"description\":\"删除停车区域\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (230, '2026-04-20 11:32:23.219', '2026-04-20 11:32:23.219', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 4826700, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/parking/channel/create\",\"apiGroup\":\"通道\",\"method\":\"POST\",\"description\":\"创建通道\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (231, '2026-04-20 11:34:53.954', '2026-04-20 11:34:53.954', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 3990500, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/parking/channel/update\",\"apiGroup\":\"通道\",\"method\":\"PUT\",\"description\":\"更新通道\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (232, '2026-04-20 11:35:22.042', '2026-04-20 11:35:22.042', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 4441100, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/parking/channel/get\",\"apiGroup\":\"通道\",\"method\":\"GET\",\"description\":\"根据ID获取通道\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (233, '2026-04-20 11:37:11.962', '2026-04-20 11:37:11.962', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 4270000, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/parking/channel/get-by-code\",\"apiGroup\":\"通道\",\"method\":\"GET\",\"description\":\"根据编码获取通道\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (234, '2026-04-20 11:37:58.114', '2026-04-20 11:37:58.114', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 4509500, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/parking/channel/list\",\"apiGroup\":\"通道\",\"method\":\"GET\",\"description\":\"获取通道列表\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (235, '2026-04-20 11:38:18.141', '2026-04-20 11:38:18.141', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 7227700, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/parking/channel/delete\",\"apiGroup\":\"通道\",\"method\":\"DELETE\",\"description\":\"删除通道\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (236, '2026-04-20 11:40:39.794', '2026-04-20 11:40:39.794', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 4117100, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/parking/device/create\",\"apiGroup\":\"设备\",\"method\":\"POST\",\"description\":\"创建设备\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (237, '2026-04-20 11:41:06.185', '2026-04-20 11:41:06.185', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 3909500, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/parking/device/update\",\"apiGroup\":\"设备\",\"method\":\"PUT\",\"description\":\"更新设备\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (238, '2026-04-20 11:41:31.889', '2026-04-20 11:41:31.889', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 3747700, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/parking/device/get\",\"apiGroup\":\"设备\",\"method\":\"GET\",\"description\":\"根据ID获取设备\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (239, '2026-04-20 11:41:53.905', '2026-04-20 11:41:53.905', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 3654100, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/parking/device/get-by-code\",\"apiGroup\":\"设备\",\"method\":\"GET\",\"description\":\"根据编码获取设备\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (240, '2026-04-20 11:42:16.457', '2026-04-20 11:42:16.457', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 4175700, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/parking/device/list\",\"apiGroup\":\"设备\",\"method\":\"GET\",\"description\":\"获取设备列表\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (241, '2026-04-20 11:42:45.784', '2026-04-20 11:42:45.784', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 3006100, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/parking/device/delete\",\"apiGroup\":\"设备\",\"method\":\"DELETE\",\"description\":\"删除设备\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (242, '2026-04-20 11:43:25.995', '2026-04-20 11:43:25.995', NULL, '127.0.0.1', 'POST', '/casbin/updateCasbin', 200, 16194300, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '[超出记录长度]', '{\"code\":0,\"data\":{},\"msg\":\"更新成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (243, '2026-04-21 15:47:56.857', '2026-04-21 15:47:56.857', NULL, '127.0.0.1', 'POST', '/api/getApiById', 200, 1070700, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"id\":105}', '{\"code\":0,\"data\":{\"api\":{\"ID\":105,\"CreatedAt\":\"2026-04-20T10:25:19.431+08:00\",\"UpdatedAt\":\"2026-04-20T10:25:19.431+08:00\",\"path\":\"/owner/create\",\"description\":\"新增车主\",\"apiGroup\":\"车主\",\"method\":\"POST\"}},\"msg\":\"获取成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (244, '2026-04-23 09:24:54.620', '2026-04-23 09:24:54.620', NULL, '127.0.0.1', 'POST', '/menu/addBaseMenu', 200, 127844900, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"ID\":0,\"path\":\"carInfo\",\"name\":\"carInfo\",\"hidden\":false,\"parentId\":31,\"component\":\"view/parking/carInfo.vue\",\"meta\":{\"activeName\":\"\",\"title\":\"车辆信息\",\"icon\":\"notebook\",\"defaultMenu\":false,\"closeTab\":false,\"keepAlive\":false},\"parameters\":[],\"menuBtn\":[]}', '{\"code\":0,\"data\":{},\"msg\":\"添加成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (245, '2026-04-23 09:36:07.306', '2026-04-23 09:36:07.306', NULL, '127.0.0.1', 'POST', '/menu/addMenuAuthority', 200, 82907300, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '[超出记录长度]', '{\"code\":0,\"data\":{},\"msg\":\"添加成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (246, '2026-04-24 10:15:11.665', '2026-04-24 10:15:11.665', NULL, '127.0.0.1', 'POST', '/menu/addBaseMenu', 200, 5197500, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"ID\":0,\"path\":\"pricing\",\"name\":\"pricing\",\"hidden\":false,\"parentId\":31,\"component\":\"view/parking/pricing.vue\",\"meta\":{\"activeName\":\"\",\"title\":\"收费配置\",\"icon\":\"\",\"defaultMenu\":false,\"closeTab\":false,\"keepAlive\":false},\"parameters\":[],\"menuBtn\":[]}', '{\"code\":0,\"data\":{},\"msg\":\"添加成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (247, '2026-04-24 10:18:18.512', '2026-04-24 10:18:18.512', NULL, '127.0.0.1', 'POST', '/menu/updateBaseMenu', 200, 57442700, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"ID\":41,\"CreatedAt\":\"2026-04-24T10:15:11.661+08:00\",\"UpdatedAt\":\"2026-04-24T10:15:11.661+08:00\",\"parentId\":31,\"path\":\"pricing\",\"name\":\"pricing\",\"hidden\":false,\"component\":\"view/parking/pricing.vue\",\"sort\":0,\"meta\":{\"activeName\":\"\",\"keepAlive\":false,\"defaultMenu\":false,\"title\":\"收费配置\",\"icon\":\"office-building\",\"closeTab\":false},\"authoritys\":null,\"children\":null,\"parameters\":[],\"menuBtn\":[]}', '{\"code\":0,\"data\":{},\"msg\":\"更新成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (248, '2026-04-24 10:22:55.713', '2026-04-24 10:22:55.713', NULL, '127.0.0.1', 'POST', '/menu/addMenuAuthority', 200, 42292800, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '[超出记录长度]', '{\"code\":0,\"data\":{},\"msg\":\"添加成功\"}', 1); INSERT INTO `sys_operation_records` VALUES (249, '2026-04-30 13:49:26.010', '2026-04-30 13:49:26.010', NULL, '127.0.0.1', 'POST', '/user/setUserAuthorities', 200, 5536400, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"ID\":1,\"authorityId\":888}', '{\"code\":0,\"data\":{},\"msg\":\"修改成功\"}', 3); INSERT INTO `sys_operation_records` VALUES (250, '2026-04-30 13:49:26.715', '2026-04-30 13:49:26.715', NULL, '127.0.0.1', 'POST', '/user/setUserAuthorities', 200, 1739500, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"ID\":1,\"authorityId\":888}', '{\"code\":0,\"data\":{},\"msg\":\"修改成功\"}', 3); INSERT INTO `sys_operation_records` VALUES (251, '2026-04-30 13:49:49.112', '2026-04-30 13:49:49.112', NULL, '127.0.0.1', 'POST', '/casbin/updateCasbin', 200, 7836700, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '[超出记录长度]', '{\"code\":0,\"data\":{},\"msg\":\"更新成功\"}', 3); INSERT INTO `sys_operation_records` VALUES (252, '2026-04-30 13:49:49.886', '2026-04-30 13:49:49.886', NULL, '127.0.0.1', 'POST', '/casbin/updateCasbin', 200, 4789000, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '[超出记录长度]', '{\"code\":0,\"data\":{},\"msg\":\"更新成功\"}', 3); INSERT INTO `sys_operation_records` VALUES (253, '2026-05-08 10:23:37.922', '2026-05-08 10:23:37.922', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 12277800, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/parking/lot/all\",\"apiGroup\":\"停车\",\"method\":\"GET\",\"description\":\"查询所有停车区域\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 3); INSERT INTO `sys_operation_records` VALUES (254, '2026-05-08 10:23:48.986', '2026-05-08 10:23:48.986', NULL, '127.0.0.1', 'POST', '/casbin/updateCasbin', 200, 19859200, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '[超出记录长度]', '{\"code\":0,\"data\":{},\"msg\":\"更新成功\"}', 3); INSERT INTO `sys_operation_records` VALUES (255, '2026-05-08 11:08:10.748', '2026-05-08 11:08:10.748', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 19688000, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/shortlist/queryShortlistList\",\"apiGroup\":\"黑白名单\",\"method\":\"GET\",\"description\":\"查询黑白名单\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 3); INSERT INTO `sys_operation_records` VALUES (256, '2026-05-08 11:08:21.913', '2026-05-08 11:08:21.913', NULL, '127.0.0.1', 'POST', '/casbin/updateCasbin', 200, 19749800, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '[超出记录长度]', '{\"code\":0,\"data\":{},\"msg\":\"更新成功\"}', 3); INSERT INTO `sys_operation_records` VALUES (257, '2026-05-08 14:23:46.950', '2026-05-08 14:23:46.950', NULL, '127.0.0.1', 'POST', '/api/getApiById', 200, 528600, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"id\":146}', '{\"code\":0,\"data\":{\"api\":{\"ID\":146,\"CreatedAt\":\"2026-05-08T11:08:10.736+08:00\",\"UpdatedAt\":\"2026-05-08T11:08:10.736+08:00\",\"path\":\"/shortlist/queryShortlistList\",\"description\":\"查询黑白名单\",\"apiGroup\":\"黑白名单\",\"method\":\"GET\"}},\"msg\":\"获取成功\"}', 3); INSERT INTO `sys_operation_records` VALUES (258, '2026-05-08 14:23:49.877', '2026-05-08 14:23:49.877', NULL, '127.0.0.1', 'POST', '/api/updateApi', 200, 1723700, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"ID\":146,\"CreatedAt\":\"2026-05-08T11:08:10.736+08:00\",\"UpdatedAt\":\"2026-05-08T11:08:10.736+08:00\",\"path\":\"/shortlist/queryShortlistList\",\"description\":\"查询黑白名单\",\"apiGroup\":\"黑白名单\",\"method\":\"POST\"}', '{\"code\":7,\"data\":{},\"msg\":\"修改失败\"}', 3); INSERT INTO `sys_operation_records` VALUES (259, '2026-05-08 14:25:02.079', '2026-05-08 14:25:02.079', NULL, '127.0.0.1', 'POST', '/api/deleteApi', 200, 7695000, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"ID\":146,\"CreatedAt\":\"2026-05-08T11:08:10.736+08:00\",\"UpdatedAt\":\"2026-05-08T11:08:10.736+08:00\",\"path\":\"/shortlist/queryShortlistList\",\"description\":\"查询黑白名单\",\"apiGroup\":\"黑白名单\",\"method\":\"GET\"}', '{\"code\":0,\"data\":{},\"msg\":\"删除成功\"}', 3); INSERT INTO `sys_operation_records` VALUES (260, '2026-05-08 14:25:20.908', '2026-05-08 14:25:20.908', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 5312600, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/shortlist/queryShortlistList\",\"apiGroup\":\"黑白名单\",\"method\":\"POST\",\"description\":\"获取黑白名单\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 3); INSERT INTO `sys_operation_records` VALUES (261, '2026-05-08 14:25:30.088', '2026-05-08 14:25:30.088', NULL, '127.0.0.1', 'POST', '/casbin/updateCasbin', 200, 18156200, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '[超出记录长度]', '{\"code\":0,\"data\":{},\"msg\":\"更新成功\"}', 3); INSERT INTO `sys_operation_records` VALUES (262, '2026-05-08 14:51:02.829', '2026-05-08 14:51:02.829', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 7750700, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/vehicle/all\",\"apiGroup\":\"车辆\",\"method\":\"GET\",\"description\":\"获取全部车辆\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 3); INSERT INTO `sys_operation_records` VALUES (263, '2026-05-08 14:53:35.480', '2026-05-08 14:53:35.480', NULL, '127.0.0.1', 'POST', '/casbin/updateCasbin', 200, 15060100, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '[超出记录长度]', '{\"code\":0,\"data\":{},\"msg\":\"更新成功\"}', 3); INSERT INTO `sys_operation_records` VALUES (264, '2026-05-08 15:54:59.471', '2026-05-08 15:54:59.471', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 4917900, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/vehicle/record/list\",\"apiGroup\":\"车辆\",\"method\":\"POST\",\"description\":\"查询车辆记录列表\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 3); INSERT INTO `sys_operation_records` VALUES (265, '2026-05-08 15:55:12.073', '2026-05-08 15:55:12.073', NULL, '127.0.0.1', 'POST', '/casbin/updateCasbin', 200, 12129300, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '[超出记录长度]', '{\"code\":0,\"data\":{},\"msg\":\"更新成功\"}', 3); INSERT INTO `sys_operation_records` VALUES (266, '2026-05-08 17:28:34.061', '2026-05-08 17:28:34.061', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 20936200, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/vehicle/type/create\",\"apiGroup\":\"车辆类型\",\"method\":\"POST\",\"description\":\"新增车辆类型\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 3); INSERT INTO `sys_operation_records` VALUES (267, '2026-05-08 17:28:56.221', '2026-05-08 17:28:56.221', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 2827000, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/vehicle/type/update\",\"apiGroup\":\"车辆类型\",\"method\":\"PUT\",\"description\":\"修改车辆类型\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 3); INSERT INTO `sys_operation_records` VALUES (268, '2026-05-08 17:29:23.404', '2026-05-08 17:29:23.404', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 3015600, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/vehicle/type/list\",\"apiGroup\":\"车辆类型\",\"method\":\"POST\",\"description\":\"查询车辆类型列表\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 3); INSERT INTO `sys_operation_records` VALUES (269, '2026-05-08 17:30:00.830', '2026-05-08 17:30:00.830', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 1915500, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/vehicle/type/all\",\"apiGroup\":\"车辆类型\",\"method\":\"GET\",\"description\":\"查询所有车辆类型\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 3); INSERT INTO `sys_operation_records` VALUES (270, '2026-05-08 17:30:16.058', '2026-05-08 17:30:16.058', NULL, '127.0.0.1', 'POST', '/casbin/updateCasbin', 200, 25239800, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '[超出记录长度]', '{\"code\":0,\"data\":{},\"msg\":\"更新成功\"}', 3); INSERT INTO `sys_operation_records` VALUES (271, '2026-05-09 17:24:42.809', '2026-05-09 17:24:42.809', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 11513400, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/shortlist/createShortlist\",\"apiGroup\":\"黑白名单\",\"method\":\"POST\",\"description\":\"新增黑白名单\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 3); INSERT INTO `sys_operation_records` VALUES (272, '2026-05-09 17:25:02.589', '2026-05-09 17:25:02.589', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 4093000, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/shortlist/deleteShortlist\",\"apiGroup\":\"黑白名单\",\"method\":\"DELETE\",\"description\":\"删除黑白名单\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 3); INSERT INTO `sys_operation_records` VALUES (273, '2026-05-09 17:26:21.734', '2026-05-09 17:26:21.734', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 2832600, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/shortlist/updateShortlist\",\"apiGroup\":\"黑白名单\",\"method\":\"PUT\",\"description\":\"修改黑白名单\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 3); INSERT INTO `sys_operation_records` VALUES (274, '2026-05-09 17:26:56.871', '2026-05-09 17:26:56.871', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 6344700, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/shortlist/queryAllShortlists\",\"apiGroup\":\"黑白名单\",\"method\":\"GET\",\"description\":\"查询所有黑白名单\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 3); INSERT INTO `sys_operation_records` VALUES (275, '2026-05-09 17:28:08.968', '2026-05-09 17:28:08.968', NULL, '127.0.0.1', 'POST', '/api/createApi', 200, 3794000, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"path\":\"/vehicle/type/delete\",\"apiGroup\":\"车辆类型\",\"method\":\"DELETE\",\"description\":\"删除车辆类型\"}', '{\"code\":0,\"data\":{},\"msg\":\"创建成功\"}', 3); INSERT INTO `sys_operation_records` VALUES (276, '2026-05-09 17:28:30.071', '2026-05-09 17:28:30.071', NULL, '127.0.0.1', 'POST', '/casbin/updateCasbin', 200, 22133900, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '[超出记录长度]', '{\"code\":0,\"data\":{},\"msg\":\"更新成功\"}', 3); INSERT INTO `sys_operation_records` VALUES (277, '2026-05-11 10:06:15.259', '2026-05-11 10:06:15.259', NULL, '127.0.0.1', 'PUT', '/shortlist/updateShortlist', 200, 0, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"ID\":1,\"list_type\":\"白名单\",\"vehicle_id\":27,\"expiration_time\":\"2026-05-08 11:10:14\"}', '{\"code\":7,\"data\":{},\"msg\":\"参数错误\"}', 3); INSERT INTO `sys_operation_records` VALUES (278, '2026-05-11 10:07:44.180', '2026-05-11 10:07:44.180', NULL, '127.0.0.1', 'PUT', '/shortlist/updateShortlist', 200, 512000, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"ID\":1,\"list_type\":\"白名单\",\"vehicle_id\":27,\"expiration_time\":\"2026-05-08 11:10:14\"}', '{\"code\":7,\"data\":{},\"msg\":\"参数错误parsing time \\\"2026-05-08 11:10:14\\\" as \\\"2006-01-02T15:04:05Z07:00\\\": cannot parse \\\" 11:10:14\\\" as \\\"T\\\"\"}', 3); INSERT INTO `sys_operation_records` VALUES (279, '2026-05-11 10:09:25.065', '2026-05-11 10:09:25.065', NULL, '127.0.0.1', 'PUT', '/shortlist/updateShortlist', 200, 0, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"ID\":1,\"list_type\":\"白名单\",\"vehicle_id\":27,\"expiration_time\":\"2026-05-08 11:10:14\"}', '{\"code\":7,\"data\":{},\"msg\":\"参数错误parsing time \\\"2026-05-08 11:10:14\\\" as \\\"2006-01-02T15:04:05Z07:00\\\": cannot parse \\\" 11:10:14\\\" as \\\"T\\\"\"}', 3); INSERT INTO `sys_operation_records` VALUES (280, '2026-05-11 10:14:24.333', '2026-05-11 10:14:24.333', NULL, '127.0.0.1', 'PUT', '/shortlist/updateShortlist', 200, 521600, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"ID\":1,\"list_type\":\"白名单\",\"vehicle_id\":27,\"expiration_time\":\"2026-05-08 11:10:14\"}', '{\"code\":7,\"data\":{},\"msg\":\"参数错误parsing time \\\"2026-05-08 11:10:14\\\" as \\\"2006-01-02T15:04:05Z07:00\\\": cannot parse \\\" 11:10:14\\\" as \\\"T\\\"\"}', 3); INSERT INTO `sys_operation_records` VALUES (281, '2026-05-11 10:15:40.941', '2026-05-11 10:15:40.941', NULL, '127.0.0.1', 'PUT', '/shortlist/updateShortlist', 200, 4346400, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"ID\":1,\"list_type\":\"黑名单\",\"vehicle_id\":27,\"expiration_time\":\"2026-05-30T03:10:14.000Z\"}', '{\"code\":0,\"data\":{},\"msg\":\"修改成功\"}', 3); INSERT INTO `sys_operation_records` VALUES (282, '2026-05-11 10:15:44.193', '2026-05-11 10:15:44.193', NULL, '127.0.0.1', 'PUT', '/shortlist/updateShortlist', 200, 0, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"ID\":1,\"list_type\":\"黑名单\",\"vehicle_id\":27,\"expiration_time\":\"2026-05-30 11:10:14\"}', '{\"code\":7,\"data\":{},\"msg\":\"参数错误parsing time \\\"2026-05-30 11:10:14\\\" as \\\"2006-01-02T15:04:05Z07:00\\\": cannot parse \\\" 11:10:14\\\" as \\\"T\\\"\"}', 3); INSERT INTO `sys_operation_records` VALUES (283, '2026-05-11 10:15:53.307', '2026-05-11 10:15:53.307', NULL, '127.0.0.1', 'PUT', '/shortlist/updateShortlist', 200, 3663000, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"ID\":1,\"list_type\":\"黑名单\",\"vehicle_id\":27,\"expiration_time\":\"2026-05-31T03:10:14.000Z\"}', '{\"code\":0,\"data\":{},\"msg\":\"修改成功\"}', 3); INSERT INTO `sys_operation_records` VALUES (284, '2026-05-11 10:16:03.682', '2026-05-11 10:16:03.682', NULL, '127.0.0.1', 'PUT', '/shortlist/updateShortlist', 200, 1580000, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"ID\":1,\"list_type\":\"白名单\",\"vehicle_id\":27,\"expiration_time\":\"2026-06-03T03:10:14.000Z\"}', '{\"code\":0,\"data\":{},\"msg\":\"修改成功\"}', 3); INSERT INTO `sys_operation_records` VALUES (285, '2026-05-11 10:20:25.456', '2026-05-11 10:20:25.456', NULL, '127.0.0.1', 'PUT', '/shortlist/updateShortlist', 200, 0, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"ID\":1,\"list_type\":\"黑名单\",\"vehicle_id\":27,\"expiration_time\":\"2026-06-03 11:10:14\"}', '{\"code\":7,\"data\":{},\"msg\":\"参数错误parsing time \\\"2026-06-03 11:10:14\\\" as \\\"2006-01-02T15:04:05Z07:00\\\": cannot parse \\\" 11:10:14\\\" as \\\"T\\\"\"}', 3); INSERT INTO `sys_operation_records` VALUES (286, '2026-05-11 10:31:48.675', '2026-05-11 10:31:48.675', NULL, '127.0.0.1', 'POST', '/shortlist/createShortlist', 200, 538000, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"ID\":0,\"list_type\":\"白名单\",\"vehicle_id\":25,\"expiration_time\":\"\"}', '{\"code\":7,\"data\":{},\"msg\":\"参数错误\"}', 3); INSERT INTO `sys_operation_records` VALUES (287, '2026-05-11 10:32:32.734', '2026-05-11 10:32:32.734', NULL, '127.0.0.1', 'POST', '/shortlist/createShortlist', 200, 529400, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"ID\":0,\"list_type\":\"白名单\",\"vehicle_id\":25,\"expiration_time\":\"\"}', '{\"code\":7,\"data\":{},\"msg\":\"参数错误parsing time \\\"\\\" as \\\"2006-01-02T15:04:05Z07:00\\\": cannot parse \\\"\\\" as \\\"2006\\\"\"}', 3); INSERT INTO `sys_operation_records` VALUES (288, '2026-05-11 10:33:52.923', '2026-05-11 10:33:52.923', NULL, '127.0.0.1', 'POST', '/shortlist/createShortlist', 200, 2140400, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0', '', '{\"ID\":0,\"list_type\":\"白名单\",\"vehicle_id\":25,\"expiration_time\":null}', '{\"code\":0,\"data\":{},\"msg\":\"新增成功\"}', 3); -- ---------------------------- -- 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, 888); INSERT INTO `sys_user_authority` VALUES (4, 618); -- ---------------------------- -- 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 = 5 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', '2026-04-30 13:49:26.714', NULL, '07c9149c-6a9a-4126-8d8a-dd11c7b914a1', 'admin', '$2a$10$WTDQCqEQzEi/FU2UKejgGuWDK3PtHT0yb6xwY.yhx4ugjAmS6iTNa', '龙弛管理员', 'dark', 'uploads/file/70b1e321d2ec7357cb1b948f5bde35a6_20240606094912.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-06-07 09:37:12.052', NULL, '0a5db918-c3cc-4034-a32a-6c15f37e78cb', 'xuwenhao', '$2a$10$EL7QgO5cVNdB6N2rYqAQNOLj8w3mSh9noKpjmPfFO98ip0GyR9x3y', '许文浩', 'dark', 'uploads/file/c67b3af7ed83579cc083089fc0bbefd0_20240505115511.jpg', '#fff', '#1890ff', 888, '17365743261', 'sn3115614529@163.com', 1); INSERT INTO `sys_users` VALUES (4, '2024-06-07 09:39:41.995', '2024-06-11 09:51:50.310', NULL, '9fce89d6-8552-4637-9cd1-9ffd6c8d4dbd', 'chengqian', '$2a$10$0qbv0aeavXAxdqUNIAhIC.TK/hfgC8Ky.sP0dK9fAw9lIsR9cIive', '程潜', 'dark', 'https://qmplusimg.henrongyi.top/1576554439myAvatar.png', '#fff', '#1890ff', 618, '18574363259', '', 1); -- ---------------------------- -- Table structure for uhf_reader -- ---------------------------- DROP TABLE IF EXISTS `uhf_reader`; CREATE TABLE `uhf_reader` ( `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, `device_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `device_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `connect_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'tcp', `ip_address` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `port` bigint(20) NULL DEFAULT 0, `com_port` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `baud_rate` bigint(20) NULL DEFAULT 9600, `status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'offline', `is_active` tinyint(1) NULL DEFAULT 1, `description` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `parking_lot_id` bigint(20) UNSIGNED NULL DEFAULT NULL, `last_online_time` datetime(3) NULL DEFAULT NULL COMMENT '最后上线时间', `channel_id` bigint(20) UNSIGNED NULL DEFAULT NULL COMMENT '绑定通道ID', `device_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `idx_uhf_reader_device_code`(`device_code`) USING BTREE, INDEX `idx_uhf_reader_deleted_at`(`deleted_at`) USING BTREE, INDEX `idx_uhf_reader_channel_id`(`channel_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of uhf_reader -- ---------------------------- INSERT INTO `uhf_reader` VALUES (1, '2026-05-05 08:10:21.000', '2026-05-11 10:59:50.900', NULL, '2121', '2121', 'serial', NULL, 0, 'COM12', 115200, 'online', 1, NULL, 1, NULL, 1, ''); INSERT INTO `uhf_reader` VALUES (2, '2026-05-11 11:33:25.653', '2026-05-11 11:33:25.653', NULL, '231321', '测试4', 'tcp', '192.168.1.110', 8866, '', 9600, 'offline', 1, '', 2, NULL, 0, ''); -- ---------------------------- -- Table structure for vehicle -- ---------------------------- DROP TABLE IF EXISTS `vehicle`; CREATE TABLE `vehicle` ( `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, `plate_number` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `vehicle_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `vehicle_brand` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `vehicle_color` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `owner_id` bigint(20) UNSIGNED NULL DEFAULT NULL, `last_entry_time` datetime(3) NULL DEFAULT NULL, `last_exit_time` datetime(3) NULL DEFAULT NULL, `total_stay_time` bigint(20) NULL DEFAULT NULL, `total_fee` double NULL DEFAULT NULL, `rfid_tag` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `rf_id_tag` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `vehicle_type_id` bigint(20) UNSIGNED NOT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `idx_vehicle_plate_number`(`plate_number`) USING BTREE, INDEX `idx_vehicle_deleted_at`(`deleted_at`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 29 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of vehicle -- ---------------------------- INSERT INTO `vehicle` VALUES (25, '2026-04-28 16:39:23.544', '2026-05-11 11:01:50.409', NULL, '湘F:896T1', '临时车', '宾利', '蓝色', 3, '2026-05-11 11:01:34.955', '2026-05-11 11:01:50.405', 22, 2.2, '000200000000000181010110', '000200000000000181010110', 1); INSERT INTO `vehicle` VALUES (27, '2026-04-28 16:56:10.801', '2026-05-08 17:41:26.968', NULL, '湘p:9586T', '月租车', '保时捷', '黑色', 2, NULL, NULL, 0, 0, '', '000200000000010181010110', 2); INSERT INTO `vehicle` VALUES (28, '2026-04-28 16:57:27.703', '2026-04-28 16:57:27.703', '2026-04-29 10:33:01.377', '湘c:964P0', '月租车', '迈巴赫', '褐色', 3, NULL, NULL, 0, 0, NULL, '', 0); -- ---------------------------- -- Table structure for vehicle_record -- ---------------------------- DROP TABLE IF EXISTS `vehicle_record`; CREATE TABLE `vehicle_record` ( `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, `plate_number` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `entry_time` datetime(3) NULL DEFAULT NULL, `exit_time` datetime(3) NULL DEFAULT NULL, `stay_time` bigint(20) NULL DEFAULT NULL, `fee` double NULL DEFAULT NULL, `payment_status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'unpaid', `entry_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `exit_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `parking_lot_id` bigint(20) UNSIGNED NULL DEFAULT NULL, `parking_space_id` bigint(20) UNSIGNED NULL DEFAULT NULL, `rf_id_tag` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `rfid_tag` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `idx_vehicle_record_deleted_at`(`deleted_at`) USING BTREE, INDEX `idx_vehicle_record_plate_number`(`plate_number`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of vehicle_record -- ---------------------------- INSERT INTO `vehicle_record` VALUES (2, '2026-05-07 08:42:26.357', '2026-05-07 08:47:55.547', NULL, '', '2026-05-07 08:42:26.357', '2026-05-07 08:47:55.546', 5, 0.5, 'paid', '', '', 1, 0, NULL, '00020000000000018101'); INSERT INTO `vehicle_record` VALUES (3, '2026-05-09 15:53:46.499', '2026-05-09 16:03:37.485', NULL, '', '2026-05-09 15:53:46.499', '2026-05-09 16:03:37.483', 9, 0.9, 'paid', '', '', 0, 0, NULL, '00020000000000018101'); INSERT INTO `vehicle_record` VALUES (4, '2026-05-09 16:20:54.900', '2026-05-09 16:21:43.283', NULL, '', '2026-05-09 16:20:54.900', '2026-05-09 16:21:43.283', 0, 0, 'paid', '', '', 1, 0, NULL, '00020000000000018101'); INSERT INTO `vehicle_record` VALUES (5, '2026-05-09 16:27:44.839', '2026-05-09 16:28:18.038', NULL, '', '2026-05-09 16:27:44.839', '2026-05-09 16:28:18.037', 0, 0, 'paid', '', '', 1, 0, NULL, '00020000000000018101'); INSERT INTO `vehicle_record` VALUES (7, '2026-05-09 16:37:26.822', '2026-05-09 16:37:52.482', NULL, '', '2026-05-09 16:37:26.822', '2026-05-09 16:37:52.482', 0, 0, 'paid', '', '', 1, 0, NULL, '00020000000000018101'); INSERT INTO `vehicle_record` VALUES (8, '2026-05-09 16:38:16.088', '2026-05-09 16:46:39.062', NULL, '', '2026-05-09 16:38:16.088', '2026-05-09 16:46:39.062', 8, 0.8, 'paid', '', '', 1, 0, NULL, '00020000000000018101'); INSERT INTO `vehicle_record` VALUES (9, '2026-05-11 10:52:12.704', '2026-05-11 10:53:01.839', NULL, '', '2026-05-11 10:52:12.704', '2026-05-11 10:53:01.839', 0, 0, 'paid', '', '', 1, 0, NULL, '000200000000000181010110'); INSERT INTO `vehicle_record` VALUES (10, '2026-05-11 11:00:37.212', '2026-05-11 11:01:04.343', NULL, '', '2026-05-11 11:00:37.212', '2026-05-11 11:01:04.343', 0, 0, 'paid', '', '', 1, 0, NULL, '000200000000000181010110'); INSERT INTO `vehicle_record` VALUES (11, '2026-05-11 11:01:34.955', '2026-05-11 11:01:50.406', NULL, '', '2026-05-11 11:01:34.955', '2026-05-11 11:01:50.405', 0, 0, 'paid', '', '', 1, 0, NULL, '000200000000000181010110'); -- ---------------------------- -- Table structure for vehicle_type -- ---------------------------- DROP TABLE IF EXISTS `vehicle_type`; CREATE TABLE `vehicle_type` ( `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 '名称', `remarks` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_vehicle_type_deleted_at`(`deleted_at`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of vehicle_type -- ---------------------------- INSERT INTO `vehicle_type` VALUES (1, '2026-05-08 17:40:32.000', '2026-05-08 17:40:35.000', NULL, '临时车', NULL); INSERT INTO `vehicle_type` VALUES (2, '2026-05-08 17:40:49.000', '2026-05-08 17:40:51.000', NULL, '月租车', NULL); INSERT INTO `vehicle_type` VALUES (3, '2026-05-09 17:28:59.080', '2026-05-09 17:28:59.080', NULL, '户主车', ''); SET FOREIGN_KEY_CHECKS = 1;