[Koha-bugs] [Bug 3777] Field Sizes Inconsistent

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3777

--- Comment #5 from Katrin Fischer <katrin.fischer at 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.