Shopware 6.4.20.0 vs 6.4.20.1 — Database Changes

Base Shopware 6.4.20.0 → Target Shopware 6.4.20.1

Tables Added

Tables Removed

122

Tables Changed

108

Unchanged

Tables removed in 6.4.20.1

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 10 columns
swag_paypal_pos_sales_channel_run_log had 8 columns

Tables changed 206 column changes in total

acl_role ~1

privileges Type: longtext → json

app ~4

modules Type: longtext → json

main_module Type: longtext → json

cookies Type: longtext → json

allowed_hosts Type: longtext → json

app_administration_snippet ~1

value Type: longtext → json

app_cms_block ~1

block Type: longtext → json

app_flow_action ~4

parameters Type: longtext → json

config Type: longtext → json

headers Type: longtext → json

requirements Type: longtext → json

app_flow_action_translation ~1

custom_fields Type: longtext → json

app_script_condition ~1

config Type: longtext → json

app_translation ~1

custom_fields Type: longtext → json

cart ~1

rule_ids Type: longtext → json

category ~1

cms_page_version_id Default: ???jK¾K??u,4% →

category_translation ~3

breadcrumb Type: longtext → json

custom_fields Type: longtext → json

slot_config Type: longtext → json

cms_block ~4

version_id Default: ???jK¾K??u,4% →

cms_section_version_id Default: ???jK¾K??u,4% →

visibility Type: longtext → json

custom_fields Type: longtext → json

cms_page ~2

version_id Default: ???jK¾K??u,4% →

config Type: longtext → json

cms_page_translation ~2

cms_page_version_id Default: ???jK¾K??u,4% →

custom_fields Type: longtext → json

cms_section ~4

version_id Default: ???jK¾K??u,4% →

cms_page_version_id Default: ???jK¾K??u,4% →

visibility Type: longtext → json

custom_fields Type: longtext → json

cms_slot ~1

cms_block_version_id Default: ???jK¾K??u,4% →

cms_slot_translation ~2

config Type: longtext → json

custom_fields Type: longtext → json

country ~2

customer_tax Type: longtext → json

company_tax Type: longtext → json

country_state_translation ~1

custom_fields Type: longtext → json

country_translation ~2

address_format Type: longtext → json

custom_fields Type: longtext → json

currency ~2

item_rounding Type: longtext → json

total_rounding Type: longtext → json

currency_country_rounding ~2

item_rounding Type: longtext → json

total_rounding Type: longtext → json

currency_translation ~1

custom_fields Type: longtext → json

custom_entity ~1

fields Type: longtext → json

custom_field ~1

config Type: longtext → json

custom_field_set ~1

config Type: longtext → json

customer ~4

vat_ids Type: longtext → json

newsletter_sales_channel_ids Type: longtext → json

custom_fields Type: longtext → json

tag_ids Type: longtext → json

customer_address ~1

custom_fields Type: longtext → json

customer_group_translation ~1

custom_fields Type: longtext → json

customer_wishlist ~1

custom_fields Type: longtext → json

delivery_time_translation ~1

custom_fields Type: longtext → json

document ~2

config Type: longtext → json

custom_fields Type: longtext → json

document_base_config ~2

config Type: longtext → json

custom_fields Type: longtext → json

document_type_translation ~1

custom_fields Type: longtext → json

event_action ~2

config Type: longtext → json

custom_fields Type: longtext → json

flow ~1

custom_fields Type: longtext → json

flow_sequence ~2

config Type: longtext → json

custom_fields Type: longtext → json

flow_template ~1

config Type: longtext → json

import_export_log ~2

config Type: longtext → json

result Type: longtext → json

import_export_profile ~2

update_by Type: longtext → json

config Type: longtext → json

integration ~1

custom_fields Type: longtext → json

landing_page ~1

cms_page_version_id Default: ???jK¾K??u,4% →

landing_page_translation ~2

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 ~2

context Type: longtext → json

extra Type: longtext → json

mail_template_translation ~1

custom_fields Type: longtext → json

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

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 ~1

custom_fields Type: longtext → json

notification ~1

required_privileges Type: longtext → json

number_range_translation ~1

custom_fields Type: longtext → json

number_range_type_translation ~1

custom_fields Type: longtext → json

order ~6

price Type: longtext → json

shipping_costs Type: longtext → json

custom_fields Type: longtext → json

item_rounding Type: longtext → json

total_rounding Type: longtext → json

rule_ids Type: longtext → json

order_address ~1

custom_fields Type: longtext → json

order_customer ~2

vat_ids Type: longtext → json

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 ~5

states Type: longtext → json

payload Type: longtext → json

price_definition Type: longtext → json

price Type: longtext → json

custom_fields Type: longtext → json

order_line_item_download ~1

custom_fields Type: longtext → json

order_transaction ~2

amount Type: longtext → json

custom_fields Type: longtext → json

order_transaction_capture ~2

amount Type: longtext → json

custom_fields Type: longtext → json

order_transaction_capture_refund ~2

amount Type: longtext → json

custom_fields Type: longtext → json

order_transaction_capture_refund_position ~2

amount Type: longtext → json

custom_fields Type: longtext → json

payment_method_translation ~1

custom_fields Type: longtext → json

plugin ~1

autoload Type: longtext → json

plugin_translation ~2

changelog Type: longtext → json

custom_fields Type: longtext → json

product ~15

cms_page_version_id Default: ???jK¾K??u,4% →

category_tree Type: longtext → json

category_ids Type: longtext → json

stream_ids 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

states Type: longtext → json

variant_listing_config Type: longtext → json

product_configurator_setting ~2

price Type: longtext → json

custom_fields Type: longtext → json

product_download ~1

custom_fields Type: longtext → json

product_feature_set ~1

features Type: longtext → json

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 Type: longtext → 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 ~3

custom_fields Type: longtext → json

slot_config Type: longtext → json

custom_search_keywords Type: longtext → json

promotion ~2

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 Type: longtext → json

property_group_option_translation ~1

custom_fields Type: longtext → json

property_group_translation ~1

custom_fields Type: longtext → json

rule ~3

areas Type: longtext → json

module_types Type: longtext → json

custom_fields Type: longtext → json

rule_condition ~2

value Type: longtext → json

custom_fields Type: longtext → json

sales_channel ~3

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 ~2

home_slot_config Type: longtext → 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 Type: longtext → json

seo_url ~1

custom_fields Type: longtext → json

seo_url_template ~1

custom_fields Type: longtext → json

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 ~1

configuration_value Type: longtext → json

tax ~1

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

custom_fields Type: longtext → json

user_access_key ~1

custom_fields Type: longtext → json

user_config ~1

value Type: longtext → json

version_commit_data ~2

entity_id Type: longtext → json

payload Type: longtext → json

webhook_event_log ~3

request_content Type: longtext → json

response_content Type: longtext → json

custom_fields Type: longtext → json

Need a different pair? Use the interactive comparison tool.