Shopware 6.3.5.4 vs 6.4.20.2 — Database Changes

Base Shopware 6.3.5.4 → Target Shopware 6.4.20.2

Tables Added

Tables Removed

116

Tables Changed

Unchanged

Tables added in 6.4.20.2

admin_elasticsearch_index_task 5 columns
app_administration_snippet 6 columns
app_cms_block 8 columns
app_cms_block_translation 5 columns
app_flow_action 14 columns
app_flow_action_translation 8 columns
app_payment_method 13 columns
app_script_condition 10 columns
app_script_condition_translation 5 columns
currency_country_rounding 7 columns
custom_entity 6 columns
flow 11 columns
flow_sequence 13 columns
flow_template 5 columns
increment 6 columns
notification 9 columns
order_line_item_download 10 columns
order_transaction_capture 9 columns
order_transaction_capture_refund 9 columns
order_transaction_capture_refund_position 11 columns
payment_token 2 columns
product_download 9 columns
product_stream_mapping 3 columns
rule_tag 2 columns
sales_channel_rule 2 columns
script 8 columns
theme_child 2 columns
webhook_event_log 17 columns

Tables removed in 6.4.20.2

swag_paypal_pos_sales_channel had 10 columns
swag_paypal_pos_sales_channel_inventory had 5 columns
swag_paypal_pos_sales_channel_media had 5 columns
swag_paypal_pos_sales_channel_product had 6 columns
swag_paypal_pos_sales_channel_run had 7 columns
swag_paypal_pos_sales_channel_run_log had 8 columns

Tables changed 262 column changes in total

acl_role +1 ~1

deleted_at added · datetime(3)

privileges Type: longtext → json

app +5 ~2

base_app_url added · varchar(1024)

allow_disable added · tinyint(1)

main_module added · json

allowed_hosts added · json

template_load_priority added · int(11)

modules Type: longtext → json

cookies Type: longtext → json

app_translation +1

custom_fields added · json

cart +5 −1 ~1 2 index changes

rule_ids added · json

updated_at added · datetime(3)

auto_increment added · bigint(20)

compressed added · tinyint(1)

payload added · longblob

cart removed

created_at Key: (none) → MUL

category +1

cms_page_version_id added · binary(16)

category_translation +3 ~3

internal_link added · binary(16)

link_new_tab added · tinyint(4)

link_type added · varchar(255)

breadcrumb Type: longtext → json

custom_fields Type: longtext → json

slot_config Type: longtext → json

cms_block +3 ~1

version_id added · binary(16)

cms_section_version_id added · binary(16)

visibility added · json

custom_fields Type: longtext → json

cms_page +2 ~1

version_id added · binary(16)

css_class added · varchar(255)

config Type: longtext → json

cms_page_translation +1 ~2 1 index change

cms_page_version_id added · binary(16)

name Nullable: false → true

custom_fields Type: longtext → json

cms_section +3 ~1

version_id added · binary(16)

cms_page_version_id added · binary(16)

visibility added · json

custom_fields Type: longtext → json

cms_slot +1

cms_block_version_id added · binary(16)

cms_slot_translation ~2

config Type: longtext → json

custom_fields Type: longtext → json

country +8

vat_id_required added · tinyint(1)

customer_tax added · json

company_tax added · json

advanced_postal_code_pattern added · varchar(255)

check_advanced_postal_code_pattern added · tinyint(1)

check_postal_code_pattern added · tinyint(1)

default_postal_code_pattern added · varchar(1024)

postal_code_required added · tinyint(1)

country_state_translation ~1

custom_fields Type: longtext → json

country_translation +1 ~1

address_format added · json

custom_fields Type: longtext → json

currency +3 −1

item_rounding added · json

total_rounding added · json

tax_free_from added · double

decimal_precision removed

currency_translation ~1

custom_fields Type: longtext → json

custom_field +1 ~1

allow_customer_write added · tinyint(4)

config Type: longtext → json

custom_field_set ~1

config Type: longtext → json

customer +7 −3 ~5 3 index changes

double_opt_in_registration added · tinyint(1)

double_opt_in_email_sent_date added · datetime(3)

double_opt_in_confirm_date added · datetime(3)

newsletter_sales_channel_ids added · json

order_total_amount added · double

created_by_id added · binary(16)

updated_by_id added · binary(16)

doubleOptInRegistration removed

doubleOptInEmailSentDate removed

doubleOptInConfirmDate removed

salutation_id Nullable: false → true

