PythonQ 248-8XX Manuel d'utilisateur Page 245

  • Télécharger
  • Ajouter à mon manuel
  • Imprimer
  • Page
    / 299
  • Table des matières
  • DEPANNAGE
  • MARQUE LIVRES
  • Noté. / 5. Basé sur avis des utilisateurs
Vue de la page 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 ]
Vue de la page 244
1 2 ... 240 241 242 243 244 245 246 247 248 249 250 ... 298 299

Commentaires sur ces manuels

Pas de commentaire