INSERT INTO `business_settings` (`type`, `value`) VALUES ( 'order_tracking', '{"enable_order_tracking":"1","name":"Ecommerce","moto":"Express Delivery"}' ), ( 'navbar_bg_color', '#00002E' ), ( 'navbar_text_color', 'white' ), ( 'enable_sub_footer', '1' ), ( 'enable_policy_section', '1' ), ( 'sub_footer_bg_color', '#f5f5f5' ), ( 'policy_section_bg_color', '#f5f5f5' ), ( 'sub_footer_text_color', 'black' ), ( 'policy_section_text_color', 'black' ), ( 'footer_element', '7' ), ( 'megamenu_element', '12' ), ( 'footer_bg_color', '#000000' ), ( 'footer_text_color', '#ffffff' ), ( 'enable_play_store_link', '1' ), ( 'enable_app_store_link', '1' ), ( 'enable_seller_app_link', '1' ), ( 'enable_delivery_app_link', '1' ), ( 'top_header_bg_color', '#ffffff' ), ( 'top_header_text_color', '#000000' ), ( 'search_bg_color', '#3490f3' ), ( 'search_text_color', '#ffffff' ); UPDATE orders SET tracking_code = CONCAT( 'TRK-', UPPER(SUBSTRING(REPLACE(UUID(), '-', ''), 1, 4)), RIGHT(UNIX_TIMESTAMP(), 5) ) WHERE tracking_code IS NULL OR tracking_code = ''; ALTER TABLE `orders` ADD COLUMN `delivery_status_update_datetime` VARCHAR(255) NULL AFTER `delivery_status`; UPDATE `business_settings` SET `value` = '11.0.0' WHERE `business_settings`.`type` = 'current_version'; UPDATE `email_templates` SET `default_text` = '

Dear [[customer_name]],

Thank you for your order! We''re excited to let you know that your order #[[order_code]] has been confirmed.

Order Details:

[[tracking_section]]

You will receive another email when your order is picked up. 

If you have any questions or need further assistance, please don''t hesitate to contact us at [[admin_email]].

Best regards,

The [[store_name]] Team


' WHERE `identifier` = 'order_confirmed_email_to_customer'; UPDATE `email_templates` SET `default_text` = '

Dear [[customer_name]],

Thank you for your order! We''re excited to let you know that your order #[[order_code]] has been picked up.

Order Details:

[[tracking_section]]

You will receive another email when your order is on the way. 

If you have any questions or need further assistance, please don''t hesitate to contact us at [[admin_email]].

Best regards,

The [[store_name]] Team


' WHERE `identifier` = 'order_picked_up_email_to_customer'; UPDATE `email_templates` SET `default_text` = '

Dear [[customer_name]],

Thank you for your order! We''re excited to let you know that your order #[[order_code]] is on the way.

Order Details:

[[tracking_section]]

You will receive another email when your order is delivered. 

If you have any questions or need further assistance, please don''t hesitate to contact us at [[admin_email]].

Best regards,

The [[store_name]] Team


' WHERE `identifier` = 'order_on_the_way_email_to_customer'; UPDATE `email_templates` SET `default_text` = '

Dear [[customer_name]],

We''re pleased to inform you that your order #[[order_code]] has been successfully delivered!

Order Details:

[[tracking_section]]

We hope you are satisfied with your purchase. If you have any questions or need further assistance, please don''t hesitate to reach out at [[admin_email]].

Thank you for shopping with us!

Best regards,

The [[store_name]] Team


' WHERE `identifier` = 'order_delivered_email_to_customer'; INSERT INTO `permissions` (`id`, `name`, `section`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'view_product_management_dashboard', 'product', 'web', current_timestamp(), current_timestamp()), (NULL, 'system_setup', 'website_setup', 'web', current_timestamp(), current_timestamp()), (NULL, 'logo_and_favicon', 'website_setup', 'web', current_timestamp(), current_timestamp()), (NULL, 'banners_and_sliders', 'website_setup', 'web', current_timestamp(), current_timestamp()), (NULL, 'can_manage_admin_panel', 'website_setup', 'web', current_timestamp(), current_timestamp()), (NULL, 'select_footer', 'website_setup', 'web', current_timestamp(), current_timestamp()), (NULL, 'select_megamenu', 'website_setup', 'web', current_timestamp(), current_timestamp()), (NULL, 'footer_setup', 'website_setup', 'web', current_timestamp(), current_timestamp()), (NULL, 'manage_custom_script', 'marketing_analytics', 'web', current_timestamp(), current_timestamp()), (NULL, 'manage_sitemap_generator', 'marketing_analytics', 'web', current_timestamp(), current_timestamp()), (NULL, 'manage_global_seo', 'marketing_analytics', 'web', current_timestamp(), current_timestamp()), (NULL, 'manage_marketing_dashboard', 'marketing', 'web', current_timestamp(), current_timestamp()), (NULL, 'manage_marketing_analytics_dashboard', 'marketing_analytics', 'web', current_timestamp(), current_timestamp()), (NULL, 'view_website_dashboard', 'website_setup', 'web', current_timestamp(), current_timestamp()); INSERT INTO `notification_types` (`id`, `user_type`, `type`, `name`, `image`, `default_text`, `status`, `addon`, `created_at`, `updated_at`) VALUES (NULL, 'customer', 'order_tracking', 'Order Tracking', NULL, 'Tracking code for order [[order_code]] is [[tracking_code]].', 1, NULL, CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP()); INSERT INTO `elements` (`id`, `name`, `created_at`, `updated_at`) VALUES (2, 'Footer', '2025-07-28 00:02:29', '2025-07-28 00:02:29'), (3, 'Megamenu', '2025-07-28 00:02:29', '2025-07-28 00:02:29'); INSERT INTO `element_types` (`id`, `element_id`, `name`, `is_default`, `created_at`, `updated_at`) VALUES (7, 2, 'Footer 1', 0, current_timestamp(), current_timestamp()), (8, 2, 'Footer 2', 0, current_timestamp(), current_timestamp()), (9, 2, 'Footer 3', 0, current_timestamp(), current_timestamp()), (10, 1, 'Header 7', 0, current_timestamp(), current_timestamp()), (11, 3, 'Megamenu 1', 0, current_timestamp(), current_timestamp()), (12, 3, 'Megamenu 2', 0, current_timestamp(), current_timestamp()); INSERT INTO `element_styles` (`id`, `element_type_id`, `name`, `value`, `created_at`, `updated_at`) VALUES (33, 7, 'footer_bg_color', '#000000', current_timestamp(), current_timestamp() ), (35, 7, 'footer_text_color', '#ffffff', current_timestamp(), current_timestamp() ), (36, 8, 'footer_bg_color', '#dc3545', current_timestamp(), current_timestamp() ), (38, 8, 'footer_text_color', '#ffffff', current_timestamp(), current_timestamp() ), (39, 9, 'footer_bg_color', '#ffffff', current_timestamp(), current_timestamp() ), (41, 9, 'footer_text_color', '#000000', current_timestamp(), current_timestamp() ), (42, 10, 'top_header_bg_color', '#ffffff', current_timestamp(), current_timestamp() ), (43, 10, 'top_header_text_color', '#000000', current_timestamp(), current_timestamp() ), (44, 10, 'search_bg_color', '#3490f3', current_timestamp(), current_timestamp() ), (45, 10, 'search_text_color', '#ffffff', current_timestamp(), current_timestamp() ); COMMIT;