-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `heatcontent_dev`
--

-- --------------------------------------------------------

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

CREATE TABLE `wp_commentmeta` (
  `meta_id` bigint(20) UNSIGNED NOT NULL,
  `comment_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
  `meta_key` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `meta_value` longtext COLLATE utf8mb4_unicode_520_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

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

CREATE TABLE `wp_comments` (
  `comment_ID` bigint(20) UNSIGNED NOT NULL,
  `comment_post_ID` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
  `comment_author` tinytext COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `comment_author_email` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `comment_author_url` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `comment_author_IP` varchar(100) COLLATE utf8mb4_unicode_520_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_520_ci NOT NULL,
  `comment_karma` int(11) NOT NULL DEFAULT '0',
  `comment_approved` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '1',
  `comment_agent` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `comment_type` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `comment_parent` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
  `user_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

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

CREATE TABLE `wp_links` (
  `link_id` bigint(20) UNSIGNED NOT NULL,
  `link_url` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `link_name` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `link_image` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `link_target` varchar(25) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `link_description` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `link_visible` varchar(20) COLLATE utf8mb4_unicode_520_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_520_ci NOT NULL DEFAULT '',
  `link_notes` mediumtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `link_rss` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `wp_options`
--

CREATE TABLE `wp_options` (
  `option_id` bigint(20) UNSIGNED NOT NULL,
  `option_name` varchar(191) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `option_value` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `autoload` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'yes'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;



-- --------------------------------------------------------

--
-- Table structure for table `wp_postmeta`
--

CREATE TABLE `wp_postmeta` (
  `meta_id` bigint(20) UNSIGNED NOT NULL,
  `post_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
  `meta_key` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `meta_value` longtext COLLATE utf8mb4_unicode_520_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_postmeta`
--

INSERT INTO `wp_postmeta` (`meta_id`, `post_id`, `meta_key`, `meta_value`) VALUES
(1, 2, '_wp_page_template', 'default'),
(2, 3, '_wp_page_template', 'default'),
(3, 5, '_edit_last', '1'),
(4, 5, '_edit_lock', '1535720871:1'),
(5, 6, '_wp_attached_file', '2018/08/photo.jpg'),
(6, 6, '_wp_attachment_metadata', 'a:5:{s:5:\"width\";i:352;s:6:\"height\";i:406;s:4:\"file\";s:17:\"2018/08/photo.jpg\";s:5:\"sizes\";a:1:{s:9:\"thumbnail\";a:4:{s:4:\"file\";s:17:\"photo-150x150.jpg\";s:5:\"width\";i:150;s:6:\"height\";i:150;s:9:\"mime-type\";s:10:\"image/jpeg\";}}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:{}}}'),
(15, 5, '_thumbnail_id', '6'),
(18, 10, '_edit_last', '1'),
(19, 10, 'field_5b842ac615516', 'a:14:{s:3:\"key\";s:19:\"field_5b842ac615516\";s:5:\"label\";s:21:\"Nome do profissional \";s:4:\"name\";s:12:\"profissional\";s:4:\"type\";s:4:\"text\";s:12:\"instructions\";s:0:\"\";s:8:\"required\";s:1:\"1\";s:13:\"default_value\";s:0:\"\";s:11:\"placeholder\";s:34:\"Digite o nome do profissional aqui\";s:7:\"prepend\";s:0:\"\";s:6:\"append\";s:0:\"\";s:10:\"formatting\";s:4:\"html\";s:9:\"maxlength\";s:0:\"\";s:17:\"conditional_logic\";a:3:{s:6:\"status\";s:1:\"0\";s:5:\"rules\";a:1:{i:0;a:3:{s:5:\"field\";s:4:\"null\";s:8:\"operator\";s:2:\"==\";s:5:\"value\";s:0:\"\";}}s:8:\"allorany\";s:3:\"all\";}s:8:\"order_no\";i:0;}'),
(21, 10, 'position', 'normal'),
(22, 10, 'layout', 'no_box'),
(23, 10, 'hide_on_screen', ''),
(24, 10, '_edit_lock', '1535404184:1'),
(28, 12, 'profissional', 'Felipe'),
(29, 12, '_profissional', 'field_5b842ac615516'),
(30, 5, 'profissional', 'Felipe'),
(31, 5, '_profissional', 'field_5b842ac615516'),
(32, 10, 'field_5b842ca050668', 'a:14:{s:3:\"key\";s:19:\"field_5b842ca050668\";s:5:\"label\";s:22:\"Cargo do profissional \";s:4:\"name\";s:5:\"cargo\";s:4:\"type\";s:4:\"text\";s:12:\"instructions\";s:0:\"\";s:8:\"required\";s:1:\"0\";s:13:\"default_value\";s:0:\"\";s:11:\"placeholder\";s:35:\"Digite o cargo do profissional aqui\";s:7:\"prepend\";s:0:\"\";s:6:\"append\";s:0:\"\";s:10:\"formatting\";s:4:\"html\";s:9:\"maxlength\";s:0:\"\";s:17:\"conditional_logic\";a:3:{s:6:\"status\";s:1:\"0\";s:5:\"rules\";a:1:{i:0;a:3:{s:5:\"field\";s:4:\"null\";s:8:\"operator\";s:2:\"==\";s:5:\"value\";s:0:\"\";}}s:8:\"allorany\";s:3:\"all\";}s:8:\"order_no\";i:1;}'),
(36, 13, 'profissional', 'Felipe'),
(37, 13, '_profissional', 'field_5b842ac615516'),
(38, 13, 'cargo', 'Front-end developer'),
(39, 13, '_cargo', 'field_5b842ca050668'),
(40, 5, 'cargo', 'Front-end developer'),
(41, 5, '_cargo', 'field_5b842ca050668'),
(42, 10, 'field_5b842d65972a6', 'a:14:{s:3:\"key\";s:19:\"field_5b842d65972a6\";s:5:\"label\";s:7:\"Empresa\";s:4:\"name\";s:7:\"empresa\";s:4:\"type\";s:4:\"text\";s:12:\"instructions\";s:0:\"\";s:8:\"required\";s:1:\"0\";s:13:\"default_value\";s:0:\"\";s:11:\"placeholder\";s:29:\"Digite o nome da empresa aqui\";s:7:\"prepend\";s:0:\"\";s:6:\"append\";s:0:\"\";s:10:\"formatting\";s:4:\"html\";s:9:\"maxlength\";s:0:\"\";s:17:\"conditional_logic\";a:3:{s:6:\"status\";s:1:\"0\";s:5:\"rules\";a:1:{i:0;a:3:{s:5:\"field\";s:4:\"null\";s:8:\"operator\";s:2:\"==\";s:5:\"value\";s:0:\"\";}}s:8:\"allorany\";s:3:\"all\";}s:8:\"order_no\";i:2;}'),
(46, 14, 'profissional', 'Felipe'),
(47, 14, '_profissional', 'field_5b842ac615516'),
(48, 14, 'cargo', 'Front-end developer'),
(49, 14, '_cargo', 'field_5b842ca050668'),
(50, 14, 'empresa', 'Cappen'),
(51, 14, '_empresa', 'field_5b842d65972a6'),
(52, 5, 'empresa', 'Cappen'),
(53, 5, '_empresa', 'field_5b842d65972a6'),
(54, 10, 'field_5b842ff56e3d7', 'a:15:{s:3:\"key\";s:19:\"field_5b842ff56e3d7\";s:5:\"label\";s:11:\"Data e Hora\";s:4:\"name\";s:11:\"data-e-hora\";s:4:\"type\";s:16:\"date_time_picker\";s:12:\"instructions\";s:0:\"\";s:8:\"required\";s:1:\"0\";s:9:\"show_date\";s:4:\"true\";s:11:\"date_format\";s:8:\"yy-mm-dd\";s:11:\"time_format\";s:8:\"HH:mm:ss\";s:16:\"show_week_number\";s:5:\"false\";s:6:\"picker\";s:6:\"slider\";s:17:\"save_as_timestamp\";s:4:\"true\";s:16:\"get_as_timestamp\";s:5:\"false\";s:17:\"conditional_logic\";a:3:{s:6:\"status\";s:1:\"0\";s:5:\"rules\";a:1:{i:0;a:2:{s:5:\"field\";s:4:\"null\";s:8:\"operator\";s:2:\"==\";}}s:8:\"allorany\";s:3:\"all\";}s:8:\"order_no\";i:3;}'),
(59, 16, 'profissional', 'Felipe'),
(60, 16, '_profissional', 'field_5b842ac615516'),
(61, 16, 'cargo', 'Front-end developer'),
(62, 16, '_cargo', 'field_5b842ca050668'),
(63, 16, 'empresa', 'Cappen'),
(64, 16, '_empresa', 'field_5b842d65972a6'),
(65, 16, 'data-e-hora', '1850193000'),
(66, 16, '_data-e-hora', 'field_5b842ff56e3d7'),
(67, 5, 'data-e-hora', '1535477400'),
(68, 5, '_data-e-hora', 'field_5b842ff56e3d7'),
(75, 17, 'profissional', 'Felipe'),
(76, 17, '_profissional', 'field_5b842ac615516'),
(77, 17, 'cargo', 'Front-end developer'),
(78, 17, '_cargo', 'field_5b842ca050668'),
(79, 17, 'empresa', 'Cappen'),
(80, 17, '_empresa', 'field_5b842d65972a6'),
(81, 17, 'data-e-hora', ''),
(82, 17, '_data-e-hora', 'field_5b842ff56e3d7'),
(85, 18, 'profissional', 'Felipe'),
(86, 18, '_profissional', 'field_5b842ac615516'),
(87, 18, 'cargo', 'Front-end developer'),
(88, 18, '_cargo', 'field_5b842ca050668'),
(89, 18, 'empresa', 'Cappen'),
(90, 18, '_empresa', 'field_5b842d65972a6'),
(91, 18, 'data-e-hora', ''),
(92, 18, '_data-e-hora', 'field_5b842ff56e3d7'),
(96, 19, 'profissional', 'Felipe'),
(97, 19, '_profissional', 'field_5b842ac615516'),
(98, 19, 'cargo', 'Front-end developer'),
(99, 19, '_cargo', 'field_5b842ca050668'),
(100, 19, 'empresa', 'Cappen'),
(101, 19, '_empresa', 'field_5b842d65972a6'),
(102, 19, 'data-e-hora', '1535477400'),
(103, 19, '_data-e-hora', 'field_5b842ff56e3d7'),
(107, 10, 'field_5b843d000ac2d', 'a:14:{s:3:\"key\";s:19:\"field_5b843d000ac2d\";s:5:\"label\";s:6:\"Preço\";s:4:\"name\";s:5:\"preco\";s:4:\"type\";s:4:\"text\";s:12:\"instructions\";s:0:\"\";s:8:\"required\";s:1:\"0\";s:13:\"default_value\";s:0:\"\";s:11:\"placeholder\";s:27:\"Digite o preço da palestra\";s:7:\"prepend\";s:0:\"\";s:6:\"append\";s:0:\"\";s:10:\"formatting\";s:4:\"html\";s:9:\"maxlength\";s:0:\"\";s:17:\"conditional_logic\";a:3:{s:6:\"status\";s:1:\"0\";s:5:\"rules\";a:1:{i:0;a:3:{s:5:\"field\";s:4:\"null\";s:8:\"operator\";s:2:\"==\";s:5:\"value\";s:0:\"\";}}s:8:\"allorany\";s:3:\"all\";}s:8:\"order_no\";i:4;}'),
(115, 21, 'profissional', 'Felipe'),
(116, 21, '_profissional', 'field_5b842ac615516'),
(117, 21, 'cargo', 'Front-end developer'),
(118, 21, '_cargo', 'field_5b842ca050668'),
(119, 21, 'empresa', 'Cappen'),
(120, 21, '_empresa', 'field_5b842d65972a6'),
(121, 21, 'data-e-hora', '1535477400'),
(122, 21, '_data-e-hora', 'field_5b842ff56e3d7'),
(123, 21, 'preco', '100,00'),
(124, 21, '_preco', 'field_5b843d000ac2d'),
(125, 5, 'preco', '100,00'),
(126, 5, '_preco', 'field_5b843d000ac2d'),
(127, 10, 'field_5b84432a0a467', 'a:15:{s:3:\"key\";s:19:\"field_5b84432a0a467\";s:5:\"label\";s:5:\"Vagas\";s:4:\"name\";s:5:\"vagas\";s:4:\"type\";s:6:\"number\";s:12:\"instructions\";s:0:\"\";s:8:\"required\";s:1:\"0\";s:13:\"default_value\";s:0:\"\";s:11:\"placeholder\";s:0:\"\";s:7:\"prepend\";s:0:\"\";s:6:\"append\";s:0:\"\";s:3:\"min\";s:0:\"\";s:3:\"max\";s:0:\"\";s:4:\"step\";s:0:\"\";s:17:\"conditional_logic\";a:3:{s:6:\"status\";s:1:\"0\";s:5:\"rules\";a:1:{i:0;a:3:{s:5:\"field\";s:4:\"null\";s:8:\"operator\";s:2:\"==\";s:5:\"value\";s:0:\"\";}}s:8:\"allorany\";s:3:\"all\";}s:8:\"order_no\";i:5;}'),
(131, 22, 'profissional', 'Felipe'),
(132, 22, '_profissional', 'field_5b842ac615516'),
(133, 22, 'cargo', 'Front-end developer'),
(134, 22, '_cargo', 'field_5b842ca050668'),
(135, 22, 'empresa', 'Cappen'),
(136, 22, '_empresa', 'field_5b842d65972a6'),
(137, 22, 'data-e-hora', '1535477400'),
(138, 22, '_data-e-hora', 'field_5b842ff56e3d7'),
(139, 22, 'preco', '100,00'),
(140, 22, '_preco', 'field_5b843d000ac2d'),
(141, 22, 'vagas', '150'),
(142, 22, '_vagas', 'field_5b84432a0a467'),
(143, 5, 'vagas', '150'),
(144, 5, '_vagas', 'field_5b84432a0a467'),
(145, 24, '_edit_last', '1'),
(146, 24, '_edit_lock', '1535725160:1'),
(149, 25, 'profissional', 'Felipe'),
(150, 25, '_profissional', 'field_5b842ac615516'),
(151, 25, 'cargo', 'Front-end developer'),
(152, 25, '_cargo', 'field_5b842ca050668'),
(153, 25, 'empresa', 'Cappen'),
(154, 25, '_empresa', 'field_5b842d65972a6'),
(155, 25, 'data-e-hora', '1535542080'),
(156, 25, '_data-e-hora', 'field_5b842ff56e3d7'),
(157, 25, 'preco', '2,00'),
(158, 25, '_preco', 'field_5b843d000ac2d'),
(159, 25, 'vagas', '200'),
(160, 25, '_vagas', 'field_5b84432a0a467'),
(161, 24, 'profissional', 'Felipe'),
(162, 24, '_profissional', 'field_5b842ac615516'),
(163, 24, 'cargo', 'Front-end developer'),
(164, 24, '_cargo', 'field_5b842ca050668'),
(165, 24, 'empresa', 'Cappen'),
(166, 24, '_empresa', 'field_5b842d65972a6'),
(167, 24, 'data-e-hora', '1535282880'),
(168, 24, '_data-e-hora', 'field_5b842ff56e3d7'),
(169, 24, 'preco', '2,00'),
(170, 24, '_preco', 'field_5b843d000ac2d'),
(171, 24, 'vagas', '200'),
(172, 24, '_vagas', 'field_5b84432a0a467'),
(173, 24, '_thumbnail_id', '6'),
(176, 10, 'rule', 'a:5:{s:5:\"param\";s:9:\"post_type\";s:8:\"operator\";s:2:\"==\";s:5:\"value\";s:4:\"post\";s:8:\"order_no\";i:0;s:8:\"group_no\";i:0;}'),
(179, 26, 'profissional', 'Felipe'),
(180, 26, '_profissional', 'field_5b842ac615516'),
(181, 26, 'cargo', 'Front-end developer'),
(182, 26, '_cargo', 'field_5b842ca050668'),
(183, 26, 'empresa', 'Cappen'),
(184, 26, '_empresa', 'field_5b842d65972a6'),
(185, 26, 'data-e-hora', '1535282880'),
(186, 26, '_data-e-hora', 'field_5b842ff56e3d7'),
(187, 26, 'preco', '2,00'),
(188, 26, '_preco', 'field_5b843d000ac2d'),
(189, 26, 'vagas', '200'),
(190, 26, '_vagas', 'field_5b84432a0a467'),
(191, 27, '_edit_last', '1'),
(192, 27, '_edit_lock', '1535404743:1'),
(195, 29, 'profissional', 'Felipe'),
(196, 29, '_profissional', 'field_5b842ac615516'),
(197, 29, 'cargo', 'Front-end developer'),
(198, 29, '_cargo', 'field_5b842ca050668'),
(199, 29, 'empresa', 'Cappen'),
(200, 29, '_empresa', 'field_5b842d65972a6'),
(201, 29, 'data-e-hora', '1535477400'),
(202, 29, '_data-e-hora', 'field_5b842ff56e3d7'),
(203, 29, 'preco', '100,00'),
(204, 29, '_preco', 'field_5b843d000ac2d'),
(205, 29, 'vagas', '150'),
(206, 29, '_vagas', 'field_5b84432a0a467'),
(209, 30, 'profissional', 'Felipe'),
(210, 30, '_profissional', 'field_5b842ac615516'),
(211, 30, 'cargo', 'Front-end developer'),
(212, 30, '_cargo', 'field_5b842ca050668'),
(213, 30, 'empresa', 'Cappen'),
(214, 30, '_empresa', 'field_5b842d65972a6'),
(215, 30, 'data-e-hora', '1535282880'),
(216, 30, '_data-e-hora', 'field_5b842ff56e3d7'),
(217, 30, 'preco', '2,00'),
(218, 30, '_preco', 'field_5b843d000ac2d'),
(219, 30, 'vagas', '200'),
(220, 30, '_vagas', 'field_5b84432a0a467'),
(221, 31, '_mc4wp_settings', 'a:8:{s:15:\"required_fields\";s:5:\"EMAIL\";s:5:\"lists\";a:1:{i:0;s:10:\"621b0cc48b\";}s:12:\"double_optin\";s:1:\"1\";s:15:\"update_existing\";s:1:\"0\";s:17:\"replace_interests\";s:1:\"1\";s:18:\"hide_after_success\";s:1:\"0\";s:8:\"redirect\";s:0:\"\";s:3:\"css\";s:1:\"0\";}'),
(222, 31, 'text_subscribed', 'Thank you, your sign-up request was successful! Please check your email inbox to confirm.'),
(223, 31, 'text_invalid_email', 'Please provide a valid email address.'),
(224, 31, 'text_required_field_missing', 'Please fill in the required fields.'),
(225, 31, 'text_already_subscribed', 'Given email address is already subscribed, thank you!'),
(226, 31, 'text_error', 'Oops. Something went wrong. Please try again later.'),
(227, 31, 'text_unsubscribed', 'You were successfully unsubscribed.'),
(228, 31, 'text_not_subscribed', 'Given email address is not subscribed.'),
(229, 31, 'text_no_lists_selected', 'Please select at least one list.'),
(230, 31, 'text_updated', 'Thank you, your records have been updated!');

-- --------------------------------------------------------

--
-- Table structure for table `wp_termmeta`
--

CREATE TABLE `wp_termmeta` (
  `meta_id` bigint(20) UNSIGNED NOT NULL,
  `term_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
  `meta_key` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `meta_value` longtext COLLATE utf8mb4_unicode_520_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Table structure for table `wp_terms`
--

CREATE TABLE `wp_terms` (
  `term_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `slug` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `term_group` bigint(10) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_terms`
--

INSERT INTO `wp_terms` (`term_id`, `name`, `slug`, `term_group`) VALUES
(1, 'Sem categoria', 'sem-categoria', 0);

-- --------------------------------------------------------

--
-- Table structure for table `wp_term_relationships`
--

CREATE TABLE `wp_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'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_term_relationships`
--

INSERT INTO `wp_term_relationships` (`object_id`, `term_taxonomy_id`, `term_order`) VALUES
(5, 1, 0),
(24, 1, 0);

-- --------------------------------------------------------

--
-- Table structure for table `wp_term_taxonomy`
--

CREATE TABLE `wp_term_taxonomy` (
  `term_taxonomy_id` bigint(20) UNSIGNED NOT NULL,
  `term_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
  `taxonomy` varchar(32) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `description` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `parent` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
  `count` bigint(20) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_term_taxonomy`
--

INSERT INTO `wp_term_taxonomy` (`term_taxonomy_id`, `term_id`, `taxonomy`, `description`, `parent`, `count`) VALUES
(1, 1, 'category', '', 0, 2);

-- --------------------------------------------------------

--
-- Table structure for table `wp_usermeta`
--

CREATE TABLE `wp_usermeta` (
  `umeta_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
  `meta_key` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `meta_value` longtext COLLATE utf8mb4_unicode_520_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_usermeta`
--

INSERT INTO `wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES
(1, 1, 'nickname', 'admin'),
(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, 'wp_capabilities', 'a:1:{s:13:\"administrator\";b:1;}'),
(13, 1, 'wp_user_level', '10'),
(14, 1, 'dismissed_wp_pointers', 'wp496_privacy'),
(15, 1, 'show_welcome_panel', '1'),
(16, 1, 'session_tokens', 'a:1:{s:64:\"36b962e9813a8d494e5f28fc4990eb0373dd5695c5233c76252e12baf7a872fb\";a:4:{s:10:\"expiration\";i:1536870309;s:2:\"ip\";s:14:\"186.225.56.134\";s:2:\"ua\";s:114:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/69.0.3497.81 Safari/537.36\";s:5:\"login\";i:1536697509;}}'),
(17, 1, 'wp_dashboard_quick_press_last_post_id', '4'),
(18, 1, 'wp_user-settings', 'libraryContent=browse&editor=html'),
(19, 1, 'wp_user-settings-time', '1535389819'),
(20, 1, 'closedpostboxes_post', 'a:0:{}'),
(21, 1, 'metaboxhidden_post', 'a:8:{i:0;s:12:\"revisionsdiv\";i:1;s:11:\"postexcerpt\";i:2;s:13:\"trackbacksdiv\";i:3;s:10:\"postcustom\";i:4;s:16:\"commentstatusdiv\";i:5;s:11:\"commentsdiv\";i:6;s:7:\"slugdiv\";i:7;s:9:\"authordiv\";}');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `wp_commentmeta`
--
ALTER TABLE `wp_commentmeta`
  ADD PRIMARY KEY (`meta_id`),
  ADD KEY `comment_id` (`comment_id`),
  ADD KEY `meta_key` (`meta_key`(191));

--
-- Indexes for table `wp_comments`
--
ALTER TABLE `wp_comments`
  ADD PRIMARY KEY (`comment_ID`),
  ADD KEY `comment_post_ID` (`comment_post_ID`),
  ADD KEY `comment_approved_date_gmt` (`comment_approved`,`comment_date_gmt`),
  ADD KEY `comment_date_gmt` (`comment_date_gmt`),
  ADD KEY `comment_parent` (`comment_parent`),
  ADD KEY `comment_author_email` (`comment_author_email`(10));

--
-- Indexes for table `wp_links`
--
ALTER TABLE `wp_links`
  ADD PRIMARY KEY (`link_id`),
  ADD KEY `link_visible` (`link_visible`);

--
-- Indexes for table `wp_options`
--
ALTER TABLE `wp_options`
  ADD PRIMARY KEY (`option_id`),
  ADD UNIQUE KEY `option_name` (`option_name`);

--
-- Indexes for table `wp_postmeta`
--
ALTER TABLE `wp_postmeta`
  ADD PRIMARY KEY (`meta_id`),
  ADD KEY `post_id` (`post_id`),
  ADD KEY `meta_key` (`meta_key`(191));

--
-- Indexes for table `wp_termmeta`
--
ALTER TABLE `wp_termmeta`
  ADD PRIMARY KEY (`meta_id`),
  ADD KEY `term_id` (`term_id`),
  ADD KEY `meta_key` (`meta_key`(191));

--
-- Indexes for table `wp_terms`
--
ALTER TABLE `wp_terms`
  ADD PRIMARY KEY (`term_id`),
  ADD KEY `slug` (`slug`(191)),
  ADD KEY `name` (`name`(191));

--
-- Indexes for table `wp_term_relationships`
--
ALTER TABLE `wp_term_relationships`
  ADD PRIMARY KEY (`object_id`,`term_taxonomy_id`),
  ADD KEY `term_taxonomy_id` (`term_taxonomy_id`);

--
-- Indexes for table `wp_term_taxonomy`
--
ALTER TABLE `wp_term_taxonomy`
  ADD PRIMARY KEY (`term_taxonomy_id`),
  ADD UNIQUE KEY `term_id_taxonomy` (`term_id`,`taxonomy`),
  ADD KEY `taxonomy` (`taxonomy`);

--
-- Indexes for table `wp_usermeta`
--
ALTER TABLE `wp_usermeta`
  ADD PRIMARY KEY (`umeta_id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `meta_key` (`meta_key`(191));

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `wp_commentmeta`
--
ALTER TABLE `wp_commentmeta`
  MODIFY `meta_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `wp_comments`
--
ALTER TABLE `wp_comments`
  MODIFY `comment_ID` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `wp_links`
--
ALTER TABLE `wp_links`
  MODIFY `link_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `wp_options`
--
ALTER TABLE `wp_options`
  MODIFY `option_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=282;

--
-- AUTO_INCREMENT for table `wp_postmeta`
--
ALTER TABLE `wp_postmeta`
  MODIFY `meta_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=231;

--
-- AUTO_INCREMENT for table `wp_termmeta`
--
ALTER TABLE `wp_termmeta`
  MODIFY `meta_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `wp_terms`
--
ALTER TABLE `wp_terms`
  MODIFY `term_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `wp_term_taxonomy`
--
ALTER TABLE `wp_term_taxonomy`
  MODIFY `term_taxonomy_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `wp_usermeta`
--
ALTER TABLE `wp_usermeta`
  MODIFY `umeta_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;
COMMIT;

