-- =====================================================
|
-- mdm_item 表新增字段：辅单位、默认仓库
|
-- 执行时间：2026-07-01
|
-- =====================================================
|
|
ALTER TABLE `mdm_item`
|
ADD COLUMN `unit_measure_id2` bigint DEFAULT NULL COMMENT '辅单位1编号' AFTER `unit_measure_id`,
|
ADD COLUMN `unit_measure_rate1` decimal(24,6) DEFAULT NULL COMMENT '辅单位1换算比率' AFTER `unit_measure_id2`,
|
ADD COLUMN `unit_measure_id3` bigint DEFAULT NULL COMMENT '辅单位2编号' AFTER `unit_measure_rate1`,
|
ADD COLUMN `unit_measure_rate2` decimal(24,6) DEFAULT NULL COMMENT '辅单位2换算比率' AFTER `unit_measure_id3`,
|
ADD COLUMN `warehouse_id` bigint DEFAULT NULL COMMENT '默认仓库编号' AFTER `unit_measure_rate2`,
|
ADD COLUMN `warehouse_code` varchar(50) DEFAULT NULL COMMENT '默认仓库编码' AFTER `warehouse_id`;
|
