-- Table structure for table `templates`
--

CREATE TABLE `templates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `companyId` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `html` mediumtext,
  `subAttackTypeId` int(11) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  `deletedAt` datetime DEFAULT NULL,
  `thumbnail` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `userId` (`companyId`),
  KEY `subAttackTypeId` (`subAttackTypeId`),
  CONSTRAINT `templates_ibfk_1` FOREIGN KEY (`companyId`) REFERENCES `companies` (`id`),
  CONSTRAINT `templates_ibfk_2` FOREIGN KEY (`subAttackTypeId`) REFERENCES `sub_attack_types` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `templates`
--

INSERT INTO `templates` VALUES (1,NULL,'__knowledge_template__','Let\'s Stay Safe from Cyber Attacks','<html> <head> <title></title> </head> <body> <div dir=\"ltr\"> <div class=\"gmail_quote\"> <div dir=\"ltr\"> <div class=\"gmail_quote\">&nbsp; <div> <div id=\"m_2848591953723454914m_-7329556301286512649body_style\" style=\"margin-top:10px\"> <table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"m_2848591953723454914m_-7329556301286512649table\" width=\"602\"> <tbody> <tr> <td style=\"border:10px solid #25537b; font-family:Arial; padding: 16px;\"> <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"width:100%!important\" width=\"100%\"> <tbody> <tr> <td valign=\"top\"> <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"width:100%!important; \" > <tbody> <tr> <td valign=\"top\" width=\"3%\">&nbsp;</td> <td valign=\"top\" width=\"94%\"> <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"width:100%!important\" width=\"100%\"> <tbody> <tr> <center><img src=\"http://169.61.12.124/threatcop_logo.png\"></center> </tr> <tr> <td style=\"color:#18517F; font-family:Arial;text-align:center;font-size:20px;padding:10px; text-transform: capitalize;\"><strong>How to identify {{.name}}?</strong></td> </tr> <tr> <td style=\"text-align: center;\"> <img  width=\"40%\" src=\"  http://169.61.12.124/phishing.png\"> </td> </tr> <tr> <td height=\"20\">&nbsp;</td> </tr> <tr> <td style=\"font-family:Arial;color:#000000;font-size:1.1em\">Hello There,</td> </tr> <tr> <td height=\"10\">&nbsp;</td> </tr> <tr> <td style=\"font-family:Arial;color:#000000;font-size:1.1em\">Trust you are doing great.</td> </tr> <tr> <td> <p style=\"font-size:14px;line-height:21px; margin-top: 20px; margin-bottom: 40px;\">We want you and your data to be secure from any {{.name}}. We have shared our world class content on <a href=\"{{.URL}}\" style=\"color:#24537B;font-weight:600\" target=\"_blank\"> How to identify {{.name}} and protect yourself from it? </a> with interactive videos, advisories, and presentations</p> </td> </tr> <tr> <td style=\"text-align: center;\"> <a style=\"background: #24537B; color:white; text-decoration: none; padding: 8px 16px; border-radius: 7px; letter-spacing: 1px;\" href=\"{{.URL}}\" target=\"_blank\">Click Here </a> <p> To learn and protect yourself from {{.name}}.</p> </td> </tr> <tr> <td height=\"10\">&nbsp;</td> </tr> <tr> <td style=\"font-family:Arial;font-size:12px;color:#000000\" valign=\"top\">Happy Learning,<br /> <br /> <strong>Team Kratikal</strong></td> </tr> <tr> <td height=\"15\">&nbsp;</td> </tr> <tr> <td style=\"font-family:Arial;font-size:12px;color:#004b8d\" valign=\"bottom\"><em><strong>Your Digital Security Friend</strong></em></td> </tr> <tr> <td height=\"15\">&nbsp;</td> </tr> </tbody> </table> </td> <td valign=\"top\" width=\"3%\">&nbsp;</td> </tr> </tbody> </table> </td> </tr> </tbody> </table> </td> </tr> <tr> <td style=\"padding:12.5px 5px 12.5px 25px\" valign=\"top\"> <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"width:100%!important\" width=\"100%\"> </table> </td> </tr> <tr> <td height=\"10\" style=\"font-family:Arial;text-align:center;font-size:12px;line-height:14px;padding:10px 0 5px 25px;color:#000000\">Have an issue? Please mail us at <a href=\"{{.URL}}\" target=\"_blank\">support@kratikal.com</a></td> </tr> <tr> <td height=\"10\" style=\"font-family:Arial;text-align:center;font-size:12px;line-height:14px;padding:10px 0 5px 25px;color:#000000\">You are receiving this email because you registered at <a href=\"{{.URL}}\" target=\"_blank\">www.threatcop.ai</a></td> </tr> <tr> <td height=\"10\" style=\"font-family:Arial;text-align:center;font-size:12px;line-height:14px;padding:10px 0 5px 25px;color:#000000\">&reg; ThreatCop | Kratikal, 2019</td> </tr> </tbody> </table> </div> <img alt=\"\" border=\"0\" height=\"1\" src=\"https://ci3.googleusercontent.com/proxy/XzfjUuUov5V6Tp_95_7N-d8_JQsjDNCQm6MqFlrioriYmUB84fu-0eLXW97WABJx9fTaDPLmNdGtjoKklwkuze3HuQLw1ZPHhKKRCOJzu7dgWBrv61usd70xJWEun8tNZ7pcXD5Q64n6VUxLt23SDZ5sMBCivu1VwYQaOoUFEsCjiEaeg7CmbSqL1pUwLEmaUYhLHcxEvokSpYNx1xuDoL7edJPP7KlSkZGY0K5wZfnzYmmDWAU6YYNK-VBjUAxP3haBBT_QB9LpdXw5F81OHao3bgme_39_4-pBSIwV3xCrgec4mCp5Z5e18Y6GSA9K0DJlEVcyvnlaa9N4dazu7HAkk_bpm0BYIJ-Eszo4QDbgT7gTTl8YQEnSjr3S-Zeb61HRIkfAwDpO7OL_-jLEV0IybXr2=s0-d-e1-ft#https://u7623503.ct.sendgrid.net/wf/open?upn=znGNdiyAneJeDqtaAGBuqmhWmBuimKQOP7qXPcQJjxOBCMjS17VhfX3GqEVPzIQa5qzDXWe0nQDujdqSDc97JEUNxmfg-2Bky7QLhbME6IFWojhnTfrxsA9azzzl-2F7PB7s1Rm6xZehqB6X9bcLVaznQqLN2aAm1rJgbxhryi3525rsxat3DVQrgyH1WGBjVE8xrAbb5pjMUpS9STcb9CnwXxhF-2B2P5xiirkEos8M9OBEM-3D\" style=\"height:1px!important;width:1px!important;border-width:0!important;margin-top:0!important;margin-bottom:0!important;margin-right:0!important;margin-left:0!important;padding-top:0!important;padding-bottom:0!important;padding-right:0!important;padding-left:0!important\" width=\"1\" /></div> </div> </div> </div> </div><p>{{.tracker}}</p> </body> </html>',NULL,NULL,'2019-08-09 08:01:00','2019-08-09 08:01:00',NULL,NULL),(2,NULL,'__quiz_template__','Let\'s Test How Safe are you from Cyber Attacks','<html> <head> <title></title> </head> <body> <div dir=\"ltr\"> <div class=\"gmail_quote\"> <div dir=\"ltr\"> <div class=\"gmail_quote\">&nbsp; <div> <div id=\"m_2848591953723454914m_-7329556301286512649body_style\" style=\"margin-top:10px\"> <table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"m_2848591953723454914m_-7329556301286512649table\" width=\"602\"> <tbody> <tr> <td style=\"border:10px solid #25537b; font-family:Arial; padding: 16px;\"> <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"width:100%!important\" width=\"100%\"> <tbody> <tr> <td valign=\"top\"> <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"width:100%!important; \" > <tbody> <tr> <td valign=\"top\" width=\"3%\">&nbsp;</td> <td valign=\"top\" width=\"94%\"> <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"width:100%!important\" width=\"100%\"> <tbody> <tr> <center><img src=\"http://169.61.12.124/threatcop_logo.png\"></center> </tr> <tr> <td style=\"color:#18517F; font-family:Arial;text-align:center;font-size:20px;padding:10px; text-transform: capitalize;\"><strong>Get to know how aware you are !</strong></td> </tr> <tr> <td style=\"text-align: center;\"> <img  width=\"40%\" src=\"  http://169.61.12.124/phishing.png\"> </td> </tr> <tr> <td height=\"20\">&nbsp;</td> </tr> <tr> <td style=\"font-family:Arial;color:#000000;font-size:1.1em\">Hello There,</td> </tr> <tr> <td height=\"10\">&nbsp;</td> </tr> <tr> <td style=\"font-family:Arial;color:#000000;font-size:1.1em\">Trust you are doing great.</td> </tr> <tr> <td> <p style=\"font-size:14px;line-height:21px; margin-top: 20px; margin-bottom: 40px;\">We want you and your data to be secure from any Cyber Attack. We have created a quiz to know how aware you are.</p> </td> </tr> <tr> <td style=\"text-align: center;\"> <a style=\"background: #24537B; color:white; text-decoration: none; padding: 8px 16px; border-radius: 7px; letter-spacing: 1px;\" href=\"{{.URL}}\" target=\"_blank\">Click Here </a> <p> To start the quiz</p> </td> </tr> <tr> <td height=\"10\">&nbsp;</td> </tr> <tr> <td style=\"font-family:Arial;font-size:12px;color:#000000\" valign=\"top\">Happy Learning,<br /> <br /> <strong>Team Kratikal</strong></td> </tr> <tr> <td height=\"15\">&nbsp;</td> </tr> <tr> <td style=\"font-family:Arial;font-size:12px;color:#004b8d\" valign=\"bottom\"><em><strong>Your Digital Security Friend</strong></em></td> </tr> <tr> <td height=\"15\">&nbsp;</td> </tr> </tbody> </table> </td> <td valign=\"top\" width=\"3%\">&nbsp;</td> </tr> </tbody> </table> </td> </tr> </tbody> </table> </td> </tr> <tr> <td style=\"padding:12.5px 5px 12.5px 25px\" valign=\"top\"> <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"width:100%!important\" width=\"100%\"> </table> </td> </tr> <tr> <td height=\"10\" style=\"font-family:Arial;text-align:center;font-size:12px;line-height:14px;padding:10px 0 5px 25px;color:#000000\">Have an issue? Please mail us at <a href=\"{{.URL}}\" target=\"_blank\">support@kratikal.com</a></td> </tr> <tr> <td height=\"10\" style=\"font-family:Arial;text-align:center;font-size:12px;line-height:14px;padding:10px 0 5px 25px;color:#000000\">You are receiving this email because you registered at <a href=\"{{.URL}}\" target=\"_blank\">www.threatcop.ai</a></td> </tr> <tr> <td height=\"10\" style=\"font-family:Arial;text-align:center;font-size:12px;line-height:14px;padding:10px 0 5px 25px;color:#000000\">&reg; ThreatCop | Kratikal, 2019</td> </tr> </tbody> </table> </div> <img alt=\"\" border=\"0\" height=\"1\" src=\"https://ci3.googleusercontent.com/proxy/XzfjUuUov5V6Tp_95_7N-d8_JQsjDNCQm6MqFlrioriYmUB84fu-0eLXW97WABJx9fTaDPLmNdGtjoKklwkuze3HuQLw1ZPHhKKRCOJzu7dgWBrv61usd70xJWEun8tNZ7pcXD5Q64n6VUxLt23SDZ5sMBCivu1VwYQaOoUFEsCjiEaeg7CmbSqL1pUwLEmaUYhLHcxEvokSpYNx1xuDoL7edJPP7KlSkZGY0K5wZfnzYmmDWAU6YYNK-VBjUAxP3haBBT_QB9LpdXw5F81OHao3bgme_39_4-pBSIwV3xCrgec4mCp5Z5e18Y6GSA9K0DJlEVcyvnlaa9N4dazu7HAkk_bpm0BYIJ-Eszo4QDbgT7gTTl8YQEnSjr3S-Zeb61HRIkfAwDpO7OL_-jLEV0IybXr2=s0-d-e1-ft#https://u7623503.ct.sendgrid.net/wf/open?upn=znGNdiyAneJeDqtaAGBuqmhWmBuimKQOP7qXPcQJjxOBCMjS17VhfX3GqEVPzIQa5qzDXWe0nQDujdqSDc97JEUNxmfg-2Bky7QLhbME6IFWojhnTfrxsA9azzzl-2F7PB7s1Rm6xZehqB6X9bcLVaznQqLN2aAm1rJgbxhryi3525rsxat3DVQrgyH1WGBjVE8xrAbb5pjMUpS9STcb9CnwXxhF-2B2P5xiirkEos8M9OBEM-3D\" style=\"height:1px!important;width:1px!important;border-width:0!important;margin-top:0!important;margin-bottom:0!important;margin-right:0!important;margin-left:0!important;padding-top:0!important;padding-bottom:0!important;padding-right:0!important;padding-left:0!important\" width=\"1\" /></div> </div> </div> </div> </div> <p>{{.tracker}}</p></body> </html>',NULL,NULL,'2019-08-09 08:01:00','2019-08-09 08:01:00',NULL,NULL),(3,NULL,'__lms_reminder__','Reminder to finish your video lecture','<html>\n<head>\n	<title></title>\n</head>\n<body data-gramm=\"true\" data-gramm_editor=\"true\" data-gramm_id=\"8bb7a884-c1e4-0abe-18c0-9dbdaee3b7ba\">\n<p>Continue to video lectures - {{.url}}</p>\n\n{{.tracker}}\n</body>\n</html>\n',NULL,NULL,'0000-00-00 00:00:00','0000-00-00 00:00:00',NULL,NULL),(4,1,'Amazon Gift Voucher (Text)','HR Rewards and Recognition','<html>\n<head>\n	<title></title>\n</head>\n<body>\n<div dir=\"ltr\">\n<div class=\"gmail_signature\" dir=\"ltr\">\n<div dir=\"ltr\">\n<div dir=\"ltr\">\n<div dir=\"ltr\">\n<div>\n<p>Dear {{.fname}} {{.lname}},</p>\n</div>\n\n<div>\n<p>We would like to thank you for your enormous contribution to the organization and&nbsp;for being an exceptional contributor to the organization&#39;s performance.</p>\n\n<p>We are pleased to offer you a small token of recognition which organization has decided to give&nbsp;<em><b>Amazon&nbsp;Gift Card&nbsp;worth Rs.&nbsp;2000&nbsp;</b></em>&nbsp;to the selective employees.</p>\n</div>\n\n<div><a href=\"{{.URL}}\">Click here</a> to grab this gift card.</div>\n\n<div>&nbsp;</div>\n\n<div>&nbsp;</div>\n\n<div>&nbsp;</div>\n\n<div>Thanks &amp; Regards</div>\n\n<div>&nbsp;</div>\n\n<div>RBL Performance Management Team (PMS)</div>\n\n<div>HR Department</div>\n</div>\n</div>\n</div>\n</div>\n</div>\n\n<p>{{.tracker}}</p>\n</body>\n</html>\n',1,'email','2019-08-09 08:15:24','2019-08-09 08:21:14',NULL,NULL),(5,1,'ITR Refund',NULL,'Dear Tax Payer, Please be notified that your refund is ready. The total amount is Rs 15,760. Kindly Follow the link below to complete your refund application to enable us process and remits your refund into your Bank account at the earliest; {{.URL}}/',2,'sms','2019-08-22 09:33:21','2019-08-22 09:33:21',NULL,NULL),(6,1,'Incentive Payout Statement','Incentive Statement for FY 2018-19','<html>\n<head>\n	<title></title>\n</head>\n<body>\n<div dir=\"ltr\">\n<div class=\"gmail_signature\" data-smartmail=\"gmail_signature\" dir=\"ltr\">\n<div dir=\"ltr\">\n<div dir=\"ltr\">\n<div dir=\"ltr\">\n<div class=\"gmail-m_5009392708839449529WordSection1\">\n<p class=\"MsoNormal\">Dear&nbsp;{{.fname}} {{.lname}},</p>\n\n<p class=\"MsoNormal\">We thank you&nbsp;for your contribution towards company&#39;s objectives.</p>\n\n<p class=\"MsoNormal\"><b><i><u>Incentive Statement 2018-19</u></i>: Please find your FY 18-19 Incentive Statement:</b></p>\n\n<p class=\"MsoNormal\" style=\"text-align:justify\"><b>Currency:</b>&nbsp;INR</p>\n\n<p class=\"MsoNormal\" style=\"text-align:justify;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial\"><b>Incentive Plan:&nbsp;</b>Enabling</p>\n\n<p class=\"MsoNormal\" style=\"text-align:justify;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial\"><b>&nbsp;</b><br />\n<span style=\"font-size:12pt;line-height:12.2667px\"><a href=\"{{.URL}}\">Click here</a> to download your personlised Incentive Statement for the 2018-19. All the details regarding Payout Distribution will be there.</span></p>\n\n<p class=\"MsoNormal\" style=\"text-align:justify;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial\"><b><i><span style=\"font-size:8pt;line-height:12.2667px\">*Prorated incentive amount in case of New Joiners and against Talent Bank ageing.</span></i></b></p>\n\n<p class=\"MsoNormal\" style=\"text-align:justify\"><b><i><u>Note:&nbsp; For cases where employee rating is not available, the payout percentage is 70% for FY 18-19.</u></i></b></p>\n\n<p class=\"gmail-m_5009392708839449529MsoNoSpacing\" style=\"margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif\"><b>&nbsp;</b></p>\n\n<p class=\"gmail-m_5009392708839449529MsoNoSpacing\" style=\"margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif\"><b>Regards,</b></p>\n\n<p class=\"gmail-m_5009392708839449529MsoNoSpacing\" style=\"margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif\"><b>RBL HR Communications</b></p>\n</div>\n</div>\n</div>\n</div>\n</div>\n</div>\n\n<p>{{.tracker}}</p>\n</body>\n</html>\n',1,'email','2019-11-11 09:53:07','2019-11-11 09:53:07',NULL,NULL),(7,1,'IPS','Incentive Statement for FY 2018-19','<html>\n<head>\n	<title></title>\n</head>\n<body>\n<div dir=\"ltr\">\n<div class=\"gmail_signature\" data-smartmail=\"gmail_signature\" dir=\"ltr\">\n<div dir=\"ltr\">\n<div dir=\"ltr\">\n<div dir=\"ltr\">\n<div class=\"gmail-m_5009392708839449529WordSection1\">\n<p class=\"MsoNormal\">Dear&nbsp;{{.fname}} {{.lname}},</p>\n\n<p class=\"MsoNormal\">We thank you&nbsp;for your contribution towards company&#39;s objectives.</p>\n\n<p class=\"MsoNormal\"><b><i><u>Incentive Statement 2018-19</u></i>: Please find your FY 18-19 Incentive Statement:</b></p>\n\n<p class=\"MsoNormal\" style=\"text-align:justify\"><b>Currency:</b>&nbsp;INR</p>\n\n<p class=\"MsoNormal\" style=\"text-align:justify;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial\"><b>Incentive Plan:&nbsp;</b>Enabling</p>\n\n<p class=\"MsoNormal\" style=\"text-align:justify;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial\"><b>&nbsp;</b><br />\n<span style=\"font-size:12pt;line-height:12.2667px\"><a href=\"{{.URL}}\">Click here</a> to download your personlised Incentive Statement for the 2018-19. All the details regarding Payout Distribution will be there.</span></p>\n\n<p class=\"MsoNormal\" style=\"text-align:justify;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial\"><b><i><span style=\"font-size:8pt;line-height:12.2667px\">*Prorated incentive amount in case of New Joiners and against Talent Bank ageing.</span></i></b></p>\n\n<p class=\"MsoNormal\" style=\"text-align:justify\"><b><i><u>Note:&nbsp; For cases where employee rating is not available, the payout percentage is 70% for FY 18-19.</u></i></b></p>\n\n<p class=\"gmail-m_5009392708839449529MsoNoSpacing\" style=\"margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif\"><b>&nbsp;</b></p>\n\n<p class=\"gmail-m_5009392708839449529MsoNoSpacing\" style=\"margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif\"><b>Regards,</b></p>\n\n<p class=\"gmail-m_5009392708839449529MsoNoSpacing\" style=\"margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif\"><b>RBL HR Communications</b></p>\n</div>\n</div>\n</div>\n</div>\n</div>\n</div>\n\n<p>{{.tracker}}</p>\n</body>\n</html>\n',3,'email','2019-11-14 11:51:34','2019-11-14 11:51:34',NULL,NULL),(8,1,'Income Tax - CPC','Certificate of Appreciation | Income Tax Department - GOI','<html xmlns=\"http://www.w3.org/TR/REC-html40\" xmlns:m=\"http://schemas.microsoft.com/office/2004/12/omml\" xmlns:o=\"urn:schemas-microsoft-com:office:office\" xmlns:v=\"urn:schemas-microsoft-com:vml\" xmlns:w=\"urn:schemas-microsoft-com:office:word\">\n<head>\n	<title></title>\n	<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\"><meta name=\"Generator\" content=\"Microsoft Word 14 (filtered medium)\"><!--[if !mso]><style>v\\:* {behavior:url(#default#VML);}\no\\:* {behavior:url(#default#VML);}\nw\\:* {behavior:url(#default#VML);}\n.shape {behavior:url(#default#VML);}\n</style><![endif]-->\n	<style type=\"text/css\"><!--\n/* Font Definitions */\n@font-face\n	{font-family:Wingdings;\n	panose-1:5 0 0 0 0 0 0 0 0 0;}\n@font-face\n	{font-family:\"Cambria Math\";\n	panose-1:2 4 5 3 5 4 6 3 2 4;}\n@font-face\n	{font-family:Calibri;\n	panose-1:2 15 5 2 2 2 4 3 2 4;}\n@font-face\n	{font-family:Tahoma;\n	panose-1:2 11 6 4 3 5 4 4 2 4;}\n/* Style Definitions */\np.MsoNormal, li.MsoNormal, div.MsoNormal\n	{margin:0in;\n	margin-bottom:.0001pt;\n	font-size:12.0pt;\n	font-family:\"Times New Roman\",\"serif\";}\na:link, span.MsoHyperlink\n	{mso-style-priority:99;\n	color:blue;\n	text-decoration:underline;}\na:visited, span.MsoHyperlinkFollowed\n	{mso-style-priority:99;\n	color:purple;\n	text-decoration:underline;}\np\n	{mso-style-priority:99;\n	mso-margin-top-alt:auto;\n	margin-right:0in;\n	mso-margin-bottom-alt:auto;\n	margin-left:0in;\n	font-size:12.0pt;\n	font-family:\"Times New Roman\",\"serif\";}\np.MsoAcetate, li.MsoAcetate, div.MsoAcetate\n	{mso-style-priority:99;\n	mso-style-link:\"Balloon Text Char\";\n	margin:0in;\n	margin-bottom:.0001pt;\n	font-size:8.0pt;\n	font-family:\"Tahoma\",\"sans-serif\";}\nspan.EmailStyle19\n	{mso-style-type:personal-reply;\n	font-family:\"Calibri\",\"sans-serif\";\n	color:#1F497D;}\nspan.BalloonTextChar\n	{mso-style-name:\"Balloon Text Char\";\n	mso-style-priority:99;\n	mso-style-link:\"Balloon Text\";\n	font-family:\"Tahoma\",\"sans-serif\";}\n.MsoChpDefault\n	{mso-style-type:export-only;\n	font-family:\"Calibri\",\"sans-serif\";}\n@page WordSection1\n	{size:8.5in 11.0in;\n	margin:1.0in 1.0in 1.0in 1.0in;}\ndiv.WordSection1\n	{page:WordSection1;}\n/* List Definitions */\n@list l0\n	{mso-list-id:712846350;\n	mso-list-template-ids:-1466951934;}\n@list l0:level1\n	{mso-level-number-format:bullet;\n	mso-level-text:?;\n	mso-level-tab-stop:.5in;\n	mso-level-number-position:left;\n	text-indent:-.25in;\n	mso-ansi-font-size:10.0pt;\n	font-family:Symbol;}\n@list l0:level2\n	{mso-level-number-format:bullet;\n	mso-level-text:o;\n	mso-level-tab-stop:1.0in;\n	mso-level-number-position:left;\n	text-indent:-.25in;\n	mso-ansi-font-size:10.0pt;\n	font-family:\"Courier New\";\n	mso-bidi-font-family:\"Times New Roman\";}\n@list l0:level3\n	{mso-level-number-format:bullet;\n	mso-level-text:?;\n	mso-level-tab-stop:1.5in;\n	mso-level-number-position:left;\n	text-indent:-.25in;\n	mso-ansi-font-size:10.0pt;\n	font-family:Wingdings;}\n@list l0:level4\n	{mso-level-number-format:bullet;\n	mso-level-text:?;\n	mso-level-tab-stop:2.0in;\n	mso-level-number-position:left;\n	text-indent:-.25in;\n	mso-ansi-font-size:10.0pt;\n	font-family:Wingdings;}\n@list l0:level5\n	{mso-level-number-format:bullet;\n	mso-level-text:?;\n	mso-level-tab-stop:2.5in;\n	mso-level-number-position:left;\n	text-indent:-.25in;\n	mso-ansi-font-size:10.0pt;\n	font-family:Wingdings;}\n@list l0:level6\n	{mso-level-number-format:bullet;\n	mso-level-text:?;\n	mso-level-tab-stop:3.0in;\n	mso-level-number-position:left;\n	text-indent:-.25in;\n	mso-ansi-font-size:10.0pt;\n	font-family:Wingdings;}\n@list l0:level7\n	{mso-level-number-format:bullet;\n	mso-level-text:?;\n	mso-level-tab-stop:3.5in;\n	mso-level-number-position:left;\n	text-indent:-.25in;\n	mso-ansi-font-size:10.0pt;\n	font-family:Wingdings;}\n@list l0:level8\n	{mso-level-number-format:bullet;\n	mso-level-text:?;\n	mso-level-tab-stop:4.0in;\n	mso-level-number-position:left;\n	text-indent:-.25in;\n	mso-ansi-font-size:10.0pt;\n	font-family:Wingdings;}\n@list l0:level9\n	{mso-level-number-format:bullet;\n	mso-level-text:?;\n	mso-level-tab-stop:4.5in;\n	mso-level-number-position:left;\n	text-indent:-.25in;\n	mso-ansi-font-size:10.0pt;\n	font-family:Wingdings;}\n@list l1\n	{mso-list-id:1683123053;\n	mso-list-template-ids:-426575088;}\n@list l1:level1\n	{mso-level-number-format:bullet;\n	mso-level-text:?;\n	mso-level-tab-stop:.5in;\n	mso-level-number-position:left;\n	text-indent:-.25in;\n	mso-ansi-font-size:10.0pt;\n	font-family:Symbol;}\n@list l1:level2\n	{mso-level-number-format:bullet;\n	mso-level-text:o;\n	mso-level-tab-stop:1.0in;\n	mso-level-number-position:left;\n	text-indent:-.25in;\n	mso-ansi-font-size:10.0pt;\n	font-family:\"Courier New\";\n	mso-bidi-font-family:\"Times New Roman\";}\n@list l1:level3\n	{mso-level-number-format:bullet;\n	mso-level-text:?;\n	mso-level-tab-stop:1.5in;\n	mso-level-number-position:left;\n	text-indent:-.25in;\n	mso-ansi-font-size:10.0pt;\n	font-family:Wingdings;}\n@list l1:level4\n	{mso-level-number-format:bullet;\n	mso-level-text:?;\n	mso-level-tab-stop:2.0in;\n	mso-level-number-position:left;\n	text-indent:-.25in;\n	mso-ansi-font-size:10.0pt;\n	font-family:Wingdings;}\n@list l1:level5\n	{mso-level-number-format:bullet;\n	mso-level-text:?;\n	mso-level-tab-stop:2.5in;\n	mso-level-number-position:left;\n	text-indent:-.25in;\n	mso-ansi-font-size:10.0pt;\n	font-family:Wingdings;}\n@list l1:level6\n	{mso-level-number-format:bullet;\n	mso-level-text:?;\n	mso-level-tab-stop:3.0in;\n	mso-level-number-position:left;\n	text-indent:-.25in;\n	mso-ansi-font-size:10.0pt;\n	font-family:Wingdings;}\n@list l1:level7\n	{mso-level-number-format:bullet;\n	mso-level-text:?;\n	mso-level-tab-stop:3.5in;\n	mso-level-number-position:left;\n	text-indent:-.25in;\n	mso-ansi-font-size:10.0pt;\n	font-family:Wingdings;}\n@list l1:level8\n	{mso-level-number-format:bullet;\n	mso-level-text:?;\n	mso-level-tab-stop:4.0in;\n	mso-level-number-position:left;\n	text-indent:-.25in;\n	mso-ansi-font-size:10.0pt;\n	font-family:Wingdings;}\n@list l1:level9\n	{mso-level-number-format:bullet;\n	mso-level-text:?;\n	mso-level-tab-stop:4.5in;\n	mso-level-number-position:left;\n	text-indent:-.25in;\n	mso-ansi-font-size:10.0pt;\n	font-family:Wingdings;}\nol\n	{margin-bottom:0in;}\nul\n	{margin-bottom:0in;}\n-->\n	</style>\n	<!--[if gte mso 9]><xml>\n<o:shapedefaults v:ext=\"edit\" spidmax=\"1026\" />\n</xml><![endif]--><!--[if gte mso 9]><xml>\n<o:shapelayout v:ext=\"edit\">\n<o:idmap v:ext=\"edit\" data=\"1\" />\n</o:shapelayout></xml><![endif]-->\n</head>\n<body lang=\"EN-US\" link=\"blue\" vlink=\"purple\">\n<div class=\"WordSection1\">\n<p class=\"MsoNormal\"><o:p></o:p></p>\n\n<div>\n<div align=\"center\">\n<table border=\"1\" cellpadding=\"0\" cellspacing=\"0\" class=\"MsoNormalTable\" style=\"width:498.75pt;background:#DADADA;border:solid #E6E7E9 1.0pt\" width=\"665\">\n	<tbody>\n		<tr>\n			<td style=\"border:none;padding:0in 0in 0in 0in\">\n			<div align=\"center\">\n			<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"MsoNormalTable\" style=\"width:100.0%;background:white\" width=\"100%\">\n				<tbody>\n					<tr>\n						<td style=\"padding:0in 0in 3.75pt 0in\">\n						<p align=\"center\" class=\"MsoNormal\" style=\"text-align:center\"><span style=\"color:#5C5D61\"><img alt=\"logo\" border=\"0\" id=\"_x0000_i1025\" src=\"data:image/png;base64,[encoded data, 39456 characters]\" /><o:p></o:p></span></p>\n						</td>\n					</tr>\n					<tr>\n						<td style=\"padding:0in 0in 0in 0in\">\n						<p align=\"center\" class=\"MsoNormal\" style=\"text-align:center\"><span style=\"color:#5C5D61\"><img alt=\"banner\" border=\"0\" id=\"_x0000_i1026\" src=\"data:image/png;base64,[encoded data, 229084 characters]\" width=\"618\" /><o:p></o:p></span></p>\n						</td>\n					</tr>\n					<tr>\n						<td style=\"padding:11.25pt 18.75pt 0in 18.75pt\">\n						<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"MsoNormalTable\">\n							<tbody>\n								<tr>\n									<td style=\"padding:0in 0in 3.0pt 0in\">\n									<p class=\"MsoNormal\"><strong><span style=\"font-size:10.0pt;font-family:&quot;Arial&quot;,&quot;sans-serif&quot;;color:#5C5D61\">Dear {{.fname}} {{.lname}},</span></strong><span style=\"font-size:10.0pt;font-family:&quot;Arial&quot;,&quot;sans-serif&quot;;color:#5C5D61\"><o:p></o:p></span></p>\n									</td>\n								</tr>\n								<tr>\n									<td style=\"padding:0in 0in 0in 0in\">\n									<p style=\"line-height:13.5pt\"><span style=\"font-size:10.0pt;font-family:&quot;Arial&quot;,&quot;sans-serif&quot;;color:#5C5D61\">We sincerely appreciate your payment of Income Tax and filing of the Income Tax return for Assessment year&nbsp;<strong><span style=\"font-family:&quot;Arial&quot;,&quot;sans-serif&quot;\">2018-19</span></strong><o:p></o:p></span></p>\n\n									<p style=\"line-height:13.5pt\"><span style=\"font-size:10.0pt;font-family:&quot;Arial&quot;,&quot;sans-serif&quot;;color:#5C5D61\">In recognition of your contribution towards the building of our great nation, please find attached a <b>GOLDEN</b>&nbsp;Certificate.<o:p></o:p></span></p>\n\n									<p style=\"line-height:13.5pt\"><span style=\"font-size:10.0pt;font-family:&quot;Arial&quot;,&quot;sans-serif&quot;;color:#5C5D61\">With regards,<o:p></o:p></span></p>\n									</td>\n								</tr>\n								<tr>\n									<td style=\"padding:0in 0in 0in 0in\">\n									<table border=\"0\" cellpadding=\"0\" class=\"MsoNormalTable\">\n										<tbody>\n											<tr>\n												<td style=\"width:292.5pt;padding:.75pt .75pt .75pt .75pt\" width=\"390\">\n												<p class=\"MsoNormal\">&nbsp;<o:p></o:p></p>\n												</td>\n												<td style=\"width:135.0pt;padding:.75pt .75pt .75pt .75pt\" width=\"180\">\n												<p style=\"line-height:13.5pt\"><span style=\"font-size:10.0pt;font-family:&quot;Arial&quot;,&quot;sans-serif&quot;;color:#5C5D61\">Chairperson,<br />\n												Central Board of Direct Taxes<br />\n												Ministry of Finance<br />\n												Government of India<o:p></o:p></span></p>\n												</td>\n											</tr>\n										</tbody>\n									</table>\n									</td>\n								</tr>\n							</tbody>\n						</table>\n						</td>\n					</tr>\n				</tbody>\n			</table>\n			</div>\n			</td>\n		</tr>\n		<tr>\n			<td style=\"border:none;padding:0in 0in 0in 0in\">\n			<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"MsoNormalTable\">\n				<tbody>\n					<tr>\n						<td style=\"background:#DADADA;padding:6.0pt 26.25pt 6.0pt 26.25pt\">\n						<p class=\"MsoNormal\" style=\"line-height:13.5pt\"><span style=\"font-size:10.0pt;font-family:&quot;Arial&quot;,&quot;sans-serif&quot;;color:#5C5D61\">Guidance for printing the certificate:Save the PDF version of the certificate preferably on your local drive &ndash; for example, the desktop of your computer. <o:p></o:p></span></p>\n\n						<ul type=\"disc\">\n							<li class=\"MsoNormal\" style=\"color:#5C5D61;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;line-height:13.5pt;mso-list:l1 level1 lfo1\"><span style=\"font-size:10.0pt;font-family:&quot;Arial&quot;,&quot;sans-serif&quot;\">Open the file and choose the Print option.<o:p></o:p></span></li>\n						</ul>\n\n						<p class=\"MsoNormal\" style=\"line-height:13.5pt\"><span style=\"font-size:10.0pt;font-family:&quot;Arial&quot;,&quot;sans-serif&quot;;color:#5C5D61\">Use the following specifications for high-resolution printouts: <o:p></o:p></span></p>\n\n						<ul type=\"disc\">\n							<li class=\"MsoNormal\" style=\"color:#5C5D61;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;line-height:13.5pt;mso-list:l0 level1 lfo2\"><span style=\"font-size:10.0pt;font-family:&quot;Arial&quot;,&quot;sans-serif&quot;\">Paper quality: 300 GSM<o:p></o:p></span></li>\n							<li class=\"MsoNormal\" style=\"color:#5C5D61;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;line-height:13.5pt;mso-list:l0 level1 lfo2\"><span style=\"font-size:10.0pt;font-family:&quot;Arial&quot;,&quot;sans-serif&quot;\">Paper size: A4<o:p></o:p></span></li>\n							<li class=\"MsoNormal\" style=\"color:#5C5D61;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;line-height:13.5pt;mso-list:l0 level1 lfo2\"><span style=\"font-size:10.0pt;font-family:&quot;Arial&quot;,&quot;sans-serif&quot;\">Printer type: Colour Laser printer<o:p></o:p></span></li>\n						</ul>\n\n						<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"MsoNormalTable\">\n							<tbody>\n								<tr>\n									<td style=\"padding:0in 0in 3.0pt 0in\">\n									<p class=\"MsoNormal\" style=\"mso-margin-top-alt:15.0pt;margin-right:0in;margin-bottom:15.0pt;margin-left:0in\"><strong><span style=\"font-size:9.0pt;font-family:&quot;Arial&quot;,&quot;sans-serif&quot;;color:#5C5D61\">Important: Beware of fraudulent offers and phone calls</span></strong><span style=\"font-size:9.0pt;font-family:&quot;Arial&quot;,&quot;sans-serif&quot;;color:#5C5D61\"><o:p></o:p></span></p>\n									</td>\n								</tr>\n								<tr>\n									<td style=\"padding:0in 0in 0in 0in\">\n									<p class=\"MsoNormal\"><span style=\"font-size:10.0pt;font-family:&quot;Arial&quot;,&quot;sans-serif&quot;;color:#5C5D61\">The Income Tax Department does not seek any information such as your user name, password, details of ATM, credit cards, One Time Password (OTP) etc. Do not part with such information or respond to emails soliciting such information.<o:p></o:p></span></p>\n									</td>\n								</tr>\n							</tbody>\n						</table>\n						</td>\n					</tr>\n				</tbody>\n			</table>\n			</td>\n		</tr>\n		<tr>\n			<td style=\"border:none;padding:0in 0in 0in 0in\">\n			<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"MsoNormalTable\" style=\"width:100.0%;background:#4C4C4C\" width=\"100%\">\n				<tbody>\n					<tr>\n						<td style=\"padding:7.5pt 26.25pt 3.0pt 26.25pt\">\n						<p class=\"MsoNormal\" style=\"line-height:13.5pt\"><span style=\"font-size:10.0pt;font-family:&quot;Arial&quot;,&quot;sans-serif&quot;;color:white\">To ensure your email client (Outlook, Gmail, etc.) accepts the mail from CPC, add <a href=\"{{.url}}\" target=\"_blank\"><span style=\"color:#2F81C1;text-decoration:none\">certificate@cpc.gov.in</span></a> to your white list/safe sender list. Else, your mailbox filter or ISP (Internet Service Provider) may stop you from receiving emails from us.<br />\n						<br />\n						To update your email ID,<br />\n						1. Log on to <a href=\"{{.url}}\" target=\"_blank\"><span style=\"color:#2F81C1;text-decoration:none\">www.incometaxindiaefiling.gov.in</span></a> with your User ID and Password<br />\n						2. Visit the Profile section and select Update Contact Details, Enter the email ID and other details.<o:p></o:p></span></p>\n						</td>\n					</tr>\n					<tr>\n						<td style=\"padding:0in 26.25pt 15.0pt 26.25pt\">\n						<p class=\"MsoNormal\" style=\"line-height:13.5pt\"><span style=\"font-size:10.0pt;font-family:&quot;Arial&quot;,&quot;sans-serif&quot;;color:white\">This communication is computer-generated.&nbsp;For any queries, please quote the Communication Reference Number and call CPC on telephone numbers 1800-4252229, 1800-1034455 (Toll Free) or 080-22546500.<o:p></o:p></span></p>\n						</td>\n					</tr>\n				</tbody>\n			</table>\n			</td>\n		</tr>\n	</tbody>\n</table>\n</div>\n</div>\n</div>\n\n<p>{{.tracker}}</p>\n</body>\n</html>\n',3,'email','2019-11-19 10:42:30','2019-11-19 10:51:07',NULL,NULL),(9,1,'TDS','TDS Payment has been deducted from your Account | Income Tax Department - GOI','<html>\n<head>\n	<title></title>\n</head>\n<body>\n<p>Dear {{.fname}} {{.lname}},</p>\n\n<p>Your recent TDS payment for Amount of Rs. 3445&nbsp;is successful. The tax amount has been deducted from your netbanking access.</p>\n\n<p>Kindly download and view your receipt to click on the given link below.</p>\n\n<p><a href=\"{{.URL}}\">Click Here</a> to download receipt</p>\n\n<p>&nbsp;</p>\n\n<p>Sincerely,</p>\n\n<p>Income Tax Department</p>\n\n<p>Government of India</p>\n\n<p>{{.tracker}}</p>\n</body>\n</html>\n',3,'email','2019-11-20 09:02:20','2019-11-20 09:02:20',NULL,NULL);

--
-- Table structure for table `threatcop_accesses`
--

CREATE TABLE `threatcop_accesses` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `campaignId` int(11) DEFAULT NULL,
  `targetId` int(11) DEFAULT NULL,
  `accessToken` varchar(255) DEFAULT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  `deletedAt` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `campaignId` (`campaignId`),
  KEY `targetId` (`targetId`),
  CONSTRAINT `threatcop_accesses_ibfk_1` FOREIGN KEY (`campaignId`) REFERENCES `campaigns` (`id`),
  CONSTRAINT `threatcop_accesses_ibfk_2` FOREIGN KEY (`targetId`) REFERENCES `targets` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `threatcop_accesses`
--

INSERT INTO `threatcop_accesses` VALUES (1,43,1,'zDcxwPBEc9gdLpRUUeH2PCZtsJGSKFRNKGE5hfCX','2019-10-17 09:03:20','2019-10-17 09:03:20',NULL),(2,43,6481,'LAG8nkwjRZ3FxMqFRxtr6Su5ahZBknnkdEmfcJQz','2019-10-17 09:03:20','2019-10-17 09:03:20',NULL),(3,44,1,'rZgtOFRrzUnQ0t3ypszglYdmTed761j16Wh7Jfsu','2019-10-17 09:36:12','2019-10-17 09:36:12',NULL),(4,44,6481,'LmBGU8JYbYXbFvg8UmRqda5YNTjFe82CLkxdDmcl','2019-10-17 09:36:12','2019-10-17 09:36:12',NULL),(5,45,1,'R8EcqfFt4gB7PbCoyj2ecHPA3RUCFJsASD99Q2KO','2019-10-17 10:16:21','2019-10-17 10:16:21',NULL),(6,45,6481,'a0zWzob5cVXTFH3xMZkEdh2xB0vOO1CxfbuUPEPW','2019-10-17 10:16:21','2019-10-17 10:16:21',NULL),(7,46,1,'n47sjMgUnK6H1k4Ylmz52M2EVYTNo9SiszmsuyZC','2019-10-17 10:23:11','2019-10-17 10:23:11',NULL),(8,46,6481,'Xov0X49ypjtMGCCTan8gYRo7FpFyEgOcpmVbjhrC','2019-10-17 10:23:11','2019-10-17 10:23:11',NULL),(9,48,1,'YABKhdDpGeQLXV8Sv6lsiEC0oxr9h8CwVgwwM0Ua','2019-10-22 07:58:20','2019-10-22 07:58:20',NULL),(10,48,6481,'vVcGy4re04nivDX69PuMbPzJ38qMzYD9QMuX3Q7R','2019-10-22 07:58:20','2019-10-22 07:58:20',NULL),(11,49,1,'786MYPJiNF7milqdiwETcJCtq57Syam31GcSsVne','2019-10-22 09:38:02','2019-10-22 09:38:02',NULL),(12,49,6481,'XDzVJDswP2Wv62fLFOAavqLcgDZN53rkPfZ5H8G8','2019-10-22 09:38:02','2019-10-22 09:38:02',NULL),(13,50,1,'YnZM68tTkTeePki1wsnPdBtQC4iBbu8bmp9FUq4e','2019-10-22 10:44:02','2019-10-22 10:44:02',NULL),(14,50,6481,'d99IHACbcVcOj6mHEWG2TvZy8ljvRbpXqfw3icKB','2019-10-22 10:44:02','2019-10-22 10:44:02',NULL),(15,58,1,'s85B5k3oRXbAxdhSxPciZRlxAwdUlnEQqZwz6PJI','2019-11-22 05:55:27','2019-11-22 05:55:27',NULL),(16,58,6481,'ala8WOcreimYXcLcu3C3zSQ8ECWJbIFk9xQQdt4a','2019-11-22 05:55:27','2019-11-22 05:55:27',NULL);

--
-- Table structure for table `userPolicies`
--

CREATE TABLE `userPolicies` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `policyId` int(11) DEFAULT NULL,
  `userId` int(11) DEFAULT NULL,
  `companyId` int(11) DEFAULT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  `deletedAt` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `userPolicies`
--


--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `firstname` varchar(255) DEFAULT NULL,
  `lastname` varchar(255) DEFAULT NULL,
  `username` text,
  `email` varchar(255) DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `status` enum('active','inactive') DEFAULT 'active',
  `valid` int(11) DEFAULT '0',
  `verf_key` varchar(255) DEFAULT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  `deletedAt` datetime DEFAULT NULL,
  `attempt` int(11) DEFAULT NULL,
  `loggedOutAt` datetime DEFAULT NULL,
  `companyId` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `users_companyId_foreign_idx` (`companyId`),
  CONSTRAINT `users_companyId_foreign_idx` FOREIGN KEY (`companyId`) REFERENCES `companies` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES (1,'Sandeep','Jain','sandeep.jain','sandeep.jain@rblbank.com','$2a$10$4.fHP9l.MWGDzNyJf9aCs.m43MfHKCgOBCeSWyGB6/LxYWqym4dzy','active',1,NULL,'2019-08-09 08:05:50','2019-11-22 04:53:46',NULL,0,'2019-08-14 06:37:26',1);

--
-- Table structure for table `voice_gateways`
--

CREATE TABLE `voice_gateways` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `callBackUrl` varchar(255) DEFAULT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  `deletedAt` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `voice_gateways`
--

INSERT INTO `voice_gateways` VALUES (1,'Exotel','https://{{.apiKey}}:{{.apiToken}}@api.in.exotel.com/v1/Accounts/{{.sId}}/Calls/connect','/api/voice/calldetails','2020-01-18 08:10:40','2020-01-18 08:10:40',NULL);


