-- MySQL dump 10.14 Distrib 5.5.60-MariaDB, for Linux (x86_64) -- -- Host: localhost Database: qicheoa -- ------------------------------------------------------ -- Server version 5.5.60-MariaDB /*!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 `sub_menu` -- DROP TABLE IF EXISTS `sub_menu`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sub_menu` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `NAME` varchar(45) NOT NULL, `NO` int(11) NOT NULL, `MENU_ID` int(11) NOT NULL, `PERMISSION` int(11) DEFAULT NULL, `URL` varchar(128) NOT NULL DEFAULT '', `ICON` varchar(128) DEFAULT NULL, `ICON2` varchar(128) DEFAULT NULL COMMENT '未选中', `TYPE` int(11) NOT NULL DEFAULT '0' COMMENT '1: PC 2: ANDROID 4: IOS', `ORDER_WEIGHT` int(11) NOT NULL DEFAULT '0', `GMT_CREATED` datetime NOT NULL, `GMT_MODIFIED` datetime NOT NULL, `REMARK` varchar(1024) DEFAULT NULL, `IS_DELETED` int(11) NOT NULL DEFAULT '1', `CREATE_BY` int(11) NOT NULL, `UPDATE_BY` int(11) NOT NULL, PRIMARY KEY (`ID`), KEY `idx` (`MENU_ID`), KEY `menu` (`MENU_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=84 DEFAULT CHARSET=utf8 COMMENT='二级菜单'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `sub_menu` -- LOCK TABLES `sub_menu` WRITE; /*!40000 ALTER TABLE `sub_menu` DISABLE KEYS */; INSERT INTO `sub_menu` VALUES (2,'车辆',2001,3,16,'app.vehicle.list',NULL,NULL,1,100,'2020-06-15 14:22:59','2020-06-15 14:22:59',NULL,1,23,23),(3,'司机',2002,3,32,'app.driver.list',NULL,NULL,1,99,'2020-06-15 14:22:59','2020-06-15 14:22:59',NULL,1,23,23),(4,'用车人',2003,3,384,'app.contacts.list',NULL,NULL,1,98,'2020-06-15 14:22:59','2020-06-15 14:22:59',NULL,1,23,23),(5,'油卡',2007,3,16,'app.oilCard.list',NULL,NULL,1,97,'2020-06-15 14:22:59','2020-06-15 14:22:59',NULL,1,23,23),(6,'提醒',2004,3,8192,'app.remind.list',NULL,NULL,1,96,'2020-06-15 14:22:59','2020-06-15 14:22:59',NULL,1,23,23),(7,'权限分组',2005,3,1024,'app.group.list',NULL,NULL,1,95,'2020-06-15 14:22:59','2020-06-15 14:22:59',NULL,1,23,23),(8,'账号',2006,3,1024,'app.manager.list',NULL,NULL,1,94,'2020-06-15 14:22:59','2020-06-15 14:22:59',NULL,1,23,23),(9,'邀请码',2008,3,65535,'app.referral.list',NULL,NULL,1,93,'2020-06-15 14:22:59','2020-06-15 14:22:59',NULL,1,23,23),(10,'排班调度',3001,4,1,'app.scheduling.list',NULL,NULL,1,100,'2020-06-15 14:22:59','2020-06-15 14:22:59',NULL,1,23,23),(11,'用车审批',3002,4,4096,'app.approval.list({type:1})',NULL,NULL,1,99,'2020-06-15 14:22:59','2020-06-15 14:22:59',NULL,1,23,23),(12,'班车管理',3003,4,2,'app.regular.list',NULL,NULL,1,98,'2020-06-15 14:22:59','2020-06-15 14:22:59',NULL,1,23,23),(13,'自定义字段',3004,4,1,'app.customize.list',NULL,NULL,1,97,'2020-06-15 14:23:00','2020-06-15 14:23:00',NULL,1,23,23),(14,'订单类型',3005,4,1,'app.ordertype.list',NULL,NULL,1,96,'2020-06-15 14:23:00','2020-06-15 14:23:00',NULL,1,23,23),(15,'城市列表',3010,4,1024,'app.city.list',NULL,NULL,1,95,'2020-06-15 14:23:00','2020-06-15 14:23:00',NULL,1,23,23),(16,'通知管理',3006,4,8192,'app.notice.list',NULL,NULL,1,94,'2020-06-15 14:23:00','2020-06-15 14:23:00',NULL,1,23,23),(17,'评价报表',3009,4,4,'app.scheduling.comment',NULL,NULL,1,93,'2020-06-15 14:23:00','2020-06-15 14:23:00',NULL,1,23,23),(18,'排班报表',3007,4,4,'app.report.scheduling',NULL,NULL,1,92,'2020-06-15 14:23:00','2020-06-15 14:23:00',NULL,1,23,23),(19,'班车报表',3008,4,2,'app.report.regular',NULL,NULL,1,91,'2020-06-15 14:23:00','2020-06-15 14:23:00',NULL,1,23,23),(20,'定位监控',4001,5,8,'app.monitor',NULL,NULL,1,100,'2020-06-15 14:23:00','2020-06-15 14:23:00',NULL,1,23,23),(21,'油耗监控',4008,5,8,'app.oilCost.list',NULL,NULL,1,99,'2020-06-15 14:23:00','2020-06-15 14:23:00',NULL,1,23,23),(22,'电子围栏',4002,5,8,'app.fence.list',NULL,NULL,1,98,'2020-06-15 14:23:00','2020-06-15 14:23:00',NULL,1,23,23),(23,'路径规划',4003,5,8,'app.pathFence.list',NULL,NULL,1,97,'2020-06-15 14:23:00','2020-06-15 14:23:00',NULL,1,23,23),(24,'趟数统计',4007,5,8,'app.route.list',NULL,NULL,1,96,'2020-06-15 14:23:00','2020-06-15 14:23:00',NULL,1,23,23),(25,'OBD报表',4005,5,5,'app.obd.list',NULL,NULL,1,95,'2020-06-15 14:23:01','2020-06-15 14:23:01',NULL,1,23,23),(26,'ADAS报表',4006,5,5,'app.adas',NULL,NULL,1,94,'2020-06-15 14:23:01','2020-06-15 14:23:01',NULL,1,23,23),(27,'行程报表',4004,5,4,'app.report.travel',NULL,NULL,1,93,'2020-06-15 14:23:01','2020-06-15 14:23:01',NULL,1,23,23),(28,'实时查询',6001,6,16,'app.violation.query',NULL,NULL,1,100,'2020-06-15 14:23:01','2020-06-15 14:23:01',NULL,1,23,23),(29,'批量查询',6002,6,16,'app.violation.config',NULL,NULL,1,99,'2020-06-15 14:23:01','2020-06-15 14:23:01',NULL,1,23,23),(30,'违章报表',6003,6,16,'app.violation.history','','',1,98,'2020-06-15 14:23:01','2020-06-17 15:58:02','',1,23,24),(31,'财务结算',5001,7,64,'app.expense.list',NULL,NULL,1,100,'2020-06-15 14:23:01','2020-06-15 14:23:01',NULL,1,23,23),(32,'费用类型',5002,7,64,'app.expense.type',NULL,NULL,1,99,'2020-06-15 14:23:01','2020-06-15 14:23:01',NULL,1,23,23),(33,'费用审批',5003,7,4096,'app.approval.list({type:2})',NULL,NULL,1,98,'2020-06-15 14:23:01','2020-06-15 14:23:01',NULL,1,23,23),(34,'财务报表',5004,7,4,'app.report.expense',NULL,NULL,1,97,'2020-06-15 14:23:01','2020-06-15 14:23:01',NULL,1,23,23),(35,'客户订单',5005,7,64,'app.sales.schOrderList',NULL,NULL,1,96,'2020-06-15 14:23:01','2020-06-15 14:23:01',NULL,1,23,23),(36,'请假审批',7001,8,4096,'app.approval.list({type:4})',NULL,NULL,1,100,'2020-06-15 14:23:01','2020-06-15 14:23:01',NULL,1,23,23),(37,'请假统计',7002,8,16384,'app.leave.list',NULL,NULL,1,99,'2020-06-15 14:23:02','2020-06-15 14:23:02',NULL,1,23,23),(38,'维保审批',7003,8,4096,'app.approval.list({type:8})',NULL,NULL,1,98,'2020-06-15 14:23:02','2020-06-15 14:23:02',NULL,1,23,23),(39,'维保统计',7004,8,16384,'app.maintenance.list',NULL,NULL,1,97,'2020-06-15 14:23:02','2020-06-15 14:23:02',NULL,1,23,23),(40,'短信模板列表',8001,9,32768,'app.broadcast.list',NULL,NULL,1,100,'2020-06-15 14:23:02','2020-06-15 14:23:02',NULL,1,23,23),(41,'群发短信列表',8002,9,32768,'app.broadcast.taskList',NULL,NULL,1,99,'2020-06-15 14:23:02','2020-06-15 14:23:02',NULL,1,23,23),(42,'群发消息',8003,9,32768,'app.broadcast.messageList',NULL,NULL,1,98,'2020-06-15 14:23:02','2020-06-15 14:23:02',NULL,1,23,23),(43,'商品列表',9001,10,65535,'app.sales.list',NULL,NULL,1,100,'2020-06-15 14:23:02','2020-06-15 14:23:02',NULL,1,23,23),(44,'GPS续费',9002,10,65535,'app.sales.gpsList',NULL,NULL,1,99,'2020-06-15 14:23:02','2020-06-15 14:23:02',NULL,1,23,23),(45,'我的订单',9003,10,65535,'app.sales.orderList',NULL,NULL,1,98,'2020-06-15 14:23:02','2020-06-15 14:23:02',NULL,1,23,23),(46,'账单列表',9004,10,65535,'app.billing.list',NULL,NULL,1,97,'2020-06-15 14:23:02','2020-06-15 14:23:02',NULL,1,23,23),(47,'我的发票',9005,10,65535,'app.invoice.invoiceData',NULL,NULL,1,96,'2020-06-15 14:23:02','2020-06-15 14:23:02',NULL,1,23,23),(48,'车辆管理',1001,3,0,'vehicle','https://oss.cheoa.cn/202006/19/10123434.png','',4,100,'2020-06-16 21:24:52','2020-06-19 10:12:37','',1,24,24),(49,'司机管理',1002,3,0,'driver','https://oss.cheoa.cn/202006/19/10124444.png','',4,99,'2020-06-16 21:25:33','2020-06-19 10:12:47','',1,24,24),(50,'用车人',1003,3,0,'contacts','https://oss.cheoa.cn/202006/19/10131212.png','',4,98,'2020-06-16 21:26:05','2020-06-19 10:13:15','',1,24,24),(51,'客户单位',1004,3,0,'customer','https://oss.cheoa.cn/202006/17/10573434.png','',4,97,'2020-06-16 21:26:40','2020-06-17 10:57:35','',1,24,24),(52,'提醒事项',1005,3,0,'remind','https://oss.cheoa.cn/202006/19/10132121.png','',4,96,'2020-06-16 21:27:11','2020-06-19 10:13:25','',1,24,24),(53,'违章查询',1006,3,0,'violation','https://oss.cheoa.cn/202006/19/10133131.png','',4,95,'2020-06-16 21:27:57','2020-06-19 10:13:34','',1,24,24),(54,'短信群发',1007,3,0,'broadcast','https://oss.cheoa.cn/202006/19/10133939.png','',4,94,'2020-06-16 21:28:32','2020-06-19 10:13:42','',1,24,24),(55,'优惠加油',1008,3,0,'tuanyou','https://oss.cheoa.cn/202006/19/10134949.png','',4,93,'2020-06-16 21:29:09','2020-06-19 10:13:52','',1,24,24),(56,'费用审批',11001,11,0,'approval/expense','https://oss.cheoa.cn/202006/19/10135858.png','',4,100,'2020-06-16 21:30:50','2020-06-19 10:14:01','',1,24,24),(57,'用车审批',11002,11,0,'approval/scheduling','https://oss.cheoa.cn/202006/19/10140707.png','',4,99,'2020-06-16 21:31:16','2020-06-19 10:14:10','',1,24,24),(58,'请假审批',11003,11,0,'approval/leave','https://oss.cheoa.cn/202006/19/10141616.png','',4,98,'2020-06-16 21:31:45','2020-06-19 10:14:18','',1,24,24),(59,'维保审批',11004,11,0,'approval/maintenance','https://oss.cheoa.cn/202006/19/10161919.png','',4,97,'2020-06-16 21:32:27','2020-06-19 10:16:20','',1,24,24),(60,'排班报表',12001,12,0,'report/scheduling','https://oss.cheoa.cn/202006/19/10143636.png','',4,100,'2020-06-16 21:33:14','2020-06-19 10:14:39','',1,24,24),(61,'财务报表',12002,12,0,'report/expense','https://oss.cheoa.cn/202006/19/10144545.png','',4,99,'2020-06-16 21:33:41','2020-06-19 10:14:48','',1,24,24),(62,'行程报表',12003,12,0,'report/travel','https://oss.cheoa.cn/202006/19/10145454.png','',4,98,'2020-06-16 21:34:30','2020-06-19 10:14:56','',1,24,24),(63,'违章报表',12004,12,0,'violation/list','https://oss.cheoa.cn/202006/19/10151212.png','',4,97,'2020-06-16 21:34:59','2020-06-19 10:15:15','',1,24,24),(64,'请假报表',12005,12,0,'report/leave','https://oss.cheoa.cn/202006/19/10152222.png','',4,96,'2020-06-16 21:35:32','2020-06-19 10:15:26','',1,24,24),(65,'维保报表',12006,12,0,'report/maintenance','https://oss.cheoa.cn/202006/19/10153939.png','',4,95,'2020-06-16 21:36:15','2020-06-19 10:15:42','',1,24,24),(66,'车辆管理',1001,3,0,'com.cheoa.admin.activity.VehicleActivity','https://oss.cheoa.cn/202006/19/10072020.png','',2,100,'2020-06-17 10:01:28','2020-06-19 10:07:25','',1,24,24),(67,'司机管理',1002,3,0,'com.cheoa.admin.activity.DriverActivity','https://oss.cheoa.cn/202006/19/10073333.png','',2,99,'2020-06-17 10:02:21','2020-06-19 10:07:38','',1,24,24),(68,'用车人',1003,3,0,'com.cheoa.admin.activity.CustomerActivity','https://oss.cheoa.cn/202006/19/10074646.png','',2,98,'2020-06-17 10:03:55','2020-06-19 10:07:51','',1,24,24),(69,'提醒事项',1004,3,0,'com.cheoa.admin.activity.RemindActivity','https://oss.cheoa.cn/202006/19/10080000.png','',2,97,'2020-06-17 10:05:16','2020-06-19 10:08:04','',1,24,24),(70,'短信群发',1006,3,0,'com.cheoa.admin.activity.BroadcastSmsActivity','https://oss.cheoa.cn/202006/19/10082828.png','',2,95,'2020-06-17 10:13:56','2020-06-19 10:08:35','',1,24,24),(71,'优惠加油',1007,3,0,'com.cheoa.admin.activity.ComeOnActivity','https://oss.cheoa.cn/202006/19/10084343.png','',2,94,'2020-06-17 10:15:12','2020-06-19 10:08:51','',1,24,24),(72,'违章查询',1005,3,0,'com.cheoa.admin.activity.ViolationHighActivity','https://oss.cheoa.cn/202006/19/10081414.png','',2,96,'2020-06-17 10:29:25','2020-06-19 10:08:18','',1,24,24),(73,'费用审批',11001,11,0,'com.cheoa.admin.activity.ApprovalActivity?cost','https://oss.cheoa.cn/202006/19/10085858.png','',2,100,'2020-06-17 13:57:09','2020-06-19 10:09:02','',1,24,24),(74,'用车审批',11002,11,0,'com.cheoa.admin.activity.ApprovalActivity?vehicle','https://oss.cheoa.cn/202006/19/10091313.png','',2,99,'2020-06-17 13:57:48','2020-06-19 10:09:17','',1,24,24),(75,'请假审批',11003,11,0,'com.cheoa.admin.activity.ApprovalActivity?leave','https://oss.cheoa.cn/202006/19/10092525.png','',2,98,'2020-06-17 13:58:43','2020-06-19 10:09:28','',1,24,24),(76,'维保审批',11004,11,0,'com.cheoa.admin.activity.ApprovalActivity?maintenance','https://oss.cheoa.cn/202006/19/10093636.png','',2,97,'2020-06-17 13:59:26','2020-06-19 10:09:39','',1,24,24),(77,'排班报表',12001,12,0,'com.cheoa.admin.activity.SchedulingReportActivity','https://oss.cheoa.cn/202006/19/10094747.png','',2,100,'2020-06-17 14:02:51','2020-06-19 10:09:52','',1,24,24),(78,'财务报表',12002,12,0,'com.cheoa.admin.activity.ExpenseReportActivity','https://oss.cheoa.cn/202006/19/10100303.png','',2,99,'2020-06-17 14:03:48','2020-06-19 10:10:09','',1,24,24),(79,'行程报表',12003,12,0,'com.cheoa.admin.activity.TravelReportActivity','https://oss.cheoa.cn/202006/19/10101818.png','',2,98,'2020-06-17 14:04:21','2020-06-19 10:10:22','',1,24,24),(80,'违章报表',12004,12,0,'com.cheoa.admin.activity.ViolationReportActivity','https://oss.cheoa.cn/202006/19/10103333.png','',2,97,'2020-06-17 14:05:00','2020-06-19 10:10:43','',1,24,24),(81,'请假报表',12005,12,0,'com.cheoa.admin.activity.LeaveReportActivity','https://oss.cheoa.cn/202006/19/10105353.png','',2,96,'2020-06-17 14:05:48','2020-06-19 10:10:59','',1,24,24),(82,'维保报表',12006,12,0,'com.cheoa.admin.activity.MaintenanceReportActivity','https://oss.cheoa.cn/202006/17/14062020.png','',2,95,'2020-06-17 14:06:21','2020-06-17 14:06:21','',1,24,24),(83,'温度监控',4009,5,8,'app.temperature.list','','',1,99,'2020-06-30 16:23:57','2020-06-30 16:27:34','',1,20,24); /*!40000 ALTER TABLE `sub_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 2020-07-06 10:57:46