From f08492ae9086891675a6418cd781943d1521246a Mon Sep 17 00:00:00 2001 From: Mason James Date: Thu, 8 Nov 2007 00:42:36 -0600 Subject: [PATCH] changing missed branchcode columns from varchar(4) to 10 Signed-off-by: Chris Cormack Signed-off-by: Joshua Ferraro --- installer/kohastructure.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/installer/kohastructure.sql b/installer/kohastructure.sql index 282977318e..2f2c6422f1 100644 --- a/installer/kohastructure.sql +++ b/installer/kohastructure.sql @@ -791,7 +791,7 @@ CREATE TABLE `deleteditems` ( `barcode` varchar(20) default NULL, `dateaccessioned` date default NULL, `booksellerid` varchar(10) default NULL, - `homebranch` varchar(4) default NULL, + `homebranch` varchar(10) default NULL, `price` decimal(8,2) default NULL, `replacementprice` decimal(8,2) default NULL, `replacementpricedate` date default NULL, @@ -1002,7 +1002,7 @@ CREATE TABLE `items` ( `barcode` varchar(20) default NULL, `dateaccessioned` date default NULL, `booksellerid` varchar(10) default NULL, - `homebranch` varchar(4) default NULL, + `homebranch` varchar(10) default NULL, `price` decimal(8,2) default NULL, `replacementprice` decimal(8,2) default NULL, `replacementpricedate` date default NULL, @@ -1544,7 +1544,7 @@ CREATE TABLE `subscription` ( `callnumber` text, `branchcode` varchar(10) NOT NULL default '', `hemisphere` tinyint(3) default 0, - `lastbranch` varchar(4), + `lastbranch` varchar(10), PRIMARY KEY (`subscriptionid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- 2.39.5