Jul 29, 2025, 09:14 AM
-- --------------------------------------------------------
--
-- Table structure for table `alert_log`
--
CREATE TABLE `alert_log` (
`alert_log_id` bigint(20) NOT NULL,
`client_id` bigint(20) NOT NULL,
`log_module_id` bigint(20) NOT NULL,
`notification_type` enum('mail','sms','notification') NOT NULL,
`message_to` varchar(255) NOT NULL,
`message_from` varchar(255) NOT NULL,
`subject` varchar(255) NOT NULL,
`message` text NOT NULL,
`alert_message_date` datetime NOT NULL,
`ip_address` varchar(255) NOT NULL,
`log_by` varchar(255) NOT NULL,
`createddate` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `alert_log`
--
INSERT INTO `alert_log` (`alert_log_id`, `client_id`, `log_module_id`, `notification_type`, `message_to`, `message_from`, `subject`, `message`, `alert_message_date`, `ip_address`, `log_by`, `createddate`) VALUES
(1, 366449, 9, 'mail', '[email protected]', '[email protected]', 'INTERESTED IN BUSINESS CREDIT', '<p>Hello Nimesh Patel,</p>\n\n<p>Have no time to repair your credit on your own? Personalized Credit Repair Service.</p>\n\n<p>Call Credit Freedom and Restoration. Your start to finanicial freedom!</p>\n\n<p> </p>\n\n<p>"Teamwork makes the dreamwork" <br />\nCall 1.866.391.6303 Ext 1 to start your credit repair today with no money down.</p>\n\n<p> </p>\n', '2022-03-24 10:24:52', '', '', '2022-03-24 10:24:52'),
(9, 366449, 9, 'mail', '[email protected]', '[email protected]', 'INTERESTED IN BUSINESS CREDIT', '<p>Hello Nimesh Patel,</p>\n\n<p>Have no time to repair your credit on your own? Personalized Credit Repair Service.</p>\n\n<p>Call Credit Freedom and Restoration. Your start to finanicial freedom!</p>\n\n<p> </p>\n\n<p>"Teamwork makes the dreamwork" <br />\nCall 1.866.391.6303 Ext 1 to start your credit repair today with no money down.</p>\n\n<p> </p>\n', '2022-03-25 12:01:01', '', '', '2022-03-25 12:01:01'),
(10, 366449, 9, 'mail', '[email protected]', '[email protected]', 'INTERESTED IN BUSINESS CREDIT', '<p>Hello Nimesh Patel,</p>\n\n<p>Have no time to repair your credit on your own? Personalized Credit Repair Service.</p>\n\n<p>Call Credit Freedom and Restoration. Your start to finanicial freedom!</p>\n\n<p> </p>\n\n<p>"Teamwork makes the dreamwork" <br />\nCall 1.866.391.6303 Ext 1 to start your credit repair today with no money down.</p>\n\n<p> </p>\n', '2022-03-26 12:01:01', '', '', '2022-03-26 12:01:01'),
(11, 366449, 9, 'mail', '[email protected]', '[email protected]', 'INTERESTED IN BUSINESS CREDIT', '<p>Hello Nimesh Patel,</p>\n\n<p>Have no time to repair your credit on your own? Personalized Credit Repair Service.</p>\n\n<p>Call Credit Freedom and Restoration. Your start to finanicial freedom!</p>\n\n<p> </p>\n\n<p>"Teamwork makes the dreamwork" <br />\nCall 1.866.391.6303 Ext 1 to start your credit repair today with no money down.</p>\n\n<p> </p>\n', '2022-03-27 12:01:01', '', '', '2022-03-27 12:01:01'),
(12, 366449, 9, 'mail', '[email protected]', '[email protected]', 'INTERESTED IN BUSINESS CREDIT', '<p>Hello Nimesh Patel,</p>\n\n<p>Have no time to repair your credit on your own? Personalized Credit Repair Service.</p>\n\n<p>Call Credit Freedom and Restoration. Your start to finanicial freedom!</p>\n\n<p> </p>\n\n<p>"Teamwork makes the dreamwork" <br />\nCall 1.866.391.6303 Ext 1 to start your credit repair today with no money down.</p>\n\n<p> </p>\n', '2022-03-28 12:01:01', '', '', '2022-03-28 12:01:01'),
(13, 25267, 12, 'sms', '3026601932', '+19032895145', 'Credit Card Usage', 'Hello Bernard Manuel,\n\n\nHey, your Credit Card usage is 73%\n\nJust wanted to make you aware your credit score will increase by bringing your usage back down to 30%.\n\nCredit Freedom with Melissa\n\n866-391-6303\n', '2022-03-30 03:32:11', '18.224.36.50', 'Automation', '2022-03-30 03:32:11'),
(14, 25267, 12, 'mail', '[email protected]', '[email protected]', 'Credit Card Usage', 'Hello Bernard Manuel,\n\n\nHey, your Credit Card usage is 73%\n\nJust wanted to make you aware your credit score will increase by bringing your usage back down to 30%.\n\nCredit Freedom with Melissa\n\n866-391-6303\n', '2022-03-30 03:32:12', '18.224.36.50', 'Automation', '2022-03-30 03:32:12'),
(15, 25267, 12, 'sms', '3026601932', '+19032895145', 'Credit Card Usage', 'Hello Bernard Manuel,\n\n\nHey, your Credit Card usage is 73%\n\nJust wanted to make you aware your credit score will increase by bringing your usage back down to 30%.\n\nCredit Freedom with Melissa\n\n866-391-6303\n', '2022-03-30 03:34:37', '18.224.36.50', 'Automation', '2022-03-30 03:34:37'),
(16, 25267, 12, 'mail', '[email protected]', '[email protected]', 'Credit Card Usage', 'Hello Bernard Manuel,\n\n\nHey, your Credit Card usage is 73%\n\nJust wanted to make you aware your credit score will increase by bringing your usage back down to 30%.\n\nCredit Freedom with Melissa\n\n866-391-6303\n', '2022-03-30 03:34:38', '18.224.36.50', 'Automation', '2022-03-30 03:34:38'),
(17, 801880, 12, 'sms', '5166437754', '+19032895145', 'Credit Card Usage', 'Hello Shackera Lemard,\n\n\nHey, your Credit Card usage is 115%\n\nJust wanted to make you aware your credit score will increase by bringing your usage back down to 30%.\n\nCredit Freedom with Melissa\n\n866-391-6303\n', '2022-03-30 04:08:27', '18.224.36.50', 'Automation', '2022-03-30 04:08:27'),
(18, 801880, 12, 'mail', '[email protected]', '[email protected]', 'Credit Card Usage', 'Hello Shackera Lemard,\n\n\nHey, your Credit Card usage is 115%\n\nJust wanted to make you aware your credit score will increase by bringing your usage back down to 30%.\n\nCredit Freedom with Melissa\n\n866-391-6303\n', '2022-03-30 04:08:27', '18.224.36.50', 'Automation', '2022-03-30 04:08:27'),
(19, 704356, 12, 'sms', '9085026350', '+19032895145', 'Credit Card Usage', 'Hello Angel Hunter,\n\n\nHey, your Credit Card usage is 126%\n\nJust wanted to make you aware your credit score will increase by bringing your usage back down to 30%.\n\nCredit Freedom with Melissa\n\n866-391-6303\n', '2022-03-30 04:23:13', '18.224.36.50', 'Automation', '2022-03-30 04:23:13'),
(20, 704356, 12, 'mail', '[email protected]', '[email protected]', 'Credit Card Usage', 'Hello Angel Hunter,\n\n\nHey, your Credit Card usage is 126%\n\nJust wanted to make you aware your credit score will increase by bringing your usage back down to 30%.\n\nCredit Freedom with Melissa\n\n866-391-6303\n', '2022-03-30 04:23:13', '18.224.36.50', 'Automation', '2022-03-30 04:23:13'),
(21, 274008, 12, 'sms', '2166889821', '+19032895145', 'Credit Card Usage', 'Hello Comfort Kai,\n\n\nHey, your Credit Card usage is 105%\n\nJust wanted to make you aware your credit score will increase by bringing your usage back down to 30%.\n\nCredit Freedom with Melissa\n\n866-391-6303\n', '2022-03-30 04:25:47', '18.224.36.50', 'Automation', '2022-03-30 04:25:47'),
(22, 274008, 12, 'mail', '[email protected]', '[email protected]', 'Credit Card Usage', 'Hello Comfort Kai,\n\n\nHey, your Credit Card usage is 105%\n\nJust wanted to make you aware your credit score will increase by bringing your usage back down to 30%.\n\nCredit Freedom with Melissa\n\n866-391-6303\n', '2022-03-30 04:25:47', '18.224.36.50', 'Automation', '2022-03-30 04:25:47'),