Shopware 6.4.20.2 vs 6.5.8.19 — Database Changes

Base Shopware 6.4.20.2 → Target Shopware 6.5.8.19

Tables Added

Tables Removed

102

Tables Changed

120

Unchanged

Tables added in 6.5.8.19

Tables removed in 6.5.8.19

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 178 column changes in total

admin_elasticsearch_index_task ~1

doc_count Type: int(11) → int

app ~2

path Type: varchar(255) → varchar(4096) · Nullable: false → true

template_load_priority Type: int(11) → int

app_action_button −1

open_new_tab removed

app_action_button_translation ~1

label Nullable: false → true

app_cms_block_translation ~1

label Nullable: false → true

app_config ~1

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

app_flow_action_translation ~1

label Nullable: false → true

app_payment_method +1

recurring_url added · varchar(255)

app_script_condition_translation ~1

name Nullable: false → true

app_translation ~1

label Nullable: false → true

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

country_translation ~1

address_format Nullable: false → true

currency ~1

position Type: int(11) → int

custom_entity +5 1 index change

flags added · json

plugin_id added · binary(16)

custom_fields_aware added · tinyint(1)

label_property added · varchar(255)

deleted_at added · datetime(3)

custom_field +1 ~1

allow_cart_expose added · tinyint(1)

allow_customer_write Type: tinyint(4) → tinyint

custom_field_set ~1

position Type: int(11) → int

customer +2 −1 ~2

account_type added · varchar(255)

review_count added · int

newsletter removed

auto_increment Type: bigint(20) unsigned → bigint unsigned

order_count Type: int(5) → int

customer_address −1 ~1

vat_id removed

street Nullable: true → false

delivery_time ~2

min Type: int(3) → int

max Type: int(3) → int

document +1 1 index change

document_number added · varchar(255)

document_type_translation ~1

name Nullable: false → true

elasticsearch_index_task ~1

doc_count Type: int(11) → int

flow +1 ~1 1 index change

app_flow_event_id added · binary(16)

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

mail_template_type_translation ~1

name Nullable: false → true

media +2 ~1

path added · varchar(2048)

config added · json

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

path added · varchar(2048)

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

number_range_type_translation ~1

type_name Nullable: false → true

order +1 ~2 1 index change

source added · varchar(255)

auto_increment Type: bigint(20) unsigned → bigint unsigned

order_number Key: (none) → MUL

order_address ~1

zipcode Nullable: false → true

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

version_id added · binary(16)

order_transaction_capture_refund +2

version_id added · binary(16)

capture_version_id added · binary(16)

order_transaction_capture_refund_position +2 ~1

version_id added · binary(16)

refund_version_id added · binary(16)

quantity Type: int(11) → int

payment_method +1 ~1 1 index change

technical_name added · varchar(255)

position Type: int(11) → int

product +1 −5 ~14 1 index change

canonical_product_version_id added · binary(16)

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

available Default: 1 → 0

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

name Nullable: false → true

product_download ~1

position Type: int(11) → int

product_export ~1

interval Type: int(11) → int

product_feature_set_translation ~1

name Nullable: false → true · Default: → null

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

default_run_interval added · int

run_interval Type: int(11) → int

shipping_method +1 ~2 1 index change

technical_name added · varchar(255)

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

state_machine_history +2

referenced_id added · binary(16)

referenced_version_id added · binary(16)

state_machine_state_translation ~1

name Nullable: false → true

state_machine_translation ~1

name Nullable: false → true

tax ~2

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

position Type: int(11) → int

tax_rule +1 ~1

active_from added · datetime(3)

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

tax_rule_type ~1

position Type: int(11) → int

tax_rule_type_translation ~1

type_name Nullable: false → true

theme +1

theme_json added · json

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

only_live_version added · tinyint unsigned

error_count Type: int(11) → int

webhook_event_log +1 ~3

only_live_version added · tinyint unsigned

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.