migrations.rb

remove_index aspect_visibilities, shareable_and_aspect_id
add_index aspect_visibilities, ["shareable_id", "shareable_type", "aspect_id"], name: shareable_and_aspect_id, length: {"shareable_type"=>189}, using: :btree

remove_index aspect_visibilities, index_aspect_visibilities_on_shareable_id_and_shareable_type
add_index aspect_visibilities, ["shareable_id", "shareable_type"], name: index_aspect_visibilities_on_shareable_id_and_shareable_type, length: {"shareable_type"=>190}, using: :btree

remove_index chat_contacts, index_chat_contacts_on_user_id_and_jid
add_index chat_contacts, ["user_id", "jid"], name: index_chat_contacts_on_user_id_and_jid, length: {"jid"=>190}, using: :btree

remove_index comments, index_comments_on_guid
add_index comments, ["guid"], name: index_comments_on_guid, length: {"guid"=>191}, using: :btree

remove_index comments, index_comments_on_commentable_id_and_commentable_type
add_index comments, ["commentable_id", "commentable_type"], name: index_comments_on_commentable_id_and_commentable_type, length: {"commentable_type"=>190}, using: :btree

remove_index likes, index_likes_on_guid
add_index likes, ["guid"], name: index_likes_on_guid, length: {"guid"=>191}, using: :btree

remove_index likes, index_likes_on_target_id_and_author_id_and_target_type
add_index likes, ["target_id", "author_id", "target_type"], name: index_likes_on_target_id_and_author_id_and_target_type, length: {"target_type"=>189}, using: :btree

remove_index notifications, index_notifications_on_target_type_and_target_id
add_index notifications, ["target_type", "target_id"], name: index_notifications_on_target_type_and_target_id, length: {"target_type"=>190}, using: :btree

remove_index o_embed_caches, index_o_embed_caches_on_url
add_index o_embed_caches, ["url"], name: index_o_embed_caches_on_url, length: {"url"=>191}, using: :btree

remove_index participations, index_participations_on_guid
add_index participations, ["guid"], name: index_participations_on_guid, length: {"guid"=>191}, using: :btree

remove_index participations, index_participations_on_target_id_and_target_type_and_author_id
add_index participations, ["target_id", "target_type", "author_id"], name: index_participations_on_target_id_and_target_type_and_author_id, length: {"target_type"=>189}, using: :btree

remove_index people, index_people_on_diaspora_handle
add_index people, ["diaspora_handle"], name: index_people_on_diaspora_handle, length: {"diaspora_handle"=>191}, using: :btree

remove_index people, index_people_on_guid
add_index people, ["guid"], name: index_people_on_guid, length: {"guid"=>191}, using: :btree

remove_index photos, index_photos_on_status_message_guid
add_index photos, ["status_message_guid"], name: index_photos_on_status_message_guid, length: {"status_message_guid"=>191}, using: :btree

remove_index posts, index_posts_on_guid
add_index posts, ["guid"], name: index_posts_on_guid, length: {"guid"=>191}, using: :btree

remove_index posts, index_posts_on_author_id_and_root_guid
add_index posts, ["author_id", "root_guid"], name: index_posts_on_author_id_and_root_guid, length: {"root_guid"=>190}, using: :btree

remove_index posts, index_posts_on_id_and_type_and_created_at
add_index posts, ["id", "type", "created_at"], name: index_posts_on_id_and_type_and_created_at, length: {"type"=>189}, using: :btree

remove_index posts, index_posts_on_root_guid
add_index posts, ["root_guid"], name: index_posts_on_root_guid, length: {"root_guid"=>191}, using: :btree

remove_index posts, index_posts_on_status_message_guid_and_pending
add_index posts, ["status_message_guid", "pending"], name: index_posts_on_status_message_guid_and_pending, length: {"status_message_guid"=>190}, using: :btree

remove_index posts, index_posts_on_status_message_guid
add_index posts, ["status_message_guid"], name: index_posts_on_status_message_guid, length: {"status_message_guid"=>191}, using: :btree

remove_index posts, index_posts_on_type_and_pending_and_id
add_index posts, ["type", "pending", "id"], name: index_posts_on_type_and_pending_and_id, length: {"type"=>189}, using: :btree

remove_index posts, index_posts_on_tweet_id
add_index posts, ["tweet_id"], name: index_posts_on_tweet_id, length: {"tweet_id"=>191}, using: :btree

remove_index profiles, index_profiles_on_full_name_and_searchable
add_index profiles, ["full_name", "searchable"], name: index_profiles_on_full_name_and_searchable, length: {"full_name"=>190}, using: :btree

remove_index profiles, index_profiles_on_full_name
add_index profiles, ["full_name"], name: index_profiles_on_full_name, length: {"full_name"=>191}, using: :btree

remove_index rails_admin_histories, index_rails_admin_histories
add_index rails_admin_histories, ["item", "table", "month", "year"], name: index_rails_admin_histories, length: {"table"=>188}, using: :btree

remove_index schema_migrations, unique_schema_migrations
add_index schema_migrations, ["version"], name: unique_schema_migrations, length: {"version"=>191}, using: :btree

remove_index services, index_services_on_type_and_uid
add_index services, ["type", "uid"], name: index_services_on_type_and_uid, length: {"type"=>95, "uid"=>95}, using: :btree

remove_index share_visibilities, shareable_and_contact_id
add_index share_visibilities, ["shareable_id", "shareable_type", "contact_id"], name: shareable_and_contact_id, length: {"shareable_type"=>189}, using: :btree

remove_index share_visibilities, shareable_and_hidden_and_contact_id
add_index share_visibilities, ["shareable_id", "shareable_type", "hidden", "contact_id"], name: shareable_and_hidden_and_contact_id, length: {"shareable_type"=>188}, using: :btree

remove_index simple_captcha_data, idx_key
add_index simple_captcha_data, ["key"], name: idx_key, length: {"key"=>191}, using: :btree

remove_index taggings, index_taggings_uniquely
add_index taggings, ["taggable_id", "taggable_type", "tag_id"], name: index_taggings_uniquely, length: {"taggable_type"=>189}, using: :btree

remove_index taggings, index_taggings_on_taggable_id_and_taggable_type_and_context
add_index taggings, ["taggable_id", "taggable_type", "context"], name: index_taggings_on_taggable_id_and_taggable_type_and_context, length: {"taggable_type"=>95, "context"=>95}, using: :btree

remove_index tags, index_tags_on_name
add_index tags, ["name"], name: index_tags_on_name, length: {"name"=>191}, using: :btree

remove_index users, index_users_on_authentication_token
add_index users, ["authentication_token"], name: index_users_on_authentication_token, length: {"authentication_token"=>191}, using: :btree

remove_index users, index_users_on_invitation_service_and_invitation_identifier
add_index users, ["invitation_service", "invitation_identifier"], name: index_users_on_invitation_service_and_invitation_identifier, length: {"invitation_service"=>95, "invitation_identifier"=>95}, using: :btree

remove_index users, index_users_on_username
add_index users, ["username"], name: index_users_on_username, length: {"username"=>191}, using: :btree

remove_index users, index_users_on_email
add_index users, ["email"], name: index_users_on_email, length: {"email"=>191}, using: :btree

remove_index users, index_users_on_invitation_token
add_index users, ["invitation_token"], name: index_users_on_invitation_token, length: {"invitation_token"=>191}, using: :btree