[Koha-patches] [PATCH] Bug 4133 Amend kohastructure to reflect earlier patch

Colin Campbell colin.campbell at ptfs-europe.com
Mon Feb 8 17:33:55 CET 2010


updatedatebase is now setting aqorders.quantityreceived to NOT NULL
kohastructure needs bringing into line
---
 installer/data/mysql/kohastructure.sql |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
index b700a17..b530724 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,
-- 
1.6.6




More information about the Koha-patches mailing list