Skip to content

Instantly share code, notes, and snippets.

@atimmer
Last active October 16, 2020 09:31
Show Gist options
  • Star 2 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save atimmer/892eb075a9025c9cf4be0dde895b231c to your computer and use it in GitHub Desktop.
Save atimmer/892eb075a9025c9cf4be0dde895b231c to your computer and use it in GitHub Desktop.
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;
@sae1kodok
Copy link

sae1kodok commented Oct 16, 2020

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