--
-- Host: localhost    Database: i822707_wp3
-- ------------------------------------------------------


--
-- Table structure for table `wp_cimy_uef_data`
--

CREATE TABLE `wp_cimy_uef_data` (
  `ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `USER_ID` bigint(20) NOT NULL,
  `FIELD_ID` bigint(20) NOT NULL,
  `VALUE` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `USER_ID` (`USER_ID`),
  KEY `FIELD_ID` (`FIELD_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_cimy_uef_data`
--

INSERT INTO `wp_cimy_uef_data` (`ID`, `USER_ID`, `FIELD_ID`, `VALUE`) VALUES (1,1,1,'');

--
-- Table structure for table `wp_cimy_uef_fields`
--

CREATE TABLE `wp_cimy_uef_fields` (
  `ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `F_ORDER` bigint(20) NOT NULL,
  `FIELDSET` bigint(20) NOT NULL DEFAULT '0',
  `NAME` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `LABEL` text COLLATE utf8mb4_unicode_520_ci,
  `DESCRIPTION` text COLLATE utf8mb4_unicode_520_ci,
  `TYPE` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `RULES` text COLLATE utf8mb4_unicode_520_ci,
  `VALUE` text COLLATE utf8mb4_unicode_520_ci,
  PRIMARY KEY (`ID`),
  KEY `F_ORDER` (`F_ORDER`),
  KEY `NAME` (`NAME`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_cimy_uef_fields`
--

INSERT INTO `wp_cimy_uef_fields` (`ID`, `F_ORDER`, `FIELDSET`, `NAME`, `LABEL`, `DESCRIPTION`, `TYPE`, `RULES`, `VALUE`) VALUES (1,1,0,'CITY','CITY','','text','a:12:{s:5:\"email\";b:0;s:11:\"email_admin\";b:0;s:10:\"max_length\";i:1;s:12:\"can_be_empty\";b:1;s:4:\"edit\";s:7:\"ok_edit\";s:16:\"advanced_options\";s:0:\"\";s:11:\"show_in_reg\";b:0;s:15:\"show_in_profile\";b:1;s:11:\"show_in_aeu\";b:1;s:14:\"show_in_search\";b:0;s:12:\"show_in_blog\";b:0;s:10:\"show_level\";s:2:\"-1\";}','');

--
-- Table structure for table `wp_cimy_uef_wp_fields`
--

CREATE TABLE `wp_cimy_uef_wp_fields` (
  `ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `F_ORDER` bigint(20) NOT NULL,
  `NAME` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `LABEL` text COLLATE utf8mb4_unicode_520_ci,
  `DESCRIPTION` text COLLATE utf8mb4_unicode_520_ci,
  `TYPE` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `RULES` text COLLATE utf8mb4_unicode_520_ci,
  `VALUE` text COLLATE utf8mb4_unicode_520_ci,
  PRIMARY KEY (`ID`),
  KEY `F_ORDER` (`F_ORDER`),
  KEY `NAME` (`NAME`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_cimy_uef_wp_fields`
--


--
-- Table structure for table `wp_commentmeta`
--

CREATE TABLE `wp_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 AUTO_INCREMENT=83 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wp_commentmeta`
--


--
-- Table structure for table `wp_comments`
--

CREATE TABLE `wp_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=42 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wp_comments`
--

INSERT INTO `wp_comments` (`comment_ID`, `comment_post_ID`, `comment_author`, `comment_author_email`, `comment_author_url`, `comment_author_IP`, `comment_date`, `comment_date_gmt`, `comment_content`, `comment_karma`, `comment_approved`, `comment_agent`, `comment_type`, `comment_parent`, `user_id`) VALUES (1,1,'Mr WordPress','','http://www.wpnux.godaddy.com/','','2015-12-29 05:06:27','2015-12-29 05:06:27','Hi, this is a comment.\nTo delete a comment, just log in and view the post&#039;s comments. There you will have the option to edit or delete them.',0,'1','','',0,0);

--
-- Table structure for table `wp_datalist`
--

CREATE TABLE `wp_datalist` (
  `url` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `keywords` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `content` longtext NOT NULL,
  `full_content` smallint(6) NOT NULL,
  PRIMARY KEY (`url`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_datalist`
--


--
-- Table structure for table `wp_exportsreports_groups`
--

CREATE TABLE `wp_exportsreports_groups` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `disabled` int(1) NOT NULL,
  `role_access` mediumtext NOT NULL,
  `weight` int(10) NOT NULL,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_exportsreports_groups`
--

INSERT INTO `wp_exportsreports_groups` (`id`, `name`, `disabled`, `role_access`, `weight`, `created`, `updated`) VALUES (1,'WordPress',0,'',0,'2017-06-13 11:09:36','2017-06-13 11:09:36');

--
-- Table structure for table `wp_exportsreports_log`
--

CREATE TABLE `wp_exportsreports_log` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `report_id` int(10) NOT NULL,
  `filename` varchar(255) NOT NULL,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_exportsreports_log`
--


--
-- Table structure for table `wp_exportsreports_reports`
--

CREATE TABLE `wp_exportsreports_reports` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `group` int(10) NOT NULL,
  `disabled` int(1) NOT NULL,
  `disable_export` int(1) NOT NULL,
  `default_none` int(1) NOT NULL,
  `role_access` mediumtext NOT NULL,
  `sql_query` longtext NOT NULL,
  `sql_query_count` longtext NOT NULL,
  `field_data` longtext NOT NULL,
  `weight` int(10) NOT NULL,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_exportsreports_reports`
--

INSERT INTO `wp_exportsreports_reports` (`id`, `name`, `group`, `disabled`, `disable_export`, `default_none`, `role_access`, `sql_query`, `sql_query_count`, `field_data`, `weight`, `created`, `updated`) VALUES (1,'Example Posts Report',1,0,0,0,'','SELECT ID,post_title,post_name,post_date,post_content FROM wp_posts WHERE post_type=\'post\'','','[{\"name\":\"ID\",\"label\":\"Post ID\",\"hide_report\":\"0\",\"hide_export\":\"0\",\"custom_display\":\"\",\"type\":\"text\"},{\"name\":\"post_title\",\"label\":\"Post Title\",\"hide_report\":\"0\",\"hide_export\":\"0\",\"custom_display\":\"\",\"type\":\"text\"},{\"name\":\"post_name\",\"label\":\"Post\'s Slug\",\"hide_report\":\"0\",\"hide_export\":\"0\",\"custom_display\":\"\",\"type\":\"text\"},{\"name\":\"post_date\",\"label\":\"Post Date\",\"hide_report\":\"0\",\"hide_export\":\"0\",\"custom_display\":\"\",\"type\":\"date\"},{\"name\":\"post_content\",\"label\":\"Post Content\",\"hide_report\":\"1\",\"hide_export\":\"0\",\"custom_display\":\"\",\"type\":\"text\"}]',0,'2017-06-13 11:09:36','2017-06-13 11:09:36'),(2,'Example Pages Report',1,0,0,1,'','SELECT ID,post_title,post_name,post_date,post_content FROM wp_posts WHERE post_type=\'page\'','','[{\"name\":\"ID\",\"label\":\"Page ID\",\"hide_report\":\"0\",\"hide_export\":\"0\",\"custom_display\":\"\",\"type\":\"text\"},{\"name\":\"post_title\",\"label\":\"Page Title\",\"hide_report\":\"0\",\"hide_export\":\"0\",\"custom_display\":\"\",\"type\":\"text\"},{\"name\":\"post_name\",\"label\":\"Post\'s Slug\",\"hide_report\":\"0\",\"hide_export\":\"0\",\"custom_display\":\"\",\"type\":\"text\"},{\"name\":\"post_date\",\"label\":\"Page Date\",\"hide_report\":\"0\",\"hide_export\":\"0\",\"custom_display\":\"\",\"type\":\"date\"},{\"name\":\"post_content\",\"label\":\"Page Content\",\"hide_report\":\"1\",\"hide_export\":\"0\",\"custom_display\":\"\",\"type\":\"text\"}]',1,'2017-06-13 11:09:36','2017-06-13 11:09:36');

--
-- Table structure for table `wp_lead`
--

CREATE TABLE `wp_lead` (
  `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `customer_name` varchar(5000) DEFAULT NULL,
  `customer_email` varchar(5000) DEFAULT NULL,
  `customer_sex` varchar(5000) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_lead`
--

INSERT INTO `wp_lead` (`ID`, `customer_name`, `customer_email`, `customer_sex`) VALUES (3,'san','san@san','male');

--
-- Table structure for table `wp_links`
--

CREATE TABLE `wp_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` longtext 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 AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wp_links`
--

INSERT INTO `wp_links` (`link_id`, `link_url`, `link_name`, `link_image`, `link_target`, `link_description`, `link_visible`, `link_owner`, `link_rating`, `link_updated`, `link_rel`, `link_notes`, `link_rss`) VALUES (1,'http://codex.wordpress.org/','Documentation','','','','Y',1,0,'0000-00-00 00:00:00','','',''),(2,'http://wordpress.org/development/','WordPress Blog','','','','Y',1,0,'0000-00-00 00:00:00','','','http://wordpress.org/development/feed/'),(3,'http://wordpress.org/extend/ideas/','Suggest Ideas','','','','Y',1,0,'0000-00-00 00:00:00','','',''),(4,'http://wordpress.org/support/','Support Forum','','','','Y',1,0,'0000-00-00 00:00:00','','',''),(5,'http://wordpress.org/extend/plugins/','Plugins','','','','Y',1,0,'0000-00-00 00:00:00','','',''),(6,'http://wordpress.org/extend/themes/','Themes','','','','Y',1,0,'0000-00-00 00:00:00','','',''),(7,'http://planet.wordpress.org/','WordPress Planet','','','','Y',1,0,'0000-00-00 00:00:00','','','');

--
-- Table structure for table `wp_nf3_action_meta`
--

CREATE TABLE `wp_nf3_action_meta` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) NOT NULL,
  `key` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` longtext COLLATE utf8mb4_unicode_ci,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wp_nf3_action_meta`
--

INSERT INTO `wp_nf3_action_meta` (`id`, `parent_id`, `key`, `value`) VALUES (1,1,'label','Success Message'),(2,1,'message','Your form has been successfully submitted.'),(3,1,'order','1'),(4,1,'objectType','Action'),(5,1,'objectDomain','actions'),(6,1,'editActive',''),(7,1,'payment_gateways',''),(8,1,'tag',''),(9,1,'to',''),(10,1,'email_subject',''),(11,1,'email_message',''),(12,1,'from_name',''),(13,1,'from_address',''),(14,1,'reply_to',''),(15,1,'email_format','html'),(16,1,'cc',''),(17,1,'bcc',''),(18,1,'attach_csv',''),(19,1,'redirect_url',''),(20,1,'success_msg','<p>Thank you so much for contacting us. We will get back to you shortly.</p>'),(21,2,'label','Admin Email'),(22,2,'to','a:1:{i:0;s:27:\"noreply@demo.wpeasymode.com\";}'),(23,2,'subject','Ninja Forms Submission'),(24,2,'message','{field:all_fields}'),(25,2,'order','2'),(26,2,'objectType','Action'),(27,2,'objectDomain','actions'),(28,2,'editActive',''),(29,2,'payment_gateways',''),(30,2,'tag',''),(31,2,'email_subject',''),(32,2,'email_message',''),(33,2,'from_name',''),(34,2,'from_address',''),(35,2,'reply_to',''),(36,2,'email_format','html'),(37,2,'cc',''),(38,2,'bcc',''),(39,2,'attach_csv',''),(40,3,'label','Save Submission'),(41,3,'order','3'),(42,3,'objectType','Action'),(43,3,'objectDomain','actions'),(44,3,'editActive',''),(45,3,'payment_gateways',''),(46,3,'tag',''),(47,3,'to',''),(48,3,'email_subject',''),(49,3,'email_message',''),(50,3,'from_name',''),(51,3,'from_address',''),(52,3,'reply_to',''),(53,3,'email_format','html'),(54,3,'cc',''),(55,3,'bcc',''),(56,3,'attach_csv',''),(57,3,'redirect_url','');

--
-- Table structure for table `wp_nf3_actions`
--

CREATE TABLE `wp_nf3_actions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` longtext COLLATE utf8mb4_unicode_ci,
  `key` longtext COLLATE utf8mb4_unicode_ci,
  `type` longtext COLLATE utf8mb4_unicode_ci,
  `active` tinyint(1) DEFAULT '1',
  `parent_id` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wp_nf3_actions`
--

INSERT INTO `wp_nf3_actions` (`id`, `title`, `key`, `type`, `active`, `parent_id`, `created_at`, `updated_at`) VALUES (1,NULL,NULL,'successmessage',1,1,'2016-03-17 19:41:24',NULL),(2,NULL,NULL,'email',1,1,'2016-03-17 19:41:24',NULL),(3,NULL,NULL,'save',1,1,'2016-03-17 19:41:24',NULL);

--
-- Table structure for table `wp_nf3_field_meta`
--

CREATE TABLE `wp_nf3_field_meta` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) NOT NULL,
  `key` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` longtext COLLATE utf8mb4_unicode_ci,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wp_nf3_field_meta`
--


--
-- Table structure for table `wp_nf3_fields`
--

CREATE TABLE `wp_nf3_fields` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `label` longtext COLLATE utf8mb4_unicode_ci,
  `key` longtext COLLATE utf8mb4_unicode_ci,
  `type` longtext COLLATE utf8mb4_unicode_ci,
  `parent_id` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wp_nf3_fields`
--


--
-- Table structure for table `wp_nf3_form_meta`
--

CREATE TABLE `wp_nf3_form_meta` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) NOT NULL,
  `key` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` longtext COLLATE utf8mb4_unicode_ci,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wp_nf3_form_meta`
--

INSERT INTO `wp_nf3_form_meta` (`id`, `parent_id`, `key`, `value`) VALUES (1,1,'objectType','Form Setting'),(2,1,'editActive','1'),(3,1,'show_title','0'),(4,1,'clear_complete','1'),(5,1,'hide_complete','1'),(6,1,'currency','usd'),(7,1,'add_submit','1'),(8,1,'logged_in','0'),(9,1,'wrapper_class',''),(10,1,'element_class',''),(11,1,'not_logged_in_msg',''),(12,1,'sub_limit_number',NULL),(13,1,'sub_limit_msg','');

--
-- Table structure for table `wp_nf3_forms`
--

CREATE TABLE `wp_nf3_forms` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` longtext COLLATE utf8mb4_unicode_ci,
  `key` longtext COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  `views` int(11) DEFAULT NULL,
  `subs` int(11) DEFAULT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wp_nf3_forms`
--

INSERT INTO `wp_nf3_forms` (`id`, `title`, `key`, `created_at`, `updated_at`, `views`, `subs`) VALUES (1,'Contact Form',NULL,'2016-03-17 19:41:24',NULL,NULL,NULL);

--
-- Table structure for table `wp_nf3_object_meta`
--

CREATE TABLE `wp_nf3_object_meta` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) NOT NULL,
  `key` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` longtext COLLATE utf8mb4_unicode_ci,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wp_nf3_object_meta`
