Shopware 6.4.20.2 vs 6.5.0.0 — Database Changes

Base Shopware 6.4.20.2 → Target Shopware 6.5.0.0

Tables Added

Tables Removed

Tables Changed

142

Unchanged

Tables added in 6.5.0.0

Tables removed in 6.5.0.0

dead_message had 14 columns
enqueue had 12 columns
event_action had 10 columns
event_action_rule had 2 columns
event_action_sales_channel had 2 columns
mail_template_sales_channel had 6 columns
message_queue_stats had 5 columns
sales_channel_rule had 2 columns

Tables changed 131 column changes in total

admin_elasticsearch_index_task ~1

doc_count Type: int(11) → int

app ~1

template_load_priority Type: int(11) → int

app_action_button −1

open_new_tab removed

cart −1 ~1

name removed

auto_increment Type: bigint(20) → bigint

category +1 ~6 1 index change

custom_entity_type_id added · binary(16)

auto_increment Type: int(11) → int

cms_page_version_id Default: → 0x0FA91CE3E96A4BC2BE4BD9CE752C3425

level Type: int(11) unsigned → int unsigned

child_count Type: int(11) unsigned → int unsigned

display_nested_products Type: tinyint(1) unsigned → tinyint unsigned

visible Type: tinyint(1) unsigned → tinyint unsigned

category_translation ~1

link_new_tab Type: tinyint(4) → tinyint

cms_block ~3

version_id Default: → 0x0FA91CE3E96A4BC2BE4BD9CE752C3425

cms_section_version_id Default: → 0x0FA91CE3E96A4BC2BE4BD9CE752C3425

position Type: int(11) → int

cms_page ~1

version_id Default: → 0x0FA91CE3E96A4BC2BE4BD9CE752C3425

cms_page_translation ~1

cms_page_version_id Default: → 0x0FA91CE3E96A4BC2BE4BD9CE752C3425

cms_section ~3

version_id Default: → 0x0FA91CE3E96A4BC2BE4BD9CE752C3425

cms_page_version_id Default: → 0x0FA91CE3E96A4BC2BE4BD9CE752C3425

position Type: int(11) → int

cms_slot ~1

cms_block_version_id Default: → 0x0FA91CE3E96A4BC2BE4BD9CE752C3425

country −2 ~1

tax_free removed

company_tax_free removed

position Type: int(11) → int

country_state ~1

position Type: int(11) → int

currency ~1

position Type: int(11) → int

custom_entity +2 1 index change

flags added · json

plugin_id added · binary(16)

custom_field ~1

allow_customer_write Type: tinyint(4) → tinyint

custom_field_set ~1

position Type: int(11) → int

customer −1 ~2

newsletter removed

auto_increment Type: bigint(20) unsigned → bigint unsigned

order_count Type: int(5) → int

customer_address −1

vat_id removed

delivery_time ~2

min Type: int(3) → int

max Type: int(3) → int

elasticsearch_index_task ~1

doc_count Type: int(11) → int

flow ~1

priority Type: int(11) → int

flow_sequence ~2

position Type: int(11) → int

display_group Type: int(11) → int

import_export_file ~1

size Type: int(11) → int

import_export_log ~1

records Type: int(11) → int

import_export_profile ~1

system_default Type: tinyint(1) unsigned → tinyint unsigned

increment ~1

count Type: bigint(20) unsigned → bigint unsigned

landing_page ~1

cms_page_version_id Default: → 0x0FA91CE3E96A4BC2BE4BD9CE752C3425

log_entry ~1

level Type: smallint(6) → smallint

mail_header_footer ~1

system_default Type: tinyint(1) unsigned → tinyint unsigned

mail_template ~1

system_default Type: tinyint(1) unsigned → tinyint unsigned

mail_template_media ~1

position Type: int(11) → int

media ~1

file_size Type: int(10) unsigned → int unsigned

media_folder ~1

child_count Type: int(11) unsigned → int unsigned

media_folder_configuration ~1

thumbnail_quality Type: int(11) → int

media_thumbnail ~2

width Type: int(10) unsigned → int unsigned

height Type: int(10) unsigned → int unsigned

media_thumbnail_size ~2

width Type: int(11) → int

height Type: int(11) → int

