Modifying Field's Data Type In the Koha Database
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?
Hi, 2009/4/26 Melanie Saldua <reilied00@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@liblime.com p: 1-888-564-2457 x709 skype: gmcharlt
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@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?
participants (3)
-
Galen Charlton -
Joe Atzberger -
Melanie Saldua