update-2026.06.sql 1.46 KB

Edit Raw Blame History

ALTER TABLE `receipt_detail`
ADD COLUMN `areaCode` varchar(50) NULL COMMENT '库位' AFTER `materialID`;

ALTER TABLE `receipt_header`
ADD COLUMN `qcFlag` varchar(20) NULL COMMENT '检验标识：0-待检；1-合格；2-不合格' AFTER `mesCode`;

ALTER TABLE `receipt_header`
ADD COLUMN `makerName` varchar(64) NULL COMMENT '制单人' AFTER `qcFlag`;

ALTER TABLE `receipt_header`
ADD COLUMN `po` varchar(64) NULL COMMENT '工单号' AFTER `makerName`;

ALTER TABLE `receipt_header`
ADD COLUMN `orderDate` datetime NULL COMMENT '操作时间' AFTER `po`;

ALTER TABLE `receipt_detail`
ADD COLUMN `ctn` varchar(128) NULL COMMENT '箱签号' AFTER `areaCode`;

ALTER TABLE `receipt_header`
ADD COLUMN `source` varchar(20) NULL COMMENT '来源' AFTER `orderDate`;

ALTER TABLE `receipt_detail`
ADD COLUMN `inspectionDate` datetime NULL COMMENT '检验日期' AFTER `qcCheck`,
ADD COLUMN `inspector` varchar(64) NULL COMMENT '检验人员' AFTER `inspectionDate`;

ALTER TABLE `receipt_header`
ADD COLUMN `orderNo` varchar(64) NULL COMMENT '收货单号' AFTER `source`;

INSERT INTO `receipt_type` (`warehouseCode`, `companyCode`, `code`, `name`, `referType`, `receiptFlow`, `enable`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `version`, `processStamp`)
SELECT 'CS0001', 'BHF', 'JY', '检验入库单', '', '2', 1, NOW(), 'MES', NOW(), 'MES', 0, '0'
WHERE NOT EXISTS (
    SELECT 1 FROM `receipt_type` WHERE `warehouseCode` = 'CS0001' AND `companyCode` = 'BHF' AND `code` = 'JY'
);