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

Joe Atzberger ohiocore at gmail.com
Tue Apr 28 02:01:00 NZST 2009


This sounds like a bad idea, and suggests that you are not importing your
data in a safe way.  The biblionumber is Koha's *internal* key for the
record.

What data do you need 100 digits for?  I don't expect that you old system
would require it for its DB key.  Do you really plan to import
1,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,
000,000,000,000 records?

I'm guessing no.

-- 
Joe Atzberger
LibLime - Open Source Library Solutions



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?
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20090427/a847fd53/attachment.htm 


More information about the Koha mailing list