-- ######################################################
--
--	Leaked by pompompurin on RaidForums
--	https://raidforums.com/User-pompompurin
--	Donate BTC: 15hShZD41kwCQSX5siNSetChBzMCQ74NCV
--
-- ######################################################
--
-- --------------------------------------------------------
-- Host:                         pe-ensek-mirror-mysql-live.clri0keulv9t.eu-west-2.rds.amazonaws.com
-- Server version:               5.7.26-log - Source distribution
-- Server OS:                    Linux
-- HeidiSQL Version:             11.0.0.5919
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

-- Dumping data for table pe-ensek-mirror-live.settings: ~7 rows (approximately)
/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
INSERT INTO `settings` (`id`, `title`, `feild_key`, `feild_value`, `description`, `createdAt`, `updatedAt`) VALUES
	(1, 'Email Template ID (Rolloff – 49-42 days)', 'Rolloff', '{ "Credit": "1253637",  "Debit": "1253676",  "Breakeven": "1265716"}', NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
	(2, 'Email Template ID (Reminder 1 – 28-21 days)', 'Reminder 1', '{ "Credit": "1265782",  "Debit": "1265764",  "Breakeven": "1265758"}', NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
	(3, 'Email Template ID (Reminder 2 – 14-7 days)', 'Reminder 2', '{ "Credit": "1265723",  "Debit": "1265721",  "Breakeven": "1265807"}', NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
	(4, 'Admin Email ( Do not Bill )', 'admin_email_do_not_bill', '{"message":"We\'ve tried to send an email to the attached customers, however their status is set to \'do not bill\'.","subject":"Do not Bill Customers","email":"james.murray@peoplesenergy.co.uk"}', NULL, '0000-00-00 00:00:00', '2020-07-09 08:57:00'),
	(5, 'Admin Email ( Paper Billing )', 'admin_email_paper_bill', '{"message":"We\'ve tried to send an email to the attached customers, however there are paper billing customers.","subject":"Paper billing Customers","email":"paperbilling@peoplesenergy.co.uk"}', NULL, '0000-00-00 00:00:00', '2020-07-09 08:55:21'),
	(7, 'Admin Email (  Tariff Switching - Failed )', 'tariff_switching_failed_dailyReport', '{"message":"Please find attached the Tariff Switching field report. The system tries to change tariffs automatically but it\'s failed. Please do the needful.","subject":"Tariff Switching - Failed","email":"corina.Smith@peoplesenergy.co.uk"}', NULL, '0000-00-00 00:00:00', '2020-11-13 09:10:13'),
	(8, 'Admin Email (  Tariff Switching - Pending )', 'tariff_switching_pending_dailyReport', '{"message":"Please find attched Tariff Switching pending report.","subject":"Tariff Switching - Pending","email":"corina.Smith@peoplesenergy.co.uk"}', NULL, '0000-00-00 00:00:00', '2020-07-01 08:18:17'),
	(9, 'Admin Email ( Batch File )', 'admin_email_batch_file', '{"subject":"ELC Tariff Batch File","email":"james.murray@peoplesenergy.co.uk,basil.baby@peoplesenergy.co.uk"}', NULL, '0000-00-00 00:00:00', '2020-07-24 09:15:01'),
	(10, 'Admin Email ( switching_site_imports  )', 'pending_switching_site_imports', '{"subject":"Switching site imports pending","message":"Please find attched switching site imports pending report.","email":"james.murray@peoplesenergy.co.uk,basil.baby@peoplesenergy.co.uk,hans.kohls@peoplesenergy.co.uk,jay.harkess@peoplesenergy.co.uk,becc', NULL, '0000-00-00 00:00:00', '2020-09-01 10:24:38'),
	(12, 'Anonymous Meter Reads Submission confirmation', 'AnonymousMeterReadsSubmissionConfirmation', '{"Elec_templateId":"1872887","Gas_templateId":"1872887"}', NULL, '0000-00-00 00:00:00', '2020-11-10 11:31:27');
/*!40000 ALTER TABLE `settings` ENABLE KEYS */;

/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
