Bug 36667 - aqorders.quantity should be NOT NULL
Summary: aqorders.quantity should be NOT NULL
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: Database (show other bugs)
Version: Main
Hardware: All All
: P5 - low enhancement
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-04-22 12:49 UTC by Marcel de Rooy
Modified: 2024-04-22 12:49 UTC (History)
0 users

See Also:
GIT URL:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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.)