Production lots (serial numbers) can be deleted even if it has stock moves

To replicate, create a new production lot, create and process a reception or delivery using that lot. Then delete the lot. The deletion is successful! and the serial number in product move is removed even if the move state is done and serial number is required for that product!

The main problem is that the default value for 'ondelete' field attribute is 'set null' and it is not defined for 'prodlot_id' field in 'stock.move' model. It should be defined as 'restricted'.

I believe the default value for ondelete should be 'no action' as this is the default behavior of PostgreSQL and every other database I used before. 'cascade' and 'set null' should be always explicitly declared in field definition.

Regards,

Mohammad Alhashash