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

bsl_dml_v1.0.0.sql 13 KB
History Raw

1234567891011121314151617181920212223242526272829303132333435363738394041 
  1. UPDATE `warewms-baisuilai`.`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-baisuilai`.`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-baisuilai`.`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-baisuilai`.`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-baisuilai`.`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-baisuilai`.`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-baisuilai`.`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-baisuilai`.`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-baisuilai`.`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. INSERT INTO `warewms-baisuilai`.`sys_dict_type`(`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (120, '供应商状态', 'supplier_status', '0', 'admin', '2023-11-10 09:53:05', 'admin', '2023-11-10 09:53:19', '供应商状态');
    13. 

  13. 

  14. INSERT INTO `warewms-baisuilai`.`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);
    15. 

  15. INSERT INTO `warewms-baisuilai`.`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);
    16. 

  16. INSERT INTO `warewms-baisuilai`.`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);
    17. 

  17. INSERT INTO `warewms-baisuilai`.`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);
    18. 

  18. INSERT INTO `warewms-baisuilai`.`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);
    19. 

  19. INSERT INTO `warewms-baisuilai`.`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);
    20. 

  20. INSERT INTO `warewms-baisuilai`.`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);
    21. 

  21. INSERT INTO `warewms-baisuilai`.`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);
    22. 

  22. 

  23. INSERT INTO `warewms-baisuilai`.`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 (189, 0, '禁用', '0', 'supplier_status', NULL, 'danger', 'N', '0', 'admin', '2023-11-10 09:54:49', 'admin', '2023-11-10 09:54:55', '禁用');
    24. 

  24. INSERT INTO `warewms-baisuilai`.`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 (190, 1, '启用且合格', '1', 'supplier_status', NULL, 'primary', 'N', '0', 'admin', '2023-11-10 09:55:46', 'admin', '2023-11-10 09:59:15', '启用且合格');
    25. 

  25. INSERT INTO `warewms-baisuilai`.`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 (191, 2, '启用不合格', '2', 'supplier_status', NULL, 'warning', 'N', '0', 'admin', '2023-11-10 09:59:07', '', NULL, '启用不合格');
    26. 

  26. 

  27. UPDATE `warewms-baisuilai`.`sys_dict_data` SET `dict_sort` = 1, `dict_label` = '生产领料单', `dict_value` = 'ProductionPickingReceipt', `dict_type` = 'so_type', `css_class` = NULL, `list_class` = 'default', `is_default` = 'N', `status` = '0', `create_by` = 'admin', `create_time` = '2022-10-18 22:18:04', `update_by` = 'admin', `update_time` = '2023-11-13 14:38:08', `remark` = NULL WHERE `dict_code` = 142;
    28. 

  28. UPDATE `warewms-baisuilai`.`sys_dict_data` SET `dict_sort` = 2, `dict_label` = '销售出库单', `dict_value` = 'SaleOutboundOrder', `dict_type` = 'so_type', `css_class` = NULL, `list_class` = 'default', `is_default` = 'N', `status` = '0', `create_by` = 'admin', `create_time` = '2022-10-18 22:19:56', `update_by` = 'admin', `update_time` = '2023-11-13 14:38:34', `remark` = NULL WHERE `dict_code` = 143;
    29. 

  29. UPDATE `warewms-baisuilai`.`sys_dict_data` SET `dict_sort` = 1, `dict_label` = '成品入库单', `dict_value` = 'FinishedProductReceipt', `dict_type` = 'asn_type', `css_class` = NULL, `list_class` = 'default', `is_default` = 'N', `status` = '0', `create_by` = 'admin', `create_time` = '2022-10-11 17:34:00', `update_by` = 'admin', `update_time` = '2023-11-13 14:35:28', `remark` = NULL WHERE `dict_code` = 119;
    30. 

  30. UPDATE `warewms-baisuilai`.`sys_dict_data` SET `dict_sort` = 2, `dict_label` = '生产退库单', `dict_value` = 'ProductionReturnOrder', `dict_type` = 'asn_type', `css_class` = NULL, `list_class` = 'default', `is_default` = 'N', `status` = '0', `create_by` = 'admin', `create_time` = '2022-10-11 17:34:32', `update_by` = 'admin', `update_time` = '2023-11-13 14:36:11', `remark` = NULL WHERE `dict_code` = 120;
    31. 

  31. UPDATE `warewms-baisuilai`.`sys_dict_data` SET `dict_sort` = 3, `dict_label` = '销售退库单', `dict_value` = 'SaleReturnOrder', `dict_type` = 'asn_type', `css_class` = NULL, `list_class` = 'default', `is_default` = 'N', `status` = '0', `create_by` = 'admin', `create_time` = '2023-04-03 19:51:54', `update_by` = 'admin', `update_time` = '2023-11-13 14:36:34', `remark` = NULL WHERE `dict_code` = 163;
    32. 

  32. UPDATE `warewms-baisuilai`.`sys_dict_data` SET `dict_sort` = 0, `dict_label` = '采购收货', `dict_value` = 'PurchaseReceipt', `dict_type` = 'asn_type', `css_class` = NULL, `list_class` = 'default', `is_default` = 'N', `status` = '0', `create_by` = 'admin', `create_time` = '2023-05-16 12:15:03', `update_by` = 'admin', `update_time` = '2023-11-13 14:34:53', `remark` = NULL WHERE `dict_code` = 176;
    33. 

  33. 

  34. INSERT INTO `warewms-baicuilai`.`sys_config`(`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1, '主框架页-默认皮肤样式名称', 'sys.index.skinName', 'skin-blue', 'Y', 'admin', '2022-02-09 15:16:10', '', NULL, '蓝色 skin-blue、绿色 skin-green、紫色 skin-purple、红色 skin-red、黄色 skin-yellow');
    35. 

  35. INSERT INTO `warewms-baicuilai`.`sys_config`(`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2, '用户管理-账号初始密码', 'sys.user.initPassword', '123456', 'Y', 'admin', '2022-02-09 15:16:10', '', NULL, '初始化密码 123456');
    36. 

  36. INSERT INTO `warewms-baicuilai`.`sys_config`(`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (3, '主框架页-侧边栏主题', 'sys.index.sideTheme', 'theme-dark', 'Y', 'admin', '2022-02-09 15:16:10', '', NULL, '深色主题theme-dark，浅色主题theme-light');
    37. 

  37. INSERT INTO `warewms-baicuilai`.`sys_config`(`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (4, '账号自助-验证码开关', 'sys.account.captchaOnOff', 'false', 'Y', 'admin', '2022-02-09 15:16:10', 'admin', '2022-02-16 10:55:56', '是否开启验证码功能（true开启，false关闭）');
    38. 

  38. INSERT INTO `warewms-baicuilai`.`sys_config`(`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (5, '账号自助-是否开启用户注册功能', 'sys.account.registerUser', 'false', 'Y', 'admin', '2022-02-09 15:16:10', '', NULL, '是否开启注册用户功能（true开启，false关闭）');
    39. 

  39. INSERT INTO `warewms-baicuilai`.`sys_config`(`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (7, 'RFID标签（墙外）', 'sys.rfid.tag.out', 'E2806995000040075925A12E,E28069950000500090C0952B', 'N', 'admin', '2023-01-07 17:42:05', 'admin', '2023-01-10 15:02:59', 'RFID对应的读取标签号');
    40. 

  40. INSERT INTO `warewms-baicuilai`.`sys_config`(`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (8, 'RFID标签（室内）', 'sys.rfid.tag.in', '22', 'N', 'admin', '2023-01-07 17:42:52', 'admin', '2023-01-07 17:43:29', 'RFID对应的读取标签号');
    41. 

  41. INSERT INTO `warewms-baicuilai`.`sys_config`(`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (9, '单据导出中文字段', 'sys.doc.field.remark', '{\"docNo\":\"单据号\",\"docType\":\"单据类型\",\"businessType\":\"业务类型\",\"remark\":\"备注\",\"docLineNo\":\"明细行号\",\"skuCode\":\"物料编码\",\"skuName\":\"物料名称\",\"skuQty\":\"物料数量\",\"productLotNumber\":\"产品批号\",\"receiver\":\"收货人\",\"warehousePerson\":\"入库人\",\"reviewerNext\":\"复审人\",\"specification\":\"规格\",\"qualityInspectionDoc\":\"质检单号\",\"incomeLotNumber\":\"进厂批号\",\"productLotNumber\":\"产品批号\",\"measureUnit\":\"计量单位\",\"manufactureDate\":\"生产日期\",\"returner\":\"退库人\",\"vendorCode\":\"供应商编码\",\"vendorName\":\"供应商全称\",\"purchaser\":\"采购人\",\"taxRate\":\"税率\",\"originalLotNumber\":\"进厂批号\",\"incomeLotNumber\":\"进厂批号\",\"manufactureDate\":\"生产日期\",\"priceIncludeTax\":\"含税价\",\"customName\":\"客户名称\",\"reviewer\":\"审核人\",\"receiveAddress\":\"收货地址\",\"receivePhone\":\"收货人电话\",\"docCreator\":\"制单人\",\"shipper\":\"发货人\",\"receivePhone\":\"收货人电话\",\"saleContract\":\"销售合同\",\"productName\":\"产品名称\",\"saleReturnUnit\":\"销售退货单位\",\"saleReturner\":\"销售退货人\",\"warehouseType\":\"仓库类别\",\"saleReturner\":\"销售退货人\"}', 'N', '', NULL, '', NULL, NULL);
    42.