| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960 |
- -- MySQL dump 10.13 Distrib 5.7.42, for Linux (x86_64)
- --
- -- Host: 192.168.0.210 Database: reghao_bnt_tdb
- -- ------------------------------------------------------
- -- Server version 5.7.36
- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
- /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
- /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
- /*!40101 SET NAMES utf8 */;
- /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
- /*!40103 SET TIME_ZONE='+00:00' */;
- /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
- /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
- /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
- /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
- --
- -- Table structure for table `sys_menu`
- --
- DROP TABLE IF EXISTS `sys_menu`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `sys_menu` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `create_time` datetime(6) DEFAULT NULL,
- `update_time` datetime(6) DEFAULT NULL,
- `icon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
- `pid` int(11) DEFAULT NULL,
- `pos` int(11) DEFAULT NULL,
- `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
- `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
- `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
- `enabled` bit(1) DEFAULT NULL,
- `deleted` bit(1) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=13421 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `sys_menu`
- --
- LOCK TABLES `sys_menu` WRITE;
- /*!40000 ALTER TABLE `sys_menu` DISABLE KEYS */;
- INSERT INTO `sys_menu` VALUES (1,'2021-05-11 15:20:06.022212','2024-07-29 13:02:25.068263','fa fa-cog',0,99,'RBAC','dir','admin/rbac/',_binary '',_binary '\0'),(2,'2021-05-11 15:20:06.042662','2021-05-19 16:14:04.207084','fa fa-user',1,1,'资源管理','page','admin/rbac/menu/',_binary '',_binary '\0'),(3,'2021-05-11 15:20:06.041503','2021-05-11 15:20:06.041529','fa fa-user',1,2,'角色管理','page','admin/rbac/role/',_binary '',_binary '\0'),(4,'2021-05-11 15:20:06.040161','2021-05-19 14:05:42.646522','fa fa-user',1,3,'用户管理','page','admin/rbac/user/',_binary '',_binary '\0'),(5,'2021-05-11 15:20:06.023637','2024-07-29 13:02:25.073805','fa fa-cog',0,88,'系统','dir','admin/sys/',_binary '',_binary '\0'),(6,'2024-02-01 14:26:45.382748','2024-02-01 14:26:45.382766','fa fa-cog',26,2,'头像列表','page','admin/tnb/account/avatar',_binary '',_binary '\0'),(7,'2024-02-05 09:32:04.801615','2024-02-05 09:32:04.801630','fa fa-cog',29,5,'会员计划','page','admin/tnb/site/vip',_binary '',_binary '\0'),(8,'2022-09-22 17:57:35.861167','2022-09-22 17:57:35.861193','fa fa-cog',40,7,'运行日志','page','admin/sys/log/rt',_binary '',_binary '\0'),(9,'2024-02-01 14:26:45.382748','2024-02-01 14:26:45.382766','fa fa-cog',40,1,'访问日志','page','admin/sys/log/access',_binary '',_binary '\0'),(10,'2024-02-01 14:27:22.721533','2024-02-01 14:27:22.721541','fa fa-cog',25,1,'系统状态','dir','admin/tnb/sys/',_binary '',_binary '\0'),(11,'2024-02-01 14:29:58.174273','2024-02-01 14:29:58.174282','fa fa-cog',5,2,'通知','page','admin/sys/notify/sender',_binary '',_binary '\0'),(12,'2021-05-20 13:54:34.299197','2024-07-29 13:02:25.075657','fa fa-server',0,3,'blog','dir','admin/blog/',_binary '',_binary '\0'),(13,'2021-05-13 10:31:09.179446','2024-07-29 13:02:25.074811','fa fa-cog',10,3,'网关路由','page','admin/tnb/sys/route',_binary '',_binary '\0'),(14,'2021-05-13 10:34:32.400476','2023-11-02 13:28:31.292504','fa fa-cog',12,3,'分类管理','page','admin/blog/category/list',_binary '',_binary '\0'),(15,'2021-05-13 10:38:19.945521','2023-11-02 13:28:31.304294','fa fa-cog',12,4,'标签列表','page','admin/blog/tag/list',_binary '',_binary '\0'),(16,'2021-05-17 18:08:58.040642','2023-11-02 13:28:31.305271','fa fa-cog',12,5,'文章管理','page','admin/blog/post/list',_binary '',_binary '\0'),(17,'2021-05-17 18:10:42.043424','2021-05-17 18:10:42.043453','fa fa-cog',12,6,'面试题','page','admin/blog/interview/question/list',_binary '',_binary '\0'),(18,'2024-02-05 09:32:04.801615','2024-07-29 13:02:25.077112','fa fa-cog',0,11,'oss','dir','admin/oss/',_binary '',_binary '\0'),(19,'2021-05-13 10:38:19.945521','2023-11-02 13:28:31.304294','fa fa-cog',5,1,'OSS','page','admin/sys/oss/store/list',_binary '',_binary '\0'),(20,'2021-05-13 10:34:32.400476','2024-02-27 08:39:32.913229','fa fa-cog',18,4,'上传通道','page','admin/oss/channel/list',_binary '',_binary '\0'),(21,'2021-05-20 13:53:46.834540','2024-02-27 08:39:32.920551','fa fa-cog',18,3,'我的节点','page','admin/oss/my/list',_binary '',_binary '\0'),(22,'2022-09-22 17:57:35.861167','2022-09-22 17:57:35.861193','fa fa-cog',18,9,'对象上传','page','admin/oss/object/upload',_binary '',_binary '\0'),(23,'2023-11-02 13:37:43.413211','2024-02-20 15:40:52.691948','fa fa-cog',18,5,'OSS Key','page','admin/oss/key',_binary '',_binary '\0'),(24,'2023-11-08 09:50:28.465738','2024-02-20 15:45:01.661523','fa fa-cog',18,7,'对象列表','page','admin/oss/object/list',_binary '',_binary '\0'),(25,'2021-05-20 13:55:24.546804','2021-05-20 13:55:24.546861','fa fa-server',0,22,'tnb','dir','admin/tnb/',_binary '',_binary '\0'),(26,'2021-05-20 13:54:34.299197','2024-07-29 13:02:25.077823','fa fa-cog',25,33,'帐号','dir','admin/tnb/account/',_binary '',_binary '\0'),(27,'2021-05-13 10:31:09.179446','2024-07-29 13:02:25.078631','fa fa-cog',25,34,'内容','dir','admin/tnb/content/',_binary '',_binary '\0'),(28,'2021-05-20 13:44:18.715247','2024-07-29 13:02:25.079303','fa fa-cog',25,35,'消息','dir','admin/tnb/message',_binary '',_binary '\0'),(29,'2023-11-02 13:28:31.320919','2024-07-29 13:02:25.079928','fa fa-cog',25,31,'站点配置','dir','admin/tnb/site/',_binary '',_binary '\0'),(30,'2021-05-20 13:55:24.546804','2021-05-20 13:55:24.546861','fa fa-cog',26,1,'用户列表','page','admin/tnb/account/list',_binary '',_binary '\0'),(31,'2021-05-20 13:53:46.834540','2023-11-02 13:28:31.306284','fa fa-cog',26,9,'充值请求','page','admin/tnb/account/charge',_binary '',_binary '\0'),(32,'2021-05-17 18:08:58.040642','2023-11-02 13:28:31.305271','fa fa-cog',29,2,'站点公告','page','admin/tnb/site/config',_binary '',_binary '\0'),(33,'2021-05-20 13:45:11.729758','2021-05-20 13:45:11.729792','fa fa-cog',29,3,'视频分区','page','admin/tnb/site/content',_binary '',_binary '\0'),(34,'2021-05-13 10:38:19.945521','2023-11-02 13:28:31.304294','fa fa-cog',27,1,'稿件列表','page','admin/tnb/content/post',_binary '',_binary '\0'),(35,'2022-09-22 17:57:35.861167','2022-09-22 17:57:35.861193','fa fa-cog',28,1,'消息列表','page','admin/tnb/message/list',_binary '',_binary '\0'),(36,'2024-02-01 14:26:45.382748','2024-02-01 14:26:45.382766','fa fa-cog',29,4,'第三方通知配置','page','admin/tnb/site/message',_binary '',_binary '\0'),(37,'2023-11-01 10:57:40.679387','2023-11-02 13:36:36.717174','fa fa-cog',29,1,'文件存储','page','admin/tnb/site/file',_binary '',_binary '\0'),(38,'2024-02-01 14:26:45.382748','2024-07-29 13:02:25.080535','fa fa-cog',10,4,'请求日志','page','admin/tnb/sys/log',_binary '',_binary '\0'),(39,'2024-02-01 14:26:45.382748','2024-02-01 14:26:45.382766','fa fa-cog',10,1,'dubbo','page','admin/tnb/sys/dubbo',_binary '',_binary '\0'),(40,'2022-09-22 17:57:35.861167','2022-09-22 17:57:35.861193','fa fa-cog',5,3,'日志','dir','admin/sys/log/',_binary '',_binary '\0'),(13409,'2022-09-22 17:57:35.861167','2022-09-22 17:57:35.861193','fa fa-file',27,2,'延时任务','page','admin/tnb/content/video/convert',_binary '',_binary '\0'),(13410,'2021-05-17 18:10:42.043424','2021-05-17 18:10:42.043453','fa fa-dashboard',12,1,'博客仪表盘','page','admin/blog/dashboard',_binary '\0',_binary '\0'),(13411,'2021-05-17 18:10:42.043424','2021-05-17 18:10:42.043453','fa fa-dashboard',10,2,'springcloud','page','admin/tnb/sys/springcloud',_binary '',_binary '\0'),(13412,'2021-05-17 18:10:42.043424','2021-05-17 18:10:42.043453','fa fa-dashboard',5,7,'device','page','admin/sys/device',_binary '\0',_binary '\0'),(13413,'2021-05-17 18:10:42.043424','2021-05-17 18:10:42.043453','fa fa-camera',0,39,'我的监控','page','disk/cam',_binary '',_binary '\0'),(13414,'2021-05-17 18:10:42.043424','2021-05-17 18:10:42.043453','fa fa-file-o',0,31,'我的文件','page','disk/file',_binary '',_binary '\0'),(13415,'2021-05-17 18:10:42.043424','2021-05-17 18:10:42.043453','fa fa-file-word-o',0,35,'我的文档','page','disk/doc',_binary '',_binary '\0'),(13416,'2021-05-17 18:10:42.043424','2021-05-17 18:10:42.043453','fa fa-file-audio-o',0,34,'我的音频','page','disk/audio',_binary '',_binary '\0'),(13417,'2021-05-17 18:10:42.043424','2021-05-17 18:10:42.043453','fa fa-file-image-o',0,32,'我的图片','page','disk/image',_binary '',_binary '\0'),(13418,'2021-05-17 18:10:42.043424','2021-05-17 18:10:42.043453','fa fa-file-video-o',0,33,'我的视频','page','disk/video',_binary '',_binary '\0'),(13419,'2021-05-17 18:10:42.043424','2021-05-17 18:10:42.043453','fa fa-calendar',0,38,'我的日历','page','disk/calendar',_binary '',_binary '\0'),(13420,'2021-05-17 18:10:42.043424','2021-05-17 18:10:42.043453','fa fa-dashboard',0,1,'user','dir','admin/user1/',_binary '\0',_binary '\0');
- /*!40000 ALTER TABLE `sys_menu` ENABLE KEYS */;
- UNLOCK TABLES;
- /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
- /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
- /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
- /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
- /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
- /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
- /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
- /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
- -- Dump completed on 2024-12-15 22:47:22
|