--
-- Host: localhost    Database: can101_wp855
-- ------------------------------------------------------


--
-- Table structure for table `wphi_commentmeta`
--

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

--
-- Dumping data for table `wphi_commentmeta`
--


--
-- Table structure for table `wphi_comments`
--

CREATE TABLE `wphi_comments` (
  `comment_ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `comment_post_ID` bigint(20) unsigned NOT NULL DEFAULT 0,
  `comment_author` tinytext NOT NULL,
  `comment_author_email` varchar(100) NOT NULL DEFAULT '',
  `comment_author_url` varchar(200) NOT NULL DEFAULT '',
  `comment_author_IP` varchar(100) 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 NOT NULL,
  `comment_karma` int(11) NOT NULL DEFAULT 0,
  `comment_approved` varchar(20) NOT NULL DEFAULT '1',
  `comment_agent` varchar(255) NOT NULL DEFAULT '',
  `comment_type` varchar(20) NOT NULL DEFAULT '',
  `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=utf8;

--
-- Dumping data for table `wphi_comments`
--

INSERT INTO `wphi_comments` VALUES (1,1,'A WordPress Commenter','wapuu@wordpress.example','https://wordpress.org/','','2018-10-17 01:51:04','2018-10-17 01:51:04','Hi, this is a comment.\nTo get started with moderating, editing, and deleting comments, please visit the Comments screen in the dashboard.\nCommenter avatars come from <a href=\"https://gravatar.com\">Gravatar</a>.',0,'1','','',0,0);

--
-- Table structure for table `wphi_csp3_subscribers`
--

CREATE TABLE `wphi_csp3_subscribers` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `page_id` int(11) NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `fname` varchar(255) DEFAULT NULL,
  `lname` varchar(255) DEFAULT NULL,
  `ref_url` varchar(255) DEFAULT NULL,
  `clicks` int(11) NOT NULL DEFAULT 0,
  `conversions` int(11) NOT NULL DEFAULT 0,
  `referrer` int(11) NOT NULL DEFAULT 0,
  `ip` varchar(255) DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wphi_csp3_subscribers`
--


--
-- Table structure for table `wphi_cspv5_pages`
--

CREATE TABLE `wphi_cspv5_pages` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `path` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `settings` text DEFAULT NULL,
  `html` text DEFAULT NULL,
  `meta` text DEFAULT NULL,
  `mailprovider` varchar(255) DEFAULT NULL,
  `deactivate` int(11) NOT NULL DEFAULT 0,
  `created` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wphi_cspv5_pages`
--

INSERT INTO `wphi_cspv5_pages` VALUES (1,'','Coming Soon Page','cs','[encoded data, 5196 characters]',NULL,NULL,'database',0,'2018-10-18 02:02:40');

--
-- Table structure for table `wphi_links`
--

CREATE TABLE `wphi_links` (
  `link_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `link_url` varchar(255) NOT NULL DEFAULT '',
  `link_name` varchar(255) NOT NULL DEFAULT '',
  `link_image` varchar(255) NOT NULL DEFAULT '',
  `link_target` varchar(25) NOT NULL DEFAULT '',
  `link_description` varchar(255) NOT NULL DEFAULT '',
  `link_visible` varchar(20) 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) NOT NULL DEFAULT '',
  `link_notes` mediumtext NOT NULL,
  `link_rss` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`link_id`),
  KEY `link_visible` (`link_visible`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wphi_links`
--


--
-- Table structure for table `wphi_options`
--

CREATE TABLE `wphi_options` (
  `option_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `option_name` varchar(191) NOT NULL DEFAULT '',
  `option_value` longtext NOT NULL,
  `autoload` varchar(20) NOT NULL DEFAULT 'yes',
  PRIMARY KEY (`option_id`),
  UNIQUE KEY `option_name` (`option_name`)
) ENGINE=MyISAM AUTO_INCREMENT=211 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wphi_options`
--



--
-- Table structure for table `wphi_postmeta`
--

CREATE TABLE `wphi_postmeta` (
  `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `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`(191))
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wphi_postmeta`
--

INSERT INTO `wphi_postmeta` VALUES (1,2,'_wp_page_template','default'),(2,3,'_wp_page_template','default'),(6,6,'_wp_attachment_metadata','a:5:{s:5:\"width\";i:930;s:6:\"height\";i:843;s:4:\"file\";s:29:\"2018/10/Cannabis-United-8.png\";s:5:\"sizes\";a:4:{s:9:\"thumbnail\";a:4:{s:4:\"file\";s:29:\"Cannabis-United-8-150x150.png\";s:5:\"width\";i:150;s:6:\"height\";i:150;s:9:\"mime-type\";s:9:\"image/png\";}s:6:\"medium\";a:4:{s:4:\"file\";s:29:\"Cannabis-United-8-300x272.png\";s:5:\"width\";i:300;s:6:\"height\";i:272;s:9:\"mime-type\";s:9:\"image/png\";}s:12:\"medium_large\";a:4:{s:4:\"file\";s:29:\"Cannabis-United-8-768x696.png\";s:5:\"width\";i:768;s:6:\"height\";i:696;s:9:\"mime-type\";s:9:\"image/png\";}s:32:\"twentyseventeen-thumbnail-avatar\";a:4:{s:4:\"file\";s:29:\"Cannabis-United-8-100x100.png\";s:5:\"width\";i:100;s:6:\"height\";i:100;s:9:\"mime-type\";s:9:\"image/png\";}}s:10:\"image_meta\";a:12:{s:8:\"aperture\";s:1:\"0\";s:6:\"credit\";s:0:\"\";s:6:\"camera\";s:0:\"\";s:7:\"caption\";s:0:\"\";s:17:\"created_timestamp\";s:1:\"0\";s:9:\"copyright\";s:0:\"\";s:12:\"focal_length\";s:1:\"0\";s:3:\"iso\";s:1:\"0\";s:13:\"shutter_speed\";s:1:\"0\";s:5:\"title\";s:0:\"\";s:11:\"orientation\";s:1:\"0\";s:8:\"keywords\";a:0:{}}}'),(5,6,'_wp_attached_file','2018/10/Cannabis-United-8.png'),(7,7,'_wp_attached_file','2018/10/CU-background-PSZ5B2J.jpg'),(8,7,'_wp_attachment_metadata','a:5:{s:5:\"width\";i:2933;s:6:\"height\";i:1956;s:4:\"file\";s:33:\"2018/10/CU-background-PSZ5B2J.jpg\";s:5:\"sizes\";a:6:{s:9:\"thumbnail\";a:4:{s:4:\"file\";s:33:\"CU-background-PSZ5B2J-150x150.jpg\";s:5:\"width\";i:150;s:6:\"height\";i:150;s:9:\"mime-type\";s:10:\"image/jpeg\";}s:6:\"medium\";a:4:{s:4:\"file\";s:33:\"CU-background-PSZ5B2J-300x200.jpg\";s:5:\"width\";i:300;s:6:\"height\";i:200;s:9:\"mime-type\";s:10:\"image/jpeg\";}s:12:\"medium_large\";a:4:{s:4:\"file\";s:33:\"CU-background-PSZ5B2J-768x512.jpg\";s:5:\"width\";i:768;s:6:\"height\";i:512;s:9:\"mime-type\";s:10:\"image/jpeg\";}s:5:\"large\";a:4:{s:4:\"file\";s:34:\"CU-background-PSZ5B2J-1024x683.jpg\";s:5:\"width\";i:1024;s:6:\"height\";i:683;s:9:\"mime-type\";s:10:\"image/jpeg\";}s:30:\"twentyseventeen-featured-image\";a:4:{s:4:\"file\";s:35:\"CU-background-PSZ5B2J-2000x1200.jpg\";s:5:\"width\";i:2000;s:6:\"height\";i:1200;s:9:\"mime-type\";s:10:\"image/jpeg\";}s:32:\"twentyseventeen-thumbnail-avatar\";a:4:{s:4:\"file\";s:33:\"CU-background-PSZ5B2J-100x100.jpg\";s:5:\"width\";i:100;s:6:\"height\";i:100;s:9:\"mime-type\";s:10:\"image/jpeg\";}}s:10:\"image_meta\";a:12:{s:8:\"aperture\";s:3:\"2.8\";s:6:\"credit\";s:11:\"Vadim Lavra\";s:6:\"camera\";s:21:\"Canon EOS 5D Mark III\";s:7:\"caption\";s:55:\"multicolored holiday bokeh. Abstract blurred background\";s:17:\"created_timestamp\";s:10:\"1450799115\";s:9:\"copyright\";s:0:\"\";s:12:\"focal_length\";s:3:\"100\";s:3:\"iso\";s:3:\"100\";s:13:\"shutter_speed\";s:4:\"0.05\";s:5:\"title\";s:26:\"multicolored holiday bokeh\";s:11:\"orientation\";s:1:\"1\";s:8:\"keywords\";a:40:{i:0;s:10:\"background\";i:1;s:4:\"blue\";i:2;s:4:\"blur\";i:3;s:7:\"blurred\";i:4;s:5:\"bokeh\";i:5;s:6:\"bright\";i:6;s:4:\"city\";i:7;s:5:\"cubic\";i:8;s:10:\"decoration\";i:9;s:6:\"design\";i:10;s:5:\"disco\";i:11;s:7:\"dynamic\";i:12;s:6:\"effect\";i:13;s:13:\"entertainment\";i:14;s:5:\"flare\";i:15;s:4:\"glow\";i:16;s:7:\"glowing\";i:17;s:5:\"green\";i:18;s:10:\"highlights\";i:19;s:7:\"holiday\";i:20;s:11:\"illuminated\";i:21;s:12:\"illumination\";i:22;s:5:\"light\";i:23;s:5:\"magic\";i:24;s:3:\"new\";i:25;s:5:\"night\";i:26;s:9:\"nightlife\";i:27;s:7:\"pattern\";i:28;s:3:\"red\";i:29;s:8:\"romantic\";i:30;s:5:\"shape\";i:31;s:5:\"shine\";i:32;s:5:\"shiny\";i:33;s:7:\"sparkle\";i:34;s:5:\"spots\";i:35;s:8:\"twilight\";i:36;s:5:\"vivid\";i:37;s:4:\"xmas\";i:38;s:4:\"year\";i:39;s:6:\"yellow\";}}}');

--
-- Table structure for table `wphi_rp4wp_cache`
--

CREATE TABLE `wphi_rp4wp_cache` (
  `post_id` bigint(20) unsigned NOT NULL,
  `word` varchar(255) NOT NULL,
  `weight` float unsigned NOT NULL,
  `post_type` varchar(20) NOT NULL,
  PRIMARY KEY (`post_id`,`word`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wphi_rp4wp_cache`
--


--
-- Table structure for table `wphi_term_relationships`
--

CREATE TABLE `wphi_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=utf8;

--
-- Dumping data for table `wphi_term_relationships`
--

INSERT INTO `wphi_term_relationships` VALUES (1,1,0);

--
-- Table structure for table `wphi_term_taxonomy`
--

CREATE TABLE `wphi_term_taxonomy` (
  `term_taxonomy_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `term_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  `taxonomy` varchar(32) NOT NULL DEFAULT '',
  `description` longtext 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=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wphi_term_taxonomy`
--

INSERT INTO `wphi_term_taxonomy` VALUES (1,1,'category','',0,1);

--
-- Table structure for table `wphi_termmeta`
--

CREATE TABLE `wphi_termmeta` (
  `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `term_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  `meta_key` varchar(255) DEFAULT NULL,
  `meta_value` longtext DEFAULT NULL,
  PRIMARY KEY (`meta_id`),
  KEY `term_id` (`term_id`),
  KEY `meta_key` (`meta_key`(191))
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wphi_termmeta`
--


--
-- Table structure for table `wphi_terms`
--

CREATE TABLE `wphi_terms` (
  `term_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL DEFAULT '',
  `slug` varchar(200) 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=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wphi_terms`
--

INSERT INTO `wphi_terms` VALUES (1,'Uncategorized','uncategorized',0);

--
-- Table structure for table `wphi_usermeta`
--

CREATE TABLE `wphi_usermeta` (
  `umeta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  `meta_key` varchar(255) DEFAULT NULL,
  `meta_value` longtext DEFAULT NULL,
  PRIMARY KEY (`umeta_id`),
  KEY `user_id` (`user_id`),
  KEY `meta_key` (`meta_key`(191))
) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wphi_usermeta`
--

INSERT INTO `wphi_usermeta` VALUES (1,1,'nickname','RetailAdmin'),(2,1,'first_name',''),(3,1,'last_name',''),(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,'wphi_capabilities','a:1:{s:13:\"administrator\";b:1;}'),(13,1,'wphi_user_level','10'),(14,1,'dismissed_wp_pointers','wp496_privacy'),(15,1,'show_welcome_panel','0'),(17,1,'wphi_dashboard_quick_press_last_post_id','4'),(18,1,'community-events-location','a:1:{s:2:\"ip\";s:12:\"75.100.232.0\";}'),(19,1,'show_try_gutenberg_panel','0'),(20,1,'closedpostboxes_dashboard','a:4:{i:0;s:19:\"dashboard_right_now\";i:1;s:18:\"dashboard_activity\";i:2;s:21:\"dashboard_quick_press\";i:3;s:17:\"dashboard_primary\";}'),(21,1,'metaboxhidden_dashboard','a:0:{}'),(22,1,'wphi_user-settings','imgsize=full&libraryContent=browse&editor=html'),(23,1,'wphi_user-settings-time','1539828925');