email Key: (none) → MUL

vat_ids Type: longtext → json

custom_fields Type: longtext → json

tag_ids Type: longtext → json

customer_address ~4

department Type: varchar(35) → varchar(255)

salutation_id Nullable: false → true

zipcode Nullable: false → true

custom_fields Type: longtext → json

customer_group_translation ~1

custom_fields Type: longtext → json

customer_wishlist ~1

custom_fields Type: longtext → json

customer_wishlist_product −1

custom_fields removed

delivery_time_translation ~1

custom_fields Type: longtext → json

document ~2

config Type: longtext → json

custom_fields Type: longtext → json

document_base_config +1 ~1

custom_fields added · json

config Type: longtext → json

document_type_translation ~1

custom_fields Type: longtext → json

enqueue ~1 1 index change

delivery_id Key: (none) → MUL

event_action +2 ~1

custom_fields added · json

migrated_flow_id added · binary(16)

config Type: longtext → json

import_export_file ~1

access_token Nullable: false → true

import_export_log +1 ~1

result added · json

config Type: longtext → json

import_export_profile +2 ~1

type added · varchar(255)

update_by added · json

config Type: longtext → json

integration +1 ~1

deleted_at added · datetime(3)

custom_fields Type: longtext → json

landing_page +1

cms_page_version_id added · binary(16)

landing_page_translation +1 ~2

url added · varchar(255)

custom_fields Type: longtext → json

slot_config Type: longtext → json

language ~1

custom_fields Type: longtext → json

locale_translation ~1

custom_fields Type: longtext → json

log_entry ~4 1 index change

message Type: varchar(255) → longtext

context Type: longtext → json

extra Type: longtext → json

created_at Key: (none) → MUL

mail_template_translation ~1

custom_fields Type: longtext → json

mail_template_type +1

template_data added · longtext

mail_template_type_translation ~1

custom_fields Type: longtext → json

media ~1

meta_data Type: longtext → json

media_default_folder ~2

association_fields Type: longtext → json

custom_fields Type: longtext → json

media_folder +1 ~1

path added · longtext

custom_fields Type: longtext → json

media_folder_configuration ~1

custom_fields Type: longtext → json

media_thumbnail ~1

custom_fields Type: longtext → json

media_thumbnail_size ~1

custom_fields Type: longtext → json

media_translation ~1

custom_fields Type: longtext → json

newsletter_recipient ~2 1 index change

email Key: (none) → MUL

custom_fields Type: longtext → json

number_range_translation ~1

custom_fields Type: longtext → json

number_range_type_translation ~1

custom_fields Type: longtext → json

order +2 ~5 1 index change

item_rounding added · json

total_rounding added · json

price Type: longtext → json

order_date Key: (none) → MUL

shipping_costs Type: longtext → json

custom_fields Type: longtext → json

rule_ids Type: longtext → json

order_address ~3

department Type: varchar(35) → varchar(255)

salutation_id Nullable: false → true

custom_fields Type: longtext → json

order_customer +1 ~2

vat_ids added · json

salutation_id Nullable: false → true

custom_fields Type: longtext → json

order_delivery ~3

tracking_codes Type: longtext → json

shipping_costs Type: longtext → json

custom_fields Type: longtext → json

order_delivery_position ~2

price Type: longtext → json

custom_fields Type: longtext → json

order_line_item +2 ~4 1 index change

promotion_id added · binary(16)

states added · json

payload Type: longtext → json

price_definition Type: longtext → json

price Type: longtext → json

custom_fields Type: longtext → json

order_transaction ~2

amount Type: longtext → json

custom_fields Type: longtext → json

payment_method_translation +1 ~1

distinguishable_name added · varchar(255)

custom_fields Type: longtext → json

plugin ~1

autoload Type: longtext → json

plugin_translation ~2

changelog Type: longtext → json

custom_fields Type: longtext → json

product +8 −2 ~10 2 index changes

cms_page_version_id added · binary(16)

category_ids added · json

stream_ids added · json

cheapest_price added · longtext

cheapest_price_accessor added · longtext

states added · json

display_parent added · tinyint(1)

variant_listing_config added · json

listing_prices removed

purchase_price removed

category_tree Type: longtext → json

option_ids Type: longtext → json

property_ids Type: longtext → json

price Type: longtext → json

purchase_prices Type: longtext → json

whitelist_ids Type: longtext → json

blacklist_ids Type: longtext → json

tag_ids Type: longtext → json

