class ResetBySchema < ActiveRecord::Migration
  def change
    create_table "collectionships", force: true do |t|
      t.integer  "user_id"
      t.integer  "product_id"
      t.datetime "created_at"
      t.datetime "updated_at"
    end

    add_index "collectionships", ["user_id", "product_id"], name: "index_collectionships_on_user_id_and_product_id", unique: true, using: :btree

    create_table "evaluates", force: true do |t|
      t.string   "title"
      t.text     "details"
      t.integer  "product_id"
      t.integer  "user_id"
      t.datetime "created_at"
      t.datetime "updated_at"
      t.integer  "messages_count", default: 0
    end

    create_table "likeships", force: true do |t|
      t.integer  "user_id"
      t.integer  "likeable_id"
      t.string   "likeable_type"
      t.datetime "created_at"
      t.datetime "updated_at"
    end

    add_index "likeships", ["user_id", "likeable_id", "likeable_type"], name: "index_likeships_on_user_id_and_likeable_id_and_likeable_type", unique: true, using: :btree

    create_table "messages", force: true do |t|
      t.text     "content"
      t.datetime "created_at"
      t.datetime "updated_at"
      t.integer  "user_id"
      t.string   "messageable_type"
      t.integer  "messageable_id"
    end

    add_index "messages", ["created_at"], name: "index_messages_on_product_id_and_created_at", using: :btree

    create_table "notifications", force: true do |t|
      t.integer  "user_id"
      t.integer  "message_id"
      t.boolean  "read",       default: false
      t.datetime "created_at"
      t.datetime "updated_at"
    end

    add_index "notifications", ["message_id"], name: "index_notifications_on_message_id", using: :btree
    add_index "notifications", ["user_id"], name: "index_notifications_on_user_id", using: :btree

    create_table "product_categories", force: true do |t|
      t.string   "name"
      t.datetime "created_at"
      t.datetime "updated_at"
    end

    add_index "product_categories", ["name"], name: "index_product_categories_on_name", unique: true, using: :btree

    create_table "product_pictures", force: true do |t|
      t.string   "picture"
      t.string   "picture_content_type"
      t.integer  "picture_file_size"
      t.integer  "product_id"
      t.datetime "created_at"
      t.datetime "updated_at"
    end

    add_index "product_pictures", ["product_id"], name: "index_product_pictures_on_product_id", using: :btree

    create_table "products", force: true do |t|
      t.string   "name"
      t.string   "description"
      t.text     "details"
      t.decimal  "price",               precision: 8, scale: 2
      t.datetime "created_at"
      t.datetime "updated_at"
      t.integer  "product_category_id"
      t.integer  "cover_id"
      t.datetime "published_at"
      t.string   "buy_link"
      t.integer  "messages_count",                              default: 0
      t.integer  "evaluates_count",                             default: 0
    end

    create_table "user_pictures", force: true do |t|
      t.string   "picture"
      t.string   "picture_content_type"
      t.integer  "picture_file_size"
      t.integer  "user_id"
      t.datetime "created_at"
      t.datetime "updated_at"
    end

    create_table "users", force: true do |t|
      t.string   "email"
      t.string   "password_digest"
      t.string   "name"
      t.datetime "created_at"
      t.datetime "updated_at"
      t.integer  "roles_mask"
      t.integer  "cover_id"
      t.string   "description"
    end

    add_index "users", ["email"], name: "index_users_on_email", unique: true, using: :btree
  end
end
