class CreatePayableDetails < ActiveRecord::Migration

  def self.up
    create_table "payable_details", :force => true do |t|
      t.integer  "payable_id",            :comment => '買掛番号'
      t.column   "deal_type_code",        :"SMALLINT(6)", :comment => '取引タイプ'
      t.integer  "trade_id",              :comment => '仕入番号'
      t.integer  "payment_id",            :comment => '支払番号'
      t.integer  "carry_id",              :comment => '繰越番号'
      t.datetime "created_at",            :comment => '作成日時'
      t.datetime "updated_at",            :comment => '更新日時'
    end
    execute "ALTER TABLE payable_details COMMENT = '買掛明細'"
    add_index "payable_details", ["payable_id"], :name => "payable_id"
    add_index "payable_details", ["deal_type_code"], :name => "deal_type_code"
    add_index "payable_details", ["trade_id"], :name => "trade_id"
    add_index "payable_details", ["payment_id"], :name => "payment_id"
    add_index "payable_details", ["carry_id"], :name => "carry_id"
  end

  def self.down
    drop_table :payable_details
  end

end