class Schema < ActiveRecord::Migration
  def self.up
    create_table :accounts 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 do |t|
      t.column :string_id, :string
      t.column :name, :string
      t.column :description, :string
      t.column :banner, :string
    end
    
    create_table :items 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 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 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 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 do |t|
      t.column :string_id, :string
      t.column :category_id, :integer
      t.column :name, :string
      t.column :description, :string
    end

    create_table :sessions do |t|
      t.column :session_id, :string
      t.column :data, :text
      t.column :updated_at, :datetime
    end

    add_index :sessions, :session_id
    add_index :sessions, :updated_at

    create_table :suppliers 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

  def self.down
  end
end