From 5a087678da7e04678bdc310a9b8c4946183cfec1 Mon Sep 17 00:00:00 2001 From: Colin Campbell Date: Mon, 8 Feb 2010 16:33:55 +0000 Subject: [PATCH] Bug 4133 Amend kohastructure to reflect earlier patch updatedatebase is now setting aqorders.quantityreceived to NOT NULL kohastructure needs bringing into line Signed-off-by: Galen Charlton --- installer/data/mysql/kohastructure.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index b700a17846..b530724e94 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -2492,7 +2492,7 @@ CREATE TABLE `aqorders` ( `booksellerinvoicenumber` mediumtext, `freight` decimal(28,6) default NULL, `unitprice` decimal(28,6) default NULL, - `quantityreceived` smallint(6) default NULL, + `quantityreceived` smallint(6) NOT NULL default 0, `cancelledby` varchar(10) default NULL, `datecancellationprinted` date default NULL, `notes` mediumtext, -- 2.39.2