# This file is autogenerated. Instead of editing this file, please use the
# migrations feature of ActiveRecord to incrementally modify your database, and
# then regenerate this schema definition.

ActiveRecord::Schema.define(:version => 1) do

  create_table "accounts", :force => true do |t|
    t.column "username",             :string
    t.column "password",             :string
    t.column "email",                :string
    t.column "first_name",           :string
    t.column "last_name",            :string
    t.column "status",               :string
    t.column "address_line_1",       :string
    t.column "address_line_2",       :string
    t.column "city",                 :string
    t.column "state",                :string
    t.column "zip",                  :string
    t.column "country",              :string
    t.column "phone",                :string
    t.column "language_preference",  :string
    t.column "favorite_category_id", :integer
    t.column "my_list_option",       :boolean
    t.column "banner_option",        :boolean
  end

  create_table "categories", :force => true do |t|
    t.column "string_id",   :string
    t.column "name",        :string
    t.column "description", :string
    t.column "banner",      :string
  end

  create_table "items", :force => true do |t|
    t.column "product_id", :integer
    t.column "string_id",  :string
    t.column "list_price", :decimal, :precision => 10, :scale => 2
    t.column "unit_cost",  :decimal, :precision => 10, :scale => 2
    t.column "supplier",   :integer
    t.column "status",     :string
    t.column "attribute1", :string
    t.column "attribute2", :string
    t.column "attribute3", :string
    t.column "attribute4", :string
    t.column "attribute5", :string
    t.column "quantity",   :integer
  end

  create_table "line_items", :force => true do |t|
    t.column "order_id",    :integer
    t.column "line_number", :integer
    t.column "quantity",    :integer
    t.column "unit_price",  :decimal, :precision => 10, :scale => 2
  end

  create_table "order_status", :force => true do |t|
    t.column "order_id",    :integer
    t.column "line_number", :integer
    t.column "created_at",  :datetime
    t.column "status",      :string
  end

  create_table "orders", :force => true do |t|
    t.column "account_id",              :integer
    t.column "created_at",              :datetime
    t.column "shipping_address_line_1", :string
    t.column "shipping_address_line_2", :string
    t.column "shipping_city",           :string
    t.column "shipping_state",          :string
    t.column "shipping_zip",            :string
    t.column "shipping_country",        :string
    t.column "billing_address_line_1",  :string
    t.column "billing_address_line_2",  :string
    t.column "billing_city",            :string
    t.column "billing_state",           :string
    t.column "billing_zip",             :string
    t.column "billing_country",         :string
    t.column "courier",                 :string
    t.column "total_price",             :decimal,  :precision => 10, :scale => 2
    t.column "bill_to_first_name",      :string
    t.column "bill_to_last_name",       :string
    t.column "ship_to_first_name",      :string
    t.column "ship_to_last_name",       :string
    t.column "credit_card",             :string
    t.column "expiration_date",         :string
    t.column "card_type",               :string
    t.column "locale",                  :string
  end

  create_table "products", :force => true do |t|
    t.column "string_id",   :string
    t.column "category_id", :integer
    t.column "name",        :string
    t.column "description", :string
  end

  create_table "sessions", :force => true do |t|
    t.column "session_id", :string
    t.column "data",       :text
    t.column "updated_at", :datetime
  end

  add_index "sessions", ["session_id"], :name => "index_sessions_on_session_id"
  add_index "sessions", ["updated_at"], :name => "index_sessions_on_updated_at"

  create_table "suppliers", :force => true do |t|
    t.column "name",           :string
    t.column "status",         :string, :limit => 2
    t.column "address_line_1", :string
    t.column "address_line_2", :string
    t.column "city",           :string
    t.column "state",          :string
    t.column "zip",            :string
    t.column "phone",          :string
  end

end