-- 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 `sys_menu`
--

DROP TABLE IF EXISTS `sys_menu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sys_menu` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `pid` bigint(20) DEFAULT NULL COMMENT '上级ID，一级菜单为0',
  `url` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '菜单URL',
  `type` tinyint(3) unsigned DEFAULT NULL COMMENT '类型   0：菜单   1：按钮',
  `icon` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '菜单图标',
  `permissions` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '权限标识，如：sys:menu:save',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  `del_flag` tinyint(3) unsigned DEFAULT NULL COMMENT '删除标识  0：未删除    1：删除',
  `creator` bigint(20) DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `updater` bigint(20) DEFAULT NULL COMMENT '更新者',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_pid` (`pid`),
  KEY `idx_del_flag` (`del_flag`),
  KEY `idx_create_date` (`create_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='菜单管理';
/*!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 (1067246875800000002,0,'',0,'icon-lock','',0,0,1067246875800000001,'2021-04-08 17:22:02',1067246875800000001,'2021-04-08 17:22:02'),(1067246875800000003,1067246875800000002,'sys/user',0,'icon-user','',0,0,1067246875800000001,'2021-04-08 17:22:02',1067246875800000001,'2021-04-08 17:22:02'),(1067246875800000004,1067246875800000003,'',1,'','sys:user:page,sys:user:info',0,0,1067246875800000001,'2021-04-08 17:22:02',1067246875800000001,'2021-04-08 17:22:02'),(1067246875800000005,1067246875800000003,'',1,'','sys:user:save,sys:dept:list,sys:role:list',1,0,1067246875800000001,'2021-04-08 17:22:02',1067246875800000001,'2021-04-08 17:22:02'),(1067246875800000006,1067246875800000003,'',1,'','sys:user:update,sys:dept:list,sys:role:list',2,0,1067246875800000001,'2021-04-08 17:22:02',1067246875800000001,'2021-04-08 17:22:02'),(1067246875800000007,1067246875800000003,'',1,'','sys:user:delete',3,0,1067246875800000001,'2021-04-08 17:22:02',1067246875800000001,'2021-04-08 17:22:02'),(1067246875800000008,1067246875800000003,'',1,'','sys:user:export',4,0,1067246875800000001,'2021-04-08 17:22:02',1067246875800000001,'2021-04-08 17:22:02'),(1067246875800000009,1067246875800000002,'sys/dept',0,'icon-apartment','',1,0,1067246875800000001,'2021-04-08 17:22:02',1067246875800000001,'2021-04-08 17:22:02'),(1067246875800000010,1067246875800000009,'',1,'','sys:dept:list,sys:dept:info',0,0,1067246875800000001,'2021-04-08 17:22:02',1067246875800000001,'2021-04-08 17:22:02'),(1067246875800000011,1067246875800000009,'',1,'','sys:dept:save',1,0,1067246875800000001,'2021-04-08 17:22:02',1067246875800000001,'2021-04-08 17:22:02'),(1067246875800000012,1067246875800000009,'',1,'','sys:dept:update',2,0,1067246875800000001,'2021-04-08 17:22:02',1067246875800000001,'2021-04-08 17:22:02'),(1067246875800000013,1067246875800000009,'',1,'','sys:dept:delete',3,0,1067246875800000001,'2021-04-08 17:22:02',1067246875800000001,'2021-04-08 17:22:02'),(1067246875800000014,1067246875800000002,'sys/role',0,'icon-team','',2,0,1067246875800000001,'2021-04-08 17:22:02',1067246875800000001,'2021-04-08 17:22:02'),(1067246875800000015,1067246875800000014,'',1,'','sys:role:page,sys:role:info',0,0,1067246875800000001,'2021-04-08 17:22:02',1067246875800000001,'2021-04-08 17:22:02'),(1067246875800000016,1067246875800000014,'',1,'','sys:role:save,sys:menu:select,sys:dept:list',1,0,1067246875800000001,'2021-04-08 17:22:02',1067246875800000001,'2021-04-08 17:22:02'),(1067246875800000017,1067246875800000014,'',1,'','sys:role:update,sys:menu:select,sys:dept:list',2,0,1067246875800000001,'2021-04-08 17:22:02',1067246875800000001,'2021-04-08 17:22:02'),(1067246875800000018,1067246875800000014,'',1,'','sys:role:delete',3,0,1067246875800000001,'2021-04-08 17:22:02',1067246875800000001,'2021-04-08 17:22:02'),(1067246875800000019,0,'',0,'icon-setting',NULL,1,0,1067246875800000001,'2021-04-08 17:22:02',1067246875800000001,'2021-04-08 17:22:02'),(1067246875800000020,1067246875800000019,'sys/menu',0,'icon-unorderedlist',NULL,0,0,1067246875800000001,'2021-04-08 17:22:02',1067246875800000001,'2021-04-08 17:22:02'),(1067246875800000021,1067246875800000020,NULL,1,NULL,'sys:menu:list,sys:menu:info',0,0,1067246875800000001,'2021-04-08 17:22:02',1067246875800000001,'2021-04-08 17:22:02'),(1067246875800000022,1067246875800000020,NULL,1,NULL,'sys:menu:save',1,0,1067246875800000001,'2021-04-08 17:22:02',1067246875800000001,'2021-04-08 17:22:02'),(1067246875800000023,1067246875800000020,NULL,1,NULL,'sys:menu:update',2,0,1067246875800000001,'2021-04-08 17:22:02',1067246875800000001,'2021-04-08 17:22:02'),(1067246875800000024,1067246875800000020,NULL,1,NULL,'sys:menu:delete',3,0,1067246875800000001,'2021-04-08 17:22:02',1067246875800000001,'2021-04-08 17:22:02'),(1067246875800000025,1067246875800000019,'sys/params',0,'icon-fileprotect','',1,0,1067246875800000001,'2021-04-08 17:22:02',1067246875800000001,'2021-04-08 17:22:02'),(1067246875800000026,1067246875800000025,NULL,1,NULL,'sys:params:page,sys:params:info',0,0,1067246875800000001,'2021-04-08 17:22:02',1067246875800000001,'2021-04-08 17:22:02'),(1067246875800000027,1067246875800000025,NULL,1,NULL,'sys:params:save',1,0,1067246875800000001,'2021-04-08 17:22:02',1067246875800000001,'2021-04-08 17:22:02'),(1067246875800000028,1067246875800000025,NULL,1,NULL,'sys:params:update',2,0,1067246875800000001,'2021-04-08 17:22:02',1067246875800000001,'2021-04-08 17:22:02'),(1067246875800000029,1067246875800000025,NULL,1,NULL,'sys:params:delete',3,0,1067246875800000001,'2021-04-08 17:22:02',1067246875800000001,'2021-04-08 17:22:02'),(1067246875800000030,1067246875800000025,'',1,NULL,'sys:params:export',4,0,1067246875800000001,'2021-04-08 17:22:02',1067246875800000001,'2021-04-08 17:22:02'),(1067246875800000031,1067246875800000019,'sys/dict-type',0,'icon-gold','',2,0,1067246875800000001,'2021-04-08 17:22:02',1067246875800000001,'2021-04-08 17:22:02'),(1067246875800000032,1067246875800000031,'',1,'','sys:dict:page,sys:dict:info',0,0,1067246875800000001,'2021-04-08 17:22:02',1067246875800000001,'2021-04-08 17:22:02'),(1067246875800000033,1067246875800000031,'',1,'','sys:dict:save',1,0,1067246875800000001,'2021-04-08 17:22:02',1067246875800000001,'2021-04-08 17:22:02'),(1067246875800000034,1067246875800000031,'',1,'','sys:dict:update',2,0,1067246875800000001,'2021-04-08 17:22:02',1067246875800000001,'2021-04-08 17:22:02'),(1067246875800000035,1067246875800000031,'',1,'','sys:dict:delete',3,0,1067246875800000001,'2021-04-08 17:22:02',1067246875800000001,'2021-04-08 17:22:02'),(1067246875800000036,0,'',0,'icon-container','',4,0,1067246875800000001,'2021-04-08 17:22:02',1067246875800000001,'2021-04-08 17:22:02'),(1067246875800000037,1067246875800000036,'sys/log-login',0,'icon-filedone','sys:log:login',0,0,1067246875800000001,'2021-04-08 17:22:02',1067246875800000001,'2021-04-08 17:22:02'),(1067246875800000038,1067246875800000036,'sys/log-operation',0,'icon-solution','sys:log:operation',1,0,1067246875800000001,'2021-04-08 17:22:02',1067246875800000001,'2021-04-08 17:22:02'),(1067246875800000039,1067246875800000036,'sys/log-error',0,'icon-file-exception','sys:log:error',2,0,1067246875800000001,'2021-04-08 17:22:02',1067246875800000001,'2021-04-08 17:22:02'),(1067246875800000040,0,'',0,'icon-desktop','',5,0,1067246875800000001,'2021-04-08 17:22:02',1067246875800000001,'2021-04-08 17:22:02'),(1067246875800000041,1067246875800000040,'{{ window.SITE_CONFIG[\"apiURL\"] }}/monitor',0,'icon-medicinebox','',0,0,1067246875800000001,'2021-04-08 17:22:02',1067246875800000001,'2021-04-08 17:22:02'),(1067246875800000042,1067246875800000040,'{{ window.SITE_CONFIG[\"apiURL\"] }}/doc.html',0,'icon-file-word','',1,0,1067246875800000001,'2021-04-08 17:22:02',1067246875800000001,'2021-04-08 17:22:02'),(1067246875800000401,0,'',0,'icon-bell','',4,0,1067246875800000001,'2021-04-08 17:22:02',1067246875800000001,'2021-04-08 17:22:02'),(1067246875800000402,1067246875800000401,'sys/notice',0,'icon-bell','sys:notice:all,sys:dept:list',0,0,1067246875800000001,'2021-04-08 17:22:02',1067246875800000001,'2021-04-08 17:22:02'),(1067246875800000403,1067246875800000401,'sys/notice-user',0,'icon-notification','sys:notice:all',1,0,1067246875800000001,'2021-04-08 17:22:02',1067246875800000001,'2021-04-08 17:22:02'),(1164489061834969089,1067246875800000019,'sys/region',0,'icon-location','0',3,0,1067246875800000001,'2021-04-08 17:22:02',1067246875800000001,'2021-04-08 17:22:02'),(1164492214366130178,1164489061834969089,'',1,'','sys:region:list,sys:region:info',0,0,1067246875800000001,'2021-04-08 17:22:02',1067246875800000001,'2021-04-08 17:22:02'),(1164492872829915138,1164489061834969089,'',1,'','sys:region:save',1,0,1067246875800000001,'2021-04-08 17:22:02',1067246875800000001,'2021-04-08 17:22:02'),(1164493252347318273,1164489061834969089,'',1,'','sys:region:update',2,0,1067246875800000001,'2021-04-08 17:22:02',1067246875800000001,'2021-04-08 17:22:02'),(1164493391254278145,1164489061834969089,'',1,'','sys:region:delete',3,0,1067246875800000001,'2021-04-08 17:22:02',1067246875800000001,'2021-04-08 17:22:02'),(1176372255559024642,0,'',0,'icon-windows','',999,0,1067246875800000001,'2021-04-08 17:22:02',1067246875800000001,'2021-04-08 17:22:02'),(1206460008292216834,1176372255559024642,'sys/news',0,'icon-file-word','demo:news:all',0,0,1067246875800000001,'2021-04-08 17:22:02',1067246875800000001,'2021-04-08 17:22:02'),(1380426397641768962,0,'',0,'icon-deploymentunit','',6,0,1067246875800000001,'2021-04-09 15:44:35',1067246875800000001,'2021-04-09 15:49:53'),(1380430366128635905,1380426397641768962,'',0,'','',1,1,1067246875800000001,'2021-04-09 16:00:21',1067246875800000001,'2021-04-09 16:09:53'),(1380430500447027202,1380426397641768962,'portal/teacher',0,'icon-team','',2,0,1067246875800000001,'2021-04-09 16:00:53',1067246875800000001,'2021-04-27 19:29:39'),(1380430703229042689,1380426397641768962,'',0,'icon-file-text','',4,0,1067246875800000001,'2021-04-09 16:01:41',1067246875800000001,'2021-04-09 16:17:42'),(1380430919856455682,1380426397641768962,'',1,'','',3,1,1067246875800000001,'2021-04-09 16:02:33',1067246875800000001,'2021-04-09 16:10:35'),(1380431496954937345,1380426397641768962,'',0,'','',5,1,1067246875800000001,'2021-04-09 16:04:51',1067246875800000001,'2021-04-09 16:05:16'),(1380431665519820802,1380426397641768962,'',1,'','',5,1,1067246875800000001,'2021-04-09 16:05:31',1067246875800000001,'2021-04-09 16:10:38'),(1380432914810044417,1380426397641768962,'portal/module',0,'icon-project','',1,0,1067246875800000001,'2021-04-09 16:10:29',1067246875800000001,'2021-04-09 16:21:43'),(1380433015485923330,1380426397641768962,'portal/level',0,'icon-contacts','',3,1,1067246875800000001,'2021-04-09 16:10:53',1067246875800000001,'2021-07-16 09:01:02'),(1380433080355028993,1380426397641768962,'portal/file',0,'icon-folder','',5,1,1067246875800000001,'2021-04-09 16:11:08',1067246875800000001,'2021-05-23 15:47:03'),(1380436997210013697,1380430703229042689,'',0,'icon-table','',1,1,1067246875800000001,'2021-04-09 16:26:42',1067246875800000001,'2021-04-09 16:27:13'),(1380437343110070273,1380430703229042689,'portal/article-issue',0,'icon-link','',0,0,1067246875800000001,'2021-04-09 16:28:05',1067246875800000001,'2021-04-19 16:45:03'),(1381518250097565698,1380426397641768962,'',0,'icon-layout','',0,0,1067246875800000001,'2021-04-12 16:03:13',1067246875800000001,'2021-05-23 14:19:53'),(1381518762653663234,1381518250097565698,'portal/index',0,'icon-database','',0,1,1067246875800000001,'2021-04-12 16:05:15',1067246875800000001,'2021-05-23 15:47:37'),(1381518945206984706,1381518250097565698,'portal/home',0,'icon-file-text','',1,1,1067246875800000001,'2021-04-12 16:05:59',1067246875800000001,'2021-05-23 15:47:41'),(1381593089973506049,1380430500447027202,'portal/teacherlist',0,'icon-appstore','',0,1,1067246875800000001,'2021-04-12 21:00:36',1067246875800000001,'2021-04-19 16:13:49'),(1381616569217462273,1380430500447027202,'portal/teacher-add',0,'icon-check-circle','',1,1,1067246875800000001,'2021-04-12 22:33:54',1067246875800000001,'2021-04-19 16:12:51'),(1382175878734614530,1380430703229042689,'portal/article-draft',0,'icon-file-text','',2,0,1067246875800000001,'2021-04-14 11:36:24',1067246875800000001,'2021-04-14 13:18:04'),(1382227439720534018,1380430703229042689,'portal/article-write',0,'icon-edit','',1,0,1067246875800000001,'2021-04-14 15:01:17',1067246875800000001,'2021-04-19 16:45:09'),(1382229191110889474,1380430703229042689,'portal/article-audit',0,'icon-filedone','',3,0,1067246875800000001,'2021-04-14 15:08:14',1067246875800000001,'2021-04-14 15:10:00'),(1382230630713462786,1380430703229042689,'portal/article-recycle',0,'icon-delete','',4,0,1067246875800000001,'2021-04-14 15:13:58',1067246875800000001,'2021-04-14 15:13:58'),(1382594402173595649,1380430500447027202,'portal/teacher-update',0,'icon-check-circle','',2,1,1067246875800000001,'2021-04-15 15:19:27',1067246875800000001,'2021-04-15 21:25:55'),(1382619965605543937,1380426397641768962,'portal/file',0,'icon-folder','',5,0,1067246875800000001,'2021-04-15 17:01:02',1067246875800000001,'2021-05-24 10:34:37'),(1396350627474485250,1381518250097565698,'portal/carousel',0,'icon-play-square','',0,0,1067246875800000001,'2021-05-23 14:21:47',1067246875800000001,'2021-05-23 14:23:56'),(1396753390646571010,1381518250097565698,'portal/card',0,'icon-image','',1,1,1067246875800000001,'2021-05-24 17:02:13',1067246875800000001,'2021-05-24 17:02:59'),(1396753894705442817,1381518250097565698,'portal/app-footer',0,'icon-tag-fill','',2,0,1067246875800000001,'2021-05-24 17:04:14',1067246875800000001,'2021-07-15 23:03:43'),(1399258494473728001,1381518250097565698,'portal/cooperation',0,'icon-export','',1,0,1067246875800000001,'2021-05-31 14:56:37',1067246875800000001,'2021-07-15 23:03:28'),(1404630549268496386,1381518250097565698,'portal/components',0,'icon-sever-fill','',3,0,1067246875800000001,'2021-06-15 10:43:14',1067246875800000001,'2021-07-15 23:03:56'),(1441321612967202817,1380426397641768962,'portal/student',0,'icon-zhihu','',3,0,1067246875800000001,'2021-09-24 16:40:26',1067246875800000001,'2021-09-24 16:40:26');
/*!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 2021-12-13 19:20:11