5 lines
324 B
SQL
5 lines
324 B
SQL
update purchase_check_info set purchaser = null where purchaser = 0;
|
|
update purchase_part_info set purchaser = null where purchaser = 0;
|
|
|
|
ALTER TABLE purchase_check_info MODIFY COLUMN purchaser int default null comment '采购员';
|
|
ALTER TABLE purchase_part_info MODIFY COLUMN purchaser int default null comment '采购员'; |