class CreateAssets < ActiveRecord::Migration
  def change
    create_table :assets do |t|
      t.string :name
      t.text   :description
      t.string :current_location
      t.boolean :is_new
      t.boolean :is_traded
      t.boolean :electroic_need
      t.string :volts
      t.string :model_no
      t.string :serial_no
      t.string :sku
      t.date   :manufactured_date
      t.date   :purchased_date
      t.string :purchased_from
      t.text   :info
      t.string :replace_priority
      
      #manufacture
      t.string :company_name
      t.integer :company_phone
      t.text    :company_detail
      t.text    :comapny_address
      t.text    :company_other
      #cost
      t.integer :cost_of_owner
      t.integer :purchased_cost
      
      
      
      t.timestamps
    end
  end
end