From 84b5174ebab3ef9213a8e527bb0d235f70aaeca5 Mon Sep 17 00:00:00 2001 From: slef Date: Wed, 12 Nov 2003 16:07:13 +0000 Subject: [PATCH] update cardnumber to 16 digits --- misc/koha.mysql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/misc/koha.mysql b/misc/koha.mysql index f3c4bd263b..c0df39006c 100644 --- a/misc/koha.mysql +++ b/misc/koha.mysql @@ -270,7 +270,7 @@ CREATE TABLE `borexp` ( CREATE TABLE `borrowers` ( `borrowernumber` int(11) NOT NULL default '0', - `cardnumber` varchar(9) NOT NULL default '', + `cardnumber` varchar(16) NOT NULL default '', `surname` text NOT NULL, `firstname` text NOT NULL, `title` text, @@ -311,7 +311,7 @@ CREATE TABLE `borrowers` ( `preferredcont` char(1) default NULL, `physstreet` varchar(100) default NULL, KEY `borrowernumber` (`borrowernumber`), - KEY `cardnumber` (`cardnumber`) + KEY `cardnumber` (`cardnumber`) UNIQUE ); # -- 2.39.2