Skip to content

J
jiedao-api-boot-master
Switch branch/tag
Find file
Normal viewHistoryPermalink
2022-11-05_update.sql 1.12 KB
Newer Older
lanbaoming's avatar
2024-04-08
1397b2a1
 
lanbaoming committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 

--  以下正式环境 已执行

alter table `ecw_order_warehouse_in` add column `specification_type` int DEFAULT '1' COMMENT '入仓规格类型';

INSERT INTO `system_dict_type`(`name`, `type`, `status`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`)
VALUES ('入仓规格类型', 'warehousing_specification_type', 0, '箱/整板', '115', '2022-11-04 23:33:45', '115', '2022-11-04 23:33:45', b'0');

INSERT INTO `system_dict_data`( `sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`)
VALUES ( 1, '箱',  '1', 'warehousing_specification_type', 0, 'default', '', '箱', '115', '2022-11-04 23:33:45', '115', '2022-11-04 23:33:45', b'0', 'pacakge');
INSERT INTO `system_dict_data`( `sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`)
VALUES ( 2, '整板', '2', 'warehousing_specification_type', 0, 'default', '', '整板', '115', '2022-11-04 23:33:45', '115', '2022-11-04 23:33:45', b'0', 'board');