/* DUPLICATOR-LITE (MYSQL-DUMP BUILD MODE) MYSQL SCRIPT CREATED ON : 2021-06-29 00:09:01 */

CREATE TABLE `wpbi_commentmeta` (
  `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `comment_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  `meta_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_value` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`meta_id`),
  KEY `comment_id` (`comment_id`),
  KEY `meta_key` (`meta_key`(191))
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `wpbi_comments` (
  `comment_ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `comment_post_ID` bigint(20) unsigned NOT NULL DEFAULT 0,
  `comment_author` tinytext COLLATE utf8mb4_unicode_ci NOT NULL,
  `comment_author_email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `comment_author_url` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `comment_author_IP` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `comment_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `comment_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `comment_content` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `comment_karma` int(11) NOT NULL DEFAULT 0,
  `comment_approved` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `comment_agent` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `comment_type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'comment',
  `comment_parent` bigint(20) unsigned NOT NULL DEFAULT 0,
  `user_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`comment_ID`),
  KEY `comment_post_ID` (`comment_post_ID`),
  KEY `comment_approved_date_gmt` (`comment_approved`,`comment_date_gmt`),
  KEY `comment_date_gmt` (`comment_date_gmt`),
  KEY `comment_parent` (`comment_parent`),
  KEY `comment_author_email` (`comment_author_email`(10))
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `wpbi_crm_log` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `object_id` mediumint(9) NOT NULL,
  `object_type` varchar(11) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` mediumint(9) NOT NULL,
  `action` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `attribute` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `msgno` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_to` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_from` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subject` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `text` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_references` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `time` datetime DEFAULT NULL,
  `other` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `wpbi_crm_log_meta` (
  `meta_id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `message_id` mediumint(9) NOT NULL,
  `meta_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_group` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_value` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  UNIQUE KEY `id` (`meta_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `wpbi_erp_ac_banks` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `ledger_id` int(10) unsigned DEFAULT NULL,
  `account_number` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `bank_name` varchar(30) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ledger_id` (`ledger_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

INSERT INTO `wpbi_erp_ac_banks` VALUES (1,7,'',''),(2,62,'012345689','ABC Bank');
CREATE TABLE `wpbi_erp_ac_chart_classes` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

INSERT INTO `wpbi_erp_ac_chart_classes` VALUES (1,'Assets'),(2,'Liabilities'),(3,'Expenses'),(4,'Income'),(5,'Equity');
CREATE TABLE `wpbi_erp_ac_chart_types` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(60) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `class_id` tinyint(3) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `class_id` (`class_id`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

INSERT INTO `wpbi_erp_ac_chart_types` VALUES (1,'Current Asset',1),(2,'Fixed Asset',1),(3,'Inventory',1),(4,'Non-current Asset',1),(5,'Prepayment',1),(6,'Bank & Cash',1),(7,'Current Liability',2),(8,'Liability',2),(9,'Non-current Liability',2),(10,'Depreciation',3),(11,'Direct Costs',3),(12,'Expense',3),(13,'Revenue',4),(14,'Sales',4),(15,'Other Income',4),(16,'Equity',5);
CREATE TABLE `wpbi_erp_ac_journals` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `ledger_id` int(11) unsigned NOT NULL,
  `transaction_id` bigint(20) unsigned NOT NULL,
  `type` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `debit` decimal(13,4) unsigned DEFAULT NULL,
  `credit` decimal(13,4) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ledger_id` (`ledger_id`),
  KEY `transaction_id` (`transaction_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

CREATE TABLE `wpbi_erp_ac_ledger` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(10) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `parent` int(11) unsigned NOT NULL DEFAULT 0,
  `type_id` int(3) unsigned NOT NULL DEFAULT 0,
  `currency` varchar(10) COLLATE utf8mb4_unicode_520_ci DEFAULT '',
  `tax` bigint(20) DEFAULT NULL,
  `cash_account` tinyint(2) unsigned NOT NULL DEFAULT 0,
  `reconcile` tinyint(2) unsigned NOT NULL DEFAULT 0,
  `system` tinyint(2) unsigned NOT NULL DEFAULT 0,
  `active` tinyint(2) unsigned NOT NULL DEFAULT 1,
  `created_by` bigint(20) DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `code` (`code`),
  KEY `type_id` (`type_id`),
  KEY `parent` (`parent`)
) ENGINE=MyISAM AUTO_INCREMENT=63 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

INSERT INTO `wpbi_erp_ac_ledger` VALUES (1,'120','Accounts Receivable',NULL,0,1,'',NULL,0,0,1,1,0),(2,'140','Inventory',NULL,0,3,'',NULL,0,0,1,1,0),(3,'150','Office Equipment',NULL,0,2,'',NULL,0,0,1,1,0),(4,'151','Less Accumulated Depreciation on Office Equipment',NULL,0,2,'',NULL,0,0,1,1,0),(5,'160','Computer Equipment',NULL,0,2,'',NULL,0,0,1,1,0),(6,'161','Less Accumulated Depreciation on Computer Equipment',NULL,0,2,'',NULL,0,0,1,1,0),(7,'090','Petty Cash',NULL,0,6,'',NULL,1,1,0,1,0),(8,'200','Accounts Payable',NULL,0,7,'',NULL,0,0,1,1,0),(9,'205','Accruals',NULL,0,7,'',NULL,0,0,0,1,0),(10,'210','Unpaid Expense Claims',NULL,0,7,'',NULL,0,0,1,1,0),(11,'215','Wages Payable',NULL,0,7,'',NULL,0,0,1,1,0),(12,'216','Wages Payable - Payroll',NULL,0,7,'',NULL,0,0,0,1,0),(13,'220','Sales Tax',NULL,0,7,'',NULL,0,0,1,1,0),(14,'230','Employee Tax Payable',NULL,0,7,'',NULL,0,0,0,1,0),(15,'235','Employee Benefits Payable',NULL,0,7,'',NULL,0,0,0,1,0),(16,'236','Employee Deductions payable',NULL,0,7,'',NULL,0,0,0,1,0),(17,'240','Income Tax Payable',NULL,0,7,'',NULL,0,0,0,1,0),(18,'250','Suspense',NULL,0,7,'',NULL,0,0,0,1,0),(19,'255','Historical Adjustments',NULL,0,7,'',NULL,0,0,1,1,0),(20,'260','Rounding',NULL,0,7,'',NULL,0,0,1,1,0),(21,'835','Revenue Received in Advance',NULL,0,7,'',NULL,0,0,0,1,0),(22,'855','Clearing Account',NULL,0,7,'',NULL,0,0,0,1,0),(23,'290','Loan',NULL,0,9,'',NULL,0,0,0,1,0),(24,'500','Costs of Goods Sold',NULL,0,11,'',NULL,0,0,1,1,0),(25,'600','Advertising',NULL,0,12,'',NULL,0,0,0,1,0),(26,'605','Bank Service Charges',NULL,0,12,'',NULL,0,0,0,1,0),(27,'610','Janitorial Expenses',NULL,0,12,'',NULL,0,0,0,1,0),(28,'615','Consulting & Accounting',NULL,0,12,'',NULL,0,0,0,1,0),(29,'620','Entertainment',NULL,0,12,'',NULL,0,0,0,1,0),(30,'624','Postage & Delivary',NULL,0,12,'',NULL,0,0,0,1,0),(31,'628','General Expenses',NULL,0,12,'',NULL,0,0,0,1,0),(32,'632','Insurance',NULL,0,12,'',NULL,0,0,0,1,0),(33,'636','Legal Expenses',NULL,0,12,'',NULL,0,0,0,1,0),(34,'640','Utilities',NULL,0,12,'',NULL,0,0,1,1,0),(35,'644','Automobile Expenses',NULL,0,12,'',NULL,0,0,0,1,0),(36,'648','Office Expenses',NULL,0,12,'',NULL,0,0,1,1,0),(37,'652','Printing & Stationary',NULL,0,12,'',NULL,0,0,0,1,0),(38,'656','Rent',NULL,0,12,'',NULL,0,0,1,1,0),(39,'660','Repairs & Maintenance',NULL,0,12,'',NULL,0,0,0,1,0),(40,'664','Wages & Salaries',NULL,0,12,'',NULL,0,0,0,1,0),(41,'668','Payroll Tax Expense',NULL,0,12,'',NULL,0,0,0,1,0),(42,'672','Dues & Subscriptions',NULL,0,12,'',NULL,0,0,0,1,0),(43,'676','Telephone & Internet',NULL,0,12,'',NULL,0,0,0,1,0),(44,'680','Travel',NULL,0,12,'',NULL,0,0,0,1,0),(45,'684','Bad Debts',NULL,0,12,'',NULL,0,0,0,1,0),(46,'700','Depreciation',NULL,0,10,'',NULL,0,0,1,1,0),(47,'710','Income Tax Expense',NULL,0,12,'',NULL,0,0,0,1,0),(48,'715','Employee Benefits Expense',NULL,0,12,'',NULL,0,0,0,1,0),(49,'800','Interest Expense',NULL,0,12,'',NULL,0,0,0,1,0),(50,'810','Bank Revaluations',NULL,0,12,'',NULL,0,0,1,1,0),(51,'815','Unrealized Currency Gains',NULL,0,12,'',NULL,0,0,1,1,0),(52,'820','Realized Currency Gains',NULL,0,12,'',NULL,0,0,1,1,0),(53,'825','Sales Discount',NULL,0,12,'',NULL,0,0,1,1,0),(54,'400','Sales',NULL,0,13,'',NULL,0,0,0,1,0),(55,'460','Interest Income',NULL,0,13,'',NULL,0,0,0,1,0),(56,'470','Other Revenue',NULL,0,13,'',NULL,0,0,0,1,0),(57,'475','Purchase Discount',NULL,0,13,'',NULL,0,0,1,1,0),(58,'300','Owners Contribution',NULL,0,16,'',NULL,0,0,0,1,0),(59,'310','Owners Draw',NULL,0,16,'',NULL,0,0,0,1,0),(60,'320','Retained Earnings',NULL,0,16,'',NULL,0,0,1,1,0),(61,'330','Common Stock',NULL,0,16,'',NULL,0,0,0,1,0),(62,'092','Savings Account',NULL,0,6,'',NULL,1,1,0,1,0);
CREATE TABLE `wpbi_erp_ac_payments` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `transaction_id` int(11) NOT NULL,
  `parent` int(11) NOT NULL,
  `child` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

CREATE TABLE `wpbi_erp_ac_tax` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `tax_number` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `is_compound` varchar(5) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `created_by` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

CREATE TABLE `wpbi_erp_ac_tax_items` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tax_id` bigint(20) NOT NULL,
  `component_name` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `agency_name` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `tax_rate` float NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

CREATE TABLE `wpbi_erp_ac_transaction_items` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `transaction_id` bigint(20) unsigned DEFAULT NULL,
  `journal_id` bigint(20) unsigned DEFAULT NULL,
  `product_id` int(10) unsigned DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `qty` decimal(10,2) unsigned NOT NULL DEFAULT 1.00,
  `unit_price` decimal(13,4) unsigned NOT NULL DEFAULT 0.0000,
  `discount` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `tax` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `tax_rate` decimal(13,4) NOT NULL,
  `tax_journal` bigint(20) NOT NULL,
  `line_total` decimal(13,4) unsigned NOT NULL DEFAULT 0.0000,
  `order` tinyint(3) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `transaction_id` (`transaction_id`),
  KEY `journal_id` (`journal_id`),
  KEY `product_id` (`product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

CREATE TABLE `wpbi_erp_ac_transactions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(10) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `form_type` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `status` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `billing_address` tinytext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `ref` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `summary` text COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `issue_date` date DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `currency` varchar(10) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `conversion_rate` decimal(2,2) unsigned DEFAULT NULL,
  `sub_total` decimal(13,4) DEFAULT 0.0000,
  `total` decimal(13,4) DEFAULT 0.0000,
  `due` decimal(13,4) unsigned DEFAULT 0.0000,
  `trans_total` decimal(13,4) DEFAULT 0.0000,
  `invoice_number` int(10) unsigned DEFAULT 0,
  `invoice_format` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `files` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `parent` bigint(20) unsigned NOT NULL DEFAULT 0,
  `created_by` int(11) unsigned DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `type` (`type`),
  KEY `status` (`status`),
  KEY `issue_date` (`issue_date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

