User manual

Customizing Koha Software
Understanding Koha's database
We also need to understand how Koha's database is organized. This will help us
make software changes that require access to the database or that require updates
to be made to it. In this section we take a quick look at how to browse the database;
we also list some of the important tables.
Browsing Koha's database
Let's start by logging in to MySQL. First, we use the
use
command to switch to
Koha's database:
mysql> use koha
Database changed
We use the
show tables
command to view a listing of all tables in the database:
mysql> show tables;
Tables_ in_koha_testing
accountlines
accountoffsets
action logs
alert
agbasket
agbookfund
agbooksellers
1
To view how a particular table organized, we use the
describe
command:
mysql> describe borrowers;
Field
1
Type
1
Null 1
Key 1
Default
1
Extra
borrowernumber
int(11) I
NO
I
PRI
NULL
I
auto_
increment
1
[ 230 ]