-- phpMyAdmin SQL Dump
-- version 5.0.4
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Jul 11, 2021 at 09:14 PM
-- Server version: 5.7.18
-- PHP Version: 7.4.11

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `installer`
--

-- --------------------------------------------------------

--
-- Table structure for table `hd_account_details`
--

CREATE TABLE `hd_account_details` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL,
  `fullname` varchar(160) COLLATE utf8_unicode_ci DEFAULT NULL,
  `company` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `city` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `country` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `locale` varchar(100) COLLATE utf8_unicode_ci DEFAULT 'en_US',
  `address` varchar(64) COLLATE utf8_unicode_ci DEFAULT '-',
  `phone` varchar(32) COLLATE utf8_unicode_ci DEFAULT '-',
  `mobile` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `skype` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `language` varchar(40) COLLATE utf8_unicode_ci DEFAULT 'english',
  `department` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `avatar` mediumtext COLLATE utf8_unicode_ci,
  `use_gravatar` enum('Y','N') COLLATE utf8_unicode_ci DEFAULT 'Y',
  `as_company` enum('false','true') COLLATE utf8_unicode_ci DEFAULT 'false',
  `allowed_modules` text COLLATE utf8_unicode_ci,
  `hourly_rate` decimal(10,2) DEFAULT '0.00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `hd_activities`
--