migration ~1

creation_timestamp Type: int(8) → int

number_range ~1

start Type: int(8) → int

number_range_state ~1

last_value Type: int(8) → int

order ~2 1 index change

auto_increment Type: bigint(20) unsigned → bigint unsigned

order_number Key: (none) → MUL

order_delivery_position ~3

total_price Type: int(11) → int

unit_price Type: int(11) → int

quantity Type: int(11) → int

order_line_item ~2

quantity Type: int(11) → int

position Type: int(11) → int

order_line_item_download ~1

position Type: int(11) → int

order_transaction_capture_refund_position ~1

quantity Type: int(11) → int

payment_method ~1

position Type: int(11) → int

product −5 ~13 1 index change

whitelist_ids removed

blacklist_ids removed

configurator_group_config removed

main_variant_id removed

display_parent removed

auto_increment Type: int(11) → int

active Type: tinyint(3) unsigned → tinyint unsigned

cms_page_version_id Default: → 0x0FA91CE3E96A4BC2BE4BD9CE752C3425

sales Type: int(11) → int

stock Type: int(11) → int

available_stock Type: int(11) → int

restock_time Type: int(11) → int

purchase_steps Type: int(11) unsigned → int unsigned

max_purchase Type: int(11) unsigned → int unsigned

min_purchase Type: int(11) unsigned → int unsigned

mark_as_topseller Type: tinyint(1) unsigned → tinyint unsigned

child_count Type: int(11) → int

variant_listing_config Extra: VIRTUAL GENERATED → (none)

product_configurator_setting ~1

position Type: int(11) → int

product_cross_selling ~2

position Type: int(11) → int

limit Type: int(11) → int

product_cross_selling_assigned_products ~1

position Type: int(11) → int

product_download ~1

position Type: int(11) → int

product_export ~1

interval Type: int(11) → int

product_media ~1

position Type: int(11) → int

product_price ~2

quantity_start Type: int(11) → int

quantity_end Type: int(11) → int

product_search_config ~1

min_search_length Type: smallint(6) → smallint

product_search_config_field ~1

ranking Type: int(11) → int

product_sorting ~1

priority Type: int(11) unsigned → int unsigned

product_stream_filter ~1

position Type: int(11) → int

product_visibility ~1

visibility Type: int(11) → int

promotion ~4

max_redemptions_global Type: int(11) → int

max_redemptions_per_customer Type: int(11) → int

priority Type: int(11) → int

order_count Type: int(11) → int

promotion_sales_channel ~1

priority Type: int(11) → int

property_group_option_translation ~1

position Type: int(11) → int

property_group_translation ~1

position Type: int(11) → int

rule ~1

priority Type: int(11) → int

rule_condition ~1

position Type: int(11) → int

sales_channel ~2

navigation_category_depth Type: int(11) → int

hreflang_active Type: tinyint(1) unsigned → tinyint unsigned

sales_channel_api_context ~1

updated_at Extra: on update CURRENT_TIMESTAMP → DEFAULT_GENERATED on update CURRENT_TIMESTAMP

sales_channel_domain ~1

hreflang_use_only_locale Type: tinyint(1) unsigned → tinyint unsigned

sales_channel_translation ~1

home_enabled Type: tinyint(4) → tinyint

scheduled_task ~1

run_interval Type: int(11) → int

shipping_method ~2

active Type: tinyint(1) unsigned → tinyint unsigned · Default: 1 → 0

position Type: int(11) → int

shipping_method_price ~1

calculation Type: int(1) unsigned → int unsigned

tax ~2

tax_rate Type: decimal(10,2) → decimal(10,3) · Nullable: false → true

position Type: int(11) → int

tax_rule ~1

tax_rate Type: double(10,2) → double(10,3) · Nullable: false → true

tax_rule_type ~1

position Type: int(11) → int

user_access_key −1

write_access removed

version_commit ~1

auto_increment Type: bigint(20) → bigint

version_commit_data ~1

auto_increment Type: bigint(20) → bigint

webhook ~1

error_count Type: int(11) → int

webhook_event_log ~3

timestamp Type: int(11) → int

processing_time Type: int(11) → int

response_status_code Type: int(11) → int

Need a different pair? Use the interactive comparison tool.