/*
SQLyog Ultimate v13.1.1 (64 bit)
MySQL - 8.0.11 : Database - ckzy_mes
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!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 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`ckzy_mes` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */;

USE `ckzy_mes`;

/*Table structure for table `equipment_account` */

DROP TABLE IF EXISTS `equipment_account`;

CREATE TABLE `equipment_account` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `category_coding` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '类别编码',
  `asset_category` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '资产类别',
  `asset_number` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '资产编号',
  `asset_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '资产名称',
  `specification_model` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '规格型号',
  `quantity` int(11) DEFAULT NULL COMMENT '数量',
  `term` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '单位',
  `status` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '资产状态',
  `device_number` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '设备编号',
  `extended_properties` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '其他属性',
  `version` bigint(20) DEFAULT '1' COMMENT '版本',
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '逻辑删除(1:已删除，0:未删除)',
  `created_user` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '创建用户',
  `created_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_user` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '更新用户',
  `updated_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='设备台账表';

/*Data for the table `equipment_account` */

insert  into `equipment_account`(`id`,`category_coding`,`asset_category`,`asset_number`,`asset_name`,`specification_model`,`quantity`,`term`,`status`,`device_number`,`extended_properties`,`version`,`is_deleted`,`created_user`,`created_time`,`updated_user`,`updated_time`) values 
(2,'APT4869','JAVA','363200543','计算机应用','TTY-AASS',5,'个','静态','ad0302','{\"updatedTime\":\"2021-08-22T16:21:45\",\"specificationModel\":\"TTY-AASS\",\"quantity\":5,\"assetCategory\":\"JAVA\",\"updatedUser\":\"admin\",\"deviceNumber\":\"ad0302\",\"version\":2,\"extendedProperties\":\"{\\\"specificationModel\\\":\\\"TTY-AASS\\\",\\\"quantity\\\":5,\\\"assetCategory\\\":\\\"JAVA\\\",\\\"deviceNumber\\\":\\\"ad0302\\\",\\\"extendedProperties\\\":\\\"\\\",\\\"assetNumber\\\":\\\"363200543\\\",\\\"assetName\\\":\\\"计算机应用\\\",\\\"term\\\":\\\"个\\\",\\\"status\\\":\\\"静态\\\"}\",\"assetNumber\":\"363200543\",\"isDeleted\":0,\"assetName\":\"计算机应用\",\"createdTime\":\"2021-08-22T14:50:45\",\"term\":\"个\",\"id\":2,\"categoryCoding\":\"APT4869\",\"createdUser\":\"admin\",\"status\":\"静态\",\"manufacturer\":\"sea个\",\"purchasingManufacturer\":\"爱国\"}',4,0,'admin','2021-08-22 14:50:45','admin','2021-08-25 23:02:37'),
(3,'当时法国','数学系','SX1234','高级数学','SX8765',50,'本','正常','SX3345','{\"specificationModel\":\"SX8765\",\"quantity\":50,\"assetCategory\":\"数学系\",\"deviceNumber\":\"SX3345\",\"extendedProperties\":\"\",\"assetNumber\":\"SX1234\",\"assetName\":\"高级数学\",\"term\":\"本\",\"status\":\"正常\",\"id\":3,\"categoryCoding\":\"当时法国\",\"serviceMonthLimit\":\"是个负担\",\"enableTime\":\"2021-08-02T16:00:01.000Z\"}',1,0,'admin','2021-08-22 15:02:15','admin','2021-08-22 18:46:02'),
(4,'APT4869','好东西','zyorzhy0zhy0','小爱同学','dd',33,'个','大师','DFAF5488','{\"id\":0,\"categoryCoding\":\"APT4869\",\"assetCategory\":\"好东西\",\"assetNumber\":\"zyorzhy0zhy0\",\"assetName\":\"小爱同学\",\"specificationModel\":\"dd\",\"quantity\":\"33\",\"term\":\"个\",\"status\":\"大师\",\"deviceNumber\":\"DFAF5488\",\"extendedProperties\":\"\",\"assetOwnership\":\"123\",\"manufacturer\":\"发酒疯\",\"purchasingManufacturer\":\"范德萨\",\"storageLocation\":\"法师\",\"managementDepartment\":\" 安抚\",\"personLiable\":\"的萨芬\",\"userDepartment\":\"发顺丰\",\"user\":\"发发\",\"serviceMonthLimit\":\"33\",\"enableTime\":\"2021-08-22T10:29:47.000Z\",\"unitPrice\":\"36554\",\"remarks\":\" 发放\",\"model\":\"5421\",\"contractNo\":\"487451\"}',1,0,'admin','2021-08-22 18:30:57','admin','2021-08-22 18:30:57'),
(5,'APT4869','好东西','zyorzhy0zhy0','小爱同学','dd',33,'个','大师','DFAF5488','{\"id\":0,\"categoryCoding\":\"APT4869\",\"assetCategory\":\"好东西\",\"assetNumber\":\"zyorzhy0zhy0\",\"assetName\":\"小爱同学\",\"specificationModel\":\"dd\",\"quantity\":\"33\",\"term\":\"个\",\"status\":\"大师\",\"deviceNumber\":\"DFAF5488\",\"extendedProperties\":\"\",\"assetOwnership\":\"123\",\"manufacturer\":\"发酒疯\",\"purchasingManufacturer\":\"范德萨\",\"storageLocation\":\"法师\",\"managementDepartment\":\" 安抚\",\"personLiable\":\"的萨芬\",\"userDepartment\":\"发顺丰\",\"user\":\"发大水了\",\"serviceMonthLimit\":\"33\",\"enableTime\":\"2021-08-22T10:29:47.000Z\",\"unitPrice\":\"36554\",\"remarks\":\" 发放\",\"model\":\"5421\",\"contractNo\":\"487451\"}',1,0,'admin','2021-08-22 18:34:19','admin','2021-08-22 18:44:25'),
(6,'APT4869','旮都是','zyorzhy0zhy0','小爱同学','dd',33,'个','大师','DFAF5488','{\"specificationModel\":\"dd\",\"quantity\":33,\"assetCategory\":\"旮都是\",\"deviceNumber\":\"DFAF5488\",\"extendedProperties\":\"{\\\"id\\\":6,\\\"categoryCoding\\\":\\\"APT4869\\\",\\\"assetCategory\\\":\\\"给个机会\\\",\\\"assetNumber\\\":\\\"zyorzhy0zhy0\\\",\\\"assetName\\\":\\\"小爱同学\\\",\\\"specificationModel\\\":\\\"dd\\\",\\\"quantity\\\":\\\"33\\\",\\\"term\\\":\\\"个\\\",\\\"status\\\":\\\"大师\\\",\\\"deviceNumber\\\":\\\"DFAF5488\\\",\\\"extendedProperties\\\":\\\"\\\",\\\"assetOwnership\\\":\\\"123\\\",\\\"manufacturer\\\":\\\"发酒疯\\\",\\\"purchasingManufacturer\\\":\\\"范德萨\\\",\\\"storageLocation\\\":\\\"法师\\\",\\\"managementDepartment\\\":\\\" 安抚\\\",\\\"personLiable\\\":\\\"的萨芬\\\",\\\"userDepartment\\\":\\\"发顺丰\\\",\\\"user\\\":\\\"沸腾鱼\\\",\\\"serviceMonthLimit\\\":\\\"33\\\",\\\"enableTime\\\":\\\"2021-08-22T10:29:47.000Z\\\",\\\"unitPrice\\\":\\\"36554\\\",\\\"remarks\\\":\\\" 发放\\\",\\\"model\\\":\\\"5421\\\",\\\"contractNo\\\":\\\"487451\\\"}\",\"assetNumber\":\"zyorzhy0zhy0\",\"assetName\":\"小爱同学\",\"term\":\"个\",\"id\":6,\"categoryCoding\":\"APT4869\",\"status\":\"大师\",\"assetOwnership\":\"第三方\",\"manufacturer\":\"阿凡达\",\"purchasingManufacturer\":\" 大师傅\",\"storageLocation\":\"供奉的是\",\"managementDepartment\":\"供奉的是\",\"personLiable\":\"给士大夫\",\"userDepartment\":\" 告诉对方\",\"user\":\" 根深蒂固\",\"serviceMonthLimit\":\"33\",\"enableTime\":\"2021-08-22T10:45:21.000Z\",\"unitPrice\":\"33\",\"remarks\":\"复旦皇冠\",\"model\":\"发多少个\",\"contractNo\":\"三个\"}',1,0,'admin','2021-08-22 18:37:53','admin','2021-08-22 18:48:35'),
(7,'放骨灰盒','阿斯顿发生','阿发是否','发顺丰','发发',33,'发','12','发发','{\"specificationModel\":\"发发\",\"quantity\":\"33\",\"assetCategory\":\"阿斯顿发生\",\"deviceNumber\":\"发发\",\"extendedProperties\":\"{\\\"id\\\":6,\\\"categoryCoding\\\":\\\"APT4869\\\",\\\"assetCategory\\\":\\\"给个机会\\\",\\\"assetNumber\\\":\\\"zyorzhy0zhy0\\\",\\\"assetName\\\":\\\"小爱同学\\\",\\\"specificationModel\\\":\\\"dd\\\",\\\"quantity\\\":\\\"33\\\",\\\"term\\\":\\\"个\\\",\\\"status\\\":\\\"大师\\\",\\\"deviceNumber\\\":\\\"DFAF5488\\\",\\\"extendedProperties\\\":\\\"\\\",\\\"assetOwnership\\\":\\\"123\\\",\\\"manufacturer\\\":\\\"发酒疯\\\",\\\"purchasingManufacturer\\\":\\\"范德萨\\\",\\\"storageLocation\\\":\\\"法师\\\",\\\"managementDepartment\\\":\\\" 安抚\\\",\\\"personLiable\\\":\\\"的萨芬\\\",\\\"userDepartment\\\":\\\"发顺丰\\\",\\\"user\\\":\\\"沸腾鱼\\\",\\\"serviceMonthLimit\\\":\\\"33\\\",\\\"enableTime\\\":\\\"2021-08-22T10:29:47.000Z\\\",\\\"unitPrice\\\":\\\"36554\\\",\\\"remarks\\\":\\\" 发放\\\",\\\"model\\\":\\\"5421\\\",\\\"contractNo\\\":\\\"487451\\\"}\",\"assetNumber\":\"阿发是否\",\"assetName\":\"发顺丰\",\"term\":\"发\",\"id\":7,\"categoryCoding\":\"放骨灰盒\",\"status\":\"12\",\"assetOwnership\":\"安抚啊\",\"manufacturer\":\" 发的地方\",\"purchasingManufacturer\":\" 暗室逢灯\",\"storageLocation\":\"发发\",\"managementDepartment\":\"发发\",\"personLiable\":\"发阿萨\",\"userDepartment\":\" 发顺丰\",\"user\":\" 安抚\",\"serviceMonthLimit\":\" 阿斯弗\",\"enableTime\":\"2021-08-22T10:51:37.000Z\",\"unitPrice\":\"33\",\"remarks\":\"萨芬\",\"model\":\"发发 \",\"contractNo\":\"阿斯弗\"}',1,0,'admin','2021-08-22 18:51:51','admin','2021-08-22 18:56:07'),
(8,'岁的法国 ','五七二','确认',' 请问','确认',33,' 去微软 ','去','发发','{\"id\":8,\"categoryCoding\":\"岁的法国 \",\"assetCategory\":\"五七二\",\"assetNumber\":\"确认\",\"assetName\":\" 请问\",\"specificationModel\":\"确认\",\"quantity\":\"33\",\"term\":\" 去微软 \",\"status\":\"去\",\"deviceNumber\":\"发发\",\"assetOwnership\":\"去微软\",\"manufacturer\":\" 去微软\",\"purchasingManufacturer\":\" 请问\",\"storageLocation\":\"确认去\",\"managementDepartment\":\"却仍然\",\"personLiable\":\"去\",\"userDepartment\":\"确认去\",\"user\":\"去热犬\",\"serviceMonthLimit\":\"去去\",\"enableTime\":\"2021-08-22T10:57:56.000Z\",\"unitPrice\":\"确认\",\"remarks\":\" 去\",\"model\":\" 去\",\"contractNo\":\"发士大夫\"}',2,0,'admin','2021-08-22 18:58:39','admin','2021-08-25 23:02:19'),
(9,'被重新发给','发多少个','确认','请问','确认',33,'是个负担给','去','公司的','{\"assetCategory\":\"发多少个\",\"assetName\":\"请问\",\"assetNumber\":\"确认\",\"assetOwnership\":\"公司的给\",\"categoryCoding\":\"被重新发给\",\"contractNo\":\"收购\",\"deviceNumber\":\"公司的\",\"enableTime\":\"2021-08-22T10:57:56.000Z\",\"id\":9,\"managementDepartment\":\"岁的法国\",\"manufacturer\":\"去微软\",\"model\":\"去\",\"personLiable\":\"去\",\"purchasingManufacturer\":\"请问\",\"quantity\":33,\"remarks\":\"去\",\"serviceMonthLimit\":\"去去\",\"specificationModel\":\"确认\",\"status\":\"去\",\"storageLocation\":\"确认去\",\"term\":\"是个负担给\",\"unitPrice\":\"545\",\"user\":\"去热犬\",\"userDepartment\":\"山豆根发射点\"}',2,0,'admin','2021-08-30 22:13:36','admin','2021-08-30 22:15:19');

/*Table structure for table `equipment_account_field` */

DROP TABLE IF EXISTS `equipment_account_field`;