CREATE TABLE `hd_activities` (
  `activity_id` int(11) NOT NULL,
  `user` int(11) NOT NULL,
  `module` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `module_field_id` int(11) DEFAULT NULL,
  `activity` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `activity_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `icon` varchar(32) COLLATE utf8_unicode_ci DEFAULT 'fa-coffee',
  `value1` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `value2` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `deleted` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `hd_additional_fields`
--

CREATE TABLE `hd_additional_fields` (
  `id` int(11) NOT NULL,
  `domain` int(100) NOT NULL,
  `field_name` text NOT NULL,
  `field_value` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `hd_blocks`
--

CREATE TABLE `hd_blocks` (
  `block_id` int(11) NOT NULL,
  `type` varchar(100) NOT NULL,
  `name` varchar(100) NOT NULL,
  `id` varchar(100) NOT NULL,
  `module` varchar(100) NOT NULL,
  `theme` varchar(100) NOT NULL,
  `section` varchar(100) NOT NULL,
  `weight` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `hd_blocks`
--

INSERT INTO `hd_blocks` (`block_id`, `type`, `name`, `id`, `module`, `theme`, `section`, `weight`) VALUES
(10, 'Module', '', 'domain_availability_checker', 'Domains', 'original', 'full_width_top', 1),
(21, 'Module', '', 'domain_pricing_table', 'Domains', 'original', 'content_top', 0),
(34, 'Module', 'Home Slider', 'sliders_7', 'Sliders', 'original', 'full_width_top', 0),
(35, 'Module', 'Main Menu', 'menus_1', 'Menus', 'original', 'main_menu', 0),
(43, 'Module', 'Website Packages', 'items_13', 'Items', 'original', 'content_top', 0),
(44, 'Custom', 'Sidebar Right', '18', 'Block', 'original', 'sidebar_right', 0),
(45, 'Custom', 'Left Sidebar', '19', 'Block', 'original', 'sidebar_left', 0),
(47, 'Custom', 'Google Map', '17', 'Block', 'original', 'full_width_top', 0),
(48, 'Custom', 'Contact Page Image', '16', 'Block', 'original', 'sidebar_right', 0),
(51, 'Custom', 'Top icons', '24', 'Block', 'original', 'header_top_right', 1),
(54, 'Module', 'cPanel Hosting', 'items_12', 'Items', 'original', 'footer_top', 1),
(62, 'Custom', 'Domains Image', '28', 'Block', 'original', 'sidebar_right', 0),
(69, 'Custom', 'Demo Login', '32', 'Block', 'original', 'header_top_left', 0),
(70, 'Custom', 'Our Service Guarantee', '33', 'Block', 'original', 'page_bottom', 1),
(72, 'Module', 'Installation FAQ', 'faq_34', 'FAQ', 'original', 'footer_top', 0),
(73, 'Module', 'Installation', 'faq_30', 'FAQ', 'original', 'footer_top', 0),
(74, 'Custom', 'Contact Details Top', '12', 'Block', 'original', 'header_top_left', 0),
(75, 'Module', '', 'cart_icon_block', 'Cart', 'original', 'floating_icon', 0),
(77, 'Custom', 'Home', '34', 'Block', 'original', 'content_top', 0),
(78, 'Module', 'Plesk Hosting', 'items_19', 'Items', 'original', 'content_top', 1),
(82, 'Module', 'DirectAdmin Hosting', 'items_20', 'Items', 'original', 'content_bottom', 0);

-- --------------------------------------------------------

--
-- Table structure for table `hd_blocks_custom`
--

CREATE TABLE `hd_blocks_custom` (
  `id` int(11) NOT NULL,
  `name` varchar(100) CHARACTER SET utf8 NOT NULL,
  `code` longtext CHARACTER SET utf8 NOT NULL,
  `format` varchar(20) NOT NULL,
  `type` varchar(6) NOT NULL DEFAULT 'Custom',
  `module` varchar(5) NOT NULL DEFAULT 'Block'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `hd_blocks_custom`
--

INSERT INTO `hd_blocks_custom` (`id`, `name`, `code`, `format`, `type`, `module`) VALUES
(5, 'Block with PHP', '$address = config_item(\'company_address\');\r\n$phone = config_item(\'company_phone\');\r\n$email = config_item(\'company_email\');\r\n$phone = config_item(\'company_phone\');\r\necho \'<h3 class=\"section-header section-title\">Our Address</h3>\r\n       <ul class=\"contact-info\">\r\n        <li><span><i class=\"fa fa-home\"></i>\' .  $address  . \'</span></li>\r\n        <li><span><i class=\"fa fa-phone\"></i>\' .  $phone . \'</span></li>\r\n        <li><i class=\"fa fa-envelope-o\" aria-hidden=\"true\"></i><a href=\"#\">\' .  $email . \'</a></li>\r\n        \r\n       </ul>\'; ', 'php', 'Custom', 'Block'),
(12, 'Contact Details Top', '<ul class=\"list-inline top-contact\">\r\n								<li>\r\n									<p>	<span><i class =\"fa fa-phone\"></i>+ 255 545 11222</span>\r\n									</p>\r\n								</li>\r\n								<li>\r\n									<p><span><i class =\"fa fa-envelope\"></i> info@hostingbilling.net</span>\r\n									</p>\r\n								</li>\r\n							</ul>', 'js', 'Custom', 'Block'),
(16, 'Contact Page Image', '<img src=\"resource/images/contact.png\">', 'rich_text', 'Custom', 'Block'),
(17, 'Google Map', '<div class=\"embed-responsive embed-responsive-100x400px\">\r\n<iframe src=\"https://www.google.com/maps/embed?pb=!1m14!1m8!1m3!1d35818.719732048536!2d-4.25169!3d55.868392!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x488815562056ceeb%3A0x71e683b805ef511e!2sGlasgow%2C+Glasgow+City%2C+UK!5e0!3m2!1sen!2sus!4v1448625188752\" width=\"600\" height=\"450\" frameborder=\"0\" style=\"border:0\" allowfullscreen></iframe>\r\n  </div>', 'js', 'Custom', 'Block'),
(18, 'Sidebar Right', '<h1 style=\"text-align: center; \"><h2>Right Sidebar</h2><br></h1><p style=\"text-align: center; \"><img src=\"data:image/jpeg;base64, \" data-filename=\"special.jpg\" style=\"width: 334px;\"><br></p>', 'rich_text', 'Custom', 'Block'),
(19, 'Left Sidebar', '<h2>Left sidebar</h2>\r\n<h4>Example with code</h4>\r\n\r\n<div id=\"MyClockDisplay\" class=\"clock\" onload=\"showTime()\"></div>\r\n<script>\r\n\r\nfunction showTime(){\r\n    var date = new Date();\r\n    var h = date.getHours(); // 0 - 23\r\n    var m = date.getMinutes(); // 0 - 59\r\n    var s = date.getSeconds(); // 0 - 59\r\n    var session = \"AM\";\r\n    \r\n    if(h == 0){\r\n        h = 12;\r\n    }\r\n    \r\n    if(h > 12){\r\n        h = h - 12;\r\n        session = \"PM\";\r\n    }\r\n    \r\n    h = (h < 10) ? \"0\" + h : h;\r\n    m = (m < 10) ? \"0\" + m : m;\r\n    s = (s < 10) ? \"0\" + s : s;\r\n    \r\n    var time = h + \":\" + m + \":\" + s + \" \" + session;\r\n    document.getElementById(\"MyClockDisplay\").innerText = time;\r\n    document.getElementById(\"MyClockDisplay\").textContent = time;\r\n    \r\n    setTimeout(showTime, 1000);\r\n    \r\n}\r\n\r\nshowTime();\r\n\r\n</script>', 'js', 'Custom', 'Block'),
(24, 'Top icons', 'echo \'<ul class=\"list-inline top-widget\">\n        <li class=\"top-social\">\n         <a href=\"#\"><i class=\"fa fa-facebook\"></i></a>\n         <a href=\"#\"><i class=\"fa fa-twitter\"></i></a>\n         <a href=\"#\"><i class=\"fa fa-google-plus\"></i></a>\n         <a href=\"#\"><i class=\"fa fa-linkedin\"></i></a>\n        </li>\n        <li>\n         <a class=\"button-quote\" href=\"\'.base_url().\'auth/login\" id=\"\">Sign in</a>\n        </li>\n       </ul>\';', 'php', 'Custom', 'Block');
INSERT INTO `hd_blocks_custom` (`id`, `name`, `code`, `format`, `type`, `module`) VALUES
(28, 'Domains Image', '<p><img style=\"width: 100%;\" src=\"data:image/jpeg;base64, \" data-filename=\"domains.jpg\"><br></p>', 'rich_text', 'Custom', 'Block');
INSERT INTO `hd_blocks_custom` (`id`, `name`, `code`, `format`, `type`, `module`) VALUES
(32, 'Demo Login', '<span></span>', 'js', 'Custom', 'Block'),
(33, 'Why Choose Us', '<div class=\"btgrid\">\n<div class=\"row row-1\">\n<div class=\"col-md-6\">\n<div class=\"content\">\n<h1>Why Choose Us?</h1>\n\n<ul>\n	<li><big>&nbsp;&nbsp;&nbsp; Easy to use Control Panel</big></li>\n	<li><big>&nbsp;&nbsp;&nbsp; 24/7 Support</big></li>\n	<li><big>&nbsp;&nbsp;&nbsp; DDOS Protection</big></li>\n	<li><big>&nbsp;&nbsp;&nbsp; Money Back Guarantee</big></li>\n	<li><big>&nbsp;&nbsp;&nbsp; Free Nightly Backups</big></li>\n	<li><big>&nbsp;&nbsp;&nbsp; Outstanding reliability</big></li>\n	<li><big>&nbsp;&nbsp;&nbsp; Powerful, Fast Servers</big></li>\n	<li><big>&nbsp;&nbsp;&nbsp; Superior technology</big></li>\n	<li><big>&nbsp;&nbsp;&nbsp; Secured Web site</big></li>\n	<li><big>&nbsp;&nbsp;&nbsp; WordPress hosting</big></li>\n	<li><big>&nbsp;&nbsp;&nbsp; No Overloaded Servers</big></li>\n</ul>\n</div>\n</div>\n\n<div class=\"col-md-6\">\n<div class=\"content\">\n<p><img alt=\"\" src=\"/resource/uploads/638478249.png\" style=\"height:410px; width:573px\" /></p>\n</div>\n</div>\n</div>\n</div>\n', 'rich_text', 'Custom', 'Block'),
(34, 'Home', '<div class=\"col-sm-4\">\r\n<p><img src=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADwAAAA8CAYAAAA6/NlyAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA2RpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuMC1jMDYwIDYxLjEzNDc3NywgMjAxMC8wMi8xMi0xNzozMjowMCAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOk9yaWdpbmFsRG9jdW1lbnRJRD0ieG1wLmRpZDo4MzRBMzc3MDIzRDhFMjExQjE5NUMzQzQxMDY2RTg5MSIgeG1wTU06RG9jdW1lbnRJRD0ieG1wLmRpZDpBQkMwOUY4RUQ5QjIxMUUyOUIzODgwQzExMTk5OUExNiIgeG1wTU06SW5zdGFuY2VJRD0ieG1wLmlpZDpBQkMwOUY4REQ5QjIxMUUyOUIzODgwQzExMTk5OUExNiIgeG1wOkNyZWF0b3JUb29sPSJBZG9iZSBQaG90b3Nob3AgQ1M1IFdpbmRvd3MiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDpDNjYzQTg4QkZGRDhFMjExOUIyOUQzNDA5ODRBNThGNCIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDo4MzRBMzc3MDIzRDhFMjExQjE5NUMzQzQxMDY2RTg5MSIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/Pni7Z4sAAAOwSURBVHja7JtNbtpAFMcHxAHcG5gT1NzAZB0pZpdd4ARJTkA4AfQEkF13IVLXjW8Q9wThBvENqF09S5Zr+/3ffGCX8qSRSMD2/Dzve+zB8XhUEvn+46fSFMmFBsqRDNV/JhfgC3C9eDT6IJ5r4PwCbzS8HsDm89iiB4yEHrq4QED/yj9Ps5F2CBuU5rOwtsI1sIo+Iyv9IIQJBLCFzJGVHhrActAhTeAzG2sh8Hs2Pug4H4CFoQdc4sHAliUh9Y6ysayZqInE2VjRNZC57JrUuxVYAFtI6tiRHQQ3shZ6aBFWKfdeW6I1terdZsNS2D7KvOo/2oC/nUFilZvYMwR8e321Q+Jaz2Gn5OiwsOQYOqaRnAoWisMWofd0njHVu1MaE/p7TN/HrmChOFzy2lAm0xAeVhRSJN54S8mLNVhRakkrLVG/A63eQghbHJtPfCbM09k5SnLpUBCmEoJNLJjBVHDD5lwuICkPlwJYmxWU5HweV6hANpytrk/JPKrGLsrFgIoKxI6/mK7wPfi7hcPaOCHnh6xyZAocgfaGhBSf1O6l1K1gbY/kCbTnG1NgJGlHUtF1qc6NKOwU4e6DPnOyMlmgPzac2ejRgrpNmN9sQaDHbGwYlf3UnaitNu0r0OKZg+daMwlHSubTKTBnu0vh+bjf/+oauM2RhBqNgRAwod4C6zYROLXuFLjLtk8nwJ6BfVtX21MAB8zEUw3Y1MDGnQNz9ibtj3HJxdeugW+Y7zcCFd0BcVZ7hdFqCcnExoy39ijbipgb8wjUvFznpbFiQncPD0A+vVTtva+UOhj56txVzpeQ2iOFAZLENDpKFDgGUsM5TToBzqXruR/AQubV1IZRp7N1GHd9cHVbc20I+Pb6KgGdTqDkW6NonH8Bb+a+LaRJvDS6yohTkcJK9rlWVsIStWljAfSbMt8jLvpYKOyGc3ySNm0gLARCmuyT5qqu6XhfeE3PRhxGn+VocyS5hjwzviCiJCYyuFZrWxd55MEUFo2TocXzN0Jzjzy4gD2V1EIPzxS2cHh/efc2p7X+h2HL0EsUeOaqCD+xWi8g4CzusnutPZdYZMMa0AmViCtlf3/pQCuFbtTttLx0yYFx6V3VIxYbWvfK7NGnPcXufY0z8lpgF0aJBwPN7d/6lGpKmvEzUsmU8cCeBFYE3AAt2ay2/ZJHFZqFFQNXoJWS7fS7eKulgN4r8EmjkYZdFY5MqW4eDK+a00QJHpoZaV6oa9CqB4fl8lbLBfjM5LcAAwAdEkOHmxZ29gAAAABJRU5ErkJggg==\" style=\"width:60px\" /></p>\r\n\r\n<p>Instant Setup<br />\r\n&nbsp;</p>\r\n\r\n<p>As soon as you make a successful payment your web hosting and domain names will be activated immediately. We do not charge extra fees for setting up your account.</p>\r\n</div>\r\n\r\n<div class=\"col-sm-4\">\r\n<p><img src=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADwAAAA8CAYAAAA6/NlyAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA2RpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuMC1jMDYwIDYxLjEzNDc3NywgMjAxMC8wMi8xMi0xNzozMjowMCAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOk9yaWdpbmFsRG9jdW1lbnRJRD0ieG1wLmRpZDo4MzRBMzc3MDIzRDhFMjExQjE5NUMzQzQxMDY2RTg5MSIgeG1wTU06RG9jdW1lbnRJRD0ieG1wLmRpZDpBQkMwOUY5MkQ5QjIxMUUyOUIzODgwQzExMTk5OUExNiIgeG1wTU06SW5zdGFuY2VJRD0ieG1wLmlpZDpBQkMwOUY5MUQ5QjIxMUUyOUIzODgwQzExMTk5OUExNiIgeG1wOkNyZWF0b3JUb29sPSJBZG9iZSBQaG90b3Nob3AgQ1M1IFdpbmRvd3MiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDpDNjYzQTg4QkZGRDhFMjExOUIyOUQzNDA5ODRBNThGNCIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDo4MzRBMzc3MDIzRDhFMjExQjE5NUMzQzQxMDY2RTg5MSIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/PqYr6pQAAATESURBVHja5FtZaBVXGJ574y4GrVmIKCKaoFUTXEoExSWoiMYsbWk1LYK4PQktPtQu9M0NQV/EBUHwQYm4xHtVRNGoUGxB65tWRK1ixVYjrcs1atLcfj/5Bw6nZ86Z5c7NvZMfPsKcbe435z//+c4/k1g6nba8WPPpViuAzQM2AlOAv4GjwCag3e0Ay2prgtzf6mNlz+YAp4FBfF0MfA+UA03Av9n4EfEskY0B3wlkRfuMH4YVJcIDgUpN/ZSoEY4Zlk/fqBEmS/usy1vCOWF9fLpnPTADGMBlBbxO7wG0b90CXgeYOXLxUmAm32eQvXVhW6Qx/wBasEXd9/zjvezDuBn9kIPAckX1LmAP8DvwDugS6gZzebHD0LQ3b1OseSI6F9gCTJD6PKNtGaRbw3TpVQqyL4FFwHqe2XaJrN/13gG8ABJANXBcakMPby8moTAUwhiY2q6UionYOuBcyEvvFbAC+EUqL2f1FsoMTwKqpLIz9Cyksk+5/FdgH1ABpAxjd/Df1cBF4BqwAxgptHkDbBDa2vZxWIQXA/0lt9sttfmB9TG1nQqsBS4BC4G3mrH7AVuB/QCJ5enA10x+tNDuqmKW58P7PsgoYQxIUbhBETRuCNcTgR8V3UcAR4AizS2I3DeK8grW26K1Ksafk+kZnqiQfxRQ2oTrao1iGsrblpOVGA4dMeH6kaLNJ5kmXMtuJ1qBtI+/DSlgvVO4v2w18MLhGSHM7lynqCqSggq52p8hEG6WBMx4RZsyYHamZvhDDkCyFbIosI3IruFomilLAjuFawqaCxzaNmaKcJ1mbX7F69M2OuB/kSHSSRY5YjZkhUJxeYrWcRfuvFTTZBQwRCo7yRmMVACy9hjygxun6VPmRoSYZpii8zRN/SWHqJngmU75JPulQ98WoFPTtzEo4TrDieqEpi7hw72TGrIWq7fbmv7zTdE6HsCdnwMXDAQSinVoapsySNCkpr7U5NZxg3aeqqm/4nIbsoPPm4BtxMCoy3A2+CVca3Dnkx5c1Xbvdgeyyyz3uWk6WPymqV8A7xzmiTA6xBzEhm3/uHBn1QOiJfITu+0DPjB8bnlLxFPQOmWQqTVeZ7jS4M6kqp74iMAXWRuP4Xt861OSJg1JhgavhE3unAiwx3bxSetVgDGuAzc19QudREjcwZ3rNYM9NWxHoRu7dbMft1bNYpUisyHafRYjsZ4gK7zMM0V0cutjbggvcTiC2UZp08tW7huJkCJ4Q5tpDTda0bBSlVvHHQRHVGyRG8L9I0S4wm+KJ18t3tsIp3sbYVf7sM5I997LMQ6bre5EfyiEKfF+t4dVlixE2gItaoMNyEEvLQiTcE8Y5b7LQgvbOWSzOKtCOaxbrIvHRpVwJR/y6W0CfT1AuW96f5TEmi2OImE5wW8bvQVpiiLhyZq6qigSfqypexRFwvscyumd9KEoEj5rdX8V9FwoI4XXBOFxJ5vSMpu2iyM1pZPeAz9LDyByhMkeMsI7LxqsKwcfSjrMGSYt3aMZEcW/IBSESZiCSWeOzfCwMAmX5HsCoNdlPKJOONbbCP/lhvC1CBE+7Ibwakv/4Ug+GOmF7ZbiZZryXwCw131kdX8MXp6HZOlrgvPAAeju/71h/E+AAQBilxbT/hVOkQAAAABJRU5ErkJggg==\" style=\"width:60px\" /></p>\r\n\r\n<p>Constant Backups<br />\r\n&nbsp;</p>\r\n\r\n<p>Your hosting account is backed up daily going 2 months back at no extra cost. We use dedicated backup servers, providing fast &amp; easy individual file rollback abilities.</p>\r\n</div>\r\n\r\n<div class=\"col-sm-4\">\r\n<p><img src=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADwAAAA8CAYAAAA6/NlyAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA2RpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuMC1jMDYwIDYxLjEzNDc3NywgMjAxMC8wMi8xMi0xNzozMjowMCAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOk9yaWdpbmFsRG9jdW1lbnRJRD0ieG1wLmRpZDo4MzRBMzc3MDIzRDhFMjExQjE5NUMzQzQxMDY2RTg5MSIgeG1wTU06RG9jdW1lbnRJRD0ieG1wLmRpZDpBQkNFRjdBMEQ5QjIxMUUyOUIzODgwQzExMTk5OUExNiIgeG1wTU06SW5zdGFuY2VJRD0ieG1wLmlpZDpBQkNFRjc5RkQ5QjIxMUUyOUIzODgwQzExMTk5OUExNiIgeG1wOkNyZWF0b3JUb29sPSJBZG9iZSBQaG90b3Nob3AgQ1M1IFdpbmRvd3MiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDpDNjYzQTg4QkZGRDhFMjExOUIyOUQzNDA5ODRBNThGNCIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDo4MzRBMzc3MDIzRDhFMjExQjE5NUMzQzQxMDY2RTg5MSIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/PjwiTYAAAAPrSURBVHja7Jq/TxRBFMf3FomdrT+4O/BHo8JxxlhZaWLDz6OzMsbCUlsrGuI/oLGxUTsrETgsIMHCkoOA6FEBonhQ2xkQfC98Ny7L7cyb3b29FfYlLxdu3s7Mh3nfnbdzm9nb27OOk9nWMbMU+KjbCdML3pZnVM058jfkt/D3Nvkr8kfkvxXXnSR/Rv7ANSce6D75D3fg3b7biVnhdvJJFyxbK/lDAKvsMeLcC8BkZfSbuJTmSb0n7/Jpv0fe4tPWgvZ6VkC/+SQBZ8nHyYuKmFOKsWy0+xn3O0HelgTgPNK4oIn7BD3Xs220q6yAcfLNBG7HyupgV8mHNTHDiFNZN49HN832ZgB3ALZbE7dC3i+AceJWhNAdcQLnDVZ2gLwq7LeK+FVBejN0oPTOmNTSGIS11KkJXSPvJV8OMKfLGOO8Ju4Lj0H78veGrDDSqCyAXQ0Ba+G6XsFK8zzKpultG8COK/ZZrxaXrXC2LExvns+YCbQ2pZHGEwLNrgH2a4SF0VWMrUvvzzy2JL2VwDFpNlZN2wnQbKyatkNq1tl6GgUbRNPK4uRQSjdZsw3X9AFgA81+Q5pVrfjtCubYEUTTtieNJw002wxYPgCoGmh60pveNmDP0Mc7ASz/t0rNgvVAl7ynIT7Qo8R32rvCT8mvaS5ex41jKQlnUwS9hPmsa0Kvge8AcI+ggrpDgyxaCTKazwLPS/CU1eMFzgj6/59P7DNe4CnNBRfJp0kLnUmiwHymMT+VTXmBn5BXBA/9Y4JiJC7YAooj3QlIBXz/gEkLNfoYFEBfwMbf1WTYbmEBwjyDxLfpV3icRUfXNR3xdtCHiiZucw70sgLYATfsoVoajQwyq+ksh0GLMcMWhbCzKC03tQ8PFLSFTV0HnYWmizHCjgthS+CQPw9Tep+z9k/9bwjSmx8iFmOAzQlha0EPAJKg6VCaNTrTcmm6ItD0hwakdxH9SmD7dbBaYJemJVtWm6X/jSlIGrcJYAf9NGsMbLhP5yKClmrWga2Ja0zDg3ippjcghSA3Mi4qyoI0npOmsfEK19H0nGDLKgdY6aIQlle2zxTWGBi2hefQigB6wgDa+R04G6VmowBmY80MkS8IoEcFTzOXEKeD5fGGTDQbFbCj014BND9ljWhiRiz9oRyPw4dyG2HuhmHfAKhB0/OauJvW/gsu9awV7Sqbxzi1kPON5B2Pn6i9VSv9i3zXp20X7aqVLWEcKwnA7nraD5rf1frj08bfv1bA9lv608nYgR1N8937o+u7HfKX5C801z5H3I7ruxn0txHhHM0Kj6Ng6culKXAKnAKnwClwCpwCp8ApcAqcAovsrwADAI9xZQ3N89abAAAAAElFTkSuQmCC\" style=\"width:60px\" /></p>\r\n\r\n<p>GIT/SVN Support<br />\r\n&nbsp;</p>\r\n\r\n<p>Web Developers love using version control systems. All our hosting accounts can use GIT &amp; SVN command line tools on our servers. Simply request SSH access to get started.</p>\r\n</div>\r\n\r\n<div class=\"col-sm-4\">\r\n<p>&nbsp;</p>\r\n\r\n<p><img src=\"data:image/png;base64, \" style=\"width:60px\" /></p>\r\n\r\n<p>280+ Install Scripts<br />\r\n&nbsp;</p>\r\n\r\n<p>All our hosting accounts allow you to install popular software such as Wordpress, Drupal, Joolma and Magento in one easy step. Upgrading your software is just as easy!</p>\r\n</div>\r\n\r\n<div class=\"col-sm-4\">\r\n<p>&nbsp;</p>\r\n\r\n<p><img src=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADwAAAA8CAYAAAA6/NlyAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA2RpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuMC1jMDYwIDYxLjEzNDc3NywgMjAxMC8wMi8xMi0xNzozMjowMCAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOk9yaWdpbmFsRG9jdW1lbnRJRD0ieG1wLmRpZDo4MzRBMzc3MDIzRDhFMjExQjE5NUMzQzQxMDY2RTg5MSIgeG1wTU06RG9jdW1lbnRJRD0ieG1wLmRpZDpBQkNFRjdBOEQ5QjIxMUUyOUIzODgwQzExMTk5OUExNiIgeG1wTU06SW5zdGFuY2VJRD0ieG1wLmlpZDpBQkNFRjdBN0Q5QjIxMUUyOUIzODgwQzExMTk5OUExNiIgeG1wOkNyZWF0b3JUb29sPSJBZG9iZSBQaG90b3Nob3AgQ1M1IFdpbmRvd3MiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDpDNjYzQTg4QkZGRDhFMjExOUIyOUQzNDA5ODRBNThGNCIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDo4MzRBMzc3MDIzRDhFMjExQjE5NUMzQzQxMDY2RTg5MSIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/PifEEHQAAAchSURBVHja7FtpbFRVGH1vajdqK0bqggvSqBiJJrgkLjEaa/wjxSggYNxBhdYl1Grq1lqptApFCS0/3FB+GEVqsDT+oMZYV6LB1A2poGIBhWLBbtjSdsbzZc6Fm5d5M/OWmTYyNzl5w5vOve/c8y33fvdhhkIh41hqAeMYaynCKcL/s3ac0x+80/yxXNKBG4GrgAuBCYAJ9AC/AJ8Bm4BOvx947vTr1HNcgcu9wCVABtABbATW4G8G/FZYCN8GlAGXA6cDpwDnA7OB1cDnwDPACX6TBtlSXD4CFgAFQB4wDXgB2IDvz7T7rek0LVFhaVlALZXuBfSORO1xQD6wDXgY2OIT3yeApcBBoB3YB5zF8U2O+SVwJ5Qe9NOHxWwepxnlsS8FGfgQsBM4FVgLXOkD2XKS7eJE3g88AATpnjLufuBS4IZEBK3DnPEmkjYsKkv/3UAasIJKeCFbA/zNOFEMBX/A9WmtX0VaJuDqREXpQZL+IAJpQ1M7n39nejDjLo1sG9yrAZ8fZP9BToYiPCGRaWmQCgjpXBvS4ufXujBtIfs8cIBkS0i2XogDu4A+oBqYSd9O5yQ4I4xOpwJZDs37QyA7wvchmtwtLn1WAtQiTdkSkpVU+CzuN5LwFE7wt44Io9M8+l0DPpsOlK6hGmk2318MjHfhs0LwO5IttpBdj/sLmQ5lsn9lMHWk8NnAJCpSgw7T4iS9j8QiLWpG6FsFcSqrk22TybchK5F6Fe/9Jvkf9/c7JSzpJAfYA8yTB4iTtCwAppJcKIJZZ9gFFIuyYiXbSTAW2QbGiN+Bxbj/lZulpfLDIAefqwWRoM1vZIXzOkkN2URkk99HI3skGosZa2Q7SKzKQraHZB/F/U/dbh6kk3+1hz5ApWtsfjeJ+fgCYHeUfoeBf2yisfLZdhtle6nse/TZes2MRdlWL7ulPzm4bsZdJF1rsQ7x9w005e2M2NEC3cmWZ6h04bP1nAAhWxpL2XhMWpaFPwLXcxlpaqQl/J9BRfP5gJNJdjAK2RAVruCkNPNeLq1ph40ZS559DnBlxnFvHtD5TbispDmblgeXXdBJ3CT00SJiKat+m8nJfoyTJu0h4BtgM9Ur0cxYyL4LLNSisSLbajhosfbDLcBWqjdgCTzdHDjAIBaKc9lo0gqkLee1iUSkvQLcp5GtAtZxk7CK93a6IRtzpYUOZXn2Ev04EOHBVW41HK6RFWmxiGVAkSZAD5eH/VR2HXdFDZrPLnZDNu79MEy7jP7UGyUluWkqL6dbzLuM1ZK1VLZBi8alTnzWbYlnBfPy3QwuQz4RNqmy1bzV50eAOrqP4wDlereEQYLAEkkLNLU8qmL6SHqIRGdo353G++KzUtZp9TyYixKP5NzbgUIuP9O1gBWkBQQ9mHcGyTVrKv/MouCRIl7Sqpac7Wr61UXAOUxPqrg3i/0OezDvOlpfE9Pi6JVptXaQJmY1s22Mrl5J6z49JgjbtUZel5DAkAfSy2jqG8cyYUXa9FHpkObTY5KwtPW8Vvnk06YfSieSsCIdonkbPpA2vJJOxmFaI3dHaS4nWJEWLEdanD5WCd/B5aJSuoLjeSEtAbDOC+lEEZ4DvEr/LdFIV/pIumisEBayb3KjIQWBp4D5Pis9TPMuGm3Ct5JsP+tamaxPtVl8utKjTw+qtbdT8w4kQNk+bt6zWQWR7d2WCNG7YjTMO+Aj2TWaskJW6tmLWJSzS1l+kRalZySL8ByLGSuyxTTneFJW0nzaLeFzjfDJv5RrX6MZ79bMOB6yfubpwXjztKP9MDoLUE2ZyRwO1kk4UTZSm8U0FoxzRZbJ7ajaSx/ihAnmY9/8hR8KL+CCQqWcn4zw4ZkM0uGBrFOflsndwdLTk7SSkFaIKIc4OZ7W0uiggGvivUb4PQpTMymZ7XoPZK1by2i7LCErbwiVQUV1ZCNHLy3cToqFyBmxHLy3uFKY58OyTTuRipoaAvThdsOfFi2QpdG6ajWyqu4mrxfJcc84/naaF5O+C7iZlcOgpXiXyerHrgRsOKyk5fMfRvjAO1L7nn4d1MpOzghDXTkVXMrA1G8hm808+LZh806Fz6TFR7MM++PW8QymBq3OlcIvGuEDs70W08rljN5jhM+EE7W11DccMrly7HONzd/PM45WTLc6DlpQV8qxsxmRhzlwDpVeyR3RQBKKCKpyYpBQJZ5NTHcTfHcInyfSGgpp8rIm+MRRHkYnhTRVgx2kMyB8TdXbjOS2mYzeKv0cz0WOuNJ5Rvh9zz1chJRjIt53qnA38+xkTVUps7xhHD39S2YT8x6hknl8nol8thGSlQj+sh3ZmCstqCyRbjX/WS2v+mkvl45Wk7cM5LXhy0g8RPLyGuJbeMbNnpaWICimMoSOOvnvUWUrRy1cF0yhGUtc+Ut2ZfjucMyFd+p/taQIpwinCKcIj+H2nwADAIPPt8XqH3sWAAAAAElFTkSuQmCC\" style=\"width:60px\" /></p>\r\n\r\n<p>cPanel Included<br />\r\n&nbsp;</p>\r\n\r\n<p>All hosting accounts come with the latest version of cPanel. This makes life easy for you to do routine tasks such as setting up email addresses and managing MySQL databases.</p>\r\n</div>\r\n\r\n<div class=\"col-sm-4\">\r\n<p>&nbsp;</p>\r\n\r\n<p><img src=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADwAAAA8CAYAAAA6/NlyAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA2RpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuMC1jMDYwIDYxLjEzNDc3NywgMjAxMC8wMi8xMi0xNzozMjowMCAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOk9yaWdpbmFsRG9jdW1lbnRJRD0ieG1wLmRpZDo4MzRBMzc3MDIzRDhFMjExQjE5NUMzQzQxMDY2RTg5MSIgeG1wTU06RG9jdW1lbnRJRD0ieG1wLmRpZDpBQkVBMjEyN0Q5QjIxMUUyOUIzODgwQzExMTk5OUExNiIgeG1wTU06SW5zdGFuY2VJRD0ieG1wLmlpZDpBQkVBMjEyNkQ5QjIxMUUyOUIzODgwQzExMTk5OUExNiIgeG1wOkNyZWF0b3JUb29sPSJBZG9iZSBQaG90b3Nob3AgQ1M1IFdpbmRvd3MiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDpDNjYzQTg4QkZGRDhFMjExOUIyOUQzNDA5ODRBNThGNCIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDo4MzRBMzc3MDIzRDhFMjExQjE5NUMzQzQxMDY2RTg5MSIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/PljO070AAAYFSURBVHja7FlpbFRVGH0zHUsRpSxWKm2lQqkt0NpoLVGMWlT8YV0SazQuBIOJW1SCcYlG4xJ/mCgxbqghxO2H0bgFVKIiURtoEwGR1lqLIAUrihQKVEqXGc9nziOf1zvzZjpTMen9kpOZO+++9+65334nFIvFvJEkkVRveGvlF8lMmwRMASYDecREIBcYxfdmAbLbg0Af0APsBf4A9gC/AjuAnbx2dAhbZDQwFaghZgAFJDcWyB7icw8C3dyELcBGoBH4lhsy+F8SPgE4HagFLgJmUXOZlOOIAj7/Cv7+G7AW+BRoAFpoKUlJKBUfhjlX4uMqYB61maqsp3bkpfnAaWluyu/AV8AHRE9GCINoFT7uAuqo3aFIL1BFn5SX3gC8lCFriFLTS4E36A6pmzSIFpPozfTVdGQb8DNwmONZGTT/MFABvAgsBJ4E3ok3MR5Z8ZmPgEUZICvSDPSr99Z4wyNnyPKBZcwSiTUMorKYh4AH4kTYPuUrIfV7jOMIg40pm2l6HlOU+PA+dd8xwBjLfQe4UWHjXf7G5VgCZpiargZuAr6xEgZZufFp4PYEO7gEeJN51DMWEWYqmkl/v0Rd/94gcSmJ+vdJGitnNJ7Ha+ICtwHbjbXqTToJmA1cy/SoRYLie7zW8K+gBcIP4+PRAJO5EFidhGnJ5t0NPEGCtYzSQXIsg898YA3JDyRxXxnwKsmbsoPps+0IYZCVB39s0ZyW3Vx4C8dSZFTyez8fvEkFJo/5shC4gNWTx2hdpO6TwuInZaq13NTXgQVqA88HJtA1DnAd29W7ziaHXMvaPxOLi5Cs+MFjAWQ9LmyXGt+jFuSLBIs7gUMcvw3UM2d6fMdzwDnqng7gMm6WxxjRa7hBKV1Jp0VJcbcCKzley+A4x7J22fD5YZANcUdnJ2E24lNdKjBMt8xZQI360smF+6VgPmtts3LLU+OTqXlNWGrz8cZ9hdxMz9iEeBnp6jAfUpdkyP9BmV2BLexTM4NGJmhX4xIL4U5ajy8VDEqb1W+nxrHAw5aSNJ6c6RMuSYKsBI42NZ5uaMWXVnY8Wlvb1HgaI7mWXwhfZtKSdqr0V5Ygv/uSY4nUWsaFmWuTKfy7qWHtU7bdfBfYrxZabZimbeFtqiiRgFPMrmhQaa0sTvT9RI3n8N6EJdl+Rt8g6TLMrtq4LkXEcqYUX+qp0Q4VaUsDtFTIRTcZ/XW1JYAuUmsSLrcEVIXRCLuXRovzm9J+Td3cHh4AiOY+BLbSZ2XTfgS+Vj4+lTXtGvWMCfRF01W+U+MiVmIbjELlQZLqY4vYxCDqyx3A5UEcIiDRCxLvY/BIgMNvMiqdFYRNatgJnQLcr33I4mNdBrlSZeae6oGXJChwJA0+zsorkaz+Ow+D9FaQlk7j3gSTNxqnHEWqNs5ihSRR+2LgRm5ejDl1GuedZ6nPO2myk2g55zLw7VFzJJUdb5SUuey4ruNzg0QC6VJdnz7FMq7KMtnMiTLvGRVUskjQ1iu/oALSeMt1ifarVJArYrejm/lXSC7KOdk0+1S6OClxm48QhpZ3Q8sL6ZuFxuQOI6GfFRQNFYEpAXPGKAvQqc23njxqcGwaLePzVNA/+2GQ3sAjnC3GDS3GjlcO40lq1Eh/5WkcBIo8yybGfgAA0o2svFbpsyj8PqAqp/JhJLzLCFgzWFCkKlI3LCb6As+02Bsv5u5004cHaIJzk2g0hiqS4tax+YjSmkpSfMaXwH1GLk/uEA/EK9gV1WfoqGc4ZT0D3GuWGju1Y1oQl9x6vXQcwIn/M6IN7J1XGO1reufSJF5AH7+SXU3+USD4J7PG5+y3m1jxBcpQ/nmQruZlopwFew07nDKWj5mWQXZcrWwq1rHZ7071Qen+t9RKLCPRycy7ZSwoivnbRObRUcwMIcsJ5ABT3z6ejnTw2KeddbrfQvans+BIBrXQRTTzPDubQS6HZMfxc7QiHiNRMceDjNB7GaEP0XQz+n9uaKT9Pxz2Rpg4wo6wI+wIO8KOsCPsCDvCjrAj7Ag7wo6wI+wIO8KOsCPsCDvCjrAj7AhnTv4SYABx8JYPQiBfxQAAAABJRU5ErkJggg==\" style=\"width:60px\" /></p>\r\n\r\n<p>Latest PHP &amp; MySQL<br />\r\n&nbsp;</p>\r\n\r\n<p>Our network runs the latest stable and secure versions of PHP &amp; MySQL. We also implement strict security and firewall rules to protect your website from unwanted visitors 24/7</p>\r\n</div>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n', 'rich_text', 'Custom', 'Block');

-- --------------------------------------------------------

--
-- Table structure for table `hd_blocks_modules`
--

CREATE TABLE `hd_blocks_modules` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `settings` varchar(255) NOT NULL,
  `param` varchar(20) NOT NULL,
  `type` varchar(100) NOT NULL DEFAULT 'Module',
  `module` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `hd_blocks_modules`
--

INSERT INTO `hd_blocks_modules` (`id`, `name`, `settings`, `param`, `type`, `module`) VALUES
(6, 'Main Menu', '', 'menus_1', 'Module', 'Menus'),
(7, 'Home Slider', 'a:1:{s:5:\"title\";s:2:\"no\";}', 'sliders_7', 'Module', 'Sliders'),
(9, 'cPanel Hosting', 'a:1:{s:5:\"title\";s:2:\"no\";}', 'items_12', 'Module', 'Items'),
(10, 'Website Packages', 'a:1:{s:5:\"title\";s:2:\"no\";}', 'items_13', 'Module', 'Items'),
(12, 'Plesk Hosting', 'a:1:{s:5:\"title\";s:2:\"no\";}', 'items_19', 'Module', 'Items'),
(13, 'DirectAdmin Hosting', 'a:1:{s:5:\"title\";s:2:\"no\";}', 'items_20', 'Module', 'Items'),
(23, 'Web Hosting', 'a:1:{s:5:\"title\";s:3:\"yes\";}', 'faq_33', 'Module', 'FAQ'),
(29, 'Domain Names', '', 'faq_39', 'Module', 'FAQ');

-- --------------------------------------------------------

--
-- Table structure for table `hd_blocks_pages`
--

CREATE TABLE `hd_blocks_pages` (
  `id` int(11) NOT NULL,
  `block_id` int(11) NOT NULL,
  `page` varchar(100) NOT NULL,
  `mode` varchar(10) NOT NULL DEFAULT 'show',
  `theme` varchar(100) NOT NULL,
  `module` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `hd_blocks_pages`
--

INSERT INTO `hd_blocks_pages` (`id`, `block_id`, `page`, `mode`, `theme`, `module`) VALUES
(48, 10, 'home', 'show', 'original', 'Domains'),
(49, 10, 'domain_registration', 'show', 'original', 'Domains'),
(50, 21, 'domain_registration', 'show', 'original', 'Domains'),
(74, 35, 'all', 'hide', 'original', 'Menus'),
(84, 44, 'layouts', 'show', 'original', 'Block'),
(85, 45, 'layouts', 'show', 'original', 'Block'),
(87, 47, 'contact', 'show', 'original', 'Block'),
(88, 48, 'contact', 'show', 'original', 'Block'),
(94, 51, 'all', 'hide', 'original', 'Block'),
(141, 43, 'web_design', 'show', 'original', 'Items'),
(147, 62, 'domain_registration', 'show', 'original', 'Block'),
(152, 34, 'home', 'show', 'original', 'Sliders'),
(153, 34, 'about', 'show', 'original', 'Sliders'),
(160, 69, 'all', 'hide', 'original', 'Block'),
(181, 72, 'home', 'show', 'original', 'FAQ'),
(182, 73, 'home', 'show', 'original', 'FAQ'),
(183, 74, 'all', 'hide', 'original', 'Block'),
(184, 75, 'all', 'hide', 'original', 'Cart'),
(186, 77, 'home', 'show', 'original', 'Block'),
(190, 54, 'home', 'show', 'original', 'Items'),
(195, 78, 'home', 'show', 'original', 'Items'),
(202, 82, 'web_hosting', 'show', 'original', 'Items'),
(203, 70, 'home', 'show', 'original', 'Block'),
(204, 70, 'web_hosting', 'show', 'original', 'Block'),
(205, 70, 'domain_registration', 'show', 'original', 'Block');

-- --------------------------------------------------------

--
-- Table structure for table `hd_captcha`
--

CREATE TABLE `hd_captcha` (
  `captcha_id` bigint(13) UNSIGNED NOT NULL,
  `captcha_time` int(10) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(16) COLLATE utf8_unicode_ci DEFAULT '0',
  `word` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `hd_categories`
--

CREATE TABLE `hd_categories` (
  `id` int(11) UNSIGNED NOT NULL,
  `cat_name` varchar(255) DEFAULT NULL,
  `parent` int(11) NOT NULL,
  `module` varchar(32) DEFAULT 'items',
  `pricing_table` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `hd_categories`
--

INSERT INTO `hd_categories` (`id`, `cat_name`, `parent`, `module`, `pricing_table`) VALUES
(5, 'Addons', 0, 'items', ''),
(6, 'FAQ', 0, 'pages', ''),
(7, 'Knowledgebase', 0, 'pages', ''),
(8, 'Domains', 0, 'items', ''),
(9, 'Hosting', 0, 'items', ''),
(10, 'Products & Services', 0, 'items', ''),
(12, 'cPanel Hosting', 9, 'items', 'one'),
(13, 'Website Packages', 10, 'items', 'one'),
(14, 'Domains', 8, 'items', ''),
(19, 'Plesk Hosting', 9, 'items', 'three'),
(20, 'DirectAdmin Hosting', 9, 'items', 'five'),
(27, 'General', 7, 'items', ''),
(33, 'Web Hosting', 6, 'items', ''),
(39, 'Domain Names', 6, 'items', '');

-- --------------------------------------------------------

--
-- Table structure for table `hd_companies`
--

CREATE TABLE `hd_companies` (
  `co_id` int(11) UNSIGNED NOT NULL,
  `company_ref` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `individual` tinyint(4) DEFAULT '0',
  `transaction_value` decimal(10,2) DEFAULT '0.00',
  `company_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `primary_contact` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `company_email` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `company_phone` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `company_mobile` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `company_fax` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `company_address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `company_address_two` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `company_website` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `language` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `city` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `state` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `currency` varchar(32) COLLATE utf8_unicode_ci DEFAULT 'USD',
  `country` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `VAT` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `zip` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `notes` text COLLATE utf8_unicode_ci,
  `params` text COLLATE utf8_unicode_ci,
  `imported` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `hd_config`
--

CREATE TABLE `hd_config` (
  `config_key` varchar(255) NOT NULL,
  `value` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `hd_config`
--

INSERT INTO `hd_config` (`config_key`, `value`) VALUES
('2checkout_private_key', ''),
('2checkout_publishable_key', ''),
('2checkout_seller_id', ''),
('accept_coin', 'LTCT'),
('active_theme', 'original'),
('allowed_files', 'gif|png|jpeg|jpg|pdf|doc|txt|docx|xls|zip|rar|xls|mp4'),
('allow_client_registration', 'TRUE'),
('allow_js_php_blocks', 'TRUE'),
('apply_credit', 'TRUE'),
('automatic_activation', 'TRUE'),
('automatic_bug_fixes', 'FALSE'),
('automatic_email_on_recur', 'FALSE'),
('automatic_updates', 'FALSE'),
('auto_backup_db', 'TRUE'),
('auto_close_ticket', '30'),
('beta_updates', 'TRUE'),
('billing_email', 'support@hostingbilling.net'),
('billing_email_name', 'Hosting Billing Sales'),
('bitcoin_active', 'TRUE'),
('bitcoin_address', 'xpub6DQ3AnPkH6mfroevvepugCtiLQoddnF5ZJeNTcMzcwntJ3tHQL8M7bki5fp8GDyNU3f7ZpzkYX64ecp6inuSwW5Q87fhDj2gn9YqV32Ai8w'),
('bitcoin_api_key', '33f80c9e-8e08-437a-8e93-3e5812ff98fd'),
('bitcoin_live', 'TRUE'),
('build', '0'),
('button_color', 'success'),
('captcha_login', 'FALSE'),
('captcha_registration', 'FALSE'),
('cart', 'php'),
('chart_color', '#11A7DB'),
('coinpayments_active', 'TRUE'),
('coinpayments_live', 'TRUE'),
('coinpayments_private_key', '8395262B2f59424A638C839ad8AE7dFF29872d1E69c3d9af1bc1c57fEf5ac388'),
('coinpayments_public_key', '161eb244ecf8abef157cc681bbc7649aabab1e9151168eb54e74540a85b15f08'),
('company_address', 'No 1, Official Building, Sample Street'),
('company_address_french', ''),
('company_city', ''),
('company_city_french', ''),
('company_country', 'Canada'),
('company_country_french', ''),
('company_domain', ''),
('company_domain_french', ''),
('company_email', ''),
('company_email_french', ''),
('company_fax', ''),
('company_fax_french', ''),
('company_id_prefix', 'COM'),
('company_legal_name', 'Hosting Billing'),
('company_legal_name_french', ''),
('company_logo', 'logo.png'),
('company_mobile', ''),
('company_mobile_french', ''),
('company_name', 'Hosting Billing'),
('company_name_french', ''),
('company_phone', ''),
('company_phone_2', ''),
('company_phone_2_french', ''),
('company_phone_french', ''),
('company_registration', ''),
('company_registration_french', ''),
('company_state', ''),
('company_state_french', ''),
('company_vat', ''),
('company_vat_french', ''),
('company_zip_code', ''),
('company_zip_code_french', ''),
('contact_person', 'Hosting Billing'),
('contact_person_french', ''),
('contact_sidebar_right', 'TRUE'),
('cron_key', 'FHF6545AV75223G97JB17GKGSH89'),
('cron_last_run', 'a:12:{s:14:\"cron_recurring\";a:2:{s:7:\"success\";b:1;s:6:\"result\";s:31:\"There are no recurring invoices\";}s:13:\"cron_projects\";a:2:{s:7:\"success\";b:1;s:6:\"result\";s:29:\"There are no overdue projects\";}s:13:\"cron_invoices\";a:2:{s:7:\"success\";b:1;s:6:\"result\";s:29:\"There are no overdue invoices\";}s:13:\"cron_outgoing\";a:2:{s:7:\"success\";b:1;s:6:\"result\";s:28:\"There are no outgoing emails\";}s:18:\"cron_close_tickets\";a:2:{s:7:\"success\";b:1;s:6:\"result\";s:29:\"There are no inactive tickets\";}s:14:\"cron_backup_db\";a:2:{s:7:\"success\";b:1;s:6:\"result\";s:31:\"Database backed up successfully\";}s:11:\"cron_xrates\";a:2:{s:7:\"success\";b:0;s:6:\"result\";s:30:\"App ID is blank. Rates updated\";}s:18:\"cron_fetch_tickets\";a:2:{s:7:\"success\";b:0;s:6:\"result\";s:27:\"IMAP Configuration is blank\";}s:12:\"cron_hosting\";a:2:{s:7:\"success\";b:1;s:6:\"result\";s:26:\"There are no renewals due.\";}s:16:\"cron_suspensions\";a:2:{s:7:\"success\";b:1;s:6:\"result\";s:29:\"There are no suspensions due.\";}s:17:\"cron_terminations\";a:2:{s:7:\"success\";b:1;s:6:\"result\";s:30:\"There are no terminations due.\";}s:12:\"cron_updates\";s:0:\"\";}'),
('currency_decimals', '2'),
('currency_position', 'before'),
('date_format', '%Y-%m-%d'),
('date_php_format', 'Y-m-d'),
('date_picker_format', 'yyyy-mm-dd'),
('decimal_separator', '.'),
('default_currency', 'USD'),
('default_currency_symbol', '$'),
('default_editor', 'ckeditor'),
('default_language', 'english'),
('default_project_settings', '{\"show_team_members\":\"off\",\"show_milestones\":\"on\",\"show_project_tasks\":\"on\",\"show_project_files\":\"on\",\"show_timesheets\":\"off\",\"show_project_bugs\":\"on\",\"show_project_history\":\"off\",\"show_project_calendar\":\"on\",\"show_project_comments\":\"on\",\"show_project_links\":\"on\",\"client_add_tasks\":\"on\",\"show_project_gantt\":\"on\",\"show_project_hours\":\"on\"}'),
('default_tax', '14.00'),
('default_tax2', '0.00'),
('default_terms', '<p>Thank you for your business. Please process this invoice before the due date.</p>\r\n'),
('demo_mode', 'FALSE'),
('developer', 'ig63Yd/+yuA8127gEyTz9TY4pnoeKq8dtocVP44+BJvtlRp8Vqcetwjk51dhSB6Rx8aVIKOPfUmNyKGWK7C/gg=='),
('disable_emails', 'FALSE'),
('display_invoice_badge', 'FALSE'),
('domainscoza_apikey', 'c695683a41445d342be713387f51edb1'),
('domainscoza_live', 'TRUE'),
('domain_admin_address_1', ''),
('domain_admin_address_2', ''),
('domain_admin_city', ''),
('domain_admin_company', ''),
('domain_admin_country', 'South Africa'),
('domain_admin_email', ''),
('domain_admin_firstname', ''),
('domain_admin_lastname', ''),
('domain_admin_phone', ''),
('domain_admin_state', ''),
('domain_admin_zip', ''),
('domain_checker', 'default'),
('email_account_details', 'TRUE'),
('email_invoice_message', 'Hello {CLIENT}<br>Here is the invoice of {CURRENCY} {AMOUNT}<br>You can view the invoice online at:<br>{LINK}<br>Best Regards,<br>{COMPANY}'),
('email_piping', 'TRUE'),
('email_staff_tickets', 'TRUE'),
('enable_languages', 'FALSE'),
('file_max_size', '80000'),
('increment_invoice_number', 'TRUE'),
('installed', 'FALSE'),
('instamojo_active', 'TRUE'),
('instamojo_api_key', 'test_e1aca867f696f9d889b63c0f4e1'),
('instamojo_hash', '44532b09bd374481b58ab65954029367'),
('instamojo_live', 'TRUE'),
('instamojo_oath_token', 'test_8ba6a245f5b4e94f54d2c515cbc'),
('invoices_due_after', '7'),
('invoices_due_before', '2'),
('invoice_color', '#53B567'),
('invoice_footer', 'Thank you.'),
('invoice_language', 'en'),
('invoice_logo', 'invoice_logo.png'),
('invoice_logo_height', '72'),
('invoice_logo_width', '210.433'),
('invoice_prefix', 'INV'),
('invoice_start_no', '1'),
('languages', ''),
('last_check', '1585557268'),
('last_seen_activities', '1626037461'),
('locale', 'aa_DJ'),
('login_bg', 'bg_login.jpg'),
('login_title', ''),
('logo_or_icon', 'logo_title'),
('mailbox', 'INBOX'),
('mail_encryption', 'tls'),
('mail_flags', '/novalidate-cert'),
('mail_imap', 'TRUE'),
('mail_imap_host', ''),
('mail_password', 'df13a5f137e01490a9c3ed278f16d9bf57053fc2faa80bbfdc10d2254aa1353c872fd28cbc40420113be96ad99dc1fa617183a9a996e9db58c95933b1324a9eb48ebQ0qTGFQFO7bDfId1YXI='),
('mail_port', '993'),
('mail_search', 'UNSEEN'),
('mail_ssl', 'TRUE'),
('mail_username', 'admin'),
('mollie_active', 'TRUE'),
('mollie_api_key', 'test_G7meUPuywH8GGBxn57fEVjQJwgafMQ'),
('mollie_live', 'TRUE'),
('namecheap_apikey', '12345'),
('namecheap_ip', '41.113.83.52'),
('namecheap_live', 'TRUE'),
('namecheap_username', 'test'),
('nameserver_five', ''),
('nameserver_four', ''),
('nameserver_one', ''),
('nameserver_three', ''),
('nameserver_two', ''),
('notify_payment_received', 'FALSE'),
('notify_ticket_closed', 'TRUE'),
('notify_ticket_reopened', 'TRUE'),
('notify_ticket_reply', 'TRUE'),
('order_tax', 'FALSE'),
('payfast_active', 'TRUE'),
('payfast_live', 'TRUE'),
('payfast_merchant_id', '10018446'),
('payfast_merchant_key', 'untw67wiis04u'),
('payfast_passphrase', 'SomeString-123_Random'),
('paypal_active', 'TRUE'),
('paypal_cancel_url', 'paypal/cancel'),
('paypal_email', 'support@hostingbilling.net'),
('paypal_ipn_url', 'paypal/t_ipn/ipn'),
('paypal_live', 'TRUE'),
('paypal_success_url', 'paypal/success'),
('paystack_active', 'TRUE'),
('paystack_live', 'TRUE'),
('paystack_secret_key', 'sk_test_96916efaf1525ebcc0f56b79851aab2640e08157 '),
('pdf_engine', 'invoicr'),
('protocol', 'mail'),
('purchase_code', ''),
('quantity_decimals', '0'),
('razorpay_active', 'TRUE'),
('razorpay_api_key', 'stri'),
('razorpay_live', 'TRUE'),
('recaptcha_public_key', '6LexGeIUAAAAAJ70v7Am0fGQcgHDmresRKP2WOw5'),
('reminder_message', 'Hello {CLIENT}<br>This is a friendly reminder to pay your invoice of {CURRENCY} {AMOUNT}<br>You can view the invoice online at:<br>{LINK}<br>Best Regards,<br>{COMPANY}'),
('remote_login_expires', '72'),
('resellerclub_apikey', 'Vif1XMeq3AnCC278PlElAxirdM4oAYRn'),
('resellerclub_live', 'TRUE'),
('resellerclub_resellerid', '994161'),
('reset_key', 'FHF6545AV75223G97JB17GKGSH89'),
('rows_per_table', '25'),
('settings', 'theme'),
('show_invoice_tax', 'TRUE'),
('show_login_image', 'TRUE'),
('show_only_logo', 'FALSE'),
('show_time_ago', 'TRUE'),
('sidebar_theme', 'dark'),
('site_appleicon', 'logo_favicon.png'),
('site_author', 'Hosting Domain'),
('site_desc', 'Hosting Billing is a domain and web hosting billing system.'),
('site_favicon', 'logo_favicon.png'),
('site_icon', 'fa-globe'),
('smtp_encryption', 'ssl'),
('smtp_host', ''),
('smtp_pass', '76160b3e422b94da94bc87254ff8a894f26cb8a0b9a6499c8944551076c45ef272b6c439678b67b77dfc6bcc4010a032710a5fb3f21ed63648e6c1bcd14c616cT0Ps6v2VdUsK99hKD39u4A=='),
('smtp_port', ''),
('smtp_user', ''),
('stop_timer_logout', 'FALSE'),
('stripe_active', 'TRUE'),
('stripe_live', 'TRUE'),
('stripe_private_key', 'sk_test_51HJfXiJY2WLlJEcK37q619s4WVHrxgPfoBzAAErMyTcmTz4ukYWRLhxcD8mbKSrNaESrEPRiwTbrS7KP171r83Lk00wpmfay55'),
('stripe_public_key', 'pk_test_51HJfXiJY2WLlJEcKunmHNmN59bEKRBmgFQzGIVQIIRlFENDSYlgYX5LmsX7QKbuG3hgX417rU3rGCN1hyzykX3rX00fqZh75gd'),
('support_email', 'support@hostingbilling.net'),
('support_email_name', 'Hosting Billing Support'),
('suspend_after', '3'),
('suspend_due', 'FALSE'),
('swap_to_from', 'FALSE'),
('system_font', 'source_sans'),
('tax_decimals', '0'),
('tax_name', 'GST'),
('terminate_after', '10'),
('terminate_due', 'FALSE'),
('theme_color', 'primary'),
('thousand_separator', ','),
('ticket_default_department', '2'),
('ticket_start_no', '1'),
('timezone', 'Africa/Abidjan'),
('top_bar_color', 'skin-black'),
('two_checkout_active', 'FALSE'),
('two_checkout_live', 'FALSE'),
('updates', '1'),
('update_xrates', 'TRUE'),
('use_alternate_emails', 'FALSE'),
('use_recaptcha', 'TRUE'),
('use_whoisxmlapi', 'FALSE'),
('valid_license', 'TRUE'),
('website_name', 'Hosting Billing'),
('website_name_french', 'ABC'),
('whoisxmlapi_key', ''),
('xrates_app_id', ''),
('xrates_check', '2020-07-02');

-- --------------------------------------------------------

--
-- Table structure for table `hd_countries`
--

CREATE TABLE `hd_countries` (
  `id` int(6) NOT NULL,
  `value` varchar(250) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `phone` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `code` varchar(20) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `hd_countries`
--

INSERT INTO `hd_countries` (`id`, `value`, `phone`, `code`) VALUES
(1, 'Afghanistan', '93', 'AF / AFG'),
(2, 'Albania', '355', 'AL / ALB'),
(3, 'Algeria', '213', 'DZ / DZA'),
(4, 'American Samoa', '1-684', 'AS / ASM'),
(5, 'Andorra', '376', 'AD / AND'),
(6, 'Angola', '244', 'AO / AGO'),
(7, 'Anguilla', '1-264', 'AI / AIA'),
(8, 'Antarctica', '672', 'AQ / ATA'),
(9, 'Antigua and Barbuda', '1-268', 'AG / ATG'),
(10, 'Argentina', '54', 'AR / ARG'),
(11, 'Armenia', '374', 'AM / ARM'),
(12, 'Aruba', '297', 'AW / ABW'),
(13, 'Australia', '61', 'AU / AUS'),
(14, 'Austria', '43', 'AT / AUT'),
(15, 'Azerbaijan', '994', 'AZ / AZE'),
(16, 'Bahamas', '1-242', 'BS / BHS'),
(17, 'Bahrain', '973', 'BH / BHR'),
(18, 'Bangladesh', '880', 'BD / BGD'),
(19, 'Barbados', '1-246', 'BB / BRB'),
(20, 'Belarus', '375', 'BY / BLR'),
(21, 'Belgium', '32', 'BE / BEL'),
(22, 'Belize', '501', 'BZ / BLZ'),
(23, 'Benin', '229', 'BJ / BEN'),
(24, 'Bermuda', '1-441', 'BM / BMU'),
(25, 'Bhutan', '975', 'BT / BTN'),
(26, 'Bolivia', '591', 'BO / BOL'),
(27, 'Bosnia and Herzegovina', '387', 'BA / BIH'),
(28, 'Botswana', '267', 'BW / BWA'),
(29, 'Brazil', '55', 'BR / BRA'),
(30, 'British Indian Ocean Territory', '246', 'IO / IOT'),
(31, 'British Virgin Islands', '1-284', 'VG / VGB'),
(32, 'Brunei', '673', 'BN / BRN'),
(33, 'Bulgaria', '359', 'BG / BGR'),
(34, 'Burkina Faso', '226', 'BF / BFA'),
(35, 'Burundi', '257', 'BI / BDI'),
(36, 'Cambodia', '855', 'KH / KHM'),
(37, 'Cameroon', '237', 'CM / CMR'),
(38, 'Canada', '1', 'CA / CAN'),
(39, 'Cape Verde', '238', 'CV / CPV'),
(40, 'Cayman Islands', '1-345', 'KY / CYM'),
(41, 'Central African Republic', '236', 'CF / CAF'),
(42, 'Chad', '235', 'TD / TCD'),
(43, 'Chile', '56', 'CL / CHL'),
(44, 'China', '86', 'CN / CHN'),
(45, 'Christmas Island', '61', 'CX / CXR'),
(46, 'Cocos Islands', '61', 'CC / CCK'),
(47, 'Colombia', '57', 'CO / COL'),
(48, 'Comoros', '269', 'KM / COM'),
(49, 'Cook Islands', '682', 'CK / COK'),
(50, 'Costa Rica', '506', 'CR / CRI'),
(51, 'Croatia', '385', 'HR / HRV'),
(52, 'Cuba', '53', 'CU / CUB'),
(53, 'Curacao', '599', 'CW / CUW'),
(54, 'Cyprus', '357', 'CY / CYP'),
(55, 'Czech Republic', '420', 'CZ / CZE'),
(56, 'Democratic Republic of the Congo', '243', 'CD / COD'),
(57, 'Denmark', '45', 'DK / DNK'),
(58, 'Djibouti', '253', 'DJ / DJI'),
(59, 'Dominica', '1-767', 'DM / DMA'),
(60, 'Dominican Republic', '1-809, 1-829, 1-849', 'DO / DOM'),
(61, 'East Timor', '670', 'TL / TLS'),
(62, 'Ecuador', '593', 'EC / ECU'),
(63, 'Egypt', '20', 'EG / EGY'),
(64, 'El Salvador', '503', 'SV / SLV'),
(65, 'Equatorial Guinea', '240', 'GQ / GNQ'),
(66, 'Eritrea', '291', 'ER / ERI'),
(67, 'Estonia', '372', 'EE / EST'),
(68, 'Ethiopia', '251', 'ET / ETH'),
(69, 'Falkland Islands', '500', 'FK / FLK'),
(70, 'Faroe Islands', '298', 'FO / FRO'),
(71, 'Fiji', '679', 'FJ / FJI'),
(72, 'Finland', '358', 'FI / FIN'),
(73, 'France', '33', 'FR / FRA'),
(74, 'French Polynesia', '689', 'PF / PYF'),
(75, 'Gabon', '241', 'GA / GAB'),
(76, 'Gambia', '220', 'GM / GMB'),
(77, 'Georgia', '995', 'GE / GEO'),
(78, 'Germany', '49', 'DE / DEU'),
(79, 'Ghana', '233', 'GH / GHA'),
(80, 'Gibraltar', '350', 'GI / GIB'),
(81, 'Greece', '30', 'GR / GRC'),
(82, 'Greenland', '299', 'GL / GRL'),
(83, 'Grenada', '1-473', 'GD / GRD'),
(84, 'Guam', '1-671', 'GU / GUM'),
(85, 'Guatemala', '502', 'GT / GTM'),
(86, 'Guernsey', '44-1481', 'GG / GGY'),
(87, 'Guinea', '224', 'GN / GIN'),
(88, 'Guinea-Bissau', '245', 'GW / GNB'),
(89, 'Guyana', '592', 'GY / GUY'),
(90, 'Haiti', '509', 'HT / HTI'),
(91, 'Honduras', '504', 'HN / HND'),
(92, 'Hong Kong', '852', 'HK / HKG'),
(93, 'Hungary', '36', 'HU / HUN'),
(94, 'Iceland', '354', 'IS / ISL'),
(95, 'India', '91', 'IN / IND'),
(96, 'Indonesia', '62', 'ID / IDN'),
(97, 'Iran', '98', 'IR / IRN'),
(98, 'Iraq', '964', 'IQ / IRQ'),
(99, 'Ireland', '353', 'IE / IRL'),
(100, 'Isle of Man', '44-1624', 'IM / IMN'),
(101, 'Israel', '972', 'IL / ISR'),
(102, 'Italy', '39', 'IT / ITA'),
(103, 'Ivory Coast', '225', 'CI / CIV'),
(104, 'Jamaica', '1-876', 'JM / JAM'),
(105, 'Japan', '81', 'JP / JPN'),
(106, 'Jersey', '44-1534', 'JE / JEY'),
(107, 'Jordan', '962', 'JO / JOR'),
(108, 'Kazakhstan', '7', 'KZ / KAZ'),
(109, 'Kenya', '254', 'KE / KEN'),
(110, 'Kiribati', '686', 'KI / KIR'),
(111, 'Kosovo', '383', 'XK / XKX'),
(112, 'Kuwait', '965', 'KW / KWT'),
(113, 'Kyrgyzstan', '996', 'KG / KGZ'),
(114, 'Laos', '856', 'LA / LAO'),
(115, 'Latvia', '371', 'LV / LVA'),
(116, 'Lebanon', '961', 'LB / LBN'),
(117, 'Lesotho', '266', 'LS / LSO'),
(118, 'Liberia', '231', 'LR / LBR'),
(119, 'Libya', '218', 'LY / LBY'),
(120, 'Liechtenstein', '423', 'LI / LIE'),
(121, 'Lithuania', '370', 'LT / LTU'),
(122, 'Luxembourg', '352', 'LU / LUX'),
(123, 'Macau', '853', 'MO / MAC'),
(124, 'Macedonia', '389', 'MK / MKD'),
(125, 'Madagascar', '261', 'MG / MDG'),
(126, 'Malawi', '265', 'MW / MWI'),
(127, 'Malaysia', '60', 'MY / MYS'),
(128, 'Maldives', '960', 'MV / MDV'),
(129, 'Mali', '223', 'ML / MLI'),
(130, 'Malta', '356', 'MT / MLT'),
(131, 'Marshall Islands', '692', 'MH / MHL'),
(132, 'Mauritania', '222', 'MR / MRT'),
(133, 'Mauritius', '230', 'MU / MUS'),
(134, 'Mayotte', '262', 'YT / MYT'),
(135, 'Mexico', '52', 'MX / MEX'),
(136, 'Micronesia', '691', 'FM / FSM'),
(137, 'Moldova', '373', 'MD / MDA'),
(138, 'Monaco', '377', 'MC / MCO'),
(139, 'Mongolia', '976', 'MN / MNG'),
(140, 'Montenegro', '382', 'ME / MNE'),
(141, 'Montserrat', '1-664', 'MS / MSR'),
(142, 'Morocco', '212', 'MA / MAR'),
(143, 'Mozambique', '258', 'MZ / MOZ'),
(144, 'Myanmar', '95', 'MM / MMR'),
(145, 'Namibia', '264', 'NA / NAM'),
(146, 'Nauru', '674', 'NR / NRU'),
(147, 'Nepal', '977', 'NP / NPL'),
(148, 'Netherlands', '31', 'NL / NLD'),
(149, 'Netherlands Antilles', '599', 'AN / ANT'),
(150, 'New Caledonia', '687', 'NC / NCL'),
(151, 'New Zealand', '64', 'NZ / NZL'),
(152, 'Nicaragua', '505', 'NI / NIC'),
(153, 'Niger', '227', 'NE / NER'),
(154, 'Nigeria', '234', 'NG / NGA'),
(155, 'Niue', '683', 'NU / NIU'),
(156, 'North Korea', '850', 'KP / PRK'),
(157, 'Northern Mariana Islands', '1-670', 'MP / MNP'),
(158, 'Norway', '47', 'NO / NOR'),
(159, 'Oman', '968', 'OM / OMN'),
(160, 'Pakistan', '92', 'PK / PAK'),
(161, 'Palau', '680', 'PW / PLW'),
(162, 'Palestine', '970', 'PS / PSE'),
(163, 'Panama', '507', 'PA / PAN'),
(164, 'Papua New Guinea', '675', 'PG / PNG'),
(165, 'Paraguay', '595', 'PY / PRY'),
(166, 'Peru', '51', 'PE / PER'),
(167, 'Philippines', '63', 'PH / PHL'),
(168, 'Pitcairn', '64', 'PN / PCN'),
(169, 'Poland', '48', 'PL / POL'),
(170, 'Portugal', '351', 'PT / PRT'),
(171, 'Puerto Rico', '1-787, 1-939', 'PR / PRI'),
(172, 'Qatar', '974', 'QA / QAT'),
(173, 'Republic of the Congo', '242', 'CG / COG'),
(174, 'Reunion', '262', 'RE / REU'),
(175, 'Romania', '40', 'RO / ROU'),
(176, 'Russia', '7', 'RU / RUS'),
(177, 'Rwanda', '250', 'RW / RWA'),
(178, 'Saint Barthelemy', '590', 'BL / BLM'),
(179, 'Saint Helena', '290', 'SH / SHN'),
(180, 'Saint Kitts and Nevis', '1-869', 'KN / KNA'),
(181, 'Saint Lucia', '1-758', 'LC / LCA'),
(182, 'Saint Martin', '590', 'MF / MAF'),
(183, 'Saint Pierre and Miquelon', '508', 'PM / SPM'),
(184, 'Saint Vincent and the Grenadines', '1-784', 'VC / VCT'),
(185, 'Samoa', '685', 'WS / WSM'),
(186, 'San Marino', '378', 'SM / SMR'),
(187, 'Sao Tome and Principe', '239', 'ST / STP'),
(188, 'Saudi Arabia', '966', 'SA / SAU'),
(189, 'Senegal', '221', 'SN / SEN'),
(190, 'Serbia', '381', 'RS / SRB'),
(191, 'Seychelles', '248', 'SC / SYC'),
(192, 'Sierra Leone', '232', 'SL / SLE'),
(193, 'Singapore', '65', 'SG / SGP'),
(194, 'Sint Maarten', '1-721', 'SX / SXM'),
(195, 'Slovakia', '421', 'SK / SVK'),
(196, 'Slovenia', '386', 'SI / SVN'),
(197, 'Solomon Islands', '677', 'SB / SLB'),
(198, 'Somalia', '252', 'SO / SOM'),
(199, 'South Africa', '27', 'ZA / ZAF'),
(200, 'South Korea', '82', 'KR / KOR'),
(201, 'South Sudan', '211', 'SS / SSD'),
(202, 'Spain', '34', 'ES / ESP'),
(203, 'Sri Lanka', '94', 'LK / LKA'),
(204, 'Sudan', '249', 'SD / SDN'),
(205, 'Suriname', '597', 'SR / SUR'),
(206, 'Svalbard and Jan Mayen', '47', 'SJ / SJM'),
(207, 'Swaziland', '268', 'SZ / SWZ'),
(208, 'Sweden', '46', 'SE / SWE'),
(209, 'Switzerland', '41', 'CH / CHE'),
(210, 'Syria', '963', 'SY / SYR'),
(211, 'Taiwan', '886', 'TW / TWN'),
(212, 'Tajikistan', '992', 'TJ / TJK'),
(213, 'Tanzania', '255', 'TZ / TZA'),
(214, 'Thailand', '66', 'TH / THA'),
(215, 'Togo', '228', 'TG / TGO'),
(216, 'Tokelau', '690', 'TK / TKL'),
(217, 'Tonga', '676', 'TO / TON'),
(218, 'Trinidad and Tobago', '1-868', 'TT / TTO'),
(219, 'Tunisia', '216', 'TN / TUN'),
(220, 'Turkey', '90', 'TR / TUR'),
(221, 'Turkmenistan', '993', 'TM / TKM'),
(222, 'Turks and Caicos Islands', '1-649', 'TC / TCA'),
(223, 'Tuvalu', '688', 'TV / TUV'),
(224, 'U.S. Virgin Islands', '1-340', 'VI / VIR'),
(225, 'Uganda', '256', 'UG / UGA'),
(226, 'Ukraine', '380', 'UA / UKR'),
(227, 'United Arab Emirates', '971', 'AE / ARE'),
(228, 'United Kingdom', '44', 'GB / GBR'),
(229, 'United States', '1', 'US / USA'),
(230, 'Uruguay', '598', 'UY / URY'),
(231, 'Uzbekistan', '998', 'UZ / UZB'),
(232, 'Vanuatu', '678', 'VU / VUT'),
(233, 'Vatican', '379', 'VA / VAT'),
(234, 'Venezuela', '58', 'VE / VEN'),
(235, 'Vietnam', '84', 'VN / VNM'),
(236, 'Wallis and Futuna', '681', 'WF / WLF'),
(237, 'Western Sahara', '212', 'EH / ESH'),
(238, 'Yemen', '967', 'YE / YEM'),
(239, 'Zambia', '260', 'ZM / ZMB'),
(240, 'Zimbabwe', '263', 'ZW / ZWE');

-- --------------------------------------------------------

--
-- Table structure for table `hd_currencies`
--

CREATE TABLE `hd_currencies` (
  `code` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `symbol` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
  `xrate` decimal(12,5) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `hd_currencies`
--

INSERT INTO `hd_currencies` (`code`, `name`, `symbol`, `xrate`) VALUES
('AED', 'United Arab Emirates Dirham', 'د.إ', '3.67300'),
('AUD', 'Australian Dollar', '$', '1.44323'),
('BRL', 'Brazilian Real', 'R$', '5.31780'),
('CAD', 'Canadian Dollar', '$', '1.35913'),
('CHF', 'Swiss Franc', 'Fr', '0.94359'),
('CLP', 'Chilean Peso', '$', '808.60018'),
('CNY', 'Chinese Yuan', '¥', '7.06690'),
('CZK', 'Czech Koruna', 'Kč', '23.57940'),
('DKK', 'Danish Krone', 'Kr', '6.60086'),
('EUR', 'Euro', '€', '0.88598'),
('GBP', 'British Pound', '£', '0.79893'),
('HKD', 'Hong Kong Dollar', '$', '7.75015'),
('HUF', 'Hungarian Forint', 'Ft', '311.92134'),
('IDR', 'Indonesian Rupiah', 'Rp', '14413.05000'),
('ILS', 'Israeli New Shekel', '₪', '3.44597'),
('INR', 'Indian Rupee', '₹', '74.85630'),
('JPY', 'Japanese Yen', '¥', '107.44100'),
('KES', 'Kenya shillings', ' KSh', '106.70000'),
('KN', 'Hrvatska kuna', 'kn', '7.00000'),
('KRW', 'Korean Won', '₩', '1199.24000'),
('MXN', 'Mexican Peso', '$', '22.57976'),
('MYR', 'Malaysian Ringgit', 'RM', '4.28600'),
('NGN', 'Nigerian Naira', '₦', '386.41000'),
('NOK', 'Norwegian Krone', 'kr', '9.45566'),
('NZD', 'New Zealand Dollar', '$', '1.53426'),
('PHP', 'Philippine Peso', '₱', '49.75000'),
('PKR', 'Pakistan Rupee', '₨', '166.91480'),
('PLN', 'Polish Zloty', 'zł', '3.95848'),
('RUB', 'Russian Ruble', '₽', '70.24900'),
('SEK', 'Swedish Krona', 'kr', '9.25487'),
('SGD', 'Singapore Dollar', '$', '1.39272'),
('THB', 'Thai Baht', '฿', '31.07250'),
('TRY', 'Turkish Lira', '₺', '6.85480'),
('TWD', 'Taiwan Dollar', '$', '29.44950'),
('USD', 'US Dollar', '$', '1.00000'),
('VEF', 'Bolívar Fuerte', 'Bs.', '248487.64224'),
('ZAR', 'South African Rand', 'R', '16.91680');

-- --------------------------------------------------------

--
-- Table structure for table `hd_departments`
--

CREATE TABLE `hd_departments` (
  `deptid` int(10) NOT NULL,
  `deptname` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `depthidden` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `hd_departments`
--

INSERT INTO `hd_departments` (`deptid`, `deptname`, `depthidden`) VALUES
(2, 'Support', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `hd_email_templates`
--

CREATE TABLE `hd_email_templates` (
  `template_id` int(11) NOT NULL,
  `email_group` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `subject` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `template_body` text COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `hd_email_templates`
--

INSERT INTO `hd_email_templates` (`template_id`, `email_group`, `subject`, `template_body`) VALUES
(1, 'registration', 'Registration successful', '                                        <table id=\"backgroundTable\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" align=\"center\">\r\n	<tbody>\r\n		<tr>\r\n			<td valign=\"top\">			<table cellspacing=\"0\" cellpadding=\"0\" border=\"0\" align=\"center\">\r\n				<tbody>\r\n					<tr>\r\n						<td width=\"600\" height=\"50\">&nbsp;</td>\r\n					</tr>\r\n					<tr>\r\n						<td style=\"color:#999999\" width=\"600\" height=\"90\">{INVOICE_LOGO}</td>\r\n					</tr>\r\n					<tr>\r\n						<td style=\"background:whitesmoke; border:1px solid #e0e0e0; font-family:Helvetica,Arial,sans-serif\" width=\"600\" valign=\"top\" height=\"200\" bgcolor=\"whitesmoke\">						<table style=\"margin-left:15px;\" align=\"center\">\r\n							<tbody>\r\n								<tr>\r\n									<td width=\"560\" height=\"10\">&nbsp;</td>\r\n								</tr>\r\n								<tr>\r\n									<td width=\"560\">									<h4>New Account</h4>\r\n									<p style=\"font-size:12px; font-family:Helvetica,Arial,sans-serif\">Hi {USERNAME},</p>\r\n								<p style=\"font-size:12px; line-height:20px; font-family:Helvetica,Arial,sans-serif\">			Thank you for registering at {SITE_NAME}. Please find your login details below:<br>Home page: <a href=\"{SITE_URL}\" style=\"color: #11A7DB; text-decoration: none;\"><strong>{SITE_NAME}</strong></a><br><br>Link doesn\'t work? Copy the link below and paste it in your browser address bar:<br><br>{SITE_URL}<br><br>			Your username: {USERNAME}<br>			Your email address: {EMAIL}<br>			Your password: {PASSWORD}<br><br><br>										Best Regards,<br>																		{SITE_NAME}</p>\r\n									</td>\r\n								</tr>\r\n								<tr>\r\n									<td width=\"560\" height=\"10\">&nbsp;</td>\r\n								</tr>\r\n							</tbody>\r\n						</table>\r\n						</td>\r\n					</tr>\r\n					<tr>\r\n						<td width=\"600\" height=\"10\">&nbsp;</td>\r\n					</tr>\r\n					<tr>\r\n						<td align=\"right\"><span style=\"font-size:10px; color:#999999; font-family:Helvetica,Arial,sans-serif\">{SIGNATURE}</span></td>\r\n					</tr>\r\n				</tbody>\r\n			</table>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>'),
(2, 'forgot_password', 'Forgot Password', '                    <table id=\"backgroundTable\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" align=\"center\">\r\n	<tbody>\r\n		<tr>\r\n			<td valign=\"top\">			<table cellspacing=\"0\" cellpadding=\"0\" border=\"0\" align=\"center\">\r\n				<tbody>\r\n					<tr>\r\n						<td width=\"600\" height=\"50\">&nbsp;</td>\r\n					</tr>\r\n					<tr>\r\n						<td style=\"color:#999999\" width=\"600\" height=\"90\">{INVOICE_LOGO}</td>\r\n					</tr>\r\n					<tr>\r\n						<td style=\"background:whitesmoke; border:1px solid #e0e0e0; font-family:Helvetica,Arial,sans-serif\" width=\"600\" valign=\"top\" height=\"200\" bgcolor=\"whitesmoke\">						<table style=\"margin-left:15px;\" align=\"center\">\r\n							<tbody>\r\n								<tr>\r\n									<td width=\"560\" height=\"10\">&nbsp;</td>\r\n								</tr>\r\n								<tr>\r\n									<td width=\"560\">									<h4>New Password</h4>\r\n																	<p style=\"font-size:12px; line-height:20px; font-family:Helvetica,Arial,sans-serif\">			Forgot your password, huh? No big deal.<br>To create a new password, just follow this link:<br>			<a href=\"{PASS_KEY_URL}\" style=\"color: #11A7DB; text-decoration: none;\"><strong>Create new password</strong></a><br><br>Link doesn\'t work? Copy the link below and paste it in your browser address bar:<br>			{PASS_KEY_URL}<br><br>			You received this email, because it was requested by a {SITE_NAME} user.This is part of the procedure to create a new password on the system. If you DID NOT request a new password then please ignore this email and your password will remain the same.<br><br>Thank you,<br><br>										Best Regards,<br>																		{SITE_NAME}</p>\r\n									</td>\r\n								</tr>\r\n								<tr>\r\n									<td width=\"560\" height=\"10\">&nbsp;</td>\r\n								</tr>\r\n							</tbody>\r\n						</table>\r\n						</td>\r\n					</tr>\r\n					<tr>\r\n						<td width=\"600\" height=\"10\">&nbsp;</td>\r\n					</tr>\r\n					<tr>\r\n						<td align=\"right\"><span style=\"font-size:10px; color:#999999; font-family:Helvetica,Arial,sans-serif\">{SIGNATURE}</span></td>\r\n					</tr>\r\n				</tbody>\r\n			</table>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>'),
(3, 'change_email', 'Change Email', '                    <table id=\"backgroundTable\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" align=\"center\">\r\n	<tbody>\r\n		<tr>\r\n			<td valign=\"top\">			<table cellspacing=\"0\" cellpadding=\"0\" border=\"0\" align=\"center\">\r\n				<tbody>\r\n					<tr>\r\n						<td width=\"600\" height=\"50\">&nbsp;</td>\r\n					</tr>\r\n					<tr>\r\n						<td style=\"color:#999999\" width=\"600\" height=\"90\">{INVOICE_LOGO}</td>\r\n					</tr>\r\n					<tr>\r\n						<td style=\"background:whitesmoke; border:1px solid #e0e0e0; font-family:Helvetica,Arial,sans-serif\" width=\"600\" valign=\"top\" height=\"200\" bgcolor=\"whitesmoke\">						<table style=\"margin-left:15px; \" align=\"center\">\r\n							<tbody>\r\n								<tr>\r\n									<td width=\"560\" height=\"10\">&nbsp;</td>\r\n								</tr>\r\n								<tr>\r\n									<td width=\"560\">									<h4>Change Email</h4>\r\n									<p style=\"font-size:12px; font-family:Helvetica,Arial,sans-serif\">Hi {NEW_EMAIL},</p>\r\n								<p style=\"font-size:12px; line-height:20px; font-family:Helvetica,Arial,sans-serif\">			You have changed your email address for {SITE_NAME}.<br>Please follow the link below to confirm your new email address:<br>			<a href=\"{NEW_EMAIL_KEY_URL}\" style=\"color: #11A7DB; text-decoration: none;\"><strong>Confirm Email</strong></a><br><br>			Link doesn\'t work? Copy the link below and paste it in your browser address bar:<br>			{NEW_EMAIL_KEY_URL}<br><br>			Your email address: {NEW_EMAIL}<br><br>			You received this email, because it was requested by a {SITE_NAME} user. If you have received this by mistake, please DO NOT click the confirmation link, and simply delete this email. After a short time, the request will be removed from the system.<br><br>Thank you,<br><br>										Best Regards,<br>																		{SITE_NAME}</p>\r\n									</td>\r\n								</tr>\r\n								<tr>\r\n									<td width=\"560\" height=\"10\">&nbsp;</td>\r\n								</tr>\r\n							</tbody>\r\n						</table>\r\n						</td>\r\n					</tr>\r\n					<tr>\r\n						<td width=\"600\" height=\"10\">&nbsp;</td>\r\n					</tr>\r\n					<tr>\r\n						<td align=\"right\"><span style=\"font-size:10px; color:#999999; font-family:Helvetica,Arial,sans-serif\">{SIGNATURE}</span></td>\r\n					</tr>\r\n				</tbody>\r\n			</table>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>'),
(4, 'activate_account', 'Activate Account', '                                                                                <table id=\"backgroundTable\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" align=\"center\">\r\n	<tbody>\r\n		<tr>\r\n			<td valign=\"top\">			<table cellspacing=\"0\" cellpadding=\"0\" border=\"0\" align=\"center\">\r\n				<tbody>\r\n					<tr>\r\n						<td width=\"600\" height=\"50\">&nbsp;</td>\r\n					</tr>\r\n					<tr>\r\n						<td style=\"color:#999999\" width=\"600\" height=\"90\">{INVOICE_LOGO}</td>\r\n					</tr>\r\n					<tr>\r\n						<td style=\"background:whitesmoke; border:1px solid #e0e0e0; font-family:Helvetica,Arial,sans-serif\" width=\"600\" valign=\"top\" height=\"200\" bgcolor=\"whitesmoke\">						<table style=\"margin-left:15px; \" align=\"center\">\r\n							<tbody>\r\n								<tr>\r\n									<td width=\"560\" height=\"10\">&nbsp;</td>\r\n								</tr>\r\n								<tr>\r\n									<td width=\"560\">									<h4>Activate Account</h4>\r\n									<p style=\"font-size:12px; font-family:Helvetica,Arial,sans-serif\">Hi {USERNAME},</p>\r\n								<p style=\"font-size:12px; line-height:20px; font-family:Helvetica,Arial,sans-serif\">			Thanks for registering at {SITE_NAME}.&nbsp; Please follow the link below to verify your email address:<br>			<a href=\"{ACTIVATE_URL}\" style=\"color: #11A7DB; text-decoration: none;\"><strong>Complete Registration</strong></a><br><br>			Link doesn\'t work? Copy the link below and paste it in your&nbsp; browser address bar:<br>			{ACTIVATE_URL}<br>			Please verify your email within {ACTIVATION_PERIOD} hours, otherwise your registration will become invalid and you will have to register again.<br><br>			Your username: {USERNAME}<br>			Your email address: {EMAIL}<br>			Your password: {PASSWORD}<br><br><br>																					Best Regards,<br>																		{SITE_NAME}</p>\r\n									</td>\r\n								</tr>\r\n								<tr>\r\n									<td width=\"560\" height=\"10\">&nbsp;</td>\r\n								</tr>\r\n							</tbody>\r\n						</table>\r\n						</td>\r\n					</tr>\r\n					<tr>\r\n						<td width=\"600\" height=\"10\">&nbsp;</td>\r\n					</tr>\r\n					<tr>\r\n						<td align=\"right\"><span style=\"font-size:10px; color:#999999; font-family:Helvetica,Arial,sans-serif\">{SIGNATURE}</span></td>\r\n					</tr>\r\n				</tbody>\r\n			</table>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>'),
(5, 'reset_password', 'Reset Password', '                    <table id=\"backgroundTable\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" align=\"center\">\r\n	<tbody>\r\n		<tr>\r\n			<td valign=\"top\">			<table cellspacing=\"0\" cellpadding=\"0\" border=\"0\" align=\"center\">\r\n				<tbody>\r\n					<tr>\r\n						<td width=\"600\" height=\"50\">&nbsp;</td>\r\n					</tr>\r\n					<tr>\r\n						<td style=\"color:#999999\" width=\"600\" height=\"90\">{INVOICE_LOGO}</td>\r\n					</tr>\r\n					<tr>\r\n						<td style=\"background:whitesmoke; border:1px solid #e0e0e0; font-family:Helvetica,Arial,sans-serif\" width=\"600\" valign=\"top\" height=\"200\" bgcolor=\"whitesmoke\">						<table style=\"margin-left:15px;\" align=\"center\">\r\n							<tbody>\r\n								<tr>\r\n									<td width=\"560\" height=\"10\">&nbsp;</td>\r\n								</tr>\r\n								<tr>\r\n									<td width=\"560\">									<h4>New Password</h4>\r\n									<p style=\"font-size:12px; font-family:Helvetica,Arial,sans-serif\">Hi {USERNAME},</p>\r\n								<p style=\"font-size:12px; line-height:20px; font-family:Helvetica,Arial,sans-serif\">			You have successfully changed your password.<br><br>Your username: {USERNAME}<br>Your email address: {EMAIL}<br>Your new password: {NEW_PASSWORD}<br><br><br>										Best Regards,<br>																		{SITE_NAME}</p>\r\n									</td>\r\n								</tr>\r\n								<tr>\r\n									<td width=\"560\" height=\"10\">&nbsp;</td>\r\n								</tr>\r\n							</tbody>\r\n						</table>\r\n						</td>\r\n					</tr>\r\n					<tr>\r\n						<td width=\"600\" height=\"10\">&nbsp;</td>\r\n					</tr>\r\n					<tr>\r\n						<td align=\"right\"><span style=\"font-size:10px; color:#999999; font-family:Helvetica,Arial,sans-serif\">{SIGNATURE}</span></td>\r\n					</tr>\r\n				</tbody>\r\n			</table>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>'),
(16, 'payment_email', 'Payment Received', '<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" id=\"backgroundTable\">\r\n\r\n	<tbody>\r\n\r\n		<tr>\r\n\r\n			<td valign=\"top\">			<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n\r\n				<tbody>\r\n\r\n					<tr>\r\n\r\n						<td height=\"50\" width=\"600\">&nbsp;</td>\r\n\r\n					</tr>\r\n\r\n					<tr>\r\n\r\n						<td height=\"90\" style=\"color:#999999\" width=\"600\">{INVOICE_LOGO}</td>\r\n\r\n					</tr>\r\n\r\n					<tr>\r\n\r\n						<td bgcolor=\"whitesmoke\" height=\"200\" style=\"background:whitesmoke; border:1px solid #e0e0e0; font-family:Helvetica,Arial,sans-serif\" valign=\"top\" width=\"600\">						<table align=\"center\" style=\"margin-left:15px;\">\r\n\r\n							<tbody>\r\n\r\n								<tr>\r\n\r\n									<td height=\"10\" width=\"560\">&nbsp;</td>\r\n\r\n								</tr>\r\n\r\n								<tr>\r\n\r\n									<td width=\"560\">									<h4>Invoice {REF} Payment</h4>\r\n\r\n									<p style=\"font-size:12px; font-family:Helvetica,Arial,sans-serif\">Dear Customer,</p>\r\n\r\n								<p style=\"font-size:12px; line-height:20px; font-family:Helvetica,Arial,sans-serif\">								We have received your payment of {INVOICE_CURRENCY}{PAID_AMOUNT}.<br>								Thank you for your Payment and business. We look forward to working with you again.<br>								--------------------------<br>																		<br><br>																		Best Regards,<br>																		{SITE_NAME}</p>\r\n\r\n									</td>\r\n\r\n								</tr>\r\n\r\n								<tr>\r\n\r\n									<td height=\"10\" width=\"560\">&nbsp;</td>\r\n\r\n								</tr>\r\n\r\n							</tbody>\r\n\r\n						</table>\r\n\r\n						</td>\r\n\r\n					</tr>\r\n\r\n					<tr>\r\n\r\n						<td height=\"10\" width=\"600\">&nbsp;</td>\r\n\r\n					</tr>\r\n\r\n					<tr>\r\n\r\n						<td align=\"right\"><span style=\"font-size:10px; color:#999999; font-family:Helvetica,Arial,sans-serif\">{SIGNATURE}</span></td>\r\n\r\n					</tr>\r\n\r\n				</tbody>\r\n\r\n			</table>\r\n\r\n			</td>\r\n\r\n		</tr>\r\n\r\n	</tbody>\r\n\r\n</table>'),
(17, 'invoice_message', 'Customer Invoice', '                                                            <table id=\"backgroundTable\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" align=\"center\">\r\n	<tbody>\r\n		<tr>\r\n			<td valign=\"top\">			<table cellspacing=\"0\" cellpadding=\"0\" border=\"0\" align=\"center\">\r\n				<tbody>\r\n					<tr>\r\n						<td width=\"600\" height=\"50\"> </td>\r\n					</tr>\r\n					<tr>\r\n						<td style=\"color:#999999\" width=\"600\" height=\"90\">{INVOICE_LOGO}</td>\r\n					</tr>\r\n					<tr>\r\n						<td style=\"background:whitesmoke; border:1px solid #e0e0e0; font-family:Helvetica,Arial,sans-serif\" width=\"600\" valign=\"top\" height=\"200\" bgcolor=\"whitesmoke\">						<table style=\"margin-left:15px;\" align=\"center\">\r\n							<tbody>\r\n								<tr>\r\n									<td width=\"560\" height=\"10\"> </td>\r\n								</tr>\r\n								<tr>\r\n									<td width=\"560\">									\r\n									<p style=\"font-size:12px; line-height:20px; font-family:Helvetica,Arial,sans-serif\">Dear {CLIENT},<br><br>This is a notice that invoice {REF} has been generated.<br><br>Invoice Reference: {REF}<br>Amount Due: {CURRENCY}{AMOUNT}<br><br>You can use the link below to view and pay the invoice.<br><a href=\"{INVOICE_LINK}\" style=\"color: #11A7DB; text-decoration: none;\"><strong>View Invoice</strong></a><br>									<br>									Best Regards,<br>									{SITE_NAME}</p>\r\n									</td>\r\n								</tr>\r\n								<tr>\r\n									<td width=\"560\" height=\"10\"> </td>\r\n								</tr>\r\n							</tbody>\r\n						</table>\r\n						</td>\r\n					</tr>\r\n					<tr>\r\n						<td width=\"600\" height=\"10\"> </td>\r\n					</tr>\r\n					<tr>\r\n						<td align=\"right\"><span style=\"font-size:10px; color:#999999; font-family:Helvetica,Arial,sans-serif\">{SIGNATURE}</span></td>\r\n					</tr>\r\n				</tbody>\r\n			</table>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>'),
(18, 'invoice_reminder', 'Invoice Reminder', '                    <table id=\"backgroundTable\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" align=\"center\">\r\n	<tbody>\r\n		<tr>\r\n			<td valign=\"top\">			<table cellspacing=\"0\" cellpadding=\"0\" border=\"0\" align=\"center\">\r\n				<tbody>\r\n					<tr>\r\n						<td width=\"600\" height=\"50\">&nbsp;</td>\r\n					</tr>\r\n					<tr>\r\n						<td style=\"color:#999999\" width=\"600\" height=\"90\">{INVOICE_LOGO}</td>\r\n					</tr>\r\n					<tr>\r\n						<td style=\"background:whitesmoke; border:1px solid #e0e0e0; font-family:Helvetica,Arial,sans-serif\" width=\"600\" valign=\"top\" height=\"200\" bgcolor=\"whitesmoke\">						<table style=\"margin-left:15px;\" align=\"center\">\r\n							<tbody>\r\n								<tr>\r\n									<td width=\"560\" height=\"10\">&nbsp;</td>\r\n								</tr>\r\n								<tr>\r\n									<td width=\"560\">									<h4>Invoice {REF} Reminder</h4>\r\n									<p style=\"font-size:12px; font-family:Helvetica,Arial,sans-serif\">Dear {CLIENT},</p>\r\n								<p style=\"font-size:12px; line-height:20px; font-family:Helvetica,Arial,sans-serif\">									This is a friendly reminder to pay your invoice of {CURRENCY}{AMOUNT}<br>									You can view the invoice online at:<br>																		<a href=\"{INVOICE_LINK}\" style=\"color: #11A7DB; text-decoration: none;\"><strong>View Invoice</strong>									</a><br><br>																		Best Regards,<br>																		{SITE_NAME}</p>\r\n									</td>\r\n								</tr>\r\n								<tr>\r\n									<td width=\"560\" height=\"10\">&nbsp;</td>\r\n								</tr>\r\n							</tbody>\r\n						</table>\r\n						</td>\r\n					</tr>\r\n					<tr>\r\n						<td width=\"600\" height=\"10\">&nbsp;</td>\r\n					</tr>\r\n					<tr>\r\n						<td align=\"right\"><span style=\"font-size:10px; color:#999999; font-family:Helvetica,Arial,sans-serif\">{SIGNATURE}</span></td>\r\n					</tr>\r\n				</tbody>\r\n			</table>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>'),
(19, 'message_received', 'Message Received', '<table align=\"center\" id=\"backgroundTable\">\n	<tbody>\n		<tr>\n			<td valign=\"top\">			<table align=\"center\">\n				<tbody>\n					<tr>\n						<td height=\"50\" width=\"600\">&nbsp;</td>\n					</tr>\n					<tr>\n						<td height=\"90\" style=\"color:#999999\" width=\"600\">{INVOICE_LOGO}</td>\n					</tr>\n					<tr>\n						<td bgcolor=\"whitesmoke\" height=\"200\" style=\"background:whitesmoke; border:1px solid #e0e0e0; font-family:Helvetica,Arial,sans-serif\" valign=\"top\" width=\"600\">						<table align=\"center\" style=\"margin-left:15px; \">\n							<tbody>\n								<tr>\n									<td height=\"10\" width=\"560\">&nbsp;</td>\n								</tr>\n								<tr>\n									<td width=\"560\">									<h4>New message received</h4>\n									<p style=\"font-size:12px; font-family:Helvetica,Arial,sans-serif\">Hi {RECIPIENT},</p>\n								<p style=\"font-size:12px; line-height:20px; font-family:Helvetica,Arial,sans-serif\">You have received a message from <strong>{SENDER}</strong>.<br>------------------------------------------------------------------:<br><span style=\"font-style:italic;\">{MESSAGE}</span><br><br><a href=\"{SITE_URL}\" style=\"color: #11A7DB; text-decoration: none;\"><strong>View Message</strong></a><br><br><br>									Best Regards,									<br>																		{SITE_NAME}</p>\n									</td>\n								</tr>\n								<tr>\n									<td height=\"10\" width=\"560\">&nbsp;</td>\n								</tr>\n							</tbody>\n						</table>\n						</td>\n					</tr>\n					<tr>\n						<td height=\"10\" width=\"600\">&nbsp;</td>\n					</tr>\n					<tr>\n						<td align=\"right\"><span style=\"font-size:10px; color:#999999; font-family:Helvetica,Arial,sans-serif\">{SIGNATURE}</span></td>\n					</tr>\n				</tbody>\n			</table>\n			</td>\n		</tr>\n	</tbody>\n</table>'),
(21, 'ticket_staff_email', 'Ticket [SUBJECT]', '                    <table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" id=\"backgroundTable\">\r\n	<tbody>\r\n		<tr>\r\n			<td valign=\"top\">			<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n				<tbody>\r\n					<tr>\r\n						<td height=\"50\" width=\"600\">&nbsp;</td>\r\n					</tr>\r\n					<tr>\r\n						<td height=\"90\" style=\"color:#999999\" width=\"600\">{INVOICE_LOGO}</td>\r\n					</tr>\r\n					<tr>\r\n						<td bgcolor=\"whitesmoke\" height=\"200\" style=\"background:whitesmoke; border:1px solid #e0e0e0; font-family:Helvetica,Arial,sans-serif\" valign=\"top\" width=\"600\">						<table align=\"center\" style=\"margin-left:15px;\">\r\n							<tbody>\r\n								<tr>\r\n									<td height=\"10\" width=\"560\">&nbsp;</td>\r\n								</tr>\r\n								<tr>\r\n									<td width=\"560\">									<h4>New Ticket</h4>\r\n									<p style=\"font-size:12px; font-family:Helvetica,Arial,sans-serif\">Hi {USER_EMAIL},</p>\r\n								<p style=\"font-size:12px; line-height:20px; font-family:Helvetica,Arial,sans-serif\">Ticket <strong>{SUBJECT}</strong> has been opened.<br>You may view the ticket by clicking on the following link:<br>Client Email : {REPORTER_EMAIL}<br><br><a href=\"{TICKET_LINK}\" style=\"color: #11A7DB; text-decoration: none;\"><strong>View Ticket</strong></a><br><br><br>									Best Regards,									<br>																		{SITE_NAME}</p>\r\n									</td>\r\n								</tr>\r\n								<tr>\r\n									<td height=\"10\" width=\"560\">&nbsp;</td>\r\n								</tr>\r\n							</tbody>\r\n						</table>\r\n						</td>\r\n					</tr>\r\n					<tr>\r\n						<td height=\"10\" width=\"600\">&nbsp;</td>\r\n					</tr>\r\n					<tr>\r\n						<td align=\"right\"><span style=\"font-size:10px; color:#999999; font-family:Helvetica,Arial,sans-serif\">{SIGNATURE}</span></td>\r\n					</tr>\r\n				</tbody>\r\n			</table>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>'),
(22, 'ticket_client_email', 'Ticket [SUBJECT]', '                                                                                <table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" id=\"backgroundTable\">\r\n	<tbody>\r\n		<tr>\r\n			<td valign=\"top\">			<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n				<tbody>\r\n					<tr>\r\n						<td height=\"50\" width=\"600\"> </td>\r\n					</tr>\r\n					<tr>\r\n						<td height=\"90\" style=\"color:#999999\" width=\"600\">{INVOICE_LOGO}</td>\r\n					</tr>\r\n					<tr>\r\n						<td bgcolor=\"whitesmoke\" height=\"200\" style=\"background:whitesmoke; border:1px solid #e0e0e0; font-family:Helvetica,Arial,sans-serif\" valign=\"top\" width=\"600\">						<table align=\"center\" style=\"margin-left:15px;\">\r\n							<tbody>\r\n								<tr>\r\n									<td height=\"10\" width=\"560\"> </td>\r\n								</tr>\r\n								<tr>\r\n									<td width=\"560\">									<h4>Ticket Opened</h4>\r\n									<p style=\"font-size:12px; font-family:Helvetica,Arial,sans-serif\">Hi {CLIENT_EMAIL},</p>\r\n								<p style=\"font-size:12px; line-height:20px; font-family:Helvetica,Arial,sans-serif\">			Your ticket has been opened with us.<br>Ticket <strong>{SUBJECT}</strong><br>Status : Open<br>Click on the below link to see the ticket details and post replies: <br><a href=\"{TICKET_LINK}\" style=\"color: #11A7DB; text-decoration: none;\"><strong>View Ticket</strong></a><br><br><br>									Best Regards,									<br>																		{SITE_NAME}</p>\r\n									</td>\r\n								</tr>\r\n								<tr>\r\n									<td height=\"10\" width=\"560\"> </td>\r\n								</tr>\r\n							</tbody>\r\n						</table>\r\n						</td>\r\n					</tr>\r\n					<tr>\r\n						<td height=\"10\" width=\"600\"> </td>\r\n					</tr>\r\n					<tr>\r\n						<td align=\"right\"><span style=\"font-size:10px; color:#999999; font-family:Helvetica,Arial,sans-serif\">{SIGNATURE}</span></td>\r\n					</tr>\r\n				</tbody>\r\n			</table>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>'),
(23, 'ticket_reply_email', 'Ticket [SUBJECT] response', '                                                                                <table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" id=\"backgroundTable\">	<tbody>		<tr>			<td valign=\"top\">			<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">				<tbody>					<tr>						<td height=\"50\" width=\"600\">&nbsp;</td>					</tr>					<tr>						<td height=\"90\" style=\"color:#999999\" width=\"600\">{INVOICE_LOGO}</td>					</tr>					<tr>						<td bgcolor=\"whitesmoke\" height=\"200\" style=\"background:whitesmoke; border:1px solid #e0e0e0; font-family:Helvetica,Arial,sans-serif\" valign=\"top\" width=\"600\">						<table align=\"center\" style=\"margin-left:15px;\">							<tbody>								<tr>									<td height=\"10\" width=\"560\">&nbsp;</td>								</tr>								<tr>									<td width=\"560\">									<h4>Ticket Response</h4>									<p style=\"font-size:12px; font-family:Helvetica,Arial,sans-serif\">Hi There,</p>								<p style=\"font-size:12px; line-height:20px; font-family:Helvetica,Arial,sans-serif\">A new response has been added to Ticket <strong>{SUBJECT}</strong><br><br>Ticket : <strong>#{TICKET_CODE}</strong><br>Status : <strong>{TICKET_STATUS}</strong><br><span style=\"font-style:italic;\">{TICKET_REPLY}</span><br><br>\r\nTo see the response and post additional comments, click on the link below:<br><a href=\"{TICKET_LINK}\" style=\"color: #11A7DB; text-decoration: none;\"><strong>View Ticket</strong></a><br><br>								Best Regards,<br>																		{SITE_NAME}</p>									</td>								</tr>								<tr>									<td height=\"10\" width=\"560\">&nbsp;</td>								</tr>							</tbody>						</table>						</td>					</tr>					<tr>						<td height=\"10\" width=\"600\">&nbsp;</td>					</tr>					<tr>						<td align=\"right\"><span style=\"font-size:10px; color:#999999; font-family:Helvetica,Arial,sans-serif\">{SIGNATURE}</span></td>					</tr>				</tbody>			</table>			</td>		</tr>	</tbody></table>'),
(24, 'ticket_closed_email', 'Ticket [SUBJECT] closed', '                    <table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" id=\"backgroundTable\">	<tbody>		<tr>			<td valign=\"top\">			<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">				<tbody>					<tr>						<td height=\"50\" width=\"600\">&nbsp;</td>					</tr>					<tr>						<td height=\"90\" style=\"color:#999999\" width=\"600\">{INVOICE_LOGO}</td>					</tr>					<tr>						<td bgcolor=\"whitesmoke\" height=\"200\" style=\"background:whitesmoke; border:1px solid #e0e0e0; font-family:Helvetica,Arial,sans-serif\" valign=\"top\" width=\"600\">						<table align=\"center\" style=\"margin-left:15px;\">							<tbody>								<tr>									<td height=\"10\" width=\"560\">&nbsp;</td>								</tr>								<tr>									<td width=\"560\">									<h4>Ticket Closed</h4>									<p style=\"font-size:12px; font-family:Helvetica,Arial,sans-serif\">Hi {REPORTER_EMAIL},</p>								<p style=\"font-size:12px; line-height:20px; font-family:Helvetica,Arial,sans-serif\">			Ticket <strong>{SUBJECT}</strong> has been closed by <strong>{STAFF_USERNAME}</strong><br>Ticket : <strong>#{TICKET_CODE}</strong><br>Status : <strong>{TICKET_STATUS}</strong><br>To see the responses or open the ticket, click on the link below:<br><a href=\"{TICKET_LINK}\" style=\"color: #11A7DB; text-decoration: none;\"><strong>View Ticket</strong></a><br><br><br>									Best Regards,									<br>																		{SITE_NAME}</p>									</td>								</tr>								<tr>									<td height=\"10\" width=\"560\">&nbsp;</td>								</tr>							</tbody>						</table>						</td>					</tr>					<tr>						<td height=\"10\" width=\"600\">&nbsp;</td>					</tr>					<tr>						<td align=\"right\"><span style=\"font-size:10px; color:#999999; font-family:Helvetica,Arial,sans-serif\">{SIGNATURE}</span></td>					</tr>				</tbody>			</table>			</td>		</tr>	</tbody></table>'),
(27, 'email_signature', NULL, '                                        Powered by Hosting Domain<br>'),
(28, 'auto_close_ticket', 'Ticket Auto Closed', '                                        <table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" id=\"backgroundTable\">\r\n	<tbody>\r\n		<tr>\r\n			<td valign=\"top\">			<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n				<tbody>\r\n					<tr>\r\n						<td height=\"50\" width=\"600\"> </td>\r\n					</tr>\r\n					<tr>\r\n						<td height=\"90\" style=\"color:#999999\" width=\"600\">{INVOICE_LOGO}</td>\r\n					</tr>\r\n					<tr>\r\n						<td bgcolor=\"whitesmoke\" height=\"200\" style=\"background:whitesmoke; border:1px solid #e0e0e0; font-family:Helvetica,Arial,sans-serif\" valign=\"top\" width=\"600\">						<table align=\"center\" style=\"margin-left:15px;\">\r\n							<tbody>\r\n								<tr>\r\n									<td height=\"10\" width=\"560\"> </td>\r\n								</tr>\r\n								<tr>\r\n									<td width=\"560\">									<h4>Ticket Closed</h4>\r\n									<p style=\"font-size:12px; font-family:Helvetica,Arial,sans-serif\">Hi {REPORTER_EMAIL},</p>\r\n								<p style=\"font-size:12px; line-height:20px; font-family:Helvetica,Arial,sans-serif\">Ticket <strong>{SUBJECT}</strong> has been auto closed due to inactivity. <br><br>Ticket : <strong>#{TICKET_CODE}</strong><br>Status : <strong>{TICKET_STATUS}</strong><br>To see the responses or open the ticket, click on the link below:<br><a href=\"{TICKET_LINK}\" style=\"color: #11A7DB; text-decoration: none;\"><strong>View Ticket</strong></a><br><br><br>									Best Regards,									<br>																		{SITE_NAME}</p>\r\n									</td>\r\n								</tr>\r\n								<tr>\r\n									<td height=\"10\" width=\"560\"> </td>\r\n								</tr>\r\n							</tbody>\r\n						</table>\r\n						</td>\r\n					</tr>\r\n					<tr>\r\n						<td height=\"10\" width=\"600\"> </td>\r\n					</tr>\r\n					<tr>\r\n						<td align=\"right\"><span style=\"font-size:10px; color:#999999; font-family:Helvetica,Arial,sans-serif\">{SIGNATURE}</span></td>\r\n					</tr>\r\n				</tbody>\r\n			</table>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>'),
(32, 'ticket_reopened_email', 'Ticket [SUBJECT] reopened', '                                                            <table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" id=\"backgroundTable\">\r\n	<tbody>\r\n		<tr>\r\n			<td valign=\"top\">			<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n				<tbody>\r\n					<tr>\r\n						<td height=\"50\" width=\"600\">&nbsp;</td>\r\n					</tr>\r\n					<tr>\r\n						<td height=\"90\" style=\"color:#999999\" width=\"600\">{INVOICE_LOGO}</td>\r\n					</tr>\r\n					<tr>\r\n						<td bgcolor=\"whitesmoke\" height=\"200\" style=\"background:whitesmoke; border:1px solid #e0e0e0; font-family:Helvetica,Arial,sans-serif\" valign=\"top\" width=\"600\">						<table align=\"center\" style=\"margin-left:15px;\">\r\n							<tbody>\r\n								<tr>\r\n									<td height=\"10\" width=\"560\">&nbsp;</td>\r\n								</tr>\r\n								<tr>\r\n									<td width=\"560\">									<h4>Ticket re-opened</h4>\r\n									<p style=\"font-size:12px; font-family:Helvetica,Arial,sans-serif\">Hi {RECIPIENT},</p>\r\n								<p style=\"font-size:12px; line-height:20px; font-family:Helvetica,Arial,sans-serif\">			Ticket <b>{SUBJECT}</b> was re-opened by <b>{USER}</b>.<br>Status : Open<br>Click on the below link to see the ticket details and post replies: <br><a href=\"{TICKET_LINK}\" style=\"color: #11A7DB; text-decoration: none;\"><strong>View Ticket</strong></a><br><br><br>									Best Regards,									<br>																		{SITE_NAME}</p>\r\n									</td>\r\n								</tr>\r\n								<tr>\r\n									<td height=\"10\" width=\"560\">&nbsp;</td>\r\n								</tr>\r\n							</tbody>\r\n						</table>\r\n						</td>\r\n					</tr>\r\n					<tr>\r\n						<td height=\"10\" width=\"600\">&nbsp;</td>\r\n					</tr>\r\n					<tr>\r\n						<td align=\"right\"><span style=\"font-size:10px; color:#999999; font-family:Helvetica,Arial,sans-serif\">{SIGNATURE}</span></td>\r\n					</tr>\r\n				</tbody>\r\n			</table>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>'),
(34, 'hosting_account', 'Hosting Account Information', '                                                                                                                                                                                                                                                                                                                                <table id=\"backgroundTable\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" align=\"center\">\r\n	<tbody>\r\n		<tr>\r\n			<td valign=\"top\">			<table cellspacing=\"0\" cellpadding=\"0\" border=\"0\" align=\"center\">\r\n				<tbody>\r\n					<tr>\r\n						<td width=\"600\" height=\"50\">&nbsp;</td>\r\n					</tr>\r\n					<tr>\r\n						<td style=\"color:#999999\" width=\"600\" height=\"90\">{INVOICE_LOGO}</td>\r\n					</tr>\r\n					<tr>\r\n						<td style=\"background:whitesmoke; border:1px solid #e0e0e0; font-family:Helvetica,Arial,sans-serif\" width=\"600\" valign=\"top\" height=\"200\" bgcolor=\"whitesmoke\">						<table style=\"margin-left:15px; \" align=\"center\">\r\n							<tbody>\r\n								<tr>\r\n									<td width=\"560\" height=\"10\">&nbsp;</td></tr><tr><td width=\"560\"><p style=\"font-size:12px; font-family:Helvetica,Arial,sans-serif\">Hi {CLIENT},</p>\r\n								<p style=\"font-size:12px; line-height:20px; font-family:Helvetica,Arial,sans-serif\">			Thank you for using {SITE_NAME}. <br>Your hosting account for&nbsp;{DOMAIN} has been activated.</p><h3>ACCOUNT DETAILS</h3><p style=\"font-size:12px; line-height:20px; font-family:Helvetica,Arial,sans-serif\"><b>Username:</b> {ACCOUNT_USERNAME}<br><b>Password:</b> {ACCOUNT_PASSWORD}<br><b>Next Invoice Date</b>: {RENEWAL_DATE}<br><b>Package: </b>{PACKAGE}<br><b>Payment:</b> {RENEWAL}<br><b>Amount:</b> {AMOUNT}<br><br>																					Best Regards,<br>																		{SITE_NAME}</p>\r\n									</td>\r\n								</tr>\r\n								<tr>\r\n									<td width=\"560\" height=\"10\">&nbsp;</td>\r\n								</tr>\r\n							</tbody>\r\n						</table>\r\n						</td>\r\n					</tr>\r\n					<tr>\r\n						<td width=\"600\" height=\"10\">&nbsp;</td>\r\n					</tr>\r\n					<tr>\r\n						<td align=\"right\"><span style=\"font-size:10px; color:#999999; font-family:Helvetica,Arial,sans-serif\">{SIGNATURE}</span></td>\r\n					</tr>\r\n				</tbody>\r\n			</table>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>');

-- --------------------------------------------------------

--
-- Table structure for table `hd_fields`
--

CREATE TABLE `hd_fields` (
  `id` int(10) NOT NULL,
  `deptid` int(10) NOT NULL,
  `module` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `form_id` int(11) DEFAULT NULL,
  `name` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `label` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `uniqid` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `required` int(11) DEFAULT NULL,
  `field_options` text COLLATE utf8_unicode_ci,
  `cid` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `order` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `hd_files`
--

CREATE TABLE `hd_files` (
  `file_id` int(11) NOT NULL,
  `client_id` int(11) DEFAULT '0',
  `file_name` text COLLATE utf8_unicode_ci,
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `path` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ext` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `size` int(10) DEFAULT NULL,
  `is_image` int(2) DEFAULT NULL,
  `image_width` int(5) DEFAULT NULL,
  `image_height` int(5) DEFAULT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `uploaded_by` int(11) NOT NULL,
  `date_posted` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `hd_formmeta`
--

CREATE TABLE `hd_formmeta` (
  `id` int(11) UNSIGNED NOT NULL,
  `module` varchar(64) DEFAULT NULL,
  `client_id` int(11) DEFAULT NULL,
  `ticket_id` int(11) DEFAULT NULL,
  `field_id` int(11) DEFAULT NULL,
  `meta_key` varchar(64) DEFAULT NULL,
  `meta_value` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `hd_formmeta`
--

INSERT INTO `hd_formmeta` (`id`, `module`, `client_id`, `ticket_id`, `field_id`, `meta_key`, `meta_value`) VALUES
(1, 'clients', 2, NULL, 1, 'cell', '12345'),
(2, 'clients', 2, NULL, 2, 'tax-number', '1234566'),
(3, 'clients', 1, NULL, 2, 'tax-number', '222222');

-- --------------------------------------------------------

--
-- Table structure for table `hd_hooks`
--

CREATE TABLE `hd_hooks` (
  `module` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `parent` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `hook` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `icon` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `route` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `order` int(10) DEFAULT NULL,
  `access` int(2) NOT NULL,
  `core` int(2) DEFAULT NULL,
  `visible` int(2) DEFAULT '1',
  `permission` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `enabled` int(2) NOT NULL DEFAULT '1',
  `last_run` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `hd_hooks`
--

INSERT INTO `hd_hooks` (`module`, `parent`, `hook`, `icon`, `name`, `route`, `order`, `access`, `core`, `visible`, `permission`, `enabled`, `last_run`) VALUES
('cron_backup_db', '', 'cron_job_admin', 'fa-database', 'auto_backup_database', 'crons/backup_db', 7, 1, 1, 1, '', 1, '2021-05-31 07:28:13'),
('cron_close_tickets', '', 'cron_job_admin', 'fa-ticket', 'auto_close_tickets', 'crons/close_tickets', 5, 1, 1, 1, '', 1, '2021-05-31 07:28:12'),
('cron_fetch_tickets', '', 'cron_job_admin', 'fa-ticket', 'fetch_ticket_emails', 'crons/fetch_tickets', 6, 1, 1, 1, '', 1, '2021-05-31 07:28:12'),
('cron_hosting', '', 'cron_job_admin', 'fa-server', 'hosting_renewals', 'crons/accounts', 3, 1, 1, 1, '', 1, '2021-05-31 07:28:12'),
('cron_invoices', '', 'cron_job_admin', 'fa-clock-o', 'overdue_invoices', 'crons/invoices', 3, 1, 1, 1, '', 1, '2021-05-31 07:28:12'),
('cron_outgoing', '', 'cron_job_admin', 'fa-envelope-o', 'pending_emails', 'crons/outgoing_emails', 4, 1, 1, 1, '', 1, '2021-05-31 07:28:12'),
('cron_recurring', '', 'cron_job_admin', 'fa-retweet', 'recurring_invoices', 'crons/recur', 1, 1, 1, 1, '', 1, '2021-05-31 07:28:12'),
('cron_suspensions', '', 'cron_job_admin', 'fa-ban', 'hosting_suspensions', 'crons/suspensions', 3, 1, 1, 1, '', 1, '2021-05-31 07:28:12'),
('cron_terminations', '', 'cron_job_admin', 'fa-trash', 'hosting_terminations', 'crons/terminations', 3, 1, 1, 1, '', 1, '2021-05-31 07:28:12'),
('cron_updates', '', 'cron_job_admin', 'fa-cloud-download', 'updates_bug_fixes', 'crons/updates', 7, 1, 1, 1, '', 1, '2021-05-31 07:28:12'),
('cron_xrates', '', 'cron_job_admin', 'fa-money', 'open_exchange_rates', 'crons/xrates', 8, 1, 1, 1, '', 1, '2021-05-31 07:28:13'),
('menu_accounts', '', 'main_menu_admin', 'fa-server', 'accounts', 'accounts', 3, 1, 1, 1, '', 1, '0000-00-00 00:00:00'),
('menu_accounts', '', 'main_menu_client', 'fa-server', 'accounts', 'accounts', 4, 2, 1, 1, '', 1, '0000-00-00 00:00:00'),
('menu_accounts', '', 'main_menu_staff', 'fa-server', 'accounts', 'accounts', 3, 3, 1, 1, '', 1, '0000-00-00 00:00:00'),
('menu_clients', '', 'main_menu_admin', 'fa-group', 'clients', 'companies', 7, 1, 1, 1, '', 1, '0000-00-00 00:00:00'),
('menu_clients', '', 'main_menu_staff', 'fa-users', 'clients', 'companies', 6, 3, 1, 1, '', 1, '0000-00-00 00:00:00'),
('menu_dashboard', '', 'main_menu_admin', 'fa-cloud-download', 'dashboard', 'dashboard', 1, 1, 1, 1, '1', 1, '0000-00-00 00:00:00'),
('menu_dashboard', '', 'main_menu_staff', 'fa-tachometer', 'dashboard', 'dashboard', 1, 3, 1, 1, '', 1, '0000-00-00 00:00:00'),
('menu_domains', '', 'main_menu_admin', 'fa-tachometer', 'domains', 'domains', 4, 1, 1, 1, '', 1, '0000-00-00 00:00:00'),
('menu_domains', '', 'main_menu_client', 'fa-globe', 'domains', 'domains', 2, 2, 1, 1, '', 1, '0000-00-00 00:00:00'),
('menu_domains', '', 'main_menu_staff', 'fa-globe', 'domains', 'domains', 4, 3, 1, 1, '', 1, '0000-00-00 00:00:00'),
('menu_home', '', 'main_menu_client', 'fa-dashboard', 'dashboard', 'clients', 1, 2, 1, 1, '', 1, '0000-00-00 00:00:00'),
('menu_invoices', 'menu_sales', 'main_menu_admin', 'fa-money', 'invoices', 'invoices', 5, 1, 1, 1, '', 1, '0000-00-00 00:00:00'),
('menu_invoices', '', 'main_menu_client', 'fa-list', 'invoices', 'invoices', 5, 2, 1, 1, '', 1, '0000-00-00 00:00:00'),
('menu_invoices', '', 'main_menu_staff', 'fa-list', 'invoices', 'invoices', 5, 3, 1, 1, '', 1, '0000-00-00 00:00:00'),
('menu_items', 'menu_sales', 'main_menu_admin', 'fa-align-justify', 'items', 'items', 8, 0, 1, 1, '', 1, '0000-00-00 00:00:00'),
('menu_orders', '', 'main_menu_admin', 'fa-shopping-basket', 'orders', 'orders', 2, 1, 1, 1, '', 1, '0000-00-00 00:00:00'),
('menu_orders', '', 'main_menu_client', 'fa-shopping-basket', 'new_order', 'orders/add_order', 7, 2, 1, 1, '', 1, '0000-00-00 00:00:00'),
('menu_orders', '', 'main_menu_staff', 'fa-shopping-basket', 'orders', 'orders', 2, 3, 1, 1, '', 1, '0000-00-00 00:00:00'),
('menu_payments', 'menu_sales', 'main_menu_admin', 'fa-credit-card', 'payments', 'payments', 6, 1, 1, 1, '', 1, '0000-00-00 00:00:00'),
('menu_payments', '', 'main_menu_client', 'fa-money', 'payments', 'payments', 3, 2, 1, 1, '', 1, '0000-00-00 00:00:00'),
('menu_payments', '', 'main_menu_staff', 'fa-money', 'payments', 'payments', 7, 3, 1, 1, '', 1, '0000-00-00 00:00:00'),
('menu_plugins', 'menu_system', 'main_menu_admin', 'fa-chain', 'plugins', 'plugins', 1, 1, 1, 1, '', 1, '1000-10-10 10:10:10'),
('menu_reports', '', 'main_menu_admin', 'fa-bar-chart-o', 'reports', 'reports', 13, 1, 1, 1, '', 1, '0000-00-00 00:00:00'),
('menu_reports_clientinvoices', 'menu_reports', 'main_menu_admin', 'fa-users', 'client_invoices', 'reports/view/invoicesbyclient', 4, 1, 1, 1, '', 1, '0000-00-00 00:00:00'),
('menu_reports_dashboard', 'menu_reports', 'main_menu_admin', 'fa-tachometer', 'report_dashboard', 'reports', 1, 1, 1, 1, '', 1, '0000-00-00 00:00:00'),
('menu_reports_invoices', 'menu_reports', 'main_menu_admin', 'fa-list', 'invoice_reports', 'reports/view/invoicesreport', 2, 1, 1, 1, '', 1, '0000-00-00 00:00:00'),
('menu_reports_payments', 'menu_reports', 'main_menu_admin', 'fa-credit-card', 'payments', 'reports/view/paymentsreport', 3, 1, 1, 1, '', 1, '0000-00-00 00:00:00'),
('menu_sales', '', 'main_menu_admin', 'fa-credit-card', 'sales', 'invoices', 5, 1, 1, 1, '', 1, '0000-00-00 00:00:00'),
('menu_settings', 'menu_system', 'main_menu_admin', 'fa-cogs', 'settings', 'settings', 1, 1, 1, 1, '', 1, '0000-00-00 00:00:00'),
('menu_system', '', 'main_menu_admin', 'fa-cogs', 'system', 'settings', 11, 1, 1, 1, '', 1, '0000-00-00 00:00:00'),
('menu_tax_rates', 'menu_system', 'main_menu_admin', 'fa-pencil-square-o', 'tax_rates', 'invoices/tax_rates', 9, 1, 1, 1, '', 1, '0000-00-00 00:00:00'),
('menu_tickets', '', 'main_menu_admin', 'fa-ticket', 'support', 'tickets', 10, 1, 1, 1, '', 1, '0000-00-00 00:00:00'),
('menu_tickets', '', 'main_menu_client', 'fa-ticket', 'tickets', 'tickets', 6, 2, 1, 1, '', 1, '0000-00-00 00:00:00'),
('menu_tickets', '', 'main_menu_staff', 'fa-ticket', 'tickets', 'tickets', 8, 3, 1, 1, '', 1, '0000-00-00 00:00:00'),
('menu_updates', 'menu_system', 'main_menu_admin', 'fa-cloud-download', 'updates', 'updates', 9, 1, 1, 1, '', 1, '1000-10-10 10:10:10'),
('menu_users', 'menu_system', 'main_menu_admin', 'fa-lock', 'users', 'users/account', 12, 1, 1, 1, '', 1, '0000-00-00 00:00:00'),
('settings_cron', '', 'settings_menu_admin', 'fa-rocket', 'cron_settings', 'crons', 13, 1, 1, 1, '', 1, '0000-00-00 00:00:00'),
('settings_currency', '', 'settings_menu_admin', 'fa-credit-card', 'currency_settings', 'currency', 5, 1, 1, 1, '', 1, '1000-01-01 01:01:01'),
('settings_custom_fields', '', 'settings_menu_admin', 'fa-star-o', 'custom_fields', 'fields', 11, 1, 1, 1, '', 1, '0000-00-00 00:00:00'),
('settings_departments', '', 'settings_menu_admin', 'fa-sitemap', 'departments', 'departments', 9, 1, 1, 1, '', 1, '0000-00-00 00:00:00'),
('settings_domain', '', 'settings_menu_admin', 'fa-folder', 'domain_settings', 'domain', 3, 1, 1, 1, '', 1, '0000-00-00 00:00:00'),
('settings_email', '', 'settings_menu_admin', 'fa-envelope-o', 'email_settings', 'email', 6, 1, 1, 1, '', 1, '0000-00-00 00:00:00'),
('settings_email_templates', '', 'settings_menu_admin', 'fa-pencil-square', 'email_templates', 'templates', 7, 1, 1, 1, '', 1, '0000-00-00 00:00:00'),
('settings_general', '', 'settings_menu_admin', 'fa-info-circle', 'general_settings', 'general', 1, 1, 1, 1, '', 1, '0000-00-00 00:00:00'),
('settings_invoice', 'menu_sales', 'settings_menu_admin', 'fa-money', 'invoice_settings', 'invoice', 6, 1, 1, 1, '', 1, '0000-00-00 00:00:00'),
('settings_menu', '', 'settings_menu_admin', 'fa-list-alt', 'menu_settings', 'menu', 10, 1, 1, 1, '', 1, '0000-00-00 00:00:00'),
('settings_search', '', 'settings_menu_admin', 'fa-search', 'search_settings', 'search', 3, 1, 1, 1, '', 1, '0000-00-00 00:00:00'),
('settings_system', '', 'settings_menu_admin', 'fa-desktop', 'system_settings', 'system', 2, 1, 1, 1, '', 1, '0000-00-00 00:00:00'),
('settings_theme', '', 'settings_menu_admin', 'fa-code', 'theme_settings', 'theme', 9, 1, 1, 1, '', 1, '0000-00-00 00:00:00'),
('settings_translations', '', 'settings_menu_admin', 'fa-globe', 'translations', 'translations', 12, 1, 1, 1, '', 1, '0000-00-00 00:00:00');

-- --------------------------------------------------------

--
-- Table structure for table `hd_images`
--

CREATE TABLE `hd_images` (
  `id` int(11) NOT NULL,
  `image` varchar(255) NOT NULL,
  `thumb` varchar(255) NOT NULL,
  `post_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `hd_images`
--

INSERT INTO `hd_images` (`id`, `image`, `thumb`, `post_id`) VALUES
(1, 'no-image.jpg', 'no-image.jpg', 1),
(2, 'no-image.jpg', 'no-image.jpg', 2);

-- --------------------------------------------------------

--
-- Table structure for table `hd_invoices`
--

CREATE TABLE `hd_invoices` (
  `inv_id` int(11) NOT NULL,
  `reference_no` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `client` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `due_date` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `notes` text COLLATE utf8_unicode_ci,
  `allow` int(11) NOT NULL,
  `tax` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax2` decimal(10,2) DEFAULT '0.00',
  `discount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `recurring` enum('Yes','No') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'No',
  `r_freq` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '31',
  `recur_start_date` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `recur_end_date` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `recur_frequency` varchar(12) COLLATE utf8_unicode_ci DEFAULT NULL,
  `recur_next_date` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `currency` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'USD',
  `status` enum('Unpaid','Paid','Cancelled') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Unpaid',
  `archived` int(11) DEFAULT '0',
  `date_sent` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `inv_deleted` enum('Yes','No') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'No',
  `date_saved` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `emailed` enum('Yes','No') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'No',
  `show_client` enum('Yes','No') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Yes',
  `viewed` enum('Yes','No') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'No',
  `alert_overdue` int(11) DEFAULT '0',
  `extra_fee` decimal(10,2) DEFAULT '0.00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `hd_items`
--

CREATE TABLE `hd_items` (
  `item_id` int(11) NOT NULL,
  `item_tax_rate` decimal(10,2) DEFAULT '0.00',
  `item_tax_total` decimal(10,2) NOT NULL DEFAULT '0.00',
  `quantity` decimal(10,2) DEFAULT '0.00',
  `total_cost` decimal(10,2) DEFAULT '0.00',
  `invoice_id` int(11) NOT NULL,
  `item_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT 'Item Name',
  `item_desc` longtext COLLATE utf8_unicode_ci,
  `unit_cost` decimal(10,2) DEFAULT '0.00',
  `item_order` int(11) DEFAULT '0',
  `date_saved` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `hd_items_saved`
--

CREATE TABLE `hd_items_saved` (
  `item_id` int(11) NOT NULL,
  `item_name` varchar(200) COLLATE utf8_unicode_ci DEFAULT 'Item Name',
  `item_desc` longtext COLLATE utf8_unicode_ci,
  `item_features` longtext COLLATE utf8_unicode_ci,
  `package_name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `unit_cost` decimal(10,2) DEFAULT '0.00',
  `item_tax_rate` decimal(10,2) DEFAULT '0.00',
  `item_tax_total` decimal(10,2) DEFAULT '0.00',
  `quantity` decimal(10,2) DEFAULT '0.00',
  `total_cost` decimal(10,2) DEFAULT '0.00',
  `setup_fee` decimal(10,2) NOT NULL DEFAULT '0.00',
  `payments` int(11) NOT NULL,
  `max_payments` int(11) NOT NULL,
  `max_years` int(11) NOT NULL DEFAULT '1',
  `deleted` enum('Yes','No') COLLATE utf8_unicode_ci DEFAULT 'No',
  `order_by` int(11) NOT NULL,
  `require_domain` enum('Yes','No') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'No',
  `reseller_package` enum('Yes','No') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'No',
  `allow_upgrade` enum('Yes','No') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'No',
  `server` int(11) DEFAULT '0',
  `default_registrar` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `create_account` enum('Yes','No') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'No',
  `display` enum('Yes','No') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Yes',
  `active` enum('Yes','No') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Yes',
  `package_config` text COLLATE utf8_unicode_ci NOT NULL,
  `addon` int(11) NOT NULL DEFAULT '0',
  `apply_to` text COLLATE utf8_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `hd_items_saved`
--

INSERT INTO `hd_items_saved` (`item_id`, `item_name`, `item_desc`, `item_features`, `package_name`, `unit_cost`, `item_tax_rate`, `item_tax_total`, `quantity`, `total_cost`, `setup_fee`, `payments`, `max_payments`, `max_years`, `deleted`, `order_by`, `require_domain`, `reseller_package`, `allow_upgrade`, `server`, `default_registrar`, `create_account`, `display`, `active`, `package_config`, `addon`, `apply_to`) VALUES
(8, 'Website', 'Design', '', '', '500.00', '0.00', '0.00', '1.00', '500.00', '0.00', 0, 0, 1, 'No', 0, 'No', 'No', 'No', 0, NULL, 'Yes', 'Yes', 'Yes', '', 0, NULL),
(11, 'com', NULL, NULL, NULL, NULL, '18.00', '0.00', '1.00', '0.00', '0.00', 0, 0, 5, 'No', 1, 'No', 'No', 'No', NULL, 'resellerclub', 'Yes', 'Yes', 'Yes', '', 0, NULL),
(13, 'net', NULL, NULL, '', NULL, '18.00', '0.00', '1.00', '0.00', '0.00', 0, 0, 1, 'No', 12, 'No', 'No', 'No', 0, '', 'Yes', 'Yes', 'Yes', '', 0, NULL),
(18, 'mobi', '', '', '', '0.00', '0.00', '0.00', '1.00', '0.00', '0.00', 0, 0, 1, 'No', 13, 'No', 'No', 'No', 0, NULL, 'Yes', 'Yes', 'Yes', '', 0, NULL),
(19, NULL, NULL, NULL, '', NULL, '0.00', '0.00', NULL, '0.00', '0.00', 0, 0, 1, 'No', 0, 'No', 'No', 'No', 0, NULL, 'Yes', 'Yes', 'Yes', '', 0, NULL),
(27, 'com.au', '', '', '', '0.00', '0.00', '0.00', '1.00', '0.00', '0.00', 0, 0, 1, 'No', 11, 'No', 'No', 'No', 0, NULL, 'Yes', 'Yes', 'Yes', '', 0, NULL),
(29, 'xyz', NULL, NULL, NULL, NULL, NULL, '0.00', '1.00', '0.00', '0.00', 0, 0, 1, 'No', 0, 'No', 'No', 'No', NULL, NULL, 'Yes', 'No', 'Yes', '', 0, NULL),
(39, 'Reseller Bronze', NULL, 'Plesk Control Panel, 1000MB Storage, Unlimited Domains, Unlimited Bandwidth, Unlimited Mailboxes, Unlimited Databases', NULL, NULL, '0.00', '0.00', '1.00', '0.00', '0.00', 0, 0, 1, 'No', 0, 'Yes', 'Yes', 'Yes', NULL, NULL, 'Yes', 'No', 'Yes', '', 0, NULL),
(40, 'Reseller Silver', NULL, 'Plesk Control Panel, 2000MB Storage, Unlimited Domains, Unlimited Bandwidth, Unlimited Mailboxes, Unlimited Databases', 'Reseller_Two', NULL, '0.00', '0.00', '1.00', '0.00', '0.00', 0, 0, 1, 'No', 0, 'Yes', 'Yes', 'Yes', NULL, NULL, 'Yes', 'Yes', 'Yes', '', 0, NULL),
(41, 'Reseller Gold', NULL, 'Plesk Control Panel, 3000MB Storage, Unlimited Domains, Unlimited Bandwidth, Unlimited Mailboxes, Unlimited Databases', 'Reseller_Three', NULL, '0.00', '0.00', '1.00', '0.00', '0.00', 0, 0, 1, 'No', 0, 'Yes', 'Yes', 'Yes', NULL, NULL, 'Yes', 'Yes', 'Yes', '', 0, NULL),
(42, 'Bronze', NULL, 'cPanel Control Panel,  500MB Storage, 1 Sub-Domains, 10 000MB Bandwidth, 1 Mailbox, 1 MySQL Database ', 'hostingb_One', NULL, '18.00', '0.00', '1.00', '0.00', '0.00', 0, 0, 1, 'No', 0, 'Yes', 'No', 'Yes', 1, NULL, 'Yes', 'Yes', 'Yes', 'a:4:{s:7:\"package\";s:12:\"hostingb_One\";s:7:\"item_id\";s:2:\"42\";s:9:\"server_id\";s:1:\"1\";s:6:\"submit\";s:4:\"Save\";}', 0, NULL),
(43, 'Silver', NULL, 'cPanel Control Panel, 1000MB Storage, 5 Sub-Domains, 15 000MB Bandwidth, 5 Mailboxes, 5 MySQL Databases', 'hostingb_Two', NULL, '0.00', '0.00', '1.00', '0.00', '0.00', 0, 0, 1, 'No', 0, 'Yes', 'No', 'Yes', 1, NULL, 'Yes', 'Yes', 'Yes', 'a:4:{s:7:\"package\";s:12:\"hostingb_Two\";s:7:\"item_id\";s:2:\"43\";s:9:\"server_id\";s:1:\"1\";s:6:\"submit\";s:4:\"Save\";}', 0, NULL),
(44, 'Gold', NULL, 'cPanel Control Panel, 2000MB Storage, 10 Sub-Domains, 20 000MB Bandwidth, 10 Mailboxes, 10 MySQL Databases', 'hostingb_Three', NULL, '18.00', '0.00', '1.00', '0.00', '0.00', 0, 0, 1, 'No', 0, 'Yes', 'Yes', 'Yes', 1, NULL, 'Yes', 'Yes', 'Yes', 'a:4:{s:7:\"package\";s:14:\"hostingb_Three\";s:7:\"item_id\";s:2:\"44\";s:9:\"server_id\";s:1:\"1\";s:6:\"submit\";s:4:\"Save\";}', 0, NULL),
(45, 'Bronze', NULL, '500MB Storage, 1 Sub-Domains, 10 000MB Bandwidth, 1 Mailbox, 1 Database', 'Plesk_One', NULL, '0.00', '0.00', '1.00', '0.00', '0.00', 0, 0, 1, 'No', 0, 'Yes', 'No', 'Yes', 5, NULL, 'Yes', 'Yes', 'Yes', 'a:4:{s:7:\"package\";s:9:\"Plesk_One\";s:7:\"item_id\";s:2:\"45\";s:9:\"server_id\";s:1:\"5\";s:6:\"submit\";s:4:\"Save\";}', 0, NULL),
(46, 'Silver', NULL, '1000MB Storage, 5 Sub-Domains, 15 000MB Bandwidth, 5 Mailboxes, 5 MySQL Databases', 'Plesk_Two', NULL, NULL, '0.00', '1.00', '0.00', '0.00', 0, 0, 1, 'No', 0, 'Yes', 'No', 'Yes', 5, NULL, 'Yes', 'Yes', 'Yes', 'a:4:{s:7:\"package\";s:9:\"Plesk_Two\";s:7:\"item_id\";s:2:\"46\";s:9:\"server_id\";s:1:\"5\";s:6:\"submit\";s:4:\"Save\";}', 0, NULL),
(47, 'Gold', NULL, '2000MB Storage, 10 Sub-Domains, 20 000MB Bandwidth, 10 Mailboxes, 10 MySQL Databases', 'Plesk_Three', NULL, NULL, '0.00', '1.00', '0.00', '0.00', 0, 0, 1, 'No', 0, 'Yes', 'No', 'Yes', 9, NULL, 'Yes', 'Yes', 'Yes', '', 0, NULL),
(48, 'Bronze', NULL, '500MB Storage, 1 Sub-Domains, 10 000MB Bandwidth, 1 Mailbox, 1 MySQL Database', 'direct_one', NULL, '0.00', '0.00', '1.00', '0.00', '0.00', 0, 0, 1, 'No', 0, 'Yes', 'No', 'Yes', 3, NULL, 'Yes', 'Yes', 'Yes', 'a:4:{s:7:\"package\";s:10:\"direct_one\";s:7:\"item_id\";s:2:\"48\";s:9:\"server_id\";s:1:\"3\";s:6:\"submit\";s:4:\"Save\";}', 0, NULL),
(49, 'Silver', NULL, '1000MB Storage, 5 Sub-Domains, 15 000MB Bandwidth, 5 Mailboxes, 5 MySQL Databases', 'direct_two', NULL, NULL, '0.00', '1.00', '0.00', '0.00', 0, 0, 1, 'No', 0, 'Yes', 'No', 'Yes', 3, NULL, 'Yes', 'Yes', 'Yes', 'a:4:{s:7:\"package\";s:10:\"direct_two\";s:7:\"item_id\";s:2:\"49\";s:9:\"server_id\";s:1:\"3\";s:6:\"submit\";s:4:\"Save\";}', 0, NULL),
(50, 'Gold', NULL, '2000MB Storage, 10 Sub-Domains, 20 000MB Bandwidth, 10 Mailboxes, 10 MySQL Databases', 'direct_three', NULL, NULL, '0.00', '1.00', '0.00', '0.00', 0, 0, 1, 'No', 0, 'Yes', 'Yes', 'Yes', 8, NULL, 'Yes', 'Yes', 'Yes', '', 0, NULL),
(55, 'in', NULL, NULL, NULL, NULL, '0.00', '0.00', '1.00', '0.00', '0.00', 0, 0, 5, 'No', 0, 'No', 'No', 'No', NULL, 'resellerclub', 'Yes', 'Yes', 'Yes', '', 0, NULL),
(56, 'info', NULL, NULL, NULL, NULL, NULL, '0.00', '1.00', '0.00', '0.00', 0, 0, 1, 'No', 0, 'No', 'No', 'No', NULL, NULL, 'Yes', 'Yes', 'Yes', '', 0, NULL),
(57, 'co.uk', NULL, NULL, NULL, NULL, '0.00', '0.00', '1.00', '0.00', '0.00', 0, 0, 1, 'No', 0, 'No', 'No', 'No', NULL, '', 'Yes', 'Yes', 'Yes', '', 0, NULL),
(58, 'bz', NULL, NULL, NULL, NULL, NULL, '0.00', '1.00', '0.00', '0.00', 0, 0, 1, 'No', 0, 'No', 'No', 'No', NULL, 'resellerclub', 'Yes', 'Yes', 'Yes', '', 0, NULL),
(59, 'Test 1', NULL, '', '', NULL, '0.00', '0.00', '1.00', '0.00', '0.00', 0, 0, 1, 'No', 0, 'No', 'No', 'No', NULL, NULL, 'Yes', 'Yes', 'Yes', '', 0, NULL),
(60, 'Test 2', NULL, '', '', NULL, '0.00', '0.00', '1.00', '0.00', '0.00', 0, 0, 1, 'No', 0, 'No', 'No', 'No', NULL, NULL, 'Yes', 'Yes', 'Yes', '', 0, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `hd_item_pricing`
--

CREATE TABLE `hd_item_pricing` (
  `item_pricing_id` int(11) NOT NULL,
  `item_id` int(11) NOT NULL,
  `category` int(11) NOT NULL DEFAULT '0',
  `monthly` decimal(10,2) DEFAULT '0.00',
  `quarterly` decimal(10,2) DEFAULT '0.00',
  `semi_annually` decimal(10,2) DEFAULT '0.00',
  `annually` decimal(10,2) DEFAULT '0.00',
  `biennially` decimal(10,2) NOT NULL DEFAULT '0.00',
  `triennially` decimal(10,2) NOT NULL DEFAULT '0.00',
  `registration` decimal(10,2) DEFAULT '0.00',
  `transfer` decimal(10,2) DEFAULT '0.00',
  `renewal` decimal(10,2) DEFAULT '0.00',
  `monthly_payments` int(11) NOT NULL,
  `quarterly_payments` int(11) NOT NULL,
  `semi_annually_payments` int(11) NOT NULL,
  `annually_payments` int(11) NOT NULL,
  `biennially_payments` int(11) NOT NULL,
  `triennially_payments` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `hd_item_pricing`
--

INSERT INTO `hd_item_pricing` (`item_pricing_id`, `item_id`, `category`, `monthly`, `quarterly`, `semi_annually`, `annually`, `biennially`, `triennially`, `registration`, `transfer`, `renewal`, `monthly_payments`, `quarterly_payments`, `semi_annually_payments`, `annually_payments`, `biennially_payments`, `triennially_payments`) VALUES
(3, 7, 14, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '10.00', '0.00', '10.00', 0, 0, 0, 0, 0, 0),
(6, 11, 14, NULL, NULL, NULL, NULL, '0.00', '0.00', '18.00', '19.00', '22.00', 0, 0, 0, 0, 0, 0),
(8, 13, 14, NULL, NULL, NULL, NULL, '0.00', '0.00', '19.00', '19.00', '19.00', 0, 0, 0, 0, 0, 0),
(13, 18, 14, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '24.00', '24.00', '24.00', 0, 0, 0, 0, 0, 0),
(21, 27, 14, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '12.00', '12.00', '12.00', 0, 0, 0, 0, 0, 0),
(23, 29, 14, NULL, NULL, NULL, NULL, '0.00', '0.00', '10.00', '10.00', '10.00', 0, 0, 0, 0, 0, 0),
(33, 39, 18, '0.00', '15.00', '30.00', '60.00', '0.00', '0.00', NULL, NULL, NULL, 0, 0, 0, 0, 0, 0),
(34, 40, 18, '10.00', '30.00', '30.00', '120.00', '0.00', '0.00', NULL, NULL, NULL, 0, 0, 0, 0, 0, 0),
(35, 41, 18, '15.00', '45.00', '90.00', '180.00', '0.00', '0.00', NULL, NULL, NULL, 0, 0, 0, 0, 0, 0),
(36, 42, 12, '6.00', '0.00', '0.00', '0.00', '0.00', '0.00', NULL, NULL, NULL, 0, 0, 0, 0, 0, 0),
(37, 43, 12, '10.00', '15.00', '45.00', '90.00', '0.00', '0.00', NULL, NULL, NULL, 0, 0, 0, 0, 0, 0),
(38, 44, 12, '15.00', '45.00', '90.00', '180.00', '0.00', '0.00', NULL, NULL, NULL, 0, 0, 0, 0, 0, 0),
(39, 45, 19, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', NULL, NULL, NULL, 0, 0, 0, 0, 0, 0),
(40, 46, 19, '0.00', '15.00', '45.00', '90.00', '0.00', '0.00', NULL, NULL, NULL, 0, 0, 0, 0, 0, 0),
(41, 47, 19, '15.00', '45.00', '90.00', '180.00', '0.00', '0.00', NULL, NULL, NULL, 0, 0, 0, 0, 0, 0),
(42, 48, 20, '5.00', '0.00', '0.00', '0.00', '0.00', '0.00', NULL, NULL, NULL, 0, 0, 0, 0, 0, 0),
(43, 49, 20, '0.00', '15.00', '45.00', '90.00', '0.00', '0.00', NULL, NULL, NULL, 0, 0, 0, 0, 0, 0),
(44, 50, 20, '15.00', '45.00', '90.00', '180.00', '0.00', '0.00', NULL, NULL, NULL, 0, 0, 0, 0, 0, 0),
(48, 54, 14, NULL, NULL, NULL, NULL, '0.00', '0.00', '6.00', '6.00', '6.00', 0, 0, 0, 0, 0, 0),
(49, 55, 14, NULL, NULL, NULL, NULL, '0.00', '0.00', '8.00', '8.00', '8.00', 0, 0, 0, 0, 0, 0),
(50, 56, 14, NULL, NULL, NULL, NULL, '0.00', '0.00', '8.00', '8.00', '8.00', 0, 0, 0, 0, 0, 0),
(51, 57, 14, NULL, NULL, NULL, NULL, '0.00', '0.00', '10.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0),
(52, 58, 14, NULL, NULL, NULL, NULL, '0.00', '0.00', '15.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0),
(53, 59, 22, '10.00', '0.00', '0.00', '0.00', '0.00', '0.00', NULL, NULL, NULL, 0, 0, 0, 0, 0, 0),
(54, 60, 22, '15.00', '0.00', '0.00', '0.00', '0.00', '0.00', NULL, NULL, NULL, 0, 0, 0, 0, 0, 0),
(64, 70, 12, '3.00', '0.00', '0.00', '0.00', '0.00', '0.00', NULL, NULL, NULL, 0, 0, 0, 0, 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `hd_languages`
--

CREATE TABLE `hd_languages` (
  `code` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `icon` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `active` int(2) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `hd_languages`
--

INSERT INTO `hd_languages` (`code`, `name`, `icon`, `active`) VALUES
('en', 'english', 'us', 1);

-- --------------------------------------------------------

--
-- Table structure for table `hd_links`
--

CREATE TABLE `hd_links` (
  `link_id` int(11) NOT NULL,
  `project_id` int(11) DEFAULT NULL,
  `client` int(11) DEFAULT NULL,
  `icon` varchar(255) DEFAULT NULL,
  `link_title` varchar(255) DEFAULT NULL,
  `link_url` varchar(255) DEFAULT NULL,
  `description` text,
  `username` varchar(255) DEFAULT NULL,
  `password` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `hd_locales`
--

CREATE TABLE `hd_locales` (
  `locale` varchar(10) NOT NULL,
  `code` varchar(10) DEFAULT NULL,
  `language` varchar(100) DEFAULT NULL,
  `name` varchar(250) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `hd_locales`
--

INSERT INTO `hd_locales` (`locale`, `code`, `language`, `name`) VALUES
('aa_DJ', 'aa', 'afar', 'Afar (Djibouti)'),
('aa_ER', 'aa', 'afar', 'Afar (Eritrea)'),
('aa_ET', 'aa', 'afar', 'Afar (Ethiopia)'),
('af_ZA', 'af', 'afrikaans', 'Afrikaans (South Africa)'),
('am_ET', 'am', 'amharic', 'Amharic (Ethiopia)'),
('an_ES', 'an', 'aragonese', 'Aragonese (Spain)'),
('ar_AE', 'ar', 'arabic', 'Arabic (United Arab Emirates)'),
('ar_BH', 'ar', 'arabic', 'Arabic (Bahrain)'),
('ar_DZ', 'ar', 'arabic', 'Arabic (Algeria)'),
('ar_EG', 'ar', 'arabic', 'Arabic (Egypt)'),
('ar_IN', 'ar', 'arabic', 'Arabic (India)'),
('ar_IQ', 'ar', 'arabic', 'Arabic (Iraq)'),
('ar_JO', 'ar', 'arabic', 'Arabic (Jordan)'),
('ar_KW', 'ar', 'arabic', 'Arabic (Kuwait)'),
('ar_LB', 'ar', 'arabic', 'Arabic (Lebanon)'),
('ar_LY', 'ar', 'arabic', 'Arabic (Libya)'),
('ar_MA', 'ar', 'arabic', 'Arabic (Morocco)'),
('ar_OM', 'ar', 'arabic', 'Arabic (Oman)'),
('ar_QA', 'ar', 'arabic', 'Arabic (Qatar)'),
('ar_SA', 'ar', 'arabic', 'Arabic (Saudi Arabia)'),
('ar_SD', 'ar', 'arabic', 'Arabic (Sudan)'),
('ar_SY', 'ar', 'arabic', 'Arabic (Syria)'),
('ar_TN', 'ar', 'arabic', 'Arabic (Tunisia)'),
('ar_YE', 'ar', 'arabic', 'Arabic (Yemen)'),
('ast_ES', 'ast', 'asturian', 'Asturian (Spain)'),
('as_IN', 'as', 'assamese', 'Assamese (India)'),
('az_AZ', 'az', 'azerbaijani', 'Azerbaijani (Azerbaijan)'),
('az_TR', 'az', 'azerbaijani', 'Azerbaijani (Turkey)'),
('bem_ZM', 'bem', 'bemba', 'Bemba (Zambia)'),
('ber_DZ', 'ber', 'berber', 'Berber (Algeria)'),
('ber_MA', 'ber', 'berber', 'Berber (Morocco)'),
('be_BY', 'be', 'belarusian', 'Belarusian (Belarus)'),
('bg_BG', 'bg', 'bulgarian', 'Bulgarian (Bulgaria)'),
('bn_BD', 'bn', 'bengali', 'Bengali (Bangladesh)'),
('bn_IN', 'bn', 'bengali', 'Bengali (India)'),
('bo_CN', 'bo', 'tibetan', 'Tibetan (China)'),
('bo_IN', 'bo', 'tibetan', 'Tibetan (India)'),
('br_FR', 'br', 'breton', 'Breton (France)'),
('bs_BA', 'bs', 'bosnian', 'Bosnian (Bosnia and Herzegovina)'),
('byn_ER', 'byn', 'blin', 'Blin (Eritrea)'),
('ca_AD', 'ca', 'catalan', 'Catalan (Andorra)'),
('ca_ES', 'ca', 'catalan', 'Catalan (Spain)'),
('ca_FR', 'ca', 'catalan', 'Catalan (France)'),
('ca_IT', 'ca', 'catalan', 'Catalan (Italy)'),
('crh_UA', 'crh', 'crimean turkish', 'Crimean Turkish (Ukraine)'),
('csb_PL', 'csb', 'kashubian', 'Kashubian (Poland)'),
('cs_CZ', 'cs', 'czech', 'Czech (Czech Republic)'),
('cv_RU', 'cv', 'chuvash', 'Chuvash (Russia)'),
('cy_GB', 'cy', 'welsh', 'Welsh (United Kingdom)'),
('da_DK', 'da', 'danish', 'Danish (Denmark)'),
('de_AT', 'de', 'german', 'German (Austria)'),
('de_BE', 'de', 'german', 'German (Belgium)'),
('de_CH', 'de', 'german', 'German (Switzerland)'),
('de_DE', 'de', 'german', 'German (Germany)'),
('de_LI', 'de', 'german', 'German (Liechtenstein)'),
('de_LU', 'de', 'german', 'German (Luxembourg)'),
('dv_MV', 'dv', 'divehi', 'Divehi (Maldives)'),
('dz_BT', 'dz', 'dzongkha', 'Dzongkha (Bhutan)'),
('ee_GH', 'ee', 'ewe', 'Ewe (Ghana)'),
('el_CY', 'el', 'greek', 'Greek (Cyprus)'),
('el_GR', 'el', 'greek', 'Greek (Greece)'),
('en_AG', 'en', 'english', 'English (Antigua and Barbuda)'),
('en_AS', 'en', 'english', 'English (American Samoa)'),
('en_AU', 'en', 'english', 'English (Australia)'),
('en_BW', 'en', 'english', 'English (Botswana)'),
('en_CA', 'en', 'english', 'English (Canada)'),
('en_DK', 'en', 'english', 'English (Denmark)'),
('en_GB', 'en', 'english', 'English (United Kingdom)'),
('en_GU', 'en', 'english', 'English (Guam)'),
('en_HK', 'en', 'english', 'English (Hong Kong SAR China)'),
('en_IE', 'en', 'english', 'English (Ireland)'),
('en_IN', 'en', 'english', 'English (India)'),
('en_JM', 'en', 'english', 'English (Jamaica)'),
('en_MH', 'en', 'english', 'English (Marshall Islands)'),
('en_MP', 'en', 'english', 'English (Northern Mariana Islands)'),
('en_MU', 'en', 'english', 'English (Mauritius)'),
('en_NG', 'en', 'english', 'English (Nigeria)'),
('en_NZ', 'en', 'english', 'English (New Zealand)'),
('en_PH', 'en', 'english', 'English (Philippines)'),
('en_SG', 'en', 'english', 'English (Singapore)'),
('en_TT', 'en', 'english', 'English (Trinidad and Tobago)'),
('en_US', 'en', 'english', 'English (United States)'),
('en_VI', 'en', 'english', 'English (Virgin Islands)'),
('en_ZA', 'en', 'english', 'English (South Africa)'),
('en_ZM', 'en', 'english', 'English (Zambia)'),
('en_ZW', 'en', 'english', 'English (Zimbabwe)'),
('eo', 'eo', 'esperanto', 'Esperanto'),
('es_AR', 'es', 'spanish', 'Spanish (Argentina)'),
('es_BO', 'es', 'spanish', 'Spanish (Bolivia)'),
('es_CL', 'es', 'spanish', 'Spanish (Chile)'),
('es_CO', 'es', 'spanish', 'Spanish (Colombia)'),
('es_CR', 'es', 'spanish', 'Spanish (Costa Rica)'),
('es_DO', 'es', 'spanish', 'Spanish (Dominican Republic)'),
('es_EC', 'es', 'spanish', 'Spanish (Ecuador)'),
('es_ES', 'es', 'spanish', 'Spanish (Spain)'),
('es_GT', 'es', 'spanish', 'Spanish (Guatemala)'),
('es_HN', 'es', 'spanish', 'Spanish (Honduras)'),
('es_MX', 'es', 'spanish', 'Spanish (Mexico)'),
('es_NI', 'es', 'spanish', 'Spanish (Nicaragua)'),
('es_PA', 'es', 'spanish', 'Spanish (Panama)'),
('es_PE', 'es', 'spanish', 'Spanish (Peru)'),
('es_PR', 'es', 'spanish', 'Spanish (Puerto Rico)'),
('es_PY', 'es', 'spanish', 'Spanish (Paraguay)'),
('es_SV', 'es', 'spanish', 'Spanish (El Salvador)'),
('es_US', 'es', 'spanish', 'Spanish (United States)'),
('es_UY', 'es', 'spanish', 'Spanish (Uruguay)'),
('es_VE', 'es', 'spanish', 'Spanish (Venezuela)'),
('et_EE', 'et', 'estonian', 'Estonian (Estonia)'),
('eu_ES', 'eu', 'basque', 'Basque (Spain)'),
('eu_FR', 'eu', 'basque', 'Basque (France)'),
('fa_AF', 'fa', 'persian', 'Persian (Afghanistan)'),
('fa_IR', 'fa', 'persian', 'Persian (Iran)'),
('ff_SN', 'ff', 'fulah', 'Fulah (Senegal)'),
('fil_PH', 'fil', 'filipino', 'Filipino (Philippines)'),
('fi_FI', 'fi', 'finnish', 'Finnish (Finland)'),
('fo_FO', 'fo', 'faroese', 'Faroese (Faroe Islands)'),
('fr_BE', 'fr', 'french', 'French (Belgium)'),
('fr_BF', 'fr', 'french', 'French (Burkina Faso)'),
('fr_BI', 'fr', 'french', 'French (Burundi)'),
('fr_BJ', 'fr', 'french', 'French (Benin)'),
('fr_CA', 'fr', 'french', 'French (Canada)'),
('fr_CF', 'fr', 'french', 'French (Central African Republic)'),
('fr_CG', 'fr', 'french', 'French (Congo)'),
('fr_CH', 'fr', 'french', 'French (Switzerland)'),
('fr_CM', 'fr', 'french', 'French (Cameroon)'),
('fr_FR', 'fr', 'french', 'French (France)'),
('fr_GA', 'fr', 'french', 'French (Gabon)'),
('fr_GN', 'fr', 'french', 'French (Guinea)'),
('fr_GP', 'fr', 'french', 'French (Guadeloupe)'),
('fr_GQ', 'fr', 'french', 'French (Equatorial Guinea)'),
('fr_KM', 'fr', 'french', 'French (Comoros)'),
('fr_LU', 'fr', 'french', 'French (Luxembourg)'),
('fr_MC', 'fr', 'french', 'French (Monaco)'),
('fr_MG', 'fr', 'french', 'French (Madagascar)'),
('fr_ML', 'fr', 'french', 'French (Mali)'),
('fr_MQ', 'fr', 'french', 'French (Martinique)'),
('fr_NE', 'fr', 'french', 'French (Niger)'),
('fr_SN', 'fr', 'french', 'French (Senegal)'),
('fr_TD', 'fr', 'french', 'French (Chad)'),
('fr_TG', 'fr', 'french', 'French (Togo)'),
('fur_IT', 'fur', 'friulian', 'Friulian (Italy)'),
('fy_DE', 'fy', 'western frisian', 'Western Frisian (Germany)'),
('fy_NL', 'fy', 'western frisian', 'Western Frisian (Netherlands)'),
('ga_IE', 'ga', 'irish', 'Irish (Ireland)'),
('gd_GB', 'gd', 'scottish gaelic', 'Scottish Gaelic (United Kingdom)'),
('gez_ER', 'gez', 'geez', 'Geez (Eritrea)'),
('gez_ET', 'gez', 'geez', 'Geez (Ethiopia)'),
('gl_ES', 'gl', 'galician', 'Galician (Spain)'),
('gu_IN', 'gu', 'gujarati', 'Gujarati (India)'),
('gv_GB', 'gv', 'manx', 'Manx (United Kingdom)'),
('ha_NG', 'ha', 'hausa', 'Hausa (Nigeria)'),
('he_IL', 'he', 'hebrew', 'Hebrew (Israel)'),
('hi_IN', 'hi', 'hindi', 'Hindi (India)'),
('hr_HR', 'hr', 'croatian', 'Croatian (Croatia)'),
('hsb_DE', 'hsb', 'upper sorbian', 'Upper Sorbian (Germany)'),
('ht_HT', 'ht', 'haitian', 'Haitian (Haiti)'),
('hu_HU', 'hu', 'hungarian', 'Hungarian (Hungary)'),
('hy_AM', 'hy', 'armenian', 'Armenian (Armenia)'),
('ia', 'ia', 'interlingua', 'Interlingua'),
('id_ID', 'id', 'indonesian', 'Indonesian (Indonesia)'),
('ig_NG', 'ig', 'igbo', 'Igbo (Nigeria)'),
('ik_CA', 'ik', 'inupiaq', 'Inupiaq (Canada)'),
('is_IS', 'is', 'icelandic', 'Icelandic (Iceland)'),
('it_CH', 'it', 'italian', 'Italian (Switzerland)'),
('it_IT', 'it', 'italian', 'Italian (Italy)'),
('iu_CA', 'iu', 'inuktitut', 'Inuktitut (Canada)'),
('ja_JP', 'ja', 'japanese', 'Japanese (Japan)'),
('ka_GE', 'ka', 'georgian', 'Georgian (Georgia)'),
('kk_KZ', 'kk', 'kazakh', 'Kazakh (Kazakhstan)'),
('kl_GL', 'kl', 'kalaallisut', 'Kalaallisut (Greenland)'),
('km_KH', 'km', 'khmer', 'Khmer (Cambodia)'),
('kn_IN', 'kn', 'kannada', 'Kannada (India)'),
('kok_IN', 'kok', 'konkani', 'Konkani (India)'),
('ko_KR', 'ko', 'korean', 'Korean (South Korea)'),
('ks_IN', 'ks', 'kashmiri', 'Kashmiri (India)'),
('ku_TR', 'ku', 'kurdish', 'Kurdish (Turkey)'),
('kw_GB', 'kw', 'cornish', 'Cornish (United Kingdom)'),
('ky_KG', 'ky', 'kirghiz', 'Kirghiz (Kyrgyzstan)'),
('lg_UG', 'lg', 'ganda', 'Ganda (Uganda)'),
('li_BE', 'li', 'limburgish', 'Limburgish (Belgium)'),
('li_NL', 'li', 'limburgish', 'Limburgish (Netherlands)'),
('lo_LA', 'lo', 'lao', 'Lao (Laos)'),
('lt_LT', 'lt', 'lithuanian', 'Lithuanian (Lithuania)'),
('lv_LV', 'lv', 'latvian', 'Latvian (Latvia)'),
('mai_IN', 'mai', 'maithili', 'Maithili (India)'),
('mg_MG', 'mg', 'malagasy', 'Malagasy (Madagascar)'),
('mi_NZ', 'mi', 'maori', 'Maori (New Zealand)'),
('mk_MK', 'mk', 'macedonian', 'Macedonian (Macedonia)'),
('ml_IN', 'ml', 'malayalam', 'Malayalam (India)'),
('mn_MN', 'mn', 'mongolian', 'Mongolian (Mongolia)'),
('mr_IN', 'mr', 'marathi', 'Marathi (India)'),
('ms_BN', 'ms', 'malay', 'Malay (Brunei)'),
('ms_MY', 'ms', 'malay', 'Malay (Malaysia)'),
('mt_MT', 'mt', 'maltese', 'Maltese (Malta)'),
('my_MM', 'my', 'burmese', 'Burmese (Myanmar)'),
('naq_NA', 'naq', 'namibia', 'Namibia'),
('nb_NO', 'nb', 'norwegian bokmål', 'Norwegian Bokmål (Norway)'),
('nds_DE', 'nds', 'low german', 'Low German (Germany)'),
('nds_NL', 'nds', 'low german', 'Low German (Netherlands)'),
('ne_NP', 'ne', 'nepali', 'Nepali (Nepal)'),
('nl_AW', 'nl', 'dutch', 'Dutch (Aruba)'),
('nl_BE', 'nl', 'dutch', 'Dutch (Belgium)'),
('nl_NL', 'nl', 'dutch', 'Dutch (Netherlands)'),
('nn_NO', 'nn', 'norwegian nynorsk', 'Norwegian Nynorsk (Norway)'),
('no_NO', 'no', 'norwegian', 'Norwegian (Norway)'),
('nr_ZA', 'nr', 'south ndebele', 'South Ndebele (South Africa)'),
('nso_ZA', 'nso', 'northern sotho', 'Northern Sotho (South Africa)'),
('oc_FR', 'oc', 'occitan', 'Occitan (France)'),
('om_ET', 'om', 'oromo', 'Oromo (Ethiopia)'),
('om_KE', 'om', 'oromo', 'Oromo (Kenya)'),
('or_IN', 'or', 'oriya', 'Oriya (India)'),
('os_RU', 'os', 'ossetic', 'Ossetic (Russia)'),
('pap_AN', 'pap', 'papiamento', 'Papiamento (Netherlands Antilles)'),
('pa_IN', 'pa', 'punjabi', 'Punjabi (India)'),
('pa_PK', 'pa', 'punjabi', 'Punjabi (Pakistan)'),
('pl_PL', 'pl', 'polish', 'Polish (Poland)'),
('ps_AF', 'ps', 'pashto', 'Pashto (Afghanistan)'),
('pt_BR', 'pt', 'portuguese', 'Portuguese (Brazil)'),
('pt_GW', 'pt', 'portuguese', 'Portuguese (Guinea-Bissau)'),
('pt_PT', 'pt', 'portuguese', 'Portuguese (Portugal)'),
('ro_MD', 'ro', 'romanian', 'Romanian (Moldova)'),
('ro_RO', 'ro', 'romanian', 'Romanian (Romania)'),
('ru_RU', 'ru', 'russian', 'Russian (Russia)'),
('ru_UA', 'ru', 'russian', 'Russian (Ukraine)'),
('rw_RW', 'rw', 'kinyarwanda', 'Kinyarwanda (Rwanda)'),
('sa_IN', 'sa', 'sanskrit', 'Sanskrit (India)'),
('sc_IT', 'sc', 'sardinian', 'Sardinian (Italy)'),
('sd_IN', 'sd', 'sindhi', 'Sindhi (India)'),
('seh_MZ', 'seh', 'sena', 'Sena (Mozambique)'),
('se_NO', 'se', 'northern sami', 'Northern Sami (Norway)'),
('sid_ET', 'sid', 'sidamo', 'Sidamo (Ethiopia)'),
('si_LK', 'si', 'sinhala', 'Sinhala (Sri Lanka)'),
('sk_SK', 'sk', 'slovak', 'Slovak (Slovakia)'),
('sl_SI', 'sl', 'slovenian', 'Slovenian (Slovenia)'),
('sn_ZW', 'sn', 'shona', 'Shona (Zimbabwe)'),
('so_DJ', 'so', 'somali', 'Somali (Djibouti)'),
('so_ET', 'so', 'somali', 'Somali (Ethiopia)'),
('so_KE', 'so', 'somali', 'Somali (Kenya)'),
('so_SO', 'so', 'somali', 'Somali (Somalia)'),
('sq_AL', 'sq', 'albanian', 'Albanian (Albania)'),
('sq_MK', 'sq', 'albanian', 'Albanian (Macedonia)'),
('sr_BA', 'sr', 'serbian', 'Serbian (Bosnia and Herzegovina)'),
('sr_ME', 'sr', 'serbian', 'Serbian (Montenegro)'),
('sr_RS', 'sr', 'serbian', 'Serbian (Serbia)'),
('ss_ZA', 'ss', 'swati', 'Swati (South Africa)'),
('st_ZA', 'st', 'southern sotho', 'Southern Sotho (South Africa)'),
('sv_FI', 'sv', 'swedish', 'Swedish (Finland)'),
('sv_SE', 'sv', 'swedish', 'Swedish (Sweden)'),
('sw_KE', 'sw', 'swahili', 'Swahili (Kenya)'),
('sw_TZ', 'sw', 'swahili', 'Swahili (Tanzania)'),
('ta_IN', 'ta', 'tamil', 'Tamil (India)'),
('teo_UG', 'teo', 'teso', 'Teso (Uganda)'),
('te_IN', 'te', 'telugu', 'Telugu (India)'),
('tg_TJ', 'tg', 'tajik', 'Tajik (Tajikistan)'),
('th_TH', 'th', 'thai', 'Thai (Thailand)'),
('tig_ER', 'tig', 'tigre', 'Tigre (Eritrea)'),
('ti_ER', 'ti', 'tigrinya', 'Tigrinya (Eritrea)'),
('ti_ET', 'ti', 'tigrinya', 'Tigrinya (Ethiopia)'),
('tk_TM', 'tk', 'turkmen', 'Turkmen (Turkmenistan)'),
('tl_PH', 'tl', 'tagalog', 'Tagalog (Philippines)'),
('tn_ZA', 'tn', 'tswana', 'Tswana (South Africa)'),
('to_TO', 'to', 'tongan', 'Tongan (Tonga)'),
('tr_CY', 'tr', 'turkish', 'Turkish (Cyprus)'),
('tr_TR', 'tr', 'turkish', 'Turkish (Turkey)'),
('ts_ZA', 'ts', 'tsonga', 'Tsonga (South Africa)'),
('tt_RU', 'tt', 'tatar', 'Tatar (Russia)'),
('ug_CN', 'ug', 'uighur', 'Uighur (China)'),
('uk_UA', 'uk', 'ukrainian', 'Ukrainian (Ukraine)'),
('ur_PK', 'ur', 'urdu', 'Urdu (Pakistan)'),
('uz_UZ', 'uz', 'uzbek', 'Uzbek (Uzbekistan)'),
('ve_ZA', 've', 'venda', 'Venda (South Africa)'),
('vi_VN', 'vi', 'vietnamese', 'Vietnamese (Vietnam)'),
('wa_BE', 'wa', 'walloon', 'Walloon (Belgium)'),
('wo_SN', 'wo', 'wolof', 'Wolof (Senegal)'),
('xh_ZA', 'xh', 'xhosa', 'Xhosa (South Africa)'),
('yi_US', 'yi', 'yiddish', 'Yiddish (United States)'),
('yo_NG', 'yo', 'yoruba', 'Yoruba (Nigeria)'),
('zh_CN', 'zh', 'chinese', 'Chinese (China)'),
('zh_HK', 'zh', 'chinese', 'Chinese (Hong Kong SAR China)'),
('zh_SG', 'zh', 'chinese', 'Chinese (Singapore)'),
('zh_TW', 'zh', 'chinese', 'Chinese (Taiwan)'),
('zu_ZA', 'zu', 'zulu', 'Zulu (South Africa)');

-- --------------------------------------------------------

--
-- Table structure for table `hd_login_attempts`
--

CREATE TABLE `hd_login_attempts` (
  `id` int(11) NOT NULL,
  `ip_address` varchar(40) NOT NULL,
  `login` varchar(50) NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `hd_menu`
--

CREATE TABLE `hd_menu` (
  `id` tinyint(3) UNSIGNED NOT NULL,
  `parent_id` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL DEFAULT '',
  `url` varchar(255) NOT NULL DEFAULT '',
  `position` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `group_id` tinyint(3) UNSIGNED NOT NULL DEFAULT '1',
  `page` int(11) NOT NULL,
  `active` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `hd_menu`
--

INSERT INTO `hd_menu` (`id`, `parent_id`, `title`, `url`, `position`, `group_id`, `page`, `active`) VALUES
(37, 0, 'Home', '/', 1, 1, 0, 1),
(54, 60, 'About', 'about', 2, 1, 12, 1),
(53, 0, 'ff', 'ff', 0, 0, 11, 1),
(82, 0, 'Can I host WordPress on shared hosting?', '_can_i_host_wordpress_on_shared_hosting', 0, 0, 25, 1),
(61, 60, 'Hosting Packages', 'cart/hosting_packages', 1, 1, 0, 1),
(84, 0, 'Domain Registration', 'domain_registration', 3, 1, 0, 1),
(83, 0, 'F.A.Q', 'faq', 4, 1, 0, 1),
(69, 0, 'yes', 'yes', 0, 0, 16, 1),
(93, 0, 'Web Hosting', 'web_hosting', 2, 1, 33, 1),
(86, 0, 'Is .com domain still the best?', 'is_.com_domain_still_the_best', 0, 0, 27, 1),
(87, 0, 'Do I need a domain name?', 'do_i_need_a_domain_name', 0, 0, 28, 1),
(88, 0, 'What is a domain registrar', 'what_is_a_domain_registrar', 0, 0, 29, 1),
(89, 0, 'Can I host my website on shared hosting?', 'can_i_host_my_website_on_shared_hosting', 0, 0, 30, 1),
(90, 0, 'Should I use a domain name generator?', 'should_i_use_a_domain_name_generator', 0, 0, 31, 1),
(91, 0, 'Knowledgebase', 'knowledge', 5, 1, 0, 1);

-- --------------------------------------------------------

--
-- Table structure for table `hd_menu_group`
--

CREATE TABLE `hd_menu_group` (
  `id` smallint(5) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `hd_menu_group`
--

INSERT INTO `hd_menu_group` (`id`, `title`) VALUES
(1, 'Main Menu');

-- --------------------------------------------------------

--
-- Table structure for table `hd_orders`
--

CREATE TABLE `hd_orders` (
  `id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL,
  `invoice_id` int(11) NOT NULL,
  `date` datetime DEFAULT NULL,
  `processed` date NOT NULL,
  `renewal_date` date NOT NULL,
  `domain` varchar(100) NOT NULL,
  `nameservers` varchar(100) DEFAULT NULL,
  `username` varchar(100) NOT NULL,
  `password` varchar(100) NOT NULL,
  `item` int(11) NOT NULL,
  `item_parent` int(11) NOT NULL,
  `status_id` int(11) NOT NULL DEFAULT '5',
  `type` varchar(100) NOT NULL,
  `order_id` bigint(11) NOT NULL,
  `o_id` int(11) NOT NULL,
  `process_id` bigint(11) NOT NULL,
  `counter` int(11) NOT NULL,
  `fee` decimal(10,2) NOT NULL,
  `renewal` varchar(100) DEFAULT NULL,
  `server` int(11) DEFAULT NULL,
  `registrar` varchar(100) DEFAULT NULL,
  `years` int(11) NOT NULL DEFAULT '1',
  `promo` int(11) NOT NULL DEFAULT '0',
  `parent` int(11) NOT NULL DEFAULT '0',
  `authcode` varchar(100) DEFAULT NULL,
  `additional_fields` int(11) DEFAULT NULL,
  `notes` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `hd_outgoing_emails`
--

CREATE TABLE `hd_outgoing_emails` (
  `id` int(11) UNSIGNED NOT NULL,
  `sent_to` varchar(64) DEFAULT NULL,
  `sent_from` varchar(64) DEFAULT NULL,
  `subject` text,
  `message` longtext,
  `date_sent` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `delivered` int(11) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `hd_payments`
--

CREATE TABLE `hd_payments` (
  `p_id` int(11) NOT NULL,
  `invoice` int(11) NOT NULL,
  `paid_by` int(11) NOT NULL,
  `payer_email` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `payment_method` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `currency` varchar(64) COLLATE utf8_unicode_ci DEFAULT 'USD',
  `amount` decimal(10,2) DEFAULT '0.00',
  `trans_id` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `notes` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `attached_file` text COLLATE utf8_unicode_ci,
  `payment_date` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `month_paid` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `year_paid` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `inv_deleted` enum('Yes','No') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'No',
  `refunded` enum('Yes','No') COLLATE utf8_unicode_ci DEFAULT 'No'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `hd_payment_methods`
--

CREATE TABLE `hd_payment_methods` (
  `method_id` int(11) NOT NULL,
  `method_name` varchar(64) NOT NULL DEFAULT 'Paypal'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `hd_payment_methods`
--

INSERT INTO `hd_payment_methods` (`method_id`, `method_name`) VALUES
(1, 'Online'),
(2, 'Cash'),
(3, 'Bank Deposit'),
(5, 'Cheque'),
(6, 'Account Credit');

-- --------------------------------------------------------

--
-- Table structure for table `hd_permissions`
--

CREATE TABLE `hd_permissions` (
  `permission_id` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` enum('active','inactive','deleted') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'active'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `hd_permissions`
--

INSERT INTO `hd_permissions` (`permission_id`, `name`, `description`, `status`) VALUES
(1, 'view_all_invoices', 'Allow user access to view all invoices', 'active'),
(2, 'edit_all_invoices', 'Allow user access to edit all invoices', 'active'),
(3, 'add_invoices', 'Allow user access to add invoices', 'active'),
(4, 'delete_invoices', 'Allow user access to delete invoice', 'active'),
(5, 'pay_invoice_offline', 'Allow user access to make offline Invoice Payments', 'active'),
(6, 'view_payments', 'Allow user access to view own payments', 'active'),
(7, 'email_invoices', 'Allow user access to email invoices', 'active'),
(8, 'send_email_reminders', 'Allow user access to send invoice reminders', 'active'),
(23, 'edit_settings', 'Allow user access to edit all settings', 'active'),
(32, 'view_all_payments', 'Allow staff to view all payments', 'active'),
(33, 'edit_payments', 'Allow staff to edit payments', 'active'),
(35, 'manage_accounts', 'Allow user to activate, suspend and delete accounts', 'active'),
(36, 'manage_orders', 'Allow user to activate, cancel and delete orders', 'active'),
(37, 'create_orders', 'Allow user to create orders', 'active');

-- --------------------------------------------------------

--
-- Table structure for table `hd_plugins`
--

CREATE TABLE `hd_plugins` (
  `plugin_id` int(11) NOT NULL,
  `system_name` varchar(150) NOT NULL,
  `name` varchar(150) NOT NULL,
  `category` varchar(100) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `uri` varchar(255) DEFAULT NULL,
  `version` varchar(10) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `author` varchar(50) DEFAULT NULL,
  `author_uri` varchar(255) DEFAULT NULL,
  `config` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `hd_plugins`
--

INSERT INTO `hd_plugins` (`plugin_id`, `system_name`, `name`, `category`, `status`, `uri`, `version`, `description`, `author`, `author_uri`, `config`) VALUES
(5, 'cpanel', 'cPanel', 'Servers', 0, 'http://www.hostingbilling.net', '1.0', 'cPanel API Integration.', 'Hosting Billing', 'www.hostingbilling.net', ''),
(6, 'directadmin', 'Directadmin', 'Servers', 0, 'http://www.hostingbilling.net', '1.0', 'Directadmin API Integration.', 'Hosting Billing', 'www.hostingbilling.net', ''),
(7, 'plesk', 'Plesk', 'Servers', 0, 'http://www.hostingbilling.net', '1.0', 'Plesk API Integration.', 'Hosting Billing', 'www.hostingbilling.net', ''),
(8, 'ispconfig', 'ISPConfig', 'Servers', 0, 'http://www.hostingbilling.net', '1.0', 'ISPConfig API Integration.', 'Hosting Billing', 'www.hostingbilling.net', ''),
(9, 'cwp', 'CWP', 'Servers', 0, 'http://www.hostingbilling.net', '1.0', 'Centos Web Panel API Integration.', 'Hosting Billing', 'www.hostingbilling.net', ''),
(10, 'cyberpanel', 'Cyberpanel', 'Servers', 0, 'http://www.hostingbilling.net', '1.0', 'Cyberpanel API Integration.', 'Hosting Billing', 'www.hostingbilling.net', ''),
(11, 'interworx', 'Interworx', 'Servers', 0, 'http://www.hostingbilling.net', '1.0', 'Interworx API Integration.', 'Hosting Billing', 'www.hostingbilling.net', ''),
(12, 'bitcoin', 'Bitcoin', 'Payment Gateways', 0, 'http://www.hostingbilling.net', '1.0', 'Bitcoin Payment Gateway.', 'Hosting Billing', 'www.hostingbilling.net', ''),
(13, 'checkout', 'Checkout', 'Payment Gateways', 0, 'http://www.hostingbilling.net', '1.0', '2Checkout Payment Gateway.', 'Hosting Billing', 'www.hostingbilling.net', ''),
(14, 'coinpayments', 'Coinpayments', 'Payment Gateways', 0, 'http://www.hostingbilling.net', '1.0', 'Coinpayments Payment Gateway.', 'Hosting Billing', 'www.hostingbilling.net', ''),
(15, 'domainscoza', 'Domainscoza', 'Domain Registrars', 0, 'http://www.hostingbilling.net', '1.0', 'Domains Registrar Integration', 'Hosting Billing', 'www.hostingbilling.net', ''),
(16, 'hexonet', 'Hexonet', 'Domain Registrars', 0, 'http://www.hostingbilling.net', '1.0', 'Hexonet Registrar Integration.', 'Hosting Billing', 'www.hostingbilling.net', ''),
(17, 'instamojo', 'Instamojo', 'Payment Gateways', 0, 'http://www.hostingbilling.net', '1.0', 'Instamojo Payment Gateway', 'Hosting Billing', 'www.hostingbilling.net', ''),
(18, 'internetbs', 'Internetbs', 'Domain Registrars', 0, 'http://www.hostingbilling.net', '1.0', 'Internt.bs Registrar Integration', 'Hosting Billing', 'www.hostingbilling.net', ''),
(19, 'mollie', 'Mollie', 'Payment Gateways', 0, 'http://www.hostingbilling.net', '1.0', 'Mollie Payment Gateway.', 'Hosting Billing', 'www.hostingbilling.net', ''),
(20, 'namecheap', 'Namecheap', 'Domain Registrars', 0, 'http://www.hostingbilling.net', '1.0', 'Namecheap Registrar Integration', 'Hosting Billing', 'www.hostingbilling.net', ''),
(21, 'payfast', 'Payfast', 'Payment Gateways', 0, 'http://www.hostingbilling.net', '1.0', 'Payfast Payment Gateway.', 'Hosting Billing', 'www.hostingbilling.net', ''),
(22, 'paypal', 'Paypal', 'Payment Gateways', 0, 'http://www.hostingbilling.net', '1.0', 'Paypal Payment Gateway.', 'Hosting Billing', 'www.hostingbilling.net', ''),
(23, 'paystack', 'Paystack', 'Payment Gateways', 0, 'http://www.hostingbilling.net', '1.0', 'Paystack Payment Gateway.', 'Hosting Billing', 'www.hostingbilling.net', ''),
(24, 'razorpay', 'Razorpay', 'Payment Gateways', 0, 'http://www.hostingbilling.net', '1.0', 'Razorpay Payment Gateway.', 'Hosting Billing', 'www.hostingbilling.net', ''),
(25, 'resellerclub', 'Resellerclub', 'Domain Registrars', 0, 'http://www.hostingbilling.net', '1.0', 'ResellerClub Registrar Integration', 'Hosting Billing', 'www.hostingbilling.net', ''),
(26, 'stripepay', 'Stripepay', 'Payment Gateways', 0, 'http://www.hostingbilling.net', '1.0', 'Stripepay Payment Gateway.', 'Hosting Billing', 'www.hostingbilling.net', ''),
(27, 'whoisxmlapi', 'Whoisxmlapi', 'Domain Availability', 0, 'http://www.hostingbilling.net', '1.0', 'Whois XML API Payment Gateway.', 'Hosting Billing', 'www.hostingbilling.net', ''),
(28, 'aamarpay', 'aamarPay', 'Payment Gateways', 0, 'http://www.hostingbilling.net', '1.0', 'aamarPay Payment Gateway.', 'Hosting Billing', 'www.hostingbilling.net', ''),
(29, 'namesilo', 'Namesilo', 'Domain Registrars', 0, 'http://www.hostingbilling.net', '1.0', 'Namesilo Registrar Integration.', 'Hosting Billing', 'www.hostingbilling.net', ''),
(30, 'synergywholesale', 'SynergyWholesale', 'Domain Registrars', 0, 'http://www.hostingbilling.net', '1.0', 'Synergy Wholesale Registrar Integration.', 'Hosting Billing', 'www.hostingbilling.net', '');

-- --------------------------------------------------------

--
-- Table structure for table `hd_posts`
--

CREATE TABLE `hd_posts` (
  `id` int(11) NOT NULL,
  `title` varchar(100) NOT NULL,
  `slug` varchar(100) NOT NULL,
  `pubdate` date NOT NULL,
  `body` longtext NOT NULL,
  `post_type` varchar(20) NOT NULL,
  `user_id` int(11) NOT NULL DEFAULT '1',
  `category_id` int(11) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  `parent_id` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `menu` int(11) NOT NULL,
  `sidebar_right` tinyint(1) NOT NULL,
  `sidebar_left` tinyint(1) NOT NULL,
  `order` int(11) NOT NULL DEFAULT '0',
  `option` text,
  `meta_title` varchar(255) NOT NULL,
  `meta_desc` varchar(255) NOT NULL,
  `knowledge` int(11) NOT NULL,
  `faq` int(11) NOT NULL,
  `knowledge_id` int(11) NOT NULL,
  `faq_id` int(11) NOT NULL,
  `views` int(11) NOT NULL,
  `video` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `hd_posts`
--

INSERT INTO `hd_posts` (`id`, `title`, `slug`, `pubdate`, `body`, `post_type`, `user_id`, `category_id`, `created`, `modified`, `parent_id`, `status`, `menu`, `sidebar_right`, `sidebar_left`, `order`, `option`, `meta_title`, `meta_desc`, `knowledge`, `faq`, `knowledge_id`, `faq_id`, `views`, `video`) VALUES
(1, 'Home', 'home', '2020-05-16', '<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<div class=\"btgrid\">\r\n<div class=\"row row-1\">\r\n<div class=\"col-md-6\">\r\n<div class=\"content\">\r\n<p><img alt=\"\" src=\"/resource/uploads/125782651.png\" style=\"height:370px; width:516px\" /></p>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col-md-6\">\r\n<div class=\"content\">\r\n<h1>Our Service Guarantee</h1>\r\n\r\n<hr />\r\n<h3>Server Level Protection</h3>\r\n\r\n<p>We provide protection for your website from DDoS attacks.</p>\r\n\r\n<hr />\r\n<h3>30 Day Money-back Guarantee</h3>\r\n\r\n<p>If you are unsatisfied with our services, we&rsquo;ll give you a full refund.</p>\r\n\r\n<hr />\r\n<h3>Dedicated 24/7 Support</h3>\r\n\r\n<p>Our professional support is always ready to provide assistance.</p>\r\n\r\n<hr />\r\n<h3>High-Quality Hardware</h3>\r\n\r\n<p>We use the latest hardware solutions that receive regular maintenance.</p>\r\n</div>\r\n</div>\r\n</div>\r\n</div>', 'page', 1, 0, '2020-05-12 05:41:45', '2021-07-11 16:19:24', 0, 1, 1, 0, 0, 0, NULL, 'Hosting Billing v1.5 Demo', 'Hosting Billing is a domain and web hosting billing system.', 0, 0, 0, 0, 0, ''),
(24, 'What is shared hosting?', 'what_is_shared_hosting?', '0000-00-00', '<p>Shared hosting is a form of web hosting in which many web hosting customers share a single (virtual or physical) server.</p>\r\n\r\n<p>The customers in a shared hosting environment are partitioned away form each other, so (when everything goes well), they have absolutely no access to each other&rsquo;s files, and are ideally not even aware of each other.<br />\r\n&nbsp;</p>\r\n\r\n<p>Shared hosting allows for a high customer-to-hardware density, which makes it a very inexpensive way to run a website &mdash; shared hosting is the cheapest form of hosting, and relatively high-quality shared hosting plans can be had for less than $10/month (sometimes less than $5/month, with a good coupon).<br />\r\n&nbsp;</p>\r\n\r\n<p>The problem with shared hosting is that a limited pool of computer resources is being shared by a large number of customers. This can cause slow-downs and site outages if one or more sites on a shared hosting server gets a lot a of traffic.<br />\r\n&nbsp;</p>\r\n\r\n<p>To prevent this, shared hosting providers usually institute some kind of throttling &mdash; even on so-called &ldquo;unlimited plans.&rdquo; This usually kicks in if your traffic spikes, which makes shared hosting plans a terrible idea if you are trying to build a highly-scalable, well-trafficked website.</p>', 'page', 1, 0, '2021-03-25 13:59:17', '2021-03-25 14:42:20', 0, 1, 0, 0, 0, 0, NULL, 'What is shared hosting?', 'Hosting Billing is a domain and web hosting billing system.', 0, 1, 0, 33, 0, ''),
(25, 'Can I host WordPress on shared hosting?', '_can_i_host_wordpress_on_shared_hosting', '0000-00-00', '<p>Yes.</p>\r\n\r\n<p>Because of its popularity, most shared hosting providers are well-equipped to handle a WordPress blog. Many even offer a simple one-click installation script, allowing you to get set up with a new WordPress site very quickly.</p>\r\n\r\n<p>You can use our hosting features comparison tool to find hosting providers that support WordPress.</p>\r\n\r\n<p>&nbsp;</p>', 'page', 1, 0, '2021-03-25 14:22:18', '2021-03-25 14:22:18', 0, 1, 0, 0, 0, 0, NULL, 'Can I host WordPress on shared hosting?', 'Hosting Billing is a domain and web hosting billing system.', 0, 1, 0, 33, 0, ''),
(26, 'Domain Registration', 'domain_registration', '0000-00-00', '<p>It all starts with a domain name</p>', 'page', 1, 0, '2021-03-25 14:26:50', '2021-03-25 14:27:10', 0, 1, 0, 0, 0, 0, NULL, 'Domain Registration', 'Hosting Billing is a domain and web hosting billing system.', 0, 0, 0, 0, 0, ''),
(31, 'Should I use a domain name generator?', 'should_i_use_a_domain_name_generator', '0000-00-00', '<p>A domain name generator is a tool that takes one or more keywords as inputs and provides a list of possible domain names based on combinations of your keywords and common affixes such as <code>my</code>, <code>i</code>, or <code>best</code>. Some will attempt to create new words by combining letters from your different key words. Usually these tools are combined with a domain name availability checker, so that only available options are presented.</p>\r\n\r\n<p>Domain name generator tools can be a good way to brainstorm ideas, especially if you&rsquo;re stuck for a creative name or the name you really want is taken. However, ideas from a domain name generator need to evaluated to see if they would be a good fit for your site.</p>', 'page', 1, 0, '2021-03-25 14:40:10', '2021-03-25 14:40:10', 0, 1, 0, 0, 0, 0, NULL, 'Should I use a domain name generator?', 'Hosting Billing is a domain and web hosting billing system.', 0, 1, 0, 39, 0, ''),
(29, 'What is a domain registrar', 'what_is_a_domain_registrar', '0000-00-00', '<p>A domain name registrar is a company that manages the registration of domain names. When you buy a new domain name, you are buying it &ldquo;from&rdquo; a registrar (that is &mdash; you are paying the registration fee to a registrar).</p>', 'page', 1, 0, '2021-03-25 14:38:55', '2021-03-25 14:38:55', 0, 1, 0, 0, 0, 0, NULL, 'What is a domain registrar', 'Hosting Billing is a domain and web hosting billing system.', 0, 1, 0, 39, 0, ''),
(27, 'Is .com domain still the best?', 'is_.com_domain_still_the_best', '0000-00-00', '<p>Even with all the additional options, <code>.com</code> seems to remain the gold standard for domain names. It carries a high-degree of trust with consumers, and communicates a sense of legitimacy that is hard to achieve with other domain name extensions.<br />\r\nBecause of this <code>.com</code> domains continue to have the highest sale price in the domain aftermarket.</p>', 'page', 1, 0, '2021-03-25 14:37:21', '2021-03-25 14:37:21', 0, 1, 0, 0, 0, 0, NULL, 'Is .com domain still the best?', 'Hosting Billing is a domain and web hosting billing system.', 0, 1, 0, 39, 0, ''),
(28, 'Do I need a domain name?', 'do_i_need_a_domain_name', '0000-00-00', '<p>If you want to set up a website, you probably need a domain name.</p>\r\n\r\n<p>Some people set up free blogs or other types of sites using a domain name that belong to a third-party service like WordPress.com or Tumblr. That&rsquo;s okay for small personal blogs &mdash; but if you want to build a serious online presence, you really should have your own domain name.</p>\r\n\r\n<p>It isn&rsquo;t hard to get your own domain name, all you need to do is buy one from a good domain name registrar.</p>', 'page', 1, 0, '2021-03-25 14:38:12', '2021-03-25 14:38:12', 0, 1, 0, 0, 0, 0, NULL, 'Do I need a domain name?', 'Hosting Billing is a domain and web hosting billing system.', 0, 1, 0, 39, 0, ''),
(33, 'Web Hosting', 'web_hosting', '0000-00-00', '<p><img alt=\"\" src=\"/resource/uploads/hosting.jpg\" /></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<hr />\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>', 'page', 1, 0, '2021-07-11 16:59:07', '2021-07-11 20:47:25', 0, 1, 1, 0, 0, 0, NULL, 'Web Hosting', 'Hosting Billing is a domain and web hosting billing system.', 0, 0, 0, 0, 0, ''),
(30, 'Can I host my website on shared hosting?', 'can_i_host_my_website_on_shared_hosting', '0000-00-00', '<p>Usually, yes. The question is whether you want to.</p>\r\n\r\n<p>If you are launching a more-or-less basic site which will have limited traffic &mdash; such as a personal blog, a homepage for a small offline business, or a website for local non-profit organization &mdash; then shared hosting is a great way to go. It will provide all the hosting power you need for up to several hundred visitors a day, for a reasonably low cost.</p>\r\n\r\n<p>If you need a website that will work with larger traffic numbers &mdash; several thousand a day, especially highly engaged visitors on an interactive site (like a store or web app) &mdash; then shared hosting is going to be a terrible experience for you. You would be better off, in that case, with a VPS hosting plan.</p>', 'page', 1, 0, '2021-03-25 14:39:35', '2021-03-25 14:39:35', 0, 1, 0, 0, 0, 0, NULL, 'Can I host my website on shared hosting?', 'Hosting Billing is a domain and web hosting billing system.', 0, 1, 0, 33, 0, '');

-- --------------------------------------------------------

--
-- Table structure for table `hd_post_meta`
--

CREATE TABLE `hd_post_meta` (
  `ID` int(11) NOT NULL,
  `post_id` int(11) NOT NULL,
  `type` varchar(255) NOT NULL DEFAULT 'post',
  `title_arabic` varchar(255) DEFAULT NULL,
  `body_arabic` text
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `hd_priorities`
--

CREATE TABLE `hd_priorities` (
  `priority` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `hd_priorities`
--

INSERT INTO `hd_priorities` (`priority`) VALUES
('Low'),
('Medium'),
('High'),
('Urgent');

-- --------------------------------------------------------

--
-- Table structure for table `hd_promotions`
--

CREATE TABLE `hd_promotions` (
  `id` int(11) NOT NULL,
  `type` int(11) NOT NULL,
  `code` varchar(100) NOT NULL,
  `value` decimal(10,2) NOT NULL DEFAULT '0.00',
  `description` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `apply_to` text,
  `required` text,
  `billing_cycle` text,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `payment` int(11) NOT NULL,
  `per_order` int(11) NOT NULL,
  `per_client` int(11) NOT NULL,
  `first_order` int(11) NOT NULL,
  `new_customers` int(11) NOT NULL,
  `use_date` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `hd_resellerclub_ids`
--

CREATE TABLE `hd_resellerclub_ids` (
  `id` int(11) NOT NULL,
  `contact_id` int(11) DEFAULT NULL,
  `customer_id` int(11) DEFAULT NULL,
  `domain` varchar(100) DEFAULT NULL,
  `admin_id` int(11) DEFAULT NULL,
  `order_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `hd_roles`
--

CREATE TABLE `hd_roles` (
  `r_id` int(11) NOT NULL,
  `role` varchar(64) NOT NULL,
  `default` int(11) NOT NULL,
  `permissions` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `hd_roles`
--

INSERT INTO `hd_roles` (`r_id`, `role`, `default`, `permissions`) VALUES
(1, 'admin', 1, '{\"settings\":\"permissions\",\"role\":\"admin\",\"view_all_invoices\":\"on\",\"edit_invoices\":\"on\",\"pay_invoice_offline\":\"on\",\"view_all_payments\":\"on\",\"email_invoices\":\"on\",\"send_email_reminders\":\"on\"}'),
(2, 'client', 2, '{\"settings\":\"permissions\",\"role\":\"client\"}'),
(3, 'staff', 3, '{\"settings\":\"permissions\",\"role\":\"staff\",\"view_all_invoices\":\"on\",\"edit_invoices\":\"on\",\"add_invoices\":\"on\",\"pay_invoice_offline\":\"on\",\"send_email_reminders\":\"on\",\"view_orders\":\"on\",\"manage_orders\":\"on\"}');

-- --------------------------------------------------------

--
-- Table structure for table `hd_servers`
--

CREATE TABLE `hd_servers` (
  `id` int(11) NOT NULL,
  `type` varchar(100) NOT NULL,
  `name` varchar(100) NOT NULL,
  `hostname` varchar(100) NOT NULL,
  `port` int(10) NOT NULL,
  `use_ssl` enum('Yes','No') NOT NULL DEFAULT 'Yes',
  `username` varchar(100) NOT NULL,
  `authkey` text NOT NULL,
  `selected` int(11) NOT NULL DEFAULT '0',
  `ns1` varchar(100) DEFAULT NULL,
  `ns2` varchar(100) DEFAULT NULL,
  `ns3` varchar(100) DEFAULT NULL,
  `ns4` varchar(100) DEFAULT NULL,
  `ns5` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `hd_slider`
--

CREATE TABLE `hd_slider` (
  `slider_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `hd_slider`
--

INSERT INTO `hd_slider` (`slider_id`, `name`, `status`) VALUES
(7, 'Home Slider', 1);

-- --------------------------------------------------------

--
-- Table structure for table `hd_sliders`
--

CREATE TABLE `hd_sliders` (
  `slide_id` int(11) NOT NULL,
  `slider` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text CHARACTER SET utf8,
  `image` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `hd_sliders`
--

INSERT INTO `hd_sliders` (`slide_id`, `slider`, `title`, `description`, `image`) VALUES
(5, 0, 'edw', 'vvvv', ''),
(6, 0, 'ff', 'gg', ''),
(7, 0, 'gh', 'bnm', ''),
(15, 7, '', ' ', 'slide1.jpg'),
(16, 7, 'Test', '  ', 'slide2.jpg'),
(17, 7, '', '     Slide with html  caption example <a href=\"auth/login\" class=\"btn btn-sm btn-warning\">Login</a>', 'slide3.jpg');

-- --------------------------------------------------------

--
-- Table structure for table `hd_states`
--

CREATE TABLE `hd_states` (
  `state` varchar(25) CHARACTER SET utf8 DEFAULT NULL,
  `code` varchar(2) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `hd_states`
--

INSERT INTO `hd_states` (`state`, `code`) VALUES
('Alabama', 'AL'),
('Alaska', 'AK'),
('Arizona', 'AZ'),
('Arkansas', 'AR'),
('California', 'CA'),
('Colorado', 'CO'),
('Connecticut', 'CT'),
('Delaware', 'DE'),
('District of Columbia', 'DC'),
('Florida', 'FL'),
('Georgia', 'GA'),
('Hawaii', 'HI'),
('Idaho', 'ID'),
('Illinois', 'IL'),
('Indiana', 'IN'),
('Iowa', 'IA'),
('Kansas', 'KS'),
('Kentucky', 'KY'),
('Louisiana', 'LA'),
('Maine', 'ME'),
('Maryland', 'MD'),
('Massachusetts', 'MA'),
('Michigan', 'MI'),
('Minnesota', 'MN'),
('Mississippi', 'MS'),
('Missouri', 'MO'),
('Montana', 'MT'),
('Nebraska', 'NE'),
('Nevada', 'NV'),
('New Hampshire', 'NH'),
('New Jersey', 'NJ'),
('New Mexico', 'NM'),
('New York', 'NY'),
('North Carolina', 'NC'),
('North Dakota', 'ND'),
('Ohio', 'OH'),
('Oklahoma', 'OK'),
('Oregon', 'OR'),
('Pennsylvania', 'PA'),
('Rhode Island', 'RI'),
('South Carolina', 'SC'),
('South Dakota', 'SD'),
('Tennessee', 'TN'),
('Texas', 'TX'),
('Utah', 'UT'),
('Vermont', 'VT'),
('Virginia', 'VA'),
('Washington', 'WA'),
('West Virginia', 'WV'),
('Wisconsin', 'WI'),
('Wyoming', 'WY'),
('Armed Forces Africa', 'AE'),
('Armed Forces Americas', 'AA'),
('Armed Forces Canada', 'AE'),
('Armed Forces Europe', 'AE'),
('Armed Forces Middle East', 'AE'),
('Armed Forces Pacific', 'AP'),
('Alberta', 'AB'),
('British Columbia', 'BC'),
('Manitoba', 'MB'),
('New Brunswick', 'NB'),
('Newfoundland and Labrador', 'NL'),
('Northwest Territories', 'NT'),
('Nova Scotia', 'NS'),
('Nunavut', 'NU'),
('Ontario', 'ON'),
('Prince Edward Island', 'PE'),
('Quebec', 'QC'),
('Saskatchewan', 'SK'),
('Yukon', 'YT');

-- --------------------------------------------------------

--
-- Table structure for table `hd_status`
--

CREATE TABLE `hd_status` (
  `id` int(11) NOT NULL,
  `status` varchar(200) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `hd_status`
--

INSERT INTO `hd_status` (`id`, `status`) VALUES
(1, 'resolved'),
(2, 'closed'),
(3, 'open'),
(5, 'pending'),
(6, 'active'),
(7, 'cancelled'),
(8, 'deleted'),
(9, 'suspended'),
(10, 'status');

-- --------------------------------------------------------

--
-- Table structure for table `hd_tax_rates`
--

CREATE TABLE `hd_tax_rates` (
  `tax_rate_id` int(11) NOT NULL,
  `tax_rate_name` varchar(25) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `tax_rate_percent` decimal(10,2) NOT NULL DEFAULT '0.00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `hd_tax_rates`
--

INSERT INTO `hd_tax_rates` (`tax_rate_id`, `tax_rate_name`, `tax_rate_percent`) VALUES
(2, 'GST', '18.00');

-- --------------------------------------------------------

--
-- Table structure for table `hd_ticketreplies`
--

CREATE TABLE `hd_ticketreplies` (
  `id` int(10) NOT NULL,
  `ticketid` int(10) DEFAULT NULL,
  `body` longtext COLLATE utf8_unicode_ci,
  `replier` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `replierid` int(10) DEFAULT NULL,
  `attachment` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `visibility` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `hd_tickets`
--

CREATE TABLE `hd_tickets` (
  `id` int(10) NOT NULL,
  `ticket_code` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `subject` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `body` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `status` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `department` int(11) DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL,
  `reporter` int(10) DEFAULT '0',
  `priority` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `additional` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `attachment` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `archived_t` int(2) DEFAULT '0',
  `created` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `hd_un_sessions`
--

CREATE TABLE `hd_un_sessions` (
  `id` varchar(40) NOT NULL,
  `ip_address` varchar(45) NOT NULL,
  `timestamp` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `data` blob NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `hd_un_sessions`
--

INSERT INTO `hd_un_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('2934618fecf7ff55679db5e819fcfcd72c4661f1', '::1', 1474573713, 0x5f5f63695f6c6173745f726567656e65726174657c693a313437343537333634383b7265717565737465645f706167657c733a32343a22687474703a2f2f6c6f63616c686f73742f666f6c6974652f223b757365725f69647c733a313a2231223b757365726e616d657c733a353a2261646d696e223b726f6c655f69647c733a313a2231223b7374617475737c733a313a2231223b70726576696f75735f706167657c733a32343a22687474703a2f2f6c6f63616c686f73742f666f6c6974652f223b);

-- --------------------------------------------------------

--
-- Table structure for table `hd_updates`
--

CREATE TABLE `hd_updates` (
  `build` int(11) NOT NULL DEFAULT '0',
  `code` varchar(50) DEFAULT NULL,
  `date` timestamp NULL DEFAULT NULL,
  `version` varchar(10) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `description` text,
  `filename` varchar(255) DEFAULT NULL,
  `importance` enum('low','medium','high') DEFAULT 'low',
  `dependencies` varchar(255) DEFAULT NULL,
  `installed` int(11) DEFAULT '0',
  `sql` text,
  `files` text,
  `depends` varchar(255) DEFAULT NULL,
  `includes` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `hd_users`
--

CREATE TABLE `hd_users` (
  `id` int(11) NOT NULL,
  `username` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `role_id` int(11) NOT NULL DEFAULT '2',
  `activated` tinyint(1) NOT NULL DEFAULT '1',
  `banned` tinyint(1) NOT NULL DEFAULT '0',
  `ban_reason` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `new_password_key` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `new_password_requested` datetime DEFAULT NULL,
  `new_email` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `new_email_key` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `last_ip` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `last_login` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
  `created` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `code` varchar(100) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `hd_user_autologin`
--

CREATE TABLE `hd_user_autologin` (
  `key_id` char(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `user_id` int(11) NOT NULL DEFAULT '0',
  `user_agent` varchar(150) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `last_ip` varchar(40) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `last_login` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `expires` timestamp NULL DEFAULT NULL,
  `remote` int(2) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `hd_user_autologin`
--

INSERT INTO `hd_user_autologin` (`key_id`, `user_id`, `user_agent`, `last_ip`, `last_login`, `expires`, `remote`) VALUES
('a7b65bba081e293e36dc5345492bc081', 1, 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.93 Safari/537.36', '154.72.153.91', '2021-05-08 17:55:39', NULL, 0),
('ad906ea3b995e431b9fb0c21644f136f', 1, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.124 Safari/537.36', '37.111.218.213', '2021-07-04 16:56:47', NULL, 0),
('bfad413bb7891cc46a1f60652f234a4f', 415, '', '', '2021-07-04 17:43:46', '2021-07-07 15:07:43', 1),
('c4ba24eeaf68c41a14d01de14f068b56', 1, '', '', '2021-05-11 14:04:10', '2021-05-14 12:05:04', 1),
('cfc85d53f0349f01d0d37e5dee6f7187', 2, '', '', '2020-08-13 20:43:06', '2020-08-16 18:08:43', 1);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `hd_account_details`
--
ALTER TABLE `hd_account_details`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `hd_activities`
--
ALTER TABLE `hd_activities`
  ADD PRIMARY KEY (`activity_id`);

--
-- Indexes for table `hd_additional_fields`
--
ALTER TABLE `hd_additional_fields`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `hd_blocks`
--
ALTER TABLE `hd_blocks`
  ADD PRIMARY KEY (`block_id`);

--
-- Indexes for table `hd_blocks_custom`
--
ALTER TABLE `hd_blocks_custom`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `hd_blocks_modules`
--
ALTER TABLE `hd_blocks_modules`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `hd_blocks_pages`
--
ALTER TABLE `hd_blocks_pages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `hd_captcha`
--
ALTER TABLE `hd_captcha`
  ADD PRIMARY KEY (`captcha_id`),
  ADD KEY `word` (`word`);

--
-- Indexes for table `hd_categories`
--
ALTER TABLE `hd_categories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `hd_companies`
--
ALTER TABLE `hd_companies`
  ADD PRIMARY KEY (`co_id`);

--
-- Indexes for table `hd_config`
--
ALTER TABLE `hd_config`
  ADD PRIMARY KEY (`config_key`);

--
-- Indexes for table `hd_countries`
--
ALTER TABLE `hd_countries`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `hd_currencies`
--
ALTER TABLE `hd_currencies`
  ADD PRIMARY KEY (`code`);

--
-- Indexes for table `hd_departments`
--
ALTER TABLE `hd_departments`
  ADD PRIMARY KEY (`deptid`);

--
-- Indexes for table `hd_email_templates`
--
ALTER TABLE `hd_email_templates`
  ADD PRIMARY KEY (`template_id`);

--
-- Indexes for table `hd_fields`
--
ALTER TABLE `hd_fields`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `hd_files`
--
ALTER TABLE `hd_files`
  ADD PRIMARY KEY (`file_id`);

--
-- Indexes for table `hd_formmeta`
--
ALTER TABLE `hd_formmeta`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `hd_hooks`
--
ALTER TABLE `hd_hooks`
  ADD PRIMARY KEY (`module`,`hook`,`access`);

--
-- Indexes for table `hd_images`
--
ALTER TABLE `hd_images`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `hd_invoices`
--
ALTER TABLE `hd_invoices`
  ADD PRIMARY KEY (`inv_id`),
  ADD UNIQUE KEY `reference_no` (`reference_no`);

--
-- Indexes for table `hd_items`
--
ALTER TABLE `hd_items`
  ADD PRIMARY KEY (`item_id`);

--
-- Indexes for table `hd_items_saved`
--
ALTER TABLE `hd_items_saved`
  ADD PRIMARY KEY (`item_id`);

--
-- Indexes for table `hd_item_pricing`
--
ALTER TABLE `hd_item_pricing`
  ADD PRIMARY KEY (`item_pricing_id`);

--
-- Indexes for table `hd_languages`
--
ALTER TABLE `hd_languages`
  ADD PRIMARY KEY (`code`);

--
-- Indexes for table `hd_links`
--
ALTER TABLE `hd_links`
  ADD PRIMARY KEY (`link_id`);

--
-- Indexes for table `hd_locales`
--
ALTER TABLE `hd_locales`
  ADD PRIMARY KEY (`locale`);

--
-- Indexes for table `hd_login_attempts`
--
ALTER TABLE `hd_login_attempts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `hd_menu`
--
ALTER TABLE `hd_menu`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `hd_menu_group`
--
ALTER TABLE `hd_menu_group`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `hd_orders`
--
ALTER TABLE `hd_orders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `processed` (`processed`,`renewal_date`),
  ADD KEY `order_id` (`order_id`,`process_id`);

--
-- Indexes for table `hd_outgoing_emails`
--
ALTER TABLE `hd_outgoing_emails`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `hd_payments`
--
ALTER TABLE `hd_payments`
  ADD PRIMARY KEY (`p_id`),
  ADD KEY `p_id` (`p_id`);

--
-- Indexes for table `hd_payment_methods`
--
ALTER TABLE `hd_payment_methods`
  ADD PRIMARY KEY (`method_id`);

--
-- Indexes for table `hd_permissions`
--
ALTER TABLE `hd_permissions`
  ADD PRIMARY KEY (`permission_id`);

--
-- Indexes for table `hd_plugins`
--
ALTER TABLE `hd_plugins`
  ADD PRIMARY KEY (`plugin_id`);

--
-- Indexes for table `hd_posts`
--
ALTER TABLE `hd_posts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `hd_post_meta`
--
ALTER TABLE `hd_post_meta`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `hd_promotions`
--
ALTER TABLE `hd_promotions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `hd_resellerclub_ids`
--
ALTER TABLE `hd_resellerclub_ids`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `domain` (`domain`);

--
-- Indexes for table `hd_roles`
--
ALTER TABLE `hd_roles`
  ADD PRIMARY KEY (`r_id`);

--
-- Indexes for table `hd_servers`
--
ALTER TABLE `hd_servers`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `hd_slider`
--
ALTER TABLE `hd_slider`
  ADD PRIMARY KEY (`slider_id`);

--
-- Indexes for table `hd_sliders`
--
ALTER TABLE `hd_sliders`
  ADD PRIMARY KEY (`slide_id`);

--
-- Indexes for table `hd_status`
--
ALTER TABLE `hd_status`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `hd_tax_rates`
--
ALTER TABLE `hd_tax_rates`
  ADD KEY `Index 1` (`tax_rate_id`);

--
-- Indexes for table `hd_ticketreplies`
--
ALTER TABLE `hd_ticketreplies`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `hd_tickets`
--
ALTER TABLE `hd_tickets`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `ticket_code` (`ticket_code`);

--
-- Indexes for table `hd_un_sessions`
--
ALTER TABLE `hd_un_sessions`
  ADD KEY `ci_sessions_timestamp` (`timestamp`);

--
-- Indexes for table `hd_updates`
--
ALTER TABLE `hd_updates`
  ADD PRIMARY KEY (`build`);

--
-- Indexes for table `hd_users`
--
ALTER TABLE `hd_users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `username` (`username`);

--
-- Indexes for table `hd_user_autologin`
--
ALTER TABLE `hd_user_autologin`
  ADD PRIMARY KEY (`key_id`,`user_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `hd_account_details`
--
ALTER TABLE `hd_account_details`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `hd_activities`
--
ALTER TABLE `hd_activities`
  MODIFY `activity_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `hd_additional_fields`
--
ALTER TABLE `hd_additional_fields`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `hd_blocks`
--
ALTER TABLE `hd_blocks`
  MODIFY `block_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=83;

--
-- AUTO_INCREMENT for table `hd_blocks_custom`
--
ALTER TABLE `hd_blocks_custom`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;

--
-- AUTO_INCREMENT for table `hd_blocks_modules`
--
ALTER TABLE `hd_blocks_modules`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;

--
-- AUTO_INCREMENT for table `hd_blocks_pages`
--
ALTER TABLE `hd_blocks_pages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=206;

--
-- AUTO_INCREMENT for table `hd_captcha`
--
ALTER TABLE `hd_captcha`
  MODIFY `captcha_id` bigint(13) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `hd_categories`
--
ALTER TABLE `hd_categories`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=40;

--
-- AUTO_INCREMENT for table `hd_companies`
--
ALTER TABLE `hd_companies`
  MODIFY `co_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `hd_countries`
--
ALTER TABLE `hd_countries`
  MODIFY `id` int(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=241;

--
-- AUTO_INCREMENT for table `hd_departments`
--
ALTER TABLE `hd_departments`
  MODIFY `deptid` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `hd_email_templates`
--
ALTER TABLE `hd_email_templates`
  MODIFY `template_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;

--
-- AUTO_INCREMENT for table `hd_fields`
--
ALTER TABLE `hd_fields`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `hd_files`
--
ALTER TABLE `hd_files`
  MODIFY `file_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `hd_formmeta`
--
ALTER TABLE `hd_formmeta`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `hd_images`
--
ALTER TABLE `hd_images`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `hd_invoices`
--
ALTER TABLE `hd_invoices`
  MODIFY `inv_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `hd_items`
--
ALTER TABLE `hd_items`
  MODIFY `item_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `hd_items_saved`
--
ALTER TABLE `hd_items_saved`
  MODIFY `item_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=80;

--
-- AUTO_INCREMENT for table `hd_item_pricing`
--
ALTER TABLE `hd_item_pricing`
  MODIFY `item_pricing_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=73;

--
-- AUTO_INCREMENT for table `hd_links`
--
ALTER TABLE `hd_links`
  MODIFY `link_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `hd_login_attempts`
--
ALTER TABLE `hd_login_attempts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `hd_menu`
--
ALTER TABLE `hd_menu`
  MODIFY `id` tinyint(3) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=94;

--
-- AUTO_INCREMENT for table `hd_menu_group`
--
ALTER TABLE `hd_menu_group`
  MODIFY `id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `hd_orders`
--
ALTER TABLE `hd_orders`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `hd_outgoing_emails`
--
ALTER TABLE `hd_outgoing_emails`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `hd_payments`
--
ALTER TABLE `hd_payments`
  MODIFY `p_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `hd_payment_methods`
--
ALTER TABLE `hd_payment_methods`
  MODIFY `method_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `hd_permissions`
--
ALTER TABLE `hd_permissions`
  MODIFY `permission_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38;

--
-- AUTO_INCREMENT for table `hd_plugins`
--
ALTER TABLE `hd_plugins`
  MODIFY `plugin_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT for table `hd_posts`
--
ALTER TABLE `hd_posts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;

--
-- AUTO_INCREMENT for table `hd_post_meta`
--
ALTER TABLE `hd_post_meta`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `hd_promotions`
--
ALTER TABLE `hd_promotions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `hd_resellerclub_ids`
--
ALTER TABLE `hd_resellerclub_ids`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `hd_roles`
--
ALTER TABLE `hd_roles`
  MODIFY `r_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `hd_servers`
--
ALTER TABLE `hd_servers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `hd_slider`
--
ALTER TABLE `hd_slider`
  MODIFY `slider_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `hd_sliders`
--
ALTER TABLE `hd_sliders`
  MODIFY `slide_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `hd_status`
--
ALTER TABLE `hd_status`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `hd_tax_rates`
--
ALTER TABLE `hd_tax_rates`
  MODIFY `tax_rate_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `hd_ticketreplies`
--
ALTER TABLE `hd_ticketreplies`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `hd_tickets`
--
ALTER TABLE `hd_tickets`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `hd_users`
--
ALTER TABLE `hd_users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
