class CreateArrivings < ActiveRecord::Migration

  def self.up
    create_table "arrivings", :force => true do |t|
      t.integer  "order_id",                :comment => '発注番号'
      t.integer  "rev_number",              :comment => 'リビジョン番号'
      t.date     "input_date",              :comment => '入力日'
      t.date     "target_date",             :comment => '処理日'
      t.integer  "user_id",                 :comment => '入力者'
      t.integer  "section_id",              :comment => '入力者部署'
      t.integer  "supplier_id",             :comment => '仕入先'
      t.string   "invoice_number",          :limit => 20, :comment => '仕入先番号'
      t.integer  "warehouse_id",            :comment => '納品先'
      t.column   "state_code",              :"SMALLINT(6)", :comment => '状態'
      t.string   "note",                    :limit => 200, :comment => '備考'
      t.column   "invalid_flag_code",       :"SMALLINT(6)", :comment => '削除フラグ'
      t.datetime "print_check_date",        :comment => '記録票印刷日時'
      t.datetime "deleted_at",              :comment => '削除日時'
      t.datetime "created_at",              :comment => '作成日時'
      t.datetime "updated_at",              :comment => '更新日時'
    end
    execute "ALTER TABLE arrivings COMMENT = '入荷'"
    add_index 'arrivings', ['order_id'], :name => 'order_id'
    add_index 'arrivings', ['target_date'], :name => 'target_date'
    add_index 'arrivings', ['supplier_id'], :name => 'supplier_id'
    add_index 'arrivings', ['warehouse_id'], :name => 'warehouse_id'
    add_index 'arrivings', ['invalid_flag_code'], :name => 'invalid_flag_code'
  end

  def self.down
    drop_table :arrivings
  end

end