text: -- MySQL dump 10.13  Distrib 5.5.38, for debian-linux-gnu (x86_64)
  --
  -- Host: localhost    Database: boxbilling
  -- ------------------------------------------------------
  -- Server version	5.5.38-0ubuntu0.14.04.1
  
  /*!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 utf8 */;
  /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  /*!40103 SET TIME_ZONE='+00:00' */;
  /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  
  --
  -- Table structure for table `activity_admin_history`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `activity_admin_history` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `admin_id` bigint(20) DEFAULT NULL,
    `ip` varchar(45) DEFAULT NULL,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `admin_id_idx` (`admin_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `activity_client_email`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `activity_client_email` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `client_id` bigint(20) DEFAULT NULL,
    `sender` varchar(255) DEFAULT NULL,
    `recipients` text,
    `subject` varchar(255) DEFAULT NULL,
    `content_html` text,
    `content_text` text,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `client_id_idx` (`client_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `activity_client_history`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `activity_client_history` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `client_id` bigint(20) DEFAULT NULL,
    `ip` varchar(45) DEFAULT NULL,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `client_id_idx` (`client_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `activity_system`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `activity_system` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `priority` tinyint(4) DEFAULT NULL,
    `admin_id` bigint(20) DEFAULT NULL,
    `client_id` bigint(20) DEFAULT NULL,
    `message` text,
    `ip` varchar(45) DEFAULT NULL,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `admin_id_idx` (`admin_id`),
    KEY `client_id_idx` (`client_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `admin`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `admin` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `role` varchar(30) DEFAULT 'staff' COMMENT 'admin, staff',
    `admin_group_id` bigint(20) DEFAULT '1',
    `email` varchar(255) DEFAULT NULL,
    `pass` varchar(255) DEFAULT NULL,
    `salt` varchar(255) DEFAULT NULL,
    `name` varchar(255) DEFAULT NULL,
    `signature` varchar(255) DEFAULT NULL,
    `protected` tinyint(1) DEFAULT '0',
    `status` varchar(30) DEFAULT 'active' COMMENT 'active, inactive',
    `api_token` varchar(128) DEFAULT NULL,
    `permissions` text,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `email` (`email`),
    KEY `admin_group_id_idx` (`admin_group_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `admin_group`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `admin_group` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `name` varchar(255) DEFAULT NULL,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `api_request`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `api_request` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `ip` varchar(45) DEFAULT NULL,
    `request` text,
    `created_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `cart`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `cart` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `session_id` varchar(32) DEFAULT NULL,
    `currency_id` bigint(20) DEFAULT NULL,
    `promo_id` bigint(20) DEFAULT NULL,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `session_id_idx` (`session_id`),
    KEY `currency_id_idx` (`currency_id`),
    KEY `promo_id_idx` (`promo_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `cart_product`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `cart_product` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `cart_id` bigint(20) DEFAULT NULL,
    `product_id` bigint(20) DEFAULT NULL,
    `config` text,
    PRIMARY KEY (`id`),
    KEY `cart_id_idx` (`cart_id`),
    KEY `product_id_idx` (`product_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `client`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `client` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `aid` varchar(255) DEFAULT NULL COMMENT 'Alternative id for foreign systems',
    `client_group_id` bigint(20) DEFAULT NULL,
    `role` varchar(30) NOT NULL DEFAULT 'client' COMMENT 'client',
    `auth_type` varchar(255) DEFAULT NULL,
    `email` varchar(255) DEFAULT NULL,
    `pass` varchar(255) DEFAULT NULL,
    `salt` varchar(255) DEFAULT NULL,
    `status` varchar(30) DEFAULT 'active' COMMENT 'active, suspended, canceled',
    `email_approved` tinyint(1) DEFAULT NULL,
    `tax_exempt` tinyint(1) DEFAULT '0',
    `type` varchar(100) DEFAULT NULL,
    `first_name` varchar(100) DEFAULT NULL,
    `last_name` varchar(100) DEFAULT NULL,
    `gender` varchar(20) DEFAULT NULL,
    `birthday` date DEFAULT NULL,
    `phone_cc` varchar(10) DEFAULT NULL,
    `phone` varchar(100) DEFAULT NULL,
    `company` varchar(100) DEFAULT NULL,
    `company_vat` varchar(100) DEFAULT NULL,
    `company_number` varchar(255) DEFAULT NULL,
    `address_1` varchar(100) DEFAULT NULL,
    `address_2` varchar(100) DEFAULT NULL,
    `city` varchar(100) DEFAULT NULL,
    `state` varchar(100) DEFAULT NULL,
    `postcode` varchar(100) DEFAULT NULL,
    `country` varchar(100) DEFAULT NULL,
    `document_type` varchar(100) DEFAULT NULL,
    `document_nr` varchar(20) DEFAULT NULL,
    `notes` text,
    `currency` varchar(10) DEFAULT NULL,
    `lang` varchar(10) DEFAULT NULL,
    `ip` varchar(45) DEFAULT NULL,
    `api_token` varchar(128) DEFAULT NULL,
    `referred_by` varchar(255) DEFAULT NULL,
    `custom_1` text,
    `custom_2` text,
    `custom_3` text,
    `custom_4` text,
    `custom_5` text,
    `custom_6` text,
    `custom_7` text,
    `custom_8` text,
    `custom_9` text,
    `custom_10` text,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `email` (`email`),
    KEY `alternative_id_idx` (`aid`),
    KEY `client_group_id_idx` (`client_group_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `client_balance`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `client_balance` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `client_id` bigint(20) DEFAULT NULL,
    `type` varchar(100) DEFAULT NULL,
    `rel_id` int(11) DEFAULT NULL,
    `amount` decimal(18,2) DEFAULT '0.00',
    `description` text,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `client_id_idx` (`client_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `client_group`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `client_group` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `title` varchar(255) DEFAULT NULL,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `client_order`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `client_order` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `client_id` bigint(20) DEFAULT NULL,
    `product_id` bigint(20) DEFAULT NULL,
    `form_id` bigint(20) DEFAULT NULL,
    `promo_id` bigint(20) DEFAULT NULL,
    `promo_recurring` tinyint(1) DEFAULT NULL,
    `promo_used` bigint(20) DEFAULT NULL,
    `group_id` varchar(255) DEFAULT NULL,
    `group_master` tinyint(1) DEFAULT '0',
    `invoice_option` varchar(255) DEFAULT NULL,
    `title` varchar(255) DEFAULT NULL,
    `currency` varchar(20) DEFAULT NULL,
    `unpaid_invoice_id` bigint(20) DEFAULT NULL,
    `service_id` bigint(20) DEFAULT NULL,
    `service_type` varchar(100) DEFAULT NULL,
    `period` varchar(20) DEFAULT NULL,
    `quantity` bigint(20) DEFAULT '1',
    `unit` varchar(100) DEFAULT NULL,
    `price` double(18,2) DEFAULT NULL,
    `discount` double(18,2) DEFAULT NULL COMMENT 'first invoice discount',
    `status` varchar(50) DEFAULT NULL,
    `reason` varchar(255) DEFAULT NULL COMMENT 'suspend/cancel reason',
    `notes` text,
    `config` text,
    `referred_by` varchar(255) DEFAULT NULL,
    `expires_at` datetime DEFAULT NULL,
    `activated_at` datetime DEFAULT NULL,
    `suspended_at` datetime DEFAULT NULL,
    `unsuspended_at` datetime DEFAULT NULL,
    `canceled_at` datetime DEFAULT NULL,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `client_id_idx` (`client_id`),
    KEY `product_id_idx` (`product_id`),
    KEY `form_id_idx` (`form_id`),
    KEY `promo_id_idx` (`promo_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `client_order_meta`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `client_order_meta` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `client_order_id` bigint(20) DEFAULT NULL,
    `name` varchar(255) DEFAULT NULL,
    `value` text,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `client_order_id_idx` (`client_order_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `client_order_status`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `client_order_status` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `client_order_id` bigint(20) DEFAULT NULL,
    `status` varchar(20) DEFAULT NULL,
    `notes` text,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `client_order_id_idx` (`client_order_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `client_password_reset`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `client_password_reset` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `client_id` bigint(20) DEFAULT NULL,
    `hash` varchar(100) DEFAULT NULL,
    `ip` varchar(45) DEFAULT NULL,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `client_id_idx` (`client_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `currency`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `currency` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `title` varchar(50) DEFAULT NULL,
    `code` varchar(3) DEFAULT NULL,
    `is_default` tinyint(1) DEFAULT '0',
    `conversion_rate` decimal(13,6) DEFAULT '1.000000',
    `format` varchar(30) DEFAULT NULL,
    `price_format` varchar(50) DEFAULT '1',
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `email_template`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `email_template` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `action_code` varchar(255) DEFAULT NULL,
    `category` varchar(30) DEFAULT NULL COMMENT 'general, domain, invoice, hosting, support, download, custom, license',
    `enabled` tinyint(1) DEFAULT '1',
    `subject` varchar(255) DEFAULT NULL,
    `content` text,
    `description` text,
    `vars` text,
    PRIMARY KEY (`id`),
    UNIQUE KEY `action_code` (`action_code`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `extension`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `extension` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `type` varchar(255) DEFAULT NULL,
    `name` varchar(255) DEFAULT NULL,
    `status` varchar(100) DEFAULT NULL,
    `version` varchar(100) DEFAULT NULL,
    `manifest` text,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `extension_meta`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `extension_meta` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `client_id` bigint(20) DEFAULT NULL,
    `extension` varchar(255) DEFAULT NULL,
    `rel_type` varchar(255) DEFAULT NULL,
    `rel_id` varchar(255) DEFAULT NULL,
    `meta_key` varchar(255) DEFAULT NULL,
    `meta_value` longtext,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `client_id_idx` (`client_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `form`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `form` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `name` varchar(255) DEFAULT NULL,
    `style` text,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `form_field`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `form_field` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `form_id` bigint(20) DEFAULT NULL,
    `name` varchar(255) DEFAULT NULL,
    `label` varchar(255) DEFAULT NULL,
    `hide_label` tinyint(1) DEFAULT NULL,
    `description` varchar(255) DEFAULT NULL,
    `type` varchar(255) DEFAULT NULL,
    `default_value` varchar(255) DEFAULT NULL,
    `required` tinyint(1) DEFAULT NULL,
    `hidden` tinyint(1) DEFAULT NULL,
    `readonly` tinyint(1) DEFAULT NULL,
    `is_unique` tinyint(1) DEFAULT NULL,
    `prefix` varchar(255) DEFAULT NULL,
    `suffix` varchar(255) DEFAULT NULL,
    `options` text,
    `show_initial` varchar(255) DEFAULT NULL,
    `show_middle` varchar(255) DEFAULT NULL,
    `show_prefix` varchar(255) DEFAULT NULL,
    `show_suffix` varchar(255) DEFAULT NULL,
    `text_size` int(11) DEFAULT NULL,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `form_id_idx` (`form_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `forum`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `forum` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `category` varchar(255) DEFAULT NULL,
    `title` text,
    `description` text,
    `slug` varchar(255) DEFAULT NULL,
    `status` varchar(100) DEFAULT NULL,
    `priority` int(11) DEFAULT NULL,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `slug` (`slug`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `forum_topic`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `forum_topic` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `forum_id` bigint(20) DEFAULT NULL,
    `title` text,
    `slug` varchar(255) DEFAULT NULL,
    `status` varchar(100) DEFAULT NULL,
    `sticky` tinyint(1) DEFAULT '0',
    `views` int(11) DEFAULT '0',
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `slug` (`slug`),
    KEY `forum_id_idx` (`forum_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `forum_topic_message`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `forum_topic_message` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `forum_topic_id` bigint(20) DEFAULT NULL,
    `client_id` bigint(20) DEFAULT NULL,
    `admin_id` bigint(20) DEFAULT NULL,
    `message` text,
    `ip` varchar(45) DEFAULT NULL,
    `points` varchar(255) DEFAULT NULL,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `forum_topic_id_idx` (`forum_topic_id`),
    KEY `client_id_idx` (`client_id`),
    KEY `admin_id_idx` (`admin_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `invoice`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `invoice` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `client_id` bigint(20) DEFAULT NULL,
    `serie` varchar(50) DEFAULT NULL,
    `nr` varchar(255) DEFAULT NULL,
    `hash` varchar(255) DEFAULT NULL COMMENT 'To access via public link',
    `currency` varchar(25) DEFAULT NULL,
    `currency_rate` decimal(13,6) DEFAULT NULL,
    `credit` double(18,2) DEFAULT NULL,
    `base_income` double(18,2) DEFAULT NULL COMMENT 'Income in default currency',
    `base_refund` double(18,2) DEFAULT NULL COMMENT 'Refund in default currency',
    `refund` double(18,2) DEFAULT NULL,
    `notes` text,
    `text_1` text,
    `text_2` text,
    `status` varchar(50) DEFAULT 'unpaid' COMMENT 'paid, unpaid',
    `seller_company` varchar(255) DEFAULT NULL,
    `seller_company_vat` varchar(255) DEFAULT NULL,
    `seller_company_number` varchar(255) DEFAULT NULL,
    `seller_address` varchar(255) DEFAULT NULL,
    `seller_phone` varchar(255) DEFAULT NULL,
    `seller_email` varchar(255) DEFAULT NULL,
    `buyer_first_name` varchar(255) DEFAULT NULL,
    `buyer_last_name` varchar(255) DEFAULT NULL,
    `buyer_company` varchar(255) DEFAULT NULL,
    `buyer_company_vat` varchar(255) DEFAULT NULL,
    `buyer_company_number` varchar(255) DEFAULT NULL,
    `buyer_address` varchar(255) DEFAULT NULL,
    `buyer_city` varchar(255) DEFAULT NULL,
    `buyer_state` varchar(255) DEFAULT NULL,
    `buyer_country` varchar(255) DEFAULT NULL,
    `buyer_zip` varchar(255) DEFAULT NULL,
    `buyer_phone` varchar(255) DEFAULT NULL,
    `buyer_phone_cc` varchar(255) DEFAULT NULL,
    `buyer_email` varchar(255) DEFAULT NULL,
    `gateway_id` int(11) DEFAULT NULL,
    `approved` tinyint(1) DEFAULT '0',
    `taxname` varchar(255) DEFAULT NULL,
    `taxrate` varchar(35) DEFAULT NULL,
    `due_at` datetime DEFAULT NULL,
    `reminded_at` datetime DEFAULT NULL,
    `paid_at` datetime DEFAULT NULL,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `hash` (`hash`),
    KEY `client_id_idx` (`client_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `invoice_item`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `invoice_item` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `invoice_id` bigint(20) DEFAULT NULL,
    `type` varchar(100) DEFAULT NULL,
    `rel_id` text,
    `task` varchar(100) DEFAULT NULL,
    `status` varchar(100) DEFAULT NULL,
    `title` varchar(255) DEFAULT NULL,
    `period` varchar(10) DEFAULT NULL,
    `quantity` bigint(20) DEFAULT NULL,
    `unit` varchar(100) DEFAULT NULL,
    `price` double(18,2) DEFAULT NULL,
    `charged` tinyint(1) DEFAULT '0',
    `taxed` tinyint(1) DEFAULT '0',
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `invoice_id_idx` (`invoice_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `kb_article`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `kb_article` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `kb_article_category_id` bigint(20) DEFAULT NULL,
    `views` int(11) DEFAULT '0',
    `title` varchar(100) DEFAULT NULL,
    `content` text,
    `slug` varchar(255) DEFAULT NULL,
    `status` varchar(30) DEFAULT 'active' COMMENT 'active, draft',
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `slug` (`slug`),
    KEY `kb_article_category_id_idx` (`kb_article_category_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `kb_article_category`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `kb_article_category` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `title` varchar(100) DEFAULT NULL,
    `description` text,
    `slug` varchar(255) DEFAULT NULL,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `slug` (`slug`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `mod_email_queue`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `mod_email_queue` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `to` varchar(255) NOT NULL,
    `from` varchar(255) NOT NULL,
    `subject` varchar(255) NOT NULL,
    `content` text NOT NULL,
    `to_name` varchar(255) DEFAULT NULL,
    `from_name` varchar(255) DEFAULT NULL,
    `client_id` int(11) DEFAULT NULL,
    `admin_id` int(11) DEFAULT NULL,
    `priority` int(11) DEFAULT NULL,
    `tries` int(11) NOT NULL,
    `status` varchar(20) NOT NULL,
    `created_at` datetime NOT NULL,
    `updated_at` datetime NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `mod_massmailer`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `mod_massmailer` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `from_email` varchar(255) DEFAULT NULL,
    `from_name` varchar(255) DEFAULT NULL,
    `subject` varchar(255) DEFAULT NULL,
    `content` text,
    `filter` text,
    `status` varchar(255) DEFAULT NULL,
    `sent_at` datetime DEFAULT NULL,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `pay_gateway`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `pay_gateway` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `name` varchar(255) DEFAULT NULL,
    `gateway` varchar(255) DEFAULT NULL,
    `accepted_currencies` text,
    `enabled` tinyint(1) DEFAULT '1',
    `allow_single` tinyint(1) DEFAULT '1',
    `allow_recurrent` tinyint(1) DEFAULT '1',
    `test_mode` tinyint(1) DEFAULT '0',
    `config` text,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `post`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `post` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `admin_id` bigint(20) DEFAULT NULL,
    `title` varchar(255) DEFAULT NULL,
    `content` text,
    `slug` varchar(255) DEFAULT NULL,
    `status` varchar(30) DEFAULT 'draft' COMMENT 'active, draft',
    `image` varchar(255) DEFAULT NULL,
    `section` varchar(255) DEFAULT NULL,
    `publish_at` datetime DEFAULT NULL,
    `published_at` datetime DEFAULT NULL,
    `expires_at` datetime DEFAULT NULL,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `slug` (`slug`),
    KEY `admin_id_idx` (`admin_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `product`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `product` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `product_category_id` bigint(20) DEFAULT NULL,
    `product_payment_id` bigint(20) DEFAULT NULL,
    `form_id` bigint(20) DEFAULT NULL,
    `title` varchar(255) DEFAULT NULL,
    `slug` varchar(255) DEFAULT NULL,
    `description` text,
    `unit` varchar(50) DEFAULT 'product',
    `active` tinyint(1) DEFAULT '1',
    `status` varchar(50) DEFAULT 'enabled' COMMENT 'enabled, disabled',
    `hidden` tinyint(1) DEFAULT '0',
    `is_addon` tinyint(1) DEFAULT '0',
    `setup` varchar(50) DEFAULT 'after_payment',
    `addons` text,
    `icon_url` varchar(255) DEFAULT NULL,
    `allow_quantity_select` tinyint(1) DEFAULT '0',
    `stock_control` tinyint(1) DEFAULT '0',
    `quantity_in_stock` int(11) DEFAULT '0',
    `plugin` varchar(255) DEFAULT NULL,
    `plugin_config` text,
    `upgrades` text,
    `priority` bigint(20) DEFAULT NULL,
    `config` text,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    `type` varchar(255) DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `slug` (`slug`),
    KEY `product_type_idx` (`type`),
    KEY `product_category_id_idx` (`product_category_id`),
    KEY `product_payment_id_idx` (`product_payment_id`),
    KEY `form_id_idx` (`form_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `product_category`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `product_category` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `title` varchar(100) DEFAULT NULL,
    `description` text,
    `icon_url` varchar(255) DEFAULT NULL,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `product_payment`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `product_payment` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `type` varchar(30) DEFAULT NULL COMMENT 'free, once, recurrent',
    `once_price` decimal(18,2) DEFAULT '0.00',
    `once_setup_price` decimal(18,2) DEFAULT '0.00',
    `w_price` decimal(18,2) DEFAULT '0.00',
    `m_price` decimal(18,2) DEFAULT '0.00',
    `q_price` decimal(18,2) DEFAULT '0.00',
    `b_price` decimal(18,2) DEFAULT '0.00',
    `a_price` decimal(18,2) DEFAULT '0.00',
    `bia_price` decimal(18,2) DEFAULT '0.00',
    `tria_price` decimal(18,2) DEFAULT '0.00',
    `w_setup_price` decimal(18,2) DEFAULT '0.00',
    `m_setup_price` decimal(18,2) DEFAULT '0.00',
    `q_setup_price` decimal(18,2) DEFAULT '0.00',
    `b_setup_price` decimal(18,2) DEFAULT '0.00',
    `a_setup_price` decimal(18,2) DEFAULT '0.00',
    `bia_setup_price` decimal(18,2) DEFAULT '0.00',
    `tria_setup_price` decimal(18,2) DEFAULT '0.00',
    `w_enabled` tinyint(1) DEFAULT '1',
    `m_enabled` tinyint(1) DEFAULT '1',
    `q_enabled` tinyint(1) DEFAULT '1',
    `b_enabled` tinyint(1) DEFAULT '1',
    `a_enabled` tinyint(1) DEFAULT '1',
    `bia_enabled` tinyint(1) DEFAULT '1',
    `tria_enabled` tinyint(1) DEFAULT '1',
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `promo`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `promo` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `code` varchar(100) DEFAULT NULL,
    `description` text,
    `type` varchar(30) NOT NULL DEFAULT 'percentage' COMMENT 'absolute, percentage, trial',
    `value` decimal(18,2) DEFAULT NULL,
    `maxuses` int(11) DEFAULT '0',
    `used` int(11) DEFAULT '0',
    `freesetup` tinyint(1) DEFAULT '0',
    `once_per_client` tinyint(1) DEFAULT '0',
    `recurring` tinyint(1) DEFAULT '0',
    `active` tinyint(1) DEFAULT '0',
    `products` text,
    `periods` text,
    `client_groups` text,
    `start_at` datetime DEFAULT NULL,
    `end_at` datetime DEFAULT NULL,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `start_index_idx` (`start_at`),
    KEY `end_index_idx` (`end_at`),
    KEY `active_index_idx` (`active`),
    KEY `code_index_idx` (`code`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `queue`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `queue` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `name` varchar(100) DEFAULT NULL,
    `mod` varchar(255) DEFAULT NULL,
    `timeout` bigint(20) DEFAULT NULL,
    `iteration` int(10) DEFAULT NULL,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `queue_message`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `queue_message` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `queue_id` bigint(20) DEFAULT NULL,
    `handle` char(32) DEFAULT NULL,
    `handler` varchar(255) DEFAULT NULL,
    `body` longblob,
    `hash` char(32) DEFAULT NULL,
    `timeout` double(18,2) DEFAULT NULL,
    `log` text,
    `execute_at` datetime DEFAULT NULL,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `queue_id_idx` (`queue_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `service_boxbillinglicense`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `service_boxbillinglicense` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `client_id` bigint(20) DEFAULT NULL,
    `oid` varchar(255) DEFAULT NULL,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `oid` (`oid`),
    KEY `client_id_idx` (`client_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `service_custom`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `service_custom` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `client_id` bigint(20) DEFAULT NULL,
    `plugin` varchar(255) DEFAULT NULL,
    `plugin_config` text,
    `f1` text,
    `f2` text,
    `f3` text,
    `f4` text,
    `f5` text,
    `f6` text,
    `f7` text,
    `f8` text,
    `f9` text,
    `f10` text,
    `config` text,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `client_id_idx` (`client_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `service_domain`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `service_domain` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `client_id` bigint(20) DEFAULT NULL,
    `tld_registrar_id` bigint(20) DEFAULT NULL,
    `sld` varchar(255) DEFAULT NULL,
    `tld` varchar(100) DEFAULT NULL,
    `ns1` varchar(255) DEFAULT NULL,
    `ns2` varchar(255) DEFAULT NULL,
    `ns3` varchar(255) DEFAULT NULL,
    `ns4` varchar(255) DEFAULT NULL,
    `period` int(11) DEFAULT NULL,
    `privacy` int(11) DEFAULT NULL,
    `locked` tinyint(1) DEFAULT '1',
    `transfer_code` varchar(255) DEFAULT NULL,
    `action` varchar(30) DEFAULT NULL,
    `contact_email` varchar(255) DEFAULT NULL,
    `contact_company` varchar(255) DEFAULT NULL,
    `contact_first_name` varchar(255) DEFAULT NULL,
    `contact_last_name` varchar(255) DEFAULT NULL,
    `contact_address1` varchar(255) DEFAULT NULL,
    `contact_address2` varchar(255) DEFAULT NULL,
    `contact_city` varchar(255) DEFAULT NULL,
    `contact_state` varchar(255) DEFAULT NULL,
    `contact_postcode` varchar(255) DEFAULT NULL,
    `contact_country` varchar(255) DEFAULT NULL,
    `contact_phone_cc` varchar(255) DEFAULT NULL,
    `contact_phone` varchar(255) DEFAULT NULL,
    `details` text,
    `synced_at` datetime DEFAULT NULL,
    `registered_at` datetime DEFAULT NULL,
    `expires_at` datetime DEFAULT NULL,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `client_id_idx` (`client_id`),
    KEY `tld_registrar_id_idx` (`tld_registrar_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `service_downloadable`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `service_downloadable` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `client_id` bigint(20) DEFAULT NULL,
    `filename` varchar(100) DEFAULT NULL,
    `downloads` int(11) DEFAULT NULL,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `client_id_idx` (`client_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `service_hosting`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `service_hosting` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `client_id` bigint(20) DEFAULT NULL,
    `service_hosting_server_id` bigint(20) DEFAULT NULL,
    `service_hosting_hp_id` bigint(20) DEFAULT NULL,
    `sld` varchar(255) DEFAULT NULL,
    `tld` varchar(255) DEFAULT NULL,
    `ip` varchar(45) DEFAULT NULL,
    `username` varchar(255) DEFAULT NULL,
    `pass` varchar(255) DEFAULT NULL,
    `reseller` tinyint(1) DEFAULT NULL,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `client_id_idx` (`client_id`),
    KEY `service_hosting_server_id_idx` (`service_hosting_server_id`),
    KEY `service_hosting_hp_id_idx` (`service_hosting_hp_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `service_hosting_hp`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `service_hosting_hp` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `name` varchar(255) DEFAULT NULL,
    `quota` varchar(50) DEFAULT NULL,
    `bandwidth` varchar(50) DEFAULT NULL,
    `max_ftp` varchar(50) DEFAULT NULL,
    `max_sql` varchar(50) DEFAULT NULL,
    `max_pop` varchar(50) DEFAULT NULL,
    `max_sub` varchar(50) DEFAULT NULL,
    `max_park` varchar(50) DEFAULT NULL,
    `max_addon` varchar(50) DEFAULT NULL,
    `config` text,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `service_hosting_server`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `service_hosting_server` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `name` varchar(100) DEFAULT NULL,
    `ip` varchar(45) DEFAULT NULL,
    `hostname` varchar(100) DEFAULT NULL,
    `assigned_ips` text,
    `status_url` varchar(255) DEFAULT NULL,
    `active` tinyint(1) DEFAULT NULL,
    `max_accounts` bigint(20) DEFAULT NULL,
    `ns1` varchar(100) DEFAULT NULL,
    `ns2` varchar(100) DEFAULT NULL,
    `ns3` varchar(100) DEFAULT NULL,
    `ns4` varchar(100) DEFAULT NULL,
    `manager` varchar(100) DEFAULT NULL,
    `username` text,
    `password` text,
    `accesshash` text,
    `port` varchar(20) DEFAULT NULL,
    `config` text,
    `secure` tinyint(1) DEFAULT NULL,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `service_license`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `service_license` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `client_id` bigint(20) DEFAULT NULL,
    `license_key` varchar(255) DEFAULT NULL,
    `validate_ip` tinyint(1) DEFAULT '1',
    `validate_host` tinyint(1) DEFAULT '1',
    `validate_path` tinyint(1) DEFAULT '0',
    `validate_version` tinyint(1) DEFAULT '0',
    `ips` text,
    `hosts` text,
    `paths` text,
    `versions` text,
    `config` text,
    `plugin` varchar(255) DEFAULT NULL,
    `checked_at` datetime DEFAULT NULL,
    `pinged_at` datetime DEFAULT NULL,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `license_key` (`license_key`),
    KEY `client_id_idx` (`client_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `service_membership`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `service_membership` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `client_id` bigint(20) DEFAULT NULL,
    `config` text,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `client_id_idx` (`client_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `service_solusvm`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `service_solusvm` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `cluster_id` bigint(20) DEFAULT NULL,
    `client_id` bigint(20) DEFAULT NULL,
    `vserverid` varchar(255) DEFAULT NULL,
    `virtid` varchar(255) DEFAULT NULL,
    `nodeid` varchar(255) DEFAULT NULL,
    `type` varchar(255) DEFAULT NULL,
    `node` varchar(255) DEFAULT NULL,
    `nodegroup` varchar(255) DEFAULT NULL,
    `hostname` varchar(255) DEFAULT NULL,
    `rootpassword` varchar(255) DEFAULT NULL,
    `username` varchar(255) DEFAULT NULL,
    `plan` varchar(255) DEFAULT NULL,
    `template` varchar(255) DEFAULT NULL,
    `ips` varchar(255) DEFAULT NULL,
    `hvmt` varchar(255) DEFAULT NULL,
    `custommemory` varchar(255) DEFAULT NULL,
    `customdiskspace` varchar(255) DEFAULT NULL,
    `custombandwidth` varchar(255) DEFAULT NULL,
    `customcpu` varchar(255) DEFAULT NULL,
    `customextraip` varchar(255) DEFAULT NULL,
    `issuelicense` varchar(255) DEFAULT NULL,
    `mainipaddress` varchar(255) DEFAULT NULL,
    `extraipaddress` varchar(255) DEFAULT NULL,
    `consoleuser` varchar(255) DEFAULT NULL,
    `consolepassword` varchar(255) DEFAULT NULL,
    `config` text,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `client_id_idx` (`client_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `session`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `session` (
    `id` varchar(32) NOT NULL DEFAULT '',
    `modified_at` int(11) DEFAULT NULL,
    `content` text,
    UNIQUE KEY `unique_id` (`id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `setting`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `setting` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `param` varchar(255) DEFAULT NULL,
    `value` text,
    `public` tinyint(1) DEFAULT '0',
    `category` varchar(255) DEFAULT NULL,
    `hash` varchar(255) DEFAULT NULL,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `param` (`param`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `subscription`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `subscription` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `client_id` bigint(20) DEFAULT NULL,
    `pay_gateway_id` bigint(20) DEFAULT NULL,
    `sid` varchar(255) DEFAULT NULL,
    `rel_type` varchar(100) DEFAULT NULL,
    `rel_id` bigint(20) DEFAULT NULL,
    `period` varchar(255) DEFAULT NULL,
    `amount` double(18,2) DEFAULT NULL,
    `currency` varchar(50) DEFAULT NULL,
    `status` varchar(255) DEFAULT NULL,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `client_id_idx` (`client_id`),
    KEY `pay_gateway_id_idx` (`pay_gateway_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `support_helpdesk`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `support_helpdesk` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `name` varchar(255) DEFAULT NULL,
    `email` varchar(255) DEFAULT NULL,
    `close_after` smallint(6) DEFAULT '24',
    `can_reopen` tinyint(1) DEFAULT '0',
    `signature` text,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `support_p_ticket`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `support_p_ticket` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `hash` varchar(255) DEFAULT NULL,
    `author_name` varchar(255) DEFAULT NULL,
    `author_email` varchar(255) DEFAULT NULL,
    `subject` varchar(255) DEFAULT NULL,
    `status` varchar(30) DEFAULT 'open',
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `support_p_ticket_message`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `support_p_ticket_message` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `support_p_ticket_id` bigint(20) DEFAULT NULL,
    `admin_id` bigint(20) DEFAULT NULL COMMENT 'Filled when message author is admin',
    `content` text,
    `ip` varchar(45) DEFAULT NULL,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `support_p_ticket_id_idx` (`support_p_ticket_id`),
    KEY `admin_id_idx` (`admin_id`),
    FULLTEXT KEY `content_idx` (`content`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `support_pr`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `support_pr` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `support_pr_category_id` bigint(20) DEFAULT NULL,
    `title` varchar(100) DEFAULT NULL,
    `content` text,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `support_pr_category_id_idx` (`support_pr_category_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `support_pr_category`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `support_pr_category` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `title` varchar(100) DEFAULT NULL,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `support_ticket`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `support_ticket` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `support_helpdesk_id` bigint(20) DEFAULT NULL,
    `client_id` bigint(20) DEFAULT NULL,
    `priority` int(11) DEFAULT '100',
    `subject` varchar(255) DEFAULT NULL,
    `status` varchar(30) DEFAULT 'open' COMMENT 'open, closed, on_hold',
    `rel_type` varchar(100) DEFAULT NULL,
    `rel_id` bigint(20) DEFAULT NULL,
    `rel_task` varchar(100) DEFAULT NULL,
    `rel_new_value` text,
    `rel_status` varchar(100) DEFAULT NULL,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `support_helpdesk_id_idx` (`support_helpdesk_id`),
    KEY `client_id_idx` (`client_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `support_ticket_message`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `support_ticket_message` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `support_ticket_id` bigint(20) DEFAULT NULL,
    `client_id` bigint(20) DEFAULT NULL,
    `admin_id` bigint(20) DEFAULT NULL,
    `content` text,
    `attachment` varchar(255) DEFAULT NULL,
    `ip` varchar(45) DEFAULT NULL,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `support_ticket_id_idx` (`support_ticket_id`),
    KEY `client_id_idx` (`client_id`),
    KEY `admin_id_idx` (`admin_id`),
    FULLTEXT KEY `content_idx` (`content`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `support_ticket_note`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `support_ticket_note` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `support_ticket_id` bigint(20) DEFAULT NULL,
    `admin_id` bigint(20) DEFAULT NULL,
    `note` text,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `support_ticket_id_idx` (`support_ticket_id`),
    KEY `admin_id_idx` (`admin_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `tax`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `tax` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `level` bigint(20) DEFAULT NULL,
    `name` varchar(255) DEFAULT NULL,
    `country` varchar(255) DEFAULT NULL,
    `state` varchar(255) DEFAULT NULL,
    `taxrate` varchar(255) DEFAULT NULL,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `tld`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `tld` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `tld_registrar_id` bigint(20) DEFAULT NULL,
    `tld` varchar(15) DEFAULT NULL,
    `price_registration` decimal(18,2) DEFAULT '0.00',
    `price_renew` decimal(18,2) DEFAULT '0.00',
    `price_transfer` decimal(18,2) DEFAULT '0.00',
    `allow_register` tinyint(1) DEFAULT NULL,
    `allow_transfer` tinyint(1) DEFAULT NULL,
    `active` tinyint(1) DEFAULT '1',
    `min_years` tinyint(4) DEFAULT NULL,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `tld` (`tld`),
    KEY `tld_registrar_id_idx` (`tld_registrar_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `tld_registrar`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `tld_registrar` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `name` varchar(255) DEFAULT NULL,
    `registrar` varchar(255) DEFAULT NULL,
    `test_mode` tinyint(4) DEFAULT '0',
    `config` text,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `transaction`
  --
  
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `transaction` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `invoice_id` bigint(20) DEFAULT NULL,
    `gateway_id` int(11) DEFAULT NULL,
    `txn_id` varchar(255) DEFAULT NULL,
    `txn_status` varchar(255) DEFAULT NULL,
    `s_id` varchar(255) DEFAULT NULL,
    `s_period` varchar(255) DEFAULT NULL,
    `amount` varchar(255) DEFAULT NULL,
    `currency` varchar(10) DEFAULT NULL,
    `type` varchar(255) DEFAULT NULL,
    `status` varchar(255) DEFAULT 'received',
    `ip` varchar(45) DEFAULT NULL,
    `error` text,
    `error_code` int(11) DEFAULT NULL,
    `validate_ipn` tinyint(1) DEFAULT '1',
    `ipn` text,
    `output` text,
    `note` text,
    `created_at` datetime DEFAULT NULL,
    `updated_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `invoice_id_idx` (`invoice_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  
  /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  /*!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 */;
  /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  
  -- Dump completed on 2014-09-19 15:00:47
  