
ALTER TABLE `admin_notifications` CHANGE `read_status` `is_read` TINYINT(1) NOT NULL DEFAULT '0';
ALTER TABLE `admin_notifications` ADD `user_id` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `id`;
ALTER TABLE `admin_password_resets` DROP `updated_at`;
ALTER TABLE `deposits` CHANGE `final_amo` `final_amount` DECIMAL(28,8) NOT NULL DEFAULT '0.00000000';
ALTER TABLE `deposits` CHANGE `btc_amo` `btc_amount` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;
ALTER TABLE `deposits` CHANGE `try` `payment_try` INT NOT NULL DEFAULT '0';
ALTER TABLE `deposits` ADD `success_url` VARCHAR(255) NULL DEFAULT NULL AFTER `admin_feedback`, ADD `failed_url` VARCHAR(255) NULL DEFAULT NULL AFTER `success_url`, ADD `last_cron` INT NOT NULL DEFAULT '0' AFTER `failed_url`;

RENAME TABLE `email_logs` TO `notification_logs`;
ALTER TABLE `notification_logs` ADD `user_id` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `id`;
ALTER TABLE `notification_logs` CHANGE `mail_sender` `sender` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;
ALTER TABLE `notification_logs` CHANGE `email_from` `sent_from` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;
ALTER TABLE `notification_logs` CHANGE `email_to` `sent_to` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;
ALTER TABLE `notification_logs` ADD `notification_type` VARCHAR(40) NULL DEFAULT NULL AFTER `message`;

RENAME TABLE `email_sms_templates` TO `notification_templates`;
ALTER TABLE `notification_templates` CHANGE `subj` `subject` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
ALTER TABLE `notification_templates` ADD `push_title` VARCHAR(255) NULL DEFAULT NULL AFTER `subject`;
ALTER TABLE `notification_templates` ADD `push_body` TEXT NULL DEFAULT NULL AFTER `sms_body`;
ALTER TABLE `notification_templates` ADD `email_sent_from_name` VARCHAR(40) NULL DEFAULT NULL AFTER `email_status`, ADD `email_sent_from_address` VARCHAR(40) NULL DEFAULT NULL AFTER `email_sent_from_name`;
ALTER TABLE `notification_templates` ADD `sms_sent_from` VARCHAR(40) NULL DEFAULT NULL AFTER `sms_status`, ADD `push_status` TINYINT(1) NOT NULL DEFAULT '0' AFTER `sms_sent_from`;
ALTER TABLE `notification_templates` CHANGE `act` `act` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;
ALTER TABLE `notification_templates` CHANGE `name` `name` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;
ALTER TABLE `notification_templates` CHANGE `subject` `subject` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;
ALTER TABLE `notification_templates` CHANGE `shortcodes` `shortcodes` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;
ALTER TABLE `extensions` DROP `deleted_at`;

START TRANSACTION;

