/*
 Navicat Premium Data Transfer

 Source Server         : ubuntu
 Source Server Type    : MySQL
 Source Server Version : 80035
 Source Host           : localhost:3306
 Source Schema         : pdt

 Target Server Type    : MySQL
 Target Server Version : 80035
 File Encoding         : 65001

 Date: 09/01/2025 11:44:23
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for TB_admin_menu
-- ----------------------------
DROP TABLE IF EXISTS `TB_admin_menu`;
CREATE TABLE `TB_admin_menu`  (
  `id` int(0) UNSIGNED NOT NULL AUTO_INCREMENT,
  `parent_id` int(0) NOT NULL DEFAULT 0,
  `order` int(0) NOT NULL DEFAULT 0,
  `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `uri` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `permission` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `created_at` timestamp(0) NULL DEFAULT NULL,
  `updated_at` timestamp(0) NULL DEFAULT NULL,
  `title_en` varchar(55) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '菜单英文名',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 46 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of TB_admin_menu
-- ----------------------------
INSERT INTO `TB_admin_menu` VALUES (1, 0, 1, '信息中心', 'fa-bar-chart', '/', NULL, NULL, '2022-08-15 14:47:19', 'Information Center');
INSERT INTO `TB_admin_menu` VALUES (2, 0, 36, '后台管理', 'fa-tasks', NULL, NULL, NULL, '2024-09-25 14:42:15', 'Back-stage Management');
INSERT INTO `TB_admin_menu` VALUES (3, 2, 37, '用户管理', 'fa-users', 'auth/users', NULL, NULL, '2024-09-25 14:42:15', 'User Management');
INSERT INTO `TB_admin_menu` VALUES (4, 2, 38, '角色管理', 'fa-user', 'auth/roles', NULL, NULL, '2024-09-25 14:42:15', 'Role Management');
INSERT INTO `TB_admin_menu` VALUES (5, 2, 39, '权限管理', 'fa-ban', 'auth/permissions', NULL, NULL, '2024-09-25 14:42:15', 'Rights Management');
INSERT INTO `TB_admin_menu` VALUES (6, 2, 40, '菜单管理', 'fa-bars', 'auth/menu', NULL, NULL, '2024-09-25 14:42:15', 'Menu Management');
INSERT INTO `TB_admin_menu` VALUES (7, 2, 41, '日志管理', 'fa-history', 'auth/logs', NULL, NULL, '2024-09-25 14:42:15', 'Log Management');
INSERT INTO `TB_admin_menu` VALUES (8, 11, 9, '站点管理', 'fa-sitemap', 'site-infos', 'site-infos-menu', '2022-08-04 16:58:54', '2023-08-23 14:25:36', 'Site Management');
INSERT INTO `TB_admin_menu` VALUES (10, 11, 8, '部门管理', 'fa-users', '/department', 'department-menu', '2022-08-15 10:25:51', '2023-08-23 14:25:26', 'Department Management');
INSERT INTO `TB_admin_menu` VALUES (11, 0, 3, '数据管理', 'fa-database', NULL, NULL, '2022-08-15 14:46:42', '2023-08-22 14:49:50', 'Data Management');
INSERT INTO `TB_admin_menu` VALUES (12, 11, 12, '中继台管理', 'fa-server', '/repeatorInfo', 'repeatorInfo-menu', '2022-08-15 14:47:56', '2023-08-23 14:27:23', 'Relay Station Management');
INSERT INTO `TB_admin_menu` VALUES (13, 11, 10, '分组管理', 'fa-object-ungroup', '/groupInfo', 'groupInfo-menu', '2022-08-15 14:48:03', '2023-08-23 14:25:57', 'Group Management');
INSERT INTO `TB_admin_menu` VALUES (14, 11, 13, '临近站管理', 'fa-map-marker', '/nearSiteInfo', 'nearSiteInfo-menu', '2022-08-15 14:54:19', '2023-08-23 14:27:35', 'Adjacent Station Management');
INSERT INTO `TB_admin_menu` VALUES (15, 0, 15, '在线会话', 'fa-microphone', NULL, NULL, '2022-08-15 14:54:46', '2023-08-22 14:49:50', 'Online Conversation');
INSERT INTO `TB_admin_menu` VALUES (16, 15, 17, '在线站点会话', 'fa-volume-control-phone', '/onlineSiteInfo', 'onlineSiteInfo-list', '2022-08-15 15:20:04', '2023-08-23 14:29:06', 'Online Site Sessions');
INSERT INTO `TB_admin_menu` VALUES (17, 15, 18, '在线设备', 'fa-mobile-phone', '/onlineDeviceInfo', 'onlineDeviceInfo-site-list', '2022-08-15 15:20:15', '2023-08-23 14:29:25', 'In-line Equipment');
INSERT INTO `TB_admin_menu` VALUES (18, 15, 19, '呼叫拓扑', 'fa-bars', '/directTalkSession', 'directTalkSession-list', '2022-08-15 15:20:56', '2023-08-23 14:29:44', 'Call Topology');
INSERT INTO `TB_admin_menu` VALUES (19, 11, 14, '设备管理', 'fa-mobile-phone', '/deviceInfo', 'deviceInfo-menu', '2022-08-15 15:21:12', '2023-08-23 14:28:00', 'Equipment Management');
INSERT INTO `TB_admin_menu` VALUES (20, 0, 20, '可视化调度', 'fa-bullseye', NULL, NULL, '2022-08-15 15:21:27', '2023-08-22 14:49:50', 'Visual Dispatch');
INSERT INTO `TB_admin_menu` VALUES (21, 20, 23, '地图', 'fa-map', '/map', 'map-menu', '2022-08-15 15:21:44', '2023-08-23 14:30:31', 'Map');
INSERT INTO `TB_admin_menu` VALUES (22, 20, 22, '电子围栏', 'fa-th', '/mapFence', 'mapFence-menu', '2022-08-15 15:22:03', '2023-08-23 14:30:11', 'Electronic Fence');
INSERT INTO `TB_admin_menu` VALUES (23, 0, 24, '系统日志', 'fa-clone', NULL, NULL, '2022-08-15 15:22:16', '2023-08-22 14:49:50', 'System Log');
INSERT INTO `TB_admin_menu` VALUES (24, 23, 28, '日志查询', 'fa-clipboard', 'logs-infos', 'logs-infos', '2022-08-15 15:22:28', '2024-09-25 14:42:15', 'Log Query');
INSERT INTO `TB_admin_menu` VALUES (25, 23, 29, '录音', 'fa-file-sound-o', 'videorecode-infos', 'Recording', '2022-08-15 15:22:38', '2024-09-25 14:42:15', 'Recording');
INSERT INTO `TB_admin_menu` VALUES (26, 32, 34, '参数设置管理', 'fa-cog', '/settings', 'settings-menu', '2022-08-19 11:19:13', '2024-09-25 14:42:15', 'Recording Parameter Setting Management');
INSERT INTO `TB_admin_menu` VALUES (27, 11, 7, '调度台管理', 'fa-bars', 'dispatcher', 'dispatcher-menu', '2022-09-02 16:39:23', '2023-08-23 14:23:42', 'Dispatch Management');
INSERT INTO `TB_admin_menu` VALUES (31, 20, 21, 'GPS订阅', 'fa-check-circle', '/gpsSubscriptions', 'gpsSubscriptions-menu', '2022-10-13 15:08:16', '2023-08-23 14:30:00', 'GPS Subscription');
INSERT INTO `TB_admin_menu` VALUES (30, 11, 11, '动态分组', 'fa-forumbee', '/trendsGroup', 'trendsGroup-menu', '2022-09-22 17:08:09', '2023-08-23 14:26:57', 'Dynamic Grouping');
INSERT INTO `TB_admin_menu` VALUES (32, 0, 30, '配置管理', 'fa-cogs', NULL, NULL, '2022-10-27 17:09:53', '2024-09-25 14:42:15', 'Configuration Management');
INSERT INTO `TB_admin_menu` VALUES (33, 32, 35, '核心库配置管理', 'fa-cog', 'coreConfig', 'coreConfig', '2022-10-27 17:10:29', '2024-09-25 14:42:15', 'Core Library Configuration Management');
INSERT INTO `TB_admin_menu` VALUES (34, 11, 6, '区域编码管理', 'fa-bars', 'area-code', 'area-code-menu', '2022-12-01 16:42:59', '2023-08-23 14:23:20', 'Regional Management');
INSERT INTO `TB_admin_menu` VALUES (35, 11, 5, '警员设备管理', 'fa-balance-scale', 'police-info', 'police-info-menu', '2022-12-06 17:02:00', '2023-08-23 14:19:42', 'Police Officer Equipment Management');
INSERT INTO `TB_admin_menu` VALUES (36, 32, 33, '站点相关配置', 'fa-bars', '/serverConfig', 'serverConfig-menu', '2023-02-23 15:04:28', '2024-09-25 14:42:15', 'Site Related Configuration');
INSERT INTO `TB_admin_menu` VALUES (37, 11, 4, '设备所在组', 'fa-clone', 'grouphasdevic', 'grouphasdevic-menu', '2023-03-17 10:36:02', '2023-08-23 14:16:45', 'Device In Group');
INSERT INTO `TB_admin_menu` VALUES (38, 15, 16, '部门站点关系管理', 'fa-codepen', 'departmentWithSite', 'departmentWithSite', '2023-03-31 10:41:29', '2023-08-23 14:28:22', 'Department Site Relationship Management');
INSERT INTO `TB_admin_menu` VALUES (39, 0, 2, '火警设备管理', 'fa-fire-extinguisher', 'fireAlarm', NULL, '2023-08-22 14:49:44', '2023-08-22 14:51:23', 'Fire alarm equipment management');
INSERT INTO `TB_admin_menu` VALUES (40, 23, 27, '后台短信记录', 'fa-commenting-o', 'sendmessagerecord', 'sendmessagerecord', '2023-08-22 14:50:52', '2024-09-25 14:42:15', 'Background SMS recording');
INSERT INTO `TB_admin_menu` VALUES (42, 32, 31, 'APP版本配置', 'fa-android', 'deviceOTA', NULL, '2024-01-12 15:05:20', '2024-09-25 14:42:15', 'APP version configuration');
INSERT INTO `TB_admin_menu` VALUES (43, 32, 32, '固件版本管理', 'fa-asterisk', 'deviceFirmwares', NULL, '2024-01-12 15:48:43', '2024-09-25 14:42:15', 'Firmware version management');
INSERT INTO `TB_admin_menu` VALUES (45, 23, 25, '录音下载', 'fa-bars', 'recorddownload', '*', '2024-09-25 14:42:13', '2024-09-25 14:42:15', 'Record Download');

SET FOREIGN_KEY_CHECKS = 1;
