/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50722
Source Host           : localhost:3306
Source Database       : ccs_yj

Target Server Type    : MYSQL
Target Server Version : 50722
File Encoding         : 65001

Date: 2022-11-09 10:49:23
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for ccs_action
-- ----------------------------
DROP TABLE IF EXISTS `ccs_action`;
CREATE TABLE `ccs_action` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ip` varchar(20) NOT NULL COMMENT 'ip',
  `protocol_type` varchar(20) NOT NULL DEFAULT 'OPCUA' COMMENT '协议类型',
  `operate_type` varchar(50) NOT NULL COMMENT '操作类型',
  `operate_name` varchar(50) NOT NULL COMMENT '操作名称',
  `file_path` varchar(100) DEFAULT NULL COMMENT '文件路径',
  `plc_ip` varchar(50) DEFAULT NULL COMMENT '移动序号',
  `order_index` varchar(2) DEFAULT NULL COMMENT 'rfid序号',
  `description` varchar(100) DEFAULT NULL COMMENT '备注',
  UNIQUE KEY `pk_id` (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of ccs_action
-- ----------------------------
INSERT INTO `ccs_action` VALUES ('33', '192.168.11.170', 'S7_1500', 'GetQualityCenter', '框体线取物品', null, '', null, null);
INSERT INTO `ccs_action` VALUES ('34', '192.168.11.170', 'S7_1500', 'SendQualityCenter', '框体线送物品', null, '', null, null);
INSERT INTO `ccs_action` VALUES ('35', '192.168.11.170', 'S7_1500', 'MoveRobotPosition', '框体线机器人移动物品', null, '', null, null);
INSERT INTO `ccs_action` VALUES ('37', '192.168.11.130', 'S7_1500', 'StartLabelMachine', '启动打标机', null, null, null, null);
INSERT INTO `ccs_action` VALUES ('38', '192.168.11.170', 'S7_1500', 'StartCleanMachine', '启动框体清洗机', null, null, null, null);
INSERT INTO `ccs_action` VALUES ('39', '192.168.11.186', 'HEIDEHAIN', 'StartNCProgram', '框体线启动哈默机床1程序', '', '192.168.11.170', null, null);
INSERT INTO `ccs_action` VALUES ('40', '192.168.11.187', 'HEIDEHAIN', 'StartNCProgram', '框体线启动哈默机床2程序', null, '192.168.11.170', null, null);
INSERT INTO `ccs_action` VALUES ('41', '192.168.11.188', 'HEIDEHAIN', 'StartNCProgram', '框体线启动哈默机床3程序', null, '192.168.11.170', null, null);
INSERT INTO `ccs_action` VALUES ('42', '192.168.11.189', 'FANUC', 'StartNCProgram', '沈机机床4启动', null, '192.168.11.170', null, null);
INSERT INTO `ccs_action` VALUES ('43', '192.168.11.190', 'FANUC', 'StartNCProgram', '沈机机床5启动', null, '192.168.11.170', null, null);
INSERT INTO `ccs_action` VALUES ('44', '192.168.11.191', 'FANUC', 'StartNCProgram', '沈机机床6启动', null, '192.168.11.170', null, null);
INSERT INTO `ccs_action` VALUES ('45', '192.168.11.192', 'FANUC', 'StartNCProgram', '沈机机床7启动', null, '192.168.11.170', null, null);
INSERT INTO `ccs_action` VALUES ('46', '192.168.11.130', 'S7_1500', 'QueryThreeCoordinatesFreePos', '查询三坐标检测空闲位置', null, '192.168.11.130', null, null);
INSERT INTO `ccs_action` VALUES ('47', '192.168.11.130', 'S7_1500', 'SendThreeCoordinates', '启动三坐标测量', null, '192.168.11.130', null, null);
INSERT INTO `ccs_action` VALUES ('48', '192.168.11.130', 'S7_1500', 'GetServoStacker', '伺服舵机取物品', null, '192.168.11.130', null, null);
INSERT INTO `ccs_action` VALUES ('49', '192.168.11.130', 'S7_1500', 'SendServoStacker', '伺服舵机送物品', null, '192.168.11.130', null, null);
INSERT INTO `ccs_action` VALUES ('52', '192.168.11.150', 'S7_1500', 'StartCleanMachine', '启动舱体清洗机', null, '192.168.11.150', null, null);
INSERT INTO `ccs_action` VALUES ('55', '192.168.11.130', 'S7_1500', 'ReadRFID', '读RFID', null, null, null, null);
INSERT INTO `ccs_action` VALUES ('56', '192.168.11.130', 'S7_1500', 'WriteRFID', '写RFID', null, null, null, null);
INSERT INTO `ccs_action` VALUES ('60', '192.168.11.150', 'S7_1500', 'GetQualityCenter', '舱体线取物品', null, '', null, null);
INSERT INTO `ccs_action` VALUES ('61', '192.168.11.150', 'S7_1500', 'SendQualityCenter', '舱体线送物品', null, '', null, null);
INSERT INTO `ccs_action` VALUES ('62', '192.168.11.150', 'S7_1500', 'MoveRobotPosition', '舱体线机器人移动物品', null, '', null, null);

-- ----------------------------
-- Table structure for ccs_action_address
-- ----------------------------
DROP TABLE IF EXISTS `ccs_action_address`;
CREATE TABLE `ccs_action_address` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `action_id` int(11) NOT NULL DEFAULT '0' COMMENT '动作id',
  `type` varchar(20) NOT NULL COMMENT '类型：WRITE,CHECK,CALLBACK,CALLBACK_FAIL',
  `address` varchar(20) NOT NULL COMMENT '点位地址',
  `value` varchar(20) DEFAULT NULL COMMENT '点位值',
  `check_type` bit(1) NOT NULL DEFAULT b'1' COMMENT '校验类型，1等于 0表示不等于',
  `sort` int(11) NOT NULL DEFAULT '1' COMMENT '顺序',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=305 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of ccs_action_address
-- ----------------------------
INSERT INTO `ccs_action_address` VALUES ('1', '33', 'WRITE', 'DB200.46', null, '', '1');
INSERT INTO `ccs_action_address` VALUES ('2', '33', 'WRITE', 'DB200.50', '1', '', '2');
INSERT INTO `ccs_action_address` VALUES ('3', '33', 'CHECK', 'DB200.4', '1', '\0', '1');
INSERT INTO `ccs_action_address` VALUES ('4', '33', 'CALLBACK', 'DB200.50', '3', '', '1');
INSERT INTO `ccs_action_address` VALUES ('5', '33', 'CALLBACK_FAIL', 'DB200.50', '9', '', '1');
INSERT INTO `ccs_action_address` VALUES ('6', '33', 'CALLBACK_FAIL', 'DB200.50', '10', '', '2');
INSERT INTO `ccs_action_address` VALUES ('7', '34', 'WRITE', 'DB200.48', null, '', '1');
INSERT INTO `ccs_action_address` VALUES ('8', '34', 'WRITE', 'DB200.50', '4', '', '2');
INSERT INTO `ccs_action_address` VALUES ('9', '34', 'CHECK', 'DB200.4', '1', '\0', '1');
INSERT INTO `ccs_action_address` VALUES ('10', '34', 'CALLBACK', 'DB200.50', '6', '', '1');
INSERT INTO `ccs_action_address` VALUES ('11', '34', 'CALLBACK_FAIL', 'DB200.50', '9', '', '1');
INSERT INTO `ccs_action_address` VALUES ('12', '34', 'CALLBACK_FAIL', 'DB200.50', '10', '', '1');
INSERT INTO `ccs_action_address` VALUES ('13', '31', 'WRITE', 'DB200.46', null, '', '1');
INSERT INTO `ccs_action_address` VALUES ('14', '31', 'WRITE', 'DB200.50', '1', '', '2');
INSERT INTO `ccs_action_address` VALUES ('15', '31', 'CHECK', 'DB200.4', null, '\0', '1');
INSERT INTO `ccs_action_address` VALUES ('16', '31', 'CALLBACK', 'DB200.50', '3', '', '1');
INSERT INTO `ccs_action_address` VALUES ('17', '31', 'CALLBACK_FAIL', 'DB200.50', '9', '', '1');
INSERT INTO `ccs_action_address` VALUES ('18', '31', 'CALLBACK_FAIL', 'DB200.50', '10', '', '2');
INSERT INTO `ccs_action_address` VALUES ('19', '32', 'WRITE', 'DB200.48', null, '', '1');
INSERT INTO `ccs_action_address` VALUES ('20', '32', 'WRITE', 'DB200.50', '4', '', '2');
INSERT INTO `ccs_action_address` VALUES ('21', '32', 'CHECK', 'DB200.4', '1', '\0', '1');
INSERT INTO `ccs_action_address` VALUES ('22', '32', 'CALLBACK', 'DB200.50', '6', '', '1');
INSERT INTO `ccs_action_address` VALUES ('23', '32', 'CALLBACK_FAIL', 'DB200.50', '9', '', '1');
INSERT INTO `ccs_action_address` VALUES ('24', '32', 'CALLBACK_FAIL', 'DB200.50', '10', '', '2');
INSERT INTO `ccs_action_address` VALUES ('25', '35', 'WRITE', 'DB200.46', null, '', '1');
INSERT INTO `ccs_action_address` VALUES ('26', '35', 'WRITE', 'DB200.50', '7', '', '2');
INSERT INTO `ccs_action_address` VALUES ('27', '35', 'CHECK', 'DB200.4', '1', '\0', '1');
INSERT INTO `ccs_action_address` VALUES ('28', '35', 'CALLBACK', 'DB200.50', '8', '', '1');
INSERT INTO `ccs_action_address` VALUES ('29', '35', 'CALLBACK_FAIL', 'DB200.50', '9', '', '1');
INSERT INTO `ccs_action_address` VALUES ('30', '35', 'CALLBACK_FAIL', 'DB200.50', '10', '', '2');
INSERT INTO `ccs_action_address` VALUES ('31', '39', 'WRITE', 'DB200.312', '1', '', '1');
INSERT INTO `ccs_action_address` VALUES ('32', '39', 'CHECK', '', '', '', '1');
INSERT INTO `ccs_action_address` VALUES ('33', '39', 'CALLBACK', 'DB200.388', '1', '', '1');
INSERT INTO `ccs_action_address` VALUES ('34', '40', 'WRITE', 'DB200.314', '1', '', '2');
INSERT INTO `ccs_action_address` VALUES ('35', '40', 'CHECK', '', '', '', '1');
INSERT INTO `ccs_action_address` VALUES ('36', '40', 'CALLBACK', 'DB200.390', '1', '', '1');
INSERT INTO `ccs_action_address` VALUES ('37', '41', 'WRITE', 'DB200.316', '1', '', '1');
INSERT INTO `ccs_action_address` VALUES ('38', '41', 'CHECK', '', '', '', '1');
INSERT INTO `ccs_action_address` VALUES ('39', '41', 'CALLBACK', 'DB200.392', '1', '', '1');
INSERT INTO `ccs_action_address` VALUES ('40', '42', 'WRITE', 'DB200.318', '1', '', '1');
INSERT INTO `ccs_action_address` VALUES ('41', '42', 'CHECK', '', '', '', '1');
INSERT INTO `ccs_action_address` VALUES ('42', '42', 'CALLBACK', 'DB200.394', '', '', '1');
INSERT INTO `ccs_action_address` VALUES ('43', '43', 'WRITE', 'DB200.320', '1', '', '1');
INSERT INTO `ccs_action_address` VALUES ('44', '43', 'CHECK', '', '', '', '1');
INSERT INTO `ccs_action_address` VALUES ('45', '43', 'CALLBACK', 'DB200.396', '1', '', '2');
INSERT INTO `ccs_action_address` VALUES ('46', '44', 'WRITE', 'DB200.322', '1', '', '1');
INSERT INTO `ccs_action_address` VALUES ('47', '44', 'CHECK', '', '', '', '1');
INSERT INTO `ccs_action_address` VALUES ('48', '44', 'CALLBACK', ' DB200.398', '1', '', '1');
INSERT INTO `ccs_action_address` VALUES ('49', '45', 'WRITE', 'DB200.324', '1', '', '1');
INSERT INTO `ccs_action_address` VALUES ('50', '45', 'CHECK', '', '', '', '1');
INSERT INTO `ccs_action_address` VALUES ('51', '45', 'CALLBACK', 'DB200.400', '1', '', '1');
INSERT INTO `ccs_action_address` VALUES ('52', '40', 'WRITE', 'DB200.302', '4', '', '1');
INSERT INTO `ccs_action_address` VALUES ('53', '40', 'WRITE_CHECK', 'DB200.308', '0', '', '1');
INSERT INTO `ccs_action_address` VALUES ('55', '46', 'CHECK_BAK', 'DB200.8.0', '1', '', '1');
INSERT INTO `ccs_action_address` VALUES ('56', '46', 'CHECK', 'DB200.12.0', '1', '', '2');
INSERT INTO `ccs_action_address` VALUES ('57', '46', 'CHECK_BAK', 'DB200.16.0', '1', '', '3');
INSERT INTO `ccs_action_address` VALUES ('58', '47', 'CHECK', 'DB200.8.0', '1', '', '1');
INSERT INTO `ccs_action_address` VALUES ('59', '47', 'CHECK', 'DB200.12.0', '1', '', '2');
INSERT INTO `ccs_action_address` VALUES ('60', '47', 'CHECK', 'DB200.16.0', '1', '', '3');
INSERT INTO `ccs_action_address` VALUES ('61', '47', 'WRITE', 'DB200.2428.0', 'workProgramName', '', '1');
INSERT INTO `ccs_action_address` VALUES ('62', '47', 'WRITE', 'DB200.2448.0', 'workProgramName', '', '2');
INSERT INTO `ccs_action_address` VALUES ('63', '47', 'WRITE', 'DB200.2468.0', 'workProgramName', '', '3');
INSERT INTO `ccs_action_address` VALUES ('64', '47', 'WRITE', 'DB200.2548.0', 'workId', '', '1');
INSERT INTO `ccs_action_address` VALUES ('65', '47', 'WRITE', 'DB200.2588.0', 'workId', '', '2');
INSERT INTO `ccs_action_address` VALUES ('66', '47', 'WRITE', 'DB200.2628.0', 'workId', '', '3');
INSERT INTO `ccs_action_address` VALUES ('67', '47', 'WRITE', 'DB200.2788.0', 'procedureNo', '', '1');
INSERT INTO `ccs_action_address` VALUES ('68', '47', 'WRITE', 'DB200.2808.0', 'procedureNo', '', '2');
INSERT INTO `ccs_action_address` VALUES ('69', '47', 'WRITE', 'DB200.2828.0', 'procedureNo', '', '3');
INSERT INTO `ccs_action_address` VALUES ('70', '47', 'CALLBACK', 'DB200.50', '6', '', '1');
INSERT INTO `ccs_action_address` VALUES ('71', '47', 'CALLBACK_GET_COOR', 'DB200.2488.0', 'workProgramName', '', '1');
INSERT INTO `ccs_action_address` VALUES ('72', '47', 'CALLBACK_GET_COOR', 'DB200.2508.0', 'workProgramName', '', '2');
INSERT INTO `ccs_action_address` VALUES ('73', '47', 'CALLBACK_GET_COOR', 'DB200.2528.0', 'workProgramName', '', '3');
INSERT INTO `ccs_action_address` VALUES ('74', '47', 'CALLBACK_GET_COOR', 'DB200.2668.0', 'workId', '', '1');
INSERT INTO `ccs_action_address` VALUES ('75', '47', 'CALLBACK_GET_COOR', 'DB200.2708.0', 'workId', '', '2');
INSERT INTO `ccs_action_address` VALUES ('76', '47', 'CALLBACK_GET_COOR', 'DB200.2748.0', 'workId', '', '3');
INSERT INTO `ccs_action_address` VALUES ('77', '47', 'CALLBACK_GET_COOR', 'DB200.2848.0', 'procedureNo', '', '1');
INSERT INTO `ccs_action_address` VALUES ('78', '47', 'CALLBACK_GET_COOR', 'DB200.2868.0', 'procedureNo', '', '2');
INSERT INTO `ccs_action_address` VALUES ('79', '47', 'CALLBACK_GET_COOR', 'DB200.2888.0', 'procedureNo', '', '3');
INSERT INTO `ccs_action_address` VALUES ('80', '47', 'CALLBACK_CHECK_COOR', 'DB200.6.0', null, '', '1');
INSERT INTO `ccs_action_address` VALUES ('81', '47', 'CALLBACK_CHECK_COOR', 'DB200.10.0', null, '', '2');
INSERT INTO `ccs_action_address` VALUES ('82', '47', 'CALLBACK_CHECK_COOR', 'DB200.14.0', null, '', '3');
INSERT INTO `ccs_action_address` VALUES ('83', '47', 'WRITE_SEND', 'DB200.48', '', '', '1');
INSERT INTO `ccs_action_address` VALUES ('84', '47', 'WRITE_SEND', 'DB200.50', '4', '', '2');
INSERT INTO `ccs_action_address` VALUES ('86', '47', 'CALLBACK_FAIL', 'DB200.50', '9', '', '1');
INSERT INTO `ccs_action_address` VALUES ('87', '47', 'CALLBACK_FAIL', 'DB200.50', '10', '', '2');
INSERT INTO `ccs_action_address` VALUES ('88', '48', 'WRITE', 'DB200.46', null, '', '1');
INSERT INTO `ccs_action_address` VALUES ('89', '48', 'WRITE', 'DB200.50', '1', '', '2');
INSERT INTO `ccs_action_address` VALUES ('90', '48', 'CHECK', 'DB200.4', '1', '\0', '1');
INSERT INTO `ccs_action_address` VALUES ('91', '48', 'CALLBACK', 'DB200.50', '3', '', '1');
INSERT INTO `ccs_action_address` VALUES ('92', '48', 'CALLBACK_FAIL', 'DB200.50', '9', '', '1');
INSERT INTO `ccs_action_address` VALUES ('93', '48', 'CALLBACK_FAIL', 'DB200.50', '10', '', '2');
INSERT INTO `ccs_action_address` VALUES ('94', '49', 'WRITE', 'DB200.48', null, '', '1');
INSERT INTO `ccs_action_address` VALUES ('95', '49', 'WRITE', 'DB200.50', '4', '', '2');
INSERT INTO `ccs_action_address` VALUES ('96', '49', 'CHECK', 'DB200.4', '1', '\0', '1');
INSERT INTO `ccs_action_address` VALUES ('97', '49', 'CALLBACK', 'DB200.50', '6', '', '1');
INSERT INTO `ccs_action_address` VALUES ('98', '49', 'CALLBACK_FAIL', 'DB200.50', '9', '', '1');
INSERT INTO `ccs_action_address` VALUES ('99', '49', 'CALLBACK_FAIL', 'DB200.50', '10', '', '1');
INSERT INTO `ccs_action_address` VALUES ('100', '37', 'WRITE', 'DB200.52', '', '', '1');
INSERT INTO `ccs_action_address` VALUES ('101', '37', 'WRITE', 'DB200.53', null, '', '2');
INSERT INTO `ccs_action_address` VALUES ('102', '37', 'WRITE', 'DB200.54', null, '', '3');
INSERT INTO `ccs_action_address` VALUES ('104', '37', 'WRITE', 'DB200.182', null, '', '4');
INSERT INTO `ccs_action_address` VALUES ('105', '37', 'WRITE', 'DB200.310', null, '', '5');
INSERT INTO `ccs_action_address` VALUES ('106', '37', 'WRITE', 'DB200.438', null, '', '6');
INSERT INTO `ccs_action_address` VALUES ('107', '37', 'WRITE', 'DB200.470', null, '', '7');
INSERT INTO `ccs_action_address` VALUES ('108', '37', 'WRITE', 'DB200.46', '370', '', '8');
INSERT INTO `ccs_action_address` VALUES ('109', '37', 'WRITE', 'DB200.50', '1', '', '9');
INSERT INTO `ccs_action_address` VALUES ('110', '37', 'CALLBACK', 'DB200.50', '3', '', '1');
INSERT INTO `ccs_action_address` VALUES ('111', '37', 'CALLBACK', 'DB200.24', '1', '', '2');
INSERT INTO `ccs_action_address` VALUES ('112', '55', 'WRITE1', 'DB200.508', '', '', '1');
INSERT INTO `ccs_action_address` VALUES ('113', '55', 'WRITE1', 'DB200.476', '1', '', '2');
INSERT INTO `ccs_action_address` VALUES ('114', '55', 'WRITE1', 'DB200.476', '0', '', '3');
INSERT INTO `ccs_action_address` VALUES ('115', '55', 'WRITE2', 'DB200.748', '', '', '1');
INSERT INTO `ccs_action_address` VALUES ('116', '55', 'WRITE2', 'DB200.480', '1', '', '2');
INSERT INTO `ccs_action_address` VALUES ('117', '55', 'WRITE2', 'DB200.480', '0', '', '3');
INSERT INTO `ccs_action_address` VALUES ('118', '55', 'WRITE3', 'DB200.988', '', '', '1');
INSERT INTO `ccs_action_address` VALUES ('119', '55', 'WRITE3', 'DB200.484', '1', '', '2');
INSERT INTO `ccs_action_address` VALUES ('120', '55', 'WRITE3', 'DB200.484', '0', '', '3');
INSERT INTO `ccs_action_address` VALUES ('121', '55', 'WRITE4', 'DB200.1228', null, '', '1');
INSERT INTO `ccs_action_address` VALUES ('122', '55', 'WRITE4', 'DB200.488', '1', '', '2');
INSERT INTO `ccs_action_address` VALUES ('123', '55', 'WRITE4', 'DB200.488', '0', '', '3');
INSERT INTO `ccs_action_address` VALUES ('124', '55', 'WRITE5', 'DB200.1468', null, '', '1');
INSERT INTO `ccs_action_address` VALUES ('125', '55', 'WRITE5', 'DB200.492', '1', '', '2');
INSERT INTO `ccs_action_address` VALUES ('126', '55', 'WRITE5', 'DB200.492', '0', '', '3');
INSERT INTO `ccs_action_address` VALUES ('127', '55', 'WRITE6', 'DB200.1708', null, '', '1');
INSERT INTO `ccs_action_address` VALUES ('128', '55', 'WRITE6', 'DB200.496', '1', '', '2');
INSERT INTO `ccs_action_address` VALUES ('129', '55', 'WRITE6', 'DB200.496', '0', '', '3');
INSERT INTO `ccs_action_address` VALUES ('130', '56', 'WRITE1', 'DB200.628', '', '', '1');
INSERT INTO `ccs_action_address` VALUES ('131', '56', 'WRITE1', 'DB200.478', '1', '', '2');
INSERT INTO `ccs_action_address` VALUES ('132', '56', 'WRITE1', 'DB200.478', '0', '', '3');
INSERT INTO `ccs_action_address` VALUES ('133', '56', 'WRITE2', 'DB200.868', '', '', '1');
INSERT INTO `ccs_action_address` VALUES ('134', '56', 'WRITE2', 'DB200.482', '1', '', '2');
INSERT INTO `ccs_action_address` VALUES ('135', '56', 'WRITE2', 'DB200.482', '0', '', '3');
INSERT INTO `ccs_action_address` VALUES ('136', '56', 'WRITE3', 'DB200.1108', '', '', '1');
INSERT INTO `ccs_action_address` VALUES ('137', '56', 'WRITE3', 'DB200.486', '1', '', '2');
INSERT INTO `ccs_action_address` VALUES ('138', '56', 'WRITE3', 'DB200.486', '0', '', '3');
INSERT INTO `ccs_action_address` VALUES ('139', '56', 'WRITE4', 'DB200.1348', null, '', '1');
INSERT INTO `ccs_action_address` VALUES ('140', '56', 'WRITE4', 'DB200.490', '1', '', '2');
INSERT INTO `ccs_action_address` VALUES ('141', '56', 'WRITE4', 'DB200.490', '0', '', '3');
INSERT INTO `ccs_action_address` VALUES ('142', '56', 'WRITE5', 'DB200.1588', null, '', '1');
INSERT INTO `ccs_action_address` VALUES ('143', '56', 'WRITE5', 'DB200.494', '1', '', '2');
INSERT INTO `ccs_action_address` VALUES ('144', '56', 'WRITE5', 'DB200.494', '0', '', '3');
INSERT INTO `ccs_action_address` VALUES ('145', '56', 'WRITE6', 'DB200.1828', null, '', '1');
INSERT INTO `ccs_action_address` VALUES ('146', '56', 'WRITE6', 'DB200.498', '1', '', '2');
INSERT INTO `ccs_action_address` VALUES ('147', '56', 'WRITE6', 'DB200.498', '0', '', '3');
INSERT INTO `ccs_action_address` VALUES ('160', '38', 'WRITE', 'DB200.48', '123', '', '1');
INSERT INTO `ccs_action_address` VALUES ('161', '38', 'CALLBACK', 'DB200.48', '1', '', '1');
INSERT INTO `ccs_action_address` VALUES ('201', '60', 'WRITE', 'DB200.46', null, '', '1');
INSERT INTO `ccs_action_address` VALUES ('202', '60', 'WRITE', 'DB200.50', '1', '', '2');
INSERT INTO `ccs_action_address` VALUES ('203', '60', 'CHECK', 'DB200.4', '1', '\0', '1');
INSERT INTO `ccs_action_address` VALUES ('204', '60', 'CALLBACK', 'DB200.50', '3', '', '1');
INSERT INTO `ccs_action_address` VALUES ('205', '60', 'CALLBACK_FAIL', 'DB200.50', '9', '', '1');
INSERT INTO `ccs_action_address` VALUES ('206', '60', 'CALLBACK_FAIL', 'DB200.50', '10', '', '2');
INSERT INTO `ccs_action_address` VALUES ('207', '61', 'WRITE', 'DB200.46', null, '', '1');
INSERT INTO `ccs_action_address` VALUES ('208', '61', 'WRITE', 'DB200.50', '4', '', '2');
INSERT INTO `ccs_action_address` VALUES ('209', '61', 'CHECK', 'DB200.4', '1', '\0', '1');
INSERT INTO `ccs_action_address` VALUES ('210', '61', 'CALLBACK', 'DB200.50', '6', '', '1');
INSERT INTO `ccs_action_address` VALUES ('211', '61', 'CALLBACK_FAIL', 'DB200.50', '9', '', '1');
INSERT INTO `ccs_action_address` VALUES ('212', '61', 'CALLBACK_FAIL', 'DB200.50', '10', '', '1');
INSERT INTO `ccs_action_address` VALUES ('213', '62', 'WRITE', 'DB200.46', null, '', '1');
INSERT INTO `ccs_action_address` VALUES ('214', '62', 'WRITE', 'DB200.50', '7', '', '2');
INSERT INTO `ccs_action_address` VALUES ('215', '62', 'CHECK', 'DB200.4', '1', '\0', '1');
INSERT INTO `ccs_action_address` VALUES ('216', '62', 'CALLBACK', 'DB200.50', '8', '', '1');
INSERT INTO `ccs_action_address` VALUES ('217', '62', 'CALLBACK_FAIL', 'DB200.50', '9', '', '1');
INSERT INTO `ccs_action_address` VALUES ('218', '62', 'CALLBACK_FAIL', 'DB200.50', '10', '', '2');
INSERT INTO `ccs_action_address` VALUES ('300', '47', 'CALLBACK', 'DB200.38', '2', '', '2');
INSERT INTO `ccs_action_address` VALUES ('301', '38', 'WRITE', 'DB200.50', '4', '', '2');
INSERT INTO `ccs_action_address` VALUES ('302', '52', 'WRITE', 'DB200.48', '123', '', '1');
INSERT INTO `ccs_action_address` VALUES ('303', '52', 'CALLBACK', 'DB200.48', '1', '', '1');
INSERT INTO `ccs_action_address` VALUES ('304', '52', 'WRITE', 'DB200.50', '4', '', '2');

-- ----------------------------
-- Table structure for ccs_device
-- ----------------------------
DROP TABLE IF EXISTS `ccs_device`;
CREATE TABLE `ccs_device` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ip` varchar(20) NOT NULL,
  `user_name` varchar(20) DEFAULT NULL,
  `port` int(11) DEFAULT NULL,
  `password` varchar(50) DEFAULT NULL,
  `server_url` varchar(50) DEFAULT NULL COMMENT '服务类型',
  `protocol_type` varchar(20) NOT NULL DEFAULT 'OPCUA' COMMENT '协议类型',
  `state` bit(1) NOT NULL DEFAULT b'1' COMMENT '1表示启用 0表示停用',
  `use_state` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否使用0:不使用 1:使用',
  `description` varchar(100) DEFAULT NULL,
  UNIQUE KEY `pk_id` (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of ccs_device
-- ----------------------------
INSERT INTO `ccs_device` VALUES ('1', '192.168.170.206', 'OpcUaClient', '4840', '12345678', 'opc.tcp://192.168.170.206:4840', 'OPCUA', '\0', '\0', null);
INSERT INTO `ccs_device` VALUES ('3', '127.0.0.1', 'manufact', '22', 'SUNRISE', '127.0.0.1', 'FTP', '', '\0', null);
INSERT INTO `ccs_device` VALUES ('4', '192.168.11.170', null, '102', null, '192.168.11.170', 'S7_1500', '\0', '', '框体线CPU PLC');
INSERT INTO `ccs_device` VALUES ('6', '192.168.11.186', 'eth01', '1900', null, '192.168.11.186', 'HEIDEHAIN', '\0', '\0', '哈默机床1');
INSERT INTO `ccs_device` VALUES ('7', '192.168.11.187', 'eth02', '1900', null, '192.168.11.187', 'HEIDEHAIN', '', '', '哈默机床2');
INSERT INTO `ccs_device` VALUES ('8', '192.168.11.188', 'eth03', '1900', null, '192.168.11.188', 'HEIDEHAIN', '\0', '\0', '哈默机床3');
INSERT INTO `ccs_device` VALUES ('9', '192.168.11.189', null, '8193', null, '192.168.11.189', 'FANUC', '', '', '沈机机床1');
INSERT INTO `ccs_device` VALUES ('10', '192.168.11.190', null, '8193', null, '192.168.11.190', 'FANUC', '', '', '沈机机床2');
INSERT INTO `ccs_device` VALUES ('11', '192.168.11.191', null, '8193', null, '192.168.11.191', 'FANUC', '', '', '沈机机床3');
INSERT INTO `ccs_device` VALUES ('12', '192.168.11.192', null, '8193', null, '192.168.11.192', 'FANUC', '', '', '沈机机床4');
INSERT INTO `ccs_device` VALUES ('13', '192.168.11.150', null, '102', null, '192.168.11.150', 'S7_1500', '\0', '\0', '舱体线CPU PLC ');
INSERT INTO `ccs_device` VALUES ('15', '192.168.11.130', null, '102', null, '192.168.11.130', 'S7_1500', '', '', '保障中心CPU PLC');

-- ----------------------------
-- Table structure for ccs_dictionary
-- ----------------------------
DROP TABLE IF EXISTS `ccs_dictionary`;
CREATE TABLE `ccs_dictionary` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(100) NOT NULL COMMENT '类型',
  `code` varchar(100) NOT NULL COMMENT '编码',
  `name` varchar(64) NOT NULL COMMENT '名称',
  `dict_value` varchar(64) DEFAULT NULL COMMENT '值',
  `description` varchar(255) DEFAULT '' COMMENT '描述',
  `state` bit(1) NOT NULL DEFAULT b'1' COMMENT '1表示启用 0表示停用',
  UNIQUE KEY `pk_id` (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb4 COMMENT='字典项';

-- ----------------------------
-- Records of ccs_dictionary
-- ----------------------------
INSERT INTO `ccs_dictionary` VALUES ('1', 'GetIntelligenceUnit', '1', '1', '1', '智能单元取物品条件', '');
INSERT INTO `ccs_dictionary` VALUES ('2', 'GetFlexibleWire', '2', '2', '1', '柔性线取物品', '');
INSERT INTO `ccs_dictionary` VALUES ('3', 'GetQualityCenter', '1', '1', '1', '质量中心取物品', '');
INSERT INTO `ccs_dictionary` VALUES ('4', 'SendIntelligenceUnit', '1', '1', '1', '智能单元送物品', '');
INSERT INTO `ccs_dictionary` VALUES ('5', 'SendFlexibleWire', '1', '1', '1', '柔性线送物品', '');
INSERT INTO `ccs_dictionary` VALUES ('6', 'SendQualityCenter', '1', '1', '1', '质量中心送物品', '');
INSERT INTO `ccs_dictionary` VALUES ('7', 'MoveRobotPosition', '1', '1', '1', '柔性线机器人移动物品', '');
INSERT INTO `ccs_dictionary` VALUES ('8', 'UploadFile', '1', '1', '1', '上传文件', '');
INSERT INTO `ccs_dictionary` VALUES ('9', 'StartNCProgram', '1', '1', '1', '启动机床程序', '');
INSERT INTO `ccs_dictionary` VALUES ('10', 'SendLinShift', '1', '1', '1', '粗偏写入', '');
INSERT INTO `ccs_dictionary` VALUES ('11', 'SendLinShiftFine', '1', '1', '1', '精偏写入', '');
INSERT INTO `ccs_dictionary` VALUES ('12', 'StartCleanMachine', '1', '1', '1', '启动清洗机', '');
INSERT INTO `ccs_dictionary` VALUES ('13', 'StartLabelMachine', '1', '1', '1', '启动打标机', '');
INSERT INTO `ccs_dictionary` VALUES ('14', 'StartCoordinateMeasuringMachine', '1', '1', '1', '启动三坐标', '');
INSERT INTO `ccs_dictionary` VALUES ('15', 'GetServoStacker', '1', '1', '1', '伺服舵机取物品', '');
INSERT INTO `ccs_dictionary` VALUES ('16', 'SendServoStacker', '1', '1', '1', '伺服舵机放物品', '');
INSERT INTO `ccs_dictionary` VALUES ('17', 'ReadRFID', '1', '1', '1', '读RFID', '');
INSERT INTO `ccs_dictionary` VALUES ('18', 'WriteRFID', '1', '1', '1', '写RFID', '');
INSERT INTO `ccs_dictionary` VALUES ('19', 'PlcWarnInfo', '1', '1', '总控急停按钮被拍下', '机器人报警信息内容', '');
INSERT INTO `ccs_dictionary` VALUES ('20', 'PlcWarnInfo', '2', '2', '安全门1急停被拍下', '', '');
INSERT INTO `ccs_dictionary` VALUES ('21', 'PlcWarnInfo', '3', '3', '安全门2急停被拍', '', '');
INSERT INTO `ccs_dictionary` VALUES ('22', 'PlcWarnInfo', '4', '4', '装配平台1急停被拍下', '', '');
INSERT INTO `ccs_dictionary` VALUES ('23', 'PlcWarnInfo', '5', '5', '装配平台2急停被拍下', '', '');
INSERT INTO `ccs_dictionary` VALUES ('24', 'PlcWarnInfo', '6', '6', '装配平台3急停被拍下', '', '');
INSERT INTO `ccs_dictionary` VALUES ('25', 'PlcWarnInfo', '7', '7', '装配平台4急停被拍下', '', '');
INSERT INTO `ccs_dictionary` VALUES ('26', 'PlcWarnInfo', '8', '8', '装配平台5急停被拍下', '', '');
INSERT INTO `ccs_dictionary` VALUES ('27', 'PlcWarnInfo', '9', '9', '装配平台6急停被拍下', '', '');
INSERT INTO `ccs_dictionary` VALUES ('28', 'PlcWarnInfo', '10', '10', '安全门1被打开', '', '');
INSERT INTO `ccs_dictionary` VALUES ('29', 'PlcWarnInfo', '11', '11', '安全门2被打开', '', '');
INSERT INTO `ccs_dictionary` VALUES ('30', 'PlcWarnInfo', '12', '12', 'X轴伺服驱动器故障', '', '');
INSERT INTO `ccs_dictionary` VALUES ('31', 'PlcWarnInfo', '13', '13', 'Y轴伺服驱动器故障', '', '');
INSERT INTO `ccs_dictionary` VALUES ('32', 'PlcWarnInfo', '14', '14', 'Z轴伺服驱动器故障', '', '');
INSERT INTO `ccs_dictionary` VALUES ('33', 'PlcWarnInfo', '15', '15', 'B轴伺服驱动器故障', '', '');
INSERT INTO `ccs_dictionary` VALUES ('34', 'PlcWarnInfo', '16', '16', 'X轴负软限位报警', '', '');
INSERT INTO `ccs_dictionary` VALUES ('35', 'PlcWarnInfo', '17', '17', 'X轴正软限位报警', '', '');
INSERT INTO `ccs_dictionary` VALUES ('36', 'PlcWarnInfo', '18', '18', 'Y轴负软限位报警', '', '');
INSERT INTO `ccs_dictionary` VALUES ('37', 'PlcWarnInfo', '19', '19', 'Y轴正软限位报警', '', '');
INSERT INTO `ccs_dictionary` VALUES ('38', 'PlcWarnInfo', '20', '20', 'Z轴负软限位报警', '', '');
INSERT INTO `ccs_dictionary` VALUES ('39', 'PlcWarnInfo', '21', '21', 'Z轴正软限位报警', '', '');
INSERT INTO `ccs_dictionary` VALUES ('40', 'PlcWarnInfo', '22', '22', 'B轴负软限位报警', '', '');
INSERT INTO `ccs_dictionary` VALUES ('41', 'PlcWarnInfo', '23', '23', 'B轴正软限位报警', '', '');
INSERT INTO `ccs_dictionary` VALUES ('42', 'PlcWarnInfo', '24', '24', '气源异常', '', '');
INSERT INTO `ccs_dictionary` VALUES ('43', 'PlcWarnInfo', '25', '25', '润滑油位低', '', '');
INSERT INTO `ccs_dictionary` VALUES ('44', 'PlcWarnInfo', '26', '26', '伺服使能未打开', '', '');
INSERT INTO `ccs_dictionary` VALUES ('45', 'PlcWarnInfo', '27', '27', 'X轴零点丢失', '', '');
INSERT INTO `ccs_dictionary` VALUES ('46', 'PlcWarnInfo', '28', '28', 'Y轴零点丢失', '', '');
INSERT INTO `ccs_dictionary` VALUES ('47', 'PlcWarnInfo', '29', '29', 'Z轴零点丢失', '', '');
INSERT INTO `ccs_dictionary` VALUES ('48', 'PlcWarnInfo', '30', '30', 'B轴零点丢失', '', '');

-- ----------------------------
-- Table structure for ccs_equipment_monitor
-- ----------------------------
DROP TABLE IF EXISTS `ccs_equipment_monitor`;
CREATE TABLE `ccs_equipment_monitor` (
  `id` bigint(20) NOT NULL,
  `ip` varchar(45) DEFAULT NULL,
  `name` varchar(45) DEFAULT NULL,
  `serial_no` varchar(45) DEFAULT NULL COMMENT '序号',
  `type` varchar(45) DEFAULT NULL COMMENT '类型',
  `description` varchar(45) DEFAULT NULL COMMENT '描述',
  `address` varchar(45) DEFAULT NULL COMMENT '地址',
  `address2` varchar(45) DEFAULT NULL COMMENT '地址2',
  `source` varchar(45) DEFAULT NULL COMMENT '来源',
  `status` varchar(45) DEFAULT NULL COMMENT '状态',
  `line` varchar(45) DEFAULT NULL,
  `location` varchar(45) DEFAULT NULL,
  `control_status` varchar(45) DEFAULT NULL COMMENT '控制状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of ccs_equipment_monitor
-- ----------------------------
INSERT INTO `ccs_equipment_monitor` VALUES ('5', '192.168.11.150', '地轨托盘交换台1', null, null, null, null, null, null, '离线', '舱体线', '125', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('6', '192.168.11.150', '地轨托盘交换台2', null, null, null, null, null, null, '离线', '舱体线', '126', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('16', '192.168.11.170', '地轨托盘交换台1', null, null, null, null, null, null, '在线', '框体线', '125', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('17', '192.168.11.170', '地轨托盘交换台2', null, null, null, null, null, null, '在线', '框体线', '126', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('36', '192.168.11.141', '三坐标缓存', '', null, null, '', null, null, '离线', '保障中心', '372', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('37', '192.168.11.141', '三坐标缓存', '', null, null, null, null, null, '离线', '保障中心', '374', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1496350084294508544', '192.168.11.170', '机械手', 'KT_jqr', null, null, 'DB200.4', 'DB200.50', null, '空闲', '框体线', '124', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1496351733469675520', '192.168.11.150', '舱体_清洗机', 'CT_123', null, null, null, null, null, '离线', '舱体线', '123', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1496352097438793728', '192.168.11.150', '机械手', 'CT_jqr', null, null, 'DB200.4', 'DB200.50', null, '离线', '舱体线', '124', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1496354590755389440', '192.168.11.150', '舱体_FP1000—五轴', 'CT_127', null, null, null, null, null, '离线', '舱体线', '127', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1496354747433615360', '192.168.11.150', '舱体_DMU 125P-FD(不进线)', 'CT_128', null, null, null, null, null, '离线', '舱体线', '128', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1496354880934117376', '192.168.11.150', '舱体_DMU 100P duoBLOCK-1', 'CT_129', null, null, null, null, null, '离线', '舱体线', '129', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1496355074757099520', '192.168.11.150', '舱体_DMU 100P duoBLOCK-2', 'CT_130', null, null, null, null, null, '离线', '舱体线', '130', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1496355233519894528', '192.168.11.150', '舱体_DMU 100P duoBLOCK-3', 'CT_131', null, null, null, null, null, '离线', '舱体线', '131', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1496356621587054592', '192.168.11.150', '舱体_AGV接驳位1', 'CT_121', null, null, null, null, null, '离线', '舱体线', '121', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1496356795835219968', '192.168.11.150', '舱体_AGV接驳位2', 'CT_122', null, null, null, null, null, '离线', '舱体线', '122', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1496357467590754304', '192.168.11.186', '框体_哈默五轴C650U-1', 'KT_127', 'HEIDEHAIN', null, null, null, null, '离线', '框体线', '127', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1496357660788785152', '192.168.11.187', '框体_哈默五轴C650U-2', 'KT_128', 'HEIDEHAIN', null, null, null, null, '在线', '框体线', '128', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1496357927273889792', '192.168.11.188', '框体_哈默五轴C650U-3', 'KT_129', 'HEIDEHAIN', null, null, null, null, '离线', '框体线', '129', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1496358051194601472', '192.168.11.189', '框体_VMC1300B三轴-1', 'KT_130', 'FANUC', null, null, null, null, '在线', '框体线', '130', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1496358206379655168', '192.168.11.190', '框体_VMC1300B三轴-2', 'KT_131', 'FANUC', null, null, null, null, '离线', '框体线', '131', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1496358296792072192', '192.168.11.191', '框体_VMC1300B三轴-3', 'KT_132', 'FANUC', null, null, null, null, '在线', '框体线', '132', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1496358417596416000', '192.168.11.192', '框体_VMC1300B三轴-4', 'KT_133', 'FANUC', null, null, null, null, '在线', '框体线', '133', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1496358798653128704', '192.168.11.215', '框体_AGV接驳位1', 'KT_121', null, null, null, null, null, '离线', '框体线', '121', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1496358957009076224', '192.168.11.217', '框体_AGV接驳位2', 'KT_122', null, null, null, null, null, '离线', '框体线', '122', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1496359112462565376', '192.168.11.183', '框体_清洗机', 'KT_123', null, null, null, null, null, '离线', '框体线', '123', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1496360341817262080', '192.168.11.130', '保障中心_伺服舵机', 'BZ_371', null, null, 'DB200.4', 'DB200.50', null, '在线', '保障中心', '371', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1496362306701885440', '192.168.11.130', '保障中心_AGV接驳位1', 'BZ_361', null, null, null, null, null, '在线', '保障中心', '361', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1496362579914653696', '192.168.11.130', '保障中心_AGV接驳位2', 'BZ_362', null, null, null, null, null, '在线', '保障中心', '362', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1496362719262015488', '192.168.11.130', '保障中心_AGV接驳位3', 'BZ_363', null, null, null, null, null, '在线', '保障中心', '363', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1496362944240287744', '192.168.11.142', '保障中心_三坐标', 'BZ_szb', null, null, 'DB200.4', 'DB200.50', null, '在线', '保障中心', '373', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1496363176541814784', '192.168.11.130', '保障中心_打标机', 'BZ_370', null, null, null, null, null, '在线', '保障中心', '370', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1496363582865014784', '192.168.11.130', '保障中心_上下料站1', 'BZ_364', null, null, null, null, null, '在线', '保障中心', '364', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1496364001796292608', '192.168.11.130', '保障中心_上下料站2', 'BZ_365', null, null, null, null, null, '在线', '保障中心', '365', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1496364152329863168', '192.168.11.130', '保障中心_上下料站3', 'BZ_366', null, null, null, null, null, '在线', '保障中心', '366', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1496364250765983744', '192.168.11.130', '保障中心_上下料站4', 'BZ_367', null, null, null, null, null, '在线', '保障中心', '367', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1496364402251661312', '192.168.11.130', '保障中心_上下料站5', 'BZ_368', null, null, null, null, null, '在线', '保障中心', '368', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1496364549605949440', '192.168.11.130', '保障中心_上下料站6', 'BZ_369', null, null, null, null, null, '在线', '保障中心', '369', '系统监管');

-- ----------------------------
-- Table structure for ccs_tagvalue
-- ----------------------------
DROP TABLE IF EXISTS `ccs_tagvalue`;
CREATE TABLE `ccs_tagvalue` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `address` varchar(100) DEFAULT NULL,
  `tag_value` varchar(100) DEFAULT NULL,
  `type` varchar(45) DEFAULT NULL,
  `unit` varchar(45) DEFAULT NULL,
  `protocol_type` varchar(45) DEFAULT NULL,
  `ip` varchar(45) DEFAULT NULL,
  `description` varchar(80) DEFAULT NULL,
  `component` varchar(45) DEFAULT NULL,
  `component_number` varchar(45) DEFAULT NULL,
  `device_id` varchar(45) DEFAULT NULL,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `online_state` bit(1) DEFAULT NULL COMMENT '在线状态0：不在线1：在线',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=610 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of ccs_tagvalue
-- ----------------------------
INSERT INTO `ccs_tagvalue` VALUES ('8', 'DB200.0', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '心跳信号', null, null, '419901074472701952', '2022-11-08 16:46:28', '');
INSERT INTO `ccs_tagvalue` VALUES ('9', 'DB200.2', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '机械手工作模式', '', '', '419901074472701952', '2022-11-08 10:23:24', '');
INSERT INTO `ccs_tagvalue` VALUES ('10', 'DB200.4', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '工作状态', '', '', '419901074472701952', '2022-11-08 15:37:33', '');
INSERT INTO `ccs_tagvalue` VALUES ('11', 'DB200.6', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '备用_13(RFID读取)', null, null, '419901074472701952', '2022-08-15 11:11:58', '');
INSERT INTO `ccs_tagvalue` VALUES ('12', 'DB200.8', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '机床1允许取料', '', '', '419901074472701952', '2022-08-15 11:11:58', '');
INSERT INTO `ccs_tagvalue` VALUES ('13', 'DB200.10', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '机床1允许放料', null, null, '419901074472701952', '2022-08-15 11:11:58', '');
INSERT INTO `ccs_tagvalue` VALUES ('14', 'DB200.12', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '机床2允许取料', null, null, '419901074472701952', '2022-09-23 11:43:59', '');
INSERT INTO `ccs_tagvalue` VALUES ('15', 'DB200.14', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '机床2允许放料', null, null, '419901074472701952', '2022-08-15 11:11:58', '');
INSERT INTO `ccs_tagvalue` VALUES ('16', 'DB200.16', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '机床3允许取料', null, null, '419901074472701952', '2022-08-15 11:11:58', '');
INSERT INTO `ccs_tagvalue` VALUES ('17', 'DB200.18', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '机床3允许放料', null, null, '419901074472701952', '2022-08-15 11:11:59', '');
INSERT INTO `ccs_tagvalue` VALUES ('18', 'DB200.20', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '机床4允许取料', null, null, '419901074472701952', '2022-08-15 11:11:59', '');
INSERT INTO `ccs_tagvalue` VALUES ('19', 'DB200.22', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '机床4允许放料', null, null, '419901074472701952', '2022-08-15 11:11:59', '');
INSERT INTO `ccs_tagvalue` VALUES ('20', 'DB200.24', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '机床5允许取料', null, null, '419901074472701952', '2022-08-15 11:11:59', '');
INSERT INTO `ccs_tagvalue` VALUES ('21', 'DB200.26', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '机床5允许放料', null, null, '419901074472701952', '2022-08-15 11:11:59', '');
INSERT INTO `ccs_tagvalue` VALUES ('22', 'DB200.28', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '备用_5(RFID写入)', null, null, '419901074472701952', '2022-08-15 11:11:59', '');
INSERT INTO `ccs_tagvalue` VALUES ('23', 'DB200.30', '1', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '安全点', null, null, '419901074472701952', '2022-11-07 19:00:10', '');
INSERT INTO `ccs_tagvalue` VALUES ('62', 'DB200.32', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', 'plc系统状态', null, null, '419901074472701952', '2022-11-08 10:23:25', '');
INSERT INTO `ccs_tagvalue` VALUES ('63', 'DB200.34', '14', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', 'PLC报警内容', null, null, '419901074472701952', '2022-11-08 15:36:25', '');
INSERT INTO `ccs_tagvalue` VALUES ('64', 'DB200.36', '4', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', 'PLC三色灯状态', null, null, '419901074472701952', '2022-11-08 15:36:26', '');
INSERT INTO `ccs_tagvalue` VALUES ('65', 'DB200.40', '1', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '地轨所在工位', null, null, '419901074472701952', '2022-11-08 15:36:26', '');
INSERT INTO `ccs_tagvalue` VALUES ('66', 'DB200.42', '101', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', 'AGV是否有料', null, null, '419901074472701952', '2022-11-08 15:36:26', '');
INSERT INTO `ccs_tagvalue` VALUES ('67', 'DB200.44', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '当前任务ID', null, null, '419901074472701952', '2022-08-15 11:11:59', '');
INSERT INTO `ccs_tagvalue` VALUES ('68', 'DB200.46', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '源工位（取）', null, null, '419901074472701952', '2022-11-08 11:20:26', '');
INSERT INTO `ccs_tagvalue` VALUES ('69', 'DB200.50', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '执行结果(1.取执行2.取执行中3.取完成4.放执行5.放执行中6.放完成7.地轨移动8.移动完成9.机器人故障10.取故障11.放故障)', null, null, '419901074472701952', '2022-11-08 11:20:26', '');
INSERT INTO `ccs_tagvalue` VALUES ('70', 'DB200.52', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '机床6允许取料', null, null, '419901074472701952', '2022-11-04 14:11:41', '');
INSERT INTO `ccs_tagvalue` VALUES ('71', 'DB200.54', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '机床6允许放料', null, null, '419901074472701952', '2022-11-04 14:09:51', '');
INSERT INTO `ccs_tagvalue` VALUES ('144', 'DB200.56', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '机床7允许取料', null, null, '419900590890422272', '2022-11-08 10:23:26', '');
INSERT INTO `ccs_tagvalue` VALUES ('145', 'DB200.58', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '机床7允许放料', null, null, '419900590890422272', '2022-11-07 18:57:13', '');
INSERT INTO `ccs_tagvalue` VALUES ('146', 'DB200.300', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '哈默机床1程序编号', null, null, '419900590890422272', '2022-08-15 11:12:00', '');
INSERT INTO `ccs_tagvalue` VALUES ('147', 'DB200.302', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '哈默机床2程序编号', null, null, '419900590890422272', '2022-09-21 15:05:55', '');
INSERT INTO `ccs_tagvalue` VALUES ('148', 'DB200.304', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '哈默机床3程序编号', null, null, '419900590890422272', '2022-11-04 13:27:06', '');
INSERT INTO `ccs_tagvalue` VALUES ('149', 'DB200.306', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '哈默机床1程序编号已应用', null, null, '419900590890422272', '2022-08-15 11:12:00', '');
INSERT INTO `ccs_tagvalue` VALUES ('150', 'DB200.308', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '哈默机床2程序编号已应用', null, null, '419900590890422272', '2022-09-21 15:05:55', '');
INSERT INTO `ccs_tagvalue` VALUES ('151', 'DB200.310', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '哈默机床3程序编号已应用', null, null, '419900590890422272', '2022-08-15 11:12:00', '');
INSERT INTO `ccs_tagvalue` VALUES ('152', 'DB200.312', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '哈默机床1启动', null, null, '419900590890422272', '2022-08-15 11:12:00', '');
INSERT INTO `ccs_tagvalue` VALUES ('153', 'DB200.314', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '哈默机床2启动', null, null, '419900590890422272', '2022-09-21 15:05:58', '');
INSERT INTO `ccs_tagvalue` VALUES ('154', 'DB200.316', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '哈默机床3启动', null, null, '419900590890422272', '2022-08-15 11:12:01', '');
INSERT INTO `ccs_tagvalue` VALUES ('155', 'DB200.318', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '沈机机床4启动', null, null, '419900590890422272', '2022-11-01 19:14:48', '');
INSERT INTO `ccs_tagvalue` VALUES ('156', 'DB200.320', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '沈机机床5启动', null, null, '419900590890422272', '2022-08-15 11:12:01', '');
INSERT INTO `ccs_tagvalue` VALUES ('157', 'DB200.322', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '沈机机床6启动', null, null, '419900590890422272', '2022-11-04 14:10:10', '');
INSERT INTO `ccs_tagvalue` VALUES ('158', 'DB200.324', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '沈机机床7启动', null, null, '419900590890422272', '2022-11-07 18:57:35', '');
INSERT INTO `ccs_tagvalue` VALUES ('159', 'DB200.326', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '哈默机床1程序激活', null, null, '419900590890422272', '2022-11-08 16:48:01', '');
INSERT INTO `ccs_tagvalue` VALUES ('160', 'DB200.328', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '哈默机床2程序激活', null, null, '419900590890422272', '2022-11-08 16:43:45', '');
INSERT INTO `ccs_tagvalue` VALUES ('161', 'DB200.330', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '哈默机床3程序激活', null, null, '419900590890422272', '2022-11-01 18:07:39', '');
INSERT INTO `ccs_tagvalue` VALUES ('162', 'DB200.332', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '沈机机床4程序激活', null, null, '419900590890422272', '2022-08-15 11:12:01', '');
INSERT INTO `ccs_tagvalue` VALUES ('163', 'DB200.334', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '沈机机床5程序激活', null, null, '419900590890422272', '2022-08-15 11:12:01', '');
INSERT INTO `ccs_tagvalue` VALUES ('164', 'DB200.336', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '沈机机床6程序激活', null, null, '419900590890422272', '2022-11-04 14:10:10', '');
INSERT INTO `ccs_tagvalue` VALUES ('165', 'DB200.338', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '沈机机床7程序激活', null, null, '419900590890422272', '2022-11-07 18:57:36', '');
INSERT INTO `ccs_tagvalue` VALUES ('166', 'DB200.34', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.150', 'PLC报警内容', null, null, null, '2022-10-13 17:09:19', '');
INSERT INTO `ccs_tagvalue` VALUES ('167', 'DB300.388', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.186', '哈默机床1加工完成', null, null, null, '2022-11-08 11:41:45', '');
INSERT INTO `ccs_tagvalue` VALUES ('168', 'DB200.390', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.187', '哈默机床2加工完成', null, null, null, '2022-11-08 11:43:57', '');
INSERT INTO `ccs_tagvalue` VALUES ('169', 'DB200.392', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.188', '哈默机床3加工完成', null, null, null, '2022-11-08 11:43:57', '');
INSERT INTO `ccs_tagvalue` VALUES ('170', 'DB200.394', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.189', '沈机机床4加工完成', null, null, null, '2022-11-08 11:47:57', '');
INSERT INTO `ccs_tagvalue` VALUES ('171', 'DB200.396', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.190', '沈机机床5加工完成', null, null, null, '2022-11-08 11:47:57', '');
INSERT INTO `ccs_tagvalue` VALUES ('172', 'DB200.398', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.191', '沈机机床6加工完成', null, null, null, '2022-11-08 11:47:57', '');
INSERT INTO `ccs_tagvalue` VALUES ('173', 'DB200.400', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.192', '沈机机床7加工完成', null, null, null, '2022-11-08 11:47:57', '');
INSERT INTO `ccs_tagvalue` VALUES ('304', 'MainProg', '0000', 'String', 'NULL', 'FANUC', '192.168.11.192', '主程序', null, null, null, '2022-07-28 15:10:34', null);
INSERT INTO `ccs_tagvalue` VALUES ('305', 'Status', '1', 'String', 'NULL', 'FANUC', '192.168.11.192', null, null, null, null, '2022-08-15 13:32:39', null);
INSERT INTO `ccs_tagvalue` VALUES ('306', 'PowerOnTime', '126451', 'String', 'NULL', 'FANUC', '192.168.11.192', null, null, null, null, '2022-08-15 13:34:38', null);
INSERT INTO `ccs_tagvalue` VALUES ('307', 'ActSpindle', '0', 'String', 'NULL', 'FANUC', '192.168.11.192', null, null, null, null, '2022-07-28 15:11:34', null);
INSERT INTO `ccs_tagvalue` VALUES ('308', 'AccumulateCuttingTime', '', 'String', 'NULL', 'FANUC', '192.168.11.192', null, null, null, null, '2022-07-28 10:51:56', null);
INSERT INTO `ccs_tagvalue` VALUES ('400', 'DB200.18', '0', 'SHORT', null, 'S7_1500', '192.168.11.141', '三坐标左边检测完成1:good,2:waring,3:bad', null, null, null, '2022-10-25 15:09:39', null);
INSERT INTO `ccs_tagvalue` VALUES ('401', 'DB200.20', '0', 'SHORT', null, 'S7_1500', '192.168.11.141', '三坐标中间工位检测完成1:good,2:waring,3:bad', null, null, null, '2022-10-25 15:09:39', null);
INSERT INTO `ccs_tagvalue` VALUES ('402', 'DB200.22', '0', 'SHORT', null, 'S7_1500', '192.168.11.141', '三坐标右侧工位检测完成1:good,2:waring,3:bad', null, null, null, '2022-10-25 15:09:39', null);
INSERT INTO `ccs_tagvalue` VALUES ('403', 'DB200.0.0', '1', 'SHORT', null, 'S7_1500', '192.168.11.130', null, null, null, null, '2022-11-08 18:37:06', null);
INSERT INTO `ccs_tagvalue` VALUES ('500', 'DB200.50', '3', 'SHORT', null, 'S7_1500', '192.168.11.130', '跺机取放', null, null, null, '2022-11-08 18:06:47', null);
INSERT INTO `ccs_tagvalue` VALUES ('501', 'DB200.10', '0', 'SHORT', null, 'S7_1500', '192.168.11.130', '三坐标滑台中间工位可取', null, null, null, '2022-11-05 18:11:28', null);
INSERT INTO `ccs_tagvalue` VALUES ('502', 'DB200.12', '1', 'SHORT', null, 'S7_1500', '192.168.11.130', '三坐标滑台中间工位可放', null, null, null, '2022-11-08 18:34:58', null);
INSERT INTO `ccs_tagvalue` VALUES ('503', 'DB200.48', '0', 'SHORT', null, 'S7_1500', '192.168.11.170', '框体线清洗机执行结果', null, null, null, '2022-11-07 14:12:59', null);
INSERT INTO `ccs_tagvalue` VALUES ('600', 'DB200.24', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.130', '打标完成标志', null, null, null, '2022-11-08 18:37:08', null);
INSERT INTO `ccs_tagvalue` VALUES ('601', 'DB200.0', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.150', '心跳信号', null, null, '419901074472701952', '2022-11-08 10:22:15', '');
INSERT INTO `ccs_tagvalue` VALUES ('602', 'DB200.2', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.150', '机械手工作模式', '', '', '419901074472701952', '2022-11-08 11:51:42', '');
INSERT INTO `ccs_tagvalue` VALUES ('603', 'DB200.4', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.150', '工作状态', '', '', '419901074472701952', '2022-11-08 11:51:41', '');
INSERT INTO `ccs_tagvalue` VALUES ('604', 'DB200.30', '1', 'SHORT', 'NULL', 'S7_1500', '192.168.11.150', '安全点', null, null, '419901074472701952', '2022-11-08 11:51:30', '');
INSERT INTO `ccs_tagvalue` VALUES ('605', 'DB200.32', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.150', 'plc系统状态', null, null, '419901074472701952', '2022-11-08 11:55:20', '');
INSERT INTO `ccs_tagvalue` VALUES ('606', 'DB200.34', '29', 'SHORT', 'NULL', 'S7_1500', '192.168.11.150', 'PLC报警内容', null, null, '419901074472701952', '2022-11-07 18:06:36', '');
INSERT INTO `ccs_tagvalue` VALUES ('607', 'DB200.36', '3', 'SHORT', 'NULL', 'S7_1500', '192.168.11.150', 'PLC三色灯状态', null, null, '419901074472701952', '2022-11-08 11:47:34', '');
INSERT INTO `ccs_tagvalue` VALUES ('608', 'DB200.48', '0', 'SHORT', null, 'S7_1500', '192.168.11.150', '舱体线清洗机执行结果', null, null, null, '2022-11-07 14:12:59', null);
INSERT INTO `ccs_tagvalue` VALUES ('609', 'DB200.50', '6', 'SHORT', 'NULL', 'S7_1500', '192.168.11.150', '执行结果(1.取执行2.取执行中3.取完成4.放执行5.放执行中6.放完成7.地轨移动8.移动完成9.机器人故障10.取故障11.放故障)', null, null, '419901074472701952', '2022-11-08 11:51:31', '');

-- ----------------------------
-- Table structure for ccs_task_callback
-- ----------------------------
DROP TABLE IF EXISTS `ccs_task_callback`;
CREATE TABLE `ccs_task_callback` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ip` varchar(50) NOT NULL COMMENT 'IP',
  `port` varchar(10) DEFAULT NULL COMMENT '端口',
  `task_id` varchar(50) NOT NULL COMMENT '任务id',
  `task_node_id` varchar(50) DEFAULT NULL COMMENT '任务节点',
  `operate_name` varchar(50) DEFAULT NULL COMMENT '操作名称',
  `operate_type` varchar(50) DEFAULT NULL COMMENT '操作类型',
  `address` varchar(50) DEFAULT NULL COMMENT '点位',
  `address2` varchar(50) DEFAULT NULL COMMENT '点位2',
  `address3` varchar(50) DEFAULT NULL COMMENT '点位3',
  `callback_value` varchar(20) DEFAULT NULL COMMENT '目标值',
  `callback_value2` varchar(20) DEFAULT NULL COMMENT '目标值2',
  `callback_value3` varchar(20) DEFAULT NULL COMMENT '目标值3',
  `state` bit(1) NOT NULL DEFAULT b'1' COMMENT '1表示需回调 0表示已回调',
  `data` varchar(100) DEFAULT NULL COMMENT '参数',
  `fail_address` varchar(20) DEFAULT NULL,
  `fail_address2` varchar(20) DEFAULT NULL,
  `fail_address3` varchar(20) DEFAULT NULL,
  `success_reset_address` varchar(20) DEFAULT NULL,
  `success_reset_address2` varchar(20) DEFAULT NULL,
  `success_reset_value` varchar(20) DEFAULT NULL,
  `success_reset_value2` varchar(20) DEFAULT NULL,
  `callback_fail_value` varchar(20) DEFAULT NULL,
  `callback_fail_value2` varchar(20) DEFAULT NULL,
  `callback_fail_value3` varchar(100) DEFAULT NULL,
  `description` varchar(100) DEFAULT NULL,
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  UNIQUE KEY `pk_id` (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=469 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of ccs_task_callback
-- ----------------------------

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` varchar(32) NOT NULL,
  `login_name` varchar(50) NOT NULL,
  `password` varchar(50) DEFAULT NULL,
  `gender` varchar(10) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', '22', '1', '1', '2022-06-12 15:34:50');
