Shopware 6.6.10.23 vs 6.7.13.1 — Database Changes

Base Shopware 6.6.10.23 → Target Shopware 6.7.13.1

Tables Added

Tables Removed

Tables Changed

193

Unchanged

Tables added in 6.7.13.1

app_mcp_prompt 6 columns
app_mcp_prompt_translation 6 columns
app_mcp_resource 8 columns
app_mcp_resource_translation 6 columns
app_mcp_tool 8 columns
app_mcp_tool_translation 6 columns
consent_log 4 columns
consent_state 7 columns
document_file 6 columns
mcp_tool_result_cache 5 columns
measurement_display_unit 9 columns
measurement_display_unit_translation 6 columns
measurement_system 4 columns
measurement_system_translation 6 columns
messenger_stats 4 columns
oauth_user 7 columns
sales_channel_file 8 columns
sales_channel_tracking_customer 5 columns
sales_channel_tracking_order 6 columns
theme_runtime_config 8 columns
webhook_delivery 10 columns
webhook_stream 6 columns

Tables changed 69 column changes in total

app +2

requested_privileges added · json

context_gateway_url added · varchar(255)

custom_field +1

include_in_search added · tinyint(1)

custom_field_set +1

extension_name added · varchar(255)

customer −1 1 index change

default_payment_method_id removed

customer_address ~2

first_name Type: varchar(50) → varchar(255)

last_name Type: varchar(60) → varchar(255)

document −1

file_type removed

document_base_config +9

page_size added · varchar(32)

page_orientation added · varchar(32)

items_per_page added · int unsigned

display_header added · tinyint(1)

display_footer added · tinyint(1)

display_page_count added · tinyint(1)

display_company_address added · tinyint(1)

display_return_address added · tinyint(1)

display_customer_vat_id added · tinyint(1)

import_export_profile −1 ~1

name removed

technical_name Nullable: true → false

integration +1

mcp_allowlist added · json

language +1

active added · tinyint(1)

mail_template +1

was_modified_by_user added · tinyint(1)

media ~1 3 index changes

uploaded_at Key: (none) → MUL

media_thumbnail +1 1 index change

media_thumbnail_size_id added · binary(16)

notification ~1

message Nullable: true → false

order +5 2 index changes

primary_order_delivery_id added · binary(16)

primary_order_delivery_version_id added · binary(16)

primary_order_transaction_id added · binary(16)

primary_order_transaction_version_id added · binary(16)

internal_comment added · longtext

order_address ~3 1 index change

first_name Type: varchar(50) → varchar(255)

last_name Type: varchar(60) → varchar(255)

created_at Key: (none) → MUL

order_delivery_position ~2

total_price Type: int → double

unit_price Type: int → double

order_line_item ~1 3 index changes

created_at Key: (none) → MUL

order_transaction ~1 1 index change

created_at Key: (none) → MUL

payment_method ~1

technical_name Nullable: true → false

payment_token +1

consumed added · tinyint(1)

product +4 ~3 5 index changes

type added · varchar(32)

mainCategories added · binary(16)

open_graph_media_id added · binary(16)

openGraphMedia added · binary(16)

categories Key: (none) → MUL

weight Type: decimal(10,3) unsigned → decimal(15,6) unsigned

display_group Type: varchar(50) → varchar(64)

product_cross_selling_assigned_products 1 index change

product_export +2

provider added · varchar(255)

feed_label added · varchar(20)

product_manufacturer −1

link removed

product_manufacturer_translation +1

link added · longtext

product_search_config_field +1

use_exact_subfield added · tinyint(1)

product_stream +2

internal added · tinyint(1)

display_as_group added · tinyint(1)

product_translation +3

og_title added · varchar(255)

og_description added · varchar(255)

description_teaser added · varchar(512)

sales_channel +3

measurement_units added · json

maintenance_ip_allowlist added · json

business_time_zone added · varchar(255)

sales_channel_analytics +2

track_offcanvas_cart added · tinyint(1)

enhanced_conversions added · tinyint(1)

sales_channel_domain +1

measurement_units added · json

salutation +1

position added · int

shipping_method ~1

technical_name Nullable: true → false

state_machine_history +2 1 index change

integration_id added · binary(16)

internal_comment added · text

user +1 ~1

mcp_allowlist added · json

active Default: 0 → 1

webhook_event_log +1

sequence added · bigint unsigned

Need a different pair? Use the interactive comparison tool.