300_ccs/sql/ccs_300.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_300

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

Date: 2023-11-13 16:22:33
*/

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

-- ----------------------------
-- Records of ccs_action
-- ----------------------------
INSERT INTO `ccs_action` VALUES ('1', '192.168.3.15', 'S7_1500', 'RobotAction', '机器人取放动作', null, '', null, null);
INSERT INTO `ccs_action` VALUES ('2', '192.168.3.100', 'HEIDEHAIN', 'StartNCProgram', '海德汉机床1启动程序', '', '192.168.3.15', null, null);
INSERT INTO `ccs_action` VALUES ('3', '192.168.11.164', 'OPCUA', 'StartNCProgram', '西门子机床2启动程序', null, '192.168.11.150', null, null);
INSERT INTO `ccs_action` VALUES ('4', '192.168.3.15', 'S7_1500', 'StartCleanMachine', '启动清洗', null, '', null, null);
INSERT INTO `ccs_action` VALUES ('5', '192.168.3.15', 'S7_1500', 'StartDryMachine', '启动吹气', 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',
  `action_name` varchar(100) DEFAULT NULL COMMENT '动作名称',
  `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 '顺序',
  `description` varchar(100) DEFAULT NULL COMMENT '描述',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of ccs_action_address
-- ----------------------------
INSERT INTO `ccs_action_address` VALUES ('1', '1', '机器人取放动作', 'WRITE', 'DB300.100', null, '
', '1', '起始地址');
INSERT INTO `ccs_action_address` VALUES ('2', '1', '机器人取放动作', 'WRITE', 'DB300.102', '', '
', '2', '目标地址');
INSERT INTO `ccs_action_address` VALUES ('3', '1', '机器人取放动作', 'WRITE', 'DB300.106', '1', '
', '3', '流程启动操作');
INSERT INTO `ccs_action_address` VALUES ('4', '1', '机器人取放动作', 'CHECK', 'DB300.1.0', 'True', '
', '1', '心跳信号（机器人）');
INSERT INTO `ccs_action_address` VALUES ('6', '1', '机器人取放动作', 'CALLBACK', 'DB300.0.1', 'True', '
', '2', '无流程运行（机器人）');
INSERT INTO `ccs_action_address` VALUES ('7', '1', '机器人取放动作', 'CALLBACK_FAIL', 'DB300.0.6', 'True', '
', '1', '故障信号（机器人）');
INSERT INTO `ccs_action_address` VALUES ('8', '1', '机器人取放动作', 'CALLBACK_FAIL', 'DB300.0.7', 'True', '
', '2', '急停2被拍下（机器人）');
INSERT INTO `ccs_action_address` VALUES ('9', '1', '机器人取放动作', 'CHECK_SUCESS', 'DB300.0.0', 'True', '
', '1', '流程运行中（机器人）');
INSERT INTO `ccs_action_address` VALUES ('10', '1', '机器人取放动作', 'CHECK', 'DB300.0.6', 'True', '
', '1', '故障信号（机器人）');
INSERT INTO `ccs_action_address` VALUES ('41', '4', '启动清洗机', 'CHECK', 'DB300.1.0', 'True', '
', '1', '心跳信号（机器人）');
INSERT INTO `ccs_action_address` VALUES ('42', '4', '启动清洗机', 'CALLBACK', 'DB300.150.6', 'True', '
', '2', '吹气运行状态（清洗机');
INSERT INTO `ccs_action_address` VALUES ('43', '4', '启动清洗机', 'CALLBACK_FAIL', 'DB300.0.6', 'True', '
', '1', '故障信号（机器人）');
INSERT INTO `ccs_action_address` VALUES ('44', '4', '启动清洗机', 'CALLBACK_FAIL', 'DB300.0.7', 'True', '
', '2', '急停2被拍下（机器人）');
INSERT INTO `ccs_action_address` VALUES ('51', '5', '启动吹气', 'CHECK', 'DB300.1.0', 'True', '
', '1', '心跳信号（机器人）');
INSERT INTO `ccs_action_address` VALUES ('52', '5', '启动吹气', 'CALLBACK', 'DB300.150.5', 'True', '
', '2', '吹气运行状态（清洗机');
INSERT INTO `ccs_action_address` VALUES ('53', '5', '启动吹气', 'CALLBACK_FAIL', 'DB300.0.7', 'True', '
', '1', '故障信号（机器人）');
INSERT INTO `ccs_action_address` VALUES ('54', '5', '启动吹气', 'CALLBACK_FAIL', 'DB300.0.1', 'True', '
', '2', '急停2被拍下（机器人）');
INSERT INTO `ccs_action_address` VALUES ('60', '2', '机床1启动', 'CALLBACK', 'DB300.6.5', 'True', '
', '2', '加工完成信号（五轴1机床');
INSERT INTO `ccs_action_address` VALUES ('70', '3', '机床2启动', 'CALLBACK', 'DB300.10.5', 'True', '
', '2', '加工完成信号（五轴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,
  `disconnect_update_time` datetime DEFAULT NULL COMMENT '掉线上线更新时间',
  `offline_update_time` datetime DEFAULT NULL COMMENT '离线进线更新时间',
  `timeout_remind_duration` decimal(5,2) DEFAULT NULL COMMENT '超时提醒时长',
  UNIQUE KEY `pk_id` (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of ccs_device
-- ----------------------------
INSERT INTO `ccs_device` VALUES ('1', '192.168.3.15', null, '102', null, '192.168.3.15', 'S7_1500', '
', '
', 'PLC总控', '2023-05-12 20:13:05', '2023-04-24 09:36:04', '0.00');
INSERT INTO `ccs_device` VALUES ('2', '192.168.3.100', 'eth01', '1900', null, '192.168.3.100', 'HEIDEHAIN', '\0', '
', '机床1', '2023-06-17 11:37:13', '2023-05-30 00:21:04', '0.00');
INSERT INTO `ccs_device` VALUES ('3', '192.168.11.164', 'OpcUaClient', '4840', '123456', 'opc.tcp://192.168.11.164:4840', 'OPCUA', '\0', '
', '机床2', '2023-06-17 12:06:50', '2023-06-17 12:06:56', '0.00');

-- ----------------------------
-- 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) COLLATE utf8mb4_bin NOT NULL COMMENT '类型',
  `code` varchar(100) COLLATE utf8mb4_bin NOT NULL COMMENT '编码',
  `name` varchar(64) COLLATE utf8mb4_bin NOT NULL COMMENT '名称',
  `dict_value` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '值',
  `description` varchar(255) COLLATE utf8mb4_bin DEFAULT '' COMMENT '描述',
  `state` bit(1) NOT NULL DEFAULT b'1' COMMENT '1表示启用 0表示停用',
  UNIQUE KEY `pk_id` (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=122 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin 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', '192.168.11.130', '1', '1', '总控急停按钮被拍下', '保障中心总控急停按钮被拍下，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('20', '192.168.11.130', '2', '2', '安全门1急停被拍下', '保障中心安全门1急停被拍下，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('21', '192.168.11.130', '3', '3', '安全门2急停被拍', '保障中心安全门2急停被拍下，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('22', '192.168.11.130', '4', '4', '装配平台1急停被拍下', '保障中心上下料站1急停被拍下，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('23', '192.168.11.130', '5', '5', '装配平台2急停被拍下', '保障中心上下料站2急停被拍下，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('24', '192.168.11.130', '6', '6', '装配平台3急停被拍下', '保障中心上下料站3急停被拍下，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('25', '192.168.11.130', '7', '7', '装配平台4急停被拍下', '保障中心上下料站4急停被拍下，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('26', '192.168.11.130', '8', '8', '装配平台5急停被拍下', '保障中心上下料站5急停被拍下，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('27', '192.168.11.130', '9', '9', '装配平台6急停被拍下', '保障中心上下料站6急停被拍下，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('28', '192.168.11.130', '10', '10', '安全门1被打开', '保障中心安全门1被打开，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('29', '192.168.11.130', '11', '11', '安全门2被打开', '保障中心安全门2被打开，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('30', '192.168.11.130', '12', '12', 'X轴伺服驱动器故障', '保障中心伺服舵机X轴伺服驱动器故障，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('31', '192.168.11.130', '13', '13', 'Y轴伺服驱动器故障', '保障中心伺服舵机Y轴伺服驱动器故障，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('32', '192.168.11.130', '14', '14', 'Z轴伺服驱动器故障', '保障中心伺服舵机Z轴伺服驱动器故障，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('33', '192.168.11.130', '15', '15', 'B轴伺服驱动器故障', '保障中心伺服舵机B轴伺服驱动器故障，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('34', '192.168.11.130', '16', '16', 'X轴负软限位报警', '保障中心伺服舵机X轴负软限位报警，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('35', '192.168.11.130', '17', '17', 'X轴正软限位报警', '保障中心伺服舵机X轴正软限位报警，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('36', '192.168.11.130', '18', '18', 'Y轴负软限位报警', '保障中心伺服舵机Y轴负软限位报警，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('37', '192.168.11.130', '19', '19', 'Y轴正软限位报警', '保障中心伺服舵机Y轴正软限位报警，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('38', '192.168.11.130', '20', '20', 'Z轴负软限位报警', '保障中心伺服舵机Z轴负软限位报警，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('39', '192.168.11.130', '21', '21', 'Z轴正软限位报警', '保障中心伺服舵机Z轴正软限位报警，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('40', '192.168.11.130', '22', '22', 'B轴负软限位报警', '保障中心伺服舵机B轴负软限位报警，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('41', '192.168.11.130', '23', '23', 'B轴正软限位报警', '保障中心伺服舵机B轴正软限位报警，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('42', '192.168.11.130', '24', '24', '气源异常', '保障中心气源异常，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('43', '192.168.11.130', '25', '25', '润滑油位低', '保障中心伺服舵机润滑油位低，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('44', '192.168.11.130', '26', '26', '伺服使能未打开', '保障中心伺服舵机伺服使能未打开，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('45', '192.168.11.130', '27', '27', 'X轴零点丢失', '保障中心伺服舵机X轴零点丢失，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('46', '192.168.11.130', '28', '28', 'Y轴零点丢失', '保障中心伺服舵机Y轴零点丢失，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('47', '192.168.11.130', '29', '29', 'Z轴零点丢失', '保障中心伺服舵机Z轴零点丢失，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('48', '192.168.11.130', '30', '30', 'B轴零点丢失', '保障中心伺服舵机B轴零点丢失，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('49', '192.168.11.130', '41', '41', '三坐标按钮盒急停按钮被拍下', '保障中心三坐标按钮盒急停按钮被拍下，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('50', '192.168.11.130', '42', '42', '三坐标电箱急停按钮被拍下', '保障中心三坐标电箱急停按钮被拍下，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('51', '192.168.11.130', '43', '43', '三坐标气源报警', '保障中心三坐标气源报警，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('52', '192.168.11.130', '44', '44', '三坐标横行左移未到位', '保障中心三坐标横行左移未到位，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('53', '192.168.11.130', '45', '45', '三坐标横行右移未到位', '保障中心三坐标横行右移未到位，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('54', '192.168.11.130', '46', '46', '三坐标交互工位1顶缸上升未到位', '保障中心三坐标交互工位1顶缸上升未到位，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('55', '192.168.11.130', '47', '47', '三坐标交互工位1顶缸下降未到位', '保障中心三坐标交互工位1顶缸下降未到位，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('56', '192.168.11.130', '48', '48', '三坐标交互工位2顶缸上升未到位', '保障中心三坐标交互工位2顶缸上升未到位，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('57', '192.168.11.130', '49', '49', '三坐标交互工位2顶缸下降未到位', '保障中心三坐标交互工位2顶缸下降未到位，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('58', '192.168.11.130', '50', '50', '三坐标检测工位正向挡缸阻挡未到位', '保障中心三坐标检测工位正向挡缸阻挡未到位，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('59', '192.168.11.130', '51', '51', '三坐标检测工位正向挡缸释放未到位', '保障中心三坐标检测工位正向挡缸释放未到位，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('60', '192.168.11.130', '52', '52', '三坐标检测工位反向挡缸阻挡未到位', '保障中心三坐标检测工位反向挡缸阻挡未到位，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('61', '192.168.11.130', '53', '53', '三坐标检测工位反向挡缸释放未到位', '保障中心三坐标检测工位反向挡缸释放未到位，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('62', '192.168.11.130', '54', '54', '三坐标检测工位顶缸上升未到位', '保障中心三坐标检测工位顶缸上升未到位，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('63', '192.168.11.130', '55', '55', '三坐标检测工位顶缸下降未到位', '保障中心三坐标检测工位顶缸下降未到位，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('64', '192.168.3.15', '1', '1', '总控急停按钮被拍下', '框体线总控急停按钮被拍下，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('65', '192.168.3.15', '2', '2', '安全围栏门1急停按钮被拍下', '框体线安全围栏门1急停按钮被拍下，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('66', '192.168.3.15', '3', '3', '安全围栏门2急停按钮被拍下', '框体线安全围栏门2急停按钮被拍下，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('67', '192.168.3.15', '4', '4', '机床维护门1急停按钮被拍下', '框体线机床维护门1急停按钮被拍下，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('68', '192.168.3.15', '5', '5', '机床维护门2急停按钮被拍下', '框体线机床维护门2急停按钮被拍下，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('69', '192.168.3.15', '6', '6', '机床维护门3急停按钮被拍下', '框体线机床维护门3急停按钮被拍下，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('70', '192.168.3.15', '7', '7', '关节机器人急停被拍下', '框体线关节机器人急停被拍下，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('71', '192.168.3.15', '8', '8', '安全围栏门1被打开', '框体线安全围栏门1被打开，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('72', '192.168.3.15', '9', '9', '安全围栏门2被打开', '框体线安全围栏门2被打开，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('73', '192.168.3.15', '10', '10', '机床维护门1被打开', '框体线机床维护门1被打开，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('74', '192.168.3.15', '11', '11', '机床维护门2被打开', '框体线机床维护门2被打开，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('75', '192.168.3.15', '12', '12', '机床维护门3被打开', '框体线机床维护门3被打开，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('76', '192.168.3.15', '13', '13', '关节机器人故障', '框体线机床关节机器人故障，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('77', '192.168.3.15', '14', '14', 'U地轨伺服驱动器故障', '框体线U地轨伺服驱动器故障，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('78', '192.168.3.15', '15', '15', '地轨自动润滑油位低', '框体线地轨自动润滑油位低，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('79', '192.168.3.15', '16', '16', '液压站油位低', '框体线液压站油位低，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('80', '192.168.3.15', '17', '17', '机床维护门1升降缸上升未到位', '框体线机床维护门1升降缸上升未到位，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('81', '192.168.3.15', '18', '18', '机床维护门1升降缸下降未到位', '框体线机床维护门1升降缸下降未到位，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('82', '192.168.3.15', '19', '19', '机床维护门2升降缸上升未到位', '框体线机床维护门2升降缸上升未到位，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('83', '192.168.3.15', '20', '20', '机床维护门2升降缸下降未到位', '框体线机床维护门2升降缸下降未到位，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('84', '192.168.3.15', '21', '21', '机床维护门3升降缸上升未到位', '框体线机床维护门3升降缸上升未到位，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('85', '192.168.3.15', '22', '22', '机床维护门3升降缸下降未到位', '框体线机床维护门3升降缸下降未到位，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('86', '192.168.3.15', '23', '23', '液压站总压力异常', '框体线液压站总压力异常，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('87', '192.168.3.15', '24', '24', '液压站高温报警', '框体线液压站高温报警，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('88', '192.168.3.15', '25', '25', '液压站夹紧流量异常', '框体线液压站夹紧流量异常，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('89', '192.168.3.15', '26', '26', '联轴器夹紧压力异常', '框体线联轴器夹紧压力异常，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('90', '192.168.3.15', '27', '27', '联轴器松开压力异常', '框体线联轴器松开压力异常，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('91', '192.168.3.15', '28', '28', '放动作托盘检测异常', '框体线放动作托盘检测异常，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('92', '192.168.3.15', '29', '29', '地轨位置与工位号不匹配', '框体线地轨位置与工位号不匹配，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('93', '192.168.3.15', '1', '1', '总控急停按钮被拍下', '舱体线总控急停按钮被拍下，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('94', '192.168.3.15', '2', '2', '安全围栏门1急停按钮被拍下', '舱体线安全围栏门1急停按钮被拍下，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('95', '192.168.3.15', '3', '3', '安全围栏门2急停按钮被拍下', '舱体线安全围栏门2急停按钮被拍下，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('96', '192.168.3.15', '4', '4', '机床维护门1急停按钮被拍下', '舱体线机床维护门1急停按钮被拍下，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('97', '192.168.3.15', '5', '5', '机床维护门2急停按钮被拍下', '舱体线机床维护门2急停按钮被拍下，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('98', '192.168.3.15', '6', '6', '机床维护门3急停按钮被拍下', '舱体线机床维护门3急停按钮被拍下，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('99', '192.168.3.15', '7', '7', '关节机器人急停被拍下', '舱体线关节机器人急停被拍下，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('100', '192.168.3.15', '8', '8', '安全围栏门1被打开', '舱体线安全围栏门1被打开，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('101', '192.168.3.15', '9', '9', '安全围栏门2被打开', '舱体线安全围栏门2被打开，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('102', '192.168.3.15', '10', '10', '机床维护门1被打开', '舱体线机床维护门1被打开，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('103', '192.168.3.15', '11', '11', '机床维护门2被打开', '舱体线机床维护门2被打开，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('104', '192.168.3.15', '12', '12', '机床维护门3被打开', '舱体线机床维护门3被打开，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('105', '192.168.3.15', '13', '13', '关节机器人故障', '舱体线机床关节机器人故障，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('106', '192.168.3.15', '14', '14', 'U地轨伺服驱动器故障', '舱体线U地轨伺服驱动器故障，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('107', '192.168.3.15', '15', '15', '地轨自动润滑油位低', '舱体线地轨自动润滑油位低，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('108', '192.168.3.15', '16', '16', '液压站油位低', '舱体线液压站油位低，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('109', '192.168.3.15', '17', '17', '机床维护门1升降缸上升未到位', '舱体线机床维护门1升降缸上升未到位，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('110', '192.168.3.15', '18', '18', '机床维护门1升降缸下降未到位', '舱体线机床维护门1升降缸下降未到位，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('111', '192.168.3.15', '19', '19', '机床维护门2升降缸上升未到位', '舱体线机床维护门2升降缸上升未到位，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('112', '192.168.3.15', '20', '20', '机床维护门2升降缸下降未到位', '舱体线机床维护门2升降缸下降未到位，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('113', '192.168.3.15', '21', '21', '机床维护门3升降缸上升未到位', '舱体线机床维护门3升降缸上升未到位，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('114', '192.168.3.15', '22', '22', '机床维护门3升降缸下降未到位', '舱体线机床维护门3升降缸下降未到位，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('115', '192.168.3.15', '23', '23', '液压站总压力异常', '舱体线液压站总压力异常，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('116', '192.168.3.15', '24', '24', '液压站高温报警', '舱体线液压站高温报警，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('117', '192.168.3.15', '25', '25', '液压站夹紧流量异常', '舱体线液压站夹紧流量异常，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('118', '192.168.3.15', '26', '26', '联轴器夹紧压力异常', '舱体线联轴器夹紧压力异常，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('119', '192.168.3.15', '27', '27', '联轴器松开压力异常', '舱体线联轴器松开压力异常，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('120', '192.168.3.15', '28', '28', '放动作托盘检测异常', '舱体线放动作托盘检测异常，请人工检查', '
');
INSERT INTO `ccs_dictionary` VALUES ('121', '192.168.3.15', '29', '29', '地轨位置与工位号不匹配', '舱体线地轨位置与工位号不匹配，请人工检查', '
');

-- ----------------------------
-- 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 ('1496350084294508544', '192.168.3.15', '机械手', 'KT_jqr', 'S7_1500', null, 'DB200.4', 'DB200.50', null, '空闲', '框体线', '124', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1496351733469675520', '192.168.3.15', '舱体_清洗机', 'CT_123', null, null, null, null, null, '在线', '舱体线', '123', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1496352097438793728', '192.168.3.15', '机械手', 'CT_jqr', 'S7_1500', null, 'DB200.4', 'DB200.50', null, '空闲', '舱体线', '124', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1496354590755389440', '192.168.3.15', '舱体_FP1000—五轴', 'CT_127', null, null, null, null, null, '在线', '舱体线', '127', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1496354747433615360', '192.168.3.15', '舱体_DMU 125P-FD(不进线)', 'CT_128', '', null, null, null, null, '在线', '舱体线', '128', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1496354880934117376', '192.168.3.15', '舱体_DMU 100P duoBLOCK-1', 'CT_129', null, null, null, null, null, '在线', '舱体线', '129', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1496355074757099520', '192.168.3.15', '舱体_DMU 100P duoBLOCK-2', 'CT_130', null, null, null, null, null, '在线', '舱体线', '130', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1496355233519894528', '192.168.3.15', '舱体_DMU 100P duoBLOCK-3', 'CT_131', null, null, null, null, null, '在线', '舱体线', '131', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1496356621587054592', '192.168.3.15', '舱体_AGV接驳位1', 'CT_121', null, null, null, null, null, '在线', '舱体线', '121', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1496356795835219968', '192.168.3.15', '舱体_AGV接驳位2', 'CT_122', null, null, null, null, null, '在线', '舱体线', '122', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1496357467590754304', '192.168.3.15', '框体_哈默五轴C650U-1', 'KT_127', 'HEIDEHAIN', null, null, null, null, '离线', '框体线', '127', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1496357660788785152', '192.168.3.15', '框体_哈默五轴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.170', '框体_AGV接驳位1', 'KT_121', null, null, null, null, null, '在线', '框体线', '121', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1496358957009076224', '192.168.11.170', '框体_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', 'S7_1500', 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, '在线', '保障中心', '361', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1496362579914653696', '192.168.11.130', '保障中心_AGV接驳位2', 'BZ_362', '', null, null, null, null, '在线', '保障中心', '362', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1496362719262015488', '192.168.11.130', '保障中心_AGV接驳位3', 'BZ_363', '', null, null, null, null, '在线', '保障中心', '363', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1496363176541814784', '192.168.11.130', '保障中心_打标机', 'BZ_370', '', null, null, null, null, '在线', '保障中心', '370', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1496363582865014784', '192.168.11.130', '保障中心_上下料站1', 'BZ_364', '', null, null, null, null, '在线', '保障中心', '364', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1496364001796292608', '192.168.11.130', '保障中心_上下料站2', 'BZ_365', '', null, null, null, null, '在线', '保障中心', '365', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1496364152329863168', '192.168.11.130', '保障中心_上下料站3', 'BZ_366', '', null, null, null, null, '在线', '保障中心', '366', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1496364250765983744', '192.168.11.130', '保障中心_上下料站4', 'BZ_367', '', 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', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1506364549605949440', '192.168.11.170', '地轨托盘交换台1', null, null, null, null, null, null, '在线', '框体线', '125', '系统监管');
INSERT INTO `ccs_equipment_monitor` VALUES ('1516364549605949440', '192.168.11.170', '地轨托盘交换台2', null, null, null, null, null, null, '在线', '框体线', '126', '系统监管');

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

-- ----------------------------
-- Records of ccs_tagvalue
-- ----------------------------
INSERT INTO `ccs_tagvalue` VALUES ('1', 'DB300.0.0', '0', 'BOOL', 'NULL', 'S7_1500', '192.168.3.15', '流程运行中（机器人）', null, null, '419901074472701952', '2023-06-17 11:37:50', '
');
INSERT INTO `ccs_tagvalue` VALUES ('2', 'DB300.0.1', '0', 'BOOL', 'NULL', 'S7_1500', '192.168.3.15', '无流程运行（机器人）', '', '', '419901074472701952', '2023-06-17 10:43:43', '
');
INSERT INTO `ccs_tagvalue` VALUES ('3', 'DB300.0.2', '0', 'BOOL', 'NULL', 'S7_1500', '192.168.3.15', 'RFID写入成功（机器人）', '', '', '419901074472701952', '2023-06-17 10:43:47', '
');
INSERT INTO `ccs_tagvalue` VALUES ('4', 'DB300.0.3', '0', 'BOOL', 'NULL', 'S7_1500', '192.168.3.15', '产线维护门1被打开（机器人）', null, null, '419901074472701952', '2022-08-15 11:11:58', '
');
INSERT INTO `ccs_tagvalue` VALUES ('5', 'DB300.0.4', '0', 'BOOL', 'NULL', 'S7_1500', '192.168.3.15', '产线维护门2被打开（机器人）', '', '', '419901074472701952', '2023-06-17 10:39:23', '
');
INSERT INTO `ccs_tagvalue` VALUES ('6', 'DB300.0.5', '0', 'BOOL', 'NULL', 'S7_1500', '192.168.3.15', '产线维护门3被打开（机器人）', null, null, '419901074472701952', '2022-08-15 11:11:58', '
');
INSERT INTO `ccs_tagvalue` VALUES ('7', 'DB300.0.6', '0', 'BOOL', 'NULL', 'S7_1500', '192.168.3.15', '故障信号（机器人）', null, null, '419901074472701952', '2023-05-25 20:24:12', '
');
INSERT INTO `ccs_tagvalue` VALUES ('8', 'DB300.0.7', '0', 'BOOL', 'NULL', 'S7_1500', '192.168.3.15', '急停2被拍下（机器人）', null, null, '419901074472701952', '2022-08-15 11:11:58', '
');
INSERT INTO `ccs_tagvalue` VALUES ('9', 'DB300.1.0', '0', 'BOOL', 'NULL', 'S7_1500', '192.168.3.15', '心跳信号（机器人）', null, null, '419901074472701952', '2023-06-16 10:08:24', '
');
INSERT INTO `ccs_tagvalue` VALUES ('10', 'DB300.1.1', '0', 'BOOL', 'NULL', 'S7_1500', '192.168.3.15', '产线维护门4被打开（机器人）', null, null, '419901074472701952', '2022-08-15 11:11:59', '
');
INSERT INTO `ccs_tagvalue` VALUES ('11', 'DB300.1.2', '0', 'BOOL', 'NULL', 'S7_1500', '192.168.3.15', '产线维护门5被打开（机器人）', null, null, '419901074472701952', '2023-05-25 23:21:55', '
');
INSERT INTO `ccs_tagvalue` VALUES ('12', 'DB300.1.3', '0', 'BOOL', 'NULL', 'S7_1500', '192.168.3.15', '产线维护门6被打开（机器人）', null, null, '419901074472701952', '2023-06-08 10:21:11', '
');
INSERT INTO `ccs_tagvalue` VALUES ('13', 'DB300.6.0', '0', 'BOOL', 'NULL', 'S7_1500', '192.168.3.15', '申请上料（五轴1机床）', null, null, '419901074472701952', '2023-06-02 10:12:13', '
');
INSERT INTO `ccs_tagvalue` VALUES ('14', 'DB300.6.1', '0', 'BOOL', 'NULL', 'S7_1500', '192.168.3.15', '申请下料（五轴1机床）', null, null, '419901074472701952', '2023-05-30 09:26:54', '
');
INSERT INTO `ccs_tagvalue` VALUES ('15', 'DB300.6.2', '0', 'BOOL', 'NULL', 'S7_1500', '192.168.3.15', '心跳信号（五轴1机床）', null, null, '419901074472701952', '2022-08-15 11:11:59', '
');
INSERT INTO `ccs_tagvalue` VALUES ('16', 'DB300.6.3', '0', 'BOOL', 'NULL', 'S7_1500', '192.168.3.15', '故障状态（五轴1机床）', null, null, '419901074472701952', '2023-06-17 10:41:53', '
');
INSERT INTO `ccs_tagvalue` VALUES ('17', 'DB300.6.4', '0', 'BOOL', 'NULL', 'S7_1500', '192.168.3.15', '运行状态（五轴1机床）', null, null, '419901074472701952', '2023-06-17 10:43:40', '
');
INSERT INTO `ccs_tagvalue` VALUES ('18', 'DB300.6.5', '0', 'BOOL', 'NULL', 'S7_1500', '192.168.3.15', '加工完成信号（五轴1机床）', null, null, '419901074472701952', '2023-06-16 17:23:41', '
');
INSERT INTO `ccs_tagvalue` VALUES ('19', 'DB300.6.6', '0', 'BOOL', 'NULL', 'S7_1500', '192.168.3.15', '空闲信号（五轴1机床）', null, null, '419901074472701952', '2023-06-17 10:43:40', '
');
INSERT INTO `ccs_tagvalue` VALUES ('20', 'DB300.10.0', '0', 'BOOL', 'NULL', 'S7_1500', '192.168.3.15', '申请上料（五轴2机床）', null, null, '419901074472701952', '2023-06-17 10:40:59', '
');
INSERT INTO `ccs_tagvalue` VALUES ('21', 'DB300.10.1', '0', 'BOOL', 'NULL', 'S7_1500', '192.168.3.15', '申请下料（五轴2机床）', null, null, '419901074472701952', '2023-06-16 22:04:18', '
');
INSERT INTO `ccs_tagvalue` VALUES ('22', 'DB300.10.2', '0', 'BOOL', 'NULL', 'S7_1500', '192.168.3.15', '心跳信号（五轴2机床）', null, null, '419901074472701952', '2022-08-15 11:11:59', '
');
INSERT INTO `ccs_tagvalue` VALUES ('23', 'DB300.10.3', '0', 'BOOL', 'NULL', 'S7_1500', '192.168.3.15', '故障状态（五轴2机床）', null, null, '419901074472701952', '2023-06-16 22:07:14', '
');
INSERT INTO `ccs_tagvalue` VALUES ('24', 'DB300.10.4', '0', 'BOOL', 'NULL', 'S7_1500', '192.168.3.15', '运行状态（五轴2机床）', null, null, '419901074472701952', '2023-06-17 10:34:09', '
');
INSERT INTO `ccs_tagvalue` VALUES ('70', 'DB300.10.5', '0', 'BOOL', 'NULL', 'S7_1500', '192.168.3.15', '加工完成信号（五轴2机床）', null, null, '419901074472701952', '2023-06-14 22:59:53', '
');
INSERT INTO `ccs_tagvalue` VALUES ('71', 'DB300.10.6', '0', 'BOOL', 'NULL', 'S7_1500', '192.168.3.15', '空闲信号（五轴2机床）', null, null, '419901074472701952', '2023-06-15 17:01:28', '
');
INSERT INTO `ccs_tagvalue` VALUES ('144', 'DB300.16.0', '0', 'BOOL', 'NULL', 'S7_1500', '192.168.3.15', '吹气申请上料（清洗机）', null, null, '419900590890422272', '2023-06-14 22:34:35', '
');
INSERT INTO `ccs_tagvalue` VALUES ('145', 'DB300.16.1', '0', 'BOOL', 'NULL', 'S7_1500', '192.168.3.15', '吹气申请下料（清洗机）', null, null, '419900590890422272', '2023-06-15 19:29:47', '
');
INSERT INTO `ccs_tagvalue` VALUES ('146', 'DB300.16.2', '84', 'BOOL', 'NULL', 'S7_1500', '192.168.3.15', '水洗申请上料（清洗机）', null, null, '419900590890422272', '2023-06-16 11:34:59', '
');
INSERT INTO `ccs_tagvalue` VALUES ('147', 'DB300.16.3', '0', 'BOOL', 'NULL', 'S7_1500', '192.168.3.15', '水洗申请下料（清洗机）', null, null, '419900590890422272', '2023-05-25 18:39:01', '
');
INSERT INTO `ccs_tagvalue` VALUES ('148', 'DB300.16.4', '0', 'BOOL', 'NULL', 'S7_1500', '192.168.3.15', '心跳信号（清洗机）', null, null, '419900590890422272', '2023-06-16 22:08:15', '
');
INSERT INTO `ccs_tagvalue` VALUES ('149', 'DB300.16.5', '0', 'BOOL', 'NULL', 'S7_1500', '192.168.3.15', '故障状态（清洗机）', null, null, '419900590890422272', '2023-05-24 13:40:55', '
');
INSERT INTO `ccs_tagvalue` VALUES ('150', 'DB300.16.6', '0', 'BOOL', 'NULL', 'S7_1500', '192.168.3.15', '吹气运行状态（清洗机）', null, null, '419900590890422272', '2023-05-25 18:39:02', '
');
INSERT INTO `ccs_tagvalue` VALUES ('151', 'DB300.16.7', '0', 'BOOL', 'NULL', 'S7_1500', '192.168.3.15', '水洗运行状态（清洗机）', null, null, '419900590890422272', '2023-06-16 22:08:15', '
');

-- ----------------------------
-- 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` int(10) NOT NULL DEFAULT '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=11 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of ccs_task_callback
-- ----------------------------
INSERT INTO `ccs_task_callback` VALUES ('1', '192.168.3.15', null, '10001', '10001', '机器人动作', 'RobotAction', null, 'DB300.DBX0.1', null, null, '1', null, '1', null, 'DB300.DBX0.7', 'DB300.DBX0.1', null, null, null, null, null, '1', '1', null, null, '2023-11-12 10:38:29', '2023-11-12 10:38:29');
INSERT INTO `ccs_task_callback` VALUES ('2', '192.168.3.15', null, '10001', '10001', '机器人动作', 'RobotAction', null, 'DB300.DBX0.1', null, null, '1', null, '1', null, 'DB300.DBX0.7', 'DB300.DBX0.1', null, null, null, null, null, '1', '1', null, null, '2023-11-12 10:43:26', '2023-11-12 10:43:26');
INSERT INTO `ccs_task_callback` VALUES ('3', '192.168.3.15', null, '10001', '10001', '机器人动作', 'RobotAction', null, 'DB300.DBX0.1', null, null, '1', null, '1', null, 'DB300.DBX0.7', 'DB300.DBX0.1', null, null, null, null, null, '1', '1', null, null, '2023-11-12 10:49:03', '2023-11-12 10:49:03');
INSERT INTO `ccs_task_callback` VALUES ('4', '192.168.3.15', null, '10001', '10001', '机器人动作', 'RobotAction', null, 'DB300.DBX0.1', null, null, '1', null, '1', null, 'DB300.DBX0.7', 'DB300.DBX0.1', null, null, null, null, null, '1', '1', null, null, '2023-11-12 10:51:39', '2023-11-12 10:51:39');
INSERT INTO `ccs_task_callback` VALUES ('5', '192.168.3.15', null, '10001', '10001', '机器人动作', 'RobotAction', null, 'DB300.DBX0.1', null, null, '1', null, '1', null, 'DB300.DBX0.7', 'DB300.DBX0.1', null, null, null, null, null, '1', '1', null, null, '2023-11-12 10:52:58', '2023-11-12 10:52:58');
INSERT INTO `ccs_task_callback` VALUES ('6', '192.168.3.15', null, '10001', '10001', '机器人动作', 'RobotAction', null, 'DB300.DBX0.1', null, null, '1', null, '1', null, 'DB300.DBX0.7', 'DB300.DBX0.1', null, null, null, null, null, '1', '1', null, null, '2023-11-12 10:56:04', '2023-11-12 10:56:04');
INSERT INTO `ccs_task_callback` VALUES ('7', '192.168.3.15', null, '10001', '10001', '机器人动作', 'RobotAction', null, 'DB300.DBX0.1', null, null, '1', null, '1', null, 'DB300.DBX0.7', 'DB300.DBX0.1', null, null, null, null, null, '1', '1', null, null, '2023-11-12 10:57:28', '2023-11-12 10:57:28');
INSERT INTO `ccs_task_callback` VALUES ('8', '192.168.3.15', null, '10001', '10001', '机器人动作', 'RobotAction', null, 'DB300.DBX0.1', null, null, '1', null, '1', null, 'DB300.DBX0.7', 'DB300.DBX0.1', null, null, null, null, null, '1', '1', null, null, '2023-11-12 11:02:25', '2023-11-12 11:02:25');
INSERT INTO `ccs_task_callback` VALUES ('9', '192.168.3.15', null, '10001', '10001', '机器人动作', 'RobotAction', null, 'DB300.DBX0.1', null, null, '1', null, '1', null, 'DB300.DBX0.7', 'DB300.DBX0.1', null, null, null, null, null, '1', '1', null, null, '2023-11-12 11:10:58', '2023-11-12 11:10:58');
INSERT INTO `ccs_task_callback` VALUES ('10', '192.168.3.15', null, '10001', '10001', '机器人动作', 'RobotAction', null, 'DB300.DBX0.1', null, null, '1', null, '1', null, 'DB300.DBX0.7', 'DB300.DBX0.1', null, null, null, null, null, '1', '1', null, null, '2023-11-12 11:44:33', '2023-11-12 11:44:33');

-- ----------------------------
-- 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=utf8;

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