-- MySQL dump 10.13 Distrib 8.0.26, for Win64 (x86_64) -- -- Host: 121.48.165.167 Database: portal -- ------------------------------------------------------ -- Server version 5.7.33-0ubuntu0.16.04.1 /*!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 */; /*!50503 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 `tb_module` -- DROP TABLE IF EXISTS `tb_module`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `tb_module` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID', `name` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '模块名称', `path` varchar(256) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '路由地址', `route_name` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '路由名称', `component` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '组件ID', `parent_id` bigint(20) NOT NULL COMMENT '父模块ID', `priority` int(11) NOT NULL DEFAULT '1' COMMENT '优先级', `hidden` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否隐藏', `is_external` tinyint(4) NOT NULL DEFAULT '0', `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `id_UNIQUE` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tb_module` -- LOCK TABLES `tb_module` WRITE; /*!40000 ALTER TABLE `tb_module` DISABLE KEYS */; INSERT INTO `tb_module` VALUES (1,'新闻中心','','','',0,1,0,0,1,'2021-04-29 20:14:04','2021-09-24 09:07:06'),(2,'中心概况','','','',0,2,0,0,1,'2021-04-29 20:14:04','2021-08-22 11:19:06'),(3,'科学研究','','','',0,3,0,0,1,'2021-04-29 20:14:04','2021-09-24 10:57:18'),(4,'人才培养','','','',0,4,0,0,1,'2021-04-29 20:14:04','2021-09-23 23:34:21'),(5,'校友动态','/fellow','Fellow','/image-list',0,5,0,0,0,'2021-04-29 20:14:04','2021-12-13 19:01:19'),(6,'合作交流','','','',0,6,0,0,1,'2021-04-29 20:14:04','2021-09-23 23:33:59'),(7,'公共服务','','','',0,7,0,0,1,'2021-04-29 20:14:04','2021-09-23 18:02:47'),(8,'搜索','/search','Search','/search',0,8,1,0,1,'2021-04-29 20:14:04','2021-09-09 11:44:25'),(9,'综合新闻','/news/general','General','/image-list',1,1,0,0,1,'2021-04-29 20:14:04','2021-08-22 11:19:06'),(10,'通知公告','/news/notice','Notice','/image-list',1,2,0,0,1,'2021-04-29 20:14:04','2021-09-24 08:42:33'),(11,'学生工作','/news/student','Student','/image-list',1,3,0,0,1,'2021-05-31 11:10:38','2021-08-22 11:19:06'),(12,'中心简介','/overview/up','Up','/overview',2,1,0,0,1,'2021-04-29 20:14:04','2021-09-24 10:58:02'),(14,'教师团队','/overview/teachers','Teachers','/teacher-list',2,2,0,0,1,'2021-04-29 20:14:04','2021-09-24 08:42:33'),(15,'科研团队','/research/team','Team','/card-view',3,1,0,0,1,'2021-04-29 20:14:04','2021-09-24 16:34:15'),(16,'科研成果','/research/harvest','Harvest','/card-view',3,2,0,0,1,'2021-04-29 20:14:04','2021-09-24 16:34:16'),(17,'成果分享','/research/share','Share','/share',3,3,0,0,1,'2021-04-29 20:14:04','2021-09-24 11:16:32'),(18,'研究生培养','/education/postgraduate','Postgraduate','/postgraduate-list',4,1,0,0,1,'2021-04-29 20:14:04','2021-10-09 18:00:04'),(19,'本科生培养','/education/graduate','Graduate','/graduate-list',4,2,0,0,1,'2021-04-29 20:14:04','2021-10-09 18:00:04'),(20,'企业合作','/cooperation/company','Company','/image-list',6,1,0,0,1,'2021-04-29 20:14:04','2021-10-09 16:50:22'),(21,'国际交流','/cooperation/exchange','International','/image-list',6,2,0,0,1,'2021-04-29 20:14:04','2021-08-22 11:19:06'),(22,'网上服务大厅','https://eportal.uestc.edu.cn/new/index.html','','',7,1,0,1,1,'2021-05-20 11:45:12','2021-08-23 07:54:30'),(23,'后勤服务平台','https://hq.uestc.edu.cn/web/','','',7,2,0,1,1,'2021-05-20 12:33:38','2021-08-23 07:54:30'),(24,'财务平台','https://www.jcc.uestc.edu.cn/index.html','','',7,3,0,1,1,'2021-05-20 12:33:38','2021-08-23 07:54:30'),(25,'招标采购','https://cg.uestc.edu.cn/f/list-a607f12009cf4e969c23c2c181b4d306.html','','',7,4,0,1,1,'2021-05-20 12:33:38','2021-08-23 07:54:30'),(26,'网络服务','https://www.info.uestc.edu.cn/','','',7,5,0,1,1,'2021-05-20 12:33:38','2021-08-23 07:54:30'),(27,'学校医院','https://www.hospital.uestc.edu.cn/','','',7,6,0,1,1,'2021-05-20 12:33:38','2021-08-23 07:54:30'),(28,'校园地图','https://gis.uestc.edu.cn/#/','','',7,7,0,1,1,'2021-05-20 12:33:38','2021-08-23 07:54:30'),(29,'VI系统','https://vi.uestc.edu.cn/','','',7,8,0,1,1,'2021-05-20 12:33:38','2021-08-23 07:54:30'),(30,'学校图书馆','https://www.lib.uestc.edu.cn/','',NULL,7,9,0,1,1,'2021-10-09 17:45:56','2021-10-09 17:45:56'),(31,'组织架构','/overview/organization','Organization','/organization',2,3,0,0,1,'2021-10-09 17:48:38','2021-10-12 13:16:54'),(34,'组织','/overview/organ',NULL,NULL,2,4,0,0,0,'2021-10-12 13:16:15','2021-10-12 20:15:10'); /*!40000 ALTER TABLE `tb_module` 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 2021-12-13 19:20:01