8 lines
345 B
MySQL
8 lines
345 B
MySQL
|
-- 完工入库单明细表添加销售订单关联字段
|
||
|
|
ALTER TABLE `wm_manufacture_into_entry`
|
||
|
|
ADD COLUMN `sale_order_entry_id` BIGINT(20) NULL COMMENT '销售订单明细ID' AFTER `manufacture_date`;
|
||
|
|
|
||
|
|
-- 添加索引以提高查询性能
|
||
|
|
ALTER TABLE `wm_manufacture_into_entry`
|
||
|
|
ADD INDEX `idx_sale_order_entry_id` (`sale_order_entry_id`);
|