[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