sys_menu.sql 9.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960
  1. -- MySQL dump 10.13 Distrib 5.7.42, for Linux (x86_64)
  2. --
  3. -- Host: 192.168.0.210 Database: reghao_bnt_tdb
  4. -- ------------------------------------------------------
  5. -- Server version 5.7.36
  6. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  7. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  8. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  9. /*!40101 SET NAMES utf8 */;
  10. /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  11. /*!40103 SET TIME_ZONE='+00:00' */;
  12. /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  13. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  14. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  15. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  16. --
  17. -- Table structure for table `sys_menu`
  18. --
  19. DROP TABLE IF EXISTS `sys_menu`;
  20. /*!40101 SET @saved_cs_client = @@character_set_client */;
  21. /*!40101 SET character_set_client = utf8 */;
  22. CREATE TABLE `sys_menu` (
  23. `id` int(11) NOT NULL AUTO_INCREMENT,
  24. `create_time` datetime(6) DEFAULT NULL,
  25. `update_time` datetime(6) DEFAULT NULL,
  26. `icon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  27. `pid` int(11) DEFAULT NULL,
  28. `pos` int(11) DEFAULT NULL,
  29. `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  30. `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  31. `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  32. `enabled` bit(1) DEFAULT NULL,
  33. `deleted` bit(1) NOT NULL,
  34. PRIMARY KEY (`id`)
  35. ) ENGINE=InnoDB AUTO_INCREMENT=13421 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  36. /*!40101 SET character_set_client = @saved_cs_client */;
  37. --
  38. -- Dumping data for table `sys_menu`
  39. --
  40. LOCK TABLES `sys_menu` WRITE;
  41. /*!40000 ALTER TABLE `sys_menu` DISABLE KEYS */;
  42. 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');
  43. /*!40000 ALTER TABLE `sys_menu` ENABLE KEYS */;
  44. UNLOCK TABLES;
  45. /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  46. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  47. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  48. /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  49. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  50. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  51. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  52. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  53. -- Dump completed on 2024-12-15 22:47:22