5 lines
324 B
MySQL
5 lines
324 B
MySQL
|
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 '采购员';
|