Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
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;
@ghost

This comment has been minimized.

Copy link

ghost commented Jul 15, 2018

@yogeshbaghel You should enter these lines to SQL section in your phpMyadmin into the related database

@ghost

This comment has been minimized.

Copy link

ghost commented Jul 15, 2018

Worked fine for me. Thanks

@jovanmili91

This comment has been minimized.

Copy link

jovanmili91 commented Feb 22, 2019

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

@jovanmili91

This comment has been minimized.

Copy link

jovanmili91 commented Feb 22, 2019

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

@okeyravi

This comment has been minimized.

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.