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` = '<span id="docs-internal-guid-f3f6e5f2-7fff-fad6-c225-baa3513e76cb"><p dir="ltr" style="line-height:1.38;margin-top:12pt;margin-bottom:12pt;"><span style="font-size: 11pt; font-family: &quot;Roboto Slab&quot;, serif; background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; white-space-collapse: preserve;\">Dear [[customer_name]],</span></p><p dir="ltr" style="line-height:1.38;margin-top:12pt;margin-bottom:12pt;"><span style="font-size: 11pt; font-family: &quot;Roboto Slab&quot;, serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; white-space-collapse: preserve;\">Thank you for your order! We''re excited to let you know that your order #[[order_code]] has been confirmed.</span></p><p dir="ltr" style="line-height:1.38;margin-top:12pt;margin-bottom:12pt;"><span style="font-size: 11pt; font-family: &quot;Roboto Slab&quot;, serif; background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; white-space-collapse: preserve;\">Order Details:</span></p><ul style="margin-bottom: 0px; padding-inline-start: 48px;"><li dir="ltr" style="list-style-type: disc; font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; white-space: pre;" aria-level="1"><p dir="ltr" style="line-height:1.38;margin-top:12pt;margin-bottom:0pt;" role="presentation"><span style="font-size: 11pt; font-family: &quot;Roboto Slab&quot;, serif; background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; text-wrap: wrap;\">Order Code:</span><span style="font-size: 11pt; font-family: &quot;Roboto Slab&quot;, serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; text-wrap: wrap;\"> [[order_code]]</span></p></li><li dir="ltr" style="list-style-type: disc; font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; white-space: pre;" aria-level="1"><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt;" role="presentation"><span style="font-size: 11pt; font-family: &quot;Roboto Slab&quot;, serif; background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; text-wrap: wrap;\">Order Date:</span><span style="font-size: 11pt; font-family: &quot;Roboto Slab&quot;, serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; text-wrap: wrap;\"> [[order_date]]</span></p></li><li dir="ltr" style="list-style-type: disc; font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; white-space: pre;" aria-level="1"><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:12pt;" role="presentation"><span style="font-size: 11pt; font-family: &quot;Roboto Slab&quot;, serif; background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; text-wrap: wrap;\">Total Amount:</span><span style="font-size: 11pt; font-family: &quot;Roboto Slab&quot;, serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; text-wrap: wrap;\"> [[order_amount]]</span></p></li></ul>[[tracking_section]]<p dir="ltr" style="line-height:1.38;margin-top:12pt;margin-bottom:12pt;"><span style="font-size: 11pt; font-family: &quot;Roboto Slab&quot;, serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; white-space-collapse: preserve;\">You will receive another email when your order is picked up.&nbsp;</span></p><p dir="ltr" style="line-height:1.38;margin-top:12pt;margin-bottom:12pt;"><span style="font-size: 11pt; font-family: &quot;Roboto Slab&quot;, serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; white-space-collapse: preserve;\">If you have any questions or need further assistance, please don''t hesitate to contact us at </span><span style="font-family: Roboto, sans-serif; font-size: 14.6667px; white-space-collapse: preserve;\">[[admin_email]]</span><span style="background-color: transparent; font-family: &quot;Roboto Slab&quot;, serif; font-size: 11pt; white-space-collapse: preserve;\">.</span></p><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt;"><span style="font-size: 11pt; font-family: &quot;Roboto Slab&quot;, serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; white-space-collapse: preserve;\">Best regards,</span></p><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt;"><span style="font-size: 11pt; font-family: &quot;Roboto Slab&quot;, serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; white-space-collapse: preserve;\">The [[store_name]] Team</span></p><div><span style="font-size: 11pt; font-family: &quot;Roboto Slab&quot;, serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; white-space-collapse: preserve;\"><br></span></div></span>'
WHERE `identifier` = 'order_confirmed_email_to_customer';

UPDATE `email_templates` 
SET `default_text` = '<p dir="ltr" style="margin-top: 12pt; margin-bottom: 12pt; line-height: 1.38;"><span style="font-size: 11pt; font-family: &quot;Roboto Slab&quot;, serif; background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; white-space-collapse: preserve;\">Dear [[customer_name]],</span></p><p dir="ltr" style="margin-top: 12pt; margin-bottom: 12pt; line-height: 1.38;"><span style="font-size: 11pt; font-family: &quot;Roboto Slab&quot;, serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; white-space-collapse: preserve;\">Thank you for your order! We''re excited to let you know that your order #[[order_code]] has been picked up.</span></p><p dir="ltr" style="margin-top: 12pt; margin-bottom: 12pt; line-height: 1.38;"><span style="font-size: 11pt; font-family: &quot;Roboto Slab&quot;, serif; background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; white-space-collapse: preserve;\">Order Details:</span></p><ul style="margin-bottom: 0px; padding-inline-start: 48px;"><li dir="ltr" aria-level="1" style="list-style-type: disc; font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; white-space: pre;"><p dir="ltr" role="presentation" style="margin-top: 12pt; margin-bottom: 0pt; line-height: 1.38;"><span style="font-size: 11pt; font-family: &quot;Roboto Slab&quot;, serif; background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; text-wrap: wrap;\">Order Code:</span><span style="font-size: 11pt; font-family: &quot;Roboto Slab&quot;, serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; text-wrap: wrap;\"> [[order_code]]</span></p></li><li dir="ltr" aria-level="1" style="list-style-type: disc; font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; white-space: pre;"><p dir="ltr" role="presentation" style="margin-top: 0pt; margin-bottom: 0pt; line-height: 1.38;"><span style="font-size: 11pt; font-family: &quot;Roboto Slab&quot;, serif; background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; text-wrap: wrap;\">Order Date:</span><span style="font-size: 11pt; font-family: &quot;Roboto Slab&quot;, serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; text-wrap: wrap;\"> [[order_date]]</span></p></li><li dir="ltr" aria-level="1" style="list-style-type: disc; font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; white-space: pre;"><p dir="ltr" role="presentation" style="margin-top: 0pt; margin-bottom: 12pt; line-height: 1.38;"><span style="font-size: 11pt; font-family: &quot;Roboto Slab&quot;, serif; background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; text-wrap: wrap;\">Total Amount:</span><span style="font-size: 11pt; font-family: &quot;Roboto Slab&quot;, serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; text-wrap: wrap;\"> [[order_amount]]</span></p></li></ul>[[tracking_section]]<p dir="ltr" style="margin-top: 12pt; margin-bottom: 12pt; line-height: 1.38;"><span style="font-size: 11pt; font-family: &quot;Roboto Slab&quot;, serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; white-space-collapse: preserve;\">You will receive another email when your order is on the way.&nbsp;</span></p><p dir="ltr" style="margin-top: 12pt; margin-bottom: 12pt; line-height: 1.38;"><span style="font-size: 11pt; font-family: &quot;Roboto Slab&quot;, serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; white-space-collapse: preserve;\">If you have any questions or need further assistance, please don''t hesitate to contact us at </span><span style="font-family: Roboto, sans-serif; font-size: 14.6667px; white-space-collapse: preserve;\">[[admin_email]]</span><span style="background-color: transparent; font-family: &quot;Roboto Slab&quot;, serif; font-size: 11pt; white-space-collapse: preserve;\">.</span></p><p dir="ltr" style="margin-top: 0pt; margin-bottom: 0pt; line-height: 1.38;"><span style="font-size: 11pt; font-family: &quot;Roboto Slab&quot;, serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; white-space-collapse: preserve;\">Best regards,</span></p><p dir="ltr" style="margin-top: 0pt; margin-bottom: 0pt; line-height: 1.38;"><span style="font-size: 11pt; font-family: &quot;Roboto Slab&quot;, serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; white-space-collapse: preserve;\">The [[store_name]] Team</span></p><div><span style="font-size: 11pt; font-family: &quot;Roboto Slab&quot;, serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; white-space-collapse: preserve;\"><br></span></div>'
WHERE `identifier` = 'order_picked_up_email_to_customer';

UPDATE `email_templates` 
SET `default_text` = '<p dir="ltr" style="margin-top: 12pt; margin-bottom: 12pt; line-height: 1.38;"><span style="font-size: 11pt; font-family: &quot;Roboto Slab&quot;, serif; background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; white-space-collapse: preserve;\">Dear [[customer_name]],</span></p><p dir="ltr" style="margin-top: 12pt; margin-bottom: 12pt; line-height: 1.38;"><span style="font-size: 11pt; font-family: &quot;Roboto Slab&quot;, serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; white-space-collapse: preserve;\">Thank you for your order! We''re excited to let you know that your order #[[order_code]] is on the way.</span></p><p dir="ltr" style="margin-top: 12pt; margin-bottom: 12pt; line-height: 1.38;"><span style="font-size: 11pt; font-family: &quot;Roboto Slab&quot;, serif; background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; white-space-collapse: preserve;\">Order Details:</span></p><ul style="margin-bottom: 0px; padding-inline-start: 48px;"><li dir="ltr" aria-level="1" style="list-style-type: disc; font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; white-space: pre;"><p dir="ltr" role="presentation" style="margin-top: 12pt; margin-bottom: 0pt; line-height: 1.38;"><span style="font-size: 11pt; font-family: &quot;Roboto Slab&quot;, serif; background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; text-wrap: wrap;\">Order Code:</span><span style="font-size: 11pt; font-family: &quot;Roboto Slab&quot;, serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; text-wrap: wrap;\"> [[order_code]]</span></p></li><li dir="ltr" aria-level="1" style="list-style-type: disc; font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; white-space: pre;"><p dir="ltr" role="presentation" style="margin-top: 0pt; margin-bottom: 0pt; line-height: 1.38;"><span style="font-size: 11pt; font-family: &quot;Roboto Slab&quot;, serif; background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; text-wrap: wrap;\">Order Date:</span><span style="font-size: 11pt; font-family: &quot;Roboto Slab&quot;, serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; text-wrap: wrap;\"> [[order_date]]</span></p></li><li dir="ltr" aria-level="1" style="list-style-type: disc; font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; white-space: pre;"><p dir="ltr" role="presentation" style="margin-top: 0pt; margin-bottom: 12pt; line-height: 1.38;"><span style="font-size: 11pt; font-family: &quot;Roboto Slab&quot;, serif; background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; text-wrap: wrap;\">Total Amount:</span><span style="font-size: 11pt; font-family: &quot;Roboto Slab&quot;, serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; text-wrap: wrap;\"> [[order_amount]]</span></p></li></ul>[[tracking_section]]<p dir="ltr" style="margin-top: 12pt; margin-bottom: 12pt; line-height: 1.38;"><span style="font-size: 11pt; font-family: &quot;Roboto Slab&quot;, serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; white-space-collapse: preserve;\">You will receive another email when your order is delivered</span><span style="background-color: transparent; font-family: &quot;Roboto Slab&quot;, serif; font-size: 11pt; white-space-collapse: preserve;\">.&nbsp;</span></p><p dir="ltr" style="margin-top: 12pt; margin-bottom: 12pt; line-height: 1.38;"><span style="font-size: 11pt; font-family: &quot;Roboto Slab&quot;, serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; white-space-collapse: preserve;\">If you have any questions or need further assistance, please don''t hesitate to contact us at </span><span style="font-family: Roboto, sans-serif; font-size: 14.6667px; white-space-collapse: preserve;\">[[admin_email]]</span><span style="background-color: transparent; font-family: &quot;Roboto Slab&quot;, serif; font-size: 11pt; white-space-collapse: preserve;\">.</span></p><p dir="ltr" style="margin-top: 0pt; margin-bottom: 0pt; line-height: 1.38;"><span style="font-size: 11pt; font-family: &quot;Roboto Slab&quot;, serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; white-space-collapse: preserve;\">Best regards,</span></p><p dir="ltr" style="margin-top: 0pt; margin-bottom: 0pt; line-height: 1.38;"><span style="font-size: 11pt; font-family: &quot;Roboto Slab&quot;, serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; white-space-collapse: preserve;\">The [[store_name]] Team</span></p><div><span style="font-size: 11pt; font-family: &quot;Roboto Slab&quot;, serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; white-space-collapse: preserve;\"><br></span></div>'
WHERE `identifier` = 'order_on_the_way_email_to_customer';

UPDATE `email_templates` 
SET `default_text` = '<span id="docs-internal-guid-b907beb0-7fff-b0c4-dd7e-2bc83d56e3bd"><p dir="ltr" style="line-height:1.38;margin-top:12pt;margin-bottom:12pt;"><span style="font-size: 11pt; font-family: Roboto, sans-serif; background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; white-space-collapse: preserve;\">Dear [[customer_name]],</span></p><p dir="ltr" style="line-height:1.38;margin-top:12pt;margin-bottom:12pt;"><span style="font-size: 11pt; font-family: Roboto, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; white-space-collapse: preserve;\">We''re pleased to inform you that your order #[[order_code]] has been successfully delivered!</span></p><p dir="ltr" style="line-height:1.38;margin-top:12pt;margin-bottom:12pt;"><span style="font-size: 11pt; font-family: Roboto, sans-serif; background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; white-space-collapse: preserve;\">Order Details:</span></p><ul style="margin-bottom: 0px; padding-inline-start: 48px;"><li dir="ltr" style="list-style-type: disc; font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; white-space: pre;" aria-level="1"><p dir="ltr" style="line-height:1.38;margin-top:12pt;margin-bottom:0pt;" role="presentation"><span style="font-size: 11pt; font-family: Roboto, sans-serif; background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; text-wrap: wrap;\">Order Code:</span><span style="font-size: 11pt; font-family: Roboto, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; text-wrap: wrap;\"> [[order_code]]</span></p></li><li dir="ltr" style="list-style-type: disc; font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; white-space: pre;" aria-level="1"><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt;" role="presentation"><span style="font-size: 11pt; font-family: Roboto, sans-serif; background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; text-wrap: wrap;\">Order Date:</span><span style="font-size: 11pt; font-family: Roboto, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; text-wrap: wrap;\"> [[order_date]]</span></p></li><li dir="ltr" style="list-style-type: disc; font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; white-space: pre;" aria-level="1"><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt;" role="presentation"><span style="font-size: 11pt; font-family: Roboto, sans-serif; background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; text-wrap: wrap;\">Delivery Date:</span><span style="font-size: 11pt; font-family: Roboto, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; text-wrap: wrap;\"> [[delivery_date]]</span></p></li><li dir="ltr" style="list-style-type: disc; font-size: 11pt; font-family: Arial, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; white-space: pre;" aria-level="1"><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:12pt;" role="presentation"><span style="font-size: 11pt; font-family: Roboto, sans-serif; background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; text-wrap: wrap;\">Total Amount:</span><span style="font-size: 11pt; font-family: Roboto, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; text-wrap: wrap;\"> [[order_amount]]</span></p></li></ul>[[tracking_section]]<p dir="ltr" style="line-height:1.38;margin-top:12pt;margin-bottom:12pt;"><span style="font-size: 11pt; font-family: Roboto, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; white-space-collapse: preserve;\">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 </span><span style="font-family: Roboto, sans-serif; font-size: 14.6667px; white-space-collapse: preserve;\">[[admin_email]]</span><span style="background-color: transparent; font-family: Roboto, sans-serif; font-size: 11pt; white-space-collapse: preserve;\">.</span></p><p dir="ltr" style="line-height:1.38;margin-top:12pt;margin-bottom:12pt;"><span style="font-size: 11pt; font-family: Roboto, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; white-space-collapse: preserve;\">Thank you for shopping with us!</span></p><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt;"><span style="font-size: 11pt; font-family: Roboto, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; white-space-collapse: preserve;\">Best regards,</span></p><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt;"><span style="font-size: 11pt; font-family: Roboto, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; white-space-collapse: preserve;\">The [[store_name]] Team</span></p><div><span style="font-size: 11pt; font-family: Roboto, sans-serif; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-variant-position: normal; vertical-align: baseline; white-space-collapse: preserve;\"><br></span></div></span>'
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;