[Koha-bugs] [Bug 3445] New: action_logs table needs some thought

[bugzilla-daemon at liblime.com]

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 at liblime.com
        ReportedBy: galen.charlton at liblime.com
                CC: joe.atzberger at liblime.com, colin.campbell at 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.