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.