INSERT INTO `#__cmgiftcard_email_templates` (`id`, `template_id`, `subject`, `body`, `modified`, `modified_by`, `checked_out`, `checked_out_time`) VALUES (NULL, 'physical_admin', 'New physical gift card {gift_card_code} from order {order_number}', '<p><strong>This is a sample email template.</strong></p>\r\n<p>Dear administrator,</p>\r\n<p>There is a new physical gift card from order {order_number}.</p>\r\n<ul>\r\n<li>Gift card\'s code: {gift_card_code}</li>\r\n<li>Gift card\'s amount: {gift_card_amount}</li>\r\n<li>Order\'s number: {order_number}</li>\r\n<li>Order\'s completed date: {completed_date}</li>\r\n<li>Order\'s total amount: {order_amount}</li>\r\n<li>Payment method: {payment_method}</li>\r\n<li>Transaction ID: {transaction_id}</li>\r\n<li>Sender\'s name: {sender_name}</li>\r\n<li>Recipient\'s name: {recipient_name}</li>\r\n<li>Recipient\'s email: {recipient_email}</li>\r\n<li>Recipient\'s address 1: {recipient_address_1}</li>\r\n<li>Recipient\'s address 2: {recipient_address_2}</li>\r\n<li>Recipient\'s address 3: {recipient_address_3}</li>\r\n<li>Recipient\'s postal box: {recipient_postal_box}</li>\r\n<li>Recipient\'s city: {recipient_city}</li>\r\n<li>Recipient\'s state: {recipient_state}</li>\r\n<li>Recipient\'s postal_code: {recipient_postal_code}</li>\r\n<li>Recipient\'s country: {recipient_country}</li>\r\n<li>Message to recipient: {gift_card_message}</li>\r\n</ul>\r\n<p>Best regards,<br />Company Name</p>', '0000-00-00 00:00:00', '0', '0', '0000-00-00 00:00:00');