[Koha] how to administer some tables + (small) bug in distro

[Chris Cormack]

On Sat, 2002-02-02 at 03:19, paul POULAIN wrote: I begin to play a
little  deeper with koha, and would like to know if there is a web
interface (other than phpMyAdmin !) to administer the following tables :

        * aqbookfound
        * adbudget
        * branchcategories
        * branches
        * categories
        * currency
        * itemtypes
        * printers
        * stopwords
        * systempreferences
        * users

Nope not at the moment, its definitely something that needs to be done
tho. There isnt really a system librarian interface to koha. (Apart from
mysql on the command line (my method) or phpMyAdmin).
Any volunteers to work on an interface to the tables gratefully accepted
:-)

Second bunch of questions : 

        * what should the systemprefs table containt? It's empty

I think the plan for that was that it would contain things like whether
koha uses the fullfledged acquisitions system, or the simple system.
What language, etc.
IIRC its now be superseded by /etc/koha.conf

        * what is the user table used for/where ?

We use the users table for doing authentication with Apache::AuthDBI, so
it contains the users and passwords for valid users to connect to the
librarian part of koha.

        * Is there somwhere a drawed schema of the DB (dependencies
          between tables ?)
    
I did do some drawings a while back, ill hunt them up and post a link to
them for you.

Last, a small bug in the sample database : it does'nt contain the
systempref table.
If you create the DB trough koha.mysql, it's created, but empty ;-(((

Ahh right, ill work on fixing that up

Thanks for your input

Chris

-- 
Chris Cormack                                               Programmer
025 500 789                                  Katipo Communications Ltd
chris at katipo.co.nz                                    www.katipo.co.nz