Prestashop 1.6 to 1.7 database scheme difference

[Gramzivi]

I want to upgrade my shop from 1.6 to 1.7

 

What are the major differences between database schemes in 1.6 and 1.7 ?

 

I saw that mostly tables are same, but is there some new features in database that 1.6 don't have, or it's done on different way ?

[bellini13]

I'm sure that this analysis has not been documented anywhere, so I think the quickest way to get your answer is to..

 

1) Install PS v1.7

2) Install PS v1.6.x

3) Export both database schema (not the data) to separate sql files

4) Use a difference program to compare the 2 sql files to each other, which will highlight the differences for you

[tuk66]

All changes should be in the \install\upgrade\sql\install\upgrade\sql\1.7.0.0.sql file (PS 1.7).

[bellini13]

only if you trust the upgrade process

[tuk66]

We must mention that all

/* PHP:... */;

inserts in that file are also very important. They work on the database as well. So not all database changes are done by SQL queries.

[japutko]

Just for the sake of saving time for future readers I attached both schemas to this topic prestashop-1.6-schema.txt prestashop-1.7-schema.txt. You can compare them in a tool such as https://www.diffchecker.com to see for yourself.

 

Cheers.

[Nikolai]

When we did update of prestashop import module ( http://mydataprovider.com/prestashop ) we found only minor changes (for products populating)

so there is no big changes in this area.