class CreateCustomerLedgers < ActiveRecord::Migration

  def self.up
    create_table "customer_ledgers", :force => true do |t|
      t.integer  "customer_id",            :comment => '得意先'
      t.integer  "customer_group_id",      :comment => '得意先グループ'
      t.date     "target_date",            :comment => '対象月'
      t.column   "cutoff_date_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 customer_ledgers COMMENT = '得意先元帳'"
    add_index "customer_ledgers", ["customer_id"], :name => "customer_id"
    add_index "customer_ledgers", ["customer_group_id"], :name => "customer_group_id"
    add_index "customer_ledgers", ["target_date"], :name => "target_date"
  end

  def self.down
    drop_table :customer_ledgers
  end

end