· 6 years ago · May 02, 2019, 10:08 AM
1BY MR.JOKER@
2
3host: http://construtoraconfortec.com.br
4Servidor: localhost:3306
5Versão do servidor: 5.6.29
6Versão do PHP: 5.4.31
7
8
9
10CREATE TABLE IF NOT EXISTS `wp_comments` (
11 `comment_ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
12 `comment_post_ID` bigint(20) unsigned NOT NULL DEFAULT '0',
13 `comment_author` tinytext NOT NULL,
14 `comment_author_email` varchar(100) NOT NULL DEFAULT '',
15 `comment_author_url` varchar(200) NOT NULL DEFAULT '',
16 `comment_author_IP` varchar(100) NOT NULL DEFAULT '',
17 `comment_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
18 `comment_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
19 `comment_content` text NOT NULL,
20 `comment_karma` int(11) NOT NULL DEFAULT '0',
21 `comment_approved` varchar(20) NOT NULL DEFAULT '1',
22 `comment_agent` varchar(255) NOT NULL DEFAULT '',
23 `comment_type` varchar(20) NOT NULL DEFAULT '',
24 `comment_parent` bigint(20) unsigned NOT NULL DEFAULT '0',
25 `user_id` bigint(20) unsigned NOT NULL DEFAULT '0',
26 PRIMARY KEY (`comment_ID`),
27 KEY `comment_post_ID` (`comment_post_ID`),
28 KEY `comment_approved_date_gmt` (`comment_approved`,`comment_date_gmt`),
29 KEY `comment_date_gmt` (`comment_date_gmt`),
30 KEY `comment_parent` (`comment_parent`),
31 KEY `comment_author_email` (`comment_author_email`(10))
32) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
33Fazendo dump de dados para tabela `wp_comments`
34
35
36
37INSERT 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
38(1, 1, 'Sr. WordPress', '', 'https://wordpress.org/', '', '2015-10-28 20:30:15', '2015-10-28 20:30:15', 'Olá, Isto é um comentário.\nPara excluir um comentário, faça o login e veja os comentários de posts. Lá você terá a opção de editá-los ou excluÃ-los.', 0, '1', '', '', 0, 0),
39(2, 132, 'Mr WordPress', '', 'https://wordpress.org/', '', '2014-09-18 22:21:46', '2014-09-18 22:21:46', 'Hi, this is a comment.\nTo delete a comment, just log in and view the post's comments. There you will have the option to edit or delete them.', 0, '1', '', '', 0, 0),
40(3, 136, 'Mike Garcia', 'mike@progressionstudios.com', '', '50.174.83.64', '2014-09-19 00:39:28', '2014-09-19 00:39:28', 'Hi, this is a comment.\nTo delete a comment, just log in and view the post''s comments. There you will have the option to edit or delete them.', 0, '1', '', '', 0, 1),
41(4, 90, 'Mike Garcia', 'mike@progressionstudios.com', '', '50.174.83.64', '2014-09-19 00:39:37', '2014-09-19 00:39:37', 'Hi, this is a comment.\nTo delete a comment, just log in and view the post''s comments. There you will have the option to edit or delete them.', 0, '1', '', '', 0, 1),
42(5, 90, 'Mike Garcia', 'mike@progressionstudios.com', '', '50.174.83.64', '2014-09-19 00:39:50', '2014-09-19 00:39:50', 'Here is a sample response to a comment!', 0, '1', '', '', 4, 1),
43(6, 137, 'Mike Garcia', 'mike@progressionstudios.com', '', '50.174.83.64', '2014-09-19 00:39:31', '2014-09-19 00:39:31', 'Hi, this is a comment.\nTo delete a comment, just log in and view the post''s comments. There you will have the option to edit or delete them.', 0, '1', '', '', 0, 1),
44(7, 137, 'Mike Garcia', 'mike@progressionstudios.com', '', '50.174.83.64', '2014-09-19 00:39:47', '2014-09-19 00:39:47', 'Here is a sample response to a comment!', 0, '1', '', '', 6, 1);
45
46CREATE TABLE IF NOT EXISTS `wp_usermeta` (
47 `umeta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
48 `user_id` bigint(20) unsigned NOT NULL DEFAULT '0',
49 `meta_key` varchar(255) DEFAULT NULL,
50 `meta_value` longtext,
51 PRIMARY KEY (`umeta_id`),
52 KEY `user_id` (`user_id`),
53 KEY `meta_key` (`meta_key`(191))
54) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=48 ;
55Fazendo dump de dados para tabela `wp_usermeta
56
57INSERT INTO `wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES
58(1, 1, 'nickname', 'confortec'),
59(2, 1, 'first_name', ''),
60(3, 1, 'last_name', ''),
61(4, 1, 'description', ''),
62(5, 1, 'rich_editing', 'true'),
63(6, 1, 'comment_shortcuts', 'false'),
64(7, 1, 'admin_color', 'fresh'),
65(8, 1, 'use_ssl', '0'),
66(9, 1, 'show_admin_bar_front', 'true'),
67(10, 1, 'wp_capabilities', 'a:1:{s:13:"administrator";b:1;}'),
68(11, 1, 'wp_user_level', '10'),
69(12, 1, 'dismissed_wp_pointers', ''),
70(13, 1, 'show_welcome_panel', '1'),
71(45, 1, 'session_tokens', 'a:1:{s:64:"629265e131de7fdd700aeececbe5a11588b2f34a7a036bd1dca8271fc500b54b";a:4:{s:10:"expiration";i:1455974582;s:2:"ip";s:14:"179.99.201.154";s:2:"ua";s:108:"Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2652.2 Safari/537.36";s:5:"login";i:1455801782;}}'),
72(15, 1, 'wp_dashboard_quick_press_last_post_id', '236'),
73(16, 1, 'wp_user-settings', 'libraryContent=browse&unfold=1&mfold=o&editor=tinymce&imgsize=full'),
74(17, 1, 'wp_user-settings-time', '1446550396'),
75(46, 1, 'closedpostboxes_responsive-gallery', 'a:1:{i:0;s:16:"Plugin Shortcode";}'),
76(47, 1, 'metaboxhidden_responsive-gallery', 'a:1:{i:0;s:7:"slugdiv";}'),
77(18, 2, 'nickname', 'mikegarcia05_t0m4nrc4'),
78(19, 2, 'first_name', ''),
79(20, 2, 'last_name', ''),
80(21, 2, 'description', ''),
81(22, 2, 'rich_editing', 'true'),
82(23, 2, 'comment_shortcuts', 'false'),
83(24, 2, 'admin_color', 'fresh'),
84(25, 2, 'use_ssl', '0'),
85(26, 2, 'show_admin_bar_front', 'true'),
86(27, 2, 'wp_capabilities', 'a:1:{s:10:"subscriber";b:1;}'),
87(28, 2, 'wp_user_level', '0'),
88(29, 2, 'dismissed_wp_pointers', ''),
89(30, 3, 'nickname', 'ProgressionStudios'),
90(31, 3, 'first_name', 'Mike'),
91(32, 3, 'last_name', 'Garcia'),
92(33, 3, 'description', ''),
93(34, 3, 'rich_editing', 'true'),
94(35, 3, 'comment_shortcuts', 'false'),
95(36, 3, 'admin_color', 'fresh'),
96(37, 3, 'use_ssl', '0'),
97(38, 3, 'show_admin_bar_front', 'true'),
98(39, 3, 'wp_capabilities', 'a:1:{s:10:"subscriber";b:1;}'),
99(40, 3, 'wp_user_level', '0'),
100(41, 3, 'dismissed_wp_pointers', ''),
101(42, 1, 'nav_menu_recently_edited', '7'),
102(43, 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";}'),
103(44, 1, 'metaboxhidden_nav-menus', 'a:8:{i:0;s:13:"add-portfolio";i:1;s:15:"add-testimonial";i:2;s:11:"add-service";i:3;s:12:"add-post_tag";i:4;s:15:"add-post_format";i:5;s:18:"add-portfolio_type";i:6;s:20:"add-testimonial_type";i:7;s:16:"add-service_type";}');
104
105-- --------------------------------------------------------
106
107CREATE TABLE IF NOT EXISTS `wp_users` (
108 `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
109 `user_login` varchar(60) NOT NULL DEFAULT '',
110 `user_pass` varchar(64) NOT NULL DEFAULT '',
111 `user_nicename` varchar(50) NOT NULL DEFAULT '',
112 `user_email` varchar(100) NOT NULL DEFAULT '',
113 `user_url` varchar(100) NOT NULL DEFAULT '',
114 `user_registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
115 `user_activation_key` varchar(60) NOT NULL DEFAULT '',
116 `user_status` int(11) NOT NULL DEFAULT '0',
117 `display_name` varchar(250) NOT NULL DEFAULT '',
118 PRIMARY KEY (`ID`),
119 KEY `user_login_key` (`user_login`),
120 KEY `user_nicename` (`user_nicename`)
121) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
122Fazendo dump de dados para tabela `wp_users`
123
124INSERT INTO `wp_users` (`ID`, `user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_activation_key`, `user_status`, `display_name`) VALUES
125(1, 'confortec', '$P$BPmc723HaXwTOtzRz8fDEG0DKagTai.', 'confortec', 'holdingsim@gmail.com', '', '2015-10-28 20:30:15', '', 0, 'confortec'),
126(2, 'mikegarcia05_t0m4nrc4', '$P$BSM0Q9R.dhTXQeAosRv3rgvz9OanN4/', 'mikegarcia05_t0m4nrc4', 'mikegarcia05@gmail.com', '', '2015-10-30 15:06:08', '', 0, 'mikegarcia05_t0m4nrc4'),
127(3, 'ProgressionStudios', '$P$BGaRyQ9TAgRyhbrlZn54vGpsAwr2Te0', 'progressionstudios', 'mike@progressionstudios.com', '', '2015-10-30 15:06:08', '', 0, 'Mike Garcia');
128
129/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
130/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
131/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;