-- qr_codes
ALTER TABLE `qr_codes` ADD `qr_image` VARCHAR(30) NULL DEFAULT NULL AFTER `secret`;
-- Merchant Group
ALTER TABLE `merchant_groups` ADD `fee_bearer` VARCHAR(10) NOT NULL DEFAULT 'User' COMMENT 'Merchant, User ' AFTER `fee`, ADD INDEX `fee_bearer_merchant_groups_idx` (`fee_bearer`);
-- Merchant Payments
ALTER TABLE `merchant_payments` ADD `fee_bearer` VARCHAR(10) NOT NULL COMMENT 'Merchant, User' AFTER `uuid`, ADD `percentage` DECIMAL(20,8) NULL DEFAULT '0.00000000' AFTER `fee_bearer`;
-- `metas` table
INSERT INTO `metas` (`id`, `url`, `title`, `description`, `keywords`) VALUES (NULL, 'payout/store', 'Withdraw', 'Withdraw', NULL);
UPDATE `metas` SET `title`='Withdraw',`description`='Withdraw' WHERE `title` = 'Payout';
UPDATE `metas` SET `title`='Withdrawals',`description`='Withdrawals' WHERE `title` = 'Payouts';
-- Email Templates
TRUNCATE `email_templates`;
ALTER TABLE `email_templates`
DROP `temp_id`;
ALTER TABLE `email_templates` ADD `name` VARCHAR(191) NOT NULL AFTER `language_id`, ADD `alias` VARCHAR(191) NOT NULL AFTER `name`, ADD `status` VARCHAR(8) NOT NULL DEFAULT 'Active' AFTER `type`, ADD `group` VARCHAR(40) NOT NULL AFTER `status`, ADD `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `group`, ADD `updated_at` TIMESTAMP on update CURRENT_TIMESTAMP NULL DEFAULT NULL AFTER `created_at`;
ALTER TABLE `email_templates` ADD INDEX `email_templates_name_idx` (`name`);
ALTER TABLE `email_templates` ADD INDEX `email_templates_alias_idx` (`alias`);
INSERT INTO `email_templates` (`language_id`, `name`, `alias`, `subject`, `body`, `lang`, `type`, `status`, `group`, `created_at`, `updated_at`) VALUES
(1, 'Notify Admin on Deposit', 'notify-admin-on-deposit', 'Money Deposit Notification', 'Hi {admin},\r\n
Amount {amount} has been deposited by {user}\r\n
Here’s a brief overview of the Deposit:\r\n
Deposited at: {created_at}\r\n
Deposited via: {payment_method}\r\n
Transaction ID: {uuid}\r\n
Currency: {code}\r\n
Amount: {amount}\r\n
Fee: {fee}\r\n
If you have any questions, please feel free to reply to this email.\r\n
Regards,\r\n
{soft_name}', 'en', 'email', 'Active', 'Deposit', '2023-07-18 08:51:58', NULL),
(2, 'Notify Admin on Deposit', 'notify-admin-on-deposit', '', '', 'ar', 'email', 'Active', 'Deposit', '2023-07-18 08:51:58', NULL),
(3, 'Notify Admin on Deposit', 'notify-admin-on-deposit', '', '', 'fr', 'email', 'Active', 'Deposit', '2023-07-18 08:51:58', NULL),
(4, 'Notify Admin on Deposit', 'notify-admin-on-deposit', '', '', 'pt', 'email', 'Active', 'Deposit', '2023-07-18 08:51:58', NULL),
(5, 'Notify Admin on Deposit', 'notify-admin-on-deposit', '', '', 'ru', 'email', 'Active', 'Deposit', '2023-07-18 08:51:58', NULL),
(6, 'Notify Admin on Deposit', 'notify-admin-on-deposit', '', '', 'es', 'email', 'Active', 'Deposit', '2023-07-18 08:51:58', NULL),
(7, 'Notify Admin on Deposit', 'notify-admin-on-deposit', '', '', 'tr', 'email', 'Active', 'Deposit', '2023-07-18 08:51:58', NULL),
(8, 'Notify Admin on Deposit', 'notify-admin-on-deposit', '', '', 'ch', 'email', 'Active', 'Deposit', '2023-07-18 08:51:58', NULL),
(1, 'Notify User on Deposit via Admin', 'notify-user-on-deposit-via-admin', 'Deposit via System Administrator', 'Hi {user},\r\n
Amount {amount} has been deposited to your account by System Administrator.\r\n
Here’s a brief overview of the Deposit:\r\n
Deposited at: {created_at}\r\n
Transaction ID: {uuid}\r\n
Currency: {code}\r\n
Amount: {amount}\r\n
Fee: {fee}\r\n
If you have any questions, please feel free to reply to this email.\r\n
Regards,\r\n
{soft_name}', 'en', 'email', 'Active', 'Deposit', '2023-07-18 08:51:58', NULL),
(2, 'Notify User on Deposit via Admin', 'notify-user-on-deposit-via-admin', '', '', 'ar', 'email', 'Active', 'Deposit', '2023-07-18 08:51:58', NULL),
(3, 'Notify User on Deposit via Admin', 'notify-user-on-deposit-via-admin', '', '', 'fr', 'email', 'Active', 'Deposit', '2023-07-18 08:51:58', NULL),
(4, 'Notify User on Deposit via Admin', 'notify-user-on-deposit-via-admin', '', '', 'pt', 'email', 'Active', 'Deposit', '2023-07-18 08:51:58', NULL),
(5, 'Notify User on Deposit via Admin', 'notify-user-on-deposit-via-admin', '', '', 'ru', 'email', 'Active', 'Deposit', '2023-07-18 08:51:58', NULL),
(6, 'Notify User on Deposit via Admin', 'notify-user-on-deposit-via-admin', '', '', 'es', 'email', 'Active', 'Deposit', '2023-07-18 08:51:58', NULL),
(7, 'Notify User on Deposit via Admin', 'notify-user-on-deposit-via-admin', '', '', 'tr', 'email', 'Active', 'Deposit', '2023-07-18 08:51:58', NULL),
(8, 'Notify User on Deposit via Admin', 'notify-user-on-deposit-via-admin', '', '', 'ch', 'email', 'Active', 'Deposit', '2023-07-18 08:51:58', NULL),
(1, 'Notify Money Receiver', 'notify-money-receiver', 'Money Received Notification', 'Hi {receiver_id},\r\n
You have received {amount} on your account.\r\n
\r\n Here’s a brief overview of your Received:\r\n
Transferred at: {created_at}\r\n
Transaction ID: {uuid}\r\n
Sent By: {sender_id}\r\n
Amount: {amount}\r\n
Note: {note}\r\n
If you have any questions, please feel free to reply to this email.\r\n
Regards,\r\n
{soft_name}', 'en', 'email', 'Active', 'Send Money', '2023-07-18 08:51:58', NULL),
(2, 'Notify Money Receiver', 'notify-money-receiver', '', '', 'ar', 'email', 'Active', 'Send Money', '2023-07-18 08:51:58', NULL),
(3, 'Notify Money Receiver', 'notify-money-receiver', '', '', 'fr', 'email', 'Active', 'Send Money', '2023-07-18 08:51:58', NULL),
(4, 'Notify Money Receiver', 'notify-money-receiver', '', '', 'pt', 'email', 'Active', 'Send Money', '2023-07-18 08:51:58', NULL),
(5, 'Notify Money Receiver', 'notify-money-receiver', '', '', 'ru', 'email', 'Active', 'Send Money', '2023-07-18 08:51:58', NULL),
(6, 'Notify Money Receiver', 'notify-money-receiver', '', '', 'es', 'email', 'Active', 'Send Money', '2023-07-18 08:51:58', NULL),
(7, 'Notify Money Receiver', 'notify-money-receiver', '', '', 'tr', 'email', 'Active', 'Send Money', '2023-07-18 08:51:58', NULL),
(8, 'Notify Money Receiver', 'notify-money-receiver', '', '', 'ch', 'email', 'Active', 'Send Money', '2023-07-18 08:51:58', NULL),
(1, 'Notify Admin on Transfer', 'notify-admin-on-transfer', 'Money Transfer Notification', 'Hi {admin},\r\n
{sender} has been transferred {amount} to {receiver}.\r\n
Here’s a brief overview of the Transfer:\r\n
Transferred at: {created_at}\r\n
Transaction ID: {uuid}\r\n
Sent By: {sender}\r\n
Received By: {receiver}\r\n
Amount: {amount}\r\n
Fee (deducted from {sender}): {fee}\r\n
Note: {note}\r\n
If you have any questions, please feel free to reply to this email.\r\n
Regards,\r\n
{soft_name}', 'en', 'email', 'Active', 'Send Money', '2023-07-18 08:51:58', NULL),
(2, 'Notify Admin on Transfer', 'notify-admin-on-transfer', '', '', 'ar', 'email', 'Active', 'Send Money', '2023-07-18 08:51:58', NULL),
(3, 'Notify Admin on Transfer', 'notify-admin-on-transfer', '', '', 'fr', 'email', 'Active', 'Send Money', '2023-07-18 08:51:58', NULL),
(4, 'Notify Admin on Transfer', 'notify-admin-on-transfer', '', '', 'pt', 'email', 'Active', 'Send Money', '2023-07-18 08:51:58', NULL),
(5, 'Notify Admin on Transfer', 'notify-admin-on-transfer', '', '', 'ru', 'email', 'Active', 'Send Money', '2023-07-18 08:51:58', NULL),
(6, 'Notify Admin on Transfer', 'notify-admin-on-transfer', '', '', 'es', 'email', 'Active', 'Send Money', '2023-07-18 08:51:58', NULL),
(7, 'Notify Admin on Transfer', 'notify-admin-on-transfer', '', '', 'tr', 'email', 'Active', 'Send Money', '2023-07-18 08:51:58', NULL),
(8, 'Notify Admin on Transfer', 'notify-admin-on-transfer', '', '', 'ch', 'email', 'Active', 'Send Money', '2023-07-18 08:51:58', NULL),
(1, 'Notify Request Receiver', 'notify-request-receiver', 'Request Money Notification', 'Hi {request_receiver},\r\n
{request_sender} has been requested {amount} from you.\r\n
Here’s a brief overview of the Request:\r\n
\r\n Request: #{uuid}\r\n
\r\n Requested At: {created_at}\r\n
\r\n Requested Amount: {amount}\r\n
\r\n Note: {note}\r\n
If you have any questions, please feel free to reply to this email.\r\n
Regards,\r\n
{soft_name}', 'en', 'email', 'Active', 'Request Money', '2023-07-18 08:51:58', NULL),
(2, 'Notify Request Receiver', 'notify-request-receiver', '', '', 'ar', 'email', 'Active', 'Request Money', '2023-07-18 08:51:58', NULL),
(3, 'Notify Request Receiver', 'notify-request-receiver', '', '', 'fr', 'email', 'Active', 'Request Money', '2023-07-18 08:51:58', NULL),
(4, 'Notify Request Receiver', 'notify-request-receiver', '', '', 'pt', 'email', 'Active', 'Request Money', '2023-07-18 08:51:58', NULL),
(5, 'Notify Request Receiver', 'notify-request-receiver', '', '', 'ru', 'email', 'Active', 'Request Money', '2023-07-18 08:51:58', NULL),
(6, 'Notify Request Receiver', 'notify-request-receiver', '', '', 'es', 'email', 'Active', 'Request Money', '2023-07-18 08:51:58', NULL),
(7, 'Notify Request Receiver', 'notify-request-receiver', '', '', 'tr', 'email', 'Active', 'Request Money', '2023-07-18 08:51:58', NULL),
(8, 'Notify Request Receiver', 'notify-request-receiver', '', '', 'ch', 'email', 'Active', 'Request Money', '2023-07-18 08:51:58', NULL),
(1, 'Notify Request Sender on Money Received', 'notify-request-sender-on-money-received', 'Requested Money Received Notification', 'Hi {request_sender},\r\n
Your request of #{uuid} has been received by {request_receiver}.\r\n
Here’s a brief overview of the Request:\r\n
\r\n Received Date: {created_at}.\r\n
\r\n Requested Amount: {amount}\r\n
\r\n Received Amount: {accept_amount}\r\n
\r\n Currency: {currency}\r\n
If you have any questions, please feel free to reply to this email.\r\n
Regards,\r\n
{soft_name}', 'en', 'email', 'Active', 'Request Money', '2023-07-18 08:51:58', NULL),
(2, 'Notify Request Sender on Money Received', 'notify-request-sender-on-money-received', '', '', 'ar', 'email', 'Active', 'Request Money', '2023-07-18 08:51:58', NULL),
(3, 'Notify Request Sender on Money Received', 'notify-request-sender-on-money-received', '', '', 'fr', 'email', 'Active', 'Request Money', '2023-07-18 08:51:58', NULL),
(4, 'Notify Request Sender on Money Received', 'notify-request-sender-on-money-received', '', '', 'pt', 'email', 'Active', 'Request Money', '2023-07-18 08:51:58', NULL),
(5, 'Notify Request Sender on Money Received', 'notify-request-sender-on-money-received', '', '', 'ru', 'email', 'Active', 'Request Money', '2023-07-18 08:51:58', NULL),
(6, 'Notify Request Sender on Money Received', 'notify-request-sender-on-money-received', '', '', 'es', 'email', 'Active', 'Request Money', '2023-07-18 08:51:58', NULL),
(7, 'Notify Request Sender on Money Received', 'notify-request-sender-on-money-received', '', '', 'tr', 'email', 'Active', 'Request Money', '2023-07-18 08:51:58', NULL),
(8, 'Notify Request Sender on Money Received', 'notify-request-sender-on-money-received', '', '', 'ch', 'email', 'Active', 'Request Money', '2023-07-18 08:51:58', NULL),
(1, 'Notify Admin on Money Received', 'notify-admin-on-money-received', 'Request Money Received Notification', 'Hi {admin},\r\n
Money request of #{uuid} from {request_sender} has been received by {request_receiver}.\r\n
Here’s a brief overview of the Request Acceptance:\r\n
Received at: {created_at}\r\n
Transaction ID: {uuid}\r\n
Currency: {code}\r\n
Requested By: {request_sender}\r\n
Received By: {request_receiver}\r\n
Requested Amount: {request_amount}\r\n
Given Amount: {given_amount}\r\n
Fee (deducted from {request_receiver}): {fee}\r\n
If you have any questions, please feel free to reply to this email.\r\n
Regards,\r\n
{soft_name}', 'en', 'email', 'Active', 'Request Money', '2023-07-18 08:51:58', NULL),
(2, 'Notify Admin on Money Received', 'notify-admin-on-money-received', '', '', 'ar', 'email', 'Active', 'Request Money', '2023-07-18 08:51:58', NULL),
(3, 'Notify Admin on Money Received', 'notify-admin-on-money-received', '', '', 'fr', 'email', 'Active', 'Request Money', '2023-07-18 08:51:58', NULL),
(4, 'Notify Admin on Money Received', 'notify-admin-on-money-received', '', '', 'pt', 'email', 'Active', 'Request Money', '2023-07-18 08:51:58', NULL),
(5, 'Notify Admin on Money Received', 'notify-admin-on-money-received', '', '', 'ru', 'email', 'Active', 'Request Money', '2023-07-18 08:51:58', NULL),
(6, 'Notify Admin on Money Received', 'notify-admin-on-money-received', '', '', 'es', 'email', 'Active', 'Request Money', '2023-07-18 08:51:58', NULL),
(7, 'Notify Admin on Money Received', 'notify-admin-on-money-received', '', '', 'tr', 'email', 'Active', 'Request Money', '2023-07-18 08:51:58', NULL),
(8, 'Notify Admin on Money Received', 'notify-admin-on-money-received', '', '', 'ch', 'email', 'Active', 'Request Money', '2023-07-18 08:51:58', NULL),
(1, 'Notify Admin on Exchange', 'notify-admin-on-exchange', 'Money Exchange Notification', 'Hi {admin},\r\n
Amount {amount} has been exchanged by {user}\r\n
Here’s a brief overview of the Exchange:\r\n
Exchanged at: {created_at}\r\n
Transaction ID: {uuid}\r\n
From wallet: {from_wallet}\r\n
To wallet: {to_wallet}\r\n
Exchanged Amount: {exchanged_amount}\r\n
Exchange Rate: 1 {from_wallet} = {exchange_rate} {to_wallet}\r\n
Fee (deducted from {from_wallet}): {fee}\r\n
If you have any questions, please feel free to reply to this email.\r\n
Regards,\r\n
{soft_name}', 'en', 'email', 'Active', 'Exchange', '2023-07-18 08:51:58', NULL),
(2, 'Notify Admin on Exchange', 'notify-admin-on-exchange', '', '', 'ar', 'email', 'Active', 'Exchange', '2023-07-18 08:51:58', NULL),
(3, 'Notify Admin on Exchange', 'notify-admin-on-exchange', '', '', 'fr', 'email', 'Active', 'Exchange', '2023-07-18 08:51:58', NULL),
(4, 'Notify Admin on Exchange', 'notify-admin-on-exchange', '', '', 'pt', 'email', 'Active', 'Exchange', '2023-07-18 08:51:58', NULL),
(5, 'Notify Admin on Exchange', 'notify-admin-on-exchange', '', '', 'ru', 'email', 'Active', 'Exchange', '2023-07-18 08:51:58', NULL),
(6, 'Notify Admin on Exchange', 'notify-admin-on-exchange', '', '', 'es', 'email', 'Active', 'Exchange', '2023-07-18 08:51:58', NULL),
(7, 'Notify Admin on Exchange', 'notify-admin-on-exchange', '', '', 'tr', 'email', 'Active', 'Exchange', '2023-07-18 08:51:58', NULL),
(8, 'Notify Admin on Exchange', 'notify-admin-on-exchange', '', '', 'ch', 'email', 'Active', 'Exchange', '2023-07-18 08:51:58', NULL),
(1, 'Notify Admin on Withdrawal', 'notify-admin-on-withdrawal', 'Money Withdrawal Notification', 'Hi {admin},\r\n
{amount} has been withdrawn by {user}.\r\n
Here’s a brief overview of the Withdrawn:\r\n
Withdrawn at: {created_at}\r\n
Transaction ID: {uuid}\r\n
Withdraw via: {payment_method}\r\n
Currency: {code}\r\n
Amount: {amount}\r\n
Fee: {fee}\r\n
If you have any questions, please feel free to reply to this email.\r\n
Regards,\r\n
{soft_name}', 'en', 'email', 'Active', 'Withdraw', '2023-07-18 08:51:58', NULL),
(2, 'Notify Admin on Withdrawal', 'notify-admin-on-withdrawal', '', '', 'ar', 'email', 'Active', 'Withdraw', '2023-07-18 08:51:58', NULL),
(3, 'Notify Admin on Withdrawal', 'notify-admin-on-withdrawal', '', '', 'fr', 'email', 'Active', 'Withdraw', '2023-07-18 08:51:58', NULL),
(4, 'Notify Admin on Withdrawal', 'notify-admin-on-withdrawal', '', '', 'pt', 'email', 'Active', 'Withdraw', '2023-07-18 08:51:58', NULL),
(5, 'Notify Admin on Withdrawal', 'notify-admin-on-withdrawal', '', '', 'ru', 'email', 'Active', 'Withdraw', '2023-07-18 08:51:58', NULL),
(6, 'Notify Admin on Withdrawal', 'notify-admin-on-withdrawal', '', '', 'es', 'email', 'Active', 'Withdraw', '2023-07-18 08:51:58', NULL),
(7, 'Notify Admin on Withdrawal', 'notify-admin-on-withdrawal', '', '', 'tr', 'email', 'Active', 'Withdraw', '2023-07-18 08:51:58', NULL),
(8, 'Notify Admin on Withdrawal', 'notify-admin-on-withdrawal', '', '', 'ch', 'email', 'Active', 'Withdraw', '2023-07-18 08:51:58', NULL),
(1, 'Notify User on Withdrawal via Admin', 'notify-user-on-withdrawal-via-admin', 'Money Withdrawal Notification', 'Hi {user},\r\n
{amount} has been withdrawn from your account by System Administrator.\r\n
Here’s a brief overview of the withdrawn:\r\n
Withdrawn at: {created_at}\r\n
Transaction ID: {uuid}\r\n
Currency: {code}\r\n
Amount: {amount}\r\n
Fee: {fee}\r\n
If you have any questions, please feel free to reply to this email.\r\n
Regards,\r\n
{soft_name}', 'en', 'email', 'Active', 'Withdraw', '2023-07-18 08:51:58', NULL),
(2, 'Notify User on Withdrawal via Admin', 'notify-user-on-withdrawal-via-admin', '', '', 'ar', 'email', 'Active', 'Withdraw', '2023-07-18 08:51:58', NULL),
(3, 'Notify User on Withdrawal via Admin', 'notify-user-on-withdrawal-via-admin', '', '', 'fr', 'email', 'Active', 'Withdraw', '2023-07-18 08:51:58', NULL),
(4, 'Notify User on Withdrawal via Admin', 'notify-user-on-withdrawal-via-admin', '', '', 'pt', 'email', 'Active', 'Withdraw', '2023-07-18 08:51:58', NULL),
(5, 'Notify User on Withdrawal via Admin', 'notify-user-on-withdrawal-via-admin', '', '', 'ru', 'email', 'Active', 'Withdraw', '2023-07-18 08:51:58', NULL),
(6, 'Notify User on Withdrawal via Admin', 'notify-user-on-withdrawal-via-admin', '', '', 'es', 'email', 'Active', 'Withdraw', '2023-07-18 08:51:58', NULL),
(7, 'Notify User on Withdrawal via Admin', 'notify-user-on-withdrawal-via-admin', '', '', 'tr', 'email', 'Active', 'Withdraw', '2023-07-18 08:51:58', NULL),
(8, 'Notify User on Withdrawal via Admin', 'notify-user-on-withdrawal-via-admin', '', '', 'ch', 'email', 'Active', 'Withdraw', '2023-07-18 08:51:58', NULL),
(1, 'Notify Merchant', 'notify-merchant', 'Merchant Payment Notification', 'Hi {merchant},\r\n
Payment has been completed. Amount {amount} has been paid to {merchant}.\r\n
Here’s a brief overview of the Payment:\r\n
Paid at: {created_at}\r\n
Transaction ID: {uuid}\r\n
Currency: {code}\r\n
Paid By: {user}\r\n
Paid To: {merchant}\r\n
Amount: {amount}\r\n
Fee (deducted from {fee_bearer}): {fee}\r\n
If you have any questions, please feel free to reply to this email.\r\n
Regards,\r\n
{soft_name}', 'en', 'email', 'Active', 'Merchant Payment', '2023-07-18 08:51:58', NULL),
(2, 'Notify Merchant', 'notify-merchant', '', '', 'ar', 'email', 'Active', 'Merchant Payment', '2023-07-18 08:51:58', NULL),
(3, 'Notify Merchant', 'notify-merchant', '', '', 'fr', 'email', 'Active', 'Merchant Payment', '2023-07-18 08:51:58', NULL),
(4, 'Notify Merchant', 'notify-merchant', '', '', 'pt', 'email', 'Active', 'Merchant Payment', '2023-07-18 08:51:58', NULL),
(5, 'Notify Merchant', 'notify-merchant', '', '', 'ru', 'email', 'Active', 'Merchant Payment', '2023-07-18 08:51:58', NULL),
(6, 'Notify Merchant', 'notify-merchant', '', '', 'es', 'email', 'Active', 'Merchant Payment', '2023-07-18 08:51:58', NULL),
(7, 'Notify Merchant', 'notify-merchant', '', '', 'tr', 'email', 'Active', 'Merchant Payment', '2023-07-18 08:51:58', NULL),
(8, 'Notify Merchant', 'notify-merchant', '', '', 'ch', 'email', 'Active', 'Merchant Payment', '2023-07-18 08:51:58', NULL),
(1, 'Notify Admin on Payment', 'notify-admin-on-payment', 'Merchant Payment Notification', 'Hi {admin},\r\n
Merchant payment completed. Amount {amount} has been paid by {user} to {merchant}.\r\n
Here’s a brief overview of the Payment:\r\n
Paid at: {created_at}\r\n
Transaction ID: {uuid}\r\n
Currency: {code}\r\n
Paid By: {user}\r\n
Paid To: {merchant}\r\n
Amount: {amount}\r\n
Fee (deducted from {fee_bearer}): {fee}\r\n
If you have any questions, please feel free to reply to this email.\r\n
Regards,\r\n
{soft_name}', 'en', 'email', 'Active', 'Merchant Payment', '2023-07-18 08:51:58', NULL),
(2, 'Notify Admin on Payment', 'notify-admin-on-payment', '', '', 'ar', 'email', 'Active', 'Merchant Payment', '2023-07-18 08:51:58', NULL),
(3, 'Notify Admin on Payment', 'notify-admin-on-payment', '', '', 'fr', 'email', 'Active', 'Merchant Payment', '2023-07-18 08:51:58', NULL),
(4, 'Notify Admin on Payment', 'notify-admin-on-payment', '', '', 'pt', 'email', 'Active', 'Merchant Payment', '2023-07-18 08:51:58', NULL),
(5, 'Notify Admin on Payment', 'notify-admin-on-payment', '', '', 'ru', 'email', 'Active', 'Merchant Payment', '2023-07-18 08:51:58', NULL),
(6, 'Notify Admin on Payment', 'notify-admin-on-payment', '', '', 'es', 'email', 'Active', 'Merchant Payment', '2023-07-18 08:51:58', NULL),
(7, 'Notify Admin on Payment', 'notify-admin-on-payment', '', '', 'tr', 'email', 'Active', 'Merchant Payment', '2023-07-18 08:51:58', NULL),
(8, 'Notify Admin on Payment', 'notify-admin-on-payment', '', '', 'ch', 'email', 'Active', 'Merchant Payment', '2023-07-18 08:51:58', NULL),
(1, 'New Ticket', 'new-ticket', 'New Ticket has been {assigned/created}', 'Hi {admin/assignee/user},\r\n
Ticket #{ticket_code} was {assigned/created} {to/for} you.\r\n
Here’s a brief overview of the ticket:\r\n
Ticket #{ticket_code} was created at {created_at}.\r\n
Assignee: {assignee}\r\n
User: {user}\r\n
Ticket Subject: {subject}\r\n
Ticket Message: {message}\r\n
Ticket Status: {status}\r\n
Ticket Priority Level: {priority}\r\n
If you have any questions, please feel free to reply to this email.\r\n
Regards,\r\n
{soft_name}', 'en', 'email', 'Active', 'Ticket', '2023-07-18 08:51:58', NULL),
(2, 'New Ticket', 'new-ticket', '', '', 'ar', 'email', 'Active', 'Ticket', '2023-07-18 08:51:58', NULL),
(3, 'New Ticket', 'new-ticket', '', '', 'fr', 'email', 'Active', 'Ticket', '2023-07-18 08:51:58', NULL),
(4, 'New Ticket', 'new-ticket', '', '', 'pt', 'email', 'Active', 'Ticket', '2023-07-18 08:51:58', NULL),
(5, 'New Ticket', 'new-ticket', '', '', 'ru', 'email', 'Active', 'Ticket', '2023-07-18 08:51:58', NULL),
(6, 'New Ticket', 'new-ticket', '', '', 'es', 'email', 'Active', 'Ticket', '2023-07-18 08:51:58', NULL),
(7, 'New Ticket', 'new-ticket', '', '', 'tr', 'email', 'Active', 'Ticket', '2023-07-18 08:51:58', NULL),
(8, 'New Ticket', 'new-ticket', '', '', 'ch', 'email', 'Active', 'Ticket', '2023-07-18 08:51:58', NULL),
(1, 'Ticket Reply', 'ticket-reply', 'Ticket Reply Notification', 'Hi {assignee/user},\r\n
You have received a ticket reply.\r\n
Here’s a brief overview of the reply:\r\n
This reply was initiated against ticket code #{ticket_code}.\r\n
Assignee: {assignee}\r\n
Reply Message: {message}\r\n
Reply Status: {status}\r\n
Reply Priority Level: {priority}\r\n
If you have any questions, please feel free to reply to this email.\r\n
Regards,\r\n
{soft_name}', 'en', 'email', 'Active', 'Ticket', '2023-07-18 08:51:58', NULL),
(2, 'Ticket Reply', 'ticket-reply', '', '', 'ar', 'email', 'Active', 'Ticket', '2023-07-18 08:51:58', NULL),
(3, 'Ticket Reply', 'ticket-reply', '', '', 'fr', 'email', 'Active', 'Ticket', '2023-07-18 08:51:58', NULL),
(4, 'Ticket Reply', 'ticket-reply', '', '', 'pt', 'email', 'Active', 'Ticket', '2023-07-18 08:51:58', NULL),
(5, 'Ticket Reply', 'ticket-reply', '', '', 'ru', 'email', 'Active', 'Ticket', '2023-07-18 08:51:58', NULL),
(6, 'Ticket Reply', 'ticket-reply', '', '', 'es', 'email', 'Active', 'Ticket', '2023-07-18 08:51:58', NULL),
(7, 'Ticket Reply', 'ticket-reply', '', '', 'tr', 'email', 'Active', 'Ticket', '2023-07-18 08:51:58', NULL),
(8, 'Ticket Reply', 'ticket-reply', '', '', 'ch', 'email', 'Active', 'Ticket', '2023-07-18 08:51:58', NULL),
(1, 'Open Dispute', 'open-dispute', 'Dispute Open Notification', 'Hi {admin/merchant},\r\n
Dispute ID #{dispute_id} has been opened by {claimant}.\r\n
Here’s a brief overview of the dispute:\r\n
Created at: {created_at}\r\n
Transaction ID: {uuid}\r\n
Claimant: {claimant}\r\n
Defendant: {defendant}\r\n
Dispute Subject: {subject}\r\n
Dispute description: {description}\r\n
Dispute Status: {status}\r\n
If you have any questions, please feel free to reply to this email.\r\n
Regards,\r\n
{soft_name}', 'en', 'email', 'Active', 'Dispute', '2023-07-18 08:51:58', NULL),
(2, 'Open Dispute', 'open-dispute', '', '', 'ar', 'email', 'Active', 'Dispute', '2023-07-18 08:51:58', NULL),
(3, 'Open Dispute', 'open-dispute', '', '', 'fr', 'email', 'Active', 'Dispute', '2023-07-18 08:51:58', NULL),
(4, 'Open Dispute', 'open-dispute', '', '', 'pt', 'email', 'Active', 'Dispute', '2023-07-18 08:51:58', NULL),
(5, 'Open Dispute', 'open-dispute', '', '', 'ru', 'email', 'Active', 'Dispute', '2023-07-18 08:51:58', NULL),
(6, 'Open Dispute', 'open-dispute', '', '', 'es', 'email', 'Active', 'Dispute', '2023-07-18 08:51:58', NULL),
(7, 'Open Dispute', 'open-dispute', '', '', 'tr', 'email', 'Active', 'Dispute', '2023-07-18 08:51:58', NULL),
(8, 'Open Dispute', 'open-dispute', '', '', 'ch', 'email', 'Active', 'Dispute', '2023-07-18 08:51:58', NULL),
(1, 'Dispute Reply', 'dispute-reply', 'New Dispute Reply', 'Hi {admin/merchant/user},\r\n
You have received a new dispute reply from {user}.\r\n
Here’s a brief overview of the reply:\r\n
Replied at {created_at}\r\n
Dispute ID: {dispute_id}\r\n
Transaction ID: {transaction_id}\r\n
Claimant: {claimant}\r\n
Defendant {defendant}\r\n
Subject: {subject}\r\n
Replied Message: {message}\r\n
Status: {status}\r\n
If you have any questions, please feel free to reply to this email.\r\n
Regards,\r\n
{soft_name}', 'en', 'email', 'Active', 'Dispute', '2023-07-18 08:51:58', NULL),
(2, 'Dispute Reply', 'dispute-reply', '', '', 'ar', 'email', 'Active', 'Dispute', '2023-07-18 08:51:58', NULL),
(3, 'Dispute Reply', 'dispute-reply', '', '', 'fr', 'email', 'Active', 'Dispute', '2023-07-18 08:51:58', NULL),
(4, 'Dispute Reply', 'dispute-reply', '', '', 'pt', 'email', 'Active', 'Dispute', '2023-07-18 08:51:58', NULL),
(5, 'Dispute Reply', 'dispute-reply', '', '', 'ru', 'email', 'Active', 'Dispute', '2023-07-18 08:51:58', NULL),
(6, 'Dispute Reply', 'dispute-reply', '', '', 'es', 'email', 'Active', 'Dispute', '2023-07-18 08:51:58', NULL),
(7, 'Dispute Reply', 'dispute-reply', '', '', 'tr', 'email', 'Active', 'Dispute', '2023-07-18 08:51:58', NULL),
(8, 'Dispute Reply', 'dispute-reply', '', '', 'ch', 'email', 'Active', 'Dispute', '2023-07-18 08:51:58', NULL),
(1, 'Two-fa Authentication', 'two-fa-authentication', '2fa OTP code', 'Hi {user},\r\n
\r\n Your 2-Factor Authentication code is: {code}\r\n
Regards,\r\n
{soft_name}', 'en', 'email', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(2, 'Two-fa Authentication', 'two-fa-authentication', '', '', 'ar', 'email', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(3, 'Two-fa Authentication', 'two-fa-authentication', '', '', 'fr', 'email', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(4, 'Two-fa Authentication', 'two-fa-authentication', '', '', 'pt', 'email', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(5, 'Two-fa Authentication', 'two-fa-authentication', '', '', 'ru', 'email', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(6, 'Two-fa Authentication', 'two-fa-authentication', '', '', 'es', 'email', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(7, 'Two-fa Authentication', 'two-fa-authentication', '', '', 'tr', 'email', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(8, 'Two-fa Authentication', 'two-fa-authentication', '', '', 'ch', 'email', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(1, 'Address or Identity Verification', 'address-or-identity-verification', '{Identity/Address} Verification', 'Hi {user},\r\n
Your {Identity/Address} verification is {approved/pending/rejected}.\r\n
If you have any questions, please feel free to reply to this email.\r\n
Regards,\r\n
{soft_name}', 'en', 'email', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(2, 'Address or Identity Verification', 'address-or-identity-verification', '', '', 'ar', 'email', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(3, 'Address or Identity Verification', 'address-or-identity-verification', '', '', 'fr', 'email', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(4, 'Address or Identity Verification', 'address-or-identity-verification', '', '', 'pt', 'email', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(5, 'Address or Identity Verification', 'address-or-identity-verification', '', '', 'ru', 'email', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(6, 'Address or Identity Verification', 'address-or-identity-verification', '', '', 'es', 'email', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(7, 'Address or Identity Verification', 'address-or-identity-verification', '', '', 'tr', 'email', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(8, 'Address or Identity Verification', 'address-or-identity-verification', '', '', 'ch', 'email', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(1, 'Email Verification', 'email-verification', 'Email Verification', 'Hi {user},\r\n
\r\n Your registered email id: {email}. Please click on the below link to verify your account,
\r\n {verification_url}\r\n
If you have any questions, please feel free to reply to this email.\r\n
Regards,\r\n
{soft_name}', 'en', 'email', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(2, 'Email Verification', 'email-verification', '', '', 'ar', 'email', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(3, 'Email Verification', 'email-verification', '', '', 'fr', 'email', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(4, 'Email Verification', 'email-verification', '', '', 'pt', 'email', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(5, 'Email Verification', 'email-verification', '', '', 'ru', 'email', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(6, 'Email Verification', 'email-verification', '', '', 'es', 'email', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(7, 'Email Verification', 'email-verification', '', '', 'tr', 'email', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(8, 'Email Verification', 'email-verification', '', '', 'ch', 'email', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(1, 'Password Reset', 'password-reset', 'Password Reset Notification', 'Hi {user},\r\n
\r\n Your registered email id: {email}. Please click on the below link to reset your password,
\r\n {password_reset_url}\r\n
If you have any questions, please feel free to reply to this email.\r\n
Regards,\r\n
{soft_name}', 'en', 'email', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(2, 'Password Reset', 'password-reset', '', '', 'ar', 'email', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(3, 'Password Reset', 'password-reset', '', '', 'fr', 'email', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(4, 'Password Reset', 'password-reset', '', '', 'pt', 'email', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(5, 'Password Reset', 'password-reset', '', '', 'ru', 'email', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(6, 'Password Reset', 'password-reset', '', '', 'es', 'email', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(7, 'Password Reset', 'password-reset', '', '', 'tr', 'email', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(8, 'Password Reset', 'password-reset', '', '', 'ch', 'email', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(1, 'Profile Status Change', 'profile-status-change', 'Profile Status Change', 'Hi {user},\r\n
Your profile status has been changed to {status} by the System Administrator\r\n
If you have any questions, please feel free to reply to this email.\r\n
Regards,\r\n
{soft_name}.', 'en', 'email', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(2, 'Profile Status Change', 'profile-status-change', '', '', 'ar', 'email', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(3, 'Profile Status Change', 'profile-status-change', '', '', 'fr', 'email', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(4, 'Profile Status Change', 'profile-status-change', '', '', 'pt', 'email', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(5, 'Profile Status Change', 'profile-status-change', '', '', 'ru', 'email', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(6, 'Profile Status Change', 'profile-status-change', '', '', 'es', 'email', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(7, 'Profile Status Change', 'profile-status-change', '', '', 'tr', 'email', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(8, 'Profile Status Change', 'profile-status-change', '', '', 'ch', 'email', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(1, 'Transaction Status Update', 'transaction-status-update', 'Transaction Status Update Notification', 'Hi {user},\r\n
We would like to inform you that the transaction for {transaction_type} with the ID #{uuid} has been updated to {status} by the system administrator.\r\n
Amount {amount} has been {added/subtracted} {from/to} your account.\r\n
If you have any questions, please feel free to reply to this email.\r\n
Regards,\r\n
{soft_name}.', 'en', 'email', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(2, 'Transaction Status Update', 'transaction-status-update', '', '', 'ar', 'email', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(3, 'Transaction Status Update', 'transaction-status-update', '', '', 'fr', 'email', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(4, 'Transaction Status Update', 'transaction-status-update', '', '', 'pt', 'email', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(5, 'Transaction Status Update', 'transaction-status-update', '', '', 'ru', 'email', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(6, 'Transaction Status Update', 'transaction-status-update', '', '', 'es', 'email', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(7, 'Transaction Status Update', 'transaction-status-update', '', '', 'tr', 'email', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(8, 'Transaction Status Update', 'transaction-status-update', '', '', 'ch', 'email', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(1, 'Address or Identity Verification', 'address-or-identity-verification', '{Identity/Address} Verification', 'Hi {user}, Your {Identity/Address} verification is {approved/pending/rejected}.Regards, {soft_name}.', 'en', 'sms', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(2, 'Address or Identity Verification', 'address-or-identity-verification', '', '', 'ar', 'sms', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(3, 'Address or Identity Verification', 'address-or-identity-verification', '', '', 'fr', 'sms', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(4, 'Address or Identity Verification', 'address-or-identity-verification', '', '', 'pt', 'sms', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(5, 'Address or Identity Verification', 'address-or-identity-verification', '', '', 'ru', 'sms', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(6, 'Address or Identity Verification', 'address-or-identity-verification', '', '', 'es', 'sms', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(7, 'Address or Identity Verification', 'address-or-identity-verification', '', '', 'tr', 'sms', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(8, 'Address or Identity Verification', 'address-or-identity-verification', '', '', 'ch', 'sms', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(1, 'Notify Money Receiver', 'notify-money-receiver', 'Money Received Notification', 'Hi {receiver_id}, You have received amount {amount} tnxId #{uuid} at {created_at} on your account. Regards, {soft_name}.', 'en', 'sms', 'Active', 'Send Money', '2023-07-18 08:51:58', NULL),
(2, 'Notify Money Receiver', 'notify-money-receiver', '', '', 'ar', 'sms', 'Active', 'Send Money', '2023-07-18 08:51:58', NULL),
(3, 'Notify Money Receiver', 'notify-money-receiver', '', '', 'fr', 'sms', 'Active', 'Send Money', '2023-07-18 08:51:58', NULL),
(4, 'Notify Money Receiver', 'notify-money-receiver', '', '', 'pt', 'sms', 'Active', 'Send Money', '2023-07-18 08:51:58', NULL),
(5, 'Notify Money Receiver', 'notify-money-receiver', '', '', 'ru', 'sms', 'Active', 'Send Money', '2023-07-18 08:51:58', NULL),
(6, 'Notify Money Receiver', 'notify-money-receiver', '', '', 'es', 'sms', 'Active', 'Send Money', '2023-07-18 08:51:58', NULL),
(7, 'Notify Money Receiver', 'notify-money-receiver', '', '', 'tr', 'sms', 'Active', 'Send Money', '2023-07-18 08:51:58', NULL),
(8, 'Notify Money Receiver', 'notify-money-receiver', '', '', 'ch', 'sms', 'Active', 'Send Money', '2023-07-18 08:51:58', NULL),
(1, 'Notify Request Receiver', 'notify-request-receiver', 'Request Money Notification', 'Hi {request_receiver}, {request_sender} has been requested amount {amount} with tnxId: #{uuid} at {created_at} from you. Regards, {soft_name}.', 'en', 'sms', 'Active', 'Request Money', '2023-07-18 08:51:58', NULL),
(2, 'Notify Request Receiver', 'notify-request-receiver', '', '', 'ar', 'sms', 'Active', 'Request Money', '2023-07-18 08:51:58', NULL),
(3, 'Notify Request Receiver', 'notify-request-receiver', '', '', 'fr', 'sms', 'Active', 'Request Money', '2023-07-18 08:51:58', NULL),
(4, 'Notify Request Receiver', 'notify-request-receiver', '', '', 'pt', 'sms', 'Active', 'Request Money', '2023-07-18 08:51:58', NULL),
(5, 'Notify Request Receiver', 'notify-request-receiver', '', '', 'ru', 'sms', 'Active', 'Request Money', '2023-07-18 08:51:58', NULL),
(6, 'Notify Request Receiver', 'notify-request-receiver', '', '', 'es', 'sms', 'Active', 'Request Money', '2023-07-18 08:51:58', NULL),
(7, 'Notify Request Receiver', 'notify-request-receiver', '', '', 'tr', 'sms', 'Active', 'Request Money', '2023-07-18 08:51:58', NULL),
(8, 'Notify Request Receiver', 'notify-request-receiver', '', '', 'ch', 'sms', 'Active', 'Request Money', '2023-07-18 08:51:58', NULL),
(1, 'Notify Request Sender on Money Received', 'notify-request-sender-on-money-received', 'Requested Money Received Notification', 'Dear {request_sender}, You have received amount {amount} tnxId #{uuid} from {request_receiver}. Regards, {soft_name}.', 'en', 'sms', 'Active', 'Request Money', '2023-07-18 08:51:58', NULL),
(2, 'Notify Request Sender on Money Received', 'notify-request-sender-on-money-received', '', '', 'ar', 'sms', 'Active', 'Request Money', '2023-07-18 08:51:58', NULL),
(3, 'Notify Request Sender on Money Received', 'notify-request-sender-on-money-received', '', '', 'fr', 'sms', 'Active', 'Request Money', '2023-07-18 08:51:58', NULL),
(4, 'Notify Request Sender on Money Received', 'notify-request-sender-on-money-received', '', '', 'pt', 'sms', 'Active', 'Request Money', '2023-07-18 08:51:58', NULL),
(5, 'Notify Request Sender on Money Received', 'notify-request-sender-on-money-received', '', '', 'ru', 'sms', 'Active', 'Request Money', '2023-07-18 08:51:58', NULL),
(6, 'Notify Request Sender on Money Received', 'notify-request-sender-on-money-received', '', '', 'es', 'sms', 'Active', 'Request Money', '2023-07-18 08:51:58', NULL),
(7, 'Notify Request Sender on Money Received', 'notify-request-sender-on-money-received', '', '', 'tr', 'sms', 'Active', 'Request Money', '2023-07-18 08:51:58', NULL),
(8, 'Notify Request Sender on Money Received', 'notify-request-sender-on-money-received', '', '', 'ch', 'sms', 'Active', 'Request Money', '2023-07-18 08:51:58', NULL),
(1, 'Transaction Status Update', 'transaction-status-update', 'Transaction Status Update Notification', 'Hi {user}, The transaction {transaction_type} with ID #{uuid} has been updated to {status} by the administrator. Amount {amount} has been {added/subtracted} {from/to} your account. Regards, {soft_name}.', 'en', 'sms', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(2, 'Transaction Status Update', 'transaction-status-update', '', '', 'ar', 'sms', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(3, 'Transaction Status Update', 'transaction-status-update', '', '', 'fr', 'sms', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(4, 'Transaction Status Update', 'transaction-status-update', '', '', 'pt', 'sms', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(5, 'Transaction Status Update', 'transaction-status-update', '', '', 'ru', 'sms', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(6, 'Transaction Status Update', 'transaction-status-update', '', '', 'es', 'sms', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(7, 'Transaction Status Update', 'transaction-status-update', '', '', 'tr', 'sms', 'Active', 'General', '2023-07-18 08:51:58', NULL),
(8, 'Transaction Status Update', 'transaction-status-update', '', '', 'ch', 'sms', 'Active', 'General', '2023-07-18 08:51:58', NULL);
-- Transaction Types
UPDATE `transaction_types` SET `name` = 'Request_Sent' WHERE `transaction_types`.`name` = 'Request_From';
UPDATE `transaction_types` SET `name` = 'Request_Received' WHERE `transaction_types`.`name` = 'Request_To';
ALTER TABLE `currencies` CHANGE `address` `address` VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;
-- Table structure for table `failed_jobs`
DROP TABLE IF EXISTS `failed_jobs`;
CREATE TABLE IF NOT EXISTS `failed_jobs` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`uuid` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
`queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
`payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Table structure for table `jobs`
DROP TABLE IF EXISTS `jobs`;
CREATE TABLE IF NOT EXISTS `jobs` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`queue` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`attempts` tinyint(3) UNSIGNED NOT NULL,
`reserved_at` int(10) UNSIGNED DEFAULT NULL,
`available_at` int(10) UNSIGNED NOT NULL,
`created_at` int(10) UNSIGNED NOT NULL,
PRIMARY KEY (`id`),
KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Table structure for table `personal_access_tokens`
DROP TABLE IF EXISTS `personal_access_tokens`;
CREATE TABLE IF NOT EXISTS `personal_access_tokens` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`tokenable_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`tokenable_id` bigint(20) UNSIGNED NOT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
`abilities` text COLLATE utf8mb4_unicode_ci,
`last_used_at` timestamp NULL DEFAULT NULL,
`expires_at` timestamp NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;