[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