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

[bugzilla-daemon at kohaorg.ec2.liblime.com]

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

           Summary: Field Sizes Inconsistent
           Product: Koha
           Version: HEAD
          Platform: PC
        OS/Version: All
            Status: NEW
          Severity: trivial
          Priority: P5
         Component: Database
        AssignedTo: gmcharlt at gmail.com
        ReportedBy: nengard at gmail.com
   Estimated Hours: 0.0
 Change sponsored?: ---


When looking at the borrowers table the field sizes are inconsistent.  All
address fields should be the same and all city/state fields should be the same,
etc etc.

`address` mediumtext NOT NULL,
  `address2` text,
  `city` mediumtext NOT NULL,

`B_address` varchar(100) default NULL,
  `B_address2` text default NULL,
  `B_city` mediumtext,


`altcontactaddress1` varchar(255) default NULL,
  `altcontactaddress2` varchar(255) default NULL,
  `altcontactaddress3` varchar(255) default NULL,

I recommend mediumtext for them all.


-- 
Configure bugmail: http://bugs.koha.org/cgi-bin/bugzilla3/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are watching all bug changes.