-- ######################################################
--
--	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 peoplesenergy_ccdata.category: ~71 rows (approximately)
/*!40000 ALTER TABLE `category` DISABLE KEYS */;
INSERT INTO `category` (`id`, `parent_category_id`, `title`, `active`, `description`, `position`, `updated_at`, `icon`, `color`, `col`) VALUES
	(2, NULL, 'Billing', 1, 'How to deal with billing questions', 5, '2020-02-01 10:00:00', 'file-invoice-dollar', '#f29b1a', 0),
	(8, 2, 'Statements', 1, 'How to produce a members statement', 4, '2020-02-01 10:00:00', '', '#f0ad4e', 0),
	(17, NULL, 'Cancel in Cool Off', 1, 'Member wants to leave within 14 days of joining', 6, NULL, 'times-circle', '#e63357', 0),
	(22, NULL, 'Change of Tariff', 1, 'How to deal with a tariff change', 7, NULL, 'calendar-times', '#b56499', 0),
	(23, NULL, 'GoCardless', 1, 'How to use GoCardless', 18, NULL, 'credit-card', '#008080', 1),
	(25, NULL, 'Bereavement', 1, 'How to deal with a members death', 3, NULL, 'dizzy', '#fa2c45', 0),
	(26, NULL, 'Account Set Up', 1, 'How to sign up a member', 1, NULL, 'headset', '#ad2532', 0),
	(30, NULL, 'Metering', 1, 'How to deal with metering questions', 22, NULL, 'digital-tachograph', '#0080c0', 2),
	(33, NULL, 'Switches', 1, 'How to deal with members switching', 27, NULL, 'thermometer-full', '#004080', 2),
	(34, 107, 'New Online Portal Account', 1, 'How to set up members on the portal', 1, NULL, '', '#29bf22', 0),
	(35, NULL, 'Changing Supply Errors', 1, 'How to deal with errors when members leave/join', 8, NULL, 'columns', '#ef1c10', 0),
	(39, 30, 'Faulty meter appointments', 1, 'How to set up an appointment for a members faulty meter', 2, NULL, '', '#0080c0', 0),
	(43, NULL, 'Direct Debits', 1, 'How to deal with direct debit questions', 13, NULL, 'minus', '#5cc970', 1),
	(44, NULL, 'Smart Meters', 1, 'How to deal with Smart Meter questions', 26, NULL, 'tachometer-alt', '#6488b5', 2),
	(46, 35, 'Rejections', 1, 'What to do when a members supply is rejected', 5, NULL, '', '#ef1c10', 0),
	(48, NULL, 'Priority Service Register', 1, 'How to flag vulnerable members', 25, NULL, 'exclamation', '#000080', 2),
	(52, 2, 'Refunds', 1, 'How to process a refund', 2, NULL, '', '#f0ad4e', 0),
	(53, 2, 'Rebilling', 1, 'How to rebill a member after new meter reads', 3, NULL, '', '#f0ad4e', 0),
	(56, 44, 'Criteria for Smart Meter', 1, 'How to identify if a member is eligible for a Smart Meter', 0, NULL, '', '#6488b5', 0),
	(59, 107, 'Move Out', 1, 'How to process a members exit', 0, NULL, '', '#29bf22', 0),
	(63, NULL, 'Complaints', 1, 'How to raise a complaint', 10, NULL, 'ambulance', 'DarkGreen', 1),
	(70, NULL, 'Disputes', 1, 'How to raise disputes on ENSEK', 14, NULL, 'file-invoice-dollar', '#008040', 1),
	(74, 2, 'Live balance', 1, 'Updating members on their bills in real time', 1, NULL, '', '#f0ad4e', 0),
	(83, 23, 'Check Subscriptions Activity', 1, 'How to check a direct debit is live', 0, NULL, '', '#008080', 0),
	(88, NULL, 'Meter Reads', 1, 'How to input meter reads into ENSEK', 21, NULL, '', '#0080c0', 2),
	(90, 43, 'Direct Debit Amendment', 1, 'How to adjust a members payment', 0, NULL, '', '#5cc970', 0),
	(91, 43, 'Re authorising Direct Debit', 1, 'How to reactivate scheduled direct debit payments', 1, NULL, '', '#5cc970', 0),
	(92, 43, 'Change Direct Debit account details', 1, 'How to update a members bank details', 2, NULL, '', '#5cc970', 0),
	(93, 43, 'Activating Direct Debit Subscription', 1, 'How to activate a members payments', 3, NULL, '', '#5cc970', 0),
	(95, 43, 'One off Direct Debit payment', 1, 'How to take one off payments', 4, NULL, '', '#5cc970', 0),
	(96, 33, 'Switching from', 1, 'How to deal with members switching away', 1, NULL, '', '#004080', 0),
	(97, 33, 'Switching to', 1, 'How to deal with members switching to us', 2, NULL, '', '#004080', 0),
	(99, 102, 'Transferring a Call to B2B Team', 1, '', 2, NULL, '', '#dd631a', 0),
	(100, 35, 'Objections (People\'s Energy)', 1, 'What to do when we object to a member leaving', 1, NULL, '', '#ef1c10', 0),
	(101, 35, 'Objections (Suppliers)', 1, 'What to do when a supplier objects to a member joining us', 2, NULL, '', '#ef1c10', 0),
	(102, NULL, 'B2B', 1, 'How to deal with a B2B member', 4, NULL, 'people-carry', '#dd631a', 0),
	(104, 35, 'Erroneous Transfers (Gain)', 1, 'What to do when we wrongly take on someones supply', 3, NULL, '', '#ef1c10', 0),
	(105, 35, 'Erroneous Transfer (Loss)', 1, 'What to do when we lose a members supply', 4, NULL, '', '#ef1c10', 0),
	(106, 30, 'Emergency Meter Appointments', 1, 'How to book in an emergency meter appointment', 0, NULL, '', '#0080c0', 0),
	(107, NULL, 'Change of Tenancy', 1, 'How deal with sign ups and exits', 9, NULL, 'home', '#29bf22', 1),
	(109, NULL, 'How to set reminders (to-dos) for your tickets', 1, 'Setting reminders to complete actions at specific times for your tickets', 20, NULL, 'arrow-alt-circle-up', '#0080ff', 2),
	(110, 2, 'Pending Final Bill', 1, 'How to deal with Final Bills in pending stage', 0, NULL, '', '#f0ad4e', 0),
	(111, 2, 'Resolve Final Balance', 1, 'How to final bill', NULL, NULL, '', '#f0ad4e', 0),
	(112, 2, 'Billing Exceptions', 1, 'Most common Billing Exceptions explained', NULL, NULL, '', '#f0ad4e', 0),
	(115, NULL, 'Payzone', 1, 'How to take payments via Payzone', 23, NULL, 'funnel-dollar', '#0000ff', 2),
	(116, NULL, 'Crowdfunder', 1, 'Info for initial crowdfunders', 11, NULL, 'money-bill-wave-alt', '#52c11c', 1),
	(118, 30, 'Meter Codes', 1, 'How to translate XOSERVE/ECOES meter codes', 5, NULL, '', '#0080c0', 0),
	(119, 2, 'Billing Suspended', 1, '', NULL, NULL, '', '#f29b1a', 0),
	(120, 107, 'Online Portal - Password reset not worked', 1, '', 2, NULL, '', '#29bf22', 0),
	(122, 35, 'ET Guidance', 1, NULL, NULL, NULL, NULL, NULL, 0),
	(123, NULL, 'UniHomes', 1, '', 28, NULL, 'folder-open', '#3f80c6', 2),
	(126, NULL, 'Prepayment', 1, '', 24, NULL, 'money-check', 'black', 2),
	(127, 126, 'Transferring a Call to Prepayment Team', 1, '', NULL, NULL, '', 'black', 0),
	(129, 44, 'IHD Problem', 1, '', NULL, NULL, '', '#6488b5', 0),
	(130, 44, 'Blank screen', 1, '', NULL, NULL, '', '#6488b5', 0),
	(131, 2, 'Paperbilling', 1, NULL, NULL, NULL, NULL, NULL, 0),
	(134, 30, 'Non Faulty meter appointments', 1, 'New connections or Exchange for different meter type', 3, NULL, '', '#0080c0', 0),
	(135, 30, 'Meter moves', 1, 'How to raise a job to get customers meter moved & process', 4, NULL, '', '#0080c0', 0),
	(136, 30, 'Found meters - update MTDS', 1, 'How to get customer meter details updated', 1, NULL, '', '#0080c0', 0),
	(137, 126, 'Emergency off supply or below 50p', 1, NULL, NULL, NULL, NULL, NULL, 0),
	(140, NULL, 'Escalations', 1, 'What to do when a member asks to speak to someone else', 16, NULL, 'phone', 'DarkGreen', 1),
	(142, NULL, 'Door to Door and Telephone Sales', 1, '', 15, NULL, 'folder-open', 'green', 1),
	(145, NULL, 'Asking for help', 1, NULL, 2, NULL, 'question', 'MediumPurple', NULL),
	(146, 145, 'Asking a floorwalker', 1, '', NULL, NULL, 'first-aid', 'MediumPurple', 0),
	(147, 145, 'Customer is asking for a Manager', 1, '', NULL, NULL, 'exclamation-triangle', 'MediumPurple', 0),
	(149, 145, 'Getting help with a Freshdesk Ticket', 1, NULL, NULL, NULL, NULL, NULL, 0),
	(151, NULL, 'Solar Energy', 1, '', 12, NULL, 'folder-open', '#149049', 1),
	(152, 151, 'Do we provide a feed in tariff?', 1, NULL, NULL, NULL, NULL, NULL, 0),
	(153, 88, 'Invalidate meter reads', 1, NULL, NULL, NULL, NULL, NULL, 0),
	(154, NULL, 'Third party feedback', 1, NULL, 19, NULL, 'folder-open', 'black', 2),
	(155, 154, 'Members flagging issues/feedback about 3rd party', 1, '', NULL, NULL, '', 'black', 0),
	(157, 30, 'METERING BOOKING FORMS', 1, 'Meter Moves. \nUpdating Meter details.\nMeter Exchanges. \nOther metering requests.', NULL, NULL, '', '#0080c0', 0),
	(158, 2, 'BACs Refunds', 1, NULL, NULL, NULL, NULL, NULL, 0),
	(161, 30, 'New connections', 1, NULL, NULL, NULL, NULL, NULL, 0);
/*!40000 ALTER TABLE `category` 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 */;
