http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3777 --- Comment #5 from Katrin Fischer <katrin.fischer@bsz-bw.de> 2010-11-30 21:17:10 UTC --- Started work on database changes, will all suggested changes made table borrowers will look like this: DROP TABLE IF EXISTS `borrowers`; CREATE TABLE `borrowers` ( `borrowernumber` int(11) NOT NULL auto_increment, `cardnumber` varchar(16) default NULL, `surname` text default NULL, `firstname` text default NULL, `title` text default NULL, `othernames` text default NULL, `initials` text default NULL, `streetnumber` varchar(10) default NULL, `streettype` varchar(50) default NULL, `address` text default NULL, `address2` text default NULL, `city` text default NULL, `zipcode` varchar(50) default NULL, `country` text default NULL, `email` text default NULL, `phone` text default NULL, `mobile` text default NULL, `fax` text default NULL, `emailpro` text default NULL, `phonepro` text default NULL, `B_streetnumber` varchar(10) default NULL, `B_streettype` varchar(50) default NULL, `B_address` text default NULL, `B_address2` text default NULL, `B_city` text default NULL, `B_zipcode` varchar(50) default NULL, `B_country` text default NULL, `B_email` text default NULL, `B_phone` text default NULL, `dateofbirth` date default NULL, `branchcode` varchar(10) NOT NULL default '', `categorycode` varchar(10) NOT NULL default '', `dateenrolled` date default NULL, `dateexpiry` date default NULL, `gonenoaddress` tinyint(1) default NULL, `lost` tinyint(1) default NULL, `debarred` tinyint(1) default NULL, `contactname` text default NULL, `contactfirstname` text default NULL, `contacttitle` text default NULL, `guarantorid` int(11) default NULL, `borrowernotes` text default NULL, `relationship` varchar(100) default NULL, `ethnicity` varchar(50) default NULL, `ethnotes` text default NULL, `sex` varchar(1) default NULL, `password` varchar(30) default NULL, `flags` int(11) default NULL, `userid` varchar(50) default NULL, `opacnote` text default NULL, `contactnote` text default NULL, `sort1` varchar(80) default NULL, `sort2` varchar(80) default NULL, `altcontactfirstname` text default NULL, `altcontactsurname` text default NULL, `altcontactaddress1` text default NULL, `altcontactaddress2` text default NULL, `altcontactaddress3` text default NULL, `altcontactzipcode` varchar(50) default NULL, `altcontactcountry` text default NULL, `altcontactphone` text default NULL, `smsalertnumber` text default NULL, `privacy` integer(11) DEFAULT '1' NOT NULL, UNIQUE KEY `cardnumber` (`cardnumber`), PRIMARY KEY `borrowernumber` (`borrowernumber`), KEY `categorycode` (`categorycode`), KEY `branchcode` (`branchcode`), KEY `userid` (`userid`), KEY `guarantorid` (`guarantorid`), CONSTRAINT `borrowers_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`), CONSTRAINT `borrowers_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; Please let me know if you see any problem with that or have suggestions for further improvement. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA contact for the bug.