[Bug 3168] New: `accountlines.accountno` is SMALL-INT, and maxs too quickly
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@liblime.com ReportedBy: mason.loves.sushi@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.
http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3168 Mason James <mason.loves.sushi@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |INVALID --- Comment #1 from Mason James <mason.loves.sushi@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.
participants (1)
-
bugzilla-daemon＠liblime.com