14 lines
389 B
MySQL
14 lines
389 B
MySQL
|
-- 可选的数据库迁移脚本
|
||
|
|
-- 删除入库单表中的 receipt_method_detail 和 purpose_detail 字段
|
||
|
|
-- 注意：执行前请先备份数据库
|
||
|
|
|
||
|
|
-- 删除 receipt_method_detail 列
|
||
|
|
ALTER TABLE warehouse_receipt DROP COLUMN receipt_method_detail;
|
||
|
|
|
||
|
|
-- 删除 purpose_detail 列
|
||
|
|
ALTER TABLE warehouse_receipt DROP COLUMN purpose_detail;
|
||
|
|
|
||
|
|
-- 验证修改
|
||
|
|
DESCRIBE warehouse_receipt;
|
||
|
|
|