gistfile1.txt

    add_index :carts, [:id, :deleted_at]
    add_index :carts, [:token, :deleted_at]
    add_index :carts, [:coupon_id, :deleted_at]
    add_index :line_items, [:id, :deleted_at]
    add_index :line_items, [:quantity, :deleted_at]
    add_index :websites, [:id, :deleted_at]
    add_index :websites, [:subdomain, :deleted_at]
    add_index :websites, [:stripe_customer_id, :deleted_at]
    add_index :products, [:id, :deleted_at]
    add_index :products, [:slug, :deleted_at]
    add_index :products, [:product_type, :deleted_at]
    add_index :products, [:productable_type, :deleted_at]
    add_index :products, [:category_id, :deleted_at]
    add_index :products, [:is_visitor_upload, :deleted_at]
    add_index :products, [:archived_at, :deleted_at]
    add_index :products, [:uploaded_by, :deleted_at]
    add_index :products, [:updated_at, :deleted_at]
    add_index :pages, [:id, :deleted_at]
    add_index :pages, [:slug, :deleted_at]
    add_index :pages, [:pageable_type, :deleted_at]
    add_index :pages, [:online_status, :deleted_at]
    add_index :categories, [:slug, :deleted_at]
    add_index :categories, [:id, :deleted_at]
    add_index :categories, [:visible_in_product_galleries, :deleted_at]
    add_index :users, [:id, :deleted_at]
    add_index :users, [:auth_token, :deleted_at]
    add_index :users, [:email, :deleted_at]
    add_index :users, [:email, :website_id, :deleted_at]
    add_index :users, [:id, :guest, :deleted_at]
    add_index :users, [:guest, :deleted_at]
    add_index :users, [:auth_token, :guest, :deleted_at]
    add_index :contacts, [:id, :deleted_at]
    add_index :stores, [:id, :deleted_at]
    add_index :art_print_stores, [:id, :deleted_at]
    add_index :art_upload_stores, [:id, :deleted_at]
    add_index :art_print_products, [:id, :deleted_at]
    add_index :media, [:id, :deleted_at]
    add_index :media, [:manufacturer_id, :deleted_at]
    add_index :frames, [:id, :deleted_at]
    add_index :frames, [:manufacturer_id, :deleted_at]
    add_index :style_finishes, [:id, :deleted_at]
    add_index :print_options, [:id, :deleted_at]
    add_index :medium_availabilities, [:medium_id, :product_id]
    #add_index :medium_availabilities, [:medium_id, :store_id, :product_id]
    add_index :medium_availabilities, [:store_id, :product_id]
    #add_index :frame_availabilities, [:medium_id, :store_id, :product_id]
    add_index :product_favorites, [:id, :deleted_at]
    add_index :product_favorites, [:product_id, :deleted_at]
    add_index :favorite_lists, [:id, :deleted_at]
    add_index :favorite_lists, [:default, :deleted_at]
    add_index :templates, [:id, :deleted_at]
    add_index :templates, [:admin, :deleted_at]
    add_index :orders, [:website_id, :order_status, :deleted_at]
    add_index :orders, [:id, :deleted_at]
    add_index :orders, [:website_id, :deleted_at]
    add_index :body_sections, [:id, :deleted_at]
    #add_index :body_sections, [:body_sectionable_id, :body_sectionable_type, :deleted_at]
    #add_index :body_sections, [:location, :body_section_type, :deleted_at]
    add_index :form_fields, [:id, :deleted_at]
    add_index :form_fields, [:required, :deleted_at]
    add_index :memberships, [:auth_level]
    add_index :photos, [:album_id]