[Koha-bugs] [Bug 3168] `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


Mason James <mason.loves.sushi at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|                            |INVALID




--- Comment #1 from Mason James <mason.loves.sushi at gmail.com>  2009-05-13 10:38:46 ---
(In reply to comment #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,
> 

this isnt a bug, 

'accountno' column is incremented for *each* borrower - closing


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