Home Explore Help
Register Sign In
WAREWMS
/
WAREAMS
2
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Tree: 4649c6ad9b
Branches Tags
WAREAMS
/
base_sql
/
pallet_sql
/
yonghu_dml_20230921.sql

yonghu_dml_20230921.sql 5.1 KB
History Raw

12345678910111213141516171819202122232425262728 
  1. DELETE FROM `sys_config` WHERE config_id = 10;
    2. 

  2. DELETE FROM `sys_config` WHERE config_id = 11;
    3. 

  3. INSERT INTO `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (10, '入库检测光栅', 'sys.guangshan.no5', 'Y', 'N', 'admin', '2023-10-19 15:16:10', NULL, NULL, '光栅是否开启【参数键值】condig_value(Y开启，N关闭)');
    4. 

  4. INSERT INTO `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (11, '出库检测光栅', 'sys.guangshan.no6', 'Y', 'N', 'admin', '2023-10-19 15:16:10', NULL, NULL, '光栅是否开启【参数键值】condig_value(Y开启，N关闭)');
    5. 

  5. 

  6. DELETE FROM `ams_hexdefine_detail` WHERE business_type = '76' or business_type = '77';
    7. 

  7. INSERT INTO `ams_hexdefine_detail` (`id`, `business_type`, `col_name`, `col_type`, `bind_table`, `col_val`, `val_type`, `sort_index`) VALUES ('227', '76', 'Header key', '1', NULL, '87CD', '1', '1');
    8. 

  8. INSERT INTO `ams_hexdefine_detail` (`id`, `business_type`, `col_name`, `col_type`, `bind_table`, `col_val`, `val_type`, `sort_index`) VALUES ('228', '76', 'Size of header', '1', NULL, '0008', '1', '2');
    9. 

  9. INSERT INTO `ams_hexdefine_detail` (`id`, `business_type`, `col_name`, `col_type`, `bind_table`, `col_val`, `val_type`, `sort_index`) VALUES ('229', '76', 'Size of message', '1', NULL, '000B', '1', '3');
    10. 

  10. INSERT INTO `ams_hexdefine_detail` (`id`, `business_type`, `col_name`, `col_type`, `bind_table`, `col_val`, `val_type`, `sort_index`) VALUES ('230', '76', 'Funcation code', '1', NULL, '0001', '1', '4');
    11. 

  11. INSERT INTO `ams_hexdefine_detail` (`id`, `business_type`, `col_name`, `col_type`, `bind_table`, `col_val`, `val_type`, `sort_index`) VALUES ('231', '76', 'Message type', '1', NULL, '0071', '1', '5');
    12. 

  12. INSERT INTO `ams_hexdefine_detail` (`id`, `business_type`, `col_name`, `col_type`, `bind_table`, `col_val`, `val_type`, `sort_index`) VALUES ('232', '76', 'Number of parameters', '1', NULL, '0008', '1', '6');
    13. 

  13. INSERT INTO `ams_hexdefine_detail` (`id`, `business_type`, `col_name`, `col_type`, `bind_table`, `col_val`, `val_type`, `sort_index`) VALUES ('233', '76', 'TS Order', '1', NULL, '4C', '1', '7');
    14. 

  14. INSERT INTO `ams_hexdefine_detail` (`id`, `business_type`, `col_name`, `col_type`, `bind_table`, `col_val`, `val_type`, `sort_index`) VALUES ('234', '76', 'Priority', '2', NULL, 'priority', '1', '8');
    15. 

  15. INSERT INTO `ams_hexdefine_detail` (`id`, `business_type`, `col_name`, `col_type`, `bind_table`, `col_val`, `val_type`, `sort_index`) VALUES ('235', '76', 'code', '1', NULL, '0001', '1', '9');
    16. 

  16. INSERT INTO `ams_hexdefine_detail` (`id`, `business_type`, `col_name`, `col_type`, `bind_table`, `col_val`, `val_type`, `sort_index`) VALUES ('236', '76', 'IKEY', '2', NULL, 'iKey', '1', '10');
    17. 

  17. INSERT INTO `ams_hexdefine_detail` (`id`, `business_type`, `col_name`, `col_type`, `bind_table`, `col_val`, `val_type`, `sort_index`) VALUES ('237', '76', 'LP0', '2', NULL, 'ext1', '1', '11');
    18. 

  18. INSERT INTO `ams_hexdefine_detail` (`id`, `business_type`, `col_name`, `col_type`, `bind_table`, `col_val`, `val_type`, `sort_index`) VALUES ('240', '77', 'Header key', '1', NULL, '87CD', '1', '1');
    19. 

  19. INSERT INTO `ams_hexdefine_detail` (`id`, `business_type`, `col_name`, `col_type`, `bind_table`, `col_val`, `val_type`, `sort_index`) VALUES ('241', '77', 'Size of header', '1', NULL, '0008', '1', '2');
    20. 

  20. INSERT INTO `ams_hexdefine_detail` (`id`, `business_type`, `col_name`, `col_type`, `bind_table`, `col_val`, `val_type`, `sort_index`) VALUES ('242', '77', 'Size of message', '1', NULL, '000B', '1', '3');
    21. 

  21. INSERT INTO `ams_hexdefine_detail` (`id`, `business_type`, `col_name`, `col_type`, `bind_table`, `col_val`, `val_type`, `sort_index`) VALUES ('243', '77', 'Funcation code', '1', NULL, '0001', '1', '4');
    22. 

  22. INSERT INTO `ams_hexdefine_detail` (`id`, `business_type`, `col_name`, `col_type`, `bind_table`, `col_val`, `val_type`, `sort_index`) VALUES ('244', '77', 'Message type', '1', NULL, '0071', '1', '5');
    23. 

  23. INSERT INTO `ams_hexdefine_detail` (`id`, `business_type`, `col_name`, `col_type`, `bind_table`, `col_val`, `val_type`, `sort_index`) VALUES ('245', '77', 'Number of parameters', '1', NULL, '0008', '1', '6');
    24. 

  24. INSERT INTO `ams_hexdefine_detail` (`id`, `business_type`, `col_name`, `col_type`, `bind_table`, `col_val`, `val_type`, `sort_index`) VALUES ('246', '77', 'TS Order', '1', NULL, '4D', '1', '7');
    25. 

  25. INSERT INTO `ams_hexdefine_detail` (`id`, `business_type`, `col_name`, `col_type`, `bind_table`, `col_val`, `val_type`, `sort_index`) VALUES ('247', '77', 'Priority', '2', NULL, 'priority', '1', '8');
    26. 

  26. INSERT INTO `ams_hexdefine_detail` (`id`, `business_type`, `col_name`, `col_type`, `bind_table`, `col_val`, `val_type`, `sort_index`) VALUES ('248', '77', 'code', '1', NULL, '0001', '1', '9');
    27. 

  27. INSERT INTO `ams_hexdefine_detail` (`id`, `business_type`, `col_name`, `col_type`, `bind_table`, `col_val`, `val_type`, `sort_index`) VALUES ('249', '77', 'IKEY', '2', NULL, 'iKey', '1', '10');
    28. 

  28. INSERT INTO `ams_hexdefine_detail` (`id`, `business_type`, `col_name`, `col_type`, `bind_table`, `col_val`, `val_type`, `sort_index`) VALUES ('250', '77', 'LP0', '2', NULL, 'ext1', '1', '11');
    29.