Skip to content

Instantly share code, notes, and snippets.

@atimmer

atimmer/create-yoast-seo-5.0-tables.sql

Last active October 16, 2020 09:31
Show Gist options
  • Save atimmer/892eb075a9025c9cf4be0dde895b231c to your computer and use it in GitHub Desktop.
Save atimmer/892eb075a9025c9cf4be0dde895b231c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
create-yoast-seo-5.0-tables.sql
CREATE TABLE `wp_yoast_seo_links` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`post_id` bigint(20) unsigned NOT NULL,
`target_post_id` bigint(20) unsigned NOT NULL,
`type` varchar(8) COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `link_direction` (`post_id`,`type`)
) DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `wp_yoast_seo_meta` (
`object_id` bigint(20) unsigned NOT NULL,
`internal_link_count` int(10) unsigned NOT NULL DEFAULT '0',
`incoming_link_count` int(10) unsigned DEFAULT NULL,
UNIQUE KEY `object_id` (`object_id`)
) DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@jovanmili91
Copy link

Ok, i just follow ghost comment. Thanks ! Its working now

@okeyravi
Copy link

okeyravi commented Mar 1, 2019

Hi, I have mentioned it Yoast SEO table creation step by step on my website. It will help you guys to create Yoast seo tables in database properly. Thanks GitHub for this wonderful article.

@normanlolx
Copy link

normanlolx commented May 29, 2019 •
edited
Loading

WP-CLI

This can simply be done with WP-CLI:

$ wp db query < create-yoast-seo-5.0-tables.sql

@sae1kodok
Copy link

sae1kodok commented Oct 16, 2020 •
edited
Loading

hi okeyravi
I have tried your code but an error occurs, can you help. Oh, I want to create a wp_yoast_seo_meta table on my site, https://saelekko.com/
i am using yoast seo Version 15.1.1

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment