Database differences



  • I made a comparison of the database structure of Prestashop 1.6.1.11 and Thirty Bees. For those interested here a summary of the conclusions:

    • A lot of field size differences. Most interesting is password going from 32 to 60 positions. For the rest mainly id sizes increasing from 10 to 11. Both changes happened also in Prestashop with the change to 1.7.

    • CHARSET changed from utf8 to utf8mb4. This is accompanied by a lot of COLLATE clauses in the database. With COLLATE you can declare that with search or sorting a different charset should be used. Different character sets have different ways to deal with accented characters.

    • quite a few tables were dropped: ps_advice, ps_advice_lang, ps_badge, ps_badge_lang, ps_condition, ps_condition_advice, ps_condition_badge, ps_cronjobs, ps_tab_advice
      All the tables that are dropped in PS 1.7 (ps_compare, ps_compare_product, ps_theme, ps_theme_meta, ps_theme_specific, ps_scene, ps_scene_category, ps_scene_lang, ps_scene_products, ps_scene_shop) are still present in TB.

    • one table got an extra field: display_from_sub in the ps_category table

    • a few tables got extra keys: ps_configuration (name), ps_connections_source (http_referer and request_uri), ps_page_type (name)

    • four new tables: ps_currency_module, ps_module_carrier, ps_page_cache and ps_redis_servers. ps_currency_module is a bit puzzling as there already exists a ps_module_currency table. ps_module_carrier has three fields: id_module, id_shop and id_reference. Missing is an id_carrier: maybe this is id_reference. This table - with the same fields - can also be found in PS 1.7.

    • Prestashop 1.7 has a few new fields in the product tables: isbn, show_condition and state. They are not present in Thirty Bees.



  • Very interesting post! I spend quite a bit of time looking at the PS / 30bz database tables directly while working with the API so it’s interesting to hear about what has changed. I’d upvote you, but the site seems to give a very limited number of upvotes per day, and I’ve run out!


  • administrators

    Thank you very much! The doc page with all the differences is still in the making, though we do have published the migration scripts: https://github.com/thirtybees/migrationscripts/tree/master/16

    Can I copy some of the texts for the documentation?



  • @mdekker said in Database differences:

    Can I copy some of the texts for the documentation?

    Sure, no problem.


Log in to reply
 

Looks like your connection to thirty bees forum was lost, please wait while we try to reconnect.