· 5 years ago · Jul 08, 2020, 11:48 AM
1
2
3CREATE TABLE IF NOT EXISTS `wp0z_actionscheduler_actions` (
4 `action_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
5 `hook` varchar(191) COLLATE utf8mb4_unicode_520_ci NOT NULL,
6 `status` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,
7 `scheduled_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
8 `scheduled_date_local` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
9 `args` varchar(191) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
10 `schedule` longtext COLLATE utf8mb4_unicode_520_ci,
11 `group_id` bigint(20) unsigned NOT NULL DEFAULT '0',
12 `attempts` int(11) NOT NULL DEFAULT '0',
13 `last_attempt_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
14 `last_attempt_local` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
15 `claim_id` bigint(20) unsigned NOT NULL DEFAULT '0',
16 `extended_args` varchar(8000) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
17 PRIMARY KEY (`action_id`),
18 KEY `hook` (`hook`),
19 KEY `status` (`status`),
20 KEY `scheduled_date_gmt` (`scheduled_date_gmt`),
21 KEY `args` (`args`),
22 KEY `group_id` (`group_id`),
23 KEY `last_attempt_gmt` (`last_attempt_gmt`),
24 KEY `claim_id` (`claim_id`)
25) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci AUTO_INCREMENT=1 ;
26
27-- --------------------------------------------------------
28
29--
30-- Tábla szerkezet: `wp0z_actionscheduler_claims`
31--
32
33CREATE TABLE IF NOT EXISTS `wp0z_actionscheduler_claims` (
34 `claim_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
35 `date_created_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
36 PRIMARY KEY (`claim_id`),
37 KEY `date_created_gmt` (`date_created_gmt`)
38) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci AUTO_INCREMENT=1 ;
39
40-- --------------------------------------------------------
41
42--
43-- Tábla szerkezet: `wp0z_actionscheduler_groups`
44--
45
46CREATE TABLE IF NOT EXISTS `wp0z_actionscheduler_groups` (
47 `group_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
48 `slug` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
49 PRIMARY KEY (`group_id`),
50 KEY `slug` (`slug`(191))
51) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci AUTO_INCREMENT=1 ;
52
53-- --------------------------------------------------------
54
55--
56-- Tábla szerkezet: `wp0z_actionscheduler_logs`
57--
58
59CREATE TABLE IF NOT EXISTS `wp0z_actionscheduler_logs` (
60 `log_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
61 `action_id` bigint(20) unsigned NOT NULL,
62 `message` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
63 `log_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
64 `log_date_local` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
65 PRIMARY KEY (`log_id`),
66 KEY `action_id` (`action_id`),
67 KEY `log_date_gmt` (`log_date_gmt`)
68) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci AUTO_INCREMENT=142 ;
69
70-- --------------------------------------------------------
71
72--
73-- Tábla szerkezet: `wp0z_cf_forms`
74--
75
76CREATE TABLE IF NOT EXISTS `wp0z_cf_forms` (
77 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
78 `form_id` varchar(18) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
79 `type` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
80 `config` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
81 PRIMARY KEY (`id`),
82 KEY `form_id` (`form_id`)
83) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci AUTO_INCREMENT=1 ;
84
85-- --------------------------------------------------------
86
87--
88-- Tábla szerkezet: `wp0z_cf_form_entries`
89--
90
91CREATE TABLE IF NOT EXISTS `wp0z_cf_form_entries` (
92 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
93 `form_id` varchar(18) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
94 `user_id` int(11) NOT NULL,
95 `datestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
96 `status` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'active',
97 PRIMARY KEY (`id`),
98 KEY `form_id` (`form_id`),
99 KEY `user_id` (`user_id`),
100 KEY `date_time` (`datestamp`),
101 KEY `status` (`status`)
102) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci AUTO_INCREMENT=1 ;
103
104-- --------------------------------------------------------
105
106--
107-- Tábla szerkezet: `wp0z_cf_form_entry_meta`
108--
109
110CREATE TABLE IF NOT EXISTS `wp0z_cf_form_entry_meta` (
111 `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
112 `entry_id` bigint(20) unsigned NOT NULL DEFAULT '0',
113 `process_id` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
114 `meta_key` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
115 `meta_value` longtext COLLATE utf8mb4_unicode_520_ci,
116 PRIMARY KEY (`meta_id`),
117 KEY `meta_key` (`meta_key`(191)),
118 KEY `entry_id` (`entry_id`)
119) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci AUTO_INCREMENT=1 ;
120
121-- --------------------------------------------------------
122
123--
124-- Tábla szerkezet: `wp0z_cf_form_entry_values`
125--
126
127CREATE TABLE IF NOT EXISTS `wp0z_cf_form_entry_values` (
128 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
129 `entry_id` int(11) NOT NULL,
130 `field_id` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,
131 `slug` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
132 `value` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
133 PRIMARY KEY (`id`),
134 KEY `form_id` (`entry_id`),
135 KEY `field_id` (`field_id`),
136 KEY `slug` (`slug`(191))
137) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci AUTO_INCREMENT=1 ;
138
139-- --------------------------------------------------------
140
141--
142-- Tábla szerkezet: `wp0z_cf_pro_messages`
143--
144
145CREATE TABLE IF NOT EXISTS `wp0z_cf_pro_messages` (
146 `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
147 `cfp_id` bigint(20) unsigned DEFAULT NULL,
148 `entry_id` bigint(20) unsigned DEFAULT NULL,
149 `hash` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
150 `type` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
151 PRIMARY KEY (`ID`)
152) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci AUTO_INCREMENT=1 ;
153
154-- --------------------------------------------------------
155
156--
157-- Tábla szerkezet: `wp0z_cf_queue_failures`
158--
159
160CREATE TABLE IF NOT EXISTS `wp0z_cf_queue_failures` (
161 `id` bigint(20) NOT NULL AUTO_INCREMENT,
162 `job` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
163 `error` text COLLATE utf8mb4_unicode_520_ci,
164 `failed_at` datetime NOT NULL,
165 PRIMARY KEY (`id`)
166) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci AUTO_INCREMENT=1 ;
167
168-- --------------------------------------------------------
169
170--
171-- Tábla szerkezet: `wp0z_cf_queue_jobs`
172--
173
174CREATE TABLE IF NOT EXISTS `wp0z_cf_queue_jobs` (
175 `id` bigint(20) NOT NULL AUTO_INCREMENT,
176 `job` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
177 `attempts` tinyint(3) NOT NULL DEFAULT '0',
178 `reserved_at` datetime DEFAULT NULL,
179 `available_at` datetime NOT NULL,
180 `created_at` datetime NOT NULL,
181 PRIMARY KEY (`id`)
182) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci AUTO_INCREMENT=1 ;
183
184-- --------------------------------------------------------
185
186--
187-- Tábla szerkezet: `wp0z_commentmeta`
188--
189
190CREATE TABLE IF NOT EXISTS `wp0z_commentmeta` (
191 `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
192 `comment_id` bigint(20) unsigned NOT NULL DEFAULT '0',
193 `meta_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
194 `meta_value` longtext COLLATE utf8mb4_unicode_ci,
195 PRIMARY KEY (`meta_id`),
196 KEY `comment_id` (`comment_id`),
197 KEY `meta_key` (`meta_key`(191))
198) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
199
200-- --------------------------------------------------------
201
202--
203-- Tábla szerkezet: `wp0z_comments`
204--
205
206CREATE TABLE IF NOT EXISTS `wp0z_comments` (
207 `comment_ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
208 `comment_post_ID` bigint(20) unsigned NOT NULL DEFAULT '0',
209 `comment_author` tinytext COLLATE utf8mb4_unicode_ci NOT NULL,
210 `comment_author_email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
211 `comment_author_url` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
212 `comment_author_IP` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
213 `comment_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
214 `comment_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
215 `comment_content` text COLLATE utf8mb4_unicode_ci NOT NULL,
216 `comment_karma` int(11) NOT NULL DEFAULT '0',
217 `comment_approved` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
218 `comment_agent` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
219 `comment_type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
220 `comment_parent` bigint(20) unsigned NOT NULL DEFAULT '0',
221 `user_id` bigint(20) unsigned NOT NULL DEFAULT '0',
222 PRIMARY KEY (`comment_ID`),
223 KEY `comment_post_ID` (`comment_post_ID`),
224 KEY `comment_approved_date_gmt` (`comment_approved`,`comment_date_gmt`),
225 KEY `comment_date_gmt` (`comment_date_gmt`),
226 KEY `comment_parent` (`comment_parent`),
227 KEY `comment_author_email` (`comment_author_email`(10)),
228 KEY `woo_idx_comment_type` (`comment_type`)
229) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
230
231-- --------------------------------------------------------
232
233--
234-- Tábla szerkezet: `wp0z_duplicator_packages`
235--
236
237CREATE TABLE IF NOT EXISTS `wp0z_duplicator_packages` (
238 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
239 `name` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
240 `hash` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
241 `status` int(11) NOT NULL,
242 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
243 `owner` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
244 `package` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
245 PRIMARY KEY (`id`),
246 KEY `hash` (`hash`)
247) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
248
249-- --------------------------------------------------------
250
251--
252-- Tábla szerkezet: `wp0z_links`
253--
254
255CREATE TABLE IF NOT EXISTS `wp0z_links` (
256 `link_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
257 `link_url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
258 `link_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
259 `link_image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
260 `link_target` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
261 `link_description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
262 `link_visible` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Y',
263 `link_owner` bigint(20) unsigned NOT NULL DEFAULT '1',
264 `link_rating` int(11) NOT NULL DEFAULT '0',
265 `link_updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
266 `link_rel` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
267 `link_notes` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
268 `link_rss` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
269 PRIMARY KEY (`link_id`),
270 KEY `link_visible` (`link_visible`)
271) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
272
273-- --------------------------------------------------------
274
275--
276-- Tábla szerkezet: `wp0z_options`
277--
278
279CREATE TABLE IF NOT EXISTS `wp0z_options` (
280 `option_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
281 `option_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
282 `option_value` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
283 `autoload` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'yes',
284 PRIMARY KEY (`option_id`),
285 UNIQUE KEY `option_name` (`option_name`),
286 KEY `autoload` (`autoload`)
287) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
288
289-- --------------------------------------------------------
290
291--
292-- Tábla szerkezet: `wp0z_postmeta`
293--
294
295CREATE TABLE IF NOT EXISTS `wp0z_postmeta` (
296 `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
297 `post_id` bigint(20) unsigned NOT NULL DEFAULT '0',
298 `meta_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
299 `meta_value` longtext COLLATE utf8mb4_unicode_ci,
300 PRIMARY KEY (`meta_id`),
301 KEY `post_id` (`post_id`),
302 KEY `meta_key` (`meta_key`(191))
303) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
304
305-- --------------------------------------------------------
306
307--
308-- Tábla szerkezet: `wp0z_posts`
309--
310
311CREATE TABLE IF NOT EXISTS `wp0z_posts` (
312 `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
313 `post_author` bigint(20) unsigned NOT NULL DEFAULT '0',
314 `post_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
315 `post_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
316 `post_content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
317 `post_title` text COLLATE utf8mb4_unicode_ci NOT NULL,
318 `post_excerpt` text COLLATE utf8mb4_unicode_ci NOT NULL,
319 `post_status` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'publish',
320 `comment_status` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'open',
321 `ping_status` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'open',
322 `post_password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
323 `post_name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
324 `to_ping` text COLLATE utf8mb4_unicode_ci NOT NULL,
325 `pinged` text COLLATE utf8mb4_unicode_ci NOT NULL,
326 `post_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
327 `post_modified_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
328 `post_content_filtered` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
329 `post_parent` bigint(20) unsigned NOT NULL DEFAULT '0',
330 `guid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
331 `menu_order` int(11) NOT NULL DEFAULT '0',
332 `post_type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'post',
333 `post_mime_type` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
334 `comment_count` bigint(20) NOT NULL DEFAULT '0',
335 PRIMARY KEY (`ID`),
336 KEY `post_name` (`post_name`(191)),
337 KEY `type_status_date` (`post_type`,`post_status`,`post_date`,`ID`),
338 KEY `post_parent` (`post_parent`),
339 KEY `post_author` (`post_author`)
340) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
341
342-- --------------------------------------------------------
343
344--
345-- Tábla szerkezet: `wp0z_termmeta`
346--
347
348CREATE TABLE IF NOT EXISTS `wp0z_termmeta` (
349 `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
350 `term_id` bigint(20) unsigned NOT NULL DEFAULT '0',
351 `meta_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
352 `meta_value` longtext COLLATE utf8mb4_unicode_ci,
353 PRIMARY KEY (`meta_id`),
354 KEY `term_id` (`term_id`),
355 KEY `meta_key` (`meta_key`(191))
356) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
357
358-- --------------------------------------------------------
359
360--
361-- Tábla szerkezet: `wp0z_terms`
362--
363
364CREATE TABLE IF NOT EXISTS `wp0z_terms` (
365 `term_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
366 `name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
367 `slug` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
368 `term_group` bigint(10) NOT NULL DEFAULT '0',
369 PRIMARY KEY (`term_id`),
370 KEY `slug` (`slug`(191)),
371 KEY `name` (`name`(191))
372) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
373
374-- --------------------------------------------------------
375
376--
377-- Tábla szerkezet: `wp0z_term_relationships`
378--
379
380CREATE TABLE IF NOT EXISTS `wp0z_term_relationships` (
381 `object_id` bigint(20) unsigned NOT NULL DEFAULT '0',
382 `term_taxonomy_id` bigint(20) unsigned NOT NULL DEFAULT '0',
383 `term_order` int(11) NOT NULL DEFAULT '0',
384 PRIMARY KEY (`object_id`,`term_taxonomy_id`),
385 KEY `term_taxonomy_id` (`term_taxonomy_id`)
386) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
387
388-- --------------------------------------------------------
389
390--
391-- Tábla szerkezet: `wp0z_term_taxonomy`
392--
393
394CREATE TABLE IF NOT EXISTS `wp0z_term_taxonomy` (
395 `term_taxonomy_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
396 `term_id` bigint(20) unsigned NOT NULL DEFAULT '0',
397 `taxonomy` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
398 `description` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
399 `parent` bigint(20) unsigned NOT NULL DEFAULT '0',
400 `count` bigint(20) NOT NULL DEFAULT '0',
401 PRIMARY KEY (`term_taxonomy_id`),
402 UNIQUE KEY `term_id_taxonomy` (`term_id`,`taxonomy`),
403 KEY `taxonomy` (`taxonomy`)
404) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
405
406-- --------------------------------------------------------
407
408--
409-- Tábla szerkezet: `wp0z_usermeta`
410--
411
412CREATE TABLE IF NOT EXISTS `wp0z_usermeta` (
413 `umeta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
414 `user_id` bigint(20) unsigned NOT NULL DEFAULT '0',
415 `meta_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
416 `meta_value` longtext COLLATE utf8mb4_unicode_ci,
417 PRIMARY KEY (`umeta_id`),
418 KEY `user_id` (`user_id`),
419 KEY `meta_key` (`meta_key`(191))
420) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
421
422-- --------------------------------------------------------
423
424--
425-- Tábla szerkezet: `wp0z_users`
426--
427
428CREATE TABLE IF NOT EXISTS `wp0z_users` (
429 `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
430 `user_login` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
431 `user_pass` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
432 `user_nicename` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
433 `user_email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
434 `user_url` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
435 `user_registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
436 `user_activation_key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
437 `user_status` int(11) NOT NULL DEFAULT '0',
438 `display_name` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
439 PRIMARY KEY (`ID`),
440 KEY `user_login_key` (`user_login`),
441 KEY `user_nicename` (`user_nicename`),
442 KEY `user_email` (`user_email`)
443) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
444
445-- --------------------------------------------------------
446
447--
448-- Tábla szerkezet: `wp0z_wc_admin_notes`
449--
450
451CREATE TABLE IF NOT EXISTS `wp0z_wc_admin_notes` (
452 `note_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
453 `name` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
454 `type` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,
455 `locale` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,
456 `title` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
457 `content` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
458 `icon` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
459 `content_data` longtext COLLATE utf8mb4_unicode_520_ci,
460 `status` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
461 `source` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
462 `date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
463 `date_reminder` datetime DEFAULT NULL,
464 `is_snoozable` tinyint(1) NOT NULL DEFAULT '0',
465 PRIMARY KEY (`note_id`)
466) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci AUTO_INCREMENT=1 ;
467
468-- --------------------------------------------------------
469
470--
471-- Tábla szerkezet: `wp0z_wc_admin_note_actions`
472--
473
474CREATE TABLE IF NOT EXISTS `wp0z_wc_admin_note_actions` (
475 `action_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
476 `note_id` bigint(20) unsigned NOT NULL,
477 `name` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
478 `label` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
479 `query` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
480 `status` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
481 `is_primary` tinyint(1) NOT NULL DEFAULT '0',
482 PRIMARY KEY (`action_id`),
483 KEY `note_id` (`note_id`)
484) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci AUTO_INCREMENT=1 ;
485
486-- --------------------------------------------------------
487
488--
489-- Tábla szerkezet: `wp0z_wc_category_lookup`
490--
491
492CREATE TABLE IF NOT EXISTS `wp0z_wc_category_lookup` (
493 `category_tree_id` bigint(20) unsigned NOT NULL,
494 `category_id` bigint(20) unsigned NOT NULL,
495 PRIMARY KEY (`category_tree_id`,`category_id`)
496) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
497
498-- --------------------------------------------------------
499
500--
501-- Tábla szerkezet: `wp0z_wc_customer_lookup`
502--
503
504CREATE TABLE IF NOT EXISTS `wp0z_wc_customer_lookup` (
505 `customer_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
506 `user_id` bigint(20) unsigned DEFAULT NULL,
507 `username` varchar(60) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
508 `first_name` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
509 `last_name` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
510 `email` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
511 `date_last_active` timestamp NULL DEFAULT NULL,
512 `date_registered` timestamp NULL DEFAULT NULL,
513 `country` char(2) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
514 `postcode` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
515 `city` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
516 `state` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
517 PRIMARY KEY (`customer_id`),
518 UNIQUE KEY `user_id` (`user_id`),
519 KEY `email` (`email`)
520) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci AUTO_INCREMENT=1 ;
521
522-- --------------------------------------------------------
523
524--
525-- Tábla szerkezet: `wp0z_wc_download_log`
526--
527
528CREATE TABLE IF NOT EXISTS `wp0z_wc_download_log` (
529 `download_log_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
530 `timestamp` datetime NOT NULL,
531 `permission_id` bigint(20) unsigned NOT NULL,
532 `user_id` bigint(20) unsigned DEFAULT NULL,
533 `user_ip_address` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT '',
534 PRIMARY KEY (`download_log_id`),
535 KEY `permission_id` (`permission_id`),
536 KEY `timestamp` (`timestamp`)
537) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci AUTO_INCREMENT=1 ;
538
539-- --------------------------------------------------------
540
541--
542-- Tábla szerkezet: `wp0z_wc_order_coupon_lookup`
543--
544
545CREATE TABLE IF NOT EXISTS `wp0z_wc_order_coupon_lookup` (
546 `order_id` bigint(20) unsigned NOT NULL,
547 `coupon_id` bigint(20) unsigned NOT NULL,
548 `date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
549 `discount_amount` double NOT NULL DEFAULT '0',
550 PRIMARY KEY (`order_id`,`coupon_id`),
551 KEY `coupon_id` (`coupon_id`),
552 KEY `date_created` (`date_created`)
553) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
554
555-- --------------------------------------------------------
556
557--
558-- Tábla szerkezet: `wp0z_wc_order_product_lookup`
559--
560
561CREATE TABLE IF NOT EXISTS `wp0z_wc_order_product_lookup` (
562 `order_item_id` bigint(20) unsigned NOT NULL,
563 `order_id` bigint(20) unsigned NOT NULL,
564 `product_id` bigint(20) unsigned NOT NULL,
565 `variation_id` bigint(20) unsigned NOT NULL,
566 `customer_id` bigint(20) unsigned DEFAULT NULL,
567 `date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
568 `product_qty` int(11) NOT NULL,
569 `product_net_revenue` double NOT NULL DEFAULT '0',
570 `product_gross_revenue` double NOT NULL DEFAULT '0',
571 `coupon_amount` double NOT NULL DEFAULT '0',
572 `tax_amount` double NOT NULL DEFAULT '0',
573 `shipping_amount` double NOT NULL DEFAULT '0',
574 `shipping_tax_amount` double NOT NULL DEFAULT '0',
575 PRIMARY KEY (`order_item_id`),
576 KEY `order_id` (`order_id`),
577 KEY `product_id` (`product_id`),
578 KEY `customer_id` (`customer_id`),
579 KEY `date_created` (`date_created`)
580) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
581
582-- --------------------------------------------------------
583
584--
585-- Tábla szerkezet: `wp0z_wc_order_stats`
586--
587
588CREATE TABLE IF NOT EXISTS `wp0z_wc_order_stats` (
589 `order_id` bigint(20) unsigned NOT NULL,
590 `parent_id` bigint(20) unsigned NOT NULL DEFAULT '0',
591 `date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
592 `date_created_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
593 `num_items_sold` int(11) NOT NULL DEFAULT '0',
594 `total_sales` double NOT NULL DEFAULT '0',
595 `tax_total` double NOT NULL DEFAULT '0',
596 `shipping_total` double NOT NULL DEFAULT '0',
597 `net_total` double NOT NULL DEFAULT '0',
598 `returning_customer` tinyint(1) DEFAULT NULL,
599 `status` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
600 `customer_id` bigint(20) unsigned NOT NULL,
601 PRIMARY KEY (`order_id`),
602 KEY `date_created` (`date_created`),
603 KEY `customer_id` (`customer_id`),
604 KEY `status` (`status`(191))
605) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
606
607-- --------------------------------------------------------
608
609--
610-- Tábla szerkezet: `wp0z_wc_order_tax_lookup`
611--
612
613CREATE TABLE IF NOT EXISTS `wp0z_wc_order_tax_lookup` (
614 `order_id` bigint(20) unsigned NOT NULL,
615 `tax_rate_id` bigint(20) unsigned NOT NULL,
616 `date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
617 `shipping_tax` double NOT NULL DEFAULT '0',
618 `order_tax` double NOT NULL DEFAULT '0',
619 `total_tax` double NOT NULL DEFAULT '0',
620 PRIMARY KEY (`order_id`,`tax_rate_id`),
621 KEY `tax_rate_id` (`tax_rate_id`),
622 KEY `date_created` (`date_created`)
623) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
624
625-- --------------------------------------------------------
626
627--
628-- Tábla szerkezet: `wp0z_wc_product_meta_lookup`
629--
630
631CREATE TABLE IF NOT EXISTS `wp0z_wc_product_meta_lookup` (
632 `product_id` bigint(20) NOT NULL,
633 `sku` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT '',
634 `virtual` tinyint(1) DEFAULT '0',
635 `downloadable` tinyint(1) DEFAULT '0',
636 `min_price` decimal(19,4) DEFAULT NULL,
637 `max_price` decimal(19,4) DEFAULT NULL,
638 `onsale` tinyint(1) DEFAULT '0',
639 `stock_quantity` double DEFAULT NULL,
640 `stock_status` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT 'instock',
641 `rating_count` bigint(20) DEFAULT '0',
642 `average_rating` decimal(3,2) DEFAULT '0.00',
643 `total_sales` bigint(20) DEFAULT '0',
644 `tax_status` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT 'taxable',
645 `tax_class` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT '',
646 PRIMARY KEY (`product_id`),
647 KEY `virtual` (`virtual`),
648 KEY `downloadable` (`downloadable`),
649 KEY `stock_status` (`stock_status`),
650 KEY `stock_quantity` (`stock_quantity`),
651 KEY `onsale` (`onsale`),
652 KEY `min_max_price` (`min_price`,`max_price`)
653) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
654
655-- --------------------------------------------------------
656
657--
658-- Tábla szerkezet: `wp0z_wc_tax_rate_classes`
659--
660
661CREATE TABLE IF NOT EXISTS `wp0z_wc_tax_rate_classes` (
662 `tax_rate_class_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
663 `name` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
664 `slug` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
665 PRIMARY KEY (`tax_rate_class_id`),
666 UNIQUE KEY `slug` (`slug`(191))
667) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci AUTO_INCREMENT=1 ;
668
669-- --------------------------------------------------------
670
671--
672-- Tábla szerkezet: `wp0z_wc_webhooks`
673--
674
675CREATE TABLE IF NOT EXISTS `wp0z_wc_webhooks` (
676 `webhook_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
677 `status` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
678 `name` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
679 `user_id` bigint(20) unsigned NOT NULL,
680 `delivery_url` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
681 `secret` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
682 `topic` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
683 `date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
684 `date_created_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
685 `date_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
686 `date_modified_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
687 `api_version` smallint(4) NOT NULL,
688 `failure_count` smallint(10) NOT NULL DEFAULT '0',
689 `pending_delivery` tinyint(1) NOT NULL DEFAULT '0',
690 PRIMARY KEY (`webhook_id`),
691 KEY `user_id` (`user_id`)
692) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci AUTO_INCREMENT=1 ;
693
694-- --------------------------------------------------------
695
696--
697-- Tábla szerkezet: `wp0z_wfblockediplog`
698--
699
700CREATE TABLE IF NOT EXISTS `wp0z_wfblockediplog` (
701 `IP` binary(16) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
702 `countryCode` varchar(2) NOT NULL,
703 `blockCount` int(10) unsigned NOT NULL DEFAULT '0',
704 `unixday` int(10) unsigned NOT NULL,
705 `blockType` varchar(50) NOT NULL DEFAULT 'generic',
706 PRIMARY KEY (`IP`,`unixday`,`blockType`)
707) ENGINE=MyISAM DEFAULT CHARSET=utf8;
708
709-- --------------------------------------------------------
710
711--
712-- Tábla szerkezet: `wp0z_wfblocks7`
713--
714
715CREATE TABLE IF NOT EXISTS `wp0z_wfblocks7` (
716 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
717 `type` int(10) unsigned NOT NULL DEFAULT '0',
718 `IP` binary(16) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
719 `blockedTime` bigint(20) NOT NULL,
720 `reason` varchar(255) NOT NULL,
721 `lastAttempt` int(10) unsigned DEFAULT '0',
722 `blockedHits` int(10) unsigned DEFAULT '0',
723 `expiration` bigint(20) unsigned NOT NULL DEFAULT '0',
724 `parameters` text,
725 PRIMARY KEY (`id`),
726 KEY `type` (`type`),
727 KEY `IP` (`IP`),
728 KEY `expiration` (`expiration`)
729) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
730
731-- --------------------------------------------------------
732
733--
734-- Tábla szerkezet: `wp0z_wfconfig`
735--
736
737CREATE TABLE IF NOT EXISTS `wp0z_wfconfig` (
738 `name` varchar(100) NOT NULL,
739 `val` longblob,
740 `autoload` enum('no','yes') NOT NULL DEFAULT 'yes',
741 PRIMARY KEY (`name`)
742) ENGINE=MyISAM DEFAULT CHARSET=utf8;
743
744-- --------------------------------------------------------
745
746--
747-- Tábla szerkezet: `wp0z_wfcrawlers`
748--
749
750CREATE TABLE IF NOT EXISTS `wp0z_wfcrawlers` (
751 `IP` binary(16) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
752 `patternSig` binary(16) NOT NULL,
753 `status` char(8) NOT NULL,
754 `lastUpdate` int(10) unsigned NOT NULL,
755 `PTR` varchar(255) DEFAULT '',
756 PRIMARY KEY (`IP`,`patternSig`)
757) ENGINE=MyISAM DEFAULT CHARSET=utf8;
758
759-- --------------------------------------------------------
760
761--
762-- Tábla szerkezet: `wp0z_wffilechanges`
763--
764
765CREATE TABLE IF NOT EXISTS `wp0z_wffilechanges` (
766 `filenameHash` char(64) NOT NULL,
767 `file` varchar(1000) NOT NULL,
768 `md5` char(32) NOT NULL,
769 PRIMARY KEY (`filenameHash`)
770) ENGINE=MyISAM DEFAULT CHARSET=utf8;
771
772-- --------------------------------------------------------
773
774--
775-- Tábla szerkezet: `wp0z_wffilemods`
776--
777
778CREATE TABLE IF NOT EXISTS `wp0z_wffilemods` (
779 `filenameMD5` binary(16) NOT NULL,
780 `filename` varchar(1000) NOT NULL,
781 `knownFile` tinyint(3) unsigned NOT NULL,
782 `oldMD5` binary(16) NOT NULL,
783 `newMD5` binary(16) NOT NULL,
784 `SHAC` binary(32) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
785 `stoppedOnSignature` varchar(255) NOT NULL DEFAULT '',
786 `stoppedOnPosition` int(10) unsigned NOT NULL DEFAULT '0',
787 `isSafeFile` varchar(1) NOT NULL DEFAULT '?',
788 PRIMARY KEY (`filenameMD5`)
789) ENGINE=MyISAM DEFAULT CHARSET=utf8;
790
791-- --------------------------------------------------------
792
793--
794-- Tábla szerkezet: `wp0z_wfhits`
795--
796
797CREATE TABLE IF NOT EXISTS `wp0z_wfhits` (
798 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
799 `attackLogTime` double(17,6) unsigned NOT NULL,
800 `ctime` double(17,6) unsigned NOT NULL,
801 `IP` binary(16) DEFAULT NULL,
802 `jsRun` tinyint(4) DEFAULT '0',
803 `statusCode` int(11) NOT NULL DEFAULT '200',
804 `isGoogle` tinyint(4) NOT NULL,
805 `userID` int(10) unsigned NOT NULL,
806 `newVisit` tinyint(3) unsigned NOT NULL,
807 `URL` text,
808 `referer` text,
809 `UA` text,
810 `action` varchar(64) NOT NULL DEFAULT '',
811 `actionDescription` text,
812 `actionData` text,
813 PRIMARY KEY (`id`),
814 KEY `k1` (`ctime`),
815 KEY `k2` (`IP`,`ctime`),
816 KEY `attackLogTime` (`attackLogTime`)
817) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
818
819-- --------------------------------------------------------
820
821--
822-- Tábla szerkezet: `wp0z_wfhoover`
823--
824
825CREATE TABLE IF NOT EXISTS `wp0z_wfhoover` (
826 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
827 `owner` text,
828 `host` text,
829 `path` text,
830 `hostKey` varbinary(124) DEFAULT NULL,
831 PRIMARY KEY (`id`),
832 KEY `k2` (`hostKey`)
833) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
834
835-- --------------------------------------------------------
836
837--
838-- Tábla szerkezet: `wp0z_wfissues`
839--
840
841CREATE TABLE IF NOT EXISTS `wp0z_wfissues` (
842 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
843 `time` int(10) unsigned NOT NULL,
844 `lastUpdated` int(10) unsigned NOT NULL,
845 `status` varchar(10) NOT NULL,
846 `type` varchar(20) NOT NULL,
847 `severity` tinyint(3) unsigned NOT NULL,
848 `ignoreP` char(32) NOT NULL,
849 `ignoreC` char(32) NOT NULL,
850 `shortMsg` varchar(255) NOT NULL,
851 `longMsg` text,
852 `data` text,
853 PRIMARY KEY (`id`),
854 KEY `lastUpdated` (`lastUpdated`),
855 KEY `status` (`status`),
856 KEY `ignoreP` (`ignoreP`),
857 KEY `ignoreC` (`ignoreC`)
858) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
859
860-- --------------------------------------------------------
861
862--
863-- Tábla szerkezet: `wp0z_wfknownfilelist`
864--
865
866CREATE TABLE IF NOT EXISTS `wp0z_wfknownfilelist` (
867 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
868 `path` text NOT NULL,
869 PRIMARY KEY (`id`)
870) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
871
872-- --------------------------------------------------------
873
874--
875-- Tábla szerkezet: `wp0z_wflivetraffichuman`
876--
877
878CREATE TABLE IF NOT EXISTS `wp0z_wflivetraffichuman` (
879 `IP` binary(16) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
880 `identifier` binary(32) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
881 `expiration` int(10) unsigned NOT NULL,
882 PRIMARY KEY (`IP`,`identifier`),
883 KEY `expiration` (`expiration`)
884) ENGINE=MyISAM DEFAULT CHARSET=utf8;
885
886-- --------------------------------------------------------
887
888--
889-- Tábla szerkezet: `wp0z_wflocs`
890--
891
892CREATE TABLE IF NOT EXISTS `wp0z_wflocs` (
893 `IP` binary(16) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
894 `ctime` int(10) unsigned NOT NULL,
895 `failed` tinyint(3) unsigned NOT NULL,
896 `city` varchar(255) DEFAULT '',
897 `region` varchar(255) DEFAULT '',
898 `countryName` varchar(255) DEFAULT '',
899 `countryCode` char(2) DEFAULT '',
900 `lat` float(10,7) DEFAULT '0.0000000',
901 `lon` float(10,7) DEFAULT '0.0000000',
902 PRIMARY KEY (`IP`)
903) ENGINE=MyISAM DEFAULT CHARSET=utf8;
904
905-- --------------------------------------------------------
906
907--
908-- Tábla szerkezet: `wp0z_wflogins`
909--
910
911CREATE TABLE IF NOT EXISTS `wp0z_wflogins` (
912 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
913 `hitID` int(11) DEFAULT NULL,
914 `ctime` double(17,6) unsigned NOT NULL,
915 `fail` tinyint(3) unsigned NOT NULL,
916 `action` varchar(40) NOT NULL,
917 `username` varchar(255) NOT NULL,
918 `userID` int(10) unsigned NOT NULL,
919 `IP` binary(16) DEFAULT NULL,
920 `UA` text,
921 PRIMARY KEY (`id`),
922 KEY `k1` (`IP`,`fail`),
923 KEY `hitID` (`hitID`)
924) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
925
926-- --------------------------------------------------------
927
928--
929-- Tábla szerkezet: `wp0z_wfls_2fa_secrets`
930--
931
932CREATE TABLE IF NOT EXISTS `wp0z_wfls_2fa_secrets` (
933 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
934 `user_id` bigint(20) unsigned NOT NULL,
935 `secret` tinyblob NOT NULL,
936 `recovery` blob NOT NULL,
937 `ctime` int(10) unsigned NOT NULL,
938 `vtime` int(10) unsigned NOT NULL,
939 `mode` enum('authenticator') NOT NULL DEFAULT 'authenticator',
940 PRIMARY KEY (`id`),
941 KEY `user_id` (`user_id`)
942) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
943
944-- --------------------------------------------------------
945
946--
947-- Tábla szerkezet: `wp0z_wfls_settings`
948--
949
950CREATE TABLE IF NOT EXISTS `wp0z_wfls_settings` (
951 `name` varchar(191) NOT NULL DEFAULT '',
952 `value` longblob,
953 `autoload` enum('no','yes') NOT NULL DEFAULT 'yes',
954 PRIMARY KEY (`name`)
955) ENGINE=InnoDB DEFAULT CHARSET=utf8;
956
957-- --------------------------------------------------------
958
959--
960-- Tábla szerkezet: `wp0z_wfnotifications`
961--
962
963CREATE TABLE IF NOT EXISTS `wp0z_wfnotifications` (
964 `id` varchar(32) NOT NULL DEFAULT '',
965 `new` tinyint(3) unsigned NOT NULL DEFAULT '1',
966 `category` varchar(255) NOT NULL,
967 `priority` int(11) NOT NULL DEFAULT '1000',
968 `ctime` int(10) unsigned NOT NULL,
969 `html` text NOT NULL,
970 `links` text NOT NULL,
971 PRIMARY KEY (`id`)
972) ENGINE=MyISAM DEFAULT CHARSET=utf8;
973
974-- --------------------------------------------------------
975
976--
977-- Tábla szerkezet: `wp0z_wfpendingissues`
978--
979
980CREATE TABLE IF NOT EXISTS `wp0z_wfpendingissues` (
981 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
982 `time` int(10) unsigned NOT NULL,
983 `lastUpdated` int(10) unsigned NOT NULL,
984 `status` varchar(10) NOT NULL,
985 `type` varchar(20) NOT NULL,
986 `severity` tinyint(3) unsigned NOT NULL,
987 `ignoreP` char(32) NOT NULL,
988 `ignoreC` char(32) NOT NULL,
989 `shortMsg` varchar(255) NOT NULL,
990 `longMsg` text,
991 `data` text,
992 PRIMARY KEY (`id`),
993 KEY `lastUpdated` (`lastUpdated`),
994 KEY `status` (`status`),
995 KEY `ignoreP` (`ignoreP`),
996 KEY `ignoreC` (`ignoreC`)
997) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
998
999-- --------------------------------------------------------
1000
1001--
1002-- Tábla szerkezet: `wp0z_wfreversecache`
1003--
1004
1005CREATE TABLE IF NOT EXISTS `wp0z_wfreversecache` (
1006 `IP` binary(16) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
1007 `host` varchar(255) NOT NULL,
1008 `lastUpdate` int(10) unsigned NOT NULL,
1009 PRIMARY KEY (`IP`)
1010) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1011
1012-- --------------------------------------------------------
1013
1014--
1015-- Tábla szerkezet: `wp0z_wfsnipcache`
1016--
1017
1018CREATE TABLE IF NOT EXISTS `wp0z_wfsnipcache` (
1019 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1020 `IP` varchar(45) NOT NULL DEFAULT '',
1021 `expiration` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1022 `body` varchar(255) NOT NULL DEFAULT '',
1023 `count` int(10) unsigned NOT NULL DEFAULT '0',
1024 `type` int(10) unsigned NOT NULL DEFAULT '0',
1025 PRIMARY KEY (`id`),
1026 KEY `expiration` (`expiration`),
1027 KEY `IP` (`IP`),
1028 KEY `type` (`type`)
1029) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1030
1031-- --------------------------------------------------------
1032
1033--
1034-- Tábla szerkezet: `wp0z_wfstatus`
1035--
1036
1037CREATE TABLE IF NOT EXISTS `wp0z_wfstatus` (
1038 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1039 `ctime` double(17,6) unsigned NOT NULL,
1040 `level` tinyint(3) unsigned NOT NULL,
1041 `type` char(5) NOT NULL,
1042 `msg` varchar(1000) NOT NULL,
1043 PRIMARY KEY (`id`),
1044 KEY `k1` (`ctime`),
1045 KEY `k2` (`type`)
1046) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1047
1048-- --------------------------------------------------------
1049
1050--
1051-- Tábla szerkezet: `wp0z_wftrafficrates`
1052--
1053
1054CREATE TABLE IF NOT EXISTS `wp0z_wftrafficrates` (
1055 `eMin` int(10) unsigned NOT NULL,
1056 `IP` binary(16) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
1057 `hitType` enum('hit','404') NOT NULL DEFAULT 'hit',
1058 `hits` int(10) unsigned NOT NULL,
1059 PRIMARY KEY (`eMin`,`IP`,`hitType`)
1060) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1061
1062-- --------------------------------------------------------
1063
1064--
1065-- Tábla szerkezet: `wp0z_woocommerce_api_keys`
1066--
1067
1068CREATE TABLE IF NOT EXISTS `wp0z_woocommerce_api_keys` (
1069 `key_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1070 `user_id` bigint(20) unsigned NOT NULL,
1071 `description` varchar(200) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1072 `permissions` varchar(10) COLLATE utf8mb4_unicode_520_ci NOT NULL,
1073 `consumer_key` char(64) COLLATE utf8mb4_unicode_520_ci NOT NULL,
1074 `consumer_secret` char(43) COLLATE utf8mb4_unicode_520_ci NOT NULL,
1075 `nonces` longtext COLLATE utf8mb4_unicode_520_ci,
1076 `truncated_key` char(7) COLLATE utf8mb4_unicode_520_ci NOT NULL,
1077 `last_access` datetime DEFAULT NULL,
1078 PRIMARY KEY (`key_id`),
1079 KEY `consumer_key` (`consumer_key`),
1080 KEY `consumer_secret` (`consumer_secret`)
1081) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci AUTO_INCREMENT=1 ;
1082
1083-- --------------------------------------------------------
1084
1085--
1086-- Tábla szerkezet: `wp0z_woocommerce_attribute_taxonomies`
1087--
1088
1089CREATE TABLE IF NOT EXISTS `wp0z_woocommerce_attribute_taxonomies` (
1090 `attribute_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1091 `attribute_name` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
1092 `attribute_label` varchar(200) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1093 `attribute_type` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,
1094 `attribute_orderby` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,
1095 `attribute_public` int(1) NOT NULL DEFAULT '1',
1096 PRIMARY KEY (`attribute_id`),
1097 KEY `attribute_name` (`attribute_name`(20))
1098) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci AUTO_INCREMENT=1 ;
1099
1100-- --------------------------------------------------------
1101
1102--
1103-- Tábla szerkezet: `wp0z_woocommerce_downloadable_product_permissions`
1104--
1105
1106CREATE TABLE IF NOT EXISTS `wp0z_woocommerce_downloadable_product_permissions` (
1107 `permission_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1108 `download_id` varchar(36) COLLATE utf8mb4_unicode_520_ci NOT NULL,
1109 `product_id` bigint(20) unsigned NOT NULL,
1110 `order_id` bigint(20) unsigned NOT NULL DEFAULT '0',
1111 `order_key` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
1112 `user_email` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
1113 `user_id` bigint(20) unsigned DEFAULT NULL,
1114 `downloads_remaining` varchar(9) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1115 `access_granted` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1116 `access_expires` datetime DEFAULT NULL,
1117 `download_count` bigint(20) unsigned NOT NULL DEFAULT '0',
1118 PRIMARY KEY (`permission_id`),
1119 KEY `download_order_key_product` (`product_id`,`order_id`,`order_key`(16),`download_id`),
1120 KEY `download_order_product` (`download_id`,`order_id`,`product_id`),
1121 KEY `order_id` (`order_id`),
1122 KEY `user_order_remaining_expires` (`user_id`,`order_id`,`downloads_remaining`,`access_expires`)
1123) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci AUTO_INCREMENT=1 ;
1124
1125-- --------------------------------------------------------
1126
1127--
1128-- Tábla szerkezet: `wp0z_woocommerce_log`
1129--
1130
1131CREATE TABLE IF NOT EXISTS `wp0z_woocommerce_log` (
1132 `log_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1133 `timestamp` datetime NOT NULL,
1134 `level` smallint(4) NOT NULL,
1135 `source` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
1136 `message` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
1137 `context` longtext COLLATE utf8mb4_unicode_520_ci,
1138 PRIMARY KEY (`log_id`),
1139 KEY `level` (`level`)
1140) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci AUTO_INCREMENT=1 ;
1141
1142-- --------------------------------------------------------
1143
1144--
1145-- Tábla szerkezet: `wp0z_woocommerce_order_itemmeta`
1146--
1147
1148CREATE TABLE IF NOT EXISTS `wp0z_woocommerce_order_itemmeta` (
1149 `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1150 `order_item_id` bigint(20) unsigned NOT NULL,
1151 `meta_key` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1152 `meta_value` longtext COLLATE utf8mb4_unicode_520_ci,
1153 PRIMARY KEY (`meta_id`),
1154 KEY `order_item_id` (`order_item_id`),
1155 KEY `meta_key` (`meta_key`(32))
1156) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci AUTO_INCREMENT=1 ;
1157
1158-- --------------------------------------------------------
1159
1160--
1161-- Tábla szerkezet: `wp0z_woocommerce_order_items`
1162--
1163
1164CREATE TABLE IF NOT EXISTS `wp0z_woocommerce_order_items` (
1165 `order_item_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1166 `order_item_name` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
1167 `order_item_type` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
1168 `order_id` bigint(20) unsigned NOT NULL,
1169 PRIMARY KEY (`order_item_id`),
1170 KEY `order_id` (`order_id`)
1171) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci AUTO_INCREMENT=1 ;
1172
1173-- --------------------------------------------------------
1174
1175--
1176-- Tábla szerkezet: `wp0z_woocommerce_payment_tokenmeta`
1177--
1178
1179CREATE TABLE IF NOT EXISTS `wp0z_woocommerce_payment_tokenmeta` (
1180 `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1181 `payment_token_id` bigint(20) unsigned NOT NULL,
1182 `meta_key` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
1183 `meta_value` longtext COLLATE utf8mb4_unicode_520_ci,
1184 PRIMARY KEY (`meta_id`),
1185 KEY `payment_token_id` (`payment_token_id`),
1186 KEY `meta_key` (`meta_key`(32))
1187) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci AUTO_INCREMENT=1 ;
1188
1189-- --------------------------------------------------------
1190
1191--
1192-- Tábla szerkezet: `wp0z_woocommerce_payment_tokens`
1193--
1194
1195CREATE TABLE IF NOT EXISTS `wp0z_woocommerce_payment_tokens` (
1196 `token_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1197 `gateway_id` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
1198 `token` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
1199 `user_id` bigint(20) unsigned NOT NULL DEFAULT '0',
1200 `type` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
1201 `is_default` tinyint(1) NOT NULL DEFAULT '0',
1202 PRIMARY KEY (`token_id`),
1203 KEY `user_id` (`user_id`)
1204) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci AUTO_INCREMENT=1 ;
1205
1206-- --------------------------------------------------------
1207
1208--
1209-- Tábla szerkezet: `wp0z_woocommerce_sessions`
1210--
1211
1212CREATE TABLE IF NOT EXISTS `wp0z_woocommerce_sessions` (
1213 `session_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1214 `session_key` char(32) COLLATE utf8mb4_unicode_520_ci NOT NULL,
1215 `session_value` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
1216 `session_expiry` bigint(20) unsigned NOT NULL,
1217 PRIMARY KEY (`session_id`),
1218 UNIQUE KEY `session_key` (`session_key`)
1219) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci AUTO_INCREMENT=1 ;
1220
1221-- --------------------------------------------------------
1222
1223--
1224-- Tábla szerkezet: `wp0z_woocommerce_shipping_zones`
1225--
1226
1227CREATE TABLE IF NOT EXISTS `wp0z_woocommerce_shipping_zones` (
1228 `zone_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1229 `zone_name` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
1230 `zone_order` bigint(20) unsigned NOT NULL,
1231 PRIMARY KEY (`zone_id`)
1232) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci AUTO_INCREMENT=1 ;
1233
1234-- --------------------------------------------------------
1235
1236--
1237-- Tábla szerkezet: `wp0z_woocommerce_shipping_zone_locations`
1238--
1239
1240CREATE TABLE IF NOT EXISTS `wp0z_woocommerce_shipping_zone_locations` (
1241 `location_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1242 `zone_id` bigint(20) unsigned NOT NULL,
1243 `location_code` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
1244 `location_type` varchar(40) COLLATE utf8mb4_unicode_520_ci NOT NULL,
1245 PRIMARY KEY (`location_id`),
1246 KEY `location_id` (`location_id`),
1247 KEY `location_type_code` (`location_type`(10),`location_code`(20))
1248) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci AUTO_INCREMENT=1 ;
1249
1250-- --------------------------------------------------------
1251
1252--
1253-- Tábla szerkezet: `wp0z_woocommerce_shipping_zone_methods`
1254--
1255
1256CREATE TABLE IF NOT EXISTS `wp0z_woocommerce_shipping_zone_methods` (
1257 `zone_id` bigint(20) unsigned NOT NULL,
1258 `instance_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1259 `method_id` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
1260 `method_order` bigint(20) unsigned NOT NULL,
1261 `is_enabled` tinyint(1) NOT NULL DEFAULT '1',
1262 PRIMARY KEY (`instance_id`)
1263) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci AUTO_INCREMENT=3 ;
1264
1265-- --------------------------------------------------------
1266
1267--
1268-- Tábla szerkezet: `wp0z_woocommerce_tax_rates`
1269--
1270
1271CREATE TABLE IF NOT EXISTS `wp0z_woocommerce_tax_rates` (
1272 `tax_rate_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1273 `tax_rate_country` varchar(2) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
1274 `tax_rate_state` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
1275 `tax_rate` varchar(8) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
1276 `tax_rate_name` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
1277 `tax_rate_priority` bigint(20) unsigned NOT NULL,
1278 `tax_rate_compound` int(1) NOT NULL DEFAULT '0',
1279 `tax_rate_shipping` int(1) NOT NULL DEFAULT '1',
1280 `tax_rate_order` bigint(20) unsigned NOT NULL,
1281 `tax_rate_class` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
1282 PRIMARY KEY (`tax_rate_id`),
1283 KEY `tax_rate_country` (`tax_rate_country`),
1284 KEY `tax_rate_state` (`tax_rate_state`(2)),
1285 KEY `tax_rate_class` (`tax_rate_class`(10)),
1286 KEY `tax_rate_priority` (`tax_rate_priority`)
1287) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci AUTO_INCREMENT=1 ;
1288
1289-- --------------------------------------------------------
1290
1291--
1292-- Tábla szerkezet: `wp0z_woocommerce_tax_rate_locations`
1293--
1294
1295CREATE TABLE IF NOT EXISTS `wp0z_woocommerce_tax_rate_locations` (
1296 `location_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1297 `location_code` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
1298 `tax_rate_id` bigint(20) unsigned NOT NULL,
1299 `location_type` varchar(40) COLLATE utf8mb4_unicode_520_ci NOT NULL,
1300 PRIMARY KEY (`location_id`),
1301 KEY `tax_rate_id` (`tax_rate_id`),
1302 KEY `location_type_code` (`location_type`(10),`location_code`(20))
1303) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci AUTO_INCREMENT=1 ;
1304
1305-- --------------------------------------------------------
1306
1307--
1308-- Tábla szerkezet: `wp0z_yoast_indexable`
1309--
1310
1311CREATE TABLE IF NOT EXISTS `wp0z_yoast_indexable` (
1312 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
1313 `permalink` longtext COLLATE utf8mb4_unicode_ci,
1314 `permalink_hash` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1315 `object_id` int(11) unsigned DEFAULT NULL,
1316 `object_type` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
1317 `object_sub_type` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1318 `author_id` int(11) unsigned DEFAULT NULL,
1319 `post_parent` int(11) unsigned DEFAULT NULL,
1320 `title` text COLLATE utf8mb4_unicode_ci,
1321 `description` mediumtext COLLATE utf8mb4_unicode_ci,
1322 `breadcrumb_title` text COLLATE utf8mb4_unicode_ci,
1323 `post_status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1324 `is_public` tinyint(1) DEFAULT NULL,
1325 `is_protected` tinyint(1) DEFAULT '0',
1326 `has_public_posts` tinyint(1) DEFAULT NULL,
1327 `number_of_pages` int(11) unsigned DEFAULT NULL,
1328 `canonical` longtext COLLATE utf8mb4_unicode_ci,
1329 `primary_focus_keyword` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1330 `primary_focus_keyword_score` int(3) DEFAULT NULL,
1331 `readability_score` int(3) DEFAULT NULL,
1332 `is_cornerstone` tinyint(1) DEFAULT '0',
1333 `is_robots_noindex` tinyint(1) DEFAULT '0',
1334 `is_robots_nofollow` tinyint(1) DEFAULT '0',
1335 `is_robots_noarchive` tinyint(1) DEFAULT '0',
1336 `is_robots_noimageindex` tinyint(1) DEFAULT '0',
1337 `is_robots_nosnippet` tinyint(1) DEFAULT '0',
1338 `twitter_title` text COLLATE utf8mb4_unicode_ci,
1339 `twitter_image` longtext COLLATE utf8mb4_unicode_ci,
1340 `twitter_description` longtext COLLATE utf8mb4_unicode_ci,
1341 `twitter_image_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1342 `twitter_image_source` text COLLATE utf8mb4_unicode_ci,
1343 `open_graph_title` text COLLATE utf8mb4_unicode_ci,
1344 `open_graph_description` longtext COLLATE utf8mb4_unicode_ci,
1345 `open_graph_image` longtext COLLATE utf8mb4_unicode_ci,
1346 `open_graph_image_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1347 `open_graph_image_source` text COLLATE utf8mb4_unicode_ci,
1348 `open_graph_image_meta` mediumtext COLLATE utf8mb4_unicode_ci,
1349 `link_count` int(11) DEFAULT NULL,
1350 `incoming_link_count` int(11) DEFAULT NULL,
1351 `prominent_words_version` int(11) unsigned DEFAULT NULL,
1352 `created_at` datetime DEFAULT NULL,
1353 `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1354 `blog_id` bigint(20) NOT NULL DEFAULT '1',
1355 `language` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1356 `region` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1357 `schema_page_type` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1358 `schema_article_type` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1359 PRIMARY KEY (`id`),
1360 KEY `object_type_and_sub_type` (`object_type`,`object_sub_type`),
1361 KEY `permalink_hash` (`permalink_hash`),
1362 KEY `object_id_and_type` (`object_id`,`object_type`)
1363) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
1364
1365-- --------------------------------------------------------
1366
1367--
1368-- Tábla szerkezet: `wp0z_yoast_indexable_hierarchy`
1369--
1370
1371CREATE TABLE IF NOT EXISTS `wp0z_yoast_indexable_hierarchy` (
1372 `indexable_id` int(11) unsigned NOT NULL DEFAULT '0',
1373 `ancestor_id` int(11) unsigned NOT NULL DEFAULT '0',
1374 `depth` int(11) unsigned DEFAULT NULL,
1375 `blog_id` bigint(20) NOT NULL DEFAULT '1',
1376 PRIMARY KEY (`indexable_id`,`ancestor_id`),
1377 KEY `indexable_id` (`indexable_id`),
1378 KEY `ancestor_id` (`ancestor_id`),
1379 KEY `depth` (`depth`)
1380) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1381
1382-- --------------------------------------------------------
1383
1384--
1385-- Tábla szerkezet: `wp0z_yoast_migrations`
1386--
1387
1388CREATE TABLE IF NOT EXISTS `wp0z_yoast_migrations` (
1389 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
1390 `version` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1391 PRIMARY KEY (`id`),
1392 UNIQUE KEY `idx_wp0z_yoast_migrations_version` (`version`)
1393) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
1394
1395-- --------------------------------------------------------
1396
1397--
1398-- Tábla szerkezet: `wp0z_yoast_primary_term`
1399--
1400
1401CREATE TABLE IF NOT EXISTS `wp0z_yoast_primary_term` (
1402 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
1403 `post_id` int(11) unsigned NOT NULL,
1404 `term_id` int(11) unsigned NOT NULL,
1405 `taxonomy` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
1406 `created_at` datetime DEFAULT NULL,
1407 `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1408 `blog_id` bigint(20) NOT NULL DEFAULT '1',
1409 PRIMARY KEY (`id`),
1410 KEY `post_taxonomy` (`post_id`,`taxonomy`),
1411 KEY `post_term` (`post_id`,`term_id`)
1412) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
1413
1414-- --------------------------------------------------------
1415
1416--
1417-- Tábla szerkezet: `wp0z_yoast_seo_links`
1418--
1419
1420CREATE TABLE IF NOT EXISTS `wp0z_yoast_seo_links` (
1421 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1422 `url` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
1423 `post_id` bigint(20) unsigned NOT NULL,
1424 `target_post_id` bigint(20) unsigned NOT NULL,
1425 `type` varchar(8) COLLATE utf8mb4_unicode_520_ci NOT NULL,
1426 PRIMARY KEY (`id`),
1427 KEY `link_direction` (`post_id`,`type`)
1428) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci AUTO_INCREMENT=1 ;
1429
1430-- --------------------------------------------------------
1431
1432--
1433-- Tábla szerkezet: `wp0z_yoast_seo_meta`
1434--
1435
1436CREATE TABLE IF NOT EXISTS `wp0z_yoast_seo_meta` (
1437 `object_id` bigint(20) unsigned NOT NULL,
1438 `internal_link_count` int(10) unsigned DEFAULT NULL,
1439 `incoming_link_count` int(10) unsigned DEFAULT NULL,
1440 UNIQUE KEY `object_id` (`object_id`)
1441) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;