WAREAMS/base_sql/bucket_sql/xuankuang_ddl_20230904.sql

-- ----------------------------
-- 增加库位对应wcs库位信息
-- ----------------------------
update base_location_info set userdefine4 = '0110S' where row_index = 1 and row_no = 10 and shift_no = 1;
update base_location_info set userdefine4 = '0205S' where row_index = 2 and row_no = 5 and shift_no = 1;
update base_location_info set userdefine4 = '0206S' where row_index = 2 and row_no = 6 and shift_no = 1;
update base_location_info set userdefine4 = '0207S' where row_index = 2 and row_no = 7 and shift_no = 1;
update base_location_info set userdefine4 = '0208S' where row_index = 2 and row_no = 8 and shift_no = 1;
update base_location_info set userdefine4 = '0210S' where row_index = 2 and row_no = 10 and shift_no = 1;
update base_location_info set userdefine4 = '0301S' where row_index = 3 and row_no = 1 and shift_no = 1;
update base_location_info set userdefine4 = '0302S' where row_index = 3 and row_no = 2 and shift_no = 1;
update base_location_info set userdefine4 = '0303S' where row_index = 3 and row_no = 3 and shift_no = 1;
update base_location_info set userdefine4 = '0305S' where row_index = 3 and row_no = 5 and shift_no = 1;
update base_location_info set userdefine4 = '0306S' where row_index = 3 and row_no = 6 and shift_no = 1;
update base_location_info set userdefine4 = '0307S' where row_index = 3 and row_no = 7 and shift_no = 1;
update base_location_info set userdefine4 = '0308S' where row_index = 3 and row_no = 8 and shift_no = 1;
update base_location_info set userdefine4 = '0310S' where row_index = 3 and row_no = 10 and shift_no = 1;
update base_location_info set userdefine4 = '0401S' where row_index = 4 and row_no = 1 and shift_no = 1;
update base_location_info set userdefine4 = '0402S' where row_index = 4 and row_no = 2 and shift_no = 1;
update base_location_info set userdefine4 = '0403S' where row_index = 4 and row_no = 3 and shift_no = 1;
update base_location_info set userdefine4 = '0405S' where row_index = 4 and row_no = 5 and shift_no = 1;
update base_location_info set userdefine4 = '0406S' where row_index = 4 and row_no = 6 and shift_no = 1;
update base_location_info set userdefine4 = '0407S' where row_index = 4 and row_no = 7 and shift_no = 1;
update base_location_info set userdefine4 = '0408S' where row_index = 4 and row_no = 8 and shift_no = 1;
update base_location_info set userdefine4 = '0410S' where row_index = 4 and row_no = 10 and shift_no = 1;
update base_location_info set userdefine4 = '0503S' where row_index = 5 and row_no = 3 and shift_no = 1;
update base_location_info set userdefine4 = '0505S' where row_index = 5 and row_no = 5 and shift_no = 1;
update base_location_info set userdefine4 = '0506S' where row_index = 5 and row_no = 6 and shift_no = 1;
update base_location_info set userdefine4 = '0507S' where row_index = 5 and row_no = 7 and shift_no = 1;
update base_location_info set userdefine4 = '0508S' where row_index = 5 and row_no = 8 and shift_no = 1;
update base_location_info set userdefine4 = '0510S' where row_index = 5 and row_no = 10 and shift_no = 1;
update base_location_info set userdefine4 = '0603S' where row_index = 6 and row_no = 3 and shift_no = 1;
update base_location_info set userdefine4 = '0605S' where row_index = 6 and row_no = 5 and shift_no = 1;
update base_location_info set userdefine4 = '0606S' where row_index = 6 and row_no = 6 and shift_no = 1;
update base_location_info set userdefine4 = '0607S' where row_index = 6 and row_no = 7 and shift_no = 1;
update base_location_info set userdefine4 = '0608S' where row_index = 6 and row_no = 8 and shift_no = 1;
update base_location_info set userdefine4 = '0610S' where row_index = 6 and row_no = 10 and shift_no = 1;
update base_location_info set userdefine4 = '0703S' where row_index = 7 and row_no = 3 and shift_no = 1;
update base_location_info set userdefine4 = '0705S' where row_index = 7 and row_no = 5 and shift_no = 1;
update base_location_info set userdefine4 = '0706S' where row_index = 7 and row_no = 6 and shift_no = 1;
update base_location_info set userdefine4 = '0707S' where row_index = 7 and row_no = 7 and shift_no = 1;
update base_location_info set userdefine4 = '0708S' where row_index = 7 and row_no = 8 and shift_no = 1;
update base_location_info set userdefine4 = '0710S' where row_index = 7 and row_no = 10 and shift_no = 1;
update base_location_info set userdefine4 = '0801S' where row_index = 8 and row_no = 1 and shift_no = 1;
update base_location_info set userdefine4 = '0802S' where row_index = 8 and row_no = 2 and shift_no = 1;
update base_location_info set userdefine4 = '0803S' where row_index = 8 and row_no = 3 and shift_no = 1;
update base_location_info set userdefine4 = '0805S' where row_index = 8 and row_no = 5 and shift_no = 1;
update base_location_info set userdefine4 = '0806S' where row_index = 8 and row_no = 6 and shift_no = 1;
update base_location_info set userdefine4 = '0807S' where row_index = 8 and row_no = 7 and shift_no = 1;
update base_location_info set userdefine4 = '0808S' where row_index = 8 and row_no = 8 and shift_no = 1;
update base_location_info set userdefine4 = '0810S' where row_index = 8 and row_no = 10 and shift_no = 1;
update base_location_info set userdefine4 = '0901S' where row_index = 9 and row_no = 1 and shift_no = 1;
update base_location_info set userdefine4 = '0902S' where row_index = 9 and row_no = 2 and shift_no = 1;
update base_location_info set userdefine4 = '0903S' where row_index = 9 and row_no = 3 and shift_no = 1;
update base_location_info set userdefine4 = '0905S' where row_index = 9 and row_no = 5 and shift_no = 1;
update base_location_info set userdefine4 = '0906S' where row_index = 9 and row_no = 6 and shift_no = 1;
update base_location_info set userdefine4 = '0907S' where row_index = 9 and row_no = 7 and shift_no = 1;
update base_location_info set userdefine4 = '0908S' where row_index = 9 and row_no = 8 and shift_no = 1;
update base_location_info set userdefine4 = '0910S' where row_index = 9 and row_no = 10 and shift_no = 1;
update base_location_info set userdefine4 = '1005S' where row_index = 10 and row_no = 5 and shift_no = 1;
update base_location_info set userdefine4 = '1006S' where row_index = 10 and row_no = 6 and shift_no = 1;
update base_location_info set userdefine4 = '1007S' where row_index = 10 and row_no = 7 and shift_no = 1;
update base_location_info set userdefine4 = '1008S' where row_index = 10 and row_no = 8 and shift_no = 1;
update base_location_info set userdefine4 = '1010S' where row_index = 10 and row_no = 10 and shift_no = 1;
update base_location_info set userdefine4 = '1110S' where row_index = 11 and row_no = 10 and shift_no = 1;
update base_location_info set userdefine4 = '1205S' where row_index = 12 and row_no = 5 and shift_no = 1;
update base_location_info set userdefine4 = '1206S' where row_index = 12 and row_no = 6 and shift_no = 1;
update base_location_info set userdefine4 = '1207S' where row_index = 12 and row_no = 7 and shift_no = 1;
update base_location_info set userdefine4 = '1208S' where row_index = 12 and row_no = 8 and shift_no = 1;
update base_location_info set userdefine4 = '1210S' where row_index = 12 and row_no = 10 and shift_no = 1;
update base_location_info set userdefine4 = '1303S' where row_index = 13 and row_no = 3 and shift_no = 1;
update base_location_info set userdefine4 = '1305S' where row_index = 13 and row_no = 5 and shift_no = 1;
update base_location_info set userdefine4 = '1306S' where row_index = 13 and row_no = 6 and shift_no = 1;
update base_location_info set userdefine4 = '1307S' where row_index = 13 and row_no = 7 and shift_no = 1;
update base_location_info set userdefine4 = '1308S' where row_index = 13 and row_no = 8 and shift_no = 1;
update base_location_info set userdefine4 = '1310S' where row_index = 13 and row_no = 10 and shift_no = 1;
update base_location_info set userdefine4 = '1405S' where row_index = 14 and row_no = 5 and shift_no = 1;
update base_location_info set userdefine4 = '1406S' where row_index = 14 and row_no = 6 and shift_no = 1;
update base_location_info set userdefine4 = '1407S' where row_index = 14 and row_no = 7 and shift_no = 1;
update base_location_info set userdefine4 = '1408S' where row_index = 14 and row_no = 8 and shift_no = 1;
update base_location_info set userdefine4 = '1410S' where row_index = 14 and row_no = 10 and shift_no = 1;
update base_location_info set userdefine4 = '0110S' where row_index = 1 and row_no = 10 and shift_no = 2;
update base_location_info set userdefine4 = '0205S' where row_index = 2 and row_no = 5 and shift_no = 2;
update base_location_info set userdefine4 = '0206S' where row_index = 2 and row_no = 6 and shift_no = 2;
update base_location_info set userdefine4 = '0207S' where row_index = 2 and row_no = 7 and shift_no = 2;
update base_location_info set userdefine4 = '0208S' where row_index = 2 and row_no = 8 and shift_no = 2;
update base_location_info set userdefine4 = '0210S' where row_index = 2 and row_no = 10 and shift_no = 2;
update base_location_info set userdefine4 = '0301S' where row_index = 3 and row_no = 1 and shift_no = 2;
update base_location_info set userdefine4 = '0302S' where row_index = 3 and row_no = 2 and shift_no = 2;
update base_location_info set userdefine4 = '0303S' where row_index = 3 and row_no = 3 and shift_no = 2;
update base_location_info set userdefine4 = '0305S' where row_index = 3 and row_no = 5 and shift_no = 2;
update base_location_info set userdefine4 = '0306S' where row_index = 3 and row_no = 6 and shift_no = 2;
update base_location_info set userdefine4 = '0307S' where row_index = 3 and row_no = 7 and shift_no = 2;
update base_location_info set userdefine4 = '0308S' where row_index = 3 and row_no = 8 and shift_no = 2;
update base_location_info set userdefine4 = '0310S' where row_index = 3 and row_no = 10 and shift_no = 2;
update base_location_info set userdefine4 = '0401S' where row_index = 4 and row_no = 1 and shift_no = 2;
update base_location_info set userdefine4 = '0402S' where row_index = 4 and row_no = 2 and shift_no = 2;
update base_location_info set userdefine4 = '0403S' where row_index = 4 and row_no = 3 and shift_no = 2;
update base_location_info set userdefine4 = '0405S' where row_index = 4 and row_no = 5 and shift_no = 2;
update base_location_info set userdefine4 = '0406S' where row_index = 4 and row_no = 6 and shift_no = 2;
update base_location_info set userdefine4 = '0407S' where row_index = 4 and row_no = 7 and shift_no = 2;
update base_location_info set userdefine4 = '0408S' where row_index = 4 and row_no = 8 and shift_no = 2;
update base_location_info set userdefine4 = '0410S' where row_index = 4 and row_no = 10 and shift_no = 2;
update base_location_info set userdefine4 = '0503S' where row_index = 5 and row_no = 3 and shift_no = 2;
update base_location_info set userdefine4 = '0505S' where row_index = 5 and row_no = 5 and shift_no = 2;
update base_location_info set userdefine4 = '0506S' where row_index = 5 and row_no = 6 and shift_no = 2;
update base_location_info set userdefine4 = '0507S' where row_index = 5 and row_no = 7 and shift_no = 2;
update base_location_info set userdefine4 = '0508S' where row_index = 5 and row_no = 8 and shift_no = 2;
update base_location_info set userdefine4 = '0510S' where row_index = 5 and row_no = 10 and shift_no = 2;
update base_location_info set userdefine4 = '0605S' where row_index = 6 and row_no = 5 and shift_no = 2;
update base_location_info set userdefine4 = '0606S' where row_index = 6 and row_no = 6 and shift_no = 2;
update base_location_info set userdefine4 = '0607S' where row_index = 6 and row_no = 7 and shift_no = 2;
update base_location_info set userdefine4 = '0608S' where row_index = 6 and row_no = 8 and shift_no = 2;
update base_location_info set userdefine4 = '0610S' where row_index = 6 and row_no = 10 and shift_no = 2;
update base_location_info set userdefine4 = '0703S' where row_index = 7 and row_no = 3 and shift_no = 2;
update base_location_info set userdefine4 = '0705S' where row_index = 7 and row_no = 5 and shift_no = 2;
update base_location_info set userdefine4 = '0706S' where row_index = 7 and row_no = 6 and shift_no = 2;
update base_location_info set userdefine4 = '0707S' where row_index = 7 and row_no = 7 and shift_no = 2;
update base_location_info set userdefine4 = '0708S' where row_index = 7 and row_no = 8 and shift_no = 2;
update base_location_info set userdefine4 = '0710S' where row_index = 7 and row_no = 10 and shift_no = 2;
update base_location_info set userdefine4 = '0801S' where row_index = 8 and row_no = 1 and shift_no = 2;
update base_location_info set userdefine4 = '0802S' where row_index = 8 and row_no = 2 and shift_no = 2;
update base_location_info set userdefine4 = '0803S' where row_index = 8 and row_no = 3 and shift_no = 2;
update base_location_info set userdefine4 = '0805S' where row_index = 8 and row_no = 5 and shift_no = 2;
update base_location_info set userdefine4 = '0806S' where row_index = 8 and row_no = 6 and shift_no = 2;
update base_location_info set userdefine4 = '0807S' where row_index = 8 and row_no = 7 and shift_no = 2;
update base_location_info set userdefine4 = '0808S' where row_index = 8 and row_no = 8 and shift_no = 2;
update base_location_info set userdefine4 = '0810S' where row_index = 8 and row_no = 10 and shift_no = 2;
update base_location_info set userdefine4 = '0901S' where row_index = 9 and row_no = 1 and shift_no = 2;
update base_location_info set userdefine4 = '0902S' where row_index = 9 and row_no = 2 and shift_no = 2;
update base_location_info set userdefine4 = '0903S' where row_index = 9 and row_no = 3 and shift_no = 2;
update base_location_info set userdefine4 = '0905S' where row_index = 9 and row_no = 5 and shift_no = 2;
update base_location_info set userdefine4 = '0906S' where row_index = 9 and row_no = 6 and shift_no = 2;
update base_location_info set userdefine4 = '0907S' where row_index = 9 and row_no = 7 and shift_no = 2;
update base_location_info set userdefine4 = '0908S' where row_index = 9 and row_no = 8 and shift_no = 2;
update base_location_info set userdefine4 = '0910S' where row_index = 9 and row_no = 10 and shift_no = 2;
update base_location_info set userdefine4 = '1005S' where row_index = 10 and row_no = 5 and shift_no = 2;
update base_location_info set userdefine4 = '1006S' where row_index = 10 and row_no = 6 and shift_no = 2;
update base_location_info set userdefine4 = '1007S' where row_index = 10 and row_no = 7 and shift_no = 2;
update base_location_info set userdefine4 = '1008S' where row_index = 10 and row_no = 8 and shift_no = 2;
update base_location_info set userdefine4 = '1010S' where row_index = 10 and row_no = 10 and shift_no = 2;
update base_location_info set userdefine4 = '1110S' where row_index = 11 and row_no = 10 and shift_no = 2;
update base_location_info set userdefine4 = '1205S' where row_index = 12 and row_no = 5 and shift_no = 2;
update base_location_info set userdefine4 = '1206S' where row_index = 12 and row_no = 6 and shift_no = 2;
update base_location_info set userdefine4 = '1207S' where row_index = 12 and row_no = 7 and shift_no = 2;
update base_location_info set userdefine4 = '1208S' where row_index = 12 and row_no = 8 and shift_no = 2;
update base_location_info set userdefine4 = '1210S' where row_index = 12 and row_no = 10 and shift_no = 2;
update base_location_info set userdefine4 = '1305S' where row_index = 13 and row_no = 5 and shift_no = 2;
update base_location_info set userdefine4 = '1306S' where row_index = 13 and row_no = 6 and shift_no = 2;
update base_location_info set userdefine4 = '1307S' where row_index = 13 and row_no = 7 and shift_no = 2;
update base_location_info set userdefine4 = '1308S' where row_index = 13 and row_no = 8 and shift_no = 2;
update base_location_info set userdefine4 = '1310S' where row_index = 13 and row_no = 10 and shift_no = 2;
update base_location_info set userdefine4 = '1405S' where row_index = 14 and row_no = 5 and shift_no = 2;
update base_location_info set userdefine4 = '1406S' where row_index = 14 and row_no = 6 and shift_no = 2;
update base_location_info set userdefine4 = '1407S' where row_index = 14 and row_no = 7 and shift_no = 2;
update base_location_info set userdefine4 = '1408S' where row_index = 14 and row_no = 8 and shift_no = 2;
update base_location_info set userdefine4 = '1410S' where row_index = 14 and row_no = 10 and shift_no = 2;
update base_location_info set userdefine4 = '0110S' where row_index = 1 and row_no = 10 and shift_no = 3;
update base_location_info set userdefine4 = '0205S' where row_index = 2 and row_no = 5 and shift_no = 3;
update base_location_info set userdefine4 = '0206S' where row_index = 2 and row_no = 6 and shift_no = 3;
update base_location_info set userdefine4 = '0207S' where row_index = 2 and row_no = 7 and shift_no = 3;
update base_location_info set userdefine4 = '0208S' where row_index = 2 and row_no = 8 and shift_no = 3;
update base_location_info set userdefine4 = '0210S' where row_index = 2 and row_no = 10 and shift_no = 3;
update base_location_info set userdefine4 = '0301S' where row_index = 3 and row_no = 1 and shift_no = 3;
update base_location_info set userdefine4 = '0302S' where row_index = 3 and row_no = 2 and shift_no = 3;
update base_location_info set userdefine4 = '0303S' where row_index = 3 and row_no = 3 and shift_no = 3;
update base_location_info set userdefine4 = '0305S' where row_index = 3 and row_no = 5 and shift_no = 3;
update base_location_info set userdefine4 = '0306S' where row_index = 3 and row_no = 6 and shift_no = 3;
update base_location_info set userdefine4 = '0307S' where row_index = 3 and row_no = 7 and shift_no = 3;
update base_location_info set userdefine4 = '0308S' where row_index = 3 and row_no = 8 and shift_no = 3;
update base_location_info set userdefine4 = '0310S' where row_index = 3 and row_no = 10 and shift_no = 3;
update base_location_info set userdefine4 = '0401S' where row_index = 4 and row_no = 1 and shift_no = 3;
update base_location_info set userdefine4 = '0402S' where row_index = 4 and row_no = 2 and shift_no = 3;
update base_location_info set userdefine4 = '0403S' where row_index = 4 and row_no = 3 and shift_no = 3;
update base_location_info set userdefine4 = '0405S' where row_index = 4 and row_no = 5 and shift_no = 3;
update base_location_info set userdefine4 = '0406S' where row_index = 4 and row_no = 6 and shift_no = 3;
update base_location_info set userdefine4 = '0407S' where row_index = 4 and row_no = 7 and shift_no = 3;
update base_location_info set userdefine4 = '0408S' where row_index = 4 and row_no = 8 and shift_no = 3;
update base_location_info set userdefine4 = '0410S' where row_index = 4 and row_no = 10 and shift_no = 3;
update base_location_info set userdefine4 = '0503S' where row_index = 5 and row_no = 3 and shift_no = 3;
update base_location_info set userdefine4 = '0505S' where row_index = 5 and row_no = 5 and shift_no = 3;
update base_location_info set userdefine4 = '0506S' where row_index = 5 and row_no = 6 and shift_no = 3;
update base_location_info set userdefine4 = '0507S' where row_index = 5 and row_no = 7 and shift_no = 3;
update base_location_info set userdefine4 = '0508S' where row_index = 5 and row_no = 8 and shift_no = 3;
update base_location_info set userdefine4 = '0510S' where row_index = 5 and row_no = 10 and shift_no = 3;
update base_location_info set userdefine4 = '0605S' where row_index = 6 and row_no = 5 and shift_no = 3;
update base_location_info set userdefine4 = '0606S' where row_index = 6 and row_no = 6 and shift_no = 3;
update base_location_info set userdefine4 = '0607S' where row_index = 6 and row_no = 7 and shift_no = 3;
update base_location_info set userdefine4 = '0608S' where row_index = 6 and row_no = 8 and shift_no = 3;
update base_location_info set userdefine4 = '0610S' where row_index = 6 and row_no = 10 and shift_no = 3;
update base_location_info set userdefine4 = '0703S' where row_index = 7 and row_no = 3 and shift_no = 3;
update base_location_info set userdefine4 = '0705S' where row_index = 7 and row_no = 5 and shift_no = 3;
update base_location_info set userdefine4 = '0706S' where row_index = 7 and row_no = 6 and shift_no = 3;
update base_location_info set userdefine4 = '0707S' where row_index = 7 and row_no = 7 and shift_no = 3;
update base_location_info set userdefine4 = '0708S' where row_index = 7 and row_no = 8 and shift_no = 3;
update base_location_info set userdefine4 = '0710S' where row_index = 7 and row_no = 10 and shift_no = 3;
update base_location_info set userdefine4 = '0801S' where row_index = 8 and row_no = 1 and shift_no = 3;
update base_location_info set userdefine4 = '0802S' where row_index = 8 and row_no = 2 and shift_no = 3;
update base_location_info set userdefine4 = '0803S' where row_index = 8 and row_no = 3 and shift_no = 3;
update base_location_info set userdefine4 = '0805S' where row_index = 8 and row_no = 5 and shift_no = 3;
update base_location_info set userdefine4 = '0806S' where row_index = 8 and row_no = 6 and shift_no = 3;
update base_location_info set userdefine4 = '0807S' where row_index = 8 and row_no = 7 and shift_no = 3;
update base_location_info set userdefine4 = '0808S' where row_index = 8 and row_no = 8 and shift_no = 3;
update base_location_info set userdefine4 = '0810S' where row_index = 8 and row_no = 10 and shift_no = 3;
update base_location_info set userdefine4 = '0901S' where row_index = 9 and row_no = 1 and shift_no = 3;
update base_location_info set userdefine4 = '0902S' where row_index = 9 and row_no = 2 and shift_no = 3;
update base_location_info set userdefine4 = '0903S' where row_index = 9 and row_no = 3 and shift_no = 3;
update base_location_info set userdefine4 = '0905S' where row_index = 9 and row_no = 5 and shift_no = 3;
update base_location_info set userdefine4 = '0906S' where row_index = 9 and row_no = 6 and shift_no = 3;
update base_location_info set userdefine4 = '0907S' where row_index = 9 and row_no = 7 and shift_no = 3;
update base_location_info set userdefine4 = '0908S' where row_index = 9 and row_no = 8 and shift_no = 3;
update base_location_info set userdefine4 = '0910S' where row_index = 9 and row_no = 10 and shift_no = 3;
update base_location_info set userdefine4 = '1005S' where row_index = 10 and row_no = 5 and shift_no = 3;
update base_location_info set userdefine4 = '1006S' where row_index = 10 and row_no = 6 and shift_no = 3;
update base_location_info set userdefine4 = '1007S' where row_index = 10 and row_no = 7 and shift_no = 3;
update base_location_info set userdefine4 = '1008S' where row_index = 10 and row_no = 8 and shift_no = 3;
update base_location_info set userdefine4 = '1010S' where row_index = 10 and row_no = 10 and shift_no = 3;
update base_location_info set userdefine4 = '1110S' where row_index = 11 and row_no = 10 and shift_no = 3;
update base_location_info set userdefine4 = '1205S' where row_index = 12 and row_no = 5 and shift_no = 3;
update base_location_info set userdefine4 = '1206S' where row_index = 12 and row_no = 6 and shift_no = 3;
update base_location_info set userdefine4 = '1207S' where row_index = 12 and row_no = 7 and shift_no = 3;
update base_location_info set userdefine4 = '1208S' where row_index = 12 and row_no = 8 and shift_no = 3;
update base_location_info set userdefine4 = '1210S' where row_index = 12 and row_no = 10 and shift_no = 3;
update base_location_info set userdefine4 = '1305S' where row_index = 13 and row_no = 5 and shift_no = 3;
update base_location_info set userdefine4 = '1306S' where row_index = 13 and row_no = 6 and shift_no = 3;
update base_location_info set userdefine4 = '1307S' where row_index = 13 and row_no = 7 and shift_no = 3;
update base_location_info set userdefine4 = '1308S' where row_index = 13 and row_no = 8 and shift_no = 3;
update base_location_info set userdefine4 = '1310S' where row_index = 13 and row_no = 10 and shift_no = 3;
update base_location_info set userdefine4 = '1405S' where row_index = 14 and row_no = 5 and shift_no = 3;
update base_location_info set userdefine4 = '1406S' where row_index = 14 and row_no = 6 and shift_no = 3;
update base_location_info set userdefine4 = '1407S' where row_index = 14 and row_no = 7 and shift_no = 3;
update base_location_info set userdefine4 = '1408S' where row_index = 14 and row_no = 8 and shift_no = 3;
update base_location_info set userdefine4 = '1410S' where row_index = 14 and row_no = 10 and shift_no = 3;