CREATE TABLE `wpbi_erp_audit_log` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `component` varchar(50) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `sub_component` varchar(50) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `data_id` bigint(20) DEFAULT NULL,
  `old_value` longtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `new_value` longtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `message` longtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `changetype` varchar(10) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `component` (`component`),
  KEY `sub_component` (`sub_component`),
  KEY `changetype` (`changetype`),
  KEY `created_by` (`created_by`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

CREATE TABLE `wpbi_erp_company_locations` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int(11) unsigned DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `address_1` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `address_2` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `city` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `state` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `zip` int(6) DEFAULT NULL,
  `country` varchar(5) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `fax` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `phone` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `company_id` (`company_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

CREATE TABLE `wpbi_erp_crm_activities_task` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `activity_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `activity_id` (`activity_id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

CREATE TABLE `wpbi_erp_crm_contact_group` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `private` tinyint(1) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

CREATE TABLE `wpbi_erp_crm_contact_subscriber` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `group_id` int(11) DEFAULT NULL,
  `status` varchar(25) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `subscribe_at` datetime DEFAULT NULL,
  `unsubscribe_at` datetime DEFAULT NULL,
  `hash` varchar(40) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_group` (`user_id`,`group_id`),
  KEY `status` (`status`),
  KEY `hash` (`hash`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

CREATE TABLE `wpbi_erp_crm_customer_activities` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `message` longtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `email_subject` text COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `log_type` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `start_date` datetime DEFAULT NULL,
  `end_date` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `extra` longtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `sent_notification` tinyint(4) DEFAULT 0,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `type` (`type`(250)),
  KEY `log_type` (`log_type`(250)),
  KEY `created_by` (`created_by`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

CREATE TABLE `wpbi_erp_crm_customer_companies` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `customer_id` bigint(20) DEFAULT NULL,
  `company_id` bigint(50) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `customer_id` (`customer_id`),
  KEY `company_id` (`company_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

CREATE TABLE `wpbi_erp_crm_save_email_replies` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` text COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `subject` text COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `template` longtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

CREATE TABLE `wpbi_erp_crm_save_search` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `global` tinyint(4) DEFAULT 0,
  `search_name` text COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `search_val` text COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

CREATE TABLE `wpbi_erp_hr_announcement` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `post_id` bigint(11) NOT NULL,
  `status` varchar(30) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `email_status` varchar(30) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `post_id` (`post_id`),
  KEY `status` (`status`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

CREATE TABLE `wpbi_erp_hr_dependents` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `employee_id` int(11) DEFAULT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `relation` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `employee_id` (`employee_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

CREATE TABLE `wpbi_erp_hr_depts` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `description` text COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `lead` int(11) unsigned DEFAULT 0,
  `parent` int(11) unsigned DEFAULT 0,
  `status` tinyint(1) unsigned DEFAULT 1,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

CREATE TABLE `wpbi_erp_hr_designations` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `description` text COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `status` tinyint(1) DEFAULT 1,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

CREATE TABLE `wpbi_erp_hr_education` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `employee_id` int(11) unsigned DEFAULT NULL,
  `school` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `degree` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `field` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `finished` int(4) unsigned DEFAULT NULL,
  `notes` text COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `interest` text COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `employee_id` (`employee_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

CREATE TABLE `wpbi_erp_hr_employee_history` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  `module` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `category` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `type` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `comment` text COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `data` longtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `date` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `module` (`module`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

CREATE TABLE `wpbi_erp_hr_employee_notes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  `comment` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `comment_by` bigint(20) unsigned NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

CREATE TABLE `wpbi_erp_hr_employee_performance` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `employee_id` int(11) unsigned DEFAULT NULL,
  `reporting_to` int(11) unsigned DEFAULT NULL,
  `job_knowledge` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `work_quality` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `attendance` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `communication` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `dependablity` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `reviewer` int(11) unsigned DEFAULT NULL,
  `comments` text COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `completion_date` datetime DEFAULT NULL,
  `goal_description` text COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `employee_assessment` text COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `supervisor` int(11) unsigned DEFAULT NULL,
  `supervisor_assessment` text COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `type` text COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `performance_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `employee_id` (`employee_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

CREATE TABLE `wpbi_erp_hr_employees` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  `employee_id` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `designation` int(11) unsigned NOT NULL DEFAULT 0,
  `department` int(11) unsigned NOT NULL DEFAULT 0,
  `location` int(10) unsigned NOT NULL DEFAULT 0,
  `hiring_source` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `hiring_date` date NOT NULL,
  `termination_date` date NOT NULL,
  `date_of_birth` date NOT NULL,
  `reporting_to` bigint(20) unsigned NOT NULL DEFAULT 0,
  `pay_rate` int(11) unsigned NOT NULL DEFAULT 0,
  `pay_type` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `type` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `status` varchar(10) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `deleted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `employee_id` (`employee_id`),
  KEY `designation` (`designation`),
  KEY `department` (`department`),
  KEY `status` (`status`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

CREATE TABLE `wpbi_erp_hr_holiday` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `start` timestamp NOT NULL DEFAULT current_timestamp(),
  `end` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `description` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `range_status` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

CREATE TABLE `wpbi_erp_hr_leave_entitlements` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `policy_id` int(11) unsigned DEFAULT NULL,
  `days` mediumint(4) DEFAULT NULL,
  `from_date` datetime NOT NULL,
  `to_date` datetime NOT NULL,
  `comments` text COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `status` tinyint(2) unsigned NOT NULL,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `created_on` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `policy_id` (`policy_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

CREATE TABLE `wpbi_erp_hr_leave_policies` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `value` mediumint(5) DEFAULT NULL,
  `color` varchar(7) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `department` int(11) NOT NULL,
  `designation` int(11) NOT NULL,
  `gender` varchar(50) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `marital` varchar(50) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `location` int(3) NOT NULL,
  `effective_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `activate` int(2) NOT NULL,
  `execute_day` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

CREATE TABLE `wpbi_erp_hr_leave_requests` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `policy_id` int(11) unsigned NOT NULL,
  `days` tinyint(3) unsigned DEFAULT NULL,
  `start_date` datetime NOT NULL,
  `end_date` datetime NOT NULL,
  `comments` text COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `reason` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `status` tinyint(2) unsigned DEFAULT NULL,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `updated_by` bigint(20) unsigned DEFAULT NULL,
  `created_on` datetime NOT NULL,
  `updated_on` datetime DEFAULT NULL,
  `last_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `policy_id` (`policy_id`),
  KEY `status` (`status`),
  KEY `created_by` (`created_by`),
  KEY `updated_by` (`updated_by`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

CREATE TABLE `wpbi_erp_hr_leaves` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `request_id` bigint(20) unsigned NOT NULL,
  `date` date NOT NULL,
  `length_hours` decimal(6,2) unsigned NOT NULL,
  `length_days` decimal(6,2) NOT NULL,
  `start_time` time NOT NULL,
  `end_time` time NOT NULL,
  `duration_type` tinyint(4) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `request_id` (`request_id`),
  KEY `date` (`date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

CREATE TABLE `wpbi_erp_hr_work_exp` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `employee_id` int(11) DEFAULT NULL,
  `company_name` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `job_title` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `from` date DEFAULT NULL,
  `to` date DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `employee_id` (`employee_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

CREATE TABLE `wpbi_erp_people_type_relations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `people_id` bigint(20) unsigned DEFAULT NULL,
  `people_types_id` int(11) unsigned DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `people_id` (`people_id`),
  KEY `people_types_id` (`people_types_id`)
) ENGINE=MyISAM AUTO_INCREMENT=184 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

INSERT INTO `wpbi_erp_people_type_relations` VALUES (1,1,1,NULL),(2,2,1,NULL),(3,3,1,NULL),(4,4,1,NULL),(5,5,1,NULL),(6,6,1,NULL),(7,7,1,NULL),(8,8,1,NULL),(9,9,1,NULL),(10,10,1,NULL),(11,11,1,NULL),(12,12,1,NULL),(13,13,1,NULL),(14,14,1,NULL),(15,15,1,NULL),(16,16,1,NULL),(17,17,1,NULL),(18,18,1,NULL),(19,19,1,NULL),(20,20,1,NULL),(21,21,1,NULL),(22,22,1,NULL),(23,23,1,NULL),(24,24,1,NULL),(25,25,1,NULL),(26,26,1,NULL),(27,27,1,NULL),(28,28,1,NULL),(29,29,1,NULL),(30,30,1,NULL),(31,31,1,NULL),(32,32,1,NULL),(33,33,1,NULL),(34,34,1,NULL),(35,35,1,NULL),(36,36,1,NULL),(37,37,1,NULL),(38,38,1,NULL),(39,39,1,NULL),(40,40,1,NULL),(41,41,1,NULL),(42,42,1,NULL),(43,43,1,NULL),(44,44,1,NULL),(45,45,1,NULL),(46,46,1,NULL),(47,47,1,NULL),(48,48,1,NULL),(49,49,1,NULL),(50,50,1,NULL),(51,51,1,NULL),(52,52,1,NULL),(53,53,1,NULL),(54,54,1,NULL),(55,55,1,NULL),(56,56,1,NULL),(57,57,1,NULL),(58,58,1,NULL),(59,59,1,NULL),(60,60,1,NULL),(61,61,1,NULL),(62,62,1,NULL),(63,63,1,NULL),(64,64,1,NULL),(65,65,1,NULL),(66,66,1,NULL),(67,67,1,NULL),(68,68,1,NULL),(69,69,1,NULL),(70,70,1,NULL),(71,71,1,NULL),(72,72,1,NULL),(73,73,1,NULL),(74,74,1,NULL),(75,75,1,NULL),(76,76,1,NULL),(77,77,1,NULL),(78,78,1,NULL),(79,79,1,NULL),(80,80,1,NULL),(81,81,1,NULL),(82,82,1,NULL),(83,83,1,NULL),(84,84,1,NULL),(85,85,1,NULL),(86,86,1,NULL),(87,87,1,NULL),(88,88,1,NULL),(89,89,1,NULL),(90,90,1,NULL),(91,91,1,NULL),(92,92,1,NULL),(93,93,1,NULL),(94,94,1,NULL),(95,95,1,NULL),(96,96,1,NULL),(97,97,1,NULL),(98,98,1,NULL),(99,99,1,NULL),(100,100,1,NULL),(101,101,1,NULL),(102,102,1,NULL),(103,103,1,NULL),(104,104,1,NULL),(105,105,1,NULL),(106,106,1,NULL),(107,107,1,NULL),(108,108,1,NULL),(109,109,1,NULL),(110,110,1,NULL),(111,111,1,NULL),(112,112,1,NULL),(113,113,1,NULL),(114,114,1,NULL),(115,115,1,NULL),(116,116,1,NULL),(117,117,1,NULL),(118,118,1,NULL),(119,119,1,NULL),(120,120,1,NULL),(121,121,1,NULL),(122,122,1,NULL),(123,123,1,NULL),(124,124,1,NULL),(125,125,1,NULL),(126,126,1,NULL),(127,127,1,NULL),(128,128,1,NULL),(129,129,1,NULL),(130,130,1,NULL),(131,131,1,NULL),(132,132,1,NULL),(133,133,1,NULL),(134,134,1,NULL),(135,135,1,NULL),(136,136,1,NULL),(137,137,1,NULL),(138,138,1,NULL),(139,139,1,NULL),(140,140,1,NULL),(141,141,1,NULL),(142,142,1,NULL),(143,143,1,NULL),(144,144,1,NULL),(145,145,1,NULL),(146,146,1,NULL),(147,147,1,NULL),(148,148,1,NULL),(149,149,1,NULL),(150,150,1,NULL),(151,151,1,NULL),(152,152,1,NULL),(153,153,1,NULL),(154,154,1,NULL),(155,155,1,NULL),(156,156,1,NULL),(157,157,1,NULL),(158,158,1,NULL),(159,159,1,NULL),(160,160,1,NULL),(161,161,1,NULL),(162,162,1,NULL),(163,163,1,NULL),(164,164,1,NULL),(165,165,1,NULL),(166,166,1,NULL),(167,167,1,NULL),(168,168,1,NULL),(169,169,1,NULL),(170,170,1,NULL),(171,171,1,NULL),(172,172,1,NULL),(173,173,1,NULL),(174,174,1,NULL),(175,175,1,NULL),(176,176,1,NULL),(177,177,1,NULL),(178,178,1,NULL),(179,179,1,NULL),(180,180,1,NULL),(181,181,1,NULL),(182,182,1,NULL),(183,183,1,NULL);
CREATE TABLE `wpbi_erp_people_types` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

INSERT INTO `wpbi_erp_people_types` VALUES (1,'contact'),(2,'company'),(3,'customer'),(4,'vendor');
CREATE TABLE `wpbi_erp_peoplemeta` (
  `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `erp_people_id` bigint(20) DEFAULT NULL,
  `meta_key` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `meta_value` longtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  PRIMARY KEY (`meta_id`),
  KEY `erp_people_id` (`erp_people_id`),
  KEY `meta_key` (`meta_key`(191))
) ENGINE=MyISAM AUTO_INCREMENT=184 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

INSERT INTO `wpbi_erp_peoplemeta` VALUES (1,1,'contact_owner','1'),(2,2,'contact_owner','1'),(3,3,'contact_owner','1'),(4,4,'contact_owner','1'),(5,5,'contact_owner','1'),(6,6,'contact_owner','1'),(7,7,'contact_owner','1'),(8,8,'contact_owner','1'),(9,9,'contact_owner','1'),(10,10,'contact_owner','1'),(11,11,'contact_owner','1'),(12,12,'contact_owner','1'),(13,13,'contact_owner','1'),(14,14,'contact_owner','1'),(15,15,'contact_owner','1'),(16,16,'contact_owner','1'),(17,17,'contact_owner','1'),(18,18,'contact_owner','1'),(19,19,'contact_owner','1'),(20,20,'contact_owner','1'),(21,21,'contact_owner','1'),(22,22,'contact_owner','1'),(23,23,'contact_owner','1'),(24,24,'contact_owner','1'),(25,25,'contact_owner','1'),(26,26,'contact_owner','1'),(27,27,'contact_owner','1'),(28,28,'contact_owner','1'),(29,29,'contact_owner','1'),(30,30,'contact_owner','1'),(31,31,'contact_owner','1'),(32,32,'contact_owner','1'),(33,33,'contact_owner','1'),(34,34,'contact_owner','1'),(35,35,'contact_owner','1'),(36,36,'contact_owner','1'),(37,37,'contact_owner','1'),(38,38,'contact_owner','1'),(39,39,'contact_owner','1'),(40,40,'contact_owner','1'),(41,41,'contact_owner','1'),(42,42,'contact_owner','1'),(43,43,'contact_owner','1'),(44,44,'contact_owner','1'),(45,45,'contact_owner','1'),(46,46,'contact_owner','1'),(47,47,'contact_owner','1'),(48,48,'contact_owner','1'),(49,49,'contact_owner','1'),(50,50,'contact_owner','1'),(51,51,'contact_owner','1'),(52,52,'contact_owner','1'),(53,53,'contact_owner','1'),(54,54,'contact_owner','1'),(55,55,'contact_owner','1'),(56,56,'contact_owner','1'),(57,57,'contact_owner','1'),(58,58,'contact_owner','1'),(59,59,'contact_owner','1'),(60,60,'contact_owner','1'),(61,61,'contact_owner','1'),(62,62,'contact_owner','1'),(63,63,'contact_owner','1'),(64,64,'contact_owner','1'),(65,65,'contact_owner','1'),(66,66,'contact_owner','1'),(67,67,'contact_owner','1'),(68,68,'contact_owner','1'),(69,69,'contact_owner','1'),(70,70,'contact_owner','1'),(71,71,'contact_owner','1'),(72,72,'contact_owner','1'),(73,73,'contact_owner','1'),(74,74,'contact_owner','1'),(75,75,'contact_owner','1'),(76,76,'contact_owner','1'),(77,77,'contact_owner','1'),(78,78,'contact_owner','1'),(79,79,'contact_owner','1'),(80,80,'contact_owner','1'),(81,81,'contact_owner','1'),(82,82,'contact_owner','1'),(83,83,'contact_owner','1'),(84,84,'contact_owner','1'),(85,85,'contact_owner','1'),(86,86,'contact_owner','1'),(87,87,'contact_owner','1'),(88,88,'contact_owner','1'),(89,89,'contact_owner','1'),(90,90,'contact_owner','1'),(91,91,'contact_owner','1'),(92,92,'contact_owner','1'),(93,93,'contact_owner','1'),(94,94,'contact_owner','1'),(95,95,'contact_owner','1'),(96,96,'contact_owner','1'),(97,97,'contact_owner','1'),(98,98,'contact_owner','1'),(99,99,'contact_owner','1'),(100,100,'contact_owner','1'),(101,101,'contact_owner','1'),(102,102,'contact_owner','1'),(103,103,'contact_owner','1'),(104,104,'contact_owner','1'),(105,105,'contact_owner','1'),(106,106,'contact_owner','1'),(107,107,'contact_owner','1'),(108,108,'contact_owner','1'),(109,109,'contact_owner','1'),(110,110,'contact_owner','1'),(111,111,'contact_owner','1'),(112,112,'contact_owner','1'),(113,113,'contact_owner','1'),(114,114,'contact_owner','1'),(115,115,'contact_owner','1'),(116,116,'contact_owner','1'),(117,117,'contact_owner','1'),(118,118,'contact_owner','1'),(119,119,'contact_owner','1'),(120,120,'contact_owner','1'),(121,121,'contact_owner','1'),(122,122,'contact_owner','1'),(123,123,'contact_owner','1'),(124,124,'contact_owner','1'),(125,125,'contact_owner','1'),(126,126,'contact_owner','1'),(127,127,'contact_owner','1'),(128,128,'contact_owner','1'),(129,129,'contact_owner','1'),(130,130,'contact_owner','1'),(131,131,'contact_owner','1'),(132,132,'contact_owner','1'),(133,133,'contact_owner','1'),(134,134,'contact_owner','1'),(135,135,'contact_owner','1'),(136,136,'contact_owner','1'),(137,137,'contact_owner','1'),(138,138,'contact_owner','1'),(139,139,'contact_owner','1'),(140,140,'contact_owner','1'),(141,141,'contact_owner','1'),(142,142,'contact_owner','1'),(143,143,'contact_owner','1'),(144,144,'contact_owner','1'),(145,145,'contact_owner','1'),(146,146,'contact_owner','1'),(147,147,'contact_owner','1'),(148,148,'contact_owner','1'),(149,149,'contact_owner','1'),(150,150,'contact_owner','1'),(151,151,'contact_owner','1'),(152,152,'contact_owner','1'),(153,153,'contact_owner','1'),(154,154,'contact_owner','1'),(155,155,'contact_owner','1'),(156,156,'contact_owner','1'),(157,157,'contact_owner','1'),(158,158,'contact_owner','1'),(159,159,'contact_owner','1'),(160,160,'contact_owner','1'),(161,161,'contact_owner','1'),(162,162,'contact_owner','1'),(163,163,'contact_owner','1'),(164,164,'contact_owner','1'),(165,165,'contact_owner','1'),(166,166,'contact_owner','1'),(167,167,'contact_owner','1'),(168,168,'contact_owner','1'),(169,169,'contact_owner','1'),(170,170,'contact_owner','1'),(171,171,'contact_owner','1'),(172,172,'contact_owner','1'),(173,173,'contact_owner','1'),(174,174,'contact_owner','1'),(175,175,'contact_owner','1'),(176,176,'contact_owner','1'),(177,177,'contact_owner','1'),(178,178,'contact_owner','1'),(179,179,'contact_owner','1'),(180,180,'contact_owner','1'),(181,181,'contact_owner','1'),(182,182,'contact_owner','1'),(183,183,'contact_owner','1');
CREATE TABLE `wpbi_links` (
  `link_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `link_url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `link_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `link_image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `link_target` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `link_description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `link_visible` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Y',
  `link_owner` bigint(20) unsigned NOT NULL DEFAULT 1,
  `link_rating` int(11) NOT NULL DEFAULT 0,
  `link_updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `link_rel` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `link_notes` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `link_rss` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`link_id`),
  KEY `link_visible` (`link_visible`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `wpbi_litespeed_img_optm` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `post_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  `optm_status` tinyint(4) NOT NULL DEFAULT 0,
  `src` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `src_filesize` int(11) NOT NULL DEFAULT 0,
  `target_filesize` int(11) NOT NULL DEFAULT 0,
  `webp_filesize` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `post_id` (`post_id`),
  KEY `optm_status` (`optm_status`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `wpbi_options` (
  `option_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `option_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `option_value` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `autoload` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'yes',
  PRIMARY KEY (`option_id`),
  UNIQUE KEY `option_name` (`option_name`),
  KEY `autoload` (`autoload`)
) ENGINE=MyISAM AUTO_INCREMENT=21175 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


CREATE TABLE `wpbi_postmeta` (
  `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `post_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  `meta_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_value` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`meta_id`),
  KEY `post_id` (`post_id`),
  KEY `meta_key` (`meta_key`(191))
) ENGINE=MyISAM AUTO_INCREMENT=283 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `wpbi_postmeta` VALUES (256,136,'panels_data','a:3:{s:7:\"widgets\";a:5:{i:0;a:6:{s:6:\"frames\";a:1:{i:0;a:4:{s:7:\"content\";s:329:\"<p><a href=\"#myHeader\"><img class=\"alignnone wp-image-104 size-medium\" src=\"https://fpsteam.ca/wp-content/uploads/2018/10/Fossey-Professional-Services_final-300x100.png\" alt=\"\" width=\"300\" height=\"100\" /></a></p>\n<p>&nbsp;</p>\n<h1><strong>EXPERT SUPPORT FOR BUSINESS OWNERS</strong></h1>\n<p>[buttons]</p>\n<h1 id=\"myHeader\"></h1>\n\";s:23:\"content_selected_editor\";s:7:\"tinymce\";s:7:\"buttons\";a:2:{i:0;a:1:{s:6:\"button\";a:6:{s:4:\"text\";s:12:\"Client Login\";s:3:\"url\";s:31:\"https://fpsteam.ca/wp-login.php\";s:10:\"new_window\";b:1;s:11:\"button_icon\";a:5:{s:13:\"icon_selected\";s:30:\"fontawesome-arrow-circle-right\";s:10:\"icon_color\";b:0;s:4:\"icon\";i:0;s:14:\"icon_placement\";s:4:\"left\";s:24:\"so_field_container_state\";s:6:\"closed\";}s:6:\"design\";a:11:{s:5:\"width\";b:0;s:10:\"width_unit\";s:2:\"px\";s:5:\"theme\";s:4:\"wire\";s:12:\"button_color\";s:7:\"#ffffff\";s:10:\"text_color\";s:7:\"#333333\";s:5:\"hover\";b:1;s:4:\"font\";s:7:\"default\";s:9:\"font_size\";s:4:\"1.45\";s:8:\"rounding\";s:1:\"0\";s:7:\"padding\";s:1:\"1\";s:24:\"so_field_container_state\";s:6:\"closed\";}s:10:\"attributes\";a:6:{s:2:\"id\";s:0:\"\";s:7:\"classes\";s:0:\"\";s:5:\"title\";s:19:\"anchor_clientbutton\";s:7:\"onclick\";s:0:\"\";s:3:\"rel\";s:0:\"\";s:24:\"so_field_container_state\";s:6:\"closed\";}}}i:1;a:1:{s:6:\"button\";a:6:{s:4:\"text\";s:10:\"Learn More\";s:3:\"url\";s:9:\"#myHeader\";s:11:\"button_icon\";a:5:{s:13:\"icon_selected\";s:29:\"fontawesome-arrow-circle-down\";s:10:\"icon_color\";b:0;s:4:\"icon\";i:0;s:14:\"icon_placement\";s:4:\"left\";s:24:\"so_field_container_state\";s:4:\"open\";}s:6:\"design\";a:11:{s:5:\"width\";b:0;s:10:\"width_unit\";s:2:\"px\";s:5:\"theme\";s:4:\"wire\";s:12:\"button_color\";s:7:\"#ffffff\";s:10:\"text_color\";s:7:\"#333333\";s:5:\"hover\";b:1;s:4:\"font\";s:7:\"default\";s:9:\"font_size\";s:4:\"1.45\";s:8:\"rounding\";s:1:\"0\";s:7:\"padding\";s:1:\"1\";s:24:\"so_field_container_state\";s:4:\"open\";}s:10:\"attributes\";a:6:{s:2:\"id\";s:0:\"\";s:7:\"classes\";s:0:\"\";s:5:\"title\";s:0:\"\";s:7:\"onclick\";s:0:\"\";s:3:\"rel\";s:0:\"\";s:24:\"so_field_container_state\";s:6:\"closed\";}s:10:\"new_window\";b:0;}}}s:10:\"background\";a:10:{s:5:\"image\";i:132;s:14:\"image_fallback\";s:0:\"\";s:4:\"size\";s:4:\"full\";s:10:\"image_type\";s:5:\"cover\";s:7:\"opacity\";i:100;s:5:\"color\";s:7:\"#000000\";s:3:\"url\";s:0:\"\";s:24:\"so_field_container_state\";s:4:\"open\";s:10:\"new_window\";b:0;s:6:\"videos\";a:0:{}}}}s:8:\"controls\";a:7:{s:5:\"speed\";i:800;s:7:\"timeout\";i:8000;s:13:\"nav_color_hex\";s:7:\"#FFFFFF\";s:9:\"nav_style\";s:4:\"thin\";s:8:\"nav_size\";i:25;s:5:\"swipe\";b:1;s:24:\"so_field_container_state\";s:6:\"closed\";}s:6:\"design\";a:27:{s:6:\"height\";b:0;s:11:\"height_unit\";s:2:\"px\";s:17:\"height_responsive\";b:0;s:22:\"height_responsive_unit\";s:2:\"px\";s:7:\"padding\";s:3:\"13%\";s:12:\"padding_unit\";s:1:\"%\";s:17:\"extra_top_padding\";s:3:\"0px\";s:22:\"extra_top_padding_unit\";s:2:\"px\";s:13:\"padding_sides\";s:4:\"10px\";s:18:\"padding_sides_unit\";s:2:\"px\";s:5:\"width\";s:4:\"100%\";s:10:\"width_unit\";s:1:\"%\";s:12:\"heading_font\";s:0:\"\";s:13:\"heading_color\";s:7:\"#FFFFFF\";s:12:\"heading_size\";s:4:\"68px\";s:17:\"heading_size_unit\";s:2:\"px\";s:7:\"fittext\";b:1;s:18:\"fittext_compressor\";i:1;s:14:\"heading_shadow\";i:0;s:10:\"text_color\";s:7:\"#ffffff\";s:9:\"text_size\";s:4:\"32px\";s:14:\"text_size_unit\";s:2:\"px\";s:9:\"text_font\";s:0:\"\";s:11:\"text_shadow\";i:0;s:10:\"link_color\";b:0;s:16:\"link_color_hover\";b:0;s:24:\"so_field_container_state\";s:4:\"open\";}s:12:\"_sow_form_id\";s:13:\"57cb2735b5fb1\";s:19:\"_sow_form_timestamp\";s:13:\"1540077858746\";s:11:\"panels_info\";a:7:{s:5:\"class\";s:29:\"SiteOrigin_Widget_Hero_Widget\";s:3:\"raw\";b:0;s:4:\"grid\";i:0;s:4:\"cell\";i:0;s:2:\"id\";i:0;s:9:\"widget_id\";s:36:\"38b9b6d1-86b7-4f14-a7d1-612150a1ee05\";s:5:\"style\";a:4:{s:7:\"padding\";s:15:\"1mm 1mm 1mm 1mm\";s:27:\"background_image_attachment\";b:0;s:18:\"background_display\";s:5:\"cover\";s:6:\"margin\";s:15:\"0px 0px 0px 0px\";}}}i:1;a:9:{s:8:\"headline\";a:15:{s:4:\"text\";s:23:\"Which is YOUR mountain?\";s:15:\"destination_url\";s:0:\"\";s:3:\"tag\";s:2:\"h1\";s:5:\"color\";s:7:\"#333333\";s:11:\"hover_color\";b:0;s:4:\"font\";s:7:\"default\";s:9:\"font_size\";s:5:\"2.5em\";s:14:\"font_size_unit\";s:2:\"em\";s:5:\"align\";s:6:\"center\";s:11:\"line_height\";b:0;s:16:\"line_height_unit\";s:2:\"px\";s:6:\"margin\";b:0;s:11:\"margin_unit\";s:2:\"px\";s:24:\"so_field_container_state\";s:4:\"open\";s:10:\"new_window\";b:0;}s:12:\"sub_headline\";a:15:{s:4:\"text\";s:0:\"\";s:15:\"destination_url\";s:0:\"\";s:3:\"tag\";s:1:\"p\";s:5:\"color\";b:0;s:11:\"hover_color\";b:0;s:4:\"font\";s:7:\"default\";s:9:\"font_size\";b:0;s:14:\"font_size_unit\";s:2:\"px\";s:5:\"align\";s:6:\"center\";s:11:\"line_height\";s:3:\"0px\";s:16:\"line_height_unit\";s:2:\"px\";s:6:\"margin\";s:3:\"0px\";s:11:\"margin_unit\";s:2:\"px\";s:24:\"so_field_container_state\";s:4:\"open\";s:10:\"new_window\";b:0;}s:7:\"divider\";a:9:{s:5:\"style\";s:5:\"solid\";s:5:\"color\";s:7:\"#333333\";s:9:\"thickness\";i:1;s:5:\"align\";s:6:\"center\";s:5:\"width\";s:3:\"30%\";s:10:\"width_unit\";s:1:\"%\";s:6:\"margin\";s:4:\"15px\";s:11:\"margin_unit\";s:2:\"px\";s:24:\"so_field_container_state\";s:4:\"open\";}s:5:\"order\";a:3:{i:0;s:8:\"headline\";i:1;s:7:\"divider\";i:2;s:12:\"sub_headline\";}s:18:\"fittext_compressor\";i:0;s:12:\"_sow_form_id\";s:13:\"57cbb8c9398ed\";s:19:\"_sow_form_timestamp\";s:13:\"1540077915765\";s:7:\"fittext\";b:0;s:11:\"panels_info\";a:7:{s:5:\"class\";s:33:\"SiteOrigin_Widget_Headline_Widget\";s:3:\"raw\";b:0;s:4:\"grid\";i:1;s:4:\"cell\";i:0;s:2:\"id\";i:1;s:9:\"widget_id\";s:36:\"14276889-5fc0-43cb-b745-6bb250526053\";s:5:\"style\";a:3:{s:2:\"id\";s:8:\"anchor02\";s:27:\"background_image_attachment\";b:0;s:18:\"background_display\";s:4:\"tile\";}}}i:2;a:16:{s:8:\"features\";a:6:{i:0;a:12:{s:15:\"container_color\";s:7:\"#404040\";s:18:\"container_position\";s:3:\"top\";s:4:\"icon\";s:18:\"elegantline-puzzle\";s:10:\"icon_title\";s:0:\"\";s:10:\"icon_color\";s:7:\"#333333\";s:10:\"icon_image\";i:0;s:15:\"icon_image_size\";s:4:\"full\";s:5:\"title\";s:15:\"I need systems.\";s:4:\"text\";s:79:\"<p>We get your processes set up without special software or hiring people.</p>\n\";s:20:\"text_selected_editor\";s:7:\"tinymce\";s:9:\"more_text\";s:0:\"\";s:8:\"more_url\";s:0:\"\";}i:1;a:12:{s:15:\"container_color\";s:7:\"#404040\";s:18:\"container_position\";s:3:\"top\";s:4:\"icon\";s:21:\"elegantline-telescope\";s:10:\"icon_title\";s:0:\"\";s:10:\"icon_color\";s:7:\"#333333\";s:10:\"icon_image\";i:0;s:15:\"icon_image_size\";s:4:\"full\";s:5:\"title\";s:26:\"My vision is still bigger.\";s:4:\"text\";s:70:\"<p>We create the cadence and systems to let you grow sustainably.</p>\n\";s:20:\"text_selected_editor\";s:7:\"tinymce\";s:9:\"more_text\";s:0:\"\";s:8:\"more_url\";s:0:\"\";}i:2;a:12:{s:15:\"container_color\";s:7:\"#404040\";s:18:\"container_position\";s:3:\"top\";s:4:\"icon\";s:20:\"elegantline-strategy\";s:10:\"icon_title\";s:0:\"\";s:10:\"icon_color\";s:7:\"#333333\";s:10:\"icon_image\";i:0;s:15:\"icon_image_size\";s:4:\"full\";s:5:\"title\";s:28:\"I need to focus my managers.\";s:4:\"text\";s:69:\"<p>We bring clarity and set up dashboards that create alignment.</p>\n\";s:20:\"text_selected_editor\";s:7:\"tinymce\";s:9:\"more_text\";s:0:\"\";s:8:\"more_url\";s:0:\"\";}i:3;a:12:{s:15:\"container_color\";s:7:\"#404040\";s:18:\"container_position\";s:3:\"top\";s:4:\"icon\";s:17:\"elegantline-heart\";s:10:\"icon_title\";s:0:\"\";s:10:\"icon_color\";s:7:\"#333333\";s:10:\"icon_image\";i:0;s:15:\"icon_image_size\";s:4:\"full\";s:5:\"title\";s:23:\"I need a champion team.\";s:4:\"text\";s:77:\"<p>We establish goals that make sense and get everyone working together.</p>\n\";s:20:\"text_selected_editor\";s:7:\"tinymce\";s:9:\"more_text\";s:0:\"\";s:8:\"more_url\";s:0:\"\";}i:4;a:12:{s:15:\"container_color\";s:7:\"#404040\";s:18:\"container_position\";s:3:\"top\";s:4:\"icon\";s:18:\"elegantline-global\";s:10:\"icon_title\";s:0:\"\";s:10:\"icon_color\";s:7:\"#333333\";s:10:\"icon_image\";i:0;s:15:\"icon_image_size\";s:4:\"full\";s:5:\"title\";s:22:\"A complex opportunity.\";s:4:\"text\";s:87:\"<p>We simplify customer requirements and make them practical, from ISO 9001 on up.</p>\n\";s:20:\"text_selected_editor\";s:7:\"tinymce\";s:9:\"more_text\";s:0:\"\";s:8:\"more_url\";s:0:\"\";}i:5;a:12:{s:15:\"container_color\";s:7:\"#404040\";s:18:\"container_position\";s:3:\"top\";s:4:\"icon\";s:17:\"elegantline-clock\";s:10:\"icon_title\";s:0:\"\";s:10:\"icon_color\";s:7:\"#333333\";s:10:\"icon_image\";i:0;s:15:\"icon_image_size\";s:4:\"full\";s:5:\"title\";s:21:\"My family forgets me.\";s:4:\"text\";s:96:\"<p>We move companies from owner-driven to well-oiled machine and improve work/life balance.</p>\n\";s:20:\"text_selected_editor\";s:7:\"tinymce\";s:9:\"more_text\";s:0:\"\";s:8:\"more_url\";s:0:\"\";}}s:5:\"fonts\";a:4:{s:13:\"title_options\";a:5:{s:4:\"font\";s:7:\"default\";s:4:\"size\";s:5:\"1.4em\";s:9:\"size_unit\";s:2:\"em\";s:5:\"color\";b:0;s:24:\"so_field_container_state\";s:6:\"closed\";}s:12:\"text_options\";a:5:{s:4:\"font\";s:7:\"default\";s:4:\"size\";b:0;s:9:\"size_unit\";s:2:\"px\";s:5:\"color\";b:0;s:24:\"so_field_container_state\";s:6:\"closed\";}s:17:\"more_text_options\";a:5:{s:4:\"font\";s:7:\"default\";s:4:\"size\";b:0;s:9:\"size_unit\";s:2:\"px\";s:5:\"color\";b:0;s:24:\"so_field_container_state\";s:6:\"closed\";}s:24:\"so_field_container_state\";s:6:\"closed\";}s:15:\"container_shape\";s:0:\"\";s:14:\"container_size\";s:4:\"84px\";s:19:\"container_size_unit\";s:2:\"px\";s:9:\"icon_size\";s:4:\"54px\";s:14:\"icon_size_unit\";s:2:\"px\";s:7:\"per_row\";i:3;s:10:\"responsive\";b:1;s:12:\"_sow_form_id\";s:13:\"57cbbe0b22b71\";s:19:\"_sow_form_timestamp\";s:13:\"1539999475742\";s:16:\"icon_size_custom\";b:0;s:10:\"title_link\";b:0;s:9:\"icon_link\";b:0;s:10:\"new_window\";b:0;s:11:\"panels_info\";a:7:{s:5:\"class\";s:33:\"SiteOrigin_Widget_Features_Widget\";s:3:\"raw\";b:0;s:4:\"grid\";i:1;s:4:\"cell\";i:0;s:2:\"id\";i:2;s:9:\"widget_id\";s:36:\"1f35ef63-f04f-4034-b284-80f77f72dc78\";s:5:\"style\";a:4:{s:2:\"id\";s:8:\"anchor01\";s:7:\"padding\";s:11:\"3% 3% 3% 3%\";s:27:\"background_image_attachment\";b:0;s:18:\"background_display\";s:4:\"tile\";}}}i:3;a:9:{s:5:\"title\";s:31:\"Would you like to get in touch?\";s:13:\"display_title\";b:1;s:8:\"settings\";a:13:{s:2:\"to\";s:23:\"steve.fossey@fpsteam.ca\";s:4:\"from\";s:23:\"steve.fossey@fpsteam.ca\";s:15:\"default_subject\";s:19:\"Information request\";s:14:\"subject_prefix\";s:0:\"\";s:15:\"success_message\";s:482:\"<p>Thank-you! your message has been received. We\'ll get back to you shortly.</p>\n<p>In the meantime, I have some slots over the next few weeks I have set aside for conversations about peoples\' businesses. If you\'d like to talk about your work we\'d be more than happy to set a few minutes aside - just click below to make an appointment. There are no fees associated with this service.</p>\n<p>https://workprogress.ca/businessconversation</p>\n<p>Best Regards,</p>\n<p>Steve Fossey</p>\n\";s:31:\"success_message_selected_editor\";s:7:\"tinymce\";s:11:\"submit_text\";s:15:\"Send my Message\";s:9:\"submit_id\";s:0:\"\";s:7:\"onclick\";s:0:\"\";s:24:\"required_field_indicator\";b:1;s:32:\"required_field_indicator_message\";s:33:\"Fields marked with * are required\";s:14:\"log_ip_address\";b:1;s:24:\"so_field_container_state\";s:4:\"open\";}s:6:\"fields\";a:3:{i:0;a:5:{s:4:\"type\";s:4:\"name\";s:5:\"label\";s:4:\"Name\";s:11:\"description\";s:0:\"\";s:8:\"required\";a:3:{s:8:\"required\";b:1;s:15:\"missing_message\";s:23:\"Please enter your name:\";s:24:\"so_field_container_state\";s:4:\"open\";}s:7:\"options\";a:0:{}}i:1;a:5:{s:4:\"type\";s:5:\"email\";s:5:\"label\";s:6:\"Email:\";s:11:\"description\";s:0:\"\";s:8:\"required\";a:3:{s:8:\"required\";b:1;s:15:\"missing_message\";s:34:\"Please enter a valid email address\";s:24:\"so_field_container_state\";s:4:\"open\";}s:7:\"options\";a:0:{}}i:2;a:5:{s:4:\"type\";s:8:\"textarea\";s:5:\"label\";s:64:\"What is your biggest current challenge and greatest opportunity?\";s:11:\"description\";s:0:\"\";s:8:\"required\";a:3:{s:8:\"required\";b:1;s:15:\"missing_message\";s:50:\"Hm, that was succinct... please write something...\";s:24:\"so_field_container_state\";s:4:\"open\";}s:7:\"options\";a:0:{}}}s:4:\"spam\";a:3:{s:9:\"recaptcha\";a:7:{s:8:\"site_key\";s:0:\"\";s:10:\"secret_key\";s:0:\"\";s:5:\"theme\";s:5:\"light\";s:4:\"type\";s:5:\"image\";s:4:\"size\";s:6:\"normal\";s:24:\"so_field_container_state\";s:6:\"closed\";s:11:\"use_captcha\";b:0;}s:7:\"akismet\";a:3:{s:11:\"spam_action\";s:5:\"error\";s:24:\"so_field_container_state\";s:6:\"closed\";s:11:\"use_akismet\";b:0;}s:24:\"so_field_container_state\";s:6:\"closed\";}s:6:\"design\";a:8:{s:9:\"container\";a:8:{s:10:\"background\";s:7:\"#f2f2f2\";s:7:\"padding\";s:4:\"10px\";s:12:\"padding_unit\";s:2:\"px\";s:12:\"border_color\";s:7:\"#c0c0c0\";s:12:\"border_width\";s:3:\"1px\";s:17:\"border_width_unit\";s:2:\"px\";s:12:\"border_style\";s:5:\"solid\";s:24:\"so_field_container_state\";s:4:\"open\";}s:6:\"labels\";a:9:{s:4:\"font\";s:7:\"default\";s:4:\"size\";b:0;s:9:\"size_unit\";s:2:\"px\";s:5:\"color\";b:0;s:8:\"position\";s:5:\"above\";s:5:\"width\";b:0;s:10:\"width_unit\";s:2:\"px\";s:5:\"align\";s:4:\"left\";s:24:\"so_field_container_state\";s:4:\"open\";}s:6:\"fields\";a:19:{s:4:\"font\";s:7:\"default\";s:9:\"font_size\";b:0;s:14:\"font_size_unit\";s:2:\"px\";s:5:\"color\";b:0;s:6:\"margin\";b:0;s:11:\"margin_unit\";s:2:\"px\";s:7:\"padding\";b:0;s:12:\"padding_unit\";s:2:\"px\";s:6:\"height\";b:0;s:11:\"height_unit\";s:2:\"px\";s:15:\"height_textarea\";b:0;s:20:\"height_textarea_unit\";s:2:\"px\";s:10:\"background\";b:0;s:12:\"border_color\";s:7:\"#c0c0c0\";s:12:\"border_width\";s:3:\"1px\";s:17:\"border_width_unit\";s:2:\"px\";s:12:\"border_style\";s:5:\"solid\";s:13:\"border_radius\";i:0;s:24:\"so_field_container_state\";s:4:\"open\";}s:12:\"descriptions\";a:5:{s:4:\"size\";s:5:\"0.9em\";s:9:\"size_unit\";s:2:\"em\";s:5:\"color\";s:7:\"#999999\";s:5:\"style\";s:6:\"italic\";s:24:\"so_field_container_state\";s:4:\"open\";}s:6:\"errors\";a:8:{s:10:\"background\";s:7:\"#fce4e5\";s:12:\"border_color\";s:7:\"#ec666a\";s:10:\"text_color\";s:7:\"#ec666a\";s:7:\"padding\";s:3:\"5px\";s:12:\"padding_unit\";s:2:\"px\";s:6:\"margin\";s:4:\"10px\";s:11:\"margin_unit\";s:2:\"px\";s:24:\"so_field_container_state\";s:4:\"open\";}s:6:\"submit\";a:19:{s:6:\"styled\";b:1;s:16:\"background_color\";s:7:\"#eeeeee\";s:19:\"background_gradient\";i:10;s:12:\"border_color\";s:7:\"#989a9c\";s:12:\"border_style\";s:5:\"solid\";s:12:\"border_width\";s:3:\"1px\";s:17:\"border_width_unit\";s:2:\"px\";s:13:\"border_radius\";i:3;s:10:\"text_color\";s:7:\"#5a5a5a\";s:9:\"font_size\";b:0;s:14:\"font_size_unit\";s:2:\"px\";s:6:\"weight\";s:3:\"500\";s:7:\"padding\";s:4:\"10px\";s:12:\"padding_unit\";s:2:\"px\";s:5:\"width\";b:0;s:10:\"width_unit\";s:2:\"px\";s:5:\"align\";s:4:\"left\";s:15:\"inset_highlight\";i:50;s:24:\"so_field_container_state\";s:4:\"open\";}s:5:\"focus\";a:5:{s:5:\"style\";s:5:\"solid\";s:5:\"color\";b:0;s:5:\"width\";s:3:\"1px\";s:10:\"width_unit\";s:2:\"px\";s:24:\"so_field_container_state\";s:4:\"open\";}s:24:\"so_field_container_state\";s:6:\"closed\";}s:12:\"_sow_form_id\";s:31:\"9722258515bc9348d2bbd4345462070\";s:19:\"_sow_form_timestamp\";s:13:\"1540077937327\";s:11:\"panels_info\";a:7:{s:5:\"class\";s:37:\"SiteOrigin_Widgets_ContactForm_Widget\";s:3:\"raw\";b:0;s:4:\"grid\";i:1;s:4:\"cell\";i:0;s:2:\"id\";i:3;s:9:\"widget_id\";s:36:\"4f80d28a-a9bb-4fbd-84e7-6edbbcdf6c3b\";s:5:\"style\";a:3:{s:27:\"background_image_attachment\";b:0;s:18:\"background_display\";s:4:\"tile\";s:12:\"border_color\";s:7:\"#000000\";}}}i:4;a:7:{s:5:\"title\";s:0:\"\";s:4:\"text\";s:193:\"Here\'s our <a href=\"https://fpsteam.ca/privacy-policy/\" target=\"_blank\" rel=\"noopener\">Privacy Policy</a> The summary is that we will not spam you or share your information with anyone, ever.\";s:6:\"filter\";b:1;s:6:\"visual\";b:1;s:2:\"id\";s:12:\"text-7410004\";s:11:\"option_name\";s:11:\"widget_text\";s:11:\"panels_info\";a:7:{s:5:\"class\";s:14:\"WP_Widget_Text\";s:3:\"raw\";b:0;s:4:\"grid\";i:1;s:4:\"cell\";i:0;s:2:\"id\";i:4;s:9:\"widget_id\";s:36:\"ff787d46-951d-4ede-82a4-40ba26521288\";s:5:\"style\";a:2:{s:27:\"background_image_attachment\";b:0;s:18:\"background_display\";s:4:\"tile\";}}}}s:5:\"grids\";a:2:{i:0;a:3:{s:5:\"cells\";i:1;s:5:\"style\";a:5:{s:27:\"background_image_attachment\";b:0;s:18:\"background_display\";s:4:\"tile\";s:13:\"bottom_margin\";s:3:\"0px\";s:11:\"row_stretch\";s:14:\"full-stretched\";s:14:\"cell_alignment\";s:10:\"flex-start\";}s:5:\"label\";s:11:\"Main Slider\";}i:1;a:4:{s:5:\"cells\";i:1;s:5:\"style\";a:8:{s:2:\"id\";s:8:\"services\";s:7:\"padding\";s:11:\"8% 5% 5% 5%\";s:14:\"mobile_padding\";s:16:\"45px 0px 0px 0px\";s:27:\"background_image_attachment\";b:0;s:18:\"background_display\";s:4:\"tile\";s:13:\"bottom_margin\";s:4:\"45px\";s:11:\"row_stretch\";s:4:\"full\";s:14:\"cell_alignment\";s:10:\"flex-start\";}s:11:\"color_label\";i:4;s:5:\"label\";s:12:\"Our Services\";}}s:10:\"grid_cells\";a:2:{i:0;a:4:{s:4:\"grid\";i:0;s:5:\"index\";i:0;s:6:\"weight\";i:1;s:5:\"style\";a:0:{}}i:1;a:4:{s:4:\"grid\";i:1;s:5:\"index\";i:0;s:6:\"weight\";i:1;s:5:\"style\";a:0:{}}}}'),(258,138,'panels_data','a:3:{s:7:\"widgets\";a:5:{i:0;a:6:{s:6:\"frames\";a:1:{i:0;a:4:{s:7:\"content\";s:329:\"<p><a href=\"#myHeader\"><img class=\"alignnone wp-image-104 size-medium\" src=\"https://fpsteam.ca/wp-content/uploads/2018/10/Fossey-Professional-Services_final-300x100.png\" alt=\"\" width=\"300\" height=\"100\" /></a></p>\n<p>&nbsp;</p>\n<h1><strong>EXPERT SUPPORT FOR BUSINESS OWNERS</strong></h1>\n<p>[buttons]</p>\n<h1 id=\"myHeader\"></h1>\n\";s:23:\"content_selected_editor\";s:7:\"tinymce\";s:7:\"buttons\";a:2:{i:0;a:1:{s:6:\"button\";a:6:{s:4:\"text\";s:12:\"Client Login\";s:3:\"url\";s:31:\"https://fpsteam.ca/wp-login.php\";s:10:\"new_window\";b:1;s:11:\"button_icon\";a:5:{s:13:\"icon_selected\";s:30:\"fontawesome-arrow-circle-right\";s:10:\"icon_color\";b:0;s:4:\"icon\";i:0;s:14:\"icon_placement\";s:4:\"left\";s:24:\"so_field_container_state\";s:6:\"closed\";}s:6:\"design\";a:11:{s:5:\"width\";b:0;s:10:\"width_unit\";s:2:\"px\";s:5:\"theme\";s:4:\"wire\";s:12:\"button_color\";s:7:\"#ffffff\";s:10:\"text_color\";s:7:\"#333333\";s:5:\"hover\";b:1;s:4:\"font\";s:7:\"default\";s:9:\"font_size\";s:4:\"1.45\";s:8:\"rounding\";s:1:\"0\";s:7:\"padding\";s:1:\"1\";s:24:\"so_field_container_state\";s:6:\"closed\";}s:10:\"attributes\";a:6:{s:2:\"id\";s:0:\"\";s:7:\"classes\";s:0:\"\";s:5:\"title\";s:19:\"anchor_clientbutton\";s:7:\"onclick\";s:0:\"\";s:3:\"rel\";s:0:\"\";s:24:\"so_field_container_state\";s:6:\"closed\";}}}i:1;a:1:{s:6:\"button\";a:6:{s:4:\"text\";s:10:\"Learn More\";s:3:\"url\";s:9:\"#myHeader\";s:11:\"button_icon\";a:5:{s:13:\"icon_selected\";s:29:\"fontawesome-arrow-circle-down\";s:10:\"icon_color\";b:0;s:4:\"icon\";i:0;s:14:\"icon_placement\";s:4:\"left\";s:24:\"so_field_container_state\";s:4:\"open\";}s:6:\"design\";a:11:{s:5:\"width\";b:0;s:10:\"width_unit\";s:2:\"px\";s:5:\"theme\";s:4:\"wire\";s:12:\"button_color\";s:7:\"#ffffff\";s:10:\"text_color\";s:7:\"#333333\";s:5:\"hover\";b:1;s:4:\"font\";s:7:\"default\";s:9:\"font_size\";s:4:\"1.45\";s:8:\"rounding\";s:1:\"0\";s:7:\"padding\";s:1:\"1\";s:24:\"so_field_container_state\";s:4:\"open\";}s:10:\"attributes\";a:6:{s:2:\"id\";s:0:\"\";s:7:\"classes\";s:0:\"\";s:5:\"title\";s:0:\"\";s:7:\"onclick\";s:0:\"\";s:3:\"rel\";s:0:\"\";s:24:\"so_field_container_state\";s:6:\"closed\";}s:10:\"new_window\";b:0;}}}s:10:\"background\";a:10:{s:5:\"image\";i:132;s:14:\"image_fallback\";s:0:\"\";s:4:\"size\";s:4:\"full\";s:10:\"image_type\";s:5:\"cover\";s:7:\"opacity\";i:100;s:5:\"color\";s:7:\"#000000\";s:3:\"url\";s:0:\"\";s:24:\"so_field_container_state\";s:4:\"open\";s:10:\"new_window\";b:0;s:6:\"videos\";a:0:{}}}}s:8:\"controls\";a:7:{s:5:\"speed\";i:800;s:7:\"timeout\";i:8000;s:13:\"nav_color_hex\";s:7:\"#FFFFFF\";s:9:\"nav_style\";s:4:\"thin\";s:8:\"nav_size\";i:25;s:5:\"swipe\";b:1;s:24:\"so_field_container_state\";s:6:\"closed\";}s:6:\"design\";a:27:{s:6:\"height\";b:0;s:11:\"height_unit\";s:2:\"px\";s:17:\"height_responsive\";b:0;s:22:\"height_responsive_unit\";s:2:\"px\";s:7:\"padding\";s:3:\"13%\";s:12:\"padding_unit\";s:1:\"%\";s:17:\"extra_top_padding\";s:3:\"0px\";s:22:\"extra_top_padding_unit\";s:2:\"px\";s:13:\"padding_sides\";s:4:\"10px\";s:18:\"padding_sides_unit\";s:2:\"px\";s:5:\"width\";s:4:\"100%\";s:10:\"width_unit\";s:1:\"%\";s:12:\"heading_font\";s:0:\"\";s:13:\"heading_color\";s:7:\"#FFFFFF\";s:12:\"heading_size\";s:4:\"68px\";s:17:\"heading_size_unit\";s:2:\"px\";s:7:\"fittext\";b:1;s:18:\"fittext_compressor\";i:1;s:14:\"heading_shadow\";i:0;s:10:\"text_color\";s:7:\"#ffffff\";s:9:\"text_size\";s:4:\"32px\";s:14:\"text_size_unit\";s:2:\"px\";s:9:\"text_font\";s:0:\"\";s:11:\"text_shadow\";i:0;s:10:\"link_color\";b:0;s:16:\"link_color_hover\";b:0;s:24:\"so_field_container_state\";s:4:\"open\";}s:12:\"_sow_form_id\";s:13:\"57cb2735b5fb1\";s:19:\"_sow_form_timestamp\";s:13:\"1540077858746\";s:11:\"panels_info\";a:8:{s:5:\"class\";s:29:\"SiteOrigin_Widget_Hero_Widget\";s:3:\"raw\";b:0;s:4:\"grid\";i:0;s:4:\"cell\";i:0;s:2:\"id\";i:0;s:9:\"widget_id\";s:36:\"38b9b6d1-86b7-4f14-a7d1-612150a1ee05\";s:5:\"style\";a:4:{s:7:\"padding\";s:15:\"1mm 1mm 1mm 1mm\";s:27:\"background_image_attachment\";b:0;s:18:\"background_display\";s:5:\"cover\";s:6:\"margin\";s:15:\"0px 0px 0px 0px\";}s:10:\"cell_index\";i:0;}}i:1;a:9:{s:8:\"headline\";a:15:{s:4:\"text\";s:23:\"Which is YOUR mountain?\";s:15:\"destination_url\";s:0:\"\";s:3:\"tag\";s:2:\"h1\";s:5:\"color\";s:7:\"#333333\";s:11:\"hover_color\";b:0;s:4:\"font\";s:7:\"default\";s:9:\"font_size\";s:5:\"2.5em\";s:14:\"font_size_unit\";s:2:\"em\";s:5:\"align\";s:6:\"center\";s:11:\"line_height\";b:0;s:16:\"line_height_unit\";s:2:\"px\";s:6:\"margin\";b:0;s:11:\"margin_unit\";s:2:\"px\";s:24:\"so_field_container_state\";s:4:\"open\";s:10:\"new_window\";b:0;}s:12:\"sub_headline\";a:15:{s:4:\"text\";s:0:\"\";s:15:\"destination_url\";s:0:\"\";s:3:\"tag\";s:1:\"p\";s:5:\"color\";b:0;s:11:\"hover_color\";b:0;s:4:\"font\";s:7:\"default\";s:9:\"font_size\";b:0;s:14:\"font_size_unit\";s:2:\"px\";s:5:\"align\";s:6:\"center\";s:11:\"line_height\";s:3:\"0px\";s:16:\"line_height_unit\";s:2:\"px\";s:6:\"margin\";s:3:\"0px\";s:11:\"margin_unit\";s:2:\"px\";s:24:\"so_field_container_state\";s:4:\"open\";s:10:\"new_window\";b:0;}s:7:\"divider\";a:9:{s:5:\"style\";s:5:\"solid\";s:5:\"color\";s:7:\"#333333\";s:9:\"thickness\";i:1;s:5:\"align\";s:6:\"center\";s:5:\"width\";s:3:\"30%\";s:10:\"width_unit\";s:1:\"%\";s:6:\"margin\";s:4:\"15px\";s:11:\"margin_unit\";s:2:\"px\";s:24:\"so_field_container_state\";s:4:\"open\";}s:5:\"order\";a:3:{i:0;s:8:\"headline\";i:1;s:7:\"divider\";i:2;s:12:\"sub_headline\";}s:18:\"fittext_compressor\";i:0;s:12:\"_sow_form_id\";s:13:\"57cbb8c9398ed\";s:19:\"_sow_form_timestamp\";s:13:\"1540077915765\";s:7:\"fittext\";b:0;s:11:\"panels_info\";a:8:{s:5:\"class\";s:33:\"SiteOrigin_Widget_Headline_Widget\";s:3:\"raw\";b:0;s:4:\"grid\";i:1;s:4:\"cell\";i:0;s:2:\"id\";i:1;s:9:\"widget_id\";s:36:\"14276889-5fc0-43cb-b745-6bb250526053\";s:5:\"style\";a:3:{s:2:\"id\";s:8:\"anchor02\";s:27:\"background_image_attachment\";b:0;s:18:\"background_display\";s:4:\"tile\";}s:10:\"cell_index\";i:0;}}i:2;a:16:{s:8:\"features\";a:6:{i:0;a:12:{s:15:\"container_color\";s:7:\"#404040\";s:18:\"container_position\";s:3:\"top\";s:4:\"icon\";s:18:\"elegantline-puzzle\";s:10:\"icon_title\";s:0:\"\";s:10:\"icon_color\";s:7:\"#333333\";s:10:\"icon_image\";i:0;s:15:\"icon_image_size\";s:4:\"full\";s:5:\"title\";s:15:\"I need systems.\";s:4:\"text\";s:79:\"<p>We get your processes set up without special software or hiring people.</p>\n\";s:20:\"text_selected_editor\";s:7:\"tinymce\";s:9:\"more_text\";s:0:\"\";s:8:\"more_url\";s:0:\"\";}i:1;a:12:{s:15:\"container_color\";s:7:\"#404040\";s:18:\"container_position\";s:3:\"top\";s:4:\"icon\";s:21:\"elegantline-telescope\";s:10:\"icon_title\";s:0:\"\";s:10:\"icon_color\";s:7:\"#333333\";s:10:\"icon_image\";i:0;s:15:\"icon_image_size\";s:4:\"full\";s:5:\"title\";s:26:\"My vision is still bigger.\";s:4:\"text\";s:70:\"<p>We create the cadence and systems to let you grow sustainably.</p>\n\";s:20:\"text_selected_editor\";s:7:\"tinymce\";s:9:\"more_text\";s:0:\"\";s:8:\"more_url\";s:0:\"\";}i:2;a:12:{s:15:\"container_color\";s:7:\"#404040\";s:18:\"container_position\";s:3:\"top\";s:4:\"icon\";s:20:\"elegantline-strategy\";s:10:\"icon_title\";s:0:\"\";s:10:\"icon_color\";s:7:\"#333333\";s:10:\"icon_image\";i:0;s:15:\"icon_image_size\";s:4:\"full\";s:5:\"title\";s:28:\"I need to focus my managers.\";s:4:\"text\";s:69:\"<p>We bring clarity and set up dashboards that create alignment.</p>\n\";s:20:\"text_selected_editor\";s:7:\"tinymce\";s:9:\"more_text\";s:0:\"\";s:8:\"more_url\";s:0:\"\";}i:3;a:12:{s:15:\"container_color\";s:7:\"#404040\";s:18:\"container_position\";s:3:\"top\";s:4:\"icon\";s:17:\"elegantline-heart\";s:10:\"icon_title\";s:0:\"\";s:10:\"icon_color\";s:7:\"#333333\";s:10:\"icon_image\";i:0;s:15:\"icon_image_size\";s:4:\"full\";s:5:\"title\";s:23:\"I need a champion team.\";s:4:\"text\";s:77:\"<p>We establish goals that make sense and get everyone working together.</p>\n\";s:20:\"text_selected_editor\";s:7:\"tinymce\";s:9:\"more_text\";s:0:\"\";s:8:\"more_url\";s:0:\"\";}i:4;a:12:{s:15:\"container_color\";s:7:\"#404040\";s:18:\"container_position\";s:3:\"top\";s:4:\"icon\";s:18:\"elegantline-global\";s:10:\"icon_title\";s:0:\"\";s:10:\"icon_color\";s:7:\"#333333\";s:10:\"icon_image\";i:0;s:15:\"icon_image_size\";s:4:\"full\";s:5:\"title\";s:22:\"A complex opportunity.\";s:4:\"text\";s:87:\"<p>We simplify customer requirements and make them practical, from ISO 9001 on up.</p>\n\";s:20:\"text_selected_editor\";s:7:\"tinymce\";s:9:\"more_text\";s:0:\"\";s:8:\"more_url\";s:0:\"\";}i:5;a:12:{s:15:\"container_color\";s:7:\"#404040\";s:18:\"container_position\";s:3:\"top\";s:4:\"icon\";s:17:\"elegantline-clock\";s:10:\"icon_title\";s:0:\"\";s:10:\"icon_color\";s:7:\"#333333\";s:10:\"icon_image\";i:0;s:15:\"icon_image_size\";s:4:\"full\";s:5:\"title\";s:21:\"My family forgets me.\";s:4:\"text\";s:96:\"<p>We move companies from owner-driven to well-oiled machine and improve work/life balance.</p>\n\";s:20:\"text_selected_editor\";s:7:\"tinymce\";s:9:\"more_text\";s:0:\"\";s:8:\"more_url\";s:0:\"\";}}s:5:\"fonts\";a:4:{s:13:\"title_options\";a:5:{s:4:\"font\";s:7:\"default\";s:4:\"size\";s:5:\"1.4em\";s:9:\"size_unit\";s:2:\"em\";s:5:\"color\";b:0;s:24:\"so_field_container_state\";s:6:\"closed\";}s:12:\"text_options\";a:5:{s:4:\"font\";s:7:\"default\";s:4:\"size\";b:0;s:9:\"size_unit\";s:2:\"px\";s:5:\"color\";b:0;s:24:\"so_field_container_state\";s:6:\"closed\";}s:17:\"more_text_options\";a:5:{s:4:\"font\";s:7:\"default\";s:4:\"size\";b:0;s:9:\"size_unit\";s:2:\"px\";s:5:\"color\";b:0;s:24:\"so_field_container_state\";s:6:\"closed\";}s:24:\"so_field_container_state\";s:6:\"closed\";}s:15:\"container_shape\";s:0:\"\";s:14:\"container_size\";s:4:\"84px\";s:19:\"container_size_unit\";s:2:\"px\";s:9:\"icon_size\";s:4:\"54px\";s:14:\"icon_size_unit\";s:2:\"px\";s:7:\"per_row\";i:3;s:10:\"responsive\";b:1;s:12:\"_sow_form_id\";s:13:\"57cbbe0b22b71\";s:19:\"_sow_form_timestamp\";s:13:\"1539999475742\";s:16:\"icon_size_custom\";b:0;s:10:\"title_link\";b:0;s:9:\"icon_link\";b:0;s:10:\"new_window\";b:0;s:11:\"panels_info\";a:8:{s:5:\"class\";s:33:\"SiteOrigin_Widget_Features_Widget\";s:3:\"raw\";b:0;s:4:\"grid\";i:1;s:4:\"cell\";i:0;s:2:\"id\";i:2;s:9:\"widget_id\";s:36:\"1f35ef63-f04f-4034-b284-80f77f72dc78\";s:5:\"style\";a:4:{s:2:\"id\";s:8:\"anchor01\";s:7:\"padding\";s:11:\"3% 3% 3% 3%\";s:27:\"background_image_attachment\";b:0;s:18:\"background_display\";s:4:\"tile\";}s:10:\"cell_index\";i:1;}}i:3;a:9:{s:5:\"title\";s:31:\"Would you like to get in touch?\";s:13:\"display_title\";b:1;s:8:\"settings\";a:13:{s:2:\"to\";s:23:\"steve.fossey@fpsteam.ca\";s:4:\"from\";s:23:\"steve.fossey@fpsteam.ca\";s:15:\"default_subject\";s:19:\"Information request\";s:14:\"subject_prefix\";s:0:\"\";s:15:\"success_message\";s:482:\"<p>Thank-you! your message has been received. We\'ll get back to you shortly.</p>\n<p>In the meantime, I have some slots over the next few weeks I have set aside for conversations about peoples\' businesses. If you\'d like to talk about your work we\'d be more than happy to set a few minutes aside - just click below to make an appointment. There are no fees associated with this service.</p>\n<p>https://workprogress.ca/businessconversation</p>\n<p>Best Regards,</p>\n<p>Steve Fossey</p>\n\";s:31:\"success_message_selected_editor\";s:7:\"tinymce\";s:11:\"submit_text\";s:15:\"Send my Message\";s:9:\"submit_id\";s:0:\"\";s:7:\"onclick\";s:0:\"\";s:24:\"required_field_indicator\";b:1;s:32:\"required_field_indicator_message\";s:33:\"Fields marked with * are required\";s:14:\"log_ip_address\";b:1;s:24:\"so_field_container_state\";s:4:\"open\";}s:6:\"fields\";a:3:{i:0;a:5:{s:4:\"type\";s:4:\"name\";s:5:\"label\";s:4:\"Name\";s:11:\"description\";s:0:\"\";s:8:\"required\";a:3:{s:8:\"required\";b:1;s:15:\"missing_message\";s:23:\"Please enter your name:\";s:24:\"so_field_container_state\";s:4:\"open\";}s:7:\"options\";a:0:{}}i:1;a:5:{s:4:\"type\";s:5:\"email\";s:5:\"label\";s:6:\"Email:\";s:11:\"description\";s:0:\"\";s:8:\"required\";a:3:{s:8:\"required\";b:1;s:15:\"missing_message\";s:34:\"Please enter a valid email address\";s:24:\"so_field_container_state\";s:4:\"open\";}s:7:\"options\";a:0:{}}i:2;a:5:{s:4:\"type\";s:8:\"textarea\";s:5:\"label\";s:64:\"What is your biggest current challenge and greatest opportunity?\";s:11:\"description\";s:0:\"\";s:8:\"required\";a:3:{s:8:\"required\";b:1;s:15:\"missing_message\";s:50:\"Hm, that was succinct... please write something...\";s:24:\"so_field_container_state\";s:4:\"open\";}s:7:\"options\";a:0:{}}}s:4:\"spam\";a:3:{s:9:\"recaptcha\";a:7:{s:8:\"site_key\";s:0:\"\";s:10:\"secret_key\";s:0:\"\";s:5:\"theme\";s:5:\"light\";s:4:\"type\";s:5:\"image\";s:4:\"size\";s:6:\"normal\";s:24:\"so_field_container_state\";s:6:\"closed\";s:11:\"use_captcha\";b:0;}s:7:\"akismet\";a:3:{s:11:\"spam_action\";s:5:\"error\";s:24:\"so_field_container_state\";s:6:\"closed\";s:11:\"use_akismet\";b:0;}s:24:\"so_field_container_state\";s:6:\"closed\";}s:6:\"design\";a:8:{s:9:\"container\";a:8:{s:10:\"background\";s:7:\"#f2f2f2\";s:7:\"padding\";s:4:\"10px\";s:12:\"padding_unit\";s:2:\"px\";s:12:\"border_color\";s:7:\"#c0c0c0\";s:12:\"border_width\";s:3:\"1px\";s:17:\"border_width_unit\";s:2:\"px\";s:12:\"border_style\";s:5:\"solid\";s:24:\"so_field_container_state\";s:4:\"open\";}s:6:\"labels\";a:9:{s:4:\"font\";s:7:\"default\";s:4:\"size\";b:0;s:9:\"size_unit\";s:2:\"px\";s:5:\"color\";b:0;s:8:\"position\";s:5:\"above\";s:5:\"width\";b:0;s:10:\"width_unit\";s:2:\"px\";s:5:\"align\";s:4:\"left\";s:24:\"so_field_container_state\";s:4:\"open\";}s:6:\"fields\";a:19:{s:4:\"font\";s:7:\"default\";s:9:\"font_size\";b:0;s:14:\"font_size_unit\";s:2:\"px\";s:5:\"color\";b:0;s:6:\"margin\";b:0;s:11:\"margin_unit\";s:2:\"px\";s:7:\"padding\";b:0;s:12:\"padding_unit\";s:2:\"px\";s:6:\"height\";b:0;s:11:\"height_unit\";s:2:\"px\";s:15:\"height_textarea\";b:0;s:20:\"height_textarea_unit\";s:2:\"px\";s:10:\"background\";b:0;s:12:\"border_color\";s:7:\"#c0c0c0\";s:12:\"border_width\";s:3:\"1px\";s:17:\"border_width_unit\";s:2:\"px\";s:12:\"border_style\";s:5:\"solid\";s:13:\"border_radius\";i:0;s:24:\"so_field_container_state\";s:4:\"open\";}s:12:\"descriptions\";a:5:{s:4:\"size\";s:5:\"0.9em\";s:9:\"size_unit\";s:2:\"em\";s:5:\"color\";s:7:\"#999999\";s:5:\"style\";s:6:\"italic\";s:24:\"so_field_container_state\";s:4:\"open\";}s:6:\"errors\";a:8:{s:10:\"background\";s:7:\"#fce4e5\";s:12:\"border_color\";s:7:\"#ec666a\";s:10:\"text_color\";s:7:\"#ec666a\";s:7:\"padding\";s:3:\"5px\";s:12:\"padding_unit\";s:2:\"px\";s:6:\"margin\";s:4:\"10px\";s:11:\"margin_unit\";s:2:\"px\";s:24:\"so_field_container_state\";s:4:\"open\";}s:6:\"submit\";a:19:{s:6:\"styled\";b:1;s:16:\"background_color\";s:7:\"#eeeeee\";s:19:\"background_gradient\";i:10;s:12:\"border_color\";s:7:\"#989a9c\";s:12:\"border_style\";s:5:\"solid\";s:12:\"border_width\";s:3:\"1px\";s:17:\"border_width_unit\";s:2:\"px\";s:13:\"border_radius\";i:3;s:10:\"text_color\";s:7:\"#5a5a5a\";s:9:\"font_size\";b:0;s:14:\"font_size_unit\";s:2:\"px\";s:6:\"weight\";s:3:\"500\";s:7:\"padding\";s:4:\"10px\";s:12:\"padding_unit\";s:2:\"px\";s:5:\"width\";b:0;s:10:\"width_unit\";s:2:\"px\";s:5:\"align\";s:4:\"left\";s:15:\"inset_highlight\";i:50;s:24:\"so_field_container_state\";s:4:\"open\";}s:5:\"focus\";a:5:{s:5:\"style\";s:5:\"solid\";s:5:\"color\";b:0;s:5:\"width\";s:3:\"1px\";s:10:\"width_unit\";s:2:\"px\";s:24:\"so_field_container_state\";s:4:\"open\";}s:24:\"so_field_container_state\";s:6:\"closed\";}s:12:\"_sow_form_id\";s:31:\"9722258515bc9348d2bbd4345462070\";s:19:\"_sow_form_timestamp\";s:13:\"1540077937327\";s:11:\"panels_info\";a:8:{s:5:\"class\";s:37:\"SiteOrigin_Widgets_ContactForm_Widget\";s:3:\"raw\";b:0;s:4:\"grid\";i:1;s:4:\"cell\";i:0;s:2:\"id\";i:3;s:9:\"widget_id\";s:36:\"4f80d28a-a9bb-4fbd-84e7-6edbbcdf6c3b\";s:5:\"style\";a:3:{s:27:\"background_image_attachment\";b:0;s:18:\"background_display\";s:4:\"tile\";s:12:\"border_color\";s:7:\"#000000\";}s:10:\"cell_index\";i:2;}}i:4;a:7:{s:5:\"title\";s:0:\"\";s:4:\"text\";s:193:\"Here\'s our <a href=\"https://fpsteam.ca/privacy-policy/\" target=\"_blank\" rel=\"noopener\">Privacy Policy</a> The summary is that we will not spam you or share your information with anyone, ever.\";s:6:\"filter\";b:1;s:6:\"visual\";b:1;s:2:\"id\";s:12:\"text-7410004\";s:11:\"option_name\";s:11:\"widget_text\";s:11:\"panels_info\";a:8:{s:5:\"class\";s:14:\"WP_Widget_Text\";s:3:\"raw\";b:0;s:4:\"grid\";i:1;s:4:\"cell\";i:0;s:2:\"id\";i:4;s:9:\"widget_id\";s:36:\"ff787d46-951d-4ede-82a4-40ba26521288\";s:5:\"style\";a:2:{s:27:\"background_image_attachment\";b:0;s:18:\"background_display\";s:4:\"tile\";}s:10:\"cell_index\";i:3;}}}s:5:\"grids\";a:2:{i:0;a:3:{s:5:\"cells\";i:1;s:5:\"style\";a:5:{s:27:\"background_image_attachment\";b:0;s:18:\"background_display\";s:4:\"tile\";s:13:\"bottom_margin\";s:3:\"0px\";s:11:\"row_stretch\";s:14:\"full-stretched\";s:14:\"cell_alignment\";s:10:\"flex-start\";}s:5:\"label\";s:11:\"Main Slider\";}i:1;a:4:{s:5:\"cells\";i:1;s:5:\"style\";a:8:{s:2:\"id\";s:8:\"services\";s:7:\"padding\";s:11:\"8% 5% 5% 5%\";s:14:\"mobile_padding\";s:16:\"45px 0px 0px 0px\";s:27:\"background_image_attachment\";b:0;s:18:\"background_display\";s:4:\"tile\";s:13:\"bottom_margin\";s:4:\"45px\";s:11:\"row_stretch\";s:4:\"full\";s:14:\"cell_alignment\";s:10:\"flex-start\";}s:11:\"color_label\";i:4;s:5:\"label\";s:12:\"Our Services\";}}s:10:\"grid_cells\";a:2:{i:0;a:4:{s:4:\"grid\";i:0;s:5:\"index\";i:0;s:6:\"weight\";i:1;s:5:\"style\";a:0:{}}i:1;a:4:{s:4:\"grid\";i:1;s:5:\"index\";i:0;s:6:\"weight\";i:1;s:5:\"style\";a:0:{}}}}');
CREATE TABLE `wpbi_term_relationships` (
  `object_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  `term_taxonomy_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  `term_order` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`object_id`,`term_taxonomy_id`),
  KEY `term_taxonomy_id` (`term_taxonomy_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `wpbi_term_taxonomy` (
  `term_taxonomy_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `term_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  `taxonomy` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `description` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `parent` bigint(20) unsigned NOT NULL DEFAULT 0,
  `count` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`term_taxonomy_id`),
  UNIQUE KEY `term_id_taxonomy` (`term_id`,`taxonomy`),
  KEY `taxonomy` (`taxonomy`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `wpbi_term_taxonomy` VALUES (1,1,'category','',0,0),(2,2,'nav_menu','',0,0);
CREATE TABLE `wpbi_termmeta` (
  `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `term_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  `meta_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_value` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`meta_id`),
  KEY `term_id` (`term_id`),
  KEY `meta_key` (`meta_key`(191))
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `wpbi_terms` (
  `term_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `slug` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `term_group` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`term_id`),
  KEY `slug` (`slug`(191)),
  KEY `name` (`name`(191))
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `wpbi_terms` VALUES (1,'Uncategorized','uncategorized',0),(2,'intentionally blank','intentionally-blank',0);
CREATE TABLE `wpbi_tm_taskmeta` (
  `meta_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `task_id` bigint(20) NOT NULL DEFAULT 0,
  `meta_key` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `meta_value` longtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  PRIMARY KEY (`meta_id`),
  KEY `meta_key` (`meta_key`(191)),
  KEY `task_id` (`task_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

CREATE TABLE `wpbi_tm_tasks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) NOT NULL,
  `type` varchar(300) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `class_identifier` varchar(300) COLLATE utf8mb4_unicode_520_ci DEFAULT '0',
  `attempts` int(11) DEFAULT 0,
  `description` varchar(300) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `time_created` timestamp NOT NULL DEFAULT current_timestamp(),
  `last_locked_at` bigint(20) DEFAULT 0,
  `status` varchar(300) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

CREATE TABLE `wpbi_upicrm_fields` (
  `field_id` int(11) NOT NULL AUTO_INCREMENT,
  `field_name` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
  PRIMARY KEY (`field_id`)
) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

INSERT INTO `wpbi_upicrm_fields` VALUES (1,'Name'),(2,'Last name'),(3,'Date'),(4,'Message subject'),(5,'Phone number mobile'),(6,'Phone number work'),(7,'Phone number'),(8,'Email'),(9,'Role'),(10,'Company'),(11,'Industry'),(12,'Website'),(13,'Product'),(14,'Service'),(15,'City'),(16,'Street'),(17,'Country'),(18,'Zip code'),(19,'Address'),(20,'Fax number'),(21,'Future contact allowed'),(22,'Message details/Remarks'),(23,'Received From');
CREATE TABLE `wpbi_upicrm_fields_mapping` (
  `fm_id` int(11) NOT NULL AUTO_INCREMENT,
  `field_id` int(11) NOT NULL,
  `fm_name` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `source_id` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `source_type` int(11) NOT NULL,
  PRIMARY KEY (`fm_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

CREATE TABLE `wpbi_upicrm_integrations` (
  `integration_id` int(11) NOT NULL AUTO_INCREMENT,
  `integration_domain` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `integration_clean_domain` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `integration_key` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `integration_status` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `integration_is_slave` int(1) DEFAULT NULL,
  PRIMARY KEY (`integration_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `wpbi_upicrm_leads` (
  `lead_id` int(11) NOT NULL AUTO_INCREMENT,
  `source_type` int(11) NOT NULL,
  `source_id` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `lead_content` text COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `user_ip` text COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `user_referer` text COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `old_user_lead_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `lead_status_id` int(11) NOT NULL,
  `lead_management_comment` text COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `time` timestamp NOT NULL DEFAULT current_timestamp(),
  `lead_webservice_transmission` varchar(300) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  PRIMARY KEY (`lead_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

CREATE TABLE `wpbi_upicrm_leads_campaign` (
  `lead_id` int(11) DEFAULT NULL,
  `utm_source` text COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `utm_medium` text COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `utm_term` text COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `utm_content` text COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `utm_campaign` text COLLATE utf8mb4_unicode_520_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

CREATE TABLE `wpbi_upicrm_leads_integration` (
  `lead_integration_id` int(11) NOT NULL AUTO_INCREMENT,
  `lead_id` int(11) NOT NULL,
  `lead_id_external` int(11) NOT NULL,
  `integration_id` int(11) NOT NULL,
  `lead_integration_status` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `integration_is_slave` int(1) NOT NULL,
  `lead_integration_error` int(1) NOT NULL,
  PRIMARY KEY (`lead_integration_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `wpbi_upicrm_leads_route` (
  `lead_route_id` int(11) NOT NULL AUTO_INCREMENT,
  `lead_route_option` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'content',
  `field_id` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `lead_route_type` int(11) NOT NULL,
  `lead_route_value` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `lead_route_and` tinyint(1) NOT NULL,
  `lead_route_option2` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'content',
  `field_id2` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `lead_route_type2` int(11) NOT NULL,
  `lead_route_value2` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `leads_route_rr_users` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `leads_route_rr_count` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `lead_status_id` int(11) NOT NULL,
  `change_field_id` int(11) NOT NULL,
  `change_field_value` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `webservice_id` int(11) NOT NULL,
  `mail_id` int(11) NOT NULL DEFAULT 0,
  `lead_route_email_to` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `lead_route_mail_to_field_id` text COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`lead_route_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `wpbi_upicrm_leads_status` (
  `lead_status_id` int(11) NOT NULL AUTO_INCREMENT,
  `lead_status_name` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  PRIMARY KEY (`lead_status_id`),
  UNIQUE KEY `lead_status_name` (`lead_status_name`),
  UNIQUE KEY `lead_status_name_2` (`lead_status_name`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

INSERT INTO `wpbi_upicrm_leads_status` VALUES (1,'Received'),(2,'Qualified'),(3,'Assigned'),(4,'In process'),(5,'Quote'),(6,'Closing'),(7,'Revenue'),(8,'Not relevant');
CREATE TABLE `wpbi_upicrm_mails` (
  `mail_id` int(11) NOT NULL AUTO_INCREMENT,
  `mail_event` text COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `mail_content` text COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `mail_subject` text COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `mail_cc` text COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `mail_event_name` text COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  PRIMARY KEY (`mail_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

INSERT INTO `wpbi_upicrm_mails` VALUES (1,'new_lead','[lead]','New Lead','','New Lead'),(2,'change_user','[lead]','Change User','','Change User'),(3,'change_lead_status','[lead]','Change Lead Status','','Change Lead Status'),(4,'request_status','[lead]','Request status update','','Request status update from lead owner');
CREATE TABLE `wpbi_upicrm_options` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `wpbi_upicrm_users` (
  `inside_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `user_parent_id` int(11) DEFAULT NULL,
  `user_label` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_permission` int(11) DEFAULT NULL,
  PRIMARY KEY (`inside_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `wpbi_upicrm_webservice` (
  `webservice_id` int(11) NOT NULL AUTO_INCREMENT,
  `webservice_method` int(11) NOT NULL,
  `webservice_status` int(11) NOT NULL,
  `webservice_url` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `webservice_charset` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'UTF-8',
  `webservice_log` int(1) NOT NULL,
  PRIMARY KEY (`webservice_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `wpbi_upicrm_webservice_parameters` (
  `webservice_parameter_id` int(11) NOT NULL AUTO_INCREMENT,
  `webservice_id` int(11) NOT NULL,
  `webservice_parameter_option` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'content',
  `field_id` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `webservice_parameter_value` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`webservice_parameter_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `wpbi_usermeta` (
  `umeta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  `meta_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_value` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`umeta_id`),
  KEY `user_id` (`user_id`),
  KEY `meta_key` (`meta_key`(191))
) ENGINE=MyISAM AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `wpbi_usermeta` VALUES (1,1,'nickname','SteveFossey'),(2,1,'first_name','Steve'),(3,1,'last_name','Fossey'),(4,1,'description',''),(5,1,'rich_editing','true'),(6,1,'syntax_highlighting','true'),(7,1,'comment_shortcuts','false'),(8,1,'admin_color','fresh'),(9,1,'use_ssl','0'),(10,1,'show_admin_bar_front','true'),(11,1,'locale',''),(12,1,'wpbi_capabilities','a:4:{s:13:\"administrator\";b:1;s:14:\"erp_hr_manager\";b:1;s:15:\"erp_crm_manager\";b:1;s:14:\"erp_ac_manager\";b:1;}'),(13,1,'wpbi_user_level','10'),(14,1,'dismissed_wp_pointers','wp496_privacy'),(15,1,'show_welcome_panel','0'),(33,1,'session_tokens','a:1:{s:64:\"86bf877892aa012a1a86b49a402ba5a12b1224da511645b961e8b83aa9b8d7d9\";a:4:{s:10:\"expiration\";i:1625093562;s:2:\"ip\";s:12:\"45.44.235.66\";s:2:\"ua\";s:115:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.124 Safari/537.36\";s:5:\"login\";i:1624920762;}}'),(17,1,'wpbi_dashboard_quick_press_last_post_id','157'),(18,1,'community-events-location','a:1:{s:2:\"ip\";s:10:\"68.67.51.0\";}'),(19,1,'closedpostboxes_dashboard','a:1:{i:0;s:17:\"so-dashboard-news\";}'),(20,1,'metaboxhidden_dashboard','a:6:{i:0;s:17:\"so-dashboard-news\";i:1;s:21:\"dashboard_site_health\";i:2;s:19:\"dashboard_right_now\";i:3;s:18:\"dashboard_activity\";i:4;s:21:\"dashboard_quick_press\";i:5;s:17:\"dashboard_primary\";}'),(21,1,'show_try_gutenberg_panel','0'),(22,1,'wpbi_user-settings','libraryContent=browse&editor=tinymce&advImgDetails=show&siteorigin_panels_setting_tab=general&mfold=o'),(23,1,'wpbi_user-settings-time','1621435665'),(24,1,'zbs-hopscotch-tour','0'),(25,1,'zbs-hide-wp-menus','0'),(26,1,'upicrm_user_permission','2'),(30,1,'nav_menu_recently_edited','2'),(31,1,'managenav-menuscolumnshidden','a:5:{i:0;s:11:\"link-target\";i:1;s:11:\"css-classes\";i:2;s:3:\"xfn\";i:3;s:11:\"description\";i:4;s:15:\"title-attribute\";}'),(32,1,'metaboxhidden_nav-menus','a:2:{i:0;s:12:\"add-post_tag\";i:1;s:15:\"add-post_format\";}'),(27,1,'last_login','1539545476'),(28,1,'_new_email','a:2:{s:4:\"hash\";s:32:\"532abe575b0320c6546b859e68e72a06\";s:8:\"newemail\";s:23:\"steve.fossey@fpsteam.ca\";}'),(29,1,'so_panels_directory_enabled','1');
CREATE TABLE `wpbi_zbs_admlog` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `zbs_site` int(11) DEFAULT NULL,
  `zbs_team` int(11) DEFAULT NULL,
  `zbs_owner` int(11) NOT NULL,
  `zbsadmlog_status` int(3) NOT NULL,
  `zbsadmlog_cat` varchar(20) DEFAULT NULL,
  `zbsadmlog_str` varchar(500) DEFAULT NULL,
  `zbsadmlog_time` int(14) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `wpbi_zbs_aka` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `aka_type` int(11) DEFAULT NULL,
  `aka_id` int(11) NOT NULL,
  `aka_alias` varchar(200) NOT NULL,
  `aka_created` int(14) DEFAULT NULL,
  `aka_lastupdated` int(14) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `wpbi_zbs_contacts` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `zbs_site` int(11) DEFAULT NULL,
  `zbs_team` int(11) DEFAULT NULL,
  `zbs_owner` int(11) NOT NULL,
  `zbsc_status` varchar(100) DEFAULT NULL,
  `zbsc_email` varchar(200) DEFAULT NULL,
  `zbsc_prefix` varchar(30) DEFAULT NULL,
  `zbsc_fname` varchar(100) DEFAULT NULL,
  `zbsc_lname` varchar(100) DEFAULT NULL,
  `zbsc_addr1` varchar(200) DEFAULT NULL,
  `zbsc_addr2` varchar(200) DEFAULT NULL,
  `zbsc_city` varchar(100) DEFAULT NULL,
  `zbsc_county` varchar(200) DEFAULT NULL,
  `zbsc_country` varchar(200) DEFAULT NULL,
  `zbsc_postcode` varchar(50) DEFAULT NULL,
  `zbsc_secaddr1` varchar(200) DEFAULT NULL,
  `zbsc_secaddr2` varchar(200) DEFAULT NULL,
  `zbsc_seccity` varchar(100) DEFAULT NULL,
  `zbsc_seccounty` varchar(200) DEFAULT NULL,
  `zbsc_seccountry` varchar(200) DEFAULT NULL,
  `zbsc_secpostcode` varchar(50) DEFAULT NULL,
  `zbsc_hometel` varchar(40) DEFAULT NULL,
  `zbsc_worktel` varchar(40) DEFAULT NULL,
  `zbsc_mobtel` varchar(40) DEFAULT NULL,
  `zbsc_wpid` int(11) DEFAULT NULL,
  `zbsc_avatar` varchar(300) DEFAULT NULL,
  `zbsc_tw` varchar(100) DEFAULT NULL,
  `zbsc_li` varchar(300) DEFAULT NULL,
  `zbsc_fb` varchar(200) DEFAULT NULL,
  `zbsc_created` int(14) NOT NULL,
  `zbsc_lastupdated` int(14) NOT NULL,
  `zbsc_lastcontacted` int(14) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `wpbi_zbs_customfields` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `zbs_site` int(11) DEFAULT NULL,
  `zbs_team` int(11) DEFAULT NULL,
  `zbs_owner` int(11) NOT NULL,
  `zbscf_objtype` int(4) NOT NULL,
  `zbscf_objid` int(32) NOT NULL,
  `zbscf_objkey` varchar(100) NOT NULL,
  `zbscf_objval` varchar(2000) DEFAULT NULL,
  `zbscf_created` int(14) NOT NULL,
  `zbscf_lastupdated` int(14) NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `TYPEIDKEY` (`zbscf_objtype`,`zbscf_objid`,`zbscf_objkey`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `wpbi_zbs_dbmigration_meta` (
  `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `wpID` bigint(20) unsigned NOT NULL,
  `zbsID` bigint(20) unsigned NOT NULL,
  `post_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  `meta_key` varchar(255) DEFAULT NULL,
  `meta_value` longtext DEFAULT NULL,
  PRIMARY KEY (`meta_id`),
  KEY `post_id` (`post_id`),
  KEY `meta_key` (`meta_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `wpbi_zbs_dbmigration_posts` (
  `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `wpID` bigint(20) unsigned NOT NULL,
  `zbsID` bigint(20) unsigned NOT NULL,
  `post_author` bigint(20) unsigned NOT NULL DEFAULT 0,
  `post_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `post_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `post_content` longtext NOT NULL,
  `post_title` text NOT NULL,
  `post_excerpt` text NOT NULL,
  `post_status` varchar(20) NOT NULL DEFAULT 'publish',
  `comment_status` varchar(20) NOT NULL DEFAULT 'open',
  `ping_status` varchar(20) NOT NULL DEFAULT 'open',
  `post_password` varchar(255) NOT NULL DEFAULT '',
  `post_name` varchar(200) NOT NULL DEFAULT '',
  `to_ping` text NOT NULL,
  `pinged` text NOT NULL,
  `post_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `post_modified_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `post_content_filtered` longtext NOT NULL,
  `post_parent` bigint(20) unsigned NOT NULL DEFAULT 0,
  `guid` varchar(255) NOT NULL DEFAULT '',
  `menu_order` int(11) NOT NULL DEFAULT 0,
  `post_type` varchar(20) NOT NULL DEFAULT 'post',
  `post_mime_type` varchar(100) NOT NULL DEFAULT '',
  `comment_count` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`ID`),
  KEY `post_name` (`post_name`),
  KEY `type_status_date` (`post_type`,`post_status`,`post_date`,`ID`),
  KEY `post_parent` (`post_parent`),
  KEY `post_author` (`post_author`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `wpbi_zbs_externalsources` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `zbs_site` int(11) DEFAULT NULL,
  `zbs_team` int(11) DEFAULT NULL,
  `zbs_owner` int(11) NOT NULL,
  `zbss_contactid` int(11) NOT NULL,
  `zbss_source` varchar(20) NOT NULL,
  `zbss_uid` varchar(300) NOT NULL,
  `zbss_created` int(14) NOT NULL,
  `zbss_lastupdated` int(14) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `wpbi_zbs_logs` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `zbs_site` int(11) DEFAULT NULL,
  `zbs_team` int(11) DEFAULT NULL,
  `zbs_owner` int(11) NOT NULL,
  `zbsl_objtype` int(11) NOT NULL,
  `zbsl_objid` int(11) NOT NULL,
  `zbsl_type` varchar(200) NOT NULL,
  `zbsl_shortdesc` varchar(300) DEFAULT NULL,
  `zbsl_longdesc` longtext DEFAULT NULL,
  `zbsl_created` int(14) NOT NULL,
  `zbsl_lastupdated` int(14) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `wpbi_zbs_meta` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `zbs_site` int(11) DEFAULT NULL,
  `zbs_team` int(11) DEFAULT NULL,
  `zbs_owner` int(11) NOT NULL,
  `zbsm_objtype` int(11) NOT NULL,
  `zbsm_objid` int(11) NOT NULL,
  `zbsm_key` varchar(255) NOT NULL,
  `zbsm_val` longtext DEFAULT NULL,
  `zbsm_created` int(14) NOT NULL,
  `zbsm_lastupdated` int(14) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `wpbi_zbs_notifications` (
  `id` int(32) unsigned NOT NULL AUTO_INCREMENT,
  `zbs_site` int(11) DEFAULT NULL,
  `zbs_team` int(11) DEFAULT NULL,
  `zbs_owner` int(11) NOT NULL,
  `zbsnotify_recipient_id` int(32) NOT NULL,
  `zbsnotify_sender_id` int(32) NOT NULL,
  `zbsnotify_unread` tinyint(1) NOT NULL DEFAULT 1,
  `zbsnotify_emailed` tinyint(1) NOT NULL DEFAULT 0,
  `zbsnotify_type` varchar(255) NOT NULL DEFAULT '',
  `zbsnotify_parameters` text NOT NULL,
  `zbsnotify_reference_id` int(32) NOT NULL,
  `zbsnotify_created_at` int(18) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

INSERT INTO `wpbi_zbs_notifications` VALUES (1,NULL,NULL,-1,0,-999,0,0,'db2.update.253.success','funkydbupdate2',-1,1539400804);
CREATE TABLE `wpbi_zbs_object_links` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `zbs_site` int(11) DEFAULT NULL,
  `zbs_team` int(11) DEFAULT NULL,
  `zbs_owner` int(11) NOT NULL,
  `zbsol_objtype_from` int(4) NOT NULL,
  `zbsol_objtype_to` int(4) NOT NULL,
  `zbsol_objid_from` int(11) NOT NULL,
  `zbsol_objid_to` int(11) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `wpbi_zbs_segments` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `zbs_site` int(11) DEFAULT NULL,
  `zbs_team` int(11) DEFAULT NULL,
  `zbs_owner` int(11) NOT NULL,
  `zbsseg_name` varchar(120) NOT NULL,
  `zbsseg_slug` varchar(45) NOT NULL,
  `zbsseg_matchtype` varchar(10) NOT NULL,
  `zbsseg_created` int(14) NOT NULL,
  `zbsseg_lastupdated` int(14) NOT NULL,
  `zbsseg_compilecount` int(11) DEFAULT 0,
  `zbsseg_lastcompiled` int(14) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `wpbi_zbs_segments_conditions` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `zbscondition_segmentid` int(11) NOT NULL,
  `zbscondition_type` varchar(50) NOT NULL,
  `zbscondition_op` varchar(50) DEFAULT NULL,
  `zbscondition_val` varchar(250) DEFAULT NULL,
  `zbscondition_val_secondary` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `wpbi_zbs_settings` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `zbs_site` int(11) DEFAULT NULL,
  `zbs_team` int(11) DEFAULT NULL,
  `zbs_owner` int(11) NOT NULL,
  `zbsset_key` varchar(100) NOT NULL DEFAULT '-1',
  `zbsset_val` longtext DEFAULT NULL,
  `zbsset_created` int(14) NOT NULL,
  `zbsset_lastupdated` int(14) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=124 DEFAULT CHARSET=utf8;

INSERT INTO `wpbi_zbs_settings` VALUES (1,1,1,-1,'settingsinstalled','1',1539400804,1539400804),(2,1,1,-1,'wptakeovermode','0',1539400804,1539434539),(3,1,1,-1,'wptakeovermodeforall','0',1539400804,1539434539),(4,1,1,-1,'customheadertext','FPS Group',1539400804,1539434539),(5,1,1,-1,'killfrontend','0',1539400804,1539434539),(6,1,1,-1,'loginlogourl','https://fpsteam.ca/wp-content/uploads/2018/10/trimmed-logo.jpg',1539400804,1539434539),(7,1,1,-1,'showneedsquote','1',1539400804,1539434539),(8,1,1,-1,'filetypesupload','{\"pdf\":0,\"doc\":0,\"docx\":0,\"ppt\":0,\"pptx\":0,\"xls\":0,\"xlsx\":0,\"csv\":0,\"png\":0,\"jpg\":0,\"jpeg\":0,\"gif\":0,\"mp3\":0,\"txt\":0,\"zip\":0,\"all\":1}',1539400804,1539434539),(9,1,1,-1,'showaddress','1',1539400804,1539434539),(10,1,1,-1,'secondaddress','1',1539400804,1539434539),(11,1,1,-1,'countries','1',1539400804,1539434539),(12,1,1,-1,'companylevelcustomers','1',1539400804,1539434539),(13,1,1,-1,'coororg','co',1539400804,1539434539),(14,1,1,-1,'showthanksfooter','1',1539400804,1539434539),(15,1,1,-1,'showthankslogin','1',1539400804,1539434539),(16,1,1,-1,'shareessentials','1',1539400804,1539434539),(17,1,1,-1,'menulayout','2',1539400804,1539434539),(18,1,1,-1,'currency','{\"chr\":\"$\",\"strval\":\"CAD\"}',1539400804,1539434539),(19,1,1,-1,'currency_position','0',1539400804,1539434539),(20,1,1,-1,'currency_format_thousand_separator',',',1539400804,1539434539),(21,1,1,-1,'currency_format_decimal_separator','.',1539400804,1539434539),(22,1,1,-1,'currency_format_number_of_decimals','2',1539400804,1539400804),(23,1,1,-1,'smtpaccs','{\"steve-fpsteam-ca\":{\"mode\":\"wp_mail\",\"fromemail\":\"Steve@fpsteam.ca\",\"fromname\":\"Steve Fossey\",\"replyto\":\"Steve@fpsteam.ca\",\"cc\":\"\",\"bcc\":\"\",\"veri\":1539546232}}',1539400804,1539546232),(24,1,1,-1,'smtpkey','',1539400804,1539400804),(25,1,1,-1,'clicktocall','0',1539400804,1539434539),(26,1,1,-1,'clicktocalltype','1',1539400804,1539434539),(27,1,1,-1,'avatarmode','2',1539400804,1539434539),(28,1,1,-1,'businessname','',1539400804,1539401038),(29,1,1,-1,'businessyourname','',1539400804,1539401038),(30,1,1,-1,'businessyouremail','',1539400804,1539401038),(31,1,1,-1,'businessyoururl','',1539400804,1539401038),(32,1,1,-1,'twitter','',1539400804,1539401038),(33,1,1,-1,'facebook','',1539400804,1539401038),(34,1,1,-1,'linkedin','',1539400804,1539401038),(35,1,1,-1,'unsub','Click to unsubscribe: ###UNSUB-LINK###',1539400804,1539545865),(36,1,1,-1,'unsubpage','20',1539400804,1539545865),(37,1,1,-1,'unsubmsg','You have been sucessfully unsubscribed.',1539400804,1539545865),(38,1,1,-1,'mailignoresslmismatch','0',1539400804,1539545865),(39,1,1,-1,'businessextra','',1539400804,1539400804),(40,1,1,-1,'invfromemail','',1539400804,1539400804),(41,1,1,-1,'invfromname','',1539400804,1539400804),(42,1,1,-1,'invpro_pay','2',1539400804,1539400804),(43,1,1,-1,'stripe_sk','',1539400804,1539400804),(44,1,1,-1,'stripe_pk','',1539400804,1539400804),(45,1,1,-1,'ppbusinessemail','',1539400804,1539400804),(46,1,1,-1,'invtax','0',1539400804,1539400804),(47,1,1,-1,'invdis','0',1539400804,1539400804),(48,1,1,-1,'invpandp','0',1539400804,1539400804),(49,1,1,-1,'quoteoffset','0',1539400804,1539434539),(50,1,1,-1,'invoffset','0',1539400804,1539434539),(51,1,1,-1,'invallowoverride','1',1539400804,1539434539),(52,1,1,-1,'usequotebuilder','1',1539400804,1539400804),(53,1,1,-1,'showpoweredbyquotes','1',1539400804,1539400804),(54,1,1,-1,'zbs_newquote_email_content','',1539400804,1539400804),(55,1,1,-1,'zbs_quoteacc_email_content','',1539400804,1539400804),(56,1,1,-1,'taskownership','0',1539400804,1539434539),(57,1,1,-1,'autolog_customer_new','1',1539400804,1539434539),(58,1,1,-1,'autolog_company_new','1',1539400804,1539434539),(59,1,1,-1,'autolog_quote_new','1',1539400804,1539434539),(60,1,1,-1,'autolog_invoice_new','1',1539400804,1539434539),(61,1,1,-1,'autolog_transaction_new','1',1539400804,1539434539),(62,1,1,-1,'autolog_event_new','1',1539400804,1539434539),(63,1,1,-1,'autolog_clientportal_new','1',1539400804,1539434539),(64,1,1,-1,'autolog_customer_statuschange','0',1539400804,1539434539),(65,1,1,-1,'autolog_mailcampaigns_send','1',1539400804,1539400804),(66,1,1,-1,'autolog_mailcampaigns_open','1',1539400804,1539400804),(67,1,1,-1,'autolog_mailcampaigns_click','1',1539400804,1539400804),(68,1,1,-1,'autolog_mailcampaigns_unsubscribe','1',1539400804,1539400804),(69,1,1,-1,'showpoweredby','0',1539400804,1539545793),(70,1,1,-1,'usegcaptcha','0',1539400804,1539545793),(71,1,1,-1,'gcaptchasitekey','0',1539400804,1539545793),(72,1,1,-1,'gcaptchasitesecret','0',1539400804,1539545793),(73,1,1,-1,'portalpage','17',1539400804,1539400805),(74,1,1,-1,'zbs_portal_email_content','',1539400804,1539400804),(75,1,1,-1,'portalusers','0',1539400804,1539400804),(76,1,1,-1,'portalusers_extrarole','',1539400804,1539400804),(77,1,1,-1,'portalusers_status','all',1539400804,1539400804),(78,1,1,-1,'portal_hidefields','status,email',1539400804,1539400804),(79,1,1,-1,'usesocial','1',1539400804,1539434539),(80,1,1,-1,'useaka','1',1539400804,1539434539),(81,1,1,-1,'objnav','0',1539400804,1539434539),(82,1,1,-1,'emailtracking','1',1539400804,1539545865),(83,1,1,-1,'directmsgfrom','1',1539400804,1539545865),(84,1,1,-1,'emailpoweredby','0',1539400804,1539545865),(85,1,1,-1,'feat_quotes','1',1539400804,1539400929),(86,1,1,-1,'feat_invs','1',1539400804,1539400929),(87,1,1,-1,'feat_forms','1',1539400804,1539400929),(88,1,1,-1,'feat_pdfinvs','-1',1539400804,1539400804),(89,1,1,-1,'feat_csvimporterlite','1',1539400804,1539400804),(90,1,1,-1,'feat_portal','-1',1539400804,1539434357),(91,1,1,-1,'feat_custom_fields','1',1539400804,1539400804),(92,1,1,-1,'feat_api','1',1539400804,1539434376),(93,1,1,-1,'feat_calendar','1',1539400804,1539400804),(94,1,1,-1,'showid','1',1539400804,1539400804),(95,1,1,-1,'fieldoverride','-1',1539400804,1539400804),(96,1,1,-1,'customfields','{\"customers\":[[\"select\",\"Source\",\"Google,Word of mouth,Local Newspaper\"]],\"companies\":[],\"quotes\":[],\"invoices\":[],\"transactions\":[]}',1539400804,1539400804),(97,1,1,-1,'defaultstatus','Lead',1539400804,1539400804),(98,1,1,-1,'filtersfromstatus','1',1539400804,1539400804),(99,1,1,-1,'filtersfromsegments','1',1539400804,1539400804),(100,1,1,-1,'fieldsorts','{\"address\":false,\"customers\":false,\"quotes\":false,\"invoices\":false,\"transactions\":false}',1539400804,1539400804),(101,1,1,-1,'fieldhides','{\"address\":false,\"customers\":false,\"quotes\":false,\"invoices\":false,\"transactions\":false}',1539400804,1539400804),(102,1,1,-1,'migrations','[]',1539400804,1539400804),(103,1,1,-1,'customisedfields','{\"customers\":{\"status\":[1,\"Lead,Customer,Refused,Blacklisted,Cancelled by Customer,Cancelled by Us (Pre-Quote),Cancelled by Us (Post-Quote)\"],\"prefix\":[1,\"Mr,Mrs,Ms,Miss,Dr,Prof,Mr & Mrs\"]},\"transactions\":[],\"companies\":{\"status\":[1,\"Lead,Customer,Refused,Blacklisted\"]},\"quotes\":[],\"invoices\":[]}',1539400804,1539400804),(104,1,1,-1,'zbsfunnel','Lead,Customer',1539400804,1539400804),(105,1,1,-1,'perusercustomers','0',1539400804,1539434539),(106,1,1,-1,'usercangiveownership','0',1539400804,1539434539),(107,1,1,-1,'customviews','{\"customer\":{\"name\":[\"Name\"],\"email\":[\"Email\"],\"status\":[\"Status\"],\"quotes\":[\"Quotes\"],\"invoices\":[\"Invoices\"],\"transactions\":[\"Transactions\"],\"totalvalue\":[\"Total Value\"],\"added\":[\"Added\"]}}',1539400804,1539400804),(108,1,1,-1,'allowinlineedits','-1',1539400804,1539400804),(109,1,1,-1,'customviews2','{\"customer\":{\"id\":[\"ID\"],\"nameavatar\":[\"Name and Avatar\"],\"status\":[\"Status\"],\"totalvalue\":[\"Total Value\"],\"added\":[\"Added\"]},\"company\":{\"id\":[\"ID\"],\"name\":[\"Name\"],\"status\":[\"Status\"],\"contacts\":[\"Contacts\"],\"added\":[\"Added\"],\"editlink\":[\"View\"]},\"quote\":{\"id\":[\"ID\"],\"title\":[\"Quote Title\"],\"customer\":[\"Customer\"],\"status\":[\"Status\"],\"value\":[\"Quote Value\"],\"editlink\":[\"Edit\"]},\"invoice\":{\"id\":[\"ID\"],\"ref\":[\"Reference\"],\"customer\":[\"Customer\"],\"status\":[\"Status\"],\"value\":[\"Value\"],\"editlink\":[\"Edit\"]},\"form\":{\"id\":[\"ID\"],\"title\":[\"Title\"],\"style\":[\"Style\"],\"views\":[\"Views\"],\"conversions\":[\"Conversions\"],\"added\":[\"Added\"],\"editlink\":[\"Edit\"]},\"transaction\":{\"id\":[\"ID\"],\"customer\":[\"Customer\"],\"status\":[\"Status\"],\"total\":[\"Value\"],\"item\":[\"Item\"],\"added\":[\"Added\"],\"editlink\":[\"Edit Link\"]},\"transaction_filters\":{\"status_succeeded\":[\"Succeeded\"],\"status_completed\":[\"Completed\"],\"status_failed\":[\"Failed\"],\"status_refunded\":[\"Refunded\"]},\"customer_filters\":{\"lead\":[\"Lead\"],\"customer\":[\"Customer\"]},\"quote_filters\":{\"status_accepted\":[\"Accepted\"],\"status_notaccepted\":[\"Not Accepted\"]},\"invoice_filters\":{\"status_draft\":[\"Draft\"],\"status_unpaid\":[\"Unpaid\"],\"status_paid\":[\"Paid\"],\"status_overdue\":[\"Overdue\"]},\"segment\":{\"id\":[\"ID\"],\"name\":[\"Name\"],\"audiencecount\":[\"Contact Count\"],\"action\":[\"Action\"]},\"form_filters\":[]}',1539400804,1539400804),(110,1,1,-1,'company_view_docs_columns','{\"transactions\":[\"date\",\"id\",\"total\",\"status\"]}',1539400804,1539400804),(111,1,1,-1,'quickfiltersettings','{\"notcontactedinx\":30,\"olderthanx\":30}',1539400804,1539400804),(112,1,1,-1,'license_key','{\"license_key\":\"\"}',1539400804,1539400804),(113,1,1,-1,'transinclude_status','all',1539400804,1539400804),(114,1,1,-1,'whlang','[]',1539400804,1539400804),(115,1,1,-1,'zbscrm_dmz','',1539400804,1539400804),(116,1,1,-1,'quotes_default_templates','[18]',1539400806,1539400806),(117,1,1,-1,'feat_pdfinv','1',1539400929,1539400929),(118,1,1,-1,'invoicelogourl','https://fpsteam.ca/wp-content/uploads/2018/10/Fossey-Professional-Services_final.jpg',1539401038,1539401038),(119,1,1,-1,'secondaddresslabel','Second Address',1539401140,1539434539),(120,1,1,-1,'wpzbscrm_avatarmode','1',1539401140,1539434539),(121,1,1,-1,'currency_format_number_of_decimal','.',1539401140,1539434539),(122,1,1,-1,'css_override','',1539401140,1539434539),(123,1,1,-1,'smtpaccsdef','steve-fpsteam-ca',1539546232,1539546232);
CREATE TABLE `wpbi_zbs_sys_cronmanagerlogs` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `zbs_site` int(11) DEFAULT NULL,
  `zbs_team` int(11) DEFAULT NULL,
  `zbs_owner` int(11) NOT NULL,
  `job` varchar(100) NOT NULL,
  `jobstatus` int(3) DEFAULT NULL,
  `jobstarted` int(14) NOT NULL,
  `jobfinished` int(14) NOT NULL,
  `jobnotes` longtext DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `wpbi_zbs_sys_email` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `zbs_site` int(11) DEFAULT NULL,
  `zbs_team` int(11) DEFAULT NULL,
  `zbs_owner` int(11) NOT NULL,
  `zbsmail_active` int(11) NOT NULL,
  `zbsmail_id` int(11) NOT NULL,
  `zbsmail_deliverymethod` varchar(200) NOT NULL,
  `zbsmail_fromname` varchar(200) DEFAULT NULL,
  `zbsmail_fromaddress` varchar(200) DEFAULT NULL,
  `zbsmail_replyto` varchar(200) DEFAULT NULL,
  `zbsmail_ccto` varchar(200) DEFAULT NULL,
  `zbsmail_bccto` varchar(200) DEFAULT NULL,
  `zbsmail_subject` varchar(200) DEFAULT NULL,
  `zbsmail_body` longtext DEFAULT NULL,
  `zbsmail_created` int(14) NOT NULL,
  `zbsmail_lastupdated` int(14) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

INSERT INTO `wpbi_zbs_sys_email` VALUES (1,-1,-1,-1,1,0,'','','','','','','','\n\n\n\n\n<title>###TITLE###</title>\n\n@media only screen and (max-width: 620px) {\ntable[class=body] h1 {\nfont-size: 28px !important;\nmargin-bottom: 10px !important; }\ntable[class=body] p,\ntable[class=body] ul,\ntable[class=body] ol,\ntable[class=body] td,\ntable[class=body] span,\ntable[class=body] a {\nfont-size: 16px !important; }\ntable[class=body] .wrapper,\ntable[class=body] .article {\npadding: 10px !important; }\ntable[class=body] .content {\npadding: 0 !important; }\ntable[class=body] .container {\npadding: 0 !important;\nwidth: 100% !important; }\ntable[class=body] .main {\nborder-left-width: 0 !important;\nborder-radius: 0 !important;\nborder-right-width: 0 !important; }\ntable[class=body] .btn table {\nwidth: 100% !important; }\ntable[class=body] .btn a {\nwidth: 100% !important; }\ntable[class=body] .img-responsive {\nheight: auto !important;\nmax-width: 100% !important;\nwidth: auto !important; }}\n@media all {\n.ExternalClass {\nwidth: 100%; }\n.ExternalClass,\n.ExternalClass p,\n.ExternalClass span,\n.ExternalClass font,\n.ExternalClass td,\n.ExternalClass div {\nline-height: 100%; }\n.apple-link a {\ncolor: inherit !important;\nfont-family: inherit !important;\nfont-size: inherit !important;\nfont-weight: inherit !important;\nline-height: inherit !important;\ntext-decoration: none !important; }\n.btn-primary table td:hover {\nbackground-color: #34495e !important; }\n.btn-primary a:hover {\nbackground-color: #34495e !important;\nborder-color: #34495e !important; } }\n\n\n\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"body\" style=\"border-collapse:separate;background-color:#f6f6f6;width:100%\">\n<tr>\n<td style=\"font-family:sans-serif;font-size:14px;vertical-align:top\"> </td>\n<td class=\"container\" style=\"font-family:sans-serif;font-size:14px;vertical-align:top;max-width:580px;padding:10px;width:580px\">\n<div class=\"content\" style=\"max-width:580px;padding:10px\">\n<table class=\"main\" style=\"border-collapse:separate;background:#fff;width:100%\">\n<!-- START MAIN CONTENT AREA -->\n<tr>\n<td class=\"wrapper\" style=\"font-family:sans-serif;font-size:14px;vertical-align:top;padding:20px\">\n###MSGCONTENT###\n</td>\n</tr>\n<!-- END MAIN CONTENT AREA -->\n</table>\n<!-- START FOOTER -->\n<div class=\"footer\" style=\"clear:both;padding-top:10px;text-align:center;width:100%\">\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse:separate;width:100%\">\n<tr>\n<td class=\"content-block\" style=\"font-family:sans-serif;font-size:14px;vertical-align:top;color:#999999;font-size:12px;text-align:center\">\n<span class=\"apple-link\" style=\"color:#999999;font-size:12px;text-align:center\">###FOOTERBIZDEETS###</span>\n<br>\n##UNSUB-LINE##\n</td>\n</tr>\n<tr>\n<td class=\"content-block powered-by\" style=\"font-family:sans-serif;font-size:14px;vertical-align:top;color:#999999;font-size:12px;text-align:center;padding-top:40px;text-align:right\">\n###POWEREDBYDEETS###\n</td>\n</tr>\n</table>\n</div>\n</div>\n</td>\n<td style=\"font-family:sans-serif;font-size:14px;vertical-align:top\"> </td>\n</tr>\n</table>\n\n',1539400804,1539400804),(2,-1,-1,-1,1,1,'','','','','','','Your Client Portal','<strong>Your Client Portal</strong><br />\n<br />\nWelcome to your Client Portal. Your login details are:<br />\n<ul><br />\n<li>Login link: ###PORTALLINK###</li><br />\n<li>Email: ###EMAIL###</li><br />\n<li>Password: ###PASSWORD###</li><br />\n</ul><br />\nIn your client portal you can access your quotes and invoices, as well as pay invoices online using PayPal or Stripe. If you have any questions. Let us know.<br />\n<br />\n<strong>###FROMNAME###</strong>',1539400804,1539400804),(3,-1,-1,-1,1,2,'','','','','','','Quote Accepted','<h3 style=\"text-align:center;font-size: 1.5em;margin-top: 0em;margin-bottom: 2em\">Quote Accepted!</h3>\nHi there,\n<br /><br />\nThis is a notification email to let you know that your proposal <strong>###QUOTETITLE###</strong> has been accepted!\n<br /><br />\nHere is the link to view the proposal online: <a href=\"###QUOTEURL###\">###QUOTEURL###</a>\n<br /><br />\nAnd here is the link to edit the proposal:  <a href=\"###QUOTEEDITURL###\">###QUOTEEDITURL###</a>\n<br /><br />\nAwesome work!\n<br /><br />\n###FROMNAME###',1539400804,1539400804),(4,-1,-1,-1,1,3,'','','','','','','You have received an Invoice','<div class=\"container\" style=\"max-width:1200px;margin-left:auto;margin-right:auto\">\n  <div id=\"zbs_top_wrapper\">\n      <div id=\"zbs_invoice_logos\" style=\"width:50%;float:left\">\n          <div class=\"wh-logo-set ###LOGOCLASS###\">\n              <img id=\"wh-logo-set-img\" src=\"###LOGOURL###\" style=\"max-width:50%\" />\n          </div>\n      </div>\n      <div class=\"zbs-invoice-topper\" style=\"width: 50%;float: right;text-align: right\">\n          <table class=\"form-table\" style=\"text-align: right;float: right\">\n          <tr class=\"wh-large zbs-invoice-number\">\n            <td><strong><label for=\"no\">Invoice Number:</label></strong></td> \n            <td>###INVNOSTR###</td>\n          </tr>\n          <tr class=\"wh-large\">\n              <td><strong><label for=\"date\">Invoice Date:</label></strong></td>\n              <td>###INVDATESTR###</td>\n          </tr>\n          <tr class=\"wh-large\">\n              <td><strong><label for=\"Reference\">Reference:</label></strong></td>\n              <td>###REF###</td>\n          </tr>\n          <tr class=\"wh-large\">\n              <td><strong><label for=\"due\">Due date:</label></strong></td>\n              <td>###DUEDATE###</td>\n          </tr>\n       </table>\n      </div>\n  </div>\n  <div class=\"clear\" style=\"clear:both\"></div>\n  <div id=\"zbs-business-info-wrapper\">\n      <div class=\"business-info ###BIZCLASS###\">\n          ###BIZINFOTABLE###\n      </div>\n  </div>\n  <div class=\"clear\"></div>\n  <div id=\"zbs-invoice-items\" style=\"margin-top:2em\">\n      <table class=\"table\" style=\"width:100%\">\n          <thead style=\"border:1px solid #ccc;background:#f5f5f5;padding: 20px;line-height: 30px;font-weight: 100\">\n              ###TABLEHEADERS###\n          </thead>\n          <div class=\"zbs-table-block\">\n              ###LINEITEMS###\n          </div>\n      </table>\n  </div>\n  ###TOTALSTABLE###\n  </div>\n  ###VIEWINPORTAL###',1539400804,1539400804),(5,-1,-1,-1,1,4,'','','','','','','You have received a new Proposal','Hi there,\n<br /><br />\nThis is a notification email to let you know that your proposal <strong>###QUOTETITLE###</strong> is ready to view &amp; accept online.\n<br /><br />\nHere is the link to view the proposal: <a href=\"###QUOTEURL###\">###QUOTEURL###</a>\n<br /><br />\nPlease do let me know when you are ready to proceed, or if I can help you with anything else.\n<br /><br />\n###FROMNAME###',1539400804,1539400804),(6,-1,-1,-1,1,5,'','','','','','','Your Event starts soon','<h3 style=\"text-align:center;font-size: 1.5em;margin-top: 0em;margin-bottom: 2em\">Your Event is starting soon</h3>\n<div style=\"text-align:center;font-size: 1.5em;margin-top: 0em;margin-bottom: 2em\">(###EVENTTITLE###)</div>\n<br />\nYou can view your event at the following URL: \n###EVENTLINKBUTTON###',1539400804,1539400804);
CREATE TABLE `wpbi_zbs_sys_email_hist` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `zbs_site` int(11) DEFAULT NULL,
  `zbs_team` int(11) DEFAULT NULL,
  `zbs_owner` int(11) NOT NULL,
  `zbsmail_type` int(11) NOT NULL,
  `zbsmail_sender_thread` int(11) NOT NULL,
  `zbsmail_sender_email` varchar(200) NOT NULL,
  `zbsmail_sender_wpid` int(11) NOT NULL,
  `zbsmail_sender_mailbox_id` int(11) NOT NULL,
  `zbsmail_sender_mailbox_name` varchar(200) DEFAULT NULL,
  `zbsmail_receiver_email` varchar(200) NOT NULL,
  `zbsmail_sent` int(11) NOT NULL,
  `zbsmail_target_objid` int(11) NOT NULL,
  `zbsmail_assoc_objid` int(11) NOT NULL,
  `zbsmail_subject` varchar(200) DEFAULT NULL,
  `zbsmail_content` longtext DEFAULT NULL,
  `zbsmail_hash` varchar(128) DEFAULT NULL,
  `zbsmail_status` varchar(120) DEFAULT NULL,
  `zbsmail_starred` int(11) DEFAULT NULL,
  `zbsmail_opened` int(11) NOT NULL,
  `zbsmail_clicked` int(11) NOT NULL,
  `zbsmail_firstopened` int(14) NOT NULL,
  `zbsmail_lastopened` int(14) NOT NULL,
  `zbsmail_lastclicked` int(14) NOT NULL,
  `zbsmail_created` int(14) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `wpbi_zbs_tags` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `zbs_site` int(11) DEFAULT NULL,
  `zbs_team` int(11) DEFAULT NULL,
  `zbs_owner` int(11) NOT NULL,
  `zbstag_objtype` int(11) NOT NULL,
  `zbstag_name` varchar(200) NOT NULL,
  `zbstag_slug` varchar(200) NOT NULL,
  `zbstag_created` int(14) NOT NULL,
  `zbstag_lastupdated` int(14) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `wpbi_zbs_tags_links` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `zbs_site` int(11) DEFAULT NULL,
  `zbs_team` int(11) DEFAULT NULL,
  `zbs_owner` int(11) NOT NULL,
  `zbstl_objtype` int(4) NOT NULL,
  `zbstl_objid` int(11) NOT NULL,
  `zbstl_tagid` int(11) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `wpbi_zbs_temphash` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `zbs_site` int(11) DEFAULT NULL,
  `zbs_team` int(11) DEFAULT NULL,
  `zbs_owner` int(11) NOT NULL,
  `zbstemphash_status` int(11) DEFAULT -1,
  `zbstemphash_objtype` varchar(50) NOT NULL,
  `zbstemphash_objid` int(11) DEFAULT NULL,
  `zbstemphash_objhash` varchar(256) DEFAULT NULL,
  `zbstemphash_created` int(14) NOT NULL,
  `zbstemphash_lastupdated` int(14) NOT NULL,
  `zbstemphash_expiry` int(14) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `wpbi_zbs_tracking` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `zbs_site` int(11) DEFAULT NULL,
  `zbs_team` int(11) DEFAULT NULL,
  `zbs_owner` int(11) NOT NULL,
  `zbst_contactid` int(11) NOT NULL,
  `zbst_action` varchar(50) NOT NULL,
  `zbst_action_detail` longtext NOT NULL,
  `zbst_referrer` varchar(300) NOT NULL,
  `zbst_utm_source` varchar(200) NOT NULL,
  `zbst_utm_medium` varchar(200) NOT NULL,
  `zbst_utm_name` varchar(200) NOT NULL,
  `zbst_utm_term` varchar(200) NOT NULL,
  `zbst_utm_content` varchar(200) NOT NULL,
  `zbst_created` int(14) NOT NULL,
  `zbst_lastupdated` int(14) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `wpbi_zbscrm_api_keys` (
  `zbs_id` int(11) NOT NULL AUTO_INCREMENT,
  `zbs_key` varchar(200) CHARACTER SET utf8 DEFAULT NULL,
  `zbs_perm` int(1) DEFAULT NULL,
  PRIMARY KEY (`zbs_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;





/* Duplicator WordPress Timestamp: 2021-06-29 00:09:01*/
/* DUPLICATOR_MYSQLDUMP_EOF */
