· 5 years ago · Feb 17, 2020, 08:44 AM
1-- MySQL dump 10.13 Distrib 8.0.19, for Linux (x86_64)
2--
3-- Host: localhost Database: wordpress-codo-digital
4-- ------------------------------------------------------
5-- Server version 8.0.19
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/*!50503 SET NAMES utf8mb4 */;
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
22--
23-- Table structure for table `wp_options`
24--
25
26DROP TABLE IF EXISTS `wp_options`;
27/*!40101 SET @saved_cs_client = @@character_set_client */;
28/*!50503 SET character_set_client = utf8mb4 */;
29CREATE TABLE `wp_options` (
30 `option_id` bigint unsigned NOT NULL AUTO_INCREMENT,
31 `option_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
32 `option_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
33 `autoload` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'yes',
34 PRIMARY KEY (`option_id`),
35 UNIQUE KEY `option_name` (`option_name`),
36 KEY `autoload` (`autoload`)
37) ENGINE=InnoDB AUTO_INCREMENT=49778 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
38/*!40101 SET character_set_client = @saved_cs_client */;
39
40--
41-- Table structure for table `wp_users`
42--
43
44DROP TABLE IF EXISTS `wp_users`;
45/*!40101 SET @saved_cs_client = @@character_set_client */;
46/*!50503 SET character_set_client = utf8mb4 */;
47CREATE TABLE `wp_users` (
48 `ID` bigint unsigned NOT NULL AUTO_INCREMENT,
49 `user_login` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
50 `user_pass` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
51 `user_nicename` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
52 `user_email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
53 `user_url` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
54 `user_registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
55 `user_activation_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
56 `user_status` int NOT NULL DEFAULT '0',
57 `display_name` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
58 PRIMARY KEY (`ID`),
59 KEY `user_login_key` (`user_login`),
60 KEY `user_nicename` (`user_nicename`),
61 KEY `user_email` (`user_email`)
62) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
63/*!40101 SET character_set_client = @saved_cs_client */;
64
65--
66-- Dumping data for table `wp_users`
67--
68
69LOCK TABLES `wp_users` WRITE;
70/*!40000 ALTER TABLE `wp_users` DISABLE KEYS */;
71/*!40000 ALTER TABLE `wp_users` ENABLE KEYS */;
72UNLOCK TABLES;
73
74
75
76--
77-- Table structure for table `wp_usermeta`
78--
79
80DROP TABLE IF EXISTS `wp_usermeta`;
81/*!40101 SET @saved_cs_client = @@character_set_client */;
82/*!50503 SET character_set_client = utf8mb4 */;
83CREATE TABLE `wp_usermeta` (
84 `umeta_id` bigint unsigned NOT NULL AUTO_INCREMENT,
85 `user_id` bigint unsigned NOT NULL DEFAULT '0',
86 `meta_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
87 `meta_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
88 PRIMARY KEY (`umeta_id`),
89 KEY `user_id` (`user_id`),
90 KEY `meta_key` (`meta_key`(191))
91) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
92/*!40101 SET character_set_client = @saved_cs_client */;
93
94--
95-- Dumping data for table `wp_usermeta`
96--
97
98LOCK TABLES `wp_usermeta` WRITE;
99/*!40000 ALTER TABLE `wp_usermeta` DISABLE KEYS */;
100/*!40000 ALTER TABLE `wp_usermeta` ENABLE KEYS */;
101UNLOCK TABLES;
102
103--
104-- Dumping data for table `wp_options`
105--
106
107LOCK TABLES `wp_options` WRITE;
108/*!40000 ALTER TABLE `wp_options` DISABLE KEYS */;
109/*!40000 ALTER TABLE `wp_options` ENABLE KEYS */;
110UNLOCK TABLES;
111
112DROP TABLE IF EXISTS `wp_commentmeta`;
113/*!40101 SET @saved_cs_client = @@character_set_client */;
114/*!50503 SET character_set_client = utf8mb4 */;
115CREATE TABLE `wp_commentmeta` (
116 `meta_id` bigint unsigned NOT NULL AUTO_INCREMENT,
117 `comment_id` bigint unsigned NOT NULL DEFAULT '0',
118 `meta_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
119 `meta_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
120 PRIMARY KEY (`meta_id`),
121 KEY `comment_id` (`comment_id`),
122 KEY `meta_key` (`meta_key`(191))
123) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
124/*!40101 SET character_set_client = @saved_cs_client */;
125
126--
127-- Dumping data for table `wp_commentmeta`
128--
129
130LOCK TABLES `wp_commentmeta` WRITE;
131/*!40000 ALTER TABLE `wp_commentmeta` DISABLE KEYS */;
132/*!40000 ALTER TABLE `wp_commentmeta` ENABLE KEYS */;
133UNLOCK TABLES;
134
135--
136-- Table structure for table `wp_comments`
137--
138
139DROP TABLE IF EXISTS `wp_comments`;
140/*!40101 SET @saved_cs_client = @@character_set_client */;
141/*!50503 SET character_set_client = utf8mb4 */;
142CREATE TABLE `wp_comments` (
143 `comment_ID` bigint unsigned NOT NULL AUTO_INCREMENT,
144 `comment_post_ID` bigint unsigned NOT NULL DEFAULT '0',
145 `comment_author` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
146 `comment_author_email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
147 `comment_author_url` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
148 `comment_author_IP` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
149 `comment_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
150 `comment_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
151 `comment_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
152 `comment_karma` int NOT NULL DEFAULT '0',
153 `comment_approved` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '1',
154 `comment_agent` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
155 `comment_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
156 `comment_parent` bigint unsigned NOT NULL DEFAULT '0',
157 `user_id` bigint unsigned NOT NULL DEFAULT '0',
158 PRIMARY KEY (`comment_ID`),
159 KEY `comment_post_ID` (`comment_post_ID`),
160 KEY `comment_approved_date_gmt` (`comment_approved`,`comment_date_gmt`),
161 KEY `comment_date_gmt` (`comment_date_gmt`),
162 KEY `comment_parent` (`comment_parent`),
163 KEY `comment_author_email` (`comment_author_email`(10))
164) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
165/*!40101 SET character_set_client = @saved_cs_client */;
166
167--
168-- Dumping data for table `wp_comments`
169--
170
171LOCK TABLES `wp_comments` WRITE;
172/*!40000 ALTER TABLE `wp_comments` DISABLE KEYS */;
173/*!40000 ALTER TABLE `wp_comments` ENABLE KEYS */;
174UNLOCK TABLES;
175
176
177
178--
179-- Table structure for table `wp_links`
180--
181
182DROP TABLE IF EXISTS `wp_links`;
183/*!40101 SET @saved_cs_client = @@character_set_client */;
184/*!50503 SET character_set_client = utf8mb4 */;
185CREATE TABLE `wp_links` (
186 `link_id` bigint unsigned NOT NULL AUTO_INCREMENT,
187 `link_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
188 `link_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
189 `link_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
190 `link_target` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
191 `link_description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
192 `link_visible` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'Y',
193 `link_owner` bigint unsigned NOT NULL DEFAULT '1',
194 `link_rating` int NOT NULL DEFAULT '0',
195 `link_updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
196 `link_rel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
197 `link_notes` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
198 `link_rss` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
199 PRIMARY KEY (`link_id`),
200 KEY `link_visible` (`link_visible`)
201) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
202/*!40101 SET character_set_client = @saved_cs_client */;
203
204--
205-- Dumping data for table `wp_links`
206--
207
208LOCK TABLES `wp_links` WRITE;
209/*!40000 ALTER TABLE `wp_links` DISABLE KEYS */;
210/*!40000 ALTER TABLE `wp_links` ENABLE KEYS */;
211UNLOCK TABLES;
212
213--
214-- Table structure for table `wp_ewwwio_images`
215--
216
217--
218-- Table structure for table `wp_postmeta`
219--
220
221DROP TABLE IF EXISTS `wp_postmeta`;
222/*!40101 SET @saved_cs_client = @@character_set_client */;
223/*!50503 SET character_set_client = utf8mb4 */;
224CREATE TABLE `wp_postmeta` (
225 `meta_id` bigint unsigned NOT NULL AUTO_INCREMENT,
226 `post_id` bigint unsigned NOT NULL DEFAULT '0',
227 `meta_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
228 `meta_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
229 PRIMARY KEY (`meta_id`),
230 KEY `post_id` (`post_id`),
231 KEY `meta_key` (`meta_key`(191))
232) ENGINE=InnoDB AUTO_INCREMENT=507 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
233/*!40101 SET character_set_client = @saved_cs_client */;
234
235--
236-- Dumping data for table `wp_postmeta`
237--
238
239LOCK TABLES `wp_postmeta` WRITE;
240/*!40000 ALTER TABLE `wp_postmeta` DISABLE KEYS */;
241/*!40000 ALTER TABLE `wp_postmeta` ENABLE KEYS */;
242UNLOCK TABLES;
243
244--
245-- Table structure for table `wp_posts`
246--
247
248DROP TABLE IF EXISTS `wp_posts`;
249/*!40101 SET @saved_cs_client = @@character_set_client */;
250/*!50503 SET character_set_client = utf8mb4 */;
251CREATE TABLE `wp_posts` (
252 `ID` bigint unsigned NOT NULL AUTO_INCREMENT,
253 `post_author` bigint unsigned NOT NULL DEFAULT '0',
254 `post_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
255 `post_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
256 `post_content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
257 `post_title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
258 `post_excerpt` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
259 `post_status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'publish',
260 `comment_status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'open',
261 `ping_status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'open',
262 `post_password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
263 `post_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
264 `to_ping` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
265 `pinged` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
266 `post_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
267 `post_modified_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
268 `post_content_filtered` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
269 `post_parent` bigint unsigned NOT NULL DEFAULT '0',
270 `guid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
271 `menu_order` int NOT NULL DEFAULT '0',
272 `post_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'post',
273 `post_mime_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
274 `comment_count` bigint NOT NULL DEFAULT '0',
275 PRIMARY KEY (`ID`),
276 KEY `post_name` (`post_name`(191)),
277 KEY `type_status_date` (`post_type`,`post_status`,`post_date`,`ID`),
278 KEY `post_parent` (`post_parent`),
279 KEY `post_author` (`post_author`)
280) ENGINE=InnoDB AUTO_INCREMENT=411 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
281/*!40101 SET character_set_client = @saved_cs_client */;
282
283--
284-- Dumping data for table `wp_posts`
285--
286
287LOCK TABLES `wp_posts` WRITE;
288/*!40000 ALTER TABLE `wp_posts` DISABLE KEYS */;
289/*!40000 ALTER TABLE `wp_posts` ENABLE KEYS */;
290UNLOCK TABLES;
291
292
293--
294-- Table structure for table `wp_term_relationships`
295--
296
297DROP TABLE IF EXISTS `wp_term_relationships`;
298/*!40101 SET @saved_cs_client = @@character_set_client */;
299/*!50503 SET character_set_client = utf8mb4 */;
300CREATE TABLE `wp_term_relationships` (
301 `object_id` bigint unsigned NOT NULL DEFAULT '0',
302 `term_taxonomy_id` bigint unsigned NOT NULL DEFAULT '0',
303 `term_order` int NOT NULL DEFAULT '0',
304 PRIMARY KEY (`object_id`,`term_taxonomy_id`),
305 KEY `term_taxonomy_id` (`term_taxonomy_id`)
306) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
307/*!40101 SET character_set_client = @saved_cs_client */;
308
309--
310-- Dumping data for table `wp_term_relationships`
311--
312
313LOCK TABLES `wp_term_relationships` WRITE;
314/*!40000 ALTER TABLE `wp_term_relationships` DISABLE KEYS */;
315/*!40000 ALTER TABLE `wp_term_relationships` ENABLE KEYS */;
316UNLOCK TABLES;
317
318--
319-- Table structure for table `wp_term_taxonomy`
320--
321
322DROP TABLE IF EXISTS `wp_term_taxonomy`;
323/*!40101 SET @saved_cs_client = @@character_set_client */;
324/*!50503 SET character_set_client = utf8mb4 */;
325CREATE TABLE `wp_term_taxonomy` (
326 `term_taxonomy_id` bigint unsigned NOT NULL AUTO_INCREMENT,
327 `term_id` bigint unsigned NOT NULL DEFAULT '0',
328 `taxonomy` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
329 `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
330 `parent` bigint unsigned NOT NULL DEFAULT '0',
331 `count` bigint NOT NULL DEFAULT '0',
332 PRIMARY KEY (`term_taxonomy_id`),
333 UNIQUE KEY `term_id_taxonomy` (`term_id`,`taxonomy`),
334 KEY `taxonomy` (`taxonomy`)
335) ENGINE=InnoDB AUTO_INCREMENT=111 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
336/*!40101 SET character_set_client = @saved_cs_client */;
337
338--
339-- Dumping data for table `wp_term_taxonomy`
340--
341
342LOCK TABLES `wp_term_taxonomy` WRITE;
343/*!40000 ALTER TABLE `wp_term_taxonomy` DISABLE KEYS */;
344/*!40000 ALTER TABLE `wp_term_taxonomy` ENABLE KEYS */;
345UNLOCK TABLES;
346
347--
348-- Table structure for table `wp_termmeta`
349--
350
351DROP TABLE IF EXISTS `wp_termmeta`;
352/*!40101 SET @saved_cs_client = @@character_set_client */;
353/*!50503 SET character_set_client = utf8mb4 */;
354CREATE TABLE `wp_termmeta` (
355 `meta_id` bigint unsigned NOT NULL AUTO_INCREMENT,
356 `term_id` bigint unsigned NOT NULL DEFAULT '0',
357 `meta_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
358 `meta_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
359 PRIMARY KEY (`meta_id`),
360 KEY `term_id` (`term_id`),
361 KEY `meta_key` (`meta_key`(191))
362) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
363/*!40101 SET character_set_client = @saved_cs_client */;
364
365--
366-- Dumping data for table `wp_termmeta`
367--
368
369LOCK TABLES `wp_termmeta` WRITE;
370/*!40000 ALTER TABLE `wp_termmeta` DISABLE KEYS */;
371/*!40000 ALTER TABLE `wp_termmeta` ENABLE KEYS */;
372UNLOCK TABLES;
373
374--
375-- Table structure for table `wp_terms`
376--
377
378DROP TABLE IF EXISTS `wp_terms`;
379/*!40101 SET @saved_cs_client = @@character_set_client */;
380/*!50503 SET character_set_client = utf8mb4 */;
381CREATE TABLE `wp_terms` (
382 `term_id` bigint unsigned NOT NULL AUTO_INCREMENT,
383 `name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
384 `slug` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
385 `term_group` bigint NOT NULL DEFAULT '0',
386 PRIMARY KEY (`term_id`),
387 KEY `slug` (`slug`(191)),
388 KEY `name` (`name`(191))
389) ENGINE=InnoDB AUTO_INCREMENT=111 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
390/*!40101 SET character_set_client = @saved_cs_client */;
391
392--
393-- Dumping data for table `wp_terms`
394--
395
396LOCK TABLES `wp_terms` WRITE;
397/*!40000 ALTER TABLE `wp_terms` DISABLE KEYS */;
398/*!40000 ALTER TABLE `wp_terms` ENABLE KEYS */;
399UNLOCK TABLES;
400
401-- Table structure for table `wp_yoast_seo_links`
402--
403
404DROP TABLE IF EXISTS `wp_yoast_seo_links`;
405/*!40101 SET @saved_cs_client = @@character_set_client */;
406/*!50503 SET character_set_client = utf8mb4 */;
407CREATE TABLE `wp_yoast_seo_links` (
408 `id` bigint unsigned NOT NULL AUTO_INCREMENT,
409 `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
410 `post_id` bigint unsigned NOT NULL,
411 `target_post_id` bigint unsigned NOT NULL,
412 `type` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
413 PRIMARY KEY (`id`),
414 KEY `link_direction` (`post_id`,`type`)
415) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
416/*!40101 SET character_set_client = @saved_cs_client */;
417
418--
419-- Dumping data for table `wp_yoast_seo_links`
420--
421
422LOCK TABLES `wp_yoast_seo_links` WRITE;
423/*!40000 ALTER TABLE `wp_yoast_seo_links` DISABLE KEYS */;
424/*!40000 ALTER TABLE `wp_yoast_seo_links` ENABLE KEYS */;
425UNLOCK TABLES;
426
427--
428-- Table structure for table `wp_yoast_seo_meta`
429--
430--
431DROP TABLE IF EXISTS `wp_yoast_seo_meta`;
432/*!40101 SET @saved_cs_client = @@character_set_client */;
433/*!50503 SET character_set_client = utf8mb4 */;
434CREATE TABLE `wp_yoast_seo_meta` (
435 `object_id` bigint unsigned NOT NULL,
436 `internal_link_count` int unsigned DEFAULT NULL,
437 `incoming_link_count` int unsigned DEFAULT NULL,
438 UNIQUE KEY `object_id` (`object_id`)
439) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
440/*!40101 SET character_set_client = @saved_cs_client */;
441
442
443DROP TABLE IF EXISTS `wp_ewwwio_images`;
444/*!40101 SET @saved_cs_client = @@character_set_client */;
445/*!50503 SET character_set_client = utf8mb4 */;
446CREATE TABLE `wp_ewwwio_images` (
447 `id` int unsigned NOT NULL AUTO_INCREMENT,
448 `attachment_id` bigint unsigned DEFAULT NULL,
449 `gallery` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
450 `resize` varchar(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
451 `path` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
452 `converted` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
453 `results` varchar(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
454 `image_size` int unsigned DEFAULT NULL,
455 `orig_size` int unsigned DEFAULT NULL,
456 `backup` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
457 `level` int unsigned DEFAULT NULL,
458 `pending` tinyint(1) NOT NULL DEFAULT '0',
459 `updates` int unsigned DEFAULT NULL,
460 `updated` timestamp NULL DEFAULT '1971-01-01 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
461 `trace` blob,
462 UNIQUE KEY `id` (`id`),
463 KEY `path` (`path`(191)),
464 KEY `attachment_info` (`gallery`(3),`attachment_id`)
465) ENGINE=InnoDB AUTO_INCREMENT=546 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
466/*!40101 SET character_set_client = @saved_cs_client */;
467
468--
469-- Dumping data for table `wp_ewwwio_images`
470--
471
472LOCK TABLES `wp_ewwwio_images` WRITE;
473/*!40000 ALTER TABLE `wp_ewwwio_images` DISABLE KEYS */;
474/*!40000 ALTER TABLE `wp_ewwwio_images` ENABLE KEYS */;
475UNLOCK TABLES;
476
477--
478-- Table structure for table `wp_ewwwio_queue`
479--
480
481DROP TABLE IF EXISTS `wp_ewwwio_queue`;
482/*!40101 SET @saved_cs_client = @@character_set_client */;
483/*!50503 SET character_set_client = utf8mb4 */;
484CREATE TABLE `wp_ewwwio_queue` (
485 `attachment_id` bigint unsigned DEFAULT NULL,
486 `gallery` varchar(10) DEFAULT NULL,
487 `scanned` tinyint(1) NOT NULL DEFAULT '0',
488 KEY `attachment_info` (`gallery`(3),`attachment_id`)
489) ENGINE=InnoDB DEFAULT CHARSET=utf8;
490/*!40101 SET character_set_client = @saved_cs_client */;
491
492--
493-- Dumping data for table `wp_ewwwio_queue`
494--
495
496LOCK TABLES `wp_ewwwio_queue` WRITE;
497/*!40000 ALTER TABLE `wp_ewwwio_queue` DISABLE KEYS */;
498/*!40000 ALTER TABLE `wp_ewwwio_queue` ENABLE KEYS */;
499UNLOCK TABLES;
500
501--
502-- Table structure for table `wp_gf_addon_feed`
503--
504
505DROP TABLE IF EXISTS `wp_gf_addon_feed`;
506/*!40101 SET @saved_cs_client = @@character_set_client */;
507/*!50503 SET character_set_client = utf8mb4 */;
508CREATE TABLE `wp_gf_addon_feed` (
509 `id` mediumint unsigned NOT NULL AUTO_INCREMENT,
510 `form_id` mediumint unsigned NOT NULL,
511 `is_active` tinyint(1) NOT NULL DEFAULT '1',
512 `feed_order` mediumint unsigned NOT NULL DEFAULT '0',
513 `meta` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
514 `addon_slug` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
515 `event_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
516 PRIMARY KEY (`id`),
517 KEY `addon_form` (`addon_slug`,`form_id`)
518) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
519/*!40101 SET character_set_client = @saved_cs_client */;
520
521--
522-- Dumping data for table `wp_gf_addon_feed`
523--
524
525LOCK TABLES `wp_gf_addon_feed` WRITE;
526/*!40000 ALTER TABLE `wp_gf_addon_feed` DISABLE KEYS */;
527/*!40000 ALTER TABLE `wp_gf_addon_feed` ENABLE KEYS */;
528UNLOCK TABLES;
529
530--
531-- Table structure for table `wp_gf_draft_submissions`
532--
533
534DROP TABLE IF EXISTS `wp_gf_draft_submissions`;
535/*!40101 SET @saved_cs_client = @@character_set_client */;
536/*!50503 SET character_set_client = utf8mb4 */;
537CREATE TABLE `wp_gf_draft_submissions` (
538 `uuid` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
539 `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
540 `form_id` mediumint unsigned NOT NULL,
541 `date_created` datetime NOT NULL,
542 `ip` varchar(39) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
543 `source_url` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
544 `submission` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
545 PRIMARY KEY (`uuid`),
546 KEY `form_id` (`form_id`)
547) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
548/*!40101 SET character_set_client = @saved_cs_client */;
549
550--
551-- Dumping data for table `wp_gf_draft_submissions`
552--
553
554LOCK TABLES `wp_gf_draft_submissions` WRITE;
555/*!40000 ALTER TABLE `wp_gf_draft_submissions` DISABLE KEYS */;
556/*!40000 ALTER TABLE `wp_gf_draft_submissions` ENABLE KEYS */;
557UNLOCK TABLES;
558
559--
560-- Table structure for table `wp_gf_entry`
561--
562
563DROP TABLE IF EXISTS `wp_gf_entry`;
564/*!40101 SET @saved_cs_client = @@character_set_client */;
565/*!50503 SET character_set_client = utf8mb4 */;
566CREATE TABLE `wp_gf_entry` (
567 `id` int unsigned NOT NULL AUTO_INCREMENT,
568 `form_id` mediumint unsigned NOT NULL,
569 `post_id` bigint unsigned DEFAULT NULL,
570 `date_created` datetime NOT NULL,
571 `date_updated` datetime DEFAULT NULL,
572 `is_starred` tinyint(1) NOT NULL DEFAULT '0',
573 `is_read` tinyint(1) NOT NULL DEFAULT '0',
574 `ip` varchar(39) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
575 `source_url` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
576 `user_agent` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
577 `currency` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
578 `payment_status` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
579 `payment_date` datetime DEFAULT NULL,
580 `payment_amount` decimal(19,2) DEFAULT NULL,
581 `payment_method` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
582 `transaction_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
583 `is_fulfilled` tinyint(1) DEFAULT NULL,
584 `created_by` bigint unsigned DEFAULT NULL,
585 `transaction_type` tinyint(1) DEFAULT NULL,
586 `status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'active',
587 PRIMARY KEY (`id`),
588 KEY `form_id` (`form_id`),
589 KEY `form_id_status` (`form_id`,`status`)
590) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
591/*!40101 SET character_set_client = @saved_cs_client */;
592
593--
594-- Dumping data for table `wp_gf_entry`
595--
596
597LOCK TABLES `wp_gf_entry` WRITE;
598/*!40000 ALTER TABLE `wp_gf_entry` DISABLE KEYS */;
599/*!40000 ALTER TABLE `wp_gf_entry` ENABLE KEYS */;
600UNLOCK TABLES;
601
602--
603-- Table structure for table `wp_gf_entry_meta`
604--
605
606DROP TABLE IF EXISTS `wp_gf_entry_meta`;
607/*!40101 SET @saved_cs_client = @@character_set_client */;
608/*!50503 SET character_set_client = utf8mb4 */;
609CREATE TABLE `wp_gf_entry_meta` (
610 `id` bigint unsigned NOT NULL AUTO_INCREMENT,
611 `form_id` mediumint unsigned NOT NULL DEFAULT '0',
612 `entry_id` bigint unsigned NOT NULL,
613 `meta_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
614 `meta_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
615 `item_index` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
616 PRIMARY KEY (`id`),
617 KEY `meta_key` (`meta_key`(191)),
618 KEY `entry_id` (`entry_id`),
619 KEY `meta_value` (`meta_value`(191))
620) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
621/*!40101 SET character_set_client = @saved_cs_client */;
622
623--
624-- Dumping data for table `wp_gf_entry_meta`
625--
626
627LOCK TABLES `wp_gf_entry_meta` WRITE;
628/*!40000 ALTER TABLE `wp_gf_entry_meta` DISABLE KEYS */;
629/*!40000 ALTER TABLE `wp_gf_entry_meta` ENABLE KEYS */;
630UNLOCK TABLES;
631
632--
633-- Table structure for table `wp_gf_entry_notes`
634--
635
636DROP TABLE IF EXISTS `wp_gf_entry_notes`;
637/*!40101 SET @saved_cs_client = @@character_set_client */;
638/*!50503 SET character_set_client = utf8mb4 */;
639CREATE TABLE `wp_gf_entry_notes` (
640 `id` int unsigned NOT NULL AUTO_INCREMENT,
641 `entry_id` int unsigned NOT NULL,
642 `user_name` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
643 `user_id` bigint DEFAULT NULL,
644 `date_created` datetime NOT NULL,
645 `value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
646 `note_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
647 `sub_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
648 PRIMARY KEY (`id`),
649 KEY `entry_id` (`entry_id`),
650 KEY `entry_user_key` (`entry_id`,`user_id`)
651) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
652/*!40101 SET character_set_client = @saved_cs_client */;
653
654--
655-- Dumping data for table `wp_gf_entry_notes`
656--
657
658LOCK TABLES `wp_gf_entry_notes` WRITE;
659/*!40000 ALTER TABLE `wp_gf_entry_notes` DISABLE KEYS */;
660/*!40000 ALTER TABLE `wp_gf_entry_notes` ENABLE KEYS */;
661UNLOCK TABLES;
662
663--
664-- Table structure for table `wp_gf_form`
665--
666
667DROP TABLE IF EXISTS `wp_gf_form`;
668/*!40101 SET @saved_cs_client = @@character_set_client */;
669/*!50503 SET character_set_client = utf8mb4 */;
670CREATE TABLE `wp_gf_form` (
671 `id` mediumint unsigned NOT NULL AUTO_INCREMENT,
672 `title` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
673 `date_created` datetime NOT NULL,
674 `date_updated` datetime DEFAULT NULL,
675 `is_active` tinyint(1) NOT NULL DEFAULT '1',
676 `is_trash` tinyint(1) NOT NULL DEFAULT '0',
677 PRIMARY KEY (`id`)
678) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
679/*!40101 SET character_set_client = @saved_cs_client */;
680
681--
682-- Dumping data for table `wp_gf_form`
683--
684
685LOCK TABLES `wp_gf_form` WRITE;
686/*!40000 ALTER TABLE `wp_gf_form` DISABLE KEYS */;
687/*!40000 ALTER TABLE `wp_gf_form` ENABLE KEYS */;
688UNLOCK TABLES;
689
690--
691-- Table structure for table `wp_gf_form_meta`
692--
693
694DROP TABLE IF EXISTS `wp_gf_form_meta`;
695/*!40101 SET @saved_cs_client = @@character_set_client */;
696/*!50503 SET character_set_client = utf8mb4 */;
697CREATE TABLE `wp_gf_form_meta` (
698 `form_id` mediumint unsigned NOT NULL,
699 `display_meta` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
700 `entries_grid_meta` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
701 `confirmations` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
702 `notifications` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
703 PRIMARY KEY (`form_id`)
704) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
705/*!40101 SET character_set_client = @saved_cs_client */;
706
707--
708-- Dumping data for table `wp_gf_form_meta`
709--
710
711LOCK TABLES `wp_gf_form_meta` WRITE;
712/*!40000 ALTER TABLE `wp_gf_form_meta` DISABLE KEYS */;
713/*!40000 ALTER TABLE `wp_gf_form_meta` ENABLE KEYS */;
714UNLOCK TABLES;
715
716--
717-- Table structure for table `wp_gf_form_revisions`
718--
719
720DROP TABLE IF EXISTS `wp_gf_form_revisions`;
721/*!40101 SET @saved_cs_client = @@character_set_client */;
722/*!50503 SET character_set_client = utf8mb4 */;
723CREATE TABLE `wp_gf_form_revisions` (
724 `id` bigint unsigned NOT NULL AUTO_INCREMENT,
725 `form_id` mediumint unsigned NOT NULL,
726 `display_meta` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
727 `date_created` datetime NOT NULL,
728 PRIMARY KEY (`id`),
729 KEY `date_created` (`date_created`),
730 KEY `form_id` (`form_id`)
731) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
732/*!40101 SET character_set_client = @saved_cs_client */;
733
734--
735-- Dumping data for table `wp_gf_form_revisions`
736--
737
738LOCK TABLES `wp_gf_form_revisions` WRITE;
739/*!40000 ALTER TABLE `wp_gf_form_revisions` DISABLE KEYS */;
740/*!40000 ALTER TABLE `wp_gf_form_revisions` ENABLE KEYS */;
741UNLOCK TABLES;
742
743--
744-- Table structure for table `wp_gf_form_view`
745--
746
747DROP TABLE IF EXISTS `wp_gf_form_view`;
748/*!40101 SET @saved_cs_client = @@character_set_client */;
749/*!50503 SET character_set_client = utf8mb4 */;
750CREATE TABLE `wp_gf_form_view` (
751 `id` bigint unsigned NOT NULL AUTO_INCREMENT,
752 `form_id` mediumint unsigned NOT NULL,
753 `date_created` datetime NOT NULL,
754 `ip` char(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
755 `count` mediumint unsigned NOT NULL DEFAULT '1',
756 PRIMARY KEY (`id`),
757 KEY `date_created` (`date_created`),
758 KEY `form_id` (`form_id`)
759) ENGINE=InnoDB AUTO_INCREMENT=116 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
760/*!40101 SET character_set_client = @saved_cs_client */;
761
762--
763-- Dumping data for table `wp_gf_form_view`
764--
765
766LOCK TABLES `wp_gf_form_view` WRITE;
767/*!40000 ALTER TABLE `wp_gf_form_view` DISABLE KEYS */;
768/*!40000 ALTER TABLE `wp_gf_form_view` ENABLE KEYS */;
769UNLOCK TABLES;
770
771--
772-- Table structure for table `wp_oses_clicks`
773--
774
775DROP TABLE IF EXISTS `wp_oses_clicks`;
776/*!40101 SET @saved_cs_client = @@character_set_client */;
777/*!50503 SET character_set_client = utf8mb4 */;
778CREATE TABLE `wp_oses_clicks` (
779 `email_click_id` bigint NOT NULL AUTO_INCREMENT,
780 `email_id` bigint NOT NULL,
781 `email_click_url` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
782 `email_click_count` int DEFAULT '0',
783 `email_first_click_date` datetime DEFAULT NULL,
784 `email_last_click_date` datetime DEFAULT NULL,
785 PRIMARY KEY (`email_click_id`),
786 KEY `email_id` (`email_id`)
787) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
788/*!40101 SET character_set_client = @saved_cs_client */;
789
790--
791-- Dumping data for table `wp_oses_clicks`
792--
793
794LOCK TABLES `wp_oses_clicks` WRITE;
795/*!40000 ALTER TABLE `wp_oses_clicks` DISABLE KEYS */;
796/*!40000 ALTER TABLE `wp_oses_clicks` ENABLE KEYS */;
797UNLOCK TABLES;
798
799--
800-- Table structure for table `wp_oses_emails`
801--
802
803DROP TABLE IF EXISTS `wp_oses_emails`;
804/*!40101 SET @saved_cs_client = @@character_set_client */;
805/*!50503 SET character_set_client = utf8mb4 */;
806CREATE TABLE `wp_oses_emails` (
807 `email_id` bigint NOT NULL AUTO_INCREMENT,
808 `subsite_id` bigint DEFAULT NULL,
809 `email_to` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
810 `email_subject` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
811 `email_message` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
812 `email_headers` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
813 `email_attachments` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
814 `email_status` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,
815 `email_open_count` int DEFAULT '0',
816 `email_first_open_date` datetime DEFAULT NULL,
817 `email_last_open_date` datetime DEFAULT NULL,
818 `email_created` datetime NOT NULL,
819 `email_sent` datetime DEFAULT NULL,
820 `email_parent` bigint DEFAULT NULL,
821 `auto_retries` int DEFAULT '0',
822 `manual_retries` int DEFAULT '0',
823 PRIMARY KEY (`email_id`),
824 KEY `email_subject` (`email_subject`)
825) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
826/*!40101 SET character_set_client = @saved_cs_client */;
827
828--
829-- Dumping data for table `wp_oses_emails`
830--
831
832LOCK TABLES `wp_oses_emails` WRITE;
833/*!40000 ALTER TABLE `wp_oses_emails` DISABLE KEYS */;
834/*!40000 ALTER TABLE `wp_oses_emails` ENABLE KEYS */;
835UNLOCK TABLES;
836
837
838
839--
840-- Table structure for table `wp_w3tc_cdn_pathmap`
841--
842
843DROP TABLE IF EXISTS `wp_w3tc_cdn_pathmap`;
844/*!40101 SET @saved_cs_client = @@character_set_client */;
845/*!50503 SET character_set_client = utf8mb4 */;
846CREATE TABLE `wp_w3tc_cdn_pathmap` (
847 `path` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
848 `path_hash` varchar(32) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL,
849 `type` tinyint(1) NOT NULL DEFAULT '0',
850 `remote_id` varchar(200) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL,
851 PRIMARY KEY (`path_hash`),
852 KEY `remote_id` (`remote_id`)
853) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
854/*!40101 SET character_set_client = @saved_cs_client */;
855
856--
857-- Dumping data for table `wp_w3tc_cdn_pathmap`
858--
859
860LOCK TABLES `wp_w3tc_cdn_pathmap` WRITE;
861/*!40000 ALTER TABLE `wp_w3tc_cdn_pathmap` DISABLE KEYS */;
862/*!40000 ALTER TABLE `wp_w3tc_cdn_pathmap` ENABLE KEYS */;
863UNLOCK TABLES;
864
865--
866-- Table structure for table `wp_w3tc_cdn_queue`
867--
868
869DROP TABLE IF EXISTS `wp_w3tc_cdn_queue`;
870/*!40101 SET @saved_cs_client = @@character_set_client */;
871/*!50503 SET character_set_client = utf8mb4 */;
872CREATE TABLE `wp_w3tc_cdn_queue` (
873 `id` int unsigned NOT NULL AUTO_INCREMENT,
874 `local_path` varchar(500) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
875 `remote_path` varchar(500) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
876 `command` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '1 - Upload, 2 - Delete, 3 - Purge',
877 `last_error` varchar(150) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
878 `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
879 PRIMARY KEY (`id`),
880 KEY `date` (`date`)
881) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
882/*!40101 SET character_set_client = @saved_cs_client */;
883
884--
885-- Dumping data for table `wp_w3tc_cdn_queue`
886--
887
888LOCK TABLES `wp_w3tc_cdn_queue` WRITE;
889/*!40000 ALTER TABLE `wp_w3tc_cdn_queue` DISABLE KEYS */;
890/*!40000 ALTER TABLE `wp_w3tc_cdn_queue` ENABLE KEYS */;
891UNLOCK TABLES;
892
893
894--
895-- Dumping data for table `wp_yoast_seo_meta`
896--
897
898LOCK TABLES `wp_yoast_seo_meta` WRITE;
899/*!40000 ALTER TABLE `wp_yoast_seo_meta` DISABLE KEYS */;
900/*!40000 ALTER TABLE `wp_yoast_seo_meta` ENABLE KEYS */;
901UNLOCK TABLES;
902/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
903
904/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
905/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
906/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
907/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
908/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
909/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
910/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
911
912-- Dump completed on 2020-02-14 8:35:13