CREATE TABLE `equipment_account_field` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `field_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '栏位名',
  `field_prop` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '栏位编码',
  `field_status` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '栏位状态',
  `select_status` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '0' COMMENT '栏位选中状态',
  `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '备注',
  `version` bigint(20) DEFAULT '1' COMMENT '版本',
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '逻辑删除(1:已删除，0:未删除)',
  `created_user` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '创建用户',
  `created_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_user` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '更新用户',
  `updated_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=103 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='设备台账栏位表';

/*Data for the table `equipment_account_field` */

insert  into `equipment_account_field`(`id`,`field_name`,`field_prop`,`field_status`,`select_status`,`remark`,`version`,`is_deleted`,`created_user`,`created_time`,`updated_user`,`updated_time`) values 
(1,'类别编码','categoryCoding','1','1','类别编码',4,0,'admin','2021-08-20 23:06:04','admin','2021-10-31 08:05:28'),
(2,'资产类别','assetCategory','1','1','资产类别',3,0,'admin','2021-08-20 23:27:45','admin','2021-10-31 08:05:28'),
(3,'资产归属','assetOwnership','1','0','资产归属',1,0,'admin','2021-08-20 23:28:53','admin','2021-10-31 08:05:28'),
(4,'资产编号','assetNumber','1','1','资产编号',1,0,'admin','2021-08-20 23:30:10','admin','2021-10-31 08:05:28'),
(5,'资产名称','assetName','1','1','资产名称',1,0,'admin','2021-08-20 23:30:42','admin','2021-10-31 08:05:28'),
(6,'规格型号','specificationModel','1','1','规格型号',1,0,'admin','2021-08-20 23:31:18','admin','2021-10-31 08:05:28'),
(7,'生产制造厂家','manufacturer','1','0','生产制造厂家',1,0,'admin','2021-08-20 23:32:04','admin','2021-10-31 08:05:28'),
(8,'采购厂家','purchasingManufacturer','1','0','采购厂家',1,0,'admin','2021-08-20 23:32:42','admin','2021-10-31 08:05:28'),
(9,'数量','quantity','1','1','数量',1,0,'admin','2021-08-20 23:34:13','admin','2021-10-31 08:05:28'),
(10,'计量单位','term','1','1','计量单位',1,0,'admin','2021-08-20 23:33:38','admin','2021-10-31 08:05:28'),
(11,'存放地点','storageLocation','1','0','存放地点',1,0,'admin','2021-08-20 23:34:58','admin','2021-10-31 08:05:28'),
(12,'归口管理部门','managementDepartment','1','0','归口管理部门',1,0,'admin','2021-08-20 23:36:06','admin','2021-10-31 08:05:28'),
(13,'管理部门责任人','personLiable','1','0','管理部门责任人',1,0,'admin','2021-08-20 23:36:56','admin','2021-10-31 08:05:28'),
(14,'使用部门','userDepartment','1','0','使用部门',1,0,'admin','2021-08-20 23:38:04','admin','2021-10-31 08:05:28'),
(15,'使用人','user','1','0','使用人',1,0,'admin','2021-08-20 23:38:30','admin','2021-10-31 08:05:28'),
(16,'使用月限','serviceMonthLimit','1','0','使用月限',1,0,'admin','2021-08-20 23:39:54','admin','2021-10-31 08:05:28'),
(17,'启用时间','enableTime','1','0','启用时间',1,0,'admin','2021-08-20 23:40:29','admin','2021-10-31 08:05:28'),
(18,'单价（元）','unitPrice','1','0','单价（元）',1,0,'admin','2021-08-20 23:41:25','admin','2021-10-31 08:05:28'),
(19,'资产状态','status','1','0','资产状态',1,0,'admin','2021-08-20 23:42:11','admin','2021-10-31 08:05:28'),
(20,'备注','remarks','1','0','备注',1,0,'admin','2021-08-20 23:42:43','admin','2021-10-31 08:05:28'),
(21,'车型','model','1','0','车型',1,0,'admin','2021-08-20 23:43:25','admin','2021-10-31 08:05:28'),
(22,'合同号','contractNo','1','0','合同号',1,0,'admin','2021-08-20 23:44:00','admin','2021-10-31 08:05:28'),
(23,'设备编号','deviceNumber','1','1','设备编号',1,0,'admin','2021-08-20 23:45:35','admin','2021-10-31 08:05:28'),
(24,'测试','Test','0','0','',1,0,'admin','2021-08-21 00:56:13','admin','2021-08-21 21:43:21'),
(102,'序号','id','1','1','主键',1,0,'admin','2021-08-22 16:07:24','admin','2021-10-31 08:05:28');

/*Table structure for table `equipment_check_base` */

DROP TABLE IF EXISTS `equipment_check_base`;

CREATE TABLE `equipment_check_base` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `device_id` varchar(11) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '设备编号',
  `device_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '设备名称',
  `no` int(255) DEFAULT NULL COMMENT '序号',
  `place` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '部位',
  `detail` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '点检内容',
  `method` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '点检方法',
  `check_base` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '基准',
  `exception_base` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '异常处理基准',
  `level` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '重要度',
  `conditions` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '点检条件',
  `types` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '类型区分',
  `cycle` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '周期',
  `cycle_unit` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '周期单位',
  `department` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '担当',
  `sub_document` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '子文件',
  `img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '图示',
  `version` int(255) DEFAULT NULL COMMENT '版本',
  `is_deleted` tinyint(1) DEFAULT NULL COMMENT '是否删除',
  `created_user` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建用户',
  `created_time` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_user` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '更新用户',
  `updated_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='点检计划表';

/*Data for the table `equipment_check_base` */

insert  into `equipment_check_base`(`id`,`device_id`,`device_name`,`no`,`place`,`detail`,`method`,`check_base`,`exception_base`,`level`,`conditions`,`types`,`cycle`,`cycle_unit`,`department`,`sub_document`,`img`,`version`,`is_deleted`,`created_user`,`created_time`,`updated_user`,`updated_time`) values 
(1,'9701A','弧焊机器人',1,'夹具','夹具限位块紧固有无松动，有无飞溅物，有无磨损','目视，手触','紧固无松动，无飞溅物，无磨损','松动，磨损通知保全 飞溅自己清扫','A','停止中','一般','1','D','车间','始业点检','xxx',NULL,0,'admin','2021-09-04 23:57:57',NULL,'2021-09-25 21:13:25'),
(2,'9701A','弧焊机器人',8,'焊枪','焊枪外表面有无破损，连结处是否松动','目视，手触','表面无破损，连结处无松动','通知保全','A','停止中','一般','1','D','保全','始业点检','xxx',NULL,0,'admin','2021-09-05 00:02:26',NULL,'2021-09-25 21:13:32'),
(3,'4','4',4,'4','4','4','4','4','4','4','4','4','D','4','4','4',NULL,-1,'admin','2021-09-05 00:08:25','admin','2021-09-05 00:08:25'),
(4,'4','4',4,'4','4','4','4','4','4','4','4','4','D','4','4','4',NULL,NULL,NULL,NULL,NULL,NULL),
(5,'5','5',5,'5','5','5','5','5','5','5','5','5','D','5','5','5',NULL,-1,NULL,'2021-09-05 00:24:03',NULL,'2021-09-05 00:24:03'),
(6,'aaa','aaa',11,'aaa','aaa','aaa','aaa','aaa','B','停止中','法定','1','W','保全','润滑管理','aaa',NULL,0,'admin','2021-10-31 08:24:45','admin','2021-10-31 08:24:45'),
(7,'aaa','aaa',123,'aa','aaaaa','aaaaa','aaaa','aaaaaaa','B','停止中','法定','1','D','车间','润滑管理','aaaaa',NULL,0,'admin','2021-10-31 09:29:05','admin','2021-10-31 09:29:05');

/*Table structure for table `equipment_check_info` */

DROP TABLE IF EXISTS `equipment_check_info`;

CREATE TABLE `equipment_check_info` (
  `id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `device_id` varchar(11) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '设备编号',
  `device_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '设备名称',
  `shop` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '车间',
  `file_id` varchar(11) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '文件管理号',
  `file_department` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '文件发行部门',
  `authorize_sign` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '发行：批准',
  `audit_sign` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '发行：审核',
  `make_sign` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '发行：作成',
  `workshop_sign` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '会签部门：车间',
  `maintain_sign` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '会签部门：保全',
  `process_sign` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '会签部门：工艺',
  `version` int(255) DEFAULT NULL COMMENT '版本',
  `is_deleted` tinyint(1) DEFAULT NULL COMMENT '是否删除',
  `created_user` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建用户',
  `created_time` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_user` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '更新用户',
  `updated_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='点检文件信息';

/*Data for the table `equipment_check_info` */

insert  into `equipment_check_info`(`id`,`device_id`,`device_name`,`shop`,`file_id`,`file_department`,`authorize_sign`,`audit_sign`,`make_sign`,`workshop_sign`,`maintain_sign`,`process_sign`,`version`,`is_deleted`,`created_user`,`created_time`,`updated_user`,`updated_time`) values 
(1,'9701A','弧焊机器人','焊接车间','GK-12GJ-1-1','保全室','A','B','C','AA','BB','CC',NULL,0,'admin',NULL,'admin',NULL);

/*Table structure for table `equipment_check_modify` */

DROP TABLE IF EXISTS `equipment_check_modify`;

CREATE TABLE `equipment_check_modify` (
  `id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `device_id` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '设备编号',
  `device_name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '设备名称',
  `place_modify` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '修订部位',
  `reviser_modify` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '修订人签字',
  `audit_modify` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '审核人签字',
  `date_modify` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '修订日期',
  `version` bigint(20) DEFAULT NULL COMMENT '版本',
  `is_deleted` tinyint(1) DEFAULT NULL COMMENT '是否删除',
  `created_user` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建用户',
  `created_time` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_user` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '更新用户',
  `updated_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='点检修改记录表';

/*Data for the table `equipment_check_modify` */

insert  into `equipment_check_modify`(`id`,`device_id`,`device_name`,`place_modify`,`reviser_modify`,`audit_modify`,`date_modify`,`version`,`is_deleted`,`created_user`,`created_time`,`updated_user`,`updated_time`) values 
(1,'1','1','1','1','1','2021-10-01',NULL,0,'admin','2021-10-31 08:33:19','admin','2021-10-31 08:33:19');

/*Table structure for table `equipment_check_result` */

DROP TABLE IF EXISTS `equipment_check_result`;

CREATE TABLE `equipment_check_result` (
  `id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `device_id` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '设备编号',
  `device_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '设备名称',
  `station` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '工位',
  `no` int(11) DEFAULT NULL COMMENT '序号',
  `place` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `detail` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `method` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `check_base` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `exception_base` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `level` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `conditions` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `types` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `cycle` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `cycle_unit` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `shift1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '班别1',
  `shift2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '班别2',
  `date` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '日期',
  `result1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '结果1',
  `result2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '结果2',
  `day_checker` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '点检者签名：白班',
  `night_checker` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '点检者签名：夜班',
  `day_maintenance` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '保全工签名：白班',
  `night_maintenance` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '保全工签名：夜班',
  `day_monitor` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '班长确认：白班',
  `night_monitor` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '班长确认：夜班',
  `version` bigint(20) DEFAULT NULL COMMENT '版本',
  `is_deleted` tinyint(1) DEFAULT NULL COMMENT '是否删除',
  `created_user` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建用户',
  `created_time` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_user` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '更新用户',
  `updated_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='点检结果表';

/*Data for the table `equipment_check_result` */

insert  into `equipment_check_result`(`id`,`device_id`,`device_name`,`station`,`no`,`place`,`detail`,`method`,`check_base`,`exception_base`,`level`,`conditions`,`types`,`cycle`,`cycle_unit`,`shift1`,`shift2`,`date`,`result1`,`result2`,`day_checker`,`night_checker`,`day_maintenance`,`night_maintenance`,`day_monitor`,`night_monitor`,`version`,`is_deleted`,`created_user`,`created_time`,`updated_user`,`updated_time`) values 
(48,'9701A','弧焊机器人',NULL,1,'夹具','夹具限位块紧固有无松动，有无飞溅物，有无磨损','目视，手触','紧固无松动，无飞溅物，无磨损','松动，磨损通知保全 飞溅自己清扫','A','停止中','一般','1','D',NULL,NULL,'2021-10-26','计划','计划','aaa','bbb','ccc','ddd','fff','ggg',NULL,0,'admin','2021-09-04 23:57:57','admin','2021-10-27 00:01:30'),
(49,'9701A','弧焊机器人',NULL,8,'焊枪','焊枪外表面有无破损，连结处是否松动','目视，手触','表面无破损，连结处无松动','通知保全','A','停止中','一般','1','D',NULL,NULL,'2021-10-26','异常修护','正常','sss','sss','sss','sss','sss','sss',NULL,0,'admin','2021-09-05 00:02:26','admin','2021-10-27 00:18:14'),
(50,'9701A','弧焊机器人',NULL,1,'夹具','夹具限位块紧固有无松动，有无飞溅物，有无磨损','目视，手触','紧固无松动，无飞溅物，无磨损','松动，磨损通知保全 飞溅自己清扫','A','停止中','一般','1','D',NULL,NULL,'2021-10-27',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'admin','2021-09-04 23:57:57','admin','2021-09-25 21:13:25'),
(51,'9701A','弧焊机器人',NULL,8,'焊枪','焊枪外表面有无破损，连结处是否松动','目视，手触','表面无破损，连结处无松动','通知保全','A','停止中','一般','1','D',NULL,NULL,'2021-10-27',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'admin','2021-09-05 00:02:26','admin','2021-09-25 21:13:32'),
(52,'9701A','弧焊机器人',NULL,1,'夹具','夹具限位块紧固有无松动，有无飞溅物，有无磨损','目视，手触','紧固无松动，无飞溅物，无磨损','松动，磨损通知保全 飞溅自己清扫','A','停止中','一般','1','D',NULL,NULL,'2021-10-31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'admin','2021-09-04 23:57:57','admin','2021-09-25 21:13:25'),
(53,'9701A','弧焊机器人',NULL,8,'焊枪','焊枪外表面有无破损，连结处是否松动','目视，手触','表面无破损，连结处无松动','通知保全','A','停止中','一般','1','D',NULL,NULL,'2021-10-31','异常修护','正常',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'admin','2021-09-05 00:02:26','admin','2021-10-31 09:26:52'),
(54,'aaa','aaa',NULL,11,'aaa','aaa','aaa','aaa','aaa','B','停止中','法定','1','W',NULL,NULL,'2021-10-31','计划','计划','111','111','111','111','111','111',NULL,0,'admin','2021-10-31 08:24:45','admin','2021-10-31 08:25:11'),
(55,'aaa','aaa',NULL,123,'aa','aaaaa','aaaaa','aaaa','aaaaaaa','B','停止中','法定','1','D',NULL,NULL,'2021-10-31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'admin','2021-10-31 09:29:05','admin','2021-10-31 09:29:05');

/*Table structure for table `equipment_device` */

DROP TABLE IF EXISTS `equipment_device`;

CREATE TABLE `equipment_device` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `device_id` varchar(11) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '设备编号',
  `device_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '设备名称',
  `manufacturer` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '生产厂家',
  `lifetime` int(11) DEFAULT NULL COMMENT '使用年限',
  `active_time` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '启用时间',
  `end_time` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '结束时间',
  `is_end` tinyint(1) DEFAULT NULL COMMENT '是否过期',
  `part_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '零件号',
  `part_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '零件名称',
  `img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '设备图片',
  `version` bigint(255) unsigned zerofill DEFAULT NULL COMMENT '版本',
  `is_deleted` tinyint(1) unsigned zerofill DEFAULT NULL COMMENT '是否删除',
  `created_user` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建用户',
  `created_time` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_user` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '更新用户',
  `updated_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='设备信息表';

/*Data for the table `equipment_device` */

insert  into `equipment_device`(`id`,`device_id`,`device_name`,`manufacturer`,`lifetime`,`active_time`,`end_time`,`is_end`,`part_id`,`part_name`,`img`,`version`,`is_deleted`,`created_user`,`created_time`,`updated_user`,`updated_time`) values 
(1,'1','机器人1','中国',12,'2021-08-31','2033-08-31',0,'A001','part1','/static/img/device/dba09ck_logo.bmp',000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001,0,'admin','2021-09-04 00:03:29',NULL,NULL),
(2,'2','机器人2','中国',15,'2021-09-04',NULL,NULL,'A002','part2','',000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001,0,'admin','2021-09-04 00:12:05','admin','2021-09-04 00:12:05'),
(3,'3','机器人3','中国',16,'2021-09-04','2037-09-04',0,'A002','part2','',000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001,0,NULL,NULL,NULL,NULL),
(4,'1','1','1',1,'2021-09-01','2022-09-01',NULL,'1','1','',NULL,0,NULL,'2021-09-09 22:48:01',NULL,'2021-09-09 22:48:01');

/*Table structure for table `equipment_maintenance` */

DROP TABLE IF EXISTS `equipment_maintenance`;

CREATE TABLE `equipment_maintenance` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `device_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '设备名称',
  `workstation` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '工位',
  `particular_year` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '年份',
  `week` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '周次',
  `maintenance_state` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '检修状态',
  `pre_check_num` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '0' COMMENT '预检修卡号',
  `pre_repair_task_content` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '预检修任务内容',
  `Pre_repair_process_number` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '预检修工艺卡号',
  `total_working_hours` bigint(20) DEFAULT NULL COMMENT '总工时（分）',
  `second` bigint(20) DEFAULT NULL COMMENT '次/年',
  `working_hours` bigint(20) DEFAULT NULL COMMENT '工时/次（分）',
  `people_number` bigint(20) DEFAULT NULL COMMENT '人数',
  `plan_status` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '计划状态',
  `fault_times` bigint(20) DEFAULT '0' COMMENT '故障次数',
  `failure_duration` bigint(20) DEFAULT '0' COMMENT '故障时长（分）',
  `version` bigint(20) DEFAULT '1' COMMENT '版本',
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '逻辑删除(1:已删除，0:未删除)',
  `created_user` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '创建用户',
  `created_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_user` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '更新用户',
  `updated_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='设备检修表';

/*Data for the table `equipment_maintenance` */

insert  into `equipment_maintenance`(`id`,`device_name`,`workstation`,`particular_year`,`week`,`maintenance_state`,`pre_check_num`,`pre_repair_task_content`,`Pre_repair_process_number`,`total_working_hours`,`second`,`working_hours`,`people_number`,`plan_status`,`fault_times`,`failure_duration`,`version`,`is_deleted`,`created_user`,`created_time`,`updated_user`,`updated_time`) values 
(1,'点焊机器人工作站','5013','2020-12-31T16:00:00.000Z','2021-08-22T16:00:00.000Z','静态','','程序','1',90,4,30,3,'1',0,0,1,0,'admin','2021-08-28 19:01:25','admin','2021-10-16 14:47:39'),
(2,'点焊机器人工作站','5013','2020-12-31T16:00:00.000Z','2021-08-22T16:00:00.000Z','静态','','机器人原点','2',90,4,30,3,'2',0,0,1,0,'admin','2021-08-28 19:01:25','admin','2021-08-28 20:29:28'),
(3,'点焊机器人工作站','5013','2020-12-31T16:00:00.000Z','2021-08-22T16:00:00.000Z','静态','','机器人外部整体','3',90,4,30,3,'3',0,0,1,0,'admin','2021-08-28 19:01:25','admin','2021-08-28 20:29:35'),
(4,'点焊机器人工作站','5013','2020-12-31T16:00:00.000Z','2021-08-22T16:00:00.000Z','静态','','管线','4',90,4,30,3,'4',0,0,1,0,'admin','2021-08-28 19:01:25','admin','2021-08-28 20:29:40'),
(5,'点焊机器人工作站','5013','2020-12-31T16:00:00.000Z','2021-08-22T16:00:00.000Z','静态','','机器人控制箱','5',90,2,30,3,'5',0,0,1,0,'admin','2021-08-28 19:01:25','admin','2021-08-28 20:29:46'),
(6,'点焊机器人工作站','5013','2020-12-31T16:00:00.000Z','2021-08-22T16:00:00.000Z','静态','','PLC控制箱','6',90,2,30,3,'1',0,0,1,0,'admin','2021-08-28 19:01:25','admin','2021-08-28 19:01:25'),
(7,'点焊机器人工作站','5013','2020-12-31T16:00:00.000Z','2021-08-22T16:00:00.000Z','静态','','触摸屏','7',90,2,30,3,'1',0,0,1,0,'admin','2021-08-28 19:01:25','admin','2021-08-28 19:01:25'),
(8,'点焊机器人工作站','5013','2020-12-31T16:00:00.000Z','2021-08-22T16:00:00.000Z','静态','','围栏','8',90,2,30,3,'1',0,0,1,0,'admin','2021-08-28 19:01:25','admin','2021-08-28 19:01:25'),
(9,'点焊机器人工作站','5013','2020-12-31T16:00:00.000Z','2021-08-22T16:00:00.000Z','静态','','按钮板','9',90,4,30,3,'1',0,0,1,0,'admin','2021-08-28 19:01:25','admin','2021-08-28 19:01:25'),
(10,'点焊机器人工作站','5013','2020-12-31T16:00:00.000Z','2021-08-22T16:00:00.000Z','静态','','水气单元','10',90,4,30,3,'1',0,0,1,0,'admin','2021-08-28 19:01:25','admin','2021-08-28 19:01:25'),
(11,'点焊机器人工作站','5013','2020-12-31T16:00:00.000Z','2021-08-22T16:00:00.000Z','静态','','机器人焊钳','11',90,1,30,3,'1',0,0,1,0,'admin','2021-08-28 19:01:25','admin','2021-08-28 19:01:25'),
(12,'点焊机器人工作站','5013','2020-12-31T16:00:00.000Z','2021-08-22T16:00:00.000Z','静态','','修磨器','12',90,2,30,3,'1',0,0,1,0,'admin','2021-08-28 19:01:25','admin','2021-08-28 19:01:25'),
(13,'点焊机器人工作站','5013','2020-12-31T16:00:00.000Z','2021-08-22T16:00:00.000Z','静态','','焊接控制箱','13',90,2,30,3,'1',0,0,1,0,'admin','2021-08-28 19:01:25','admin','2021-08-28 19:01:25'),
(14,'点焊机器人工作站','5014','2021-12-31T16:00:00.000Z','2021-08-22T16:00:00.000Z','静态','0','程序','1',90,4,30,3,'1',0,0,1,0,'admin','2021-08-29 23:16:48','admin','2021-08-29 23:16:48'),
(15,'点焊机器人工作站','5014','2021-12-31T16:00:00.000Z','2021-08-22T16:00:00.000Z','静态','0','机器人原点','2',90,4,30,3,'1',0,0,1,0,'admin','2021-08-29 23:16:48','admin','2021-08-29 23:16:48'),
(16,'点焊机器人工作站','5014','2021-12-31T16:00:00.000Z','2021-08-22T16:00:00.000Z','静态','0','机器人外部整体','3',90,4,30,3,'1',0,0,1,0,'admin','2021-08-29 23:16:48','admin','2021-08-29 23:16:48'),
(17,'点焊机器人工作站','5014','2021-12-31T16:00:00.000Z','2021-08-22T16:00:00.000Z','静态','0','管线','4',90,4,30,3,'1',0,0,1,0,'admin','2021-08-29 23:16:48','admin','2021-08-29 23:16:48'),
(18,'点焊机器人工作站','5014','2021-12-31T16:00:00.000Z','2021-08-22T16:00:00.000Z','静态','0','机器人控制箱','5',90,2,30,3,'1',0,0,1,0,'admin','2021-08-29 23:16:48','admin','2021-08-29 23:16:48'),
(19,'点焊机器人工作站','5014','2021-12-31T16:00:00.000Z','2021-08-22T16:00:00.000Z','静态','0','PLC控制箱','6',90,2,30,3,'1',0,0,1,0,'admin','2021-08-29 23:16:48','admin','2021-08-29 23:16:48'),
(20,'点焊机器人工作站','5014','2021-12-31T16:00:00.000Z','2021-08-22T16:00:00.000Z','静态','0','触摸屏','7',90,2,30,3,'1',0,0,1,0,'admin','2021-08-29 23:16:48','admin','2021-08-29 23:16:48'),
(21,'点焊机器人工作站','5014','2021-12-31T16:00:00.000Z','2021-08-22T16:00:00.000Z','静态','0','围栏','8',90,2,30,3,'1',0,0,1,0,'admin','2021-08-29 23:16:48','admin','2021-08-29 23:16:48'),
(22,'点焊机器人工作站','5014','2021-12-31T16:00:00.000Z','2021-08-22T16:00:00.000Z','静态','0','按钮板','9',90,4,30,3,'1',0,0,1,0,'admin','2021-08-29 23:16:48','admin','2021-08-29 23:16:48'),
(23,'点焊机器人工作站','5014','2021-12-31T16:00:00.000Z','2021-08-22T16:00:00.000Z','静态','0','水气单元','10',90,4,30,3,'1',0,0,1,0,'admin','2021-08-29 23:16:48','admin','2021-08-29 23:16:48'),
(24,'点焊机器人工作站','5014','2021-12-31T16:00:00.000Z','2021-08-22T16:00:00.000Z','静态','0','机器人焊钳','11',90,1,30,3,'1',0,0,1,0,'admin','2021-08-29 23:16:48','admin','2021-08-29 23:16:48'),
(25,'点焊机器人工作站','5014','2021-12-31T16:00:00.000Z','2021-08-22T16:00:00.000Z','静态','0','修磨器','12',90,2,30,3,'1',0,0,1,0,'admin','2021-08-29 23:16:48','admin','2021-08-29 23:16:48'),
(26,'点焊机器人工作站','5014','2021-12-31T16:00:00.000Z','2021-08-22T16:00:00.000Z','静态','0','焊接控制箱','13',90,2,30,3,'1',0,0,1,0,'admin','2021-08-29 23:16:48','admin','2021-08-29 23:16:48'),
(27,'固定点焊机','3302','2020-12-31T16:00:00.000Z','2021-09-26T16:00:00.000Z','静态','','电极臂、冷却水芯','1',90,4,30,3,'1',0,0,1,0,'admin','2021-09-01 21:24:28','admin','2021-09-01 21:24:28'),
(28,'固定点焊机','3302','2020-12-31T16:00:00.000Z','2021-09-26T16:00:00.000Z','静态','','检查绝缘垫','2',90,2,30,3,'1',0,0,1,0,'admin','2021-09-01 21:24:28','admin','2021-09-01 21:24:28'),
(29,'固定点焊机','3302','2020-12-31T16:00:00.000Z','2021-09-26T16:00:00.000Z','静态','','气缸','3',90,2,30,3,'1',0,0,1,0,'admin','2021-09-01 21:24:28','admin','2021-09-01 21:24:28'),
(30,'固定点焊机','3302','2020-12-31T16:00:00.000Z','2021-09-26T16:00:00.000Z','静态','','铜排','4',90,2,30,3,'1',0,0,1,0,'admin','2021-09-01 21:24:28','admin','2021-09-01 21:24:28'),
(31,'固定点焊机','3302','2020-12-31T16:00:00.000Z','2021-09-26T16:00:00.000Z','静态','','换向阀','5',90,2,30,3,'1',0,0,1,0,'admin','2021-09-01 21:24:28','admin','2021-09-01 21:24:28'),
(32,'固定点焊机','3302','2020-12-31T16:00:00.000Z','2021-09-26T16:00:00.000Z','静态','','水气单元','6',90,1,30,3,'1',0,0,1,0,'admin','2021-09-01 21:24:28','admin','2021-09-01 21:24:28'),
(33,'固定点焊机','3302','2020-12-31T16:00:00.000Z','2021-09-26T16:00:00.000Z','静态','','启动按钮、脚踏开关','7',90,2,30,3,'1',0,0,1,0,'admin','2021-09-01 21:24:28','admin','2021-09-01 21:24:28'),
(34,'固定点焊机','3302','2020-12-31T16:00:00.000Z','2021-09-26T16:00:00.000Z','静态','','控制器','8',90,2,30,3,'1',0,0,1,0,'admin','2021-09-01 21:24:28','admin','2021-09-01 21:24:28'),
(35,'点焊机器人工作站','123','2021-12-31T16:00:00.000Z','2022-02-20T16:00:00.000Z','静态','','程序','1',90,4,30,3,'2',0,0,1,0,'admin','2021-09-04 22:55:09','admin','2021-09-04 22:55:09'),
(36,'点焊机器人工作站','123','2021-12-31T16:00:00.000Z','2022-02-20T16:00:00.000Z','静态','','机器人原点','2',90,4,30,3,'2',0,0,1,0,'admin','2021-09-04 22:55:09','admin','2021-09-04 22:55:09'),
(37,'点焊机器人工作站','123','2021-12-31T16:00:00.000Z','2022-02-20T16:00:00.000Z','静态','','机器人外部整体','3',90,4,30,3,'2',0,0,1,0,'admin','2021-09-04 22:55:09','admin','2021-09-04 22:55:09'),
(38,'点焊机器人工作站','123','2021-12-31T16:00:00.000Z','2022-02-20T16:00:00.000Z','静态','','管线','4',90,4,30,3,'2',0,0,1,0,'admin','2021-09-04 22:55:09','admin','2021-09-04 22:55:09'),
(39,'点焊机器人工作站','123','2021-12-31T16:00:00.000Z','2022-02-20T16:00:00.000Z','静态','','机器人控制箱','5',90,2,30,3,'2',0,0,1,0,'admin','2021-09-04 22:55:10','admin','2021-09-04 22:55:10'),
(40,'点焊机器人工作站','123','2021-12-31T16:00:00.000Z','2022-02-20T16:00:00.000Z','静态','','PLC控制箱','6',90,2,30,3,'2',0,0,1,0,'admin','2021-09-04 22:55:10','admin','2021-09-04 22:55:10'),
(41,'点焊机器人工作站','123','2021-12-31T16:00:00.000Z','2022-02-20T16:00:00.000Z','静态','','触摸屏','7',90,2,30,3,'2',0,0,1,0,'admin','2021-09-04 22:55:10','admin','2021-09-04 22:55:10'),
(42,'点焊机器人工作站','123','2021-12-31T16:00:00.000Z','2022-02-20T16:00:00.000Z','静态','','围栏','8',90,2,30,3,'2',0,0,1,0,'admin','2021-09-04 22:55:10','admin','2021-09-04 22:55:10'),
(43,'点焊机器人工作站','123','2021-12-31T16:00:00.000Z','2022-02-20T16:00:00.000Z','静态','','按钮板','9',90,4,30,3,'2',0,0,1,0,'admin','2021-09-04 22:55:10','admin','2021-09-04 22:55:10'),
(44,'点焊机器人工作站','123','2021-12-31T16:00:00.000Z','2022-02-20T16:00:00.000Z','静态','','水气单元','10',90,4,30,3,'2',0,0,1,0,'admin','2021-09-04 22:55:10','admin','2021-09-04 22:55:10'),
(45,'点焊机器人工作站','123','2021-12-31T16:00:00.000Z','2022-02-20T16:00:00.000Z','静态','','机器人焊钳','11',90,1,30,3,'2',0,0,1,0,'admin','2021-09-04 22:55:10','admin','2021-09-04 22:55:10'),
(46,'点焊机器人工作站','123','2021-12-31T16:00:00.000Z','2022-02-20T16:00:00.000Z','静态','','修磨器','12',90,2,30,3,'2',0,0,1,0,'admin','2021-09-04 22:55:10','admin','2021-09-04 22:55:10'),
(47,'点焊机器人工作站','123','2021-12-31T16:00:00.000Z','2022-02-20T16:00:00.000Z','静态','','焊接控制箱','13',90,2,30,3,'2',0,0,1,0,'admin','2021-09-04 22:55:10','admin','2021-09-04 22:55:10');

/*Table structure for table `equipment_maintenance_content` */

DROP TABLE IF EXISTS `equipment_maintenance_content`;

CREATE TABLE `equipment_maintenance_content` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `device_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '设备名称',
  `pre_repair_task_content` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '预检修任务内容',
  `pre_repair_process_number` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '预检修工艺卡号',
  `status` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '是否启用',
  `total_working_hours` bigint(20) DEFAULT NULL COMMENT '总工时（分）',
  `second` bigint(20) DEFAULT NULL COMMENT '次/年',
  `working_hours` bigint(20) DEFAULT NULL COMMENT '工时/次（分）',
  `people_number` bigint(20) DEFAULT NULL COMMENT '人数',
  `version` bigint(20) DEFAULT '1' COMMENT '版本',
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '逻辑删除(1:已删除，0:未删除)',
  `created_user` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '创建用户',
  `created_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_user` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '更新用户',
  `updated_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='设备检修内容表';

/*Data for the table `equipment_maintenance_content` */

insert  into `equipment_maintenance_content`(`id`,`device_name`,`pre_repair_task_content`,`pre_repair_process_number`,`status`,`total_working_hours`,`second`,`working_hours`,`people_number`,`version`,`is_deleted`,`created_user`,`created_time`,`updated_user`,`updated_time`) values 
(1,'点焊机器人工作站','程序','1','1',90,4,30,3,10,0,'admin','2021-08-25 22:25:48','admin','2021-08-29 14:09:34'),
(2,'点焊机器人工作站','机器人原点','2','1',90,4,30,3,2,0,'admin','2021-08-25 23:15:02','admin','2021-08-28 18:36:18'),
(3,'点焊机器人工作站','机器人外部整体','3','1',90,4,30,3,3,0,'admin','2021-08-25 23:15:42','admin','2021-08-28 18:37:46'),
(4,'点焊机器人工作站','管线','4','1',90,4,30,3,2,0,'admin','2021-08-25 23:16:29','admin','2021-08-28 18:37:57'),
(5,'点焊机器人工作站','机器人控制箱','5','1',90,2,30,3,2,0,'admin','2021-08-25 23:16:49','admin','2021-08-28 18:38:24'),
(6,'点焊机器人工作站','PLC控制箱','6','1',90,2,30,3,2,0,'admin','2021-08-25 23:17:17','admin','2021-08-28 18:38:34'),
(7,'点焊机器人工作站','触摸屏','7','1',90,2,30,3,2,0,'admin','2021-08-25 23:17:48','admin','2021-08-28 18:38:45'),
(8,'点焊机器人工作站','围栏','8','1',90,2,30,3,2,0,'admin','2021-08-25 23:18:15','admin','2021-08-28 18:38:55'),
(9,'点焊机器人工作站','按钮板','9','1',90,4,30,3,2,0,'admin','2021-08-25 23:18:41','admin','2021-08-28 18:39:14'),
(10,'点焊机器人工作站','水气单元','10','1',90,4,30,3,2,0,'admin','2021-08-25 23:19:02','admin','2021-08-28 18:39:24'),
(11,'点焊机器人工作站','机器人焊钳','11','1',90,1,30,3,2,0,'admin','2021-08-25 23:19:23','admin','2021-08-28 18:39:35'),
(12,'点焊机器人工作站','修磨器','12','1',90,2,30,3,2,0,'admin','2021-08-25 23:19:47','admin','2021-08-28 18:39:46'),
(13,'点焊机器人工作站','焊接控制箱','13','1',90,2,30,3,2,0,'admin','2021-08-25 23:20:12','admin','2021-08-28 18:39:58'),
(14,'固定点焊机','电极臂、冷却水芯','1','1',90,4,30,3,2,0,'admin','2021-08-25 23:21:16','admin','2021-08-28 18:40:51'),
(15,'固定点焊机','检查绝缘垫','2','1',90,2,30,3,2,0,'admin','2021-08-25 23:21:43','admin','2021-08-28 18:41:00'),
(16,'固定点焊机','气缸','3','1',90,2,30,3,2,0,'admin','2021-08-25 23:22:03','admin','2021-08-28 18:41:08'),
(17,'固定点焊机','铜排','4','1',90,2,30,3,2,0,'admin','2021-08-25 23:22:23','admin','2021-08-28 18:41:23'),
(18,'固定点焊机','换向阀','5','1',90,2,30,3,2,0,'admin','2021-08-25 23:22:44','admin','2021-08-28 18:41:32'),
(19,'固定点焊机','水气单元','6','1',90,1,30,3,2,0,'admin','2021-08-25 23:23:11','admin','2021-08-28 18:41:41'),
(20,'固定点焊机','启动按钮、脚踏开关','7','1',90,2,30,3,2,0,'admin','2021-08-25 23:23:34','admin','2021-08-28 18:41:50'),
(21,'固定点焊机','控制器','8','1',90,2,30,3,2,0,'admin','2021-08-25 23:23:57','admin','2021-08-28 18:42:02'),
(22,'分体式手工焊钳','焊钳表面清洁','1','1',90,4,30,3,1,0,'admin','2021-08-29 18:52:58','admin','2021-08-29 18:52:58'),
(23,'分体式手工焊钳','电极杆、冷却水芯','2','1',90,4,30,3,1,0,'admin','2021-08-29 18:52:58','admin','2021-08-29 18:52:58'),
(24,'分体式手工焊钳','检查绝缘垫','3','1',90,2,30,3,1,0,'admin','2021-08-29 18:52:58','admin','2021-08-29 18:52:58'),
(25,'分体式手工焊钳','转盘','4','1',90,1,30,3,1,0,'admin','2021-08-29 18:52:58','admin','2021-08-29 18:52:58'),
(26,'分体式手工焊钳','静钳体','5','1',90,2,30,3,1,0,'admin','2021-08-29 18:52:58','admin','2021-08-29 18:52:58'),
(27,'分体式手工焊钳','动钳体','6','1',90,2,30,3,1,0,'admin','2021-08-29 18:52:58','admin','2021-08-29 18:52:58'),
(28,'分体式手工焊钳','主电缆、副缆','7','1',90,2,30,3,1,0,'admin','2021-08-29 18:52:58','admin','2021-08-29 18:52:58'),
(29,'分体式手工焊钳','气缸','8','1',90,2,30,3,1,0,'admin','2021-08-29 18:52:58','admin','2021-08-29 18:52:58'),
(30,'分体式手工焊钳','换向阀','9','1',90,2,30,3,1,0,'admin','2021-08-29 18:52:58','admin','2021-08-29 18:52:58'),
(31,'分体式手工焊钳','水气单元','10','1',90,1,30,3,1,0,'admin','2021-08-29 18:52:58','admin','2021-08-29 18:52:58'),
(32,'分体式手工焊钳','手柄','11','1',90,2,30,3,1,0,'admin','2021-08-29 18:52:58','admin','2021-08-29 18:52:58'),
(33,'分体式手工焊钳','控制器','12','1',90,2,30,3,1,0,'admin','2021-08-29 18:52:58','admin','2021-08-29 18:52:58'),
(34,'机器人','加油','1111','1',10,2,10,1,2,0,'admin','2021-10-31 08:01:44','admin','2021-10-31 08:03:35');

/*Table structure for table `equipment_part` */

DROP TABLE IF EXISTS `equipment_part`;

CREATE TABLE `equipment_part` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `no` int(11) DEFAULT NULL COMMENT '序号',
  `device_id` varchar(11) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '设备编号',
  `device_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '设备名称',
  `place` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '所在部位',
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '编码',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '名称',
  `model` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '规格型号',
  `brand` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '品牌',
  `number` int(11) DEFAULT NULL COMMENT '装机数量',
  `lifetime` int(11) DEFAULT NULL COMMENT '使用寿命',
  `active_time` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `end_time` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `is_end` tinyint(1) DEFAULT NULL,
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `version` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '版本',
  `is_deleted` tinyint(1) DEFAULT NULL COMMENT '是否删除',
  `created_user` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建用户',
  `created_time` varchar(19) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建时间',
  `updated_user` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '更新用户',
  `updated_time` varchar(19) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='设备备件表';

