ALTER TABLE posts ADD KEY index_posts_on_category_id(category_id), ADD UNIQUE KEY index_posts_on_url(url), DROP KEY new_index_posts_on_category_id, DROP KEY new_index_posts_on_url, ADD CONSTRAINT posts_blog_id_fk FOREIGN KEY(blog_id) REFERENCES blogs, DROP FOREIGN KEY new_posts_blog_id_fk;