Keyword

Changing the MySQL-Type of the ID-field

  • xaoc
  • xaoc's Avatar Topic Author
  • Offline
  • Junior Member
More
11 years 3 weeks ago #118132 by xaoc
Hi to all!

For a certain purpose i need to change the length of the K2's ID from 11 to 13 signs. For making the data field containing such length i must change the type from INT to BIGINT. What do you think, can it cause any problem or complication? Or, if not with the K2 core, so maybe with any K2 extension?

I just wonder too, why currently the K2's ID is 11 signs long - current MySQL type of this field can be only 10 signs long

My purpose for this is: i build a book database and want to have as the book ID the ISBN number. At the same time i don't want put the ISBN number into an extra field cause the storing art of the extra field's values.

Thanks for any info & advice
xaoc

Please Log in or Create an account to join the conversation.


Powered by Kunena Forum