rzzn
/
Portal
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
Portal/sql/portal_tb_module.sql

63 lines
6.0 KiB
MySQL
Raw Permalink Normal View History

code commit
2025-03-10 18:25:46 +08:00
-- 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