[Koha-cvs] CVS: koha/misc koha.mysql,1.4,1.5

[MJ Ray]

Update of /cvsroot/koha/koha/misc
In directory sc8-pr-cvs1:/tmp/cvs-serv3482

Modified Files:
        koha.mysql 
Log Message:
update cardnumber to 16 digits

Index: koha.mysql
===================================================================
RCS file: /cvsroot/koha/koha/misc/koha.mysql,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -r1.4 -r1.5
*** koha.mysql  9 Jul 2003 16:19:19 -0000       1.4
--- koha.mysql  12 Nov 2003 16:07:13 -0000      1.5
***************
*** 271,275 ****
  CREATE TABLE `borrowers` (
    `borrowernumber` int(11) NOT NULL default '0',
!   `cardnumber` varchar(9) NOT NULL default '',
    `surname` text NOT NULL,
    `firstname` text NOT NULL,
--- 271,275 ----
  CREATE TABLE `borrowers` (
    `borrowernumber` int(11) NOT NULL default '0',
!   `cardnumber` varchar(16) NOT NULL default '',
    `surname` text NOT NULL,
    `firstname` text NOT NULL,
***************
*** 312,316 ****
    `physstreet` varchar(100) default NULL,
    KEY `borrowernumber` (`borrowernumber`),
!   KEY `cardnumber` (`cardnumber`)
  );
  
--- 312,316 ----
    `physstreet` varchar(100) default NULL,
    KEY `borrowernumber` (`borrowernumber`),
!   KEY `cardnumber` (`cardnumber`) UNIQUE
  );