[Koha-bugs] [Bug 2606] New: reduce number of fields in the offline circulation database in order to reduce size

bugzilla-daemon at pippin.metavore.com bugzilla-daemon at pippin.metavore.com
Mon Sep 15 16:47:42 CEST 2008


http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=2606

           Summary: reduce number of fields in the offline circulation
                    database in order to reduce size
           Product: Koha
           Version: unspecified
          Platform: PC
        OS/Version: All
            Status: NEW
          Severity: normal
          Priority: P3
         Component: Circulation
        AssignedTo: Andrew.moore at liblime.com
        ReportedBy: Andrew.moore at liblime.com
         QAContact: koha-bugs at lists.koha.org


Galen pointed out that the borrowers.db file generated by
misc/cronjobs/create_koc_db.pl script has superfluous data in it that is
unnecessarily increasing its size. Kyle believes that only these fields are
truly necessary:

>From the borrowers table:
borrowernumber
cardnumber
surname
firstname
streetaddress
city
state
phone
dateofbirth

>From the issues table:
borrowernumber
date_due
itemcallnumber
title
itemtype

So, we can eliminate the other fields and reduce the size of this file quite a
bit.




------- You are receiving this mail because: -------
You are the QA contact for the bug, or are watching the QA contact.



More information about the Koha-bugs mailing list