[Koha-bugs] [Bug 3168] New: `accountlines.accountno` is SMALL-INT, and maxs too quickly

[bugzilla-daemon at liblime.com]

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

           Summary: `accountlines.accountno` is SMALL-INT, and maxs too
                    quickly
           Product: Koha
           Version: rel_3_0
          Platform: PC
        OS/Version: All
            Status: NEW
          Severity: normal
          Priority: P5
         Component: Database
        AssignedTo: galen.charlton at liblime.com
        ReportedBy: mason.loves.sushi at gmail.com
   Estimated Hours: 0.0


Can we bump this to an INT folks?

for example, we have a DB with 1.2 million accountline records
a smallint handles just 32767 records :/

i'll make a patch for this, if people agree with the change...

any thoughts??

------------------------------------
CREATE TABLE `accountlines` (                                                   
  `borrowernumber` int(11) NOT NULL default 0,                                  
  `accountno` smallint(6) NOT NULL default 0, <<< OOPS!!
  `itemnumber` int(11) default NULL,


-- 
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.