how to administer some tables + (small) bug in distro
I've been using MySql-Front to manage data on MySQL from windows. It's very fast and very useful and of course freeware the homepage is at : http://www.mysqlfront.de/
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 Second bunch of questions : *what should the systemprefs table containt? It's empty *what is the user table used for/where ? *Is there somwhere a drawed schema of the DB (dependencies between tables ?)
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 ;-(((
Thanks -- Paul
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Zeki Celikbas
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@katipo.co.nz www.katipo.co.nz
participants (3)
-
Chris Cormack -
paul POULAIN -
Zeki Celikbas