August 2007 - Koha-devel - lists.koha-community.org

Re: [Koha-devel] Database structure, some cleaning
by Waylon Robertson 10 Aug '07

10 Aug '07

http://katipo.co.nz/gallery/koha2-4/search_ideas_1, right hand search column shows how these tables were to be used... and i did implement usage of these tables, showed Rachel a working version of this idea. Thought i committed it all.... guess not. Found the work though. as i recall, categorytable was a table of 'adult, child' and mediatype like 'cd, dvd, book, pamplet, newspaper', and subcategory like 'fiction, nonfiction, so on. My code included the search within option. should i recheck my work and commit? (to 2.9)? Waylon categorytable : ========== this table is filled by admin/itemtypecategory.pl script, commited by genjimoto on 2005-05-02, but we do nothing with this table. So I propose we remove the table and the script. mediatype : ========== This table is filled by admin/mediatype.pl script, commited by genjimoto on 2005-05-02, but we do nothing with this table. So I propose we remove the table and the script. subcategorytable : =========== this table is filled by admin/itemtypesubcategory.pl script, commited by genjimoto on 2005-05-02, but we do nothing with this table. So I propose we remove the table and the script. Send instant messages to your online friends http://au.messenger.yahoo.com

1 0

A New Reserves System
by Kyle Hall 09 Aug '07

09 Aug '07

Hey all, I've been talking with Kados and Chris about revamping the current Reserves system, which will in the future be known as the Holds system to distinguish it from Academic Reserves. I've set up a page on the Koha Wiki with a list of requirements my librarians have given me, and I would like to get suggestions and input from the rest of the Koha community before I begin this undertaking. The wiki page can be found at http://wiki.koha.org/doku.php?id=en:development:ideas_for_a_new_reserves_sy… Thanks, Kyle -- IT Tech Crawford County Federated Library System

1 0

Database structure, some cleaning
by Paul POULAIN 08 Aug '07

08 Aug '07

Hello world, I have reviewed the DB schema : ***** QUESTIONS ****** accountoffsets : ========= The accountoffsets table seems to be filled sometimes (C4/Circ.pm, line 1399 for example), but I see only some INSERT. It is SELECTEd or UPDATEd nowhere in the code On all my user database, this table is empty. So : can we remove the accountoffsets table & the code refering to it ??? aqorderdelivery : ========== the table is never filled by anyone, but used in acquisition_stats.pl under certain circumstances. I think acquisition_stats is buggy here, and we can remove the table categorytable : ========== this table is filled by admin/itemtypecategory.pl script, commited by genjimoto on 2005-05-02, but we do nothing with this table. So I propose we remove the table and the script. mediatype : ========== This table is filled by admin/mediatype.pl script, commited by genjimoto on 2005-05-02, but we do nothing with this table. So I propose we remove the table and the script. subcategorytable : =========== this table is filled by admin/itemtypesubcategory.pl script, commited by genjimoto on 2005-05-02, but we do nothing with this table. So I propose we remove the table and the script. ******* ALREADY DONE *********** just to let you know, but i'm 99.99% sure of what has to be done, so I did it already. aqorderbreakdown : ============= the branchcode, linenumber and allocation rows are never used. I've removed them from default structure. auth_subfield_table, marc_biblio, marc_blob_subfield, marc_subfield_table, : ============= useless in koha 3.0, will be important for libraries migrating from 22 to 3.0, but not for a fresh install. table removed from default structure. biblioanalysis, uploadedmarc, charges, itemsprice, sessionqueries, users, borexp, borrowers_to_borrowers, catalogueentry, marcrecorddone, websites, z3950queue, z3950results : ========= Tables not used in 3.0, removed from default structure. It can either be a koha 1.0 table that is useless, sometimes since years, or a test table. -- Paul POULAIN et Henri Damien LAURENT Consultants indépendants en logiciels libres et bibliothéconomie (http://www.koha-fr.org) Tel : 04 91 31 45 19

2 1

Fw: Community perl survey
by MJ Ray 06 Aug '07

06 Aug '07

-- forwarded text begins Take part in the 2007 Perl Survey! The Perl Survey is an attempt to capture a picture of the Perl community in all its diversity. No matter what sort of Perl programmer you are, we'd love to hear from you. The survey can be found at: http://perlsurvey.org It only takes about 5 minutes to complete. The survey will be open until September 30th, 2007. After that, we'll be reporting on the results and making the data freely available. Please feel free to forward this email to anyone other Perl programmers you know. Thanks for your help! Yours, Kirrily "Skud" Robert The Perl Survey info(a)perlsurvey.org

1 0