Página Principal Explorar Ajuda
Registe-se Iniciar Sessão
oyq28
/
imcs_ccs
1
0
Fork 0
Ficheiros Problemas 0 Pull Requests 0 Wiki
Árvore: 7e3b5fafed
Ramos Etiquetas
imcs_ccs
/
sql
/
update_1007.sql

update_1007.sql 6.9 KB
Histórico Em bruto

123456789101112131415161718192021222324252627282930313233343536373839404142434445 
  1. INSERT INTO `ccs_tagvalue`(`id`, `address`, `tag_value`, `type`, `unit`, `protocol_type`, `ip`, `description`, `component`, `component_number`, `device_id`, `update_time`, `online_state`) VALUES (400, 'DB200.18', '1', 'String', NULL, 'S7_1500', NULL, '三坐标检测完成1:good,2:waring,3:bad', NULL, NULL, NULL, '2022-10-07 16:49:54', NULL);
    2. 

  2. INSERT INTO `ccs_tagvalue`(`id`, `address`, `tag_value`, `type`, `unit`, `protocol_type`, `ip`, `description`, `component`, `component_number`, `device_id`, `update_time`, `online_state`) VALUES ('401', 'DB200.20', '1', 'String', NULL, 'S7_1500', '192.168.11.192', '三坐标中间工位检测完成1:good,2:waring,3:bad', NULL, NULL, NULL, '2022-10-24 15:29:41', NULL);
    3. 

  3. INSERT INTO `ccs_tagvalue`(`id`, `address`, `tag_value`, `type`, `unit`, `protocol_type`, `ip`, `description`, `component`, `component_number`, `device_id`, `update_time`, `online_state`) VALUES ('402', 'DB200.20', '1', 'String', NULL, 'S7_1500', '192.168.11.192', '三坐标右侧工位检测完成1:good,2:waring,3:bad', NULL, NULL, NULL, '2022-10-24 15:30:43', NULL);
    4. 

  4. 

  5. 

  6. INSERT INTO  `ccs_action`(`id`, `ip`, `protocol_type`, `operate_type`, `operate_name`, `file_path`, `plc_ip`, `order_index`, `description`) VALUES (46, '192.168.11.170', 'S7_1500', 'QueryThreeCoordinatesFreePos', '查询三坐标检测空闲位置', NULL, NULL, NULL, NULL);
    7. 

  7. INSERT INTO  `ccs_action`(`id`, `ip`, `protocol_type`, `operate_type`, `operate_name`, `file_path`, `plc_ip`, `order_index`, `description`) VALUES (47, '192.168.11.170', 'S7_1500', 'StartThreeCoordinates', '启动三坐标测量', NULL, NULL, NULL, NULL);
    8. 

  8. 

  9. 

  10. 

  11. INSERT INTO  `ccs_action_address`(`id`, `action_id`, `type`, `address`, `value`, `check_type`, `sort`) VALUES (55, 46, 'CHECK', 'DB200.8.0', '1', b'1', 1);
    12. 

  12. INSERT INTO  `ccs_action_address`(`id`, `action_id`, `type`, `address`, `value`, `check_type`, `sort`) VALUES (56, 46, 'CHECK', 'DB200.12.0', '1', b'1', 2);
    13. 

  13. INSERT INTO  `ccs_action_address`(`id`, `action_id`, `type`, `address`, `value`, `check_type`, `sort`) VALUES (57, 46, 'CHECK', 'DB200.16.0', '1', b'1', 3);
    14. 

  14. INSERT INTO  `ccs_action_address`(`id`, `action_id`, `type`, `address`, `value`, `check_type`, `sort`) VALUES (58, 47, 'CHECK', 'DB200.8.0', '1', b'1', 1);
    15. 

  15. INSERT INTO  `ccs_action_address`(`id`, `action_id`, `type`, `address`, `value`, `check_type`, `sort`) VALUES (59, 47, 'CHECK', 'DB200.12.0', '1', b'1', 2);
    16. 

  16. INSERT INTO  `ccs_action_address`(`id`, `action_id`, `type`, `address`, `value`, `check_type`, `sort`) VALUES (60, 47, 'CHECK', 'DB200.16.0', '1', b'1', 3);
    17. 

  17. INSERT INTO  `ccs_action_address`(`id`, `action_id`, `type`, `address`, `value`, `check_type`, `sort`) VALUES (61, 47, 'WRITE', 'DB200.2428.0', 'workProgramName', b'1', 1);
    18. 

  18. INSERT INTO  `ccs_action_address`(`id`, `action_id`, `type`, `address`, `value`, `check_type`, `sort`) VALUES (62, 47, 'WRITE', 'DB200.2448.0', 'workProgramName', b'1', 2);
    19. 

  19. INSERT INTO  `ccs_action_address`(`id`, `action_id`, `type`, `address`, `value`, `check_type`, `sort`) VALUES (63, 47, 'WRITE', 'DB200.2468.0', 'workProgramName', b'1', 3);
    20. 

  20. INSERT INTO  `ccs_action_address`(`id`, `action_id`, `type`, `address`, `value`, `check_type`, `sort`) VALUES (64, 47, 'WRITE', 'DB200.2548.0', 'workId', b'1', 1);
    21. 

  21. INSERT INTO  `ccs_action_address`(`id`, `action_id`, `type`, `address`, `value`, `check_type`, `sort`) VALUES (65, 47, 'WRITE', 'DB200.2588.0', 'workId', b'1', 2);
    22. 

  22. INSERT INTO  `ccs_action_address`(`id`, `action_id`, `type`, `address`, `value`, `check_type`, `sort`) VALUES (66, 47, 'WRITE', 'DB200.2628.0', 'workId', b'1', 3);
    23. 

  23. INSERT INTO  `ccs_action_address`(`id`, `action_id`, `type`, `address`, `value`, `check_type`, `sort`) VALUES (67, 47, 'WRITE', 'DB200.2788.0', 'procedureNo', b'1', 1);
    24. 

  24. INSERT INTO  `ccs_action_address`(`id`, `action_id`, `type`, `address`, `value`, `check_type`, `sort`) VALUES (68, 47, 'WRITE', 'DB200.2808.0', 'procedureNo', b'1', 2);
    25. 

  25. INSERT INTO  `ccs_action_address`(`id`, `action_id`, `type`, `address`, `value`, `check_type`, `sort`) VALUES (69, 47, 'WRITE', 'DB200.2828.0', 'procedureNo', b'1', 3);
    26. 

  26. INSERT INTO  `ccs_action_address`(`id`, `action_id`, `type`, `address`, `value`, `check_type`, `sort`) VALUES (70, 47, 'CALLBACK', 'DB200.50', '6', b'1', 1);
    27. 

  27. INSERT INTO  `ccs_action_address`(`id`, `action_id`, `type`, `address`, `value`, `check_type`, `sort`) VALUES (71, 47, 'CALLBACK_GET_COOR', 'DB200.2488.0', 'workProgramName', b'1', 1);
    28. 

  28. INSERT INTO  `ccs_action_address`(`id`, `action_id`, `type`, `address`, `value`, `check_type`, `sort`) VALUES (72, 47, 'CALLBACK_GET_COOR', 'DB200.2508.0', 'workProgramName', b'1', 2);
    29. 

  29. INSERT INTO  `ccs_action_address`(`id`, `action_id`, `type`, `address`, `value`, `check_type`, `sort`) VALUES (73, 47, 'CALLBACK_GET_COOR', 'DB200.2528.0', 'workProgramName', b'1', 3);
    30. 

  30. INSERT INTO  `ccs_action_address`(`id`, `action_id`, `type`, `address`, `value`, `check_type`, `sort`) VALUES (74, 47, 'CALLBACK_GET_COOR', 'DB200.2668.0', 'workId', b'1', 1);
    31. 

  31. INSERT INTO  `ccs_action_address`(`id`, `action_id`, `type`, `address`, `value`, `check_type`, `sort`) VALUES (75, 47, 'CALLBACK_GET_COOR', 'DB200.2708.0', 'workId', b'1', 2);
    32. 

  32. INSERT INTO  `ccs_action_address`(`id`, `action_id`, `type`, `address`, `value`, `check_type`, `sort`) VALUES (76, 47, 'CALLBACK_GET_COOR', 'DB200.2748.0', 'workId', b'1', 3);
    33. 

  33. INSERT INTO  `ccs_action_address`(`id`, `action_id`, `type`, `address`, `value`, `check_type`, `sort`) VALUES (77, 47, 'CALLBACK_GET_COOR', 'DB200.2848.0', 'procedureNo', b'1', 1);
    34. 

  34. INSERT INTO  `ccs_action_address`(`id`, `action_id`, `type`, `address`, `value`, `check_type`, `sort`) VALUES (78, 47, 'CALLBACK_GET_COOR', 'DB200.2868.0', 'procedureNo', b'1', 2);
    35. 

  35. INSERT INTO  `ccs_action_address`(`id`, `action_id`, `type`, `address`, `value`, `check_type`, `sort`) VALUES (79, 47, 'CALLBACK_GET_COOR', 'DB200.2888.0', 'procedureNo', b'1', 3);
    36. 

  36. INSERT INTO  `ccs_action_address`(`id`, `action_id`, `type`, `address`, `value`, `check_type`, `sort`) VALUES (80, 47, 'CALLBACK_CHECK_COOR', 'DB200.6.0', NULL, b'1', 1);
    37. 

  37. INSERT INTO  `ccs_action_address`(`id`, `action_id`, `type`, `address`, `value`, `check_type`, `sort`) VALUES (81, 47, 'CALLBACK_CHECK_COOR', 'DB200.10.0', NULL, b'1', 2);
    38. 

  38. INSERT INTO  `ccs_action_address`(`id`, `action_id`, `type`, `address`, `value`, `check_type`, `sort`) VALUES (82, 47, 'CALLBACK_CHECK_COOR', 'DB200.14.0', NULL, b'1', 3);
    39. 

  39. INSERT INTO  `ccs_action_address`(`id`, `action_id`, `type`, `address`, `value`, `check_type`, `sort`) VALUES (83, 47, 'WRITE_SEND', 'DB200.46', '', b'1', 1);
    40. 

  40. INSERT INTO  `ccs_action_address`(`id`, `action_id`, `type`, `address`, `value`, `check_type`, `sort`) VALUES (84, 47, 'WRITE_SEND', 'DB200.50', '4', b'1', 2); 
    41. 

  41. INSERT INTO  `ccs_action_address`(`id`, `action_id`, `type`, `address`, `value`, `check_type`, `sort`) VALUES (86, 47, 'CALLBACK_FAIL', 'DB200.50', '9', b'1', 1);
    42. 

  42. INSERT INTO  `ccs_action_address`(`id`, `action_id`, `type`, `address`, `value`, `check_type`, `sort`) VALUES (87, 47, 'CALLBACK_FAIL', 'DB200.50', '10', b'1', 2);
    43. 

  43. 

  44. 

  45.