Shopware 5.6.10 vs 5.7.19 — Database Changes

Base Shopware 5.6.10 → Target Shopware 5.7.19

Tables Added

Tables Removed

Tables Changed

234

Unchanged

Tables added in 5.7.19

s_sitemap_custom 6 columns
s_sitemap_exclude 4 columns

Tables changed 25 column changes in total

s_article_configurator_template_prices +1

regulation_price added · double

s_articles ~1

keywords Type: varchar(255) → mediumtext

s_articles_avoid_customergroups 2 index changes

s_articles_prices +1

regulation_price added · double

s_articles_supplier ~2

meta_keywords Type: varchar(255) → mediumtext

changed Default: 2021-05-06 08:34:02 → 2019-12-06 10:19:52

s_blog ~1

meta_keywords Type: varchar(255) → mediumtext

s_campaigns_logs ~1

datum Nullable: false → true · Default: 0000-00-00 00:00:00 → null

s_categories_avoid_customergroups 2 index changes

s_cms_static ~2

meta_keywords Type: varchar(255) → mediumtext

changed Default: 2021-05-06 08:34:02 → 2019-12-06 10:19:52

s_cms_support ~1

meta_keywords Type: varchar(255) → mediumtext

s_core_auth ~1

lastlogin Nullable: false → true · Default: 0000-00-00 00:00:00 → null

s_customer_streams_mapping 2 index changes

s_emarketing_banners ~2

valid_from Default: 0000-00-00 00:00:00 → null

valid_to Default: 0000-00-00 00:00:00 → null

s_emarketing_lastarticles ~1

time Nullable: false → true · Default: 0000-00-00 00:00:00 → null

s_emarketing_tellafriend ~1

datum Nullable: false → true · Default: 0000-00-00 → null

s_emotion ~1

seo_keywords Type: varchar(255) → mediumtext

s_library_component ~1 1 index change

name Key: (none) → MUL

s_order_basket ~1

datum Nullable: false → true · Default: 0000-00-00 00:00:00 → null

s_order_comparisons ~1

datum Nullable: false → true · Default: 0000-00-00 00:00:00 → null

s_order_notes ~1

datum Nullable: false → true · Default: 0000-00-00 00:00:00 → null

s_statistics_pool ~1

datum Nullable: false → true · Default: 0000-00-00 → null

s_statistics_referer ~1

datum Nullable: false → true · Default: 0000-00-00 → null

s_statistics_visitors ~1

datum Nullable: false → true · Default: 0000-00-00 → null

s_user ~2

firstlogin Nullable: false → true · Default: 0000-00-00 → null

lastlogin Nullable: false → true · Default: 0000-00-00 00:00:00 → null

Need a different pair? Use the interactive comparison tool.