PythonQ 248-8XX Manual de usuario Pagina 245

  • Descarga
  • Añadir a mis manuales
  • Imprimir
  • Pagina
    / 299
  • Tabla de contenidos
  • SOLUCIÓN DE PROBLEMAS
  • MARCADORES
  • Valorado. / 5. Basado en revisión del cliente
Vista de pagina 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 ]
Vista de pagina 244
1 2 ... 240 241 242 243 244 245 246 247 248 249 250 ... 298 299

Comentarios a estos manuales

Sin comentarios