Home Explore Help
Register Sign In
WAREWMS
/
WAREAMS
2
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Tree: cd90cb06cc
Branches Tags
WAREAMS
/
base
/
sql
/
bsl_sql
/
bsl_dml_v1.0.0.sql

bsl_dml_v1.0.0.sql 5.0 KB
History Raw

1234567891011121314151617181920 
  1. UPDATE `warewms-baicuilai`.`base_sku_type` SET `item_name` = '成品', `parent_code` = '0', `status` = '0', `create_by` = '', `create_time` = '2023-03-30 13:36:01', `update_by` = '', `update_time` = '2023-03-30 13:36:30', `remark` = '' WHERE `item_code` = 1;
    2. 

  2. UPDATE `warewms-baicuilai`.`base_sku_type` SET `item_name` = '包材', `parent_code` = '0', `status` = '0', `create_by` = '', `create_time` = '2023-03-30 13:36:09', `update_by` = '', `update_time` = '2023-03-30 13:36:37', `remark` = NULL WHERE `item_code` = 2;
    3. 

  3. UPDATE `warewms-baicuilai`.`base_sku_type` SET `item_name` = '食品添加剂', `parent_code` = '0', `status` = '0', `create_by` = '', `create_time` = '2023-03-30 18:16:00', `update_by` = '', `update_time` = '2023-03-30 18:16:21', `remark` = NULL WHERE `item_code` = 3;
    4. 

  4. UPDATE `warewms-baicuilai`.`base_sku_type` SET `item_name` = '食品添加剂过敏原区', `parent_code` = '0', `status` = '0', `create_by` = '', `create_time` = '2023-03-30 18:16:33', `update_by` = '', `update_time` = NULL, `remark` = NULL WHERE `item_code` = 4;
    5. 

  5. 

  6. INSERT INTO `warewms-baicuilai`.`base_sku_type`(`item_code`, `item_name`, `parent_code`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (5, '原料', '0', '0', '', '2023-11-09 16:00:58', '', NULL, NULL);
    7. 

  7. INSERT INTO `warewms-baicuilai`.`base_sku_type`(`item_code`, `item_name`, `parent_code`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (6, '原料过敏', '0', '0', '', '2023-11-09 16:01:29', '', NULL, NULL);
    8. 

  8. INSERT INTO `warewms-baicuilai`.`base_sku_type`(`item_code`, `item_name`, `parent_code`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (7, '空托', '0', '0', '', '2023-11-09 16:01:50', '', NULL, NULL);
    9. 

  9. INSERT INTO `warewms-baicuilai`.`base_sku_type`(`item_code`, `item_name`, `parent_code`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (8, '低耗', '0', '0', '', '2023-11-09 16:02:14', '', NULL, NULL);
    10. 

  10. 

  11. INSERT INTO `warewms-baicuilai`.`sys_dict_type`(`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (119, '物料类型', 'sku_type', '0', 'admin', '2023-11-09 17:50:41', '', NULL, '物料类型');
    12. 

  12. 

  13. INSERT INTO `warewms-baicuilai`.`sys_dict_data`(`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (181, 0, '成品', '1', 'sku_type', NULL, 'default', 'N', '0', 'admin', '2023-11-09 17:53:59', '', NULL, NULL);
    14. 

  14. INSERT INTO `warewms-baicuilai`.`sys_dict_data`(`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (182, 0, '包材', '2', 'sku_type', NULL, 'default', 'N', '0', 'admin', '2023-11-09 17:55:08', '', NULL, NULL);
    15. 

  15. INSERT INTO `warewms-baicuilai`.`sys_dict_data`(`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (183, 0, '食品添加剂', '3', 'sku_type', NULL, 'default', 'N', '0', 'admin', '2023-11-09 17:55:26', '', NULL, NULL);
    16. 

  16. INSERT INTO `warewms-baicuilai`.`sys_dict_data`(`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (184, 0, '食品添加剂过敏原区', '4', 'sku_type', NULL, 'default', 'N', '0', 'admin', '2023-11-09 17:55:45', '', NULL, NULL);
    17. 

  17. INSERT INTO `warewms-baicuilai`.`sys_dict_data`(`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (185, 0, '原料', '5', 'sku_type', NULL, 'default', 'N', '0', 'admin', '2023-11-09 17:55:59', '', NULL, NULL);
    18. 

  18. INSERT INTO `warewms-baicuilai`.`sys_dict_data`(`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (186, 0, '原料过敏', '6', 'sku_type', NULL, 'default', 'N', '0', 'admin', '2023-11-09 17:56:13', '', NULL, NULL);
    19. 

  19. INSERT INTO `warewms-baicuilai`.`sys_dict_data`(`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (187, 0, '空托', '7', 'sku_type', NULL, 'default', 'N', '0', 'admin', '2023-11-09 17:56:25', '', NULL, NULL);
    20. 

  20. INSERT INTO `warewms-baicuilai`.`sys_dict_data`(`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (188, 0, '低耗', '8', 'sku_type', NULL, 'default', 'N', '0', 'admin', '2023-11-09 17:56:37', '', NULL, NULL);
    21.