class CreateTreasuries < ActiveRecord::Migration[5.2]
  def down
    drop_table :treasuries
  end

  def up
    create_table :treasuries do |t|
      t.bigint :user_id, null: false, unsigned: true
      t.string :title, limit: 128, null: true
      t.string :data, null: false
      t.text   :result
      t.integer :state, default: 0, null: false, unsigned: true
      t.integer :kind, default: 0, null: false, unsigned: true
      t.timestamps
    end
    add_index :treasuries, :user_id
    add_index :treasuries, :data, unique: true
    add_index :treasuries, %i[user_id title], unique: true
  end
end