class CreateSupplierLedgers < ActiveRecord::Migration

  def self.up
    create_table "supplier_ledgers", :force => true do |t|
      t.integer  "supplier_id",            :comment => '仕入先'
      t.integer  "supplier_group_id",      :comment => '仕入先グループ'
      t.date     "target_date",            :comment => '対象月'
      t.column   "cutoff_date_code",       :"SMALLINT(6)", :comment => '締日'
      t.column   "currency_type_code",     :"SMALLINT(6)", :comment => '通貨'
      t.integer  "black_price",            :comment => '月間総仕入額(黒伝分)'
      t.integer  "red_price",              :comment => '月間総仕入額(赤伝分)'
      t.integer  "adjust_price",           :comment => '月間価格調整額'
      t.integer  "total_price",            :comment => '月間純仕入額'
      t.integer  "total_duty",             :comment => '月間消費税額'
      t.integer  "cash",                   :comment => '月間現金振込額'
      t.integer  "bill",                   :comment => '月間手形額'
      t.integer  "offset",                 :comment => '月間相殺額'
      t.integer  "fee",                    :comment => '月間手数料'
      t.integer  "total_credit",           :comment => '月間支払額'
      t.integer  "total_carry",            :comment => '月間残繰越額'
      t.integer  "pre_total",              :comment => '先月総買掛額'
      t.integer  "total",                  :comment => '今月総買掛額'
      t.datetime "print_sheet_date",       :comment => '元帳印刷日時'
      t.datetime "created_at",             :comment => '作成日時'
      t.datetime "updated_at",             :comment => '更新日時'
    end
    execute "ALTER TABLE supplier_ledgers COMMENT = '仕入先元帳'"
    add_index "supplier_ledgers", ["supplier_id"], :name => "customer_id"
    add_index "supplier_ledgers", ["supplier_group_id"], :name => "customer_group_id"
    add_index "supplier_ledgers", ["target_date"], :name => "target_date"
  end

  def self.down
    drop_table :stocks
  end

end