Script by https://wpindexfixer.tools.managedwphosting.nl

These are the queries for WP version 5.2.4

You need to replace 5dade14c5de79_ with your site prefix. This could be wp_ or something else. @see https://codex.wordpress.org/Editing_wp-config.php#table_prefix where to find your own prefix.

-- Starting with 5dade14c5de79_users
DELETE FROM 5dade14c5de79_users WHERE ID = 0;
ALTER TABLE 5dade14c5de79_users ADD PRIMARY KEY  (ID);
ALTER TABLE 5dade14c5de79_users ADD KEY user_login_key (user_login);
ALTER TABLE 5dade14c5de79_users ADD KEY user_nicename (user_nicename);
ALTER TABLE 5dade14c5de79_users ADD KEY user_email (user_email);
ALTER TABLE 5dade14c5de79_users MODIFY ID bigint(20) unsigned NOT NULL auto_increment;
-- Starting with 5dade14c5de79_usermeta
DELETE FROM 5dade14c5de79_usermeta WHERE umeta_id = 0;
ALTER TABLE 5dade14c5de79_usermeta ADD PRIMARY KEY  (umeta_id);
ALTER TABLE 5dade14c5de79_usermeta ADD KEY user_id (user_id);
ALTER TABLE 5dade14c5de79_usermeta ADD KEY meta_key (meta_key(191));
ALTER TABLE 5dade14c5de79_usermeta MODIFY umeta_id bigint(20) unsigned NOT NULL auto_increment;
-- Starting with 5dade14c5de79_posts
DELETE FROM 5dade14c5de79_posts WHERE ID = 0;
ALTER TABLE 5dade14c5de79_posts ADD PRIMARY KEY  (ID);
ALTER TABLE 5dade14c5de79_posts ADD KEY post_name (post_name(191));
ALTER TABLE 5dade14c5de79_posts ADD KEY type_status_date (post_type,post_status,post_date,ID);
ALTER TABLE 5dade14c5de79_posts ADD KEY post_parent (post_parent);
ALTER TABLE 5dade14c5de79_posts ADD KEY post_author (post_author);
ALTER TABLE 5dade14c5de79_posts MODIFY ID bigint(20) unsigned NOT NULL auto_increment;
-- Starting with 5dade14c5de79_comments
DELETE FROM 5dade14c5de79_comments WHERE comment_ID = 0;
ALTER TABLE 5dade14c5de79_comments ADD PRIMARY KEY  (comment_ID);
ALTER TABLE 5dade14c5de79_comments ADD KEY comment_post_ID (comment_post_ID);
ALTER TABLE 5dade14c5de79_comments ADD KEY comment_approved_date_gmt (comment_approved,comment_date_gmt);
ALTER TABLE 5dade14c5de79_comments ADD KEY comment_date_gmt (comment_date_gmt);
ALTER TABLE 5dade14c5de79_comments ADD KEY comment_parent (comment_parent);
ALTER TABLE 5dade14c5de79_comments ADD KEY comment_author_email (comment_author_email(10));
ALTER TABLE 5dade14c5de79_comments MODIFY comment_ID bigint(20) unsigned NOT NULL auto_increment;
-- Starting with 5dade14c5de79_links
DELETE FROM 5dade14c5de79_links WHERE link_id = 0;
ALTER TABLE 5dade14c5de79_links ADD PRIMARY KEY  (link_id);
ALTER TABLE 5dade14c5de79_links ADD KEY link_visible (link_visible);
ALTER TABLE 5dade14c5de79_links MODIFY link_id bigint(20) unsigned NOT NULL auto_increment;
-- Starting with 5dade14c5de79_options
DELETE FROM 5dade14c5de79_options WHERE option_id = 0;
ALTER TABLE 5dade14c5de79_options ADD PRIMARY KEY  (option_id);
ALTER TABLE 5dade14c5de79_options ADD UNIQUE KEY option_name (option_name);
ALTER TABLE 5dade14c5de79_options MODIFY option_id bigint(20) unsigned NOT NULL auto_increment;
-- Starting with 5dade14c5de79_postmeta
DELETE FROM 5dade14c5de79_postmeta WHERE meta_id = 0;
ALTER TABLE 5dade14c5de79_postmeta ADD PRIMARY KEY  (meta_id);
ALTER TABLE 5dade14c5de79_postmeta ADD KEY post_id (post_id);
ALTER TABLE 5dade14c5de79_postmeta ADD KEY meta_key (meta_key(191));
ALTER TABLE 5dade14c5de79_postmeta MODIFY meta_id bigint(20) unsigned NOT NULL auto_increment;
-- Starting with 5dade14c5de79_terms
DELETE FROM 5dade14c5de79_terms WHERE term_id = 0;
ALTER TABLE 5dade14c5de79_terms ADD PRIMARY KEY  (term_id);
ALTER TABLE 5dade14c5de79_terms ADD KEY slug (slug(191));
ALTER TABLE 5dade14c5de79_terms ADD KEY name (name(191));
ALTER TABLE 5dade14c5de79_terms MODIFY term_id bigint(20) unsigned NOT NULL auto_increment;
-- Starting with 5dade14c5de79_term_taxonomy
DELETE FROM 5dade14c5de79_term_taxonomy WHERE term_taxonomy_id = 0;
ALTER TABLE 5dade14c5de79_term_taxonomy ADD PRIMARY KEY  (term_taxonomy_id);
ALTER TABLE 5dade14c5de79_term_taxonomy ADD UNIQUE KEY term_id_taxonomy (term_id,taxonomy);
ALTER TABLE 5dade14c5de79_term_taxonomy ADD KEY taxonomy (taxonomy);
ALTER TABLE 5dade14c5de79_term_taxonomy MODIFY term_taxonomy_id bigint(20) unsigned NOT NULL auto_increment;
-- Starting with 5dade14c5de79_term_relationships
DELETE FROM 5dade14c5de79_term_relationships WHERE object_id = 0;
DELETE FROM 5dade14c5de79_term_relationships WHERE term_taxonomy_id = 0;
ALTER TABLE 5dade14c5de79_term_relationships ADD PRIMARY KEY  (object_id,term_taxonomy_id);
ALTER TABLE 5dade14c5de79_term_relationships ADD KEY term_taxonomy_id (term_taxonomy_id);
-- Starting with 5dade14c5de79_termmeta
DELETE FROM 5dade14c5de79_termmeta WHERE meta_id = 0;
ALTER TABLE 5dade14c5de79_termmeta ADD PRIMARY KEY  (meta_id);
ALTER TABLE 5dade14c5de79_termmeta ADD KEY term_id (term_id);
ALTER TABLE 5dade14c5de79_termmeta ADD KEY meta_key (meta_key(191));
ALTER TABLE 5dade14c5de79_termmeta MODIFY meta_id bigint(20) unsigned NOT NULL auto_increment;
-- Starting with 5dade14c5de79_commentmeta
DELETE FROM 5dade14c5de79_commentmeta WHERE meta_id = 0;
ALTER TABLE 5dade14c5de79_commentmeta ADD PRIMARY KEY  (meta_id);
ALTER TABLE 5dade14c5de79_commentmeta ADD KEY comment_id (comment_id);
ALTER TABLE 5dade14c5de79_commentmeta ADD KEY meta_key (meta_key(191));
ALTER TABLE 5dade14c5de79_commentmeta MODIFY meta_id bigint(20) unsigned NOT NULL auto_increment;


Script by https://wpindexfixer.tools.managedwphosting.nl