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_users` (
  `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_login` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `user_pass` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `user_nicename` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `user_email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `user_url` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `user_registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `user_activation_key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `user_status` int(11) NOT NULL DEFAULT 0,
  `display_name` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`ID`),
  KEY `user_login_key` (`user_login`),
  KEY `user_nicename` (`user_nicename`),
  KEY `user_email` (`user_email`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `wpbi_users` VALUES (1,'SteveFossey','$P$BjX5eePlUdh8188Y3JpSJBfj2Ui2xX0','stevefossey','admin@devprod.workprogress.ca','','2018-10-12 01:06:09','',0,'SteveFossey');
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 */