DELETE FROM base_location_info WHERE id = 101334;
DELETE FROM base_location_info WHERE id = 101333;
DELETE FROM base_location_info WHERE id = 101332;
DELETE FROM base_location_info WHERE id = 101331;
DELETE FROM base_location_info WHERE id = 101330;
DELETE FROM base_location_info WHERE id = 100726;
DELETE FROM base_location_info WHERE id = 100728;
INSERT INTO `base_location_info` (`id`, `warehouse_id`, `zone_id`, `location_no`, `location_barcode`, `row_no`, `row_index`, `col_no`, `col_index`, `shift_no`, `shift_index`, `stock_status`, `is_empty`, `bind_sku`, `location_type`, `rack_id`, `agv_station`, `folded_tag`, `folded_count`, `height_limit`, `weight_limit`, `userdefine1`, `userdefine2`, `userdefine3`, `userdefine4`, `userdefine5`, `userdefine6`, `userdefine7`, `userdefine8`, `userdefine9`, `userdefine10`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (101334, 1, 4, 'empty-pallet-06', NULL, NULL, NULL, '3', 1, NULL, NULL, '00', 'Y', '3', '2', NULL, NULL, 1, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'EMP_TRAY_BAG', '', '2023-08-22 16:41:57', 'admin', NULL, NULL);
INSERT INTO `base_location_info` (`id`, `warehouse_id`, `zone_id`, `location_no`, `location_barcode`, `row_no`, `row_index`, `col_no`, `col_index`, `shift_no`, `shift_index`, `stock_status`, `is_empty`, `bind_sku`, `location_type`, `rack_id`, `agv_station`, `folded_tag`, `folded_count`, `height_limit`, `weight_limit`, `userdefine1`, `userdefine2`, `userdefine3`, `userdefine4`, `userdefine5`, `userdefine6`, `userdefine7`, `userdefine8`, `userdefine9`, `userdefine10`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (101333, 1, 4, 'empty-pallet-05', NULL, NULL, NULL, '3', 1, NULL, NULL, '00', 'Y', '3', '2', NULL, NULL, 1, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'EMP_TRAY_BAG', '', '2023-08-22 16:41:57', 'admin', NULL, NULL);
INSERT INTO `base_location_info` (`id`, `warehouse_id`, `zone_id`, `location_no`, `location_barcode`, `row_no`, `row_index`, `col_no`, `col_index`, `shift_no`, `shift_index`, `stock_status`, `is_empty`, `bind_sku`, `location_type`, `rack_id`, `agv_station`, `folded_tag`, `folded_count`, `height_limit`, `weight_limit`, `userdefine1`, `userdefine2`, `userdefine3`, `userdefine4`, `userdefine5`, `userdefine6`, `userdefine7`, `userdefine8`, `userdefine9`, `userdefine10`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (101332, 1, 4, 'empty-pallet-04', NULL, NULL, NULL, '3', 1, NULL, NULL, '00', 'Y', '3', '2', NULL, NULL, 1, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'EMP_TRAY_BAG', '', '2023-08-22 16:41:57', 'admin', NULL, NULL);
INSERT INTO `base_location_info` (`id`, `warehouse_id`, `zone_id`, `location_no`, `location_barcode`, `row_no`, `row_index`, `col_no`, `col_index`, `shift_no`, `shift_index`, `stock_status`, `is_empty`, `bind_sku`, `location_type`, `rack_id`, `agv_station`, `folded_tag`, `folded_count`, `height_limit`, `weight_limit`, `userdefine1`, `userdefine2`, `userdefine3`, `userdefine4`, `userdefine5`, `userdefine6`, `userdefine7`, `userdefine8`, `userdefine9`, `userdefine10`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (101331, 1, 4, 'empty-pallet-03', NULL, NULL, NULL, '3', 1, NULL, NULL, '00', 'Y', '3', '2', NULL, NULL, 1, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'EMP_TRAY_BAG', '', '2023-08-21 16:27:10', 'admin', NULL, NULL);
INSERT INTO `base_location_info` (`id`, `warehouse_id`, `zone_id`, `location_no`, `location_barcode`, `row_no`, `row_index`, `col_no`, `col_index`, `shift_no`, `shift_index`, `stock_status`, `is_empty`, `bind_sku`, `location_type`, `rack_id`, `agv_station`, `folded_tag`, `folded_count`, `height_limit`, `weight_limit`, `userdefine1`, `userdefine2`, `userdefine3`, `userdefine4`, `userdefine5`, `userdefine6`, `userdefine7`, `userdefine8`, `userdefine9`, `userdefine10`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (101330, 1, 4, 'empty-pallet-02', NULL, NULL, NULL, '3', 1, NULL, NULL, '00', 'Y', '3', '2', NULL, NULL, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'EMP_TRAY_BAG', '', '2023-08-21 16:16:38', 'Wcs', '2023-08-22 20:24:22', NULL);
INSERT INTO `base_location_info` (`id`, `warehouse_id`, `zone_id`, `location_no`, `location_barcode`, `row_no`, `row_index`, `col_no`, `col_index`, `shift_no`, `shift_index`, `stock_status`, `is_empty`, `bind_sku`, `location_type`, `rack_id`, `agv_station`, `folded_tag`, `folded_count`, `height_limit`, `weight_limit`, `userdefine1`, `userdefine2`, `userdefine3`, `userdefine4`, `userdefine5`, `userdefine6`, `userdefine7`, `userdefine8`, `userdefine9`, `userdefine10`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (100726, 1, 4, 'empty-pallet-01', NULL, NULL, NULL, '3', 1, NULL, NULL, '00', 'Y', '3', '2', NULL, NULL, 1, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'EMP_TRAY_BAG', '', '2023-03-30 17:27:01', 'admin', '2023-08-21 16:03:24', NULL);
INSERT INTO `base_location_info` (`id`, `warehouse_id`, `zone_id`, `location_no`, `location_barcode`, `row_no`, `row_index`, `col_no`, `col_index`, `shift_no`, `shift_index`, `stock_status`, `is_empty`, `bind_sku`, `location_type`, `rack_id`, `agv_station`, `folded_tag`, `folded_count`, `height_limit`, `weight_limit`, `userdefine1`, `userdefine2`, `userdefine3`, `userdefine4`, `userdefine5`, `userdefine6`, `userdefine7`, `userdefine8`, `userdefine9`, `userdefine10`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (100728, 1, 5, 'empty-bucket-01', NULL, NULL, NULL, '2', 1, NULL, NULL, '00', 'Y', '1', '2', NULL, NULL, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-03-30 17:27:53', 'NDC', '2023-08-02 20:22:23', NULL);


DELETE FROM `inv_lot_loc_id` WHERE location_id = 101334;
DELETE FROM `inv_lot_loc_id` WHERE location_id = 101333;
DELETE FROM `inv_lot_loc_id` WHERE location_id = 101332;
DELETE FROM `inv_lot_loc_id` WHERE location_id = 101331;
DELETE FROM `inv_lot_loc_id` WHERE location_id = 101330;
DELETE FROM `inv_lot_loc_id` WHERE location_id = 100726;
INSERT INTO `inv_lot_loc_id` (`lotnum`, `location_id`, `traceid`, `customer_id`, `sku`, `qty`, `qty_each`, `qtyallocated`, `qtyallocated_each`, `qtypa`, `qtyrpin`, `qtyrpout`, `qtymvin`, `qtymvout`, `qtyonhold`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ('LT2088080800888888', '101334', NULL, 'default', 'EMP_TRAY_BAG', 1.00000000, 1.00000000, 0.00000000, 0.00000000, 0.00000000, 0.000, NULL, NULL, NULL, NULL, '', NULL, 'Generator', NULL, NULL);
INSERT INTO `inv_lot_loc_id` (`lotnum`, `location_id`, `traceid`, `customer_id`, `sku`, `qty`, `qty_each`, `qtyallocated`, `qtyallocated_each`, `qtypa`, `qtyrpin`, `qtyrpout`, `qtymvin`, `qtymvout`, `qtyonhold`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ('LT2088081800888888', '101333', NULL, 'default', 'EMP_TRAY_BAG', 1.00000000, 1.00000000, 0.00000000, 0.00000000, 0.00000000, 0.000, NULL, NULL, NULL, NULL, '', NULL, 'Generator', NULL, NULL);
INSERT INTO `inv_lot_loc_id` (`lotnum`, `location_id`, `traceid`, `customer_id`, `sku`, `qty`, `qty_each`, `qtyallocated`, `qtyallocated_each`, `qtypa`, `qtyrpin`, `qtyrpout`, `qtymvin`, `qtymvout`, `qtyonhold`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ('LT2088082800888888', '101332', NULL, 'default', 'EMP_TRAY_BAG', 1.00000000, 1.00000000, 0.00000000, 0.00000000, 0.00000000, 0.000, NULL, NULL, NULL, NULL, '', NULL, 'Generator', NULL, NULL);
INSERT INTO `inv_lot_loc_id` (`lotnum`, `location_id`, `traceid`, `customer_id`, `sku`, `qty`, `qty_each`, `qtyallocated`, `qtyallocated_each`, `qtypa`, `qtyrpin`, `qtyrpout`, `qtymvin`, `qtymvout`, `qtyonhold`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ('LT2088083800888888', '101331', NULL, 'default', 'EMP_TRAY_BAG', 1.00000000, 1.00000000, 0.00000000, 0.00000000, 0.00000000, 0.000, NULL, NULL, NULL, NULL, '', NULL, 'Generator', NULL, NULL);
INSERT INTO `inv_lot_loc_id` (`lotnum`, `location_id`, `traceid`, `customer_id`, `sku`, `qty`, `qty_each`, `qtyallocated`, `qtyallocated_each`, `qtypa`, `qtyrpin`, `qtyrpout`, `qtymvin`, `qtymvout`, `qtyonhold`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ('LT2088084800888888', '101330', NULL, 'default', 'EMP_TRAY_BAG', 1.00000000, 1.00000000, 0.00000000, 0.00000000, 0.00000000, 0.000, NULL, NULL, NULL, NULL, '', NULL, 'Generator', NULL, NULL);
INSERT INTO `inv_lot_loc_id` (`lotnum`, `location_id`, `traceid`, `customer_id`, `sku`, `qty`, `qty_each`, `qtyallocated`, `qtyallocated_each`, `qtypa`, `qtyrpin`, `qtyrpout`, `qtymvin`, `qtymvout`, `qtyonhold`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ('LT2088085800888888', '100726', NULL, 'default', 'EMP_TRAY_BAG', 1.00000000, 1.00000000, 0.00000000, 0.00000000, 0.00000000, 0.000, NULL, NULL, NULL, NULL, '', NULL, 'Generator', NULL, NULL);

DELETE FROM `sys_config` WHERE config_id = 9;
INSERT INTO `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (9, '桶装入库场景配置', 'storage.bucket.scene.config', '{\"bucketLocationIdList\":[100733],\"emptyPalletInvList\":[100726,101330,101331,101332,101333,101334],\"emptyPalletInvSort\":[100726,101330,101331,101332,101333,101334],\"locationZoneIdList\":[4,5],\"bucketCacheOut\":[100727],\"bucketCacheIn\":[100724,100725],\"emptyPalletTargetOut\":[100724,100725],\"emptyPalletSourceIn\":[100728],\"bucketCacheZoneIn\":[4],\"bucketCacheZoneOut\":[5]}', 'N', 'admin', '2023-08-21 16:06:47', 'admin', '2023-08-21 16:07:02', '桶装入库库位配置');
DELETE FROM `sys_config` WHERE config_id = 10;
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, '系统初始化仓库属性配置', 'warehouse.attribute.scene.config', '{\"row\":14,\"column\":10,\"wayRowNoList\":[4,9],\"orderRuleConfig\":\"false\"}', 'N', 'admin', '2023-09-06 22:53:21', 'admin', '2023-09-06 22:53:26', '出库建模配置');

DELETE FROM `ams_hexdefine_detail` WHERE business_type = '101';
INSERT INTO `ams_hexdefine_detail` (`business_type`, `col_name`, `col_type`, `bind_table`, `col_val`, `val_type`, `sort_index`) VALUES ( '101', 'Header key', '1', NULL, '87CD', '1', '1');
INSERT INTO `ams_hexdefine_detail` (`business_type`, `col_name`, `col_type`, `bind_table`, `col_val`, `val_type`, `sort_index`) VALUES ( '101', 'Size of header', '1', NULL, '0008', '1', '2');
INSERT INTO `ams_hexdefine_detail` (`business_type`, `col_name`, `col_type`, `bind_table`, `col_val`, `val_type`, `sort_index`) VALUES ( '101', 'Size of message', '1', NULL, '000E', '1', '3');
INSERT INTO `ams_hexdefine_detail` (`business_type`, `col_name`, `col_type`, `bind_table`, `col_val`, `val_type`, `sort_index`) VALUES ( '101', 'Funcation code', '1', NULL, '0001', '1', '4');
INSERT INTO `ams_hexdefine_detail` (`business_type`, `col_name`, `col_type`, `bind_table`, `col_val`, `val_type`, `sort_index`) VALUES ( '101', 'Message type', '1', NULL, '0071', '1', '5');
INSERT INTO `ams_hexdefine_detail` (`business_type`, `col_name`, `col_type`, `bind_table`, `col_val`, `val_type`, `sort_index`) VALUES ( '101', 'Number of parameters', '1', NULL, '000A', '1', '6');
INSERT INTO `ams_hexdefine_detail` (`business_type`, `col_name`, `col_type`, `bind_table`, `col_val`, `val_type`, `sort_index`) VALUES ( '101', 'TS Order', '1', NULL, '65', '1', '7');
INSERT INTO `ams_hexdefine_detail` (`business_type`, `col_name`, `col_type`, `bind_table`, `col_val`, `val_type`, `sort_index`) VALUES ( '101', 'Priority', '2', NULL, 'priority', '1', '8');
INSERT INTO `ams_hexdefine_detail` (`business_type`, `col_name`, `col_type`, `bind_table`, `col_val`, `val_type`, `sort_index`) VALUES ( '101', 'code', '1', NULL, '0001', '1', '9');
INSERT INTO `ams_hexdefine_detail` (`business_type`, `col_name`, `col_type`, `bind_table`, `col_val`, `val_type`, `sort_index`) VALUES ( '101', 'IKEY', '2', NULL, 'iKey', '1', '10');
INSERT INTO `ams_hexdefine_detail` (`business_type`, `col_name`, `col_type`, `bind_table`, `col_val`, `val_type`, `sort_index`) VALUES ( '101', 'LP0', '2', NULL, 'ext2', '1', '11');
INSERT INTO `ams_hexdefine_detail` (`business_type`, `col_name`, `col_type`, `bind_table`, `col_val`, `val_type`, `sort_index`) VALUES ( '101', 'LP1', '2', NULL, 'ext3', '1', '12');



INSERT INTO `sys_job` (`job_id`, `job_name`, `job_group`, `invoke_target`, `cron_expression`, `misfire_policy`, `concurrent`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (18, '搅拌槽出库单创建流程', 'DEFAULT', 'startService.agitateTankCreateOrderTask', '0/30 * * * * ?', '1', '1', '0', 'admin', '2023-09-22 13:54:21', 'admin', '2023-09-22 13:54:31', NULL);
INSERT INTO `sys_job` (`job_id`, `job_name`, `job_group`, `invoke_target`, `cron_expression`, `misfire_policy`, `concurrent`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (19, '搅拌槽开始任务流程', 'DEFAULT', 'startService.agitateTankExcuteTask', '0/30 * * * * ?', '1', '1', '0', 'admin', '2023-09-22 13:54:21', 'admin', '2023-09-22 13:54:31', NULL);