-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `callnroam_riddhi`
--

-- --------------------------------------------------------

--
-- Table structure for table `core_mail_template`
--

CREATE TABLE `core_mail_template` (
  `id` int(10) UNSIGNED NOT NULL COMMENT 'Mail Template Uuid',
  `name` varchar(128) NOT NULL COMMENT 'Name',
  `code` varchar(128) NOT NULL COMMENT 'Code',
  `from_email` varchar(128) NOT NULL COMMENT 'From Email',
  `to_email` text DEFAULT NULL COMMENT 'To Email',
  `cc` text DEFAULT NULL COMMENT 'Cc',
  `bcc` text DEFAULT NULL COMMENT 'Bcc',
  `subject` text NOT NULL COMMENT 'Subject',
  `content` text NOT NULL COMMENT 'Content',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Created At',
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Update At',
  `variables` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Mail Template Table';

--
-- Dumping data for table `core_mail_template`
--

INSERT INTO `core_mail_template` (`id`, `name`, `code`, `from_email`, `to_email`, `cc`, `bcc`, `subject`, `content`, `created_at`, `updated_at`, `variables`) VALUES
(1, 'Customer Sign up', 'CUSTOMER_SIGN_UP', 'do-not-Reply@traveldwar.com', NULL, '', '', 'Welcome to {{SiteName}}', '<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\r\n<html xmlns=\"http://www.w3.org/1999/xhtml\">\r\n<head>\r\n<meta name=\"viewport\" content=\"width=device-width\" />\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\" />\r\n<title>User Sign up</title>\r\n<link href=\"pages/css/mail.css\" media=\"all\" rel=\"stylesheet\" type=\"text/css\" />\r\n</head>\r\n\r\n<body itemscope itemtype=\"http://schema.org/EmailMessage\" style=\"-webkit-font-smoothing: antialiased;-webkit-text-size-adjust: none;width: 100% !important;height: 100%;line-height: 1.6;background-color: #f6f6f6;margin: 0;font-family: \'Raleway\', sans-serif;box-sizing: border-box;font-size: 14px;\">\r\n\r\n<table class=\"body-wrap\" style=\"background-color: #f6f6f6;display:table;margin:0 auto;padding-top: 40px;\">\r\n	<tr>\r\n\r\n		<td class=\"container\" width=\"600\" style=\"display: block !important;max-width: 600px !important;margin: 0 auto !important;clear: both !important;\">\r\n			<div class=\"content\" style=\"max-width: 600px;margin: 0 auto;display: block;padding: 20px;\">\r\n				<table class=\"main\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" style=\"background-color: #fff;border: 1px solid #e9e9e9;border-radius: 3px;border: 1px solid #999;\">\r\n                   \r\n					<tr>\r\n						<td class=\"content-wrap\" style=\"padding: 25px;\">\r\n							<table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\"> \r\n                                 <tr>\r\n                                   <td style=\"text-align: center; padding: 0 0 15px\">\r\n                                       \r\n                                             <img src=\"{{SiteLogo}}\" width=\"250\">\r\n                                        \r\n                                    </td>\r\n                                </tr>\r\n                                <tr>\r\n									<td class=\"content-block\" style=\"padding: 0 0 15px;vertical-align: top;\">\r\n										Dear {{CustomerName}},  \r\n									</td>\r\n								</tr>\r\n								<tr>\r\n									<td class=\"content-block\" style=\"padding: 0 0 15px;vertical-align: top;\">\r\n										<p style=\"font-weight: normal;font-size: 14px; margin: 0;\">Welcome to the world of {{SiteName}}.</p>\r\n									</td>\r\n								</tr>\r\n                                <tr>\r\n                                	<td class=\"content-block\" style=\"padding: 0 0 15px;vertical-align: top;\">\r\n                                        We are excited that you have registered with {{SiteName}} and look forward to meeting all your travel needs!\r\n                                    </td>\r\n                                </tr>\r\n                                <tr>\r\n                                	<td class=\"content-block\" style=\"padding: 0 0 15px;vertical-align: top;\">\r\n										Please note that the email address we have on file for you is {{CustomerEmail}}.		\r\n                                    </td>\r\n                                </tr>\r\n                                <tr>\r\n                                	<td class=\"content-block\" style=\"padding: 0 0 15px;vertical-align: top;\">\r\n                                        If you are not redirected upon link above, please copy and paste the link below into your web browser: \r\n<a href=\"{{ActivationLink}}\" target=\"_blank\" style=\"color: rgb(52, 142, 218);\">Click Here</a>                                   \r\n                                     </td>\r\n                                </tr>\r\n                                <tr>\r\n                                	<td style=\"vertical-align: top; padding:15px 0px 0px 0px\">\r\n										It\'s our pleasure to help you see the world your way!!<br>\r\n										Sincerely, <br>\r\n                                        {{SiteName}} Team!!\r\n                                    </td>\r\n                                </tr>\r\n							</table>\r\n						</td>\r\n					</tr>\r\n				</table>\r\n			</div>\r\n		</td>\r\n\r\n	</tr>\r\n</table>\r\n\r\n</body>\r\n</html>', '2018-07-23 12:55:10', '2022-05-31 13:07:52', ' {{SiteName}}, {{CustomerName}}, {{CustomerEmail}}'),
(2, 'Forgot Password', 'FORGOT_PASSWORD', 'do-not-Reply@traveldwar.com', NULL, '', '', 'Reset your Password | {{SiteName}} ', '<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\r\n<html xmlns=\"http://www.w3.org/1999/xhtml\">\r\n<head>\r\n<meta name=\"viewport\" content=\"width=device-width\" />\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\" />\r\n<title>Forgot Password</title>\r\n<link href=\"pages/css/mail.css\" media=\"all\" rel=\"stylesheet\" type=\"text/css\" />\r\n</head>\r\n\r\n<body itemscope itemtype=\"http://schema.org/EmailMessage\" style=\"-webkit-font-smoothing: antialiased;-webkit-text-size-adjust: none;width: 100% !important;height: 100%;line-height: 1.6;background-color: #f6f6f6;margin: 0;font-family: \'Raleway\', sans-serif;box-sizing: border-box;font-size: 14px;\">\r\n\r\n<table class=\"body-wrap\" style=\"background-color: #f6f6f6;display:table;margin:0 auto;padding-top: 40px;\">\r\n	<tr>\r\n\r\n		<td class=\"container\" width=\"600\" style=\"display: block !important;max-width: 600px !important;margin: 0 auto !important;clear: both !important;\">\r\n			<div class=\"content\" style=\"max-width: 600px;margin: 0 auto;display: block;padding: 20px;\">\r\n				<table class=\"main\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" style=\"background-color: #fff;border: 1px solid #e9e9e9;border-radius: 3px;border: 1px solid #999;\">\r\n                    \r\n					<tr>\r\n						<td style=\"padding: 25px;\">\r\n							<table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\"> \r\n                                <tr>\r\n                                   <td style=\"text-align: center; padding: 0 0 15px\">\r\n                                       \r\n                                           \r\n                                             <img src=\"{{SiteLogo}}\" width=\"250\">\r\n                                        \r\n                                        \r\n                                    </td>\r\n                                </tr>\r\n                                <tr>\r\n									<td style=\"padding: 0 0 15px;vertical-align: top;\">\r\n										Dear {{CustomerName}}, \r\n									</td>\r\n								</tr>\r\n								<tr>\r\n									<td style=\"padding: 0 0 15px;vertical-align: top;\">\r\n										<p style=\"font-weight: normal;font-size: 14px; margin: 0;\">\r\n                                            Can\'t remember your password? Don\'t worry about it !! It happens.</p>\r\n									</td>\r\n								</tr>\r\n                                <tr>\r\n                                	<td style=\"padding: 0 0 15px;vertical-align: top;\">\r\n                                    	<a href=\"{{forgotPasswordLink}}\" target=\"_blank\" style=\"color: rgb(52, 142, 218);\">Click Here</a> \r\n                                    </td>\r\n                                </tr>\r\n                                <tr>\r\n                                	<td style=\"padding: 0 0 15px;vertical-align: top;\">\r\n                                    	Didn\'t ask to reset your password? If you didn\'t ask for your password, it\'s likely that another user entered your username or email address by mistake while trying to reset their password. If that\'s the case, you don\'t need to take any further action and can safely disregard this email.\r\n                                    </td>\r\n                                </tr>\r\n                               \r\n                                <tr>\r\n                                	<td style=\"vertical-align: top; padding:15px 0px 0px 0px\">\r\n                                    	Thanks,<br>\r\n                                        {{SiteName}} Team!!\r\n                                    </td>\r\n                                </tr>\r\n							</table>\r\n						</td>\r\n					</tr>\r\n				</table>\r\n			</div>\r\n		</td>\r\n\r\n	</tr>\r\n</table>\r\n\r\n</body>\r\n</html>\r\n', '2018-07-24 20:25:03', '2022-05-31 13:09:50', '{{CustomerName}}, {{SiteName}} '),
(3, 'Recharge Success', 'Rechage_success', 'do-not-Reply@traveldwar.com', NULL, '', '', 'Recharge Success| {{SiteName}} ', '<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\r\n<html xmlns=\"http://www.w3.org/1999/xhtml\">\r\n<head>\r\n<meta name=\"viewport\" content=\"width=device-width\" />\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\" />\r\n<title>Forgot Password</title>\r\n<link href=\"pages/css/mail.css\" media=\"all\" rel=\"stylesheet\" type=\"text/css\" />\r\n</head>\r\n\r\n<body itemscope itemtype=\"http://schema.org/EmailMessage\" style=\"-webkit-font-smoothing: antialiased;-webkit-text-size-adjust: none;width: 100% !important;height: 100%;line-height: 1.6;background-color: #f6f6f6;margin: 0;font-family: \'Raleway\', sans-serif;box-sizing: border-box;font-size: 14px;\">\r\n\r\n<table class=\"body-wrap\" style=\"background-color: #f6f6f6;display:table;margin:0 auto;padding-top: 40px;\">\r\n	<tr>\r\n\r\n		<td class=\"container\" width=\"600\" style=\"display: block !important;max-width: 600px !important;margin: 0 auto !important;clear: both !important;\">\r\n			<div class=\"content\" style=\"max-width: 600px;margin: 0 auto;display: block;padding: 20px;\">\r\n				<table class=\"main\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" style=\"background-color: #fff;border: 1px solid #e9e9e9;border-radius: 3px;border: 1px solid #999;\">\r\n                    \r\n					<tr>\r\n						<td style=\"padding: 25px;\">\r\n							<table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\"> \r\n                                <tr>\r\n                                   <td style=\"text-align: center; padding: 0 0 15px\">\r\n                                       \r\n                                           \r\n                                             <img src=\"{{SiteLogo}}\" width=\"250\">\r\n                                        \r\n                                        \r\n                                    </td>\r\n                                </tr>\r\n                                <tr>\r\n									<td style=\"padding: 0 0 15px;vertical-align: top;\">\r\n										Dear {{CustomerName}}, \r\n									</td>\r\n								</tr>\r\n								<tr>\r\n									<td style=\"padding: 0 0 15px;vertical-align: top;\">\r\n								<h2>Recharge SuccessFull.</h2>\r\n									</td>\r\n								</tr>\r\n                                <tr>\r\n                                	<td style=\"padding: 0 0 15px;vertical-align: top;\">\r\n                                    	<a href=\"{{topupLink}}\" target=\"_blank\" style=\"color: rgb(52, 142, 218);\">Click Here</a> \r\n                                    </td>\r\n                                </tr>\r\n                               \r\n                                <tr>\r\n                                	<td style=\"vertical-align: top; padding:15px 0px 0px 0px\">\r\n                                    	Thanks,<br>\r\n                                        {{SiteName}} Team!!\r\n                                    </td>\r\n                                </tr>\r\n							</table>\r\n						</td>\r\n					</tr>\r\n				</table>\r\n			</div>\r\n		</td>\r\n\r\n	</tr>\r\n</table>\r\n\r\n</body>\r\n</html>\r\n', '2018-07-24 20:25:03', '2022-05-31 13:11:04', '{{CustomerName}}, {{SiteName}}'),
(4, 'Bursato- Login OTP', 'LOGIN_OTP', 'DoNoReply@bursato.com', NULL, NULL, NULL, 'Reset your Password | {{SiteName}} ', '<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\r\n<html xmlns=\"http://www.w3.org/1999/xhtml\">\r\n<head>\r\n<meta name=\"viewport\" content=\"width=device-width\" />\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\" />\r\n<title>Forgot Password</title>\r\n<link href=\"pages/css/mail.css\" media=\"all\" rel=\"stylesheet\" type=\"text/css\" />\r\n</head>\r\n\r\n<body itemscope itemtype=\"http://schema.org/EmailMessage\" style=\"-webkit-font-smoothing: antialiased;-webkit-text-size-adjust: none;width: 100% !important;height: 100%;line-height: 1.6;background-color: #f6f6f6;margin: 0;font-family: \'Raleway\', sans-serif;box-sizing: border-box;font-size: 14px;\">\r\n\r\n<table class=\"body-wrap\" style=\"background-color: #f6f6f6;display:table;margin:0 auto;padding-top: 40px;\">\r\n	<tr>\r\n\r\n		<td class=\"container\" width=\"600\" style=\"display: block !important;max-width: 600px !important;margin: 0 auto !important;clear: both !important;\">\r\n			<div class=\"content\" style=\"max-width: 600px;margin: 0 auto;display: block;padding: 20px;\">\r\n				<table class=\"main\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" style=\"background-color: #fff;border: 1px solid #e9e9e9;border-radius: 3px;border: 1px solid #999;\">\r\n                    \r\n					<tr>\r\n						<td style=\"padding: 25px;\">\r\n							<table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\"> \r\n                                <tr>\r\n                                   <td style=\"text-align: center; padding: 0 0 15px\">\r\n                                       \r\n                                           \r\n                                             <img src=\"{{SiteLogo}}\" width=\"250\">\r\n                                        \r\n                                        \r\n                                    </td>\r\n                                </tr>\r\n                                <tr>\r\n									<td style=\"padding: 0 0 15px;vertical-align: top;\">\r\n										Dear {{CustomerName}}, \r\n									</td>\r\n								</tr>\r\n								<tr>\r\n									<td style=\"padding: 0 0 15px;vertical-align: top;\">\r\n								<h2>Your OTP valid till next 20 mins, please do not share with others.</h2>\r\n									</td>\r\n								</tr>\r\n                                <tr>\r\n                                	<td style=\"padding: 0 0 15px;vertical-align: top;\">\r\n                                    	{{OTP}} \r\n                                    </td>\r\n                                </tr>\r\n                               \r\n                                <tr>\r\n                                	<td style=\"vertical-align: top; padding:15px 0px 0px 0px\">\r\n                                    	Thanks,<br>\r\n                                        {{SiteName}} Team!!\r\n                                    </td>\r\n                                </tr>\r\n							</table>\r\n						</td>\r\n					</tr>\r\n				</table>\r\n			</div>\r\n		</td>\r\n\r\n	</tr>\r\n</table>\r\n\r\n</body>\r\n</html>\r\n', '2022-04-30 01:55:59', '2022-05-31 13:11:47', '{{CustomerName}}, {{OTP}}, {{SiteName}}');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `core_mail_template`
--
ALTER TABLE `core_mail_template`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `code` (`code`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `core_mail_template`
--
ALTER TABLE `core_mail_template`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Mail Template Uuid', AUTO_INCREMENT=7;
COMMIT;

