ccs_yj.sql 34 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384
  1. /*
  2. Navicat MySQL Data Transfer
  3. Source Server : 127.0.0.1
  4. Source Server Version : 50722
  5. Source Host : 127.0.0.1:3306
  6. Source Database : ccs_yj
  7. Target Server Type : MYSQL
  8. Target Server Version : 50722
  9. File Encoding : 65001
  10. Date: 2022-08-17 20:31:56
  11. */
  12. SET FOREIGN_KEY_CHECKS=0;
  13. -- ----------------------------
  14. -- Table structure for ccs_action
  15. -- ----------------------------
  16. DROP TABLE IF EXISTS `ccs_action`;
  17. CREATE TABLE `ccs_action` (
  18. `id` int(10) NOT NULL AUTO_INCREMENT,
  19. `ip` varchar(20) NOT NULL COMMENT 'ip',
  20. `protocol_type` varchar(20) NOT NULL DEFAULT 'OPCUA' COMMENT '协议类型',
  21. `operate_type` varchar(50) NOT NULL COMMENT '操作类型',
  22. `operate_name` varchar(50) NOT NULL COMMENT '操作名称',
  23. `file_path` varchar(100) DEFAULT NULL COMMENT '文件路径',
  24. `plc_ip` varchar(50) DEFAULT NULL COMMENT '移动序号',
  25. `order_index` varchar(2) DEFAULT NULL COMMENT 'rfid序号',
  26. `description` varchar(100) DEFAULT NULL COMMENT '备注',
  27. UNIQUE KEY `pk_id` (`id`) USING BTREE
  28. ) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8mb4;
  29. -- ----------------------------
  30. -- Records of ccs_action
  31. -- ----------------------------
  32. INSERT INTO `ccs_action` VALUES ('31', '192.168.170.71', 'S7_1500', 'GetFlexibleWire', '柔性线取物品', null, '', null, null);
  33. INSERT INTO `ccs_action` VALUES ('32', '192.168.170.71', 'S7_1500', 'SendFlexibleWire', '柔性线送物品', null, '', null, null);
  34. INSERT INTO `ccs_action` VALUES ('33', '192.168.11.170', 'S7_1500', 'GetQualityCenter', '框体线取物品', null, '', null, null);
  35. INSERT INTO `ccs_action` VALUES ('34', '192.168.11.170', 'S7_1500', 'SendQualityCenter', '框体线送物品', null, '', null, null);
  36. INSERT INTO `ccs_action` VALUES ('35', '192.168.170.70', 'S7_1500', 'MoveRobotPosition', '柔性线机器人移动物品', null, '', null, null);
  37. INSERT INTO `ccs_action` VALUES ('36', '192.168.170.61', 'S7_1500', 'StartCoordinateMeasuringMachine', '启动三坐标', null, null, null, null);
  38. INSERT INTO `ccs_action` VALUES ('37', '1', 'S7_1500', 'StartLabelMachine', '启动打标机', null, null, null, null);
  39. INSERT INTO `ccs_action` VALUES ('38', '192.168.170.71', 'S7_1500', 'StartCleanMachine', '启动清洗机', null, null, null, null);
  40. INSERT INTO `ccs_action` VALUES ('39', '192.168.11.186', 'HEIDEHAIN', 'StartNCProgram', '框体线启动哈默机床1程序', '', '192.168.11.170', null, null);
  41. INSERT INTO `ccs_action` VALUES ('40', '192.168.11.187', 'HEIDEHAIN', 'StartNCProgram', '框体线启动哈默机床2程序', null, '192.168.11.170', null, null);
  42. INSERT INTO `ccs_action` VALUES ('41', '192.168.11.188', 'HEIDEHAIN', 'StartNCProgram', '框体线启动哈默机床3程序', null, '192.168.11.170', null, null);
  43. INSERT INTO `ccs_action` VALUES ('42', '192.168.11.189', 'FANUC', 'StartNCProgram', '沈机机床4启动', null, '192.168.11.170', null, null);
  44. INSERT INTO `ccs_action` VALUES ('43', '192.168.11.190', 'FANUC', 'StartNCProgram', '沈机机床5启动', null, '192.168.11.170', null, null);
  45. INSERT INTO `ccs_action` VALUES ('44', '192.168.11.191', 'FANUC', 'StartNCProgram', '沈机机床6启动', null, '192.168.11.170', null, null);
  46. INSERT INTO `ccs_action` VALUES ('45', '192.168.11.192', 'FANUC', 'StartNCProgram', '沈机机床7启动', null, '192.168.11.170', null, null);
  47. -- ----------------------------
  48. -- Table structure for ccs_action_address
  49. -- ----------------------------
  50. DROP TABLE IF EXISTS `ccs_action_address`;
  51. CREATE TABLE `ccs_action_address` (
  52. `id` int(11) NOT NULL AUTO_INCREMENT,
  53. `action_id` int(11) NOT NULL DEFAULT '0' COMMENT '动作id',
  54. `type` varchar(20) NOT NULL COMMENT '类型:WRITE,CHECK,CALLBACK,CALLBACK_FAIL',
  55. `address` varchar(20) NOT NULL COMMENT '点位地址',
  56. `value` varchar(20) DEFAULT NULL COMMENT '点位值',
  57. `check_type` bit(1) NOT NULL DEFAULT b'1' COMMENT '校验类型,1等于 0表示不等于',
  58. `sort` int(11) NOT NULL DEFAULT '1' COMMENT '顺序',
  59. PRIMARY KEY (`id`)
  60. ) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=utf8mb4;
  61. -- ----------------------------
  62. -- Records of ccs_action_address
  63. -- ----------------------------
  64. INSERT INTO `ccs_action_address` VALUES ('1', '33', 'WRITE', 'DB200.46', null, '', '1');
  65. INSERT INTO `ccs_action_address` VALUES ('2', '33', 'WRITE', 'DB200.50', '1', '', '2');
  66. INSERT INTO `ccs_action_address` VALUES ('3', '33', 'CHECK', 'DB200.4', '1', '\0', '1');
  67. INSERT INTO `ccs_action_address` VALUES ('4', '33', 'CALLBACK', 'DB200.50', '3', '', '1');
  68. INSERT INTO `ccs_action_address` VALUES ('5', '33', 'CALLBACK_FAIL', 'DB200.50', '9', '', '1');
  69. INSERT INTO `ccs_action_address` VALUES ('6', '33', 'CALLBACK_FAIL', 'DB200.50', '10', '', '2');
  70. INSERT INTO `ccs_action_address` VALUES ('7', '34', 'WRITE', 'DB200.46', null, '', '1');
  71. INSERT INTO `ccs_action_address` VALUES ('8', '34', 'WRITE', 'DB200.50', '4', '', '2');
  72. INSERT INTO `ccs_action_address` VALUES ('9', '34', 'CHECK', 'DB200.4', '1', '\0', '1');
  73. INSERT INTO `ccs_action_address` VALUES ('10', '34', 'CALLBACK', 'DB200.50', '6', '', '1');
  74. INSERT INTO `ccs_action_address` VALUES ('11', '34', 'CALLBACK_FAIL', 'DB200.50', '9', '', '1');
  75. INSERT INTO `ccs_action_address` VALUES ('12', '34', 'CALLBACK_FAIL', 'DB200.50', '10', '', '1');
  76. INSERT INTO `ccs_action_address` VALUES ('13', '31', 'WRITE', 'DB200.46', null, '', '1');
  77. INSERT INTO `ccs_action_address` VALUES ('14', '31', 'WRITE', 'DB200.50', '1', '', '2');
  78. INSERT INTO `ccs_action_address` VALUES ('15', '31', 'CHECK', 'DB200.4', null, '\0', '1');
  79. INSERT INTO `ccs_action_address` VALUES ('16', '31', 'CALLBACK', 'DB200.50', '3', '', '1');
  80. INSERT INTO `ccs_action_address` VALUES ('17', '31', 'CALLBACK_FAIL', 'DB200.50', '9', '', '1');
  81. INSERT INTO `ccs_action_address` VALUES ('18', '31', 'CALLBACK_FAIL', 'DB200.50', '10', '', '2');
  82. INSERT INTO `ccs_action_address` VALUES ('19', '32', 'WRITE', 'DB200.48', null, '', '1');
  83. INSERT INTO `ccs_action_address` VALUES ('20', '32', 'WRITE', 'DB200.50', '4', '', '2');
  84. INSERT INTO `ccs_action_address` VALUES ('21', '32', 'CHECK', 'DB200.4', '1', '\0', '1');
  85. INSERT INTO `ccs_action_address` VALUES ('22', '32', 'CALLBACK', 'DB200.50', '6', '', '1');
  86. INSERT INTO `ccs_action_address` VALUES ('23', '32', 'CALLBACK_FAIL', 'DB200.50', '9', '', '1');
  87. INSERT INTO `ccs_action_address` VALUES ('24', '32', 'CALLBACK_FAIL', 'DB200.50', '10', '', '2');
  88. INSERT INTO `ccs_action_address` VALUES ('25', '35', 'WRITE', 'DB200.46', null, '', '1');
  89. INSERT INTO `ccs_action_address` VALUES ('26', '35', 'WRITE', 'DB200.50', '7', '', '2');
  90. INSERT INTO `ccs_action_address` VALUES ('27', '35', 'CHECK', 'DB200.4', '1', '\0', '1');
  91. INSERT INTO `ccs_action_address` VALUES ('28', '35', 'CALLBACK', 'DB200.50', '8', '', '1');
  92. INSERT INTO `ccs_action_address` VALUES ('29', '35', 'CALLBACK_FAIL', 'DB200.50', '9', '', '1');
  93. INSERT INTO `ccs_action_address` VALUES ('30', '35', 'CALLBACK_FAIL', 'DB200.50', '10', '', '2');
  94. INSERT INTO `ccs_action_address` VALUES ('31', '39', 'WRITE', 'DB200.312', '1', '', '1');
  95. INSERT INTO `ccs_action_address` VALUES ('32', '39', 'CHECK', '', '', '', '1');
  96. INSERT INTO `ccs_action_address` VALUES ('33', '39', 'CALLBACK', 'DB200.326', '1', '', '1');
  97. INSERT INTO `ccs_action_address` VALUES ('34', '40', 'WRITE', 'DB200.314', '1', '', '1');
  98. INSERT INTO `ccs_action_address` VALUES ('35', '40', 'CHECK', '', '', '', '1');
  99. INSERT INTO `ccs_action_address` VALUES ('36', '40', 'CALLBACK', 'DB200.328', '1', '', '1');
  100. INSERT INTO `ccs_action_address` VALUES ('37', '41', 'WRITE', 'DB200.316', '1', '', '1');
  101. INSERT INTO `ccs_action_address` VALUES ('38', '41', 'CHECK', '', '', '', '1');
  102. INSERT INTO `ccs_action_address` VALUES ('39', '41', 'CALLBACK', 'DB200.330', '1', '', '1');
  103. INSERT INTO `ccs_action_address` VALUES ('40', '42', 'WRITE', 'DB200.318', null, '', '1');
  104. INSERT INTO `ccs_action_address` VALUES ('41', '42', 'CHECK', '', '', '', '1');
  105. INSERT INTO `ccs_action_address` VALUES ('42', '42', 'CALLBACK', 'DB200.332', '', '', '1');
  106. INSERT INTO `ccs_action_address` VALUES ('43', '43', 'WRITE', 'DB200.320', '1', '', '1');
  107. INSERT INTO `ccs_action_address` VALUES ('44', '43', 'CHECK', '', '', '', '1');
  108. INSERT INTO `ccs_action_address` VALUES ('45', '43', 'CALLBACK', 'DB200.334', '1', '', '2');
  109. INSERT INTO `ccs_action_address` VALUES ('46', '44', 'WRITE', 'DB200.322', '1', '', '1');
  110. INSERT INTO `ccs_action_address` VALUES ('47', '44', 'CHECK', '', '', '', '1');
  111. INSERT INTO `ccs_action_address` VALUES ('48', '44', 'CALLBACK', ' DB200.336', '1', '', '1');
  112. INSERT INTO `ccs_action_address` VALUES ('49', '45', 'WRITE', 'DB200.324', '1', '', '1');
  113. INSERT INTO `ccs_action_address` VALUES ('50', '45', 'CHECK', '', '1', '', '1');
  114. INSERT INTO `ccs_action_address` VALUES ('51', '45', 'CALLBACK', 'DB200.338', null, '', '1');
  115. -- ----------------------------
  116. -- Table structure for ccs_device
  117. -- ----------------------------
  118. DROP TABLE IF EXISTS `ccs_device`;
  119. CREATE TABLE `ccs_device` (
  120. `id` int(10) NOT NULL AUTO_INCREMENT,
  121. `ip` varchar(20) NOT NULL,
  122. `user_name` varchar(20) DEFAULT NULL,
  123. `port` int(10) DEFAULT NULL,
  124. `password` varchar(50) DEFAULT NULL,
  125. `server_url` varchar(50) DEFAULT NULL COMMENT '服务类型',
  126. `protocol_type` varchar(20) NOT NULL DEFAULT 'OPCUA' COMMENT '协议类型',
  127. `state` bit(1) NOT NULL DEFAULT b'1' COMMENT '1表示启用 0表示停用',
  128. `use_state` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否使用0:不使用 1:使用',
  129. `description` varchar(100) DEFAULT NULL,
  130. UNIQUE KEY `pk_id` (`id`) USING BTREE
  131. ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4;
  132. -- ----------------------------
  133. -- Records of ccs_device
  134. -- ----------------------------
  135. INSERT INTO `ccs_device` VALUES ('1', '192.168.170.206', 'OpcUaClient', '4840', '12345678', 'opc.tcp://192.168.170.206:4840', 'OPCUA', '\0', '\0', null);
  136. INSERT INTO `ccs_device` VALUES ('3', '127.0.0.1', 'manufact', '22', 'SUNRISE', '127.0.0.1', 'FTP', '', '\0', null);
  137. INSERT INTO `ccs_device` VALUES ('4', '192.168.11.170', null, '102', null, '192.168.11.170', 'S7_1500', '', '', '框体线CPU PLC');
  138. INSERT INTO `ccs_device` VALUES ('5', '192.168.11.171', '', '102', null, '192.168.11.171', 'S7_1500', '\0', '\0', '框体线HMI PLC');
  139. INSERT INTO `ccs_device` VALUES ('6', '192.168.11.186', 'eth01', '1900', null, '192.168.11.186', 'HEIDEHAIN', '\0', '\0', '哈默机床1');
  140. INSERT INTO `ccs_device` VALUES ('7', '192.168.11.187', 'eth02', '1900', null, '192.168.11.187', 'HEIDEHAIN', '', '', '哈默机床2');
  141. INSERT INTO `ccs_device` VALUES ('8', '192.168.11.188', 'eth03', '1900', null, '192.168.11.188', 'HEIDEHAIN', '\0', '\0', '哈默机床3');
  142. INSERT INTO `ccs_device` VALUES ('9', '192.168.11.189', null, '8193', null, '192.168.11.189', 'FANUC', '\0', '\0', '沈机机床1');
  143. INSERT INTO `ccs_device` VALUES ('10', '192.168.11.190', null, '8193', null, '192.168.11.190', 'FANUC', '\0', '\0', '沈机机床2');
  144. INSERT INTO `ccs_device` VALUES ('11', '192.168.11.191', null, '8193', null, '192.168.11.191', 'FANUC', '\0', '\0', '沈机机床3');
  145. INSERT INTO `ccs_device` VALUES ('12', '192.168.11.192', null, '8193', null, '192.168.11.192', 'FANUC', '', '', '沈机机床4');
  146. -- ----------------------------
  147. -- Table structure for ccs_dictionary
  148. -- ----------------------------
  149. DROP TABLE IF EXISTS `ccs_dictionary`;
  150. CREATE TABLE `ccs_dictionary` (
  151. `id` int(10) NOT NULL AUTO_INCREMENT,
  152. `type` varchar(100) NOT NULL COMMENT '类型',
  153. `code` varchar(100) NOT NULL COMMENT '编码',
  154. `name` varchar(64) NOT NULL COMMENT '名称',
  155. `dict_value` varchar(64) DEFAULT NULL COMMENT '值',
  156. `description` varchar(255) DEFAULT '' COMMENT '描述',
  157. `state` bit(1) NOT NULL DEFAULT b'1' COMMENT '1表示启用 0表示停用',
  158. UNIQUE KEY `pk_id` (`id`) USING BTREE
  159. ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COMMENT='字典项';
  160. -- ----------------------------
  161. -- Records of ccs_dictionary
  162. -- ----------------------------
  163. INSERT INTO `ccs_dictionary` VALUES ('1', 'GetIntelligenceUnit', '1', '1', '1', '智能单元取物品条件', '');
  164. INSERT INTO `ccs_dictionary` VALUES ('2', 'GetFlexibleWire', '2', '2', '1', '柔性线取物品', '');
  165. INSERT INTO `ccs_dictionary` VALUES ('3', 'GetQualityCenter', '1', '1', '1', '质量中心取物品', '');
  166. INSERT INTO `ccs_dictionary` VALUES ('4', 'SendIntelligenceUnit', '1', '1', '1', '智能单元送物品', '');
  167. INSERT INTO `ccs_dictionary` VALUES ('5', 'SendFlexibleWire', '1', '1', '1', '柔性线送物品', '');
  168. INSERT INTO `ccs_dictionary` VALUES ('6', 'SendQualityCenter', '1', '1', '1', '质量中心送物品', '');
  169. INSERT INTO `ccs_dictionary` VALUES ('7', 'MoveRobotPosition', '1', '1', '1', '柔性线机器人移动物品', '');
  170. INSERT INTO `ccs_dictionary` VALUES ('8', 'UploadFile', '1', '1', '1', '上传文件', '');
  171. INSERT INTO `ccs_dictionary` VALUES ('9', 'StartNCProgram', '1', '1', '1', '启动机床程序', '');
  172. INSERT INTO `ccs_dictionary` VALUES ('10', 'SendLinShift', '1', '1', '1', '粗偏写入', '');
  173. INSERT INTO `ccs_dictionary` VALUES ('11', 'SendLinShiftFine', '1', '1', '1', '精偏写入', '');
  174. INSERT INTO `ccs_dictionary` VALUES ('12', 'StartCleanMachine', '1', '1', '1', '启动清洗机', '');
  175. INSERT INTO `ccs_dictionary` VALUES ('13', 'StartLabelMachine', '1', '1', '1', '启动打标机', '');
  176. INSERT INTO `ccs_dictionary` VALUES ('14', 'StartCoordinateMeasuringMachine', '1', '1', '1', '启动三坐标', '');
  177. INSERT INTO `ccs_dictionary` VALUES ('15', 'GetServoStacker', '1', '1', '1', '伺服舵机取物品', '');
  178. INSERT INTO `ccs_dictionary` VALUES ('16', 'SendServoStacker', '1', '1', '1', '伺服舵机放物品', '');
  179. INSERT INTO `ccs_dictionary` VALUES ('17', 'ReadRFID', '1', '1', '1', '读RFID', '');
  180. INSERT INTO `ccs_dictionary` VALUES ('18', 'WriteRFID', '1', '1', '1', '写RFID', '');
  181. -- ----------------------------
  182. -- Table structure for ccs_equipment_monitor
  183. -- ----------------------------
  184. DROP TABLE IF EXISTS `ccs_equipment_monitor`;
  185. CREATE TABLE `ccs_equipment_monitor` (
  186. `id` bigint(20) NOT NULL,
  187. `ip` varchar(45) DEFAULT NULL,
  188. `name` varchar(45) DEFAULT NULL,
  189. `serial_no` varchar(45) DEFAULT NULL,
  190. `type` varchar(45) DEFAULT NULL,
  191. `description` varchar(45) DEFAULT NULL,
  192. `address` varchar(45) DEFAULT NULL,
  193. `address2` varchar(45) DEFAULT NULL,
  194. `source` varchar(45) DEFAULT NULL,
  195. `status` varchar(45) DEFAULT NULL,
  196. `line` varchar(45) DEFAULT NULL,
  197. `location` varchar(45) DEFAULT NULL,
  198. `control_status` varchar(45) DEFAULT NULL,
  199. PRIMARY KEY (`id`)
  200. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  201. -- ----------------------------
  202. -- Records of ccs_equipment_monitor
  203. -- ----------------------------
  204. INSERT INTO `ccs_equipment_monitor` VALUES ('3', null, '舱体_清洗机舱体_清洗机舱体_清洗机舱体_清洗机舱体舱体_清洗机', null, 'cnc', null, null, null, null, '生产中', '舱体线', '121', null);
  205. INSERT INTO `ccs_equipment_monitor` VALUES ('7', null, '舱体_FP1000—五轴', null, 'cnc', null, null, null, null, '在线', '舱体线', '122', null);
  206. INSERT INTO `ccs_equipment_monitor` VALUES ('8', null, '舱体_DMU 125P-FD(不进线)', null, 'cnc', null, null, null, null, '在线', '舱体线', '123', null);
  207. INSERT INTO `ccs_equipment_monitor` VALUES ('9', null, '舱体_DMU 100P duoBLOCK-1', null, 'cnc', null, null, null, null, '线', '舱体线', '124', null);
  208. INSERT INTO `ccs_equipment_monitor` VALUES ('10', null, '舱体_DMU 100P duoBLOCK-2', null, 'cnc', null, null, null, null, '/t--1', '舱体线', '125', null);
  209. INSERT INTO `ccs_equipment_monitor` VALUES ('11', null, '舱体_DMU 100P duoBLOCK-3', null, 'cnc', null, null, null, null, '在线', '舱体线', '126', null);
  210. INSERT INTO `ccs_equipment_monitor` VALUES ('14', null, '框体_清洗机', null, 'cnc', null, null, null, null, '生气', '舱体线', '127', null);
  211. INSERT INTO `ccs_equipment_monitor` VALUES ('18', null, '框体_哈默五轴C650U-1', null, 'cnc', null, null, null, null, '在线', '舱体线', '128', null);
  212. INSERT INTO `ccs_equipment_monitor` VALUES ('19', null, '框体_哈默五轴C650U-2', null, 'cnc', null, null, null, null, '生!@', '舱体线', '129', null);
  213. INSERT INTO `ccs_equipment_monitor` VALUES ('20', null, '框体_哈默五轴C650U-3', null, 'cnc', null, null, null, null, '生产中', '舱体线', '130', null);
  214. INSERT INTO `ccs_equipment_monitor` VALUES ('21', null, '框体_VMC1300B三轴-1', null, 'cnc', null, null, null, null, '/t', '舱体线', '131', null);
  215. INSERT INTO `ccs_equipment_monitor` VALUES ('22', null, '框体_VMC1300B三轴-2', null, 'cnc', null, null, null, null, '在线', '框体线', '121', null);
  216. INSERT INTO `ccs_equipment_monitor` VALUES ('23', null, '框体_VMC1300B三轴-3', null, 'cnc', null, null, null, null, '在线', '框体线', '122', null);
  217. INSERT INTO `ccs_equipment_monitor` VALUES ('24', null, '框体_VMC1300B三轴-4', null, 'cnc', null, null, null, null, '在线', '框体线', '123', null);
  218. INSERT INTO `ccs_equipment_monitor` VALUES ('34', null, '保障中心_dabiao', null, 'cnc', null, null, null, null, '生产中', '框体线', '124', null);
  219. INSERT INTO `ccs_equipment_monitor` VALUES ('36', null, '保障中心_三坐标', null, 'cnc', null, null, null, null, '生产中', '框体线', '125', null);
  220. INSERT INTO `ccs_equipment_monitor` VALUES ('10001', null, 'AGV01', null, 'agv', null, null, null, null, '空闲', '框体线', '126', null);
  221. INSERT INTO `ccs_equipment_monitor` VALUES ('10002', null, 'AGV02', null, 'agv', null, null, null, null, '空闲', '框体线', '127', null);
  222. INSERT INTO `ccs_equipment_monitor` VALUES ('10003', null, 'AGV03', null, 'agv', null, null, null, null, '生产中', '框体线', '128', null);
  223. INSERT INTO `ccs_equipment_monitor` VALUES ('10004', null, 'AGV04', null, 'agv', null, null, null, null, '充电中', '框体线', '129', null);
  224. INSERT INTO `ccs_equipment_monitor` VALUES ('10005', null, 'AGV05', null, 'agv', null, null, null, null, '空闲', '框体线', '130', null);
  225. -- ----------------------------
  226. -- Table structure for ccs_tagvalue
  227. -- ----------------------------
  228. DROP TABLE IF EXISTS `ccs_tagvalue`;
  229. CREATE TABLE `ccs_tagvalue` (
  230. `id` bigint(20) NOT NULL AUTO_INCREMENT,
  231. `address` varchar(100) DEFAULT NULL,
  232. `tag_value` varchar(100) DEFAULT NULL,
  233. `type` varchar(45) DEFAULT NULL,
  234. `unit` varchar(45) DEFAULT NULL,
  235. `protocol_type` varchar(45) DEFAULT NULL,
  236. `ip` varchar(45) DEFAULT NULL,
  237. `description` varchar(80) DEFAULT NULL,
  238. `component` varchar(45) DEFAULT NULL,
  239. `component_number` varchar(45) DEFAULT NULL,
  240. `device_id` varchar(45) DEFAULT NULL,
  241. `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  242. `online_state` bit(1) DEFAULT NULL COMMENT '在线状态0:不在线1:在线',
  243. PRIMARY KEY (`id`)
  244. ) ENGINE=InnoDB AUTO_INCREMENT=309 DEFAULT CHARSET=utf8;
  245. -- ----------------------------
  246. -- Records of ccs_tagvalue
  247. -- ----------------------------
  248. 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', '');
  249. INSERT INTO `ccs_tagvalue` VALUES ('9', 'DB200.2', '4', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '机械手工作模式', '', '', '419901074472701952', '2022-08-17 14:44:09', '');
  250. INSERT INTO `ccs_tagvalue` VALUES ('10', 'DB200.4', '1', 'SHORT', 'NULL', 'S7_1500', '192.168.11.170', '工作状态', '', '', '419901074472701952', '2022-08-17 14:45:33', '');
  251. 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', '');
  252. 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', '');
  253. 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', '');
  254. 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', '');
  255. 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', '');
  256. 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', '');
  257. 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', '');
  258. 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', '');
  259. 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', '');
  260. 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', '');
  261. 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', '');
  262. 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', '');
  263. 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', '');
  264. 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', '');
  265. 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', '');
  266. 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', '');
  267. 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', '');
  268. 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', '');
  269. 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', '');
  270. 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', '');
  271. 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', '');
  272. 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', '');
  273. 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', '');
  274. 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', '');
  275. 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', '');
  276. 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', '');
  277. 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', '');
  278. 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', '');
  279. 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', '');
  280. 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', '');
  281. 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', '');
  282. 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', '');
  283. 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', '');
  284. 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', '');
  285. 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', '');
  286. 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', '');
  287. 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', '');
  288. 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', '');
  289. 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', '');
  290. 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', '');
  291. 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', '');
  292. 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', '');
  293. 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', '');
  294. 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', '');
  295. 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', '');
  296. 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);
  297. 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);
  298. 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);
  299. 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);
  300. 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);
  301. -- ----------------------------
  302. -- Table structure for ccs_task_callback
  303. -- ----------------------------
  304. DROP TABLE IF EXISTS `ccs_task_callback`;
  305. CREATE TABLE `ccs_task_callback` (
  306. `id` int(10) NOT NULL AUTO_INCREMENT,
  307. `ip` varchar(50) NOT NULL COMMENT 'IP',
  308. `port` varchar(10) DEFAULT NULL COMMENT '端口',
  309. `task_id` varchar(50) NOT NULL COMMENT '任务id',
  310. `task_node_id` varchar(50) DEFAULT NULL COMMENT '任务节点',
  311. `operate_name` varchar(50) DEFAULT NULL COMMENT '操作名称',
  312. `operate_type` varchar(50) DEFAULT NULL COMMENT '操作类型',
  313. `address` varchar(50) DEFAULT NULL COMMENT '点位',
  314. `address2` varchar(50) DEFAULT NULL COMMENT '点位2',
  315. `address3` varchar(50) DEFAULT NULL COMMENT '点位3',
  316. `callback_value` varchar(20) DEFAULT NULL COMMENT '目标值',
  317. `callback_value2` varchar(20) DEFAULT NULL COMMENT '目标值2',
  318. `callback_value3` varchar(20) DEFAULT NULL COMMENT '目标值3',
  319. `state` bit(1) NOT NULL DEFAULT b'1' COMMENT '1表示需回调 0表示已回调',
  320. `data` varchar(100) DEFAULT NULL COMMENT '参数',
  321. `fail_address` varchar(20) DEFAULT NULL,
  322. `fail_address2` varchar(20) DEFAULT NULL,
  323. `fail_address3` varchar(20) DEFAULT NULL,
  324. `success_reset_address` varchar(20) DEFAULT NULL,
  325. `success_reset_address2` varchar(20) DEFAULT NULL,
  326. `success_reset_value` varchar(20) DEFAULT NULL,
  327. `success_reset_value2` varchar(20) DEFAULT NULL,
  328. `callback_fail_value` varchar(20) DEFAULT NULL,
  329. `callback_fail_value2` varchar(20) DEFAULT NULL,
  330. `callback_fail_value3` varchar(20) DEFAULT NULL,
  331. `description` varchar(100) DEFAULT NULL,
  332. `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  333. `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  334. UNIQUE KEY `pk_id` (`id`) USING BTREE
  335. ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4;
  336. -- ----------------------------
  337. -- Records of ccs_task_callback
  338. -- ----------------------------
  339. 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');
  340. 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');
  341. 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');
  342. 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');
  343. 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');
  344. 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');
  345. 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');
  346. 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');
  347. 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');
  348. 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');
  349. 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');
  350. -- ----------------------------
  351. -- Table structure for user
  352. -- ----------------------------
  353. DROP TABLE IF EXISTS `user`;
  354. CREATE TABLE `user` (
  355. `id` varchar(32) NOT NULL,
  356. `login_name` varchar(50) NOT NULL,
  357. `password` varchar(50) DEFAULT NULL,
  358. `gender` varchar(10) DEFAULT NULL,
  359. `create_time` datetime DEFAULT NULL
  360. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  361. -- ----------------------------
  362. -- Records of user
  363. -- ----------------------------
  364. INSERT INTO `user` VALUES ('1', '22', '1', '1', '2022-06-12 15:34:50');