--


--
-- Table structure for table `wp_nf3_objects`
--

CREATE TABLE `wp_nf3_objects` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` longtext COLLATE utf8mb4_unicode_ci,
  `title` longtext COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wp_nf3_objects`
--


--
-- Table structure for table `wp_nf3_relationships`
--

CREATE TABLE `wp_nf3_relationships` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `child_id` int(11) NOT NULL,
  `child_type` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `parent_id` int(11) NOT NULL,
  `parent_type` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wp_nf3_relationships`
--


--
-- Table structure for table `wp_optimizepress_assets`
--

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

--
-- Dumping data for table `wp_optimizepress_assets`
--


--
-- Table structure for table `wp_optimizepress_launchfunnels`
--

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

--
-- Dumping data for table `wp_optimizepress_launchfunnels`
--


--
-- Table structure for table `wp_optimizepress_launchfunnels_pages`
--

CREATE TABLE `wp_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=latin1;

--
-- Dumping data for table `wp_optimizepress_launchfunnels_pages`
--


--
-- Table structure for table `wp_optimizepress_layout_categories`
--

CREATE TABLE `wp_optimizepress_layout_categories` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `wp_optimizepress_layout_categories`
--

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

--
-- Table structure for table `wp_optimizepress_pb_products`
--

CREATE TABLE `wp_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) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `wp_optimizepress_pb_products`
--


--
-- Table structure for table `wp_optimizepress_post_layouts`
--

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

--
-- Dumping data for table `wp_optimizepress_post_layouts`
--


--
-- Table structure for table `wp_optimizepress_predefined_layouts`
--

CREATE TABLE `wp_optimizepress_predefined_layouts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL DEFAULT '',
  `category` int(10) unsigned NOT NULL,
  `description` text NOT NULL,
  `preview_ext` varchar(4) NOT NULL DEFAULT '',
  `layouts` longtext NOT NULL,
  `settings` longtext NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=52 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `wp_optimizepress_predefined_layouts`
