Jump to content

what is defination of Country ID number from in prestashop 1.7


tesshsu

Recommended Posts

Hi experts

I would like to know as I look up this table : prstshp_country

there's id_country colume

what is this reference numbers from? 

As I look at wiki it is not show the same id country .  https://en.wikipedia.org/wiki/Country_codes:_C

And it is not from premier key, in this case it is possible change the id_country or it will cause the other query retrive data logical error?

 

thank you so much


 

 

Link to comment
Share on other sites

  • 2 years later...

Hi 
This may help 
https://github.com/PrestaShop/PrestaShop/blob/1.7.7.x/install-dev/data/db_structure.sql
Have a look on structure. I noticed I had error on order viewing after change Country settings - this probably change id country i db and old addresses are invalid now.
Reference
https://github.com/PrestaShop/PrestaShop/issues/22386#issuecomment-805655341

id country is from prefix_country table for example ps_country
 

Edited by nikos83 (see edit history)
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...