imcs_ccs/sql/ccs_yj.sql

/*
Navicat MySQL Data Transfer

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

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

Date: 2022-08-17 20:31:56
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for ccs_action
-- ----------------------------
DROP TABLE IF EXISTS `ccs_action`;
CREATE TABLE `ccs_action` (
  `id` int(10) 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=46 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of ccs_action
-- ----------------------------
INSERT INTO `ccs_action` VALUES ('31', '192.168.170.71', 'S7_1500', 'GetFlexibleWire', '柔性线取物品', null, '', null, null);
INSERT INTO `ccs_action` VALUES ('32', '192.168.170.71', 'S7_1500', 'SendFlexibleWire', '柔性线送物品', null, '', null, null);
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.170.70', 'S7_1500', 'MoveRobotPosition', '柔性线机器人移动物品', null, '', null, null);
INSERT INTO `ccs_action` VALUES ('36', '192.168.170.61', 'S7_1500', 'StartCoordinateMeasuringMachine', '启动三坐标', null, null, null, null);
INSERT INTO `ccs_action` VALUES ('37', '1', 'S7_1500', 'StartLabelMachine', '启动打标机', null, null, null, null);
INSERT INTO `ccs_action` VALUES ('38', '192.168.170.71', '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);

-- ----------------------------
-- 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=52 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.46', 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.326', '1', '
', '1');
INSERT INTO `ccs_action_address` VALUES ('34', '40', 'WRITE', 'DB200.314', '1', '
', '1');
INSERT INTO `ccs_action_address` VALUES ('35', '40', 'CHECK', '', '', '
', '1');
INSERT INTO `ccs_action_address` VALUES ('36', '40', 'CALLBACK', 'DB200.328', '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.330', '1', '
', '1');
INSERT INTO `ccs_action_address` VALUES ('40', '42', 'WRITE', 'DB200.318', null, '
', '1');
INSERT INTO `ccs_action_address` VALUES ('41', '42', 'CHECK', '', '', '
', '1');
INSERT INTO `ccs_action_address` VALUES ('42', '42', 'CALLBACK', 'DB200.332', '', '
', '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.334', '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.336', '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', '
', '1');
INSERT INTO `ccs_action_address` VALUES ('51', '45', 'CALLBACK', 'DB200.338', null, '
', '1');

-- ----------------------------
-- Table structure for ccs_device
-- ----------------------------
DROP TABLE IF EXISTS `ccs_device`;
CREATE TABLE `ccs_device` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `ip` varchar(20) NOT NULL,
  `user_name` varchar(20) DEFAULT NULL,
  `port` int(10) 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=13 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', '
', '
', '框体线CPU PLC');
INSERT INTO `ccs_device` VALUES ('5', '192.168.11.171', '', '102', null, '192.168.11.171', 'S7_1500', '\0', '\0', '框体线HMI 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', '\0', '\0', '沈机机床1');
INSERT INTO `ccs_device` VALUES ('10', '192.168.11.190', null, '8193', null, '192.168.11.190', 'FANUC', '\0', '\0', '沈机机床2');
INSERT INTO `ccs_device` VALUES ('11', '192.168.11.191', null, '8193', null, '192.168.11.191', 'FANUC', '\0', '\0', '沈机机床3');
INSERT INTO `ccs_device` VALUES ('12', '192.168.11.192', null, '8193', null, '192.168.11.192', 'FANUC', '
', '
', '沈机机床4');

-- ----------------------------
-- Table structure for ccs_dictionary
-- ----------------------------
DROP TABLE IF EXISTS `ccs_dictionary`;
CREATE TABLE `ccs_dictionary` (
  `id` int(10) 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=19 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', '
');

-- ----------------------------
-- 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,
  `type` varchar(45) DEFAULT NULL,
  `description` varchar(45) DEFAULT NULL,
  `address` varchar(45) DEFAULT NULL,
  `address2` varchar(45) DEFAULT NULL,
  `source` varchar(45) DEFAULT NULL,
  `status` varchar(45) DEFAULT NULL,
  `line` varchar(45) DEFAULT NULL,
  `location` varchar(45) DEFAULT NULL,
  `control_status` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of ccs_equipment_monitor
-- ----------------------------
INSERT INTO `ccs_equipment_monitor` VALUES ('3', null, '舱体_清洗机舱体_清洗机舱体_清洗机舱体_清洗机舱体舱体_清洗机', null, 'cnc', null, null, null, null, '生产中', '舱体线', '121', null);
INSERT INTO `ccs_equipment_monitor` VALUES ('7', null, '舱体_FP1000—五轴', null, 'cnc', null, null, null, null, '在线', '舱体线', '122', null);
INSERT INTO `ccs_equipment_monitor` VALUES ('8', null, '舱体_DMU 125P-FD(不进线)', null, 'cnc', null, null, null, null, '在线', '舱体线', '123', null);
INSERT INTO `ccs_equipment_monitor` VALUES ('9', null, '舱体_DMU 100P duoBLOCK-1', null, 'cnc', null, null, null, null, '线', '舱体线', '124', null);
INSERT INTO `ccs_equipment_monitor` VALUES ('10', null, '舱体_DMU 100P duoBLOCK-2', null, 'cnc', null, null, null, null, '/t--1', '舱体线', '125', null);
INSERT INTO `ccs_equipment_monitor` VALUES ('11', null, '舱体_DMU 100P duoBLOCK-3', null, 'cnc', null, null, null, null, '在线', '舱体线', '126', null);
INSERT INTO `ccs_equipment_monitor` VALUES ('14', null, '框体_清洗机', null, 'cnc', null, null, null, null, '生气', '舱体线', '127', null);
INSERT INTO `ccs_equipment_monitor` VALUES ('18', null, '框体_哈默五轴C650U-1', null, 'cnc', null, null, null, null, '在线', '舱体线', '128', null);
INSERT INTO `ccs_equipment_monitor` VALUES ('19', null, '框体_哈默五轴C650U-2', null, 'cnc', null, null, null, null, '生！@', '舱体线', '129', null);
INSERT INTO `ccs_equipment_monitor` VALUES ('20', null, '框体_哈默五轴C650U-3', null, 'cnc', null, null, null, null, '生产中', '舱体线', '130', null);
INSERT INTO `ccs_equipment_monitor` VALUES ('21', null, '框体_VMC1300B三轴-1', null, 'cnc', null, null, null, null, '/t', '舱体线', '131', null);
INSERT INTO `ccs_equipment_monitor` VALUES ('22', null, '框体_VMC1300B三轴-2', null, 'cnc', null, null, null, null, '在线', '框体线', '121', null);
INSERT INTO `ccs_equipment_monitor` VALUES ('23', null, '框体_VMC1300B三轴-3', null, 'cnc', null, null, null, null, '在线', '框体线', '122', null);
INSERT INTO `ccs_equipment_monitor` VALUES ('24', null, '框体_VMC1300B三轴-4', null, 'cnc', null, null, null, null, '在线', '框体线', '123', null);
INSERT INTO `ccs_equipment_monitor` VALUES ('34', null, '保障中心_dabiao', null, 'cnc', null, null, null, null, '生产中', '框体线', '124', null);
INSERT INTO `ccs_equipment_monitor` VALUES ('36', null, '保障中心_三坐标', null, 'cnc', null, null, null, null, '生产中', '框体线', '125', null);
INSERT INTO `ccs_equipment_monitor` VALUES ('10001', null, 'AGV01', null, 'agv', null, null, null, null, '空闲', '框体线', '126', null);
INSERT INTO `ccs_equipment_monitor` VALUES ('10002', null, 'AGV02', null, 'agv', null, null, null, null, '空闲', '框体线', '127', null);
INSERT INTO `ccs_equipment_monitor` VALUES ('10003', null, 'AGV03', null, 'agv', null, null, null, null, '生产中', '框体线', '128', null);
INSERT INTO `ccs_equipment_monitor` VALUES ('10004', null, 'AGV04', null, 'agv', null, null, null, null, '充电中', '框体线', '129', null);
INSERT INTO `ccs_equipment_monitor` VALUES ('10005', null, 'AGV05', null, 'agv', null, null, null, null, '空闲', '框体线', '130', null);

-- ----------------------------
-- 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=309 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of ccs_tagvalue
-- ----------------------------
INSERT INTO `ccs_tagvalue` VALUES ('8', 'DB200.0', '1', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '心跳信号', null, null, '419901074472701952', '2022-08-17 14:47:00', '
');
INSERT INTO `ccs_tagvalue` VALUES ('9', 'DB200.2', '4', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '机械手工作模式', '', '', '419901074472701952', '2022-08-17 14:44:09', '
');
INSERT INTO `ccs_tagvalue` VALUES ('10', 'DB200.4', '1', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '工作状态', '', '', '419901074472701952', '2022-08-17 14:45: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', '1', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '机床2允许取料', null, null, '419901074472701952', '2022-08-17 14:43:55', '
');
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-08-17 14:44:10', '
');
INSERT INTO `ccs_tagvalue` VALUES ('62', 'DB200.32', '1', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', 'plc系统状态', null, null, '419901074472701952', '2022-08-17 14:43:56', '
');
INSERT INTO `ccs_tagvalue` VALUES ('63', 'DB200.34', '1', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', 'PLC报警内容', null, null, '419901074472701952', '2022-08-17 14:43:56', '
');
INSERT INTO `ccs_tagvalue` VALUES ('64', 'DB200.36', '3', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', 'PLC三色灯状态', null, null, '419901074472701952', '2022-08-17 14:43:56', '
');
INSERT INTO `ccs_tagvalue` VALUES ('65', 'DB200.40', '8', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '地轨所在工位', null, null, '419901074472701952', '2022-08-17 13:26:01', '
');
INSERT INTO `ccs_tagvalue` VALUES ('66', 'DB200.42', '100', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', 'AGV是否有料', null, null, '419901074472701952', '2022-08-17 09:10:23', '
');
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', '133', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '源工位（取）', null, null, '419901074472701952', '2022-08-17 09:10:23', '
');
INSERT INTO `ccs_tagvalue` VALUES ('69', 'DB200.50', '8', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '执行结果(1.取执行2.取执行中3.取完成4.放执行5.放执行中6.放完成7.地轨移动8.移动完成9.机器人故障10.取故障11.放故障)', null, null, '419901074472701952', '2022-08-17 09:13:16', '
');
INSERT INTO `ccs_tagvalue` VALUES ('70', 'DB200.52', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '机床6允许取料', null, null, '419901074472701952', '2022-08-15 11:12:00', '
');
INSERT INTO `ccs_tagvalue` VALUES ('71', 'DB200.54', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '机床6允许放料', null, null, '419901074472701952', '2022-08-15 11:12:00', '
');
INSERT INTO `ccs_tagvalue` VALUES ('144', 'DB200.56', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '机床7允许取料', null, null, '419900590890422272', '2022-08-15 11:12:00', '
');
INSERT INTO `ccs_tagvalue` VALUES ('145', 'DB200.58', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '机床7允许放料', null, null, '419900590890422272', '2022-08-16 17:21:39', '
');
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-08-15 11:12:00', '
');
INSERT INTO `ccs_tagvalue` VALUES ('148', 'DB200.304', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '哈默机床3程序编号', null, null, '419900590890422272', '2022-08-15 11:12:00', '
');
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-08-15 11:12:00', '
');
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-08-15 11:12:01', '
');
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-08-15 11:12:01', '
');
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-08-15 11:12:01', '
');
INSERT INTO `ccs_tagvalue` VALUES ('158', 'DB200.324', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '沈机机床7启动', null, null, '419900590890422272', '2022-08-15 11:12:01', '
');
INSERT INTO `ccs_tagvalue` VALUES ('159', 'DB200.326', '1', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '哈默机床1程序激活', null, null, '419900590890422272', '2022-08-17 14:43:58', '
');
INSERT INTO `ccs_tagvalue` VALUES ('160', 'DB200.328', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '哈默机床2程序激活', null, null, '419900590890422272', '2022-08-15 11:12:01', '
');
INSERT INTO `ccs_tagvalue` VALUES ('161', 'DB200.330', '1', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '哈默机床3程序激活', null, null, '419900590890422272', '2022-08-17 14:43:58', '
');
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-08-15 11:12:01', '
');
INSERT INTO `ccs_tagvalue` VALUES ('165', 'DB200.338', '0', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '沈机机床7程序激活', null, null, '419900590890422272', '2022-08-15 11:12:01', '
');
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);

-- ----------------------------
-- Table structure for ccs_task_callback
-- ----------------------------
DROP TABLE IF EXISTS `ccs_task_callback`;
CREATE TABLE `ccs_task_callback` (
  `id` int(10) 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(20) 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=12 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of ccs_task_callback
-- ----------------------------
INSERT INTO `ccs_task_callback` VALUES ('1', '192.168.11.170', null, '1', '1', '质量中心取物品', 'GetQualityCenter', 'DB200.50', null, null, '3', null, null, '
', null, 'DB200.50', 'DB200.50', null, null, null, null, null, '9', '10', null, null, '2022-08-16 15:10:52', '2022-08-16 15:10:52');
INSERT INTO `ccs_task_callback` VALUES ('2', '192.168.11.170', null, '1', '1', '质量中心取物品', 'GetQualityCenter', 'DB200.50', null, null, '3', null, null, '
', null, 'DB200.50', 'DB200.50', null, null, null, null, null, '9', '10', null, null, '2022-08-16 15:17:06', '2022-08-16 15:17:06');
INSERT INTO `ccs_task_callback` VALUES ('3', '192.168.11.170', null, '1', '1', '质量中心取物品', 'GetQualityCenter', 'DB200.50', null, null, '3', null, null, '
', null, 'DB200.50', 'DB200.50', null, null, null, null, null, '9', '10', null, null, '2022-08-16 15:34:28', '2022-08-16 15:34:28');
INSERT INTO `ccs_task_callback` VALUES ('4', '192.168.11.170', null, '1', '1', '质量中心送物品', 'SendQualityCenter', 'DB200.50', null, null, '6', null, null, '
', null, 'DB200.50', null, null, null, null, null, null, '10', null, null, null, '2022-08-16 15:47:05', '2022-08-16 15:47:05');
INSERT INTO `ccs_task_callback` VALUES ('5', '192.168.11.170', null, '1', '1', '质量中心送物品', 'SendQualityCenter', 'DB200.50', null, null, '6', null, null, '
', null, 'DB200.50', null, null, null, null, null, null, '10', null, null, null, '2022-08-16 15:51:11', '2022-08-16 15:51:11');
INSERT INTO `ccs_task_callback` VALUES ('6', '192.168.11.170', null, '1', '1', '质量中心取物品', 'GetQualityCenter', 'DB200.50', null, null, '3', null, null, '
', null, 'DB200.50', 'DB200.50', null, null, null, null, null, '9', '10', null, null, '2022-08-17 14:49:43', '2022-08-17 14:49:43');
INSERT INTO `ccs_task_callback` VALUES ('7', '192.168.11.170', null, '1', '1', '质量中心送物品', 'SendQualityCenter', 'DB200.50', null, null, '6', null, null, '
', null, 'DB200.50', null, null, null, null, null, null, '10', null, null, null, '2022-08-17 14:54:24', '2022-08-17 14:54:24');
INSERT INTO `ccs_task_callback` VALUES ('8', '192.168.11.170', null, '1', '1', '质量中心取物品', 'GetQualityCenter', 'DB200.50', null, null, '3', null, null, '
', null, 'DB200.50', 'DB200.50', null, null, null, null, null, '9', '10', null, null, '2022-08-17 15:16:20', '2022-08-17 15:16:20');
INSERT INTO `ccs_task_callback` VALUES ('9', '192.168.11.170', null, '1', '1', '质量中心取物品', 'GetQualityCenter', 'DB200.50', null, null, '3', null, null, '
', null, 'DB200.50', 'DB200.50', null, null, null, null, null, '9', '10', null, null, '2022-08-17 15:19:20', '2022-08-17 15:19:20');
INSERT INTO `ccs_task_callback` VALUES ('10', '192.168.11.170', null, '1', '1', '质量中心送物品', 'SendQualityCenter', 'DB200.50', null, null, '6', null, null, '
', null, 'DB200.50', null, null, null, null, null, null, '10', null, null, null, '2022-08-17 15:20:44', '2022-08-17 15:20:44');
INSERT INTO `ccs_task_callback` VALUES ('11', '192.168.11.170', null, '1', '1', '质量中心取物品', 'GetQualityCenter', 'DB200.50', null, null, '3', null, null, '
', null, 'DB200.50', 'DB200.50', null, null, null, null, null, '9', '10', null, null, '2022-08-17 15:48:06', '2022-08-17 15:48:06');

-- ----------------------------
-- 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');