id database column type

[mferrari]

Hi, trying to integrate prestashop with our system we have the problem that our id's on manufactures, products, categories are varchar, exists the possibility to change columns type to varchar or it will cause a corruption on the prestashop core?

 

Best Regards

[Rubens Cury]

Hi mferrari,

 

First of all, can I admit your system tables which are have varchar IDs instead of integer, can contains any text ID record? If your answer is No, please think better about your own database architecture before to consider change anything on Prestashop database.

 

Nevertheless, tables architecture are not independent in Prestashop, they all work together with their respetives classes that are have every single property defined by a name and a type.

 

So... It's up to you. My personal opinion, always try to follow the right patterns. Please consider that yours may not right.

 

Hope it helps,

Rubens Cury