/*Data for the table `equipment_part` */

insert  into `equipment_part`(`id`,`no`,`device_id`,`device_name`,`place`,`code`,`name`,`model`,`brand`,`number`,`lifetime`,`active_time`,`end_time`,`is_end`,`remark`,`version`,`is_deleted`,`created_user`,`created_time`,`updated_user`,`updated_time`) values 
(1,1,'1','机器人1','head','897','焊枪','C001','china',1,30,'2001-11-12','2051-09-09',0,'',NULL,0,'admin','2021-09-04 00:17:11',NULL,NULL),
(2,2,'2','机器人2','body','999','夹具','FA','ZZZZZ',1,10,'2001-11-12',NULL,NULL,'',NULL,0,NULL,NULL,'admin','2021-09-04 22:52:58'),
(3,3,'1','机器人1','a','123','火','sss','gggg',14,19,'2001-11-12',NULL,NULL,'',NULL,0,'admin','2021-09-04 00:22:56','admin','2021-09-04 00:22:56'),
(4,4,'4','4','4','4','4','4','4',4,4,'2001-11-12',NULL,NULL,'',NULL,0,'admin','2021-09-04 00:25:04','admin','2021-09-04 00:25:04'),
(5,5,'5','5','5','5','5','5','5',5,5,'2001-11-12',NULL,NULL,'',NULL,0,'admin','2021-09-04 00:27:03','admin','2021-09-04 00:27:03'),
(6,6,'6','6','6','6','6','6','6',6,6,'2001-11-12',NULL,NULL,'',NULL,0,'admin','2021-09-04 00:27:26','admin','2021-09-04 00:27:26'),
(7,7,'7','7','7','7','7','7','7',7,7,'2001-11-12',NULL,NULL,'',NULL,0,'admin','2021-09-04 00:28:57','admin','2021-09-04 00:28:57'),
(8,8,'8','8','8','8','8','8','8',8,8,'2001-11-12',NULL,NULL,'8',NULL,NULL,'admin','2021-09-04 22:50:34','admin','2021-09-04 22:50:34'),
(9,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2001-11-12',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

/*Table structure for table `qrtz_blob_triggers` */

DROP TABLE IF EXISTS `qrtz_blob_triggers`;

CREATE TABLE `qrtz_blob_triggers` (
  `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `TRIGGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `BLOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`) USING BTREE,
  KEY `SCHED_NAME` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`) USING BTREE,
  CONSTRAINT `qrtz_blob_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`sched_name`, `trigger_name`, `trigger_group`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

/*Data for the table `qrtz_blob_triggers` */

/*Table structure for table `qrtz_calendars` */

DROP TABLE IF EXISTS `qrtz_calendars`;

CREATE TABLE `qrtz_calendars` (
  `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CALENDAR_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CALENDAR` blob NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`CALENDAR_NAME`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

/*Data for the table `qrtz_calendars` */

/*Table structure for table `qrtz_cron_triggers` */

DROP TABLE IF EXISTS `qrtz_cron_triggers`;

CREATE TABLE `qrtz_cron_triggers` (
  `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `TRIGGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CRON_EXPRESSION` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `TIME_ZONE_ID` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`) USING BTREE,
  CONSTRAINT `qrtz_cron_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`sched_name`, `trigger_name`, `trigger_group`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

/*Data for the table `qrtz_cron_triggers` */

/*Table structure for table `qrtz_fired_triggers` */

DROP TABLE IF EXISTS `qrtz_fired_triggers`;

CREATE TABLE `qrtz_fired_triggers` (
  `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ENTRY_ID` varchar(95) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `TRIGGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `INSTANCE_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `FIRED_TIME` bigint(13) NOT NULL,
  `SCHED_TIME` bigint(13) NOT NULL,
  `PRIORITY` int(11) NOT NULL,
  `STATE` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `JOB_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `JOB_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `IS_NONCONCURRENT` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `REQUESTS_RECOVERY` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`ENTRY_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

/*Data for the table `qrtz_fired_triggers` */

/*Table structure for table `qrtz_job_details` */

DROP TABLE IF EXISTS `qrtz_job_details`;

CREATE TABLE `qrtz_job_details` (
  `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `JOB_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `JOB_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `DESCRIPTION` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `JOB_CLASS_NAME` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `IS_DURABLE` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `IS_NONCONCURRENT` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `IS_UPDATE_DATA` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `REQUESTS_RECOVERY` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `JOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`) USING BTREE,
  KEY `IDX_QRTZ_J_REQ_RECOVERY` (`SCHED_NAME`,`REQUESTS_RECOVERY`) USING BTREE,
  KEY `IDX_QRTZ_J_GRP` (`SCHED_NAME`,`JOB_GROUP`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

/*Data for the table `qrtz_job_details` */

/*Table structure for table `qrtz_locks` */

DROP TABLE IF EXISTS `qrtz_locks`;

CREATE TABLE `qrtz_locks` (
  `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `LOCK_NAME` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`LOCK_NAME`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

/*Data for the table `qrtz_locks` */

insert  into `qrtz_locks`(`SCHED_NAME`,`LOCK_NAME`) values 
('RenrenScheduler','STATE_ACCESS'),
('RenrenScheduler','TRIGGER_ACCESS');

/*Table structure for table `qrtz_paused_trigger_grps` */

DROP TABLE IF EXISTS `qrtz_paused_trigger_grps`;

CREATE TABLE `qrtz_paused_trigger_grps` (
  `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_GROUP`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

/*Data for the table `qrtz_paused_trigger_grps` */

/*Table structure for table `qrtz_scheduler_state` */

DROP TABLE IF EXISTS `qrtz_scheduler_state`;

CREATE TABLE `qrtz_scheduler_state` (
  `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `INSTANCE_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `LAST_CHECKIN_TIME` bigint(13) NOT NULL,
  `CHECKIN_INTERVAL` bigint(13) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`INSTANCE_NAME`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

/*Data for the table `qrtz_scheduler_state` */

insert  into `qrtz_scheduler_state`(`SCHED_NAME`,`INSTANCE_NAME`,`LAST_CHECKIN_TIME`,`CHECKIN_INTERVAL`) values 
('RenrenScheduler','DESKTOP-K64AET91635640392262',1635647356026,15000);

/*Table structure for table `qrtz_simple_triggers` */

DROP TABLE IF EXISTS `qrtz_simple_triggers`;

CREATE TABLE `qrtz_simple_triggers` (
  `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `TRIGGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `REPEAT_COUNT` bigint(7) NOT NULL,
  `REPEAT_INTERVAL` bigint(12) NOT NULL,
  `TIMES_TRIGGERED` bigint(10) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`) USING BTREE,
  CONSTRAINT `qrtz_simple_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`sched_name`, `trigger_name`, `trigger_group`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

/*Data for the table `qrtz_simple_triggers` */

/*Table structure for table `qrtz_simprop_triggers` */

DROP TABLE IF EXISTS `qrtz_simprop_triggers`;

CREATE TABLE `qrtz_simprop_triggers` (
  `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `TRIGGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `STR_PROP_1` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `STR_PROP_2` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `STR_PROP_3` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `INT_PROP_1` int(11) DEFAULT NULL,
  `INT_PROP_2` int(11) DEFAULT NULL,
  `LONG_PROP_1` bigint(20) DEFAULT NULL,
  `LONG_PROP_2` bigint(20) DEFAULT NULL,
  `DEC_PROP_1` decimal(13,4) DEFAULT NULL,
  `DEC_PROP_2` decimal(13,4) DEFAULT NULL,
  `BOOL_PROP_1` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `BOOL_PROP_2` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`) USING BTREE,
  CONSTRAINT `qrtz_simprop_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`sched_name`, `trigger_name`, `trigger_group`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

/*Data for the table `qrtz_simprop_triggers` */

/*Table structure for table `qrtz_triggers` */

DROP TABLE IF EXISTS `qrtz_triggers`;

CREATE TABLE `qrtz_triggers` (
  `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `TRIGGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `JOB_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `JOB_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `DESCRIPTION` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `NEXT_FIRE_TIME` bigint(13) DEFAULT NULL,
  `PREV_FIRE_TIME` bigint(13) DEFAULT NULL,
  `PRIORITY` int(11) DEFAULT NULL,
  `TRIGGER_STATE` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `TRIGGER_TYPE` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `START_TIME` bigint(13) NOT NULL,
  `END_TIME` bigint(13) DEFAULT NULL,
  `CALENDAR_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `MISFIRE_INSTR` smallint(2) DEFAULT NULL,
  `JOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`) USING BTREE,
  KEY `IDX_QRTZ_T_J` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`) USING BTREE,
  KEY `IDX_QRTZ_T_JG` (`SCHED_NAME`,`JOB_GROUP`) USING BTREE,
  KEY `IDX_QRTZ_T_C` (`SCHED_NAME`,`CALENDAR_NAME`) USING BTREE,
  KEY `IDX_QRTZ_T_G` (`SCHED_NAME`,`TRIGGER_GROUP`) USING BTREE,
  KEY `IDX_QRTZ_T_STATE` (`SCHED_NAME`,`TRIGGER_STATE`) USING BTREE,
  KEY `IDX_QRTZ_T_N_STATE` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`) USING BTREE,
  KEY `IDX_QRTZ_T_N_G_STATE` (`SCHED_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`) USING BTREE,
  KEY `IDX_QRTZ_T_NEXT_FIRE_TIME` (`SCHED_NAME`,`NEXT_FIRE_TIME`) USING BTREE,
  KEY `IDX_QRTZ_T_NFT_ST` (`SCHED_NAME`,`TRIGGER_STATE`,`NEXT_FIRE_TIME`) USING BTREE,
  KEY `IDX_QRTZ_T_NFT_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`) USING BTREE,
  KEY `IDX_QRTZ_T_NFT_ST_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_STATE`) USING BTREE,
  KEY `IDX_QRTZ_T_NFT_ST_MISFIRE_GRP` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_GROUP`,`TRIGGER_STATE`) USING BTREE,
  CONSTRAINT `qrtz_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) REFERENCES `qrtz_job_details` (`sched_name`, `job_name`, `job_group`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

/*Data for the table `qrtz_triggers` */

/*Table structure for table `schedule_job` */

DROP TABLE IF EXISTS `schedule_job`;

CREATE TABLE `schedule_job` (
  `job_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '任务id',
  `bean_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT 'spring bean名称',
  `params` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '参数',
  `cron_expression` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT 'cron表达式',
  `status` tinyint(4) DEFAULT NULL COMMENT '任务状态  0：正常  1：暂停',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`job_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='定时任务';

/*Data for the table `schedule_job` */

/*Table structure for table `schedule_job_log` */

DROP TABLE IF EXISTS `schedule_job_log`;

CREATE TABLE `schedule_job_log` (
  `log_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '任务日志id',
  `job_id` bigint(20) NOT NULL COMMENT '任务id',
  `bean_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT 'spring bean名称',
  `params` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '参数',
  `status` tinyint(4) NOT NULL COMMENT '任务状态    0：成功    1：失败',
  `error` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '失败信息',
  `times` int(11) NOT NULL COMMENT '耗时(单位：毫秒)',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`log_id`) USING BTREE,
  KEY `job_id` (`job_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='定时任务日志';

/*Data for the table `schedule_job_log` */

/*Table structure for table `sys_captcha` */

DROP TABLE IF EXISTS `sys_captcha`;

CREATE TABLE `sys_captcha` (
  `uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'uuid',
  `code` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '验证码',
  `expire_time` datetime DEFAULT NULL COMMENT '过期时间',
  PRIMARY KEY (`uuid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='系统验证码';

/*Data for the table `sys_captcha` */

insert  into `sys_captcha`(`uuid`,`code`,`expire_time`) values 
('24e045f0-b605-41d3-81fb-a2b57262d581','b54da','2021-10-07 17:33:16'),
('a5676ffc-c1f7-4761-8c0f-49bba693134c','ng57g','2021-10-11 21:31:08'),
('ac706d2e-27f6-4508-8f93-8be40cdc67fa','6cdbx','2021-09-09 21:29:03'),
('b859e264-a75b-4d7b-8ebd-043acdded10e','xnwee','2021-08-12 23:04:46'),
('baaaf004-db1e-40af-8172-d0745a564c4b','dnn8e','2021-08-31 21:10:18'),
('c182b328-e6d4-43f0-8a64-bd91edb55847','ac85p','2021-10-12 23:42:09'),
('c959958e-899f-40d9-8740-4654ed668db4','ng6fd','2021-10-16 14:41:09'),
('ce1a3ae5-c83f-4c89-8b97-7a57b19f9c19','m7c6b','2021-08-28 11:09:24'),
('e8ce6dae-2889-41ce-8c38-ae83c66aa697','wwx46','2021-08-08 16:10:15'),
('f17ec8cc-f220-4132-8bc1-3d9ab3bd9584','mcpnp','2021-08-22 14:05:24'),
('f3111550-7d83-453b-8905-0c6c9c559ca2','ebndp','2021-10-07 17:33:11');

/*Table structure for table `sys_config` */

DROP TABLE IF EXISTS `sys_config`;

CREATE TABLE `sys_config` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `param_key` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT 'key',
  `param_value` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT 'value',
  `status` tinyint(4) DEFAULT '1' COMMENT '状态   0：隐藏   1：显示',
  `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `param_key` (`param_key`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='系统配置信息表';

/*Data for the table `sys_config` */

insert  into `sys_config`(`id`,`param_key`,`param_value`,`status`,`remark`) values 
(1,'CLOUD_STORAGE_CONFIG_KEY','{\"aliyunAccessKeyId\":\"\",\"aliyunAccessKeySecret\":\"\",\"aliyunBucketName\":\"\",\"aliyunDomain\":\"\",\"aliyunEndPoint\":\"\",\"aliyunPrefix\":\"\",\"qcloudBucketName\":\"\",\"qcloudDomain\":\"\",\"qcloudPrefix\":\"\",\"qcloudSecretId\":\"\",\"qcloudSecretKey\":\"\",\"qiniuAccessKey\":\"NrgMfABZxWLo5B-YYSjoE8-AZ1EISdi1Z3ubLOeZ\",\"qiniuBucketName\":\"ios-app\",\"qiniuDomain\":\"http://7xqbwh.dl1.z0.glb.clouddn.com\",\"qiniuPrefix\":\"upload\",\"qiniuSecretKey\":\"uIwJHevMRWU0VLxFvgy0tAcOdGqasdtVlJkdy6vV\",\"type\":1}',0,'云存储配置信息');

/*Table structure for table `sys_log` */

DROP TABLE IF EXISTS `sys_log`;

CREATE TABLE `sys_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '用户名',
  `operation` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '用户操作',
  `method` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '请求方法',
  `params` varchar(5000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '请求参数',
  `time` bigint(20) NOT NULL COMMENT '执行时长(毫秒)',
  `ip` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT 'IP地址',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=105 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='系统日志';

/*Data for the table `sys_log` */

insert  into `sys_log`(`id`,`username`,`operation`,`method`,`params`,`time`,`ip`,`create_date`) values 
(1,'admin','保存菜单','com.changkun.modules.sys.controller.SysMenuController.save()','[{\"menuId\":31,\"parentId\":0,\"name\":\"追溯查询\",\"url\":\"\",\"perms\":\"\",\"type\":0,\"icon\":\"sousuo\",\"orderNum\":0}]',8,'0:0:0:0:0:0:0:1','2021-08-08 15:47:24'),
(2,'admin','修改菜单','com.changkun.modules.sys.controller.SysMenuController.update()','[{\"menuId\":31,\"parentId\":0,\"name\":\"追溯查询\",\"url\":\"\",\"perms\":\"\",\"type\":0,\"icon\":\"sousuo\",\"orderNum\":1}]',7,'0:0:0:0:0:0:0:1','2021-08-08 15:47:44'),
(3,'admin','修改菜单','com.changkun.modules.sys.controller.SysMenuController.update()','[{\"menuId\":1,\"parentId\":0,\"name\":\"系统管理\",\"type\":0,\"icon\":\"system\",\"orderNum\":99}]',6,'0:0:0:0:0:0:0:1','2021-08-08 15:47:51'),
(4,'admin','保存菜单','com.changkun.modules.sys.controller.SysMenuController.save()','[{\"menuId\":32,\"parentId\":31,\"name\":\"FDS追溯信息查询\",\"url\":\"/fds\",\"perms\":\"\",\"type\":1,\"icon\":\"sousuo\",\"orderNum\":0}]',9,'0:0:0:0:0:0:0:1','2021-08-08 15:49:20'),
(5,'admin','修改菜单','com.changkun.modules.sys.controller.SysMenuController.update()','[{\"menuId\":32,\"parentId\":31,\"name\":\"FDS追溯信息查询\",\"url\":\"search/fds\",\"perms\":\"\",\"type\":1,\"icon\":\"sousuo\",\"orderNum\":0}]',9,'0:0:0:0:0:0:0:1','2021-08-08 15:50:05'),
(6,'admin','保存菜单','com.changkun.modules.sys.controller.SysMenuController.save()','[{\"menuId\":33,\"parentId\":31,\"name\":\"拉铆枪追溯信息查询\",\"url\":\"seacher/lamao\",\"perms\":\"\",\"type\":1,\"icon\":\"sousuo\",\"orderNum\":0}]',8,'0:0:0:0:0:0:0:1','2021-08-08 15:51:03'),
(7,'admin','修改菜单','com.changkun.modules.sys.controller.SysMenuController.update()','[{\"menuId\":31,\"parentId\":0,\"name\":\"追溯系统\",\"url\":\"\",\"perms\":\"\",\"type\":0,\"icon\":\"sousuo\",\"orderNum\":1}]',7,'0:0:0:0:0:0:0:1','2021-08-08 15:52:26'),
(8,'admin','保存菜单','com.changkun.modules.sys.controller.SysMenuController.save()','[{\"menuId\":34,\"parentId\":0,\"name\":\"备件系统\",\"url\":\"\",\"perms\":\"\",\"type\":0,\"icon\":\"menu\",\"orderNum\":2}]',6,'0:0:0:0:0:0:0:1','2021-08-08 15:54:00'),
(9,'admin','保存菜单','com.changkun.modules.sys.controller.SysMenuController.save()','[{\"menuId\":35,\"parentId\":0,\"name\":\"设备管理\",\"url\":\"\",\"perms\":\"\",\"type\":0,\"icon\":\"daohang\",\"orderNum\":0}]',5,'0:0:0:0:0:0:0:1','2021-08-08 15:54:35'),
(10,'admin','保存菜单','com.changkun.modules.sys.controller.SysMenuController.save()','[{\"menuId\":36,\"parentId\":0,\"name\":\"测漏信息\",\"url\":\"\",\"perms\":\"\",\"type\":0,\"icon\":\"dangdifill\",\"orderNum\":0}]',6,'0:0:0:0:0:0:0:1','2021-08-08 15:56:43'),
(11,'admin','修改菜单','com.changkun.modules.sys.controller.SysMenuController.update()','[{\"menuId\":31,\"parentId\":0,\"name\":\"追溯系统\",\"url\":\"\",\"perms\":\"\",\"type\":0,\"icon\":\"menu\",\"orderNum\":1}]',5,'0:0:0:0:0:0:0:1','2021-08-08 15:57:02'),
(12,'admin','修改菜单','com.changkun.modules.sys.controller.SysMenuController.update()','[{\"menuId\":35,\"parentId\":0,\"name\":\"设备管理\",\"url\":\"\",\"perms\":\"\",\"type\":0,\"icon\":\"menu\",\"orderNum\":0}]',5,'0:0:0:0:0:0:0:1','2021-08-08 15:57:09'),
(13,'admin','修改菜单','com.changkun.modules.sys.controller.SysMenuController.update()','[{\"menuId\":36,\"parentId\":35,\"name\":\"测漏信息\",\"url\":\"\",\"perms\":\"\",\"type\":0,\"icon\":\"menu\",\"orderNum\":0}]',6,'0:0:0:0:0:0:0:1','2021-08-08 15:57:27'),
(14,'admin','修改菜单','com.changkun.modules.sys.controller.SysMenuController.update()','[{\"menuId\":34,\"parentId\":0,\"name\":\"测漏信息\",\"url\":\"\",\"perms\":\"\",\"type\":0,\"icon\":\"menu\",\"orderNum\":2}]',6,'0:0:0:0:0:0:0:1','2021-08-08 15:57:51'),
(15,'admin','修改菜单','com.changkun.modules.sys.controller.SysMenuController.update()','[{\"menuId\":31,\"parentId\":0,\"name\":\"追溯信息\",\"url\":\"\",\"perms\":\"\",\"type\":0,\"icon\":\"menu\",\"orderNum\":1}]',6,'0:0:0:0:0:0:0:1','2021-08-08 15:58:03'),
(16,'admin','保存菜单','com.changkun.modules.sys.controller.SysMenuController.save()','[{\"menuId\":37,\"parentId\":0,\"name\":\"检验/返修\",\"url\":\"\",\"perms\":\"\",\"type\":0,\"icon\":\"menu\",\"orderNum\":3}]',5,'0:0:0:0:0:0:0:1','2021-08-08 15:58:24'),
(17,'admin','保存菜单','com.changkun.modules.sys.controller.SysMenuController.save()','[{\"menuId\":38,\"parentId\":0,\"name\":\"产线监测\",\"url\":\"\",\"perms\":\"\",\"type\":0,\"icon\":\"\",\"orderNum\":4}]',5,'0:0:0:0:0:0:0:1','2021-08-08 15:58:57'),
(18,'admin','保存菜单','com.changkun.modules.sys.controller.SysMenuController.save()','[{\"menuId\":39,\"parentId\":0,\"name\":\"设备台账\",\"url\":\"\",\"perms\":\"\",\"type\":0,\"icon\":\"\",\"orderNum\":5}]',5,'0:0:0:0:0:0:0:1','2021-08-08 15:59:22'),
(19,'admin','删除菜单','com.changkun.modules.sys.controller.SysMenuController.delete()','[35]',2,'0:0:0:0:0:0:0:1','2021-08-08 15:59:34'),
(20,'admin','删除菜单','com.changkun.modules.sys.controller.SysMenuController.delete()','[36]',20,'0:0:0:0:0:0:0:1','2021-08-08 15:59:38'),
(21,'admin','删除菜单','com.changkun.modules.sys.controller.SysMenuController.delete()','[35]',8,'0:0:0:0:0:0:0:1','2021-08-08 15:59:42'),
(22,'admin','修改菜单','com.changkun.modules.sys.controller.SysMenuController.update()','[{\"menuId\":38,\"parentId\":0,\"name\":\"产线监测\",\"url\":\"\",\"perms\":\"\",\"type\":0,\"icon\":\"tubiao\",\"orderNum\":4}]',7,'0:0:0:0:0:0:0:1','2021-08-08 16:00:03'),
(23,'admin','修改菜单','com.changkun.modules.sys.controller.SysMenuController.update()','[{\"menuId\":39,\"parentId\":0,\"name\":\"设备台账\",\"url\":\"\",\"perms\":\"\",\"type\":0,\"icon\":\"log\",\"orderNum\":5}]',6,'0:0:0:0:0:0:0:1','2021-08-08 16:00:13'),
(24,'admin','修改菜单','com.ckzy.modules.sys.controller.SysMenuController.update()','[{\"menuId\":31,\"parentId\":0,\"name\":\"设备管理\",\"url\":\"\",\"perms\":\"\",\"type\":0,\"icon\":\"menu\",\"orderNum\":1}]',9,'0:0:0:0:0:0:0:1','2021-08-12 23:01:55'),
(25,'admin','修改菜单','com.ckzy.modules.sys.controller.SysMenuController.update()','[{\"menuId\":32,\"parentId\":31,\"name\":\"设备信息\",\"url\":\"device/device\",\"perms\":\"\",\"type\":1,\"icon\":\"sousuo\",\"orderNum\":0}]',10,'0:0:0:0:0:0:0:1','2021-08-12 23:08:14'),
(26,'admin','修改菜单','com.ckzy.modules.sys.controller.SysMenuController.update()','[{\"menuId\":33,\"parentId\":31,\"name\":\"备件信息\",\"url\":\"device/part\",\"perms\":\"\",\"type\":1,\"icon\":\"sousuo\",\"orderNum\":2}]',9,'0:0:0:0:0:0:0:1','2021-08-12 23:08:55'),
(27,'admin','修改菜单','com.ckzy.modules.sys.controller.SysMenuController.update()','[{\"menuId\":34,\"parentId\":0,\"name\":\"点检管理\",\"url\":\"\",\"perms\":\"\",\"type\":0,\"icon\":\"menu\",\"orderNum\":2}]',8,'0:0:0:0:0:0:0:1','2021-08-13 22:56:43'),
(28,'admin','修改菜单','com.ckzy.modules.sys.controller.SysMenuController.update()','[{\"menuId\":39,\"parentId\":0,\"name\":\"设备台账\",\"url\":\"\",\"perms\":\"\",\"type\":0,\"icon\":\"log\",\"orderNum\":4}]',5,'0:0:0:0:0:0:0:1','2021-08-13 22:57:06'),
(29,'admin','修改菜单','com.ckzy.modules.sys.controller.SysMenuController.update()','[{\"menuId\":38,\"parentId\":0,\"name\":\"产线监测\",\"url\":\"\",\"perms\":\"\",\"type\":0,\"icon\":\"tubiao\",\"orderNum\":5}]',5,'0:0:0:0:0:0:0:1','2021-08-13 22:57:10'),
(30,'admin','保存菜单','com.ckzy.modules.sys.controller.SysMenuController.save()','[{\"menuId\":40,\"parentId\":34,\"name\":\"点检基准表\",\"url\":\"device/checkbase\",\"perms\":\"\",\"type\":1,\"icon\":\"bianji\",\"orderNum\":0}]',10,'0:0:0:0:0:0:0:1','2021-08-13 22:58:58'),
(31,'admin','保存菜单','com.ckzy.modules.sys.controller.SysMenuController.save()','[{\"menuId\":41,\"parentId\":34,\"name\":\"点检信息表\",\"url\":\"device/checkbasedetail\",\"perms\":\"\",\"type\":1,\"icon\":\"\",\"orderNum\":0}]',6,'0:0:0:0:0:0:0:1','2021-08-13 22:59:32'),
(32,'admin','保存菜单','com.ckzy.modules.sys.controller.SysMenuController.save()','[{\"menuId\":42,\"parentId\":37,\"name\":\"检修表\",\"url\":\"/device/maint\",\"perms\":\"\",\"type\":1,\"icon\":\"\",\"orderNum\":0}]',7,'0:0:0:0:0:0:0:1','2021-08-13 23:00:17'),
(33,'admin','保存菜单','com.ckzy.modules.sys.controller.SysMenuController.save()','[{\"menuId\":43,\"parentId\":39,\"name\":\"设备台账表\",\"url\":\"/device/ledger\",\"perms\":\"\",\"type\":1,\"icon\":\"\",\"orderNum\":0}]',7,'0:0:0:0:0:0:0:1','2021-08-13 23:00:55'),
(34,'admin','修改菜单','com.ckzy.modules.sys.controller.SysMenuController.update()','[{\"menuId\":40,\"parentId\":34,\"name\":\"点检基准表\",\"url\":\"device/checkbase\",\"perms\":\"\",\"type\":1,\"icon\":\"sousuo\",\"orderNum\":0}]',39,'0:0:0:0:0:0:0:1','2021-08-13 23:01:43'),
(35,'admin','修改菜单','com.ckzy.modules.sys.controller.SysMenuController.update()','[{\"menuId\":41,\"parentId\":34,\"name\":\"点检信息表\",\"url\":\"device/checkbasedetail\",\"perms\":\"\",\"type\":1,\"icon\":\"sousuo\",\"orderNum\":0}]',57,'0:0:0:0:0:0:0:1','2021-08-13 23:01:55'),
(36,'admin','修改菜单','com.ckzy.modules.sys.controller.SysMenuController.update()','[{\"menuId\":42,\"parentId\":37,\"name\":\"检修表\",\"url\":\"/device/maint\",\"perms\":\"\",\"type\":1,\"icon\":\"sousuo\",\"orderNum\":0}]',41,'0:0:0:0:0:0:0:1','2021-08-13 23:02:04'),
(37,'admin','保存角色','com.ckzy.modules.sys.controller.SysRoleController.save()','[{\"roleId\":1,\"roleName\":\"工段长\",\"remark\":\"\",\"createUserId\":1,\"menuIdList\":[31,32,33,34,40,41,37,42,38,39,43,-666666],\"createTime\":\"Aug 13, 2021 11:06:44 PM\"}]',526,'0:0:0:0:0:0:0:1','2021-08-13 23:06:44'),
(38,'admin','保存用户','com.ckzy.modules.sys.controller.SysUserController.save()','[{\"userId\":2,\"username\":\"work\",\"password\":\"9e233602d07dd29c6946c4345771571f57ffe2345144e2d62452ccf083a754bd\",\"salt\":\"Rdp9AGarDDGUz3DoxckJ\",\"email\":\"[email protected]\",\"mobile\":\"13512341234\",\"status\":1,\"roleIdList\":[1],\"createUserId\":1,\"createTime\":\"Aug 13, 2021 11:07:43 PM\"}]',212,'0:0:0:0:0:0:0:1','2021-08-13 23:07:44'),
(39,'admin','删除菜单','com.ckzy.modules.sys.controller.SysMenuController.delete()','[43]',50,'0:0:0:0:0:0:0:1','2021-08-20 22:43:10'),
(40,'admin','保存菜单','com.ckzy.modules.sys.controller.SysMenuController.save()','[{\"menuId\":44,\"parentId\":0,\"name\":\"栏位设置\",\"url\":\"equipment/accountfield\",\"perms\":\"equipment:accountfield:list,equipment:accountfield:info,equipment:accountfield:save,equipment:accountfield:update,equipment:accountfield:delete\",\"type\":1,\"icon\":\"mudedi\",\"orderNum\":0}]',8,'0:0:0:0:0:0:0:1','2021-08-20 22:44:53'),
(41,'admin','修改菜单','com.ckzy.modules.sys.controller.SysMenuController.update()','[{\"menuId\":44,\"parentId\":39,\"name\":\"栏位设置\",\"url\":\"equipment/accountfield\",\"perms\":\"equipment:accountfield:list,equipment:accountfield:info,equipment:accountfield:save,equipment:accountfield:update,equipment:accountfield:delete\",\"type\":1,\"icon\":\"mudedi\",\"orderNum\":0}]',28,'0:0:0:0:0:0:0:1','2021-08-20 22:45:09'),
(42,'admin','保存菜单','com.ckzy.modules.sys.controller.SysMenuController.save()','[{\"menuId\":45,\"parentId\":39,\"name\":\"设备台账\",\"url\":\"equipment/account\",\"perms\":\"equipment:account:list,equipment:account:info,equipment:account:save,equipment:account:update,equipment:account:delete\",\"type\":1,\"icon\":\"menu\",\"orderNum\":1}]',29,'0:0:0:0:0:0:0:1','2021-08-20 22:47:10'),
(43,'admin','删除菜单','com.ckzy.modules.sys.controller.SysMenuController.delete()','[31]',0,'0:0:0:0:0:0:0:1','2021-08-25 22:00:07'),
(44,'admin','删除菜单','com.ckzy.modules.sys.controller.SysMenuController.delete()','[33]',77,'0:0:0:0:0:0:0:1','2021-08-25 22:00:20'),
(45,'admin','删除菜单','com.ckzy.modules.sys.controller.SysMenuController.delete()','[32]',19,'0:0:0:0:0:0:0:1','2021-08-25 22:00:28'),
(46,'admin','删除菜单','com.ckzy.modules.sys.controller.SysMenuController.delete()','[31]',0,'0:0:0:0:0:0:0:1','2021-08-25 22:00:32'),
(47,'admin','删除菜单','com.ckzy.modules.sys.controller.SysMenuController.delete()','[34]',2,'0:0:0:0:0:0:0:1','2021-08-25 22:00:57'),
(48,'admin','删除菜单','com.ckzy.modules.sys.controller.SysMenuController.delete()','[40]',19,'0:0:0:0:0:0:0:1','2021-08-25 22:01:03'),
(49,'admin','删除菜单','com.ckzy.modules.sys.controller.SysMenuController.delete()','[41]',22,'0:0:0:0:0:0:0:1','2021-08-25 22:01:12'),
(50,'admin','删除菜单','com.ckzy.modules.sys.controller.SysMenuController.delete()','[34]',56,'0:0:0:0:0:0:0:1','2021-08-25 22:01:25'),
(51,'admin','删除菜单','com.ckzy.modules.sys.controller.SysMenuController.delete()','[31]',0,'0:0:0:0:0:0:0:1','2021-08-25 22:01:38'),
(52,'admin','删除菜单','com.ckzy.modules.sys.controller.SysMenuController.delete()','[38]',98,'0:0:0:0:0:0:0:1','2021-08-25 22:02:02'),
(53,'admin','删除菜单','com.ckzy.modules.sys.controller.SysMenuController.delete()','[31]',0,'0:0:0:0:0:0:0:1','2021-08-25 22:03:16'),
(54,'admin','删除菜单','com.ckzy.modules.sys.controller.SysMenuController.delete()','[31]',0,'0:0:0:0:0:0:0:1','2021-08-25 22:03:31'),
(55,'admin','删除菜单','com.ckzy.modules.sys.controller.SysMenuController.delete()','[42]',75,'0:0:0:0:0:0:0:1','2021-08-25 22:06:22'),
(56,'admin','保存菜单','com.ckzy.modules.sys.controller.SysMenuController.save()','[{\"menuId\":46,\"parentId\":37,\"name\":\"设备检修内容\",\"url\":\"equipment/maintenancecontent\",\"perms\":\"\",\"type\":1,\"icon\":\"\",\"orderNum\":0}]',9,'0:0:0:0:0:0:0:1','2021-08-25 22:07:35'),
(57,'admin','保存菜单','com.ckzy.modules.sys.controller.SysMenuController.save()','[{\"menuId\":47,\"parentId\":46,\"name\":\"查询\",\"url\":\"\",\"perms\":\"equipment:maintenancecontent:list,equipment:maintenancecontent:info\",\"type\":2,\"icon\":\"\",\"orderNum\":0}]',16,'0:0:0:0:0:0:0:1','2021-08-25 22:08:42'),
(58,'admin','保存菜单','com.ckzy.modules.sys.controller.SysMenuController.save()','[{\"menuId\":48,\"parentId\":46,\"name\":\"新增\",\"url\":\"\",\"perms\":\"equipment:maintenancecontent:save\",\"type\":2,\"icon\":\"\",\"orderNum\":0}]',50,'0:0:0:0:0:0:0:1','2021-08-25 22:09:15'),
(59,'admin','保存菜单','com.ckzy.modules.sys.controller.SysMenuController.save()','[{\"menuId\":49,\"parentId\":46,\"name\":\"修改\",\"url\":\"\",\"perms\":\"equipment:maintenancecontent:update\",\"type\":2,\"icon\":\"\",\"orderNum\":0}]',13,'0:0:0:0:0:0:0:1','2021-08-25 22:09:42'),
(60,'admin','保存菜单','com.ckzy.modules.sys.controller.SysMenuController.save()','[{\"menuId\":50,\"parentId\":46,\"name\":\"删除\",\"url\":\"\",\"perms\":\"equipment:maintenancecontent:delete\",\"type\":2,\"icon\":\"\",\"orderNum\":0}]',49,'0:0:0:0:0:0:0:1','2021-08-25 22:09:59'),
(61,'admin','修改菜单','com.ckzy.modules.sys.controller.SysMenuController.update()','[{\"menuId\":46,\"parentId\":37,\"name\":\"设备检修内容\",\"url\":\"equipment/maintenancecontent\",\"perms\":\"\",\"type\":1,\"icon\":\"zhedie\",\"orderNum\":0}]',30,'0:0:0:0:0:0:0:1','2021-08-25 22:10:59'),
(62,'admin','保存菜单','com.ckzy.modules.sys.controller.SysMenuController.save()','[{\"menuId\":51,\"parentId\":37,\"name\":\"设备年检计划\",\"url\":\"equipment/maintenance\",\"perms\":\"\",\"type\":1,\"icon\":\"tubiao\",\"orderNum\":0}]',14,'0:0:0:0:0:0:0:1','2021-08-26 21:18:26'),
(63,'admin','保存菜单','com.ckzy.modules.sys.controller.SysMenuController.save()','[{\"menuId\":52,\"parentId\":51,\"name\":\"查询\",\"url\":\"\",\"perms\":\"equipment:maintenance:list,equipment:maintenance:info\",\"type\":2,\"icon\":\"\",\"orderNum\":0}]',35,'0:0:0:0:0:0:0:1','2021-08-26 21:19:28'),
(64,'admin','保存菜单','com.ckzy.modules.sys.controller.SysMenuController.save()','[{\"menuId\":53,\"parentId\":51,\"name\":\"新增\",\"url\":\"\",\"perms\":\"equipment:maintenance:save\",\"type\":2,\"icon\":\"\",\"orderNum\":0}]',8,'0:0:0:0:0:0:0:1','2021-08-26 21:19:56'),
(65,'admin','保存菜单','com.ckzy.modules.sys.controller.SysMenuController.save()','[{\"menuId\":54,\"parentId\":51,\"name\":\"修改\",\"url\":\"\",\"perms\":\"equipment:maintenance:update\",\"type\":2,\"icon\":\"\",\"orderNum\":0}]',48,'0:0:0:0:0:0:0:1','2021-08-26 21:20:14'),
(66,'admin','保存菜单','com.ckzy.modules.sys.controller.SysMenuController.save()','[{\"menuId\":55,\"parentId\":51,\"name\":\"删除\",\"url\":\"\",\"perms\":\"equipment:maintenance:delete\",\"type\":2,\"icon\":\"\",\"orderNum\":0}]',83,'0:0:0:0:0:0:0:1','2021-08-26 21:20:31'),
(67,'admin','保存菜单','com.ckzy.modules.sys.controller.SysMenuController.save()','[{\"menuId\":66,\"parentId\":0,\"name\":\"设备备件\",\"url\":\"equitment\",\"perms\":\"\",\"type\":1,\"icon\":\"mudedi\",\"orderNum\":0}]',19,'0:0:0:0:0:0:0:1','2021-09-03 23:12:07'),
(68,'admin','修改菜单','com.ckzy.modules.sys.controller.SysMenuController.update()','[{\"menuId\":66,\"parentId\":0,\"name\":\"设备备件\",\"url\":\"equipment\",\"perms\":\"\",\"type\":1,\"icon\":\"mudedi\",\"orderNum\":0}]',17,'0:0:0:0:0:0:0:1','2021-09-03 23:12:52'),
(69,'admin','修改菜单','com.ckzy.modules.sys.controller.SysMenuController.update()','[{\"menuId\":66,\"parentId\":0,\"name\":\"设备/备件\",\"url\":\"equipment\",\"perms\":\"\",\"type\":1,\"icon\":\"mudedi\",\"orderNum\":0}]',16,'0:0:0:0:0:0:0:1','2021-09-03 23:13:03'),
(70,'admin','修改菜单','com.ckzy.modules.sys.controller.SysMenuController.update()','[{\"menuId\":66,\"parentId\":0,\"name\":\"设备/备件\",\"url\":\"equipment\",\"perms\":\"\",\"type\":0,\"icon\":\"mudedi\",\"orderNum\":0}]',10,'0:0:0:0:0:0:0:1','2021-09-03 23:13:40'),
(71,'admin','修改菜单','com.ckzy.modules.sys.controller.SysMenuController.update()','[{\"menuId\":56,\"parentId\":66,\"name\":\"设备管理\",\"url\":\"equipment/equipmentdevice\",\"type\":1,\"icon\":\"config\",\"orderNum\":6}]',20,'0:0:0:0:0:0:0:1','2021-09-03 23:13:59'),
(72,'admin','修改菜单','com.ckzy.modules.sys.controller.SysMenuController.update()','[{\"menuId\":61,\"parentId\":66,\"name\":\"备件管理\",\"url\":\"equipment/equipmentpart\",\"type\":1,\"icon\":\"config\",\"orderNum\":6}]',79,'0:0:0:0:0:0:0:1','2021-09-03 23:14:14'),
(73,'admin','保存菜单','com.ckzy.modules.sys.controller.SysMenuController.save()','[{\"menuId\":87,\"parentId\":0,\"name\":\"点检菜单\",\"url\":\"\",\"perms\":\"\",\"type\":0,\"icon\":\"admin\",\"orderNum\":0}]',14,'0:0:0:0:0:0:0:1','2021-09-04 23:13:54'),
(74,'admin','修改菜单','com.ckzy.modules.sys.controller.SysMenuController.update()','[{\"menuId\":67,\"parentId\":87,\"name\":\"点检基准\",\"url\":\"equipment/equipmentcheckbase\",\"type\":1,\"icon\":\"bianji\",\"orderNum\":6}]',75,'0:0:0:0:0:0:0:1','2021-09-04 23:14:36'),
(75,'admin','修改菜单','com.ckzy.modules.sys.controller.SysMenuController.update()','[{\"menuId\":72,\"parentId\":1,\"name\":\"点检信息\",\"url\":\"equipment/equipmentcheckinfo\",\"type\":1,\"icon\":\"dangdifill\",\"orderNum\":6}]',22,'0:0:0:0:0:0:0:1','2021-09-04 23:14:55'),
(76,'admin','修改菜单','com.ckzy.modules.sys.controller.SysMenuController.update()','[{\"menuId\":77,\"parentId\":1,\"name\":\"修改记录\",\"url\":\"equipment/equipmentcheckmodify\",\"type\":1,\"icon\":\"daohang\",\"orderNum\":6}]',27,'0:0:0:0:0:0:0:1','2021-09-04 23:15:16'),
(77,'admin','修改菜单','com.ckzy.modules.sys.controller.SysMenuController.update()','[{\"menuId\":82,\"parentId\":1,\"name\":\"点检结果\",\"url\":\"equipment/equipmentcheckresult\",\"type\":1,\"icon\":\"duanxin\",\"orderNum\":6}]',35,'0:0:0:0:0:0:0:1','2021-09-04 23:15:31'),
(78,'admin','修改菜单','com.ckzy.modules.sys.controller.SysMenuController.update()','[{\"menuId\":72,\"parentId\":87,\"name\":\"点检信息\",\"url\":\"equipment/equipmentcheckinfo\",\"type\":1,\"icon\":\"dangdifill\",\"orderNum\":6}]',12,'0:0:0:0:0:0:0:1','2021-09-04 23:15:57'),
(79,'admin','修改菜单','com.ckzy.modules.sys.controller.SysMenuController.update()','[{\"menuId\":77,\"parentId\":87,\"name\":\"修改记录\",\"url\":\"equipment/equipmentcheckmodify\",\"type\":1,\"icon\":\"daohang\",\"orderNum\":6}]',8,'0:0:0:0:0:0:0:1','2021-09-04 23:16:10'),
(80,'admin','修改菜单','com.ckzy.modules.sys.controller.SysMenuController.update()','[{\"menuId\":82,\"parentId\":87,\"name\":\"点检结果\",\"url\":\"equipment/equipmentcheckresult\",\"type\":1,\"icon\":\"duanxin\",\"orderNum\":6}]',109,'0:0:0:0:0:0:0:1','2021-09-04 23:16:21'),
(81,'admin','保存菜单','com.ckzy.modules.sys.controller.SysMenuController.save()','[{\"menuId\":88,\"parentId\":0,\"name\":\"产线监控\",\"url\":\"\",\"perms\":\"\",\"type\":0,\"icon\":\"editor\",\"orderNum\":0}]',25,'0:0:0:0:0:0:0:1','2021-09-13 22:14:25'),
(82,'admin','保存菜单','com.ckzy.modules.sys.controller.SysMenuController.save()','[{\"menuId\":89,\"parentId\":0,\"name\":\"产线监控\",\"url\":\"view/view\",\"perms\":\"\",\"type\":1,\"icon\":\"editor\",\"orderNum\":0}]',16,'0:0:0:0:0:0:0:1','2021-09-13 22:17:25'),
(83,'admin','修改菜单','com.ckzy.modules.sys.controller.SysMenuController.update()','[{\"menuId\":89,\"parentId\":88,\"name\":\"产线监控\",\"url\":\"view/view\",\"perms\":\"\",\"type\":1,\"icon\":\"editor\",\"orderNum\":0}]',43,'0:0:0:0:0:0:0:1','2021-09-13 22:17:35'),
(84,'admin','保存菜单','com.ckzy.modules.sys.controller.SysMenuController.save()','[{\"menuId\":90,\"parentId\":87,\"name\":\"点检计划\",\"url\":\"equipment/equipmentcheck\",\"perms\":\"\",\"type\":1,\"icon\":\"\",\"orderNum\":0}]',75,'0:0:0:0:0:0:0:1','2021-09-25 21:27:11'),
(85,'admin','修改菜单','com.ckzy.modules.sys.controller.SysMenuController.update()','[{\"menuId\":90,\"parentId\":87,\"name\":\"点检计划\",\"url\":\"equipment/equipmentcheck\",\"perms\":\"\",\"type\":1,\"icon\":\"suoding\",\"orderNum\":0}]',32,'0:0:0:0:0:0:0:1','2021-10-16 13:59:19'),
(86,'admin','删除菜单','com.ckzy.modules.sys.controller.SysMenuController.delete()','[90]',230,'0:0:0:0:0:0:0:1','2021-10-16 16:02:07'),
(87,'admin','删除用户','com.ckzy.modules.sys.controller.SysUserController.delete()','[[2]]',42,'0:0:0:0:0:0:0:1','2021-10-16 16:02:27'),
(88,'admin','修改菜单','com.ckzy.modules.sys.controller.SysMenuController.update()','[{\"menuId\":82,\"parentId\":87,\"name\":\"点检结果\",\"url\":\"equipment/equipmentcheckresult\",\"type\":1,\"icon\":\"duanxin\",\"orderNum\":2}]',26,'0:0:0:0:0:0:0:1','2021-10-16 16:27:04'),
(89,'admin','修改菜单','com.ckzy.modules.sys.controller.SysMenuController.update()','[{\"menuId\":56,\"parentId\":66,\"name\":\"设备清单\",\"url\":\"equipment/equipmentdevice\",\"type\":1,\"icon\":\"config\",\"orderNum\":6}]',36,'0:0:0:0:0:0:0:1','2021-10-25 21:47:02'),
(90,'admin','修改菜单','com.ckzy.modules.sys.controller.SysMenuController.update()','[{\"menuId\":61,\"parentId\":66,\"name\":\"备件清单\",\"url\":\"equipment/equipmentpart\",\"type\":1,\"icon\":\"config\",\"orderNum\":6}]',15,'0:0:0:0:0:0:0:1','2021-10-25 21:47:12'),
(91,'admin','修改菜单','com.ckzy.modules.sys.controller.SysMenuController.update()','[{\"menuId\":66,\"parentId\":0,\"name\":\"备件管理\",\"url\":\"equipment\",\"perms\":\"\",\"type\":0,\"icon\":\"mudedi\",\"orderNum\":0}]',33,'0:0:0:0:0:0:0:1','2021-10-25 21:47:40'),
(92,'admin','修改菜单','com.ckzy.modules.sys.controller.SysMenuController.update()','[{\"menuId\":66,\"parentId\":0,\"name\":\"备件管理\",\"url\":\"equipment\",\"perms\":\"\",\"type\":0,\"icon\":\"mudedi\",\"orderNum\":4}]',42,'0:0:0:0:0:0:0:1','2021-10-25 21:48:17'),
(93,'admin','修改菜单','com.ckzy.modules.sys.controller.SysMenuController.update()','[{\"menuId\":37,\"parentId\":0,\"name\":\"检修菜单\",\"url\":\"\",\"perms\":\"\",\"type\":0,\"icon\":\"menu\",\"orderNum\":3}]',20,'0:0:0:0:0:0:0:1','2021-10-25 21:48:45'),
(94,'admin','修改菜单','com.ckzy.modules.sys.controller.SysMenuController.update()','[{\"menuId\":87,\"parentId\":0,\"name\":\"点检菜单\",\"url\":\"\",\"perms\":\"\",\"type\":0,\"icon\":\"admin\",\"orderNum\":1}]',10,'0:0:0:0:0:0:0:1','2021-10-25 21:48:51'),
(95,'admin','修改菜单','com.ckzy.modules.sys.controller.SysMenuController.update()','[{\"menuId\":37,\"parentId\":0,\"name\":\"检修菜单\",\"url\":\"\",\"perms\":\"\",\"type\":0,\"icon\":\"menu\",\"orderNum\":2}]',9,'0:0:0:0:0:0:0:1','2021-10-25 21:48:57'),
(96,'admin','修改菜单','com.ckzy.modules.sys.controller.SysMenuController.update()','[{\"menuId\":66,\"parentId\":0,\"name\":\"备件管理\",\"url\":\"equipment\",\"perms\":\"\",\"type\":0,\"icon\":\"mudedi\",\"orderNum\":5}]',8,'0:0:0:0:0:0:0:1','2021-10-25 21:49:12'),
(97,'admin','修改菜单','com.ckzy.modules.sys.controller.SysMenuController.update()','[{\"menuId\":93,\"parentId\":0,\"name\":\"数据采集\",\"url\":\"\",\"perms\":\"\",\"type\":0,\"icon\":\"zonghe\",\"orderNum\":6}]',10,'0:0:0:0:0:0:0:1','2021-10-25 21:49:17'),
(98,'admin','修改菜单','com.ckzy.modules.sys.controller.SysMenuController.update()','[{\"menuId\":89,\"parentId\":88,\"name\":\"产线大屏\",\"url\":\"view/view\",\"perms\":\"\",\"type\":1,\"icon\":\"editor\",\"orderNum\":0}]',80,'0:0:0:0:0:0:0:1','2021-10-25 21:49:54'),
(99,'admin','保存菜单','com.ckzy.modules.sys.controller.SysMenuController.save()','[{\"menuId\":110,\"parentId\":0,\"name\":\"分析报表\",\"url\":\"\",\"perms\":\"\",\"type\":0,\"icon\":\"role\",\"orderNum\":0}]',139,'0:0:0:0:0:0:0:1','2021-10-27 21:59:59'),
(100,'admin','保存菜单','com.ckzy.modules.sys.controller.SysMenuController.save()','[{\"menuId\":111,\"parentId\":110,\"name\":\"设备稼动率\",\"url\":\"charts/activation\",\"perms\":\"\",\"type\":1,\"icon\":\"oss\",\"orderNum\":0}]',49,'0:0:0:0:0:0:0:1','2021-10-27 22:02:36'),
(101,'admin','修改菜单','com.ckzy.modules.sys.controller.SysMenuController.update()','[{\"menuId\":67,\"parentId\":87,\"name\":\"点检计划\",\"url\":\"equipment/equipmentcheckbase\",\"type\":1,\"icon\":\"bianji\",\"orderNum\":6}]',53,'0:0:0:0:0:0:0:1','2021-10-27 22:57:53'),
(102,'admin','修改菜单','com.ckzy.modules.sys.controller.SysMenuController.update()','[{\"menuId\":111,\"parentId\":110,\"name\":\"故障分析\",\"url\":\"charts/activation\",\"perms\":\"\",\"type\":1,\"icon\":\"oss\",\"orderNum\":0}]',57,'0:0:0:0:0:0:0:1','2021-10-27 23:46:08'),
(103,'admin','修改菜单','com.ckzy.modules.sys.controller.SysMenuController.update()','[{\"menuId\":46,\"parentId\":37,\"name\":\"设备检修计划\",\"url\":\"equipment/maintenancecontent\",\"perms\":\"\",\"type\":1,\"icon\":\"zhedie\",\"orderNum\":0}]',17,'0:0:0:0:0:0:0:1','2021-10-30 08:53:10'),
(104,'admin','修改菜单','com.ckzy.modules.sys.controller.SysMenuController.update()','[{\"menuId\":51,\"parentId\":37,\"name\":\"设备年检结果\",\"url\":\"equipment/maintenance\",\"perms\":\"\",\"type\":1,\"icon\":\"tubiao\",\"orderNum\":0}]',11,'0:0:0:0:0:0:0:1','2021-10-30 08:53:24');

/*Table structure for table `sys_menu` */

DROP TABLE IF EXISTS `sys_menu`;

CREATE TABLE `sys_menu` (
  `menu_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `parent_id` bigint(20) DEFAULT NULL COMMENT '父菜单ID，一级菜单为0',
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '菜单名称',
  `url` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '菜单URL',
  `perms` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '授权(多个用逗号分隔，如：user:list,user:create)',
  `type` int(11) DEFAULT NULL COMMENT '类型   0：目录   1：菜单   2：按钮',
  `icon` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '菜单图标',
  `order_num` int(11) DEFAULT NULL COMMENT '排序',
  PRIMARY KEY (`menu_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=112 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='菜单管理';

/*Data for the table `sys_menu` */

insert  into `sys_menu`(`menu_id`,`parent_id`,`name`,`url`,`perms`,`type`,`icon`,`order_num`) values 
(1,0,'系统管理',NULL,NULL,0,'system',99),
(2,1,'管理员列表','sys/user',NULL,1,'admin',1),
(3,1,'角色管理','sys/role',NULL,1,'role',2),
(4,1,'菜单管理','sys/menu',NULL,1,'menu',3),
(5,1,'SQL监控','http://localhost:8080/renren-fast/druid/sql.html',NULL,1,'sql',4),
(6,1,'定时任务','job/schedule',NULL,1,'job',5),
(7,6,'查看',NULL,'sys:schedule:list,sys:schedule:info',2,NULL,0),
(8,6,'新增',NULL,'sys:schedule:save',2,NULL,0),
(9,6,'修改',NULL,'sys:schedule:update',2,NULL,0),
(10,6,'删除',NULL,'sys:schedule:delete',2,NULL,0),
(11,6,'暂停',NULL,'sys:schedule:pause',2,NULL,0),
(12,6,'恢复',NULL,'sys:schedule:resume',2,NULL,0),
(13,6,'立即执行',NULL,'sys:schedule:run',2,NULL,0),
(14,6,'日志列表',NULL,'sys:schedule:log',2,NULL,0),
(15,2,'查看',NULL,'sys:user:list,sys:user:info',2,NULL,0),
(16,2,'新增',NULL,'sys:user:save,sys:role:select',2,NULL,0),
(17,2,'修改',NULL,'sys:user:update,sys:role:select',2,NULL,0),
(18,2,'删除',NULL,'sys:user:delete',2,NULL,0),
(19,3,'查看',NULL,'sys:role:list,sys:role:info',2,NULL,0),
(20,3,'新增',NULL,'sys:role:save,sys:menu:list',2,NULL,0),
(21,3,'修改',NULL,'sys:role:update,sys:menu:list',2,NULL,0),
(22,3,'删除',NULL,'sys:role:delete',2,NULL,0),
(23,4,'查看',NULL,'sys:menu:list,sys:menu:info',2,NULL,0),
(24,4,'新增',NULL,'sys:menu:save,sys:menu:select',2,NULL,0),
(25,4,'修改',NULL,'sys:menu:update,sys:menu:select',2,NULL,0),
(26,4,'删除',NULL,'sys:menu:delete',2,NULL,0),
(27,1,'参数管理','sys/config','sys:config:list,sys:config:info,sys:config:save,sys:config:update,sys:config:delete',1,'config',6),
(29,1,'系统日志','sys/log','sys:log:list',1,'log',7),
(30,1,'文件上传','oss/oss','sys:oss:all',1,'oss',6),
(37,0,'检修菜单','','',0,'menu',2),
(39,0,'设备台账','','',0,'log',4),
(44,39,'栏位设置','equipment/accountfield','equipment:accountfield:list,equipment:accountfield:info,equipment:accountfield:save,equipment:accountfield:update,equipment:accountfield:delete',1,'mudedi',0),
(45,39,'设备台账','equipment/account','equipment:account:list,equipment:account:info,equipment:account:save,equipment:account:update,equipment:account:delete',1,'menu',1),
(46,37,'设备检修计划','equipment/maintenancecontent','',1,'zhedie',0),
(47,46,'查询','','equipment:maintenancecontent:list,equipment:maintenancecontent:info',2,'',0),
(48,46,'新增','','equipment:maintenancecontent:save',2,'',0),
(49,46,'修改','','equipment:maintenancecontent:update',2,'',0),
(50,46,'删除','','equipment:maintenancecontent:delete',2,'',0),
(51,37,'设备年检结果','equipment/maintenance','',1,'tubiao',0),
(52,51,'查询','','equipment:maintenance:list,equipment:maintenance:info',2,'',0),
(53,51,'新增','','equipment:maintenance:save',2,'',0),
(54,51,'修改','','equipment:maintenance:update',2,'',0),
(55,51,'删除','','equipment:maintenance:delete',2,'',0),
(56,66,'设备清单','equipment/equipmentdevice',NULL,1,'config',6),
(57,56,'查看',NULL,'equipment:equipmentdevice:list,equipment:equipmentdevice:info',2,NULL,6),
(58,56,'新增',NULL,'equipment:equipmentdevice:save',2,NULL,6),
(59,56,'修改',NULL,'equipment:equipmentdevice:update',2,NULL,6),
(60,56,'删除',NULL,'equipment:equipmentdevice:delete',2,NULL,6),
(61,66,'备件清单','equipment/equipmentpart',NULL,1,'config',6),
(62,61,'查看',NULL,'equipment:equipmentpart:list,equipment:equipmentpart:info',2,NULL,6),
(63,61,'新增',NULL,'equipment:equipmentpart:save',2,NULL,6),
(64,61,'修改',NULL,'equipment:equipmentpart:update',2,NULL,6),
(65,61,'删除',NULL,'equipment:equipmentpart:delete',2,NULL,6),
(66,0,'备件管理','equipment','',0,'mudedi',5),
(67,87,'点检计划','equipment/equipmentcheckbase',NULL,1,'bianji',6),
(68,67,'查看',NULL,'equipment:equipmentcheckbase:list,equipment:equipmentcheckbase:info',2,NULL,6),
(69,67,'新增',NULL,'equipment:equipmentcheckbase:save',2,NULL,6),
(70,67,'修改',NULL,'equipment:equipmentcheckbase:update',2,NULL,6),
(71,67,'删除',NULL,'equipment:equipmentcheckbase:delete',2,NULL,6),
(72,87,'点检信息','equipment/equipmentcheckinfo',NULL,1,'dangdifill',6),
(73,72,'查看',NULL,'equipment:equipmentcheckinfo:list,equipment:equipmentcheckinfo:info',2,NULL,6),
(74,72,'新增',NULL,'equipment:equipmentcheckinfo:save',2,NULL,6),
(75,72,'修改',NULL,'equipment:equipmentcheckinfo:update',2,NULL,6),
(76,72,'删除',NULL,'equipment:equipmentcheckinfo:delete',2,NULL,6),
(77,87,'修改记录','equipment/equipmentcheckmodify',NULL,1,'daohang',6),
(78,77,'查看',NULL,'equipment:equipmentcheckmodify:list,equipment:equipmentcheckmodify:info',2,NULL,6),
(79,77,'新增',NULL,'equipment:equipmentcheckmodify:save',2,NULL,6),
(80,77,'修改',NULL,'equipment:equipmentcheckmodify:update',2,NULL,6),
(81,77,'删除',NULL,'equipment:equipmentcheckmodify:delete',2,NULL,6),
(82,87,'点检结果','equipment/equipmentcheckresult',NULL,1,'duanxin',2),
(83,82,'查看',NULL,'equipment:equipmentcheckresult:list,equipment:equipmentcheckresult:info',2,NULL,6),
(84,82,'新增',NULL,'equipment:equipmentcheckresult:save',2,NULL,6),
(85,82,'修改',NULL,'equipment:equipmentcheckresult:update',2,NULL,6),
(86,82,'删除',NULL,'equipment:equipmentcheckresult:delete',2,NULL,6),
(87,0,'点检菜单','','',0,'admin',1),
(88,0,'产线监控','','',0,'editor',0),
(89,88,'产线大屏','view/view','',1,'editor',0),
(90,37,'设备检修工时','equipment/workingHour','equipment:workingHour:list',1,'job',3),
(91,1,'数据字典','equipment/dict','',1,'tubiao',0),
(92,91,'查询','','equipment:dict:list,equipment:dict:info',2,'',0),
(93,0,'数据采集','','',0,'zonghe',6),
(94,93,'过点信息','equipment/pointinformation','',1,'dangdifill',1),
(95,94,'列表','','equipment:pointinformation:list,equipment:pointinformation:info',2,'',0),
(96,93,'弧焊设备','equipment/arcweldingdata','',1,'sousuo',2),
(97,96,'列表','','equipment:arcweldingdata:list,equipment:arcweldingdata:info',2,'',0),
(98,93,'CNC信息','equipment/cncdata','',1,'daohang',3),
(99,98,'列表','','equipment:cncdata:list,equipment:cncdata:info',2,'',0),
(100,93,'尺寸检测','equipment/dimensiondetectiondata','',1,'config',4),
(101,100,'列表','','equipment:dimensiondetectiondata:list,equipment:dimensiondetectiondata:info',2,'',0),
(102,93,'拉铆信息','equipment/pullrivetingdata','',1,'geren',5),
(103,102,'列表','','equipment:pullrivetingdata:list,equipment:pullrivetingdata:info',2,'',0),
(104,93,'涂胶信息','equipment/gluingdata','',1,'oss',6),
(105,104,'列表','','equipment:gluingdata:list,equipment:gluingdata:info',2,'',0),
(106,93,'FDS信息','equipment/fdsdata','',1,'shoucangfill',7),
(107,106,'列表','','equipment:fdsdata:list,equipment:fdsdata:info',2,'',0),
(108,93,'侧漏检测','equipment/airtightnessdata','',1,'tixing',8),
(109,108,'列表','','equipment:airtightnessdata:list,equipment:airtightnessdata:info',2,'',0),
(110,0,'分析报表','','',0,'role',0),
(111,110,'故障分析','charts/activation','',1,'oss',0);

/*Table structure for table `sys_oss` */

DROP TABLE IF EXISTS `sys_oss`;

CREATE TABLE `sys_oss` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `url` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT 'URL地址',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='文件上传';

/*Data for the table `sys_oss` */

/*Table structure for table `sys_role` */

DROP TABLE IF EXISTS `sys_role`;

CREATE TABLE `sys_role` (
  `role_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `role_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '角色名称',
  `remark` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '备注',
  `create_user_id` bigint(20) DEFAULT NULL COMMENT '创建者ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`role_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='角色';

/*Data for the table `sys_role` */

insert  into `sys_role`(`role_id`,`role_name`,`remark`,`create_user_id`,`create_time`) values 
(1,'工段长','',1,'2021-08-13 23:06:44');

/*Table structure for table `sys_role_menu` */

DROP TABLE IF EXISTS `sys_role_menu`;

CREATE TABLE `sys_role_menu` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `role_id` bigint(20) DEFAULT NULL COMMENT '角色ID',
  `menu_id` bigint(20) DEFAULT NULL COMMENT '菜单ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='角色与菜单对应关系';

/*Data for the table `sys_role_menu` */

insert  into `sys_role_menu`(`id`,`role_id`,`menu_id`) values 
(1,1,31),
(7,1,37),
(10,1,39),
(12,1,-666666);

/*Table structure for table `sys_user` */

DROP TABLE IF EXISTS `sys_user`;

CREATE TABLE `sys_user` (
  `user_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户名',
  `password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '密码',
  `salt` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '盐',
  `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '邮箱',
  `mobile` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '手机号',
  `status` tinyint(4) DEFAULT NULL COMMENT '状态  0：禁用   1：正常',
  `create_user_id` bigint(20) DEFAULT NULL COMMENT '创建者ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`user_id`) USING BTREE,
  UNIQUE KEY `username` (`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='系统用户';

/*Data for the table `sys_user` */

insert  into `sys_user`(`user_id`,`username`,`password`,`salt`,`email`,`mobile`,`status`,`create_user_id`,`create_time`) values 
(1,'admin','9ec9750e709431dad22365cabc5c625482e574c74adaebba7dd02f1129e4ce1d','YzcmCZNvbXocrsz9dm8e','[email protected]','13612345678',1,1,'2016-11-11 11:11:11');

/*Table structure for table `sys_user_role` */

DROP TABLE IF EXISTS `sys_user_role`;

CREATE TABLE `sys_user_role` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) DEFAULT NULL COMMENT '用户ID',
  `role_id` bigint(20) DEFAULT NULL COMMENT '角色ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='用户与角色对应关系';

/*Data for the table `sys_user_role` */

insert  into `sys_user_role`(`id`,`user_id`,`role_id`) values 
(1,2,1);

/*Table structure for table `sys_user_token` */

DROP TABLE IF EXISTS `sys_user_token`;

CREATE TABLE `sys_user_token` (
  `user_id` bigint(20) NOT NULL,
  `token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'token',
  `expire_time` datetime DEFAULT NULL COMMENT '过期时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`user_id`) USING BTREE,
  UNIQUE KEY `token` (`token`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='系统用户Token';

/*Data for the table `sys_user_token` */

insert  into `sys_user_token`(`user_id`,`token`,`expire_time`,`update_time`) values 
(1,'7a7ca6494779af9b176374083a708cf9','2021-10-31 21:20:38','2021-10-31 09:20:38'),
(2,'b74d5262453c76a907a2aa290322e7a9','2021-08-14 11:08:00','2021-08-13 23:08:00');

/*Table structure for table `tb_air_tightness_data` */

DROP TABLE IF EXISTS `tb_air_tightness_data`;

CREATE TABLE `tb_air_tightness_data` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `workstation` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '工位',
  `PRODUCT_CODE` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '产品二维码',
  `LC_NO` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '测漏设备编号',
  `WORKING_TIME` decimal(3,2) DEFAULT NULL COMMENT '测漏时长',
  `LC_VALUE` decimal(3,2) DEFAULT NULL COMMENT '泄漏量',
  `PRO_NUMBER` tinyint(3) DEFAULT NULL COMMENT '程序号',
  `CHECK_RESULT` tinyint(3) DEFAULT NULL COMMENT '测漏结果',
  `version` bigint(20) DEFAULT '1' COMMENT '版本',
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '逻辑删除(1:已删除，0:未删除)',
  `created_user` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '创建用户',
  `created_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_user` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '更新用户',
  `updated_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='FDS数据表';

/*Data for the table `tb_air_tightness_data` */

/*Table structure for table `tb_arc_welding_data` */

DROP TABLE IF EXISTS `tb_arc_welding_data`;

CREATE TABLE `tb_arc_welding_data` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `workstation` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '工位',
  `PRODUCT_CODE` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '产品二维码',
  `CURRENT` decimal(5,2) DEFAULT NULL COMMENT '焊接电流',
  `VOLT` decimal(5,2) DEFAULT NULL COMMENT '焊接电压',
  `version` bigint(20) DEFAULT '1' COMMENT '版本',
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '逻辑删除(1:已删除，0:未删除)',
  `created_user` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '创建用户',
  `created_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_user` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '更新用户',
  `updated_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='弧焊激光数据表';

/*Data for the table `tb_arc_welding_data` */

insert  into `tb_arc_welding_data`(`id`,`workstation`,`PRODUCT_CODE`,`CURRENT`,`VOLT`,`version`,`is_deleted`,`created_user`,`created_time`,`updated_user`,`updated_time`) values 
(9,'op10','123456',2.35,230.00,1,0,'sys','2021-09-21 02:01:37','sys','2021-09-21 02:01:37');

/*Table structure for table `tb_cnc_data` */

DROP TABLE IF EXISTS `tb_cnc_data`;

CREATE TABLE `tb_cnc_data` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `workstation` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '工位',
  `PRODUCT_CODE` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '产品二维码',
  `PRO_NUMBER` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '程序号',
  `version` bigint(20) DEFAULT '1' COMMENT '版本',
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '逻辑删除(1:已删除，0:未删除)',
  `created_user` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '创建用户',
  `created_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_user` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '更新用户',
  `updated_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='CNC数据表';

/*Data for the table `tb_cnc_data` */

insert  into `tb_cnc_data`(`id`,`workstation`,`PRODUCT_CODE`,`PRO_NUMBER`,`version`,`is_deleted`,`created_user`,`created_time`,`updated_user`,`updated_time`) values 
(6,'op50','256935','2',1,0,'sys','2021-09-22 23:00:01','sys','2021-09-22 23:00:01');

/*Table structure for table `tb_device_check` */

DROP TABLE IF EXISTS `tb_device_check`;

CREATE TABLE `tb_device_check` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `station` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '工位',
  `device_name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '设备名称',
  `check_count` int(11) DEFAULT NULL COMMENT '维修次数',
  `last_time` datetime DEFAULT NULL COMMENT '最近维修时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='设备检修次数表';

/*Data for the table `tb_device_check` */

/*Table structure for table `tb_dict` */

DROP TABLE IF EXISTS `tb_dict`;

CREATE TABLE `tb_dict` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `parent_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '上级id',
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '名称',
  `value` int(11) DEFAULT NULL COMMENT '值',
  `dict_code` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '编码',
  `created_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标记（0:不可用 1:可用）',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_parent_id_value` (`parent_id`,`value`) USING BTREE,
  KEY `idx_parent_id` (`parent_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=130016 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='数据字典';

/*Data for the table `tb_dict` */

insert  into `tb_dict`(`id`,`parent_id`,`name`,`value`,`dict_code`,`created_time`,`updated_time`,`is_deleted`) values 
(1,0,'全部分类',NULL,'ROOT','2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(20000,1,'点焊机器人工作站',NULL,'dhjqrgzz','2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(20001,20000,'程序',1,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(20002,20000,'机器人原点',2,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(20003,20000,'机器人外部整体',3,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(20004,20000,'管线',4,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(20005,20000,'机器人控制箱',5,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(20006,20000,'PLC控制箱',6,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(20007,20000,'触摸屏',7,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(20008,20000,'围栏',8,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(20009,20000,'按钮板',9,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(20010,20000,'水气单元',10,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(20011,20000,'机器人焊钳',11,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(20012,20000,'修磨器',12,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(20013,20000,'焊接控制箱',13,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(30000,1,'分体式手工焊钳',NULL,'ftssghq','2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(30001,30000,'焊钳表面清洁',1,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(30002,30000,'电极杆、冷却水芯',2,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(30003,30000,'检查绝缘垫',3,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(30004,30000,'转盘',4,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(30005,30000,'静钳体',5,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(30006,30000,'动钳体',6,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(30007,30000,'主电缆、副缆',7,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(30008,30000,'气缸',8,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(30009,30000,'换向阀',9,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(30010,30000,'水气单元',10,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(30011,30000,'手柄',11,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(30012,30000,'控制器',12,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(40000,1,'固定点焊机',NULL,'gddhj','2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(40001,40000,'电极臂、冷却水芯',1,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(40002,40000,'检查绝缘垫',2,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(40003,40000,'气缸',3,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(40004,40000,'铜排',4,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(40005,40000,'换向阀',5,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(40006,40000,'水气单元',6,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(40007,40000,'启动按钮、脚踏开关',7,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(40008,40000,'控制器',8,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(50000,1,'弧焊机器人工作站',NULL,'hhjqrgzz','2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(50001,50000,'程序',1,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(50002,50000,'机器人原点',2,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(50003,50000,'机器人外部整体',3,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(50004,50000,'管线',4,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(50005,50000,'机器人控制箱',5,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(50006,50000,'PLC控制箱',6,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(50007,50000,'触摸屏',7,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(50008,50000,'围栏',8,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(50009,50000,'按钮板',9,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(50010,50000,'水气单元',10,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(50011,50000,'机器人焊枪',11,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(50012,50000,'清枪机',12,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(50013,50000,'送丝机',13,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(50014,50000,'弧焊机',14,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(60000,1,'激光打标机',NULL,'jgdbj','2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(60001,60000,'启动按钮',1,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(60002,60000,'换向阀',2,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(60003,60000,'滑轨、夹具小车',3,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(60004,60000,'激光器',4,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(60005,60000,'显示屏',5,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(60006,60000,'管线',6,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(60007,60000,'控制器',7,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(70000,1,'铝合金弧焊机器人工作站',NULL,'lhjhhjqrgzz','2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(70001,70000,'程序',1,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(70002,70000,'机器人原点',2,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(70003,70000,'机器人外部整体',3,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(70004,70000,'管线',4,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(70005,70000,'机器人控制箱',5,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(70006,70000,'PLC控制箱',6,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(70007,70000,'触摸屏',7,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(70008,70000,'围栏',8,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(70009,70000,'按钮板',9,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(70010,70000,'水气单元',10,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(70011,70000,'机器人焊枪',11,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(70012,70000,'清枪机',12,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(70013,70000,'送丝机',13,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(70014,70000,'弧焊机',14,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(80000,1,'手工弧焊机',NULL,'sghhj','2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(80001,80000,'管线',1,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(80002,80000,'送丝机',2,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(80003,80000,'弧焊机',3,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(90000,1,'手工螺柱焊机',NULL,'sglzhj','2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(90001,90000,'螺柱焊枪',1,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(90002,90000,'导向套',2,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(90003,90000,'管线',3,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(90004,90000,'控制器',4,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(100000,1,'压铆（装）机',NULL,'ymzj','2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(100001,100000,'启动按钮',1,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(100002,100000,'换向阀',2,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(100003,100000,'上、下模',3,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(100004,100000,'增压缸',4,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(100005,100000,'管线',5,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(100006,100000,'控制器',6,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(110000,1,'液压旋铆机',NULL,'yyxmj','2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(110001,110000,'启动按钮',1,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(110002,110000,'换向阀',2,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(110003,110000,'上、下模',3,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(110004,110000,'增压缸',4,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(110005,110000,'管线',5,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(110006,110000,'控制器',6,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(120000,1,'一体化手工焊钳',NULL,'ythsghq','2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(120001,120000,'焊钳表面清洁',1,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(120002,120000,'电极杆、冷却水芯',2,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(120003,120000,'检查绝缘垫',3,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(120004,120000,'转盘',4,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(120005,120000,'静钳体',5,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(120006,120000,'变压器',6,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(120007,120000,'动钳体',7,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(120008,120000,'铜排',8,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(120009,120000,'气缸',9,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(120010,120000,'换向阀',10,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(120011,120000,'水气连接块',11,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(120012,120000,'手柄',12,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(120013,120000,'吊挂',13,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(120014,120000,'控制器',14,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(130000,1,'自动打点机',NULL,'zdddj','2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(130001,130000,'焊钳表面清洁',1,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(130002,130000,'电极杆、冷却水芯',2,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(130003,130000,'检查绝缘垫',3,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(130004,130000,'控制按钮',4,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(130005,130000,'静钳体',5,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(130006,130000,'动钳体',6,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(130007,130000,'主电缆、副缆',7,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(130008,130000,'气缸',8,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(130009,130000,'换向阀',9,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(130010,130000,'水气单元',10,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(130011,130000,'启动开关',11,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(130012,130000,'触摸屏',12,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(130013,130000,'控制器',13,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(130014,130000,'XYZ轴',14,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0),
(130015,130000,'围栏',15,NULL,'2021-09-11 17:19:40','2021-09-11 17:19:40',0);

/*Table structure for table `tb_dimension_detection_data` */

DROP TABLE IF EXISTS `tb_dimension_detection_data`;

CREATE TABLE `tb_dimension_detection_data` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `workstation` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '工位',
  `PRODUCT_CODE` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '产品二维码',
  `SIZE_NO` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '具体尺寸值',
  `ERR_NO` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '错误点代号',
  `CHECK_RESULT` tinyint(3) DEFAULT NULL COMMENT '检测结果',
  `version` bigint(20) DEFAULT '1' COMMENT '版本',
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '逻辑删除(1:已删除，0:未删除)',
  `created_user` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '创建用户',
  `created_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_user` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '更新用户',
  `updated_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='尺寸检测数据表';

/*Data for the table `tb_dimension_detection_data` */

/*Table structure for table `tb_estop` */

DROP TABLE IF EXISTS `tb_estop`;

CREATE TABLE `tb_estop` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `station` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '工位',
  `device_name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '设备名称',
  `start_time` datetime DEFAULT NULL COMMENT '停线开始时间',
  `end_time` datetime DEFAULT NULL COMMENT '停线结束时间',
  `total` int(11) DEFAULT NULL COMMENT '停线时间(分)',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='设备急停表';

/*Data for the table `tb_estop` */

/*Table structure for table `tb_fault_msg` */

DROP TABLE IF EXISTS `tb_fault_msg`;

CREATE TABLE `tb_fault_msg` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `station` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '工位',
  `device_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '设备名称',
  `start_time` timestamp NOT NULL COMMENT '故障开始时间',
  `end_time` timestamp NULL DEFAULT NULL COMMENT '故障结束时间',
  `stop_time` timestamp NULL DEFAULT NULL COMMENT '停机时间',
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '故障原因',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='故障信息表';

/*Data for the table `tb_fault_msg` */

/*Table structure for table `tb_fds_data` */

DROP TABLE IF EXISTS `tb_fds_data`;

CREATE TABLE `tb_fds_data` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `workstation` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '工位',
  `PRODUCT_CODE` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '产品二维码',
  `FDS_EQUNO` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'FDS设备编号',
  `NO` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '螺钉编号',
  `WORKING_TIME` decimal(3,2) DEFAULT NULL COMMENT 'FDS时长',
  `TORGUE_FORCE` decimal(3,2) DEFAULT NULL COMMENT 'FDS扭力',
  `CHECK_RESULT` tinyint(3) DEFAULT NULL COMMENT 'FDS检测结果',
  `version` bigint(20) DEFAULT '1' COMMENT '版本',
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '逻辑删除(1:已删除，0:未删除)',
  `created_user` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '创建用户',
  `created_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_user` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '更新用户',
  `updated_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='FDS数据表';

/*Data for the table `tb_fds_data` */

/*Table structure for table `tb_gluing_data` */

DROP TABLE IF EXISTS `tb_gluing_data`;

CREATE TABLE `tb_gluing_data` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `workstation` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '工位',
  `PRODUCT_CODE` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '产品二维码',
  `WORKING_TIME` decimal(3,2) DEFAULT NULL COMMENT '涂胶视觉检测时长',
  `NO` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '涂胶编号',
  `GLUE_AMOUNT` decimal(3,2) DEFAULT NULL COMMENT '涂胶量',
  `PRESSURE` decimal(3,2) DEFAULT NULL COMMENT '涂胶压力',
  `CHECK_RESULT` tinyint(3) DEFAULT NULL COMMENT '涂胶检测结果',
  `version` bigint(20) DEFAULT '1' COMMENT '版本',
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '逻辑删除(1:已删除，0:未删除)',
  `created_user` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '创建用户',
  `created_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_user` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '更新用户',
  `updated_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='涂胶数据表';

/*Data for the table `tb_gluing_data` */

/*Table structure for table `tb_point_information` */

DROP TABLE IF EXISTS `tb_point_information`;

CREATE TABLE `tb_point_information` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `workstation` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '工位',
  `PRODUCT_CODE` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '产品二维码',
  `DEVICE_TYPE` tinyint(3) DEFAULT NULL COMMENT '工位设备类型 激光弧焊为1,CNC为2，尺寸检测为3，拉繆设备为4，涂胶设备为5，FDS设备为6，气密检测为7，其他为8',
  `PART_LOAD` tinyint(3) DEFAULT NULL COMMENT '上件到位信号',
  `PART_LOAD_TIME` timestamp NULL DEFAULT NULL COMMENT '上件到位时间',
  `PART_UNLOAD` tinyint(3) DEFAULT NULL COMMENT '下件出站信号',
  `PART_UNLOAD_TIME` timestamp NULL DEFAULT NULL COMMENT '下件出站时间',
  `CHECK_RESULT` tinyint(3) NOT NULL DEFAULT '0' COMMENT '检测结果',
  `version` bigint(20) DEFAULT '1' COMMENT '版本',
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '逻辑删除(1:已删除，0:未删除)',
  `created_user` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '创建用户',
  `created_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_user` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '更新用户',
  `updated_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='过点信息表';

/*Data for the table `tb_point_information` */

insert  into `tb_point_information`(`id`,`workstation`,`PRODUCT_CODE`,`DEVICE_TYPE`,`PART_LOAD`,`PART_LOAD_TIME`,`PART_UNLOAD`,`PART_UNLOAD_TIME`,`CHECK_RESULT`,`version`,`is_deleted`,`created_user`,`created_time`,`updated_user`,`updated_time`) values 
(11,'op10','123456',1,1,'2021-09-21 02:01:07',1,'2021-09-21 02:01:37',22,1,0,'sys','2021-09-21 02:01:07','sys','2021-09-21 02:01:37');

/*Table structure for table `tb_pull_riveting_data` */

DROP TABLE IF EXISTS `tb_pull_riveting_data`;

CREATE TABLE `tb_pull_riveting_data` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `workstation` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '工位',
  `PRODUCT_CODE` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '产品二维码',
  `NO` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '拉铆设备编号',
  `LD_NO` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '铆钉编号',
  `WORKING_TIME` decimal(3,2) DEFAULT NULL COMMENT '拉铆时间',
  `CHECK_RESULT` tinyint(3) DEFAULT NULL COMMENT '拉铆结果',
  `LM_POWER` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '拉铆拉力',
  `version` bigint(20) DEFAULT '1' COMMENT '版本',
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '逻辑删除(1:已删除，0:未删除)',
  `created_user` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '创建用户',
  `created_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_user` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '更新用户',
  `updated_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='拉铆数据表';

/*Data for the table `tb_pull_riveting_data` */

/*Table structure for table `tb_user` */

DROP TABLE IF EXISTS `tb_user`;

CREATE TABLE `tb_user` (
  `user_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户名',
  `mobile` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '手机号',
  `password` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '密码',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`user_id`) USING BTREE,
  UNIQUE KEY `username` (`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='用户';

/*Data for the table `tb_user` */

insert  into `tb_user`(`user_id`,`username`,`mobile`,`password`,`create_time`) values 
(1,'mark','13612345678','8c6976e5b5410415bde908bd4dee15dfb167a9c873fc4bb8a81f6f2ab448a918','2017-03-23 22:37:41');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;