http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3445 Summary: action_logs table needs some thought Product: Koha Version: unspecified Platform: PC OS/Version: All Status: NEW Severity: enhancement Priority: P5 Component: Database AssignedTo: galen.charlton@liblime.com ReportedBy: galen.charlton@liblime.com CC: joe.atzberger@liblime.com, colin.campbell@ptfs- europe.com Estimated Hours: 0.0 Change sponsored?: --- More and more code is increasingly depending on queries against the action_logs table, which is not currently well-designed for that purpose. Some changes to that table should be considered, including: [1] Defining separate columns for the specific record type of record ID being logged, e.g., borrowernumber, biblionumber, itemnumber, serialid, etc. [2] Defining additional indexes, include ones on * user * module * action * module, action * object (or the new ID columns specified in [1]) -- 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.