Shopware 6.2.3 vs 6.3.5.4 — Database Changes

Base Shopware 6.2.3 → Target Shopware 6.3.5.4

Tables Added

Tables Removed

Tables Changed

156

Unchanged

Tables added in 6.3.5.4

app 18 columns
app_action_button 9 columns
app_action_button_translation 5 columns
app_template 7 columns
app_translation 7 columns
customer_group_registration_sales_channels 3 columns
customer_wishlist 6 columns
customer_wishlist_product 7 columns
event_action_rule 2 columns
event_action_sales_channel 2 columns
integration_role 2 columns
landing_page 6 columns
landing_page_sales_channel 3 columns
landing_page_tag 3 columns
landing_page_translation 11 columns
product_custom_field_set 3 columns
product_feature_set 4 columns
product_feature_set_translation 6 columns
product_search_config 7 columns
product_search_config_field 9 columns
product_sorting 8 columns
product_sorting_translation 5 columns
user_config 6 columns
webhook 7 columns

Tables removed in 6.3.5.4

acl_resource had 5 columns
google_shopping_account had 8 columns
google_shopping_merchant_account had 6 columns

Tables changed 61 column changes in total

acl_role +2

description added · longtext

privileges added · longtext

category +2 1 index change

product_stream_id added · binary(16)

product_assignment_type added · varchar(32)

country +3

company_tax_free added · tinyint(1)

check_vat_id_pattern added · tinyint(1)

vat_id_pattern added · varchar(255)

custom_field_set +3 1 index change

app_id added · binary(16)

position added · int(11)

global added · tinyint(1)

customer +4 2 index changes

requested_customer_group_id added · binary(16)

vat_ids added · longtext

tag_ids added · longtext

bound_sales_channel_id added · binary(16)

customer_group +1

registration_active added · tinyint(1)

customer_group_translation +4

registration_title added · varchar(255)

registration_introduction added · longtext

registration_only_company_registration added · tinyint(1)

registration_seo_meta_description added · longtext

customer_recovery ~2 1 index change

id Key: (none) → PRI

customer_id Key: PRI → UNI

document_base_config_sales_channel ~1 1 index change

id Key: (none) → PRI

event_action +2

title added · varchar(500)

active added · tinyint(1)

integration +1

admin added · tinyint(1)

log_entry ~1 1 index change

id Key: (none) → PRI

mail_template_sales_channel ~1 1 index change

id Key: (none) → PRI

order +3 2 index changes

rule_ids added · longtext

created_by_id added · binary(16)

updated_by_id added · binary(16)

product +10 ~1 3 index changes

cms_page_id added · binary(16)

product_feature_set_id added · binary(16)

sales added · int(11)

purchase_prices added · longtext

featureSet added · binary(16)

customFieldSets added · binary(16)

custom_field_set_selection_active added · tinyint(1)

canonical_product_id added · binary(16)

canonicalProduct added · binary(16)

cmsPage added · binary(16)

active Type: tinyint(1) unsigned → tinyint(3) unsigned · Nullable: false → true · Default: 1 → null

product_export +1

paused_schedule added · tinyint(1)

product_translation +1

custom_search_keywords added · longtext

promotion ~2

max_redemptions_global Nullable: false → true · Default: 1 → null

max_redemptions_per_customer Nullable: false → true · Default: 1 → null

promotion_discount +1

picker_key added · varchar(255)

sales_channel +1

tax_calculation_type added · varchar(50)

sales_channel_analytics +1

anonymize_ip added · tinyint(1)

sales_channel_api_context +3 2 index changes

sales_channel_id added · binary(16)

customer_id added · binary(16)

updated_at added · datetime

seo_url_template ~1

template Nullable: false → true

shipping_method +2 1 index change

tax_type added · varchar(50)

tax_id added · binary(16)

shipping_method_price −2 1 index change

currency_id removed

price removed

theme ~1 1 index change

preview_media_id Key: (none) → MUL

user +2

title added · varchar(255)

last_updated_password_at added · datetime(3)

user_recovery ~2 1 index change

id Key: (none) → PRI

user_id Key: PRI → UNI

Need a different pair? Use the interactive comparison tool.