CREATE TABLE `forms` (
  `id` bigint UNSIGNED NOT NULL,
  `act` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `form_data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

ALTER TABLE `forms`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `forms`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
COMMIT;

ALTER TABLE `frontends` ADD `seo_content` LONGTEXT NULL DEFAULT NULL AFTER `data_values`, ADD `tempname` VARCHAR(40) NULL DEFAULT NULL AFTER `seo_content`, ADD `slug` VARCHAR(255) NULL DEFAULT NULL AFTER `tempname`;

ALTER TABLE `gateways` DROP `input_form`;
ALTER TABLE `gateways` ADD `form_id` INT NOT NULL DEFAULT '0' AFTER `id`;
ALTER TABLE `gateway_currencies` DROP `image`;
ALTER TABLE `general_settings` CHANGE `sitename` `site_name` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;
ALTER TABLE `general_settings` ADD `email_from_name` VARCHAR(40) NULL DEFAULT NULL AFTER `email_from`;
ALTER TABLE `general_settings` ADD `sms_template` VARCHAR(255) NULL DEFAULT NULL AFTER `email_template`, ADD `sms_from` VARCHAR(255) NULL DEFAULT NULL AFTER `sms_template`;
ALTER TABLE `general_settings` ADD `global_shortcodes` TEXT NULL DEFAULT NULL AFTER `sms_config`;
ALTER TABLE `general_settings` DROP `ev`;
ALTER TABLE `general_settings` DROP `sv`;

ALTER TABLE `general_settings` ADD `maintenance_mode` TINYINT(1) NOT NULL DEFAULT '0' AFTER `force_ssl`, ADD `multi_language` TINYINT(1) NOT NULL DEFAULT '1' AFTER `maintenance_mode`;
ALTER TABLE `general_settings` CHANGE `sys_version` `available_version` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;
ALTER TABLE `general_settings` ADD `system_customized` TINYINT(1) NOT NULL DEFAULT '0' AFTER `available_version`, ADD `paginate_number` INT NOT NULL DEFAULT '1' AFTER `system_customized`, ADD `currency_format` TINYINT NOT NULL DEFAULT '1' COMMENT ' 1=>Both 2=>Text Only 3=>Symbol Only ' AFTER `paginate_number`;

ALTER TABLE `general_settings` DROP `shipping`;
ALTER TABLE `general_settings` DROP `sms_api`;

ALTER TABLE `invoices` CHANGE `track_id` `track_id` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;
ALTER TABLE `invoices` CHANGE `price` `price` DECIMAL(28,8) NOT NULL DEFAULT '0';
ALTER TABLE `invoices` CHANGE `discount` `discount` DECIMAL(28,8) NOT NULL DEFAULT '0';
ALTER TABLE `invoices` CHANGE `charge` `charge` DECIMAL(28,8) NOT NULL DEFAULT '0';
ALTER TABLE `invoices` CHANGE `final_price` `final_price` DECIMAL(28,8) NOT NULL DEFAULT '0';
ALTER TABLE `invoices` CHANGE `status` `status` TINYINT NOT NULL DEFAULT '0' COMMENT '0=>Data Inserted, 1=>Pending, 2=>Processing, 3=>Shipping, 4=>Delivered, 5=>Payment Pending, 6=>Rejected\r\n';
ALTER TABLE `invoices` CHANGE `shipping_address` `shipping_address` LONGTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;
ALTER TABLE `invoices` CHANGE `phone` `phone` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;
ALTER TABLE `languages` DROP `text_align`;
ALTER TABLE `languages` CHANGE `icon` `image` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;

ALTER TABLE `languages` CHANGE `is_default` `is_default` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '0: not default language, 1: default language' AFTER `code`, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL AFTER `is_default`;

ALTER TABLE `orders` CHANGE `invoice_id` `invoice_id` INT UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `orders` CHANGE `qty` `qty` INT NOT NULL DEFAULT '0';
ALTER TABLE `orders` CHANGE `size` `size` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;
ALTER TABLE `orders` CHANGE `color` `color` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;

ALTER TABLE `pages` ADD `seo_content` TEXT NULL DEFAULT NULL AFTER `secs`;

ALTER TABLE `products` CHANGE `name` `name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;
ALTER TABLE `products` CHANGE `size` `size` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;
ALTER TABLE `products` CHANGE `color` `color` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;
ALTER TABLE `products` CHANGE `short_description` `short_description` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;
ALTER TABLE `products` CHANGE `description` `description` LONGTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;
ALTER TABLE `products` CHANGE `price` `price` DECIMAL(28,8) NOT NULL DEFAULT '0';
ALTER TABLE `products` CHANGE `status` `status` TINYINT NOT NULL DEFAULT '1';

ALTER TABLE `product_images` CHANGE `image` `image` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;

ALTER TABLE `reviews` CHANGE `name` `name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;
ALTER TABLE `reviews` CHANGE `rating` `rating` TINYINT NOT NULL DEFAULT '0';
ALTER TABLE `reviews` CHANGE `remark` `remark` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;

ALTER TABLE `support_attachments` CHANGE `support_message_id` `support_message_id` INT UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `support_attachments` CHANGE `attachment` `attachment` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;
ALTER TABLE `support_messages` CHANGE `message` `message` LONGTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;

ALTER TABLE `support_tickets` DROP `phone`;

ALTER TABLE `tracks` CHANGE `invoice_id` `invoice_id` INT UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `tracks` CHANGE `info` `info` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;

ALTER TABLE `admins` CHANGE `name` `name` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;
ALTER TABLE `admins` CHANGE `email` `email` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;
ALTER TABLE `admins` CHANGE `username` `username` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;

ALTER TABLE `admin_password_resets` CHANGE `email` `email` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;
ALTER TABLE `admin_password_resets` CHANGE `token` `token` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;

ALTER TABLE `carts` CHANGE `unique_id` `unique_id` INT UNSIGNED NULL DEFAULT NULL;

ALTER TABLE `coupons` CHANGE `name` `name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;
ALTER TABLE `coupons` CHANGE `code` `code` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;
ALTER TABLE `coupons` CHANGE `type` `type` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;
ALTER TABLE `coupons` CHANGE `discount` `discount` DECIMAL(28,8) NOT NULL DEFAULT '0';
ALTER TABLE `coupons` CHANGE `min_order_amount` `min_order_amount` DECIMAL(28,8) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `coupons` CHANGE `status` `status` TINYINT NOT NULL DEFAULT '0';
ALTER TABLE `deposits` CHANGE `method_currency` `method_currency` VARCHAR(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;

START TRANSACTION;

CREATE TABLE `update_logs` (
  `id` bigint UNSIGNED NOT NULL,
  `version` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `update_log` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

ALTER TABLE `update_logs`
  ADD PRIMARY KEY (`id`);
  
  ALTER TABLE `update_logs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
COMMIT;

UPDATE frontends
SET slug = LOWER(REPLACE(REPLACE(REPLACE(
    JSON_UNQUOTE(JSON_EXTRACT(data_values, '$.title')), ' ', '-'), ',', ''), '.', ''))
WHERE data_keys = 'blog.element';
UPDATE frontends
SET slug = LOWER(REPLACE(REPLACE(REPLACE(
    JSON_UNQUOTE(JSON_EXTRACT(data_values, '$.title')), ' ', '-'), ',', ''), '.', ''))
WHERE data_keys = 'policy_pages.element';

UPDATE `pages` SET `slug` = '/' WHERE `pages`.`id` = 1;
UPDATE frontends SET tempname = (SELECT active_template FROM general_settings WHERE id = 1);

UPDATE `pages` SET `slug` = 'blog' WHERE `pages`.`slug` = 'blogs';

UPDATE `general_settings` SET `global_shortcodes` = '{\n \"site_name\":\"Name of your site\",\n \"site_currency\":\"Currency of your site\",\n \"currency_symbol\":\"Symbol of currency\"\n}' WHERE `general_settings`.`id` = 1;

ALTER TABLE `invoices` ADD `delivered_at` DATETIME NULL DEFAULT NULL AFTER `created_at`;

ALTER TABLE `support_messages` CHANGE `supportticket_id` `support_ticket_id` INT UNSIGNED NOT NULL DEFAULT '0';

TRUNCATE notification_templates;


INSERT INTO `notification_templates` (`id`, `act`, `name`, `subject`, `push_title`, `email_body`, `sms_body`, `push_body`, `shortcodes`, `email_status`, `email_sent_from_name`, `email_sent_from_address`, `sms_status`, `sms_sent_from`, `push_status`, `created_at`, `updated_at`) VALUES
(1, 'PAYMENT_REQUEST', 'Manual Payment - Requested', 'Payment Request Submitted Successfully', NULL, '<div style=\"font-family: Montserrat, sans-serif;\">Your payment request of&nbsp;<span style=\"font-weight: bolder;\">{{amount}} {{site_currency}}</span>&nbsp;is via&nbsp;&nbsp;<span style=\"font-weight: bolder;\">{{method_name}}&nbsp;</span>submitted successfully<span style=\"font-weight: bolder;\">&nbsp;.<br></span></div><div style=\"font-family: Montserrat, sans-serif;\"><span style=\"font-weight: bolder;\"><br></span></div><div style=\"\"><div style=\"font-family: Montserrat, sans-serif;\"><span style=\"font-weight: bolder;\">Details of your Payment:<br></span></div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\">Amount : {{amount}} {{site_currency}}</div><div style=\"\"><font face=\"Montserrat, sans-serif\">Charge:&nbsp;</font><font color=\"#FF0000\" style=\"font-family: Montserrat, sans-serif;\">{{charge}}&nbsp;</font><span style=\"background-color: var(--bs-card-bg); text-align: var(--bs-body-text-align);\"><font color=\"#ff0000\" face=\"Montserrat, sans-serif\">{{site_currency}}</font></span></div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\">Conversion Rate : 1 {{site_currency}} = {{rate}} {{method_currency}}</div><div style=\"font-family: Montserrat, sans-serif;\">Payable : {{method_amount}} {{method_currency}}<br></div><div style=\"font-family: Montserrat, sans-serif;\">Pay via :&nbsp; {{method_name}}</div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\">Transaction Number : {{trx}}</div><div style=\"font-family: Montserrat, sans-serif;\">Ordered At:&nbsp;{{ordered_at}}</div><div style=\"font-family: Montserrat, sans-serif;\">{{track}}</div></div>', NULL, NULL, '{\r\n    \"trx\": \"Transaction Number\",\r\n    \"amount\": \"Request Amount By user\",\r\n    \"charge\": \"Gateway Charge\",\r\n    \"rate\": \"Conversion Rate\",\r\n    \"method_name\": \"Payment Method Name\",\r\n    \"method_currency\": \"Payment Method Currency\",\r\n    \"method_amount\": \"Payment Method Amount After Conversion\",\r\n    \"discount\": \"Discount Amount\",\r\n    \"ordered_at\": \"Order Date\",\r\n    \"track\": \"Tracking ID\"\r\n}', 1, '{{site_name}} Billing', NULL, 1, NULL, 0, NULL, '2024-07-03 01:25:51'),
(2, 'PAYMENT_COMPLETE', 'Payment Completed', 'Payment Completed Successfully', 'Payment Completed Successfully', '<div style=\"font-family: Montserrat, sans-serif;\">Your payment of&nbsp;<span style=\"font-weight: bolder;\">{{amount}} {{site_currency}}</span>&nbsp;is via&nbsp;&nbsp;<span style=\"font-weight: bolder;\">{{method_name}}&nbsp;</span>has been completed Successfully.<span style=\"font-weight: bolder;\"><br></span></div><div style=\"font-family: Montserrat, sans-serif;\"><span style=\"font-weight: bolder;\"><br></span></div><div style=\"font-family: Montserrat, sans-serif;\"><span style=\"font-weight: bolder;\">Details of your Payment:<br></span></div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\">Amount : {{amount}} {{site_currency}}</div><div style=\"\"><font face=\"Montserrat, sans-serif\">Charge:&nbsp;</font><font color=\"#000000\" style=\"font-family: Montserrat, sans-serif;\">{{charge}}&nbsp;</font><span style=\"background-color: var(--bs-card-bg); text-align: var(--bs-body-text-align);\"><font color=\"#000000\" face=\"Montserrat, sans-serif\">{{site_currency}}</font></span></div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\">Conversion Rate : 1 {{site_currency}} = {{rate}} {{method_currency}}</div><div style=\"font-family: Montserrat, sans-serif;\">Payable : {{method_amount}} {{method_currency}}<br></div><div style=\"font-family: Montserrat, sans-serif;\">Paid via :&nbsp; {{method_name}}</div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\">Transaction Number : {{trx}}</div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\"><span style=\"color: rgb(33, 37, 41); font-weight: bolder;\">Tracking ID:{{track}}</span></div>', 'Your payment of {{amount}} {{site_currency}} is via  {{method_name}} has been completed Successfully.\r\n\r\nDetails of your Payment:\r\n\r\nAmount : {{amount}} {{site_currency}}\r\nCharge: {{charge}} {{site_currency}}\r\n\r\nConversion Rate : 1 {{currency}} = {{rate}} {{method_currency}}\r\nPayable : {{method_amount}} {{method_currency}}\r\nPaid via :  {{method_name}}\r\n\r\nTransaction Number : {{trx}}\r\n\r\nTracking ID:{{track}}', NULL, '{\r\n    \"trx\": \"Transaction Number\",\r\n    \"amount\": \"Order Amount\",\r\n    \"charge\": \"Gateway Charge\",\r\n    \"rate\": \"Conversion Rate\",\r\n    \"method_name\": \"Payment Method Name\",\r\n    \"method_currency\": \"Payment Method Currency\",\r\n    \"method_amount\": \"Payment Method Amount After Conversion\",\r\n    \"discount\": \"Discount Amount\",\r\n    \"ordered_at\": \"Order Date\",\r\n    \"track\": \"Tracking ID\"\r\n}', 1, '{{site_name}} Billing', NULL, 1, 'Payment Completed Successfully', 0, NULL, '2024-07-03 01:15:38'),
(3, 'PAYMENT_APPROVE', 'Payment - Manual - Approved', 'Payment Request Approved', '{{site_name}} - Deposit Request Approved', '<div style=\"font-family: Montserrat, sans-serif;\">Your payment of&nbsp;<span style=\"font-weight: bolder;\">{{amount}} {{site_currency}}</span>&nbsp;is via&nbsp;&nbsp;<span style=\"font-weight: bolder;\">{{method_name}}&nbsp;</span>has been approved Successfully.<span style=\"font-weight: bolder;\"><br></span></div><div style=\"font-family: Montserrat, sans-serif;\"><span style=\"font-weight: bolder;\"><br></span></div><div style=\"font-family: Montserrat, sans-serif;\"><span style=\"font-weight: bolder;\">Details of your Payment:<br></span></div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\">Amount : {{amount}} {{site_currency}}</div><div style=\"\"><font face=\"Montserrat, sans-serif\">Charge:&nbsp;</font><font color=\"#000000\" style=\"font-family: Montserrat, sans-serif;\">{{charge}}&nbsp;</font><span style=\"background-color: var(--bs-card-bg); text-align: var(--bs-body-text-align);\"><font color=\"#000000\" face=\"Montserrat, sans-serif\">{{site_currency}}</font></span></div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\">Conversion Rate : 1 {{site_currency}} = {{rate}} {{method_currency}}</div><div style=\"font-family: Montserrat, sans-serif;\">Payable : {{method_amount}} {{method_currency}}<br></div><div style=\"font-family: Montserrat, sans-serif;\">Paid via :&nbsp; {{method_name}}</div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\">Transaction Number : {{trx}}</div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\"><span style=\"color: rgb(33, 37, 41); font-weight: bolder;\">Tracking ID:{{track}}</span><br></div>', 'We are pleased to inform you that your deposit request of {{amount}} {{site_currency}} via {{method_name}} has been approved.', 'Deposit of {{amount}} {{site_currency}} via {{method_name}} has been approved.', '{\r\n    \"trx\": \"Transaction Number\",\r\n    \"amount\": \"Order Amount\",\r\n    \"charge\": \"Gateway Charge\",\r\n    \"rate\": \"Conversion Rate\",\r\n    \"method_name\": \"Payment Method Name\",\r\n    \"method_currency\": \"Payment Method Currency\",\r\n    \"method_amount\": \"Payment Method Amount After Conversion\",\r\n    \"discount\": \"Discount Amount\",\r\n    \"ordered_at\": \"Order Date\",\r\n    \"track\": \"Tracking ID\"\r\n}', 1, '{{site_name}} Billing', NULL, 1, NULL, 0, '2021-11-03 12:00:00', '2024-07-03 02:25:21'),
(4, 'PAYMENT_REJECT', 'Payment - Manual - Rejected', 'Payment Request Rejected', '{{site_name}} - Pyment Request Rejected', '<div style=\"font-family: Montserrat, sans-serif;\">Your payment request of&nbsp;<span style=\"font-weight: bolder;\">{{amount}} {{site_currency}}</span>&nbsp;is via&nbsp;&nbsp;<span style=\"font-weight: bolder;\">{{method_name}} has been rejected</span>.<span style=\"font-weight: bolder;\"><br></span></div><br style=\"font-family: Montserrat, sans-serif;\"><div style=\"font-family: Montserrat, sans-serif;\">Transaction Number was : {{trx}}</div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><font color=\"#212529\" face=\"Montserrat, sans-serif\">{{rejection_reason}}</font><br><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\">Tracking Id {{track}}</div><div style=\"font-family: Montserrat, sans-serif;\"><span style=\"color: rgb(33, 37, 41);\">if you have any query, feel free to contact us.</span><br></div>', 'We regret to inform you that your deposit request of {{amount}} {{site_currency}} via {{method_name}} has been rejected.', 'Your deposit request of {{amount}} {{site_currency}} via {{method_name}} has been rejected.', '{\r\n    \"trx\": \"Transaction Number\",\r\n    \"amount\": \"Request Amount By user\",\r\n    \"charge\": \"Gateway Charge\",\r\n    \"rate\": \"Conversion Rate\",\r\n    \"method_name\": \"Payment Method Name\",\r\n    \"method_currency\": \"Payment Method Currency\",\r\n    \"method_amount\": \"Payment Method Amount After Conversion\",\r\n    \"ordered_at\": \"Order Date\",\r\n    \"track\": \"Tracking ID\",\r\n   \"rejection_reason\":\"Rejection Reason\"\r\n}', 1, '{{site_name}} Billing', NULL, 1, NULL, 0, '2021-11-03 12:00:00', '2024-07-03 00:30:01'),
(5, 'PASS_RESET_CODE', 'Password - Reset - Code', 'Password Reset', '{{site_name}} Password Reset Code', '<div>We\'ve received a request to reset the password for your account on <b>{{time}}</b>. The request originated from\r\n            the following IP address: <b>{{ip}}</b>, using <b>{{browser}}</b> on <b>{{operating_system}}</b>.\r\n    </div><br>\r\n    <div><span>To proceed with the password reset, please use the following account recovery code</span>: <span><b><font size=\"6\">{{code}}</font></b></span></div><br>\r\n    <div><span>If you did not initiate this password reset request, please disregard this message. Your account security\r\n            remains our top priority, and we advise you to take appropriate action if you suspect any unauthorized\r\n            access to your account.</span></div>', 'To proceed with the password reset, please use the following account recovery code: {{code}}', 'To proceed with the password reset, please use the following account recovery code: {{code}}', '{\"code\":\"Verification code for password reset\",\"ip\":\"IP address of the user\",\"browser\":\"Browser of the user\",\"operating_system\":\"Operating system of the user\",\"time\":\"Time of the request\"}', 1, '{{site_name}} Authentication Center', NULL, 0, NULL, 0, '2021-11-03 12:00:00', '2024-05-08 07:24:57'),
(6, 'PASS_RESET_DONE', 'Password - Reset - Confirmation', 'Password Reset Successful', NULL, '<div><div><span>We are writing to inform you that the password reset for your account was successful. This action was completed at {{time}} from the following browser</span>: <span>{{browser}}</span><span>on {{operating_system}}, with the IP address</span>: <span>{{ip}}</span>.</div><br><div><span>Your account security is our utmost priority, and we are committed to ensuring the safety of your information. If you did not initiate this password reset or notice any suspicious activity on your account, please contact our support team immediately for further assistance.</span></div></div>', 'We are writing to inform you that the password reset for your account was successful.', 'We are writing to inform you that the password reset for your account was successful.', '{\"ip\":\"IP address of the user\",\"browser\":\"Browser of the user\",\"operating_system\":\"Operating system of the user\",\"time\":\"Time of the request\"}', 1, '{{site_name}} Authentication Center', NULL, 1, NULL, 0, '2021-11-03 12:00:00', '2024-04-25 03:27:24'),
(7, 'ADMIN_SUPPORT_REPLY', 'Support - Reply', 'Re: {{ticket_subject}} - Ticket #{{ticket_id}}', '{{site_name}} - Support Ticket Replied', '<div>\r\n    <div><span>Thank you for reaching out to us regarding your support ticket with the subject</span>:\r\n        <span>\"{{ticket_subject}}\"&nbsp;</span><span>and ticket ID</span>: {{ticket_id}}.</div><br>\r\n    <div><span>We have carefully reviewed your inquiry, and we are pleased to provide you with the following\r\n            response</span><span>:</span></div><br>\r\n    <div>{{reply}}</div><br>\r\n    <div><span>If you have any further questions or need additional assistance, please feel free to reply by clicking on\r\n            the following link</span>: <a href=\"{{link}}\" title=\"\" target=\"_blank\">{{link}}</a><span>. This link will take you to\r\n            the ticket thread where you can provide further information or ask for clarification.</span></div><br>\r\n    <div><span>Thank you for your patience and cooperation as we worked to address your concerns.</span></div>\r\n</div>', 'Thank you for reaching out to us regarding your support ticket with the subject: \"{{ticket_subject}}\" and ticket ID: {{ticket_id}}. We have carefully reviewed your inquiry. To check the response, please go to the following link: {{link}}', 'Re: {{ticket_subject}} - Ticket #{{ticket_id}}', '{\"ticket_id\":\"ID of the support ticket\",\"ticket_subject\":\"Subject  of the support ticket\",\"reply\":\"Reply made by the admin\",\"link\":\"URL to view the support ticket\"}', 1, '{{site_name}} Support Team', NULL, 1, NULL, 0, '2021-11-03 12:00:00', '2024-05-08 07:26:06'),
(8, 'DEFAULT', 'Default Template', '{{subject}}', '{{subject}}', '{{message}}', '{{message}}', '{{message}}', '{\"subject\":\"Subject\",\"message\":\"Message\"}', 1, NULL, NULL, 1, NULL, 0, '2019-09-14 13:14:22', '2024-05-08 07:18:21'),
(9, 'ORDER_DELIVERED', 'Order Completed- Successful', 'Order Completed Successfully', NULL, '<div style=\"font-family: Montserrat, sans-serif;\">Your order #{{track}} of amount&nbsp;{{amount}}&nbsp;{{site_currency}} &nbsp;has been delivered successfully.<br><br></div><div style=\"font-family: Montserrat, sans-serif;\">Shipping Address:&nbsp;&nbsp;{{shipping_address}}.</div><div style=\"font-family: Montserrat, sans-serif;\"><br></div><div style=\"font-family: Montserrat, sans-serif;\">Order tracking Number:&nbsp;{{track}}</div><div style=\"font-family: Montserrat, sans-serif;\">Ordered At:&nbsp;{{ordered_at}}</div><div style=\"font-family: Montserrat, sans-serif;\">Delivered At:&nbsp;{{delivered_at}}</div>', 'Your order #{{track}} of amount {{amount}} {{site_currency}}  has been delivered successfully.\r\n\r\nShipping Address:  {{shipping_address}}.\r\n\r\nOrder tracking Number: {{track}}\r\nOrdered At: {{ordered_at}}\r\nDelivered At: {{delivered_at}}', NULL, '{\r\n    \"amount\": \"Total Amount\",\r\n    \"ordered_at\": \"Ordered At\",\r\n    \"delivered_at\": \"Delivered At\",\r\n    \"track\": \"Tracking ID\",\r\n    \"shipping_address\": \"Shipping Address\"\r\n}', 1, NULL, NULL, 0, NULL, 0, NULL, '2024-07-03 00:24:41');



UPDATE `general_settings` SET `sms_config` = '{\"name\":\"nexmo\",\"clickatell\":{\"api_key\":\"----------------\"},\"infobip\":{\"username\":\"------------8888888\",\"password\":\"-----------------\"},\"message_bird\":{\"api_key\":\"-------------------\"},\"nexmo\":{\"api_key\":\"----------------------\",\"api_secret\":\"----------------------\"},\"sms_broadcast\":{\"username\":\"----------------------\",\"password\":\"-----------------------------\"},\"twilio\":{\"account_sid\":\"-----------------------\",\"auth_token\":\"---------------------------\",\"from\":\"----------------------\"},\"text_magic\":{\"username\":\"-----------------------\",\"apiv2_key\":\"-------------------------------\"},\"custom\":{\"method\":\"get\",\"url\":\"https:\\/\\/hostname\\/demo-api-v1\",\"headers\":{\"name\":[\"api_key\"],\"value\":[\"test_api 555\"]},\"body\":{\"name\":
[\"from_number\"],\"value\":[\"5657545757\"]}}}' WHERE `general_settings`.`id` = 1;


UPDATE `extensions` SET `script` = '<script async src=\"https://www.googletagmanager.com/gtag/js?id={{measurement_id}}\"></script>\n                <script>\n                  window.dataLayer = window.dataLayer || [];\n                  function gtag(){dataLayer.push(arguments);}\n                  gtag(\"js\", new Date());\n                \n                  gtag(\"config\", \"{{measurement_id}}\");\n                </script>' WHERE `extensions`.`act` = 'google-analytics';

UPDATE `extensions` SET `shortcode` = '{\"measurement_id\":{\"title\":\"Measurement ID\",\"value\":\"------\"}}' WHERE `extensions`.`act` = 'google-analytics';

DELETE FROM gateways WHERE `gateways`.`id` = 8;
DELETE FROM `gateway_currencies` WHERE `gateway_currencies`.`method_code` = 108;

INSERT INTO
  `gateways` (
    `form_id`,
    `code`,
    `name`,
    `alias`,
    `image`,
    `status`,
    `gateway_parameters`,
    `supported_currencies`,
    `crypto`,
    `extra`,
    `description`,
    `created_at`,
    `updated_at`
  )
VALUES
  (
    0,
    120,
    'Authorize.net',
    'Authorize',
    '663a35b9ca5991715090873.png',
    1,
    '{\"login_id\":{\"title\":\"Login ID\",\"global\":true,\"value\":\"59e4P9DBcZv\"},\"transaction_key\":{\"title\":\"Transaction Key\",\"global\":true,\"value\":\"47x47TJyLw2E7DbR\"}}',
    '{\"USD\":\"USD\",\"CAD\":\"CAD\",\"CHF\":\"CHF\",\"DKK\":\"DKK\",\"EUR\":\"EUR\",\"GBP\":\"GBP\",\"NOK\":\"NOK\",\"PLN\":\"PLN\",\"SEK\":\"SEK\",\"AUD\":\"AUD\",\"NZD\":\"NZD\"}',
    0,
    NULL,
    NULL,
    NULL,
    '2024-05-07 08:07:53'
  ),
  (
    0,
    121,
    'NMI',
    'NMI',
    '663a3897754cf1715091607.png',
    1,
    '{\"api_key\":{\"title\":\"API Key\",\"global\":true,\"value\":\"2F822Rw39fx762MaV7Yy86jXGTC7sCDy\"}}',
    '{\"AED\":\"AED\",\"ARS\":\"ARS\",\"AUD\":\"AUD\",\"BOB\":\"BOB\",\"BRL\":\"BRL\",\"CAD\":\"CAD\",\"CHF\":\"CHF\",\"CLP\":\"CLP\",\"CNY\":\"CNY\",\"COP\":\"COP\",\"DKK\":\"DKK\",\"EUR\":\"EUR\",\"GBP\":\"GBP\",\"HKD\":\"HKD\",\"IDR\":\"IDR\",\"ILS\":\"ILS\",\"INR\":\"INR\",\"JPY\":\"JPY\",\"KRW\":\"KRW\",\"MXN\":\"MXN\",\"MYR\":\"MYR\",\"NOK\":\"NOK\",\"NZD\":\"NZD\",\"PEN\":\"PEN\",\"PHP\":\"PHP\",\"PLN\":\"PLN\",\"PYG\":\"PYG\",\"RUB\":\"RUB\",\"SEC\":\"SEC\",\"SGD\":\"SGD\",\"THB\":\"THB\",\"TRY\":\"TRY\",\"TWD\":\"TWD\",\"USD\":\"USD\",\"ZAR\":\"ZAR\"}',
    0,
    NULL,
    NULL,
    NULL,
    '2024-05-07 08:20:07'
  ),
  (
    0,
    507,
    'BTCPay',
    'BTCPay',
    '663a35cd25a8d1715090893.png',
    1,
    '{\"store_id\":{\"title\":\"Store Id\",\"global\":true,\"value\":\"HsqFVTXSeUFJu7caoYZc3CTnP8g5LErVdHhEXPVTheHf\"},\"api_key\":{\"title\":\"Api Key\",\"global\":true,\"value\":\"4436bd706f99efae69305e7c4eff4780de1335ce\"},\"server_name\":{\"title\":\"Server Name\",\"global\":true,\"value\":\"https:\\/\\/testnet.demo.btcpayserver.org\"},\"secret_code\":{\"title\":\"Secret Code\",\"global\":true,\"value\":\"SUCdqPn9CDkY7RmJHfpQVHP2Lf2\"}}',
    '{\"BTC\":\"Bitcoin\",\"LTC\":\"Litecoin\"}',
    1,
    '{\"webhook\":{\"title\": \"IPN URL\",\"value\":\"ipn.BTCPay\"}}',
    NULL,
    NULL,
    '2024-05-07 08:08:13'
  ),
  (
    0,
    508,
    'Now payments hosted',
    'NowPaymentsHosted',
    '663a38b8d57a81715091640.png',
    1,
    '{\"api_key\":{\"title\":\"API Key\",\"global\":true,\"value\":\"--------\"},\"secret_key\":{\"title\":\"Secret Key\",\"global\":true,\"value\":\"------------\"}}',
    '{\"BTG\":\"BTG\",\"ETH\":\"ETH\",\"XMR\":\"XMR\",\"ZEC\":\"ZEC\",\"XVG\":\"XVG\",\"ADA\":\"ADA\",\"LTC\":\"LTC\",\"BCH\":\"BCH\",\"QTUM\":\"QTUM\",\"DASH\":\"DASH\",\"XLM\":\"XLM\",\"XRP\":\"XRP\",\"XEM\":\"XEM\",\"DGB\":\"DGB\",\"LSK\":\"LSK\",\"DOGE\":\"DOGE\",\"TRX\":\"TRX\",\"KMD\":\"KMD\",\"REP\":\"REP\",\"BAT\":\"BAT\",\"ARK\":\"ARK\",\"WAVES\":\"WAVES\",\"BNB\":\"BNB\",\"XZC\":\"XZC\",\"NANO\":\"NANO\",\"TUSD\":\"TUSD\",\"VET\":\"VET\",\"ZEN\":\"ZEN\",\"GRS\":\"GRS\",\"FUN\":\"FUN\",\"NEO\":\"NEO\",\"GAS\":\"GAS\",\"PAX\":\"PAX\",\"USDC\":\"USDC\",\"ONT\":\"ONT\",\"XTZ\":\"XTZ\",\"LINK\":\"LINK\",\"RVN\":\"RVN\",\"BNBMAINNET\":\"BNBMAINNET\",\"ZIL\":\"ZIL\",\"BCD\":\"BCD\",\"USDT\":\"USDT\",\"USDTERC20\":\"USDTERC20\",\"CRO\":\"CRO\",\"DAI\":\"DAI\",\"HT\":\"HT\",\"WABI\":\"WABI\",\"BUSD\":\"BUSD\",\"ALGO\":\"ALGO\",\"USDTTRC20\":\"USDTTRC20\",\"GT\":\"GT\",\"STPT\":\"STPT\",\"AVA\":\"AVA\",\"SXP\":\"SXP\",\"UNI\":\"UNI\",\"OKB\":\"OKB\",\"BTC\":\"BTC\"}',
    1,
    '',
    NULL,
    NULL,
    '2024-05-07 08:20:40'
  ),
  (
    0,
    509,
    'Now payments checkout',
    'NowPaymentsCheckout',
    '663a38a59d2541715091621.png',
    1,
    '{\"api_key\":{\"title\":\"API Key\",\"global\":true,\"value\":\"---------------\"},\"secret_key\":{\"title\":\"Secret Key\",\"global\":true,\"value\":\"-----------\"}}',
    '{\"USD\":\"USD\",\"EUR\":\"EUR\"}',
    1,
    '',
    NULL,
    NULL,
    '2024-05-07 08:20:21'
  ),
  (
    0,
    122,
    '2Checkout',
    'TwoCheckout',
    '663a39b8e64b91715091896.png',
    1,
    '{\"merchant_code\":{\"title\":\"Merchant Code\",\"global\":true,\"value\":\"253248016872\"},\"secret_key\":{\"title\":\"Secret Key\",\"global\":true,\"value\":\"eQM)ID@&vG84u!O*g[p+\"}}',
    '{\"AFN\": \"AFN\",\"ALL\": \"ALL\",\"DZD\": \"DZD\",\"ARS\": \"ARS\",\"AUD\": \"AUD\",\"AZN\": \"AZN\",\"BSD\": \"BSD\",\"BDT\": \"BDT\",\"BBD\": \"BBD\",\"BZD\": \"BZD\",\"BMD\": \"BMD\",\"BOB\": \"BOB\",\"BWP\": \"BWP\",\"BRL\": \"BRL\",\"GBP\": \"GBP\",\"BND\": \"BND\",\"BGN\": \"BGN\",\"CAD\": \"CAD\",\"CLP\": \"CLP\",\"CNY\": \"CNY\",\"COP\": \"COP\",\"CRC\": \"CRC\",\"HRK\": \"HRK\",\"CZK\": \"CZK\",\"DKK\": \"DKK\",\"DOP\": \"DOP\",\"XCD\": \"XCD\",\"EGP\": \"EGP\",\"EUR\": \"EUR\",\"FJD\": \"FJD\",\"GTQ\": \"GTQ\",\"HKD\": \"HKD\",\"HNL\": \"HNL\",\"HUF\": \"HUF\",\"INR\": \"INR\",\"IDR\": \"IDR\",\"ILS\": \"ILS\",\"JMD\": \"JMD\",\"JPY\": \"JPY\",\"KZT\": \"KZT\",\"KES\": \"KES\",\"LAK\": \"LAK\",\"MMK\": \"MMK\",\"LBP\": \"LBP\",\"LRD\": \"LRD\",\"MOP\": \"MOP\",\"MYR\": \"MYR\",\"MVR\": \"MVR\",\"MRO\": \"MRO\",\"MUR\": \"MUR\",\"MXN\": \"MXN\",\"MAD\": \"MAD\",\"NPR\": \"NPR\",\"TWD\": \"TWD\",\"NZD\": \"NZD\",\"NIO\": \"NIO\",\"NOK\": \"NOK\",\"PKR\": \"PKR\",\"PGK\": \"PGK\",\"PEN\": \"PEN\",\"PHP\": \"PHP\",\"PLN\": \"PLN\",\"QAR\": \"QAR\",\"RON\": \"RON\",\"RUB\": \"RUB\",\"WST\": \"WST\",\"SAR\": \"SAR\",\"SCR\": \"SCR\",\"SGD\": \"SGD\",\"SBD\": \"SBD\",\"ZAR\": \"ZAR\",\"KRW\": \"KRW\",\"LKR\": \"LKR\",\"SEK\": \"SEK\",\"CHF\": \"CHF\",\"SYP\": \"SYP\",\"THB\": \"THB\",\"TOP\": \"TOP\",\"TTD\": \"TTD\",\"TRY\": \"TRY\",\"UAH\": \"UAH\",\"AED\": \"AED\",\"USD\": \"USD\",\"VUV\": \"VUV\",\"VND\": \"VND\",\"XOF\": \"XOF\",\"YER\": \"YER\"}',
    0,
    '{\"approved_url\":{\"title\": \"Approved URL\",\"value\":\"ipn.TwoCheckout\"}}',
    NULL,
    NULL,
    '2024-05-07 08:24:56'
  ),
  (
    0,
    123,
    'Checkout',
    'Checkout',
    '663a3628733351715090984.png',
    1,
    '{\"secret_key\":{\"title\":\"Secret Key\",\"global\":true,\"value\":\"------\"},\"public_key\":{\"title\":\"PUBLIC KEY\",\"global\":true,\"value\":\"------\"},\"processing_channel_id\":{\"title\":\"PROCESSING CHANNEL\",\"global\":true,\"value\":\"------\"}}',
    '{\"USD\":\"USD\",\"EUR\":\"EUR\",\"GBP\":\"GBP\",\"HKD\":\"HKD\",\"AUD\":\"AUD\",\"CAN\":\"CAN\",\"CHF\":\"CHF\",\"SGD\":\"SGD\",\"JPY\":\"JPY\",\"NZD\":\"NZD\"}',
    0,
    NULL,
    NULL,
    NULL,
    '2024-05-07 08:09:44'
  ),
  (
    0,
    510,
    'Binance',
    'Binance',
    '663a35db4fd621715090907.png',
    1,
    '{\"api_key\":{\"title\":\"API Key\",\"global\":true,\"value\":\"tsu3tjiq0oqfbtmlbevoeraxhfbp3brejnm9txhjxcp4to29ujvakvfl1ibsn3ja\"},\"secret_key\":{\"title\":\"Secret Key\",\"global\":true,\"value\":\"jzngq4t04ltw8d4iqpi7admfl8tvnpehxnmi34id1zvfaenbwwvsvw7llw3zdko8\"},\"merchant_id\":{\"title\":\"Merchant ID\",\"global\":true,\"value\":\"231129033\"}}',
    '{\"BTC\":\"Bitcoin\",\"USD\":\"USD\",\"BNB\":\"BNB\"}',
    1,
    '{\"cron\":{\"title\": \"Cron Job URL\",\"value\":\"ipn.Binance\"}}',
    NULL,
    NULL,
    '2024-05-07 08:08:27'
  ),
  (
    0,
    124,
    'SslCommerz',
    'SslCommerz',
    '663a397a70c571715091834.png',
    1,
    '{\"store_id\":{\"title\":\"Store ID\",\"global\":true,\"value\":\"---------\"},\"store_password\":{\"title\":\"Store Password\",\"global\":true,\"value\":\"----------\"}}',
    '{\"BDT\":\"BDT\",\"USD\":\"USD\",\"EUR\":\"EUR\",\"SGD\":\"SGD\",\"INR\":\"INR\",\"MYR\":\"MYR\"}',
    0,
    NULL,
    NULL,
    NULL,
    '2024-05-07 08:23:54'
  ),
  (
    0,
    125,
    'Aamarpay',
    'Aamarpay',
    '663a34d5d1dfc1715090645.png',
    1,
    '{\"store_id\":{\"title\":\"Store ID\",\"global\":true,\"value\":\"aamarpaytest\"},\"signature_key\":{\"title\":\"Signature Key\",\"global\":true,\"value\":\"dbb74894e82415a2f7ff0ec3a97e4183\"}}',
    '{\"BDT\":\"BDT\"}',
    0,
    NULL,
    NULL,
    NULL,
    '2024-05-25 04:37:01'
  );

  DELETE FROM gateways WHERE `gateways`.`id` = 14;
  DELETE FROM `gateway_currencies` WHERE `gateway_currencies`.`id` = 107;
  

  INSERT INTO
  `frontends` (
    `data_keys`,
    `data_values`,
    `seo_content`,
    `tempname`,
    `slug`,
    `created_at`,
    `updated_at`
  )
VALUES
  (
    'maintenance.data',
    '{\"description\":\"<h2 style=\\\"text-align: center;\\\"><span style=\\\"color: var(--bs-body-color); text-align: var(--bs-body-text-align);\\\"><font size=\\\"6\\\">We\'re just tuning up a few things.<\\/font><\\/span><\\/h2><p>We apologize for the inconvenience but Front is currently undergoing planned maintenance. Thanks for your patience.<br><\\/p>\",\"image\":\"668546d5a409e1720010453.png\"}',
    NULL,
    NULL,
    NULL,
    NULL,
    '2024-07-03 06:40:54'
  );

  
UPDATE `extensions` SET `script` = '\n<script src=\"https://www.google.com/recaptcha/api.js\"></script>\n<div class=\"g-recaptcha\" data-sitekey=\"{{site_key}}\" data-callback=\"verifyCaptcha\"></div>\n<div id=\"g-recaptcha-error\"></div>' WHERE `extensions`.`id` = 2;

UPDATE `extensions` SET `shortcode` = '{\"site_key\":{\"title\":\"Site Key\",\"value\":\"6LdPC88fAAAAADQlUf_DV6Hrvgm-pZuLJFSLDOWV\"},\"secret_key\":{\"title\":\"Secret Key\",\"value\":\"6LdPC88fAAAAAG5SVaRYDnV2NpCrptLg2XLYKRKB\"}}' WHERE `extensions`.`id` = 2;

UPDATE `general_settings` SET `available_version` = '2.0' WHERE `general_settings`.`id` = 1;