PythonQ 248-8XX Instrukcja Użytkownika Strona 245

  • Pobierz
  • Dodaj do moich podręczników
  • Drukuj
Przeglądanie stron 244
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 ]
Przeglądanie stron 244
1 2 ... 240 241 242 243 244 245 246 247 248 249 250 ... 298 299

Komentarze do niniejszej Instrukcji

Brak uwag