· 9 years ago · Nov 11, 2016, 01:50 AM
1-- MySQL dump 10.13 Distrib 5.6.21, for Linux (x86_64)
2--
3-- Host: localhost Database: ejemplo
4-- ------------------------------------------------------
5-- Server version 5.6.21-log
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `wp_commentmeta`
20--
21
22DROP TABLE IF EXISTS `wp_commentmeta`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `wp_commentmeta` (
26 `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
27 `comment_id` bigint(20) unsigned NOT NULL DEFAULT '0',
28 `meta_key` varchar(255) DEFAULT NULL,
29 `meta_value` longtext,
30 PRIMARY KEY (`meta_id`),
31 KEY `comment_id` (`comment_id`),
32 KEY `meta_key` (`meta_key`(191))
33) ENGINE=InnoDB DEFAULT CHARSET=latin1;
34/*!40101 SET character_set_client = @saved_cs_client */;
35
36--
37-- Table structure for table `wp_comments`
38--
39
40DROP TABLE IF EXISTS `wp_comments`;
41/*!40101 SET @saved_cs_client = @@character_set_client */;
42/*!40101 SET character_set_client = utf8 */;
43CREATE TABLE `wp_comments` (
44 `comment_ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
45 `comment_post_ID` bigint(20) unsigned NOT NULL DEFAULT '0',
46 `comment_author` tinytext NOT NULL,
47 `comment_author_email` varchar(100) NOT NULL DEFAULT '',
48 `comment_author_url` varchar(200) NOT NULL DEFAULT '',
49 `comment_author_IP` varchar(100) NOT NULL DEFAULT '',
50 `comment_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
51 `comment_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
52 `comment_content` text NOT NULL,
53 `comment_karma` int(11) NOT NULL DEFAULT '0',
54 `comment_approved` varchar(20) NOT NULL DEFAULT '1',
55 `comment_agent` varchar(255) NOT NULL DEFAULT '',
56 `comment_type` varchar(20) NOT NULL DEFAULT '',
57 `comment_parent` bigint(20) unsigned NOT NULL DEFAULT '0',
58 `user_id` bigint(20) unsigned NOT NULL DEFAULT '0',
59 PRIMARY KEY (`comment_ID`),
60 KEY `comment_post_ID` (`comment_post_ID`),
61 KEY `comment_approved_date_gmt` (`comment_approved`,`comment_date_gmt`),
62 KEY `comment_date_gmt` (`comment_date_gmt`),
63 KEY `comment_parent` (`comment_parent`),
64 KEY `comment_author_email` (`comment_author_email`(10))
65) ENGINE=MyISAM DEFAULT CHARSET=utf8;
66/*!40101 SET character_set_client = @saved_cs_client */;
67
68--
69-- Table structure for table `wp_links`
70--
71
72DROP TABLE IF EXISTS `wp_links`;
73/*!40101 SET @saved_cs_client = @@character_set_client */;
74/*!40101 SET character_set_client = utf8 */;
75CREATE TABLE `wp_links` (
76 `link_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
77 `link_url` varchar(255) NOT NULL DEFAULT '',
78 `link_name` varchar(255) NOT NULL DEFAULT '',
79 `link_image` varchar(255) NOT NULL DEFAULT '',
80 `link_target` varchar(25) NOT NULL DEFAULT '',
81 `link_category` bigint(20) NOT NULL DEFAULT '0',
82 `link_description` varchar(255) NOT NULL DEFAULT '',
83 `link_visible` varchar(20) NOT NULL DEFAULT 'Y',
84 `link_owner` bigint(20) unsigned NOT NULL DEFAULT '1',
85 `link_rating` int(11) NOT NULL DEFAULT '0',
86 `link_updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
87 `link_rel` varchar(255) NOT NULL DEFAULT '',
88 `link_notes` mediumtext NOT NULL,
89 `link_rss` varchar(255) NOT NULL DEFAULT '',
90 PRIMARY KEY (`link_id`),
91 KEY `link_category` (`link_category`),
92 KEY `link_visible` (`link_visible`)
93) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;
94/*!40101 SET character_set_client = @saved_cs_client */;
95
96--
97-- Table structure for table `wp_options`
98--
99
100DROP TABLE IF EXISTS `wp_options`;
101/*!40101 SET @saved_cs_client = @@character_set_client */;
102/*!40101 SET character_set_client = utf8 */;
103CREATE TABLE `wp_options` (
104 `option_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
105 `option_name` varchar(191) DEFAULT NULL,
106 `option_value` longtext NOT NULL,
107 `autoload` varchar(20) NOT NULL DEFAULT 'yes',
108 PRIMARY KEY (`option_id`),
109 UNIQUE KEY `option_name` (`option_name`)
110) ENGINE=MyISAM AUTO_INCREMENT=17497 DEFAULT CHARSET=utf8;
111/*!40101 SET character_set_client = @saved_cs_client */;
112
113--
114-- Table structure for table `wp_postmeta`
115--
116
117DROP TABLE IF EXISTS `wp_postmeta`;
118/*!40101 SET @saved_cs_client = @@character_set_client */;
119/*!40101 SET character_set_client = utf8 */;
120CREATE TABLE `wp_postmeta` (
121 `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
122 `post_id` bigint(20) unsigned NOT NULL DEFAULT '0',
123 `meta_key` varchar(255) DEFAULT NULL,
124 `meta_value` longtext,
125 PRIMARY KEY (`meta_id`),
126 KEY `post_id` (`post_id`),
127 KEY `meta_key` (`meta_key`(191))
128) ENGINE=MyISAM AUTO_INCREMENT=810 DEFAULT CHARSET=utf8;
129/*!40101 SET character_set_client = @saved_cs_client */;
130
131--
132-- Table structure for table `wp_posts`
133--
134
135DROP TABLE IF EXISTS `wp_posts`;
136/*!40101 SET @saved_cs_client = @@character_set_client */;
137/*!40101 SET character_set_client = utf8 */;
138CREATE TABLE `wp_posts` (
139 `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
140 `post_author` bigint(20) unsigned NOT NULL DEFAULT '0',
141 `post_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
142 `post_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
143 `post_content` longtext NOT NULL,
144 `post_title` text NOT NULL,
145 `post_category` int(4) NOT NULL DEFAULT '0',
146 `post_excerpt` text NOT NULL,
147 `post_status` varchar(20) NOT NULL DEFAULT 'publish',
148 `comment_status` varchar(20) NOT NULL DEFAULT 'open',
149 `ping_status` varchar(20) NOT NULL DEFAULT 'open',
150 `post_password` varchar(20) NOT NULL DEFAULT '',
151 `post_name` varchar(200) NOT NULL DEFAULT '',
152 `to_ping` text NOT NULL,
153 `pinged` text NOT NULL,
154 `post_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
155 `post_modified_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
156 `post_content_filtered` longtext NOT NULL,
157 `post_parent` bigint(20) unsigned NOT NULL DEFAULT '0',
158 `guid` varchar(255) NOT NULL DEFAULT '',
159 `menu_order` int(11) NOT NULL DEFAULT '0',
160 `post_type` varchar(20) NOT NULL DEFAULT 'post',
161 `post_mime_type` varchar(100) NOT NULL DEFAULT '',
162 `comment_count` bigint(20) NOT NULL DEFAULT '0',
163 PRIMARY KEY (`ID`),
164 KEY `type_status_date` (`post_type`,`post_status`,`post_date`,`ID`),
165 KEY `post_parent` (`post_parent`),
166 KEY `post_author` (`post_author`),
167 KEY `post_name` (`post_name`(191))
168) ENGINE=MyISAM AUTO_INCREMENT=299 DEFAULT CHARSET=utf8;
169/*!40101 SET character_set_client = @saved_cs_client */;
170
171--
172-- Table structure for table `wp_term_relationships`
173--
174
175DROP TABLE IF EXISTS `wp_term_relationships`;
176/*!40101 SET @saved_cs_client = @@character_set_client */;
177/*!40101 SET character_set_client = utf8 */;
178CREATE TABLE `wp_term_relationships` (
179 `object_id` bigint(20) unsigned NOT NULL DEFAULT '0',
180 `term_taxonomy_id` bigint(20) unsigned NOT NULL DEFAULT '0',
181 `term_order` int(11) NOT NULL DEFAULT '0',
182 PRIMARY KEY (`object_id`,`term_taxonomy_id`),
183 KEY `term_taxonomy_id` (`term_taxonomy_id`)
184) ENGINE=MyISAM DEFAULT CHARSET=utf8;
185/*!40101 SET character_set_client = @saved_cs_client */;
186
187--
188-- Table structure for table `wp_term_taxonomy`
189--
190
191DROP TABLE IF EXISTS `wp_term_taxonomy`;
192/*!40101 SET @saved_cs_client = @@character_set_client */;
193/*!40101 SET character_set_client = utf8 */;
194CREATE TABLE `wp_term_taxonomy` (
195 `term_taxonomy_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
196 `term_id` bigint(20) unsigned NOT NULL DEFAULT '0',
197 `taxonomy` varchar(32) NOT NULL DEFAULT '',
198 `description` longtext NOT NULL,
199 `parent` bigint(20) unsigned NOT NULL DEFAULT '0',
200 `count` bigint(20) NOT NULL DEFAULT '0',
201 PRIMARY KEY (`term_taxonomy_id`),
202 UNIQUE KEY `term_id_taxonomy` (`term_id`,`taxonomy`),
203 KEY `taxonomy` (`taxonomy`)
204) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;
205/*!40101 SET character_set_client = @saved_cs_client */;
206
207--
208-- Table structure for table `wp_termmeta`
209--
210
211DROP TABLE IF EXISTS `wp_termmeta`;
212/*!40101 SET @saved_cs_client = @@character_set_client */;
213/*!40101 SET character_set_client = utf8 */;
214CREATE TABLE `wp_termmeta` (
215 `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
216 `term_id` bigint(20) unsigned NOT NULL DEFAULT '0',
217 `meta_key` varchar(255) DEFAULT NULL,
218 `meta_value` longtext,
219 PRIMARY KEY (`meta_id`),
220 KEY `term_id` (`term_id`),
221 KEY `meta_key` (`meta_key`(191))
222) ENGINE=InnoDB DEFAULT CHARSET=latin1;
223/*!40101 SET character_set_client = @saved_cs_client */;
224
225--
226-- Table structure for table `wp_terms`
227--
228
229DROP TABLE IF EXISTS `wp_terms`;
230/*!40101 SET @saved_cs_client = @@character_set_client */;
231/*!40101 SET character_set_client = utf8 */;
232CREATE TABLE `wp_terms` (
233 `term_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
234 `name` varchar(200) NOT NULL DEFAULT '',
235 `slug` varchar(200) NOT NULL DEFAULT '',
236 `term_group` bigint(10) NOT NULL DEFAULT '0',
237 PRIMARY KEY (`term_id`),
238 KEY `slug` (`slug`(191)),
239 KEY `name` (`name`(191))
240) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
241/*!40101 SET character_set_client = @saved_cs_client */;
242
243--
244-- Table structure for table `wp_usermeta`
245--
246
247DROP TABLE IF EXISTS `wp_usermeta`;
248/*!40101 SET @saved_cs_client = @@character_set_client */;
249/*!40101 SET character_set_client = utf8 */;
250CREATE TABLE `wp_usermeta` (
251 `umeta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
252 `user_id` bigint(20) unsigned NOT NULL DEFAULT '0',
253 `meta_key` varchar(255) DEFAULT NULL,
254 `meta_value` longtext,
255 PRIMARY KEY (`umeta_id`),
256 KEY `user_id` (`user_id`),
257 KEY `meta_key` (`meta_key`(191))
258) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=utf8;
259/*!40101 SET character_set_client = @saved_cs_client */;
260
261--
262-- Table structure for table `wp_users`
263--
264
265DROP TABLE IF EXISTS `wp_users`;
266/*!40101 SET @saved_cs_client = @@character_set_client */;
267/*!40101 SET character_set_client = utf8 */;
268CREATE TABLE `wp_users` (
269 `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
270 `user_login` varchar(60) NOT NULL DEFAULT '',
271 `user_pass` varchar(255) NOT NULL DEFAULT '',
272 `user_nicename` varchar(50) NOT NULL DEFAULT '',
273 `user_email` varchar(100) NOT NULL DEFAULT '',
274 `user_url` varchar(100) NOT NULL DEFAULT '',
275 `user_registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
276 `user_activation_key` varchar(255) NOT NULL DEFAULT '',
277 `user_status` int(11) NOT NULL DEFAULT '0',
278 `display_name` varchar(250) NOT NULL DEFAULT '',
279 PRIMARY KEY (`ID`),
280 KEY `user_login_key` (`user_login`),
281 KEY `user_nicename` (`user_nicename`),
282 KEY `user_email` (`user_email`)
283) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
284/*!40101 SET character_set_client = @saved_cs_client */;
285/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
286
287/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
288/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
289/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
290/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
291/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
292/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
293/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
294
295-- Dump completed on 2016-11-10 17:20:34