[Koha] Modifying Field's Data Type In the Koha Database

Galen Charlton galen.charlton at liblime.com
Tue Apr 28 01:57:33 NZST 2009


Hi,

2009/4/26 Melanie Saldua <reilied00 at gmail.com>:
> Hello! I'm a new koha user and I'm trying to migrate my existing database to
> the koha database. I was wondering if it is possible to change the data type
> of the fields in the koha database? I need to modify biblionumber's data
> type from int(11) to bigint(100). Is there a faster way to do it than modify
> every table?

No, you'll have to alter each table containing a reference to
biblionumber.  Out of curiosity, why do you need to make the display
width so wide?

Regards,

Galen
-- 
Galen Charlton
VP, Research & Development, LibLime
galen.charlton at liblime.com
p: 1-888-564-2457 x709
skype: gmcharlt


More information about the Koha mailing list