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;

Can you help me a little more precisely? Where do I need to add ? Im new

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

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.

WP-CLI

This can simply be done with WP-CLI:

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

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