Bug 36667

Summary: aqorders.quantity should be NOT NULL
Product: Koha Reporter: Marcel de Rooy <m.de.rooy>
Component: DatabaseAssignee: Bugs List <koha-bugs>
Status: NEW --- QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low    
Version: Main   
Hardware: All   
OS: All   
GIT URL: Change sponsored?: ---
Patch complexity: --- Documentation contact:
Documentation submission: Text to go in the release notes:
Version(s) released in:
Circulation function:

Description Marcel de Rooy 2024-04-22 12:49:12 UTC
From kohastructure:

`quantity` smallint(6) DEFAULT NULL COMMENT 'the quantity ordered',
`quantityreceived` smallint(6) NOT NULL DEFAULT 0 COMMENT 'the quantity that have been received so far',

=> We could do NOT NULL DEFAULT 0 for quantity (same as received) but should we even allow 0 at all ? Note however that I found an acq order with quantity==0 in our data. (Older bugs etc.)