class Bookie::Database::Migration::CreateJobSummaries

Public Instance Methods

down() click to toggle source
# File lib/bookie/database.rb, line 142
def down
 drop_table :job_summaries
end
up() click to toggle source
# File lib/bookie/database.rb, line 126
def up
  create_table :job_summaries do |t|
    t.references :user, :null => false
    t.references :system, :null => false
    t.date :date, :null => false
    t.string :command_name, :null => false
    t.integer :cpu_time, :null => false
    t.integer :memory_time, :null => false
  end
  change_table :job_summaries do |t|
    t.index [:date, :user_id, :system_id, :command_name], :unique => true, :name => 'identity'
    t.index :command_name
    t.index :date
  end
end