Shopware 6.6.10.29 vs 6.7.15.1 — Database Changes

Base Shopware 6.6.10.29 → Target Shopware 6.7.15.1

Tables Added

Tables Removed

Tables Changed

187

Unchanged

Tables added in 6.7.15.1

app_feature 8 columns
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
mcp_toolset_session 3 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_auth_code 6 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 86 column changes in total

app +3

requested_privileges added · json

context_gateway_url added · varchar(255)

unconfirmed_app_secrets added · json

country ~1

advanced_postal_code_pattern Type: varchar(255) → varchar(1024)

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)

deleted_apps +1

unconfirmed_app_secrets added · json

document +1 −1 ~2 1 index change

type_name added · varchar(255)

file_type removed

order_id Nullable: false → true

order_version_id Nullable: false → true

document_base_config +11

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)

filename_infixes added · json

type_name added · varchar(255)

document_base_config_sales_channel +1

type_name added · varchar(255)

import_export_profile −1 ~1

name removed

technical_name Nullable: true → false

integration +1

mcp_allowlist added · json

language +2

active added · tinyint(1)

translation_auto_update 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 +3

provider added · varchar(255)

next_generation_at added · datetime(3)

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)

refresh_token +2 1 index change

family_id added · binary(16)

revoked_at added · datetime(3)

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 +3 1 index change

measurement_units added · json

is_external_storefront added · tinyint(1)

external_storefront_language_id added · binary(16)

salutation +1

position added · int

seo_url 1 index change

seo_url_template +1

is_headless added · tinyint(1)

shipping_method ~1

technical_name Nullable: true → false

state_machine_history +3 1 index change

integration_id added · binary(16)

internal_comment added · text

source_type added · varchar(32)

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.