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.)