· 8 years ago · Aug 11, 2018, 08:18 AM
1DROP TABLE IF EXISTS `email_templates`;
2CREATE TABLE `email_templates` (
3 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
4 `template_key` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
5 `template_title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
6 `template_tages` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
7 `email_subject` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
8 `email_content` text COLLATE utf8_unicode_ci,
9 `sms_content` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
10 `notification_content` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
11 `status` enum('Active','Inactive') COLLATE utf8_unicode_ci DEFAULT 'Active',
12 `deleted_at` timestamp NULL DEFAULT NULL,
13 `created_at` timestamp NULL DEFAULT NULL,
14 `updated_at` timestamp NULL DEFAULT NULL,
15 PRIMARY KEY (`id`)
16) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
17
18INSERT INTO `email_templates` (`id`, `template_key`, `template_title`, `template_tages`, `email_subject`, `email_content`, `sms_content`, `notification_content`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
19(1, 'FORGOT_PASSWORD', 'Forgot Password', '{#TO_NAME#}', 'Forgot Password.', '<p>Hello TO_NAME,<br />\r\n\r\n<strong>Welcome to BookMyTaxi,</strong><br />\r\nYou have requested a password reset, please click on the below link to reset your password.<br />\r\nPassword reset link: PASSWORD_RESET_LINK<br />\r\nBest Regards,<br />\r\n\r\nThe BookMyTaxi Team</p>', NULL, NULL, 'Active', NULL, NULL, '2018-07-31 07:44:54'),
20(2, 'EMAIL_VERIFICATION_LINK', 'Email Verification link', '{#TO_NAME#}', 'Activate Your Account.', '<p>Hello TO_NAME,<br />\r\n<strong>Welcome to BookMyTaxi.</strong><br />\r\nYou have successfully created an account with BookMyTaxi. You are one step away from accessing the BookMyTaxi. Please click on below link or copy paste in browser to activate your account.<br />\r\nEMAIL_VERIFICATION_LINK<br />\r\nBest Regards,<br />\r\nThe BookMyTaxi Team</p>', NULL, NULL, 'Active', NULL, NULL, '2018-07-31 07:46:25'),
21(3, 'RESET_PASSWORD', 'Reset Password.', '{#TO_NAME#}', 'Password updated.', '<p>Hello TO_NAME,<br />\r\n<strong>Welcome to BookMyTaxi.</strong></p>\r\n\r\n<p><br />\r\nYour password has been reset successfully.</p>\r\n\r\n<p><br />\r\nBest Regards,<br />\r\n\r\nThe BookMyTexi Team</p>', NULL, NULL, 'Active', NULL, NULL, '2018-08-01 01:19:11'),
22(4, 'CONTACT_US', 'New Inquiry', '', 'New Inquiry.', '<p>Hello Admin,<br />\r\n<strong>New Inquiry from the BookMyTaxi.</strong><br />\r\n<strong>Please refer to below details : </strong><br />\r\n </p>\r\n\r\n<table>\r\n <tbody>\r\n <tr>\r\n <td><strong>Name</strong></td>\r\n <td>NAME</td>\r\n </tr>\r\n <tr>\r\n <td><strong>Email</strong></td>\r\n <td>EMAIL</td>\r\n </tr>\r\n <tr>\r\n <td><strong>Phone</strong></td>\r\n <td>PHONE</td>\r\n </tr>\r\n <tr>\r\n <td><strong>Message</strong></td>\r\n <td>MESSAGE</td>\r\n </tr>\r\n </tbody>\r\n</table>\r\n\r\n<p>Best Regards,<br />\r\nThe BookByTaxi Team</p>', NULL, NULL, 'Active', NULL, NULL, '2018-07-31 07:45:52');