variant_restrictions Type: longtext → json

configurator_group_config Type: longtext → json

product_configurator_setting ~2 1 index change

price Type: longtext → json

custom_fields Type: longtext → json

product_export +1

is_running added · tinyint(1)

product_feature_set ~1

features Type: longtext → json

product_feature_set_translation ~1

name Nullable: true → false · Default: null →

product_manufacturer_translation ~1

custom_fields Type: longtext → json

product_media ~1

custom_fields Type: longtext → json

product_price ~2

price Type: longtext → json

custom_fields Type: longtext → json

product_review +1

custom_fields added · json

product_search_config ~1

excluded_terms Type: longtext → json

product_sorting ~1

fields Type: longtext → json

product_stream ~1

api_filter Type: longtext → json

product_stream_filter ~1

custom_fields Type: longtext → json

product_stream_translation ~1

custom_fields Type: longtext → json

product_translation +1 ~2

slot_config added · json

custom_fields Type: longtext → json

custom_search_keywords Type: longtext → json

promotion +2 ~2

priority added · int(11)

prevent_combination added · tinyint(1)

orders_per_customer_count Type: longtext → json

exclusion_ids Type: longtext → json

promotion_individual_code ~1

payload Type: longtext → json

promotion_translation +1

custom_fields added · json

property_group +1

visible_on_product_detail_page added · tinyint(1)

property_group_option_translation ~1

custom_fields Type: longtext → json

property_group_translation ~1

custom_fields Type: longtext → json

rule +1 ~2

areas added · json

module_types Type: longtext → json

custom_fields Type: longtext → json

rule_condition +1 ~2 1 index change

script_id added · binary(16)

value Type: longtext → json

custom_fields Type: longtext → json

sales_channel +2 ~3 1 index change

home_cms_page_id added · binary(16)

home_cms_page_version_id added · binary(16)

configuration Type: longtext → json

maintenance_ip_whitelist Type: longtext → json

payment_method_ids Type: longtext → json

sales_channel_api_context ~2

payload Type: longtext → json

updated_at Default: current_timestamp() → CURRENT_TIMESTAMP · Extra: on update current_timestamp() → on update CURRENT_TIMESTAMP

sales_channel_domain ~1

custom_fields Type: longtext → json

sales_channel_translation +6 ~1

home_keywords added · varchar(255)

home_meta_description added · varchar(255)

home_meta_title added · varchar(255)

home_name added · varchar(255)

home_enabled added · tinyint(4)

home_slot_config added · json

custom_fields Type: longtext → json

sales_channel_type ~1

screenshot_urls Type: longtext → json

sales_channel_type_translation ~1

custom_fields Type: longtext → json

salutation_translation +1

custom_fields added · json

seo_url ~2 1 index change

foreign_key Key: (none) → MUL

custom_fields Type: longtext → json

seo_url_template ~1

custom_fields Type: longtext → json

shipping_method +1

position added · int(11)

shipping_method_price ~2

currency_price Type: longtext → json

custom_fields Type: longtext → json

shipping_method_translation ~1

custom_fields Type: longtext → json

snippet ~1

custom_fields Type: longtext → json

snippet_set ~1

custom_fields Type: longtext → json

state_machine_history ~1

entity_id Type: longtext → json

state_machine_state_translation ~1

custom_fields Type: longtext → json

state_machine_transition ~1

custom_fields Type: longtext → json

state_machine_translation ~1

custom_fields Type: longtext → json

system_config ~2 1 index change

configuration_value Type: longtext → json

sales_channel_id Key: (none) → MUL

tax +1 ~1

position added · int(11)

custom_fields Type: longtext → json

tax_rule ~1

data Type: longtext → json

theme ~2

base_config Type: longtext → json

config_values Type: longtext → json

theme_translation ~3

labels Type: longtext → json

help_texts Type: longtext → json

custom_fields Type: longtext → json

unit_translation ~1

custom_fields Type: longtext → json

user +1 ~1

time_zone added · varchar(255)

custom_fields Type: longtext → json

user_access_key ~1

custom_fields Type: longtext → json

user_config ~1

value Type: longtext → json

version ~1 1 index change

created_at Key: (none) → MUL

version_commit ~1 1 index change

created_at Key: (none) → MUL

version_commit_data ~2

entity_id Type: longtext → json

payload Type: longtext → json

webhook +2

active added · tinyint(1)

error_count added · int(11)

Need a different pair? Use the interactive comparison tool.