product-inventory-management-after.git

¶Ô±ÈÐÂÎÄ¼þ
			@@ -0,0 +1,15 @@
			-- æ´æ¹ production_order_pick

			ALTER TABLE `production_order_pick`
			MODIFY COLUMN `quantity` decimal (20, 8) NULL DEFAULT NULL COMMENT 'æ°é' AFTER `product_model_id`,
			MODIFY COLUMN `demanded_quantity` decimal (20, 8) NULL DEFAULT NULL COMMENT 'éæ±æ°é' AFTER `technology_operation_id`,
			MODIFY COLUMN `feeding_qty` decimal (20, 8) NULL DEFAULT NULL COMMENT 'è¡¥ææ»é' AFTER `is_returned`,
			MODIFY COLUMN `return_qty` decimal (20, 8) NULL DEFAULT NULL COMMENT 'éææ°é' AFTER `feeding_qty`,
			MODIFY COLUMN `actual_qty` decimal (20, 8) NULL DEFAULT NULL COMMENT 'å®éæ°é' AFTER `return_qty`;

			-- æ´æ¹ production_order_pick_record

			ALTER TABLE `production_order_pick_record`
			MODIFY COLUMN `pick_quantity` decimal (20, 8) NULL DEFAULT NULL COMMENT 'é¢ææ°é' AFTER `batch_no`,
			MODIFY COLUMN `before_quantity` decimal (20, 8) NULL DEFAULT NULL COMMENT 'é¢æåæ°é' AFTER `pick_quantity`,
			MODIFY COLUMN `after_quantity` decimal (20, 8) NULL DEFAULT NULL COMMENT 'é¢æåå©ä½æ°é' AFTER `before_quantity`;