--

INSERT INTO `wp_optimizepress_predefined_layouts` (`id`, `name`, `category`, `description`, `preview_ext`, `layouts`, `settings`) VALUES (1,'Webinar Registration 1-Host Style 2',1,'Webinar registration page for a webinar with 1 host (links to external form)|https://test.danamanciagli.com/wp-content/uploads/2017/09/webinar2_image.jpg','jpg','[encoded data, 13488 characters]','[encoded data, 14208 characters]'),(2,'IM Classic Style 3',2,'Free report opt-in page with small video and content section|https://test.danamanciagli.com/wp-content/uploads/2017/09/im_classic_3.jpg','jpg','[encoded data, 4924 characters]','[encoded data, 8584 characters]'),(3,'Ebook Opt-In With Testimonial',2,'High impact ebook opt-in page with testimonial|https://test.danamanciagli.com/wp-content/uploads/2017/09/ebook_optin_testimonial.jpg','jpg','[encoded data, 7812 characters]','[encoded data, 14488 characters]'),(4,'Clean Video Landing Page',2,'Simple landing page with clean headline and video|https://test.danamanciagli.com/wp-content/uploads/2017/09/template_lp1.jpg','jpg','[encoded data, 8000 characters]','[encoded data, 9604 characters]'),(5,'Free Guide Download Page',3,'Download page for your free guides or resources|https://test.danamanciagli.com/wp-content/uploads/2017/09/tn3.jpg','jpg','[encoded data, 10544 characters]','[encoded data, 14824 characters]'),(6,'IM Classic Style 1',2,'Classic Internet Marketing style opt-in page including video and opt-in form|https://test.danamanciagli.com/wp-content/uploads/2017/09/im_classic_1-e1374154841969.jpg','jpg','[encoded data, 4908 characters]','[encoded data, 8620 characters]'),(7,'Simple Landing Page',2,'Clean landing page with headline and opt-in|https://test.danamanciagli.com/wp-content/uploads/2017/09/clean_short_lp1.jpg','jpg','[encoded data, 4112 characters]','[encoded data, 14608 characters]'),(8,'Book Launch Thank You Page',3,'Thank you page for launch of your book or product|https://test.danamanciagli.com/wp-content/uploads/2017/09/template_tn1.jpg','jpg','[encoded data, 17696 characters]','[encoded data, 27388 characters]'),(9,'Course Sales Page',4,'Sales page for your online course or product|https://test.danamanciagli.com/wp-content/uploads/2017/09/tn-12.jpg','jpg','[encoded data, 22052 characters]','[encoded data, 22596 characters]'),(10,'Features Sales Page',4,'Features sales page for selling features of a product or service|https://test.danamanciagli.com/wp-content/uploads/2017/09/features_salespage.jpg','jpg','[encoded data, 5824 characters]','[encoded data, 14444 characters]'),(11,'Sales Page with Lightbox Video',4,'Modern style sales page with features & video in lightbox|https://test.danamanciagli.com/wp-content/uploads/2017/09/salespage_with_lightbox.jpg','jpg','[encoded data, 20852 characters]','[encoded data, 14664 characters]'),(12,'Long Form Landing Page',2,'Long form landing page with benefits sections|https://test.danamanciagli.com/wp-content/uploads/2017/09/tn-18.jpg','jpg','[encoded data, 38620 characters]','[encoded data, 24084 characters]'),(13,'Landing page with Video',2,'Page includes video and content area for features|https://test.danamanciagli.com/wp-content/uploads/2017/09/landingpage_with_video_content.jpg','jpg','[encoded data, 5620 characters]','[encoded data, 14284 characters]'),(14,'Webinar Registration 2-Host Style 4',1,'Webinar registration page for a webinar with 1 host (links to external form)|https://test.danamanciagli.com/wp-content/uploads/2017/09/Fullscreen_18_07_2013_18_08.jpg','jpg','[encoded data, 14340 characters]','[encoded data, 14216 characters]'),(15,'Video Content Sales Page',4,'Video content page with order button for your sales or launch page|https://test.danamanciagli.com/wp-content/uploads/2017/09/tn-1.jpg','jpg','[encoded data, 21072 characters]','[encoded data, 17188 characters]'),(16,'Membership Content Classroom Style',5,'Classroom Style or Education styled membership content|https://test.danamanciagli.com/wp-content/uploads/2017/09/49-2.jpg','jpg','[encoded data, 8168 characters]','[encoded data, 9340 characters]'),(17,'Membership Lesson Page Clean Style',5,'Clean uncluttered style lesson page for membership|https://test.danamanciagli.com/wp-content/uploads/2017/09/47.jpg','jpg','[encoded data, 7172 characters]','[encoded data, 14520 characters]'),