ALTER TABLE `PostBlockDiff` ADD INDEX postblockdiff_index_1 (LocalId);
ALTER TABLE `PostBlockDiff` ADD INDEX postblockdiff_index_2 (PredLocalId);

ALTER TABLE `PostBlockVersion` ADD INDEX postblockversion_index_1 (LocalId);
ALTER TABLE `PostBlockVersion` ADD INDEX postblockversion_index_2 (PredLocalId);
ALTER TABLE `PostBlockVersion` ADD INDEX postblockversion_index_3 (RootLocalId);
ALTER TABLE `PostBlockVersion` ADD INDEX postblockversion_index_4 (PredSimilarity);
ALTER TABLE `PostBlockVersion` ADD INDEX postblockversion_index_5 (PredCount);
ALTER TABLE `PostBlockVersion` ADD INDEX postblockversion_index_6 (SuccCount);
ALTER TABLE `PostBlockVersion` ADD INDEX postblockversion_index_7 (Length);
ALTER TABLE `PostBlockVersion` ADD INDEX postblockversion_index_8 (LineCount);

ALTER TABLE `CommentUrl` ADD INDEX commenturl_index_1 (PostId);

ALTER TABLE `PostReferenceGH` ADD INDEX postreferencegh_index_1 (FileId);
ALTER TABLE `PostReferenceGH` ADD INDEX postreferencegh_index_2 (Repo);
ALTER TABLE `PostReferenceGH` ADD INDEX postreferencegh_index_3 (RepoOwner);
ALTER TABLE `PostReferenceGH` ADD INDEX postreferencegh_index_4 (RepoName);
ALTER TABLE `PostReferenceGH` ADD INDEX postreferencegh_index_5 (Branch);
ALTER TABLE `PostReferenceGH` ADD INDEX postreferencegh_index_6 (FileExt);
ALTER TABLE `PostReferenceGH` ADD INDEX postreferencegh_index_7 (Size);
ALTER TABLE `PostReferenceGH` ADD INDEX postreferencegh_index_8 (Copies);

ALTER TABLE `TitleVersion` ADD INDEX titleversion_index_1 (PredEditDistance);
ALTER TABLE `TitleVersion` ADD INDEX titleversion_index_2 (SuccEditDistance);

ALTER TABLE `GHMatches` ADD INDEX ghmatches_index_1 (FileId);

ALTER TABLE `GHCommits` ADD INDEX ghcommits_index_1 (CommitId);
ALTER TABLE `GHCommits` ADD INDEX ghcommits_index_2 (Repo);
ALTER TABLE `GHCommits` ADD INDEX ghcommits_index_3 (RepoOwner);
ALTER TABLE `GHCommits` ADD INDEX ghcommits_index_4 (RepoName);