--
-- Host: localhost    Database: michae20_wp641
-- ------------------------------------------------------


--
-- Table structure for table `wpik_commentmeta`
--

CREATE TABLE `wpik_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,
  PRIMARY KEY (`meta_id`),
  KEY `comment_id` (`comment_id`),
  KEY `meta_key` (`meta_key`(191))
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wpik_commentmeta`
--


--
-- Table structure for table `wpik_comments`
--

CREATE TABLE `wpik_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_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;

--
-- Dumping data for table `wpik_comments`
--


--
-- Table structure for table `wpik_links`
--

CREATE TABLE `wpik_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;

--
-- Dumping data for table `wpik_links`
--


--
-- Table structure for table `wpik_optimizepress_assets`
--

CREATE TABLE `wpik_optimizepress_assets` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `title` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `settings` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'N',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wpik_optimizepress_assets`
--


--
-- Table structure for table `wpik_optimizepress_launchfunnels`
--

CREATE TABLE `wpik_optimizepress_launchfunnels` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(254) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wpik_optimizepress_launchfunnels`
--


--
-- Table structure for table `wpik_optimizepress_launchfunnels_pages`
--

CREATE TABLE `wpik_optimizepress_launchfunnels_pages` (
  `funnel_id` bigint(20) unsigned NOT NULL,
  `page_id` bigint(20) unsigned NOT NULL,
  `step` int(10) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wpik_optimizepress_launchfunnels_pages`
--


--
-- Table structure for table `wpik_optimizepress_layout_categories`
--

CREATE TABLE `wpik_optimizepress_layout_categories` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wpik_optimizepress_layout_categories`
--

INSERT INTO `wpik_optimizepress_layout_categories` (`id`, `name`) VALUES (1,'Opt-In Pages'),(2,'Membership Pages'),(3,'Sales Pages'),(4,'Thank You Pages'),(5,'Launch Pages'),(6,'Webinar Pages');

--
-- Table structure for table `wpik_optimizepress_pb_products`
--

CREATE TABLE `wpik_optimizepress_pb_products` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `post_id` bigint(20) unsigned NOT NULL,
  `parent_id` bigint(20) unsigned NOT NULL,
  `type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wpik_optimizepress_pb_products`
--


--
-- Table structure for table `wpik_optimizepress_post_layouts`
--

CREATE TABLE `wpik_optimizepress_post_layouts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `post_id` bigint(20) unsigned NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `layout` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'publish',
  `modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=63 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wpik_optimizepress_post_layouts`
--

INSERT INTO `wpik_optimizepress_post_layouts` (`id`, `post_id`, `type`, `layout`, `status`, `modified`) VALUES (52,224,'body','[encoded data, 9820 characters]','revision','2017-04-21 15:34:36'),(50,224,'body','[encoded data, 9820 characters]','revision','2017-04-21 15:32:17'),(38,183,'body','[encoded data, 12620 characters]','revision','2017-03-19 19:17:44'),(49,224,'body','[encoded data, 12532 characters]','revision','2017-04-21 15:30:14'),(55,224,'body','[encoded data, 9820 characters]','revision','2017-04-21 15:39:39'),(59,224,'body','[encoded data, 12532 characters]','publish','2017-04-21 15:45:21'),(51,224,'body','[encoded data, 9772 characters]','revision','2017-04-21 15:32:37'),(43,183,'body','[encoded data, 12612 characters]','revision','2017-03-23 17:20:34'),(57,224,'body','[encoded data, 9772 characters]','revision','2017-04-21 15:42:41'),(44,183,'body','[encoded data, 12024 characters]','revision','2017-03-23 17:21:19'),(42,183,'body','[encoded data, 12612 characters]','revision','2017-03-23 14:37:29'),(58,224,'body','[encoded data, 9820 characters]','revision','2017-04-21 15:44:42'),(56,224,'body','[encoded data, 12532 characters]','revision','2017-04-21 15:40:17'),(54,224,'body','[encoded data, 9772 characters]','revision','2017-04-21 15:37:39'),(62,183,'body','[encoded data, 12152 characters]','publish','2017-05-03 15:30:07'),(22,183,'body','[encoded data, 12180 characters]','revision','2017-03-19 18:25:20'),(37,183,'body','[encoded data, 12596 characters]','revision','2017-03-19 19:17:03'),(53,224,'body','[encoded data, 12532 characters]','revision','2017-04-21 15:35:18'),(33,183,'body','[encoded data, 12596 characters]','revision','2017-03-19 19:12:10'),(35,183,'body','[encoded data, 12596 characters]','revision','2017-03-19 19:14:47'),(61,183,'body','[encoded data, 12124 characters]','revision','2017-05-03 15:19:31'),(60,183,'body','[encoded data, 12004 characters]','revision','2017-05-03 15:10:28');

--
