== driver=mysql db=meemmarket_catch_catch == Dropping all tables ............................................. 543ms DONE INFO Preparing database. Creating migration table ......................................... 19ms DONE INFO Running migrations. 2014_10_12_000000_create_users_table ............................. 27ms DONE 2014_10_12_100000_create_password_resets_table ................... 14ms DONE 2018_08_08_100000_create_telescope_entries_table ................ 116ms DONE 2019_08_19_000000_create_failed_jobs_table ....................... 19ms DONE 2019_12_14_000001_create_personal_access_tokens_table ............ 30ms DONE 2020_04_17_194830_create_permission_tables ...................... 156ms DONE 2020_04_29_000001_create_promotions_table ........................ 33ms DONE 2020_06_02_051901_create_marvel_tables .......................... 872ms DONE 2020_10_26_163529_create_media_table ............................. 16ms DONE 2021_10_12_193855_create_reviews_table .......................... 123ms DONE 2022_03_23_051901_create_marvel_delivery_time_tables .............. 5ms DONE 2022_04_11_094659_create_jobs_table .............................. 12ms DONE 2023_07_12_030502_create_notify_logs_table ....................... 27ms DONE 2023_07_19_162433_create_faqs_table ............................... 4ms DONE 2023_08_14_173253_create_flash_sales_table ....................... 58ms DONE 2023_08_28_114418_create_refund_policies_table ................... 62ms DONE 2023_09_07_061715_create_refund_reasons_table .................... 23ms DONE 2024_12_27_000001_create_coupon_usages_table ..................... 54ms DONE 2025_12_06_000002_add_editor_role_permission ...................... 6ms DONE 2026_05_03_111116_create_promotion_product_table ................. 28ms DONE 2026_05_09_000001_create_brands_table ............................. 4ms DONE 2026_05_09_000002_create_brand_product_table ..................... 43ms DONE 2026_05_09_000003_create_contacts_table ........................... 5ms DONE 2026_05_17_000001_add_selected_promotion_checkout_fields ......... 74ms DONE 2026_05_18_000001_add_level_to_categories_table ................... 1ms DONE 2026_05_23_100001_create_countries_table ......................... 20ms DONE 2026_05_23_100002_create_governorates_table ...................... 38ms DONE 2026_05_23_100003_create_cities_table ............................ 35ms DONE 2026_05_23_100004_create_shipping_prices_table ................... 29ms DONE 2026_06_01_065407_create_one_time_passwords_table ................ 13ms DONE 2026_06_01_124741_create_content_pages_table ..................... 23ms DONE 2026_06_01_135945_create_sections_table .......................... 31ms DONE 2026_06_13_094100_add_product_filter_indexes ...................... 0ms DONE 2026_06_17_000001_create_coupon_product_table .................... 53ms DONE 2026_06_17_000003_create_slider_product_table .................... 37ms DONE 2026_06_17_000009_create_section_types_table ..................... 15ms DONE 2026_06_17_000010_create_section_type_settings_table ............. 23ms DONE 2026_06_17_000011_drop_section_settings_and_unique_type ........... 4ms DONE 2026_06_23_000001_create_banner_product_table .................... 37ms DONE 2026_06_27_000001_create_imports_table ........................... 22ms DONE 2026_07_05_080102_create_activity_log_table ...................... 32ms DONE 2026_07_05_080103_add_event_column_to_activity_log_table ......... 11ms DONE 2026_07_05_080104_add_batch_uuid_column_to_activity_log_table .... 10ms DONE 2026_07_05_080106_create_notifications_table ..................... 21ms DONE 2026_07_05_080108_add_name_to_contacts_table ...................... 0ms DONE 2026_07_08_000001_add_fulfillment_and_payment_to_orders ........... 1ms DONE 2026_07_08_000002_add_payment_tracking_to_transactions ............ 2ms DONE 2026_07_08_141643_add_not_null_constraints_to_orders_and_transactions 152ms DONE 2026_07_11_000001_add_governorate_id_to_orders ................... 18ms DONE 2026_07_11_000002_make_payment_gateway_nullable ................... 6ms DONE 2026_07_11_000003_create_pickup_locations_table ................... 5ms DONE 2026_07_11_000004_add_pickup_location_snapshot_to_orders .......... 0ms DONE 2026_07_12_000001_create_payment_reconciliation_results_table .... 43ms DONE 2026_07_12_000002_add_free_shipping_to_coupons_discount_type ...... 5ms DONE 2026_07_14_103540_add_inventory_restored_at_to_orders ............. 7ms DONE 2026_07_15_000001_create_tags_table .............................. 18ms DONE 2026_07_15_000002_create_product_tag_table ....................... 22ms DONE 2026_07_15_000003_create_coupon_assignments_table ................ 33ms DONE 2026_07_15_000004_create_coupon_assignment_usages_table .......... 60ms DONE 2026_07_16_000001_create_invoice_sequences_table ................. 13ms DONE 2026_07_16_000002_create_invoices_table ......................... 167ms DONE 2026_07_17_000001_fix_cart_foreign_key_cascades .................. 76ms DONE 2026_07_18_000001_make_promotion_gift_product_variant_nullable .... 0ms DONE 2026_07_18_000002_add_unique_constraint_to_category_product ....... 1ms DONE 2026_07_19_000001_add_unique_constraints_to_attributes ............ 0ms DONE 2026_07_27_081603_add_order_status_columns_to_orders_table ....... 10ms DONE 2026_07_27_082000_add_uuid_and_verification_to_invoices_table .... 32ms DONE 2026_07_28_000001_create_invoice_timeline_table .................. 48ms DONE 2026_07_28_000002_create_credit_notes_table ...................... 83ms DONE 2026_07_28_000003_create_debit_notes_table ....................... 63ms DONE 2026_07_28_000004_create_shipments_table ......................... 63ms DONE 2026_07_28_000005_add_invoice_lifecycle_columns .................. 19ms DONE 2026_07_28_000006_remove_unique_order_id_from_invoices ........... 54ms DONE 2026_07_28_000007_add_order_number_to_orders_table ............... 10ms DONE 2026_08_03_000001_create_providers_table ......................... 29ms DONE 2026_08_03_000002_create_social_login_codes_table ................ 42ms DONE 2026_08_10_000001_create_site_reviews_table ...................... 54ms DONE 2026_08_10_000002_create_currencies_table ........................ 24ms DONE 2026_08_10_000003_create_currency_rates_table .................... 30ms DONE 2026_08_10_000004_add_currency_columns_to_orders_table ............ 8ms DONE 2026_08_11_000001_add_catalog_currency_code_to_orders_table ...... 12ms DONE 2026_08_11_000002_create_user_preferences_table .................. 17ms DONE 2026_08_11_000003_add_currency_snapshot_columns_to_order_products_table 6ms DONE 2026_08_13_000001_add_reminder_sent_at_to_carts_table ............. 8ms DONE 2026_08_13_000002_add_ending_soon_notified_at_to_promotions_table . 6ms DONE 2026_08_13_000003_add_ending_soon_notified_at_to_flash_sales_table 6ms DONE 2026_08_18_000001_create_static_pages_table ...................... 10ms DONE 2026_08_18_000002_create_static_sections_table ................... 27ms DONE 2026_08_19_000001_add_processing_to_orders_status_enum ........... 14ms DONE 2026_08_23_073810_create_device_tokens_table ..................... 36ms DONE 2026_08_23_105834_add_item_type_to_products_table ................ 17ms DONE 2026_08_23_120000_shrink_products_item_type_enum .................. 7ms DONE 2026_08_23_120100_add_item_type_to_order_products_table .......... 13ms DONE 2026_08_23_120200_create_digital_assets_table .................... 43ms DONE 2026_08_23_120300_create_digital_entitlements_table .............. 76ms DONE 2026_08_23_120400_create_digital_asset_entitlement_pivot_table ... 46ms DONE 2026_08_23_120500_create_digital_download_logs_table ............. 41ms DONE 2026_08_23_130000_make_orders_address_nullable ................... 18ms DONE 2026_08_24_120100_extend_digital_assets_for_multi_type_assets .... 59ms DONE 2026_08_24_120200_create_digital_license_keys_table .............. 73ms DONE 2026_08_24_120300_add_expires_at_to_digital_entitlements_table .... 9ms DONE 2026_08_26_100001_add_inventory_reservation_state_to_orders ...... 26ms DONE 2026_08_31_120000_add_inventory_state_restored_at_to_orders_table 10ms DONE 2026_08_31_120100_create_coupon_reservations_table ............... 78ms DONE 2026_08_31_130000_add_unique_pending_order_constraint ............ 20ms DONE 2026_09_01_194546_add_type_status_index_to_imports_table .......... 8ms DONE 2026_09_01_194558_add_created_by_created_at_index_to_imports_table 9ms DONE 2026_09_02_000001_make_transactions_invoice_id_nullable .......... 44ms DONE 2026_09_04_000000_add_operation_type_to_imports_table ............ 24ms DONE 2026_09_06_114430_make_users_email_nullable ...................... 33ms DONE 2026_09_08_000001_create_tax_classes_table ....................... 12ms DONE 2026_09_08_000002_add_tax_snapshot_to_orders_table ............... 68ms DONE 2026_09_08_000003_add_tax_to_order_products_products_settings .... 61ms DONE 2026_09_08_000004_add_rate_sync_fields_to_currencies_table ....... 10ms DONE 2026_09_08_000005_add_rate_provenance_to_currency_rates_table ..... 6ms DONE 2026_09_09_000000_remove_super_admin_permission ................... 1ms DONE 2026_09_09_000001_simplify_tax_to_direct_rates .................. 346ms DONE 2026_09_10_000001_create_coupon_targetings_table ................. 35ms DONE 2026_09_10_000002_create_coupon_claims_table ..................... 46ms DONE 2026_09_10_000003_create_customer_metrics_table .................. 50ms DONE 2026_09_10_000004_rename_max_claims_per_user_to_max_claims_in_coupon_targetings 51ms DONE 2026_09_11_000001_create_order_status_history_table .............. 70ms DONE 2026_09_11_000002_make_coupon_assignment_usages_order_id_non_nullable 70ms DONE 2026_09_11_000003_add_check_constraint_to_coupon_assignment_usages 20ms DONE 2026_09_12_000001_create_user_notification_preferences_table ..... 30ms DONE 2026_09_12_000002_create_order_notifications_table ............... 64ms DONE 2026_09_12_000003_create_user_device_tokens_table ................ 38ms DONE 2026_09_13_000001_create_order_analytics_hourly_view .............. 5ms DONE 2026_09_13_000002_create_order_performance_metrics_view ........... 7ms DONE 2026_09_13_000003_create_customer_lifetime_value_view ............. 4ms DONE 2026_09_13_000004_create_notification_performance_view ............ 4ms DONE 2026_09_14_000001_add_claim_lifecycle_to_coupon_claims ........... 23ms DONE 2026_09_14_000001_add_type_config_is_active_to_static_sections_table 7ms DONE 2026_09_14_000002_add_ttl_to_coupon_targetings .................... 6ms DONE 2026_09_14_000003_extend_targeting_modes .......................... 4ms DONE 2026_09_15_000001_add_activity_log_indexes ....................... 39ms DONE 2026_09_20_194034_create_order_tracking_events_table ............. 76ms DONE 2026_09_21_074300_add_cancellation_tracking_to_orders_table ...... 36ms DONE 2026_09_21_121356_add_shipment_tracking_to_orders_table .......... 20ms DONE 2026_09_22_000001_add_legacy_currency_status_to_orders_table ..... 27ms DONE 2026_09_22_081818_create_warehouses_table ........................ 17ms DONE 2026_09_22_081824_create_locations_table ......................... 40ms DONE 2026_09_22_081825_create_product_locations_table ................ 109ms DONE 2026_09_22_100001_create_coupon_outbox_table ..................... 47ms DONE 2026_09_22_100002_create_coupon_event_logs_table ................. 72ms DONE 2026_09_22_100003_create_coupon_distribution_runs_table .......... 35ms DONE 2026_09_22_100004_create_coupon_distribution_recipients_table .... 70ms DONE 2026_09_22_100005_create_coupon_distribution_user_states_table ... 53ms DONE 2026_09_22_100006_add_candidate_selection_indexes ................ 17ms DONE 2026_09_22_100007_add_notify_pending_user_state .................. 16ms DONE 2026_09_22_100008_widen_coupon_outbox_attempts ................... 53ms DONE 2026_09_22_130803_create_fulfillments_table ..................... 114ms DONE 2026_09_22_130826_create_fulfillment_items_table ................ 104ms DONE 2026_09_22_190340_create_fulfillment_batches_table ............... 54ms DONE 2026_09_22_190356_create_picking_tasks_table ..................... 67ms DONE 2026_09_22_190932_create_packing_stations_table .................. 62ms DONE 2026_09_22_190957_create_packing_tasks_table ..................... 52ms DONE 2026_09_22_191253_add_fulfillment_fields_to_shipments_table ...... 39ms DONE 2026_09_22_192635_create_return_requests_table .................. 115ms DONE 2026_09_22_192643_create_return_items_table ...................... 84ms DONE 2026_09_23_000001_add_wms_fields_to_fulfillments_table ........... 15ms DONE 2026_09_23_000002_add_wms_barcode_and_hint_fields ................ 94ms DONE 2026_09_23_000003_add_claim_fields_to_picking_tasks .............. 69ms DONE 2026_09_23_000004_create_packages_tables ......................... 96ms DONE 2026_09_23_000005_add_idempotency_to_shipments ................... 16ms DONE 2026_09_23_000006_add_restored_quantity_to_order_products ......... 8ms DONE 2026_09_23_000007_add_warehouse_to_users ......................... 21ms DONE 2026_09_25_000001_add_idempotency_key_to_transactions ............ 22ms DONE 2026_09_26_000001_repair_orders_pending_unique_partial_index ...... 0ms DONE 2026_09_26_000002_repair_coupon_targetings_sqlite_parity .......... 0ms DONE 2026_09_27_000001_normalize_coupon_codes_canonical ................ 1ms DONE 2026_09_27_000001_widen_transactions_amount_to_3dp ............... 24ms DONE 2026_09_27_000002_add_is_public_to_coupons_table .................. 7ms DONE 2026_09_28_000001_add_governorate_id_to_address_table ............ 28ms DONE 2026_09_28_000001_create_order_status_flow_tables ............... 128ms DONE 2026_09_28_000002_extend_orders_with_flow ........................ 96ms DONE 2026_09_29_000001_widen_order_status_enum_for_global_catalog ..... 20ms DONE 2026_09_30_000001_create_flow_inputs_table ....................... 55ms DONE 2026_09_30_000002_create_order_flow_values_table ................. 38ms DONE 2026_09_30_000003_add_flow_value_columns_to_orders_table ......... 71ms DONE 2026_10_01_000001_make_flow_status_names_translatable ............ 48ms DONE 2026_10_02_000001_add_legacy_order_status_column_to_orders_table . 25ms DONE 2026_10_02_000002_add_parent_id_to_orders_table .................. 30ms DONE PASS: table exists: digital_assets PASS: table exists: digital_entitlements PASS: table exists: digital_asset_entitlement PASS: table exists: digital_download_logs PASS: table exists: digital_license_keys PASS: digital_assets has column id PASS: digital_assets has column uuid PASS: digital_assets has column product_id PASS: digital_assets has column type PASS: digital_assets has column disk PASS: digital_assets has column path PASS: digital_assets has column original_name PASS: digital_assets has column display_name PASS: digital_assets has column mime PASS: digital_assets has column extension PASS: digital_assets has column size PASS: digital_assets has column checksum PASS: digital_assets has column status PASS: digital_assets has column metadata PASS: digital_assets has column external_url PASS: digital_assets has column secret PASS: digital_assets has column sort_order PASS: digital_assets has column expires_at PASS: digital_assets has column created_at PASS: digital_assets has column updated_at PASS: digital_assets.path NULL PASS: digital_assets.display_name NULL PASS: digital_assets.extension NULL PASS: digital_assets.checksum NULL PASS: digital_assets.status NOT NULL PASS: digital_assets.metadata NULL PASS: digital_assets.external_url NULL PASS: digital_assets.secret NULL PASS: digital_assets.expires_at NULL PASS: digital_assets.original_name NOT NULL PASS: digital_assets.mime NOT NULL PASS: digital_assets.size NOT NULL PASS: digital_assets uuid unique index PASS: digital_assets product+sort index PASS: digital_assets product+status index PASS: digital_assets.product_id FK → products CASCADE PASS: digital_license_keys has column id PASS: digital_license_keys has column uuid PASS: digital_license_keys has column asset_id PASS: digital_license_keys has column encrypted_key PASS: digital_license_keys has column status PASS: digital_license_keys has column allocated_entitlement_id PASS: digital_license_keys has column assigned_at PASS: digital_license_keys has column revealed_at PASS: digital_license_keys has column consumed_at PASS: digital_license_keys has column revoked_at PASS: digital_license_keys has column created_at PASS: digital_license_keys has column updated_at PASS: digital_license_keys.encrypted_key NOT NULL PASS: digital_license_keys.allocated_entitlement_id NULL PASS: digital_license_keys.status NOT NULL PASS: license_keys uuid unique index PASS: license_keys asset+status composite index PASS: license_keys allocation index PASS: license_keys.asset_id FK → digital_assets CASCADE PASS: license_keys.allocated_entitlement_id FK SET NULL PASS: digital_entitlements has column id PASS: digital_entitlements has column uuid PASS: digital_entitlements has column order_id PASS: digital_entitlements has column order_product_id PASS: digital_entitlements has column user_id PASS: digital_entitlements has column status PASS: digital_entitlements has column delivered_at PASS: digital_entitlements has column download_limit PASS: digital_entitlements has column download_count PASS: digital_entitlements has column revoked_at PASS: digital_entitlements has column expires_at PASS: digital_entitlements.expires_at NULL PASS: new asset row defaults status=active PASS: new asset row keeps FILE default type ==== RESULT: 75/75 checks passed ====